dbt Integration with Workstream.io

Workstream integrates with your dbt cloud project. Once connected, Workstream automatically syncs exposures to show real-time monitoring of data quality and freshness alongside your existing analytics tools. Should data issues arise with critical assets, get automatically notified to see which underlying models or sources have an issue, and view assets to see what is happening. Since Workstream supports many analytics tools, you can now streamline access to assets and tracking of underlying data issues in a single place. Never again ask or answer questions such as “Does this look right?” or “How do I use this?"

See Workstream @ Coalesce 2023

We made it to Coalesce 2023, hosted by dbt Labs. Did you? If you missed our session about how to automate answers to annoying business questions with dbt-powered data knowledge, you can still catch it on LinkedIn Live.

New Integration Highlights

  • Workstream integrates with dbt projects to automatically sync exposures and shows real-time monitoring of data quality and freshness.
  • Workstream supports many analytics tools so that users can streamline access to assets and tracking of underlying data issues in a single place.
  • The benefits of using Workstream + dbt include having a one-stop shop for exposing data quality status and issues across all analytics tools, importing assets into a single workspace, being able to surface built-in tests for data correctness and freshness, etc.
  • Workstream allows you to  to leverage your dbt project to build business-facing documentation: When leveraging any of our documentation features, including asset content overviews or Workstream docs, you can pull in dynamic definitions of your dbt nodes.

How does Workstream work with dbt?

Workstream connects to your dbt cloud & tracks any exposures configured in your project. Tables that matter to you can be distilled down to insightful and actionable data. Connect dbt, and easily access your BI tools where the distilled data would typically go. 

Benefits of Workstream + dbt

  • One-stop shop for exposing data quality issues across all of your analytics tools – from BI solutions like Tableau and Looker to data in operational systems like Salesforce, and even one-off exploratory analysis in spreadsheets or notebooks. 
  • Import your assets into one workspace, and allow us to automatically create status pages for your most critical ones.
  • Surface built-in tests for data correctness and freshness to remedy urgent analytics issues before stakeholders become aware of data quality issues.
  • Enjoy having conversations with stakeholders about anything, and curate in-line documentation, training content, and FAQs, so you never have to answer the same question twice.

Frequently Asked Questions

[Q] How does Workstream identify which dbt assets to create status pages for?

[A] Workstream creates a status page for any data asset that is configured as Exposure in dbt. From there, we automatically identify what sources and models provide the underlying data for that asset, and include them on the status page.

[Q] Where are the dbt status pages presented?

[A] Status pages are presented wherever you’re viewing the asset (in our web application, or natively in your analytics tools via the Workstream Concierge Chrome extension)

About dbt Labs

dbt Labs is on a mission to empower data practitioners to create and disseminate organizational knowledge. Having pioneered the practice of analytics engineering, they are fortunate to support a community of over 25,000 data practitioners committed to changing how data teams work together. This development framework combines modular SQL with software engineering best practices to make data transformation reliable, fast, and fun.

Sky Curve
Pink Curve

Ready to supercharge your analytics workflow?

We are building for the most innovative, forward thinking data teams around. If that sounds like you, please reach out!