cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results for 
Search instead for 
Did you mean: 

Assistance Needed: Issues with Databricks SQL Queries and Performance

dikokob
New Contributor III

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

Let's talk about data-powered performance
4 REPLIES 4

Walter_C
Databricks Employee
Databricks Employee

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.

dikokob
New Contributor III

@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.

Let's talk about data-powered performance

Walter_C
Databricks Employee
Databricks Employee

I will check on this with our internal team.

dikokob
New Contributor III

Thanks @Walter_C, looking forward to hearing back from you.

Let's talk about data-powered performance

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group