CREATE VIEW
This grammar is partially supported in Snowflake. Translation pending for these CREATE VIEW elements:
Description
Views are based on the result-set of an
SQL
query.CREATE VIEW
constructs a virtual table that has no physical data therefore other operations likeALTER VIEW
andDROP VIEW
only change metadata. (Spark SQL Language Reference CREATE VIEW)
Grammar Syntax
Sample Source Patterns
COMMENT clause
Input Code:
Output Code:
OR REPLACE
This clause is fully supported in Snowflake
TEMPORARY (non-GLOBAL) VIEW
This clause is fully supported in Snowflake
IF NOT EXISTS
This clause is fully supported in Snowflake
Columns list
This clause is fully supported in Snowflake
Last updated