Overview

Snowflake is the leading multi-cloud data warehouse – runs on AWS, Azure, GCP. The Automize Snowflake connector covers SQL execution + database/schema/warehouse metadata via the Snowflake SQL API.

Regions: Account lives in one cloud region (AWS us-east-1, Azure West Europe, etc.). Replication for cross-region DR.
Plans: Per-credit pricing for warehouse compute + per-GB-month storage. Editions: Standard, Enterprise, Business Critical, VPS.

Setting up the connection

Auth type: Bearer Token.

Snowflake → Admin → Users → create user with default role + default warehouse.
Generate key pair or use OAuth via Snowflake's auth integration.
In Automize → Settings → Connectors → Snowflake. Paste account identifier + token. Account format: <orgname>-<account_name>.

Find your credentials at https://app.snowflake.com/.

Rate limits

Per-warehouse concurrency limited by warehouse size + queue policy. SQL API rate-limited per user (~few hundred req/min).

Data model

Hierarchy:

    Account ─┬─ Databases ─── Schemas ─── Tables / Views
             ├─ Warehouses (compute clusters)
             └─ Roles + Users

Available operations

3 operations available. Click any row to jump to its detail.

Operation	Category	What it does
Cancel Statement	General	Cancel a running statement
Execute SQL	General	Execute a SQL statement
Get Statement Status	General	Check status of a SQL statement

Operations

Cancel Statement

Cancel a running statement

Parameter	Required	Type	Description
Statement Handle `statement_handle`	Yes	text

Execute SQL

Execute a SQL statement

Parameter	Required	Type
Statement `statement`	Yes	text
Database `database`	Yes	textarea
Schema `schema`	Yes	text
Warehouse `warehouse`	Yes	text
Role `role`	Yes	text

Tips

statement: SQL. Returns statementHandle for async polling on large queries.
warehouse + database + schema as context.

Get Statement Status

Check status of a SQL statement

Parameter	Required	Type	Description
Statement Handle `statement_handle`	Yes	text

FAQ

Warehouse sizing?: XS to 6XL. Larger = faster but more credits/hour. Use Auto-Suspend (60 sec idle) + Auto-Resume for cost control.
Snowflake vs BigQuery vs Redshift?: Snowflake: best multi-cloud + separated storage/compute. BigQuery: best serverless on GCP. Redshift: most mature on AWS.

Snowflake integration