How to Sync Snowflake Users w/ Azure Active Directory

This video might just save you hours of trial and error.

Azure Active Directory (AAD) is one of the most popular ways to manage users.

Snowflake is one of the most popular cloud databases.

We know it’s best practice to keep user information consistent.

But.. this won’t happen between these two platforms by default.

Getting it to work can take you on a wild ride if you don’t know where to start.

So in today’s video I’ll walk you through step by step how to set up “provisioning” users for Snowflake through Azure Active Directory.

** You’ll also watch me mess up 7 times trying to debug an error.

But, hey, this is the life we chose as Data Engineers!

Thank you for watching!

New to Data Engineering? Check out some of my free Starter Guides:
– https://bit.ly/3GWTbuG

▬▬▬▬▬▬ T I M E S T A M P S ⏰ ▬▬▬▬▬▬
00:00 – Intro
00:28 – Create a User in Azure
01:29 – Add Enterprise Application
02:50 – Snowflake Setup
04:46 – Azure Provisioning Setup
06:56 – Provision (Sync) A User
07:46 – Set Custom Field Mappings
11:36 – Trial & Error (aka Debug) x7

▬▬▬▬▬▬ Useful Links 🔗 ▬▬▬▬▬▬
► https://docs.snowflake.com/en/user-guide/scim-azure.html
► https://community.snowflake.com/s/article/HowTo-How-to-Set-up-Snowflake-Custom-Attributes-in-Azure-AD-SCIM-for-Default-Roles-and-Default-Warehouses

▬▬▬▬▬▬ Want to learn more? 📚 ▬▬▬▬▬▬
Data-Build-Tool (dbt) ► https://bit.ly/3HCS0ht
Snowflake ► https://bit.ly/3mTpqk0
GitHub ► https://bit.ly/331QnuJ
Terraform ► https://bit.ly/3EV4wam
Power BI ► https://bit.ly/3JGErQ3

▬▬▬▬▬▬ Connect with me 🔄 ▬▬▬▬▬▬
▬▬▬▬▬▬ Connect with me 🔄 ▬▬▬▬▬▬
Twitter ► https://www.twitter.com/kahandata
Newsletter ► https://www.kahandatasolutions.com/blog
Website ► https://www.kahandatasolutions.com

How to Sync Azure & Snowflake Users | Provisioning
Automate Snowflake Users w/ Azure Active Directory
#kahandatasolutions #dataengineering #snowflake