Schema Info
Schema Name: sfdl_dev_redshift.analytics_dwh_fact_call_genesys
- created: 2021-05-28 12:26:03
- disabled: False
- format: raw
- id: 1562
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_dev_redshift", "table": "analytics_dwh_fact_call_genesys" } - type: redshift
Schema Versions: 3
-
Version 4708847
- created: 2024-08-14 13:43:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_dwh_fact_call_genesys`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/separated_dt/dwh_fact_call_genesys/2024-08-14/1723660985'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_dwh_fact_call_genesys" ] - hive_path: s3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-08-14/1723660985
- id: 4708847
- 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: 1562
- schema_scan_id: 6565838
- updated: 2024-08-14 13:44:01
-
Version 4705895
- created: 2024-05-14 06:07:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_dwh_fact_call_genesys`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/separated_dt/dwh_fact_call_genesys/2024-05-14/1715684669'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_dwh_fact_call_genesys" ] - hive_path: s3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-05-14/1715684669
- id: 4705895
- 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: 1562
- schema_scan_id: 6490581
- updated: 2024-05-14 06:08:12
-
Version 4705779
- created: 2024-05-13 15:48:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_dwh_fact_call_genesys`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/separated_dt/dwh_fact_call_genesys/2024-05-13/1715633247'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_dwh_fact_call_genesys" ] - hive_path: s3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-05-13/1715633247
- id: 4705779
- 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: 1562
- schema_scan_id: 6490230
- updated: 2024-05-13 15:48:34
Schema Scans: 3
Last at 2024-08-14 13:43:41
-
Scan 6565838
- duration: 0:00:25.977194
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 186, "partitions_applied": false, "success": true } - id: 6565838
- 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-dev", "key": "meta/dwh_fact_call_genesys/2024-08-14/1723660985/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-08-14/1723660985/dt=2024-08-13", "name": "dt", "type": "string", "value": "2024-08-13" }, "s3": { "bucket": "sfdl-redshift-analytics-dev", "hive_path": "s3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-08-14/1723660985", "key": "separated_dt/dwh_fact_call_genesys/2024-08-14/1723660985/dt=2024-08-13/0003_part_00.gz" }, "schema": { "name": "sfdl_dev_redshift.analytics_dwh_fact_call_genesys", "type": "redshift" }, "trace_context": { "parent_id": 16928912851391731323, "service_name": "redshift_unloads", "span_id": 7120027991147502805, "trace_id": 12557216006385932792 } } - running: False
- schema_name_id: 1562
- start_time: 2024-08-14 13:43:41
- success: True
- trace_id: 12557216006385932792
-
Scan 6490581
- duration: 0:00:25.004400
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 276, "partitions_applied": false, "success": true } - id: 6490581
- 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-dev", "key": "meta/dwh_fact_call_genesys/2024-05-14/1715684669/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-05-14/1715684669/dt=2024-05-13", "name": "dt", "type": "string", "value": "2024-05-13" }, "s3": { "bucket": "sfdl-redshift-analytics-dev", "hive_path": "s3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-05-14/1715684669", "key": "separated_dt/dwh_fact_call_genesys/2024-05-14/1715684669/dt=2024-05-13/0006_part_00.gz" }, "schema": { "name": "sfdl_dev_redshift.analytics_dwh_fact_call_genesys", "type": "redshift" }, "trace_context": { "parent_id": 17087423196558862641, "service_name": "redshift_unloads", "span_id": 7343971134875911109, "trace_id": 18285554397012904402 } } - running: False
- schema_name_id: 1562
- start_time: 2024-05-14 06:07:54
- success: True
- trace_id: 18285554397012904402
-
Scan 6490230
- duration: 0:00:24.729025
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 275, "partitions_applied": false, "success": true } - id: 6490230
- 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-dev", "key": "meta/dwh_fact_call_genesys/2024-05-13/1715633247/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-05-13/1715633247/dt=2024-05-12", "name": "dt", "type": "string", "value": "2024-05-12" }, "s3": { "bucket": "sfdl-redshift-analytics-dev", "hive_path": "s3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-05-13/1715633247", "key": "separated_dt/dwh_fact_call_genesys/2024-05-13/1715633247/dt=2024-05-12/0003_part_00.gz" }, "schema": { "name": "sfdl_dev_redshift.analytics_dwh_fact_call_genesys", "type": "redshift" }, "trace_context": { "parent_id": 10001221452348136946, "service_name": "redshift_unloads", "span_id": 12065920169396130466, "trace_id": 1924199719707016619 } } - running: False
- schema_name_id: 1562
- start_time: 2024-05-13 15:48:16
- success: True
- trace_id: 1924199719707016619
- count: 6
- ddl:
[ "ALTER TABLE\n `sfdl_dev_redshift.analytics_dwh_fact_call_genesys`\nADD\n\n\n PARTITION (dt='2024-05-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-05-13/1715633247/dt=2024-05-11/'\n PARTITION (dt='2024-05-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-05-13/1715633247/dt=2024-05-12/'\n PARTITION (dt='2024-05-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-05-14/1715684669/dt=2024-05-13/'\n PARTITION (dt='2024-08-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-08-14/1723660985/dt=2024-08-11/'\n PARTITION (dt='2024-08-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-08-14/1723660985/dt=2024-08-12/'\n PARTITION (dt='2024-08-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-08-14/1723660985/dt=2024-08-13/'\n;" ] - name: dt
- state:
[ { "info": { "id": 253963, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-05-13/1715633247/dt=2024-05-11/", "name": "dt", "value": "2024-05-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-13 15:48:40", "last_data": "2024-05-13 15:48:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 253962, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-05-13/1715633247/dt=2024-05-12/", "name": "dt", "value": "2024-05-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-13 15:48:18", "last_data": "2024-05-13 15:48:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254013, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-05-14/1715684669/dt=2024-05-13/", "name": "dt", "value": "2024-05-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 06:07:56", "last_data": "2024-05-14 06:07:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259713, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-08-14/1723660985/dt=2024-08-11/", "name": "dt", "value": "2024-08-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 13:44:06", "last_data": "2024-08-14 13:44:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259714, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-08-14/1723660985/dt=2024-08-12/", "name": "dt", "value": "2024-08-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 13:44:06", "last_data": "2024-08-14 13:44:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259712, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-08-14/1723660985/dt=2024-08-13/", "name": "dt", "value": "2024-08-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 13:43:42", "last_data": "2024-08-14 13:43:42" }, "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: 2024-08-14 13:43:42
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/separated_dt/dwh_fact_call_genesys/2024-08-14/1723660985'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_dwh_fact_call_genesys`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_dwh_fact_call_genesys" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2021-05-28 12:26:03",
"disabled": false,
"format": "raw",
"id": 1562,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_dev_redshift",
"table": "analytics_dwh_fact_call_genesys"
},
"type": "redshift"
},
"partition": {
"count": 6,
"ddl": [
"ALTER TABLE\n `sfdl_dev_redshift.analytics_dwh_fact_call_genesys`\nADD\n\n\n PARTITION (dt='2024-05-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-05-13/1715633247/dt=2024-05-11/'\n PARTITION (dt='2024-05-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-05-13/1715633247/dt=2024-05-12/'\n PARTITION (dt='2024-05-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-05-14/1715684669/dt=2024-05-13/'\n PARTITION (dt='2024-08-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-08-14/1723660985/dt=2024-08-11/'\n PARTITION (dt='2024-08-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-08-14/1723660985/dt=2024-08-12/'\n PARTITION (dt='2024-08-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-08-14/1723660985/dt=2024-08-13/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 253963,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-05-13/1715633247/dt=2024-05-11/",
"name": "dt",
"value": "2024-05-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-13 15:48:40",
"last_data": "2024-05-13 15:48:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 253962,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-05-13/1715633247/dt=2024-05-12/",
"name": "dt",
"value": "2024-05-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-13 15:48:18",
"last_data": "2024-05-13 15:48:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254013,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-05-14/1715684669/dt=2024-05-13/",
"name": "dt",
"value": "2024-05-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 06:07:56",
"last_data": "2024-05-14 06:07:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259713,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-08-14/1723660985/dt=2024-08-11/",
"name": "dt",
"value": "2024-08-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 13:44:06",
"last_data": "2024-08-14 13:44:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259714,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-08-14/1723660985/dt=2024-08-12/",
"name": "dt",
"value": "2024-08-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 13:44:06",
"last_data": "2024-08-14 13:44:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259712,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/dwh_fact_call_genesys/2024-08-14/1723660985/dt=2024-08-13/",
"name": "dt",
"value": "2024-08-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 13:43:42",
"last_data": "2024-08-14 13:43:42"
},
"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": "2024-08-14 13:43:42",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/separated_dt/dwh_fact_call_genesys/2024-08-14/1723660985'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_dwh_fact_call_genesys`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_dwh_fact_call_genesys"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}