Required Privileges and Custom Roles

If you create a custom role with the required privileges, define the role that the stage uses in one of the following ways:

Assign the custom role as the default role

In Snowflake, assign the custom role as the default role for the Snowflake user account specified in the stage. A Snowflake user account is associated with a single default role.

Override the default role with the custom role

In the stage, use the Role property to specify the name of the custom role. The custom role overrides the role assigned to the Snowflake user account specified in the stage.

For example, you might define custom roles in Snowflake for specific data sources, and then specify one of the roles when configuring a Snowflake stage.

Use a Snowflake connection

When working with Control Hub, you can configure a Snowflake connection to provide connection details for Snowflake stages.

When a Snowflake stage is configured to use a Snowflake connection, the stage uses the role associated with the connection. You cannot define the role to use in stage properties. For more information, see the Control Hub documentation../../reusable-content/connections/../../controlhub/UserGuide/ConnectionTypes/SnowflakeConn-CustomRoles.html.