Data difference between SQL warehouse and all-purpose compute

Daan — Wed, 05 Feb 2025 10:01:47 GMT

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?

Re: Data difference between SQL warehouse and all-purpose compute

Ayushi_Suthar — Wed, 05 Feb 2025 14:38:14 GMT

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

topic Data difference between SQL warehouse and all-purpose compute in Get Started Discussions

Data difference between SQL warehouse and all-purpose compute

Re: Data difference between SQL warehouse and all-purpose compute