Hey Guys,

Is there a way to open pyodbc read only connection with simba spark driver?

At the moment, I'm able to execute queries such as select , delete, insert into - basically every sql statement using pyodbc.

I tried to open pyodbc connection but only with read permissions which means the user won't be able to delete/ create/ change any table - just read data from it. but didn't succeed.

I tried open connections in this way:

con  = pyodbc.connect(connection_string, autocommit=True, readonly=True)

Is there a built in way already? Or I must check the query that i have been asked to execute?

Hope you can help me,

Thanks!