Schema Info
Schema Name: sfdl_dev_manual.genesys_genesys_conversations
- created: 2019-08-06 10:21:18
- disabled: False
- format: raw
- id: 1270
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_dev_manual", "table": "genesys_genesys_conversations" } - type: manual
Schema Versions: 2
-
Version 4671474
- created: 2019-08-09 15:35:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`", "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_genesys_conversations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_manual.genesys_genesys_conversations`\n(\n`conversationStart`STRING,`mediaStatsMinConversationRFactor`STRING,`mediaStatsMinConversationMos`STRING,`divisionIds`array,`participants`array - hive_path: s3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations
- id: 4671474
- processed: 1
- raw_data:
{ "_origin": "2019-08-09T15:35:07Z|separated_dt/genesys_conversations/dt=2019-08-08/44b546bb-82b9-44b6-a134-b7ba9e03318d.json.gz|airflow_genesys_dev", "conversationEnd": "2019-08-08T20:16:38.164Z", "conversationId": "a8a4e14e-c1d0-4823-890b-754ef9a406c1", "conversationStart": "2019-08-08T13:37:09.579Z", "divisionIds": [ "b4a5d15d-7294-44dc-a910-e370ad9ec9ab" ], "evaluations": [ { "contextId": "a3edb833-b3f9-4b6c-9396-cc093036cd4e", "evaluationId": "2efa8c14-d665-45bc-ba0a-b1e4011d99dc", "evaluatorId": "d2c412b2-0fdd-421e-8fac-bb604584fcbe", "eventTime": "2019-08-08T20:54:41.202Z", "formId": "ee460aa0-3182-43ec-9803-1b6ff535f9fc", "formName": "Front Door Quality Form - 7/31/19", "oTotalCriticalScore": 0, "oTotalScore": 93, "queueId": "f790132a-cb6f-4006-b7d3-05d5229db142", "userId": "6c5ff27a-fe3a-45ed-919a-369b746718f3" } ], "mediaStatsMinConversationMos": 4.392085552215576, "mediaStatsMinConversationRFactor": 78.79325103759766, "originatingDirection": "inbound", "participants": [ { "participantId": "f70c92be-b9fa-46bf-9bab-98987256bcc4", "participantName": "Buchanan Dam TX", "purpose": "ivr", "sessions": [ { "ani": "tel:+15122634114", "direction": "inbound", "dnis": "tel:+15128863822", "edgeId": "4b37b1ff-4c07-48ef-9598-cc9f209479ab", "flow": { "endingLanguage": "en-us", "entryReason": "tel:+15128863822", "entryType": "dnis", "exitReason": "TRANSFER", "flowId": "ec5ccfb9-c141-4e07-b9fa-eca8582c0d00", "flowName": "Test - Front Door Call Flow", "flowType": "INBOUNDCALL", "flowVersion": "14.0", "issuedCallback": false, "startingLanguage": "en-us", "transferTargetAddress": "f790132a-cb6f-4006-b7d3-05d5229db142", "transferTargetName": "New Front Door", "transferType": "ACD" }, "mediaEndpointStats": [ { "codecs": [ "audio/PCMU" ], "discardedPackets": 7, "maxLatencyMs": 30, "minMos": 4.863378047943115, "minRFactor": 91.63826751708984, "receivedPackets": 49 } ], "mediaType": "voice", "metrics": [ { "emitDate": "2019-08-08T13:37:11.193Z", "name": "tIvr", "value": 999 } ], "peerId": "4f3bece2-4166-4fb7-b556-a2ce15e24121", "recording": true, "remoteNameDisplayable": "Buchanan Dam TX", "segments": [ { "conference": false, "disconnectType": "error", "errorCode": "error.ininedgecontrol.connection.media", "queueId": "f790132a-cb6f-4006-b7d3-05d5229db142", "segmentEnd": "2019-08-08T13:37:11.193Z", "segmentStart": "2019-08-08T13:37:10.194Z", "segmentType": "ivr", "sipResponseCodes": [ 480 ] } ], "sessionDnis": "tel:+15128863822", "sessionId": "6f68db75-a2c2-4d45-afde-38637333782e" } ], "userId": "7f832d4a-88d5-40c7-859e-cb8e21e5c8a4" } ] } - schema_attributes:
{ "_origin": "string", "conversationEnd": "string", "conversationId": "string", "conversationStart": "string", "divisionIds": [ "string" ], "evaluations": [ { "contextId": "string", "evaluationId": "string", "evaluatorId": "string", "eventTime": "string", "formId": "string", "formName": "string", "oTotalCriticalScore": "string", "oTotalScore": "string", "queueId": "string", "userId": "string" } ], "mediaStatsMinConversationMos": "string", "mediaStatsMinConversationRFactor": "string", "originatingDirection": "string", "participants": [ { "participantId": "string", "participantName": "string", "purpose": "string", "sessions": [ { "ani": "string", "direction": "string", "dnis": "string", "edgeId": "string", "flow.endingLanguage": "string", "flow.entryReason": "string", "flow.entryType": "string", "flow.exitReason": "string", "flow.flowId": "string", "flow.flowName": "string", "flow.flowType": "string", "flow.flowVersion": "string", "flow.issuedCallback": "string", "flow.startingLanguage": "string", "flow.transferTargetAddress": "string", "flow.transferTargetName": "string", "flow.transferType": "string", "mediaEndpointStats": [ { "codecs": [ "string" ], "discardedPackets": "string", "maxLatencyMs": "string", "minMos": "string", "minRFactor": "string", "receivedPackets": "string" } ], "mediaType": "string", "metrics": [ { "emitDate": "string", "name": "string", "value": "string" } ], "peerId": "string", "recording": "string", "remoteNameDisplayable": "string", "segments": [ { "conference": "string", "disconnectType": "string", "errorCode": "string", "queueId": "string", "segmentEnd": "string", "segmentStart": "string", "segmentType": "string", "sipResponseCodes": [ "int" ] } ], "sessionDnis": "string", "sessionId": "string" } ], "userId": "string" } ] } - schema_name_id: 1270
- schema_scan_id: 5130809
- updated: 2019-08-09 15:35:45
-
Version 4671449
- created: 2019-08-06 10:21:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`", "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_genesys_conversations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_manual.genesys_genesys_conversations`\n(\n`mediaStatsMinConversationRFactor`STRING,`conversationEnd`STRING,`mediaStatsMinConversationMos`STRING,`divisionIds`array,`conversationId`STRING,`participants`array - hive_path: s3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations
- id: 4671449
- processed: 1
- raw_data:
{ "_origin": "2019-08-06T10:20:51Z|separated_dt/genesys_conversations/dt=2019-08-05/d2dfe0f4-cd45-496a-81dd-a64135598fcb.json.gz|airflow_genesys_dev", "conversationEnd": "2019-08-04T22:54:01.981Z", "conversationId": "9e3ab8c9-1d71-4b6b-852c-6eb52b1f233f", "conversationStart": "2019-08-04T22:53:44.814Z", "divisionIds": [ "b4a5d15d-7294-44dc-a910-e370ad9ec9ab" ], "mediaStatsMinConversationMos": 4.394038677215576, "mediaStatsMinConversationRFactor": 91.61065673828125, "originatingDirection": "inbound", "participants": [ { "participantId": "fe7c402b-78b4-41c0-9bbe-ed428f614166", "participantName": "Washington DC", "purpose": "external", "sessions": [ { "ani": "tel:+12029817852", "direction": "inbound", "dnis": "tel:+19198234523", "edgeId": "4b37b1ff-4c07-48ef-9598-cc9f209479ab", "mediaEndpointStats": [ {}, { "codecs": [ "audio/PCMU" ], "maxLatencyMs": 30, "minMos": 4.394038677215576, "minRFactor": 92.43730926513672, "receivedPackets": 784 }, { "codecs": [ "audio/opus" ], "maxLatencyMs": 29, "minMos": 4.862704753875732, "minRFactor": 91.61065673828125, "receivedPackets": 183 } ], "mediaType": "voice", "metrics": [ { "emitDate": "2019-08-04T22:53:58.329Z", "name": "nConnected", "value": 1 } ], "recording": true, "remoteNameDisplayable": "Washington DC", "segments": [ { "conference": false, "segmentEnd": "2019-08-04T22:53:58.329Z", "segmentStart": "2019-08-04T22:53:44.824Z", "segmentType": "system" }, { "conference": false, "disconnectType": "endpoint", "segmentEnd": "2019-08-04T22:54:01.978Z", "segmentStart": "2019-08-04T22:53:58.329Z", "segmentType": "interact" } ], "sessionDnis": "tel:+19198234523", "sessionId": "52503844-b1ea-4e49-a177-a2447587de07" } ] }, { "participantId": "7ec280fa-706d-4110-be1d-40855747b715", "purpose": "user", "sessions": [ { "ani": "tel:+12029817852", "direction": "inbound", "dnis": "tel:+19198234523", "edgeId": "4b37b1ff-4c07-48ef-9598-cc9f209479ab", "mediaEndpointStats": [ {}, {} ], "mediaType": "voice", "metrics": [ { "emitDate": "2019-08-04T22:53:57.460Z", "name": "tAlert", "value": 12008 }, { "emitDate": "2019-08-04T22:53:57.460Z", "name": "tNotResponding", "value": 12008 } ], "peerId": "52503844-b1ea-4e49-a177-a2447587de07", "segments": [ { "conference": false, "disconnectType": "noAnswerTransfer", "segmentEnd": "2019-08-04T22:53:57.460Z", "segmentStart": "2019-08-04T22:53:45.452Z", "segmentType": "alert" } ], "sessionDnis": "sip:5d10e67ccabfc51844d8ad45+storable.orgspan.com;tgrp=1ac5cd40-37eb-4113-bac5-54126db1d413;trunk-context=storable@localhost", "sessionId": "7e96c91b-7c41-42b1-8ad4-e9e374666e92" } ], "userId": "e9d1ff51-e80b-43c9-b3e9-12777094526b" }, { "participantId": "dd777e12-384e-4ce5-bd82-75635b854ac0", "purpose": "voicemail", "sessions": [ { "ani": "tel:+12029817852", "direction": "inbound", "dnis": "tel:+19198234523", "edgeId": "588c826d-aa06-4354-a55e-1266a5073e19", "mediaEndpointStats": [ { "codecs": [ "audio/opus" ], "maxLatencyMs": 30, "minMos": 4.87713623046875, "minRFactor": 92.21543884277344, "receivedPackets": 183 } ], "mediaType": "voice", "metrics": [ { "emitDate": "2019-08-04T22:54:01.981Z", "name": "tVoicemail", "value": 3666 } ], "peerId": "52503844-b1ea-4e49-a177-a2447587de07", "segments": [ { "conference": false, "segmentEnd": "2019-08-04T22:53:58.315Z", "segmentStart": "2019-08-04T22:53:57.738Z", "segmentType": "system" }, { "conference": false, "disconnectType": "peer", "segmentEnd": "2019-08-04T22:54:01.981Z", "segmentStart": "2019-08-04T22:53:58.315Z", "segmentType": "interact" } ], "sessionDnis": "sip:[email protected];language=en-US;user=voicemail", "sessionId": "4bf8aa1e-437f-4906-95c4-acf40818b794" } ], "userId": "e9d1ff51-e80b-43c9-b3e9-12777094526b" } ] } - schema_attributes:
{ "_origin": "string", "conversationEnd": "string", "conversationId": "string", "conversationStart": "string", "divisionIds": [ "string" ], "mediaStatsMinConversationMos": "string", "mediaStatsMinConversationRFactor": "string", "originatingDirection": "string", "participants": [ { "participantId": "string", "participantName": "string", "purpose": "string", "sessions": [ { "ani": "string", "direction": "string", "dnis": "string", "edgeId": "string", "mediaEndpointStats": [ { "codecs": [ "string" ], "maxLatencyMs": "string", "minMos": "string", "minRFactor": "string", "receivedPackets": "string" } ], "mediaType": "string", "metrics": [ { "emitDate": "string", "name": "string", "value": "string" } ], "peerId": "string", "segments": [ { "conference": "string", "disconnectType": "string", "segmentEnd": "string", "segmentStart": "string", "segmentType": "string" } ], "sessionDnis": "string", "sessionId": "string" } ], "userId": "string" } ] } - schema_name_id: 1270
- schema_scan_id: 5125709
- updated: 2019-08-06 10:21:32
Schema Scans: 2
Last at 2019-08-09 15:35:31
-
Scan 5130809
- duration: 0:00:21.351046
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 6, "partitions_applied": false, "success": true } - id: 5130809
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-08/", "name": "dt", "type": "string", "value": "2019-08-08" }, "s3": { "bucket": "sfdl-manual-genesys-dev", "hive_path": "s3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations", "key": "separated_dt/genesys_conversations/dt=2019-08-08/44b546bb-82b9-44b6-a134-b7ba9e03318d.json.gz" }, "schema": { "name": "sfdl_dev_manual.genesys_genesys_conversations", "type": "manual" } } - running: False
- schema_name_id: 1270
- start_time: 2019-08-09 15:35:31
- success: True
- trace_id: 8794687789572156170
-
Scan 5125709
- duration: 0:00:19.373095
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 3, "partitions_applied": false, "success": true } - id: 5125709
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-05/", "name": "dt", "type": "string", "value": "2019-08-05" }, "s3": { "bucket": "sfdl-manual-genesys-dev", "hive_path": "s3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations", "key": "separated_dt/genesys_conversations/dt=2019-08-05/d2dfe0f4-cd45-496a-81dd-a64135598fcb.json.gz" }, "schema": { "name": "sfdl_dev_manual.genesys_genesys_conversations", "type": "manual" } } - running: False
- schema_name_id: 1270
- start_time: 2019-08-06 10:21:18
- success: True
- trace_id: 11000616107207338319
- count: 5
- ddl:
[ "ALTER TABLE\n `sfdl_dev_manual.genesys_genesys_conversations`\nADD\n\n\n PARTITION (dt='2019-08-13') location 's3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-13/'\n PARTITION (dt='2019-08-14') location 's3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-14/'\n PARTITION (dt='2019-08-19') location 's3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-19/'\n PARTITION (dt='2019-08-20') location 's3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-20/'\n PARTITION (dt='2019-08-21') location 's3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-21/'\n;" ] - name: dt
- state:
[ { "info": { "id": 143815, "location": "s3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-13/", "name": "dt", "value": "2019-08-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-08-14 11:05:25", "last_data": "2019-08-14 11:05:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 143816, "location": "s3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-14/", "name": "dt", "value": "2019-08-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-08-14 11:05:28", "last_data": "2019-08-14 11:05:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 143983, "location": "s3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-19/", "name": "dt", "value": "2019-08-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-08-20 15:24:06", "last_data": "2019-08-20 15:24:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 143984, "location": "s3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-20/", "name": "dt", "value": "2019-08-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-08-20 15:24:10", "last_data": "2019-08-21 13:55:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 144026, "location": "s3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-21/", "name": "dt", "value": "2019-08-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-08-21 13:55:04", "last_data": "2019-08-21 13:55:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } } ] - type: string
- attributes:
{ "_origin": "string", "conversationEnd": "string", "conversationId": "string", "conversationStart": "string", "divisionIds": [ "string" ], "evaluations": [ { "contextId": "string", "evaluationId": "string", "evaluatorId": "string", "eventTime": "string", "formId": "string", "formName": "string", "oTotalCriticalScore": "string", "oTotalScore": "string", "queueId": "string", "userId": "string" } ], "mediaStatsMinConversationMos": "string", "mediaStatsMinConversationRFactor": "string", "originatingDirection": "string", "participants": [ { "participantId": "string", "participantName": "string", "purpose": "string", "sessions": [ { "ani": "string", "direction": "string", "dnis": "string", "edgeId": "string", "flow.endingLanguage": "string", "flow.entryReason": "string", "flow.entryType": "string", "flow.exitReason": "string", "flow.flowId": "string", "flow.flowName": "string", "flow.flowType": "string", "flow.flowVersion": "string", "flow.issuedCallback": "string", "flow.startingLanguage": "string", "flow.transferTargetAddress": "string", "flow.transferTargetName": "string", "flow.transferType": "string", "mediaEndpointStats": [ { "codecs": [ "string" ], "discardedPackets": "string", "maxLatencyMs": "string", "minMos": "string", "minRFactor": "string", "receivedPackets": "string" } ], "mediaType": "string", "metrics": [ { "emitDate": "string", "name": "string", "value": "string" } ], "peerId": "string", "recording": "string", "remoteNameDisplayable": "string", "segments": [ { "conference": "string", "disconnectType": "string", "errorCode": "string", "queueId": "string", "segmentEnd": "string", "segmentStart": "string", "segmentType": "string", "sipResponseCodes": [ "int" ] } ], "sessionDnis": "string", "sessionId": "string" } ], "userId": "string" } ] } - created: 2019-08-09 15:35:32
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_manual.genesys_genesys_conversations`\n(\n`conversationStart`STRING,`mediaStatsMinConversationRFactor`STRING,`mediaStatsMinConversationMos`STRING,`divisionIds`array,`participants`array
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2019-08-06 10:21:18",
"disabled": false,
"format": "raw",
"id": 1270,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_dev_manual",
"table": "genesys_genesys_conversations"
},
"type": "manual"
},
"partition": {
"count": 5,
"ddl": [
"ALTER TABLE\n `sfdl_dev_manual.genesys_genesys_conversations`\nADD\n\n\n PARTITION (dt='2019-08-13') location 's3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-13/'\n PARTITION (dt='2019-08-14') location 's3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-14/'\n PARTITION (dt='2019-08-19') location 's3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-19/'\n PARTITION (dt='2019-08-20') location 's3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-20/'\n PARTITION (dt='2019-08-21') location 's3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-21/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 143815,
"location": "s3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-13/",
"name": "dt",
"value": "2019-08-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-08-14 11:05:25",
"last_data": "2019-08-14 11:05:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 143816,
"location": "s3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-14/",
"name": "dt",
"value": "2019-08-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-08-14 11:05:28",
"last_data": "2019-08-14 11:05:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 143983,
"location": "s3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-19/",
"name": "dt",
"value": "2019-08-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-08-20 15:24:06",
"last_data": "2019-08-20 15:24:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 143984,
"location": "s3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-20/",
"name": "dt",
"value": "2019-08-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-08-20 15:24:10",
"last_data": "2019-08-21 13:55:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 144026,
"location": "s3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations/dt=2019-08-21/",
"name": "dt",
"value": "2019-08-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-08-21 13:55:04",
"last_data": "2019-08-21 13:55:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_origin": "string",
"conversationEnd": "string",
"conversationId": "string",
"conversationStart": "string",
"divisionIds": [
"string"
],
"evaluations": [
{
"contextId": "string",
"evaluationId": "string",
"evaluatorId": "string",
"eventTime": "string",
"formId": "string",
"formName": "string",
"oTotalCriticalScore": "string",
"oTotalScore": "string",
"queueId": "string",
"userId": "string"
}
],
"mediaStatsMinConversationMos": "string",
"mediaStatsMinConversationRFactor": "string",
"originatingDirection": "string",
"participants": [
{
"participantId": "string",
"participantName": "string",
"purpose": "string",
"sessions": [
{
"ani": "string",
"direction": "string",
"dnis": "string",
"edgeId": "string",
"flow.endingLanguage": "string",
"flow.entryReason": "string",
"flow.entryType": "string",
"flow.exitReason": "string",
"flow.flowId": "string",
"flow.flowName": "string",
"flow.flowType": "string",
"flow.flowVersion": "string",
"flow.issuedCallback": "string",
"flow.startingLanguage": "string",
"flow.transferTargetAddress": "string",
"flow.transferTargetName": "string",
"flow.transferType": "string",
"mediaEndpointStats": [
{
"codecs": [
"string"
],
"discardedPackets": "string",
"maxLatencyMs": "string",
"minMos": "string",
"minRFactor": "string",
"receivedPackets": "string"
}
],
"mediaType": "string",
"metrics": [
{
"emitDate": "string",
"name": "string",
"value": "string"
}
],
"peerId": "string",
"recording": "string",
"remoteNameDisplayable": "string",
"segments": [
{
"conference": "string",
"disconnectType": "string",
"errorCode": "string",
"queueId": "string",
"segmentEnd": "string",
"segmentStart": "string",
"segmentType": "string",
"sipResponseCodes": [
"int"
]
}
],
"sessionDnis": "string",
"sessionId": "string"
}
],
"userId": "string"
}
]
},
"created": "2019-08-09 15:35:32",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_manual.genesys_genesys_conversations`\n(\n`conversationStart`STRING,`mediaStatsMinConversationRFactor`STRING,`mediaStatsMinConversationMos`STRING,`divisionIds`array,`participants`array>,`direction`:STRING,`edgeId`:STRING,`sessionDnis`:STRING,`segments`:array,`errorCode`:STRING,`queueId`:STRING>>,`flow`:struct<`flowName`:STRING,`transferType`:STRING,`endingLanguage`:STRING,`exitReason`:STRING,`flowId`:STRING,`startingLanguage`:STRING,`entryReason`:STRING,`issuedCallback`:STRING,`flowVersion`:STRING,`flowType`:STRING,`transferTargetAddress`:STRING,`entryType`:STRING,`transferTargetName`:STRING>,`mediaType`:STRING,`ani`:STRING,`remoteNameDisplayable`:STRING,`sessionId`:STRING,`peerId`:STRING,`mediaEndpointStats`:array,`discardedPackets`:STRING>>,`dnis`:STRING,`recording`:STRING>>,`participantId`:STRING,`participantName`:STRING,`userId`:STRING>>,`originatingDirection`STRING,`_origin`STRING,`evaluations`array>,`conversationId`STRING,`conversationEnd`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-manual-genesys-dev/separated_dt/genesys_conversations'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_genesys_conversations`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_manual.genesys_genesys_conversations"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}