Assistance Needed: Issues with Databricks SQL Queries and Performance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Monday - last edited Monday
Hi everyone,
I hope you're all doing well.
I'm experiencing some challenges with Databricks SQL, and I wanted to reach out to see if others have encountered similar issues or have suggestions for troubleshooting. Below is a summary of the problems I'm facing:
Issues Observed
1. Error Messages and Query Loading:
- Error tabs frequently appear while working on existing queries (see attached screenshots).
- Queries fail to load with the message: "Unable to load query. Please check you have permissions and that the query exists." Reloading does not resolve the issue.
2. Editor Switching:
- The platform randomly switches between the classic SQL editor and the new one, especially when working with a mix of saved queries from the classic editor and newly created ones.
3. Performance Problems:
- Tabs sometimes close unexpectedly or fail to display correctly.
- Query execution times are inconsistent, with some queries taking significantly longer than usual to run.
Steps Taken
I've already tried clearing my browser cache and cookies (using Chrome), but the issues persist.
Request for Assistance
I've attached screenshots to provide more context on the behaviour. Has anyone experienced similar issues, or is this a known problem? Any advice or guidance on next steps would be greatly appreciated.
Thank you in advance for your support!
Best regards,
Boitumelo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Tuesday
After hitting on Reload the query becomes available but you see that the SQL editor changes to classic or to the new editor as well.
I have noticed some of this behavior when the query is not supported on any of either views so the system will try to jump in between each other to make it work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
@Walter_C, thanks for the response. Do you perhaps know if there is a potential remedy for this behaviour?
I also wonder if the Databricks team is working on a fix.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
I will check on this with our internal team.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
Thanks @Walter_C, looking forward to hearing back from you.