Matillion is data transformation for cloud data warehouses. According to the vendor, only Matillion is purpose-built for Amazon Redshift, Snowflake, and Google BigQuery enabling businesses to achieve new levels of simplicity, speed, scale, and savings.
Quickly develop custom Transformation jobs by combining Filters, Joins, Aggregates, Calculators, Ranks, as well as more complex transformations such as Rankings, window calculations, and change-detection by dragging and dropping these onto a canvas GUI. Use Orchestration features to automate your ETL workflows with scheduling, notifications and alerting, and control flow.
Once your jobs are built, run them with confidence with component level validation and data sampling. For any custom or unique needs, Matillion also has Bash and Python Script components giving you the ultimate extensibility and flexibility.
Shared Job templates, Dynamic and Grid variables, and Version control help your development teams share resources across your Matillion instance.
Enterprise customers benefit from additional auditing and permissions, automatic job documentation, data lineage and more. Learn more about enterprise features here.
Each product comes with a set of warehouse specific features that help you get the most out of the platform. See our Product Feature pages on matillion.com for more information.