Schema Info
Schema Name: sfdl_stage_firehose.services_ddg_stream
- created: 2019-09-24 14:48:37
- disabled: False
- format: raw
- id: 896
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_stage_firehose", "table": "services_ddg_stream" } - type: firehose
Schema Versions: 2
-
Version 280575
- created: 2020-07-29 14:56:10
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_firehose`", "DROP TABLE IF EXISTS `sfdl_stage_firehose.services_ddg_stream`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_firehose.services_ddg_stream`\n(\n`time`STRING,`bid_info`struct<`facilityId`:STRING,`bidType`:STRING,`minBid`:STRING,`effectiveBid`:STRING,`confirmationCode`:STRING,`isDdg`:STRING,`maxBid`:STRING>,`timestamp`STRING,`isoTime`STRING,`object_name`STRING,`action`STRING,`isoTimestamp`STRING,`_origin`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream'\n", "MSCK REPAIR TABLE sfdl_stage_firehose.services_ddg_stream" ] - hive_path: s3://sfdl-firehose-services-stage/separated_dt/ddg_stream
- id: 280575
- processed: 1
- raw_data:
{ "_origin": "2020-07-29T19:56:02Z|separated_dt/ddg_stream/dt=2020-07-29/ddg_stream-stage-1-2020-07-29-19-54-57-3a9046ed-6c5b-40b6-a35c-b35ca5253b7b.gz|firehose-stage", "action": "bid_info_changed", "bid_info": { "bidType": "PERCENT", "confirmationCode": "QUCDX26GE", "effectiveBid": "1.75", "facilityId": "105463", "isDdg": false, "maxBid": "1.75", "minBid": "1.75" }, "isoTime": "2020-07-29T14:53:55-05:00", "object_name": "ddg_stream", "time": "20200729 14:53:55.1231" } - schema_attributes:
{ "_origin": "string", "action": "string", "bid_info.bidType": "string", "bid_info.confirmationCode": "string", "bid_info.effectiveBid": "string", "bid_info.facilityId": "string", "bid_info.isDdg": "string", "bid_info.maxBid": "string", "bid_info.minBid": "string", "isoTime": "string", "isoTimestamp": "string", "object_name": "string", "time": "string", "timestamp": "string" } - schema_name_id: 896
- schema_scan_id: 2876860
- updated: 2020-07-29 14:57:19
-
Version 225962
- created: 2019-09-24 14:48:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_firehose`", "DROP TABLE IF EXISTS `sfdl_stage_firehose.services_ddg_stream`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_firehose.services_ddg_stream`\n(\n`object_name`STRING,`bid_info`struct<`confirmationCode`:STRING,`facilityId`:STRING,`bidType`:STRING,`minBid`:STRING,`maxBid`:STRING,`effectiveBid`:STRING,`isDdg`:STRING>,`action`STRING,`timestamp`STRING,`isoTimestamp`STRING,`_origin`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream'\n", "MSCK REPAIR TABLE sfdl_stage_firehose.services_ddg_stream" ] - hive_path: s3://sfdl-firehose-services-stage/separated_dt/ddg_stream
- id: 225962
- processed: 1
- raw_data:
{ "_origin": "2019-09-24T19:48:23Z|separated_dt/ddg_stream/dt=2019-09-24/ddg_stream-stage-1-2019-09-24-19-47-19-ea2e1d10-f0a6-418a-b522-1bfafc756e1c.gz|firehose-stage", "action": "bid_info_changed", "bid_info": { "bidType": "PERCENT", "confirmationCode": "HH3H45S63", "effectiveBid": "1.25", "facilityId": "204142", "isDdg": false, "maxBid": "1.25", "minBid": "1.25" }, "isoTimestamp": "2019-09-24T14:47:15-05:00", "object_name": "ddg_stream", "timestamp": "20190924 14:47:15.3901" } - schema_attributes:
{ "_origin": "string", "action": "string", "bid_info.bidType": "string", "bid_info.confirmationCode": "string", "bid_info.effectiveBid": "string", "bid_info.facilityId": "string", "bid_info.isDdg": "string", "bid_info.maxBid": "string", "bid_info.minBid": "string", "isoTimestamp": "string", "object_name": "string", "timestamp": "string" } - schema_name_id: 896
- schema_scan_id: 2357902
- updated: 2019-09-24 14:48:48
Schema Scans: 15
Last at 2026-04-16 14:22:40
-
Scan 6415029
- duration: 0:00:00.746414
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 6415029
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-16/", "name": "dt", "type": "string", "value": "2026-04-16" }, "s3": { "bucket": "sfdl-firehose-services-stage", "hive_path": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream", "key": "separated_dt/ddg_stream/dt=2026-04-16/ddg_stream-stage-1-2026-04-16-19-21-15-375a9047-dbbf-4e01-81ea-9f042fdf6f19.gz" }, "schema": { "name": "sfdl_stage_firehose.services_ddg_stream", "type": "firehose" } } - running: False
- schema_name_id: 896
- start_time: 2026-04-16 14:22:40
- success: True
- trace_id: 6565946080588690280
-
Scan 6415027
- duration: 0:00:00.668642
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 6415027
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-16/", "name": "dt", "type": "string", "value": "2026-04-16" }, "s3": { "bucket": "sfdl-firehose-services-stage", "hive_path": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream", "key": "separated_dt/ddg_stream/dt=2026-04-16/ddg_stream-stage-1-2026-04-16-19-18-31-1dea4607-8b7f-41be-a059-783244ed3684.gz" }, "schema": { "name": "sfdl_stage_firehose.services_ddg_stream", "type": "firehose" } } - running: False
- schema_name_id: 896
- start_time: 2026-04-16 14:19:50
- success: True
- trace_id: 5649452860771689699
-
Scan 6415025
- duration: 0:00:00.664038
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 6415025
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-16/", "name": "dt", "type": "string", "value": "2026-04-16" }, "s3": { "bucket": "sfdl-firehose-services-stage", "hive_path": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream", "key": "separated_dt/ddg_stream/dt=2026-04-16/ddg_stream-stage-1-2026-04-16-19-16-03-4c07364a-3e2b-49f2-9960-c9718ac9955c.gz" }, "schema": { "name": "sfdl_stage_firehose.services_ddg_stream", "type": "firehose" } } - running: False
- schema_name_id: 896
- start_time: 2026-04-16 14:17:24
- success: True
- trace_id: 205385140340019079
-
Scan 6415023
- duration: 0:00:00.723104
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 6415023
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-16/", "name": "dt", "type": "string", "value": "2026-04-16" }, "s3": { "bucket": "sfdl-firehose-services-stage", "hive_path": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream", "key": "separated_dt/ddg_stream/dt=2026-04-16/ddg_stream-stage-1-2026-04-16-19-13-19-8a492161-4e8b-409a-a637-efc60f64c3c2.gz" }, "schema": { "name": "sfdl_stage_firehose.services_ddg_stream", "type": "firehose" } } - running: False
- schema_name_id: 896
- start_time: 2026-04-16 14:14:39
- success: True
- trace_id: 10857748668063589781
-
Scan 6415021
- duration: 0:00:00.679518
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 6415021
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-16/", "name": "dt", "type": "string", "value": "2026-04-16" }, "s3": { "bucket": "sfdl-firehose-services-stage", "hive_path": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream", "key": "separated_dt/ddg_stream/dt=2026-04-16/ddg_stream-stage-1-2026-04-16-19-10-59-68e7f48c-8be2-46f4-b64d-d1f2c998da56.gz" }, "schema": { "name": "sfdl_stage_firehose.services_ddg_stream", "type": "firehose" } } - running: False
- schema_name_id: 896
- start_time: 2026-04-16 14:12:08
- success: True
- trace_id: 14915843865009850163
-
Scan 6415019
- duration: 0:00:00.964624
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 6415019
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-16/", "name": "dt", "type": "string", "value": "2026-04-16" }, "s3": { "bucket": "sfdl-firehose-services-stage", "hive_path": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream", "key": "separated_dt/ddg_stream/dt=2026-04-16/ddg_stream-stage-1-2026-04-16-19-04-41-17a2ab0e-a42d-40b1-92da-417fd0a488de.gz" }, "schema": { "name": "sfdl_stage_firehose.services_ddg_stream", "type": "firehose" } } - running: False
- schema_name_id: 896
- start_time: 2026-04-16 14:05:59
- success: True
- trace_id: 9442307869653864739
-
Scan 6414966
- duration: 0:00:00.671622
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 6414966
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-16/", "name": "dt", "type": "string", "value": "2026-04-16" }, "s3": { "bucket": "sfdl-firehose-services-stage", "hive_path": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream", "key": "separated_dt/ddg_stream/dt=2026-04-16/ddg_stream-stage-1-2026-04-16-15-32-22-28c1c03d-2e20-482d-b3ae-d09875afea3e.gz" }, "schema": { "name": "sfdl_stage_firehose.services_ddg_stream", "type": "firehose" } } - running: False
- schema_name_id: 896
- start_time: 2026-04-16 10:33:32
- success: True
- trace_id: 9081600445883376867
-
Scan 6414964
- duration: 0:00:00.777515
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 6414964
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-16/", "name": "dt", "type": "string", "value": "2026-04-16" }, "s3": { "bucket": "sfdl-firehose-services-stage", "hive_path": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream", "key": "separated_dt/ddg_stream/dt=2026-04-16/ddg_stream-stage-1-2026-04-16-15-20-48-2b5c7c87-91c9-43b6-9da1-154e53290adb.gz" }, "schema": { "name": "sfdl_stage_firehose.services_ddg_stream", "type": "firehose" } } - running: False
- schema_name_id: 896
- start_time: 2026-04-16 10:22:01
- success: True
- trace_id: 5155284878194615860
-
Scan 6414963
- duration: 0:00:00.738281
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 6414963
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-16/", "name": "dt", "type": "string", "value": "2026-04-16" }, "s3": { "bucket": "sfdl-firehose-services-stage", "hive_path": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream", "key": "separated_dt/ddg_stream/dt=2026-04-16/ddg_stream-stage-1-2026-04-16-15-17-28-91164b32-5d35-4f16-a8ff-65096f2a309b.gz" }, "schema": { "name": "sfdl_stage_firehose.services_ddg_stream", "type": "firehose" } } - running: False
- schema_name_id: 896
- start_time: 2026-04-16 10:18:50
- success: True
- trace_id: 9776584172278295215
-
Scan 6414960
- duration: 0:00:00.738077
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 6414960
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-16/", "name": "dt", "type": "string", "value": "2026-04-16" }, "s3": { "bucket": "sfdl-firehose-services-stage", "hive_path": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream", "key": "separated_dt/ddg_stream/dt=2026-04-16/ddg_stream-stage-1-2026-04-16-15-12-06-5ce6be6a-f9d8-4f6d-81b7-4c96ec154d06.gz" }, "schema": { "name": "sfdl_stage_firehose.services_ddg_stream", "type": "firehose" } } - running: False
- schema_name_id: 896
- start_time: 2026-04-16 10:13:22
- success: True
- trace_id: 10971861748823696425
-
Scan 6414959
- duration: 0:00:00.669030
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 6414959
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-16/", "name": "dt", "type": "string", "value": "2026-04-16" }, "s3": { "bucket": "sfdl-firehose-services-stage", "hive_path": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream", "key": "separated_dt/ddg_stream/dt=2026-04-16/ddg_stream-stage-1-2026-04-16-15-03-14-038e07cd-aed1-4024-9c9c-93dd49de26f7.gz" }, "schema": { "name": "sfdl_stage_firehose.services_ddg_stream", "type": "firehose" } } - running: False
- schema_name_id: 896
- start_time: 2026-04-16 10:04:43
- success: True
- trace_id: 2753599238154328472
-
Scan 6414955
- duration: 0:00:00.692501
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 6414955
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-16/", "name": "dt", "type": "string", "value": "2026-04-16" }, "s3": { "bucket": "sfdl-firehose-services-stage", "hive_path": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream", "key": "separated_dt/ddg_stream/dt=2026-04-16/ddg_stream-stage-1-2026-04-16-14-58-03-e7937555-32e3-45ad-b5b9-5ca415c00955.gz" }, "schema": { "name": "sfdl_stage_firehose.services_ddg_stream", "type": "firehose" } } - running: False
- schema_name_id: 896
- start_time: 2026-04-16 09:59:22
- success: True
- trace_id: 7058287203669578908
-
Scan 6414954
- duration: 0:00:00.681094
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 6414954
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-16/", "name": "dt", "type": "string", "value": "2026-04-16" }, "s3": { "bucket": "sfdl-firehose-services-stage", "hive_path": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream", "key": "separated_dt/ddg_stream/dt=2026-04-16/ddg_stream-stage-1-2026-04-16-14-55-16-9fdf001b-98ea-450f-8293-bd5d5cd1dafe.gz" }, "schema": { "name": "sfdl_stage_firehose.services_ddg_stream", "type": "firehose" } } - running: False
- schema_name_id: 896
- start_time: 2026-04-16 09:56:40
- success: True
- trace_id: 6570623819696226259
-
Scan 6414952
- duration: 0:00:00.666416
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 6414952
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-16/", "name": "dt", "type": "string", "value": "2026-04-16" }, "s3": { "bucket": "sfdl-firehose-services-stage", "hive_path": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream", "key": "separated_dt/ddg_stream/dt=2026-04-16/ddg_stream-stage-1-2026-04-16-14-52-53-3151d5d1-04c8-4a8b-a54b-e2b493a5f524.gz" }, "schema": { "name": "sfdl_stage_firehose.services_ddg_stream", "type": "firehose" } } - running: False
- schema_name_id: 896
- start_time: 2026-04-16 09:54:05
- success: True
- trace_id: 12220019137709415737
-
Scan 6414949
- duration: 0:00:00.735240
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 6414949
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-16/", "name": "dt", "type": "string", "value": "2026-04-16" }, "s3": { "bucket": "sfdl-firehose-services-stage", "hive_path": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream", "key": "separated_dt/ddg_stream/dt=2026-04-16/ddg_stream-stage-1-2026-04-16-14-50-24-2f664daa-2278-4afc-80fd-e9bf4b30ef61.gz" }, "schema": { "name": "sfdl_stage_firehose.services_ddg_stream", "type": "firehose" } } - running: False
- schema_name_id: 896
- start_time: 2026-04-16 09:51:35
- success: True
- trace_id: 9469390358638256385
- count: 140
- ddl:
[ "ALTER TABLE\n `sfdl_stage_firehose.services_ddg_stream`\nADD\n\n\n PARTITION (dt='2025-10-15') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-15/'\n PARTITION (dt='2025-10-16') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-16/'\n PARTITION (dt='2025-10-17') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-17/'\n PARTITION (dt='2025-10-21') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-21/'\n PARTITION (dt='2025-10-22') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-22/'\n PARTITION (dt='2025-10-23') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-23/'\n PARTITION (dt='2025-10-24') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-24/'\n PARTITION (dt='2025-10-25') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-25/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-26/'\n PARTITION (dt='2025-10-27') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-27/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-28/'\n PARTITION (dt='2025-10-29') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-29/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-30/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-04/'\n PARTITION (dt='2025-11-07') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-07/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-09/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-10/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-12/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-13/'\n PARTITION (dt='2025-11-17') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-17/'\n PARTITION (dt='2025-11-18') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-18/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-19/'\n PARTITION (dt='2025-11-20') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-20/'\n PARTITION (dt='2025-11-21') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-21/'\n PARTITION (dt='2025-11-24') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-24/'\n PARTITION (dt='2025-11-25') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-25/'\n PARTITION (dt='2025-11-28') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-28/'\n PARTITION (dt='2025-12-01') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-01/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-02/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-04/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-05/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-08/'\n PARTITION (dt='2025-12-09') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-09/'\n PARTITION (dt='2025-12-10') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-10/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-12/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-16/'\n PARTITION (dt='2025-12-17') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-17/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-19/'\n PARTITION (dt='2025-12-22') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-22/'\n PARTITION (dt='2025-12-23') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-23/'\n PARTITION (dt='2025-12-24') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-24/'\n PARTITION (dt='2025-12-25') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-25/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-26/'\n PARTITION (dt='2025-12-27') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-27/'\n PARTITION (dt='2025-12-28') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-28/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-31/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-01/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-02/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-03/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-04/'\n PARTITION (dt='2026-01-05') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-08/'\n PARTITION (dt='2026-01-09') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-09/'\n PARTITION (dt='2026-01-10') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-10/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-11/'\n PARTITION (dt='2026-01-12') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-12/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-13/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-14/'\n PARTITION (dt='2026-01-15') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-15/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-16/'\n PARTITION (dt='2026-01-17') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-17/'\n PARTITION (dt='2026-01-18') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-18/'\n PARTITION (dt='2026-01-19') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-19/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-20/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-21/'\n PARTITION (dt='2026-01-22') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-22/'\n PARTITION (dt='2026-01-23') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-23/'\n PARTITION (dt='2026-01-24') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-24/'\n PARTITION (dt='2026-01-25') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-25/'\n PARTITION (dt='2026-01-26') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-28/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-29/'\n PARTITION (dt='2026-01-30') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-30/'\n PARTITION (dt='2026-01-31') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-31/'\n PARTITION (dt='2026-02-01') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-01/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-04/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-05/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-11/'\n PARTITION (dt='2026-02-12') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-12/'\n PARTITION (dt='2026-02-13') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-13/'\n PARTITION (dt='2026-02-16') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-16/'\n PARTITION (dt='2026-02-17') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-17/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-18/'\n PARTITION (dt='2026-02-19') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-19/'\n PARTITION (dt='2026-02-20') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-20/'\n PARTITION (dt='2026-02-22') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-22/'\n PARTITION (dt='2026-02-24') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-24/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-25/'\n PARTITION (dt='2026-02-26') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-26/'\n PARTITION (dt='2026-02-27') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-27/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-02/'\n PARTITION (dt='2026-03-03') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-03/'\n PARTITION (dt='2026-03-04') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-04/'\n PARTITION (dt='2026-03-05') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-05/'\n PARTITION (dt='2026-03-06') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-06/'\n PARTITION (dt='2026-03-08') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-08/'\n PARTITION (dt='2026-03-09') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-09/'\n PARTITION (dt='2026-03-10') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-10/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-11/'\n PARTITION (dt='2026-03-12') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-12/'\n PARTITION (dt='2026-03-13') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-13/'\n PARTITION (dt='2026-03-16') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-16/'\n PARTITION (dt='2026-03-18') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-18/'\n PARTITION (dt='2026-03-20') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-20/'\n PARTITION (dt='2026-03-21') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-21/'\n PARTITION (dt='2026-03-22') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-22/'\n PARTITION (dt='2026-03-23') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-23/'\n PARTITION (dt='2026-03-24') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-24/'\n PARTITION (dt='2026-03-25') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-25/'\n PARTITION (dt='2026-03-26') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-26/'\n PARTITION (dt='2026-03-27') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-27/'\n PARTITION (dt='2026-03-28') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-28/'\n PARTITION (dt='2026-03-29') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-29/'\n PARTITION (dt='2026-03-30') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-30/'\n PARTITION (dt='2026-03-31') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-31/'\n PARTITION (dt='2026-04-01') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-01/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-02/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-03/'\n PARTITION (dt='2026-04-06') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-06/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-07/'\n PARTITION (dt='2026-04-08') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-08/'\n PARTITION (dt='2026-04-09') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-09/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-10/'\n PARTITION (dt='2026-04-12') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-12/'\n PARTITION (dt='2026-04-13') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-13/'\n PARTITION (dt='2026-04-14') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-14/'\n PARTITION (dt='2026-04-15') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-15/'\n PARTITION (dt='2026-04-16') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-16/'\n;" ] - name: dt
- state:
[ { "info": { "id": 650145, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-15/", "name": "dt", "value": "2025-10-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-15 02:34:47", "last_data": "2025-10-15 14:22:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650260, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-16/", "name": "dt", "value": "2025-10-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-16 02:15:49", "last_data": "2025-10-16 10:01:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650380, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-17/", "name": "dt", "value": "2025-10-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-17 04:26:15", "last_data": "2025-10-17 04:43:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650836, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-21/", "name": "dt", "value": "2025-10-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-21 02:07:53", "last_data": "2025-10-21 14:50:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650949, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-22/", "name": "dt", "value": "2025-10-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-22 00:58:06", "last_data": "2025-10-22 14:40:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651073, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-23/", "name": "dt", "value": "2025-10-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-23 05:22:57", "last_data": "2025-10-23 12:17:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651176, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-24/", "name": "dt", "value": "2025-10-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-24 02:30:48", "last_data": "2025-10-24 02:30:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651373, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-25/", "name": "dt", "value": "2025-10-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-25 11:40:51", "last_data": "2025-10-25 14:19:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651401, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-26/", "name": "dt", "value": "2025-10-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-26 03:04:21", "last_data": "2025-10-26 08:54:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651508, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-27/", "name": "dt", "value": "2025-10-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-27 00:43:26", "last_data": "2025-10-27 07:11:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651608, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-28/", "name": "dt", "value": "2025-10-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-27 22:44:17", "last_data": "2025-10-28 07:22:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651748, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-29/", "name": "dt", "value": "2025-10-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-29 01:38:44", "last_data": "2025-10-29 10:26:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651836, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-30/", "name": "dt", "value": "2025-10-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-30 00:02:16", "last_data": "2025-10-30 04:08:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652311, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-03/", "name": "dt", "value": "2025-11-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-03 00:57:14", "last_data": "2025-11-03 07:02:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652448, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-04/", "name": "dt", "value": "2025-11-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-04 04:45:56", "last_data": "2025-11-04 04:45:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652774, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-07/", "name": "dt", "value": "2025-11-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-07 01:04:53", "last_data": "2025-11-07 13:52:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653082, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-09/", "name": "dt", "value": "2025-11-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-09 10:55:35", "last_data": "2025-11-09 10:55:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653086, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-10/", "name": "dt", "value": "2025-11-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-09 23:13:13", "last_data": "2025-11-10 07:06:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653227, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-11/", "name": "dt", "value": "2025-11-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-11 00:12:39", "last_data": "2025-11-11 07:27:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653349, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-12/", "name": "dt", "value": "2025-11-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-12 03:18:22", "last_data": "2025-11-12 15:41:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653471, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-13/", "name": "dt", "value": "2025-11-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-13 03:59:27", "last_data": "2025-11-13 05:26:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653890, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-17/", "name": "dt", "value": "2025-11-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-17 00:02:33", "last_data": "2025-11-17 04:43:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656097, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-18/", "name": "dt", "value": "2025-11-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-18 04:09:23", "last_data": "2025-11-18 16:24:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656205, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-19/", "name": "dt", "value": "2025-11-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-19 01:40:31", "last_data": "2025-11-19 01:40:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656293, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-20/", "name": "dt", "value": "2025-11-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-19 23:39:06", "last_data": "2025-11-20 03:14:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656408, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-21/", "name": "dt", "value": "2025-11-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-20 22:57:57", "last_data": "2025-11-20 22:57:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656774, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-24/", "name": "dt", "value": "2025-11-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-24 03:50:08", "last_data": "2025-11-24 03:50:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656863, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-25/", "name": "dt", "value": "2025-11-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-24 22:00:21", "last_data": "2025-11-24 22:00:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657019, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-28/", "name": "dt", "value": "2025-11-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-28 01:52:38", "last_data": "2025-11-28 01:52:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657077, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-01/", "name": "dt", "value": "2025-12-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-01 01:07:20", "last_data": "2025-12-01 02:02:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657110, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-02/", "name": "dt", "value": "2025-12-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-02 16:24:02", "last_data": "2025-12-02 16:24:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657145, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-04/", "name": "dt", "value": "2025-12-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-04 01:16:59", "last_data": "2025-12-04 02:57:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657168, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-05/", "name": "dt", "value": "2025-12-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-05 02:34:07", "last_data": "2025-12-05 02:34:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657229, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-08/", "name": "dt", "value": "2025-12-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-08 00:41:17", "last_data": "2025-12-08 03:26:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657251, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-09/", "name": "dt", "value": "2025-12-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-08 23:25:35", "last_data": "2025-12-09 16:30:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657278, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-10/", "name": "dt", "value": "2025-12-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-10 00:37:12", "last_data": "2025-12-10 08:39:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657414, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-11/", "name": "dt", "value": "2025-12-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-11 01:16:12", "last_data": "2025-12-11 16:36:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657543, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-12/", "name": "dt", "value": "2025-12-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-12 04:41:20", "last_data": "2025-12-12 06:40:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657970, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-16/", "name": "dt", "value": "2025-12-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-15 23:38:18", "last_data": "2025-12-16 16:20:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658085, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-17/", "name": "dt", "value": "2025-12-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-16 23:43:45", "last_data": "2025-12-17 03:22:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658204, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-18/", "name": "dt", "value": "2025-12-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-17 23:38:32", "last_data": "2025-12-18 05:49:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658357, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-19/", "name": "dt", "value": "2025-12-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-19 05:42:15", "last_data": "2025-12-19 05:42:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658691, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-22/", "name": "dt", "value": "2025-12-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-22 01:21:10", "last_data": "2025-12-22 03:21:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658785, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-23/", "name": "dt", "value": "2025-12-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-22 22:21:37", "last_data": "2025-12-23 13:40:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658974, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-24/", "name": "dt", "value": "2025-12-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-24 00:41:11", "last_data": "2025-12-24 00:50:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659069, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-25/", "name": "dt", "value": "2025-12-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-24 23:37:40", "last_data": "2025-12-24 23:37:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659185, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-26/", "name": "dt", "value": "2025-12-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-25 23:37:51", "last_data": "2025-12-26 05:25:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659299, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-27/", "name": "dt", "value": "2025-12-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-26 23:38:20", "last_data": "2025-12-26 23:38:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659413, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-28/", "name": "dt", "value": "2025-12-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-27 23:37:55", "last_data": "2025-12-27 23:37:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659528, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-29/", "name": "dt", "value": "2025-12-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-28 22:43:27", "last_data": "2025-12-28 23:37:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659648, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-30/", "name": "dt", "value": "2025-12-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-29 23:38:23", "last_data": "2025-12-29 23:38:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659765, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-31/", "name": "dt", "value": "2025-12-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-30 23:39:02", "last_data": "2025-12-31 01:56:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659883, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-01/", "name": "dt", "value": "2026-01-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-31 23:38:25", "last_data": "2026-01-01 08:13:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660011, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-02/", "name": "dt", "value": "2026-01-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-01 23:38:11", "last_data": "2026-01-02 03:53:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660129, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-03/", "name": "dt", "value": "2026-01-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-02 23:38:55", "last_data": "2026-01-02 23:38:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660244, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-04/", "name": "dt", "value": "2026-01-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-03 23:38:18", "last_data": "2026-01-03 23:38:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660360, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-05/", "name": "dt", "value": "2026-01-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-04 23:37:56", "last_data": "2026-01-05 14:46:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660479, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-06/", "name": "dt", "value": "2026-01-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-05 23:38:12", "last_data": "2026-01-06 16:21:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660596, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-07/", "name": "dt", "value": "2026-01-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-06 23:38:41", "last_data": "2026-01-07 02:55:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660714, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-08/", "name": "dt", "value": "2026-01-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-07 22:36:15", "last_data": "2026-01-08 04:52:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660833, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-09/", "name": "dt", "value": "2026-01-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-08 23:37:58", "last_data": "2026-01-09 08:24:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660949, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-10/", "name": "dt", "value": "2026-01-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-09 23:37:45", "last_data": "2026-01-09 23:37:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661065, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-11/", "name": "dt", "value": "2026-01-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-10 23:38:24", "last_data": "2026-01-11 05:29:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661181, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-12/", "name": "dt", "value": "2026-01-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-11 23:39:13", "last_data": "2026-01-12 15:53:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661301, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-13/", "name": "dt", "value": "2026-01-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-12 21:46:31", "last_data": "2026-01-13 09:30:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661416, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-14/", "name": "dt", "value": "2026-01-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-13 23:37:51", "last_data": "2026-01-14 14:40:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661533, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-15/", "name": "dt", "value": "2026-01-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-14 23:37:53", "last_data": "2026-01-15 13:33:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661651, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-16/", "name": "dt", "value": "2026-01-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-15 23:38:22", "last_data": "2026-01-16 04:30:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661769, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-17/", "name": "dt", "value": "2026-01-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-16 23:38:18", "last_data": "2026-01-16 23:38:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661883, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-18/", "name": "dt", "value": "2026-01-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-17 23:39:35", "last_data": "2026-01-17 23:39:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661998, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-19/", "name": "dt", "value": "2026-01-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-18 23:16:44", "last_data": "2026-01-19 07:55:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662119, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-20/", "name": "dt", "value": "2026-01-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-19 23:38:58", "last_data": "2026-01-20 09:10:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662264, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-21/", "name": "dt", "value": "2026-01-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-21 03:35:26", "last_data": "2026-01-21 16:27:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662405, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-22/", "name": "dt", "value": "2026-01-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-21 22:57:55", "last_data": "2026-01-21 23:37:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662547, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-23/", "name": "dt", "value": "2026-01-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-23 01:33:40", "last_data": "2026-01-23 01:50:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662639, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-24/", "name": "dt", "value": "2026-01-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-23 23:38:39", "last_data": "2026-01-23 23:38:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662754, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-25/", "name": "dt", "value": "2026-01-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-24 23:43:11", "last_data": "2026-01-24 23:43:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662870, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-26/", "name": "dt", "value": "2026-01-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-25 23:38:41", "last_data": "2026-01-26 17:13:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662990, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-27/", "name": "dt", "value": "2026-01-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-26 23:38:17", "last_data": "2026-01-27 16:57:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 663108, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-28/", "name": "dt", "value": "2026-01-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-27 23:38:33", "last_data": "2026-01-27 23:38:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 663224, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-29/", "name": "dt", "value": "2026-01-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-28 23:38:20", "last_data": "2026-01-29 01:42:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666068, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-30/", "name": "dt", "value": "2026-01-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-29 23:38:06", "last_data": "2026-01-30 05:12:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666186, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-31/", "name": "dt", "value": "2026-01-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-30 23:38:24", "last_data": "2026-01-30 23:38:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666303, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-01/", "name": "dt", "value": "2026-02-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-31 23:38:23", "last_data": "2026-01-31 23:38:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666435, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-02/", "name": "dt", "value": "2026-02-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-01 23:37:28", "last_data": "2026-02-02 04:33:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666553, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-03/", "name": "dt", "value": "2026-02-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-02 23:38:05", "last_data": "2026-02-03 15:59:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666672, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-04/", "name": "dt", "value": "2026-02-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-03 23:38:07", "last_data": "2026-02-04 06:57:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666791, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-05/", "name": "dt", "value": "2026-02-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-04 23:38:11", "last_data": "2026-02-04 23:38:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667400, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-10/", "name": "dt", "value": "2026-02-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-10 03:30:50", "last_data": "2026-02-10 15:41:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667513, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-11/", "name": "dt", "value": "2026-02-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-11 01:00:09", "last_data": "2026-02-11 15:32:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667606, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-12/", "name": "dt", "value": "2026-02-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-11 22:58:16", "last_data": "2026-02-12 08:14:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667746, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-13/", "name": "dt", "value": "2026-02-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-13 00:29:03", "last_data": "2026-02-13 10:57:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668103, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-16/", "name": "dt", "value": "2026-02-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-16 03:37:56", "last_data": "2026-02-16 04:57:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668224, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-17/", "name": "dt", "value": "2026-02-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-17 03:53:32", "last_data": "2026-02-17 06:33:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668310, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-18/", "name": "dt", "value": "2026-02-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-17 23:35:56", "last_data": "2026-02-18 04:12:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668428, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-19/", "name": "dt", "value": "2026-02-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-18 23:26:12", "last_data": "2026-02-19 09:32:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668548, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-20/", "name": "dt", "value": "2026-02-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-19 23:52:07", "last_data": "2026-02-20 14:14:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668779, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-22/", "name": "dt", "value": "2026-02-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-21 23:52:38", "last_data": "2026-02-21 23:52:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669013, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-24/", "name": "dt", "value": "2026-02-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-23 23:28:04", "last_data": "2026-02-24 15:45:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669171, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-25/", "name": "dt", "value": "2026-02-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-25 04:29:11", "last_data": "2026-02-25 09:05:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669250, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-26/", "name": "dt", "value": "2026-02-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-25 23:55:25", "last_data": "2026-02-26 07:18:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669368, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-27/", "name": "dt", "value": "2026-02-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-26 21:38:34", "last_data": "2026-02-27 01:46:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669747, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-02/", "name": "dt", "value": "2026-03-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-02 00:26:02", "last_data": "2026-03-02 16:27:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669867, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-03/", "name": "dt", "value": "2026-03-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-03 00:57:38", "last_data": "2026-03-03 16:49:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670002, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-04/", "name": "dt", "value": "2026-03-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-04 04:29:31", "last_data": "2026-03-04 05:32:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670174, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-05/", "name": "dt", "value": "2026-03-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-05 08:06:55", "last_data": "2026-03-05 10:39:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670271, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-06/", "name": "dt", "value": "2026-03-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-06 03:48:38", "last_data": "2026-03-06 12:24:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670520, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-08/", "name": "dt", "value": "2026-03-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-08 07:13:23", "last_data": "2026-03-08 07:13:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670641, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-09/", "name": "dt", "value": "2026-03-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-09 08:10:02", "last_data": "2026-03-09 08:19:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670734, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-10/", "name": "dt", "value": "2026-03-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-10 02:22:13", "last_data": "2026-03-10 03:07:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670851, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-11/", "name": "dt", "value": "2026-03-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-11 01:46:07", "last_data": "2026-03-11 15:56:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670970, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-12/", "name": "dt", "value": "2026-03-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-12 01:11:56", "last_data": "2026-03-12 12:24:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671083, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-13/", "name": "dt", "value": "2026-03-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-13 00:51:03", "last_data": "2026-03-13 04:36:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671432, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-16/", "name": "dt", "value": "2026-03-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-16 00:50:37", "last_data": "2026-03-16 09:39:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671668, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-18/", "name": "dt", "value": "2026-03-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-18 00:47:32", "last_data": "2026-03-18 01:43:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671907, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-20/", "name": "dt", "value": "2026-03-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-20 01:40:53", "last_data": "2026-03-20 05:25:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672021, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-21/", "name": "dt", "value": "2026-03-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-21 00:38:51", "last_data": "2026-03-21 01:14:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672137, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-22/", "name": "dt", "value": "2026-03-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-22 00:48:52", "last_data": "2026-03-22 01:23:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672254, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-23/", "name": "dt", "value": "2026-03-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-23 00:40:41", "last_data": "2026-03-23 04:02:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672353, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-24/", "name": "dt", "value": "2026-03-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-23 22:12:35", "last_data": "2026-03-24 00:38:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672473, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-25/", "name": "dt", "value": "2026-03-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-24 23:42:22", "last_data": "2026-03-25 01:31:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672704, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-26/", "name": "dt", "value": "2026-03-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-26 11:35:14", "last_data": "2026-03-26 11:35:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672729, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-27/", "name": "dt", "value": "2026-03-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-27 00:39:16", "last_data": "2026-03-27 00:39:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672847, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-28/", "name": "dt", "value": "2026-03-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-28 00:38:15", "last_data": "2026-03-28 00:38:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672964, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-29/", "name": "dt", "value": "2026-03-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-29 00:38:55", "last_data": "2026-03-29 11:09:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673080, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-30/", "name": "dt", "value": "2026-03-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-30 00:38:52", "last_data": "2026-03-30 14:24:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673200, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-31/", "name": "dt", "value": "2026-03-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-31 00:21:04", "last_data": "2026-03-31 01:31:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673319, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-01/", "name": "dt", "value": "2026-04-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-01 00:38:22", "last_data": "2026-04-01 11:29:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673461, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-02/", "name": "dt", "value": "2026-04-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-01 22:31:33", "last_data": "2026-04-02 04:33:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673600, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-03/", "name": "dt", "value": "2026-04-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-03 00:38:29", "last_data": "2026-04-03 11:17:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673946, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-06/", "name": "dt", "value": "2026-04-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-06 00:43:38", "last_data": "2026-04-06 04:26:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674069, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-07/", "name": "dt", "value": "2026-04-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-07 01:02:14", "last_data": "2026-04-07 03:38:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674183, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-08/", "name": "dt", "value": "2026-04-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-08 00:22:35", "last_data": "2026-04-08 01:22:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674305, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-09/", "name": "dt", "value": "2026-04-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-09 01:41:15", "last_data": "2026-04-09 08:15:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674420, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-10/", "name": "dt", "value": "2026-04-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-10 00:15:13", "last_data": "2026-04-10 06:25:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674682, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-12/", "name": "dt", "value": "2026-04-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-12 08:47:19", "last_data": "2026-04-12 08:47:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674748, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-13/", "name": "dt", "value": "2026-04-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-12 23:55:29", "last_data": "2026-04-13 08:53:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674866, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-14/", "name": "dt", "value": "2026-04-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-13 23:58:58", "last_data": "2026-04-14 04:47:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 675006, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-15/", "name": "dt", "value": "2026-04-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-15 00:21:07", "last_data": "2026-04-15 04:28:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 675124, "location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-16/", "name": "dt", "value": "2026-04-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-16 00:22:47", "last_data": "2026-04-16 14:22:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } } ] - type: string
- attributes:
{ "_origin": "string", "action": "string", "bid_info.bidType": "string", "bid_info.confirmationCode": "string", "bid_info.effectiveBid": "string", "bid_info.facilityId": "string", "bid_info.isDdg": "string", "bid_info.maxBid": "string", "bid_info.minBid": "string", "isoTime": "string", "isoTimestamp": "string", "object_name": "string", "time": "string", "timestamp": "string" } - created: 2020-07-29 14:56:10
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_firehose`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_firehose.services_ddg_stream`\n(\n`time`STRING,`bid_info`struct<`facilityId`:STRING,`bidType`:STRING,`minBid`:STRING,`effectiveBid`:STRING,`confirmationCode`:STRING,`isDdg`:STRING,`maxBid`:STRING>,`timestamp`STRING,`isoTime`STRING,`object_name`STRING,`action`STRING,`isoTimestamp`STRING,`_origin`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_firehose.services_ddg_stream`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_firehose.services_ddg_stream" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2019-09-24 14:48:37",
"disabled": false,
"format": "raw",
"id": 896,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_stage_firehose",
"table": "services_ddg_stream"
},
"type": "firehose"
},
"partition": {
"count": 140,
"ddl": [
"ALTER TABLE\n `sfdl_stage_firehose.services_ddg_stream`\nADD\n\n\n PARTITION (dt='2025-10-15') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-15/'\n PARTITION (dt='2025-10-16') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-16/'\n PARTITION (dt='2025-10-17') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-17/'\n PARTITION (dt='2025-10-21') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-21/'\n PARTITION (dt='2025-10-22') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-22/'\n PARTITION (dt='2025-10-23') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-23/'\n PARTITION (dt='2025-10-24') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-24/'\n PARTITION (dt='2025-10-25') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-25/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-26/'\n PARTITION (dt='2025-10-27') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-27/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-28/'\n PARTITION (dt='2025-10-29') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-29/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-30/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-04/'\n PARTITION (dt='2025-11-07') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-07/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-09/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-10/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-12/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-13/'\n PARTITION (dt='2025-11-17') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-17/'\n PARTITION (dt='2025-11-18') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-18/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-19/'\n PARTITION (dt='2025-11-20') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-20/'\n PARTITION (dt='2025-11-21') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-21/'\n PARTITION (dt='2025-11-24') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-24/'\n PARTITION (dt='2025-11-25') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-25/'\n PARTITION (dt='2025-11-28') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-28/'\n PARTITION (dt='2025-12-01') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-01/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-02/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-04/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-05/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-08/'\n PARTITION (dt='2025-12-09') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-09/'\n PARTITION (dt='2025-12-10') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-10/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-12/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-16/'\n PARTITION (dt='2025-12-17') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-17/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-19/'\n PARTITION (dt='2025-12-22') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-22/'\n PARTITION (dt='2025-12-23') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-23/'\n PARTITION (dt='2025-12-24') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-24/'\n PARTITION (dt='2025-12-25') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-25/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-26/'\n PARTITION (dt='2025-12-27') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-27/'\n PARTITION (dt='2025-12-28') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-28/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-31/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-01/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-02/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-03/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-04/'\n PARTITION (dt='2026-01-05') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-08/'\n PARTITION (dt='2026-01-09') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-09/'\n PARTITION (dt='2026-01-10') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-10/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-11/'\n PARTITION (dt='2026-01-12') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-12/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-13/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-14/'\n PARTITION (dt='2026-01-15') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-15/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-16/'\n PARTITION (dt='2026-01-17') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-17/'\n PARTITION (dt='2026-01-18') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-18/'\n PARTITION (dt='2026-01-19') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-19/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-20/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-21/'\n PARTITION (dt='2026-01-22') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-22/'\n PARTITION (dt='2026-01-23') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-23/'\n PARTITION (dt='2026-01-24') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-24/'\n PARTITION (dt='2026-01-25') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-25/'\n PARTITION (dt='2026-01-26') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-28/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-29/'\n PARTITION (dt='2026-01-30') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-30/'\n PARTITION (dt='2026-01-31') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-31/'\n PARTITION (dt='2026-02-01') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-01/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-04/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-05/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-11/'\n PARTITION (dt='2026-02-12') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-12/'\n PARTITION (dt='2026-02-13') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-13/'\n PARTITION (dt='2026-02-16') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-16/'\n PARTITION (dt='2026-02-17') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-17/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-18/'\n PARTITION (dt='2026-02-19') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-19/'\n PARTITION (dt='2026-02-20') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-20/'\n PARTITION (dt='2026-02-22') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-22/'\n PARTITION (dt='2026-02-24') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-24/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-25/'\n PARTITION (dt='2026-02-26') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-26/'\n PARTITION (dt='2026-02-27') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-27/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-02/'\n PARTITION (dt='2026-03-03') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-03/'\n PARTITION (dt='2026-03-04') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-04/'\n PARTITION (dt='2026-03-05') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-05/'\n PARTITION (dt='2026-03-06') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-06/'\n PARTITION (dt='2026-03-08') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-08/'\n PARTITION (dt='2026-03-09') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-09/'\n PARTITION (dt='2026-03-10') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-10/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-11/'\n PARTITION (dt='2026-03-12') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-12/'\n PARTITION (dt='2026-03-13') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-13/'\n PARTITION (dt='2026-03-16') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-16/'\n PARTITION (dt='2026-03-18') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-18/'\n PARTITION (dt='2026-03-20') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-20/'\n PARTITION (dt='2026-03-21') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-21/'\n PARTITION (dt='2026-03-22') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-22/'\n PARTITION (dt='2026-03-23') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-23/'\n PARTITION (dt='2026-03-24') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-24/'\n PARTITION (dt='2026-03-25') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-25/'\n PARTITION (dt='2026-03-26') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-26/'\n PARTITION (dt='2026-03-27') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-27/'\n PARTITION (dt='2026-03-28') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-28/'\n PARTITION (dt='2026-03-29') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-29/'\n PARTITION (dt='2026-03-30') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-30/'\n PARTITION (dt='2026-03-31') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-31/'\n PARTITION (dt='2026-04-01') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-01/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-02/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-03/'\n PARTITION (dt='2026-04-06') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-06/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-07/'\n PARTITION (dt='2026-04-08') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-08/'\n PARTITION (dt='2026-04-09') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-09/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-10/'\n PARTITION (dt='2026-04-12') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-12/'\n PARTITION (dt='2026-04-13') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-13/'\n PARTITION (dt='2026-04-14') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-14/'\n PARTITION (dt='2026-04-15') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-15/'\n PARTITION (dt='2026-04-16') location 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-16/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 650145,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-15/",
"name": "dt",
"value": "2025-10-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-15 02:34:47",
"last_data": "2025-10-15 14:22:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650260,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-16/",
"name": "dt",
"value": "2025-10-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-16 02:15:49",
"last_data": "2025-10-16 10:01:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650380,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-17/",
"name": "dt",
"value": "2025-10-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-17 04:26:15",
"last_data": "2025-10-17 04:43:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650836,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-21/",
"name": "dt",
"value": "2025-10-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-21 02:07:53",
"last_data": "2025-10-21 14:50:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650949,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-22/",
"name": "dt",
"value": "2025-10-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-22 00:58:06",
"last_data": "2025-10-22 14:40:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651073,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-23/",
"name": "dt",
"value": "2025-10-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-23 05:22:57",
"last_data": "2025-10-23 12:17:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651176,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-24/",
"name": "dt",
"value": "2025-10-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-24 02:30:48",
"last_data": "2025-10-24 02:30:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651373,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-25/",
"name": "dt",
"value": "2025-10-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-25 11:40:51",
"last_data": "2025-10-25 14:19:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651401,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-26/",
"name": "dt",
"value": "2025-10-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-26 03:04:21",
"last_data": "2025-10-26 08:54:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651508,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-27/",
"name": "dt",
"value": "2025-10-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-27 00:43:26",
"last_data": "2025-10-27 07:11:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651608,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-28/",
"name": "dt",
"value": "2025-10-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-27 22:44:17",
"last_data": "2025-10-28 07:22:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651748,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-29/",
"name": "dt",
"value": "2025-10-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-29 01:38:44",
"last_data": "2025-10-29 10:26:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651836,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-10-30/",
"name": "dt",
"value": "2025-10-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-30 00:02:16",
"last_data": "2025-10-30 04:08:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652311,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-03/",
"name": "dt",
"value": "2025-11-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-03 00:57:14",
"last_data": "2025-11-03 07:02:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652448,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-04/",
"name": "dt",
"value": "2025-11-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-04 04:45:56",
"last_data": "2025-11-04 04:45:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652774,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-07/",
"name": "dt",
"value": "2025-11-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-07 01:04:53",
"last_data": "2025-11-07 13:52:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653082,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-09/",
"name": "dt",
"value": "2025-11-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-09 10:55:35",
"last_data": "2025-11-09 10:55:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653086,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-10/",
"name": "dt",
"value": "2025-11-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-09 23:13:13",
"last_data": "2025-11-10 07:06:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653227,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-11/",
"name": "dt",
"value": "2025-11-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-11 00:12:39",
"last_data": "2025-11-11 07:27:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653349,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-12/",
"name": "dt",
"value": "2025-11-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-12 03:18:22",
"last_data": "2025-11-12 15:41:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653471,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-13/",
"name": "dt",
"value": "2025-11-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-13 03:59:27",
"last_data": "2025-11-13 05:26:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653890,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-17/",
"name": "dt",
"value": "2025-11-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-17 00:02:33",
"last_data": "2025-11-17 04:43:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656097,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-18/",
"name": "dt",
"value": "2025-11-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-18 04:09:23",
"last_data": "2025-11-18 16:24:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656205,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-19/",
"name": "dt",
"value": "2025-11-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-19 01:40:31",
"last_data": "2025-11-19 01:40:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656293,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-20/",
"name": "dt",
"value": "2025-11-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-19 23:39:06",
"last_data": "2025-11-20 03:14:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656408,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-21/",
"name": "dt",
"value": "2025-11-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-20 22:57:57",
"last_data": "2025-11-20 22:57:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656774,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-24/",
"name": "dt",
"value": "2025-11-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-24 03:50:08",
"last_data": "2025-11-24 03:50:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656863,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-25/",
"name": "dt",
"value": "2025-11-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-24 22:00:21",
"last_data": "2025-11-24 22:00:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657019,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-11-28/",
"name": "dt",
"value": "2025-11-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-28 01:52:38",
"last_data": "2025-11-28 01:52:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657077,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-01/",
"name": "dt",
"value": "2025-12-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-01 01:07:20",
"last_data": "2025-12-01 02:02:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657110,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-02/",
"name": "dt",
"value": "2025-12-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-02 16:24:02",
"last_data": "2025-12-02 16:24:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657145,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-04/",
"name": "dt",
"value": "2025-12-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-04 01:16:59",
"last_data": "2025-12-04 02:57:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657168,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-05/",
"name": "dt",
"value": "2025-12-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-05 02:34:07",
"last_data": "2025-12-05 02:34:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657229,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-08/",
"name": "dt",
"value": "2025-12-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-08 00:41:17",
"last_data": "2025-12-08 03:26:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657251,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-09/",
"name": "dt",
"value": "2025-12-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-08 23:25:35",
"last_data": "2025-12-09 16:30:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657278,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-10/",
"name": "dt",
"value": "2025-12-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-10 00:37:12",
"last_data": "2025-12-10 08:39:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657414,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-11/",
"name": "dt",
"value": "2025-12-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-11 01:16:12",
"last_data": "2025-12-11 16:36:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657543,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-12/",
"name": "dt",
"value": "2025-12-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-12 04:41:20",
"last_data": "2025-12-12 06:40:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657970,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-16/",
"name": "dt",
"value": "2025-12-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-15 23:38:18",
"last_data": "2025-12-16 16:20:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658085,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-17/",
"name": "dt",
"value": "2025-12-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-16 23:43:45",
"last_data": "2025-12-17 03:22:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658204,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-18/",
"name": "dt",
"value": "2025-12-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-17 23:38:32",
"last_data": "2025-12-18 05:49:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658357,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-19/",
"name": "dt",
"value": "2025-12-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-19 05:42:15",
"last_data": "2025-12-19 05:42:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658691,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-22/",
"name": "dt",
"value": "2025-12-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-22 01:21:10",
"last_data": "2025-12-22 03:21:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658785,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-23/",
"name": "dt",
"value": "2025-12-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-22 22:21:37",
"last_data": "2025-12-23 13:40:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658974,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-24/",
"name": "dt",
"value": "2025-12-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-24 00:41:11",
"last_data": "2025-12-24 00:50:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659069,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-25/",
"name": "dt",
"value": "2025-12-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-24 23:37:40",
"last_data": "2025-12-24 23:37:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659185,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-26/",
"name": "dt",
"value": "2025-12-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-25 23:37:51",
"last_data": "2025-12-26 05:25:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659299,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-27/",
"name": "dt",
"value": "2025-12-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-26 23:38:20",
"last_data": "2025-12-26 23:38:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659413,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-28/",
"name": "dt",
"value": "2025-12-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-27 23:37:55",
"last_data": "2025-12-27 23:37:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659528,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-29/",
"name": "dt",
"value": "2025-12-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-28 22:43:27",
"last_data": "2025-12-28 23:37:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659648,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-30/",
"name": "dt",
"value": "2025-12-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-29 23:38:23",
"last_data": "2025-12-29 23:38:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659765,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2025-12-31/",
"name": "dt",
"value": "2025-12-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-30 23:39:02",
"last_data": "2025-12-31 01:56:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659883,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-01/",
"name": "dt",
"value": "2026-01-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-31 23:38:25",
"last_data": "2026-01-01 08:13:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660011,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-02/",
"name": "dt",
"value": "2026-01-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-01 23:38:11",
"last_data": "2026-01-02 03:53:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660129,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-03/",
"name": "dt",
"value": "2026-01-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-02 23:38:55",
"last_data": "2026-01-02 23:38:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660244,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-04/",
"name": "dt",
"value": "2026-01-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-03 23:38:18",
"last_data": "2026-01-03 23:38:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660360,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-05/",
"name": "dt",
"value": "2026-01-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-04 23:37:56",
"last_data": "2026-01-05 14:46:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660479,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-06/",
"name": "dt",
"value": "2026-01-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-05 23:38:12",
"last_data": "2026-01-06 16:21:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660596,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-07/",
"name": "dt",
"value": "2026-01-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-06 23:38:41",
"last_data": "2026-01-07 02:55:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660714,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-08/",
"name": "dt",
"value": "2026-01-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-07 22:36:15",
"last_data": "2026-01-08 04:52:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660833,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-09/",
"name": "dt",
"value": "2026-01-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-08 23:37:58",
"last_data": "2026-01-09 08:24:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660949,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-10/",
"name": "dt",
"value": "2026-01-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-09 23:37:45",
"last_data": "2026-01-09 23:37:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661065,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-11/",
"name": "dt",
"value": "2026-01-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-10 23:38:24",
"last_data": "2026-01-11 05:29:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661181,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-12/",
"name": "dt",
"value": "2026-01-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-11 23:39:13",
"last_data": "2026-01-12 15:53:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661301,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-13/",
"name": "dt",
"value": "2026-01-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-12 21:46:31",
"last_data": "2026-01-13 09:30:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661416,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-14/",
"name": "dt",
"value": "2026-01-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-13 23:37:51",
"last_data": "2026-01-14 14:40:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661533,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-15/",
"name": "dt",
"value": "2026-01-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-14 23:37:53",
"last_data": "2026-01-15 13:33:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661651,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-16/",
"name": "dt",
"value": "2026-01-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-15 23:38:22",
"last_data": "2026-01-16 04:30:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661769,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-17/",
"name": "dt",
"value": "2026-01-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-16 23:38:18",
"last_data": "2026-01-16 23:38:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661883,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-18/",
"name": "dt",
"value": "2026-01-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-17 23:39:35",
"last_data": "2026-01-17 23:39:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661998,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-19/",
"name": "dt",
"value": "2026-01-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-18 23:16:44",
"last_data": "2026-01-19 07:55:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662119,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-20/",
"name": "dt",
"value": "2026-01-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-19 23:38:58",
"last_data": "2026-01-20 09:10:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662264,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-21/",
"name": "dt",
"value": "2026-01-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-21 03:35:26",
"last_data": "2026-01-21 16:27:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662405,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-22/",
"name": "dt",
"value": "2026-01-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-21 22:57:55",
"last_data": "2026-01-21 23:37:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662547,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-23/",
"name": "dt",
"value": "2026-01-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-23 01:33:40",
"last_data": "2026-01-23 01:50:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662639,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-24/",
"name": "dt",
"value": "2026-01-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-23 23:38:39",
"last_data": "2026-01-23 23:38:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662754,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-25/",
"name": "dt",
"value": "2026-01-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-24 23:43:11",
"last_data": "2026-01-24 23:43:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662870,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-26/",
"name": "dt",
"value": "2026-01-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-25 23:38:41",
"last_data": "2026-01-26 17:13:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662990,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-27/",
"name": "dt",
"value": "2026-01-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-26 23:38:17",
"last_data": "2026-01-27 16:57:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 663108,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-28/",
"name": "dt",
"value": "2026-01-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-27 23:38:33",
"last_data": "2026-01-27 23:38:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 663224,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-29/",
"name": "dt",
"value": "2026-01-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-28 23:38:20",
"last_data": "2026-01-29 01:42:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666068,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-30/",
"name": "dt",
"value": "2026-01-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-29 23:38:06",
"last_data": "2026-01-30 05:12:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666186,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-01-31/",
"name": "dt",
"value": "2026-01-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-30 23:38:24",
"last_data": "2026-01-30 23:38:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666303,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-01/",
"name": "dt",
"value": "2026-02-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-31 23:38:23",
"last_data": "2026-01-31 23:38:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666435,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-02/",
"name": "dt",
"value": "2026-02-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-01 23:37:28",
"last_data": "2026-02-02 04:33:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666553,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-03/",
"name": "dt",
"value": "2026-02-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-02 23:38:05",
"last_data": "2026-02-03 15:59:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666672,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-04/",
"name": "dt",
"value": "2026-02-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-03 23:38:07",
"last_data": "2026-02-04 06:57:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666791,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-05/",
"name": "dt",
"value": "2026-02-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-04 23:38:11",
"last_data": "2026-02-04 23:38:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667400,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-10/",
"name": "dt",
"value": "2026-02-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-10 03:30:50",
"last_data": "2026-02-10 15:41:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667513,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-11/",
"name": "dt",
"value": "2026-02-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-11 01:00:09",
"last_data": "2026-02-11 15:32:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667606,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-12/",
"name": "dt",
"value": "2026-02-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-11 22:58:16",
"last_data": "2026-02-12 08:14:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667746,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-13/",
"name": "dt",
"value": "2026-02-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-13 00:29:03",
"last_data": "2026-02-13 10:57:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668103,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-16/",
"name": "dt",
"value": "2026-02-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-16 03:37:56",
"last_data": "2026-02-16 04:57:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668224,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-17/",
"name": "dt",
"value": "2026-02-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-17 03:53:32",
"last_data": "2026-02-17 06:33:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668310,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-18/",
"name": "dt",
"value": "2026-02-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-17 23:35:56",
"last_data": "2026-02-18 04:12:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668428,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-19/",
"name": "dt",
"value": "2026-02-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-18 23:26:12",
"last_data": "2026-02-19 09:32:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668548,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-20/",
"name": "dt",
"value": "2026-02-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-19 23:52:07",
"last_data": "2026-02-20 14:14:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668779,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-22/",
"name": "dt",
"value": "2026-02-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-21 23:52:38",
"last_data": "2026-02-21 23:52:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669013,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-24/",
"name": "dt",
"value": "2026-02-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-23 23:28:04",
"last_data": "2026-02-24 15:45:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669171,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-25/",
"name": "dt",
"value": "2026-02-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-25 04:29:11",
"last_data": "2026-02-25 09:05:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669250,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-26/",
"name": "dt",
"value": "2026-02-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-25 23:55:25",
"last_data": "2026-02-26 07:18:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669368,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-02-27/",
"name": "dt",
"value": "2026-02-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-26 21:38:34",
"last_data": "2026-02-27 01:46:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669747,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-02/",
"name": "dt",
"value": "2026-03-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-02 00:26:02",
"last_data": "2026-03-02 16:27:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669867,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-03/",
"name": "dt",
"value": "2026-03-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-03 00:57:38",
"last_data": "2026-03-03 16:49:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670002,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-04/",
"name": "dt",
"value": "2026-03-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-04 04:29:31",
"last_data": "2026-03-04 05:32:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670174,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-05/",
"name": "dt",
"value": "2026-03-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-05 08:06:55",
"last_data": "2026-03-05 10:39:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670271,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-06/",
"name": "dt",
"value": "2026-03-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-06 03:48:38",
"last_data": "2026-03-06 12:24:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670520,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-08/",
"name": "dt",
"value": "2026-03-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-08 07:13:23",
"last_data": "2026-03-08 07:13:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670641,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-09/",
"name": "dt",
"value": "2026-03-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-09 08:10:02",
"last_data": "2026-03-09 08:19:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670734,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-10/",
"name": "dt",
"value": "2026-03-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-10 02:22:13",
"last_data": "2026-03-10 03:07:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670851,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-11/",
"name": "dt",
"value": "2026-03-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-11 01:46:07",
"last_data": "2026-03-11 15:56:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670970,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-12/",
"name": "dt",
"value": "2026-03-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-12 01:11:56",
"last_data": "2026-03-12 12:24:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671083,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-13/",
"name": "dt",
"value": "2026-03-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-13 00:51:03",
"last_data": "2026-03-13 04:36:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671432,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-16/",
"name": "dt",
"value": "2026-03-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-16 00:50:37",
"last_data": "2026-03-16 09:39:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671668,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-18/",
"name": "dt",
"value": "2026-03-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-18 00:47:32",
"last_data": "2026-03-18 01:43:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671907,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-20/",
"name": "dt",
"value": "2026-03-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-20 01:40:53",
"last_data": "2026-03-20 05:25:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672021,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-21/",
"name": "dt",
"value": "2026-03-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-21 00:38:51",
"last_data": "2026-03-21 01:14:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672137,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-22/",
"name": "dt",
"value": "2026-03-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-22 00:48:52",
"last_data": "2026-03-22 01:23:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672254,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-23/",
"name": "dt",
"value": "2026-03-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-23 00:40:41",
"last_data": "2026-03-23 04:02:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672353,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-24/",
"name": "dt",
"value": "2026-03-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-23 22:12:35",
"last_data": "2026-03-24 00:38:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672473,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-25/",
"name": "dt",
"value": "2026-03-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-24 23:42:22",
"last_data": "2026-03-25 01:31:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672704,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-26/",
"name": "dt",
"value": "2026-03-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-26 11:35:14",
"last_data": "2026-03-26 11:35:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672729,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-27/",
"name": "dt",
"value": "2026-03-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-27 00:39:16",
"last_data": "2026-03-27 00:39:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672847,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-28/",
"name": "dt",
"value": "2026-03-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-28 00:38:15",
"last_data": "2026-03-28 00:38:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672964,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-29/",
"name": "dt",
"value": "2026-03-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-29 00:38:55",
"last_data": "2026-03-29 11:09:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673080,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-30/",
"name": "dt",
"value": "2026-03-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-30 00:38:52",
"last_data": "2026-03-30 14:24:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673200,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-03-31/",
"name": "dt",
"value": "2026-03-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-31 00:21:04",
"last_data": "2026-03-31 01:31:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673319,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-01/",
"name": "dt",
"value": "2026-04-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-01 00:38:22",
"last_data": "2026-04-01 11:29:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673461,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-02/",
"name": "dt",
"value": "2026-04-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-01 22:31:33",
"last_data": "2026-04-02 04:33:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673600,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-03/",
"name": "dt",
"value": "2026-04-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-03 00:38:29",
"last_data": "2026-04-03 11:17:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673946,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-06/",
"name": "dt",
"value": "2026-04-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-06 00:43:38",
"last_data": "2026-04-06 04:26:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674069,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-07/",
"name": "dt",
"value": "2026-04-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-07 01:02:14",
"last_data": "2026-04-07 03:38:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674183,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-08/",
"name": "dt",
"value": "2026-04-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-08 00:22:35",
"last_data": "2026-04-08 01:22:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674305,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-09/",
"name": "dt",
"value": "2026-04-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-09 01:41:15",
"last_data": "2026-04-09 08:15:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674420,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-10/",
"name": "dt",
"value": "2026-04-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-10 00:15:13",
"last_data": "2026-04-10 06:25:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674682,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-12/",
"name": "dt",
"value": "2026-04-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-12 08:47:19",
"last_data": "2026-04-12 08:47:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674748,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-13/",
"name": "dt",
"value": "2026-04-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-12 23:55:29",
"last_data": "2026-04-13 08:53:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674866,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-14/",
"name": "dt",
"value": "2026-04-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-13 23:58:58",
"last_data": "2026-04-14 04:47:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 675006,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-15/",
"name": "dt",
"value": "2026-04-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-15 00:21:07",
"last_data": "2026-04-15 04:28:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 675124,
"location": "s3://sfdl-firehose-services-stage/separated_dt/ddg_stream/dt=2026-04-16/",
"name": "dt",
"value": "2026-04-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-16 00:22:47",
"last_data": "2026-04-16 14:22:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_origin": "string",
"action": "string",
"bid_info.bidType": "string",
"bid_info.confirmationCode": "string",
"bid_info.effectiveBid": "string",
"bid_info.facilityId": "string",
"bid_info.isDdg": "string",
"bid_info.maxBid": "string",
"bid_info.minBid": "string",
"isoTime": "string",
"isoTimestamp": "string",
"object_name": "string",
"time": "string",
"timestamp": "string"
},
"created": "2020-07-29 14:56:10",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_firehose`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_firehose.services_ddg_stream`\n(\n`time`STRING,`bid_info`struct<`facilityId`:STRING,`bidType`:STRING,`minBid`:STRING,`effectiveBid`:STRING,`confirmationCode`:STRING,`isDdg`:STRING,`maxBid`:STRING>,`timestamp`STRING,`isoTime`STRING,`object_name`STRING,`action`STRING,`isoTimestamp`STRING,`_origin`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-firehose-services-stage/separated_dt/ddg_stream'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_firehose.services_ddg_stream`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_firehose.services_ddg_stream"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}