SnowConvert AI - Vertica - CREATE VIEW

Description

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

Grammar Syntax

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

Sample Source Patterns

Note

:class: tip 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.

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