How to Use Snowflake

Snowflake is a cloud data warehouse that separates storage from compute, so you can scale query power up, down, or off entirely, independent of how much data you actually have stored.

Step 1: Create a warehouse

A "virtual warehouse" is Snowflake's unit of compute. Pick a size (X-Small and up) based on your workload — it auto-suspends when idle so you're not paying for compute nobody's using.

Step 2: Load data

Bring data in with COPY INTO from cloud storage (S3, Azure Blob, GCS), Snowpipe for continuous streaming loads, or a connector/ETL tool pointed at your Snowflake account.

Step 3: Query with standard SQL

Snowflake uses ANSI SQL, so most existing SQL knowledge carries over directly. Snowsight, the browser-based worksheet, is where most day-to-day querying happens.

Step 4: Share data without copying it

Secure Data Sharing grants another Snowflake account live, read-only access to your data without exporting or duplicating anything — the recipient queries your actual data in place.

Step 5: Monitor credit usage

The Account Usage views and Snowsight's cost dashboards show which warehouses and queries are consuming the most compute credits, which matters since that's what actually drives your bill.

Where it bites

Cost is driven by compute-seconds, not just data volume — a warehouse left running, or sized larger than a workload actually needs, quietly burns credits even with nobody actively querying. Auto-suspend settings matter more here than most new users expect.