Databricks · Databricks Data Analyst Associate
SQL warehouses and Genie Code
Databricks Data Analyst Associate · Lesson 6 of 18 · 44:26
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the Databricks Certified Data Analyst Associate exam. In this lesson: serverless, pro, and classic SQL warehouses, sizing and scaling (cluster size against spills, more clusters against queues), Genie Code (formerly the Databricks Assistant) in the SQL editor and in notebooks, and its slash commands. Includes three original practice questions.
Preview the topics
- Cobbleway’s analysts wait several minutes each morning for their warehouse to start, and the load changes a lot through the day. The admin wants a fast start and elastic compute, with nothing to manage. Which warehouse type fits?
- On Monday mornings, dashboard queries are slow. The query profiles show no spill to disk, but many queries wait in the queue at peak time. What should the admin change?
- A query in the SQL editor fails with an error, and the analyst wants Genie Code to propose a correction, shown as a diff to accept or reject. What is the quickest way?