I configured data freshness for my sources.
This results in following query :
select max(to_timestamp(erdat||erzet,'yyyymmddhh24miss')) as max_loaded_at, convert_timezone('UTC', current_timestamp()) as snapshotted_at from EDW.stage.erp_vbap_1_stg
The output of this query is :
|2020-06-05 09:30:54.000||2020-06-05 07:45:48.860 +0000|
The difference is not calculated in the db through sql but internally by dbt.
What is the used algorithm?
Are time zone corrections applied? Should everything first been transformed to UTC?