Schema Info
Schema Name: sfdl_stage_rds.sparefoot_sparefoot_searches
- created: 2022-11-15 02:36:28
- disabled: False
- format: raw
- id: 1490
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_stage_rds", "table": "sparefoot_sparefoot_searches" } - type: rds
Schema Versions: 1
-
Version 457886
- created: 2022-11-15 02:36:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_searches`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_searches`\n(\n `cached` smallint , `dt_partition` date , `location_id` int , `page_num` int , `search_id` string , `search_term` string , `search_time` timestamp , `search_weight_id` int , `search_weight_test_id` int , `site_id` int , `sort` string , `total_listings` int , `translated_search_term` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_searches" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches
- id: 457886
- processed: 1
- raw_data:
{ "cached": "int16", "dt_partition": "date32[day]", "location_id": "int32", "page_num": "int32", "search_id": "string", "search_term": "string", "search_time": "timestamp[ns]", "search_weight_id": "int32", "search_weight_test_id": "int32", "site_id": "int32", "sort": "string", "total_listings": "int32", "translated_search_term": "string" } - schema_attributes:
{ "cached": "smallint", "dt_partition": "date", "location_id": "int", "page_num": "int", "search_id": "string", "search_term": "string", "search_time": "timestamp", "search_weight_id": "int", "search_weight_test_id": "int", "site_id": "int", "sort": "string", "total_listings": "int", "translated_search_term": "string" } - schema_name_id: 1490
- schema_scan_id: 4322996
- updated: 2022-11-15 03:31:16
Schema Scans: 3
Last at 2026-04-17 00:15:59
-
Scan 6415105
- duration: 0:00:03.905140
- exit_message:
{ "ddl_changed": false, "partitions_applied": true, "success": true } - id: 6415105
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-16", "name": "dt", "type": "string", "value": "2026-04-16" }, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches", "key": "raw_incremental/sparefoot_searches/dt=2026-04-16/searches_2.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_searches", "type": "rds" }, "trace_context": { "parent_id": 3659968119368411632, "service_name": "sparefoot", "span_id": 12021427736470344297, "trace_id": 3659968119368411632 } } - running: False
- schema_name_id: 1490
- start_time: 2026-04-17 00:15:59
- success: True
- trace_id: 3659968119368411632
-
Scan 6414584
- duration: 0:00:03.595134
- exit_message:
{ "ddl_changed": false, "partitions_applied": true, "success": true } - id: 6414584
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-15", "name": "dt", "type": "string", "value": "2026-04-15" }, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches", "key": "raw_incremental/sparefoot_searches/dt=2026-04-15/searches_2.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_searches", "type": "rds" }, "trace_context": { "parent_id": 4800274667375973262, "service_name": "sparefoot", "span_id": 9747426544692363336, "trace_id": 4800274667375973262 } } - running: False
- schema_name_id: 1490
- start_time: 2026-04-16 00:11:42
- success: True
- trace_id: 4800274667375973262
-
Scan 4322996
- duration: 0:24:06.315054
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 4712, "partitions_applied": false, "success": true } - id: 4322996
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2022-11-14", "name": "dt", "type": "string", "value": "2022-11-14" }, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches", "key": "raw_incremental/sparefoot_searches/dt=2022-11-14/searches_1.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_searches", "type": "rds" }, "trace_context": { "parent_id": 6226556346455005982, "service_name": "sparefoot", "span_id": 17916229549027145755, "trace_id": 6226556346455005982 } } - running: False
- schema_name_id: 1490
- start_time: 2022-11-15 02:36:28
- success: True
- trace_id: 6226556346455005982
- count: 170
- ddl:
[ "ALTER TABLE\n `sfdl_stage_rds.sparefoot_sparefoot_searches`\nADD\n\n\n PARTITION (dt='2025-10-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-14/'\n PARTITION (dt='2025-10-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-15/'\n PARTITION (dt='2025-10-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-16/'\n PARTITION (dt='2025-10-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-17/'\n PARTITION (dt='2025-10-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-18/'\n PARTITION (dt='2025-10-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-19/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-20/'\n PARTITION (dt='2025-10-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-21/'\n PARTITION (dt='2025-10-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-22/'\n PARTITION (dt='2025-10-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-23/'\n PARTITION (dt='2025-10-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-24/'\n PARTITION (dt='2025-10-25') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-25/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-26/'\n PARTITION (dt='2025-10-27') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-27/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-28/'\n PARTITION (dt='2025-10-29') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-29/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-30/'\n PARTITION (dt='2025-10-31') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-31/'\n PARTITION (dt='2025-11-01') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-01/'\n PARTITION (dt='2025-11-02') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-02/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-04/'\n PARTITION (dt='2025-11-05') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-05/'\n PARTITION (dt='2025-11-06') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-06/'\n PARTITION (dt='2025-11-07') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-07/'\n PARTITION (dt='2025-11-08') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-08/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-09/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-10/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-12/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-13/'\n PARTITION (dt='2025-11-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-14/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-15/'\n PARTITION (dt='2025-11-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-16/'\n PARTITION (dt='2025-11-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-17/'\n PARTITION (dt='2025-11-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-18/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-19/'\n PARTITION (dt='2025-11-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-20/'\n PARTITION (dt='2025-11-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-21/'\n PARTITION (dt='2025-11-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-22/'\n PARTITION (dt='2025-11-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-23/'\n PARTITION (dt='2025-11-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-24/'\n PARTITION (dt='2025-12-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-10/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-12/'\n PARTITION (dt='2025-12-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-13/'\n PARTITION (dt='2025-12-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-14/'\n PARTITION (dt='2025-12-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-15/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-16/'\n PARTITION (dt='2025-12-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-17/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-19/'\n PARTITION (dt='2025-12-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-20/'\n PARTITION (dt='2025-12-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-21/'\n PARTITION (dt='2025-12-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-22/'\n PARTITION (dt='2025-12-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-23/'\n PARTITION (dt='2025-12-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-24/'\n PARTITION (dt='2025-12-25') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-25/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-26/'\n PARTITION (dt='2025-12-27') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-27/'\n PARTITION (dt='2025-12-28') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-28/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-31/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-01/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-02/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-03/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-04/'\n PARTITION (dt='2026-01-05') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-08/'\n PARTITION (dt='2026-01-09') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-09/'\n PARTITION (dt='2026-01-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-10/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-11/'\n PARTITION (dt='2026-01-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-12/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-13/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-14/'\n PARTITION (dt='2026-01-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-15/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-16/'\n PARTITION (dt='2026-01-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-17/'\n PARTITION (dt='2026-01-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-18/'\n PARTITION (dt='2026-01-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-19/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-20/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-21/'\n PARTITION (dt='2026-01-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-22/'\n PARTITION (dt='2026-01-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-23/'\n PARTITION (dt='2026-01-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-24/'\n PARTITION (dt='2026-01-25') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-25/'\n PARTITION (dt='2026-01-26') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-28/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-29/'\n PARTITION (dt='2026-01-30') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-30/'\n PARTITION (dt='2026-01-31') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-31/'\n PARTITION (dt='2026-02-01') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-01/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-04/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-05/'\n PARTITION (dt='2026-02-06') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-06/'\n PARTITION (dt='2026-02-07') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-07/'\n PARTITION (dt='2026-02-08') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-08/'\n PARTITION (dt='2026-02-09') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-09/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-11/'\n PARTITION (dt='2026-02-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-12/'\n PARTITION (dt='2026-02-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-13/'\n PARTITION (dt='2026-02-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-14/'\n PARTITION (dt='2026-02-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-15/'\n PARTITION (dt='2026-02-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-16/'\n PARTITION (dt='2026-02-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-17/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-18/'\n PARTITION (dt='2026-02-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-19/'\n PARTITION (dt='2026-02-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-20/'\n PARTITION (dt='2026-02-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-21/'\n PARTITION (dt='2026-02-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-22/'\n PARTITION (dt='2026-02-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-23/'\n PARTITION (dt='2026-02-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-24/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-25/'\n PARTITION (dt='2026-02-26') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-26/'\n PARTITION (dt='2026-02-27') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-27/'\n PARTITION (dt='2026-02-28') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-28/'\n PARTITION (dt='2026-03-01') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-01/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-02/'\n PARTITION (dt='2026-03-03') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-03/'\n PARTITION (dt='2026-03-04') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-04/'\n PARTITION (dt='2026-03-05') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-05/'\n PARTITION (dt='2026-03-06') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-06/'\n PARTITION (dt='2026-03-07') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-07/'\n PARTITION (dt='2026-03-08') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-08/'\n PARTITION (dt='2026-03-09') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-09/'\n PARTITION (dt='2026-03-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-10/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-11/'\n PARTITION (dt='2026-03-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-12/'\n PARTITION (dt='2026-03-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-13/'\n PARTITION (dt='2026-03-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-14/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-15/'\n PARTITION (dt='2026-03-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-16/'\n PARTITION (dt='2026-03-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-17/'\n PARTITION (dt='2026-03-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-18/'\n PARTITION (dt='2026-03-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-19/'\n PARTITION (dt='2026-03-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-20/'\n PARTITION (dt='2026-03-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-21/'\n PARTITION (dt='2026-03-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-22/'\n PARTITION (dt='2026-03-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-23/'\n PARTITION (dt='2026-03-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-24/'\n PARTITION (dt='2026-03-25') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-25/'\n PARTITION (dt='2026-03-26') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-26/'\n PARTITION (dt='2026-03-27') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-27/'\n PARTITION (dt='2026-03-28') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-28/'\n PARTITION (dt='2026-03-29') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-29/'\n PARTITION (dt='2026-03-30') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-30/'\n PARTITION (dt='2026-03-31') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-31/'\n PARTITION (dt='2026-04-01') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-01/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-02/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-03/'\n PARTITION (dt='2026-04-04') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-04/'\n PARTITION (dt='2026-04-05') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-05/'\n PARTITION (dt='2026-04-06') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-06/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-07/'\n PARTITION (dt='2026-04-08') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-08/'\n PARTITION (dt='2026-04-09') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-09/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-10/'\n PARTITION (dt='2026-04-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-11/'\n PARTITION (dt='2026-04-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-12/'\n PARTITION (dt='2026-04-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-13/'\n PARTITION (dt='2026-04-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-14/'\n PARTITION (dt='2026-04-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-15/'\n PARTITION (dt='2026-04-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-16/'\n;" ] - name: dt
- state:
[ { "info": { "id": 650138, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-14/", "name": "dt", "value": "2025-10-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-15 00:07:18", "last_data": "2025-10-15 00:07:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650253, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-15/", "name": "dt", "value": "2025-10-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-16 00:07:12", "last_data": "2025-10-16 00:07:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650368, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-16/", "name": "dt", "value": "2025-10-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-17 00:06:58", "last_data": "2025-10-17 00:06:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650484, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-17/", "name": "dt", "value": "2025-10-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-18 00:07:18", "last_data": "2025-10-18 00:07:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650599, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-18/", "name": "dt", "value": "2025-10-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-19 00:08:19", "last_data": "2025-10-19 00:08:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650712, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-19/", "name": "dt", "value": "2025-10-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-20 00:06:59", "last_data": "2025-10-20 00:06:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650829, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-20/", "name": "dt", "value": "2025-10-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-21 00:07:44", "last_data": "2025-10-21 00:07:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650942, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-21/", "name": "dt", "value": "2025-10-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-22 00:07:43", "last_data": "2025-10-22 00:07:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651056, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-22/", "name": "dt", "value": "2025-10-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-23 00:07:43", "last_data": "2025-10-23 00:07:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651168, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-23/", "name": "dt", "value": "2025-10-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-24 00:08:19", "last_data": "2025-10-24 00:08:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651281, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-24/", "name": "dt", "value": "2025-10-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-25 00:09:21", "last_data": "2025-10-25 00:09:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651394, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-25/", "name": "dt", "value": "2025-10-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-26 00:08:03", "last_data": "2025-10-26 00:08:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651506, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-26/", "name": "dt", "value": "2025-10-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-27 00:08:50", "last_data": "2025-10-27 00:08:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651628, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-27/", "name": "dt", "value": "2025-10-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-28 00:09:13", "last_data": "2025-10-28 00:09:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651741, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-28/", "name": "dt", "value": "2025-10-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-29 00:09:53", "last_data": "2025-10-29 00:09:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651856, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-29/", "name": "dt", "value": "2025-10-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-30 00:07:56", "last_data": "2025-10-30 00:07:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651967, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-30/", "name": "dt", "value": "2025-10-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-31 00:08:06", "last_data": "2025-10-31 00:08:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652078, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-31/", "name": "dt", "value": "2025-10-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-01 00:08:11", "last_data": "2025-11-01 00:08:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652198, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-01/", "name": "dt", "value": "2025-11-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-02 00:08:00", "last_data": "2025-11-02 00:08:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652309, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-02/", "name": "dt", "value": "2025-11-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-03 00:09:44", "last_data": "2025-11-03 00:09:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652430, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-03/", "name": "dt", "value": "2025-11-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-04 00:08:56", "last_data": "2025-11-04 00:08:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652544, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-04/", "name": "dt", "value": "2025-11-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-05 00:10:04", "last_data": "2025-11-05 00:10:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652656, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-05/", "name": "dt", "value": "2025-11-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-06 00:09:22", "last_data": "2025-11-06 00:09:22" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652768, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-06/", "name": "dt", "value": "2025-11-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-07 00:08:44", "last_data": "2025-11-07 00:08:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652880, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-07/", "name": "dt", "value": "2025-11-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-08 00:09:47", "last_data": "2025-11-08 00:09:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652991, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-08/", "name": "dt", "value": "2025-11-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-09 00:07:15", "last_data": "2025-11-09 00:07:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653107, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-09/", "name": "dt", "value": "2025-11-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-10 00:06:18", "last_data": "2025-11-10 00:06:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653225, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-10/", "name": "dt", "value": "2025-11-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-11 00:07:11", "last_data": "2025-11-11 00:07:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653338, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-11/", "name": "dt", "value": "2025-11-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-12 00:09:48", "last_data": "2025-11-12 00:09:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653460, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-12/", "name": "dt", "value": "2025-11-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-13 00:07:44", "last_data": "2025-11-13 00:07:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653573, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-13/", "name": "dt", "value": "2025-11-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-14 00:07:17", "last_data": "2025-11-14 00:07:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653685, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-14/", "name": "dt", "value": "2025-11-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-15 00:07:08", "last_data": "2025-11-15 00:07:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653795, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-15/", "name": "dt", "value": "2025-11-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-16 00:07:45", "last_data": "2025-11-16 00:07:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653908, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-16/", "name": "dt", "value": "2025-11-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-17 00:08:22", "last_data": "2025-11-17 00:08:22" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656084, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-17/", "name": "dt", "value": "2025-11-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-18 00:07:44", "last_data": "2025-11-18 00:07:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656198, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-18/", "name": "dt", "value": "2025-11-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-19 00:07:31", "last_data": "2025-11-19 00:07:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656314, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-19/", "name": "dt", "value": "2025-11-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-20 00:07:35", "last_data": "2025-11-20 00:07:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656428, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-20/", "name": "dt", "value": "2025-11-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-21 00:07:47", "last_data": "2025-11-21 00:07:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656540, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-21/", "name": "dt", "value": "2025-11-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-22 00:07:07", "last_data": "2025-11-22 00:07:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656650, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-22/", "name": "dt", "value": "2025-11-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-23 00:06:58", "last_data": "2025-11-23 00:06:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656761, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-23/", "name": "dt", "value": "2025-11-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-24 00:07:14", "last_data": "2025-11-24 00:07:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656883, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-24/", "name": "dt", "value": "2025-11-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-25 00:07:29", "last_data": "2025-11-25 00:07:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657404, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-10/", "name": "dt", "value": "2025-12-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-11 00:07:43", "last_data": "2025-12-11 00:07:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657525, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-11/", "name": "dt", "value": "2025-12-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-12 00:08:22", "last_data": "2025-12-12 00:08:22" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657642, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-12/", "name": "dt", "value": "2025-12-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-13 00:08:07", "last_data": "2025-12-13 00:08:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657756, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-13/", "name": "dt", "value": "2025-12-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-14 00:07:13", "last_data": "2025-12-14 00:07:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657868, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-14/", "name": "dt", "value": "2025-12-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-15 00:12:36", "last_data": "2025-12-15 00:12:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657991, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-15/", "name": "dt", "value": "2025-12-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-16 00:08:24", "last_data": "2025-12-16 00:08:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658107, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-16/", "name": "dt", "value": "2025-12-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-17 00:07:06", "last_data": "2025-12-17 00:07:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658225, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-17/", "name": "dt", "value": "2025-12-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-18 00:08:26", "last_data": "2025-12-18 00:08:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658339, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-18/", "name": "dt", "value": "2025-12-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-19 00:07:44", "last_data": "2025-12-19 00:07:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658456, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-19/", "name": "dt", "value": "2025-12-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-20 00:07:55", "last_data": "2025-12-20 00:07:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658570, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-20/", "name": "dt", "value": "2025-12-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-21 00:07:26", "last_data": "2025-12-21 00:07:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658685, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-21/", "name": "dt", "value": "2025-12-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-22 00:06:53", "last_data": "2025-12-22 00:06:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658855, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-22/", "name": "dt", "value": "2025-12-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-23 00:07:14", "last_data": "2025-12-23 00:07:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658971, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-23/", "name": "dt", "value": "2025-12-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-24 00:07:38", "last_data": "2025-12-24 00:07:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659090, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-24/", "name": "dt", "value": "2025-12-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-25 00:07:27", "last_data": "2025-12-25 00:07:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659204, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-25/", "name": "dt", "value": "2025-12-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-26 00:06:29", "last_data": "2025-12-26 00:06:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659319, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-26/", "name": "dt", "value": "2025-12-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-27 00:07:28", "last_data": "2025-12-27 00:07:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659434, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-27/", "name": "dt", "value": "2025-12-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-28 00:07:57", "last_data": "2025-12-28 00:07:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659549, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-28/", "name": "dt", "value": "2025-12-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-29 00:08:47", "last_data": "2025-12-29 00:08:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659669, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-29/", "name": "dt", "value": "2025-12-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-30 00:08:09", "last_data": "2025-12-30 00:08:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659786, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-30/", "name": "dt", "value": "2025-12-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-31 00:07:31", "last_data": "2025-12-31 00:07:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659904, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-31/", "name": "dt", "value": "2025-12-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-01 00:07:38", "last_data": "2026-01-01 00:07:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660032, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-01/", "name": "dt", "value": "2026-01-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-02 00:07:42", "last_data": "2026-01-02 00:07:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660149, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-02/", "name": "dt", "value": "2026-01-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-03 00:07:47", "last_data": "2026-01-03 00:07:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660264, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-03/", "name": "dt", "value": "2026-01-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-04 00:07:03", "last_data": "2026-01-04 00:07:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660381, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-04/", "name": "dt", "value": "2026-01-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-05 00:07:33", "last_data": "2026-01-05 00:07:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660499, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-05/", "name": "dt", "value": "2026-01-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-06 00:07:02", "last_data": "2026-01-06 00:07:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660617, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-06/", "name": "dt", "value": "2026-01-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-07 00:07:16", "last_data": "2026-01-07 00:07:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660735, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-07/", "name": "dt", "value": "2026-01-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-08 00:09:02", "last_data": "2026-01-08 00:09:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660853, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-08/", "name": "dt", "value": "2026-01-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-09 00:07:54", "last_data": "2026-01-09 00:07:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660970, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-09/", "name": "dt", "value": "2026-01-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-10 00:08:08", "last_data": "2026-01-10 00:08:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661085, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-10/", "name": "dt", "value": "2026-01-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-11 00:08:47", "last_data": "2026-01-11 00:08:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661202, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-11/", "name": "dt", "value": "2026-01-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-12 00:08:29", "last_data": "2026-01-12 00:08:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661321, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-12/", "name": "dt", "value": "2026-01-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-13 00:09:06", "last_data": "2026-01-13 00:09:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661435, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-13/", "name": "dt", "value": "2026-01-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-14 00:10:24", "last_data": "2026-01-14 00:10:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661554, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-14/", "name": "dt", "value": "2026-01-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-15 00:09:09", "last_data": "2026-01-15 00:09:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661671, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-15/", "name": "dt", "value": "2026-01-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-16 00:08:29", "last_data": "2026-01-16 00:08:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661790, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-16/", "name": "dt", "value": "2026-01-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-17 00:10:42", "last_data": "2026-01-17 00:10:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661902, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-17/", "name": "dt", "value": "2026-01-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-18 00:10:21", "last_data": "2026-01-18 00:10:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662019, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-18/", "name": "dt", "value": "2026-01-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-19 00:09:42", "last_data": "2026-01-19 00:09:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662139, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-19/", "name": "dt", "value": "2026-01-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-20 00:10:12", "last_data": "2026-01-20 00:10:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662254, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-20/", "name": "dt", "value": "2026-01-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-21 00:07:46", "last_data": "2026-01-21 00:07:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662426, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-21/", "name": "dt", "value": "2026-01-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-22 00:07:56", "last_data": "2026-01-22 00:07:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662541, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-22/", "name": "dt", "value": "2026-01-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-23 00:09:45", "last_data": "2026-01-23 00:09:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662660, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-23/", "name": "dt", "value": "2026-01-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-24 00:07:59", "last_data": "2026-01-24 00:07:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662775, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-24/", "name": "dt", "value": "2026-01-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-25 00:07:45", "last_data": "2026-01-25 00:07:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662891, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-25/", "name": "dt", "value": "2026-01-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-26 00:07:23", "last_data": "2026-01-26 00:07:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 663011, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-26/", "name": "dt", "value": "2026-01-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-27 00:10:21", "last_data": "2026-01-27 00:10:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 663128, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-27/", "name": "dt", "value": "2026-01-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-28 00:07:49", "last_data": "2026-01-28 00:07:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 663244, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-28/", "name": "dt", "value": "2026-01-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-29 00:07:33", "last_data": "2026-01-29 00:07:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666088, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-29/", "name": "dt", "value": "2026-01-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-30 00:08:22", "last_data": "2026-01-30 00:08:22" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666206, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-30/", "name": "dt", "value": "2026-01-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-31 00:08:34", "last_data": "2026-01-31 00:08:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666323, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-31/", "name": "dt", "value": "2026-01-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-01 00:08:27", "last_data": "2026-02-01 00:08:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666455, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-01/", "name": "dt", "value": "2026-02-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-02 00:07:37", "last_data": "2026-02-02 00:07:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666574, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-02/", "name": "dt", "value": "2026-02-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-03 00:08:35", "last_data": "2026-02-03 00:08:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666693, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-03/", "name": "dt", "value": "2026-02-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-04 00:08:16", "last_data": "2026-02-04 00:08:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666812, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-04/", "name": "dt", "value": "2026-02-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-05 00:08:45", "last_data": "2026-02-05 00:08:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666928, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-05/", "name": "dt", "value": "2026-02-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-06 00:07:40", "last_data": "2026-02-06 00:07:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667043, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-06/", "name": "dt", "value": "2026-02-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-07 00:07:03", "last_data": "2026-02-07 00:07:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667157, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-07/", "name": "dt", "value": "2026-02-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-08 00:08:04", "last_data": "2026-02-08 00:08:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667271, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-08/", "name": "dt", "value": "2026-02-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-09 00:10:16", "last_data": "2026-02-09 00:10:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667388, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-09/", "name": "dt", "value": "2026-02-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-10 00:08:59", "last_data": "2026-02-10 00:08:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667507, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-10/", "name": "dt", "value": "2026-02-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-11 00:08:47", "last_data": "2026-02-11 00:08:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667627, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-11/", "name": "dt", "value": "2026-02-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-12 00:08:30", "last_data": "2026-02-12 00:08:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667744, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-12/", "name": "dt", "value": "2026-02-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-13 00:07:51", "last_data": "2026-02-13 00:07:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667862, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-13/", "name": "dt", "value": "2026-02-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-14 00:07:39", "last_data": "2026-02-14 00:07:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667976, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-14/", "name": "dt", "value": "2026-02-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-15 00:07:55", "last_data": "2026-02-15 00:07:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668091, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-15/", "name": "dt", "value": "2026-02-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-16 00:09:05", "last_data": "2026-02-16 00:09:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668211, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-16/", "name": "dt", "value": "2026-02-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-17 00:08:08", "last_data": "2026-02-17 00:08:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668332, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-17/", "name": "dt", "value": "2026-02-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-18 00:08:03", "last_data": "2026-02-18 00:08:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668450, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-18/", "name": "dt", "value": "2026-02-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-19 00:09:17", "last_data": "2026-02-19 00:09:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668568, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-19/", "name": "dt", "value": "2026-02-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-20 00:09:03", "last_data": "2026-02-20 00:09:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668683, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-20/", "name": "dt", "value": "2026-02-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-21 00:10:44", "last_data": "2026-02-21 00:10:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668800, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-21/", "name": "dt", "value": "2026-02-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-22 00:10:03", "last_data": "2026-02-22 00:10:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668915, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-22/", "name": "dt", "value": "2026-02-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-23 00:08:01", "last_data": "2026-02-23 00:08:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669034, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-23/", "name": "dt", "value": "2026-02-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-24 00:08:47", "last_data": "2026-02-24 00:08:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669152, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-24/", "name": "dt", "value": "2026-02-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-25 00:08:34", "last_data": "2026-02-25 00:08:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669271, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-25/", "name": "dt", "value": "2026-02-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-26 00:09:59", "last_data": "2026-02-26 00:09:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669388, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-26/", "name": "dt", "value": "2026-02-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-27 00:08:38", "last_data": "2026-02-27 00:08:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669505, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-27/", "name": "dt", "value": "2026-02-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-28 00:08:34", "last_data": "2026-02-28 00:08:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669619, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-28/", "name": "dt", "value": "2026-02-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-01 00:08:14", "last_data": "2026-03-01 00:08:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669745, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-01/", "name": "dt", "value": "2026-03-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-02 00:08:42", "last_data": "2026-03-02 00:08:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669864, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-02/", "name": "dt", "value": "2026-03-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-03 00:08:42", "last_data": "2026-03-03 00:08:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669982, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-03/", "name": "dt", "value": "2026-03-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-04 00:09:32", "last_data": "2026-03-04 00:09:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670140, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-04/", "name": "dt", "value": "2026-03-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-05 00:08:52", "last_data": "2026-03-05 00:08:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670258, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-05/", "name": "dt", "value": "2026-03-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-06 00:09:06", "last_data": "2026-03-06 00:09:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670377, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-06/", "name": "dt", "value": "2026-03-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-07 00:09:07", "last_data": "2026-03-07 00:09:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670491, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-07/", "name": "dt", "value": "2026-03-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-08 00:09:18", "last_data": "2026-03-08 00:09:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670608, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-08/", "name": "dt", "value": "2026-03-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-09 00:09:09", "last_data": "2026-03-09 00:09:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670727, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-09/", "name": "dt", "value": "2026-03-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-10 00:10:29", "last_data": "2026-03-10 00:10:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670845, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-10/", "name": "dt", "value": "2026-03-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-11 00:32:40", "last_data": "2026-03-11 00:32:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670963, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-11/", "name": "dt", "value": "2026-03-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-12 00:07:51", "last_data": "2026-03-12 00:07:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671081, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-12/", "name": "dt", "value": "2026-03-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-13 00:08:12", "last_data": "2026-03-13 00:08:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671199, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-13/", "name": "dt", "value": "2026-03-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-14 00:08:28", "last_data": "2026-03-14 00:08:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671314, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-14/", "name": "dt", "value": "2026-03-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-15 00:09:39", "last_data": "2026-03-15 00:09:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671429, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-15/", "name": "dt", "value": "2026-03-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-16 00:09:45", "last_data": "2026-03-16 00:09:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671550, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-16/", "name": "dt", "value": "2026-03-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-17 00:08:26", "last_data": "2026-03-17 00:08:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671665, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-17/", "name": "dt", "value": "2026-03-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-18 00:08:19", "last_data": "2026-03-18 00:08:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671785, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-18/", "name": "dt", "value": "2026-03-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-19 00:09:41", "last_data": "2026-03-19 00:09:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671901, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-19/", "name": "dt", "value": "2026-03-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-20 00:08:06", "last_data": "2026-03-20 00:08:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672019, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-20/", "name": "dt", "value": "2026-03-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-21 00:09:11", "last_data": "2026-03-21 00:09:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672135, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-21/", "name": "dt", "value": "2026-03-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-22 00:10:41", "last_data": "2026-03-22 00:10:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672252, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-22/", "name": "dt", "value": "2026-03-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-23 00:09:27", "last_data": "2026-03-23 00:09:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672374, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-23/", "name": "dt", "value": "2026-03-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-24 00:08:28", "last_data": "2026-03-24 00:08:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672494, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-24/", "name": "dt", "value": "2026-03-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-25 00:09:12", "last_data": "2026-03-25 00:09:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672611, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-25/", "name": "dt", "value": "2026-03-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-26 00:10:25", "last_data": "2026-03-26 00:10:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672727, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-26/", "name": "dt", "value": "2026-03-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-27 00:08:34", "last_data": "2026-03-27 00:08:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672845, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-27/", "name": "dt", "value": "2026-03-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-28 00:09:31", "last_data": "2026-03-28 00:09:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672961, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-28/", "name": "dt", "value": "2026-03-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-29 00:09:21", "last_data": "2026-03-29 00:09:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673078, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-29/", "name": "dt", "value": "2026-03-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-30 00:10:59", "last_data": "2026-03-30 00:10:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673198, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-30/", "name": "dt", "value": "2026-03-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-31 00:09:57", "last_data": "2026-03-31 00:09:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673316, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-31/", "name": "dt", "value": "2026-03-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-01 00:08:58", "last_data": "2026-04-01 00:08:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673483, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-01/", "name": "dt", "value": "2026-04-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-02 00:09:31", "last_data": "2026-04-02 00:09:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673597, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-02/", "name": "dt", "value": "2026-04-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-03 00:09:42", "last_data": "2026-04-03 00:09:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673714, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-03/", "name": "dt", "value": "2026-04-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-04 00:08:58", "last_data": "2026-04-04 00:08:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673828, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-04/", "name": "dt", "value": "2026-04-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-05 00:09:09", "last_data": "2026-04-05 00:09:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673943, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-05/", "name": "dt", "value": "2026-04-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-06 00:07:44", "last_data": "2026-04-06 00:07:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674064, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-06/", "name": "dt", "value": "2026-04-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-07 00:10:55", "last_data": "2026-04-07 00:10:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674181, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-07/", "name": "dt", "value": "2026-04-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-08 00:10:16", "last_data": "2026-04-08 00:10:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674299, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-08/", "name": "dt", "value": "2026-04-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-09 00:12:06", "last_data": "2026-04-09 00:12:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674418, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-09/", "name": "dt", "value": "2026-04-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-10 00:09:42", "last_data": "2026-04-10 00:09:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674535, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-10/", "name": "dt", "value": "2026-04-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-11 00:08:52", "last_data": "2026-04-11 00:08:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674650, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-11/", "name": "dt", "value": "2026-04-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-12 00:09:05", "last_data": "2026-04-12 00:09:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674767, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-12/", "name": "dt", "value": "2026-04-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-13 00:12:06", "last_data": "2026-04-13 00:12:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674886, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-13/", "name": "dt", "value": "2026-04-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-14 00:10:07", "last_data": "2026-04-14 00:10:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 675002, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-14/", "name": "dt", "value": "2026-04-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-15 00:08:34", "last_data": "2026-04-15 00:08:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 675122, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-15/", "name": "dt", "value": "2026-04-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-16 00:11:43", "last_data": "2026-04-16 00:11:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 675261, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-16/", "name": "dt", "value": "2026-04-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-17 00:16:00", "last_data": "2026-04-17 00:16:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } } ] - type: string
- attributes:
{ "cached": "smallint", "dt_partition": "date", "location_id": "int", "page_num": "int", "search_id": "string", "search_term": "string", "search_time": "timestamp", "search_weight_id": "int", "search_weight_test_id": "int", "site_id": "int", "sort": "string", "total_listings": "int", "translated_search_term": "string" } - created: 2022-11-15 02:36:28
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_searches`\n(\n `cached` smallint , `dt_partition` date , `location_id` int , `page_num` int , `search_id` string , `search_term` string , `search_time` timestamp , `search_weight_id` int , `search_weight_test_id` int , `site_id` int , `sort` string , `total_listings` int , `translated_search_term` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_searches`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_searches" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2022-11-15 02:36:28",
"disabled": false,
"format": "raw",
"id": 1490,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_stage_rds",
"table": "sparefoot_sparefoot_searches"
},
"type": "rds"
},
"partition": {
"count": 170,
"ddl": [
"ALTER TABLE\n `sfdl_stage_rds.sparefoot_sparefoot_searches`\nADD\n\n\n PARTITION (dt='2025-10-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-14/'\n PARTITION (dt='2025-10-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-15/'\n PARTITION (dt='2025-10-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-16/'\n PARTITION (dt='2025-10-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-17/'\n PARTITION (dt='2025-10-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-18/'\n PARTITION (dt='2025-10-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-19/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-20/'\n PARTITION (dt='2025-10-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-21/'\n PARTITION (dt='2025-10-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-22/'\n PARTITION (dt='2025-10-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-23/'\n PARTITION (dt='2025-10-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-24/'\n PARTITION (dt='2025-10-25') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-25/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-26/'\n PARTITION (dt='2025-10-27') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-27/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-28/'\n PARTITION (dt='2025-10-29') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-29/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-30/'\n PARTITION (dt='2025-10-31') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-31/'\n PARTITION (dt='2025-11-01') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-01/'\n PARTITION (dt='2025-11-02') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-02/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-04/'\n PARTITION (dt='2025-11-05') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-05/'\n PARTITION (dt='2025-11-06') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-06/'\n PARTITION (dt='2025-11-07') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-07/'\n PARTITION (dt='2025-11-08') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-08/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-09/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-10/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-12/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-13/'\n PARTITION (dt='2025-11-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-14/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-15/'\n PARTITION (dt='2025-11-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-16/'\n PARTITION (dt='2025-11-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-17/'\n PARTITION (dt='2025-11-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-18/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-19/'\n PARTITION (dt='2025-11-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-20/'\n PARTITION (dt='2025-11-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-21/'\n PARTITION (dt='2025-11-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-22/'\n PARTITION (dt='2025-11-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-23/'\n PARTITION (dt='2025-11-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-24/'\n PARTITION (dt='2025-12-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-10/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-12/'\n PARTITION (dt='2025-12-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-13/'\n PARTITION (dt='2025-12-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-14/'\n PARTITION (dt='2025-12-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-15/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-16/'\n PARTITION (dt='2025-12-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-17/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-19/'\n PARTITION (dt='2025-12-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-20/'\n PARTITION (dt='2025-12-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-21/'\n PARTITION (dt='2025-12-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-22/'\n PARTITION (dt='2025-12-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-23/'\n PARTITION (dt='2025-12-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-24/'\n PARTITION (dt='2025-12-25') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-25/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-26/'\n PARTITION (dt='2025-12-27') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-27/'\n PARTITION (dt='2025-12-28') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-28/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-31/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-01/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-02/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-03/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-04/'\n PARTITION (dt='2026-01-05') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-08/'\n PARTITION (dt='2026-01-09') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-09/'\n PARTITION (dt='2026-01-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-10/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-11/'\n PARTITION (dt='2026-01-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-12/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-13/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-14/'\n PARTITION (dt='2026-01-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-15/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-16/'\n PARTITION (dt='2026-01-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-17/'\n PARTITION (dt='2026-01-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-18/'\n PARTITION (dt='2026-01-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-19/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-20/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-21/'\n PARTITION (dt='2026-01-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-22/'\n PARTITION (dt='2026-01-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-23/'\n PARTITION (dt='2026-01-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-24/'\n PARTITION (dt='2026-01-25') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-25/'\n PARTITION (dt='2026-01-26') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-28/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-29/'\n PARTITION (dt='2026-01-30') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-30/'\n PARTITION (dt='2026-01-31') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-31/'\n PARTITION (dt='2026-02-01') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-01/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-04/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-05/'\n PARTITION (dt='2026-02-06') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-06/'\n PARTITION (dt='2026-02-07') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-07/'\n PARTITION (dt='2026-02-08') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-08/'\n PARTITION (dt='2026-02-09') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-09/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-11/'\n PARTITION (dt='2026-02-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-12/'\n PARTITION (dt='2026-02-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-13/'\n PARTITION (dt='2026-02-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-14/'\n PARTITION (dt='2026-02-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-15/'\n PARTITION (dt='2026-02-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-16/'\n PARTITION (dt='2026-02-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-17/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-18/'\n PARTITION (dt='2026-02-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-19/'\n PARTITION (dt='2026-02-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-20/'\n PARTITION (dt='2026-02-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-21/'\n PARTITION (dt='2026-02-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-22/'\n PARTITION (dt='2026-02-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-23/'\n PARTITION (dt='2026-02-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-24/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-25/'\n PARTITION (dt='2026-02-26') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-26/'\n PARTITION (dt='2026-02-27') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-27/'\n PARTITION (dt='2026-02-28') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-28/'\n PARTITION (dt='2026-03-01') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-01/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-02/'\n PARTITION (dt='2026-03-03') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-03/'\n PARTITION (dt='2026-03-04') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-04/'\n PARTITION (dt='2026-03-05') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-05/'\n PARTITION (dt='2026-03-06') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-06/'\n PARTITION (dt='2026-03-07') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-07/'\n PARTITION (dt='2026-03-08') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-08/'\n PARTITION (dt='2026-03-09') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-09/'\n PARTITION (dt='2026-03-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-10/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-11/'\n PARTITION (dt='2026-03-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-12/'\n PARTITION (dt='2026-03-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-13/'\n PARTITION (dt='2026-03-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-14/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-15/'\n PARTITION (dt='2026-03-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-16/'\n PARTITION (dt='2026-03-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-17/'\n PARTITION (dt='2026-03-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-18/'\n PARTITION (dt='2026-03-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-19/'\n PARTITION (dt='2026-03-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-20/'\n PARTITION (dt='2026-03-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-21/'\n PARTITION (dt='2026-03-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-22/'\n PARTITION (dt='2026-03-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-23/'\n PARTITION (dt='2026-03-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-24/'\n PARTITION (dt='2026-03-25') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-25/'\n PARTITION (dt='2026-03-26') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-26/'\n PARTITION (dt='2026-03-27') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-27/'\n PARTITION (dt='2026-03-28') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-28/'\n PARTITION (dt='2026-03-29') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-29/'\n PARTITION (dt='2026-03-30') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-30/'\n PARTITION (dt='2026-03-31') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-31/'\n PARTITION (dt='2026-04-01') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-01/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-02/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-03/'\n PARTITION (dt='2026-04-04') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-04/'\n PARTITION (dt='2026-04-05') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-05/'\n PARTITION (dt='2026-04-06') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-06/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-07/'\n PARTITION (dt='2026-04-08') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-08/'\n PARTITION (dt='2026-04-09') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-09/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-10/'\n PARTITION (dt='2026-04-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-11/'\n PARTITION (dt='2026-04-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-12/'\n PARTITION (dt='2026-04-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-13/'\n PARTITION (dt='2026-04-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-14/'\n PARTITION (dt='2026-04-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-15/'\n PARTITION (dt='2026-04-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-16/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 650138,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-14/",
"name": "dt",
"value": "2025-10-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-15 00:07:18",
"last_data": "2025-10-15 00:07:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650253,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-15/",
"name": "dt",
"value": "2025-10-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-16 00:07:12",
"last_data": "2025-10-16 00:07:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650368,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-16/",
"name": "dt",
"value": "2025-10-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-17 00:06:58",
"last_data": "2025-10-17 00:06:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650484,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-17/",
"name": "dt",
"value": "2025-10-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-18 00:07:18",
"last_data": "2025-10-18 00:07:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650599,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-18/",
"name": "dt",
"value": "2025-10-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-19 00:08:19",
"last_data": "2025-10-19 00:08:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650712,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-19/",
"name": "dt",
"value": "2025-10-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-20 00:06:59",
"last_data": "2025-10-20 00:06:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650829,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-20/",
"name": "dt",
"value": "2025-10-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-21 00:07:44",
"last_data": "2025-10-21 00:07:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650942,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-21/",
"name": "dt",
"value": "2025-10-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-22 00:07:43",
"last_data": "2025-10-22 00:07:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651056,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-22/",
"name": "dt",
"value": "2025-10-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-23 00:07:43",
"last_data": "2025-10-23 00:07:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651168,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-23/",
"name": "dt",
"value": "2025-10-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-24 00:08:19",
"last_data": "2025-10-24 00:08:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651281,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-24/",
"name": "dt",
"value": "2025-10-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-25 00:09:21",
"last_data": "2025-10-25 00:09:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651394,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-25/",
"name": "dt",
"value": "2025-10-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-26 00:08:03",
"last_data": "2025-10-26 00:08:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651506,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-26/",
"name": "dt",
"value": "2025-10-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-27 00:08:50",
"last_data": "2025-10-27 00:08:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651628,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-27/",
"name": "dt",
"value": "2025-10-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-28 00:09:13",
"last_data": "2025-10-28 00:09:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651741,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-28/",
"name": "dt",
"value": "2025-10-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-29 00:09:53",
"last_data": "2025-10-29 00:09:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651856,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-29/",
"name": "dt",
"value": "2025-10-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-30 00:07:56",
"last_data": "2025-10-30 00:07:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651967,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-30/",
"name": "dt",
"value": "2025-10-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-31 00:08:06",
"last_data": "2025-10-31 00:08:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652078,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-10-31/",
"name": "dt",
"value": "2025-10-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-01 00:08:11",
"last_data": "2025-11-01 00:08:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652198,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-01/",
"name": "dt",
"value": "2025-11-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-02 00:08:00",
"last_data": "2025-11-02 00:08:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652309,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-02/",
"name": "dt",
"value": "2025-11-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-03 00:09:44",
"last_data": "2025-11-03 00:09:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652430,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-03/",
"name": "dt",
"value": "2025-11-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-04 00:08:56",
"last_data": "2025-11-04 00:08:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652544,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-04/",
"name": "dt",
"value": "2025-11-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-05 00:10:04",
"last_data": "2025-11-05 00:10:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652656,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-05/",
"name": "dt",
"value": "2025-11-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-06 00:09:22",
"last_data": "2025-11-06 00:09:22"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652768,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-06/",
"name": "dt",
"value": "2025-11-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-07 00:08:44",
"last_data": "2025-11-07 00:08:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652880,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-07/",
"name": "dt",
"value": "2025-11-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-08 00:09:47",
"last_data": "2025-11-08 00:09:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652991,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-08/",
"name": "dt",
"value": "2025-11-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-09 00:07:15",
"last_data": "2025-11-09 00:07:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653107,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-09/",
"name": "dt",
"value": "2025-11-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-10 00:06:18",
"last_data": "2025-11-10 00:06:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653225,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-10/",
"name": "dt",
"value": "2025-11-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-11 00:07:11",
"last_data": "2025-11-11 00:07:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653338,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-11/",
"name": "dt",
"value": "2025-11-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-12 00:09:48",
"last_data": "2025-11-12 00:09:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653460,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-12/",
"name": "dt",
"value": "2025-11-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-13 00:07:44",
"last_data": "2025-11-13 00:07:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653573,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-13/",
"name": "dt",
"value": "2025-11-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-14 00:07:17",
"last_data": "2025-11-14 00:07:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653685,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-14/",
"name": "dt",
"value": "2025-11-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-15 00:07:08",
"last_data": "2025-11-15 00:07:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653795,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-15/",
"name": "dt",
"value": "2025-11-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-16 00:07:45",
"last_data": "2025-11-16 00:07:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653908,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-16/",
"name": "dt",
"value": "2025-11-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-17 00:08:22",
"last_data": "2025-11-17 00:08:22"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656084,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-17/",
"name": "dt",
"value": "2025-11-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-18 00:07:44",
"last_data": "2025-11-18 00:07:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656198,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-18/",
"name": "dt",
"value": "2025-11-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-19 00:07:31",
"last_data": "2025-11-19 00:07:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656314,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-19/",
"name": "dt",
"value": "2025-11-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-20 00:07:35",
"last_data": "2025-11-20 00:07:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656428,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-20/",
"name": "dt",
"value": "2025-11-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-21 00:07:47",
"last_data": "2025-11-21 00:07:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656540,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-21/",
"name": "dt",
"value": "2025-11-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-22 00:07:07",
"last_data": "2025-11-22 00:07:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656650,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-22/",
"name": "dt",
"value": "2025-11-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-23 00:06:58",
"last_data": "2025-11-23 00:06:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656761,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-23/",
"name": "dt",
"value": "2025-11-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-24 00:07:14",
"last_data": "2025-11-24 00:07:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656883,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-11-24/",
"name": "dt",
"value": "2025-11-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-25 00:07:29",
"last_data": "2025-11-25 00:07:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657404,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-10/",
"name": "dt",
"value": "2025-12-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-11 00:07:43",
"last_data": "2025-12-11 00:07:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657525,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-11/",
"name": "dt",
"value": "2025-12-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-12 00:08:22",
"last_data": "2025-12-12 00:08:22"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657642,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-12/",
"name": "dt",
"value": "2025-12-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-13 00:08:07",
"last_data": "2025-12-13 00:08:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657756,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-13/",
"name": "dt",
"value": "2025-12-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-14 00:07:13",
"last_data": "2025-12-14 00:07:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657868,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-14/",
"name": "dt",
"value": "2025-12-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-15 00:12:36",
"last_data": "2025-12-15 00:12:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657991,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-15/",
"name": "dt",
"value": "2025-12-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-16 00:08:24",
"last_data": "2025-12-16 00:08:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658107,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-16/",
"name": "dt",
"value": "2025-12-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-17 00:07:06",
"last_data": "2025-12-17 00:07:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658225,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-17/",
"name": "dt",
"value": "2025-12-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-18 00:08:26",
"last_data": "2025-12-18 00:08:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658339,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-18/",
"name": "dt",
"value": "2025-12-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-19 00:07:44",
"last_data": "2025-12-19 00:07:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658456,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-19/",
"name": "dt",
"value": "2025-12-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-20 00:07:55",
"last_data": "2025-12-20 00:07:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658570,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-20/",
"name": "dt",
"value": "2025-12-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-21 00:07:26",
"last_data": "2025-12-21 00:07:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658685,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-21/",
"name": "dt",
"value": "2025-12-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-22 00:06:53",
"last_data": "2025-12-22 00:06:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658855,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-22/",
"name": "dt",
"value": "2025-12-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-23 00:07:14",
"last_data": "2025-12-23 00:07:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658971,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-23/",
"name": "dt",
"value": "2025-12-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-24 00:07:38",
"last_data": "2025-12-24 00:07:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659090,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-24/",
"name": "dt",
"value": "2025-12-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-25 00:07:27",
"last_data": "2025-12-25 00:07:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659204,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-25/",
"name": "dt",
"value": "2025-12-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-26 00:06:29",
"last_data": "2025-12-26 00:06:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659319,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-26/",
"name": "dt",
"value": "2025-12-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-27 00:07:28",
"last_data": "2025-12-27 00:07:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659434,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-27/",
"name": "dt",
"value": "2025-12-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-28 00:07:57",
"last_data": "2025-12-28 00:07:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659549,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-28/",
"name": "dt",
"value": "2025-12-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-29 00:08:47",
"last_data": "2025-12-29 00:08:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659669,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-29/",
"name": "dt",
"value": "2025-12-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-30 00:08:09",
"last_data": "2025-12-30 00:08:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659786,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-30/",
"name": "dt",
"value": "2025-12-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-31 00:07:31",
"last_data": "2025-12-31 00:07:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659904,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2025-12-31/",
"name": "dt",
"value": "2025-12-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-01 00:07:38",
"last_data": "2026-01-01 00:07:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660032,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-01/",
"name": "dt",
"value": "2026-01-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-02 00:07:42",
"last_data": "2026-01-02 00:07:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660149,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-02/",
"name": "dt",
"value": "2026-01-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-03 00:07:47",
"last_data": "2026-01-03 00:07:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660264,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-03/",
"name": "dt",
"value": "2026-01-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-04 00:07:03",
"last_data": "2026-01-04 00:07:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660381,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-04/",
"name": "dt",
"value": "2026-01-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-05 00:07:33",
"last_data": "2026-01-05 00:07:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660499,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-05/",
"name": "dt",
"value": "2026-01-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-06 00:07:02",
"last_data": "2026-01-06 00:07:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660617,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-06/",
"name": "dt",
"value": "2026-01-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-07 00:07:16",
"last_data": "2026-01-07 00:07:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660735,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-07/",
"name": "dt",
"value": "2026-01-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-08 00:09:02",
"last_data": "2026-01-08 00:09:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660853,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-08/",
"name": "dt",
"value": "2026-01-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-09 00:07:54",
"last_data": "2026-01-09 00:07:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660970,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-09/",
"name": "dt",
"value": "2026-01-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-10 00:08:08",
"last_data": "2026-01-10 00:08:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661085,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-10/",
"name": "dt",
"value": "2026-01-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-11 00:08:47",
"last_data": "2026-01-11 00:08:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661202,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-11/",
"name": "dt",
"value": "2026-01-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-12 00:08:29",
"last_data": "2026-01-12 00:08:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661321,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-12/",
"name": "dt",
"value": "2026-01-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-13 00:09:06",
"last_data": "2026-01-13 00:09:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661435,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-13/",
"name": "dt",
"value": "2026-01-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-14 00:10:24",
"last_data": "2026-01-14 00:10:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661554,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-14/",
"name": "dt",
"value": "2026-01-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-15 00:09:09",
"last_data": "2026-01-15 00:09:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661671,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-15/",
"name": "dt",
"value": "2026-01-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-16 00:08:29",
"last_data": "2026-01-16 00:08:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661790,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-16/",
"name": "dt",
"value": "2026-01-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-17 00:10:42",
"last_data": "2026-01-17 00:10:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661902,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-17/",
"name": "dt",
"value": "2026-01-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-18 00:10:21",
"last_data": "2026-01-18 00:10:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662019,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-18/",
"name": "dt",
"value": "2026-01-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-19 00:09:42",
"last_data": "2026-01-19 00:09:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662139,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-19/",
"name": "dt",
"value": "2026-01-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-20 00:10:12",
"last_data": "2026-01-20 00:10:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662254,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-20/",
"name": "dt",
"value": "2026-01-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-21 00:07:46",
"last_data": "2026-01-21 00:07:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662426,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-21/",
"name": "dt",
"value": "2026-01-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-22 00:07:56",
"last_data": "2026-01-22 00:07:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662541,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-22/",
"name": "dt",
"value": "2026-01-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-23 00:09:45",
"last_data": "2026-01-23 00:09:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662660,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-23/",
"name": "dt",
"value": "2026-01-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-24 00:07:59",
"last_data": "2026-01-24 00:07:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662775,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-24/",
"name": "dt",
"value": "2026-01-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-25 00:07:45",
"last_data": "2026-01-25 00:07:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662891,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-25/",
"name": "dt",
"value": "2026-01-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-26 00:07:23",
"last_data": "2026-01-26 00:07:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 663011,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-26/",
"name": "dt",
"value": "2026-01-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-27 00:10:21",
"last_data": "2026-01-27 00:10:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 663128,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-27/",
"name": "dt",
"value": "2026-01-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-28 00:07:49",
"last_data": "2026-01-28 00:07:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 663244,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-28/",
"name": "dt",
"value": "2026-01-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-29 00:07:33",
"last_data": "2026-01-29 00:07:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666088,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-29/",
"name": "dt",
"value": "2026-01-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-30 00:08:22",
"last_data": "2026-01-30 00:08:22"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666206,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-30/",
"name": "dt",
"value": "2026-01-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-31 00:08:34",
"last_data": "2026-01-31 00:08:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666323,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-01-31/",
"name": "dt",
"value": "2026-01-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-01 00:08:27",
"last_data": "2026-02-01 00:08:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666455,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-01/",
"name": "dt",
"value": "2026-02-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-02 00:07:37",
"last_data": "2026-02-02 00:07:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666574,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-02/",
"name": "dt",
"value": "2026-02-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-03 00:08:35",
"last_data": "2026-02-03 00:08:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666693,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-03/",
"name": "dt",
"value": "2026-02-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-04 00:08:16",
"last_data": "2026-02-04 00:08:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666812,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-04/",
"name": "dt",
"value": "2026-02-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-05 00:08:45",
"last_data": "2026-02-05 00:08:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666928,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-05/",
"name": "dt",
"value": "2026-02-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-06 00:07:40",
"last_data": "2026-02-06 00:07:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667043,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-06/",
"name": "dt",
"value": "2026-02-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-07 00:07:03",
"last_data": "2026-02-07 00:07:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667157,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-07/",
"name": "dt",
"value": "2026-02-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-08 00:08:04",
"last_data": "2026-02-08 00:08:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667271,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-08/",
"name": "dt",
"value": "2026-02-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-09 00:10:16",
"last_data": "2026-02-09 00:10:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667388,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-09/",
"name": "dt",
"value": "2026-02-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-10 00:08:59",
"last_data": "2026-02-10 00:08:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667507,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-10/",
"name": "dt",
"value": "2026-02-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-11 00:08:47",
"last_data": "2026-02-11 00:08:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667627,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-11/",
"name": "dt",
"value": "2026-02-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-12 00:08:30",
"last_data": "2026-02-12 00:08:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667744,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-12/",
"name": "dt",
"value": "2026-02-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-13 00:07:51",
"last_data": "2026-02-13 00:07:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667862,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-13/",
"name": "dt",
"value": "2026-02-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-14 00:07:39",
"last_data": "2026-02-14 00:07:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667976,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-14/",
"name": "dt",
"value": "2026-02-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-15 00:07:55",
"last_data": "2026-02-15 00:07:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668091,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-15/",
"name": "dt",
"value": "2026-02-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-16 00:09:05",
"last_data": "2026-02-16 00:09:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668211,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-16/",
"name": "dt",
"value": "2026-02-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-17 00:08:08",
"last_data": "2026-02-17 00:08:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668332,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-17/",
"name": "dt",
"value": "2026-02-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-18 00:08:03",
"last_data": "2026-02-18 00:08:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668450,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-18/",
"name": "dt",
"value": "2026-02-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-19 00:09:17",
"last_data": "2026-02-19 00:09:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668568,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-19/",
"name": "dt",
"value": "2026-02-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-20 00:09:03",
"last_data": "2026-02-20 00:09:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668683,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-20/",
"name": "dt",
"value": "2026-02-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-21 00:10:44",
"last_data": "2026-02-21 00:10:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668800,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-21/",
"name": "dt",
"value": "2026-02-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-22 00:10:03",
"last_data": "2026-02-22 00:10:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668915,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-22/",
"name": "dt",
"value": "2026-02-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-23 00:08:01",
"last_data": "2026-02-23 00:08:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669034,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-23/",
"name": "dt",
"value": "2026-02-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-24 00:08:47",
"last_data": "2026-02-24 00:08:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669152,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-24/",
"name": "dt",
"value": "2026-02-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-25 00:08:34",
"last_data": "2026-02-25 00:08:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669271,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-25/",
"name": "dt",
"value": "2026-02-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-26 00:09:59",
"last_data": "2026-02-26 00:09:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669388,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-26/",
"name": "dt",
"value": "2026-02-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-27 00:08:38",
"last_data": "2026-02-27 00:08:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669505,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-27/",
"name": "dt",
"value": "2026-02-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-28 00:08:34",
"last_data": "2026-02-28 00:08:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669619,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-02-28/",
"name": "dt",
"value": "2026-02-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-01 00:08:14",
"last_data": "2026-03-01 00:08:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669745,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-01/",
"name": "dt",
"value": "2026-03-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-02 00:08:42",
"last_data": "2026-03-02 00:08:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669864,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-02/",
"name": "dt",
"value": "2026-03-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-03 00:08:42",
"last_data": "2026-03-03 00:08:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669982,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-03/",
"name": "dt",
"value": "2026-03-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-04 00:09:32",
"last_data": "2026-03-04 00:09:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670140,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-04/",
"name": "dt",
"value": "2026-03-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-05 00:08:52",
"last_data": "2026-03-05 00:08:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670258,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-05/",
"name": "dt",
"value": "2026-03-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-06 00:09:06",
"last_data": "2026-03-06 00:09:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670377,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-06/",
"name": "dt",
"value": "2026-03-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-07 00:09:07",
"last_data": "2026-03-07 00:09:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670491,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-07/",
"name": "dt",
"value": "2026-03-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-08 00:09:18",
"last_data": "2026-03-08 00:09:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670608,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-08/",
"name": "dt",
"value": "2026-03-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-09 00:09:09",
"last_data": "2026-03-09 00:09:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670727,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-09/",
"name": "dt",
"value": "2026-03-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-10 00:10:29",
"last_data": "2026-03-10 00:10:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670845,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-10/",
"name": "dt",
"value": "2026-03-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-11 00:32:40",
"last_data": "2026-03-11 00:32:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670963,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-11/",
"name": "dt",
"value": "2026-03-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-12 00:07:51",
"last_data": "2026-03-12 00:07:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671081,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-12/",
"name": "dt",
"value": "2026-03-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-13 00:08:12",
"last_data": "2026-03-13 00:08:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671199,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-13/",
"name": "dt",
"value": "2026-03-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-14 00:08:28",
"last_data": "2026-03-14 00:08:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671314,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-14/",
"name": "dt",
"value": "2026-03-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-15 00:09:39",
"last_data": "2026-03-15 00:09:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671429,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-15/",
"name": "dt",
"value": "2026-03-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-16 00:09:45",
"last_data": "2026-03-16 00:09:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671550,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-16/",
"name": "dt",
"value": "2026-03-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-17 00:08:26",
"last_data": "2026-03-17 00:08:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671665,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-17/",
"name": "dt",
"value": "2026-03-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-18 00:08:19",
"last_data": "2026-03-18 00:08:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671785,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-18/",
"name": "dt",
"value": "2026-03-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-19 00:09:41",
"last_data": "2026-03-19 00:09:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671901,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-19/",
"name": "dt",
"value": "2026-03-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-20 00:08:06",
"last_data": "2026-03-20 00:08:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672019,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-20/",
"name": "dt",
"value": "2026-03-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-21 00:09:11",
"last_data": "2026-03-21 00:09:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672135,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-21/",
"name": "dt",
"value": "2026-03-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-22 00:10:41",
"last_data": "2026-03-22 00:10:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672252,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-22/",
"name": "dt",
"value": "2026-03-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-23 00:09:27",
"last_data": "2026-03-23 00:09:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672374,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-23/",
"name": "dt",
"value": "2026-03-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-24 00:08:28",
"last_data": "2026-03-24 00:08:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672494,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-24/",
"name": "dt",
"value": "2026-03-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-25 00:09:12",
"last_data": "2026-03-25 00:09:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672611,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-25/",
"name": "dt",
"value": "2026-03-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-26 00:10:25",
"last_data": "2026-03-26 00:10:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672727,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-26/",
"name": "dt",
"value": "2026-03-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-27 00:08:34",
"last_data": "2026-03-27 00:08:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672845,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-27/",
"name": "dt",
"value": "2026-03-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-28 00:09:31",
"last_data": "2026-03-28 00:09:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672961,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-28/",
"name": "dt",
"value": "2026-03-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-29 00:09:21",
"last_data": "2026-03-29 00:09:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673078,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-29/",
"name": "dt",
"value": "2026-03-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-30 00:10:59",
"last_data": "2026-03-30 00:10:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673198,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-30/",
"name": "dt",
"value": "2026-03-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-31 00:09:57",
"last_data": "2026-03-31 00:09:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673316,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-03-31/",
"name": "dt",
"value": "2026-03-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-01 00:08:58",
"last_data": "2026-04-01 00:08:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673483,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-01/",
"name": "dt",
"value": "2026-04-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-02 00:09:31",
"last_data": "2026-04-02 00:09:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673597,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-02/",
"name": "dt",
"value": "2026-04-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-03 00:09:42",
"last_data": "2026-04-03 00:09:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673714,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-03/",
"name": "dt",
"value": "2026-04-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-04 00:08:58",
"last_data": "2026-04-04 00:08:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673828,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-04/",
"name": "dt",
"value": "2026-04-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-05 00:09:09",
"last_data": "2026-04-05 00:09:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673943,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-05/",
"name": "dt",
"value": "2026-04-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-06 00:07:44",
"last_data": "2026-04-06 00:07:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674064,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-06/",
"name": "dt",
"value": "2026-04-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-07 00:10:55",
"last_data": "2026-04-07 00:10:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674181,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-07/",
"name": "dt",
"value": "2026-04-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-08 00:10:16",
"last_data": "2026-04-08 00:10:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674299,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-08/",
"name": "dt",
"value": "2026-04-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-09 00:12:06",
"last_data": "2026-04-09 00:12:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674418,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-09/",
"name": "dt",
"value": "2026-04-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-10 00:09:42",
"last_data": "2026-04-10 00:09:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674535,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-10/",
"name": "dt",
"value": "2026-04-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-11 00:08:52",
"last_data": "2026-04-11 00:08:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674650,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-11/",
"name": "dt",
"value": "2026-04-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-12 00:09:05",
"last_data": "2026-04-12 00:09:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674767,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-12/",
"name": "dt",
"value": "2026-04-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-13 00:12:06",
"last_data": "2026-04-13 00:12:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674886,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-13/",
"name": "dt",
"value": "2026-04-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-14 00:10:07",
"last_data": "2026-04-14 00:10:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 675002,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-14/",
"name": "dt",
"value": "2026-04-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-15 00:08:34",
"last_data": "2026-04-15 00:08:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 675122,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-15/",
"name": "dt",
"value": "2026-04-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-16 00:11:43",
"last_data": "2026-04-16 00:11:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 675261,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches/dt=2026-04-16/",
"name": "dt",
"value": "2026-04-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-17 00:16:00",
"last_data": "2026-04-17 00:16:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"cached": "smallint",
"dt_partition": "date",
"location_id": "int",
"page_num": "int",
"search_id": "string",
"search_term": "string",
"search_time": "timestamp",
"search_weight_id": "int",
"search_weight_test_id": "int",
"site_id": "int",
"sort": "string",
"total_listings": "int",
"translated_search_term": "string"
},
"created": "2022-11-15 02:36:28",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_searches`\n(\n `cached` smallint , `dt_partition` date , `location_id` int , `page_num` int , `search_id` string , `search_term` string , `search_time` timestamp , `search_weight_id` int , `search_weight_test_id` int , `site_id` int , `sort` string , `total_listings` int , `translated_search_term` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_searches'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_searches`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_searches"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}