topic Re: Will Lakehouse Federation between Databricks and Snowflake support Azure Entra ID? in Administration & Architecture

Will Lakehouse Federation between Databricks and Snowflake support Azure Entra ID?

martkev — Wed, 20 Nov 2024 09:00:14 GMT

The Lakehouse Federation between Databricks and Snowflake looks promising, but the lack of support for Azure Entra ID as an identity provider (IdP) is a big limitation for enterprises standardized on it.

Managing separate OAuth flows or using Snowflake as an IdP adds unnecessary complexity and undermines centralized user management through Entra ID. It’s overhead we don’t want and a potential security risk.

Is there any workaround to use Entra ID for these connections? And is there a plan to provide direct support for Entra ID as an IdP?

Would love to hear from others facing this issue!

Re: Will Lakehouse Federation between Databricks and Snowflake support Azure Entra ID?

Alberto_Umana — Thu, 21 Nov 2024 15:38:26 GMT

Hello @martkev,

Currently, Azure Databricks does not support using Azure Entra ID (formerly Azure Active Directory) directly as an identity provider (IdP) for federated queries on Snowflake. The only supported OAuth integration for Snowflake is Snowflake’s native OAuth

There is a feature request to implement this feature, I will vote internally to implement this. At the moment there is not ETA for its implementation, but will keep you posted if I hear on this.

https://databricks.aha.io/ideas/ideas/DB-I-10852