Closed yamotech closed 4 months ago
Good catch!
Happy to see this being fixed! I just discovered this issue today when investigating performance issues in dev envs that (attempt to) process limited data via the start_date variable 😄
@adamribaudo-velir is there any estimate of when a release containing this fix would go out?
I can do that tomorrow. You can point your packages.yml to this specific commit in the meantime if you need it sooner.
Description & motivation
In the original code
cast(replace(_table_suffix, 'intraday_', '') as int64)
, larger values than the start_date were being retrieved, resulting in unsuccessful filtering.{{ YYYYMMDD }}{{ property_id }}
{{ YYYYMMDD }}
Checklist
dbt test
andpython -m pytest .
to validate existing tests