Examples
Welcome to our Examples Gallery! Using Datamates you can automate data engineering, analytical engineering, data infrastructure and governance workflows
Getting Started
We recommend starting with the Setup Guide for a step-by-step tutorial to setup Datamates before diving into these examples.
Example Use Cases
| Example | Description |
|---|---|
| Build, Test, Docs for dbt Models | Pull context from your dbt best practices stored in Knowledge Hub, pull requirements from a JIRA ticket, and update dbt models all within Cursor |
| Find Broken Views in Snowflake | Create a DataMate called "Sprint Work Agent" that integrates Snowflake, dbt, and Jira into GitHub Copilot to find empty Snowflake views and file tickets |
| Optimize Cost and Performance | Automate the discovery and implementation of cost and performance optimization opportunities across Snowflake, Databricks and BigQuery |
| Migrate a pyspark project to dbt | Walkthrough of migrating a PySpark-based e-commerce reporting project in Databricks to dbt with automated conversion assistance |
| Debug an Airflow DAG | Use AI to quickly debug Airflow DAGs by combining platform integrations and best-practice templates from the Knowledge Hub |
| Write Snowflake UDFs | Use the knowledge hub to create a guide for LLMs to create Snowflake UDFs with best practices and coding examples |