Schema Info
Schema Name: sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal
- created: 2022-11-15 01:15:08
- disabled: False
- format: raw
- id: 1479
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_stage_rds", "table": "sparefoot_sparefoot_facility_tenants_temporal" } - type: rds
Schema Versions: 4
-
Version 855118
- created: 2025-07-30 00:15:33
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal`\n(\n `alt_email` string , `alt_first_name` string , `alt_last_name` string , `alt_phone` bigint , `api_facility_id` string , `company_name` string , `confirmation_code` string , `corporation_id` int , `created` timestamp , `customer_address1` string , `customer_address2` string , `customer_cell_phone` bigint , `customer_city` string , `customer_email` string , `customer_first_name` string , `customer_home_phone` bigint , `customer_id` string , `customer_last_name` string , `customer_phone` bigint , `customer_state` string , `customer_work_email` string , `customer_work_phone` bigint , `customer_zip` string , `dt_partition` date , `facility_id` int , `facility_name` string , `id` string , `last_payment_amount` double , `lead_id` string , `lifetime_value` double , `listing_avail_id` int , `match_run_id` int , `modified` timestamp , `move_in_date` date , `move_out_date` date , `rent_rate` double , `source_type` string , `unit_dimensions` string , `unit_id` string , `unit_number` 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_facility_tenants_temporal'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal
- id: 855118
- processed: 1
- raw_data:
{ "alt_email": "string", "alt_first_name": "string", "alt_last_name": "string", "alt_phone": "int64", "api_facility_id": "string", "company_name": "string", "confirmation_code": "string", "corporation_id": "int32", "created": "timestamp[ns]", "customer_address1": "string", "customer_address2": "string", "customer_cell_phone": "int64", "customer_city": "string", "customer_email": "string", "customer_first_name": "string", "customer_home_phone": "int64", "customer_id": "string", "customer_last_name": "string", "customer_phone": "int64", "customer_state": "string", "customer_work_email": "string", "customer_work_phone": "int64", "customer_zip": "string", "dt_partition": "date32[day]", "facility_id": "int32", "facility_name": "string", "id": "string", "last_payment_amount": "double", "lead_id": "string", "lifetime_value": "double", "listing_avail_id": "int32", "match_run_id": "int32", "modified": "timestamp[ns]", "move_in_date": "date32[day]", "move_out_date": "date32[day]", "rent_rate": "double", "source_type": "string", "unit_dimensions": "string", "unit_id": "string", "unit_number": "string" } - schema_attributes:
{ "alt_email": "string", "alt_first_name": "string", "alt_last_name": "string", "alt_phone": "bigint", "api_facility_id": "string", "company_name": "string", "confirmation_code": "string", "corporation_id": "int", "created": "timestamp", "customer_address1": "string", "customer_address2": "string", "customer_cell_phone": "bigint", "customer_city": "string", "customer_email": "string", "customer_first_name": "string", "customer_home_phone": "bigint", "customer_id": "string", "customer_last_name": "string", "customer_phone": "bigint", "customer_state": "string", "customer_work_email": "string", "customer_work_phone": "bigint", "customer_zip": "string", "dt_partition": "date", "facility_id": "int", "facility_name": "string", "id": "string", "last_payment_amount": "double", "lead_id": "string", "lifetime_value": "double", "listing_avail_id": "int", "match_run_id": "int", "modified": "timestamp", "move_in_date": "date", "move_out_date": "date", "rent_rate": "double", "source_type": "string", "unit_dimensions": "string", "unit_id": "string", "unit_number": "string" } - schema_name_id: 1479
- schema_scan_id: 6300963
- updated: 2025-07-30 00:16:49
-
Version 851763
- created: 2025-07-08 00:17:21
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal`\n(\n `alt_email` string , `alt_first_name` string , `alt_last_name` string , `alt_phone` bigint , `api_facility_id` string , `company_name` string , `confirmation_code` string , `corporation_id` int , `created` timestamp , `customer_address1` string , `customer_address2` string , `customer_cell_phone` bigint , `customer_city` string , `customer_email` string , `customer_first_name` string , `customer_home_phone` bigint , `customer_id` string , `customer_last_name` string , `customer_phone` bigint , `customer_state` string , `customer_work_email` string , `customer_work_phone` bigint , `customer_zip` string , `dt_partition` date , `facility_id` int , `facility_name` string , `id` string , `last_payment_amount` double , `lead_id` string , `lifetime_value` double , `listing_avail_id` int , `match_run_id` int , `modified` timestamp , `move_in_date` date , `move_out_date` timestamp , `rent_rate` double , `source_type` string , `unit_dimensions` string , `unit_id` string , `unit_number` 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_facility_tenants_temporal'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal
- id: 851763
- processed: 1
- raw_data:
{ "alt_email": "string", "alt_first_name": "string", "alt_last_name": "string", "alt_phone": "int64", "api_facility_id": "string", "company_name": "string", "confirmation_code": "string", "corporation_id": "int32", "created": "timestamp[ns]", "customer_address1": "string", "customer_address2": "string", "customer_cell_phone": "int64", "customer_city": "string", "customer_email": "string", "customer_first_name": "string", "customer_home_phone": "int64", "customer_id": "string", "customer_last_name": "string", "customer_phone": "int64", "customer_state": "string", "customer_work_email": "string", "customer_work_phone": "int64", "customer_zip": "string", "dt_partition": "date32[day]", "facility_id": "int32", "facility_name": "string", "id": "string", "last_payment_amount": "double", "lead_id": "string", "lifetime_value": "double", "listing_avail_id": "int32", "match_run_id": "int32", "modified": "timestamp[ns]", "move_in_date": "date32[day]", "move_out_date": "timestamp[ns]", "rent_rate": "double", "source_type": "string", "unit_dimensions": "string", "unit_id": "string", "unit_number": "string" } - schema_attributes:
{ "alt_email": "string", "alt_first_name": "string", "alt_last_name": "string", "alt_phone": "bigint", "api_facility_id": "string", "company_name": "string", "confirmation_code": "string", "corporation_id": "int", "created": "timestamp", "customer_address1": "string", "customer_address2": "string", "customer_cell_phone": "bigint", "customer_city": "string", "customer_email": "string", "customer_first_name": "string", "customer_home_phone": "bigint", "customer_id": "string", "customer_last_name": "string", "customer_phone": "bigint", "customer_state": "string", "customer_work_email": "string", "customer_work_phone": "bigint", "customer_zip": "string", "dt_partition": "date", "facility_id": "int", "facility_name": "string", "id": "string", "last_payment_amount": "double", "lead_id": "string", "lifetime_value": "double", "listing_avail_id": "int", "match_run_id": "int", "modified": "timestamp", "move_in_date": "date", "move_out_date": "timestamp", "rent_rate": "double", "source_type": "string", "unit_dimensions": "string", "unit_id": "string", "unit_number": "string" } - schema_name_id: 1479
- schema_scan_id: 6293410
- updated: 2025-07-08 00:18:36
-
Version 752918
- created: 2024-09-24 14:15:25
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal`\n(\n `alt_email` string , `alt_first_name` string , `alt_last_name` string , `alt_phone` bigint , `api_facility_id` string , `company_name` string , `confirmation_code` string , `corporation_id` int , `created` timestamp , `customer_address1` string , `customer_address2` string , `customer_cell_phone` bigint , `customer_city` string , `customer_email` string , `customer_first_name` string , `customer_home_phone` bigint , `customer_id` string , `customer_last_name` string , `customer_phone` bigint , `customer_state` string , `customer_work_email` string , `customer_work_phone` bigint , `customer_zip` string , `dt_partition` date , `facility_id` int , `facility_name` string , `id` string , `last_payment_amount` double , `lead_id` string , `lifetime_value` double , `listing_avail_id` int , `match_run_id` int , `modified` timestamp , `move_in_date` date , `move_out_date` date , `rent_rate` double , `source_type` string , `unit_dimensions` string , `unit_id` string , `unit_number` 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_facility_tenants_temporal'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal
- id: 752918
- processed: 1
- raw_data:
{ "alt_email": "string", "alt_first_name": "string", "alt_last_name": "string", "alt_phone": "int64", "api_facility_id": "string", "company_name": "string", "confirmation_code": "string", "corporation_id": "int32", "created": "timestamp[ns]", "customer_address1": "string", "customer_address2": "string", "customer_cell_phone": "int64", "customer_city": "string", "customer_email": "string", "customer_first_name": "string", "customer_home_phone": "int64", "customer_id": "string", "customer_last_name": "string", "customer_phone": "int64", "customer_state": "string", "customer_work_email": "string", "customer_work_phone": "int64", "customer_zip": "string", "dt_partition": "date32[day]", "facility_id": "int32", "facility_name": "string", "id": "string", "last_payment_amount": "double", "lead_id": "string", "lifetime_value": "double", "listing_avail_id": "int32", "match_run_id": "int32", "modified": "timestamp[ns]", "move_in_date": "date32[day]", "move_out_date": "date32[day]", "rent_rate": "double", "source_type": "string", "unit_dimensions": "string", "unit_id": "string", "unit_number": "string" } - schema_attributes:
{ "alt_email": "string", "alt_first_name": "string", "alt_last_name": "string", "alt_phone": "bigint", "api_facility_id": "string", "company_name": "string", "confirmation_code": "string", "corporation_id": "int", "created": "timestamp", "customer_address1": "string", "customer_address2": "string", "customer_cell_phone": "bigint", "customer_city": "string", "customer_email": "string", "customer_first_name": "string", "customer_home_phone": "bigint", "customer_id": "string", "customer_last_name": "string", "customer_phone": "bigint", "customer_state": "string", "customer_work_email": "string", "customer_work_phone": "bigint", "customer_zip": "string", "dt_partition": "date", "facility_id": "int", "facility_name": "string", "id": "string", "last_payment_amount": "double", "lead_id": "string", "lifetime_value": "double", "listing_avail_id": "int", "match_run_id": "int", "modified": "timestamp", "move_in_date": "date", "move_out_date": "date", "rent_rate": "double", "source_type": "string", "unit_dimensions": "string", "unit_id": "string", "unit_number": "string" } - schema_name_id: 1479
- schema_scan_id: 6011536
- updated: 2024-09-24 14:16:31
-
Version 752835
- created: 2024-09-24 08:14:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`", "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal`\n(\n `alt_email` string , `alt_first_name` string , `alt_last_name` string , `alt_phone` bigint , `api_facility_id` string , `company_name` string , `confirmation_code` string , `corporation_id` int , `created` timestamp , `customer_address1` string , `customer_address2` string , `customer_cell_phone` bigint , `customer_city` string , `customer_email` string , `customer_first_name` string , `customer_home_phone` bigint , `customer_id` string , `customer_last_name` string , `customer_phone` bigint , `customer_state` string , `customer_work_email` string , `customer_work_phone` bigint , `customer_zip` string , `dt_partition` date , `facility_id` int , `facility_name` string , `id` string , `last_payment_amount` double , `lead_id` string , `lifetime_value` double , `listing_avail_id` int , `match_run_id` int , `modified` timestamp , `move_in_date` date , `move_out_date` timestamp , `rent_rate` double , `source_type` string , `unit_dimensions` string , `unit_id` string , `unit_number` 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_facility_tenants_temporal'\n", "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal" ] - hive_path: s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal
- id: 752835
- processed: 1
- raw_data:
{ "alt_email": "string", "alt_first_name": "string", "alt_last_name": "string", "alt_phone": "int64", "api_facility_id": "string", "company_name": "string", "confirmation_code": "string", "corporation_id": "int32", "created": "timestamp[ns]", "customer_address1": "string", "customer_address2": "string", "customer_cell_phone": "int64", "customer_city": "string", "customer_email": "string", "customer_first_name": "string", "customer_home_phone": "int64", "customer_id": "string", "customer_last_name": "string", "customer_phone": "int64", "customer_state": "string", "customer_work_email": "string", "customer_work_phone": "int64", "customer_zip": "string", "dt_partition": "date32[day]", "facility_id": "int32", "facility_name": "string", "id": "string", "last_payment_amount": "double", "lead_id": "string", "lifetime_value": "double", "listing_avail_id": "int32", "match_run_id": "int32", "modified": "timestamp[ns]", "move_in_date": "date32[day]", "move_out_date": "timestamp[ns]", "rent_rate": "double", "source_type": "string", "unit_dimensions": "string", "unit_id": "string", "unit_number": "string" } - schema_attributes:
{ "alt_email": "string", "alt_first_name": "string", "alt_last_name": "string", "alt_phone": "bigint", "api_facility_id": "string", "company_name": "string", "confirmation_code": "string", "corporation_id": "int", "created": "timestamp", "customer_address1": "string", "customer_address2": "string", "customer_cell_phone": "bigint", "customer_city": "string", "customer_email": "string", "customer_first_name": "string", "customer_home_phone": "bigint", "customer_id": "string", "customer_last_name": "string", "customer_phone": "bigint", "customer_state": "string", "customer_work_email": "string", "customer_work_phone": "bigint", "customer_zip": "string", "dt_partition": "date", "facility_id": "int", "facility_name": "string", "id": "string", "last_payment_amount": "double", "lead_id": "string", "lifetime_value": "double", "listing_avail_id": "int", "match_run_id": "int", "modified": "timestamp", "move_in_date": "date", "move_out_date": "timestamp", "rent_rate": "double", "source_type": "string", "unit_dimensions": "string", "unit_id": "string", "unit_number": "string" } - schema_name_id: 1479
- schema_scan_id: 6010947
- updated: 2024-09-24 08:15:34
Schema Scans: 6
Last at 2026-04-17 00:10:18
-
Scan 6415094
- duration: 0:00:04.469798
- exit_message:
{ "ddl_changed": false, "partitions_applied": true, "success": true } - id: 6415094
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/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_facility_tenants_temporal", "key": "raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-16/facility_tenants_temporal_1.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal", "type": "rds" }, "trace_context": { "parent_id": 8311729187175168025, "service_name": "sparefoot", "span_id": 11785014613941538018, "trace_id": 8311729187175168025 } } - running: False
- schema_name_id: 1479
- start_time: 2026-04-17 00:10:18
- success: True
- trace_id: 8311729187175168025
-
Scan 6414592
- duration: 0:00:04.471588
- exit_message:
{ "ddl_changed": false, "partitions_applied": true, "success": true } - id: 6414592
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/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_facility_tenants_temporal", "key": "raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-15/facility_tenants_temporal_1.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal", "type": "rds" }, "trace_context": { "parent_id": 9624091753564424664, "service_name": "sparefoot", "span_id": 1187435925491924989, "trace_id": 9624091753564424664 } } - running: False
- schema_name_id: 1479
- start_time: 2026-04-16 00:12:22
- success: True
- trace_id: 9624091753564424664
-
Scan 6300963
- duration: 0:02:12.169755
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 3397, "partitions_applied": false, "success": true } - id: 6300963
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-07-29", "name": "dt", "type": "string", "value": "2025-07-29" }, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal", "key": "raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-07-29/facility_tenants_temporal_1.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal", "type": "rds" }, "trace_context": { "parent_id": 1102065160055913160, "service_name": "sparefoot", "span_id": 12034962397562880354, "trace_id": 1102065160055913160 } } - running: False
- schema_name_id: 1479
- start_time: 2025-07-30 00:15:32
- success: True
- trace_id: 1102065160055913160
-
Scan 6293410
- duration: 0:05:26.979781
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 3396, "partitions_applied": false, "success": true } - id: 6293410
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-07-07", "name": "dt", "type": "string", "value": "2025-07-07" }, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal", "key": "raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-07-07/facility_tenants_temporal.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal", "type": "rds" }, "trace_context": { "parent_id": 10338373597929480496, "service_name": "sparefoot", "span_id": 4332491800986150944, "trace_id": 10338373597929480496 } } - running: False
- schema_name_id: 1479
- start_time: 2025-07-08 00:17:20
- success: True
- trace_id: 10338373597929480496
-
Scan 6011536
- duration: 0:02:01.618556
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 3116, "partitions_applied": false, "success": true } - id: 6011536
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2024-09-24", "name": "dt", "type": "string", "value": "2024-09-24" }, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal", "key": "raw_incremental/sparefoot_facility_tenants_temporal/dt=2024-09-24/facility_tenants_temporal_1.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal", "type": "rds" }, "trace_context": { "parent_id": 672491507025240648, "service_name": "sparefoot", "span_id": 1760927841593957796, "trace_id": 672491507025240648 } } - running: False
- schema_name_id: 1479
- start_time: 2024-09-24 14:15:24
- success: True
- trace_id: 672491507025240648
-
Scan 6010947
- duration: 0:05:14.740240
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 3116, "partitions_applied": false, "success": true } - id: 6010947
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2024-09-24", "name": "dt", "type": "string", "value": "2024-09-24" }, "s3": { "bucket": "sfdl-rds-sparefoot-stage", "hive_path": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal", "key": "raw_incremental/sparefoot_facility_tenants_temporal/dt=2024-09-24/facility_tenants_temporal_8.parquet.gz" }, "schema": { "name": "sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal", "type": "rds" }, "trace_context": { "parent_id": 16463227151425330160, "service_name": "sparefoot", "span_id": 13994587758290958069, "trace_id": 16463227151425330160 } } - running: False
- schema_name_id: 1479
- start_time: 2024-09-24 08:14:30
- success: True
- trace_id: 16463227151425330160
- count: 170
- ddl:
[ "ALTER TABLE\n `sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal`\nADD\n\n\n PARTITION (dt='2025-10-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-14/'\n PARTITION (dt='2025-10-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-15/'\n PARTITION (dt='2025-10-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-16/'\n PARTITION (dt='2025-10-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-17/'\n PARTITION (dt='2025-10-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-18/'\n PARTITION (dt='2025-10-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-19/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-20/'\n PARTITION (dt='2025-10-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-21/'\n PARTITION (dt='2025-10-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-22/'\n PARTITION (dt='2025-10-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-23/'\n PARTITION (dt='2025-10-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-24/'\n PARTITION (dt='2025-10-25') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-25/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-26/'\n PARTITION (dt='2025-10-27') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-27/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-28/'\n PARTITION (dt='2025-10-29') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-29/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-30/'\n PARTITION (dt='2025-10-31') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-31/'\n PARTITION (dt='2025-11-01') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-01/'\n PARTITION (dt='2025-11-02') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-02/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-04/'\n PARTITION (dt='2025-11-05') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-05/'\n PARTITION (dt='2025-11-06') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-06/'\n PARTITION (dt='2025-11-07') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-07/'\n PARTITION (dt='2025-11-08') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-08/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-09/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-10/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-12/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-13/'\n PARTITION (dt='2025-11-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-14/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-15/'\n PARTITION (dt='2025-11-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-16/'\n PARTITION (dt='2025-11-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-17/'\n PARTITION (dt='2025-11-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-18/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-19/'\n PARTITION (dt='2025-11-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-20/'\n PARTITION (dt='2025-11-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-21/'\n PARTITION (dt='2025-11-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-22/'\n PARTITION (dt='2025-11-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-23/'\n PARTITION (dt='2025-11-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-24/'\n PARTITION (dt='2025-12-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-10/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-12/'\n PARTITION (dt='2025-12-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-13/'\n PARTITION (dt='2025-12-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-14/'\n PARTITION (dt='2025-12-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-15/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-16/'\n PARTITION (dt='2025-12-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-17/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-19/'\n PARTITION (dt='2025-12-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-20/'\n PARTITION (dt='2025-12-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-21/'\n PARTITION (dt='2025-12-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-22/'\n PARTITION (dt='2025-12-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-23/'\n PARTITION (dt='2025-12-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-24/'\n PARTITION (dt='2025-12-25') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-25/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-26/'\n PARTITION (dt='2025-12-27') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-27/'\n PARTITION (dt='2025-12-28') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-28/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-31/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-01/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-02/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-03/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-04/'\n PARTITION (dt='2026-01-05') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-08/'\n PARTITION (dt='2026-01-09') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-09/'\n PARTITION (dt='2026-01-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-10/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-11/'\n PARTITION (dt='2026-01-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-12/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-13/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-14/'\n PARTITION (dt='2026-01-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-15/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-16/'\n PARTITION (dt='2026-01-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-17/'\n PARTITION (dt='2026-01-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-18/'\n PARTITION (dt='2026-01-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-19/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-20/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-21/'\n PARTITION (dt='2026-01-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-22/'\n PARTITION (dt='2026-01-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-23/'\n PARTITION (dt='2026-01-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-24/'\n PARTITION (dt='2026-01-25') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-25/'\n PARTITION (dt='2026-01-26') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-28/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-29/'\n PARTITION (dt='2026-01-30') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-30/'\n PARTITION (dt='2026-01-31') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-31/'\n PARTITION (dt='2026-02-01') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-01/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-04/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-05/'\n PARTITION (dt='2026-02-06') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-06/'\n PARTITION (dt='2026-02-07') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-07/'\n PARTITION (dt='2026-02-08') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-08/'\n PARTITION (dt='2026-02-09') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-09/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-11/'\n PARTITION (dt='2026-02-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-12/'\n PARTITION (dt='2026-02-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-13/'\n PARTITION (dt='2026-02-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-14/'\n PARTITION (dt='2026-02-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-15/'\n PARTITION (dt='2026-02-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-16/'\n PARTITION (dt='2026-02-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-17/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-18/'\n PARTITION (dt='2026-02-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-19/'\n PARTITION (dt='2026-02-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-20/'\n PARTITION (dt='2026-02-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-21/'\n PARTITION (dt='2026-02-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-22/'\n PARTITION (dt='2026-02-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-23/'\n PARTITION (dt='2026-02-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-24/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-25/'\n PARTITION (dt='2026-02-26') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-26/'\n PARTITION (dt='2026-02-27') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-27/'\n PARTITION (dt='2026-02-28') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-28/'\n PARTITION (dt='2026-03-01') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-01/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-02/'\n PARTITION (dt='2026-03-03') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-03/'\n PARTITION (dt='2026-03-04') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-04/'\n PARTITION (dt='2026-03-05') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-05/'\n PARTITION (dt='2026-03-06') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-06/'\n PARTITION (dt='2026-03-07') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-07/'\n PARTITION (dt='2026-03-08') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-08/'\n PARTITION (dt='2026-03-09') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-09/'\n PARTITION (dt='2026-03-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-10/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-11/'\n PARTITION (dt='2026-03-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-12/'\n PARTITION (dt='2026-03-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-13/'\n PARTITION (dt='2026-03-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-14/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-15/'\n PARTITION (dt='2026-03-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-16/'\n PARTITION (dt='2026-03-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-17/'\n PARTITION (dt='2026-03-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-18/'\n PARTITION (dt='2026-03-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-19/'\n PARTITION (dt='2026-03-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-20/'\n PARTITION (dt='2026-03-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-21/'\n PARTITION (dt='2026-03-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-22/'\n PARTITION (dt='2026-03-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-23/'\n PARTITION (dt='2026-03-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-24/'\n PARTITION (dt='2026-03-25') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-25/'\n PARTITION (dt='2026-03-26') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-26/'\n PARTITION (dt='2026-03-27') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-27/'\n PARTITION (dt='2026-03-28') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-28/'\n PARTITION (dt='2026-03-29') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-29/'\n PARTITION (dt='2026-03-30') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-30/'\n PARTITION (dt='2026-03-31') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-31/'\n PARTITION (dt='2026-04-01') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-01/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-02/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-03/'\n PARTITION (dt='2026-04-04') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-04/'\n PARTITION (dt='2026-04-05') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-05/'\n PARTITION (dt='2026-04-06') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-06/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-07/'\n PARTITION (dt='2026-04-08') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-08/'\n PARTITION (dt='2026-04-09') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-09/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-10/'\n PARTITION (dt='2026-04-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-11/'\n PARTITION (dt='2026-04-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-12/'\n PARTITION (dt='2026-04-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-13/'\n PARTITION (dt='2026-04-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-14/'\n PARTITION (dt='2026-04-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-15/'\n PARTITION (dt='2026-04-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-16/'\n;" ] - name: dt
- state:
[ { "info": { "id": 650139, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-14/", "name": "dt", "value": "2025-10-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-15 00:10:28", "last_data": "2025-10-15 00:10:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650254, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-15/", "name": "dt", "value": "2025-10-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-16 00:10:53", "last_data": "2025-10-16 00:10:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650369, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-16/", "name": "dt", "value": "2025-10-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-17 00:09:13", "last_data": "2025-10-17 00:09:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650485, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-17/", "name": "dt", "value": "2025-10-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-18 00:09:55", "last_data": "2025-10-18 00:09:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650600, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-18/", "name": "dt", "value": "2025-10-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-19 00:09:31", "last_data": "2025-10-19 00:09:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650713, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-19/", "name": "dt", "value": "2025-10-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-20 00:09:16", "last_data": "2025-10-20 00:09:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650830, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-20/", "name": "dt", "value": "2025-10-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-21 00:11:34", "last_data": "2025-10-21 00:11:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650943, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-21/", "name": "dt", "value": "2025-10-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-22 00:12:05", "last_data": "2025-10-22 00:12:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651057, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-22/", "name": "dt", "value": "2025-10-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-23 00:12:40", "last_data": "2025-10-23 00:12:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651170, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-23/", "name": "dt", "value": "2025-10-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-24 00:12:17", "last_data": "2025-10-24 00:12:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651282, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-24/", "name": "dt", "value": "2025-10-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-25 00:13:56", "last_data": "2025-10-25 00:13:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651395, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-25/", "name": "dt", "value": "2025-10-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-26 00:12:38", "last_data": "2025-10-26 00:12:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651507, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-26/", "name": "dt", "value": "2025-10-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-27 00:19:35", "last_data": "2025-10-27 00:19:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651629, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-27/", "name": "dt", "value": "2025-10-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-28 00:15:27", "last_data": "2025-10-28 00:15:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651742, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-28/", "name": "dt", "value": "2025-10-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-29 00:17:50", "last_data": "2025-10-29 00:17:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651857, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-29/", "name": "dt", "value": "2025-10-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-30 00:13:25", "last_data": "2025-10-30 00:13:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651968, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-30/", "name": "dt", "value": "2025-10-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-31 00:13:10", "last_data": "2025-10-31 00:13:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652079, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-31/", "name": "dt", "value": "2025-10-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-01 00:12:06", "last_data": "2025-11-01 00:12:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652199, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-01/", "name": "dt", "value": "2025-11-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-02 00:11:39", "last_data": "2025-11-02 00:11:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652310, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-02/", "name": "dt", "value": "2025-11-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-03 00:13:11", "last_data": "2025-11-03 00:13:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652431, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-03/", "name": "dt", "value": "2025-11-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-04 00:12:19", "last_data": "2025-11-04 00:12:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652545, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-04/", "name": "dt", "value": "2025-11-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-05 00:14:01", "last_data": "2025-11-05 00:14:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652657, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-05/", "name": "dt", "value": "2025-11-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-06 00:12:53", "last_data": "2025-11-06 00:12:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652769, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-06/", "name": "dt", "value": "2025-11-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-07 00:14:46", "last_data": "2025-11-07 00:14:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652881, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-07/", "name": "dt", "value": "2025-11-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-08 00:13:37", "last_data": "2025-11-08 00:13:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652992, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-08/", "name": "dt", "value": "2025-11-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-09 00:09:36", "last_data": "2025-11-09 00:09:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653108, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-09/", "name": "dt", "value": "2025-11-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-10 00:10:52", "last_data": "2025-11-10 00:10:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653226, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-10/", "name": "dt", "value": "2025-11-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-11 00:10:51", "last_data": "2025-11-11 00:10:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653339, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-11/", "name": "dt", "value": "2025-11-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-12 00:10:43", "last_data": "2025-11-12 00:10:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653461, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-12/", "name": "dt", "value": "2025-11-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-13 00:09:51", "last_data": "2025-11-13 00:09:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653574, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-13/", "name": "dt", "value": "2025-11-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-14 00:09:29", "last_data": "2025-11-14 00:09:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653686, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-14/", "name": "dt", "value": "2025-11-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-15 00:09:30", "last_data": "2025-11-15 00:09:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653796, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-15/", "name": "dt", "value": "2025-11-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-16 00:09:21", "last_data": "2025-11-16 00:09:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 655500, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-16/", "name": "dt", "value": "2025-11-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-17 00:11:00", "last_data": "2025-11-17 00:11:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656085, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-17/", "name": "dt", "value": "2025-11-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-18 00:11:05", "last_data": "2025-11-18 00:11:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656199, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-18/", "name": "dt", "value": "2025-11-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-19 00:09:44", "last_data": "2025-11-19 00:09:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656315, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-19/", "name": "dt", "value": "2025-11-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-20 00:10:53", "last_data": "2025-11-20 00:10:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656429, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-20/", "name": "dt", "value": "2025-11-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-21 00:09:48", "last_data": "2025-11-21 00:09:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656541, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-21/", "name": "dt", "value": "2025-11-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-22 00:11:00", "last_data": "2025-11-22 00:11:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656651, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-22/", "name": "dt", "value": "2025-11-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-23 00:09:46", "last_data": "2025-11-23 00:09:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656762, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-23/", "name": "dt", "value": "2025-11-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-24 00:10:00", "last_data": "2025-11-24 00:10:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656884, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-24/", "name": "dt", "value": "2025-11-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-25 00:10:57", "last_data": "2025-11-25 00:10:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657405, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-10/", "name": "dt", "value": "2025-12-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-11 00:11:08", "last_data": "2025-12-11 00:11:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657526, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-11/", "name": "dt", "value": "2025-12-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-12 00:09:44", "last_data": "2025-12-12 00:09:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657643, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-12/", "name": "dt", "value": "2025-12-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-13 00:09:39", "last_data": "2025-12-13 00:09:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657757, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-13/", "name": "dt", "value": "2025-12-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-14 00:11:13", "last_data": "2025-12-14 00:11:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657869, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-14/", "name": "dt", "value": "2025-12-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-15 00:12:46", "last_data": "2025-12-15 00:12:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657981, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-15/", "name": "dt", "value": "2025-12-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-16 00:04:10", "last_data": "2025-12-16 00:04:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658108, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-16/", "name": "dt", "value": "2025-12-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-17 00:11:17", "last_data": "2025-12-17 00:11:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658226, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-17/", "name": "dt", "value": "2025-12-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-18 00:09:54", "last_data": "2025-12-18 00:09:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658340, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-18/", "name": "dt", "value": "2025-12-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-19 00:11:06", "last_data": "2025-12-19 00:11:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658457, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-19/", "name": "dt", "value": "2025-12-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-20 00:11:26", "last_data": "2025-12-20 00:11:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658571, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-20/", "name": "dt", "value": "2025-12-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-21 00:10:50", "last_data": "2025-12-21 00:10:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658686, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-21/", "name": "dt", "value": "2025-12-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-22 00:09:33", "last_data": "2025-12-22 00:09:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658856, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-22/", "name": "dt", "value": "2025-12-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-23 00:09:34", "last_data": "2025-12-23 00:09:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658972, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-23/", "name": "dt", "value": "2025-12-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-24 00:09:56", "last_data": "2025-12-24 00:09:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659091, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-24/", "name": "dt", "value": "2025-12-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-25 00:09:44", "last_data": "2025-12-25 00:09:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659205, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-25/", "name": "dt", "value": "2025-12-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-26 00:09:49", "last_data": "2025-12-26 00:09:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659320, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-26/", "name": "dt", "value": "2025-12-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-27 00:09:48", "last_data": "2025-12-27 00:09:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659435, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-27/", "name": "dt", "value": "2025-12-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-28 00:09:19", "last_data": "2025-12-28 00:09:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659550, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-28/", "name": "dt", "value": "2025-12-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-29 00:10:50", "last_data": "2025-12-29 00:10:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659670, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-29/", "name": "dt", "value": "2025-12-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-30 00:09:27", "last_data": "2025-12-30 00:09:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659787, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-30/", "name": "dt", "value": "2025-12-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-31 00:09:30", "last_data": "2025-12-31 00:09:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659905, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-31/", "name": "dt", "value": "2025-12-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-01 00:11:01", "last_data": "2026-01-01 00:11:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660033, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-01/", "name": "dt", "value": "2026-01-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-02 00:09:49", "last_data": "2026-01-02 00:09:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660150, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-02/", "name": "dt", "value": "2026-01-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-03 00:10:52", "last_data": "2026-01-03 00:10:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660265, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-03/", "name": "dt", "value": "2026-01-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-04 00:09:31", "last_data": "2026-01-04 00:09:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660382, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-04/", "name": "dt", "value": "2026-01-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-05 00:11:03", "last_data": "2026-01-05 00:11:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660500, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-05/", "name": "dt", "value": "2026-01-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-06 00:10:23", "last_data": "2026-01-06 00:10:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660618, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-06/", "name": "dt", "value": "2026-01-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-07 00:09:59", "last_data": "2026-01-07 00:09:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660736, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-07/", "name": "dt", "value": "2026-01-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-08 00:09:28", "last_data": "2026-01-08 00:09:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660854, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-08/", "name": "dt", "value": "2026-01-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-09 00:09:36", "last_data": "2026-01-09 00:09:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660971, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-09/", "name": "dt", "value": "2026-01-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-10 00:09:35", "last_data": "2026-01-10 00:09:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661086, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-10/", "name": "dt", "value": "2026-01-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-11 00:12:49", "last_data": "2026-01-11 00:12:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661203, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-11/", "name": "dt", "value": "2026-01-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-12 00:10:36", "last_data": "2026-01-12 00:10:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661322, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-12/", "name": "dt", "value": "2026-01-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-13 00:13:08", "last_data": "2026-01-13 00:13:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661437, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-13/", "name": "dt", "value": "2026-01-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-14 00:12:21", "last_data": "2026-01-14 00:12:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661555, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-14/", "name": "dt", "value": "2026-01-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-15 00:12:34", "last_data": "2026-01-15 00:12:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661672, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-15/", "name": "dt", "value": "2026-01-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-16 00:12:13", "last_data": "2026-01-16 00:12:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661789, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-16/", "name": "dt", "value": "2026-01-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-17 00:10:41", "last_data": "2026-01-17 00:10:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661903, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-17/", "name": "dt", "value": "2026-01-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-18 00:10:26", "last_data": "2026-01-18 00:10:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662020, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-18/", "name": "dt", "value": "2026-01-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-19 00:12:31", "last_data": "2026-01-19 00:12:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662140, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-19/", "name": "dt", "value": "2026-01-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-20 00:12:47", "last_data": "2026-01-20 00:12:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662255, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-20/", "name": "dt", "value": "2026-01-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-21 00:12:34", "last_data": "2026-01-21 00:12:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662427, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-21/", "name": "dt", "value": "2026-01-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-22 00:11:19", "last_data": "2026-01-22 00:11:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662542, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-22/", "name": "dt", "value": "2026-01-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-23 00:11:31", "last_data": "2026-01-23 00:11:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662661, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-23/", "name": "dt", "value": "2026-01-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-24 00:10:44", "last_data": "2026-01-24 00:10:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662776, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-24/", "name": "dt", "value": "2026-01-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-25 00:11:30", "last_data": "2026-01-25 00:11:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662892, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-25/", "name": "dt", "value": "2026-01-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-26 00:11:20", "last_data": "2026-01-26 00:11:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 663012, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-26/", "name": "dt", "value": "2026-01-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-27 00:12:52", "last_data": "2026-01-27 00:12:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 663129, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-27/", "name": "dt", "value": "2026-01-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-28 00:09:55", "last_data": "2026-01-28 00:09:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 663245, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-28/", "name": "dt", "value": "2026-01-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-29 00:09:52", "last_data": "2026-01-29 00:09:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666089, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-29/", "name": "dt", "value": "2026-01-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-30 00:11:35", "last_data": "2026-01-30 00:11:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666207, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-30/", "name": "dt", "value": "2026-01-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-31 00:10:51", "last_data": "2026-01-31 00:10:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666324, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-31/", "name": "dt", "value": "2026-01-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-01 00:11:19", "last_data": "2026-02-01 00:11:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666456, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-01/", "name": "dt", "value": "2026-02-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-02 00:09:23", "last_data": "2026-02-02 00:09:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666575, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-02/", "name": "dt", "value": "2026-02-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-03 00:09:34", "last_data": "2026-02-03 00:09:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666694, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-03/", "name": "dt", "value": "2026-02-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-04 00:09:48", "last_data": "2026-02-04 00:09:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666813, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-04/", "name": "dt", "value": "2026-02-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-05 00:11:20", "last_data": "2026-02-05 00:11:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666929, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-05/", "name": "dt", "value": "2026-02-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-06 00:11:02", "last_data": "2026-02-06 00:11:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667044, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-06/", "name": "dt", "value": "2026-02-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-07 00:11:02", "last_data": "2026-02-07 00:11:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667158, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-07/", "name": "dt", "value": "2026-02-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-08 00:09:40", "last_data": "2026-02-08 00:09:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667272, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-08/", "name": "dt", "value": "2026-02-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-09 00:11:20", "last_data": "2026-02-09 00:11:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667389, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-09/", "name": "dt", "value": "2026-02-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-10 00:11:52", "last_data": "2026-02-10 00:11:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667508, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-10/", "name": "dt", "value": "2026-02-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-11 00:11:30", "last_data": "2026-02-11 00:11:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667628, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-11/", "name": "dt", "value": "2026-02-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-12 00:09:55", "last_data": "2026-02-12 00:09:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667745, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-12/", "name": "dt", "value": "2026-02-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-13 00:10:25", "last_data": "2026-02-13 00:10:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667863, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-13/", "name": "dt", "value": "2026-02-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-14 00:09:55", "last_data": "2026-02-14 00:09:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667977, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-14/", "name": "dt", "value": "2026-02-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-15 00:11:16", "last_data": "2026-02-15 00:11:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668092, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-15/", "name": "dt", "value": "2026-02-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-16 00:11:15", "last_data": "2026-02-16 00:11:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668212, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-16/", "name": "dt", "value": "2026-02-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-17 00:11:55", "last_data": "2026-02-17 00:11:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668333, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-17/", "name": "dt", "value": "2026-02-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-18 00:17:02", "last_data": "2026-02-18 00:17:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668451, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-18/", "name": "dt", "value": "2026-02-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-19 00:13:20", "last_data": "2026-02-19 00:13:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668569, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-19/", "name": "dt", "value": "2026-02-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-20 00:11:00", "last_data": "2026-02-20 00:11:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668684, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-20/", "name": "dt", "value": "2026-02-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-21 00:13:04", "last_data": "2026-02-21 00:13:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668801, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-21/", "name": "dt", "value": "2026-02-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-22 00:22:24", "last_data": "2026-02-22 00:22:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668916, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-22/", "name": "dt", "value": "2026-02-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-23 00:17:18", "last_data": "2026-02-23 00:17:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669035, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-23/", "name": "dt", "value": "2026-02-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-24 00:17:01", "last_data": "2026-02-24 00:17:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669153, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-24/", "name": "dt", "value": "2026-02-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-25 00:17:50", "last_data": "2026-02-25 00:17:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669272, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-25/", "name": "dt", "value": "2026-02-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-26 00:15:31", "last_data": "2026-02-26 00:15:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669389, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-26/", "name": "dt", "value": "2026-02-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-27 00:11:55", "last_data": "2026-02-27 00:11:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669506, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-27/", "name": "dt", "value": "2026-02-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-28 00:11:04", "last_data": "2026-02-28 00:11:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669620, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-28/", "name": "dt", "value": "2026-02-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-01 00:13:42", "last_data": "2026-03-01 00:13:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669746, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-01/", "name": "dt", "value": "2026-03-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-02 00:15:50", "last_data": "2026-03-02 00:15:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669865, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-02/", "name": "dt", "value": "2026-03-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-03 00:17:51", "last_data": "2026-03-03 00:17:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669983, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-03/", "name": "dt", "value": "2026-03-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-04 00:18:00", "last_data": "2026-03-04 00:18:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670142, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-04/", "name": "dt", "value": "2026-03-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-05 00:13:12", "last_data": "2026-03-05 00:13:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670260, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-05/", "name": "dt", "value": "2026-03-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-06 00:14:32", "last_data": "2026-03-06 00:14:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670378, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-06/", "name": "dt", "value": "2026-03-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-07 00:09:56", "last_data": "2026-03-07 00:09:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670492, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-07/", "name": "dt", "value": "2026-03-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-08 00:17:46", "last_data": "2026-03-08 00:17:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670609, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-08/", "name": "dt", "value": "2026-03-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-09 00:17:41", "last_data": "2026-03-09 00:17:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670728, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-09/", "name": "dt", "value": "2026-03-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-10 00:15:43", "last_data": "2026-03-10 00:15:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670846, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-10/", "name": "dt", "value": "2026-03-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-11 00:40:26", "last_data": "2026-03-11 00:40:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670964, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-11/", "name": "dt", "value": "2026-03-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-12 00:17:13", "last_data": "2026-03-12 00:17:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671082, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-12/", "name": "dt", "value": "2026-03-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-13 00:10:14", "last_data": "2026-03-13 00:10:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671200, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-13/", "name": "dt", "value": "2026-03-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-14 00:12:01", "last_data": "2026-03-14 00:12:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671315, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-14/", "name": "dt", "value": "2026-03-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-15 00:11:50", "last_data": "2026-03-15 00:11:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671430, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-15/", "name": "dt", "value": "2026-03-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-16 00:10:02", "last_data": "2026-03-16 00:10:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671551, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-16/", "name": "dt", "value": "2026-03-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-17 00:11:32", "last_data": "2026-03-17 00:11:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671666, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-17/", "name": "dt", "value": "2026-03-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-18 00:09:50", "last_data": "2026-03-18 00:09:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671786, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/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": 671902, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-19/", "name": "dt", "value": "2026-03-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-20 00:11:50", "last_data": "2026-03-20 00:11:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672020, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-20/", "name": "dt", "value": "2026-03-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-21 00:11:52", "last_data": "2026-03-21 00:11:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672136, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-21/", "name": "dt", "value": "2026-03-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-22 00:11:36", "last_data": "2026-03-22 00:11:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672253, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-22/", "name": "dt", "value": "2026-03-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-23 00:12:12", "last_data": "2026-03-23 00:12:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672375, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-23/", "name": "dt", "value": "2026-03-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-24 00:10:24", "last_data": "2026-03-24 00:10:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672495, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-24/", "name": "dt", "value": "2026-03-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-25 00:09:56", "last_data": "2026-03-25 00:09:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672610, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-25/", "name": "dt", "value": "2026-03-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-26 00:10:22", "last_data": "2026-03-26 00:10:22" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672728, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-26/", "name": "dt", "value": "2026-03-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-27 00:12:37", "last_data": "2026-03-27 00:12:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672846, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-27/", "name": "dt", "value": "2026-03-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-28 00:09:55", "last_data": "2026-03-28 00:09:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672962, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-28/", "name": "dt", "value": "2026-03-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-29 00:14:05", "last_data": "2026-03-29 00:14:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673079, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-29/", "name": "dt", "value": "2026-03-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-30 00:12:19", "last_data": "2026-03-30 00:12:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673199, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-30/", "name": "dt", "value": "2026-03-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-31 00:10:12", "last_data": "2026-03-31 00:10:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673317, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-31/", "name": "dt", "value": "2026-03-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-01 00:11:51", "last_data": "2026-04-01 00:11:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673484, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-01/", "name": "dt", "value": "2026-04-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-02 00:11:12", "last_data": "2026-04-02 00:11:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673598, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-02/", "name": "dt", "value": "2026-04-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-03 00:12:06", "last_data": "2026-04-03 00:12:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673715, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-03/", "name": "dt", "value": "2026-04-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-04 00:12:04", "last_data": "2026-04-04 00:12:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673829, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-04/", "name": "dt", "value": "2026-04-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-05 00:12:35", "last_data": "2026-04-05 00:12:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673944, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-05/", "name": "dt", "value": "2026-04-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-06 00:17:26", "last_data": "2026-04-06 00:17:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674063, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-06/", "name": "dt", "value": "2026-04-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-07 00:10:06", "last_data": "2026-04-07 00:10:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674182, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-07/", "name": "dt", "value": "2026-04-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-08 00:10:35", "last_data": "2026-04-08 00:10:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674300, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-08/", "name": "dt", "value": "2026-04-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-09 00:13:20", "last_data": "2026-04-09 00:13:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674419, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-09/", "name": "dt", "value": "2026-04-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-10 00:12:15", "last_data": "2026-04-10 00:12:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674536, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-10/", "name": "dt", "value": "2026-04-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-11 00:12:46", "last_data": "2026-04-11 00:12:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674651, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-11/", "name": "dt", "value": "2026-04-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-12 00:10:05", "last_data": "2026-04-12 00:10:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674766, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-12/", "name": "dt", "value": "2026-04-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-13 00:11:38", "last_data": "2026-04-13 00:11:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674887, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-13/", "name": "dt", "value": "2026-04-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-14 00:16:10", "last_data": "2026-04-14 00:16:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 675004, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-14/", "name": "dt", "value": "2026-04-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-15 00:10:13", "last_data": "2026-04-15 00:10:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 675123, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-15/", "name": "dt", "value": "2026-04-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-16 00:12:24", "last_data": "2026-04-16 00:12:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 675259, "location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-16/", "name": "dt", "value": "2026-04-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-17 00:10:20", "last_data": "2026-04-17 00:10:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } } ] - type: string
- attributes:
{ "alt_email": "string", "alt_first_name": "string", "alt_last_name": "string", "alt_phone": "bigint", "api_facility_id": "string", "company_name": "string", "confirmation_code": "string", "corporation_id": "int", "created": "timestamp", "customer_address1": "string", "customer_address2": "string", "customer_cell_phone": "bigint", "customer_city": "string", "customer_email": "string", "customer_first_name": "string", "customer_home_phone": "bigint", "customer_id": "string", "customer_last_name": "string", "customer_phone": "bigint", "customer_state": "string", "customer_work_email": "string", "customer_work_phone": "bigint", "customer_zip": "string", "dt_partition": "date", "facility_id": "int", "facility_name": "string", "id": "string", "last_payment_amount": "double", "lead_id": "string", "lifetime_value": "double", "listing_avail_id": "int", "match_run_id": "int", "modified": "timestamp", "move_in_date": "date", "move_out_date": "date", "rent_rate": "double", "source_type": "string", "unit_dimensions": "string", "unit_id": "string", "unit_number": "string" } - created: 2025-07-30 00:15:33
- 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_facility_tenants_temporal`\n(\n `alt_email` string , `alt_first_name` string , `alt_last_name` string , `alt_phone` bigint , `api_facility_id` string , `company_name` string , `confirmation_code` string , `corporation_id` int , `created` timestamp , `customer_address1` string , `customer_address2` string , `customer_cell_phone` bigint , `customer_city` string , `customer_email` string , `customer_first_name` string , `customer_home_phone` bigint , `customer_id` string , `customer_last_name` string , `customer_phone` bigint , `customer_state` string , `customer_work_email` string , `customer_work_phone` bigint , `customer_zip` string , `dt_partition` date , `facility_id` int , `facility_name` string , `id` string , `last_payment_amount` double , `lead_id` string , `lifetime_value` double , `listing_avail_id` int , `match_run_id` int , `modified` timestamp , `move_in_date` date , `move_out_date` date , `rent_rate` double , `source_type` string , `unit_dimensions` string , `unit_id` string , `unit_number` 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_facility_tenants_temporal'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal" }
- 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 01:15:08",
"disabled": false,
"format": "raw",
"id": 1479,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_stage_rds",
"table": "sparefoot_sparefoot_facility_tenants_temporal"
},
"type": "rds"
},
"partition": {
"count": 170,
"ddl": [
"ALTER TABLE\n `sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal`\nADD\n\n\n PARTITION (dt='2025-10-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-14/'\n PARTITION (dt='2025-10-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-15/'\n PARTITION (dt='2025-10-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-16/'\n PARTITION (dt='2025-10-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-17/'\n PARTITION (dt='2025-10-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-18/'\n PARTITION (dt='2025-10-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-19/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-20/'\n PARTITION (dt='2025-10-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-21/'\n PARTITION (dt='2025-10-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-22/'\n PARTITION (dt='2025-10-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-23/'\n PARTITION (dt='2025-10-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-24/'\n PARTITION (dt='2025-10-25') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-25/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-26/'\n PARTITION (dt='2025-10-27') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-27/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-28/'\n PARTITION (dt='2025-10-29') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-29/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-30/'\n PARTITION (dt='2025-10-31') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-31/'\n PARTITION (dt='2025-11-01') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-01/'\n PARTITION (dt='2025-11-02') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-02/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-04/'\n PARTITION (dt='2025-11-05') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-05/'\n PARTITION (dt='2025-11-06') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-06/'\n PARTITION (dt='2025-11-07') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-07/'\n PARTITION (dt='2025-11-08') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-08/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-09/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-10/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-12/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-13/'\n PARTITION (dt='2025-11-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-14/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-15/'\n PARTITION (dt='2025-11-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-16/'\n PARTITION (dt='2025-11-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-17/'\n PARTITION (dt='2025-11-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-18/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-19/'\n PARTITION (dt='2025-11-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-20/'\n PARTITION (dt='2025-11-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-21/'\n PARTITION (dt='2025-11-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-22/'\n PARTITION (dt='2025-11-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-23/'\n PARTITION (dt='2025-11-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-24/'\n PARTITION (dt='2025-12-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-10/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-12/'\n PARTITION (dt='2025-12-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-13/'\n PARTITION (dt='2025-12-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-14/'\n PARTITION (dt='2025-12-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-15/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-16/'\n PARTITION (dt='2025-12-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-17/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-19/'\n PARTITION (dt='2025-12-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-20/'\n PARTITION (dt='2025-12-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-21/'\n PARTITION (dt='2025-12-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-22/'\n PARTITION (dt='2025-12-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-23/'\n PARTITION (dt='2025-12-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-24/'\n PARTITION (dt='2025-12-25') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-25/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-26/'\n PARTITION (dt='2025-12-27') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-27/'\n PARTITION (dt='2025-12-28') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-28/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-31/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-01/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-02/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-03/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-04/'\n PARTITION (dt='2026-01-05') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-08/'\n PARTITION (dt='2026-01-09') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-09/'\n PARTITION (dt='2026-01-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-10/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-11/'\n PARTITION (dt='2026-01-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-12/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-13/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-14/'\n PARTITION (dt='2026-01-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-15/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-16/'\n PARTITION (dt='2026-01-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-17/'\n PARTITION (dt='2026-01-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-18/'\n PARTITION (dt='2026-01-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-19/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-20/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-21/'\n PARTITION (dt='2026-01-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-22/'\n PARTITION (dt='2026-01-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-23/'\n PARTITION (dt='2026-01-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-24/'\n PARTITION (dt='2026-01-25') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-25/'\n PARTITION (dt='2026-01-26') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-28/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-29/'\n PARTITION (dt='2026-01-30') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-30/'\n PARTITION (dt='2026-01-31') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-31/'\n PARTITION (dt='2026-02-01') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-01/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-04/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-05/'\n PARTITION (dt='2026-02-06') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-06/'\n PARTITION (dt='2026-02-07') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-07/'\n PARTITION (dt='2026-02-08') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-08/'\n PARTITION (dt='2026-02-09') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-09/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-11/'\n PARTITION (dt='2026-02-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-12/'\n PARTITION (dt='2026-02-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-13/'\n PARTITION (dt='2026-02-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-14/'\n PARTITION (dt='2026-02-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-15/'\n PARTITION (dt='2026-02-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-16/'\n PARTITION (dt='2026-02-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-17/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-18/'\n PARTITION (dt='2026-02-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-19/'\n PARTITION (dt='2026-02-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-20/'\n PARTITION (dt='2026-02-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-21/'\n PARTITION (dt='2026-02-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-22/'\n PARTITION (dt='2026-02-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-23/'\n PARTITION (dt='2026-02-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-24/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-25/'\n PARTITION (dt='2026-02-26') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-26/'\n PARTITION (dt='2026-02-27') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-27/'\n PARTITION (dt='2026-02-28') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-28/'\n PARTITION (dt='2026-03-01') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-01/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-02/'\n PARTITION (dt='2026-03-03') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-03/'\n PARTITION (dt='2026-03-04') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-04/'\n PARTITION (dt='2026-03-05') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-05/'\n PARTITION (dt='2026-03-06') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-06/'\n PARTITION (dt='2026-03-07') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-07/'\n PARTITION (dt='2026-03-08') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-08/'\n PARTITION (dt='2026-03-09') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-09/'\n PARTITION (dt='2026-03-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-10/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-11/'\n PARTITION (dt='2026-03-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-12/'\n PARTITION (dt='2026-03-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-13/'\n PARTITION (dt='2026-03-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-14/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-15/'\n PARTITION (dt='2026-03-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-16/'\n PARTITION (dt='2026-03-17') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-17/'\n PARTITION (dt='2026-03-18') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-18/'\n PARTITION (dt='2026-03-19') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-19/'\n PARTITION (dt='2026-03-20') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-20/'\n PARTITION (dt='2026-03-21') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-21/'\n PARTITION (dt='2026-03-22') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-22/'\n PARTITION (dt='2026-03-23') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-23/'\n PARTITION (dt='2026-03-24') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-24/'\n PARTITION (dt='2026-03-25') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-25/'\n PARTITION (dt='2026-03-26') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-26/'\n PARTITION (dt='2026-03-27') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-27/'\n PARTITION (dt='2026-03-28') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-28/'\n PARTITION (dt='2026-03-29') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-29/'\n PARTITION (dt='2026-03-30') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-30/'\n PARTITION (dt='2026-03-31') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-31/'\n PARTITION (dt='2026-04-01') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-01/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-02/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-03/'\n PARTITION (dt='2026-04-04') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-04/'\n PARTITION (dt='2026-04-05') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-05/'\n PARTITION (dt='2026-04-06') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-06/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-07/'\n PARTITION (dt='2026-04-08') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-08/'\n PARTITION (dt='2026-04-09') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-09/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-10/'\n PARTITION (dt='2026-04-11') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-11/'\n PARTITION (dt='2026-04-12') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-12/'\n PARTITION (dt='2026-04-13') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-13/'\n PARTITION (dt='2026-04-14') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-14/'\n PARTITION (dt='2026-04-15') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-15/'\n PARTITION (dt='2026-04-16') location 's3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-16/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 650139,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-14/",
"name": "dt",
"value": "2025-10-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-15 00:10:28",
"last_data": "2025-10-15 00:10:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650254,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-15/",
"name": "dt",
"value": "2025-10-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-16 00:10:53",
"last_data": "2025-10-16 00:10:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650369,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-16/",
"name": "dt",
"value": "2025-10-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-17 00:09:13",
"last_data": "2025-10-17 00:09:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650485,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-17/",
"name": "dt",
"value": "2025-10-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-18 00:09:55",
"last_data": "2025-10-18 00:09:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650600,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-18/",
"name": "dt",
"value": "2025-10-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-19 00:09:31",
"last_data": "2025-10-19 00:09:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650713,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-19/",
"name": "dt",
"value": "2025-10-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-20 00:09:16",
"last_data": "2025-10-20 00:09:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650830,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-20/",
"name": "dt",
"value": "2025-10-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-21 00:11:34",
"last_data": "2025-10-21 00:11:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650943,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-21/",
"name": "dt",
"value": "2025-10-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-22 00:12:05",
"last_data": "2025-10-22 00:12:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651057,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-22/",
"name": "dt",
"value": "2025-10-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-23 00:12:40",
"last_data": "2025-10-23 00:12:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651170,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-23/",
"name": "dt",
"value": "2025-10-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-24 00:12:17",
"last_data": "2025-10-24 00:12:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651282,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-24/",
"name": "dt",
"value": "2025-10-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-25 00:13:56",
"last_data": "2025-10-25 00:13:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651395,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-25/",
"name": "dt",
"value": "2025-10-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-26 00:12:38",
"last_data": "2025-10-26 00:12:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651507,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-26/",
"name": "dt",
"value": "2025-10-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-27 00:19:35",
"last_data": "2025-10-27 00:19:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651629,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-27/",
"name": "dt",
"value": "2025-10-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-28 00:15:27",
"last_data": "2025-10-28 00:15:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651742,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-28/",
"name": "dt",
"value": "2025-10-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-29 00:17:50",
"last_data": "2025-10-29 00:17:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651857,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-29/",
"name": "dt",
"value": "2025-10-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-30 00:13:25",
"last_data": "2025-10-30 00:13:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651968,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-30/",
"name": "dt",
"value": "2025-10-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-31 00:13:10",
"last_data": "2025-10-31 00:13:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652079,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-10-31/",
"name": "dt",
"value": "2025-10-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-01 00:12:06",
"last_data": "2025-11-01 00:12:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652199,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-01/",
"name": "dt",
"value": "2025-11-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-02 00:11:39",
"last_data": "2025-11-02 00:11:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652310,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-02/",
"name": "dt",
"value": "2025-11-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-03 00:13:11",
"last_data": "2025-11-03 00:13:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652431,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-03/",
"name": "dt",
"value": "2025-11-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-04 00:12:19",
"last_data": "2025-11-04 00:12:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652545,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-04/",
"name": "dt",
"value": "2025-11-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-05 00:14:01",
"last_data": "2025-11-05 00:14:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652657,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-05/",
"name": "dt",
"value": "2025-11-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-06 00:12:53",
"last_data": "2025-11-06 00:12:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652769,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-06/",
"name": "dt",
"value": "2025-11-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-07 00:14:46",
"last_data": "2025-11-07 00:14:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652881,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-07/",
"name": "dt",
"value": "2025-11-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-08 00:13:37",
"last_data": "2025-11-08 00:13:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652992,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-08/",
"name": "dt",
"value": "2025-11-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-09 00:09:36",
"last_data": "2025-11-09 00:09:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653108,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-09/",
"name": "dt",
"value": "2025-11-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-10 00:10:52",
"last_data": "2025-11-10 00:10:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653226,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-10/",
"name": "dt",
"value": "2025-11-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-11 00:10:51",
"last_data": "2025-11-11 00:10:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653339,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-11/",
"name": "dt",
"value": "2025-11-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-12 00:10:43",
"last_data": "2025-11-12 00:10:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653461,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-12/",
"name": "dt",
"value": "2025-11-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-13 00:09:51",
"last_data": "2025-11-13 00:09:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653574,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-13/",
"name": "dt",
"value": "2025-11-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-14 00:09:29",
"last_data": "2025-11-14 00:09:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653686,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-14/",
"name": "dt",
"value": "2025-11-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-15 00:09:30",
"last_data": "2025-11-15 00:09:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653796,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-15/",
"name": "dt",
"value": "2025-11-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-16 00:09:21",
"last_data": "2025-11-16 00:09:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 655500,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-16/",
"name": "dt",
"value": "2025-11-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-17 00:11:00",
"last_data": "2025-11-17 00:11:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656085,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-17/",
"name": "dt",
"value": "2025-11-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-18 00:11:05",
"last_data": "2025-11-18 00:11:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656199,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-18/",
"name": "dt",
"value": "2025-11-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-19 00:09:44",
"last_data": "2025-11-19 00:09:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656315,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-19/",
"name": "dt",
"value": "2025-11-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-20 00:10:53",
"last_data": "2025-11-20 00:10:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656429,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-20/",
"name": "dt",
"value": "2025-11-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-21 00:09:48",
"last_data": "2025-11-21 00:09:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656541,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-21/",
"name": "dt",
"value": "2025-11-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-22 00:11:00",
"last_data": "2025-11-22 00:11:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656651,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-22/",
"name": "dt",
"value": "2025-11-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-23 00:09:46",
"last_data": "2025-11-23 00:09:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656762,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-23/",
"name": "dt",
"value": "2025-11-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-24 00:10:00",
"last_data": "2025-11-24 00:10:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656884,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-11-24/",
"name": "dt",
"value": "2025-11-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-25 00:10:57",
"last_data": "2025-11-25 00:10:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657405,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-10/",
"name": "dt",
"value": "2025-12-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-11 00:11:08",
"last_data": "2025-12-11 00:11:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657526,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-11/",
"name": "dt",
"value": "2025-12-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-12 00:09:44",
"last_data": "2025-12-12 00:09:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657643,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-12/",
"name": "dt",
"value": "2025-12-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-13 00:09:39",
"last_data": "2025-12-13 00:09:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657757,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-13/",
"name": "dt",
"value": "2025-12-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-14 00:11:13",
"last_data": "2025-12-14 00:11:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657869,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-14/",
"name": "dt",
"value": "2025-12-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-15 00:12:46",
"last_data": "2025-12-15 00:12:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657981,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-15/",
"name": "dt",
"value": "2025-12-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-16 00:04:10",
"last_data": "2025-12-16 00:04:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658108,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-16/",
"name": "dt",
"value": "2025-12-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-17 00:11:17",
"last_data": "2025-12-17 00:11:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658226,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-17/",
"name": "dt",
"value": "2025-12-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-18 00:09:54",
"last_data": "2025-12-18 00:09:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658340,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-18/",
"name": "dt",
"value": "2025-12-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-19 00:11:06",
"last_data": "2025-12-19 00:11:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658457,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-19/",
"name": "dt",
"value": "2025-12-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-20 00:11:26",
"last_data": "2025-12-20 00:11:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658571,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-20/",
"name": "dt",
"value": "2025-12-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-21 00:10:50",
"last_data": "2025-12-21 00:10:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658686,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-21/",
"name": "dt",
"value": "2025-12-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-22 00:09:33",
"last_data": "2025-12-22 00:09:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658856,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-22/",
"name": "dt",
"value": "2025-12-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-23 00:09:34",
"last_data": "2025-12-23 00:09:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658972,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-23/",
"name": "dt",
"value": "2025-12-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-24 00:09:56",
"last_data": "2025-12-24 00:09:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659091,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-24/",
"name": "dt",
"value": "2025-12-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-25 00:09:44",
"last_data": "2025-12-25 00:09:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659205,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-25/",
"name": "dt",
"value": "2025-12-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-26 00:09:49",
"last_data": "2025-12-26 00:09:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659320,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-26/",
"name": "dt",
"value": "2025-12-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-27 00:09:48",
"last_data": "2025-12-27 00:09:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659435,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-27/",
"name": "dt",
"value": "2025-12-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-28 00:09:19",
"last_data": "2025-12-28 00:09:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659550,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-28/",
"name": "dt",
"value": "2025-12-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-29 00:10:50",
"last_data": "2025-12-29 00:10:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659670,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-29/",
"name": "dt",
"value": "2025-12-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-30 00:09:27",
"last_data": "2025-12-30 00:09:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659787,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-30/",
"name": "dt",
"value": "2025-12-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-31 00:09:30",
"last_data": "2025-12-31 00:09:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659905,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2025-12-31/",
"name": "dt",
"value": "2025-12-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-01 00:11:01",
"last_data": "2026-01-01 00:11:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660033,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-01/",
"name": "dt",
"value": "2026-01-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-02 00:09:49",
"last_data": "2026-01-02 00:09:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660150,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-02/",
"name": "dt",
"value": "2026-01-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-03 00:10:52",
"last_data": "2026-01-03 00:10:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660265,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-03/",
"name": "dt",
"value": "2026-01-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-04 00:09:31",
"last_data": "2026-01-04 00:09:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660382,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-04/",
"name": "dt",
"value": "2026-01-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-05 00:11:03",
"last_data": "2026-01-05 00:11:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660500,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-05/",
"name": "dt",
"value": "2026-01-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-06 00:10:23",
"last_data": "2026-01-06 00:10:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660618,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-06/",
"name": "dt",
"value": "2026-01-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-07 00:09:59",
"last_data": "2026-01-07 00:09:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660736,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-07/",
"name": "dt",
"value": "2026-01-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-08 00:09:28",
"last_data": "2026-01-08 00:09:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660854,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-08/",
"name": "dt",
"value": "2026-01-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-09 00:09:36",
"last_data": "2026-01-09 00:09:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660971,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-09/",
"name": "dt",
"value": "2026-01-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-10 00:09:35",
"last_data": "2026-01-10 00:09:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661086,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-10/",
"name": "dt",
"value": "2026-01-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-11 00:12:49",
"last_data": "2026-01-11 00:12:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661203,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-11/",
"name": "dt",
"value": "2026-01-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-12 00:10:36",
"last_data": "2026-01-12 00:10:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661322,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-12/",
"name": "dt",
"value": "2026-01-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-13 00:13:08",
"last_data": "2026-01-13 00:13:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661437,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-13/",
"name": "dt",
"value": "2026-01-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-14 00:12:21",
"last_data": "2026-01-14 00:12:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661555,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-14/",
"name": "dt",
"value": "2026-01-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-15 00:12:34",
"last_data": "2026-01-15 00:12:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661672,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-15/",
"name": "dt",
"value": "2026-01-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-16 00:12:13",
"last_data": "2026-01-16 00:12:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661789,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-16/",
"name": "dt",
"value": "2026-01-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-17 00:10:41",
"last_data": "2026-01-17 00:10:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661903,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-17/",
"name": "dt",
"value": "2026-01-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-18 00:10:26",
"last_data": "2026-01-18 00:10:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662020,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-18/",
"name": "dt",
"value": "2026-01-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-19 00:12:31",
"last_data": "2026-01-19 00:12:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662140,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-19/",
"name": "dt",
"value": "2026-01-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-20 00:12:47",
"last_data": "2026-01-20 00:12:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662255,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-20/",
"name": "dt",
"value": "2026-01-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-21 00:12:34",
"last_data": "2026-01-21 00:12:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662427,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-21/",
"name": "dt",
"value": "2026-01-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-22 00:11:19",
"last_data": "2026-01-22 00:11:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662542,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-22/",
"name": "dt",
"value": "2026-01-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-23 00:11:31",
"last_data": "2026-01-23 00:11:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662661,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-23/",
"name": "dt",
"value": "2026-01-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-24 00:10:44",
"last_data": "2026-01-24 00:10:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662776,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-24/",
"name": "dt",
"value": "2026-01-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-25 00:11:30",
"last_data": "2026-01-25 00:11:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662892,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-25/",
"name": "dt",
"value": "2026-01-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-26 00:11:20",
"last_data": "2026-01-26 00:11:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 663012,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-26/",
"name": "dt",
"value": "2026-01-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-27 00:12:52",
"last_data": "2026-01-27 00:12:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 663129,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-27/",
"name": "dt",
"value": "2026-01-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-28 00:09:55",
"last_data": "2026-01-28 00:09:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 663245,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-28/",
"name": "dt",
"value": "2026-01-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-29 00:09:52",
"last_data": "2026-01-29 00:09:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666089,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-29/",
"name": "dt",
"value": "2026-01-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-30 00:11:35",
"last_data": "2026-01-30 00:11:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666207,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-30/",
"name": "dt",
"value": "2026-01-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-31 00:10:51",
"last_data": "2026-01-31 00:10:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666324,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-01-31/",
"name": "dt",
"value": "2026-01-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-01 00:11:19",
"last_data": "2026-02-01 00:11:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666456,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-01/",
"name": "dt",
"value": "2026-02-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-02 00:09:23",
"last_data": "2026-02-02 00:09:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666575,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-02/",
"name": "dt",
"value": "2026-02-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-03 00:09:34",
"last_data": "2026-02-03 00:09:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666694,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-03/",
"name": "dt",
"value": "2026-02-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-04 00:09:48",
"last_data": "2026-02-04 00:09:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666813,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-04/",
"name": "dt",
"value": "2026-02-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-05 00:11:20",
"last_data": "2026-02-05 00:11:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666929,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-05/",
"name": "dt",
"value": "2026-02-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-06 00:11:02",
"last_data": "2026-02-06 00:11:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667044,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-06/",
"name": "dt",
"value": "2026-02-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-07 00:11:02",
"last_data": "2026-02-07 00:11:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667158,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-07/",
"name": "dt",
"value": "2026-02-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-08 00:09:40",
"last_data": "2026-02-08 00:09:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667272,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-08/",
"name": "dt",
"value": "2026-02-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-09 00:11:20",
"last_data": "2026-02-09 00:11:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667389,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-09/",
"name": "dt",
"value": "2026-02-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-10 00:11:52",
"last_data": "2026-02-10 00:11:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667508,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-10/",
"name": "dt",
"value": "2026-02-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-11 00:11:30",
"last_data": "2026-02-11 00:11:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667628,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-11/",
"name": "dt",
"value": "2026-02-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-12 00:09:55",
"last_data": "2026-02-12 00:09:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667745,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-12/",
"name": "dt",
"value": "2026-02-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-13 00:10:25",
"last_data": "2026-02-13 00:10:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667863,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-13/",
"name": "dt",
"value": "2026-02-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-14 00:09:55",
"last_data": "2026-02-14 00:09:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667977,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-14/",
"name": "dt",
"value": "2026-02-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-15 00:11:16",
"last_data": "2026-02-15 00:11:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668092,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-15/",
"name": "dt",
"value": "2026-02-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-16 00:11:15",
"last_data": "2026-02-16 00:11:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668212,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-16/",
"name": "dt",
"value": "2026-02-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-17 00:11:55",
"last_data": "2026-02-17 00:11:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668333,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-17/",
"name": "dt",
"value": "2026-02-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-18 00:17:02",
"last_data": "2026-02-18 00:17:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668451,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-18/",
"name": "dt",
"value": "2026-02-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-19 00:13:20",
"last_data": "2026-02-19 00:13:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668569,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-19/",
"name": "dt",
"value": "2026-02-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-20 00:11:00",
"last_data": "2026-02-20 00:11:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668684,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-20/",
"name": "dt",
"value": "2026-02-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-21 00:13:04",
"last_data": "2026-02-21 00:13:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668801,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-21/",
"name": "dt",
"value": "2026-02-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-22 00:22:24",
"last_data": "2026-02-22 00:22:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668916,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-22/",
"name": "dt",
"value": "2026-02-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-23 00:17:18",
"last_data": "2026-02-23 00:17:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669035,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-23/",
"name": "dt",
"value": "2026-02-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-24 00:17:01",
"last_data": "2026-02-24 00:17:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669153,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-24/",
"name": "dt",
"value": "2026-02-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-25 00:17:50",
"last_data": "2026-02-25 00:17:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669272,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-25/",
"name": "dt",
"value": "2026-02-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-26 00:15:31",
"last_data": "2026-02-26 00:15:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669389,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-26/",
"name": "dt",
"value": "2026-02-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-27 00:11:55",
"last_data": "2026-02-27 00:11:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669506,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-27/",
"name": "dt",
"value": "2026-02-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-28 00:11:04",
"last_data": "2026-02-28 00:11:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669620,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-02-28/",
"name": "dt",
"value": "2026-02-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-01 00:13:42",
"last_data": "2026-03-01 00:13:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669746,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-01/",
"name": "dt",
"value": "2026-03-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-02 00:15:50",
"last_data": "2026-03-02 00:15:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669865,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-02/",
"name": "dt",
"value": "2026-03-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-03 00:17:51",
"last_data": "2026-03-03 00:17:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669983,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-03/",
"name": "dt",
"value": "2026-03-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-04 00:18:00",
"last_data": "2026-03-04 00:18:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670142,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-04/",
"name": "dt",
"value": "2026-03-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-05 00:13:12",
"last_data": "2026-03-05 00:13:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670260,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-05/",
"name": "dt",
"value": "2026-03-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-06 00:14:32",
"last_data": "2026-03-06 00:14:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670378,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-06/",
"name": "dt",
"value": "2026-03-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-07 00:09:56",
"last_data": "2026-03-07 00:09:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670492,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-07/",
"name": "dt",
"value": "2026-03-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-08 00:17:46",
"last_data": "2026-03-08 00:17:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670609,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-08/",
"name": "dt",
"value": "2026-03-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-09 00:17:41",
"last_data": "2026-03-09 00:17:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670728,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-09/",
"name": "dt",
"value": "2026-03-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-10 00:15:43",
"last_data": "2026-03-10 00:15:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670846,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-10/",
"name": "dt",
"value": "2026-03-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-11 00:40:26",
"last_data": "2026-03-11 00:40:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670964,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-11/",
"name": "dt",
"value": "2026-03-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-12 00:17:13",
"last_data": "2026-03-12 00:17:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671082,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-12/",
"name": "dt",
"value": "2026-03-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-13 00:10:14",
"last_data": "2026-03-13 00:10:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671200,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-13/",
"name": "dt",
"value": "2026-03-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-14 00:12:01",
"last_data": "2026-03-14 00:12:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671315,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-14/",
"name": "dt",
"value": "2026-03-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-15 00:11:50",
"last_data": "2026-03-15 00:11:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671430,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-15/",
"name": "dt",
"value": "2026-03-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-16 00:10:02",
"last_data": "2026-03-16 00:10:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671551,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-16/",
"name": "dt",
"value": "2026-03-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-17 00:11:32",
"last_data": "2026-03-17 00:11:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671666,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-17/",
"name": "dt",
"value": "2026-03-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-18 00:09:50",
"last_data": "2026-03-18 00:09:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671786,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/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": 671902,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-19/",
"name": "dt",
"value": "2026-03-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-20 00:11:50",
"last_data": "2026-03-20 00:11:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672020,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-20/",
"name": "dt",
"value": "2026-03-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-21 00:11:52",
"last_data": "2026-03-21 00:11:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672136,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-21/",
"name": "dt",
"value": "2026-03-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-22 00:11:36",
"last_data": "2026-03-22 00:11:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672253,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-22/",
"name": "dt",
"value": "2026-03-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-23 00:12:12",
"last_data": "2026-03-23 00:12:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672375,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-23/",
"name": "dt",
"value": "2026-03-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-24 00:10:24",
"last_data": "2026-03-24 00:10:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672495,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-24/",
"name": "dt",
"value": "2026-03-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-25 00:09:56",
"last_data": "2026-03-25 00:09:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672610,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-25/",
"name": "dt",
"value": "2026-03-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-26 00:10:22",
"last_data": "2026-03-26 00:10:22"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672728,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-26/",
"name": "dt",
"value": "2026-03-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-27 00:12:37",
"last_data": "2026-03-27 00:12:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672846,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-27/",
"name": "dt",
"value": "2026-03-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-28 00:09:55",
"last_data": "2026-03-28 00:09:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672962,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-28/",
"name": "dt",
"value": "2026-03-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-29 00:14:05",
"last_data": "2026-03-29 00:14:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673079,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-29/",
"name": "dt",
"value": "2026-03-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-30 00:12:19",
"last_data": "2026-03-30 00:12:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673199,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-30/",
"name": "dt",
"value": "2026-03-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-31 00:10:12",
"last_data": "2026-03-31 00:10:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673317,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-03-31/",
"name": "dt",
"value": "2026-03-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-01 00:11:51",
"last_data": "2026-04-01 00:11:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673484,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-01/",
"name": "dt",
"value": "2026-04-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-02 00:11:12",
"last_data": "2026-04-02 00:11:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673598,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-02/",
"name": "dt",
"value": "2026-04-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-03 00:12:06",
"last_data": "2026-04-03 00:12:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673715,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-03/",
"name": "dt",
"value": "2026-04-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-04 00:12:04",
"last_data": "2026-04-04 00:12:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673829,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-04/",
"name": "dt",
"value": "2026-04-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-05 00:12:35",
"last_data": "2026-04-05 00:12:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673944,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-05/",
"name": "dt",
"value": "2026-04-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-06 00:17:26",
"last_data": "2026-04-06 00:17:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674063,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-06/",
"name": "dt",
"value": "2026-04-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-07 00:10:06",
"last_data": "2026-04-07 00:10:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674182,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-07/",
"name": "dt",
"value": "2026-04-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-08 00:10:35",
"last_data": "2026-04-08 00:10:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674300,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-08/",
"name": "dt",
"value": "2026-04-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-09 00:13:20",
"last_data": "2026-04-09 00:13:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674419,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-09/",
"name": "dt",
"value": "2026-04-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-10 00:12:15",
"last_data": "2026-04-10 00:12:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674536,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-10/",
"name": "dt",
"value": "2026-04-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-11 00:12:46",
"last_data": "2026-04-11 00:12:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674651,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-11/",
"name": "dt",
"value": "2026-04-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-12 00:10:05",
"last_data": "2026-04-12 00:10:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674766,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-12/",
"name": "dt",
"value": "2026-04-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-13 00:11:38",
"last_data": "2026-04-13 00:11:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674887,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-13/",
"name": "dt",
"value": "2026-04-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-14 00:16:10",
"last_data": "2026-04-14 00:16:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 675004,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-14/",
"name": "dt",
"value": "2026-04-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-15 00:10:13",
"last_data": "2026-04-15 00:10:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 675123,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-15/",
"name": "dt",
"value": "2026-04-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-16 00:12:24",
"last_data": "2026-04-16 00:12:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 675259,
"location": "s3://sfdl-rds-sparefoot-stage/raw_incremental/sparefoot_facility_tenants_temporal/dt=2026-04-16/",
"name": "dt",
"value": "2026-04-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-17 00:10:20",
"last_data": "2026-04-17 00:10:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"alt_email": "string",
"alt_first_name": "string",
"alt_last_name": "string",
"alt_phone": "bigint",
"api_facility_id": "string",
"company_name": "string",
"confirmation_code": "string",
"corporation_id": "int",
"created": "timestamp",
"customer_address1": "string",
"customer_address2": "string",
"customer_cell_phone": "bigint",
"customer_city": "string",
"customer_email": "string",
"customer_first_name": "string",
"customer_home_phone": "bigint",
"customer_id": "string",
"customer_last_name": "string",
"customer_phone": "bigint",
"customer_state": "string",
"customer_work_email": "string",
"customer_work_phone": "bigint",
"customer_zip": "string",
"dt_partition": "date",
"facility_id": "int",
"facility_name": "string",
"id": "string",
"last_payment_amount": "double",
"lead_id": "string",
"lifetime_value": "double",
"listing_avail_id": "int",
"match_run_id": "int",
"modified": "timestamp",
"move_in_date": "date",
"move_out_date": "date",
"rent_rate": "double",
"source_type": "string",
"unit_dimensions": "string",
"unit_id": "string",
"unit_number": "string"
},
"created": "2025-07-30 00:15:33",
"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_facility_tenants_temporal`\n(\n `alt_email` string , `alt_first_name` string , `alt_last_name` string , `alt_phone` bigint , `api_facility_id` string , `company_name` string , `confirmation_code` string , `corporation_id` int , `created` timestamp , `customer_address1` string , `customer_address2` string , `customer_cell_phone` bigint , `customer_city` string , `customer_email` string , `customer_first_name` string , `customer_home_phone` bigint , `customer_id` string , `customer_last_name` string , `customer_phone` bigint , `customer_state` string , `customer_work_email` string , `customer_work_phone` bigint , `customer_zip` string , `dt_partition` date , `facility_id` int , `facility_name` string , `id` string , `last_payment_amount` double , `lead_id` string , `lifetime_value` double , `listing_avail_id` int , `match_run_id` int , `modified` timestamp , `move_in_date` date , `move_out_date` date , `rent_rate` double , `source_type` string , `unit_dimensions` string , `unit_id` string , `unit_number` 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_facility_tenants_temporal'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_facility_tenants_temporal"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}