Schema Info
Schema Name: sfdl_prod_rds.sparephone_sparephone_inbound_phone_calls
- created: 2018-05-22 15:36:53
- disabled: False
- format: raw
- id: 449
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_rds", "table": "sparephone_sparephone_inbound_phone_calls" } - type: rds
Schema Versions: 3
-
Version 54455
- created: 2018-12-04 00:22:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparephone_sparephone_inbound_phone_calls`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparephone_sparephone_inbound_phone_calls`\n(\n `session_id` int , `to_number` varchar(40) , `from_number` varchar(40) , `transferred_to` varchar(40) , `call_state` varchar(45) , `start_time` timestamp , `end_time` timestamp , `twilio_sid` varchar(255) , `visit_id` varchar(32) , `site_id` int , `traffic_source_id` varchar(255) , `tsla` int , `transfered_to` varchar(45) , `transfered_call_id` varchar(45) , `call_classification` varchar(45) , `classification_reason` varchar(150) , `agent_answer_start_time` timestamp , `agent_answer_end_time` timestamp , `agent_user_id` int , `application` varchar(45) , `sales` smallint , `unqualified_reason_id` int , `disposition_reason_id` int , `recording_url` varchar(256) \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '~')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparephone-prod/raw/sparephone_inbound_phone_calls/2018-12-04/1543904556'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_rds.sparephone_sparephone_inbound_phone_calls" ] - hive_path: s3://sfdl-rds-sparephone-prod/raw/sparephone_inbound_phone_calls/2018-12-04/1543904556
- id: 54455
- processed: 1
- raw_data:
{ "agent_answer_end_time": 17, "agent_answer_start_time": 16, "agent_user_id": 18, "application": 19, "call_classification": 14, "call_state": 4, "classification_reason": 15, "disposition_reason_id": 22, "end_time": 6, "from_number": 2, "recording_url": 23, "sales": 20, "session_id": 0, "site_id": 9, "start_time": 5, "to_number": 1, "traffic_source_id": 10, "transfered_call_id": 13, "transfered_to": 12, "transferred_to": 3, "tsla": 11, "twilio_sid": 7, "unqualified_reason_id": 21, "visit_id": 8 } - schema_attributes:
{ "agent_answer_end_time": "timestamp", "agent_answer_start_time": "timestamp", "agent_user_id": "int", "application": "varchar(45)", "call_classification": "varchar(45)", "call_state": "varchar(45)", "classification_reason": "varchar(150)", "disposition_reason_id": "int", "end_time": "timestamp", "from_number": "varchar(40)", "recording_url": "varchar(256)", "sales": "smallint", "session_id": "int", "site_id": "int", "start_time": "timestamp", "to_number": "varchar(40)", "traffic_source_id": "varchar(255)", "transfered_call_id": "varchar(45)", "transfered_to": "varchar(45)", "transferred_to": "varchar(40)", "tsla": "int", "twilio_sid": "varchar(255)", "unqualified_reason_id": "int", "visit_id": "varchar(32)" } - schema_name_id: 449
- schema_scan_id: 21439108
- updated: 2018-12-04 00:23:20
-
Version 54351
- created: 2018-12-03 00:18:41
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparephone_sparephone_inbound_phone_calls`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparephone_sparephone_inbound_phone_calls`\n(\n `session_id` int , `to_number` varchar(40) , `from_number` varchar(40) , `transferred_to` varchar(40) , `call_state` varchar(45) , `start_time` timestamp , `end_time` timestamp , `twilio_sid` varchar(255) , `visit_id` varchar(32) , `site_id` int , `traffic_source_id` varchar(255) , `tsla` int , `transfered_to` varchar(45) , `transfered_call_id` varchar(45) , `call_classification` varchar(45) , `classification_reason` varchar(150) , `agent_answer_start_time` timestamp , `agent_answer_end_time` timestamp , `agent_user_id` int , `application` varchar(45) , `sales` smallint , `unqualified_reason_id` int , `disposition_reason_id` int , `recording_url` varchar(256) \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '~')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparephone-prod/raw/sparephone_inbound_phone_calls/2018-12-03/1543817913'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_rds.sparephone_sparephone_inbound_phone_calls" ] - hive_path: s3://sfdl-rds-sparephone-prod/raw/sparephone_inbound_phone_calls/2018-12-03/1543817913
- id: 54351
- processed: 1
- raw_data:
{ "agent_answer_end_time": 17, "agent_answer_start_time": 16, "agent_user_id": 18, "application": 19, "call_classification": 14, "call_state": 4, "classification_reason": 15, "disposition_reason_id": 22, "end_time": 6, "from_number": 2, "recording_url": 23, "sales": 20, "session_id": 0, "site_id": 9, "start_time": 5, "to_number": 1, "traffic_source_id": 10, "transfered_call_id": 13, "transfered_to": 12, "transferred_to": 3, "tsla": 11, "twilio_sid": 7, "unqualified_reason_id": 21, "visit_id": 8 } - schema_attributes:
{ "agent_answer_end_time": "timestamp", "agent_answer_start_time": "timestamp", "agent_user_id": "int", "application": "varchar(45)", "call_classification": "varchar(45)", "call_state": "varchar(45)", "classification_reason": "varchar(150)", "disposition_reason_id": "int", "end_time": "timestamp", "from_number": "varchar(40)", "recording_url": "varchar(256)", "sales": "smallint", "session_id": "int", "site_id": "int", "start_time": "timestamp", "to_number": "varchar(40)", "traffic_source_id": "varchar(255)", "transfered_call_id": "varchar(45)", "transfered_to": "varchar(45)", "transferred_to": "varchar(40)", "tsla": "int", "twilio_sid": "varchar(255)", "unqualified_reason_id": "int", "visit_id": "varchar(32)" } - schema_name_id: 449
- schema_scan_id: 21411373
- updated: 2018-12-03 00:18:51
-
Version 54229
- created: 2018-12-02 00:19:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparephone_sparephone_inbound_phone_calls`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparephone_sparephone_inbound_phone_calls`\n(\n `session_id` int , `to_number` varchar(40) , `from_number` varchar(40) , `transferred_to` varchar(40) , `call_state` varchar(45) , `start_time` timestamp , `end_time` timestamp , `twilio_sid` varchar(255) , `visit_id` varchar(32) , `site_id` int , `traffic_source_id` varchar(255) , `tsla` int , `transfered_to` varchar(45) , `transfered_call_id` varchar(45) , `call_classification` varchar(45) , `classification_reason` varchar(150) , `agent_answer_start_time` timestamp , `agent_answer_end_time` timestamp , `agent_user_id` int , `application` varchar(45) , `sales` smallint , `unqualified_reason_id` int , `disposition_reason_id` int , `recording_url` varchar(256) \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '~')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparephone-prod/raw/sparephone_inbound_phone_calls/2018-12-02/1543731552'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_rds.sparephone_sparephone_inbound_phone_calls" ] - hive_path: s3://sfdl-rds-sparephone-prod/raw/sparephone_inbound_phone_calls/2018-12-02/1543731552
- id: 54229
- processed: 1
- raw_data:
{ "agent_answer_end_time": 17, "agent_answer_start_time": 16, "agent_user_id": 18, "application": 19, "call_classification": 14, "call_state": 4, "classification_reason": 15, "disposition_reason_id": 22, "end_time": 6, "from_number": 2, "recording_url": 23, "sales": 20, "session_id": 0, "site_id": 9, "start_time": 5, "to_number": 1, "traffic_source_id": 10, "transfered_call_id": 13, "transfered_to": 12, "transferred_to": 3, "tsla": 11, "twilio_sid": 7, "unqualified_reason_id": 21, "visit_id": 8 } - schema_attributes:
{ "agent_answer_end_time": "timestamp", "agent_answer_start_time": "timestamp", "agent_user_id": "int", "application": "varchar(45)", "call_classification": "varchar(45)", "call_state": "varchar(45)", "classification_reason": "varchar(150)", "disposition_reason_id": "int", "end_time": "timestamp", "from_number": "varchar(40)", "recording_url": "varchar(256)", "sales": "smallint", "session_id": "int", "site_id": "int", "start_time": "timestamp", "to_number": "varchar(40)", "traffic_source_id": "varchar(255)", "transfered_call_id": "varchar(45)", "transfered_to": "varchar(45)", "transferred_to": "varchar(40)", "tsla": "int", "twilio_sid": "varchar(255)", "unqualified_reason_id": "int", "visit_id": "varchar(32)" } - schema_name_id: 449
- schema_scan_id: 21385117
- updated: 2018-12-02 00:19:27
Schema Scans: 3
Last at 2018-12-04 00:22:50
-
Scan 21439108
- duration: 0:00:49.942802
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 21439108
- payload:
{ "datatype_dict": { "agent_answer_end_time": "timestamp", "agent_answer_start_time": "timestamp", "agent_user_id": "int", "application": "varchar(45)", "call_classification": "varchar(45)", "call_state": "varchar(45)", "classification_reason": "varchar(150)", "disposition_reason_id": "int", "end_time": "timestamp", "from_number": "varchar(40)", "recording_url": "varchar(256)", "sales": "smallint", "session_id": "int", "site_id": "int", "start_time": "timestamp", "to_number": "varchar(40)", "traffic_source_id": "varchar(255)", "transfered_call_id": "varchar(45)", "transfered_to": "varchar(45)", "transferred_to": "varchar(40)", "tsla": "int", "twilio_sid": "varchar(255)", "unqualified_reason_id": "int", "visit_id": "varchar(32)" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "~" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-rds-sparephone-prod", "hive_path": "s3://sfdl-rds-sparephone-prod/raw/sparephone_inbound_phone_calls/2018-12-04/1543904556", "key": "raw/sparephone_inbound_phone_calls/2018-12-04/1543904556/split.sparephone.inbound_phone_calls.000000.dat.gz" }, "schema": { "name": "sfdl_prod_rds.sparephone_sparephone_inbound_phone_calls", "type": "rds" } } - running: False
- schema_name_id: 449
- start_time: 2018-12-04 00:22:50
- success: True
- trace_id: 4356739353235521227
-
Scan 21411373
- duration: 0:00:16.497993
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 21411373
- payload:
{ "datatype_dict": { "agent_answer_end_time": "timestamp", "agent_answer_start_time": "timestamp", "agent_user_id": "int", "application": "varchar(45)", "call_classification": "varchar(45)", "call_state": "varchar(45)", "classification_reason": "varchar(150)", "disposition_reason_id": "int", "end_time": "timestamp", "from_number": "varchar(40)", "recording_url": "varchar(256)", "sales": "smallint", "session_id": "int", "site_id": "int", "start_time": "timestamp", "to_number": "varchar(40)", "traffic_source_id": "varchar(255)", "transfered_call_id": "varchar(45)", "transfered_to": "varchar(45)", "transferred_to": "varchar(40)", "tsla": "int", "twilio_sid": "varchar(255)", "unqualified_reason_id": "int", "visit_id": "varchar(32)" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "~" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-rds-sparephone-prod", "hive_path": "s3://sfdl-rds-sparephone-prod/raw/sparephone_inbound_phone_calls/2018-12-03/1543817913", "key": "raw/sparephone_inbound_phone_calls/2018-12-03/1543817913/split.sparephone.inbound_phone_calls.000000.dat.gz" }, "schema": { "name": "sfdl_prod_rds.sparephone_sparephone_inbound_phone_calls", "type": "rds" } } - running: False
- schema_name_id: 449
- start_time: 2018-12-03 00:18:38
- success: True
- trace_id: 1361932719606084650
-
Scan 21385117
- duration: 0:00:14.572405
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 21385117
- payload:
{ "datatype_dict": { "agent_answer_end_time": "timestamp", "agent_answer_start_time": "timestamp", "agent_user_id": "int", "application": "varchar(45)", "call_classification": "varchar(45)", "call_state": "varchar(45)", "classification_reason": "varchar(150)", "disposition_reason_id": "int", "end_time": "timestamp", "from_number": "varchar(40)", "recording_url": "varchar(256)", "sales": "smallint", "session_id": "int", "site_id": "int", "start_time": "timestamp", "to_number": "varchar(40)", "traffic_source_id": "varchar(255)", "transfered_call_id": "varchar(45)", "transfered_to": "varchar(45)", "transferred_to": "varchar(40)", "tsla": "int", "twilio_sid": "varchar(255)", "unqualified_reason_id": "int", "visit_id": "varchar(32)" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "~" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-rds-sparephone-prod", "hive_path": "s3://sfdl-rds-sparephone-prod/raw/sparephone_inbound_phone_calls/2018-12-02/1543731552", "key": "raw/sparephone_inbound_phone_calls/2018-12-02/1543731552/split.sparephone.inbound_phone_calls.000000.dat.gz" }, "schema": { "name": "sfdl_prod_rds.sparephone_sparephone_inbound_phone_calls", "type": "rds" } } - running: False
- schema_name_id: 449
- start_time: 2018-12-02 00:19:15
- success: True
- trace_id: 7310744830262399517
- attributes:
{ "agent_answer_end_time": "timestamp", "agent_answer_start_time": "timestamp", "agent_user_id": "int", "application": "varchar(45)", "call_classification": "varchar(45)", "call_state": "varchar(45)", "classification_reason": "varchar(150)", "disposition_reason_id": "int", "end_time": "timestamp", "from_number": "varchar(40)", "recording_url": "varchar(256)", "sales": "smallint", "session_id": "int", "site_id": "int", "start_time": "timestamp", "to_number": "varchar(40)", "traffic_source_id": "varchar(255)", "transfered_call_id": "varchar(45)", "transfered_to": "varchar(45)", "transferred_to": "varchar(40)", "tsla": "int", "twilio_sid": "varchar(255)", "unqualified_reason_id": "int", "visit_id": "varchar(32)" } - created: 2018-12-04 00:22:51
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparephone_sparephone_inbound_phone_calls`\n(\n `session_id` int , `to_number` varchar(40) , `from_number` varchar(40) , `transferred_to` varchar(40) , `call_state` varchar(45) , `start_time` timestamp , `end_time` timestamp , `twilio_sid` varchar(255) , `visit_id` varchar(32) , `site_id` int , `traffic_source_id` varchar(255) , `tsla` int , `transfered_to` varchar(45) , `transfered_call_id` varchar(45) , `call_classification` varchar(45) , `classification_reason` varchar(150) , `agent_answer_start_time` timestamp , `agent_answer_end_time` timestamp , `agent_user_id` int , `application` varchar(45) , `sales` smallint , `unqualified_reason_id` int , `disposition_reason_id` int , `recording_url` varchar(256) \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '~')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparephone-prod/raw/sparephone_inbound_phone_calls/2018-12-04/1543904556'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparephone_sparephone_inbound_phone_calls`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparephone_sparephone_inbound_phone_calls" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2018-05-22 15:36:53",
"disabled": false,
"format": "raw",
"id": 449,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_rds",
"table": "sparephone_sparephone_inbound_phone_calls"
},
"type": "rds"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"agent_answer_end_time": "timestamp",
"agent_answer_start_time": "timestamp",
"agent_user_id": "int",
"application": "varchar(45)",
"call_classification": "varchar(45)",
"call_state": "varchar(45)",
"classification_reason": "varchar(150)",
"disposition_reason_id": "int",
"end_time": "timestamp",
"from_number": "varchar(40)",
"recording_url": "varchar(256)",
"sales": "smallint",
"session_id": "int",
"site_id": "int",
"start_time": "timestamp",
"to_number": "varchar(40)",
"traffic_source_id": "varchar(255)",
"transfered_call_id": "varchar(45)",
"transfered_to": "varchar(45)",
"transferred_to": "varchar(40)",
"tsla": "int",
"twilio_sid": "varchar(255)",
"unqualified_reason_id": "int",
"visit_id": "varchar(32)"
},
"created": "2018-12-04 00:22:51",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparephone_sparephone_inbound_phone_calls`\n(\n `session_id` int , `to_number` varchar(40) , `from_number` varchar(40) , `transferred_to` varchar(40) , `call_state` varchar(45) , `start_time` timestamp , `end_time` timestamp , `twilio_sid` varchar(255) , `visit_id` varchar(32) , `site_id` int , `traffic_source_id` varchar(255) , `tsla` int , `transfered_to` varchar(45) , `transfered_call_id` varchar(45) , `call_classification` varchar(45) , `classification_reason` varchar(150) , `agent_answer_start_time` timestamp , `agent_answer_end_time` timestamp , `agent_user_id` int , `application` varchar(45) , `sales` smallint , `unqualified_reason_id` int , `disposition_reason_id` int , `recording_url` varchar(256) \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '~')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-rds-sparephone-prod/raw/sparephone_inbound_phone_calls/2018-12-04/1543904556'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparephone_sparephone_inbound_phone_calls`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparephone_sparephone_inbound_phone_calls"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}