How to Sync Snowflake Users w/ Azure Active Directory

[@KahanDataSolutions]

Deliver more impact w/ modern data tools, without getting overwhelmed See how in The Starter Guide for Modern Data → www.kahandatasolutions.com/guide

[@yasielmesa1603]

@KahanDataSolutions With the custom field mappings (8:26), can you map a whole group to gain access to only to a specific database, with a specific warehouse, with specific rights like Read, or read write?

[@dudhay]

precise instructions, thanks a lot!

[@KahanDataSolutions]

Glad it helped!

[@rkravinderkumar05]

I followed the same steps and in snowflake, describe user shows default_role correctly. But when I m doing SSO, it doesnt see that role at all. And there are no grants. It just uses PUBLIC role. What am i missing?

[@OffBrandToby]

The silly thing that tripped me up about the link around 08:11 is that you have to go to that link and then navigate to provisioning from the same tab. If you are jumping between tabs or going back another day, you aren't going to get the options you want.

[@naveenkumar-tb1de]

Thanks for this,this has been very precise.

[@KahanDataSolutions]

Glad it was helpful!

[@beemac79]

Do you need to have the roles setup first on snowflake? If for example, you have a Database called DB1 and you want to assign a role DB1_RW to it, can you do that from the AD side?

[@terryjacksonterrjacktechni4458]

Am I missing something or is there no links to the online articles he is using?

[@akhileshg7100]

That is awesome content. Just curious, is that token never expire type? Or expires over a period?

[@andresss85]

is it possible to sync current snowflake users to Azure AD ? I already have more than 100 users in snowflake and want them into AD

[@SuperICHmagdich]

Very nice!

[@KahanDataSolutions]

Thanks!