SSC-EWI-VT0001

Inherited privileges clause is not supported in Snowflake.

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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 [email protected]