bug: Unable to connect to Databrick with Read only roles

[deepug14]

What happened?

We should be able to connect to databricks with readonly roles and run queries.
Unable to create to databricks from python code with user having read only access as it fails to create volume post connection

Source : https://github.com/ibis-project/ibis/blob/main/ibis/backends/databricks/__init__.py

def _post_connect(self, *, memtable_volume: str) -> None:
sql = f"CREATE VOLUME IF NOT EXISTS {memtable_volume} COMMENT 'Ibis memtable storage volume'"
with self.con.cursor() as cur:
cur.execute(sql)

What version of ibis are you using?

10.6.0
have tried other versions as well

What backend(s) are you using, if any?

Databricks

Relevant log output

\.venv\lib\site-packages\databricks\sql\thrift back 
end.py", line 604, in check command not in error or closed state 
raise ServerOperationError(
databricks.sq1.exc.ServerOperationError: PERMISSION DENIED: User does not have CREATE VOLUME on Schema

Code of Conduct

• I agree to follow this project's Code of Conduct

[LegrandT]

Up, there should be a switch to avoid that