phData

MARCH 1, 2023

The first one we want to talk about is the Toolkit SQL analyze command. When customers are looking to perform a migration, one of the first things that needs to occur is an assessment of the level of effort to migrate existing data definition language (DDL) and data markup language (DML).

SQL 52

SQL Data Pipeline Data Quality Database 52

phData

MARCH 31, 2023

You have tons of data and SQL to migrate, and you need to ensure that it’s done right, or it’s your job on the line! WIthin our Toolkit CLI, we primarily have two different tools: our SQL Translation Tool and our Data Source Tool. Added a default name (the folder or file name) when generating SQL reports.

SQL 52

SQL Data Profiling Data Pipeline Database 52

phData

SEPTEMBER 7, 2023

Over the last month, we’ve been heavily focused on adding additional support for SQL translations to our SQL Translations tool. Specifically, we’ve been introducing fixes and features for our Microsoft SQL Server to Snowflake translation. This is where the SQL Translation tool can be a massive accelerator for your migration.

SQL 52

SQL Data Profiling Data Pipeline Database 52

phData

JULY 29, 2023

We’ve been focusing on two key areas: Microsoft SQL Server to Snowflake Data Cloud SQL translations and our new Advisor tool within the phData Toolkit. Operational Risks identify operational risks such as data loss or failures in the event of an unforeseen outage or disaster. Let’s dive in.

SQL 52

SQL Database Data Pipeline 52

phData

JUNE 26, 2023

While many of our customers leverage our UI for tools like our SQL Translation or Privilege Audit tooling, there are limitations when it comes to using a UI. You wouldn’t want to pay someone (or perform yourself) to manually copy/paste each file into a browser window and copy/paste the translated SQL back.

SQL 52

SQL Data Profiling Data Pipeline Data Governance 52

phData

JULY 12, 2023

Unlike traditional methods that rely on complex SQL queries for orchestration, Matillion Jobs provides a more streamlined approach. By converting SQL scripts into Matillion Jobs , users can take advantage of the platform’s advanced features for job orchestration, scheduling, and sharing. In our case, this table is “orders.”

SQL 52

SQL ETL Database Data Pipeline 52

phData

APRIL 21, 2023

Unlike traditional methods that rely on complex SQL queries for orchestration, Matillion Jobs provide a more streamlined approach. By converting SQL scripts into Matillion Jobs , users can take advantage of the platform’s advanced features for job orchestration, scheduling, and sharing. In our case, this table is “orders.”

SQL 52

SQL ETL Database Data Pipeline 52

ODSC - Open Data Science

SEPTEMBER 20, 2023

ODSC West 2023 is just a couple of months away, and we couldn’t be more excited to be able to share our Preliminary Schedule with you! Day 1: Monday, October 30th (Bootcamp, VIP, Platinum) Day 1 of ODSC West 2023 will feature our hands-on training sessions, workshops, and tutorials and will be open to Platinum, Bootcamp, and VIP pass holders.

Data Wrangling 52

Data Wrangling Data Science Machine Learning Machine Learning 52

Snorkel AI

MAY 26, 2023

[link] Ahmad Khan, head of artificial intelligence and machine learning strategy at Snowflake gave a presentation entitled “Scalable SQL + Python ML Pipelines in the Cloud” about his company’s Snowpark service at Snorkel AI’s Future of Data-Centric AI virtual conference in August 2022. Welcome everybody.

SQL 52

SQL ML ML Python 52

Snorkel AI

MAY 26, 2023

[link] Ahmad Khan, head of artificial intelligence and machine learning strategy at Snowflake gave a presentation entitled “Scalable SQL + Python ML Pipelines in the Cloud” about his company’s Snowpark service at Snorkel AI’s Future of Data-Centric AI virtual conference in August 2022. Welcome everybody.

SQL 52

SQL ML ML Python 52

Dataconomy

MAY 16, 2023

Key skills and qualifications for machine learning engineers include: Strong programming skills: Proficiency in programming languages such as Python, R, or Java is essential for implementing machine learning algorithms and building data pipelines.

Data Scientist 156

Data Scientist ML ML Machine Learning 156

Pickl AI

NOVEMBER 4, 2024

Effective data governance enhances quality and security throughout the data lifecycle. What is Data Engineering? Data Engineering is designing, constructing, and managing systems that enable data collection, storage, and analysis. The global data warehouse as a service market was valued at USD 9.06

Data Engineering 52

Data Engineering Data Engineering Data Engineering Data Engineer 52

phData

NOVEMBER 2, 2023

Managing data pipelines efficiently is paramount for any organization. The Snowflake Data Cloud has introduced a groundbreaking feature that promises to simplify and supercharge this process: Snowflake Dynamic Tables. What are Snowflake Dynamic Tables?

