Schema Info

Schema Name: sfdl_dev_manual.genesys_conversations

created: 2019-08-21 16:44:43
disabled: False
format: raw
id: 1287
is_partitioned: True
is_schema_datatyped: False

name:

{
    "database": "sfdl_dev_manual",
    "table": "genesys_conversations"
}

type: manual

Schema Versions: 3

Version 4705692

created: 2024-05-13 12:47:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_conversations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_manual.genesys_conversations`\n(\n`conferenceStart`STRING,`customerParticipation`STRING,`originatingDirection`STRING,`conversationId`STRING,`mediaStatsMinConversationRFactor`STRING,`conversationStart`STRING,`conversationEnd`STRING,`resolutions`array>,`mediaStatsMinConversationMos`STRING,`divisionIds`array,`conversationInitiator`STRING,`evaluations`array>,`participants`array,`eventTime`:STRING,`maxLatencyMs`:STRING,`minMos`:STRING,`minRFactor`:STRING,`receivedPackets`:STRING,`discardedPackets`:STRING,`underrunPackets`:STRING>>,`flow`:struct<`endingLanguage`:STRING,`entryReason`:STRING,`entryType`:STRING,`exitReason`:STRING,`flowId`:STRING,`flowName`:STRING,`flowType`:STRING,`flowVersion`:STRING,`startingLanguage`:STRING,`outcomes`:array>,`transferTargetAddress`:STRING,`transferTargetName`:STRING,`transferType`:STRING>,`metrics`:array>,`segments`:array>>,`recording`:STRING,`agentBullseyeRing`:STRING,`requestedRoutings`:array,`routingRing`:STRING,`selectedAgentId`:STRING,`usedRouting`:STRING,`destinationAddresses`:array>>,`externalContactId`:STRING,`teamId`:STRING,`userId`:STRING>>,`_origin`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/conversations'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_conversations"
]

hive_path: s3://sfdl-manual-genesys-dev/separated_dt/conversations
id: 4705692
processed: 1

raw_data:

{
    "_origin": "2024-05-13T12:44:52Z|separated_dt/conversations/dt=2024-05-11/f483bed6-540a-461b-b4a1-ec176f027f45.json.gz|airflow_genesys_dev",
    "conferenceStart": "2024-05-11T13:33:30.145Z",
    "conversationEnd": "2024-05-11T12:20:18.589Z",
    "conversationId": "0c0ad138-de5e-48de-85c8-68141998cb95",
    "conversationStart": "2024-05-11T12:06:23.049Z",
    "divisionIds": [
        "f59a31a3-3a6e-402f-8ef8-658486543e13"
    ],
    "evaluations": [
        {
            "assigneeApplicable": true,
            "calibrationId": "8d13c909-37b9-430f-8671-404b88566715",
            "contextId": "7f24fc74-867c-4f96-baea-fe514e6ef997",
            "evaluationId": "6cf832c5-d4fd-46a5-a1ca-ba0854f9d6d1",
            "evaluationStatus": "Finished",
            "evaluatorId": "dde9c9b3-9d87-453c-8749-938eb55644b0",
            "eventTime": "2024-05-11T14:08:05.093Z",
            "formId": "1f870df4-f479-4d8c-9c41-028f85739fad",
            "formName": "SpareFoot Call Center Sales Global Quality Form",
            "oTotalCriticalScore": 66,
            "oTotalScore": 88,
            "queueId": "9e3e2e2b-9c72-4921-b68f-74930a7ae05c",
            "released": true,
            "rescored": true,
            "userId": "c8321e97-e56a-46b2-b526-e24a0bc9cb44"
        }
    ],
    "mediaStatsMinConversationMos": 4.39299567552302,
    "mediaStatsMinConversationRFactor": 88.4217300415039,
    "originatingDirection": "inbound",
    "participants": [
        {
            "externalContactId": "8e2447c8-bd05-437c-a810-1f3de2b94867",
            "participantId": "7b92d061-56ca-4c1e-96f0-aa062840953e",
            "participantName": "Marketplace - Closed",
            "purpose": "ivr",
            "sessions": [
                {
                    "agentBullseyeRing": 1,
                    "ani": "tel:+17187912185",
                    "destinationAddresses": [
                        "1(410) 668-1944",
                        "1(410) 668-1944",
                        "1(410) 668-1944"
                    ],
                    "direction": "inbound",
                    "dnis": "tel:+15122775732",
                    "edgeId": "32dffcde-259a-4622-8bce-f4bdf4dcd96d",
                    "flow": {
                        "endingLanguage": "en-us",
                        "entryReason": "tel:+15122775732",
                        "entryType": "dnis",
                        "exitReason": "TRANSFER",
                        "flowId": "a0161c4f-742b-4ef4-837d-608392929cee",
                        "flowName": "Marketplace - Open",
                        "flowType": "INBOUNDCALL",
                        "flowVersion": "37.0",
                        "outcomes": [
                            {
                                "flowOutcome": "086d66b0-9cf5-4141-88b1-dcda8cda7523:FAILURE",
                                "flowOutcomeId": "086d66b0-9cf5-4141-88b1-dcda8cda7523",
                                "flowOutcomeStartTimestamp": "2024-05-11T16:09:12.200Z",
                                "flowOutcomeValue": "FAILURE"
                            }
                        ],
                        "startingLanguage": "en-us",
                        "transferTargetAddress": "9e3e2e2b-9c72-4921-b68f-74930a7ae05c",
                        "transferTargetName": "SpareFoot Marketplace Sales",
                        "transferType": "ACD"
                    },
                    "mediaEndpointStats": [
                        {
                            "codecs": [
                                "audio/PCMU"
                            ],
                            "discardedPackets": 1,
                            "eventTime": "2024-05-11T19:33:35.039Z",
                            "maxLatencyMs": 30,
                            "minMos": 4.288637707708395,
                            "minRFactor": 88.06053161621094,
                            "receivedPackets": 1289,
                            "underrunPackets": 1
                        }
                    ],
                    "mediaType": "voice",
                    "metrics": [
                        {
                            "emitDate": "2024-05-11T05:01:16.363Z",
                            "name": "tFlowDisconnect",
                            "value": 8902
                        }
                    ],
                    "peerId": "c56e064e-28f5-4b81-a47f-0ae310df58eb",
                    "protocolCallId": "[email protected]",
                    "provider": "Edge",
                    "recording": true,
                    "remote": "Toledo OH",
                    "remoteNameDisplayable": "New York City NY",
                    "requestedRoutings": [
                        "Bullseye"
                    ],
                    "routingRing": 1,
                    "segments": [
                        {
                            "conference": false,
                            "disconnectType": "peer",
                            "errorCode": "error.ininedgecontrol.callflow.document.accept.media",
                            "queueId": "9e3e2e2b-9c72-4921-b68f-74930a7ae05c",
                            "segmentEnd": "2024-05-11T05:01:16.360Z",
                            "segmentStart": "2024-05-11T05:01:07.201Z",
                            "segmentType": "ivr",
                            "sipResponseCodes": [
                                487
                            ]
                        }
                    ],
                    "selectedAgentId": "38ab06cb-fd2e-4ed2-be3e-cfdfd290c1a3",
                    "sessionDnis": "tel:+15122775732",
                    "sessionId": "670f780b-313c-487c-84f4-dc27bd487e60",
                    "usedRouting": "Bullseye"
                }
            ],
            "teamId": "e3d7916a-3d8f-4198-9098-9c45cacd2ce2",
            "userId": "2201401f-466b-4a0b-a705-fc6f4bee8961"
        }
    ]
}

schema_attributes:

{
    "_origin": "string",
    "conferenceStart": "string",
    "conversationEnd": "string",
    "conversationId": "string",
    "conversationInitiator": "string",
    "conversationStart": "string",
    "customerParticipation": "string",
    "divisionIds": [
        "string"
    ],
    "evaluations": [
        {
            "assigneeApplicable": "string",
            "calibrationId": "string",
            "contextId": "string",
            "evaluationId": "string",
            "evaluationStatus": "string",
            "evaluatorId": "string",
            "eventTime": "string",
            "formId": "string",
            "formName": "string",
            "oTotalCriticalScore": "string",
            "oTotalScore": "string",
            "queueId": "string",
            "released": "string",
            "rescored": "string",
            "userId": "string"
        }
    ],
    "mediaStatsMinConversationMos": "string",
    "mediaStatsMinConversationRFactor": "string",
    "originatingDirection": "string",
    "participants": [
        {
            "externalContactId": "string",
            "participantId": "string",
            "participantName": "string",
            "purpose": "string",
            "sessions": [
                {
                    "agentBullseyeRing": "string",
                    "ani": "string",
                    "destinationAddresses": [
                        "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.outcomes": [
                        {
                            "flowOutcome": "string",
                            "flowOutcomeId": "string",
                            "flowOutcomeStartTimestamp": "string",
                            "flowOutcomeValue": "string"
                        }
                    ],
                    "flow.startingLanguage": "string",
                    "flow.transferTargetAddress": "string",
                    "flow.transferTargetName": "string",
                    "flow.transferType": "string",
                    "mediaEndpointStats": [
                        {
                            "codecs": [
                                "string"
                            ],
                            "discardedPackets": "string",
                            "eventTime": "string",
                            "maxLatencyMs": "string",
                            "minMos": "string",
                            "minRFactor": "string",
                            "receivedPackets": "string",
                            "underrunPackets": "string"
                        }
                    ],
                    "mediaType": "string",
                    "metrics": [
                        {
                            "emitDate": "string",
                            "name": "string",
                            "value": "string"
                        }
                    ],
                    "peerId": "string",
                    "protocolCallId": "string",
                    "provider": "string",
                    "recording": "string",
                    "remote": "string",
                    "remoteNameDisplayable": "string",
                    "requestedRoutings": [
                        "string"
                    ],
                    "routingRing": "string",
                    "segments": [
                        {
                            "conference": "string",
                            "disconnectType": "string",
                            "errorCode": "string",
                            "queueId": "string",
                            "segmentEnd": "string",
                            "segmentStart": "string",
                            "segmentType": "string",
                            "sipResponseCodes": [
                                "int"
                            ]
                        }
                    ],
                    "selectedAgentId": "string",
                    "sessionDnis": "string",
                    "sessionId": "string",
                    "usedRouting": "string"
                }
            ],
            "teamId": "string",
            "userId": "string"
        }
    ],
    "resolutions": [
        {
            "eventTime": "string"
        }
    ]
}

schema_name_id: 1287
schema_scan_id: 6489845
updated: 2024-05-13 12:48:13

Version 4700897

created: 2024-01-29 12:49:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_conversations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_manual.genesys_conversations`\n(\n`mediaStatsMinConversationRFactor`STRING,`_origin`STRING,`customerParticipation`STRING,`evaluations`array>,`conversationId`STRING,`participants`array,`callbackUserName`:STRING,`direction`:STRING,`mediaType`:STRING,`peerId`:STRING,`provider`:STRING,`remote`:STRING,`requestedRoutings`:array,`routingRing`:STRING,`selectedAgentId`:STRING,`sessionId`:STRING,`skipEnabled`:STRING,`timeoutSeconds`:STRING,`usedRouting`:STRING,`metrics`:array>,`segments`:array>,`ani`:STRING,`dnis`:STRING,`edgeId`:STRING,`protocolCallId`:STRING,`recording`:STRING,`remoteNameDisplayable`:STRING,`sessionDnis`:STRING,`mediaEndpointStats`:array,`eventTime`:STRING,`maxLatencyMs`:STRING,`minMos`:STRING,`minRFactor`:STRING,`receivedPackets`:STRING>>>>,`externalContactId`:STRING,`participantName`:STRING>>,`conversationEnd`STRING,`conversationStart`STRING,`divisionIds`array,`mediaStatsMinConversationMos`STRING,`originatingDirection`STRING,`resolutions`array>,`conversationInitiator`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/conversations'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_conversations"
]

