SQL-first transformations with dbt™
dbt™ is a SQL-first transformation tool that enables analytics engineers to develop code following software engineering best practices like modularity, portability, CI/CD, and documentation. The main reason we chose to integrate with dbt is the transformations as code approach that it enables - a huge community that understands how to develop in dbt makes the choice a clear winner for our customers too. Developing transforms in code with SQL and the auto generated documentation enables enterprise-grade data pipelines in tools that data engineers instinctively understand.
Version Control and CI/CD
Use Matatika to deploy and promote changes between dev, UAT, and production environments. Git-enabled version control enables collaboration and rollback.
Test and Document
Use Matatika to develop and test every model prior to production release, and share dynamically generated documentation with all stakeholders.
Develop
Data engineers write modular data transformations in .sql or .py files – Matatika together with dbt handles the chore of dependency management.
Matatika with dbt is a powerful open source alternative to:
– Matillion
– Alteryx
– talend