SSC-EWI-TD0068

Snowflake does not support profiles, referencing role instead

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.

Severity

Medium

Description

Teradata profiles allow defining of multiple common parameters related to storage space and password constraints management.

However, Snowflake works with cloud architecture and automatically manages and optimizes storage, meaning no storage customization is done on the user side. Also, Snowflake currently has a password policy defined that applies to all user passwords and is not modifiable.

This error is generated when a reference to a Teradata profile is found to indicate that it was changed to a reference to the user's role, which is the nearest approximation to a profile in Snowflake, although there might be differences in the query results unless the profile and role names of a user are the same.

Example code

Input Code:

IN -> Teradata_01.sql
SELECT PROFILE;

Output Code:

OUT -> Teradata_01.sql
SELECT
CURRENT_ROLE() !!!RESOLVE EWI!!! /*** SSC-EWI-TD0068 - SNOWFLAKE DOES NOT SUPPORT PROFILES, REFERENCING ROLE INSTEAD ***/!!!;

Recommendations

  • Avoid referencing user profiles, they are not supported, and query results will be different unless the user has the same name for both its profile and role.

  • If you need more support, you can email us at [email protected]

Last updated