hive_path: s3://sfdl-manual-genesys-dev/separated_dt/conversations
id: 4700897
processed: 1

raw_data:

{
    "_origin": "2024-01-29T12:48:47Z|separated_dt/conversations/dt=2023-05-02/e6ef0a55-9e37-4bb0-8771-bab3276386eb.json.gz|airflow_genesys_dev",
    "conversationEnd": "2023-05-03T13:44:49.049Z",
    "conversationId": "909b5036-4398-4204-bca2-0f16ecbe4168",
    "conversationStart": "2023-05-02T02:40:33.276Z",
    "divisionIds": [
        "f59a31a3-3a6e-402f-8ef8-658486543e13"
    ],
    "mediaStatsMinConversationMos": 4.386559433415702,
    "mediaStatsMinConversationRFactor": 91.46633911132812,
    "originatingDirection": "inbound",
    "participants": [
        {
            "externalContactId": "668e3d07-618a-46ff-91d7-682e1d87333e",
            "participantId": "1b3c07ce-4ce6-48cf-af7f-38418af59aeb",
            "participantName": "Fairborn OH",
            "purpose": "agent",
            "sessions": [
                {
                    "agentBullseyeRing": 1,
                    "ani": "tel:+19378793008",
                    "callbackNumbers": [
                        "+13024383957"
                    ],
                    "callbackUserName": "Name Not Provided",
                    "direction": "outbound",
                    "dnis": "tel:+19198650789",
                    "edgeId": "c1bc42da-e8b9-44a0-aede-ae2cb02a1349",
                    "mediaEndpointStats": [
                        {
                            "codecs": [
                                "audio/opus"
                            ],
                            "eventTime": "2023-05-02T13:53:49.904Z",
                            "maxLatencyMs": 30,
                            "minMos": 4.882646283740963,
                            "minRFactor": 92.4539566040039,
                            "receivedPackets": 3228
                        }
                    ],
                    "mediaType": "callback",
                    "metrics": [
                        {
                            "emitDate": "2023-05-03T13:44:49.049Z",
                            "name": "tHandle",
                            "value": 20149
                        }
                    ],
                    "peerId": "f14c5ef5-28b2-4d90-9a90-c80346f7626a",
                    "protocolCallId": "[email protected]",
                    "provider": "PureCloud Callback",
                    "recording": true,
                    "remote": "Newport Beach CA",
                    "remoteNameDisplayable": "Fairborn OH",
                    "requestedRoutings": [
                        "Standard"
                    ],
                    "routingRing": 1,
                    "segments": [
                        {
                            "conference": false,
                            "disconnectType": "client",
                            "queueId": "9bced551-6228-425a-86a4-8d83ace3e788",
                            "segmentEnd": "2023-05-03T13:44:49.049Z",
                            "segmentStart": "2023-05-03T13:44:46.537Z",
                            "segmentType": "wrapup",
                            "wrapUpCode": "ae306229-d830-453d-9d44-b728e28f6cd2"
                        }
                    ],
                    "selectedAgentId": "da24c015-aac7-4fc8-9c97-d67e85073356",
                    "sessionDnis": "tel:+19198650789",
                    "sessionId": "6ce51a41-736d-4e14-8d18-2df54ebbdbb4",
                    "skipEnabled": true,
                    "timeoutSeconds": 0,
                    "usedRouting": "Standard"
                }
            ],
            "userId": "da24c015-aac7-4fc8-9c97-d67e85073356"
        }
    ],
    "resolutions": [
        {
            "eventTime": "2023-05-10T19:00:30.577Z"
        }
    ]
}

