topic Re: is there a read only option in jdbc driver? in Data Engineering

is there a read only option in jdbc driver?

624398 — Mon, 06 Mar 2023 15:17:17 GMT

Is there a "read only" option when using databricks sql using jdbc driver?

I'm looking for an equivalent to this:

https://docs.aws.amazon.com/redshift/latest/mgmt/jdbc20-configuration-options.html#jdbc20-readonly-option

Thanks!

Re: is there a read only option in jdbc driver?

624398 — Thu, 09 Mar 2023 08:34:27 GMT

@Debayan Mukherjee Thanks for your reply - but I don't think this help my case:

I want to let my app's users to be able to query over my databricks sql server, with prevention of editing data.

Statements like drop, insert, delete, update, truncate, etc... should not be allowed in that context.

Perhaps I did not fully understand your suggestion...

Thanks!

Re: is there a read only option in jdbc driver?

Anonymous — Sat, 11 Mar 2023 15:15:11 GMT

@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

Re: is there a read only option in jdbc driver?

Vartika — Fri, 31 Mar 2023 09:57:14 GMT

Hi @Nativ Issac

Hope everything is going great.

Just wanted to check in if you were able to resolve your issue. If yes, would you be happy to mark an answer as best so that other members can find the solution more quickly? If not, please tell us so we can help you.

Cheers!

Re: is there a read only option in jdbc driver?

624398 — Fri, 31 Mar 2023 10:27:12 GMT

Hello @Vartika Nain ,

Still struggling with this

Re: is there a read only option in jdbc driver?

Anonymous — Fri, 31 Mar 2023 10:38:35 GMT

@Nativ Issac

Have you tried these steps?

Create service principal
Create a PAT token on behalf of the service of the service principal.
Grant only READ privileges to the service principal on all catalogs.
Use the service principal token to access the tables in JDBC

Re: is there a read only option in jdbc driver?

624398 — Sun, 02 Apr 2023 07:12:20 GMT

Hello @John Lourdu

Thanks for your reply!

Unfortunately, for my project purposes, I can't do your suggested solution:

The project I'm working on is getting credentials of a customer databricks sql server and can not create service accounts etc...

Getting the customer do your solution is not the best option for me: it's a large company so every interaction is a hassle in terms of bureaucracy and politics..

Therefore I'm looking for a software solution.

Hope we can figure this out..

Thanks!

Re: is there a read only option in jdbc driver?

Debayan — Thu, 09 Mar 2023 06:50:30 GMT

Hi, You can refer to https://docs.databricks.com/external-data/jdbc.html#read-data-with-jdbc

Please let us know if this helps.

Also please tag @Debayan with your next response which will notify me, Thank you!