Databricks Data Intelligence Platform on GCP
Overview
The Databricks Data Intelligence Platform on Google Cloud provides a unified architecture for ingesting, transforming, governing, and serving data and AI workloads across the supply chain. It combines a lakehouse foundation (Delta Lake, Unity Catalog) with AI/ML capabilities (Mosaic AI), operational analytics, and a governed integration layer — all running on Google Cloud Storage as the persistence tier.
The architecture is structured across seven horizontal phases: Sources → Ingest → Transform → Query/Process → Serve → Analyse, with a vertical Integrate column for cross-cutting concerns (identity, governance, AI services, orchestration).
Architecture Diagram
Component Descriptions
Sources
| Source | Type | Ingestion path |
|---|---|---|
| Files / Logs | Semi-structured | ETL via Auto Loader or Lakeflow Connect |
| Sensors & IoT | Unstructured | ETL via Pub/Sub + Datastream |
| RDBMS / DWH | Structured | ETL via Lakeflow Connect / Cloud Data Fusion |
| Business Apps | Structured | ETL via Lakeflow Connect |
| Media | Unstructured | ETL / Federation |
| HMS* / BigQuery | Federated catalog | Federation via Unity Catalog |
| Marketplaces / Data Shares | External datasets | Sharing via Delta Sharing |
Ingest
| Component | Role |
|---|---|
| Lakeflow Connect | Native managed connector for batch and CDC ingestion from databases and SaaS sources |
| Auto Loader | Incremental file-based ingestion from cloud storage with schema inference |
| Cloud Data Fusion | GCP-native ETL/ELT pipelines for complex data integration flows |
| Pub/Sub | GCP managed message bus for real-time event ingestion |
| Datastream | GCP CDC (change data capture) service for streaming database changes |
Platform layers
| Layer | Key components | Purpose |
|---|---|---|
| Orchestration | Lakeflow Jobs, MLflow, Asset Bundles, SDKs, Terraform Provider | CI/CD, job scheduling, MLOps lifecycle, IaC |
| Mosaic AI | Feature Engineering, Traditional ML, Agent Bricks, Agent Framework, Vector Search, Model Serving, AI Gateway | End-to-end AI/ML and GenAI development and serving |
| Data Engineering | Pipelines, Spark / Photon | Batch and streaming data transformation at scale |
| Data Warehousing | AI Functions, Databricks SQL, Connectors & APIs | SQL analytics, embedded AI functions, external connectivity |
| Data Intelligence | Assistant, Predictive Optimization, Predictive IO | Natural language interface, automated performance tuning |
| Unity Catalog | Federation, Access Control, Catalog & Lineage, Data & AI Assets, Business Semantics, Quality Monitoring | Single governance layer for data and AI assets across the platform |
| Data Management | Delta Lake, Iceberg, bronze/silver/gold medallion | Open-format lakehouse storage with ACID transactions |
| Collaboration | Delta Sharing, Marketplace, Clean Rooms | Secure cross-organisation data sharing and collaboration |
Serve & Analyse
| Component | Type | Consumer |
|---|---|---|
| Dashboards | AI/BI | Business users |
| Genie | AI/BI conversational analytics | Business users |
| Cloud BigTable | Operational DB (low-latency NoSQL) | Applications |
| Cloud SQL | Operational DB (relational) | Applications |
| Data Store | Operational DB (Firestore) | Applications |
| Looker | BI / semantic layer | Analysts, executives |
| Databricks Apps | Native application hosting | Internal apps |
| Business / AI App | Custom application | End users |
| Data Consumer | Sharing Partner | External partners |
Integrate (cross-cutting)
| Component | Role |
|---|---|
| ID Provider | Authentication and SSO for platform access |
| Enterprise Catalog (Governance) | External data catalog federation; policy import/export |
| Anthropic | Third-party frontier model access via AI Gateway |
| Vertex AI | GCP-native model registry, AutoML, managed endpoints |
| External Orchestrator | Airflow, Cloud Composer, or other external schedulers triggering Databricks jobs |
Storage
Google Cloud Storage is the single underlying object store. All Delta Lake tables, Iceberg tables, and raw files persist in GCS buckets, decoupling compute from storage and enabling independent scaling of each tier.
Key Design Decisions
- Open lakehouse over proprietary lock-in. Delta Lake and Iceberg are open table formats. Unity Catalog governs both, and data can be read by any Iceberg-compatible engine, reducing dependence on a single vendor.
- Unity Catalog as the single governance plane. All data assets — tables, ML models, volumes, notebooks — are registered in Unity Catalog. Access control is attribute-based and enforced at query time, not at the ETL layer.
- Medallion architecture for data quality. Bronze (raw), silver (cleaned/conformed), gold (business-ready aggregates) layers enforce quality gates and make data lineage traceable end-to-end.
- AI Gateway as the frontier model abstraction. All GenAI calls (Anthropic, Vertex AI, self-hosted models) are routed through the AI Gateway, enabling rate limiting, cost attribution, audit logging, and model swapping without application changes.
- Google Cloud Storage as the decoupled storage tier. Compute (Databricks clusters) and storage (GCS) scale independently. All data survives cluster termination, and multiple compute engines can access the same tables concurrently.
- Sharing via Delta Sharing, not data copy. External partners and marketplaces receive live, governed access to data shares rather than point-in-time extracts, keeping a single source of truth.
Related Principles
- Data as a Strategic Asset
- Single Source of Truth
- Accessible with Governance
- Loosely Coupled, Highly Cohesive
- Cloud-Native by Default
- Observability First
Related Capabilities
- Demand Planning — consumes gold-layer demand signals
- Supply Planning — constrained planning models run on Databricks SQL / Spark
- Performance Management & Reporting — Looker and Genie serve KPI dashboards
- Supplier Quality Management — quality monitoring via Unity Catalog data quality
- Warehouse Management — operational events ingested via Pub/Sub and Datastream
- Transportation Management — track & trace events feed real-time control tower views