Investigate why two datasets that should agree don't — two pipelines writing the same logical table, a rollup vs the detail it aggregates, a dashboard vs its source, one environment vs another. Use when row counts, totals, or date ranges disagree and the question is what happened rather than just what differs. Covers…
Run the project cost report and write the analysis into it. Use when asked about this project's cloud spend, cost anomalies, spikes or trends, DBU/DSU consumption, per-job or per-pipeline cost, or the AWS vs Databricks split. Runs make project-costs (AWS Cost Explorer + Databricks system.billing), then analyses the…
Diagram a SQL query and explain what it shows — either its execution steps (mode=plan) or its column lineage (mode=lineage) — then trace it through small data so the defects the picture cannot show become visible. Use when asked to visualize, diagram, explain or review what a query does, how it joins its tables, or…
Native Databricks AI/BI Lakeview Dashboard patterns for Alpura. Load when building, editing, or reviewing any Databricks Dashboard — dataset SQL queries, widget configuration, counter tiles, chart tiles, filter widgets, parameter references, layout, and markdown header tiles. Also load when the user asks about…
Delta Live Tables pipeline patterns for Alpura's Medallion architecture. Load when building or reviewing any DLT pipeline, ingestion notebook, Bronze/Silver/Gold table definitions, streaming pipeline code, CDC patterns, or SCD Type 2 slowly changing dimensions. Also load when the user mentions Auto Loader, DLT…
Complete UX/UI design system + Plotly chart layer for all Databricks Apps at Alpura. Load when building, reviewing, or debugging any app UI — dashboards, ui.py, app.py, Plotly charts, KPI cards, filter panels, data tables, dark-theme layouts, or any visual component. Also @mention when the user asks about colors…