cd ../projects
Data Platform / CI/CD

Databricks + Snowflake DevOps

Azure DevOps YAML pipelines for data platform CI/CD

Azure DevOpsDatabricksSnowflakedbtPythonUnity CatalogDelta Lake

OVERVIEW

End-to-end DevOps automation for Databricks Unity Catalog migration and Snowflake dbt deployments using Azure DevOps multi-stage YAML pipelines, automated testing, and blue/green deployment strategies for zero-downtime data platform releases.

ARCHITECTURE

// mermaid architecture diagram
graph LR
  subgraph DEV["Development"]
    GIT[Git Repository]
    PR[Pull Request]
  end
  subgraph CICD["Azure DevOps Pipeline"]
    LINT[dbt lint & test]
    UNIT[Unit Tests]
    PLAN[Databricks Plan]
    DEPLOY_STG[Deploy Staging]
    DEPLOY_PRD[Deploy Production]
  end
  subgraph DATA["Data Platforms"]
    SNOW[Snowflake]
    DBX[Databricks UC]
    DELTA[Delta Lake]
  end
  GIT --> PR --> LINT --> UNIT --> PLAN --> DEPLOY_STG --> DEPLOY_PRD
  DEPLOY_STG --> SNOW & DBX
  DEPLOY_PRD --> DELTA

💡 Render with mermaid.live for interactive diagram

KEY HIGHLIGHTS

  • Multi-stage Azure DevOps pipeline: lint → test → plan → staging → prod
  • Unity Catalog migration scripts preserving ACLs and lineage
  • dbt model orchestration with Databricks Workflows
  • Automated rollback on test failure with Slack notifications
  • Secret management via Azure Key Vault referenced in pipelines

METRICS

100+ dbt models automated
Unity Catalog migration for 5TB+ data
Zero downtime deployments
60% faster release cycles

TECH STACK

Azure DevOpsDatabricksSnowflakedbtPythonUnity CatalogDelta Lake
Back to all projects