Case Study: Québec Blue Cross cuts deployment time 98% with Dremio and dbt

Key results

The challenge

Québec Blue Cross relied on manual data processes that were time-consuming, often taking three hours to complete deployments, error-prone, and impossible to scale as its data operations grew.

The solution

The team adopted Dremio as a semantic layer with dbt Core and Apache Airflow orchestration, automating validation and deployment of physical and virtual datasets.

The results, in context

Deployment time fell from three hours to four minutes and seven seconds, a 98% reduction. Within a single quarter the team grew from 200 to 1,200 physical datasets (6x) and expanded virtual datasets from 950 to 1,400, a 140% increase.

Products used