phData

SEPTEMBER 2, 2024

In this blog, we will cover the best practices for developing jobs in Matillion, an ETL/ELT tool built specifically for cloud database platforms. Matillion is a SaaS-based data integration platform that can be hosted in AWS, Azure, or GCP. To do this, we need to integrate third-party secret managers in Matillion ETL.

ETL 52

ETL Data Warehouse SQL Database 52

phData

APRIL 29, 2024

Understanding Fivetran Fivetran is a popular Software-as-a-Service platform that enables users to automate the movement of data and ETL processes across diverse sources to a target destination. This includes most of the popular cloud object storage along with several options that on-premises can use, such as FTP/sFTP.

SQL 52

SQL Data Warehouse Azure Cloud Data 52

Data Science Dojo

JULY 3, 2024

Big Data Technologies : Handling and processing large datasets using tools like Hadoop, Spark, and cloud platforms such as AWS and Google Cloud. Data Processing and Analysis : Techniques for data cleaning, manipulation, and analysis using libraries such as Pandas and Numpy in Python.

Data Science 150

Data Science Machine Learning Machine Learning Data Visualization 150

phData

FEBRUARY 14, 2023

Fivetran works with all three Snowflake cloud providers. If using a network policy with Snowflake, be sure to add Fivetran’s IP address list , which will ensure Azure Data Factory (ADF) Azure Data Factory is a fully managed, serverless data integration service built by Microsoft.

Data Warehouse 59

Data Warehouse Azure AWS Database 59

phData

FEBRUARY 21, 2025

The Cloud represents an iteration beyond the on-prem data warehouse, where computing resources are delivered over the Internet and are managed by a third-party provider. Examples include: Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform (GCP). Data integrations and pipelines can also impact latency.

Data Warehouse 52

Data Warehouse Cloud Data ETL Cloud Computing 52

Precisely

MAY 23, 2024

The sudden popularity of cloud data platforms like Databricks , Snowflake , Amazon Redshift, Amazon RDS, Confluent Cloud , and Azure Synapse has accelerated the need for powerful data integration tools that can deliver large volumes of information from transactional applications to the cloud reliably, at scale, and in real time.

Data Governance 64

Data Governance ETL Data Pipeline Azure 64

Precisely

MAY 23, 2024

The sudden popularity of cloud data platforms like Databricks , Snowflake , Amazon Redshift, Amazon RDS, Confluent Cloud , and Azure Synapse has accelerated the need for powerful data integration tools that can deliver large volumes of information from transactional applications to the cloud reliably, at scale, and in real time.

Data Governance 52

Data Governance ETL Data Pipeline Azure 52

phData

NOVEMBER 28, 2023

Matillion is also built for scalability and future data demands, with support for cloud data platforms such as Snowflake Data Cloud , Databricks, Amazon Redshift, Microsoft Azure Synapse, and Google BigQuery, making it future-ready, everyone-ready, and AI-ready. Why Does it Matter?

Data Warehouse 52

Data Warehouse Data Pipeline ETL Azure 52

phData

JANUARY 19, 2024

Matillion is also built for scalability and future data demands, with support for cloud data platforms such as Snowflake Data Cloud , Databricks, Amazon Redshift, Microsoft Azure Synapse, and Google BigQuery, making it future-ready, everyone-ready, and AI-ready.

Data Pipeline 52

Data Pipeline Data Warehouse ETL Azure 52

phData

SEPTEMBER 27, 2024

If the event log is your customer’s diary, think of persistent staging as their scrapbook – a place where raw customer data is collected, organized, and kept for future reference. In traditional ETL (Extract, Transform, Load) processes in CDPs, staging areas were often temporary holding pens for data.

Data Modeling 52

Data Modeling Data Models Apache Kafka Data Lakes 52

phData

OCTOBER 28, 2024

Modern low-code/no-code ETL tools allow data engineers and analysts to build pipelines seamlessly using a drag-and-drop and configure approach with minimal coding. One such option is the availability of Python Components in Matillion ETL, which allows us to run Python code inside the Matillion instance.

Python 52

Python ETL AWS Database 52

phData

JULY 18, 2023

With the birth of cloud data warehouses, data applications, and generative AI , processing large volumes of data faster and cheaper is more approachable and desired than ever. This typically results in long-running ETL pipelines that cause decisions to be made on stale or old data.

Data Warehouse 52

Data Warehouse Analytics Analytics SQL 52