alvinsnow

HomeGuides

Same result,
two ways.

Almost everything in Snowflake can be built by typing SQL or by clicking through Snowsight. Each guide does both, side by side, with the same names, so you can follow one path, compare them, or start in the UI and keep the result as code.

Create a warehouse
CREATE WAREHOUSE ANALYTICS_WH
  WAREHOUSE_SIZE = XSMALL
  GENERATION = '2'
  AUTO_SUSPEND = 60
  AUTO_RESUME = TRUE;

-- one script: review it, rerun it, keep it in Git

New warehouse

NameANALYTICS_WH
TypeStandard (Gen2)
SizeX-Small
Suspend after1 minute
Create Warehouse
Compute › Warehouses= same warehouse

§1 How each guide works

How each guide works

  1. i.Set up onceType your own object names at the top. Every SQL snippet and GUI step updates to match.
  2. ii.Path A · SQLThe whole build as a script you can copy, review and keep in version control.
  3. iii.Path B · SnowsightThe same build, click by click, with screenshots of the key screens.
  4. iv.Which path?When each one wins, then clean-up steps and links to the official docs.