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?