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
Sample Source Patterns¶
Success
This syntax is fully supported in Snowflake.
Vertica¶
CREATE OR REPLACE VIEW mySchema.myuser(
userlastname
)
AS
SELECT lastname FROM users;
Snowflake¶
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.
Warning
This syntax is not supported in Snowflake.
BigQuery¶
CREATE OR REPLACE VIEW mySchema.myuser(
userlastname
)
INCLUDE SCHEMA PRIVILEGES
AS
SELECT lastname FROM users;
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;
Known Issues¶
There are no known Issues.