Schema Info

Schema Name: sfdl_dev_couch.storedge_genesys_conversations

created: 2019-08-02 13:20:40
disabled: False
format: raw
id: 1269
is_partitioned: False
is_schema_datatyped: False

name:

{
    "database": "sfdl_dev_couch",
    "table": "storedge_genesys_conversations"
}

type: couch

Schema Versions: 2

Version 4671367

created: 2019-08-02 13:21:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_couch`",
    "DROP TABLE IF EXISTS `sfdl_dev_couch.storedge_genesys_conversations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_couch.storedge_genesys_conversations`\n(\n`divisionIds`array,`participants`array>,`mediaType`:STRING,`ani`:STRING,`metrics`:array>,`sessionId`:STRING,`peerId`:STRING,`mediaEndpointStats`:array>>,`dnis`:STRING,`remoteNameDisplayable`:STRING,`recording`:STRING>>,`userId`:STRING,`participantId`:STRING,`purpose`:STRING,`participantName`:STRING>>,`conversationStart`STRING,`mediaStatsMinConversationMos`STRING,`conversationEnd`STRING,`mediaStatsMinConversationRFactor`STRING,`originatingDirection`STRING,`conversationId`STRING\n)\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-couch-storedge-dev/raw/genesys_conversations/2019-08-02/1564770107'\n",
    "MSCK REPAIR TABLE sfdl_dev_couch.storedge_genesys_conversations"
]

hive_path: s3://sfdl-couch-storedge-dev/raw/genesys_conversations/2019-08-02/1564770107
id: 4671367
processed: 1

raw_data:

{
    "conversationEnd": "2019-07-27T15:21:04.148Z",
    "conversationId": "8542107c-3d9d-4f3f-a99e-fc9e411d439e",
    "conversationStart": "2019-07-27T15:20:13.033Z",
    "divisionIds": [
        "b4a5d15d-7294-44dc-a910-e370ad9ec9ab"
    ],
    "mediaStatsMinConversationMos": 4.393360137939453,
    "mediaStatsMinConversationRFactor": 91.94320678710938,
    "originatingDirection": "inbound",
    "participants": [
        {
            "participantId": "170ef4b5-6e1b-4808-ad4c-291d314003d1",
            "participantName": "National",
            "purpose": "user",
            "sessions": [
                {
                    "ani": "tel:+1862127684100",
                    "direction": "inbound",
                    "dnis": "tel:+15128863824",
                    "edgeId": "0e89e6fa-afb8-42cf-a7d2-f586f5c15f13",
                    "mediaEndpointStats": [
                        {
                            "codecs": [
                                "audio/opus"
                            ],
                            "maxLatencyMs": 30,
                            "minMos": 4.863152503967285,
                            "minRFactor": 91.62902069091797,
                            "receivedPackets": 1903
                        }
                    ],
                    "mediaType": "voice",
                    "metrics": [
                        {
                            "emitDate": "2019-07-27T15:20:25.646Z",
                            "name": "tAlert",
                            "value": 12004
                        }
                    ],
                    "peerId": "96778617-6cce-4522-a4f4-a1f89b440ccf",
                    "recording": true,
                    "remoteNameDisplayable": "National",
                    "segments": [
                        {
                            "conference": false,
                            "disconnectType": "noAnswerTransfer",
                            "segmentEnd": "2019-07-27T15:20:25.646Z",
                            "segmentStart": "2019-07-27T15:20:13.642Z",
                            "segmentType": "alert"
                        }
                    ],
                    "sessionDnis": "tel:+15128863822",
                    "sessionId": "b50c507a-5adf-4f79-a811-15f0864b1e26"
                }
            ],
            "userId": "5162a008-042f-486f-b6c3-45b2f07bb714"
        }
    ]
}

schema_attributes:

{
    "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",
                    "recording": "string",
                    "remoteNameDisplayable": "string",
                    "segments": [
                        {
                            "conference": "string",
                            "disconnectType": "string",
                            "segmentEnd": "string",
                            "segmentStart": "string",
                            "segmentType": "string"
                        }
                    ],
                    "sessionDnis": "string",
                    "sessionId": "string"
                }
            ],
            "userId": "string"
        }
    ]
}

schema_name_id: 1269
schema_scan_id: 5121496
updated: 2019-08-02 13:22:06

Version 4671366

created: 2019-08-02 13:20:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_couch`",
    "DROP TABLE IF EXISTS `sfdl_dev_couch.storedge_genesys_conversations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_couch.storedge_genesys_conversations`\n(\n`mediaStatsMinConversationRFactor`STRING,`conversationEnd`STRING,`mediaStatsMinConversationMos`STRING,`divisionIds`array,`conversationId`STRING,`participants`array>,`mediaType`:STRING,`ani`:STRING,`metrics`:array>,`sessionId`:STRING,`peerId`:STRING,`mediaEndpointStats`:array>>,`dnis`:STRING,`remoteNameDisplayable`:STRING,`recording`:STRING>>,`userId`:STRING,`participantId`:STRING,`purpose`:STRING,`participantName`:STRING>>,`originatingDirection`STRING,`conversationStart`STRING\n)\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-couch-storedge-dev/raw/genesys_conversations/2019-08-02/1564770033'\n",
    "MSCK REPAIR TABLE sfdl_dev_couch.storedge_genesys_conversations"
]

