Feature Coverage
Resource Types and Operations
Section titled “Resource Types and Operations”This page provides a list of Snowflake query features (resource types and operations) that are supported in the LocalStack emulator. The content will be updated as additional query features and functions are implemented.
Applications
Section titled “Applications”ALTER | CREATE | DESCRIBE | DROP | SHOW | |
---|---|---|---|---|---|
APPLICATION | ✅ | ✅ | ✅ | ✅ | ✅ |
Application Packages
Section titled “Application Packages”ALTER | CREATE | DROP | SHOW | |
---|---|---|---|---|
APPLICATION PACKAGE | ✅ | ✅ | ✅ | ✅ |
Catalog Integration
Section titled “Catalog Integration”ALTER | CREATE | DESCRIBE | DROP | SHOW | |
---|---|---|---|---|---|
CATALOG INTEGRATION | ❓ | ✅ | ❓ | ✅ | ✅ |
Databases
Section titled “Databases”ALTER | CREATE | DESCRIBE | DROP | SHOW | UNDROP | USE | |
---|---|---|---|---|---|---|---|
DATABASE | ✅ | ✅ | ✅ | ✅ | ✅ | ❓ | ✅ |
Data and File Operations
Section titled “Data and File Operations”COPY INTO | GET | LIST | PUT | REMOVE | |
---|---|---|---|---|---|
FILE OPERATIONS | ✅ | ✅ | ✅ | ✅ | ✅ |
Dynamic Tables
Section titled “Dynamic Tables”ALTER | CREATE | DESCRIBE | DROP | SHOW | UNDROP | |
---|---|---|---|---|---|---|
DYNAMIC TABLE | ❓ | ✅ | ✅ | ✅ | ✅ | ❓ |
External Tables
Section titled “External Tables”ALTER | CREATE | DESCRIBE | DROP | SHOW | |
---|---|---|---|---|---|
EXTERNAL TABLE | ❓ | ❓ | ❓ | ❓ | ❓ |
External Volumes
Section titled “External Volumes”ALTER | CREATE | DESCRIBE | DROP | SHOW | UNDROP | |
---|---|---|---|---|---|---|
EXTERNAL VOLUME | ✅ | ✅ | ✅ | ✅ | ✅ | ❓ |
File Formats
Section titled “File Formats”ALTER | CREATE | DESCRIBE | DROP | SHOW | |
---|---|---|---|---|---|
FILE FORMAT | ✅ | ✅ | ✅ | ✅ | ✅ |
Functions
Section titled “Functions”ALTER | CREATE | DESCRIBE | DROP | SHOW | |
---|---|---|---|---|---|
FUNCTION | ✅ | ✅ | ✅ | ✅ | ✅ |
Hybrid Tables
Section titled “Hybrid Tables”CREATE | SHOW | |
---|---|---|
HYBRID TABLE | ✅ | ✅ |
Iceberg Tables
Section titled “Iceberg Tables”ALTER | CREATE | DESCRIBE | DROP | SHOW | UNDROP | |
---|---|---|---|---|---|---|
ICEBERG TABLE | ❓ | ✅ | ❓ | ✅ | ❓ | ❓ |
Indexes
Section titled “Indexes”CREATE | DROP | SHOW | |
---|---|---|---|
INDEX | ✅ | ✅ | ✅ |
Materialized Views
Section titled “Materialized Views”ALTER | CREATE | DESCRIBE | DROP | SHOW | TRUNCATE | |
---|---|---|---|---|---|---|
MATERIALIZED VIEW | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
ALTER | CREATE | DESCRIBE | DROP | SHOW | |
---|---|---|---|---|---|
PIPE | ✅ | ✅ | ✅ | ✅ | ✅ |
Procedures
Section titled “Procedures”ALTER | CALL | CALL WITH | CREATE | DESCRIBE | DROP | SHOW | |
---|---|---|---|---|---|---|---|
PROCEDURE | ❓ | ✅ | ❓ | ✅ | ✅ | ✅ | ✅ |
ALTER | CREATE | DROP | GRANT | REVOKE | SHOW | USE | |
---|---|---|---|---|---|---|---|
ROLE | ❓ | ✅ | ✅ | ❓ | ❓ | ✅ | ✅ |
Row Access Policies
Section titled “Row Access Policies”ALTER | CREATE | DESCRIBE | DROP | SHOW | |
---|---|---|---|---|---|
ROW ACCESS POLICY | ✅ | ✅ | ✅ | ✅ | ✅ |
Schemas
Section titled “Schemas”ALTER | CREATE | DESCRIBE | DROP | SHOW | UNDROP | USE | |
---|---|---|---|---|---|---|---|
SCHEMA | ✅ | ✅ | ✅ | ✅ | ✅ | ❓ | ✅ |
Sequences
Section titled “Sequences”ALTER | CREATE | DESCRIBE | DROP | SHOW | |
---|---|---|---|---|---|
SEQUENCE | ✅ | ✅ | ✅ | ✅ | ✅ |
Shares
Section titled “Shares”ALTER | CREATE | DESCRIBE | DROP | SHOW | |
---|---|---|---|---|---|
SHARE | ❓ | ✅ | ❓ | ✅ | ❓ |
Stages
Section titled “Stages”ALTER | CREATE | DESCRIBE | DROP | SHOW | |
---|---|---|---|---|---|
STAGE | ✅ | ✅ | ✅ | ✅ | ✅ |
Storage Integrations
Section titled “Storage Integrations”ALTER | CREATE | DESCRIBE | DROP | SHOW | |
---|---|---|---|---|---|
STORAGE INTEGRATION | ❓ | ✅ | ✅ | ✅ | ✅ |
Streams
Section titled “Streams”ALTER | CREATE | DESCRIBE | DROP | SHOW | |
---|---|---|---|---|---|
STREAM | ✅ | ✅ | ✅ | ✅ | ✅ |
Streamlits
Section titled “Streamlits”ALTER | CREATE | DESCRIBE | DROP | SHOW | |
---|---|---|---|---|---|
STREAMLIT | ✅ | ✅ | ✅ | ✅ | ✅ |
Tables
Section titled “Tables”ALTER | CREATE | DESCRIBE | DROP | SHOW | TRUNCATE | UNDROP | |
---|---|---|---|---|---|---|---|
TABLE | ✅ | ✅ | ✅ | ✅ | ✅ | ❓ | ❓ |
ALTER | CREATE | DROP | SHOW | UNDROP | |
---|---|---|---|---|---|
TAG | ✅ | ✅ | ✅ | ✅ | ❓ |
ALTER | CREATE | DESCRIBE | DROP | EXECUTE | SHOW | |
---|---|---|---|---|---|---|
TASK | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
ALTER | CREATE | DESCRIBE | DROP | SHOW | |
---|---|---|---|---|---|
USER | ✅ | ✅ | ❓ | ✅ | ✅ |
ALTER | CREATE | DESCRIBE | DROP | SHOW | |
---|---|---|---|---|---|
VIEW | ✅ | ✅ | ✅ | ✅ | ✅ |
Warehouses
Section titled “Warehouses”ALTER | CREATE | DESCRIBE | DROP | SHOW | USE | |
---|---|---|---|---|---|---|
WAREHOUSE | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |