hdu
New Contributor III

2 weeks ago

Thank you, Ashwin, for looking into my question.

My table is appended whenever a new file arrives. Each file contains the same number of records (8,676), but with a different extraction date.

Regarding the results of your query above, two additional files have been appended since version 25.

_commit_version _change_type _commit_timestamp date_extraction n
25 insert 2026-07-08T15:01:20.000+00:00 2026-04-09 8676
26 insert 2026-07-08T19:49:47.000+00:00 2026-04-10 8676
27 insert 2026-07-09T12:51:10.000+00:00 2026-04-11 8676

When I run query below, I expect to see two rows, without extraction_date = '2026-04-09', however it returns three rows, including version 25. 

SELECT
  date_extraction,
  count(*) AS n
FROM table_changes('duh_dev_bronze.sibl.cup_rate', 26)
GROUP BY 1
ORDER BY 1;

date_extraction	n
2026-04-09	8676
2026-04-10	8676
2026-04-11	8676

 

0 Kudos