Schema Info
Schema Name: sfdl_dev_firehose.services_ddg_stream
- created: 2019-09-24 14:43:31
- disabled: False
- format: raw
- id: 1307
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_dev_firehose", "table": "services_ddg_stream" } - type: firehose
Schema Versions: 4
-
Version 4690110
- created: 2022-10-11 16:16:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_firehose`", "DROP TABLE IF EXISTS `sfdl_dev_firehose.services_ddg_stream`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_firehose.services_ddg_stream`\n(\n`time`STRING,`action`STRING,`timestamp`STRING,`isoTimestamp`STRING,`isoTime`STRING,`object_name`STRING,`_origin`STRING,`bid_info`struct<`minBid`:STRING,`premiumVisitorBidEnabled`:STRING,`isDdg`:STRING,`bidType`:STRING,`confirmationCode`:STRING,`effectiveBid`:STRING,`maxBid`:STRING,`facilityId`:STRING,`premiumVisitorBid`: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-dev/separated_dt/ddg_stream'\n", "MSCK REPAIR TABLE sfdl_dev_firehose.services_ddg_stream" ] - hive_path: s3://sfdl-firehose-services-dev/separated_dt/ddg_stream
- id: 4690110
- processed: 1
- raw_data:
{ "_origin": "2022-10-11T21:15:58Z|separated_dt/ddg_stream/dt=2022-10-11/ddg_stream-dev-1-2022-10-11-21-14-54-7256439c-509d-4380-b1e9-6657548cf0ed.gz|firehose-dev", "action": "bid_info_changed", "bid_info": { "bidType": "PERCENT", "confirmationCode": "ZJPKC2XAU", "effectiveBid": "1.30", "facilityId": "225602", "isDdg": false, "maxBid": "1.30", "minBid": "1.30", "premiumVisitorBid": null, "premiumVisitorBidEnabled": false }, "isoTime": "2022-10-11T16:13:53-05:00", "object_name": "ddg_stream", "time": "20221011 16:13:53.93" } - 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", "bid_info.premiumVisitorBid": "string", "bid_info.premiumVisitorBidEnabled": "string", "isoTime": "string", "isoTimestamp": "string", "object_name": "string", "time": "string", "timestamp": "string" } - schema_name_id: 1307
- schema_scan_id: 5990735
- updated: 2022-10-11 16:18:25
-
Version 4690109
- created: 2022-10-11 10:23:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_firehose`", "DROP TABLE IF EXISTS `sfdl_dev_firehose.services_ddg_stream`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_firehose.services_ddg_stream`\n(\n`time`STRING,`action`STRING,`timestamp`STRING,`isoTimestamp`STRING,`isoTime`STRING,`object_name`STRING,`_origin`STRING,`bid_info`struct<`minBid`:STRING,`isDdg`:STRING,`bidType`:STRING,`facilityId`:STRING,`confirmationCode`:STRING,`premiumVisitorBid`:STRING,`effectiveBid`:STRING,`maxBid`: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-dev/separated_dt/ddg_stream'\n", "MSCK REPAIR TABLE sfdl_dev_firehose.services_ddg_stream" ] - hive_path: s3://sfdl-firehose-services-dev/separated_dt/ddg_stream
- id: 4690109
- processed: 1
- raw_data:
{ "_origin": "2022-10-11T15:23:27Z|separated_dt/ddg_stream/dt=2022-10-11/ddg_stream-dev-1-2022-10-11-15-22-21-19982173-758b-48fd-8d42-b058191c9924.gz|firehose-dev", "action": "bid_info_changed", "bid_info": { "bidType": "PERCENT", "confirmationCode": "3FPDBKMGA", "effectiveBid": "1.30", "facilityId": "225580", "isDdg": false, "maxBid": "1.30", "minBid": "1.30", "premiumVisitorBid": null }, "isoTime": "2022-10-11T10:21:16-05:00", "object_name": "ddg_stream", "time": "20221011 10:21:16.6644" } - 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", "bid_info.premiumVisitorBid": "string", "isoTime": "string", "isoTimestamp": "string", "object_name": "string", "time": "string", "timestamp": "string" } - schema_name_id: 1307
- schema_scan_id: 5990594
- updated: 2022-10-11 10:25:53
-
Version 4680210
- created: 2020-07-23 17:06:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_firehose`", "DROP TABLE IF EXISTS `sfdl_dev_firehose.services_ddg_stream`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_firehose.services_ddg_stream`\n(\n`object_name`STRING,`isoTime`STRING,`bid_info`struct<`minBid`:STRING,`facilityId`:STRING,`isDdg`:STRING,`confirmationCode`:STRING,`maxBid`:STRING,`effectiveBid`:STRING,`bidType`:STRING>,`_origin`STRING,`time`STRING,`action`STRING,`timestamp`STRING,`isoTimestamp`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-dev/separated_dt/ddg_stream'\n", "MSCK REPAIR TABLE sfdl_dev_firehose.services_ddg_stream" ] - hive_path: s3://sfdl-firehose-services-dev/separated_dt/ddg_stream
- id: 4680210
- processed: 1
- raw_data:
{ "_origin": "2020-07-23T22:04:45Z|separated_dt/ddg_stream/dt=2020-07-23/ddg_stream-dev-1-2020-07-23-22-03-42-0e664c5e-a83f-492f-a16e-785af5c48624.gz|firehose-dev", "action": "bid_info_changed", "bid_info": { "bidType": "PERCENT", "confirmationCode": "UECQDHWUE", "effectiveBid": "1.75", "facilityId": "105463", "isDdg": false, "maxBid": "1.75", "minBid": "1.75" }, "isoTime": "2020-07-23T17:02:38-05:00", "object_name": "ddg_stream", "time": "20200723 17:02:38.0608" } - 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: 1307
- schema_scan_id: 5654619
- updated: 2020-07-23 17:07:32
-
Version 4672444
- created: 2019-09-24 14:43:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_firehose`", "DROP TABLE IF EXISTS `sfdl_dev_firehose.services_ddg_stream`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/separated_dt/ddg_stream'\n", "MSCK REPAIR TABLE sfdl_dev_firehose.services_ddg_stream" ] - hive_path: s3://sfdl-firehose-services-dev/separated_dt/ddg_stream
- id: 4672444
- processed: 1
- raw_data:
{ "_origin": "2019-09-24T19:43:26Z|separated_dt/ddg_stream/dt=2019-09-24/ddg_stream-dev-1-2019-09-24-19-42-23-65bce3d7-e207-443a-b600-2f146c03aa87.gz|firehose-dev", "action": "bid_info_changed", "bid_info": { "bidType": "PERCENT", "confirmationCode": "UZZSBH8XA", "effectiveBid": "1.25", "facilityId": "204142", "isDdg": false, "maxBid": "1.25", "minBid": "1.25" }, "isoTimestamp": "2019-09-24T14:42:21-05:00", "object_name": "ddg_stream", "timestamp": "20190924 14:42:21.8715" } - 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: 1307
- schema_scan_id: 5180599
- updated: 2019-09-24 14:43:42
Schema Scans: 4
Last at 2022-10-11 16:16:06
-
Scan 5990735
- duration: 0:02:30.220700
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 527, "partitions_applied": false, "success": true } - id: 5990735
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2022-10-11/", "name": "dt", "type": "string", "value": "2022-10-11" }, "s3": { "bucket": "sfdl-firehose-services-dev", "hive_path": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream", "key": "separated_dt/ddg_stream/dt=2022-10-11/ddg_stream-dev-1-2022-10-11-21-14-54-7256439c-509d-4380-b1e9-6657548cf0ed.gz" }, "schema": { "name": "sfdl_dev_firehose.services_ddg_stream", "type": "firehose" } } - running: False
- schema_name_id: 1307
- start_time: 2022-10-11 16:16:06
- success: True
- trace_id: 521651110555349245
-
Scan 5990594
- duration: 0:02:54.180333
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 527, "partitions_applied": false, "success": true } - id: 5990594
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2022-10-11/", "name": "dt", "type": "string", "value": "2022-10-11" }, "s3": { "bucket": "sfdl-firehose-services-dev", "hive_path": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream", "key": "separated_dt/ddg_stream/dt=2022-10-11/ddg_stream-dev-1-2022-10-11-15-22-21-19982173-758b-48fd-8d42-b058191c9924.gz" }, "schema": { "name": "sfdl_dev_firehose.services_ddg_stream", "type": "firehose" } } - running: False
- schema_name_id: 1307
- start_time: 2022-10-11 10:23:32
- success: True
- trace_id: 8151733478197069009
-
Scan 5654619
- duration: 0:00:50.109029
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 175, "partitions_applied": false, "success": true } - id: 5654619
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2020-07-23/", "name": "dt", "type": "string", "value": "2020-07-23" }, "s3": { "bucket": "sfdl-firehose-services-dev", "hive_path": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream", "key": "separated_dt/ddg_stream/dt=2020-07-23/ddg_stream-dev-1-2020-07-23-22-03-42-0e664c5e-a83f-492f-a16e-785af5c48624.gz" }, "schema": { "name": "sfdl_dev_firehose.services_ddg_stream", "type": "firehose" } } - running: False
- schema_name_id: 1307
- start_time: 2020-07-23 17:06:45
- success: True
- trace_id: 8930785473324031188
-
Scan 5180599
- duration: 0:00:13.894907
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1, "partitions_applied": false, "success": true } - id: 5180599
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2019-09-24/", "name": "dt", "type": "string", "value": "2019-09-24" }, "s3": { "bucket": "sfdl-firehose-services-dev", "hive_path": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream", "key": "separated_dt/ddg_stream/dt=2019-09-24/ddg_stream-dev-1-2019-09-24-19-42-23-65bce3d7-e207-443a-b600-2f146c03aa87.gz" }, "schema": { "name": "sfdl_dev_firehose.services_ddg_stream", "type": "firehose" } } - running: False
- schema_name_id: 1307
- start_time: 2019-09-24 14:43:31
- success: True
- trace_id: 5874237481638544121
- count: 65
- ddl:
[ "ALTER TABLE\n `sfdl_dev_firehose.services_ddg_stream`\nADD\n\n\n PARTITION (dt='2025-12-01') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-01/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-02/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-03/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-08/'\n PARTITION (dt='2025-12-09') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-09/'\n PARTITION (dt='2025-12-10') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-10/'\n PARTITION (dt='2025-12-15') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-15/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-19/'\n PARTITION (dt='2025-12-22') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-22/'\n PARTITION (dt='2025-12-23') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-23/'\n PARTITION (dt='2025-12-24') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-24/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-26/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-31/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-02/'\n PARTITION (dt='2026-01-05') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-08/'\n PARTITION (dt='2026-01-09') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-09/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-11/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-13/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-14/'\n PARTITION (dt='2026-01-19') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-19/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-20/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-21/'\n PARTITION (dt='2026-01-22') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-22/'\n PARTITION (dt='2026-01-23') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-23/'\n PARTITION (dt='2026-01-26') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-28/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-04/'\n PARTITION (dt='2026-02-17') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-17/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-18/'\n PARTITION (dt='2026-02-19') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-19/'\n PARTITION (dt='2026-02-20') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-20/'\n PARTITION (dt='2026-02-23') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-23/'\n PARTITION (dt='2026-02-24') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-24/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-25/'\n PARTITION (dt='2026-02-26') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-26/'\n PARTITION (dt='2026-02-27') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-27/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-02/'\n PARTITION (dt='2026-03-03') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-03/'\n PARTITION (dt='2026-03-10') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-10/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-11/'\n PARTITION (dt='2026-03-12') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-12/'\n PARTITION (dt='2026-03-13') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-13/'\n PARTITION (dt='2026-03-16') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-16/'\n PARTITION (dt='2026-03-17') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-17/'\n PARTITION (dt='2026-03-18') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-18/'\n PARTITION (dt='2026-03-19') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-19/'\n PARTITION (dt='2026-03-23') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-23/'\n PARTITION (dt='2026-03-24') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-24/'\n PARTITION (dt='2026-03-26') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-26/'\n PARTITION (dt='2026-03-30') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-30/'\n PARTITION (dt='2026-03-31') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-31/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-04-02/'\n PARTITION (dt='2026-04-06') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-04-06/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-04-07/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-04-10/'\n PARTITION (dt='2026-04-13') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-04-13/'\n;" ] - name: dt
- state:
[ { "info": { "id": 304127, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-01/", "name": "dt", "value": "2025-12-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-08 03:55:45", "last_data": "2025-12-08 03:57:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304139, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-02/", "name": "dt", "value": "2025-12-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-08 03:56:56", "last_data": "2025-12-08 03:58:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304160, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-03/", "name": "dt", "value": "2025-12-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-08 03:58:48", "last_data": "2025-12-08 04:00:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304172, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-08/", "name": "dt", "value": "2025-12-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-08 04:03:46", "last_data": "2025-12-08 04:03:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304208, "location": "s3://sfdl-firehose-services-dev/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:55:38", "last_data": "2025-12-09 16:51:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304249, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-10/", "name": "dt", "value": "2025-12-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-10 07:43:47", "last_data": "2025-12-10 13:47:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304595, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-15/", "name": "dt", "value": "2025-12-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-14 23:34:34", "last_data": "2025-12-14 23:34:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304792, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-18/", "name": "dt", "value": "2025-12-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-18 05:40:03", "last_data": "2025-12-18 11:49:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304856, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-19/", "name": "dt", "value": "2025-12-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-19 00:31:42", "last_data": "2025-12-19 04:03:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305048, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-22/", "name": "dt", "value": "2025-12-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-22 07:39:46", "last_data": "2025-12-22 07:56:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305114, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-23/", "name": "dt", "value": "2025-12-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-23 04:06:24", "last_data": "2025-12-23 15:49:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305180, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-24/", "name": "dt", "value": "2025-12-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-24 01:14:05", "last_data": "2025-12-24 01:14:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305307, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-26/", "name": "dt", "value": "2025-12-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-26 00:20:14", "last_data": "2025-12-26 00:20:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305494, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-29/", "name": "dt", "value": "2025-12-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-28 23:20:47", "last_data": "2025-12-29 14:13:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 306837, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-30/", "name": "dt", "value": "2025-12-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-30 04:20:11", "last_data": "2025-12-30 06:17:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 306964, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-31/", "name": "dt", "value": "2025-12-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-31 14:56:28", "last_data": "2025-12-31 14:56:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307029, "location": "s3://sfdl-firehose-services-dev/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:06:59", "last_data": "2026-01-02 12:08:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307219, "location": "s3://sfdl-firehose-services-dev/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:36:10", "last_data": "2026-01-05 10:35:22" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307288, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-06/", "name": "dt", "value": "2026-01-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-06 02:18:26", "last_data": "2026-01-06 15:58:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307411, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-07/", "name": "dt", "value": "2026-01-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-07 10:18:14", "last_data": "2026-01-07 11:36:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307418, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-08/", "name": "dt", "value": "2026-01-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-07 23:47:11", "last_data": "2026-01-08 00:43:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307485, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-09/", "name": "dt", "value": "2026-01-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-09 08:57:51", "last_data": "2026-01-09 11:33:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307611, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-11/", "name": "dt", "value": "2026-01-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-11 09:17:35", "last_data": "2026-01-11 10:11:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307799, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-13/", "name": "dt", "value": "2026-01-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-13 11:20:25", "last_data": "2026-01-13 11:20:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307866, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-14/", "name": "dt", "value": "2026-01-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-14 13:56:29", "last_data": "2026-01-14 14:01:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308118, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-19/", "name": "dt", "value": "2026-01-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-18 22:56:07", "last_data": "2026-01-19 03:42:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308187, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-20/", "name": "dt", "value": "2026-01-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-20 08:12:29", "last_data": "2026-01-20 10:13:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308252, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-21/", "name": "dt", "value": "2026-01-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-21 00:06:22", "last_data": "2026-01-21 16:21:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308430, "location": "s3://sfdl-firehose-services-dev/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:32:36", "last_data": "2026-01-22 11:43:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308554, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-23/", "name": "dt", "value": "2026-01-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-23 11:25:47", "last_data": "2026-01-23 11:45:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308749, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-26/", "name": "dt", "value": "2026-01-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-26 13:42:42", "last_data": "2026-01-26 17:09:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308751, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-27/", "name": "dt", "value": "2026-01-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-27 03:40:36", "last_data": "2026-01-27 16:45:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308871, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-28/", "name": "dt", "value": "2026-01-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-28 09:41:08", "last_data": "2026-01-28 13:14:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309195, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-02/", "name": "dt", "value": "2026-02-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-02 14:07:02", "last_data": "2026-02-02 16:50:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309197, "location": "s3://sfdl-firehose-services-dev/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:00:41", "last_data": "2026-02-03 15:21:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309325, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-04/", "name": "dt", "value": "2026-02-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-04 12:38:01", "last_data": "2026-02-04 14:17:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310084, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-17/", "name": "dt", "value": "2026-02-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-16 23:16:10", "last_data": "2026-02-17 09:21:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310237, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-18/", "name": "dt", "value": "2026-02-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-18 00:50:23", "last_data": "2026-02-18 10:37:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310300, "location": "s3://sfdl-firehose-services-dev/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:11:52", "last_data": "2026-02-18 23:44:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310380, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-20/", "name": "dt", "value": "2026-02-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-20 09:32:42", "last_data": "2026-02-20 09:46:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310555, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-23/", "name": "dt", "value": "2026-02-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-23 03:38:42", "last_data": "2026-02-23 03:48:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310621, "location": "s3://sfdl-firehose-services-dev/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:29:09", "last_data": "2026-02-24 15:12:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310687, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-25/", "name": "dt", "value": "2026-02-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-25 01:40:58", "last_data": "2026-02-25 10:02:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310814, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-26/", "name": "dt", "value": "2026-02-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-26 14:52:38", "last_data": "2026-02-26 15:15:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310880, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-27/", "name": "dt", "value": "2026-02-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-27 14:12:18", "last_data": "2026-02-27 16:18:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311029, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-02/", "name": "dt", "value": "2026-03-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-02 09:29:48", "last_data": "2026-03-02 16:16:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311073, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-03/", "name": "dt", "value": "2026-03-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-03 02:57:57", "last_data": "2026-03-03 15:45:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311516, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-10/", "name": "dt", "value": "2026-03-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-10 05:11:07", "last_data": "2026-03-10 13:39:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311581, "location": "s3://sfdl-firehose-services-dev/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:17:50", "last_data": "2026-03-11 05:07:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311646, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-12/", "name": "dt", "value": "2026-03-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-12 03:42:11", "last_data": "2026-03-12 13:19:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311711, "location": "s3://sfdl-firehose-services-dev/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:43:38", "last_data": "2026-03-13 00:43:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311901, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-16/", "name": "dt", "value": "2026-03-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-16 08:59:37", "last_data": "2026-03-16 11:48:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311967, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-17/", "name": "dt", "value": "2026-03-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-17 01:19:53", "last_data": "2026-03-17 01:26:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312074, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-18/", "name": "dt", "value": "2026-03-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-17 20:21:57", "last_data": "2026-03-18 07:07:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312200, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-19/", "name": "dt", "value": "2026-03-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-19 10:29:55", "last_data": "2026-03-19 10:39:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312393, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-23/", "name": "dt", "value": "2026-03-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-23 03:10:43", "last_data": "2026-03-23 13:54:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312458, "location": "s3://sfdl-firehose-services-dev/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:00:47", "last_data": "2026-03-24 01:20:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312586, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-26/", "name": "dt", "value": "2026-03-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-26 00:16:39", "last_data": "2026-03-26 00:16:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312839, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-30/", "name": "dt", "value": "2026-03-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-30 04:24:27", "last_data": "2026-03-30 04:24:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312904, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-31/", "name": "dt", "value": "2026-03-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-31 01:56:58", "last_data": "2026-03-31 02:15:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313033, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-04-02/", "name": "dt", "value": "2026-04-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-02 01:01:48", "last_data": "2026-04-02 10:55:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313286, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-04-06/", "name": "dt", "value": "2026-04-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-06 09:02:01", "last_data": "2026-04-06 09:02:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313352, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-04-07/", "name": "dt", "value": "2026-04-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-07 00:11:09", "last_data": "2026-04-07 00:56:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313543, "location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-04-10/", "name": "dt", "value": "2026-04-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-10 03:31:28", "last_data": "2026-04-10 05:18:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313731, "location": "s3://sfdl-firehose-services-dev/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:54:04", "last_data": "2026-04-13 15:45:52" }, "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", "bid_info.premiumVisitorBid": "string", "bid_info.premiumVisitorBidEnabled": "string", "isoTime": "string", "isoTimestamp": "string", "object_name": "string", "time": "string", "timestamp": "string" } - created: 2022-10-11 16:16:07
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_firehose`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_firehose.services_ddg_stream`\n(\n`time`STRING,`action`STRING,`timestamp`STRING,`isoTimestamp`STRING,`isoTime`STRING,`object_name`STRING,`_origin`STRING,`bid_info`struct<`minBid`:STRING,`premiumVisitorBidEnabled`:STRING,`isDdg`:STRING,`bidType`:STRING,`confirmationCode`:STRING,`effectiveBid`:STRING,`maxBid`:STRING,`facilityId`:STRING,`premiumVisitorBid`: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-dev/separated_dt/ddg_stream'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_firehose.services_ddg_stream`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_firehose.services_ddg_stream" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2019-09-24 14:43:31",
"disabled": false,
"format": "raw",
"id": 1307,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_dev_firehose",
"table": "services_ddg_stream"
},
"type": "firehose"
},
"partition": {
"count": 65,
"ddl": [
"ALTER TABLE\n `sfdl_dev_firehose.services_ddg_stream`\nADD\n\n\n PARTITION (dt='2025-12-01') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-01/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-02/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-03/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-08/'\n PARTITION (dt='2025-12-09') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-09/'\n PARTITION (dt='2025-12-10') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-10/'\n PARTITION (dt='2025-12-15') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-15/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-19/'\n PARTITION (dt='2025-12-22') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-22/'\n PARTITION (dt='2025-12-23') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-23/'\n PARTITION (dt='2025-12-24') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-24/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-26/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-31/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-02/'\n PARTITION (dt='2026-01-05') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-08/'\n PARTITION (dt='2026-01-09') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-09/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-11/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-13/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-14/'\n PARTITION (dt='2026-01-19') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-19/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-20/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-21/'\n PARTITION (dt='2026-01-22') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-22/'\n PARTITION (dt='2026-01-23') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-23/'\n PARTITION (dt='2026-01-26') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-28/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-04/'\n PARTITION (dt='2026-02-17') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-17/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-18/'\n PARTITION (dt='2026-02-19') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-19/'\n PARTITION (dt='2026-02-20') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-20/'\n PARTITION (dt='2026-02-23') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-23/'\n PARTITION (dt='2026-02-24') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-24/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-25/'\n PARTITION (dt='2026-02-26') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-26/'\n PARTITION (dt='2026-02-27') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-27/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-02/'\n PARTITION (dt='2026-03-03') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-03/'\n PARTITION (dt='2026-03-10') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-10/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-11/'\n PARTITION (dt='2026-03-12') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-12/'\n PARTITION (dt='2026-03-13') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-13/'\n PARTITION (dt='2026-03-16') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-16/'\n PARTITION (dt='2026-03-17') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-17/'\n PARTITION (dt='2026-03-18') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-18/'\n PARTITION (dt='2026-03-19') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-19/'\n PARTITION (dt='2026-03-23') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-23/'\n PARTITION (dt='2026-03-24') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-24/'\n PARTITION (dt='2026-03-26') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-26/'\n PARTITION (dt='2026-03-30') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-30/'\n PARTITION (dt='2026-03-31') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-31/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-04-02/'\n PARTITION (dt='2026-04-06') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-04-06/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-04-07/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-04-10/'\n PARTITION (dt='2026-04-13') location 's3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-04-13/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 304127,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-01/",
"name": "dt",
"value": "2025-12-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-08 03:55:45",
"last_data": "2025-12-08 03:57:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304139,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-02/",
"name": "dt",
"value": "2025-12-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-08 03:56:56",
"last_data": "2025-12-08 03:58:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304160,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-03/",
"name": "dt",
"value": "2025-12-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-08 03:58:48",
"last_data": "2025-12-08 04:00:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304172,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-08/",
"name": "dt",
"value": "2025-12-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-08 04:03:46",
"last_data": "2025-12-08 04:03:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304208,
"location": "s3://sfdl-firehose-services-dev/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:55:38",
"last_data": "2025-12-09 16:51:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304249,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-10/",
"name": "dt",
"value": "2025-12-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-10 07:43:47",
"last_data": "2025-12-10 13:47:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304595,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-15/",
"name": "dt",
"value": "2025-12-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-14 23:34:34",
"last_data": "2025-12-14 23:34:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304792,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-18/",
"name": "dt",
"value": "2025-12-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-18 05:40:03",
"last_data": "2025-12-18 11:49:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304856,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-19/",
"name": "dt",
"value": "2025-12-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-19 00:31:42",
"last_data": "2025-12-19 04:03:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305048,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-22/",
"name": "dt",
"value": "2025-12-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-22 07:39:46",
"last_data": "2025-12-22 07:56:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305114,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-23/",
"name": "dt",
"value": "2025-12-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-23 04:06:24",
"last_data": "2025-12-23 15:49:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305180,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-24/",
"name": "dt",
"value": "2025-12-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-24 01:14:05",
"last_data": "2025-12-24 01:14:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305307,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-26/",
"name": "dt",
"value": "2025-12-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-26 00:20:14",
"last_data": "2025-12-26 00:20:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305494,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-29/",
"name": "dt",
"value": "2025-12-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-28 23:20:47",
"last_data": "2025-12-29 14:13:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 306837,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-30/",
"name": "dt",
"value": "2025-12-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-30 04:20:11",
"last_data": "2025-12-30 06:17:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 306964,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2025-12-31/",
"name": "dt",
"value": "2025-12-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-31 14:56:28",
"last_data": "2025-12-31 14:56:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307029,
"location": "s3://sfdl-firehose-services-dev/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:06:59",
"last_data": "2026-01-02 12:08:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307219,
"location": "s3://sfdl-firehose-services-dev/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:36:10",
"last_data": "2026-01-05 10:35:22"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307288,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-06/",
"name": "dt",
"value": "2026-01-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-06 02:18:26",
"last_data": "2026-01-06 15:58:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307411,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-07/",
"name": "dt",
"value": "2026-01-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-07 10:18:14",
"last_data": "2026-01-07 11:36:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307418,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-08/",
"name": "dt",
"value": "2026-01-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-07 23:47:11",
"last_data": "2026-01-08 00:43:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307485,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-09/",
"name": "dt",
"value": "2026-01-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-09 08:57:51",
"last_data": "2026-01-09 11:33:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307611,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-11/",
"name": "dt",
"value": "2026-01-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-11 09:17:35",
"last_data": "2026-01-11 10:11:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307799,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-13/",
"name": "dt",
"value": "2026-01-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-13 11:20:25",
"last_data": "2026-01-13 11:20:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307866,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-14/",
"name": "dt",
"value": "2026-01-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-14 13:56:29",
"last_data": "2026-01-14 14:01:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308118,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-19/",
"name": "dt",
"value": "2026-01-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-18 22:56:07",
"last_data": "2026-01-19 03:42:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308187,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-20/",
"name": "dt",
"value": "2026-01-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-20 08:12:29",
"last_data": "2026-01-20 10:13:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308252,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-21/",
"name": "dt",
"value": "2026-01-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-21 00:06:22",
"last_data": "2026-01-21 16:21:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308430,
"location": "s3://sfdl-firehose-services-dev/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:32:36",
"last_data": "2026-01-22 11:43:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308554,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-23/",
"name": "dt",
"value": "2026-01-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-23 11:25:47",
"last_data": "2026-01-23 11:45:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308749,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-26/",
"name": "dt",
"value": "2026-01-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-26 13:42:42",
"last_data": "2026-01-26 17:09:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308751,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-27/",
"name": "dt",
"value": "2026-01-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-27 03:40:36",
"last_data": "2026-01-27 16:45:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308871,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-01-28/",
"name": "dt",
"value": "2026-01-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-28 09:41:08",
"last_data": "2026-01-28 13:14:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309195,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-02/",
"name": "dt",
"value": "2026-02-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-02 14:07:02",
"last_data": "2026-02-02 16:50:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309197,
"location": "s3://sfdl-firehose-services-dev/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:00:41",
"last_data": "2026-02-03 15:21:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309325,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-04/",
"name": "dt",
"value": "2026-02-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-04 12:38:01",
"last_data": "2026-02-04 14:17:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310084,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-17/",
"name": "dt",
"value": "2026-02-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-16 23:16:10",
"last_data": "2026-02-17 09:21:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310237,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-18/",
"name": "dt",
"value": "2026-02-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-18 00:50:23",
"last_data": "2026-02-18 10:37:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310300,
"location": "s3://sfdl-firehose-services-dev/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:11:52",
"last_data": "2026-02-18 23:44:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310380,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-20/",
"name": "dt",
"value": "2026-02-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-20 09:32:42",
"last_data": "2026-02-20 09:46:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310555,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-23/",
"name": "dt",
"value": "2026-02-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-23 03:38:42",
"last_data": "2026-02-23 03:48:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310621,
"location": "s3://sfdl-firehose-services-dev/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:29:09",
"last_data": "2026-02-24 15:12:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310687,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-25/",
"name": "dt",
"value": "2026-02-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-25 01:40:58",
"last_data": "2026-02-25 10:02:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310814,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-26/",
"name": "dt",
"value": "2026-02-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-26 14:52:38",
"last_data": "2026-02-26 15:15:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310880,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-02-27/",
"name": "dt",
"value": "2026-02-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-27 14:12:18",
"last_data": "2026-02-27 16:18:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311029,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-02/",
"name": "dt",
"value": "2026-03-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-02 09:29:48",
"last_data": "2026-03-02 16:16:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311073,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-03/",
"name": "dt",
"value": "2026-03-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-03 02:57:57",
"last_data": "2026-03-03 15:45:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311516,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-10/",
"name": "dt",
"value": "2026-03-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-10 05:11:07",
"last_data": "2026-03-10 13:39:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311581,
"location": "s3://sfdl-firehose-services-dev/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:17:50",
"last_data": "2026-03-11 05:07:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311646,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-12/",
"name": "dt",
"value": "2026-03-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-12 03:42:11",
"last_data": "2026-03-12 13:19:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311711,
"location": "s3://sfdl-firehose-services-dev/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:43:38",
"last_data": "2026-03-13 00:43:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311901,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-16/",
"name": "dt",
"value": "2026-03-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-16 08:59:37",
"last_data": "2026-03-16 11:48:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311967,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-17/",
"name": "dt",
"value": "2026-03-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-17 01:19:53",
"last_data": "2026-03-17 01:26:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312074,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-18/",
"name": "dt",
"value": "2026-03-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-17 20:21:57",
"last_data": "2026-03-18 07:07:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312200,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-19/",
"name": "dt",
"value": "2026-03-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-19 10:29:55",
"last_data": "2026-03-19 10:39:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312393,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-23/",
"name": "dt",
"value": "2026-03-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-23 03:10:43",
"last_data": "2026-03-23 13:54:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312458,
"location": "s3://sfdl-firehose-services-dev/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:00:47",
"last_data": "2026-03-24 01:20:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312586,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-26/",
"name": "dt",
"value": "2026-03-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-26 00:16:39",
"last_data": "2026-03-26 00:16:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312839,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-30/",
"name": "dt",
"value": "2026-03-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-30 04:24:27",
"last_data": "2026-03-30 04:24:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312904,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-03-31/",
"name": "dt",
"value": "2026-03-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-31 01:56:58",
"last_data": "2026-03-31 02:15:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313033,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-04-02/",
"name": "dt",
"value": "2026-04-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-02 01:01:48",
"last_data": "2026-04-02 10:55:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313286,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-04-06/",
"name": "dt",
"value": "2026-04-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-06 09:02:01",
"last_data": "2026-04-06 09:02:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313352,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-04-07/",
"name": "dt",
"value": "2026-04-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-07 00:11:09",
"last_data": "2026-04-07 00:56:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313543,
"location": "s3://sfdl-firehose-services-dev/separated_dt/ddg_stream/dt=2026-04-10/",
"name": "dt",
"value": "2026-04-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-10 03:31:28",
"last_data": "2026-04-10 05:18:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313731,
"location": "s3://sfdl-firehose-services-dev/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:54:04",
"last_data": "2026-04-13 15:45:52"
},
"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",
"bid_info.premiumVisitorBid": "string",
"bid_info.premiumVisitorBidEnabled": "string",
"isoTime": "string",
"isoTimestamp": "string",
"object_name": "string",
"time": "string",
"timestamp": "string"
},
"created": "2022-10-11 16:16:07",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_firehose`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_firehose.services_ddg_stream`\n(\n`time`STRING,`action`STRING,`timestamp`STRING,`isoTimestamp`STRING,`isoTime`STRING,`object_name`STRING,`_origin`STRING,`bid_info`struct<`minBid`:STRING,`premiumVisitorBidEnabled`:STRING,`isDdg`:STRING,`bidType`:STRING,`confirmationCode`:STRING,`effectiveBid`:STRING,`maxBid`:STRING,`facilityId`:STRING,`premiumVisitorBid`: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-dev/separated_dt/ddg_stream'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_firehose.services_ddg_stream`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_firehose.services_ddg_stream"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}