Select Star for dbt

ETL / ELT

Select Star and dbt provide a powerful joint solution for data integration and data discovery. Users can easily share their dbt docs accompanied with Select Star’s auto-generated data context. Select star also allows you to trace data provenance and guide proper data usage, including setting owners, tags, and rich-text docs and metrics.

dbt Integration Features

Column-level Lineage

Select Star provides automated, dbt data lineage at the column-level for all dbt operations. The platform also provides column-level lineage of the dbt models, linkage between the materialized tables/views, and BI dashboards from Tableau, Looker, PowerBI, Mode, Periscope, etc.

dbt Docs Integration

Select Star provides data documentation and data discovery on top of dbt projects by natively connecting with the data warehouse, transformation layer (dbt), and popular BI tools. Users can search across multiple platforms and make semantic connections. The dbt model page shows everything from the dbt docs, as well as links to linked tables.

dbt Tags Integration

Users can sync all their existing dbt tags to Select Star making them available, searchable, and automated. Tags in Select Star will automatically be matched to the dbt tags ingested, based on name to decrease duplication. Once matched, the Select Star tag will appear everywhere with a tooltip highlighting this connection.

Select Star for dbt includes:

Browse more integrations

Snowflake

Snowflake and Select Star provide a powerful solution for automated data discovery in your Data Cloud. Select Star integrates with your Snowflake metadata to uncover deep contextual insights in your data relationships, helping you democratize data across different domain teams and functions.
Learn more

Google BigQuery

Select Star and Google BigQuery provide a powerful joint solution for data discovery across your cloud data platform. Easily trace column-level lineage to downstream data sources and BI dashboards. Better understand downstream dependencies and the impact of changes to dashboards. Explore how data is joined and how it originated and easily filter by usage and ownership.
Learn more

Amazon Redshift

Select Star and Amazon Redshift provide a powerful joint solution for data discovery, lineage, and documentation in your cloud data warehouse. Select Star is able to leverage the metadata of your Amazon Redshift environment to catalog tables and columns, lineage to the column-level, and documentation to further enrich discovery in your cloud data warehouse.
Learn more