warehouse & BIBeginner
SQL & Analytics
Query the lakehouse from the SQL editor, model gold tables and views for BI, and understand what a SQL warehouse costs.
0 of 30 done
30 of 30 written|~30 h
01Foundations
02Model for BI
03Query and serve
Platform & governanceData engineering · LakeflowData warehousing & BI
Drag to pan · scroll to zoom · click a task to open it · the small button says what it covers
The same path as a list30 concepts
Stage 1 · Foundations
Delta Lake, the lakehouse table formatUnity Catalog, the governance layerThe SQL editorGenie CodeSQL warehouse sessionsQuery parameters and session variablesStage 2 · Model for BI
Gold objects: tables, views, materialized views, streaming tablesMedallion architecture: bronze, silver, goldMetric viewsModelling data inside a dashboardDomains and PagesDashboard filters, parameters and variablesDashboard schedules and subscriptionsStage 3 · Query and serve
Sizing a SQL warehouseReading the query profileAI/BI dashboardsGenie AgentsThe Genie knowledge storeGenie benchmarks, feedback and monitoringStandalone materialized views in Databricks SQLThe Genie OntologyStreaming tables from Databricks SQLSQL alertsUsing Genie outside the UI: API, embedding and agentsWhat an alert costs to runSQL warehouse types and channelsQuery performance insightsQuery caching layersTuning a Genie Agent for correct answersGenie OneThe analyst’s half of the platform. You do not need to know Spark internals to be useful here, but you do need to know what a warehouse costs, why a query is slow, and which object to build for BI.
If you already run pipelines, jump straight to the Query and serve stage: the modelling concepts overlap with Data Engineering.
Full resources for this path
593 freeAuthor an agent and deploy it on Databricks AppsDocumentation · Databricks · checked 24 Oct 2026Free
Create agent tools using Unity Catalog functionsDocumentation · Databricks · checked 24 Oct 2026Free
Databricks Runtime 17.3 LTS for Machine LearningDocumentation · Databricks · checked 24 Oct 2026Free
Priority pay-per-token for Foundation Model APIsDocumentation · Databricks · checked 24 Oct 2026Free
Fine-grained access control on dedicated computeDocumentation · Databricks · checked 24 Oct 2026Free
Advancing Spark - Photon on Databricks ClustersVideo · Advancing Analytics · checked 17 Oct 2026Free
Create agent tools using Unity Catalog functionsDocumentation · Databricks · checked 10 Oct 2026Free
Configure Structured Streaming trigger intervalsDocumentation · Databricks · checked 17 Oct 2026Free
Performance Tuning - Spark 4.2.0 DocumentationDocumentation · Apache Spark · checked 17 Oct 2026Free
Set Spark configuration properties on DatabricksDocumentation · Databricks · checked 17 Oct 2026Free
Nothing of that kind on this path. Try the full list.