Product area
SQL Editor
The workspace SQL editor: saved queries, snippets, parameters, running on SQL warehouses.
Concepts
- 1The SQL editorThe SQL editor is the workspace's dedicated place to write and run SQL against a warehouse: one statement or several, with results, a query history, and everything needed to save and share a query — no notebook cells, no other language.Beginner
- 2Genie CodeGenie Code is the assistant built into the workspace. It writes and runs code, builds pipelines and dashboards, explains and fixes errors, and reads Unity Catalog to know what your tables actually contain.Beginner
- 3SQL warehouse sessionsA session is the state a SQL warehouse keeps for you between statements. It is created the first time you run a query on a warehouse, and from then on the statements you run share variables, temporary views, temporary tables, the current catalog and schema…Intermediate
- 4Query parameters and session variablesA named parameter marker is a colon followed by a name, written where a value would go: WHERE fareamount < :fareparameter. It is a typed placeholder, not text substitution. The value is supplied when the statement runs, by the widget the surface renders, by…Intermediate
News
No news for this area.