Databricks Community

03-06-2023

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-optionThanks!

06-22-2022

Hey all,My aim is to validate a given SQL string without actually running it.I thought I could use the `EXPLAIN` statement to do so.So I tried using the `databricks-sql-connector` for python to explain a query, and so determine whether it's valid or ...

04-02-2023

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

03-31-2023

Hello @Vartika Nain ,Still struggling with this

03-09-2023

@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, et...

07-31-2022

Hi' I'm still searching for a more suited solution to my use case.Installing pyspark seems too much (build time and extra packages I don't really need).Is there a way to make this a feature request?

07-03-2022

Hi @Hubert Dudek, thanks for replying!The optimal solution I was looking for was in the databricks-sql-connector.Installing large package such pyspark for this specific feature seems too much for my project purposes.Thank you very much!

Databricks Community

User Stats

User Activity

is there a read only option in jdbc driver?

Making py connector to raise an error for wrong SQL when asking to plan a query

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

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

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

Re: Making py connector to raise an error for wrong SQL when asking to plan a query

Re: Making py connector to raise an error for wrong SQL when asking to plan a query