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