schema_attributes:

{
    "_origin": "string",
    "conversationEnd": "string",
    "conversationId": "string",
    "conversationInitiator": "string",
    "conversationStart": "string",
    "customerParticipation": "string",
    "divisionIds": [
        "string"
    ],
    "evaluations": [
        {
            "contextId": "string",
            "evaluationId": "string",
            "evaluatorId": "string",
            "eventTime": "string",
            "formId": "string",
            "formName": "string",
            "oTotalCriticalScore": "string",
            "oTotalScore": "string",
            "queueId": "string",
            "released": "string",
            "rescored": "string",
            "userId": "string"
        }
    ],
    "mediaStatsMinConversationMos": "string",
    "mediaStatsMinConversationRFactor": "string",
    "originatingDirection": "string",
    "participants": [
        {
            "externalContactId": "string",
            "participantId": "string",
            "participantName": "string",
            "purpose": "string",
            "sessions": [
                {
                    "agentBullseyeRing": "string",
                    "ani": "string",
                    "callbackNumbers": [
                        "string"
                    ],
                    "callbackUserName": "string",
                    "direction": "string",
                    "dnis": "string",
                    "edgeId": "string",
                    "mediaEndpointStats": [
                        {
                            "codecs": [
                                "string"
                            ],
                            "eventTime": "string",
                            "maxLatencyMs": "string",
                            "minMos": "string",
                            "minRFactor": "string",
                            "receivedPackets": "string"
                        }
                    ],
                    "mediaType": "string",
                    "metrics": [
                        {
                            "emitDate": "string",
                            "name": "string",
                            "value": "string"
                        }
                    ],
                    "peerId": "string",
                    "protocolCallId": "string",
                    "provider": "string",
                    "recording": "string",
                    "remote": "string",
                    "remoteNameDisplayable": "string",
                    "requestedRoutings": [
                        "string"
                    ],
                    "routingRing": "string",
                    "segments": [
                        {
                            "conference": "string",
                            "disconnectType": "string",
                            "queueId": "string",
                            "segmentEnd": "string",
                            "segmentStart": "string",
                            "segmentType": "string",
                            "wrapUpCode": "string"
                        }
                    ],
                    "selectedAgentId": "string",
                    "sessionDnis": "string",
                    "sessionId": "string",
                    "skipEnabled": "string",
                    "timeoutSeconds": "string",
                    "usedRouting": "string"
                }
            ],
            "userId": "string"
        }
    ],
    "resolutions": [
        {
            "eventTime": "string"
        }
    ]
}

