Product area
SQL Warehouses
SQL warehouses: types (classic, pro, serverless), sizing, scaling, costs, and when to use one instead of a cluster.
Concepts
- 1Sizing a SQL warehouseA SQL warehouse is compute dedicated to running SQL: the SQL editor, dashboards, alerts, Genie Agents, and any BI tool connecting over JDBC/ODBC all point at one. Setting one up means two separate choices — a type (serverless, pro, or classic) and a size (a…Intermediate
- 2Standalone materialized views in Databricks SQLA standalone materialized view is a Unity Catalog managed table that physically stores the result of a query, defined outside a Lakeflow pipeline. You write CREATE MATERIALIZED VIEW in the SQL editor, or from a notebook on serverless general compute, and…Intermediate
- 3Streaming tables from Databricks SQLA streaming table is a Unity Catalog managed table that only ever appends, and that keeps itself up to date by reading new rows from its source. The standalone version is the one you declare in the SQL editor with CREATE OR REFRESH STREAMING TABLE, without…Intermediate
- 4SQL warehouse types and channelsA SQL warehouse has two settings that decide what engine you get, and neither of them is the t-shirt size. The type decides where the compute runs and which acceleration features the engine has. The channel decides which Databricks SQL compute version that…Intermediate
News
No news for this area.