The Basics of ETL Testing
Imagine spending lots of time and resources to move your data to a new system, only to realize that the data is incomplete or inaccurate. Not only would this result in costly mistakes, but it
Read Article
Data transformation
-
-
dbt Core Data Sheet
Read Flipbook
-
Databricks & Matillion Enterprise Data Productivity Datasheet
Read Flipbook
-
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
-
Loading More...
