Matillion

AI prompt component to leverage Large Language Models in pipelines for handling complex and unstructured data

Virtual data engineers that partner with your team to build pipelines, automate tedious tasks, and accelerate delivery of trusted data using plain language prompts

Enrich LLMs with enterprise data using Retrieval Augmented Generation capabilities through vector data stores

Easily manage tasks across multiple tenants with access control, provisioning, and system maintenance

Native integration with AWS cloud platform

Native integration with Databricks for optimized data loading and transformation

Native integration with Snowflake for optimized performance and ability to load data directly into Snowflake

High-code SQL IDE that automatically checks all SQL statements for errors

Execute Python scripts directly within Snowflake account using the Snowpark service to reduce pipeline bottlenecks

Ability to write and execute code in SQL, Python, and dbt with native orchestration through Matillion

Community collaboration platform to share best practices, custom connectors, dbt packages, JDBC drivers, and reusable job templates

No-code REST API and visual Designer to quickly build and manage custom connectors to any data source

Custom connectors built based on customer requests that are not in the library and can be delivered in days

Library of hundreds of pre-configured connectors to ingest data from any source including ERP, CRM, HRIS, SaaS systems, and spreadsheets

End-to-end data lineage tracking from source to output to optimize pipelines and troubleshoot efficiently

Automatically tag all data with correct metadata upon loading into Databricks

Integration with top data catalogs such as Collibra and Alation

Enrich data in the Cloud Data Platform and push that data back to operational systems

Ingest data into cloud data warehouse in minutes with pre-built or custom data connectors

Maintain data integrity by capturing change events in real time with no performance impact

Build pipelines capturing and processing real-time changes to data

Validate and sample data interactively during pipeline development

Execute dbt core transformations within Matillion's PipelineOS without needing other infrastructure

Deploy on your own hosted Agent infrastructure in addition to full SaaS deployment

Automatically annotate data pipelines with context and documentation to enhance collaboration

Unify role-based access control across Databricks workspaces and orchestrate notebooks from within Matillion

RESTful API for flexible integrations with data quality, governance, and orchestration tools

Automate and schedule data pipelines based on custom parameters at set times and intervals

Operating system for pipelines that dynamically scales by distributing individual pipeline tasks across multiple stateless containers

Generates native SQL to Snowflake, Databricks, and AWS while leveraging those platforms for improved performance and processing

Intuitive visual designer to drag and drop components into a canvas to assemble complex data pipelines without extensive coding

Pay only for pipeline execution and task hours, designed to scale with pipeline execution, team size, and project complexity

Keep Matillion running even if components temporarily fail through clustered instances or full SaaS deployment

Library of prebuilt transformations and orchestrations that can be bundled and shared across organization

Scale with unlimited developer users, admin users, projects, and environments

Track and report all user actions with configurable retention periods

Enhanced security with multi-factor authentication support

Dedicated private connectivity route between your VPC and the service

Role-based access control with permissions based on groups and users

Built-in SSO support with custom SSO available in Scale tier

Native Git integration allowing version control, collaboration, and management of pipelines from within Matillion