🗄️Snowflake
Also known as Snowflake Data Cloud, Snowflake Data Warehouse
A warehouse in the cloud. You pay for the space and the work apart.
Think of it like
It is like a library where you rent reading rooms by the hour. The books stay put. You pay for the rooms you use.
Example
A team runs reports on a small warehouse and a big monthly job on a large one. Both read the same tables at once.
Why it matters
Teams can query the same data without slowing each other down. A paused warehouse costs nothing for compute.
Definition
Example code
sql
CREATE WAREHOUSE reporting_wh
WAREHOUSE_SIZE = 'XSMALL'
AUTO_SUSPEND = 60;Common mistake
Key takeaways
- 1Storage apart. Data sits in one shared store.
- 2Compute apart. Virtual warehouses run the queries.
- 3Pay per use. Paused compute costs nothing.