MSCEWI2068

Snowflake does not support profiles, referencing role instead

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

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:

SELECT PROFILE;

Output Code:

SELECT
  CURRENT_ROLE() /*** MSC-ERROR - MSCEWI2068 - 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]