DOC // DZ-ARCH-001PLANE: WORKDAY DATA CLOUD ↔ DATA BRICKS/SNOWFLAKE LAKEHOUSE
Enterprise Architecture Practice

Engineering Zero-ETL Federation and Deterministic AI Execution Rails.

We bridge Workday Data Cloud and Databricks / Snowflake Lakehouses for Healthcare IDNs. Strict CDMC Governance. Zero API Latency.

FIG-1.0 // TOPOLOGY
01. SOURCE PLANE
Workday wd5 / Prism / Epic / GHX
↓ Apache Iceberg + Polaris Catalog
02. LAKEHOUSE PLANE
Databricks / Snowflake External Tables / Trino LDQ
↓ OIDC Token Exchange + MCP JSON-RPC
03. EXECUTION RAILS
Colilot / Claude / Gemini / Agent Gateway
STATUS: PRODUCTION SPECCDMC-COMPLIANT
TARGET VERTICAL
HEALTHCARE IDNS
GOVERNANCE FRAMEWORK
EDM COUNCIL CDMC
TABLE FORMAT
APACHE ICEBERG V2
API INGESTION LATENCY
0 MS (ZERO-COPY)

SEC-02 // CORE ARCHITECTURE PRIMITIVES

3-COLUMN SPECIFICATION
SPEC-01

Zero-Copy Federation

Apache Iceberg

Direct Iceberg table metadata registration across Workday Data Cloud and Snowflake Polaris catalogs. Elimination of batch ETL pipelines, staging S3 buckets, and redundant Parquet egress.

  • >Catalog: Apache Polaris / Iceberg v2
  • >Sync Mode: Metadata Pointer Registration
  • >Storage Footprint: Single-Copy Object Store
SPEC-02

Model Context Protocol

Copilot/Claude/Gemini Orchestration

Typed MCP server interfaces binding Microsoft Copilot, Anthropic Claude and Google Gemini toolchains to Workday Agent Gateway, Databricks Mosaic and Snowflake Cortex endpoints. Schema-validated JSON-RPC execution.

  • >Transport: JSON-RPC 2.0 / SSE
  • >Contract: Strict JSON Schema Payloads
  • >Execution: Deterministic Tool Routing
SPEC-03

Identity Federation

OIDC/OAuth 2.0

End-to-end token propagation mapping Entra ID and Okta claims directly to Snowflake RBAC roles and Workday Security Domains. Row-level HIPAA policy enforcement at query runtime.

  • >Protocol: OIDC / OAuth 2.0 Token Exchange
  • >Policy: Dynamic Row & Column Masking
  • >Audit: Immutable Principal Attribution

SEC-03 // IMPLEMENTATION PATHWAYS

Review fixed-fee engineering deliverables and healthcare IDN reference topologies.