Schema Info
Schema Name: sfdl_prod_redshift.analytics_dwh_hist_unit
- created: 2018-04-02 10:59:11
- disabled: False
- format: raw
- id: 333
- is_partitioned: True
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_redshift", "table": "analytics_dwh_hist_unit" } - type: redshift
Schema Versions: 3
-
Version 956788
- created: 2024-07-25 18:13:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_hist_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_hist_unit`\n(\n `audit_id` bigint , `day_key` int , `day` date , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `is_physical_unit` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_hist_unit" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit
- id: 956788
- processed: 1
- raw_data:
{ "_origin": "20", "active": "12", "approve": "14", "audit_id": "0", "climate_controlled": "9", "day": "2", "day_key": "1", "drive_up": "11", "facility_key": "4", "grouping_hash": "16", "is_physical_unit": "15", "length": "18", "publish": "13", "quantity": "8", "regular_price": "6", "reservation_window": "17", "sparefoot_price": "7", "unit_key": "3", "unit_type_key": "5", "vehicle": "10", "width": "19" } - schema_attributes:
{ "_origin": "string", "active": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "day": "date", "day_key": "int", "drive_up": "int", "facility_key": "int", "grouping_hash": "varchar(32)", "is_physical_unit": "int", "length": "decimal", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "vehicle": "int", "width": "decimal" } - schema_name_id: 333
- schema_scan_id: 123776291
- updated: 2024-07-25 18:14:13
-
Version 955206
- created: 2024-07-24 06:03:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_hist_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_hist_unit`\n(\n `audit_id` bigint , `day_key` int , `day` date , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `is_physical_unit` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-prod/separated_dt/dwh_hist_unit/2024-07-24/1721807139'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_hist_unit" ] - hive_path: s3://sfdl-redshift-analytics-prod/separated_dt/dwh_hist_unit/2024-07-24/1721807139
- id: 955206
- processed: 1
- raw_data:
{ "_origin": "20", "active": "12", "approve": "14", "audit_id": "0", "climate_controlled": "9", "day": "2", "day_key": "1", "drive_up": "11", "facility_key": "4", "grouping_hash": "16", "is_physical_unit": "15", "length": "18", "publish": "13", "quantity": "8", "regular_price": "6", "reservation_window": "17", "sparefoot_price": "7", "unit_key": "3", "unit_type_key": "5", "vehicle": "10", "width": "19" } - schema_attributes:
{ "_origin": "string", "active": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "day": "date", "day_key": "int", "drive_up": "int", "facility_key": "int", "grouping_hash": "varchar(32)", "is_physical_unit": "int", "length": "decimal", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "vehicle": "int", "width": "decimal" } - schema_name_id: 333
- schema_scan_id: 123660785
- updated: 2024-07-24 06:04:03
-
Version 954069
- created: 2024-07-23 06:09:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_hist_unit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_hist_unit`\n(\n `audit_id` bigint , `day_key` int , `day` date , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `is_physical_unit` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-prod/separated_dt/dwh_hist_unit/2024-07-23/1721720421'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_hist_unit" ] - hive_path: s3://sfdl-redshift-analytics-prod/separated_dt/dwh_hist_unit/2024-07-23/1721720421
- id: 954069
- processed: 1
- raw_data:
{ "_origin": "20", "active": "12", "approve": "14", "audit_id": "0", "climate_controlled": "9", "day": "2", "day_key": "1", "drive_up": "11", "facility_key": "4", "grouping_hash": "16", "is_physical_unit": "15", "length": "18", "publish": "13", "quantity": "8", "regular_price": "6", "reservation_window": "17", "sparefoot_price": "7", "unit_key": "3", "unit_type_key": "5", "vehicle": "10", "width": "19" } - schema_attributes:
{ "_origin": "string", "active": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "day": "date", "day_key": "int", "drive_up": "int", "facility_key": "int", "grouping_hash": "varchar(32)", "is_physical_unit": "int", "length": "decimal", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "vehicle": "int", "width": "decimal" } - schema_name_id: 333
- schema_scan_id: 123587163
- updated: 2024-07-23 06:10:52
Schema Scans: 5
Last at 2026-04-17 07:19:18
-
Scan 162173155
- duration: 0:00:03.757694
- exit_message:
{ "ddl_changed": false, "partitions_applied": true, "success": true } - id: 162173155
- payload:
{ "datatype_dict": { "active": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "day": "date", "day_key": "int", "drive_up": "int", "facility_key": "int", "grouping_hash": "varchar(32)", "is_physical_unit": "int", "length": "decimal", "origin_key": "varchar", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "vehicle": "int", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-prod", "key": "meta/dwh_hist_unit/2026-04-17/1776413443/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-16", "name": "dt", "type": "string", "value": "2026-04-16" }, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit", "key": "raw_incremental/dwh_hist_unit/dt=2026-04-16/0007_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_dwh_hist_unit", "type": "redshift" }, "trace_context": { "parent_id": 5107757743048159476, "service_name": "redshift_unloads", "span_id": 7447345817988693401, "trace_id": 8094176588287355884 } } - running: False
- schema_name_id: 333
- start_time: 2026-04-17 07:19:18
- success: True
- trace_id: 8094176588287355884
-
Scan 162117441
- duration: 0:00:03.900910
- exit_message:
{ "ddl_changed": false, "partitions_applied": true, "success": true } - id: 162117441
- payload:
{ "datatype_dict": { "active": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "day": "date", "day_key": "int", "drive_up": "int", "facility_key": "int", "grouping_hash": "varchar(32)", "is_physical_unit": "int", "length": "decimal", "origin_key": "varchar", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "vehicle": "int", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-prod", "key": "meta/dwh_hist_unit/2026-04-16/1776327536/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-15", "name": "dt", "type": "string", "value": "2026-04-15" }, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit", "key": "raw_incremental/dwh_hist_unit/dt=2026-04-15/0007_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_dwh_hist_unit", "type": "redshift" }, "trace_context": { "parent_id": 13086846222859816994, "service_name": "redshift_unloads", "span_id": 8435001909837188543, "trace_id": 13953399115247891496 } } - running: False
- schema_name_id: 333
- start_time: 2026-04-16 07:19:59
- success: True
- trace_id: 13953399115247891496
-
Scan 123776291
- duration: 0:01:43.418717
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2032, "partitions_applied": false, "success": true } - id: 123776291
- payload:
{ "datatype_dict": { "active": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "day": "date", "day_key": "int", "drive_up": "int", "facility_key": "int", "grouping_hash": "varchar(32)", "is_physical_unit": "int", "length": "decimal", "origin_key": "varchar", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "vehicle": "int", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-prod", "key": "meta/dwh_hist_unit/2024-07-25/1721946330/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2024-07-24", "name": "dt", "type": "string", "value": "2024-07-24" }, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit", "key": "raw_incremental/dwh_hist_unit/dt=2024-07-24/0007_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_dwh_hist_unit", "type": "redshift" }, "trace_context": { "parent_id": 1149721631340322254, "service_name": "redshift_unloads", "span_id": 14808284777323922628, "trace_id": 7966376364629065891 } } - running: False
- schema_name_id: 333
- start_time: 2024-07-25 18:13:10
- success: True
- trace_id: 7966376364629065891
-
Scan 123660785
- duration: 0:01:43.442473
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2200, "partitions_applied": false, "success": true } - id: 123660785
- payload:
{ "datatype_dict": { "active": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "day": "date", "day_key": "int", "drive_up": "int", "facility_key": "int", "grouping_hash": "varchar(32)", "is_physical_unit": "int", "length": "decimal", "origin_key": "varchar", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "vehicle": "int", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-prod", "key": "meta/dwh_hist_unit/2024-07-24/1721807139/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-prod/separated_dt/dwh_hist_unit/2024-07-24/1721807139/dt=2024-07-23", "name": "dt", "type": "string", "value": "2024-07-23" }, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/separated_dt/dwh_hist_unit/2024-07-24/1721807139", "key": "separated_dt/dwh_hist_unit/2024-07-24/1721807139/dt=2024-07-23/0007_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_dwh_hist_unit", "type": "redshift" }, "trace_context": { "parent_id": 6747765509272985315, "service_name": "redshift_unloads", "span_id": 14098718877221525709, "trace_id": 3950424257008135505 } } - running: False
- schema_name_id: 333
- start_time: 2024-07-24 06:03:00
- success: True
- trace_id: 3950424257008135505
-
Scan 123587163
- duration: 0:01:49.006589
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2199, "partitions_applied": false, "success": true } - id: 123587163
- payload:
{ "datatype_dict": { "active": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "day": "date", "day_key": "int", "drive_up": "int", "facility_key": "int", "grouping_hash": "varchar(32)", "is_physical_unit": "int", "length": "decimal", "origin_key": "varchar", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "vehicle": "int", "width": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-prod", "key": "meta/dwh_hist_unit/2024-07-23/1721720421/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-prod/separated_dt/dwh_hist_unit/2024-07-23/1721720421/dt=2024-07-22", "name": "dt", "type": "string", "value": "2024-07-22" }, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/separated_dt/dwh_hist_unit/2024-07-23/1721720421", "key": "separated_dt/dwh_hist_unit/2024-07-23/1721720421/dt=2024-07-22/0007_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_dwh_hist_unit", "type": "redshift" }, "trace_context": { "parent_id": 7363320553406984316, "service_name": "redshift_unloads", "span_id": 7213762104248505891, "trace_id": 4859692080731321575 } } - running: False
- schema_name_id: 333
- start_time: 2024-07-23 06:09:46
- success: True
- trace_id: 4859692080731321575
- count: 183
- ddl:
[ "ALTER TABLE\n `sfdl_prod_redshift.analytics_dwh_hist_unit`\nADD\n\n\n PARTITION (dt='2025-10-14') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-14/'\n PARTITION (dt='2025-10-15') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-15/'\n PARTITION (dt='2025-10-16') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-16/'\n PARTITION (dt='2025-10-17') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-17/'\n PARTITION (dt='2025-10-18') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-18/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-20/'\n PARTITION (dt='2025-10-21') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-21/'\n PARTITION (dt='2025-10-22') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-22/'\n PARTITION (dt='2025-10-23') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-23/'\n PARTITION (dt='2025-10-24') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-24/'\n PARTITION (dt='2025-10-25') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-25/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-26/'\n PARTITION (dt='2025-10-27') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-27/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-28/'\n PARTITION (dt='2025-10-29') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-29/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-30/'\n PARTITION (dt='2025-10-31') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-31/'\n PARTITION (dt='2025-11-01') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-01/'\n PARTITION (dt='2025-11-02') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-02/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-04/'\n PARTITION (dt='2025-11-05') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-05/'\n PARTITION (dt='2025-11-06') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-06/'\n PARTITION (dt='2025-11-07') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-07/'\n PARTITION (dt='2025-11-08') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-08/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-09/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-10/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-12/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-13/'\n PARTITION (dt='2025-11-14') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-14/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-15/'\n PARTITION (dt='2025-11-16') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-16/'\n PARTITION (dt='2025-11-17') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-17/'\n PARTITION (dt='2025-11-18') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-18/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-19/'\n PARTITION (dt='2025-11-20') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-20/'\n PARTITION (dt='2025-11-21') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-21/'\n PARTITION (dt='2025-11-22') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-22/'\n PARTITION (dt='2025-11-23') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-23/'\n PARTITION (dt='2025-11-24') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-24/'\n PARTITION (dt='2025-11-25') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-25/'\n PARTITION (dt='2025-11-26') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-26/'\n PARTITION (dt='2025-11-27') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-27/'\n PARTITION (dt='2025-11-28') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-28/'\n PARTITION (dt='2025-11-29') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-29/'\n PARTITION (dt='2025-11-30') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-30/'\n PARTITION (dt='2025-12-01') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-01/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-02/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-03/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-04/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-05/'\n PARTITION (dt='2025-12-06') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-06/'\n PARTITION (dt='2025-12-07') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-07/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-08/'\n PARTITION (dt='2025-12-09') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-09/'\n PARTITION (dt='2025-12-10') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-10/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-12/'\n PARTITION (dt='2025-12-13') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-13/'\n PARTITION (dt='2025-12-14') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-14/'\n PARTITION (dt='2025-12-15') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-15/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-16/'\n PARTITION (dt='2025-12-17') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-17/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-19/'\n PARTITION (dt='2025-12-20') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-20/'\n PARTITION (dt='2025-12-21') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-21/'\n PARTITION (dt='2025-12-22') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-22/'\n PARTITION (dt='2025-12-23') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-23/'\n PARTITION (dt='2025-12-24') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-24/'\n PARTITION (dt='2025-12-25') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-25/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-26/'\n PARTITION (dt='2025-12-27') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-27/'\n PARTITION (dt='2025-12-28') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-28/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-31/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-01/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-02/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-03/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-04/'\n PARTITION (dt='2026-01-05') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-07/'\n PARTITION (dt='2026-01-09') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-09/'\n PARTITION (dt='2026-01-10') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-10/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-11/'\n PARTITION (dt='2026-01-12') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-12/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-13/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-14/'\n PARTITION (dt='2026-01-15') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-15/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-16/'\n PARTITION (dt='2026-01-17') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-17/'\n PARTITION (dt='2026-01-18') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-18/'\n PARTITION (dt='2026-01-19') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-19/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-20/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-21/'\n PARTITION (dt='2026-01-22') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-22/'\n PARTITION (dt='2026-01-23') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-23/'\n PARTITION (dt='2026-01-24') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-24/'\n PARTITION (dt='2026-01-25') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-25/'\n PARTITION (dt='2026-01-26') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-28/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-29/'\n PARTITION (dt='2026-01-30') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-30/'\n PARTITION (dt='2026-01-31') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-31/'\n PARTITION (dt='2026-02-01') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-01/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-04/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-05/'\n PARTITION (dt='2026-02-06') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-06/'\n PARTITION (dt='2026-02-07') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-07/'\n PARTITION (dt='2026-02-08') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-08/'\n PARTITION (dt='2026-02-09') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-09/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-11/'\n PARTITION (dt='2026-02-12') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-12/'\n PARTITION (dt='2026-02-13') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-13/'\n PARTITION (dt='2026-02-14') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-14/'\n PARTITION (dt='2026-02-15') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-15/'\n PARTITION (dt='2026-02-16') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-16/'\n PARTITION (dt='2026-02-17') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-17/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-18/'\n PARTITION (dt='2026-02-19') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-19/'\n PARTITION (dt='2026-02-20') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-20/'\n PARTITION (dt='2026-02-21') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-21/'\n PARTITION (dt='2026-02-22') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-22/'\n PARTITION (dt='2026-02-23') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-23/'\n PARTITION (dt='2026-02-24') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-24/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-25/'\n PARTITION (dt='2026-02-26') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-26/'\n PARTITION (dt='2026-02-27') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-27/'\n PARTITION (dt='2026-02-28') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-28/'\n PARTITION (dt='2026-03-01') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-01/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-02/'\n PARTITION (dt='2026-03-03') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-03/'\n PARTITION (dt='2026-03-04') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-04/'\n PARTITION (dt='2026-03-05') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-05/'\n PARTITION (dt='2026-03-06') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-06/'\n PARTITION (dt='2026-03-07') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-07/'\n PARTITION (dt='2026-03-08') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-08/'\n PARTITION (dt='2026-03-09') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-09/'\n PARTITION (dt='2026-03-10') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-10/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-11/'\n PARTITION (dt='2026-03-12') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-12/'\n PARTITION (dt='2026-03-13') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-13/'\n PARTITION (dt='2026-03-14') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-14/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-15/'\n PARTITION (dt='2026-03-16') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-16/'\n PARTITION (dt='2026-03-17') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-17/'\n PARTITION (dt='2026-03-18') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-18/'\n PARTITION (dt='2026-03-19') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-19/'\n PARTITION (dt='2026-03-20') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-20/'\n PARTITION (dt='2026-03-21') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-21/'\n PARTITION (dt='2026-03-22') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-22/'\n PARTITION (dt='2026-03-23') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-23/'\n PARTITION (dt='2026-03-24') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-24/'\n PARTITION (dt='2026-03-25') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-25/'\n PARTITION (dt='2026-03-26') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-26/'\n PARTITION (dt='2026-03-27') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-27/'\n PARTITION (dt='2026-03-28') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-28/'\n PARTITION (dt='2026-03-29') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-29/'\n PARTITION (dt='2026-03-30') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-30/'\n PARTITION (dt='2026-03-31') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-31/'\n PARTITION (dt='2026-04-01') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-01/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-02/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-03/'\n PARTITION (dt='2026-04-04') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-04/'\n PARTITION (dt='2026-04-05') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-05/'\n PARTITION (dt='2026-04-06') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-06/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-07/'\n PARTITION (dt='2026-04-08') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-08/'\n PARTITION (dt='2026-04-09') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-09/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-10/'\n PARTITION (dt='2026-04-11') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-11/'\n PARTITION (dt='2026-04-12') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-12/'\n PARTITION (dt='2026-04-13') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-13/'\n PARTITION (dt='2026-04-14') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-14/'\n PARTITION (dt='2026-04-15') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-15/'\n PARTITION (dt='2026-04-16') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-16/'\n;" ] - name: dt
- state:
[ { "info": { "id": 1566072, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-14/", "name": "dt", "value": "2025-10-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-15 06:45:01", "last_data": "2025-10-15 06:45:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1566306, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-15/", "name": "dt", "value": "2025-10-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-16 06:57:19", "last_data": "2025-10-16 06:57:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1584185, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-16/", "name": "dt", "value": "2025-10-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-17 06:45:43", "last_data": "2025-10-17 06:45:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1595970, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-17/", "name": "dt", "value": "2025-10-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-18 06:41:29", "last_data": "2025-10-18 06:41:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1596191, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-18/", "name": "dt", "value": "2025-10-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-19 06:44:01", "last_data": "2025-10-19 06:44:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1597007, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-20/", "name": "dt", "value": "2025-10-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-21 08:00:48", "last_data": "2025-10-21 08:00:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1597239, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-21/", "name": "dt", "value": "2025-10-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-22 07:00:35", "last_data": "2025-10-22 07:00:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1597472, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-22/", "name": "dt", "value": "2025-10-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-23 07:34:05", "last_data": "2025-10-23 07:34:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1597735, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-23/", "name": "dt", "value": "2025-10-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-24 07:49:40", "last_data": "2025-10-24 07:49:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1597971, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-24/", "name": "dt", "value": "2025-10-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-25 07:29:52", "last_data": "2025-10-25 07:29:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1598206, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-25/", "name": "dt", "value": "2025-10-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-26 07:47:38", "last_data": "2025-10-26 07:47:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1598423, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-26/", "name": "dt", "value": "2025-10-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-27 07:41:35", "last_data": "2025-10-27 07:41:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1598668, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-27/", "name": "dt", "value": "2025-10-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-28 07:37:18", "last_data": "2025-10-28 07:37:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1598903, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-28/", "name": "dt", "value": "2025-10-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-29 08:58:24", "last_data": "2025-10-29 08:58:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1599139, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-29/", "name": "dt", "value": "2025-10-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-30 07:13:30", "last_data": "2025-10-30 07:13:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1599372, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-30/", "name": "dt", "value": "2025-10-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-31 07:29:00", "last_data": "2025-10-31 07:29:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1599614, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-31/", "name": "dt", "value": "2025-10-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-01 07:36:41", "last_data": "2025-11-01 07:36:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1600035, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-01/", "name": "dt", "value": "2025-11-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-02 06:09:25", "last_data": "2025-11-02 06:09:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1600279, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-02/", "name": "dt", "value": "2025-11-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-03 07:16:11", "last_data": "2025-11-03 07:16:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1600519, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-03/", "name": "dt", "value": "2025-11-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-04 07:23:50", "last_data": "2025-11-04 07:23:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1600763, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-04/", "name": "dt", "value": "2025-11-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-05 07:43:48", "last_data": "2025-11-05 07:43:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1600996, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-05/", "name": "dt", "value": "2025-11-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-06 07:27:21", "last_data": "2025-11-06 07:27:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1601233, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-06/", "name": "dt", "value": "2025-11-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-07 06:58:53", "last_data": "2025-11-07 06:58:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1601498, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-07/", "name": "dt", "value": "2025-11-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-08 06:49:56", "last_data": "2025-11-08 06:49:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1601730, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-08/", "name": "dt", "value": "2025-11-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-09 07:21:15", "last_data": "2025-11-09 07:21:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1601967, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-09/", "name": "dt", "value": "2025-11-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-10 07:27:31", "last_data": "2025-11-10 07:27:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1602207, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-10/", "name": "dt", "value": "2025-11-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-11 07:14:09", "last_data": "2025-11-11 07:14:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1602443, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-11/", "name": "dt", "value": "2025-11-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-12 06:57:25", "last_data": "2025-11-12 06:57:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1602680, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-12/", "name": "dt", "value": "2025-11-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-13 07:32:27", "last_data": "2025-11-13 07:32:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1602916, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-13/", "name": "dt", "value": "2025-11-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-14 07:28:25", "last_data": "2025-11-14 07:28:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1603145, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-14/", "name": "dt", "value": "2025-11-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-15 06:59:08", "last_data": "2025-11-15 06:59:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1605387, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-15/", "name": "dt", "value": "2025-11-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-16 07:47:51", "last_data": "2025-11-16 07:47:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1605809, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-16/", "name": "dt", "value": "2025-11-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-17 07:10:31", "last_data": "2025-11-17 07:10:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1606074, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-17/", "name": "dt", "value": "2025-11-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-18 06:59:35", "last_data": "2025-11-18 06:59:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1606308, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-18/", "name": "dt", "value": "2025-11-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-19 06:59:29", "last_data": "2025-11-19 06:59:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1606554, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-19/", "name": "dt", "value": "2025-11-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-20 07:44:02", "last_data": "2025-11-20 07:44:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1606785, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-20/", "name": "dt", "value": "2025-11-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-21 07:21:53", "last_data": "2025-11-21 07:21:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1607555, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-21/", "name": "dt", "value": "2025-11-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-22 07:00:52", "last_data": "2025-11-22 07:00:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1607803, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-22/", "name": "dt", "value": "2025-11-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-23 06:59:52", "last_data": "2025-11-23 06:59:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1608033, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-23/", "name": "dt", "value": "2025-11-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-24 07:25:41", "last_data": "2025-11-24 07:25:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1608271, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-24/", "name": "dt", "value": "2025-11-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-25 07:15:59", "last_data": "2025-11-25 07:15:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1608508, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-25/", "name": "dt", "value": "2025-11-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-26 07:11:53", "last_data": "2025-11-26 07:11:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1608742, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-26/", "name": "dt", "value": "2025-11-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-27 07:11:56", "last_data": "2025-11-27 07:11:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1608966, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-27/", "name": "dt", "value": "2025-11-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-28 07:14:17", "last_data": "2025-11-28 07:14:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1609200, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-28/", "name": "dt", "value": "2025-11-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-29 07:20:04", "last_data": "2025-11-29 07:20:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1609429, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-29/", "name": "dt", "value": "2025-11-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-30 07:26:03", "last_data": "2025-11-30 07:26:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1609664, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-30/", "name": "dt", "value": "2025-11-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-01 07:29:44", "last_data": "2025-12-01 07:29:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1609907, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-01/", "name": "dt", "value": "2025-12-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-02 07:21:37", "last_data": "2025-12-02 07:21:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1610143, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-02/", "name": "dt", "value": "2025-12-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-03 07:10:51", "last_data": "2025-12-03 07:10:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1610387, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-03/", "name": "dt", "value": "2025-12-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-04 07:12:55", "last_data": "2025-12-04 07:12:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1610619, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-04/", "name": "dt", "value": "2025-12-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-05 07:09:10", "last_data": "2025-12-05 07:09:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1611138, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-05/", "name": "dt", "value": "2025-12-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-06 06:57:04", "last_data": "2025-12-06 06:57:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1611372, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-06/", "name": "dt", "value": "2025-12-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-07 07:35:49", "last_data": "2025-12-07 07:35:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1611593, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-07/", "name": "dt", "value": "2025-12-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-08 07:20:40", "last_data": "2025-12-08 07:20:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1611832, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-08/", "name": "dt", "value": "2025-12-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-09 07:10:04", "last_data": "2025-12-09 07:10:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1612315, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-09/", "name": "dt", "value": "2025-12-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-10 07:11:33", "last_data": "2025-12-10 07:11:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1612551, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-10/", "name": "dt", "value": "2025-12-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-11 07:21:30", "last_data": "2025-12-11 07:21:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1612810, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-11/", "name": "dt", "value": "2025-12-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-12 07:49:16", "last_data": "2025-12-12 07:49:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1613124, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-12/", "name": "dt", "value": "2025-12-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-13 07:11:43", "last_data": "2025-12-13 07:11:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1613343, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-13/", "name": "dt", "value": "2025-12-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-14 07:20:14", "last_data": "2025-12-14 07:20:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1613572, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-14/", "name": "dt", "value": "2025-12-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-15 07:41:27", "last_data": "2025-12-15 07:41:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1616243, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-15/", "name": "dt", "value": "2025-12-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-16 07:07:06", "last_data": "2025-12-16 07:07:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1616590, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-16/", "name": "dt", "value": "2025-12-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-17 07:12:11", "last_data": "2025-12-17 07:12:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1616808, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-17/", "name": "dt", "value": "2025-12-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-18 07:20:22", "last_data": "2025-12-18 07:20:22" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1617034, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-18/", "name": "dt", "value": "2025-12-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-19 07:28:05", "last_data": "2025-12-19 07:28:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1617246, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-19/", "name": "dt", "value": "2025-12-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-20 07:00:44", "last_data": "2025-12-20 07:00:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1617495, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-20/", "name": "dt", "value": "2025-12-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-21 07:26:27", "last_data": "2025-12-21 07:26:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1617708, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-21/", "name": "dt", "value": "2025-12-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-22 07:22:24", "last_data": "2025-12-22 07:22:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1617926, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-22/", "name": "dt", "value": "2025-12-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-23 07:19:56", "last_data": "2025-12-23 07:19:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1618139, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-23/", "name": "dt", "value": "2025-12-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-24 07:05:28", "last_data": "2025-12-24 07:05:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1618357, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-24/", "name": "dt", "value": "2025-12-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-25 06:59:34", "last_data": "2025-12-25 06:59:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1618570, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-25/", "name": "dt", "value": "2025-12-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-26 07:00:29", "last_data": "2025-12-26 07:00:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1618787, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-26/", "name": "dt", "value": "2025-12-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-27 07:05:48", "last_data": "2025-12-27 07:05:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1618996, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-27/", "name": "dt", "value": "2025-12-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-28 07:19:05", "last_data": "2025-12-28 07:19:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1619247, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-28/", "name": "dt", "value": "2025-12-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-29 07:00:48", "last_data": "2025-12-29 07:00:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1619463, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-29/", "name": "dt", "value": "2025-12-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-30 07:06:49", "last_data": "2025-12-30 07:06:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1619683, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-30/", "name": "dt", "value": "2025-12-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-31 07:10:35", "last_data": "2025-12-31 07:10:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1619914, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-31/", "name": "dt", "value": "2025-12-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-01 07:19:43", "last_data": "2026-01-01 07:19:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1620135, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-01/", "name": "dt", "value": "2026-01-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-02 07:09:20", "last_data": "2026-01-02 07:09:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1620355, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-02/", "name": "dt", "value": "2026-01-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-03 07:03:45", "last_data": "2026-01-03 07:03:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1620566, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-03/", "name": "dt", "value": "2026-01-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-04 07:10:16", "last_data": "2026-01-04 07:10:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1620783, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-04/", "name": "dt", "value": "2026-01-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-05 07:07:23", "last_data": "2026-01-05 07:07:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1621005, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-05/", "name": "dt", "value": "2026-01-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-06 07:07:22", "last_data": "2026-01-06 07:07:22" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1621225, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-06/", "name": "dt", "value": "2026-01-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-07 07:02:34", "last_data": "2026-01-07 07:02:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1621453, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-07/", "name": "dt", "value": "2026-01-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-08 07:02:37", "last_data": "2026-01-08 07:02:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1621901, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-09/", "name": "dt", "value": "2026-01-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-10 07:07:23", "last_data": "2026-01-10 07:07:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1622129, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-10/", "name": "dt", "value": "2026-01-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-11 07:19:30", "last_data": "2026-01-11 07:19:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1622339, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-11/", "name": "dt", "value": "2026-01-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-12 06:57:29", "last_data": "2026-01-12 06:57:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1622681, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-12/", "name": "dt", "value": "2026-01-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-13 07:13:54", "last_data": "2026-01-13 07:13:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1622899, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-13/", "name": "dt", "value": "2026-01-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-14 07:15:40", "last_data": "2026-01-14 07:15:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1623115, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-14/", "name": "dt", "value": "2026-01-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-15 07:22:01", "last_data": "2026-01-15 07:22:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1624651, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-15/", "name": "dt", "value": "2026-01-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-16 07:03:29", "last_data": "2026-01-16 07:03:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1626016, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-16/", "name": "dt", "value": "2026-01-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-17 16:00:01", "last_data": "2026-01-17 16:00:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1626133, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-17/", "name": "dt", "value": "2026-01-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-18 07:14:11", "last_data": "2026-01-18 07:14:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1626347, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-18/", "name": "dt", "value": "2026-01-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-19 07:21:25", "last_data": "2026-01-19 07:21:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1626596, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-19/", "name": "dt", "value": "2026-01-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-20 07:24:28", "last_data": "2026-01-20 07:24:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1626821, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-20/", "name": "dt", "value": "2026-01-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-21 08:22:05", "last_data": "2026-01-21 08:22:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1627033, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-21/", "name": "dt", "value": "2026-01-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-22 08:08:46", "last_data": "2026-01-22 08:08:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1627246, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-22/", "name": "dt", "value": "2026-01-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-23 07:09:42", "last_data": "2026-01-23 07:09:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1627461, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-23/", "name": "dt", "value": "2026-01-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-24 07:18:31", "last_data": "2026-01-24 07:18:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1627677, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-24/", "name": "dt", "value": "2026-01-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-25 07:42:00", "last_data": "2026-01-25 07:42:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1627888, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-25/", "name": "dt", "value": "2026-01-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-26 07:24:38", "last_data": "2026-01-26 07:24:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1628111, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-26/", "name": "dt", "value": "2026-01-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-27 07:20:23", "last_data": "2026-01-27 07:20:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1628329, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-27/", "name": "dt", "value": "2026-01-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-28 07:12:11", "last_data": "2026-01-28 07:12:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1628548, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-28/", "name": "dt", "value": "2026-01-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-29 07:10:10", "last_data": "2026-01-29 07:10:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1628774, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-29/", "name": "dt", "value": "2026-01-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-30 07:02:37", "last_data": "2026-01-30 07:02:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1628999, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-30/", "name": "dt", "value": "2026-01-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-31 07:06:13", "last_data": "2026-01-31 07:06:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1629217, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-31/", "name": "dt", "value": "2026-01-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-01 07:12:54", "last_data": "2026-02-01 07:12:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1629430, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-01/", "name": "dt", "value": "2026-02-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-02 07:15:53", "last_data": "2026-02-02 07:15:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1629709, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-02/", "name": "dt", "value": "2026-02-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-03 07:03:25", "last_data": "2026-02-03 07:03:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1629934, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-03/", "name": "dt", "value": "2026-02-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-04 07:11:35", "last_data": "2026-02-04 07:11:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1630159, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-04/", "name": "dt", "value": "2026-02-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-05 07:20:51", "last_data": "2026-02-05 07:20:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1630379, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-05/", "name": "dt", "value": "2026-02-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-06 07:23:18", "last_data": "2026-02-06 07:23:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1630596, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-06/", "name": "dt", "value": "2026-02-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-07 07:17:26", "last_data": "2026-02-07 07:17:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1630811, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-07/", "name": "dt", "value": "2026-02-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-08 07:07:33", "last_data": "2026-02-08 07:07:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1631028, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-08/", "name": "dt", "value": "2026-02-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-09 07:16:56", "last_data": "2026-02-09 07:16:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1631252, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-09/", "name": "dt", "value": "2026-02-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-10 07:24:49", "last_data": "2026-02-10 07:24:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1631481, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-10/", "name": "dt", "value": "2026-02-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-11 07:11:06", "last_data": "2026-02-11 07:11:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1631788, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-11/", "name": "dt", "value": "2026-02-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-12 07:03:39", "last_data": "2026-02-12 07:03:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1632099, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-12/", "name": "dt", "value": "2026-02-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-13 07:14:54", "last_data": "2026-02-13 07:14:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1632315, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-13/", "name": "dt", "value": "2026-02-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-14 07:27:33", "last_data": "2026-02-14 07:27:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1632518, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-14/", "name": "dt", "value": "2026-02-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-15 07:09:46", "last_data": "2026-02-15 07:09:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1634654, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-15/", "name": "dt", "value": "2026-02-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-16 07:23:00", "last_data": "2026-02-16 07:23:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1635095, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-16/", "name": "dt", "value": "2026-02-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-17 07:31:01", "last_data": "2026-02-17 07:31:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1635312, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-17/", "name": "dt", "value": "2026-02-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-18 07:17:18", "last_data": "2026-02-18 07:17:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1635529, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-18/", "name": "dt", "value": "2026-02-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-19 07:15:53", "last_data": "2026-02-19 07:15:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1635739, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-19/", "name": "dt", "value": "2026-02-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-20 07:02:37", "last_data": "2026-02-20 07:02:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1635953, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-20/", "name": "dt", "value": "2026-02-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-21 07:12:07", "last_data": "2026-02-21 07:12:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1636165, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-21/", "name": "dt", "value": "2026-02-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-22 07:27:47", "last_data": "2026-02-22 07:27:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1636434, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-22/", "name": "dt", "value": "2026-02-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-23 07:20:10", "last_data": "2026-02-23 07:20:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1636720, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-23/", "name": "dt", "value": "2026-02-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-24 07:33:27", "last_data": "2026-02-24 07:33:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1636978, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-24/", "name": "dt", "value": "2026-02-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-25 07:30:25", "last_data": "2026-02-25 07:30:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1637555, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-25/", "name": "dt", "value": "2026-02-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-26 07:23:27", "last_data": "2026-02-26 07:23:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1640946, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-26/", "name": "dt", "value": "2026-02-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-27 07:20:11", "last_data": "2026-02-27 07:20:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1641165, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-27/", "name": "dt", "value": "2026-02-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-28 07:30:55", "last_data": "2026-02-28 07:30:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1641388, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-28/", "name": "dt", "value": "2026-02-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-01 07:18:40", "last_data": "2026-03-01 07:18:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1641605, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-01/", "name": "dt", "value": "2026-03-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-02 07:12:47", "last_data": "2026-03-02 07:12:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1641836, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-02/", "name": "dt", "value": "2026-03-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-03 07:24:40", "last_data": "2026-03-03 07:24:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1642048, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-03/", "name": "dt", "value": "2026-03-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-04 07:20:13", "last_data": "2026-03-04 07:20:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1642269, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-04/", "name": "dt", "value": "2026-03-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-05 07:22:35", "last_data": "2026-03-05 07:22:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1642492, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-05/", "name": "dt", "value": "2026-03-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-06 07:22:42", "last_data": "2026-03-06 07:22:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1642708, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-06/", "name": "dt", "value": "2026-03-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-07 07:11:34", "last_data": "2026-03-07 07:11:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1642920, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-07/", "name": "dt", "value": "2026-03-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-08 08:01:35", "last_data": "2026-03-08 08:01:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1643756, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-08/", "name": "dt", "value": "2026-03-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-09 07:18:57", "last_data": "2026-03-09 07:18:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1644103, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-09/", "name": "dt", "value": "2026-03-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-10 07:19:13", "last_data": "2026-03-10 07:19:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1645051, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-10/", "name": "dt", "value": "2026-03-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-11 07:19:37", "last_data": "2026-03-11 07:19:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1645268, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-11/", "name": "dt", "value": "2026-03-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-12 07:17:49", "last_data": "2026-03-12 07:17:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1645483, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-12/", "name": "dt", "value": "2026-03-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-13 07:20:13", "last_data": "2026-03-13 07:20:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1645694, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-13/", "name": "dt", "value": "2026-03-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-14 07:08:43", "last_data": "2026-03-14 07:08:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1645904, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-14/", "name": "dt", "value": "2026-03-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-15 07:26:04", "last_data": "2026-03-15 07:26:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1647509, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-15/", "name": "dt", "value": "2026-03-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-16 07:24:39", "last_data": "2026-03-16 07:24:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1648138, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-16/", "name": "dt", "value": "2026-03-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-17 07:29:47", "last_data": "2026-03-17 07:29:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1648350, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-17/", "name": "dt", "value": "2026-03-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-18 07:16:04", "last_data": "2026-03-18 07:16:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1648600, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-18/", "name": "dt", "value": "2026-03-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-19 07:22:21", "last_data": "2026-03-19 07:22:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1648812, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-19/", "name": "dt", "value": "2026-03-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-20 07:19:55", "last_data": "2026-03-20 07:19:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1649027, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-20/", "name": "dt", "value": "2026-03-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-21 07:48:58", "last_data": "2026-03-21 07:48:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1649355, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-21/", "name": "dt", "value": "2026-03-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-22 07:26:04", "last_data": "2026-03-22 07:26:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1649560, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-22/", "name": "dt", "value": "2026-03-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-23 07:28:14", "last_data": "2026-03-23 07:28:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1649776, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-23/", "name": "dt", "value": "2026-03-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-24 07:06:22", "last_data": "2026-03-24 07:06:22" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1650000, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-24/", "name": "dt", "value": "2026-03-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-25 07:11:37", "last_data": "2026-03-25 07:11:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1650249, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-25/", "name": "dt", "value": "2026-03-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-26 07:27:03", "last_data": "2026-03-26 07:27:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1650463, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-26/", "name": "dt", "value": "2026-03-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-27 07:19:21", "last_data": "2026-03-27 07:19:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1650673, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-27/", "name": "dt", "value": "2026-03-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-28 07:24:37", "last_data": "2026-03-28 07:24:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1650888, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-28/", "name": "dt", "value": "2026-03-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-29 07:27:09", "last_data": "2026-03-29 07:27:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1651522, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-29/", "name": "dt", "value": "2026-03-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-30 07:32:42", "last_data": "2026-03-30 07:32:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1651828, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-30/", "name": "dt", "value": "2026-03-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-31 07:32:16", "last_data": "2026-03-31 07:32:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1652050, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-31/", "name": "dt", "value": "2026-03-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-01 07:18:02", "last_data": "2026-04-01 07:18:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1652429, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-01/", "name": "dt", "value": "2026-04-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-02 07:35:53", "last_data": "2026-04-02 07:35:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1652641, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-02/", "name": "dt", "value": "2026-04-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-03 07:20:58", "last_data": "2026-04-03 07:20:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1652862, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-03/", "name": "dt", "value": "2026-04-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-04 07:17:06", "last_data": "2026-04-04 07:17:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1653076, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-04/", "name": "dt", "value": "2026-04-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-05 07:32:47", "last_data": "2026-04-05 07:32:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1656584, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-05/", "name": "dt", "value": "2026-04-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-06 07:26:42", "last_data": "2026-04-06 07:26:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1656796, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-06/", "name": "dt", "value": "2026-04-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-07 07:19:35", "last_data": "2026-04-07 07:19:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1657026, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-07/", "name": "dt", "value": "2026-04-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-08 07:25:33", "last_data": "2026-04-08 07:25:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1657434, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-08/", "name": "dt", "value": "2026-04-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-09 07:26:46", "last_data": "2026-04-09 07:26:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1657649, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-09/", "name": "dt", "value": "2026-04-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-10 07:23:53", "last_data": "2026-04-10 07:23:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1657871, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-10/", "name": "dt", "value": "2026-04-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-11 07:19:40", "last_data": "2026-04-11 07:19:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1658076, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-11/", "name": "dt", "value": "2026-04-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-12 07:20:47", "last_data": "2026-04-12 07:20:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1658285, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-12/", "name": "dt", "value": "2026-04-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-13 07:22:14", "last_data": "2026-04-13 07:22:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1658507, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-13/", "name": "dt", "value": "2026-04-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-14 07:31:54", "last_data": "2026-04-14 07:31:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1658718, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-14/", "name": "dt", "value": "2026-04-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-15 07:28:55", "last_data": "2026-04-15 07:28:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1660129, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-15/", "name": "dt", "value": "2026-04-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-16 07:20:00", "last_data": "2026-04-16 07:20:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1661347, "location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-16/", "name": "dt", "value": "2026-04-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-17 07:19:18", "last_data": "2026-04-17 07:19:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } } ] - type: string
- attributes:
{ "_origin": "string", "active": "int", "approve": "int", "audit_id": "bigint", "climate_controlled": "int", "day": "date", "day_key": "int", "drive_up": "int", "facility_key": "int", "grouping_hash": "varchar(32)", "is_physical_unit": "int", "length": "decimal", "publish": "int", "quantity": "int", "regular_price": "decimal", "reservation_window": "int", "sparefoot_price": "decimal", "unit_key": "bigint", "unit_type_key": "int", "vehicle": "int", "width": "decimal" } - created: 2024-07-25 18:13:11
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_hist_unit`\n(\n `audit_id` bigint , `day_key` int , `day` date , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `is_physical_unit` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_hist_unit`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_hist_unit" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2018-04-02 10:59:11",
"disabled": false,
"format": "raw",
"id": 333,
"is_partitioned": true,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_redshift",
"table": "analytics_dwh_hist_unit"
},
"type": "redshift"
},
"partition": {
"count": 183,
"ddl": [
"ALTER TABLE\n `sfdl_prod_redshift.analytics_dwh_hist_unit`\nADD\n\n\n PARTITION (dt='2025-10-14') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-14/'\n PARTITION (dt='2025-10-15') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-15/'\n PARTITION (dt='2025-10-16') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-16/'\n PARTITION (dt='2025-10-17') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-17/'\n PARTITION (dt='2025-10-18') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-18/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-20/'\n PARTITION (dt='2025-10-21') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-21/'\n PARTITION (dt='2025-10-22') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-22/'\n PARTITION (dt='2025-10-23') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-23/'\n PARTITION (dt='2025-10-24') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-24/'\n PARTITION (dt='2025-10-25') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-25/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-26/'\n PARTITION (dt='2025-10-27') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-27/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-28/'\n PARTITION (dt='2025-10-29') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-29/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-30/'\n PARTITION (dt='2025-10-31') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-31/'\n PARTITION (dt='2025-11-01') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-01/'\n PARTITION (dt='2025-11-02') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-02/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-04/'\n PARTITION (dt='2025-11-05') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-05/'\n PARTITION (dt='2025-11-06') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-06/'\n PARTITION (dt='2025-11-07') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-07/'\n PARTITION (dt='2025-11-08') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-08/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-09/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-10/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-12/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-13/'\n PARTITION (dt='2025-11-14') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-14/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-15/'\n PARTITION (dt='2025-11-16') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-16/'\n PARTITION (dt='2025-11-17') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-17/'\n PARTITION (dt='2025-11-18') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-18/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-19/'\n PARTITION (dt='2025-11-20') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-20/'\n PARTITION (dt='2025-11-21') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-21/'\n PARTITION (dt='2025-11-22') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-22/'\n PARTITION (dt='2025-11-23') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-23/'\n PARTITION (dt='2025-11-24') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-24/'\n PARTITION (dt='2025-11-25') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-25/'\n PARTITION (dt='2025-11-26') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-26/'\n PARTITION (dt='2025-11-27') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-27/'\n PARTITION (dt='2025-11-28') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-28/'\n PARTITION (dt='2025-11-29') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-29/'\n PARTITION (dt='2025-11-30') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-30/'\n PARTITION (dt='2025-12-01') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-01/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-02/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-03/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-04/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-05/'\n PARTITION (dt='2025-12-06') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-06/'\n PARTITION (dt='2025-12-07') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-07/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-08/'\n PARTITION (dt='2025-12-09') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-09/'\n PARTITION (dt='2025-12-10') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-10/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-12/'\n PARTITION (dt='2025-12-13') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-13/'\n PARTITION (dt='2025-12-14') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-14/'\n PARTITION (dt='2025-12-15') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-15/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-16/'\n PARTITION (dt='2025-12-17') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-17/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-19/'\n PARTITION (dt='2025-12-20') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-20/'\n PARTITION (dt='2025-12-21') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-21/'\n PARTITION (dt='2025-12-22') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-22/'\n PARTITION (dt='2025-12-23') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-23/'\n PARTITION (dt='2025-12-24') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-24/'\n PARTITION (dt='2025-12-25') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-25/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-26/'\n PARTITION (dt='2025-12-27') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-27/'\n PARTITION (dt='2025-12-28') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-28/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-31/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-01/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-02/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-03/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-04/'\n PARTITION (dt='2026-01-05') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-07/'\n PARTITION (dt='2026-01-09') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-09/'\n PARTITION (dt='2026-01-10') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-10/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-11/'\n PARTITION (dt='2026-01-12') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-12/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-13/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-14/'\n PARTITION (dt='2026-01-15') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-15/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-16/'\n PARTITION (dt='2026-01-17') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-17/'\n PARTITION (dt='2026-01-18') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-18/'\n PARTITION (dt='2026-01-19') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-19/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-20/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-21/'\n PARTITION (dt='2026-01-22') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-22/'\n PARTITION (dt='2026-01-23') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-23/'\n PARTITION (dt='2026-01-24') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-24/'\n PARTITION (dt='2026-01-25') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-25/'\n PARTITION (dt='2026-01-26') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-28/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-29/'\n PARTITION (dt='2026-01-30') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-30/'\n PARTITION (dt='2026-01-31') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-31/'\n PARTITION (dt='2026-02-01') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-01/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-04/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-05/'\n PARTITION (dt='2026-02-06') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-06/'\n PARTITION (dt='2026-02-07') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-07/'\n PARTITION (dt='2026-02-08') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-08/'\n PARTITION (dt='2026-02-09') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-09/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-11/'\n PARTITION (dt='2026-02-12') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-12/'\n PARTITION (dt='2026-02-13') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-13/'\n PARTITION (dt='2026-02-14') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-14/'\n PARTITION (dt='2026-02-15') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-15/'\n PARTITION (dt='2026-02-16') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-16/'\n PARTITION (dt='2026-02-17') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-17/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-18/'\n PARTITION (dt='2026-02-19') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-19/'\n PARTITION (dt='2026-02-20') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-20/'\n PARTITION (dt='2026-02-21') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-21/'\n PARTITION (dt='2026-02-22') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-22/'\n PARTITION (dt='2026-02-23') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-23/'\n PARTITION (dt='2026-02-24') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-24/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-25/'\n PARTITION (dt='2026-02-26') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-26/'\n PARTITION (dt='2026-02-27') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-27/'\n PARTITION (dt='2026-02-28') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-28/'\n PARTITION (dt='2026-03-01') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-01/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-02/'\n PARTITION (dt='2026-03-03') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-03/'\n PARTITION (dt='2026-03-04') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-04/'\n PARTITION (dt='2026-03-05') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-05/'\n PARTITION (dt='2026-03-06') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-06/'\n PARTITION (dt='2026-03-07') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-07/'\n PARTITION (dt='2026-03-08') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-08/'\n PARTITION (dt='2026-03-09') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-09/'\n PARTITION (dt='2026-03-10') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-10/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-11/'\n PARTITION (dt='2026-03-12') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-12/'\n PARTITION (dt='2026-03-13') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-13/'\n PARTITION (dt='2026-03-14') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-14/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-15/'\n PARTITION (dt='2026-03-16') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-16/'\n PARTITION (dt='2026-03-17') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-17/'\n PARTITION (dt='2026-03-18') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-18/'\n PARTITION (dt='2026-03-19') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-19/'\n PARTITION (dt='2026-03-20') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-20/'\n PARTITION (dt='2026-03-21') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-21/'\n PARTITION (dt='2026-03-22') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-22/'\n PARTITION (dt='2026-03-23') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-23/'\n PARTITION (dt='2026-03-24') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-24/'\n PARTITION (dt='2026-03-25') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-25/'\n PARTITION (dt='2026-03-26') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-26/'\n PARTITION (dt='2026-03-27') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-27/'\n PARTITION (dt='2026-03-28') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-28/'\n PARTITION (dt='2026-03-29') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-29/'\n PARTITION (dt='2026-03-30') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-30/'\n PARTITION (dt='2026-03-31') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-31/'\n PARTITION (dt='2026-04-01') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-01/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-02/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-03/'\n PARTITION (dt='2026-04-04') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-04/'\n PARTITION (dt='2026-04-05') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-05/'\n PARTITION (dt='2026-04-06') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-06/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-07/'\n PARTITION (dt='2026-04-08') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-08/'\n PARTITION (dt='2026-04-09') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-09/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-10/'\n PARTITION (dt='2026-04-11') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-11/'\n PARTITION (dt='2026-04-12') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-12/'\n PARTITION (dt='2026-04-13') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-13/'\n PARTITION (dt='2026-04-14') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-14/'\n PARTITION (dt='2026-04-15') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-15/'\n PARTITION (dt='2026-04-16') location 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-16/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 1566072,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-14/",
"name": "dt",
"value": "2025-10-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-15 06:45:01",
"last_data": "2025-10-15 06:45:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1566306,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-15/",
"name": "dt",
"value": "2025-10-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-16 06:57:19",
"last_data": "2025-10-16 06:57:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1584185,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-16/",
"name": "dt",
"value": "2025-10-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-17 06:45:43",
"last_data": "2025-10-17 06:45:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1595970,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-17/",
"name": "dt",
"value": "2025-10-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-18 06:41:29",
"last_data": "2025-10-18 06:41:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1596191,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-18/",
"name": "dt",
"value": "2025-10-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-19 06:44:01",
"last_data": "2025-10-19 06:44:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1597007,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-20/",
"name": "dt",
"value": "2025-10-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-21 08:00:48",
"last_data": "2025-10-21 08:00:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1597239,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-21/",
"name": "dt",
"value": "2025-10-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-22 07:00:35",
"last_data": "2025-10-22 07:00:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1597472,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-22/",
"name": "dt",
"value": "2025-10-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-23 07:34:05",
"last_data": "2025-10-23 07:34:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1597735,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-23/",
"name": "dt",
"value": "2025-10-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-24 07:49:40",
"last_data": "2025-10-24 07:49:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1597971,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-24/",
"name": "dt",
"value": "2025-10-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-25 07:29:52",
"last_data": "2025-10-25 07:29:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1598206,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-25/",
"name": "dt",
"value": "2025-10-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-26 07:47:38",
"last_data": "2025-10-26 07:47:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1598423,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-26/",
"name": "dt",
"value": "2025-10-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-27 07:41:35",
"last_data": "2025-10-27 07:41:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1598668,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-27/",
"name": "dt",
"value": "2025-10-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-28 07:37:18",
"last_data": "2025-10-28 07:37:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1598903,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-28/",
"name": "dt",
"value": "2025-10-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-29 08:58:24",
"last_data": "2025-10-29 08:58:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1599139,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-29/",
"name": "dt",
"value": "2025-10-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-30 07:13:30",
"last_data": "2025-10-30 07:13:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1599372,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-30/",
"name": "dt",
"value": "2025-10-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-31 07:29:00",
"last_data": "2025-10-31 07:29:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1599614,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-10-31/",
"name": "dt",
"value": "2025-10-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-01 07:36:41",
"last_data": "2025-11-01 07:36:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1600035,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-01/",
"name": "dt",
"value": "2025-11-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-02 06:09:25",
"last_data": "2025-11-02 06:09:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1600279,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-02/",
"name": "dt",
"value": "2025-11-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-03 07:16:11",
"last_data": "2025-11-03 07:16:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1600519,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-03/",
"name": "dt",
"value": "2025-11-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-04 07:23:50",
"last_data": "2025-11-04 07:23:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1600763,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-04/",
"name": "dt",
"value": "2025-11-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-05 07:43:48",
"last_data": "2025-11-05 07:43:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1600996,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-05/",
"name": "dt",
"value": "2025-11-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-06 07:27:21",
"last_data": "2025-11-06 07:27:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1601233,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-06/",
"name": "dt",
"value": "2025-11-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-07 06:58:53",
"last_data": "2025-11-07 06:58:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1601498,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-07/",
"name": "dt",
"value": "2025-11-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-08 06:49:56",
"last_data": "2025-11-08 06:49:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1601730,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-08/",
"name": "dt",
"value": "2025-11-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-09 07:21:15",
"last_data": "2025-11-09 07:21:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1601967,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-09/",
"name": "dt",
"value": "2025-11-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-10 07:27:31",
"last_data": "2025-11-10 07:27:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1602207,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-10/",
"name": "dt",
"value": "2025-11-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-11 07:14:09",
"last_data": "2025-11-11 07:14:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1602443,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-11/",
"name": "dt",
"value": "2025-11-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-12 06:57:25",
"last_data": "2025-11-12 06:57:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1602680,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-12/",
"name": "dt",
"value": "2025-11-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-13 07:32:27",
"last_data": "2025-11-13 07:32:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1602916,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-13/",
"name": "dt",
"value": "2025-11-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-14 07:28:25",
"last_data": "2025-11-14 07:28:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1603145,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-14/",
"name": "dt",
"value": "2025-11-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-15 06:59:08",
"last_data": "2025-11-15 06:59:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1605387,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-15/",
"name": "dt",
"value": "2025-11-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-16 07:47:51",
"last_data": "2025-11-16 07:47:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1605809,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-16/",
"name": "dt",
"value": "2025-11-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-17 07:10:31",
"last_data": "2025-11-17 07:10:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1606074,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-17/",
"name": "dt",
"value": "2025-11-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-18 06:59:35",
"last_data": "2025-11-18 06:59:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1606308,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-18/",
"name": "dt",
"value": "2025-11-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-19 06:59:29",
"last_data": "2025-11-19 06:59:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1606554,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-19/",
"name": "dt",
"value": "2025-11-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-20 07:44:02",
"last_data": "2025-11-20 07:44:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1606785,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-20/",
"name": "dt",
"value": "2025-11-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-21 07:21:53",
"last_data": "2025-11-21 07:21:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1607555,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-21/",
"name": "dt",
"value": "2025-11-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-22 07:00:52",
"last_data": "2025-11-22 07:00:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1607803,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-22/",
"name": "dt",
"value": "2025-11-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-23 06:59:52",
"last_data": "2025-11-23 06:59:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1608033,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-23/",
"name": "dt",
"value": "2025-11-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-24 07:25:41",
"last_data": "2025-11-24 07:25:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1608271,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-24/",
"name": "dt",
"value": "2025-11-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-25 07:15:59",
"last_data": "2025-11-25 07:15:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1608508,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-25/",
"name": "dt",
"value": "2025-11-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-26 07:11:53",
"last_data": "2025-11-26 07:11:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1608742,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-26/",
"name": "dt",
"value": "2025-11-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-27 07:11:56",
"last_data": "2025-11-27 07:11:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1608966,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-27/",
"name": "dt",
"value": "2025-11-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-28 07:14:17",
"last_data": "2025-11-28 07:14:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1609200,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-28/",
"name": "dt",
"value": "2025-11-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-29 07:20:04",
"last_data": "2025-11-29 07:20:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1609429,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-29/",
"name": "dt",
"value": "2025-11-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-30 07:26:03",
"last_data": "2025-11-30 07:26:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1609664,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-11-30/",
"name": "dt",
"value": "2025-11-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-01 07:29:44",
"last_data": "2025-12-01 07:29:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1609907,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-01/",
"name": "dt",
"value": "2025-12-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-02 07:21:37",
"last_data": "2025-12-02 07:21:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1610143,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-02/",
"name": "dt",
"value": "2025-12-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-03 07:10:51",
"last_data": "2025-12-03 07:10:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1610387,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-03/",
"name": "dt",
"value": "2025-12-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-04 07:12:55",
"last_data": "2025-12-04 07:12:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1610619,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-04/",
"name": "dt",
"value": "2025-12-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-05 07:09:10",
"last_data": "2025-12-05 07:09:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1611138,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-05/",
"name": "dt",
"value": "2025-12-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-06 06:57:04",
"last_data": "2025-12-06 06:57:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1611372,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-06/",
"name": "dt",
"value": "2025-12-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-07 07:35:49",
"last_data": "2025-12-07 07:35:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1611593,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-07/",
"name": "dt",
"value": "2025-12-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-08 07:20:40",
"last_data": "2025-12-08 07:20:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1611832,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-08/",
"name": "dt",
"value": "2025-12-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-09 07:10:04",
"last_data": "2025-12-09 07:10:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1612315,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-09/",
"name": "dt",
"value": "2025-12-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-10 07:11:33",
"last_data": "2025-12-10 07:11:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1612551,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-10/",
"name": "dt",
"value": "2025-12-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-11 07:21:30",
"last_data": "2025-12-11 07:21:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1612810,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-11/",
"name": "dt",
"value": "2025-12-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-12 07:49:16",
"last_data": "2025-12-12 07:49:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1613124,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-12/",
"name": "dt",
"value": "2025-12-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-13 07:11:43",
"last_data": "2025-12-13 07:11:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1613343,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-13/",
"name": "dt",
"value": "2025-12-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-14 07:20:14",
"last_data": "2025-12-14 07:20:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1613572,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-14/",
"name": "dt",
"value": "2025-12-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-15 07:41:27",
"last_data": "2025-12-15 07:41:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1616243,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-15/",
"name": "dt",
"value": "2025-12-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-16 07:07:06",
"last_data": "2025-12-16 07:07:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1616590,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-16/",
"name": "dt",
"value": "2025-12-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-17 07:12:11",
"last_data": "2025-12-17 07:12:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1616808,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-17/",
"name": "dt",
"value": "2025-12-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-18 07:20:22",
"last_data": "2025-12-18 07:20:22"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1617034,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-18/",
"name": "dt",
"value": "2025-12-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-19 07:28:05",
"last_data": "2025-12-19 07:28:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1617246,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-19/",
"name": "dt",
"value": "2025-12-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-20 07:00:44",
"last_data": "2025-12-20 07:00:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1617495,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-20/",
"name": "dt",
"value": "2025-12-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-21 07:26:27",
"last_data": "2025-12-21 07:26:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1617708,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-21/",
"name": "dt",
"value": "2025-12-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-22 07:22:24",
"last_data": "2025-12-22 07:22:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1617926,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-22/",
"name": "dt",
"value": "2025-12-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-23 07:19:56",
"last_data": "2025-12-23 07:19:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1618139,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-23/",
"name": "dt",
"value": "2025-12-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-24 07:05:28",
"last_data": "2025-12-24 07:05:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1618357,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-24/",
"name": "dt",
"value": "2025-12-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-25 06:59:34",
"last_data": "2025-12-25 06:59:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1618570,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-25/",
"name": "dt",
"value": "2025-12-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-26 07:00:29",
"last_data": "2025-12-26 07:00:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1618787,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-26/",
"name": "dt",
"value": "2025-12-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-27 07:05:48",
"last_data": "2025-12-27 07:05:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1618996,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-27/",
"name": "dt",
"value": "2025-12-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-28 07:19:05",
"last_data": "2025-12-28 07:19:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1619247,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-28/",
"name": "dt",
"value": "2025-12-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-29 07:00:48",
"last_data": "2025-12-29 07:00:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1619463,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-29/",
"name": "dt",
"value": "2025-12-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-30 07:06:49",
"last_data": "2025-12-30 07:06:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1619683,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-30/",
"name": "dt",
"value": "2025-12-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-31 07:10:35",
"last_data": "2025-12-31 07:10:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1619914,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2025-12-31/",
"name": "dt",
"value": "2025-12-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-01 07:19:43",
"last_data": "2026-01-01 07:19:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1620135,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-01/",
"name": "dt",
"value": "2026-01-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-02 07:09:20",
"last_data": "2026-01-02 07:09:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1620355,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-02/",
"name": "dt",
"value": "2026-01-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-03 07:03:45",
"last_data": "2026-01-03 07:03:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1620566,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-03/",
"name": "dt",
"value": "2026-01-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-04 07:10:16",
"last_data": "2026-01-04 07:10:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1620783,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-04/",
"name": "dt",
"value": "2026-01-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-05 07:07:23",
"last_data": "2026-01-05 07:07:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1621005,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-05/",
"name": "dt",
"value": "2026-01-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-06 07:07:22",
"last_data": "2026-01-06 07:07:22"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1621225,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-06/",
"name": "dt",
"value": "2026-01-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-07 07:02:34",
"last_data": "2026-01-07 07:02:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1621453,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-07/",
"name": "dt",
"value": "2026-01-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-08 07:02:37",
"last_data": "2026-01-08 07:02:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1621901,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-09/",
"name": "dt",
"value": "2026-01-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-10 07:07:23",
"last_data": "2026-01-10 07:07:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1622129,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-10/",
"name": "dt",
"value": "2026-01-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-11 07:19:30",
"last_data": "2026-01-11 07:19:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1622339,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-11/",
"name": "dt",
"value": "2026-01-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-12 06:57:29",
"last_data": "2026-01-12 06:57:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1622681,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-12/",
"name": "dt",
"value": "2026-01-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-13 07:13:54",
"last_data": "2026-01-13 07:13:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1622899,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-13/",
"name": "dt",
"value": "2026-01-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-14 07:15:40",
"last_data": "2026-01-14 07:15:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1623115,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-14/",
"name": "dt",
"value": "2026-01-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-15 07:22:01",
"last_data": "2026-01-15 07:22:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1624651,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-15/",
"name": "dt",
"value": "2026-01-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-16 07:03:29",
"last_data": "2026-01-16 07:03:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1626016,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-16/",
"name": "dt",
"value": "2026-01-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-17 16:00:01",
"last_data": "2026-01-17 16:00:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1626133,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-17/",
"name": "dt",
"value": "2026-01-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-18 07:14:11",
"last_data": "2026-01-18 07:14:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1626347,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-18/",
"name": "dt",
"value": "2026-01-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-19 07:21:25",
"last_data": "2026-01-19 07:21:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1626596,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-19/",
"name": "dt",
"value": "2026-01-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-20 07:24:28",
"last_data": "2026-01-20 07:24:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1626821,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-20/",
"name": "dt",
"value": "2026-01-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-21 08:22:05",
"last_data": "2026-01-21 08:22:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1627033,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-21/",
"name": "dt",
"value": "2026-01-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-22 08:08:46",
"last_data": "2026-01-22 08:08:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1627246,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-22/",
"name": "dt",
"value": "2026-01-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-23 07:09:42",
"last_data": "2026-01-23 07:09:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1627461,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-23/",
"name": "dt",
"value": "2026-01-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-24 07:18:31",
"last_data": "2026-01-24 07:18:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1627677,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-24/",
"name": "dt",
"value": "2026-01-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-25 07:42:00",
"last_data": "2026-01-25 07:42:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1627888,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-25/",
"name": "dt",
"value": "2026-01-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-26 07:24:38",
"last_data": "2026-01-26 07:24:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1628111,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-26/",
"name": "dt",
"value": "2026-01-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-27 07:20:23",
"last_data": "2026-01-27 07:20:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1628329,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-27/",
"name": "dt",
"value": "2026-01-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-28 07:12:11",
"last_data": "2026-01-28 07:12:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1628548,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-28/",
"name": "dt",
"value": "2026-01-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-29 07:10:10",
"last_data": "2026-01-29 07:10:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1628774,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-29/",
"name": "dt",
"value": "2026-01-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-30 07:02:37",
"last_data": "2026-01-30 07:02:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1628999,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-30/",
"name": "dt",
"value": "2026-01-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-31 07:06:13",
"last_data": "2026-01-31 07:06:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1629217,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-01-31/",
"name": "dt",
"value": "2026-01-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-01 07:12:54",
"last_data": "2026-02-01 07:12:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1629430,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-01/",
"name": "dt",
"value": "2026-02-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-02 07:15:53",
"last_data": "2026-02-02 07:15:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1629709,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-02/",
"name": "dt",
"value": "2026-02-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-03 07:03:25",
"last_data": "2026-02-03 07:03:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1629934,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-03/",
"name": "dt",
"value": "2026-02-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-04 07:11:35",
"last_data": "2026-02-04 07:11:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1630159,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-04/",
"name": "dt",
"value": "2026-02-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-05 07:20:51",
"last_data": "2026-02-05 07:20:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1630379,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-05/",
"name": "dt",
"value": "2026-02-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-06 07:23:18",
"last_data": "2026-02-06 07:23:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1630596,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-06/",
"name": "dt",
"value": "2026-02-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-07 07:17:26",
"last_data": "2026-02-07 07:17:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1630811,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-07/",
"name": "dt",
"value": "2026-02-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-08 07:07:33",
"last_data": "2026-02-08 07:07:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1631028,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-08/",
"name": "dt",
"value": "2026-02-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-09 07:16:56",
"last_data": "2026-02-09 07:16:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1631252,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-09/",
"name": "dt",
"value": "2026-02-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-10 07:24:49",
"last_data": "2026-02-10 07:24:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1631481,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-10/",
"name": "dt",
"value": "2026-02-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-11 07:11:06",
"last_data": "2026-02-11 07:11:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1631788,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-11/",
"name": "dt",
"value": "2026-02-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-12 07:03:39",
"last_data": "2026-02-12 07:03:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1632099,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-12/",
"name": "dt",
"value": "2026-02-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-13 07:14:54",
"last_data": "2026-02-13 07:14:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1632315,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-13/",
"name": "dt",
"value": "2026-02-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-14 07:27:33",
"last_data": "2026-02-14 07:27:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1632518,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-14/",
"name": "dt",
"value": "2026-02-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-15 07:09:46",
"last_data": "2026-02-15 07:09:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1634654,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-15/",
"name": "dt",
"value": "2026-02-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-16 07:23:00",
"last_data": "2026-02-16 07:23:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1635095,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-16/",
"name": "dt",
"value": "2026-02-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-17 07:31:01",
"last_data": "2026-02-17 07:31:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1635312,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-17/",
"name": "dt",
"value": "2026-02-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-18 07:17:18",
"last_data": "2026-02-18 07:17:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1635529,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-18/",
"name": "dt",
"value": "2026-02-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-19 07:15:53",
"last_data": "2026-02-19 07:15:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1635739,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-19/",
"name": "dt",
"value": "2026-02-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-20 07:02:37",
"last_data": "2026-02-20 07:02:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1635953,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-20/",
"name": "dt",
"value": "2026-02-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-21 07:12:07",
"last_data": "2026-02-21 07:12:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1636165,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-21/",
"name": "dt",
"value": "2026-02-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-22 07:27:47",
"last_data": "2026-02-22 07:27:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1636434,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-22/",
"name": "dt",
"value": "2026-02-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-23 07:20:10",
"last_data": "2026-02-23 07:20:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1636720,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-23/",
"name": "dt",
"value": "2026-02-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-24 07:33:27",
"last_data": "2026-02-24 07:33:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1636978,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-24/",
"name": "dt",
"value": "2026-02-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-25 07:30:25",
"last_data": "2026-02-25 07:30:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1637555,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-25/",
"name": "dt",
"value": "2026-02-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-26 07:23:27",
"last_data": "2026-02-26 07:23:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1640946,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-26/",
"name": "dt",
"value": "2026-02-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-27 07:20:11",
"last_data": "2026-02-27 07:20:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1641165,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-27/",
"name": "dt",
"value": "2026-02-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-28 07:30:55",
"last_data": "2026-02-28 07:30:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1641388,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-02-28/",
"name": "dt",
"value": "2026-02-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-01 07:18:40",
"last_data": "2026-03-01 07:18:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1641605,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-01/",
"name": "dt",
"value": "2026-03-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-02 07:12:47",
"last_data": "2026-03-02 07:12:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1641836,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-02/",
"name": "dt",
"value": "2026-03-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-03 07:24:40",
"last_data": "2026-03-03 07:24:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1642048,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-03/",
"name": "dt",
"value": "2026-03-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-04 07:20:13",
"last_data": "2026-03-04 07:20:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1642269,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-04/",
"name": "dt",
"value": "2026-03-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-05 07:22:35",
"last_data": "2026-03-05 07:22:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1642492,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-05/",
"name": "dt",
"value": "2026-03-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-06 07:22:42",
"last_data": "2026-03-06 07:22:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1642708,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-06/",
"name": "dt",
"value": "2026-03-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-07 07:11:34",
"last_data": "2026-03-07 07:11:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1642920,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-07/",
"name": "dt",
"value": "2026-03-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-08 08:01:35",
"last_data": "2026-03-08 08:01:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1643756,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-08/",
"name": "dt",
"value": "2026-03-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-09 07:18:57",
"last_data": "2026-03-09 07:18:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1644103,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-09/",
"name": "dt",
"value": "2026-03-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-10 07:19:13",
"last_data": "2026-03-10 07:19:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1645051,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-10/",
"name": "dt",
"value": "2026-03-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-11 07:19:37",
"last_data": "2026-03-11 07:19:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1645268,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-11/",
"name": "dt",
"value": "2026-03-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-12 07:17:49",
"last_data": "2026-03-12 07:17:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1645483,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-12/",
"name": "dt",
"value": "2026-03-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-13 07:20:13",
"last_data": "2026-03-13 07:20:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1645694,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-13/",
"name": "dt",
"value": "2026-03-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-14 07:08:43",
"last_data": "2026-03-14 07:08:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1645904,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-14/",
"name": "dt",
"value": "2026-03-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-15 07:26:04",
"last_data": "2026-03-15 07:26:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1647509,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-15/",
"name": "dt",
"value": "2026-03-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-16 07:24:39",
"last_data": "2026-03-16 07:24:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1648138,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-16/",
"name": "dt",
"value": "2026-03-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-17 07:29:47",
"last_data": "2026-03-17 07:29:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1648350,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-17/",
"name": "dt",
"value": "2026-03-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-18 07:16:04",
"last_data": "2026-03-18 07:16:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1648600,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-18/",
"name": "dt",
"value": "2026-03-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-19 07:22:21",
"last_data": "2026-03-19 07:22:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1648812,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-19/",
"name": "dt",
"value": "2026-03-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-20 07:19:55",
"last_data": "2026-03-20 07:19:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1649027,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-20/",
"name": "dt",
"value": "2026-03-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-21 07:48:58",
"last_data": "2026-03-21 07:48:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1649355,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-21/",
"name": "dt",
"value": "2026-03-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-22 07:26:04",
"last_data": "2026-03-22 07:26:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1649560,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-22/",
"name": "dt",
"value": "2026-03-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-23 07:28:14",
"last_data": "2026-03-23 07:28:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1649776,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-23/",
"name": "dt",
"value": "2026-03-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-24 07:06:22",
"last_data": "2026-03-24 07:06:22"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1650000,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-24/",
"name": "dt",
"value": "2026-03-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-25 07:11:37",
"last_data": "2026-03-25 07:11:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1650249,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-25/",
"name": "dt",
"value": "2026-03-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-26 07:27:03",
"last_data": "2026-03-26 07:27:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1650463,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-26/",
"name": "dt",
"value": "2026-03-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-27 07:19:21",
"last_data": "2026-03-27 07:19:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1650673,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-27/",
"name": "dt",
"value": "2026-03-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-28 07:24:37",
"last_data": "2026-03-28 07:24:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1650888,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-28/",
"name": "dt",
"value": "2026-03-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-29 07:27:09",
"last_data": "2026-03-29 07:27:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1651522,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-29/",
"name": "dt",
"value": "2026-03-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-30 07:32:42",
"last_data": "2026-03-30 07:32:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1651828,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-30/",
"name": "dt",
"value": "2026-03-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-31 07:32:16",
"last_data": "2026-03-31 07:32:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1652050,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-03-31/",
"name": "dt",
"value": "2026-03-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-01 07:18:02",
"last_data": "2026-04-01 07:18:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1652429,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-01/",
"name": "dt",
"value": "2026-04-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-02 07:35:53",
"last_data": "2026-04-02 07:35:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1652641,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-02/",
"name": "dt",
"value": "2026-04-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-03 07:20:58",
"last_data": "2026-04-03 07:20:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1652862,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-03/",
"name": "dt",
"value": "2026-04-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-04 07:17:06",
"last_data": "2026-04-04 07:17:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1653076,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-04/",
"name": "dt",
"value": "2026-04-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-05 07:32:47",
"last_data": "2026-04-05 07:32:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1656584,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-05/",
"name": "dt",
"value": "2026-04-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-06 07:26:42",
"last_data": "2026-04-06 07:26:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1656796,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-06/",
"name": "dt",
"value": "2026-04-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-07 07:19:35",
"last_data": "2026-04-07 07:19:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1657026,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-07/",
"name": "dt",
"value": "2026-04-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-08 07:25:33",
"last_data": "2026-04-08 07:25:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1657434,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-08/",
"name": "dt",
"value": "2026-04-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-09 07:26:46",
"last_data": "2026-04-09 07:26:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1657649,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-09/",
"name": "dt",
"value": "2026-04-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-10 07:23:53",
"last_data": "2026-04-10 07:23:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1657871,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-10/",
"name": "dt",
"value": "2026-04-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-11 07:19:40",
"last_data": "2026-04-11 07:19:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1658076,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-11/",
"name": "dt",
"value": "2026-04-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-12 07:20:47",
"last_data": "2026-04-12 07:20:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1658285,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-12/",
"name": "dt",
"value": "2026-04-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-13 07:22:14",
"last_data": "2026-04-13 07:22:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1658507,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-13/",
"name": "dt",
"value": "2026-04-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-14 07:31:54",
"last_data": "2026-04-14 07:31:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1658718,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-14/",
"name": "dt",
"value": "2026-04-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-15 07:28:55",
"last_data": "2026-04-15 07:28:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1660129,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-15/",
"name": "dt",
"value": "2026-04-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-16 07:20:00",
"last_data": "2026-04-16 07:20:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1661347,
"location": "s3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit/dt=2026-04-16/",
"name": "dt",
"value": "2026-04-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-17 07:19:18",
"last_data": "2026-04-17 07:19:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_origin": "string",
"active": "int",
"approve": "int",
"audit_id": "bigint",
"climate_controlled": "int",
"day": "date",
"day_key": "int",
"drive_up": "int",
"facility_key": "int",
"grouping_hash": "varchar(32)",
"is_physical_unit": "int",
"length": "decimal",
"publish": "int",
"quantity": "int",
"regular_price": "decimal",
"reservation_window": "int",
"sparefoot_price": "decimal",
"unit_key": "bigint",
"unit_type_key": "int",
"vehicle": "int",
"width": "decimal"
},
"created": "2024-07-25 18:13:11",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_redshift.analytics_dwh_hist_unit`\n(\n `audit_id` bigint , `day_key` int , `day` date , `unit_key` bigint , `facility_key` int , `unit_type_key` int , `regular_price` decimal , `sparefoot_price` decimal , `quantity` int , `climate_controlled` int , `vehicle` int , `drive_up` int , `active` int , `publish` int , `approve` int , `is_physical_unit` int , `grouping_hash` varchar(32) , `reservation_window` int , `length` decimal , `width` decimal , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-prod/raw_incremental/dwh_hist_unit'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_dwh_hist_unit`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_dwh_hist_unit"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}