Schema Info
Schema Name: sfdl_stage_redshift.analytics_dwh_fact_day_facility
- created: 2018-03-30 16:58:05
- disabled: False
- format: raw
- id: 461
- is_partitioned: True
- is_schema_datatyped: True
- name:
{ "database": "sfdl_stage_redshift", "table": "analytics_dwh_fact_day_facility" } - type: redshift
Schema Versions: 3
-
Version 837342
- created: 2025-04-23 03:24:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_day_facility`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_day_facility`\n(\n `audit_id` bigint , `day_key` int , `day` date , `facility_key` int , `positive_bid_changes` int , `negative_bid_changes` int , `positive_bid_change_amount` int , `negative_bid_change_amount` int , `min_bid` decimal , `max_bid` decimal , `start_bid` decimal , `end_bid` decimal , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-23/1745396631'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_day_facility" ] - hive_path: s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-23/1745396631
- id: 837342
- processed: 1
- raw_data:
{ "_origin": "12", "audit_id": "0", "day": "2", "day_key": "1", "end_bid": "11", "facility_key": "3", "max_bid": "9", "min_bid": "8", "negative_bid_change_amount": "7", "negative_bid_changes": "5", "positive_bid_change_amount": "6", "positive_bid_changes": "4", "start_bid": "10" } - schema_attributes:
{ "_origin": "string", "audit_id": "bigint", "day": "date", "day_key": "int", "end_bid": "decimal", "facility_key": "int", "max_bid": "decimal", "min_bid": "decimal", "negative_bid_change_amount": "int", "negative_bid_changes": "int", "positive_bid_change_amount": "int", "positive_bid_changes": "int", "start_bid": "decimal" } - schema_name_id: 461
- schema_scan_id: 6263726
- updated: 2025-04-23 03:24:23
-
Version 837158
- created: 2025-04-22 03:21:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_day_facility`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_day_facility`\n(\n `audit_id` bigint , `day_key` int , `day` date , `facility_key` int , `positive_bid_changes` int , `negative_bid_changes` int , `positive_bid_change_amount` int , `negative_bid_change_amount` int , `min_bid` decimal , `max_bid` decimal , `start_bid` decimal , `end_bid` decimal , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-22/1745310101'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_day_facility" ] - hive_path: s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-22/1745310101
- id: 837158
- processed: 1
- raw_data:
{ "_origin": "12", "audit_id": "0", "day": "2", "day_key": "1", "end_bid": "11", "facility_key": "3", "max_bid": "9", "min_bid": "8", "negative_bid_change_amount": "7", "negative_bid_changes": "5", "positive_bid_change_amount": "6", "positive_bid_changes": "4", "start_bid": "10" } - schema_attributes:
{ "_origin": "string", "audit_id": "bigint", "day": "date", "day_key": "int", "end_bid": "decimal", "facility_key": "int", "max_bid": "decimal", "min_bid": "decimal", "negative_bid_change_amount": "int", "negative_bid_changes": "int", "positive_bid_change_amount": "int", "positive_bid_changes": "int", "start_bid": "decimal" } - schema_name_id: 461
- schema_scan_id: 6263319
- updated: 2025-04-22 03:22:12
-
Version 836917
- created: 2025-04-21 02:57:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_day_facility`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_day_facility`\n(\n `audit_id` bigint , `day_key` int , `day` date , `facility_key` int , `positive_bid_changes` int , `negative_bid_changes` int , `positive_bid_change_amount` int , `negative_bid_change_amount` int , `min_bid` decimal , `max_bid` decimal , `start_bid` decimal , `end_bid` decimal , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-21/1745222232'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_day_facility" ] - hive_path: s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-21/1745222232
- id: 836917
- processed: 1
- raw_data:
{ "_origin": "12", "audit_id": "0", "day": "2", "day_key": "1", "end_bid": "11", "facility_key": "3", "max_bid": "9", "min_bid": "8", "negative_bid_change_amount": "7", "negative_bid_changes": "5", "positive_bid_change_amount": "6", "positive_bid_changes": "4", "start_bid": "10" } - schema_attributes:
{ "_origin": "string", "audit_id": "bigint", "day": "date", "day_key": "int", "end_bid": "decimal", "facility_key": "int", "max_bid": "decimal", "min_bid": "decimal", "negative_bid_change_amount": "int", "negative_bid_changes": "int", "positive_bid_change_amount": "int", "positive_bid_changes": "int", "start_bid": "decimal" } - schema_name_id: 461
- schema_scan_id: 6262804
- updated: 2025-04-21 02:57:42
Schema Scans: 3
Last at 2025-04-23 03:24:06
-
Scan 6263726
- duration: 0:00:21.052681
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 110, "partitions_applied": false, "success": true } - id: 6263726
- payload:
{ "datatype_dict": { "audit_id": "bigint", "day": "date", "day_key": "int", "end_bid": "decimal", "facility_key": "int", "max_bid": "decimal", "min_bid": "decimal", "negative_bid_change_amount": "int", "negative_bid_changes": "int", "origin_key": "varchar", "positive_bid_change_amount": "int", "positive_bid_changes": "int", "start_bid": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_fact_day_facility/2025-04-23/1745396631/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-23/1745396631/dt=2025-04-09", "name": "dt", "type": "string", "value": "2025-04-09" }, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-23/1745396631", "key": "separated_dt/dwh_fact_day_facility/2025-04-23/1745396631/dt=2025-04-09/0000_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_fact_day_facility", "type": "redshift" }, "trace_context": { "parent_id": 13737406230804498768, "service_name": "redshift_unloads", "span_id": 6585772163415695661, "trace_id": 13530808841681670208 } } - running: False
- schema_name_id: 461
- start_time: 2025-04-23 03:24:06
- success: True
- trace_id: 13530808841681670208
-
Scan 6263319
- duration: 0:00:21.314630
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 110, "partitions_applied": false, "success": true } - id: 6263319
- payload:
{ "datatype_dict": { "audit_id": "bigint", "day": "date", "day_key": "int", "end_bid": "decimal", "facility_key": "int", "max_bid": "decimal", "min_bid": "decimal", "negative_bid_change_amount": "int", "negative_bid_changes": "int", "origin_key": "varchar", "positive_bid_change_amount": "int", "positive_bid_changes": "int", "start_bid": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_fact_day_facility/2025-04-22/1745310101/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-22/1745310101/dt=2025-04-09", "name": "dt", "type": "string", "value": "2025-04-09" }, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-22/1745310101", "key": "separated_dt/dwh_fact_day_facility/2025-04-22/1745310101/dt=2025-04-09/0000_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_fact_day_facility", "type": "redshift" }, "trace_context": { "parent_id": 18077552444321912204, "service_name": "redshift_unloads", "span_id": 13564704423631022472, "trace_id": 7855150693096467210 } } - running: False
- schema_name_id: 461
- start_time: 2025-04-22 03:21:56
- success: True
- trace_id: 7855150693096467210
-
Scan 6262804
- duration: 0:00:18.416070
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 110, "partitions_applied": false, "success": true } - id: 6262804
- payload:
{ "datatype_dict": { "audit_id": "bigint", "day": "date", "day_key": "int", "end_bid": "decimal", "facility_key": "int", "max_bid": "decimal", "min_bid": "decimal", "negative_bid_change_amount": "int", "negative_bid_changes": "int", "origin_key": "varchar", "positive_bid_change_amount": "int", "positive_bid_changes": "int", "start_bid": "decimal" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_fact_day_facility/2025-04-21/1745222232/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-21/1745222232/dt=2025-04-09", "name": "dt", "type": "string", "value": "2025-04-09" }, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-21/1745222232", "key": "separated_dt/dwh_fact_day_facility/2025-04-21/1745222232/dt=2025-04-09/0000_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_fact_day_facility", "type": "redshift" }, "trace_context": { "parent_id": 16940048539249544269, "service_name": "redshift_unloads", "span_id": 1042339145570517911, "trace_id": 3592320893497064653 } } - running: False
- schema_name_id: 461
- start_time: 2025-04-21 02:57:28
- success: True
- trace_id: 3592320893497064653
- count: 7
- ddl:
[ "ALTER TABLE\n `sfdl_stage_redshift.analytics_dwh_fact_day_facility`\nADD\n\n\n PARTITION (dt='2021-10-04') location 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-16/1744790542/dt=2021-10-04/'\n PARTITION (dt='2023-01-13') location 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-16/1744790542/dt=2023-01-13/'\n PARTITION (dt='2023-08-08') location 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-16/1744790542/dt=2023-08-08/'\n PARTITION (dt='2024-02-26') location 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-16/1744790542/dt=2024-02-26/'\n PARTITION (dt='2024-09-20') location 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-16/1744790542/dt=2024-09-20/'\n PARTITION (dt='2025-03-24') location 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-09/1744186393/dt=2025-03-24'\n PARTITION (dt='2025-04-09') location 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-23/1745396631/dt=2025-04-09'\n;" ] - name: dt
- state:
[ { "info": { "id": 619920, "location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-16/1744790542/dt=2021-10-04/", "name": "dt", "value": "2021-10-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-04-16 03:03:00", "last_data": "2025-04-16 03:03:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 619918, "location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-16/1744790542/dt=2023-01-13/", "name": "dt", "value": "2023-01-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-04-16 03:02:59", "last_data": "2025-04-16 03:02:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 619917, "location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-16/1744790542/dt=2023-08-08/", "name": "dt", "value": "2023-08-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-04-16 03:02:58", "last_data": "2025-04-16 03:02:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 619919, "location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-16/1744790542/dt=2024-02-26/", "name": "dt", "value": "2024-02-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-04-16 03:02:59", "last_data": "2025-04-16 03:02:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 619916, "location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-16/1744790542/dt=2024-09-20/", "name": "dt", "value": "2024-09-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-04-16 03:02:58", "last_data": "2025-04-16 03:02:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 614143, "location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-09/1744186393/dt=2025-03-24", "name": "dt", "value": "2025-03-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-03-25 03:30:51", "last_data": "2025-04-09 03:13:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 617887, "location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-23/1745396631/dt=2025-04-09", "name": "dt", "value": "2025-04-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-04-10 03:12:08", "last_data": "2025-04-23 03:24:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } } ] - type: string
- attributes:
{ "_origin": "string", "audit_id": "bigint", "day": "date", "day_key": "int", "end_bid": "decimal", "facility_key": "int", "max_bid": "decimal", "min_bid": "decimal", "negative_bid_change_amount": "int", "negative_bid_changes": "int", "positive_bid_change_amount": "int", "positive_bid_changes": "int", "start_bid": "decimal" } - created: 2025-04-23 03:24:07
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_day_facility`\n(\n `audit_id` bigint , `day_key` int , `day` date , `facility_key` int , `positive_bid_changes` int , `negative_bid_changes` int , `positive_bid_change_amount` int , `negative_bid_change_amount` int , `min_bid` decimal , `max_bid` decimal , `start_bid` decimal , `end_bid` decimal , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-23/1745396631'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_day_facility`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_day_facility" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2018-03-30 16:58:05",
"disabled": false,
"format": "raw",
"id": 461,
"is_partitioned": true,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_stage_redshift",
"table": "analytics_dwh_fact_day_facility"
},
"type": "redshift"
},
"partition": {
"count": 7,
"ddl": [
"ALTER TABLE\n `sfdl_stage_redshift.analytics_dwh_fact_day_facility`\nADD\n\n\n PARTITION (dt='2021-10-04') location 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-16/1744790542/dt=2021-10-04/'\n PARTITION (dt='2023-01-13') location 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-16/1744790542/dt=2023-01-13/'\n PARTITION (dt='2023-08-08') location 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-16/1744790542/dt=2023-08-08/'\n PARTITION (dt='2024-02-26') location 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-16/1744790542/dt=2024-02-26/'\n PARTITION (dt='2024-09-20') location 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-16/1744790542/dt=2024-09-20/'\n PARTITION (dt='2025-03-24') location 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-09/1744186393/dt=2025-03-24'\n PARTITION (dt='2025-04-09') location 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-23/1745396631/dt=2025-04-09'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 619920,
"location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-16/1744790542/dt=2021-10-04/",
"name": "dt",
"value": "2021-10-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-04-16 03:03:00",
"last_data": "2025-04-16 03:03:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 619918,
"location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-16/1744790542/dt=2023-01-13/",
"name": "dt",
"value": "2023-01-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-04-16 03:02:59",
"last_data": "2025-04-16 03:02:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 619917,
"location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-16/1744790542/dt=2023-08-08/",
"name": "dt",
"value": "2023-08-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-04-16 03:02:58",
"last_data": "2025-04-16 03:02:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 619919,
"location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-16/1744790542/dt=2024-02-26/",
"name": "dt",
"value": "2024-02-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-04-16 03:02:59",
"last_data": "2025-04-16 03:02:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 619916,
"location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-16/1744790542/dt=2024-09-20/",
"name": "dt",
"value": "2024-09-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-04-16 03:02:58",
"last_data": "2025-04-16 03:02:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 614143,
"location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-09/1744186393/dt=2025-03-24",
"name": "dt",
"value": "2025-03-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-03-25 03:30:51",
"last_data": "2025-04-09 03:13:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 617887,
"location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-23/1745396631/dt=2025-04-09",
"name": "dt",
"value": "2025-04-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-04-10 03:12:08",
"last_data": "2025-04-23 03:24:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_origin": "string",
"audit_id": "bigint",
"day": "date",
"day_key": "int",
"end_bid": "decimal",
"facility_key": "int",
"max_bid": "decimal",
"min_bid": "decimal",
"negative_bid_change_amount": "int",
"negative_bid_changes": "int",
"positive_bid_change_amount": "int",
"positive_bid_changes": "int",
"start_bid": "decimal"
},
"created": "2025-04-23 03:24:07",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_day_facility`\n(\n `audit_id` bigint , `day_key` int , `day` date , `facility_key` int , `positive_bid_changes` int , `negative_bid_changes` int , `positive_bid_change_amount` int , `negative_bid_change_amount` int , `min_bid` decimal , `max_bid` decimal , `start_bid` decimal , `end_bid` decimal , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_day_facility/2025-04-23/1745396631'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_day_facility`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_day_facility"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}