Off the back of our announcement that Transform is officially a dbt Labs partner and our enthusiasm for dbt metrics, I am excited to share our new integration with dbt metrics! This integration will allow anyone who has metrics in dbt to instantly enable metric-centric, self-serve BI on top of these metrics in Transform.
dbt metrics & Transform
The dbt metrics integration allows you to use Transform’s self-serve business intelligence product by leveraging the metrics you have created in dbt. To use the integration, simply add the required Transform secrets to the CI/CD within your dbt project. As part of your CI/CD suite, Transform will parse your dbt metrics and build a model that is uploaded to Transform. Now all the metrics you have defined in dbt are available in Transform, so anyone in your organization can interact with them! For detailed steps on how to set up your CI/CD refer to our documentation or watch our product demo below.
This integration allows you to leverage all of Transform’s metrics-centric BI workflows without additional configuration. These workflows include:
- Capturing organizational context and metric metadata like metric descriptions, annotations, alerts, and questions
- A self-serve chart builder for business users to cut metrics by dimensions and perform governed analysis
- Anyone in your organization can build saved metric queries and dashboards, helping reduce the number of “Hey, quick data questions...” slacks the data team receives
Why are dbt & Transform better together?
We think dbt metrics and Transform are more powerful together. Our mission is to make data accessible, and we think the metric is the best layer of abstraction to accomplish this mission. dbt is a core piece of our data stack, and is a natural place to define metric logic. We’re building tools that make these metrics accessible to anyone in your organization, even if they don't know SQL. With dbt & Transform, it’s now possible to instantly enable metric-centric business intelligence and activate your dbt metrics for your entire organization.
Please reach out to our team if you want to give the integration a try!