hive_path: s3://sfdl-couch-storedge-dev/raw/genesys_conversations/2019-08-02/1564770033
id: 4671366
processed: 1

raw_data:

{
    "conversationEnd": "2019-07-27T15:21:04.148Z",
    "conversationId": "8542107c-3d9d-4f3f-a99e-fc9e411d439e",
    "conversationStart": "2019-07-27T15:20:13.033Z",
    "divisionIds": [
        "b4a5d15d-7294-44dc-a910-e370ad9ec9ab"
    ],
    "mediaStatsMinConversationMos": 4.393360137939453,
    "mediaStatsMinConversationRFactor": 91.94320678710938,
    "originatingDirection": "inbound",
    "participants": [
        {
            "participantId": "170ef4b5-6e1b-4808-ad4c-291d314003d1",
            "participantName": "National",
            "purpose": "user",
            "sessions": [
                {
                    "ani": "tel:+1862127684100",
                    "direction": "inbound",
                    "dnis": "tel:+15128863824",
                    "edgeId": "0e89e6fa-afb8-42cf-a7d2-f586f5c15f13",
                    "mediaEndpointStats": [
                        {
                            "codecs": [
                                "audio/opus"
                            ],
                            "maxLatencyMs": 30,
                            "minMos": 4.863152503967285,
                            "minRFactor": 91.62902069091797,
                            "receivedPackets": 1903
                        }
                    ],
                    "mediaType": "voice",
                    "metrics": [
                        {
                            "emitDate": "2019-07-27T15:20:25.646Z",
                            "name": "tAlert",
                            "value": 12004
                        }
                    ],
                    "peerId": "96778617-6cce-4522-a4f4-a1f89b440ccf",
                    "recording": true,
                    "remoteNameDisplayable": "National",
                    "segments": [
                        {
                            "conference": false,
                            "disconnectType": "noAnswerTransfer",
                            "segmentEnd": "2019-07-27T15:20:25.646Z",
                            "segmentStart": "2019-07-27T15:20:13.642Z",
                            "segmentType": "alert"
                        }
                    ],
                    "sessionDnis": "tel:+15128863822",
                    "sessionId": "b50c507a-5adf-4f79-a811-15f0864b1e26"
                }
            ],
            "userId": "5162a008-042f-486f-b6c3-45b2f07bb714"
        }
    ]
}

schema_attributes:

{
    "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",
                    "recording": "string",
                    "remoteNameDisplayable": "string",
                    "segments": [
                        {
                            "conference": "string",
                            "disconnectType": "string",
                            "segmentEnd": "string",
                            "segmentStart": "string",
                            "segmentType": "string"
                        }
                    ],
                    "sessionDnis": "string",
                    "sessionId": "string"
                }
            ],
            "userId": "string"
        }
    ]
}

schema_name_id: 1269
schema_scan_id: 5121495
updated: 2019-08-02 13:20:52

Schema Scans: 2

Last at 2019-08-02 13:21:55

Scan 5121496

duration: 0:00:13.879861

exit_message:

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

