Alation

APRIL 18, 2023

For any data user in an enterprise today, data profiling is a key tool for resolving data quality issues and building new data solutions. In this blog, we’ll cover the definition of data profiling, top use cases, and share important techniques and best practices for data profiling today.

Data Profiling 52

Data Profiling Data Quality Data Governance Data Pipeline 52

phData

JANUARY 10, 2024

The data source tool can also directly generate the Data Definition Language (DDL) for these tables as well if you decide not to use dbt! This allows you to better understand the existing structures that are in place and more accurately perform your migration (or generate documentation, everybody’s favorite!).

Data Warehouse 52

Data Warehouse Data Profiling Data Pipeline Database 52

phData

SEPTEMBER 7, 2023

We’ve had many customers performing migrations between these platforms, and as a result, they have a lot of Data Definition Language (DDL) and Data Markup Language (DML) that needs to be translated between SQL dialects. Let’s take a look at some of the more interesting translations.

SQL 52

SQL Data Profiling Data Pipeline Database 52

phData

JUNE 26, 2023

As customers are performing platform migrations, they frequently need to translate existing stored procedures, data definition language (DDL), and data markup language (DML) to the target system. SQL Translation Updates SQL Translation is another major component of the Toolkit CLI.

SQL 52

SQL Data Profiling Data Pipeline Data Governance 52

phData

AUGUST 17, 2023

Data pipeline orchestration tools are designed to automate and manage the execution of data pipelines. These tools help streamline and schedule data movement and processing tasks, ensuring efficient and reliable data flow. This enhances the reliability and resilience of the data pipeline.

Data Engineer 52

Data Engineer Data Engineering Data Engineering Data Engineering 52