CODEWITHSUNDEEP
databricksazure-databricksazure-data-lake-gen2
Saugat Mukherjee
Saugat Mukherjee

Reputation: 990

Credential pass through for Databricks Sql

We have so far used Databricks for Data Engineering and Data Science purposes but recently have started exploring the new Databricks Sql analytics as we have a lot of SQL Analysts who also want to join the bandwagon (for some use cases).

However, the big stumbling block I have noticed is that a SQL endpoint always needs a Service Principal for Azure Data Lake Gen2 access. There is no option to just use “credential pass through “ without using a SPN.

I have tried looking up the limitations (known issues)page as well as all existing documentation but have not come across anything regarding this.

Can’t we just use a High Concurency cluster with credential pass through for data lake gen 2 (or a single user standard cluster with credential pass through) without using any spn at all (just like we do for data engineering and data science workloads)? Or at least a timeline?

This really is important in regards to fine grained security requirements in organizations for accessing Production data .

Upvotes: 1

Views: 1287

Answers (1)

KarthikBhyresh-MT
KarthikBhyresh-MT

Reputation: 5034

You are correct, this is currently not supported.

Only ways available are as below.

enter image description here

I can see similar requests already shared as ideas here and here. You can post one too or reach support team for an official response.

Upvotes: 1

Related Questions