Hi Suteja, thanks for your feedback. See my comments below and let me know if you assist further!
1) Check your network connectivity: Make sure that you have a stable internet connection and that you are able to access other websites or services without issues.
Connectivity is confirmed since I can connect to the SQL endpoint via Partner Connect and load the data into any number of tools, while at the same time receive this error in Query Editor immediately afterwards. This is also affecting anyone else using Query Editor from any location in the U.S.
2, 3) Check your DBFS storage: Verify that you have enough DBFS storage to store the query results. You can check your current DBFS storage usage by running the following command in a notebook cell:
I receive the following error in a notebook but connected to the driver web terminal and ran a 'df -h' and it seems DBFS disk space should not be an issue.
I am admin and receive the same message, but our end-users are using Query Editor in the Workspace via their AAD credentials (Azure Databricks). End-users have access to hive_metastore.default and can view table sample data via Data Explorer. Users can also load data via Partner Connect with their user tokens in their tools like Power BI so their warehouse permissions and hive permissions do not seem to be an issue. I'm not aware on any explicit DBFS volume permissions that are required on the managed storage account where root is located.
5) Check your query: Verify that your query is syntactically correct and that it is not returning an excessive amount of data. Large query results may take a long time to upload to the DBFS and can cause the "Unable to upload to DBFS Query" error.
Here's an example of a query that is generating the error. Let me know if there's other suggestions or where I can find logs related to DBFS or the SQL endpoint. Thx!
