Hi @sathya08,I'm not re-authenticating to the SQL server serverless for the authentication, but a one-time authentication to the workspace is required in my case. Without credentials, I'm getting below error. default auth: cannot configure default cr...
Hi @sathya08,Maybe you can try the below one. I can execute the query and get the output without authenticating to the SQL Warehouse cluster. from databricks.sdk import WorkspaceClientfrom databricks.sdk.service import sqlimport timew = WorkspaceCli...
if you ever received this kind of error after installing the correct Python package then try running the below command. dbutils.library.restartPython()
Hi @sathya08 I understood that you want to submit an SQL query from a notebook to a serverless cluster.Maybe you can try the below approach to achieve this. You need to install the below package: %pip install databricks-sql-connectorimport osfrom dat...
It's true. One month back I was also trying to solve a similar hierarchy problem and realized that recursive CTE is not supported in Databricks SQL. Now the only option is to go withPySpark. If you can describe your problem statement more, I will hel...