Snowflake SQL Parser Support in GSP¶
Explore the Snowflake SQL Parser product page
This page documents the SQL syntax support for Snowflake in the General SQL Parser.
Syntax Coverage Corpus¶
GSP tests Snowflake syntax against 455 documented constructs grouped into 15 categories, each cross-referenced to the documentation that defines it (151 distinct source pages).
Parse coverage¶
Measured against GSP Java 4.2.8 on 2026-08-31 (UTC) (artifact sha256 1117856ef134). Each construct below carries the complete set of examples from the Snowflake documentation; a construct counts as fully covered only when every one of its examples parses. Percentages are pass rates over this documented-example corpus — not a percentage of the entire SQL dialect.
| Constructs fully parsed | Individual statements parsed | |
|---|---|---|
| All constructs | 455 of 455 (100%) | 757 of 757 (100%) |
| SELECT (queries) | 56 of 56 (100%) | 94 of 94 (100%) |
| DML (INSERT / UPDATE / DELETE / MERGE) | 41 of 41 (100%) | 66 of 66 (100%) |
| Stored procedures | 34 of 34 (100%) | 38 of 38 (100%) |
Statements are split using the parser's own statement splitter, so multi-statement examples and procedure bodies are counted correctly. The SELECT, DML and stored-procedure rows classify each statement by its parsed statement type: a construct is counted in a row when its examples contain at least one statement of that class, and is fully parsed when all of them parse. Stored procedures covers CREATE PROCEDURE / FUNCTION / PACKAGE / TRIGGER definitions and anonymous blocks.
Machine-readable: dialect data (JSON) · all-dialect matrix · coverage matrix overview
All 455 constructs¶
| Construct | Category | Parses | Specified in |
|---|---|---|---|
ALTER ACCOUNT |
Account & Session DDL | all 1 | Snowflake docs |
ALTER ACCOUNT |
Account & Session DDL | all 1 | Snowflake docs |
ALTER SESSION |
Account & Session DDL | all 1 | Snowflake docs |
ALTER SESSION |
Account & Session DDL | all 1 | Snowflake docs |
CREATE MANAGED ACCOUNT |
Account & Session DDL | all 1 | Snowflake docs |
DESCRIBE RESULT |
Account & Session DDL | all 1 | Snowflake docs |
DESCRIBE RESULT |
Account & Session DDL | all 2 | Snowflake docs |
DROP MANAGED ACCOUNT |
Account & Session DDL | all 1 | Snowflake docs |
SET |
Account & Session DDL | all 2 | Snowflake docs |
SET |
Account & Session DDL | all 1 | Snowflake docs |
SET |
Account & Session DDL | all 1 | Snowflake docs |
SET |
Account & Session DDL | all 1 | Snowflake docs |
SET |
Account & Session DDL | all 2 | Snowflake docs |
SHOW FUNCTIONS |
Account & Session DDL | all 1 | Snowflake docs |
SHOW FUNCTIONS |
Account & Session DDL | all 1 | Snowflake docs |
SHOW GLOBAL ACCOUNTS |
Account & Session DDL | all 1 | Snowflake docs |
SHOW MANAGED ACCOUNTS |
Account & Session DDL | all 1 | Snowflake docs |
SHOW PARAMETERS |
Account & Session DDL | all 1 | Snowflake docs |
SHOW PARAMETERS |
Account & Session DDL | all 1 | Snowflake docs |
SHOW PARAMETERS |
Account & Session DDL | all 2 | Snowflake docs |
SHOW REPLICATION ACCOUNTS |
Account & Session DDL | all 1 | Snowflake docs |
SHOW REPLICATION DATABASES |
Account & Session DDL | all 1 | Snowflake docs |
SHOW REPLICATION DATABASES |
Account & Session DDL | all 1 | Snowflake docs |
UNSET |
Account & Session DDL | all 3 | Snowflake docs |
CALL |
COMMENT | all 3 | Snowflake docs |
ALTER FILE FORMAT |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
ALTER FILE FORMAT |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
ALTER PIPE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
ALTER PIPE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
ALTER PIPE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
ALTER PIPE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
ALTER PIPE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
ALTER PIPE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
ALTER STAGE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
ALTER STAGE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
ALTER STAGE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
ALTER STAGE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
ALTER STAGE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
CREATE FILE FORMAT |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
CREATE FILE FORMAT |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
CREATE FILE FORMAT |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
CREATE PIPE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
CREATE PIPE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
CREATE PIPE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
CREATE PIPE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
CREATE STAGE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
CREATE STAGE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
CREATE STAGE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
CREATE STAGE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
CREATE STAGE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
CREATE STAGE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
CREATE STAGE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
CREATE STAGE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
CREATE STAGE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
CREATE STAGE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
CREATE STAGE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
DESCRIBE FILE FORMAT |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
DESCRIBE PIPE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
DESCRIBE STAGE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
DROP FILE FORMAT |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
DROP PIPE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
DROP STAGE |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
SHOW FILE FORMATS |
Data Loading / Unloading DDL | all 2 | Snowflake docs |
SHOW FILE FORMATS |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
SHOW FILE FORMATS |
Data Loading / Unloading DDL | all 1 | Snowflake docs |
SHOW PIPES |
Data Loading / Unloading DDL | all 2 | Snowflake docs |
ALTER STREAM |
Data Pipeline DDL | all 1 | Snowflake docs |
ALTER TASK |
Data Pipeline DDL | all 1 | Snowflake docs |
ALTER TASK |
Data Pipeline DDL | all 1 | Snowflake docs |
ALTER TASK |
Data Pipeline DDL | all 1 | Snowflake docs |
ALTER TASK |
Data Pipeline DDL | all 2 | Snowflake docs |
ALTER TASK |
Data Pipeline DDL | all 1 | Snowflake docs |
ALTER TASK |
Data Pipeline DDL | all 1 | Snowflake docs |
CREATE STREAM |
Data Pipeline DDL | all 1 | Snowflake docs |
CREATE STREAM |
Data Pipeline DDL | all 1 | Snowflake docs |
CREATE STREAM |
Data Pipeline DDL | all 1 | Snowflake docs |
CREATE STREAM |
Data Pipeline DDL | all 1 | Snowflake docs |
CREATE STREAM |
Data Pipeline DDL | all 1 | Snowflake docs |
CREATE TASK |
Data Pipeline DDL | all 1 | Snowflake docs |
CREATE TASK |
Data Pipeline DDL | all 1 | Snowflake docs |
CREATE TASK |
Data Pipeline DDL | all 1 | Snowflake docs |
CREATE TASK |
Data Pipeline DDL | all 1 | Snowflake docs |
CREATE TASK |
Data Pipeline DDL | all 2 | Snowflake docs |
DESCRIBE STREAM |
Data Pipeline DDL | all 1 | Snowflake docs |
DESCRIBE TASK |
Data Pipeline DDL | all 1 | Snowflake docs |
DROP STREAM |
Data Pipeline DDL | all 3 | Snowflake docs |
DROP STREAM |
Data Pipeline DDL | all 1 | Snowflake docs |
DROP TASK |
Data Pipeline DDL | all 3 | Snowflake docs |
DROP TASK |
Data Pipeline DDL | all 1 | Snowflake docs |
SHOW STREAMS |
Data Pipeline DDL | all 1 | Snowflake docs |
SHOW STREAMS |
Data Pipeline DDL | all 1 | Snowflake docs |
SHOW TASKS |
Data Pipeline DDL | all 1 | Snowflake docs |
SHOW TASKS |
Data Pipeline DDL | all 1 | Snowflake docs |
ALTER DATABASE |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
ALTER DATABASE |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
ALTER DATABASE |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
ALTER SCHEMA |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
ALTER SCHEMA |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
ALTER SHARE |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
ALTER SHARE |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
ALTER SHARE |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
CREATE <object> … CLONE |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
CREATE <object> … CLONE |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
CREATE <object> … CLONE |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
CREATE <object> … CLONE |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
CREATE <object> … CLONE |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
CREATE <object> … CLONE |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
CREATE DATABASE |
Database, Schema, & Share DDL | all 3 | Snowflake docs |
CREATE DATABASE |
Database, Schema, & Share DDL | all 2 | Snowflake docs |
CREATE DATABASE |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
CREATE DATABASE |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
CREATE SCHEMA |
Database, Schema, & Share DDL | all 2 | Snowflake docs |
CREATE SCHEMA |
Database, Schema, & Share DDL | all 2 | Snowflake docs |
CREATE SCHEMA |
Database, Schema, & Share DDL | all 2 | Snowflake docs |
CREATE SHARE |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
DESCRIBE SHARE |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
DESCRIBE SHARE |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
DROP DATABASE |
Database, Schema, & Share DDL | all 3 | Snowflake docs |
DROP SCHEMA |
Database, Schema, & Share DDL | all 2 | Snowflake docs |
DROP SHARE |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
SHOW DATABASES |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
SHOW DATABASES |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
SHOW SCHEMAS |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
SHOW SCHEMAS |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
SHOW SHARES |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
UNDROP DATABASE |
Database, Schema, & Share DDL | all 2 | Snowflake docs |
UNDROP SCHEMA |
Database, Schema, & Share DDL | all 2 | Snowflake docs |
USE DATABASE |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
USE SCHEMA |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
USE SCHEMA |
Database, Schema, & Share DDL | all 1 | Snowflake docs |
DROP <object> |
DDL Commands | all 4 | Snowflake docs |
USE <object> |
DDL Commands | all 1 | Snowflake docs |
USE <object> |
DDL Commands | all 1 | Snowflake docs |
USE <object> |
DDL Commands | all 1 | Snowflake docs |
ALTER EXTERNAL FUNCTION |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
ALTER EXTERNAL FUNCTION |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
ALTER EXTERNAL FUNCTION |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
ALTER FUNCTION |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
ALTER FUNCTION |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
ALTER PROCEDURE |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
CREATE EXTERNAL FUNCTION |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
CREATE FUNCTION |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
CREATE FUNCTION |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
CREATE FUNCTION |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
CREATE FUNCTION |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
CREATE FUNCTION |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
CREATE PROCEDURE |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
CREATE PROCEDURE |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
DESCRIBE FUNCTION |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
DESCRIBE PROCEDURE |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
DESCRIBE PROCEDURE |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
DROP FUNCTION |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
DROP MATERIALIZED VIEW |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
DROP PROCEDURE |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
SHOW EXTERNAL FUNCTIONS |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
SHOW EXTERNAL FUNCTIONS |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
SHOW PROCEDURES |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
SHOW PROCEDURES |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
SHOW USER FUNCTIONS |
DDL for User-Defined Functions, External Functions, and Stored Procedures | all 1 | Snowflake docs |
COPY INTO <location> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <location> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <location> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <location> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <location> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <location> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <location> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <location> |
DML Commands | all 2 | Snowflake docs |
COPY INTO <location> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <location> |
DML Commands | all 3 | Snowflake docs |
COPY INTO <location> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <table> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <table> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <table> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <table> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <table> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <table> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <table> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <table> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <table> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <table> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <table> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <table> |
DML Commands | all 6 | Snowflake docs |
COPY INTO <table> |
DML Commands | all 2 | Snowflake docs |
COPY INTO <table> |
DML Commands | all 2 | Snowflake docs |
COPY INTO <table> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <table> |
DML Commands | all 1 | Snowflake docs |
COPY INTO <table> |
DML Commands | all 2 | Snowflake docs |
DELETE |
DML Commands | all 1 | Snowflake docs |
INSERT |
DML Commands | all 3 | Snowflake docs |
INSERT |
DML Commands | all 2 | Snowflake docs |
INSERT |
DML Commands | all 3 | Snowflake docs |
INSERT |
DML Commands | all 3 | Snowflake docs |
INSERT |
DML Commands | all 4 | Snowflake docs |
INSERT |
DML Commands | all 1 | Snowflake docs |
INSERT |
DML Commands | all 1 | Snowflake docs |
INSERT |
DML Commands | all 1 | Snowflake docs |
INSERT |
DML Commands | all 2 | Snowflake docs |
INSERT |
DML Commands | all 1 | Snowflake docs |
INSERT |
DML Commands | all 1 | Snowflake docs |
INSERT (multi-table) |
DML Commands | all 2 | Snowflake docs |
INSERT (multi-table) |
DML Commands | all 1 | Snowflake docs |
INSERT (multi-table) |
DML Commands | all 1 | Snowflake docs |
INSERT (multi-table) |
DML Commands | all 1 | Snowflake docs |
INSERT (multi-table) |
DML Commands | all 2 | Snowflake docs |
INSERT (multi-table) |
DML Commands | all 2 | Snowflake docs |
LIST |
DML Commands | all 1 | Snowflake docs |
LIST |
DML Commands | all 1 | Snowflake docs |
LIST |
DML Commands | all 1 | Snowflake docs |
LIST |
DML Commands | all 1 | Snowflake docs |
LIST |
DML Commands | all 1 | Snowflake docs |
MERGE |
DML Commands | all 2 | Snowflake docs |
MERGE |
DML Commands | all 2 | Snowflake docs |
MERGE |
DML Commands | all 1 | Snowflake docs |
MERGE |
DML Commands | all 2 | Snowflake docs |
MERGE |
DML Commands | all 1 | Snowflake docs |
MERGE |
DML Commands | all 3 | Snowflake docs |
MERGE |
DML Commands | all 1 | Snowflake docs |
MERGE |
DML Commands | all 1 | Snowflake docs |
MERGE |
DML Commands | all 14 | Snowflake docs |
MERGE |
DML Commands | all 1 | Snowflake docs |
PUT |
DML Commands | all 1 | Snowflake docs |
PUT |
DML Commands | all 1 | Snowflake docs |
PUT |
DML Commands | all 1 | Snowflake docs |
PUT |
DML Commands | all 1 | Snowflake docs |
REMOVE |
DML Commands | all 1 | Snowflake docs |
REMOVE |
DML Commands | all 1 | Snowflake docs |
REMOVE |
DML Commands | all 1 | Snowflake docs |
TRUNCATE TABLE |
DML Commands | all 5 | Snowflake docs |
UPDATE |
DML Commands | all 1 | Snowflake docs |
UPDATE |
DML Commands | all 3 | Snowflake docs |
UPDATE |
DML Commands | all 1 | Snowflake docs |
EXPLAIN |
GET | all 3 | Snowflake docs |
EXPLAIN |
GET | all 1 | Snowflake docs |
EXPLAIN |
GET | all 1 | Snowflake docs |
EXPLAIN |
GET | all 1 | Snowflake docs |
SELECT |
Query Syntax | all 1 | Snowflake docs |
SELECT |
Query Syntax | all 1 | Snowflake docs |
SELECT |
Query Syntax | all 2 | Snowflake docs |
Calling |
Stored Procedures | all 3 | Snowflake docs |
Catching an Error |
Stored Procedures | all 2 | Snowflake docs |
Catching an Error |
Stored Procedures | all 2 | Snowflake docs |
Create |
Stored Procedures | all 1 | Snowflake docs |
Create |
Stored Procedures | all 1 | Snowflake docs |
Dynamically |
Stored Procedures | all 3 | Snowflake docs |
Error Messages |
Stored Procedures | all 3 | Snowflake docs |
Error Messages |
Stored Procedures | all 8 | Snowflake docs |
Error Messages |
Stored Procedures | all 5 | Snowflake docs |
Examples |
Stored Procedures | all 2 | Snowflake docs |
Examples |
Stored Procedures | all 3 | Snowflake docs |
Examples |
Stored Procedures | all 2 | Snowflake docs |
JavaScript |
Stored Procedures | all 2 | Snowflake docs |
JavaScript |
Stored Procedures | all 2 | Snowflake docs |
JavaScript |
Stored Procedures | all 3 | Snowflake docs |
Line Continuation |
Stored Procedures | all 1 | Snowflake docs |
Logging an Error |
Stored Procedures | all 3 | Snowflake docs |
Logging an Error |
Stored Procedures | all 6 | Snowflake docs |
Overloading |
Stored Procedures | all 4 | Snowflake docs |
Overloading |
Stored Procedures | all 6 | Snowflake docs |
Overview |
Stored Procedures | all 4 | Snowflake docs |
Overview |
Stored Procedures | all 3 | Snowflake docs |
Owner’s Rights |
Stored Procedures | all 4 | Snowflake docs |
Protecting Privacy |
Stored Procedures | all 17 | Snowflake docs |
Recursive |
Stored Procedures | all 4 | Snowflake docs |
Retrieving Result Set Metadata |
Stored Procedures | all 3 | Snowflake docs |
Session Variables |
Stored Procedures | all 6 | Snowflake docs |
Using In Transactions |
Stored Procedures | all 3 | Snowflake docs |
Using RESULT_SCAN |
Stored Procedures | all 5 | Snowflake docs |
Using RESULT_SCAN |
Stored Procedures | all 3 | Snowflake docs |
Using RESULT_SCAN |
Stored Procedures | all 15 | Snowflake docs |
ALTER EXTERNAL TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
ALTER EXTERNAL TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
ALTER EXTERNAL TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
ALTER EXTERNAL TABLE |
Table, View, & Sequence DDL | all 4 | Snowflake docs |
ALTER MATERIALIZED VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
ALTER MATERIALIZED VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
ALTER MATERIALIZED VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
ALTER MATERIALIZED VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
ALTER MATERIALIZED VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
ALTER MATERIALIZED VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
ALTER MATERIALIZED VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
ALTER MATERIALIZED VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
ALTER MATERIALIZED VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
ALTER SEQUENCE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
ALTER TABLE |
Table, View, & Sequence DDL | all 4 | Snowflake docs |
ALTER TABLE |
Table, View, & Sequence DDL | all 7 | Snowflake docs |
ALTER TABLE |
Table, View, & Sequence DDL | all 10 | Snowflake docs |
ALTER TABLE |
Table, View, & Sequence DDL | all 10 | Snowflake docs |
ALTER TABLE |
Table, View, & Sequence DDL | all 4 | Snowflake docs |
ALTER TABLE … ALTER COLUMN |
Table, View, & Sequence DDL | all 2 | Snowflake docs |
ALTER TABLE … ALTER COLUMN |
Table, View, & Sequence DDL | all 5 | Snowflake docs |
ALTER TABLE … ALTER COLUMN |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
ALTER VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
ALTER VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
ALTER VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE EXTERNAL TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE EXTERNAL TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE EXTERNAL TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE EXTERNAL TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE EXTERNAL TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE EXTERNAL TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE EXTERNAL TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE EXTERNAL TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE EXTERNAL TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE EXTERNAL TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE EXTERNAL TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE EXTERNAL TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE MATERIALIZED VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE SEQUENCE |
Table, View, & Sequence DDL | all 2 | Snowflake docs |
CREATE SEQUENCE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE SEQUENCE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE SEQUENCE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE SEQUENCE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE SEQUENCE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE SEQUENCE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE SEQUENCE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE SEQUENCE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE SEQUENCE |
Table, View, & Sequence DDL | all 13 | Snowflake docs |
CREATE SEQUENCE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE SEQUENCE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE SEQUENCE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE SEQUENCE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE TABLE |
Table, View, & Sequence DDL | all 4 | Snowflake docs |
CREATE TABLE |
Table, View, & Sequence DDL | all 3 | Snowflake docs |
CREATE TABLE |
Table, View, & Sequence DDL | all 5 | Snowflake docs |
CREATE TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE TABLE |
Table, View, & Sequence DDL | all 6 | Snowflake docs |
CREATE TABLE |
Table, View, & Sequence DDL | all 2 | Snowflake docs |
CREATE TABLE |
Table, View, & Sequence DDL | all 2 | Snowflake docs |
CREATE VIEW |
Table, View, & Sequence DDL | all 2 | Snowflake docs |
CREATE VIEW |
Table, View, & Sequence DDL | all 2 | Snowflake docs |
CREATE VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE \| ALTER TABLE … CONSTRAINT |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE \| ALTER TABLE … CONSTRAINT |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE \| ALTER TABLE … CONSTRAINT |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
CREATE \| ALTER TABLE … CONSTRAINT |
Table, View, & Sequence DDL | all 2 | Snowflake docs |
DESCRIBE EXTERNAL TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
DESCRIBE MATERIALIZED VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
DESCRIBE MATERIALIZED VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
DESCRIBE TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
DESCRIBE TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
DESCRIBE TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
DESCRIBE VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
DESCRIBE VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
DROP EXTERNAL TABLE |
Table, View, & Sequence DDL | all 3 | Snowflake docs |
DROP EXTERNAL TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
DROP TABLE |
Table, View, & Sequence DDL | all 3 | Snowflake docs |
DROP TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
DROP VIEW |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
SHOW COLUMNS |
Table, View, & Sequence DDL | all 2 | Snowflake docs |
SHOW EXTERNAL TABLES |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
SHOW MATERIALIZED VIEWS |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
SHOW MATERIALIZED VIEWS |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
SHOW OBJECTS |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
SHOW TABLES |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
SHOW TABLES |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
SHOW VIEWS |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
UNDROP TABLE |
Table, View, & Sequence DDL | all 1 | Snowflake docs |
BEGIN |
Transactions | all 3 | Snowflake docs |
BEGIN |
Transactions | all 3 | Snowflake docs |
BEGIN |
Transactions | all 3 | Snowflake docs |
BEGIN |
Transactions | all 2 | Snowflake docs |
COMMIT |
Transactions | all 8 | Snowflake docs |
ROLLBACK |
Transactions | all 8 | Snowflake docs |
ALTER API INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
ALTER NOTIFICATION INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
ALTER ROLE |
User & Security DDL | all 1 | Snowflake docs |
ALTER ROLE |
User & Security DDL | all 1 | Snowflake docs |
ALTER SECURITY INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
ALTER STORAGE INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
ALTER USER |
User & Security DDL | all 1 | Snowflake docs |
ALTER USER |
User & Security DDL | all 1 | Snowflake docs |
ALTER USER |
User & Security DDL | all 1 | Snowflake docs |
CREATE API INTEGRATION |
User & Security DDL | all 2 | Snowflake docs |
CREATE NETWORK POLICY |
User & Security DDL | all 2 | Snowflake docs |
CREATE NETWORK POLICY |
User & Security DDL | all 2 | Snowflake docs |
CREATE NOTIFICATION INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE ROLE |
User & Security DDL | all 1 | Snowflake docs |
CREATE SECURITY INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE SECURITY INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE SECURITY INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE SECURITY INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE SECURITY INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE SECURITY INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE SECURITY INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE SECURITY INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE SECURITY INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE SECURITY INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE SECURITY INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE SECURITY INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE SECURITY INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE SECURITY INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE SECURITY INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE SECURITY INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE STORAGE INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE STORAGE INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE STORAGE INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE STORAGE INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE STORAGE INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE STORAGE INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
CREATE USER |
User & Security DDL | all 1 | Snowflake docs |
DESCRIBE INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
DROP INTEGRATION |
User & Security DDL | all 3 | Snowflake docs |
DROP INTEGRATION |
User & Security DDL | all 1 | Snowflake docs |
DROP NETWORK POLICY |
User & Security DDL | all 1 | Snowflake docs |
DROP ROLE |
User & Security DDL | all 1 | Snowflake docs |
DROP USER |
User & Security DDL | all 1 | Snowflake docs |
GRANT <privilege> … TO SHARE |
User & Security DDL | all 6 | Snowflake docs |
GRANT <privilege> … TO SHARE |
User & Security DDL | all 5 | Snowflake docs |
GRANT <privileges> … TO ROLE |
User & Security DDL | all 1 | Snowflake docs |
GRANT <privileges> … TO ROLE |
User & Security DDL | all 1 | Snowflake docs |
GRANT <privileges> … TO ROLE |
User & Security DDL | all 1 | Snowflake docs |
GRANT <privileges> … TO ROLE |
User & Security DDL | all 2 | Snowflake docs |
GRANT <privileges> … TO ROLE |
User & Security DDL | all 1 | Snowflake docs |
GRANT <privileges> … TO ROLE |
User & Security DDL | all 1 | Snowflake docs |
GRANT <privileges> … TO ROLE |
User & Security DDL | all 2 | Snowflake docs |
GRANT OWNERSHIP |
User & Security DDL | all 3 | Snowflake docs |
GRANT OWNERSHIP |
User & Security DDL | all 1 | Snowflake docs |
GRANT OWNERSHIP |
User & Security DDL | all 1 | Snowflake docs |
GRANT ROLE |
User & Security DDL | all 1 | Snowflake docs |
GRANT ROLE |
User & Security DDL | all 1 | Snowflake docs |
REVOKE <privilege> … FROM SHARE |
User & Security DDL | all 6 | Snowflake docs |
REVOKE <privilege> … FROM SHARE |
User & Security DDL | all 1 | Snowflake docs |
REVOKE <privileges> … FROM ROLE |
User & Security DDL | all 1 | Snowflake docs |
REVOKE <privileges> … FROM ROLE |
User & Security DDL | all 1 | Snowflake docs |
REVOKE <privileges> … FROM ROLE |
User & Security DDL | all 1 | Snowflake docs |
REVOKE <privileges> … FROM ROLE |
User & Security DDL | all 2 | Snowflake docs |
REVOKE <privileges> … FROM ROLE |
User & Security DDL | all 2 | Snowflake docs |
REVOKE <privileges> … FROM ROLE |
User & Security DDL | all 1 | Snowflake docs |
REVOKE ROLE |
User & Security DDL | all 1 | Snowflake docs |
REVOKE ROLE |
User & Security DDL | all 1 | Snowflake docs |
SHOW DELEGATED AUTHORIZATIONS |
User & Security DDL | all 1 | Snowflake docs |
SHOW DELEGATED AUTHORIZATIONS |
User & Security DDL | all 1 | Snowflake docs |
SHOW DELEGATED AUTHORIZATIONS |
User & Security DDL | all 1 | Snowflake docs |
SHOW GRANTS |
User & Security DDL | all 1 | Snowflake docs |
SHOW GRANTS |
User & Security DDL | all 1 | Snowflake docs |
SHOW GRANTS |
User & Security DDL | all 1 | Snowflake docs |
SHOW GRANTS |
User & Security DDL | all 1 | Snowflake docs |
SHOW GRANTS |
User & Security DDL | all 1 | Snowflake docs |
SHOW INTEGRATIONS |
User & Security DDL | all 1 | Snowflake docs |
SHOW INTEGRATIONS |
User & Security DDL | all 1 | Snowflake docs |
SHOW INTEGRATIONS |
User & Security DDL | all 1 | Snowflake docs |
SHOW NETWORK POLICIES |
User & Security DDL | all 1 | Snowflake docs |
SHOW ROLES |
User & Security DDL | all 1 | Snowflake docs |
ALTER RESOURCE MONITOR |
Warehouse & Resource Monitor DDL | all 1 | Snowflake docs |
ALTER WAREHOUSE |
Warehouse & Resource Monitor DDL | all 1 | Snowflake docs |
ALTER WAREHOUSE |
Warehouse & Resource Monitor DDL | all 2 | Snowflake docs |
CREATE RESOURCE MONITOR |
Warehouse & Resource Monitor DDL | all 1 | Snowflake docs |
CREATE WAREHOUSE |
Warehouse & Resource Monitor DDL | all 1 | Snowflake docs |
CREATE WAREHOUSE |
Warehouse & Resource Monitor DDL | all 1 | Snowflake docs |
SHOW WAREHOUSES |
Warehouse & Resource Monitor DDL | all 1 | Snowflake docs |
Key Features Supported¶
- Standard SQL operations (SELECT, INSERT, UPDATE, DELETE)
- Snowflake-specific data types and functions
- Window functions and analytical queries
- Stored procedures and user-defined functions
- Data loading and unloading operations
- Time travel and cloning features