Databricks Assistant in the SQL editor and notebooks

Starts at 37:22 in this video — SQL Warehouse full course — SQL editor (37:22)

Why this is on the exam

The outline explicitly includes Databricks Assistant in a notebook or SQL editor to write and debug SQL. Assistant is not Genie. Genie is a curated NL space over selected tables. Assistant sits next to *your* query and uses workspace/UC context.

Commands you should recognize

Exact slash-commands can vary slightly by UI version, but the exam sample maps intent to command:

`/explain` — step-by-step explanation of a query and likely issues. This is the debug/understand command.
`/generate` (or equivalent generate) — draft SQL from a prompt.
`/fix` / debug — propose a corrected statement.
`/help` — product help, not a query walkthrough.
There is no standard /optimize that rewrites Photon plans for you.

Analyst practice

Always read the generated SQL against the real schema. Assistant can hallucinate column names. Ground truth is Catalog Explorer + DESCRIBE TABLE.

SQL editor · AI assistive features