Error: QUERY_RESULT_WRITE_TO_CLOUD_STORE_FAILED when querying system tables via Databricks dashboard

[Sitharth]

Hi Team,

I'm encountering the following error when running queries on system tables through a Databricks dashboard using a Serverless SQL Warehouse:

[QUERY_RESULT_WRITE_TO_CLOUD_STORE_FAILED] An internal error occurred while uploading the result set to the cloud store. SQLSTATE: XX000

Has anyone faced this issue before or can help identify the root cause?
Any guidance on troubleshooting or configuration checks would be appreciated.

Thanks

[Khaja_Zaffer]

Hello sitharth 

The xx000 seems to be a internal bug.

Just to ask, do you have any left joins in the sql table, if yes reduce them. 

[Khaja_Zaffer]

Hello @Sitharth 

Good day

I think the cause would be this: By default, containers are missing from the databricks managed storage account

Resolution: you need to create new workspace 

With this we can close the case.