Daily Ingestion

IATF Database Ingestion Log

Refreshed 2026-11-18 10:19 AM EST

Each time TJ Systems drops a daily snapshot into the S3 bucket, the iatf-ingest Lambda reloads every table from it in one transaction. Every run is logged below (most recent first, last 50).

Runs Shown

50

Latest Run

2026-11-17 06:18 PM EST

Last Status
Success
Rows Changed (last run)

11,871,897

Ingestion runs

rows shown as +inserted ~updated -deleted
DataAnalytics_202611180017.zip

2026-11-17 06:18 PM EST · 152.2 MB · 369.8s

Success

11,871,897 rows · 34 tables

DataAnalytics_202611170018.zip

2026-11-16 06:18 PM EST · 152.1 MB · 367.9s

Success

11,866,771 rows · 34 tables

DataAnalytics_202611160018.zip

2026-11-15 06:19 PM EST · 152.1 MB · 364.2s

Success

11,860,101 rows · 34 tables

DataAnalytics_202611150018.zip

2026-11-14 06:19 PM EST · 152.1 MB · 369.9s

Success

11,859,501 rows · 34 tables

DataAnalytics_202611140018.zip

2026-11-13 06:19 PM EST · 152.0 MB · 368.9s

Success

11,858,875 rows · 34 tables

DataAnalytics_202611130017.zip

2026-11-12 06:18 PM EST · 152.0 MB · 372.6s

Success

11,854,328 rows · 34 tables

DataAnalytics_202611120017.zip

2026-11-11 06:18 PM EST · 151.9 MB · 368.2s

Success

11,849,256 rows · 34 tables

DataAnalytics_202611110017.zip

2026-11-10 06:18 PM EST · 151.9 MB · 367.6s

Success

11,844,185 rows · 34 tables

DataAnalytics_202611100018.zip

2026-11-09 06:19 PM EST · 151.8 MB · 371.0s

Success

11,840,090 rows · 34 tables

DataAnalytics_202611090017.zip

2026-11-08 06:18 PM EST · 151.8 MB · 364.3s

Success

11,833,876 rows · 34 tables

DataAnalytics_202611080018.zip

2026-11-07 06:18 PM EST · 151.8 MB · 366.3s

Success

11,833,347 rows · 34 tables

DataAnalytics_202611070018.zip

2026-11-06 06:18 PM EST · 151.8 MB · 367.7s

Success

11,833,007 rows · 34 tables

DataAnalytics_202611060018.zip

2026-11-05 06:19 PM EST · 151.7 MB · 371.3s

Success

11,827,926 rows · 34 tables

DataAnalytics_202611050018.zip

2026-11-04 06:19 PM EST · 151.6 MB · 376.5s

Success

11,823,262 rows · 34 tables

DataAnalytics_202611040020.zip

2026-11-03 06:21 PM EST · 151.6 MB · 357.5s

Success

11,817,766 rows · 34 tables

DataAnalytics_202611030017.zip

2026-11-02 06:18 PM EST · 151.5 MB · 372.7s

Success

11,812,412 rows · 34 tables

DataAnalytics_202611020017.zip

2026-11-01 06:18 PM EST · 151.5 MB · 362.4s

Success

11,806,127 rows · 34 tables

DataAnalytics_202611010017.zip

2026-10-31 07:18 PM EDT · 151.4 MB · 365.6s

Success

11,805,541 rows · 34 tables

DataAnalytics_202610310017.zip

2026-10-30 07:18 PM EDT · 151.4 MB · 374.3s

Success

11,805,003 rows · 34 tables

DataAnalytics_202610300018.zip

2026-10-29 07:19 PM EDT · 151.4 MB · 370.3s

Success

11,799,746 rows · 34 tables

DataAnalytics_202610290017.zip

2026-10-28 07:18 PM EDT · 151.3 MB · 359.4s

Success

11,794,506 rows · 34 tables

DataAnalytics_202610280017.zip

2026-10-28 08:20 AM EDT · 151.3 MB · 379.5s

Success

11,788,154 rows · 34 tables

DataAnalytics_202610280017.zip

2026-10-27 07:18 PM EDT · 151.3 MB · 0.2s

1 foreign key(s) from outside the iatf spec point into it, so the TRUNCATE would fail: coaching_oem_approvals_oem_id_fkey (apps.coaching_oem_approvals -> iatf.oems). Drop them -- an app table must not FK into a schema that is wiped and reloaded nightly (the load runs session_replication_role=replica, so the constraint is skipped during the reload anyway). Never answer this with CASCADE: that would silently empty the referencing tables every night.

