Schema Info
Schema Name: sfdl_stage_redshift.analytics_mart_facility_performance
- created: 2018-03-30 17:53:47
- disabled: False
- format: raw
- id: 467
- is_partitioned: True
- is_schema_datatyped: True
- name:
{ "database": "sfdl_stage_redshift", "table": "analytics_mart_facility_performance" } - type: redshift
Schema Versions: 3
-
Version 829529
- created: 2025-03-26 05:33:02
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_mart_facility_performance`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_mart_facility_performance`\n(\n `audit_id` bigint , `day_key` int , `day` date , `hold_day` date , `move_in_day` date , `statement_batch_move_in_start_day` date , `statement_batch_close_day` date , `site_key` int , `site` varchar(255) , `facility_key` int , `facility_name` varchar(200) , `client_key` int , `client_name` varchar(200) , `integration_key` int , `integration` varchar(100) , `facility_date_live` date , `facility_is_directory` int , `account_customer_segment` varchar(30) , `account_lifetime_customer_segment` varchar(30) , `account_manager_key` int , `account_manager` varchar(24) , `account_pricing_model` varchar(10) , `location_key` int , `zip` varchar(6) , `city` varchar(200) , `state` varchar(2) , `msa` varchar(150) , `county` varchar(32) , `reservation_type` varchar(12) , `reservation_pricing_model` varchar(12) , `reservation_touchpoint` varchar(19) , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `statement_batch_key` int , `facility_status` varchar(40) , `annotations` varchar(2048) , `sparefoot_charge` decimal(18,2) , `impressions` int , `clicks` int , `searches` int , `sum_rank` bigint , `average_sort_position` decimal(16,2) , `reservations` int , `npv` decimal(18,2) , `bid_flat` decimal , `bid_percent` decimal(6,2) , `positive_bid_changes` int , `negative_bid_changes` int , `positive_bid_change_amount` int , `negative_bid_change_amount` int , `_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/mart_facility_performance/2025-03-26/1742984366'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_mart_facility_performance" ] - hive_path: s3://sfdl-redshift-analytics-stage/separated_dt/mart_facility_performance/2025-03-26/1742984366
- id: 829529
- processed: 1
- raw_data:
{ "_origin": "50", "account_customer_segment": "17", "account_lifetime_customer_segment": "18", "account_manager": "20", "account_manager_key": "19", "account_pricing_model": "21", "annotations": "35", "audit_id": "0", "average_sort_position": "41", "bid_flat": "44", "bid_percent": "45", "city": "24", "clicks": "38", "client_key": "11", "client_name": "12", "county": "27", "day": "2", "day_key": "1", "facility_date_live": "15", "facility_is_directory": "16", "facility_key": "9", "facility_name": "10", "facility_status": "34", "hold_day": "3", "impressions": "37", "integration": "14", "integration_key": "13", "location_key": "22", "move_in_day": "4", "msa": "26", "negative_bid_change_amount": "49", "negative_bid_changes": "47", "npv": "43", "positive_bid_change_amount": "48", "positive_bid_changes": "46", "reservation_auto_state": "32", "reservation_pricing_model": "29", "reservation_state": "31", "reservation_touchpoint": "30", "reservation_type": "28", "reservations": "42", "searches": "39", "site": "8", "site_key": "7", "sparefoot_charge": "36", "state": "25", "statement_batch_close_day": "6", "statement_batch_key": "33", "statement_batch_move_in_start_day": "5", "sum_rank": "40", "zip": "23" } - schema_attributes:
{ "_origin": "string", "account_customer_segment": "varchar(30)", "account_lifetime_customer_segment": "varchar(30)", "account_manager": "varchar(24)", "account_manager_key": "int", "account_pricing_model": "varchar(10)", "annotations": "varchar(2048)", "audit_id": "bigint", "average_sort_position": "decimal(16,2)", "bid_flat": "decimal", "bid_percent": "decimal(6,2)", "city": "varchar(200)", "clicks": "int", "client_key": "int", "client_name": "varchar(200)", "county": "varchar(32)", "day": "date", "day_key": "int", "facility_date_live": "date", "facility_is_directory": "int", "facility_key": "int", "facility_name": "varchar(200)", "facility_status": "varchar(40)", "hold_day": "date", "impressions": "int", "integration": "varchar(100)", "integration_key": "int", "location_key": "int", "move_in_day": "date", "msa": "varchar(150)", "negative_bid_change_amount": "int", "negative_bid_changes": "int", "npv": "decimal(18,2)", "positive_bid_change_amount": "int", "positive_bid_changes": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(19)", "reservation_type": "varchar(12)", "reservations": "int", "searches": "int", "site": "varchar(255)", "site_key": "int", "sparefoot_charge": "decimal(18,2)", "state": "varchar(2)", "statement_batch_close_day": "date", "statement_batch_key": "int", "statement_batch_move_in_start_day": "date", "sum_rank": "bigint", "zip": "varchar(6)" } - schema_name_id: 467
- schema_scan_id: 6250281
- updated: 2025-03-26 05:33:42
-
Version 829123
- created: 2025-03-25 05:25:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_mart_facility_performance`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_mart_facility_performance`\n(\n `audit_id` bigint , `day_key` int , `day` date , `hold_day` date , `move_in_day` date , `statement_batch_move_in_start_day` date , `statement_batch_close_day` date , `site_key` int , `site` varchar(255) , `facility_key` int , `facility_name` varchar(200) , `client_key` int , `client_name` varchar(200) , `integration_key` int , `integration` varchar(100) , `facility_date_live` date , `facility_is_directory` int , `account_customer_segment` varchar(30) , `account_lifetime_customer_segment` varchar(30) , `account_manager_key` int , `account_manager` varchar(24) , `account_pricing_model` varchar(10) , `location_key` int , `zip` varchar(6) , `city` varchar(200) , `state` varchar(2) , `msa` varchar(150) , `county` varchar(32) , `reservation_type` varchar(12) , `reservation_pricing_model` varchar(12) , `reservation_touchpoint` varchar(19) , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `statement_batch_key` int , `facility_status` varchar(40) , `annotations` varchar(2048) , `sparefoot_charge` decimal(18,2) , `impressions` int , `clicks` int , `searches` int , `sum_rank` bigint , `average_sort_position` decimal(16,2) , `reservations` int , `npv` decimal(18,2) , `bid_flat` decimal , `bid_percent` decimal(6,2) , `positive_bid_changes` int , `negative_bid_changes` int , `positive_bid_change_amount` int , `negative_bid_change_amount` int , `_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/mart_facility_performance/2025-03-25/1742897479'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_mart_facility_performance" ] - hive_path: s3://sfdl-redshift-analytics-stage/separated_dt/mart_facility_performance/2025-03-25/1742897479
- id: 829123
- processed: 1
- raw_data:
{ "_origin": "50", "account_customer_segment": "17", "account_lifetime_customer_segment": "18", "account_manager": "20", "account_manager_key": "19", "account_pricing_model": "21", "annotations": "35", "audit_id": "0", "average_sort_position": "41", "bid_flat": "44", "bid_percent": "45", "city": "24", "clicks": "38", "client_key": "11", "client_name": "12", "county": "27", "day": "2", "day_key": "1", "facility_date_live": "15", "facility_is_directory": "16", "facility_key": "9", "facility_name": "10", "facility_status": "34", "hold_day": "3", "impressions": "37", "integration": "14", "integration_key": "13", "location_key": "22", "move_in_day": "4", "msa": "26", "negative_bid_change_amount": "49", "negative_bid_changes": "47", "npv": "43", "positive_bid_change_amount": "48", "positive_bid_changes": "46", "reservation_auto_state": "32", "reservation_pricing_model": "29", "reservation_state": "31", "reservation_touchpoint": "30", "reservation_type": "28", "reservations": "42", "searches": "39", "site": "8", "site_key": "7", "sparefoot_charge": "36", "state": "25", "statement_batch_close_day": "6", "statement_batch_key": "33", "statement_batch_move_in_start_day": "5", "sum_rank": "40", "zip": "23" } - schema_attributes:
{ "_origin": "string", "account_customer_segment": "varchar(30)", "account_lifetime_customer_segment": "varchar(30)", "account_manager": "varchar(24)", "account_manager_key": "int", "account_pricing_model": "varchar(10)", "annotations": "varchar(2048)", "audit_id": "bigint", "average_sort_position": "decimal(16,2)", "bid_flat": "decimal", "bid_percent": "decimal(6,2)", "city": "varchar(200)", "clicks": "int", "client_key": "int", "client_name": "varchar(200)", "county": "varchar(32)", "day": "date", "day_key": "int", "facility_date_live": "date", "facility_is_directory": "int", "facility_key": "int", "facility_name": "varchar(200)", "facility_status": "varchar(40)", "hold_day": "date", "impressions": "int", "integration": "varchar(100)", "integration_key": "int", "location_key": "int", "move_in_day": "date", "msa": "varchar(150)", "negative_bid_change_amount": "int", "negative_bid_changes": "int", "npv": "decimal(18,2)", "positive_bid_change_amount": "int", "positive_bid_changes": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(19)", "reservation_type": "varchar(12)", "reservations": "int", "searches": "int", "site": "varchar(255)", "site_key": "int", "sparefoot_charge": "decimal(18,2)", "state": "varchar(2)", "statement_batch_close_day": "date", "statement_batch_key": "int", "statement_batch_move_in_start_day": "date", "sum_rank": "bigint", "zip": "varchar(6)" } - schema_name_id: 467
- schema_scan_id: 6249656
- updated: 2025-03-25 05:25:56
-
Version 828715
- created: 2025-03-24 05:36:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_mart_facility_performance`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_mart_facility_performance`\n(\n `audit_id` bigint , `day_key` int , `day` date , `hold_day` date , `move_in_day` date , `statement_batch_move_in_start_day` date , `statement_batch_close_day` date , `site_key` int , `site` varchar(255) , `facility_key` int , `facility_name` varchar(200) , `client_key` int , `client_name` varchar(200) , `integration_key` int , `integration` varchar(100) , `facility_date_live` date , `facility_is_directory` int , `account_customer_segment` varchar(30) , `account_lifetime_customer_segment` varchar(30) , `account_manager_key` int , `account_manager` varchar(24) , `account_pricing_model` varchar(10) , `location_key` int , `zip` varchar(6) , `city` varchar(200) , `state` varchar(2) , `msa` varchar(150) , `county` varchar(32) , `reservation_type` varchar(12) , `reservation_pricing_model` varchar(12) , `reservation_touchpoint` varchar(19) , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `statement_batch_key` int , `facility_status` varchar(40) , `annotations` varchar(2048) , `sparefoot_charge` decimal(18,2) , `impressions` int , `clicks` int , `searches` int , `sum_rank` bigint , `average_sort_position` decimal(16,2) , `reservations` int , `npv` decimal(18,2) , `bid_flat` decimal , `bid_percent` decimal(6,2) , `positive_bid_changes` int , `negative_bid_changes` int , `positive_bid_change_amount` int , `negative_bid_change_amount` int , `_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/mart_facility_performance/2025-03-24/1742811806'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_mart_facility_performance" ] - hive_path: s3://sfdl-redshift-analytics-stage/separated_dt/mart_facility_performance/2025-03-24/1742811806
- id: 828715
- processed: 1
- raw_data:
{ "_origin": "50", "account_customer_segment": "17", "account_lifetime_customer_segment": "18", "account_manager": "20", "account_manager_key": "19", "account_pricing_model": "21", "annotations": "35", "audit_id": "0", "average_sort_position": "41", "bid_flat": "44", "bid_percent": "45", "city": "24", "clicks": "38", "client_key": "11", "client_name": "12", "county": "27", "day": "2", "day_key": "1", "facility_date_live": "15", "facility_is_directory": "16", "facility_key": "9", "facility_name": "10", "facility_status": "34", "hold_day": "3", "impressions": "37", "integration": "14", "integration_key": "13", "location_key": "22", "move_in_day": "4", "msa": "26", "negative_bid_change_amount": "49", "negative_bid_changes": "47", "npv": "43", "positive_bid_change_amount": "48", "positive_bid_changes": "46", "reservation_auto_state": "32", "reservation_pricing_model": "29", "reservation_state": "31", "reservation_touchpoint": "30", "reservation_type": "28", "reservations": "42", "searches": "39", "site": "8", "site_key": "7", "sparefoot_charge": "36", "state": "25", "statement_batch_close_day": "6", "statement_batch_key": "33", "statement_batch_move_in_start_day": "5", "sum_rank": "40", "zip": "23" } - schema_attributes:
{ "_origin": "string", "account_customer_segment": "varchar(30)", "account_lifetime_customer_segment": "varchar(30)", "account_manager": "varchar(24)", "account_manager_key": "int", "account_pricing_model": "varchar(10)", "annotations": "varchar(2048)", "audit_id": "bigint", "average_sort_position": "decimal(16,2)", "bid_flat": "decimal", "bid_percent": "decimal(6,2)", "city": "varchar(200)", "clicks": "int", "client_key": "int", "client_name": "varchar(200)", "county": "varchar(32)", "day": "date", "day_key": "int", "facility_date_live": "date", "facility_is_directory": "int", "facility_key": "int", "facility_name": "varchar(200)", "facility_status": "varchar(40)", "hold_day": "date", "impressions": "int", "integration": "varchar(100)", "integration_key": "int", "location_key": "int", "move_in_day": "date", "msa": "varchar(150)", "negative_bid_change_amount": "int", "negative_bid_changes": "int", "npv": "decimal(18,2)", "positive_bid_change_amount": "int", "positive_bid_changes": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(19)", "reservation_type": "varchar(12)", "reservations": "int", "searches": "int", "site": "varchar(255)", "site_key": "int", "sparefoot_charge": "decimal(18,2)", "state": "varchar(2)", "statement_batch_close_day": "date", "statement_batch_key": "int", "statement_batch_move_in_start_day": "date", "sum_rank": "bigint", "zip": "varchar(6)" } - schema_name_id: 467
- schema_scan_id: 6248989
- updated: 2025-03-24 05:37:36
Schema Scans: 3
Last at 2025-03-26 05:33:00
-
Scan 6250281
- duration: 0:01:14.242399
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1662, "partitions_applied": false, "success": true } - id: 6250281
- payload:
{ "datatype_dict": { "account_customer_segment": "varchar(30)", "account_lifetime_customer_segment": "varchar(30)", "account_manager": "varchar(24)", "account_manager_key": "int", "account_pricing_model": "varchar(10)", "annotations": "varchar(2048)", "audit_id": "bigint", "average_sort_position": "decimal(16,2)", "bid_flat": "decimal", "bid_percent": "decimal(6,2)", "city": "varchar(200)", "clicks": "int", "client_key": "int", "client_name": "varchar(200)", "county": "varchar(32)", "day": "date", "day_key": "int", "facility_date_live": "date", "facility_is_directory": "int", "facility_key": "int", "facility_name": "varchar(200)", "facility_status": "varchar(40)", "hold_day": "date", "impressions": "int", "integration": "varchar(100)", "integration_key": "int", "location_key": "int", "move_in_day": "date", "msa": "varchar(150)", "negative_bid_change_amount": "int", "negative_bid_changes": "int", "npv": "decimal(18,2)", "origin_key": "varchar", "positive_bid_change_amount": "int", "positive_bid_changes": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(19)", "reservation_type": "varchar(12)", "reservations": "int", "searches": "int", "site": "varchar(255)", "site_key": "int", "sparefoot_charge": "decimal(18,2)", "state": "varchar(2)", "statement_batch_close_day": "date", "statement_batch_key": "int", "statement_batch_move_in_start_day": "date", "sum_rank": "bigint", "zip": "varchar(6)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/mart_facility_performance/2025-03-26/1742984366/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-stage/separated_dt/mart_facility_performance/2025-03-26/1742984366/dt=2025-03-26", "name": "dt", "type": "string", "value": "2025-03-26" }, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/separated_dt/mart_facility_performance/2025-03-26/1742984366", "key": "separated_dt/mart_facility_performance/2025-03-26/1742984366/dt=2025-03-26/0001_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_mart_facility_performance", "type": "redshift" }, "trace_context": { "parent_id": 2852472262498694696, "service_name": "redshift_unloads", "span_id": 7590463793499119221, "trace_id": 1944038516344754928 } } - running: False
- schema_name_id: 467
- start_time: 2025-03-26 05:33:00
- success: True
- trace_id: 1944038516344754928
-
Scan 6249656
- duration: 0:01:14.771744
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1661, "partitions_applied": false, "success": true } - id: 6249656
- payload:
{ "datatype_dict": { "account_customer_segment": "varchar(30)", "account_lifetime_customer_segment": "varchar(30)", "account_manager": "varchar(24)", "account_manager_key": "int", "account_pricing_model": "varchar(10)", "annotations": "varchar(2048)", "audit_id": "bigint", "average_sort_position": "decimal(16,2)", "bid_flat": "decimal", "bid_percent": "decimal(6,2)", "city": "varchar(200)", "clicks": "int", "client_key": "int", "client_name": "varchar(200)", "county": "varchar(32)", "day": "date", "day_key": "int", "facility_date_live": "date", "facility_is_directory": "int", "facility_key": "int", "facility_name": "varchar(200)", "facility_status": "varchar(40)", "hold_day": "date", "impressions": "int", "integration": "varchar(100)", "integration_key": "int", "location_key": "int", "move_in_day": "date", "msa": "varchar(150)", "negative_bid_change_amount": "int", "negative_bid_changes": "int", "npv": "decimal(18,2)", "origin_key": "varchar", "positive_bid_change_amount": "int", "positive_bid_changes": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(19)", "reservation_type": "varchar(12)", "reservations": "int", "searches": "int", "site": "varchar(255)", "site_key": "int", "sparefoot_charge": "decimal(18,2)", "state": "varchar(2)", "statement_batch_close_day": "date", "statement_batch_key": "int", "statement_batch_move_in_start_day": "date", "sum_rank": "bigint", "zip": "varchar(6)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/mart_facility_performance/2025-03-25/1742897479/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-stage/separated_dt/mart_facility_performance/2025-03-25/1742897479/dt=2025-03-25", "name": "dt", "type": "string", "value": "2025-03-25" }, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/separated_dt/mart_facility_performance/2025-03-25/1742897479", "key": "separated_dt/mart_facility_performance/2025-03-25/1742897479/dt=2025-03-25/0002_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_mart_facility_performance", "type": "redshift" }, "trace_context": { "parent_id": 8961346828871738141, "service_name": "redshift_unloads", "span_id": 9080569709345908608, "trace_id": 15024414093567740593 } } - running: False
- schema_name_id: 467
- start_time: 2025-03-25 05:25:09
- success: True
- trace_id: 15024414093567740593
-
Scan 6248989
- duration: 0:01:11.935728
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1660, "partitions_applied": false, "success": true } - id: 6248989
- payload:
{ "datatype_dict": { "account_customer_segment": "varchar(30)", "account_lifetime_customer_segment": "varchar(30)", "account_manager": "varchar(24)", "account_manager_key": "int", "account_pricing_model": "varchar(10)", "annotations": "varchar(2048)", "audit_id": "bigint", "average_sort_position": "decimal(16,2)", "bid_flat": "decimal", "bid_percent": "decimal(6,2)", "city": "varchar(200)", "clicks": "int", "client_key": "int", "client_name": "varchar(200)", "county": "varchar(32)", "day": "date", "day_key": "int", "facility_date_live": "date", "facility_is_directory": "int", "facility_key": "int", "facility_name": "varchar(200)", "facility_status": "varchar(40)", "hold_day": "date", "impressions": "int", "integration": "varchar(100)", "integration_key": "int", "location_key": "int", "move_in_day": "date", "msa": "varchar(150)", "negative_bid_change_amount": "int", "negative_bid_changes": "int", "npv": "decimal(18,2)", "origin_key": "varchar", "positive_bid_change_amount": "int", "positive_bid_changes": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(19)", "reservation_type": "varchar(12)", "reservations": "int", "searches": "int", "site": "varchar(255)", "site_key": "int", "sparefoot_charge": "decimal(18,2)", "state": "varchar(2)", "statement_batch_close_day": "date", "statement_batch_key": "int", "statement_batch_move_in_start_day": "date", "sum_rank": "bigint", "zip": "varchar(6)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/mart_facility_performance/2025-03-24/1742811806/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-stage/separated_dt/mart_facility_performance/2025-03-24/1742811806/dt=2025-03-24", "name": "dt", "type": "string", "value": "2025-03-24" }, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/separated_dt/mart_facility_performance/2025-03-24/1742811806", "key": "separated_dt/mart_facility_performance/2025-03-24/1742811806/dt=2025-03-24/0004_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_mart_facility_performance", "type": "redshift" }, "trace_context": { "parent_id": 9384201554738655722, "service_name": "redshift_unloads", "span_id": 15058663151477822629, "trace_id": 12773841023701569975 } } - running: False
- schema_name_id: 467
- start_time: 2025-03-24 05:36:53
- success: True
- trace_id: 12773841023701569975
- count: 3
- ddl:
[ "ALTER TABLE\n `sfdl_stage_redshift.analytics_mart_facility_performance`\nADD\n\n\n PARTITION (dt='2025-03-24') location 's3://sfdl-redshift-analytics-stage/separated_dt/mart_facility_performance/2025-03-24/1742811806/dt=2025-03-24/'\n PARTITION (dt='2025-03-25') location 's3://sfdl-redshift-analytics-stage/separated_dt/mart_facility_performance/2025-03-25/1742897479/dt=2025-03-25/'\n PARTITION (dt='2025-03-26') location 's3://sfdl-redshift-analytics-stage/separated_dt/mart_facility_performance/2025-03-26/1742984366/dt=2025-03-26/'\n;" ] - name: dt
- state:
[ { "info": { "id": 614050, "location": "s3://sfdl-redshift-analytics-stage/separated_dt/mart_facility_performance/2025-03-24/1742811806/dt=2025-03-24/", "name": "dt", "value": "2025-03-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-03-24 05:36:54", "last_data": "2025-03-24 05:36:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 614153, "location": "s3://sfdl-redshift-analytics-stage/separated_dt/mart_facility_performance/2025-03-25/1742897479/dt=2025-03-25/", "name": "dt", "value": "2025-03-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-03-25 05:25:11", "last_data": "2025-03-25 05:25:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 614246, "location": "s3://sfdl-redshift-analytics-stage/separated_dt/mart_facility_performance/2025-03-26/1742984366/dt=2025-03-26/", "name": "dt", "value": "2025-03-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-03-26 05:33:02", "last_data": "2025-03-26 05:33:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } } ] - type: string
- attributes:
{ "_origin": "string", "account_customer_segment": "varchar(30)", "account_lifetime_customer_segment": "varchar(30)", "account_manager": "varchar(24)", "account_manager_key": "int", "account_pricing_model": "varchar(10)", "annotations": "varchar(2048)", "audit_id": "bigint", "average_sort_position": "decimal(16,2)", "bid_flat": "decimal", "bid_percent": "decimal(6,2)", "city": "varchar(200)", "clicks": "int", "client_key": "int", "client_name": "varchar(200)", "county": "varchar(32)", "day": "date", "day_key": "int", "facility_date_live": "date", "facility_is_directory": "int", "facility_key": "int", "facility_name": "varchar(200)", "facility_status": "varchar(40)", "hold_day": "date", "impressions": "int", "integration": "varchar(100)", "integration_key": "int", "location_key": "int", "move_in_day": "date", "msa": "varchar(150)", "negative_bid_change_amount": "int", "negative_bid_changes": "int", "npv": "decimal(18,2)", "positive_bid_change_amount": "int", "positive_bid_changes": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(19)", "reservation_type": "varchar(12)", "reservations": "int", "searches": "int", "site": "varchar(255)", "site_key": "int", "sparefoot_charge": "decimal(18,2)", "state": "varchar(2)", "statement_batch_close_day": "date", "statement_batch_key": "int", "statement_batch_move_in_start_day": "date", "sum_rank": "bigint", "zip": "varchar(6)" } - created: 2025-03-26 05:33:02
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_mart_facility_performance`\n(\n `audit_id` bigint , `day_key` int , `day` date , `hold_day` date , `move_in_day` date , `statement_batch_move_in_start_day` date , `statement_batch_close_day` date , `site_key` int , `site` varchar(255) , `facility_key` int , `facility_name` varchar(200) , `client_key` int , `client_name` varchar(200) , `integration_key` int , `integration` varchar(100) , `facility_date_live` date , `facility_is_directory` int , `account_customer_segment` varchar(30) , `account_lifetime_customer_segment` varchar(30) , `account_manager_key` int , `account_manager` varchar(24) , `account_pricing_model` varchar(10) , `location_key` int , `zip` varchar(6) , `city` varchar(200) , `state` varchar(2) , `msa` varchar(150) , `county` varchar(32) , `reservation_type` varchar(12) , `reservation_pricing_model` varchar(12) , `reservation_touchpoint` varchar(19) , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `statement_batch_key` int , `facility_status` varchar(40) , `annotations` varchar(2048) , `sparefoot_charge` decimal(18,2) , `impressions` int , `clicks` int , `searches` int , `sum_rank` bigint , `average_sort_position` decimal(16,2) , `reservations` int , `npv` decimal(18,2) , `bid_flat` decimal , `bid_percent` decimal(6,2) , `positive_bid_changes` int , `negative_bid_changes` int , `positive_bid_change_amount` int , `negative_bid_change_amount` int , `_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/mart_facility_performance/2025-03-26/1742984366'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_mart_facility_performance`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_mart_facility_performance" }
- 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 17:53:47",
"disabled": false,
"format": "raw",
"id": 467,
"is_partitioned": true,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_stage_redshift",
"table": "analytics_mart_facility_performance"
},
"type": "redshift"
},
"partition": {
"count": 3,
"ddl": [
"ALTER TABLE\n `sfdl_stage_redshift.analytics_mart_facility_performance`\nADD\n\n\n PARTITION (dt='2025-03-24') location 's3://sfdl-redshift-analytics-stage/separated_dt/mart_facility_performance/2025-03-24/1742811806/dt=2025-03-24/'\n PARTITION (dt='2025-03-25') location 's3://sfdl-redshift-analytics-stage/separated_dt/mart_facility_performance/2025-03-25/1742897479/dt=2025-03-25/'\n PARTITION (dt='2025-03-26') location 's3://sfdl-redshift-analytics-stage/separated_dt/mart_facility_performance/2025-03-26/1742984366/dt=2025-03-26/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 614050,
"location": "s3://sfdl-redshift-analytics-stage/separated_dt/mart_facility_performance/2025-03-24/1742811806/dt=2025-03-24/",
"name": "dt",
"value": "2025-03-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-03-24 05:36:54",
"last_data": "2025-03-24 05:36:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 614153,
"location": "s3://sfdl-redshift-analytics-stage/separated_dt/mart_facility_performance/2025-03-25/1742897479/dt=2025-03-25/",
"name": "dt",
"value": "2025-03-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-03-25 05:25:11",
"last_data": "2025-03-25 05:25:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 614246,
"location": "s3://sfdl-redshift-analytics-stage/separated_dt/mart_facility_performance/2025-03-26/1742984366/dt=2025-03-26/",
"name": "dt",
"value": "2025-03-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-03-26 05:33:02",
"last_data": "2025-03-26 05:33:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_origin": "string",
"account_customer_segment": "varchar(30)",
"account_lifetime_customer_segment": "varchar(30)",
"account_manager": "varchar(24)",
"account_manager_key": "int",
"account_pricing_model": "varchar(10)",
"annotations": "varchar(2048)",
"audit_id": "bigint",
"average_sort_position": "decimal(16,2)",
"bid_flat": "decimal",
"bid_percent": "decimal(6,2)",
"city": "varchar(200)",
"clicks": "int",
"client_key": "int",
"client_name": "varchar(200)",
"county": "varchar(32)",
"day": "date",
"day_key": "int",
"facility_date_live": "date",
"facility_is_directory": "int",
"facility_key": "int",
"facility_name": "varchar(200)",
"facility_status": "varchar(40)",
"hold_day": "date",
"impressions": "int",
"integration": "varchar(100)",
"integration_key": "int",
"location_key": "int",
"move_in_day": "date",
"msa": "varchar(150)",
"negative_bid_change_amount": "int",
"negative_bid_changes": "int",
"npv": "decimal(18,2)",
"positive_bid_change_amount": "int",
"positive_bid_changes": "int",
"reservation_auto_state": "varchar(20)",
"reservation_pricing_model": "varchar(12)",
"reservation_state": "varchar(20)",
"reservation_touchpoint": "varchar(19)",
"reservation_type": "varchar(12)",
"reservations": "int",
"searches": "int",
"site": "varchar(255)",
"site_key": "int",
"sparefoot_charge": "decimal(18,2)",
"state": "varchar(2)",
"statement_batch_close_day": "date",
"statement_batch_key": "int",
"statement_batch_move_in_start_day": "date",
"sum_rank": "bigint",
"zip": "varchar(6)"
},
"created": "2025-03-26 05:33:02",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_mart_facility_performance`\n(\n `audit_id` bigint , `day_key` int , `day` date , `hold_day` date , `move_in_day` date , `statement_batch_move_in_start_day` date , `statement_batch_close_day` date , `site_key` int , `site` varchar(255) , `facility_key` int , `facility_name` varchar(200) , `client_key` int , `client_name` varchar(200) , `integration_key` int , `integration` varchar(100) , `facility_date_live` date , `facility_is_directory` int , `account_customer_segment` varchar(30) , `account_lifetime_customer_segment` varchar(30) , `account_manager_key` int , `account_manager` varchar(24) , `account_pricing_model` varchar(10) , `location_key` int , `zip` varchar(6) , `city` varchar(200) , `state` varchar(2) , `msa` varchar(150) , `county` varchar(32) , `reservation_type` varchar(12) , `reservation_pricing_model` varchar(12) , `reservation_touchpoint` varchar(19) , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `statement_batch_key` int , `facility_status` varchar(40) , `annotations` varchar(2048) , `sparefoot_charge` decimal(18,2) , `impressions` int , `clicks` int , `searches` int , `sum_rank` bigint , `average_sort_position` decimal(16,2) , `reservations` int , `npv` decimal(18,2) , `bid_flat` decimal , `bid_percent` decimal(6,2) , `positive_bid_changes` int , `negative_bid_changes` int , `positive_bid_change_amount` int , `negative_bid_change_amount` int , `_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/mart_facility_performance/2025-03-26/1742984366'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_mart_facility_performance`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_mart_facility_performance"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}