Warehouses

Databricks SQL Warehouses

Types of SQL Warehouses

Sample SQL Query and Monitoring

SELECT c.c_mktsegment,count(o.o_orderkey) total_orders
FROM
dev.etl.orders_bronze o
LEFT JOIN dev.etl.customer_scd2_bronze c
ON o.o_custkey = c.c_custkey
WHERE c.__END_AT is null
group by c.c_mktsegment

Query Monitoring