can you please share, where did you exactly changed the data type ? I changed the unixtimestamp DateTimeFormat from epoch_s to %Y-%m-%dT%H:%M:%S as an attemp to make Date_trunc work properly on it but gives me the same BigInt error. Thank you
Day grain doesn't work properly on unix timestamp on hour and muintes level