id: 5121496

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-couch-storedge-dev",
        "hive_path": "s3://sfdl-couch-storedge-dev/raw/genesys_conversations/2019-08-02/1564770107",
        "key": "raw/genesys_conversations/2019-08-02/1564770107/conversations.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_couch.storedge_genesys_conversations",
        "type": "couch"
    },
    "trace_context": {
        "parent_id": 15276467313875514818,
        "service_name": "preloading",
        "span_id": 2020592821629955297,
        "trace_id": 11757649859200882741
    }
}

running: False
schema_name_id: 1269
start_time: 2019-08-02 13:21:55
success: True
trace_id: 11757649859200882741

Scan 5121495

duration: 0:00:14.189318

exit_message:

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

id: 5121495

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-couch-storedge-dev",
        "hive_path": "s3://sfdl-couch-storedge-dev/raw/genesys_conversations/2019-08-02/1564770033",
        "key": "raw/genesys_conversations/2019-08-02/1564770033/conversations.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_couch.storedge_genesys_conversations",
        "type": "couch"
    },
    "trace_context": {
        "parent_id": 14065869804908323092,
        "service_name": "preloading",
        "span_id": 7191101434014060819,
        "trace_id": 11757649859200882741
    }
}

running: False
schema_name_id: 1269
start_time: 2019-08-02 13:20:40
success: True
trace_id: 11757649859200882741

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "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",
                    "recording": "string",
                    "remoteNameDisplayable": "string",
                    "segments": [
                        {
                            "conference": "string",
                            "disconnectType": "string",
                            "segmentEnd": "string",
                            "segmentStart": "string",
                            "segmentType": "string"
                        }
                    ],
                    "sessionDnis": "string",
                    "sessionId": "string"
                }
            ],
            "userId": "string"
        }
    ]
}

created: 2019-08-02 13:21:55

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_couch`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_couch.storedge_genesys_conversations`\n(\n`divisionIds`array,`participants`array>,`mediaType`:STRING,`ani`:STRING,`metrics`:array>,`sessionId`:STRING,`peerId`:STRING,`mediaEndpointStats`:array>>,`dnis`:STRING,`remoteNameDisplayable`:STRING,`recording`:STRING>>,`userId`:STRING,`participantId`:STRING,`purpose`:STRING,`participantName`:STRING>>,`conversationStart`STRING,`mediaStatsMinConversationMos`STRING,`conversationEnd`STRING,`mediaStatsMinConversationRFactor`STRING,`originatingDirection`STRING,`conversationId`STRING\n)\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-couch-storedge-dev/raw/genesys_conversations/2019-08-02/1564770107'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_couch.storedge_genesys_conversations`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_couch.storedge_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-02 13:20:40",
        "disabled": false,
        "format": "raw",
        "id": 1269,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_dev_couch",
            "table": "storedge_genesys_conversations"
        },
        "type": "couch"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "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",
                            "recording": "string",
                            "remoteNameDisplayable": "string",
                            "segments": [
                                {
                                    "conference": "string",
                                    "disconnectType": "string",
                                    "segmentEnd": "string",
                                    "segmentStart": "string",
                                    "segmentType": "string"
                                }
                            ],
                            "sessionDnis": "string",
                            "sessionId": "string"
                        }
                    ],
                    "userId": "string"
                }
            ]
        },
        "created": "2019-08-02 13:21:55",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_couch`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_couch.storedge_genesys_conversations`\n(\n`divisionIds`array,`participants`array>,`mediaType`:STRING,`ani`:STRING,`metrics`:array>,`sessionId`:STRING,`peerId`:STRING,`mediaEndpointStats`:array>>,`dnis`:STRING,`remoteNameDisplayable`:STRING,`recording`:STRING>>,`userId`:STRING,`participantId`:STRING,`purpose`:STRING,`participantName`:STRING>>,`conversationStart`STRING,`mediaStatsMinConversationMos`STRING,`conversationEnd`STRING,`mediaStatsMinConversationRFactor`STRING,`originatingDirection`STRING,`conversationId`STRING\n)\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-couch-storedge-dev/raw/genesys_conversations/2019-08-02/1564770107'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_couch.storedge_genesys_conversations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_couch.storedge_genesys_conversations"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}