Data Pipeline 52

Data Pipeline SQL Data Warehouse Data Engineering 52

phData

DECEMBER 4, 2023

Copy Into When loading data into Snowflake, the very first and most important rule to follow is: do not load data with SQL inserts! Loading small amounts of data is cumbersome and costly: Each insert is slow — and time is credits. And once again, for loading data, do not use SQL Inserts.

Clustering 98

Clustering Database SQL Data Pipeline 98

phData

MAY 28, 2024

Coalesce is a technology platform that simplifies creating and maintaining data pipelines with an easy-to-use visual interface and customizable templates, reducing the need for extensive coding. The bread and butter of our projects with Coalesce usually takes the form of helping mutual clients achieve end-to-end data pipelines.

Data Pipeline 52

Data Pipeline SQL Machine Learning Machine Learning 52

phData

DECEMBER 29, 2022

We hope you’ve had a fantastic holiday season, filled up on delicious food, and are as excited as us to kick off the 2023 calendar year. SQL Translation Updates Over the course of the last few months, we’ve had a focus on increasing the coverage of our SQL translations from Microsoft SQL (MSSQL) to the Snowflake Data Cloud.

SQL 52

SQL Database Database Administration Data Profiling 52

DagsHub

DECEMBER 11, 2023

A complete overview revealing a diverse range of strengths and weaknesses for each data versioning tool. It does not support the ‘dvc repro’ command to reproduce its data pipeline. DVC Released in 2017, Data Version Control ( DVC for short) is an open-source tool created by iterative.

Machine Learning 98

Machine Learning Machine Learning Data Lakes Data Science 98

ODSC - Open Data Science

AUGUST 23, 2023

That’s a problem when you’re trying to work with that data in pandas because you have to pull the dataset into the memory of your machine, which can be slow, expensive, and lead to fatal out-of-memory issues. Ponder solves this problem by translating your pandas code to SQL that can be understood by your data warehouse.

Data Warehouse 52

Data Warehouse Data Science Database SQL 52

phData

MARCH 18, 2024

product_id product_name category price update_date 1 MacBook Air (15-inch, M2, 2023) Computers & Accessories $999 June 13, 2023 In the product table, we have a product, MacBook Air (15-inch, M2, 2023), and the price is $999 as of June 13, 2023. SCD Type 1 In this type, changes overwrite the existing data.

Data Warehouse 52

Data Warehouse SQL Data Pipeline Analytics 52

phData

FEBRUARY 8, 2024

Data Modeling, dbt has gradually emerged as a powerful tool that largely simplifies the process of building and handling data pipelines. dbt is an open-source command-line tool that allows data engineers to transform, test, and document the data into one single hub which follows the best practices of software engineering.

Data Models 52

Data Models Data Modeling Data Warehouse Database 52

AWS Machine Learning Blog

SEPTEMBER 18, 2024

Context In early 2023, Zeta’s machine learning (ML) teams shifted from traditional vertical teams to a more dynamic horizontal structure, introducing the concept of pods comprising diverse skill sets. Additionally, Feast promotes feature reuse, so the time spent on data preparation is reduced greatly.

AWS 126

AWS Machine Learning Machine Learning ML 126

phData

AUGUST 22, 2024

Consider a data pipeline that detects its own failures, diagnoses the issue, and recommends the fix—all automatically. This is the potential of self-healing pipelines, and this blog explores how to implement them using dbt, Snowflake Cortex , and GitHub Actions.

SQL 52

SQL Data Quality Python Data Warehouse 52

phData

MAY 25, 2023

How to Optimize Power BI and Snowflake for Advanced Analytics Spencer Baucke May 25, 2023 The world of business intelligence and data modernization has never been more competitive than it is today. The June 2021 release of Power BI Desktop introduced Custom SQL queries to Snowflake in DirectQuery mode.

Power BI 84

Power BI Analytics Analytics Azure 84

AWS Machine Learning Blog

SEPTEMBER 24, 2024

With a user base of over 37 million active consumers and 2 million monthly active Dashers at the end of 2023, the company recognized the need to reduce the burden on its live agents by providing a more efficient self-service experience for Dashers. Choose an option for allowing unredacted logs for the Lambda function in the data pipeline.

AWS 104

AWS AI AI Analytics 104

phData

JUNE 26, 2024

Cleaning and preparing the data Raw data typically shouldn’t be used in machine learning models as it’ll throw off the prediction. This can be achieved by, you guessed it, analyzing the data. phData Retail Case Study phData helps many retail businesses answer these questions and more by utilizing their data to the fullest.

