Databricks SQL endpoint authentication

NOOR_BASHASHAIK — Fri, 18 Nov 2022 22:23:08 GMT

Hi all

I have a requirement that goes like this:

Users from a particular software that doesn't have out-of-the-box integration with Databricks click on a dashboard, the button click then sends an SQL query to Databricks (user gets authenticated in Databricks) and data returned by the SQL query (executed on a SQL endpoint based cluster) is displayed in the dashboard. Row level security is enforced based on rules defined in a static delta table.

We don't want users to have the ability of generating personal access tokens and authenticating themselves via those tokens.

I think of the integration to be done via a service principal but then the queries need to be executed by the user's email I'd so row level security can be enforced.

Appreciate thoughts on how we can implement this.

topic Databricks SQL endpoint authentication in Data Engineering

Databricks SQL endpoint authentication