schema_name_id: 1287
schema_scan_id: 6413981
updated: 2024-01-29 12:49:30

Version 4693239

created: 2023-03-07 09:34:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_conversations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_manual.genesys_conversations`\n(\n`divisionIds`array,`participants`array,`eventTime`:STRING,`maxLatencyMs`:STRING,`minMos`:STRING,`minRFactor`:STRING,`receivedPackets`:STRING,`discardedPackets`:STRING,`duplicatePackets`:STRING,`underrunPackets`:STRING>>,`flow`:struct<`endingLanguage`:STRING,`entryReason`:STRING,`entryType`:STRING,`exitReason`:STRING,`flowId`:STRING,`flowName`:STRING,`flowType`:STRING,`flowVersion`:STRING,`startingLanguage`:STRING,`transferTargetAddress`:STRING,`transferTargetName`:STRING,`transferType`:STRING>,`metrics`:array>,`segments`:array>,`recording`:STRING,`agentBullseyeRing`:STRING,`requestedRoutings`:array,`routingRing`:STRING,`selectedAgentId`:STRING,`usedRouting`:STRING,`destinationAddresses`:array,`addressFrom`:STRING,`addressTo`:STRING,`deliveryStatus`:STRING,`deliveryStatusChangeDate`:STRING,`messageType`:STRING>>,`externalContactId`:STRING,`userId`:STRING,`teamId`:STRING>>,`originatingDirection`STRING,`conversationStart`STRING,`conversationInitiator`STRING,`customerParticipation`STRING,`mediaStatsMinConversationRFactor`STRING,`_origin`STRING,`evaluations`array>,`conversationEnd`STRING,`mediaStatsMinConversationMos`STRING,`conversationId`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/conversations'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_conversations"
]

hive_path: s3://sfdl-manual-genesys-dev/separated_dt/conversations
id: 4693239
processed: 1

raw_data:

{
    "_origin": "2023-03-07T09:34:44Z|separated_dt/conversations/dt=2023-03-06/292eef04-9027-46f5-9374-275374d18f1c.json.gz|airflow_genesys_dev",
    "conversationEnd": "2023-03-06T19:24:17.114Z",
    "conversationId": "ed2163af-f847-445b-bfb5-afc9cd9c1a60",
    "conversationInitiator": "customer",
    "conversationStart": "2023-03-06T19:18:53.545Z",
    "customerParticipation": true,
    "divisionIds": [
        "f59a31a3-3a6e-402f-8ef8-658486543e13"
    ],
    "evaluations": [
        {
            "contextId": "7f24fc74-867c-4f96-baea-fe514e6ef997",
            "evaluationId": "d9fd31dc-4f05-45de-91ff-dd02b2791fef",
            "evaluatorId": "8af729c7-c18b-446f-bf1c-d6e8d47f2fe6",
            "eventTime": "2023-03-06T21:21:21.403Z",
            "formId": "0a863692-6cb4-4de8-87dd-b661dec23bd4",
            "formName": "SpareFoot Call Center Sales Global Quality Form",
            "oTotalCriticalScore": 38,
            "oTotalScore": 82,
            "queueId": "9e3e2e2b-9c72-4921-b68f-74930a7ae05c",
            "released": true,
            "rescored": true,
            "userId": "3d655a21-cb14-4c73-bb4b-523c0c10ad4a"
        }
    ],
    "mediaStatsMinConversationMos": 4.390993400762788,
    "mediaStatsMinConversationRFactor": 89.56707763671875,
    "originatingDirection": "inbound",
    "participants": [
        {
            "externalContactId": "1b68f287-70e4-4636-810a-6c3c9f95acf5",
            "participantId": "a64d4226-e06b-40f9-8f49-5f3f5aefbdcb",
            "participantName": "ESS Marketing Closed",
            "purpose": "ivr",
            "sessions": [
                {
                    "addressFrom": "+16168861126",
                    "addressTo": "+14353345741",
                    "agentBullseyeRing": 1,
                    "ani": "tel:+17752971945",
                    "deliveryStatus": "Received",
                    "deliveryStatusChangeDate": "2023-03-06T21:09:38.805Z",
                    "destinationAddresses": [
                        "(786) 822-4954",
                        "(786) 822-4954"
                    ],
                    "direction": "inbound",
                    "dnis": "tel:+15127671031",
                    "edgeId": "ae940979-5353-4baa-8760-79821c4a2313",
                    "flow": {
                        "endingLanguage": "en-us",
                        "entryReason": "tel:+14354290270",
                        "entryType": "dnis",
                        "exitReason": "TRANSFER",
                        "flowId": "b16d236e-1ea8-4aab-8227-bc314b0fa6de",
                        "flowName": "ESS Marketing Closed",
                        "flowType": "INBOUNDCALL",
                        "flowVersion": "2.0",
                        "startingLanguage": "en-us",
                        "transferTargetAddress": "cd589e97-2abb-4316-b4f3-f1a377e5c4f7",
                        "transferTargetName": "ESS Marketing",
                        "transferType": "ACD_VOICEMAIL"
                    },
                    "mediaEndpointStats": [
                        {
                            "codecs": [
                                "audio/opus"
                            ],
                            "discardedPackets": 45,
                            "duplicatePackets": 4,
                            "eventTime": "2023-03-06T15:49:32.631Z",
                            "maxLatencyMs": 30,
                            "minMos": 4.884343824314904,
                            "minRFactor": 92.52836608886719,
                            "receivedPackets": 529,
                            "underrunPackets": 1
                        }
                    ],
                    "mediaType": "voice",
                    "messageType": "sms",
                    "metrics": [
                        {
                            "emitDate": "2023-03-06T15:49:32.566Z",
                            "name": "tIvr",
                            "value": 10584
                        }
                    ],
                    "peerId": "6d455ef5-b11b-4029-bca3-b4096bef157e",
                    "protocolCallId": "[email protected]",
                    "provider": "Edge",
                    "recording": true,
                    "remote": "MktgA SHARP MOVING",
                    "remoteNameDisplayable": "Carson City NV",
                    "requestedRoutings": [
                        "Bullseye"
                    ],
                    "routingRing": 1,
                    "segments": [
                        {
                            "conference": false,
                            "disconnectType": "endpoint",
                            "errorCode": "error.ininedgecontrol.connection.noAvailableLines.noPBXPassthrough",
                            "queueId": "7003f56b-13c9-4881-b479-baf231ae7246",
                            "segmentEnd": "2023-03-06T15:49:32.566Z",
                            "segmentStart": "2023-03-06T15:49:21.982Z",
                            "segmentType": "ivr"
                        }
                    ],
                    "selectedAgentId": "bfab7627-29d1-4916-abc3-fd2b702aa5d4",
                    "sessionDnis": "tel:+14354290270",
                    "sessionId": "ac5adad8-0001-4da4-a347-be62e3e7c8b5",
                    "usedRouting": "Standard"
                }
            ],
            "teamId": "23c7ea42-f2af-4fff-8e68-4049f8f602ca",
            "userId": "629820dd-9a46-400f-84f9-c9b8b7278d3a"
        }
    ]
}

schema_attributes:

{
    "_origin": "string",
    "conversationEnd": "string",
    "conversationId": "string",
    "conversationInitiator": "string",
    "conversationStart": "string",
    "customerParticipation": "string",
    "divisionIds": [
        "string"
    ],
    "evaluations": [
        {
            "contextId": "string",
            "evaluationId": "string",
            "evaluatorId": "string",
            "eventTime": "string",
            "formId": "string",
            "formName": "string",
            "oTotalCriticalScore": "string",
            "oTotalScore": "string",
            "queueId": "string",
            "released": "string",
            "rescored": "string",
            "userId": "string"
        }
    ],
    "mediaStatsMinConversationMos": "string",
    "mediaStatsMinConversationRFactor": "string",
    "originatingDirection": "string",
    "participants": [
        {
            "externalContactId": "string",
            "participantId": "string",
            "participantName": "string",
            "purpose": "string",
            "sessions": [
                {
                    "addressFrom": "string",
                    "addressTo": "string",
                    "agentBullseyeRing": "string",
                    "ani": "string",
                    "deliveryStatus": "string",
                    "deliveryStatusChangeDate": "string",
                    "destinationAddresses": [
                        "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.startingLanguage": "string",
                    "flow.transferTargetAddress": "string",
                    "flow.transferTargetName": "string",
                    "flow.transferType": "string",
                    "mediaEndpointStats": [
                        {
                            "codecs": [
                                "string"
                            ],
                            "discardedPackets": "string",
                            "duplicatePackets": "string",
                            "eventTime": "string",
                            "maxLatencyMs": "string",
                            "minMos": "string",
                            "minRFactor": "string",
                            "receivedPackets": "string",
                            "underrunPackets": "string"
                        }
                    ],
                    "mediaType": "string",
                    "messageType": "string",
                    "metrics": [
                        {
                            "emitDate": "string",
                            "name": "string",
                            "value": "string"
                        }
                    ],
                    "peerId": "string",
                    "protocolCallId": "string",
                    "provider": "string",
                    "recording": "string",
                    "remote": "string",
                    "remoteNameDisplayable": "string",
                    "requestedRoutings": [
                        "string"
                    ],
                    "routingRing": "string",
                    "segments": [
                        {
                            "conference": "string",
                            "disconnectType": "string",
                            "errorCode": "string",
                            "queueId": "string",
                            "segmentEnd": "string",
                            "segmentStart": "string",
                            "segmentType": "string"
                        }
                    ],
                    "selectedAgentId": "string",
                    "sessionDnis": "string",
                    "sessionId": "string",
                    "usedRouting": "string"
                }
            ],
            "teamId": "string",
            "userId": "string"
        }
    ]
}

schema_name_id: 1287
schema_scan_id: 6129993
updated: 2023-03-07 09:35:11

Schema Scans: 3

Last at 2024-05-13 12:46:51

Scan 6489845

duration: 0:01:06.585042

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 119,
    "partitions_applied": false,
    "success": true
}

id: 6489845

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2024-05-11/",
        "name": "dt",
        "type": "string",
        "value": "2024-05-11"
    },
    "s3": {
        "bucket": "sfdl-manual-genesys-dev",
        "hive_path": "s3://sfdl-manual-genesys-dev/separated_dt/conversations",
        "key": "separated_dt/conversations/dt=2024-05-11/f483bed6-540a-461b-b4a1-ec176f027f45.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_conversations",
        "type": "manual"
    }
}

running: False
schema_name_id: 1287
start_time: 2024-05-13 12:46:51
success: True
trace_id: 4239207453824358693

Scan 6413981

duration: 0:00:27.662420

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 93,
    "partitions_applied": false,
    "success": true
}

id: 6413981

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2023-05-02/",
        "name": "dt",
        "type": "string",
        "value": "2023-05-02"
    },
    "s3": {
        "bucket": "sfdl-manual-genesys-dev",
        "hive_path": "s3://sfdl-manual-genesys-dev/separated_dt/conversations",
        "key": "separated_dt/conversations/dt=2023-05-02/e6ef0a55-9e37-4bb0-8771-bab3276386eb.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_conversations",
        "type": "manual"
    }
}

running: False
schema_name_id: 1287
start_time: 2024-01-29 12:49:13
success: True
trace_id: 1223196476707505471

Scan 6129993

duration: 0:00:23.462246

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 82,
    "partitions_applied": false,
    "success": true
}

id: 6129993

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2023-03-06/",
        "name": "dt",
        "type": "string",
        "value": "2023-03-06"
    },
    "s3": {
        "bucket": "sfdl-manual-genesys-dev",
        "hive_path": "s3://sfdl-manual-genesys-dev/separated_dt/conversations",
        "key": "separated_dt/conversations/dt=2023-03-06/292eef04-9027-46f5-9374-275374d18f1c.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_conversations",
        "type": "manual"
    }
}

running: False
schema_name_id: 1287
start_time: 2023-03-07 09:34:52
success: True
trace_id: 15957641143790015819

Partitions:

count: 9

ddl:

[
    "ALTER TABLE\n    `sfdl_dev_manual.genesys_conversations`\nADD\n\n\n PARTITION (dt='2023-04-29') location 's3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2023-04-29/'\n PARTITION (dt='2023-04-30') location 's3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2023-04-30/'\n PARTITION (dt='2023-05-01') location 's3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2023-05-01/'\n PARTITION (dt='2023-05-02') location 's3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2023-05-02/'\n PARTITION (dt='2024-05-11') location 's3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2024-05-11/'\n PARTITION (dt='2024-05-12') location 's3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2024-05-12/'\n PARTITION (dt='2024-05-13') location 's3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2024-05-13/'\n PARTITION (dt='2024-08-12') location 's3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2024-08-12/'\n PARTITION (dt='2024-08-13') location 's3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2024-08-13/'\n;"
]

name: dt

state:

[
    {
        "info": {
            "id": 253933,
            "location": "s3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2023-04-29/",
            "name": "dt",
            "value": "2023-04-29"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2024-05-13 12:47:57",
                "last_data": "2024-05-13 12:47:57"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 253932,
            "location": "s3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2023-04-30/",
            "name": "dt",
            "value": "2023-04-30"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2024-05-13 12:47:57",
                "last_data": "2024-05-13 12:47:57"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 253931,
            "location": "s3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2023-05-01/",
            "name": "dt",
            "value": "2023-05-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2024-05-13 12:47:56",
                "last_data": "2024-05-13 12:47:56"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 253930,
            "location": "s3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2023-05-02/",
            "name": "dt",
            "value": "2023-05-02"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2024-05-13 12:47:56",
                "last_data": "2024-05-13 12:47:56"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 253927,
            "location": "s3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2024-05-11/",
            "name": "dt",
            "value": "2024-05-11"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2024-05-13 12:47:08",
                "last_data": "2024-05-13 12:47:08"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 253929,
            "location": "s3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2024-05-12/",
            "name": "dt",
            "value": "2024-05-12"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2024-05-13 12:47:31",
                "last_data": "2024-05-13 12:47:31"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 254005,
            "location": "s3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2024-05-13/",
            "name": "dt",
            "value": "2024-05-13"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2024-05-14 03:38:53",
                "last_data": "2024-05-14 03:38:53"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 259625,
            "location": "s3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2024-08-12/",
            "name": "dt",
            "value": "2024-08-12"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2024-08-14 09:47:19",
                "last_data": "2024-08-14 09:47:19"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 259624,
            "location": "s3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2024-08-13/",
            "name": "dt",
            "value": "2024-08-13"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2024-08-14 09:46:39",
                "last_data": "2024-08-14 09:46:39"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    }
]

type: string

Schema:

attributes:

{
    "_origin": "string",
    "conferenceStart": "string",
    "conversationEnd": "string",
    "conversationId": "string",
    "conversationInitiator": "string",
    "conversationStart": "string",
    "customerParticipation": "string",
    "divisionIds": [
        "string"
    ],
    "evaluations": [
        {
            "assigneeApplicable": "string",
            "calibrationId": "string",
            "contextId": "string",
            "evaluationId": "string",
            "evaluationStatus": "string",
            "evaluatorId": "string",
            "eventTime": "string",
            "formId": "string",
            "formName": "string",
            "oTotalCriticalScore": "string",
            "oTotalScore": "string",
            "queueId": "string",
            "released": "string",
            "rescored": "string",
            "userId": "string"
        }
    ],
    "mediaStatsMinConversationMos": "string",
    "mediaStatsMinConversationRFactor": "string",
    "originatingDirection": "string",
    "participants": [
        {
            "externalContactId": "string",
            "participantId": "string",
            "participantName": "string",
            "purpose": "string",
            "sessions": [
                {
                    "agentBullseyeRing": "string",
                    "ani": "string",
                    "destinationAddresses": [
                        "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.outcomes": [
                        {
                            "flowOutcome": "string",
                            "flowOutcomeId": "string",
                            "flowOutcomeStartTimestamp": "string",
                            "flowOutcomeValue": "string"
                        }
                    ],
                    "flow.startingLanguage": "string",
                    "flow.transferTargetAddress": "string",
                    "flow.transferTargetName": "string",
                    "flow.transferType": "string",
                    "mediaEndpointStats": [
                        {
                            "codecs": [
                                "string"
                            ],
                            "discardedPackets": "string",
                            "eventTime": "string",
                            "maxLatencyMs": "string",
                            "minMos": "string",
                            "minRFactor": "string",
                            "receivedPackets": "string",
                            "underrunPackets": "string"
                        }
                    ],
                    "mediaType": "string",
                    "metrics": [
                        {
                            "emitDate": "string",
                            "name": "string",
                            "value": "string"
                        }
                    ],
                    "peerId": "string",
                    "protocolCallId": "string",
                    "provider": "string",
                    "recording": "string",
                    "remote": "string",
                    "remoteNameDisplayable": "string",
                    "requestedRoutings": [
                        "string"
                    ],
                    "routingRing": "string",
                    "segments": [
                        {
                            "conference": "string",
                            "disconnectType": "string",
                            "errorCode": "string",
                            "queueId": "string",
                            "segmentEnd": "string",
                            "segmentStart": "string",
                            "segmentType": "string",
                            "sipResponseCodes": [
                                "int"
                            ]
                        }
                    ],
                    "selectedAgentId": "string",
                    "sessionDnis": "string",
                    "sessionId": "string",
                    "usedRouting": "string"
                }
            ],
            "teamId": "string",
            "userId": "string"
        }
    ],
    "resolutions": [
        {
            "eventTime": "string"
        }
    ]
}

created: 2024-05-13 12:47:08

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_manual.genesys_conversations`\n(\n`conferenceStart`STRING,`customerParticipation`STRING,`originatingDirection`STRING,`conversationId`STRING,`mediaStatsMinConversationRFactor`STRING,`conversationStart`STRING,`conversationEnd`STRING,`resolutions`array>,`mediaStatsMinConversationMos`STRING,`divisionIds`array,`conversationInitiator`STRING,`evaluations`array>,`participants`array,`eventTime`:STRING,`maxLatencyMs`:STRING,`minMos`:STRING,`minRFactor`:STRING,`receivedPackets`:STRING,`discardedPackets`:STRING,`underrunPackets`:STRING>>,`flow`:struct<`endingLanguage`:STRING,`entryReason`:STRING,`entryType`:STRING,`exitReason`:STRING,`flowId`:STRING,`flowName`:STRING,`flowType`:STRING,`flowVersion`:STRING,`startingLanguage`:STRING,`outcomes`:array>,`transferTargetAddress`:STRING,`transferTargetName`:STRING,`transferType`:STRING>,`metrics`:array>,`segments`:array>>,`recording`:STRING,`agentBullseyeRing`:STRING,`requestedRoutings`:array,`routingRing`:STRING,`selectedAgentId`:STRING,`usedRouting`:STRING,`destinationAddresses`:array>>,`externalContactId`:STRING,`teamId`:STRING,`userId`:STRING>>,`_origin`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/conversations'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_conversations`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_manual.genesys_conversations"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2019-08-21 16:44:43",
        "disabled": false,
        "format": "raw",
        "id": 1287,
        "is_partitioned": true,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_dev_manual",
            "table": "genesys_conversations"
        },
        "type": "manual"
    },
    "partition": {
        "count": 9,
        "ddl": [
            "ALTER TABLE\n    `sfdl_dev_manual.genesys_conversations`\nADD\n\n\n PARTITION (dt='2023-04-29') location 's3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2023-04-29/'\n PARTITION (dt='2023-04-30') location 's3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2023-04-30/'\n PARTITION (dt='2023-05-01') location 's3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2023-05-01/'\n PARTITION (dt='2023-05-02') location 's3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2023-05-02/'\n PARTITION (dt='2024-05-11') location 's3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2024-05-11/'\n PARTITION (dt='2024-05-12') location 's3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2024-05-12/'\n PARTITION (dt='2024-05-13') location 's3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2024-05-13/'\n PARTITION (dt='2024-08-12') location 's3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2024-08-12/'\n PARTITION (dt='2024-08-13') location 's3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2024-08-13/'\n;"
        ],
        "name": "dt",
        "state": [
            {
                "info": {
                    "id": 253933,
                    "location": "s3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2023-04-29/",
                    "name": "dt",
                    "value": "2023-04-29"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2024-05-13 12:47:57",
                        "last_data": "2024-05-13 12:47:57"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 253932,
                    "location": "s3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2023-04-30/",
                    "name": "dt",
                    "value": "2023-04-30"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2024-05-13 12:47:57",
                        "last_data": "2024-05-13 12:47:57"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 253931,
                    "location": "s3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2023-05-01/",
                    "name": "dt",
                    "value": "2023-05-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2024-05-13 12:47:56",
                        "last_data": "2024-05-13 12:47:56"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 253930,
                    "location": "s3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2023-05-02/",
                    "name": "dt",
                    "value": "2023-05-02"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2024-05-13 12:47:56",
                        "last_data": "2024-05-13 12:47:56"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 253927,
                    "location": "s3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2024-05-11/",
                    "name": "dt",
                    "value": "2024-05-11"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2024-05-13 12:47:08",
                        "last_data": "2024-05-13 12:47:08"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 253929,
                    "location": "s3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2024-05-12/",
                    "name": "dt",
                    "value": "2024-05-12"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2024-05-13 12:47:31",
                        "last_data": "2024-05-13 12:47:31"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 254005,
                    "location": "s3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2024-05-13/",
                    "name": "dt",
                    "value": "2024-05-13"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2024-05-14 03:38:53",
                        "last_data": "2024-05-14 03:38:53"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 259625,
                    "location": "s3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2024-08-12/",
                    "name": "dt",
                    "value": "2024-08-12"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2024-08-14 09:47:19",
                        "last_data": "2024-08-14 09:47:19"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 259624,
                    "location": "s3://sfdl-manual-genesys-dev/separated_dt/conversations/dt=2024-08-13/",
                    "name": "dt",
                    "value": "2024-08-13"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2024-08-14 09:46:39",
                        "last_data": "2024-08-14 09:46:39"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            }
        ],
        "type": "string"
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "conferenceStart": "string",
            "conversationEnd": "string",
            "conversationId": "string",
            "conversationInitiator": "string",
            "conversationStart": "string",
            "customerParticipation": "string",
            "divisionIds": [
                "string"
            ],
            "evaluations": [
                {
                    "assigneeApplicable": "string",
                    "calibrationId": "string",
                    "contextId": "string",
                    "evaluationId": "string",
                    "evaluationStatus": "string",
                    "evaluatorId": "string",
                    "eventTime": "string",
                    "formId": "string",
                    "formName": "string",
                    "oTotalCriticalScore": "string",
                    "oTotalScore": "string",
                    "queueId": "string",
                    "released": "string",
                    "rescored": "string",
                    "userId": "string"
                }
            ],
            "mediaStatsMinConversationMos": "string",
            "mediaStatsMinConversationRFactor": "string",
            "originatingDirection": "string",
            "participants": [
                {
                    "externalContactId": "string",
                    "participantId": "string",
                    "participantName": "string",
                    "purpose": "string",
                    "sessions": [
                        {
                            "agentBullseyeRing": "string",
                            "ani": "string",
                            "destinationAddresses": [
                                "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.outcomes": [
                                {
                                    "flowOutcome": "string",
                                    "flowOutcomeId": "string",
                                    "flowOutcomeStartTimestamp": "string",
                                    "flowOutcomeValue": "string"
                                }
                            ],
                            "flow.startingLanguage": "string",
                            "flow.transferTargetAddress": "string",
                            "flow.transferTargetName": "string",
                            "flow.transferType": "string",
                            "mediaEndpointStats": [
                                {
                                    "codecs": [
                                        "string"
                                    ],
                                    "discardedPackets": "string",
                                    "eventTime": "string",
                                    "maxLatencyMs": "string",
                                    "minMos": "string",
                                    "minRFactor": "string",
                                    "receivedPackets": "string",
                                    "underrunPackets": "string"
                                }
                            ],
                            "mediaType": "string",
                            "metrics": [
                                {
                                    "emitDate": "string",
                                    "name": "string",
                                    "value": "string"
                                }
                            ],
                            "peerId": "string",
                            "protocolCallId": "string",
                            "provider": "string",
                            "recording": "string",
                            "remote": "string",
                            "remoteNameDisplayable": "string",
                            "requestedRoutings": [
                                "string"
                            ],
                            "routingRing": "string",
                            "segments": [
                                {
                                    "conference": "string",
                                    "disconnectType": "string",
                                    "errorCode": "string",
                                    "queueId": "string",
                                    "segmentEnd": "string",
                                    "segmentStart": "string",
                                    "segmentType": "string",
                                    "sipResponseCodes": [
                                        "int"
                                    ]
                                }
                            ],
                            "selectedAgentId": "string",
                            "sessionDnis": "string",
                            "sessionId": "string",
                            "usedRouting": "string"
                        }
                    ],
                    "teamId": "string",
                    "userId": "string"
                }
            ],
            "resolutions": [
                {
                    "eventTime": "string"
                }
            ]
        },
        "created": "2024-05-13 12:47:08",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_manual.genesys_conversations`\n(\n`conferenceStart`STRING,`customerParticipation`STRING,`originatingDirection`STRING,`conversationId`STRING,`mediaStatsMinConversationRFactor`STRING,`conversationStart`STRING,`conversationEnd`STRING,`resolutions`array>,`mediaStatsMinConversationMos`STRING,`divisionIds`array,`conversationInitiator`STRING,`evaluations`array>,`participants`array,`eventTime`:STRING,`maxLatencyMs`:STRING,`minMos`:STRING,`minRFactor`:STRING,`receivedPackets`:STRING,`discardedPackets`:STRING,`underrunPackets`:STRING>>,`flow`:struct<`endingLanguage`:STRING,`entryReason`:STRING,`entryType`:STRING,`exitReason`:STRING,`flowId`:STRING,`flowName`:STRING,`flowType`:STRING,`flowVersion`:STRING,`startingLanguage`:STRING,`outcomes`:array>,`transferTargetAddress`:STRING,`transferTargetName`:STRING,`transferType`:STRING>,`metrics`:array>,`segments`:array>>,`recording`:STRING,`agentBullseyeRing`:STRING,`requestedRoutings`:array,`routingRing`:STRING,`selectedAgentId`:STRING,`usedRouting`:STRING,`destinationAddresses`:array>>,`externalContactId`:STRING,`teamId`:STRING,`userId`:STRING>>,`_origin`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/conversations'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_conversations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_manual.genesys_conversations"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}