CREATE TABLE | Supported | Column-definition, AS SELECT, and CLONE forms. OR REPLACE, IF NOT EXISTS, TRANSIENT, and TEMPORARY are supported, as are column constraints, DEFAULT, IDENTITY, AUTOINCREMENT, and COMMENT. CLUSTER BY becomes the table’s primary index; a computed clustering key is rejected. LIKE is not supported. |
CREATE VIEW | Supported | OR REPLACE, IF NOT EXISTS, and SECURE. Column-list views are not supported. |
CREATE SCHEMA | Supported | Including TRANSIENT. |
DROP TABLE, DROP VIEW, DROP SCHEMA | Supported | |
ALTER TABLE | With limitations | ADD COLUMN, DROP COLUMN, RENAME COLUMN, RENAME TO, and SET/UNSET COMMENT. Not supported: ALTER COLUMN ... SET DATA TYPE, DROP NOT NULL, CLUSTER BY, ADD/DROP CONSTRAINT, SWAP WITH, SET/UNSET TAG, and the retention settings. |
ALTER VIEW, ALTER SCHEMA | With limitations | RENAME TO and SET COMMENT. |
CREATE SCHEMA ... CLONE | Not supported | The objects in the source schema are not copied. |
CREATE DATABASE, DROP DATABASE, UNDROP | Not supported | |
USE DATABASE, USE SCHEMA, USE WAREHOUSE, USE ROLE | Not supported | |
CREATE MATERIALIZED VIEW | Not supported | |
CREATE HYBRID TABLE, CREATE ICEBERG TABLE, CREATE EVENT TABLE, CREATE EXTERNAL TABLE, CREATE DYNAMIC TABLE | Not supported | |
CREATE FUNCTION, CREATE PROCEDURE, CALL, EXECUTE IMMEDIATE | Not supported | |
CREATE STAGE, CREATE FILE FORMAT, CREATE PIPE, PUT, GET, LIST, REMOVE | Not supported | |
CREATE STREAM, CREATE TASK, CREATE ALERT, CREATE SEQUENCE | Not supported | |
SHOW, DESCRIBE, COMMENT ON | Not supported | information_schema queries and EXPLAIN work, but their columns differ from Snowflake’s. |
