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?

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