Data Modeling & Warehousing Fundamentals
Back to Modern Warehouse Engines & Performance

Snowflake Trial Setup — First Query & Credits Report

Plan 100 W8 wh-03: Snowflake trial setup (video companion article). Check: LAB SF-1 credits report.

3 minutesReading
🎯 Free Guest Mode: You are learning for free. Sign in to save your completion progress and quiz answers.

Outcome: Run your first query on a Snowflake trial and read credits consumed. Check: LAB SF-1 credits report (query history + credits).

1. Setup (free 30-day trial, no warehouse left running)

  1. Sign up for a Snowflake trial; create database W8_LAB and an X-SMALL warehouse LAB_WH with AUTO_SUSPEND = 60.
  2. Load w7-retail via the UI wizard (or the provided COPY INTO starter), then run:
USE WAREHOUSE LAB_WH;
SELECT date_trunc('month', order_date) AS m, SUM(line_total) AS revenue
FROM w8_lab.orders GROUP BY 1 ORDER BY 1;
  1. Open Query History: note wall-clock time, partitions scanned/pruned, and credits billed (QUERY_HISTORY / Account Usage).

2. LAB SF-1 credits report (required evidence)

Submit: warehouse size + auto-suspend setting + Query History screenshot with credits for the query above. Always suspend/drop LAB_WH when done. One paragraph: what auto-suspend protects you from, cost-wise.

Loading progress...