<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-M74D8PB" height="0" width="0" style="display:none;visibility:hidden">
Loading
Skip to NavigationSkip to Main Content
Default Role and Default Warehouse Not Propagating to Snowflake
Lifecycle Management
Okta Integration Network
Okta Classic Engine
Okta Identity Engine
Overview

After configuring Security Assertion Markup Language (SAML) and System for Cross-domain Identity Management (SCIM) provisioning for Snowflake, the Default Role and Default Warehouse attributes mapped from Okta do not propagate correctly. This article explains the specific requirement for these values to be accepted by Snowflake.

Applies To
  • Snowflake
  • SCIM Provisioning
  • SAML
Cause

When utilizing Okta System for Cross-domain Identity Management (SCIM) Provisioning to establish the DEFAULT_ROLE or DEFAULT_WAREHOUSE, the values are entered in either lowercase or mixed case (for example, Public or public).

Solution

When configuring the DEFAULT_ROLE or DEFAULT_WAREHOUSE attributes in Okta for Snowflake provisioning, the values must be entered in all uppercase letters. Snowflake does not recognize lowercase or mixed-case values for these specific attributes. Ensuring the values are in uppercase allows the Okta SCIM provisioning to function as intended.

Related References

Recommended content

Documentation
Search users
Documentation
Read user
Documentation
Update user
Loading
Default Role and Default Warehouse Not Propagating to Snowflake