cancel
Showing results for 
Search instead for 
Did you mean: 
Community Platform Discussions
Connect with fellow community members to discuss general topics related to the Databricks platform, industry trends, and best practices. Share experiences, ask questions, and foster collaboration within the community.
cancel
Showing results for 
Search instead for 
Did you mean: 

Data difference between SQL warehouse and all-purpose compute

Daan
New Contributor III

Hey everyone,

Executing the following query on my sql warehouse does not return any data:
select * from acc_bolt.eod.configurationhistory where netarea = '541454827900000139';
However running the same query using an all-purpose compute does return the expected data:
%sql
select * from acc_bolt.eod.configurationhistory where netarea = '541454827900000139';

How is that possible?
acc_bolt.eod.configurationhistory is an external table. Is it possible that they are working on different versions of the data?

1 REPLY 1

Ayushi_Suthar
Databricks Employee
Databricks Employee

Hi @Daan , Greetings!

Can you please confirm which SQL warehouse you are using here? If you are using a serverless, then can you try to run the query with PRO/Classic warehouse? 

Kind Regards,

Ayushi

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