Schema Info
Schema Name: sfdl_stage_redshift.analytics_dwh_fact_call_genesys
- created: 2019-11-19 11:01:32
- disabled: False
- format: raw
- id: 916
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_stage_redshift", "table": "analytics_dwh_fact_call_genesys" } - type: redshift
Schema Versions: 3
-
Version 837315
- created: 2025-04-23 03:03:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_call_genesys`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_call_genesys`\n(\n `audit_id` bigint , `day_key` int , `day` date , `call_key` bigint , `site_key` int , `traffic_source_key` int , `visitor_key` bigint , `call_event_key` bigint , `user_key` int , `disposition_reason_key` int , `_15_min_interval` timestamp , `start_time` timestamp , `end_time` timestamp , `agent_time` int , `to_number` varchar(16) , `from_number` varchar(16) , `transferred_to` varchar(16) , `agent_answer_start_time` timestamp , `agent_answer_end_time` timestamp , `call_classification` varchar(45) , `classification_reason` varchar(150) , `twilio_sid` varchar(255) , `tsla` int , `application` varchar(45) , `recording_url` varchar(256) , `phone_number_location` varchar(100) , `nvm_skill_no` int , `nvm_skill_bucket` varchar(50) , `incontact_skill_no` int , `inbound` int , `outbound` int , `delivered` int , `answered` int , `handled` int , `call_result` varchar(10) , `call_center_call` 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/dwh_fact_call_genesys/2025-04-23/1745395198'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_call_genesys" ] - hive_path: s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_call_genesys/2025-04-23/1745395198
- id: 837315
- processed: 1
- raw_data:
{ "_15_min_interval": "10", "_origin": "36", "agent_answer_end_time": "18", "agent_answer_start_time": "17", "agent_time": "13", "answered": "32", "application": "23", "audit_id": "0", "call_center_call": "35", "call_classification": "19", "call_event_key": "7", "call_key": "3", "call_result": "34", "classification_reason": "20", "day": "2", "day_key": "1", "delivered": "31", "disposition_reason_key": "9", "end_time": "12", "from_number": "15", "handled": "33", "inbound": "29", "incontact_skill_no": "28", "nvm_skill_bucket": "27", "nvm_skill_no": "26", "outbound": "30", "phone_number_location": "25", "recording_url": "24", "site_key": "4", "start_time": "11", "to_number": "14", "traffic_source_key": "5", "transferred_to": "16", "tsla": "22", "twilio_sid": "21", "user_key": "8", "visitor_key": "6" } - schema_attributes:
{ "_15_min_interval": "timestamp", "_origin": "string", "agent_answer_end_time": "timestamp", "agent_answer_start_time": "timestamp", "agent_time": "int", "answered": "int", "application": "varchar(45)", "audit_id": "bigint", "call_center_call": "int", "call_classification": "varchar(45)", "call_event_key": "bigint", "call_key": "bigint", "call_result": "varchar(10)", "classification_reason": "varchar(150)", "day": "date", "day_key": "int", "delivered": "int", "disposition_reason_key": "int", "end_time": "timestamp", "from_number": "varchar(16)", "handled": "int", "inbound": "int", "incontact_skill_no": "int", "nvm_skill_bucket": "varchar(50)", "nvm_skill_no": "int", "outbound": "int", "phone_number_location": "varchar(100)", "recording_url": "varchar(256)", "site_key": "int", "start_time": "timestamp", "to_number": "varchar(16)", "traffic_source_key": "int", "transferred_to": "varchar(16)", "tsla": "int", "twilio_sid": "varchar(255)", "user_key": "int", "visitor_key": "bigint" } - schema_name_id: 916
- schema_scan_id: 6263697
- updated: 2025-04-23 03:04:10
-
Version 837112
- created: 2025-04-22 02:55:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_call_genesys`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_call_genesys`\n(\n `audit_id` bigint , `day_key` int , `day` date , `call_key` bigint , `site_key` int , `traffic_source_key` int , `visitor_key` bigint , `call_event_key` bigint , `user_key` int , `disposition_reason_key` int , `_15_min_interval` timestamp , `start_time` timestamp , `end_time` timestamp , `agent_time` int , `to_number` varchar(16) , `from_number` varchar(16) , `transferred_to` varchar(16) , `agent_answer_start_time` timestamp , `agent_answer_end_time` timestamp , `call_classification` varchar(45) , `classification_reason` varchar(150) , `twilio_sid` varchar(255) , `tsla` int , `application` varchar(45) , `recording_url` varchar(256) , `phone_number_location` varchar(100) , `nvm_skill_no` int , `nvm_skill_bucket` varchar(50) , `incontact_skill_no` int , `inbound` int , `outbound` int , `delivered` int , `answered` int , `handled` int , `call_result` varchar(10) , `call_center_call` 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/dwh_fact_call_genesys/2025-04-22/1745308324'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_call_genesys" ] - hive_path: s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_call_genesys/2025-04-22/1745308324
- id: 837112
- processed: 1
- raw_data:
{ "_15_min_interval": "10", "_origin": "36", "agent_answer_end_time": "18", "agent_answer_start_time": "17", "agent_time": "13", "answered": "32", "application": "23", "audit_id": "0", "call_center_call": "35", "call_classification": "19", "call_event_key": "7", "call_key": "3", "call_result": "34", "classification_reason": "20", "day": "2", "day_key": "1", "delivered": "31", "disposition_reason_key": "9", "end_time": "12", "from_number": "15", "handled": "33", "inbound": "29", "incontact_skill_no": "28", "nvm_skill_bucket": "27", "nvm_skill_no": "26", "outbound": "30", "phone_number_location": "25", "recording_url": "24", "site_key": "4", "start_time": "11", "to_number": "14", "traffic_source_key": "5", "transferred_to": "16", "tsla": "22", "twilio_sid": "21", "user_key": "8", "visitor_key": "6" } - schema_attributes:
{ "_15_min_interval": "timestamp", "_origin": "string", "agent_answer_end_time": "timestamp", "agent_answer_start_time": "timestamp", "agent_time": "int", "answered": "int", "application": "varchar(45)", "audit_id": "bigint", "call_center_call": "int", "call_classification": "varchar(45)", "call_event_key": "bigint", "call_key": "bigint", "call_result": "varchar(10)", "classification_reason": "varchar(150)", "day": "date", "day_key": "int", "delivered": "int", "disposition_reason_key": "int", "end_time": "timestamp", "from_number": "varchar(16)", "handled": "int", "inbound": "int", "incontact_skill_no": "int", "nvm_skill_bucket": "varchar(50)", "nvm_skill_no": "int", "outbound": "int", "phone_number_location": "varchar(100)", "recording_url": "varchar(256)", "site_key": "int", "start_time": "timestamp", "to_number": "varchar(16)", "traffic_source_key": "int", "transferred_to": "varchar(16)", "tsla": "int", "twilio_sid": "varchar(255)", "user_key": "int", "visitor_key": "bigint" } - schema_name_id: 916
- schema_scan_id: 6263272
- updated: 2025-04-22 02:56:01
-
Version 836908
- created: 2025-04-21 02:52:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_call_genesys`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_call_genesys`\n(\n `audit_id` bigint , `day_key` int , `day` date , `call_key` bigint , `site_key` int , `traffic_source_key` int , `visitor_key` bigint , `call_event_key` bigint , `user_key` int , `disposition_reason_key` int , `_15_min_interval` timestamp , `start_time` timestamp , `end_time` timestamp , `agent_time` int , `to_number` varchar(16) , `from_number` varchar(16) , `transferred_to` varchar(16) , `agent_answer_start_time` timestamp , `agent_answer_end_time` timestamp , `call_classification` varchar(45) , `classification_reason` varchar(150) , `twilio_sid` varchar(255) , `tsla` int , `application` varchar(45) , `recording_url` varchar(256) , `phone_number_location` varchar(100) , `nvm_skill_no` int , `nvm_skill_bucket` varchar(50) , `incontact_skill_no` int , `inbound` int , `outbound` int , `delivered` int , `answered` int , `handled` int , `call_result` varchar(10) , `call_center_call` 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/dwh_fact_call_genesys/2025-04-21/1745221780'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_call_genesys" ] - hive_path: s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_call_genesys/2025-04-21/1745221780
- id: 836908
- processed: 1
- raw_data:
{ "_15_min_interval": "10", "_origin": "36", "agent_answer_end_time": "18", "agent_answer_start_time": "17", "agent_time": "13", "answered": "32", "application": "23", "audit_id": "0", "call_center_call": "35", "call_classification": "19", "call_event_key": "7", "call_key": "3", "call_result": "34", "classification_reason": "20", "day": "2", "day_key": "1", "delivered": "31", "disposition_reason_key": "9", "end_time": "12", "from_number": "15", "handled": "33", "inbound": "29", "incontact_skill_no": "28", "nvm_skill_bucket": "27", "nvm_skill_no": "26", "outbound": "30", "phone_number_location": "25", "recording_url": "24", "site_key": "4", "start_time": "11", "to_number": "14", "traffic_source_key": "5", "transferred_to": "16", "tsla": "22", "twilio_sid": "21", "user_key": "8", "visitor_key": "6" } - schema_attributes:
{ "_15_min_interval": "timestamp", "_origin": "string", "agent_answer_end_time": "timestamp", "agent_answer_start_time": "timestamp", "agent_time": "int", "answered": "int", "application": "varchar(45)", "audit_id": "bigint", "call_center_call": "int", "call_classification": "varchar(45)", "call_event_key": "bigint", "call_key": "bigint", "call_result": "varchar(10)", "classification_reason": "varchar(150)", "day": "date", "day_key": "int", "delivered": "int", "disposition_reason_key": "int", "end_time": "timestamp", "from_number": "varchar(16)", "handled": "int", "inbound": "int", "incontact_skill_no": "int", "nvm_skill_bucket": "varchar(50)", "nvm_skill_no": "int", "outbound": "int", "phone_number_location": "varchar(100)", "recording_url": "varchar(256)", "site_key": "int", "start_time": "timestamp", "to_number": "varchar(16)", "traffic_source_key": "int", "transferred_to": "varchar(16)", "tsla": "int", "twilio_sid": "varchar(255)", "user_key": "int", "visitor_key": "bigint" } - schema_name_id: 916
- schema_scan_id: 6262794
- updated: 2025-04-21 02:53:45
Schema Scans: 3
Last at 2025-04-23 03:03:14
-
Scan 6263697
- duration: 0:01:33.991600
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2178, "partitions_applied": false, "success": true } - id: 6263697
- payload:
{ "datatype_dict": { "_15_min_interval": "timestamp", "agent_answer_end_time": "timestamp", "agent_answer_start_time": "timestamp", "agent_time": "int", "answered": "int", "application": "varchar(45)", "audit_id": "bigint", "call_center_call": "int", "call_classification": "varchar(45)", "call_event_key": "bigint", "call_key": "bigint", "call_result": "varchar(10)", "classification_reason": "varchar(150)", "day": "date", "day_key": "int", "delivered": "int", "disposition_reason_key": "int", "end_time": "timestamp", "from_number": "varchar(16)", "handled": "int", "inbound": "int", "incontact_skill_no": "int", "nvm_skill_bucket": "varchar(50)", "nvm_skill_no": "int", "origin_key": "varchar", "outbound": "int", "phone_number_location": "varchar(100)", "recording_url": "varchar(256)", "site_key": "int", "start_time": "timestamp", "to_number": "varchar(16)", "traffic_source_key": "int", "transferred_to": "varchar(16)", "tsla": "int", "twilio_sid": "varchar(255)", "user_key": "int", "visitor_key": "bigint" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_fact_call_genesys/2025-04-23/1745395198/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_call_genesys/2025-04-23/1745395198/dt=2025-04-22", "name": "dt", "type": "string", "value": "2025-04-22" }, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_call_genesys/2025-04-23/1745395198", "key": "separated_dt/dwh_fact_call_genesys/2025-04-23/1745395198/dt=2025-04-22/0006_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_fact_call_genesys", "type": "redshift" }, "trace_context": { "parent_id": 18243533955030224938, "service_name": "redshift_unloads", "span_id": 17989759849179110848, "trace_id": 15384955327127372220 } } - running: False
- schema_name_id: 916
- start_time: 2025-04-23 03:03:14
- success: True
- trace_id: 15384955327127372220
-
Scan 6263272
- duration: 0:01:30.758794
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2177, "partitions_applied": false, "success": true } - id: 6263272
- payload:
{ "datatype_dict": { "_15_min_interval": "timestamp", "agent_answer_end_time": "timestamp", "agent_answer_start_time": "timestamp", "agent_time": "int", "answered": "int", "application": "varchar(45)", "audit_id": "bigint", "call_center_call": "int", "call_classification": "varchar(45)", "call_event_key": "bigint", "call_key": "bigint", "call_result": "varchar(10)", "classification_reason": "varchar(150)", "day": "date", "day_key": "int", "delivered": "int", "disposition_reason_key": "int", "end_time": "timestamp", "from_number": "varchar(16)", "handled": "int", "inbound": "int", "incontact_skill_no": "int", "nvm_skill_bucket": "varchar(50)", "nvm_skill_no": "int", "origin_key": "varchar", "outbound": "int", "phone_number_location": "varchar(100)", "recording_url": "varchar(256)", "site_key": "int", "start_time": "timestamp", "to_number": "varchar(16)", "traffic_source_key": "int", "transferred_to": "varchar(16)", "tsla": "int", "twilio_sid": "varchar(255)", "user_key": "int", "visitor_key": "bigint" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_fact_call_genesys/2025-04-22/1745308324/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_call_genesys/2025-04-22/1745308324/dt=2025-04-21", "name": "dt", "type": "string", "value": "2025-04-21" }, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_call_genesys/2025-04-22/1745308324", "key": "separated_dt/dwh_fact_call_genesys/2025-04-22/1745308324/dt=2025-04-21/0005_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_fact_call_genesys", "type": "redshift" }, "trace_context": { "parent_id": 14819673326746737866, "service_name": "redshift_unloads", "span_id": 7704572847377977125, "trace_id": 1017508598217951999 } } - running: False
- schema_name_id: 916
- start_time: 2025-04-22 02:55:07
- success: True
- trace_id: 1017508598217951999
-
Scan 6262794
- duration: 0:01:27.893000
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2176, "partitions_applied": false, "success": true } - id: 6262794
- payload:
{ "datatype_dict": { "_15_min_interval": "timestamp", "agent_answer_end_time": "timestamp", "agent_answer_start_time": "timestamp", "agent_time": "int", "answered": "int", "application": "varchar(45)", "audit_id": "bigint", "call_center_call": "int", "call_classification": "varchar(45)", "call_event_key": "bigint", "call_key": "bigint", "call_result": "varchar(10)", "classification_reason": "varchar(150)", "day": "date", "day_key": "int", "delivered": "int", "disposition_reason_key": "int", "end_time": "timestamp", "from_number": "varchar(16)", "handled": "int", "inbound": "int", "incontact_skill_no": "int", "nvm_skill_bucket": "varchar(50)", "nvm_skill_no": "int", "origin_key": "varchar", "outbound": "int", "phone_number_location": "varchar(100)", "recording_url": "varchar(256)", "site_key": "int", "start_time": "timestamp", "to_number": "varchar(16)", "traffic_source_key": "int", "transferred_to": "varchar(16)", "tsla": "int", "twilio_sid": "varchar(255)", "user_key": "int", "visitor_key": "bigint" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_fact_call_genesys/2025-04-21/1745221780/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_call_genesys/2025-04-21/1745221780/dt=2025-04-20", "name": "dt", "type": "string", "value": "2025-04-20" }, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_call_genesys/2025-04-21/1745221780", "key": "separated_dt/dwh_fact_call_genesys/2025-04-21/1745221780/dt=2025-04-20/0001_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_fact_call_genesys", "type": "redshift" }, "trace_context": { "parent_id": 15226886501742706643, "service_name": "redshift_unloads", "span_id": 16680899184026087006, "trace_id": 18198027469023799670 } } - running: False
- schema_name_id: 916
- start_time: 2025-04-21 02:52:52
- success: True
- trace_id: 18198027469023799670
- count: 3
- ddl:
[ "ALTER TABLE\n `sfdl_stage_redshift.analytics_dwh_fact_call_genesys`\nADD\n\n\n PARTITION (dt='2025-04-20') location 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_call_genesys/2025-04-21/1745221780/dt=2025-04-20/'\n PARTITION (dt='2025-04-21') location 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_call_genesys/2025-04-22/1745308324/dt=2025-04-21/'\n PARTITION (dt='2025-04-22') location 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_call_genesys/2025-04-23/1745395198/dt=2025-04-22/'\n;" ] - name: dt
- state:
[ { "info": { "id": 620853, "location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_call_genesys/2025-04-21/1745221780/dt=2025-04-20/", "name": "dt", "value": "2025-04-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-04-21 02:52:53", "last_data": "2025-04-21 02:52:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 621010, "location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_call_genesys/2025-04-22/1745308324/dt=2025-04-21/", "name": "dt", "value": "2025-04-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-04-22 02:55:09", "last_data": "2025-04-22 02:55:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 621156, "location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_call_genesys/2025-04-23/1745395198/dt=2025-04-22/", "name": "dt", "value": "2025-04-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-04-23 03:03:16", "last_data": "2025-04-23 03:03:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } } ] - type: string
- attributes:
{ "_15_min_interval": "timestamp", "_origin": "string", "agent_answer_end_time": "timestamp", "agent_answer_start_time": "timestamp", "agent_time": "int", "answered": "int", "application": "varchar(45)", "audit_id": "bigint", "call_center_call": "int", "call_classification": "varchar(45)", "call_event_key": "bigint", "call_key": "bigint", "call_result": "varchar(10)", "classification_reason": "varchar(150)", "day": "date", "day_key": "int", "delivered": "int", "disposition_reason_key": "int", "end_time": "timestamp", "from_number": "varchar(16)", "handled": "int", "inbound": "int", "incontact_skill_no": "int", "nvm_skill_bucket": "varchar(50)", "nvm_skill_no": "int", "outbound": "int", "phone_number_location": "varchar(100)", "recording_url": "varchar(256)", "site_key": "int", "start_time": "timestamp", "to_number": "varchar(16)", "traffic_source_key": "int", "transferred_to": "varchar(16)", "tsla": "int", "twilio_sid": "varchar(255)", "user_key": "int", "visitor_key": "bigint" } - created: 2025-04-23 03:03:16
- 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_call_genesys`\n(\n `audit_id` bigint , `day_key` int , `day` date , `call_key` bigint , `site_key` int , `traffic_source_key` int , `visitor_key` bigint , `call_event_key` bigint , `user_key` int , `disposition_reason_key` int , `_15_min_interval` timestamp , `start_time` timestamp , `end_time` timestamp , `agent_time` int , `to_number` varchar(16) , `from_number` varchar(16) , `transferred_to` varchar(16) , `agent_answer_start_time` timestamp , `agent_answer_end_time` timestamp , `call_classification` varchar(45) , `classification_reason` varchar(150) , `twilio_sid` varchar(255) , `tsla` int , `application` varchar(45) , `recording_url` varchar(256) , `phone_number_location` varchar(100) , `nvm_skill_no` int , `nvm_skill_bucket` varchar(50) , `incontact_skill_no` int , `inbound` int , `outbound` int , `delivered` int , `answered` int , `handled` int , `call_result` varchar(10) , `call_center_call` 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/dwh_fact_call_genesys/2025-04-23/1745395198'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_call_genesys`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_call_genesys" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2019-11-19 11:01:32",
"disabled": false,
"format": "raw",
"id": 916,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_stage_redshift",
"table": "analytics_dwh_fact_call_genesys"
},
"type": "redshift"
},
"partition": {
"count": 3,
"ddl": [
"ALTER TABLE\n `sfdl_stage_redshift.analytics_dwh_fact_call_genesys`\nADD\n\n\n PARTITION (dt='2025-04-20') location 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_call_genesys/2025-04-21/1745221780/dt=2025-04-20/'\n PARTITION (dt='2025-04-21') location 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_call_genesys/2025-04-22/1745308324/dt=2025-04-21/'\n PARTITION (dt='2025-04-22') location 's3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_call_genesys/2025-04-23/1745395198/dt=2025-04-22/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 620853,
"location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_call_genesys/2025-04-21/1745221780/dt=2025-04-20/",
"name": "dt",
"value": "2025-04-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-04-21 02:52:53",
"last_data": "2025-04-21 02:52:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 621010,
"location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_call_genesys/2025-04-22/1745308324/dt=2025-04-21/",
"name": "dt",
"value": "2025-04-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-04-22 02:55:09",
"last_data": "2025-04-22 02:55:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 621156,
"location": "s3://sfdl-redshift-analytics-stage/separated_dt/dwh_fact_call_genesys/2025-04-23/1745395198/dt=2025-04-22/",
"name": "dt",
"value": "2025-04-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-04-23 03:03:16",
"last_data": "2025-04-23 03:03:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_15_min_interval": "timestamp",
"_origin": "string",
"agent_answer_end_time": "timestamp",
"agent_answer_start_time": "timestamp",
"agent_time": "int",
"answered": "int",
"application": "varchar(45)",
"audit_id": "bigint",
"call_center_call": "int",
"call_classification": "varchar(45)",
"call_event_key": "bigint",
"call_key": "bigint",
"call_result": "varchar(10)",
"classification_reason": "varchar(150)",
"day": "date",
"day_key": "int",
"delivered": "int",
"disposition_reason_key": "int",
"end_time": "timestamp",
"from_number": "varchar(16)",
"handled": "int",
"inbound": "int",
"incontact_skill_no": "int",
"nvm_skill_bucket": "varchar(50)",
"nvm_skill_no": "int",
"outbound": "int",
"phone_number_location": "varchar(100)",
"recording_url": "varchar(256)",
"site_key": "int",
"start_time": "timestamp",
"to_number": "varchar(16)",
"traffic_source_key": "int",
"transferred_to": "varchar(16)",
"tsla": "int",
"twilio_sid": "varchar(255)",
"user_key": "int",
"visitor_key": "bigint"
},
"created": "2025-04-23 03:03:16",
"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_call_genesys`\n(\n `audit_id` bigint , `day_key` int , `day` date , `call_key` bigint , `site_key` int , `traffic_source_key` int , `visitor_key` bigint , `call_event_key` bigint , `user_key` int , `disposition_reason_key` int , `_15_min_interval` timestamp , `start_time` timestamp , `end_time` timestamp , `agent_time` int , `to_number` varchar(16) , `from_number` varchar(16) , `transferred_to` varchar(16) , `agent_answer_start_time` timestamp , `agent_answer_end_time` timestamp , `call_classification` varchar(45) , `classification_reason` varchar(150) , `twilio_sid` varchar(255) , `tsla` int , `application` varchar(45) , `recording_url` varchar(256) , `phone_number_location` varchar(100) , `nvm_skill_no` int , `nvm_skill_bucket` varchar(50) , `incontact_skill_no` int , `inbound` int , `outbound` int , `delivered` int , `answered` int , `handled` int , `call_result` varchar(10) , `call_center_call` 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/dwh_fact_call_genesys/2025-04-23/1745395198'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_call_genesys`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_call_genesys"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}