CREATE VIEW

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Description

Creates a new view. (Vertica SQL Language Reference Create view statement)

Grammar Syntax

CREATE [ OR REPLACE ] VIEW [[database.]schema.]view [ (column[,...]) ]
  [ {INCLUDE|EXCLUDE} [SCHEMA] PRIVILEGES ] AS query

Sample Source Patterns

This syntax is fully supported in Snowflake.

Input Code:

Vertica

IN -> Vertica_01.sql

CREATE OR REPLACE VIEW mySchema.myuser(
userlastname
)
AS 
SELECT lastname FROM users;

Output Code:

Snowflake

OUT -> Vertica_01.sql

CREATE OR REPLACE VIEW mySchema.myuser
(
userlastname
)
AS
SELECT lastname FROM
    users;

Inherited Schema Privileges Clause

INCLUDE SCHEMA PRIVILEGES is a Vertica-specific feature that governs how privileges are inherited, in this case, potentially from the schema level. Snowflake does not have a direct equivalent for this clause within its CREATE VIEW syntax. Privileges in Snowflake are managed explicitly through GRANT statements.

This syntax is not supported in Snowflake.

Input Code:

BigQuery

IN -> Vertica_01.sql

CREATE OR REPLACE VIEW mySchema.myuser(
userlastname
)
INCLUDE SCHEMA PRIVILEGES
AS 
SELECT lastname FROM users;

Output Code:

Snowflake

OUT -> Vertica_01.sql

CREATE OR REPLACE VIEW mySchema.myuser
(
userlastname
)
!!!RESOLVE EWI!!! /*** SSC-EWI-VT0001 - INHERITED PRIVILEGES CLAUSE IS NOT SUPPORTED IN SNOWFLAKE ***/!!!
INCLUDE SCHEMA PRIVILEGES
AS
SELECT lastname FROM
    users;

Known Issues

There are no known Issues.

Related EWIs

1. SSC-EWI-VT0001: Inherited privileges clause is not supported in Snowflake.