Data difference between SQL warehouse and all-purpose compute
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-05-2025 02:01 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-05-2025 06:38 AM
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

