Getting Started with Matillion ETL Tool
Getting Started with Matillion ETL Tool - Perficient Blog LinkedIn In this article, I will show you how you can set up your own Matillion instance, but before we get started let’s talk about the Matillion ETL tool. What is Matillion, and why should you care? Matillion is an ETL tool that is available on the Cloud Marketplace. It is completely cloud-based, billed at an hourly rate, and comes with the most significant advantages when coupled with Snowflake, Redshift, and Delta Lake. To get that significant advantage, I will be showing you the coupling of Matillion with Snowflake in this article. We have been using the Matillion ETL tool on the data warehouse, such as Snowflake on the ETL project for our clients. Recently I worked on a project in which I was working on Matillion for data transformation and orchestration from source to target. Matillion has two main flavors of jobs: Orchestration: Orchestration is primarily concerned with DDL statements (especially Creating, Dropping, and ...