Cant create new table in Datalake using Python pyodbc

1

Hi Team,

I am new to this dremio platform and currently stucked in an issue.
I am able to execute a select query on Datalake tables but i am not able to create a new table in that datalake.

Note:

  1. I have checked the privileges and my user has the access to create table.
  2. I am able to create a new table from Dremio UI query tab with the same query.
  3. Currently using pyodbc python package.

It would be great if someone can help in resolving this issue.

Thanks in advance.

2

@sbind29 Welcome to Dremio Community!

Could you help paste the SQL that you are trying in the UI and also the code you are using from python?