Machine Learning 52

Machine Learning Machine Learning Data Engineering Data Engineer 52

The MLOps Blog

JANUARY 23, 2023

Dolt LakeFS Delta Lake Pachyderm Git-like versioning Database tool Data lake Data pipelines Experiment tracking Integration with cloud platforms Integrations with ML tools Examples of data version control tools in ML DVC Data Version Control DVC is a version control system for data and machine learning teams.

ML 52

ML ML Data Lakes Machine Learning 52

Flipboard

MARCH 21, 2025

To establish trust between the data producers and data consumers, SageMaker Catalog also integrates the data quality metrics and data lineage events to track and drive transparency in data pipelines. Create a SageMaker Unified Studio domain and three projects using the SQL analytics project profile.

SQL 141

SQL Data Analyst Data Warehouse AWS 141

Pickl AI

DECEMBER 9, 2024

Introduction Big Data continues transforming industries, making it a vital asset in 2025. The global Big Data Analytics market, valued at $307.51 billion in 2023, is projected to grow to $348.21 Hive is a data warehouse tool built on Hadoop that enables SQL-like querying to analyse large datasets.

Big Data 52

Big Data Big Data Hadoop Apache Kafka 52

phData

JULY 18, 2024

Snowflake 2024 Partner of the Year Fivetran 2024 Partner of the Year dbt 2023 Partner of the Year Alation 2024 SI Partner of the Year Automation With all our experience with projects, we have created in-house automation tools for many DE tasks, especially when using Snowflake as your cloud data provider.

Machine Learning 52

Machine Learning Machine Learning Natural Language Processing Data Engineering 52

Mlearning.ai

FEBRUARY 16, 2023

Thus, the solution allows for scaling data workloads independently from one another and seamlessly handling data warehousing, data lakes , data sharing, and engineering. Data warehousing is a vital constituent of any business intelligence operation. Simplify and Win Experienced data engineers value simplicity.

Data Warehouse 52

Data Warehouse Business Intelligence Business Intelligence Database 52

phData

FEBRUARY 6, 2024

One of the more common practices when developing a data pipeline is rebuilding your data for testing changes. As one of the leaders in the industry, dbt provides several options on how to execute your pipelines to increase efficiency and specifically execute what you need. What is dbt Run + dbt Test?

Data Pipeline 52

Data Pipeline Database SQL Data Warehouse 52

ODSC - Open Data Science

SEPTEMBER 29, 2023

Furthermore, we’ve developed data encryption and governance solutions for HPCC Systems to help secure data, ensure it is only accessed by appropriate personnel, and to create audit trails to ensure data security SLAs and regulations are met. It truly is an all-in-one data lake solution. Tell me more about ECL.

Data Lakes 52

Data Lakes Clustering Big Data Big Data 52

ODSC - Open Data Science

APRIL 26, 2023

Though scripted languages such as R and Python are at the top of the list of required skills for a data analyst, Excel is still one of the most important tools to be used. Because they are the most likely to communicate data insights, they’ll also need to know SQL, and visualization tools such as Power BI and Tableau as well.

Data Analyst 52

Data Analyst Machine Learning Machine Learning Power BI 52

IBM Journey to AI blog

JULY 17, 2023

Real-time analytics and BI: Combine data from existing sources with new data to unlock new, faster insights without the cost and complexity of duplicating and moving data across different environments. The post Exploring the AI and data capabilities of watsonx appeared first on IBM Blog.

AI 74

AI AI Machine Learning Machine Learning 74

The MLOps Blog

JANUARY 26, 2024

Reference table for which technologies to use for your FTI pipelines for each ML system. Related article How to Build ETL Data Pipelines for ML See also MLOps and FTI pipelines testing Once you have built an ML system, you have to operate, maintain, and update it.

Machine Learning 72

Machine Learning Machine Learning ML ML 72

phData

JULY 18, 2023

The Ultimate Modern Data Stack Migration Guide phData Marketing July 18, 2023 This guide was co-written by a team of data experts, including Dakota Kelley, Ahmad Aburia, Sam Hall, and Sunny Yan. Imagine a world where all of your data is organized, easily accessible, and routinely leveraged to drive impactful outcomes.

Data Warehouse 52

Data Warehouse Analytics Analytics Cloud Data 52

The MLOps Blog

MARCH 21, 2023

I have worked with customers where R and SQL were the first-class languages of their data science community. You don’t need a bigger boat : The repository curated by Jacopo Tagliabue shows how several (mostly open-source) tools can be effectively combined together to run data pipelines at scale with very small teams.

Machine Learning 69

Machine Learning Machine Learning Data Scientist ML 69