Operational Data Analytics
End-to-end setup for analyzing operational database data in the lakehouse: Unity Catalog with external storage, Lakebase provisioning, Lakebase Change Data Feed (CDF) replication, and a medallion architecture pipeline with silver and gold layers.
Build with AI
- Copy the prompt below
- Paste into Cursor, Claude Code, Codex, or any coding agent
- Your agent builds it — asking questions along the way so the result is exactly what you want
New to templates? Learn more here
An end-to-end operational data analytics pipeline: data flows from an OLTP database (Lakebase Postgres) through CDC replication into Unity Catalog, gets transformed through a medallion architecture (bronze/silver/gold layers), and is ready for dashboards and downstream consumers.
Components
- Unity Catalog Setup — configure Unity Catalog with external S3 storage for your destination catalog and schema.
- Create a Lakebase Instance — provision a managed Postgres project as the OLTP source.
- Lakebase Change Data Feed (CDF) — enable continuous replication from Lakebase tables to Unity Catalog Delta history tables.
- Medallion Architecture from CDC — build silver (current-state) and gold (analytical) layers from the CDC history tables using Lakeflow Declarative Pipelines.
