CREATE VIEW

Applies to

• Hive SQL

• Spark SQL

• Databricks SQL

This grammar is partially supported in Snowflake. Translation pending for these CREATE VIEW elements:

[ [ GLOBAL ] TEMPORARY ]
[ TBLPROPERTIES ( property_name = property_value [ , ... ] ) ]

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 like ALTER VIEW and DROP VIEW only change metadata. (Spark SQL Language Reference CREATE VIEW)

Grammar Syntax

CREATE [ OR REPLACE ] [ [ GLOBAL ] TEMPORARY ] VIEW [ IF NOT EXISTS ] view_identifier
    create_view_clauses AS query

create_view_clauses :=
[ ( column_name [ COMMENT column_comment ], ... ) ]
[ COMMENT view_comment ]
[ TBLPROPERTIES ( property_name = property_value [ , ... ] ) ]

Sample Source Patterns

COMMENT clause

Input Code:

Databricks

IN -> Databricks_01.sql

CREATE VIEW my_view
COMMENT 'This view selects specific columns from person'
AS
SELECT 
   name,
   age,
   address
FROM
   person;

Output Code:

Snowflake

OUT -> Databricks_01.sql

CREATE VIEW my_view
COMMENT = '{ "Description": "This view selects specific columns from person", "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "databricks",  "convertedOn": "05/29/2025",  "domain": "no-domain-provided" }}'
AS
SELECT
   name,
   age,
   address
FROM
   person;

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