Schema Info
Schema Name: sfdl_stage_redshift.analytics_mart_call_center
- created: 2018-02-21 12:43:17
- disabled: False
- format: raw
- id: 407
- is_partitioned: True
- is_schema_datatyped: True
- name:
{ "database": "sfdl_stage_redshift", "table": "analytics_mart_call_center" } - type: redshift
Schema Versions: 3
-
Version 829526
- created: 2025-03-26 05:22:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_mart_call_center`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_mart_call_center`\n(\n `audit_id` bigint , `_15_minute_key` timestamp , `day_key` int , `day` date , `hold_day` date , `move_in_day` date , `call_day` date , `site_key` int , `site` varchar(255) , `traffic_source_key` int , `traffic_source` varchar(128) , `reservation_touchpoint` varchar(10) , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `type_of_listing` varchar(100) , `reservation_pricing_model` varchar(12) , `user_key` bigint , `disposition_reason_key` bigint , `disposition_call_type` varchar(20) , `disposition_sales_outcome` varchar(30) , `disposition_reason` varchar(300) , `agent_name` varchar(200) , `agent_office` varchar(30) , `agent_team_name` varchar(200) , `agent_start_day` date , `call_classification` varchar(45) , `call_classification_reason` varchar(150) , `incontact_skill_no` int , `incontact_skill_name` varchar(45) , `nvm_skill_no` int , `nvm_skill_name` varchar(45) , `inbound_call` int , `outbound_call` int , `delivered_call` int , `answered_call` int , `handled_call` int , `call_center_call` int , `call_result` varchar(10) , `visitors` int , `calls` int , `reservations` int , `npv` decimal(20,2) , `agent_time` int , `sparefoot_charge` decimal(20,2) , `annotations` varchar(2048) , `source` varchar(20) , `_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_call_center/2025-03-26/1742984366'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_mart_call_center" ] - hive_path: s3://sfdl-redshift-analytics-stage/separated_dt/mart_call_center/2025-03-26/1742984366
- id: 829526
- processed: 1
- raw_data:
{ "_15_minute_key": "1", "_origin": "46", "agent_name": "21", "agent_office": "22", "agent_start_day": "24", "agent_team_name": "23", "agent_time": "42", "annotations": "44", "answered_call": "34", "audit_id": "0", "call_center_call": "36", "call_classification": "25", "call_classification_reason": "26", "call_day": "6", "call_result": "37", "calls": "39", "day": "3", "day_key": "2", "delivered_call": "33", "disposition_call_type": "18", "disposition_reason": "20", "disposition_reason_key": "17", "disposition_sales_outcome": "19", "handled_call": "35", "hold_day": "4", "inbound_call": "31", "incontact_skill_name": "28", "incontact_skill_no": "27", "move_in_day": "5", "npv": "41", "nvm_skill_name": "30", "nvm_skill_no": "29", "outbound_call": "32", "reservation_auto_state": "13", "reservation_pricing_model": "15", "reservation_state": "12", "reservation_touchpoint": "11", "reservations": "40", "site": "8", "site_key": "7", "source": "45", "sparefoot_charge": "43", "traffic_source": "10", "traffic_source_key": "9", "type_of_listing": "14", "user_key": "16", "visitors": "38" } - schema_attributes:
{ "_15_minute_key": "timestamp", "_origin": "string", "agent_name": "varchar(200)", "agent_office": "varchar(30)", "agent_start_day": "date", "agent_team_name": "varchar(200)", "agent_time": "int", "annotations": "varchar(2048)", "answered_call": "int", "audit_id": "bigint", "call_center_call": "int", "call_classification": "varchar(45)", "call_classification_reason": "varchar(150)", "call_day": "date", "call_result": "varchar(10)", "calls": "int", "day": "date", "day_key": "int", "delivered_call": "int", "disposition_call_type": "varchar(20)", "disposition_reason": "varchar(300)", "disposition_reason_key": "bigint", "disposition_sales_outcome": "varchar(30)", "handled_call": "int", "hold_day": "date", "inbound_call": "int", "incontact_skill_name": "varchar(45)", "incontact_skill_no": "int", "move_in_day": "date", "npv": "decimal(20,2)", "nvm_skill_name": "varchar(45)", "nvm_skill_no": "int", "outbound_call": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(10)", "reservations": "int", "site": "varchar(255)", "site_key": "int", "source": "varchar(20)", "sparefoot_charge": "decimal(20,2)", "traffic_source": "varchar(128)", "traffic_source_key": "int", "type_of_listing": "varchar(100)", "user_key": "bigint", "visitors": "int" } - schema_name_id: 407
- schema_scan_id: 6250278
- updated: 2025-03-26 05:23:07
-
Version 829120
- created: 2025-03-25 05:14:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_mart_call_center`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_mart_call_center`\n(\n `audit_id` bigint , `_15_minute_key` timestamp , `day_key` int , `day` date , `hold_day` date , `move_in_day` date , `call_day` date , `site_key` int , `site` varchar(255) , `traffic_source_key` int , `traffic_source` varchar(128) , `reservation_touchpoint` varchar(10) , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `type_of_listing` varchar(100) , `reservation_pricing_model` varchar(12) , `user_key` bigint , `disposition_reason_key` bigint , `disposition_call_type` varchar(20) , `disposition_sales_outcome` varchar(30) , `disposition_reason` varchar(300) , `agent_name` varchar(200) , `agent_office` varchar(30) , `agent_team_name` varchar(200) , `agent_start_day` date , `call_classification` varchar(45) , `call_classification_reason` varchar(150) , `incontact_skill_no` int , `incontact_skill_name` varchar(45) , `nvm_skill_no` int , `nvm_skill_name` varchar(45) , `inbound_call` int , `outbound_call` int , `delivered_call` int , `answered_call` int , `handled_call` int , `call_center_call` int , `call_result` varchar(10) , `visitors` int , `calls` int , `reservations` int , `npv` decimal(20,2) , `agent_time` int , `sparefoot_charge` decimal(20,2) , `annotations` varchar(2048) , `source` varchar(20) , `_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_call_center/2025-03-25/1742897478'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_mart_call_center" ] - hive_path: s3://sfdl-redshift-analytics-stage/separated_dt/mart_call_center/2025-03-25/1742897478
- id: 829120
- processed: 1
- raw_data:
{ "_15_minute_key": "1", "_origin": "46", "agent_name": "21", "agent_office": "22", "agent_start_day": "24", "agent_team_name": "23", "agent_time": "42", "annotations": "44", "answered_call": "34", "audit_id": "0", "call_center_call": "36", "call_classification": "25", "call_classification_reason": "26", "call_day": "6", "call_result": "37", "calls": "39", "day": "3", "day_key": "2", "delivered_call": "33", "disposition_call_type": "18", "disposition_reason": "20", "disposition_reason_key": "17", "disposition_sales_outcome": "19", "handled_call": "35", "hold_day": "4", "inbound_call": "31", "incontact_skill_name": "28", "incontact_skill_no": "27", "move_in_day": "5", "npv": "41", "nvm_skill_name": "30", "nvm_skill_no": "29", "outbound_call": "32", "reservation_auto_state": "13", "reservation_pricing_model": "15", "reservation_state": "12", "reservation_touchpoint": "11", "reservations": "40", "site": "8", "site_key": "7", "source": "45", "sparefoot_charge": "43", "traffic_source": "10", "traffic_source_key": "9", "type_of_listing": "14", "user_key": "16", "visitors": "38" } - schema_attributes:
{ "_15_minute_key": "timestamp", "_origin": "string", "agent_name": "varchar(200)", "agent_office": "varchar(30)", "agent_start_day": "date", "agent_team_name": "varchar(200)", "agent_time": "int", "annotations": "varchar(2048)", "answered_call": "int", "audit_id": "bigint", "call_center_call": "int", "call_classification": "varchar(45)", "call_classification_reason": "varchar(150)", "call_day": "date", "call_result": "varchar(10)", "calls": "int", "day": "date", "day_key": "int", "delivered_call": "int", "disposition_call_type": "varchar(20)", "disposition_reason": "varchar(300)", "disposition_reason_key": "bigint", "disposition_sales_outcome": "varchar(30)", "handled_call": "int", "hold_day": "date", "inbound_call": "int", "incontact_skill_name": "varchar(45)", "incontact_skill_no": "int", "move_in_day": "date", "npv": "decimal(20,2)", "nvm_skill_name": "varchar(45)", "nvm_skill_no": "int", "outbound_call": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(10)", "reservations": "int", "site": "varchar(255)", "site_key": "int", "source": "varchar(20)", "sparefoot_charge": "decimal(20,2)", "traffic_source": "varchar(128)", "traffic_source_key": "int", "type_of_listing": "varchar(100)", "user_key": "bigint", "visitors": "int" } - schema_name_id: 407
- schema_scan_id: 6249647
- updated: 2025-03-25 05:15:19
-
Version 828713
- created: 2025-03-24 05:26:34
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_mart_call_center`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_mart_call_center`\n(\n `audit_id` bigint , `_15_minute_key` timestamp , `day_key` int , `day` date , `hold_day` date , `move_in_day` date , `call_day` date , `site_key` int , `site` varchar(255) , `traffic_source_key` int , `traffic_source` varchar(128) , `reservation_touchpoint` varchar(10) , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `type_of_listing` varchar(100) , `reservation_pricing_model` varchar(12) , `user_key` bigint , `disposition_reason_key` bigint , `disposition_call_type` varchar(20) , `disposition_sales_outcome` varchar(30) , `disposition_reason` varchar(300) , `agent_name` varchar(200) , `agent_office` varchar(30) , `agent_team_name` varchar(200) , `agent_start_day` date , `call_classification` varchar(45) , `call_classification_reason` varchar(150) , `incontact_skill_no` int , `incontact_skill_name` varchar(45) , `nvm_skill_no` int , `nvm_skill_name` varchar(45) , `inbound_call` int , `outbound_call` int , `delivered_call` int , `answered_call` int , `handled_call` int , `call_center_call` int , `call_result` varchar(10) , `visitors` int , `calls` int , `reservations` int , `npv` decimal(20,2) , `agent_time` int , `sparefoot_charge` decimal(20,2) , `annotations` varchar(2048) , `source` varchar(20) , `_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_call_center/2025-03-24/1742811807'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_mart_call_center" ] - hive_path: s3://sfdl-redshift-analytics-stage/separated_dt/mart_call_center/2025-03-24/1742811807
- id: 828713
- processed: 1
- raw_data:
{ "_15_minute_key": "1", "_origin": "46", "agent_name": "21", "agent_office": "22", "agent_start_day": "24", "agent_team_name": "23", "agent_time": "42", "annotations": "44", "answered_call": "34", "audit_id": "0", "call_center_call": "36", "call_classification": "25", "call_classification_reason": "26", "call_day": "6", "call_result": "37", "calls": "39", "day": "3", "day_key": "2", "delivered_call": "33", "disposition_call_type": "18", "disposition_reason": "20", "disposition_reason_key": "17", "disposition_sales_outcome": "19", "handled_call": "35", "hold_day": "4", "inbound_call": "31", "incontact_skill_name": "28", "incontact_skill_no": "27", "move_in_day": "5", "npv": "41", "nvm_skill_name": "30", "nvm_skill_no": "29", "outbound_call": "32", "reservation_auto_state": "13", "reservation_pricing_model": "15", "reservation_state": "12", "reservation_touchpoint": "11", "reservations": "40", "site": "8", "site_key": "7", "source": "45", "sparefoot_charge": "43", "traffic_source": "10", "traffic_source_key": "9", "type_of_listing": "14", "user_key": "16", "visitors": "38" } - schema_attributes:
{ "_15_minute_key": "timestamp", "_origin": "string", "agent_name": "varchar(200)", "agent_office": "varchar(30)", "agent_start_day": "date", "agent_team_name": "varchar(200)", "agent_time": "int", "annotations": "varchar(2048)", "answered_call": "int", "audit_id": "bigint", "call_center_call": "int", "call_classification": "varchar(45)", "call_classification_reason": "varchar(150)", "call_day": "date", "call_result": "varchar(10)", "calls": "int", "day": "date", "day_key": "int", "delivered_call": "int", "disposition_call_type": "varchar(20)", "disposition_reason": "varchar(300)", "disposition_reason_key": "bigint", "disposition_sales_outcome": "varchar(30)", "handled_call": "int", "hold_day": "date", "inbound_call": "int", "incontact_skill_name": "varchar(45)", "incontact_skill_no": "int", "move_in_day": "date", "npv": "decimal(20,2)", "nvm_skill_name": "varchar(45)", "nvm_skill_no": "int", "outbound_call": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(10)", "reservations": "int", "site": "varchar(255)", "site_key": "int", "source": "varchar(20)", "sparefoot_charge": "decimal(20,2)", "traffic_source": "varchar(128)", "traffic_source_key": "int", "type_of_listing": "varchar(100)", "user_key": "bigint", "visitors": "int" } - schema_name_id: 407
- schema_scan_id: 6248987
- updated: 2025-03-24 05:27:16
Schema Scans: 3
Last at 2025-03-26 05:22:26
-
Scan 6250278
- duration: 0:01:09.743312
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1668, "partitions_applied": false, "success": true } - id: 6250278
- payload:
{ "datatype_dict": { "_15_minute_key": "timestamp", "agent_name": "varchar(200)", "agent_office": "varchar(30)", "agent_start_day": "date", "agent_team_name": "varchar(200)", "agent_time": "int", "annotations": "varchar(2048)", "answered_call": "int", "audit_id": "bigint", "call_center_call": "int", "call_classification": "varchar(45)", "call_classification_reason": "varchar(150)", "call_day": "date", "call_result": "varchar(10)", "calls": "int", "day": "date", "day_key": "int", "delivered_call": "int", "disposition_call_type": "varchar(20)", "disposition_reason": "varchar(300)", "disposition_reason_key": "bigint", "disposition_sales_outcome": "varchar(30)", "handled_call": "int", "hold_day": "date", "inbound_call": "int", "incontact_skill_name": "varchar(45)", "incontact_skill_no": "int", "move_in_day": "date", "npv": "decimal(20,2)", "nvm_skill_name": "varchar(45)", "nvm_skill_no": "int", "origin_key": "varchar", "outbound_call": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(10)", "reservations": "int", "site": "varchar(255)", "site_key": "int", "source": "varchar(20)", "sparefoot_charge": "decimal(20,2)", "traffic_source": "varchar(128)", "traffic_source_key": "int", "type_of_listing": "varchar(100)", "user_key": "bigint", "visitors": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/mart_call_center/2025-03-26/1742984366/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-stage/separated_dt/mart_call_center/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_call_center/2025-03-26/1742984366", "key": "separated_dt/mart_call_center/2025-03-26/1742984366/dt=2025-03-26/0001_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_mart_call_center", "type": "redshift" }, "trace_context": { "parent_id": 2821906847476514574, "service_name": "redshift_unloads", "span_id": 4431487373037764849, "trace_id": 4311074665772417487 } } - running: False
- schema_name_id: 407
- start_time: 2025-03-26 05:22:26
- success: True
- trace_id: 4311074665772417487
-
Scan 6249647
- duration: 0:01:16.336169
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1667, "partitions_applied": false, "success": true } - id: 6249647
- payload:
{ "datatype_dict": { "_15_minute_key": "timestamp", "agent_name": "varchar(200)", "agent_office": "varchar(30)", "agent_start_day": "date", "agent_team_name": "varchar(200)", "agent_time": "int", "annotations": "varchar(2048)", "answered_call": "int", "audit_id": "bigint", "call_center_call": "int", "call_classification": "varchar(45)", "call_classification_reason": "varchar(150)", "call_day": "date", "call_result": "varchar(10)", "calls": "int", "day": "date", "day_key": "int", "delivered_call": "int", "disposition_call_type": "varchar(20)", "disposition_reason": "varchar(300)", "disposition_reason_key": "bigint", "disposition_sales_outcome": "varchar(30)", "handled_call": "int", "hold_day": "date", "inbound_call": "int", "incontact_skill_name": "varchar(45)", "incontact_skill_no": "int", "move_in_day": "date", "npv": "decimal(20,2)", "nvm_skill_name": "varchar(45)", "nvm_skill_no": "int", "origin_key": "varchar", "outbound_call": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(10)", "reservations": "int", "site": "varchar(255)", "site_key": "int", "source": "varchar(20)", "sparefoot_charge": "decimal(20,2)", "traffic_source": "varchar(128)", "traffic_source_key": "int", "type_of_listing": "varchar(100)", "user_key": "bigint", "visitors": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/mart_call_center/2025-03-25/1742897478/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-stage/separated_dt/mart_call_center/2025-03-25/1742897478/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_call_center/2025-03-25/1742897478", "key": "separated_dt/mart_call_center/2025-03-25/1742897478/dt=2025-03-25/0002_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_mart_call_center", "type": "redshift" }, "trace_context": { "parent_id": 18245190163184858424, "service_name": "redshift_unloads", "span_id": 7593833807268428119, "trace_id": 154671915754160668 } } - running: False
- schema_name_id: 407
- start_time: 2025-03-25 05:14:35
- success: True
- trace_id: 154671915754160668
-
Scan 6248987
- duration: 0:01:12.115572
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1666, "partitions_applied": false, "success": true } - id: 6248987
- payload:
{ "datatype_dict": { "_15_minute_key": "timestamp", "agent_name": "varchar(200)", "agent_office": "varchar(30)", "agent_start_day": "date", "agent_team_name": "varchar(200)", "agent_time": "int", "annotations": "varchar(2048)", "answered_call": "int", "audit_id": "bigint", "call_center_call": "int", "call_classification": "varchar(45)", "call_classification_reason": "varchar(150)", "call_day": "date", "call_result": "varchar(10)", "calls": "int", "day": "date", "day_key": "int", "delivered_call": "int", "disposition_call_type": "varchar(20)", "disposition_reason": "varchar(300)", "disposition_reason_key": "bigint", "disposition_sales_outcome": "varchar(30)", "handled_call": "int", "hold_day": "date", "inbound_call": "int", "incontact_skill_name": "varchar(45)", "incontact_skill_no": "int", "move_in_day": "date", "npv": "decimal(20,2)", "nvm_skill_name": "varchar(45)", "nvm_skill_no": "int", "origin_key": "varchar", "outbound_call": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(10)", "reservations": "int", "site": "varchar(255)", "site_key": "int", "source": "varchar(20)", "sparefoot_charge": "decimal(20,2)", "traffic_source": "varchar(128)", "traffic_source_key": "int", "type_of_listing": "varchar(100)", "user_key": "bigint", "visitors": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/mart_call_center/2025-03-24/1742811807/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-stage/separated_dt/mart_call_center/2025-03-24/1742811807/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_call_center/2025-03-24/1742811807", "key": "separated_dt/mart_call_center/2025-03-24/1742811807/dt=2025-03-24/0004_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_mart_call_center", "type": "redshift" }, "trace_context": { "parent_id": 7176330980158890817, "service_name": "redshift_unloads", "span_id": 5198558953935266789, "trace_id": 17614148624441079333 } } - running: False
- schema_name_id: 407
- start_time: 2025-03-24 05:26:32
- success: True
- trace_id: 17614148624441079333
- count: 3
- ddl:
[ "ALTER TABLE\n `sfdl_stage_redshift.analytics_mart_call_center`\nADD\n\n\n PARTITION (dt='2025-03-24') location 's3://sfdl-redshift-analytics-stage/separated_dt/mart_call_center/2025-03-24/1742811807/dt=2025-03-24/'\n PARTITION (dt='2025-03-25') location 's3://sfdl-redshift-analytics-stage/separated_dt/mart_call_center/2025-03-25/1742897478/dt=2025-03-25/'\n PARTITION (dt='2025-03-26') location 's3://sfdl-redshift-analytics-stage/separated_dt/mart_call_center/2025-03-26/1742984366/dt=2025-03-26/'\n;" ] - name: dt
- state:
[ { "info": { "id": 614048, "location": "s3://sfdl-redshift-analytics-stage/separated_dt/mart_call_center/2025-03-24/1742811807/dt=2025-03-24/", "name": "dt", "value": "2025-03-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-03-24 05:26:34", "last_data": "2025-03-24 05:26:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 614145, "location": "s3://sfdl-redshift-analytics-stage/separated_dt/mart_call_center/2025-03-25/1742897478/dt=2025-03-25/", "name": "dt", "value": "2025-03-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-03-25 05:14:37", "last_data": "2025-03-25 05:14:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 614243, "location": "s3://sfdl-redshift-analytics-stage/separated_dt/mart_call_center/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:22:27", "last_data": "2025-03-26 05:22:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } } ] - type: string
- attributes:
{ "_15_minute_key": "timestamp", "_origin": "string", "agent_name": "varchar(200)", "agent_office": "varchar(30)", "agent_start_day": "date", "agent_team_name": "varchar(200)", "agent_time": "int", "annotations": "varchar(2048)", "answered_call": "int", "audit_id": "bigint", "call_center_call": "int", "call_classification": "varchar(45)", "call_classification_reason": "varchar(150)", "call_day": "date", "call_result": "varchar(10)", "calls": "int", "day": "date", "day_key": "int", "delivered_call": "int", "disposition_call_type": "varchar(20)", "disposition_reason": "varchar(300)", "disposition_reason_key": "bigint", "disposition_sales_outcome": "varchar(30)", "handled_call": "int", "hold_day": "date", "inbound_call": "int", "incontact_skill_name": "varchar(45)", "incontact_skill_no": "int", "move_in_day": "date", "npv": "decimal(20,2)", "nvm_skill_name": "varchar(45)", "nvm_skill_no": "int", "outbound_call": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(10)", "reservations": "int", "site": "varchar(255)", "site_key": "int", "source": "varchar(20)", "sparefoot_charge": "decimal(20,2)", "traffic_source": "varchar(128)", "traffic_source_key": "int", "type_of_listing": "varchar(100)", "user_key": "bigint", "visitors": "int" } - created: 2025-03-26 05:22:27
- 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_call_center`\n(\n `audit_id` bigint , `_15_minute_key` timestamp , `day_key` int , `day` date , `hold_day` date , `move_in_day` date , `call_day` date , `site_key` int , `site` varchar(255) , `traffic_source_key` int , `traffic_source` varchar(128) , `reservation_touchpoint` varchar(10) , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `type_of_listing` varchar(100) , `reservation_pricing_model` varchar(12) , `user_key` bigint , `disposition_reason_key` bigint , `disposition_call_type` varchar(20) , `disposition_sales_outcome` varchar(30) , `disposition_reason` varchar(300) , `agent_name` varchar(200) , `agent_office` varchar(30) , `agent_team_name` varchar(200) , `agent_start_day` date , `call_classification` varchar(45) , `call_classification_reason` varchar(150) , `incontact_skill_no` int , `incontact_skill_name` varchar(45) , `nvm_skill_no` int , `nvm_skill_name` varchar(45) , `inbound_call` int , `outbound_call` int , `delivered_call` int , `answered_call` int , `handled_call` int , `call_center_call` int , `call_result` varchar(10) , `visitors` int , `calls` int , `reservations` int , `npv` decimal(20,2) , `agent_time` int , `sparefoot_charge` decimal(20,2) , `annotations` varchar(2048) , `source` varchar(20) , `_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_call_center/2025-03-26/1742984366'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_mart_call_center`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_mart_call_center" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2018-02-21 12:43:17",
"disabled": false,
"format": "raw",
"id": 407,
"is_partitioned": true,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_stage_redshift",
"table": "analytics_mart_call_center"
},
"type": "redshift"
},
"partition": {
"count": 3,
"ddl": [
"ALTER TABLE\n `sfdl_stage_redshift.analytics_mart_call_center`\nADD\n\n\n PARTITION (dt='2025-03-24') location 's3://sfdl-redshift-analytics-stage/separated_dt/mart_call_center/2025-03-24/1742811807/dt=2025-03-24/'\n PARTITION (dt='2025-03-25') location 's3://sfdl-redshift-analytics-stage/separated_dt/mart_call_center/2025-03-25/1742897478/dt=2025-03-25/'\n PARTITION (dt='2025-03-26') location 's3://sfdl-redshift-analytics-stage/separated_dt/mart_call_center/2025-03-26/1742984366/dt=2025-03-26/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 614048,
"location": "s3://sfdl-redshift-analytics-stage/separated_dt/mart_call_center/2025-03-24/1742811807/dt=2025-03-24/",
"name": "dt",
"value": "2025-03-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-03-24 05:26:34",
"last_data": "2025-03-24 05:26:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 614145,
"location": "s3://sfdl-redshift-analytics-stage/separated_dt/mart_call_center/2025-03-25/1742897478/dt=2025-03-25/",
"name": "dt",
"value": "2025-03-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-03-25 05:14:37",
"last_data": "2025-03-25 05:14:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 614243,
"location": "s3://sfdl-redshift-analytics-stage/separated_dt/mart_call_center/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:22:27",
"last_data": "2025-03-26 05:22:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_15_minute_key": "timestamp",
"_origin": "string",
"agent_name": "varchar(200)",
"agent_office": "varchar(30)",
"agent_start_day": "date",
"agent_team_name": "varchar(200)",
"agent_time": "int",
"annotations": "varchar(2048)",
"answered_call": "int",
"audit_id": "bigint",
"call_center_call": "int",
"call_classification": "varchar(45)",
"call_classification_reason": "varchar(150)",
"call_day": "date",
"call_result": "varchar(10)",
"calls": "int",
"day": "date",
"day_key": "int",
"delivered_call": "int",
"disposition_call_type": "varchar(20)",
"disposition_reason": "varchar(300)",
"disposition_reason_key": "bigint",
"disposition_sales_outcome": "varchar(30)",
"handled_call": "int",
"hold_day": "date",
"inbound_call": "int",
"incontact_skill_name": "varchar(45)",
"incontact_skill_no": "int",
"move_in_day": "date",
"npv": "decimal(20,2)",
"nvm_skill_name": "varchar(45)",
"nvm_skill_no": "int",
"outbound_call": "int",
"reservation_auto_state": "varchar(20)",
"reservation_pricing_model": "varchar(12)",
"reservation_state": "varchar(20)",
"reservation_touchpoint": "varchar(10)",
"reservations": "int",
"site": "varchar(255)",
"site_key": "int",
"source": "varchar(20)",
"sparefoot_charge": "decimal(20,2)",
"traffic_source": "varchar(128)",
"traffic_source_key": "int",
"type_of_listing": "varchar(100)",
"user_key": "bigint",
"visitors": "int"
},
"created": "2025-03-26 05:22:27",
"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_call_center`\n(\n `audit_id` bigint , `_15_minute_key` timestamp , `day_key` int , `day` date , `hold_day` date , `move_in_day` date , `call_day` date , `site_key` int , `site` varchar(255) , `traffic_source_key` int , `traffic_source` varchar(128) , `reservation_touchpoint` varchar(10) , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `type_of_listing` varchar(100) , `reservation_pricing_model` varchar(12) , `user_key` bigint , `disposition_reason_key` bigint , `disposition_call_type` varchar(20) , `disposition_sales_outcome` varchar(30) , `disposition_reason` varchar(300) , `agent_name` varchar(200) , `agent_office` varchar(30) , `agent_team_name` varchar(200) , `agent_start_day` date , `call_classification` varchar(45) , `call_classification_reason` varchar(150) , `incontact_skill_no` int , `incontact_skill_name` varchar(45) , `nvm_skill_no` int , `nvm_skill_name` varchar(45) , `inbound_call` int , `outbound_call` int , `delivered_call` int , `answered_call` int , `handled_call` int , `call_center_call` int , `call_result` varchar(10) , `visitors` int , `calls` int , `reservations` int , `npv` decimal(20,2) , `agent_time` int , `sparefoot_charge` decimal(20,2) , `annotations` varchar(2048) , `source` varchar(20) , `_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_call_center/2025-03-26/1742984366'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_mart_call_center`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_mart_call_center"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}