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
- 2Query 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
Also covered here
- Genie 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.
- SQL 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…
News
No news for this area.
Resources
Nothing of that kind for this area. Try the full list.