Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-11-2023 07:15 AM
@Nativ Issac I would suggest to use a PAT token created on behalf of a service principal and grant SELECT privilege only to the service principal to the targeted catalogs/schemas/tables. Thus you can restrict the access to the data using JDBC. Please refer to below docs on the same topic. Hope this helps.
https://docs.databricks.com/dev-tools/api/latest/token-management.html#operation/get-token
https://docs.databricks.com/data-governance/unity-catalog/manage-privileges/privileges.html
https://docs.databricks.com/archive/spark-sql-2.x-language-manual/grant.html