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

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.