What are the Basics of ETL Testing?
Now that more organizations are using ETL tools and processes to integrate and migrate their data, the obvious next step is learning more about ETL testing to confirm that these processes are...
Read Article
Data transformation
-
-
Data Modeling Techniques: Conceptual vs. Logical vs. Physical
Many of the articles in the Matillion Developer Relations channel contain logical data model diagrams. They are used both for reference and to help explain concepts. Logical data models are...
Read Article
-
NEW: Quickly Launch Matillion ETL via Databricks Partner Connect
Looking to quickly and simply integrate and transform your data in the Databricks environment? Databricks customers can now launch Matillion ETL via Databricks’ Partner Connect program. With...
Read Article
-
Matillion at Snowflake Summit 2022: What a Week! Big Announcements, Parties, and More
Whew–we’re all back from the desert and all we can say is that Snowflake Summit 2022 was an enormous success, especially for Matillion. We made a few big announcements, including our...
Read Article
-
How to Launch Snowflake Partner Connect and Matillion ETL
Snowflake is a single, global platform for your data and your essential workloads. Matillion ETL for Snowflake integrates with Snowflake-specific functionality and best practices, making it easy...
Read Article
-
Matillion ETL Job Performance Analysis and Tuning
It is common to build large, sophisticated Matillion ETL Orchestration Jobs that perform a lot of work. One example might be a “Daily ETL” job that launches many other jobs during a batch
Read Article
-
Matillion at Snowflake Summit 2022: 5 Things You Don’t Want to Miss
It’s almost time for Snowflake Summit 2022! Next week, Matillion will be headed to Las Vegas for the first live Snowflake Summit in two years. We’re proud and excited to be a Double
Read Article
-
Database Schema: Types, Examples, and Benefits
Having the right schema is a key factor supporting modern data analytics. Database schemas can be confusing, but this article will help you design the right schema for your data stores –...
Read Article
-
Connecting Matillion ETL to an Azure Synapse Analytics Dedicated SQL Pool: A Guide
This guide is a walk-through of how to connect Matillion ETL to an Azure Synapse Analytics dedicated SQL pool (formerly known as “SQL DW”). In Matillion ETL, the metadata for connecting to Azure
Read Article
-
Developing Workflows in Matillion ETL
This guide describes how to manage your Matillion ETL workflows – known as “Jobs” – by using Orchestration and Transformation components in the most appropriate way. Prerequisites The...
Read Article
-
Connecting Matillion ETL to Google BigQuery: A Guide
This guide is a walk-through of how to connect Matillion ETL to Google BigQuery. In Matillion ETL, the metadata for connecting to Google BigQuery is held in an artifact known as an Environment.
Read Article
-
Connecting Matillion ETL to a Databricks Workspace: A Guide
This guide is a walk-through of how to connect Matillion ETL to a Databricks workspace in Delta Lake on Databricks. In Matillion ETL, the metadata for connecting to Delta Lake on Databricks is
Read Article
-
Connecting Matillion ETL to Snowflake: A Guide
This guide is a walk-through of how to connect Matillion ETL to a Snowflake cloud data platform account. In Matillion ETL, the metadata for connecting to Snowflake is held in an artifact known
Read Article
-
Inclusive Design at Matillion: Building for Everyone
Matillion is committed to making sure our products and services consider diversity, equity, and inclusion at every stage of our lifecycle, from our hiring process to product delivery. At...
Read Article
-
Data Mesh is the Answer to Your Integration Challenges. Fact or Fiction?
Data mesh is a hot topic in data management circles. But what exactly is data mesh and why does it continue to spark debate? Paul Lacey, Senior Director of Product Marketing at Matillion,
Read Article
-
Data Has State – Data Functions and Design Patterns
This is the final article in a five-part series on data integration. The series covers the following foundational topics: Data-Oriented Programming needs Data Integration – App and format...
Read Article
-
Matillion ETL 1.62 Release Blog: Preview for dbt Integration, Updated Ads Connectors, and More
The Matillion ETL data integration platform continues to get better in Version 1.62. Keep reading for highlights and details in this newest version. Summary of release: 9 new and updated...
Read Article
-
Matillion + Snowflake: Increase Your Speed to Insight with Data Modernization
Business analytics tools have made it possible for companies of all sizes to gain tremendous insights from the data they collect. Whether it’s to improve decision making, optimize operations,...
Read Article
-
Data Change Management – Iterate Rapidly and Track Lineage
This is the fourth article in a five-part series on data integration. The series covers the following foundational topics: Data-Oriented Programming needs Data Integration – App and format...
Read Article
-
Create Data-Driven Organizations with a Good Data Culture
This is the third article in a five part series on data integration. The series covers the following foundational topics: Data-Oriented Programming needs Data Integration – App and format...
Read Article
-
Loading More...