Error

0 rows · 0 tables

DataAnalytics_202610270018.zip

2026-10-26 07:18 PM EDT · 151.2 MB · 358.8s

Success

11,783,394 rows · 34 tables

DataAnalytics_202610260017.zip

2026-10-25 07:18 PM EDT · 151.2 MB · 361.4s

Success

11,777,801 rows · 34 tables

DataAnalytics_202610250018.zip

2026-10-24 06:19 PM EDT · 151.2 MB · 366.7s

Success

11,777,547 rows · 34 tables

DataAnalytics_202610240018.zip

2026-10-23 06:18 PM EDT · 151.1 MB · 368.1s

Success

11,777,166 rows · 34 tables

DataAnalytics_202610230018.zip

2026-10-22 06:19 PM EDT · 151.1 MB · 373.1s

Success

11,772,539 rows · 34 tables

DataAnalytics_202610220018.zip

2026-10-21 06:18 PM EDT · 151.0 MB · 373.8s

Success

11,767,563 rows · 34 tables

DataAnalytics_202610210017.zip

2026-10-20 06:18 PM EDT · 151.0 MB · 371.1s

Success

11,762,924 rows · 34 tables

DataAnalytics_202610200018.zip

2026-10-19 06:19 PM EDT · 150.9 MB · 367.4s

Success

11,758,761 rows · 34 tables

DataAnalytics_202610190018.zip

2026-10-18 06:18 PM EDT · 150.9 MB · 353.4s

Success

11,753,414 rows · 34 tables

DataAnalytics_202610180017.zip

2026-10-17 06:18 PM EDT · 150.9 MB · 351.3s

Success

11,753,119 rows · 34 tables

DataAnalytics_202610170018.zip

2026-10-16 06:19 PM EDT · 150.9 MB · 367.9s

Success

11,752,797 rows · 34 tables

DataAnalytics_202610160018.zip

2026-10-15 06:18 PM EDT · 150.8 MB · 368.4s

Success

11,748,196 rows · 34 tables

DataAnalytics_202610150019.zip

2026-10-14 06:20 PM EDT · 150.8 MB · 362.5s

Success

11,744,312 rows · 34 tables

DataAnalytics_202610140018.zip

2026-10-13 06:19 PM EDT · 150.7 MB · 367.5s

Success

11,739,716 rows · 34 tables

DataAnalytics_202610130018.zip

2026-10-12 06:18 PM EDT · 150.7 MB · 370.6s

Success

11,735,119 rows · 34 tables

DataAnalytics_202610120017.zip

2026-10-11 06:18 PM EDT · 150.6 MB · 358.8s

Success

11,729,477 rows · 34 tables

DataAnalytics_202610110017.zip

2026-10-10 06:18 PM EDT · 150.6 MB · 361.1s

Success

11,729,149 rows · 34 tables

DataAnalytics_202610100018.zip

2026-10-09 06:18 PM EDT · 150.6 MB · 365.8s

Success

11,726,883 rows · 34 tables

DataAnalytics_202610090017.zip

2026-10-08 06:18 PM EDT · 150.5 MB · 364.6s

Success

11,721,844 rows · 34 tables

DataAnalytics_202610080018.zip

2026-10-07 06:18 PM EDT · 150.5 MB · 369.8s

Success

11,716,065 rows · 34 tables

DataAnalytics_202610070018.zip

2026-10-06 06:18 PM EDT · 150.4 MB · 404.9s

Success

11,713,075 rows · 34 tables

DataAnalytics_202610060018.zip

2026-10-05 06:18 PM EDT · 150.4 MB · 373.6s

Success

11,709,590 rows · 34 tables

DataAnalytics_202610050018.zip

2026-10-04 06:18 PM EDT · 150.4 MB · 400.4s

Success

11,706,066 rows · 34 tables

DataAnalytics_202610040017.zip

2026-10-03 06:18 PM EDT · 150.4 MB · 396.6s

Success

11,705,247 rows · 34 tables

DataAnalytics_202610030017.zip

2026-10-02 06:18 PM EDT · 150.4 MB · 399.1s

Success

11,704,404 rows · 34 tables

DataAnalytics_202610020018.zip

2026-10-01 06:19 PM EDT · 150.3 MB · 400.3s

Success

11,702,061 rows · 34 tables

DataAnalytics_202610010017.zip

2026-09-30 06:18 PM EDT · 150.3 MB · 368.2s

Success

11,699,317 rows · 34 tables