SSC-EWI-VT0001

Inherited privileges clause is not supported in Snowflake.

Description

Vertica's INCLUDE SCHEMA PRIVILEGES allows views to inherit schema-level privileges, unlike Snowflake where view access is managed by explicit GRANT statements. Migrating these Vertica views to Snowflake requires manually translating these inherited permissions into specific GRANTs .

Code Example

Input Code:

Vertica

IN -> Vertica_01.sql

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

Output Code:

Snowflake

OUT -> Vertica_01.sql

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

Recommendations

• For Snowflake, the recommendation is to translate these inherited Vertica permissions by using GRANT statements to assign the necessary privileges on the view directly to specific roles.

• If you need more support, you can email us at [e-mail]