Data Modeling with Databricks SQL — Databricks Certified Data Analyst Associate

Official references for this objective

• Databricks — Building a Production: Scale Dimensional Data Mart With Lakeflow Spark Declarative Pipelines and AUTO CDC | Databricks

  how to use AUTO CDC to handle data updates across batch and streaming pipelines, supporting continuously arriving sales transactions alongside rapidly changing product, store and

• Databricks — Modern Data Modeling at Scale: Advanced Patterns | Databricks

  how to leverage primary and foreign keys, identity columns for surrogate keys, column-level data quality constraints and much more

• Databricks — Advanced SQL Patterns for Production Analytics | Databricks

  MATCH_RECOGNIZE is landing on Databricks SQL — and it changes how analysts express row patterns.

• Databricks — Best Practices for Running dbt on Databricks: From SQL Models to Production Pipelines | Databricks

  proven patterns for building a medallion-style architecture, orchestrating dbt jobs directly in Databricks, and applying governance and observability using Unity Catalog

• Databricks — Spatial Simplified With Databricks SQL Where-House: Patterns, Performance and Applications | Databricks

  how Databricks Spatial SQL scales spatial workloads, and what this means for real-world use cases