Modelling and Transformation Engine

The DataOps Modelling and Transformation Engine (MATE) is a SQL-based database modelling and testing engine developed on top of the dbt Framework.

However, MATE offers much more than just the dbt transformation framework. We have added DataOps-specific logic, helper macros, and additional tests and custom configurations, all undergirded by the powerful DataOps orchestration platform.

Modelling and Transformation or MATE in a DataOps project is the "T" in ELT, while auto-ingestion capabilities provide the "E" and the "L." Therefore, most DataOps projects will include a MATE component to turn source data into valuable data marts and other data products.

The topics specifically discussed in this section include:

• Core Concepts
• Build Models
• Autogenerate Sources from Ingestion Tables
• Project Documentation
• Packages
• Macros
• Automated Data Testing
• Security and Governance
• MATE Best Practices