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.​

​