MSCEWI2068
Snowflake does not support profiles, referencing role instead
Medium
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.
SELECT PROFILE;
SELECT
CURRENT_ROLE() /*** MSC-ERROR - MSCEWI2068 - SNOWFLAKE DOES NOT SUPPORT PROFILES, REFERENCING ROLE INSTEAD ***/;
- 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.
- For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.
Last modified 8mo ago