SnowConvert AI - Vertica - CREATE VIEW¶

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
Copy

Sample Source Patterns¶

Success

This syntax is fully supported in Snowflake.

Vertica¶

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

Snowflake¶

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

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.

Warning

This syntax is not supported in Snowflake.

BigQuery¶

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

Snowflake¶

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;
Copy

Known Issues¶

There are no known Issues.