Case Study: Looker streamlines dbt and BI workflows with Omni

Looker streamlines dbt-to-BI workflows with Omni in one click

Looker, a business intelligence platform, faced the challenge of a completely manual workflow for integrating changes made in their dbt data models. This process required teams to coordinate and manually update their LookML models or fix countless broken SQL references whenever a simple column or table name was changed in dbt, leading to significant inefficiency.

Omni implemented a deep integration with dbt to automate this workflow. The solution automatically surfaces dbt model changes, preserving existing custom modeling and reports without manual updates. It also pulls in dbt documentation for greater visibility and allows users to author dbt models directly from definitions created in Omni's UI. This integration from Omni streamlined the analytics workflow, saving time, reducing coordination overhead, and providing greater data visibility across tools.

Looker