Hello Everyone,
For the past few months, we’ve been extensively exploring the use of Databricks as the core of our data warehousing product. We provide analytics dashboards to other organizations and are particularly interested in the Column-Level Security (CLS) and Row-Level Security (RLS) options, as data needs to be scoped per user, role, or organization.
We need to ensure that our customers (organizations with different identity providers, primarily Entra) can query their data using Single Sign-On (SSO) with Power BI or our custom embedded analytics app. While Entra B2B collaboration seems to support this, it requires an Entra Premium license for Multi-Factor Authentication (MFA) trust options. This is quite costly for our user base of over 20,000, exceeding even the cost of Databricks itself.
On Databricks AWS, it appears possible to use OIDC or SAML directly as SSO providers. However, we haven’t found this option in Azure Databricks. We’re considering using a solution like Auth0 to connect all our customers.
Has anyone implemented a similar setup using Azure Databricks? Any insights or experiences would be greatly appreciated.
Thank you!
