Snowflake JumpCloud Integration
Detailed Blog Article https://datanerdshetty.wordpress.com/2021/06/01/jumpcloud-integration-with-snowflake/
Current JumpCloud integration automatically creates/updates user information Snowflake and allows you to login using SSO. But compared to identity providers like Okta and Azure Active Directory JumpCloud doesn't automatically assign roles to users so that they can perform authorised actions on Snowflake. This means administrator has to manually grant access to specific ROLE on Snowflake side every time they make GROUP level changes on JumpCloud side.
Below is a workaround to address this above limitation by using JumpCloud APIs and Snowflake External Functions. Before you proceed with below make sure you have completed SCIM integration provided by JumpCloud.
