Schema Info

Schema Name: sfdl_dev_manual.genesys_queues

created: 2023-03-07 11:49:12
disabled: False
format: raw
id: 2207
is_partitioned: False
is_schema_datatyped: False

name:

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

type: manual

Schema Versions: 3

Version 4708738

created: 2024-08-14 09:46:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoDialAndEnd`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`scoringMethod`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`autoAnswerOnly`STRING,`enableTranscription`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`callingPartyNumber`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`enableManualAssignment`STRING,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`routingRules`array,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`: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-manual-genesys-dev/raw/queues/2024-08-14/1723646710'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-dev/raw/queues/2024-08-14/1723646710
id: 4708738
processed: 1

raw_data:

{
    "_origin": "2024-08-14T09:45:10Z|raw/queues/2024-08-13/1723646710/data.json.gz|airflow_genesys_dev",
    "acwSettings": {
        "timeoutMs": 90000,
        "wrapupPrompt": "MANDATORY_TIMEOUT"
    },
    "agentOwnedRouting": {
        "enableAgentOwnedCallbacks": false,
        "maxOwnedCallbackDelayHours": 2,
        "maxOwnedCallbackHours": 2
    },
    "autoAnswerOnly": true,
    "bullseye": {
        "rings": [
            {
                "actions": {
                    "skillsToRemove": [
                        {
                            "id": "154efaf3-c02b-4db1-a1cf-397ae3168f8f",
                            "name": "ESS Tech Support - Primary",
                            "selfUri": "/api/v2/routing/skills/154efaf3-c02b-4db1-a1cf-397ae3168f8f"
                        }
                    ]
                },
                "expansionCriteria": [
                    {
                        "threshold": 5.0,
                        "type": "TIMEOUT_SECONDS"
                    }
                ]
            }
        ]
    },
    "callingPartyNumber": "+1 ",
    "createdBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "dateCreated": "2024-03-13T20:33:32.710Z",
    "dateModified": "2024-04-08T13:48:29.207Z",
    "defaultScripts": {},
    "description": "Access control tier 3 support",
    "division": {
        "id": "b4a5d15d-7294-44dc-a910-e370ad9ec9ab",
        "name": "Home",
        "selfUri": "/api/v2/authorization/divisions/b4a5d15d-7294-44dc-a910-e370ad9ec9ab"
    },
    "enableManualAssignment": false,
    "enableTranscription": true,
    "id": "82b1a91a-a837-408f-becd-edac0f346ba5",
    "joinedMemberCount": 3,
    "mediaSettings": {
        "call": {
            "alertingTimeoutSeconds": 45,
            "serviceLevel": {
                "durationMs": 120000,
                "percentage": 0.8
            }
        },
        "callback": {
            "alertingTimeoutSeconds": 30,
            "autoDialDelaySeconds": 300,
            "autoEndDelaySeconds": 300,
            "enableAutoDialAndEnd": false,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "chat": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "email": {
            "alertingTimeoutSeconds": 300,
            "serviceLevel": {
                "durationMs": 86400000,
                "percentage": 0.8
            }
        },
        "message": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "workitem": {
            "alertingTimeoutSeconds": 60,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        }
    },
    "memberCount": 3,
    "modifiedBy": "52327b94-06c7-4cf6-855e-eb88cc4e18d3",
    "name": "AC Tier 3",
    "queueFlow": {
        "id": "c1db4dd3-d724-41e2-a1eb-e859ebfff2c7",
        "name": "BDR Queued Callback Flow",
        "selfUri": "/api/v2/flows/c1db4dd3-d724-41e2-a1eb-e859ebfff2c7"
    },
    "routingRules": [],
    "scoringMethod": "TimestampAndPriority",
    "selfUri": "/api/v2/routing/queues/82b1a91a-a837-408f-becd-edac0f346ba5",
    "skillEvaluationMethod": "BEST",
    "suppressInQueueCallRecording": false,
    "userMemberCount": 3,
    "whisperPrompt": {
        "id": "814389cb-dc0e-460a-826b-f4310e4dad20",
        "name": "MarketplaceSupportFacilityTransferWhisper",
        "selfUri": "/api/v2/architect/prompts/814389cb-dc0e-460a-826b-f4310e4dad20"
    }
}

schema_attributes:

{
    "_origin": "string",
    "active": "string",
    "acwSettings.timeoutMs": "string",
    "acwSettings.wrapupPrompt": "string",
    "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
    "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
    "agentOwnedRouting.maxOwnedCallbackHours": "string",
    "autoAnswerOnly": "string",
    "bullseye.rings": [
        {
            "actions.skillsToRemove": [
                {
                    "id": "string",
                    "name": "string",
                    "selfUri": "string"
                }
            ],
            "expansionCriteria": [
                {
                    "threshold": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "callingPartyName": "string",
    "callingPartyNumber": "string",
    "checkedInVersion.commitVersion": "string",
    "checkedInVersion.configurationUri": "string",
    "checkedInVersion.configurationVersion": "string",
    "checkedInVersion.dateCheckedIn": "string",
    "checkedInVersion.dateSaved": "string",
    "checkedInVersion.id": "string",
    "checkedInVersion.name": "string",
    "checkedInVersion.secure": "string",
    "checkedInVersion.selfUri": "string",
    "createdBy": "string",
    "currentOperation.actionName": "string",
    "currentOperation.actionStatus": "string",
    "currentOperation.complete": "string",
    "currentOperation.errorDetails": [
        "string"
    ],
    "currentOperation.id": "string",
    "currentOperation.user.id": "string",
    "currentOperation.user.name": "string",
    "currentOperation.user.organization.id": "string",
    "currentOperation.user.organization.name": "string",
    "currentOperation.user.organization.thirdPartyOrgName": "string",
    "currentOperation.user.selfUri": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "deleted": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "enableManualAssignment": "string",
    "enableTranscription": "string",
    "id": "string",
    "joinedMemberCount": "string",
    "lockedUser.id": "string",
    "lockedUser.name": "string",
    "lockedUser.selfUri": "string",
    "mediaSettings.call.alertingTimeoutSeconds": "string",
    "mediaSettings.call.serviceLevel.durationMs": "string",
    "mediaSettings.call.serviceLevel.percentage": "string",
    "mediaSettings.callback.alertingTimeoutSeconds": "string",
    "mediaSettings.callback.autoDialDelaySeconds": "string",
    "mediaSettings.callback.autoEndDelaySeconds": "string",
    "mediaSettings.callback.enableAutoDialAndEnd": "string",
    "mediaSettings.callback.serviceLevel.durationMs": "string",
    "mediaSettings.callback.serviceLevel.percentage": "string",
    "mediaSettings.chat.alertingTimeoutSeconds": "string",
    "mediaSettings.chat.serviceLevel.durationMs": "string",
    "mediaSettings.chat.serviceLevel.percentage": "string",
    "mediaSettings.email.alertingTimeoutSeconds": "string",
    "mediaSettings.email.serviceLevel.durationMs": "string",
    "mediaSettings.email.serviceLevel.percentage": "string",
    "mediaSettings.message.alertingTimeoutSeconds": "string",
    "mediaSettings.message.serviceLevel.durationMs": "string",
    "mediaSettings.message.serviceLevel.percentage": "string",
    "mediaSettings.workitem.alertingTimeoutSeconds": "string",
    "mediaSettings.workitem.serviceLevel.durationMs": "string",
    "mediaSettings.workitem.serviceLevel.percentage": "string",
    "memberCount": "string",
    "modifiedBy": "string",
    "name": "string",
    "outboundMessagingAddresses.smsAddress.id": "string",
    "outboundMessagingAddresses.smsAddress.name": "string",
    "outboundMessagingAddresses.smsAddress.selfUri": "string",
    "publishedVersion.commitVersion": "string",
    "publishedVersion.configurationUri": "string",
    "publishedVersion.configurationVersion": "string",
    "publishedVersion.createdBy.id": "string",
    "publishedVersion.createdBy.organization.id": "string",
    "publishedVersion.createdBy.organization.name": "string",
    "publishedVersion.createdBy.organization.thirdPartyOrgName": "string",
    "publishedVersion.createdBy.selfUri": "string",
    "publishedVersion.dateCheckedIn": "string",
    "publishedVersion.dateCreated": "string",
    "publishedVersion.dateSaved": "string",
    "publishedVersion.debug": "string",
    "publishedVersion.generationId": "string",
    "publishedVersion.id": "string",
    "publishedVersion.inputSchema._schema": "string",
    "publishedVersion.inputSchema.additionalProperties": "string",
    "publishedVersion.inputSchema.description": "string",
    "publishedVersion.inputSchema.title": "string",
    "publishedVersion.inputSchema.type": "string",
    "publishedVersion.name": "string",
    "publishedVersion.outputSchema._schema": "string",
    "publishedVersion.outputSchema.additionalProperties": "string",
    "publishedVersion.outputSchema.description": "string",
    "publishedVersion.outputSchema.title": "string",
    "publishedVersion.outputSchema.type": "string",
    "publishedVersion.secure": "string",
    "publishedVersion.selfUri": "string",
    "publishedVersion.supportedLanguages": [
        {
            "isDefault": "string",
            "language": "string"
        }
    ],
    "queueFlow.id": "string",
    "queueFlow.name": "string",
    "queueFlow.selfUri": "string",
    "routingRules": [
        "string"
    ],
    "savedVersion.commitVersion": "string",
    "savedVersion.configurationUri": "string",
    "savedVersion.configurationVersion": "string",
    "savedVersion.dateSaved": "string",
    "savedVersion.id": "string",
    "savedVersion.name": "string",
    "savedVersion.selfUri": "string",
    "scoringMethod": "string",
    "selfUri": "string",
    "skillEvaluationMethod": "string",
    "suppressInQueueCallRecording": "string",
    "system": "string",
    "type": "string",
    "userMemberCount": "string",
    "whisperPrompt.id": "string",
    "whisperPrompt.name": "string",
    "whisperPrompt.selfUri": "string"
}

schema_name_id: 2207
schema_scan_id: 6564808
updated: 2024-08-14 09:47:04

Version 4705880

created: 2024-05-14 03:37:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoDialAndEnd`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`scoringMethod`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`autoAnswerOnly`STRING,`enableTranscription`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`callingPartyNumber`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`enableManualAssignment`STRING,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`routingRules`array,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`: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-manual-genesys-dev/raw/queues/2024-05-14/1715675816'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-dev/raw/queues/2024-05-14/1715675816
id: 4705880
processed: 1

raw_data:

{
    "_origin": "2024-05-14T03:36:57Z|raw/queues/2024-05-13/1715675817/data.json.gz|airflow_genesys_dev",
    "acwSettings": {
        "timeoutMs": 90000,
        "wrapupPrompt": "MANDATORY_TIMEOUT"
    },
    "agentOwnedRouting": {
        "enableAgentOwnedCallbacks": false,
        "maxOwnedCallbackDelayHours": 2,
        "maxOwnedCallbackHours": 2
    },
    "autoAnswerOnly": true,
    "bullseye": {
        "rings": [
            {
                "actions": {
                    "skillsToRemove": [
                        {
                            "id": "154efaf3-c02b-4db1-a1cf-397ae3168f8f",
                            "name": "ESS Tech Support - Primary",
                            "selfUri": "/api/v2/routing/skills/154efaf3-c02b-4db1-a1cf-397ae3168f8f"
                        }
                    ]
                },
                "expansionCriteria": [
                    {
                        "threshold": 5.0,
                        "type": "TIMEOUT_SECONDS"
                    }
                ]
            }
        ]
    },
    "callingPartyNumber": "+1 ",
    "createdBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "dateCreated": "2024-03-13T20:33:32.710Z",
    "dateModified": "2024-04-08T13:48:29.207Z",
    "defaultScripts": {},
    "description": "Access control tier 3 support",
    "division": {
        "id": "b4a5d15d-7294-44dc-a910-e370ad9ec9ab",
        "name": "Home",
        "selfUri": "/api/v2/authorization/divisions/b4a5d15d-7294-44dc-a910-e370ad9ec9ab"
    },
    "enableManualAssignment": false,
    "enableTranscription": true,
    "id": "82b1a91a-a837-408f-becd-edac0f346ba5",
    "joinedMemberCount": 3,
    "mediaSettings": {
        "call": {
            "alertingTimeoutSeconds": 45,
            "serviceLevel": {
                "durationMs": 120000,
                "percentage": 0.8
            }
        },
        "callback": {
            "alertingTimeoutSeconds": 30,
            "autoDialDelaySeconds": 300,
            "autoEndDelaySeconds": 300,
            "enableAutoDialAndEnd": false,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "chat": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "email": {
            "alertingTimeoutSeconds": 300,
            "serviceLevel": {
                "durationMs": 86400000,
                "percentage": 0.8
            }
        },
        "message": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "workitem": {
            "alertingTimeoutSeconds": 60,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        }
    },
    "memberCount": 3,
    "modifiedBy": "52327b94-06c7-4cf6-855e-eb88cc4e18d3",
    "name": "AC Tier 3",
    "queueFlow": {
        "id": "c1db4dd3-d724-41e2-a1eb-e859ebfff2c7",
        "name": "BDR Queued Callback Flow",
        "selfUri": "/api/v2/flows/c1db4dd3-d724-41e2-a1eb-e859ebfff2c7"
    },
    "routingRules": [],
    "scoringMethod": "TimestampAndPriority",
    "selfUri": "/api/v2/routing/queues/82b1a91a-a837-408f-becd-edac0f346ba5",
    "skillEvaluationMethod": "BEST",
    "suppressInQueueCallRecording": false,
    "userMemberCount": 3,
    "whisperPrompt": {
        "id": "814389cb-dc0e-460a-826b-f4310e4dad20",
        "name": "MarketplaceSupportFacilityTransferWhisper",
        "selfUri": "/api/v2/architect/prompts/814389cb-dc0e-460a-826b-f4310e4dad20"
    }
}

schema_attributes:

{
    "_origin": "string",
    "active": "string",
    "acwSettings.timeoutMs": "string",
    "acwSettings.wrapupPrompt": "string",
    "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
    "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
    "agentOwnedRouting.maxOwnedCallbackHours": "string",
    "autoAnswerOnly": "string",
    "bullseye.rings": [
        {
            "actions.skillsToRemove": [
                {
                    "id": "string",
                    "name": "string",
                    "selfUri": "string"
                }
            ],
            "expansionCriteria": [
                {
                    "threshold": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "callingPartyName": "string",
    "callingPartyNumber": "string",
    "checkedInVersion.commitVersion": "string",
    "checkedInVersion.configurationUri": "string",
    "checkedInVersion.configurationVersion": "string",
    "checkedInVersion.dateCheckedIn": "string",
    "checkedInVersion.dateSaved": "string",
    "checkedInVersion.id": "string",
    "checkedInVersion.name": "string",
    "checkedInVersion.secure": "string",
    "checkedInVersion.selfUri": "string",
    "createdBy": "string",
    "currentOperation.actionName": "string",
    "currentOperation.actionStatus": "string",
    "currentOperation.complete": "string",
    "currentOperation.errorDetails": [
        "string"
    ],
    "currentOperation.id": "string",
    "currentOperation.user.id": "string",
    "currentOperation.user.name": "string",
    "currentOperation.user.organization.id": "string",
    "currentOperation.user.organization.name": "string",
    "currentOperation.user.organization.thirdPartyOrgName": "string",
    "currentOperation.user.selfUri": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "deleted": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "enableManualAssignment": "string",
    "enableTranscription": "string",
    "id": "string",
    "joinedMemberCount": "string",
    "lockedUser.id": "string",
    "lockedUser.name": "string",
    "lockedUser.selfUri": "string",
    "mediaSettings.call.alertingTimeoutSeconds": "string",
    "mediaSettings.call.serviceLevel.durationMs": "string",
    "mediaSettings.call.serviceLevel.percentage": "string",
    "mediaSettings.callback.alertingTimeoutSeconds": "string",
    "mediaSettings.callback.autoDialDelaySeconds": "string",
    "mediaSettings.callback.autoEndDelaySeconds": "string",
    "mediaSettings.callback.enableAutoDialAndEnd": "string",
    "mediaSettings.callback.serviceLevel.durationMs": "string",
    "mediaSettings.callback.serviceLevel.percentage": "string",
    "mediaSettings.chat.alertingTimeoutSeconds": "string",
    "mediaSettings.chat.serviceLevel.durationMs": "string",
    "mediaSettings.chat.serviceLevel.percentage": "string",
    "mediaSettings.email.alertingTimeoutSeconds": "string",
    "mediaSettings.email.serviceLevel.durationMs": "string",
    "mediaSettings.email.serviceLevel.percentage": "string",
    "mediaSettings.message.alertingTimeoutSeconds": "string",
    "mediaSettings.message.serviceLevel.durationMs": "string",
    "mediaSettings.message.serviceLevel.percentage": "string",
    "mediaSettings.workitem.alertingTimeoutSeconds": "string",
    "mediaSettings.workitem.serviceLevel.durationMs": "string",
    "mediaSettings.workitem.serviceLevel.percentage": "string",
    "memberCount": "string",
    "modifiedBy": "string",
    "name": "string",
    "outboundMessagingAddresses.smsAddress.id": "string",
    "outboundMessagingAddresses.smsAddress.name": "string",
    "outboundMessagingAddresses.smsAddress.selfUri": "string",
    "publishedVersion.commitVersion": "string",
    "publishedVersion.configurationUri": "string",
    "publishedVersion.configurationVersion": "string",
    "publishedVersion.createdBy.id": "string",
    "publishedVersion.createdBy.organization.id": "string",
    "publishedVersion.createdBy.organization.name": "string",
    "publishedVersion.createdBy.organization.thirdPartyOrgName": "string",
    "publishedVersion.createdBy.selfUri": "string",
    "publishedVersion.dateCheckedIn": "string",
    "publishedVersion.dateCreated": "string",
    "publishedVersion.dateSaved": "string",
    "publishedVersion.debug": "string",
    "publishedVersion.generationId": "string",
    "publishedVersion.id": "string",
    "publishedVersion.inputSchema._schema": "string",
    "publishedVersion.inputSchema.additionalProperties": "string",
    "publishedVersion.inputSchema.description": "string",
    "publishedVersion.inputSchema.title": "string",
    "publishedVersion.inputSchema.type": "string",
    "publishedVersion.name": "string",
    "publishedVersion.outputSchema._schema": "string",
    "publishedVersion.outputSchema.additionalProperties": "string",
    "publishedVersion.outputSchema.description": "string",
    "publishedVersion.outputSchema.title": "string",
    "publishedVersion.outputSchema.type": "string",
    "publishedVersion.secure": "string",
    "publishedVersion.selfUri": "string",
    "publishedVersion.supportedLanguages": [
        {
            "isDefault": "string",
            "language": "string"
        }
    ],
    "queueFlow.id": "string",
    "queueFlow.name": "string",
    "queueFlow.selfUri": "string",
    "routingRules": [
        "string"
    ],
    "savedVersion.commitVersion": "string",
    "savedVersion.configurationUri": "string",
    "savedVersion.configurationVersion": "string",
    "savedVersion.dateSaved": "string",
    "savedVersion.id": "string",
    "savedVersion.name": "string",
    "savedVersion.selfUri": "string",
    "scoringMethod": "string",
    "selfUri": "string",
    "skillEvaluationMethod": "string",
    "suppressInQueueCallRecording": "string",
    "system": "string",
    "type": "string",
    "userMemberCount": "string",
    "whisperPrompt.id": "string",
    "whisperPrompt.name": "string",
    "whisperPrompt.selfUri": "string"
}

schema_name_id: 2207
schema_scan_id: 6490559
updated: 2024-05-14 03:38:02

Version 4705694

created: 2024-05-13 12:48:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_queues`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoDialAndEnd`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`scoringMethod`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`autoAnswerOnly`STRING,`enableTranscription`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`callingPartyNumber`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`enableManualAssignment`STRING,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`routingRules`array,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`: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-manual-genesys-dev/raw/queues/2024-05-13/1715622304'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_queues"
]

hive_path: s3://sfdl-manual-genesys-dev/raw/queues/2024-05-13/1715622304
id: 4705694
processed: 1

raw_data:

{
    "_origin": "2024-05-13T12:45:04Z|raw/queues/2024-05-12/1715622304/data.json.gz|airflow_genesys_dev",
    "acwSettings": {
        "timeoutMs": 90000,
        "wrapupPrompt": "MANDATORY_TIMEOUT"
    },
    "agentOwnedRouting": {
        "enableAgentOwnedCallbacks": false,
        "maxOwnedCallbackDelayHours": 2,
        "maxOwnedCallbackHours": 2
    },
    "autoAnswerOnly": true,
    "bullseye": {
        "rings": [
            {
                "actions": {
                    "skillsToRemove": [
                        {
                            "id": "154efaf3-c02b-4db1-a1cf-397ae3168f8f",
                            "name": "ESS Tech Support - Primary",
                            "selfUri": "/api/v2/routing/skills/154efaf3-c02b-4db1-a1cf-397ae3168f8f"
                        }
                    ]
                },
                "expansionCriteria": [
                    {
                        "threshold": 5.0,
                        "type": "TIMEOUT_SECONDS"
                    }
                ]
            }
        ]
    },
    "callingPartyNumber": "+1 ",
    "createdBy": "98260109-1fb8-4c14-95b4-576ca18fa0c3",
    "dateCreated": "2024-03-13T20:33:32.710Z",
    "dateModified": "2024-04-08T13:48:29.207Z",
    "defaultScripts": {},
    "description": "Access control tier 3 support",
    "division": {
        "id": "b4a5d15d-7294-44dc-a910-e370ad9ec9ab",
        "name": "Home",
        "selfUri": "/api/v2/authorization/divisions/b4a5d15d-7294-44dc-a910-e370ad9ec9ab"
    },
    "enableManualAssignment": false,
    "enableTranscription": true,
    "id": "82b1a91a-a837-408f-becd-edac0f346ba5",
    "joinedMemberCount": 3,
    "mediaSettings": {
        "call": {
            "alertingTimeoutSeconds": 45,
            "serviceLevel": {
                "durationMs": 120000,
                "percentage": 0.8
            }
        },
        "callback": {
            "alertingTimeoutSeconds": 30,
            "autoDialDelaySeconds": 300,
            "autoEndDelaySeconds": 300,
            "enableAutoDialAndEnd": false,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "chat": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "email": {
            "alertingTimeoutSeconds": 300,
            "serviceLevel": {
                "durationMs": 86400000,
                "percentage": 0.8
            }
        },
        "message": {
            "alertingTimeoutSeconds": 30,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        },
        "workitem": {
            "alertingTimeoutSeconds": 60,
            "serviceLevel": {
                "durationMs": 20000,
                "percentage": 0.8
            }
        }
    },
    "memberCount": 3,
    "modifiedBy": "52327b94-06c7-4cf6-855e-eb88cc4e18d3",
    "name": "AC Tier 3",
    "queueFlow": {
        "id": "c1db4dd3-d724-41e2-a1eb-e859ebfff2c7",
        "name": "BDR Queued Callback Flow",
        "selfUri": "/api/v2/flows/c1db4dd3-d724-41e2-a1eb-e859ebfff2c7"
    },
    "routingRules": [],
    "scoringMethod": "TimestampAndPriority",
    "selfUri": "/api/v2/routing/queues/82b1a91a-a837-408f-becd-edac0f346ba5",
    "skillEvaluationMethod": "BEST",
    "suppressInQueueCallRecording": false,
    "userMemberCount": 3,
    "whisperPrompt": {
        "id": "814389cb-dc0e-460a-826b-f4310e4dad20",
        "name": "MarketplaceSupportFacilityTransferWhisper",
        "selfUri": "/api/v2/architect/prompts/814389cb-dc0e-460a-826b-f4310e4dad20"
    }
}

schema_attributes:

{
    "_origin": "string",
    "active": "string",
    "acwSettings.timeoutMs": "string",
    "acwSettings.wrapupPrompt": "string",
    "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
    "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
    "agentOwnedRouting.maxOwnedCallbackHours": "string",
    "autoAnswerOnly": "string",
    "bullseye.rings": [
        {
            "actions.skillsToRemove": [
                {
                    "id": "string",
                    "name": "string",
                    "selfUri": "string"
                }
            ],
            "expansionCriteria": [
                {
                    "threshold": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "callingPartyName": "string",
    "callingPartyNumber": "string",
    "checkedInVersion.commitVersion": "string",
    "checkedInVersion.configurationUri": "string",
    "checkedInVersion.configurationVersion": "string",
    "checkedInVersion.dateCheckedIn": "string",
    "checkedInVersion.dateSaved": "string",
    "checkedInVersion.id": "string",
    "checkedInVersion.name": "string",
    "checkedInVersion.secure": "string",
    "checkedInVersion.selfUri": "string",
    "createdBy": "string",
    "currentOperation.actionName": "string",
    "currentOperation.actionStatus": "string",
    "currentOperation.complete": "string",
    "currentOperation.errorDetails": [
        "string"
    ],
    "currentOperation.id": "string",
    "currentOperation.user.id": "string",
    "currentOperation.user.name": "string",
    "currentOperation.user.organization.id": "string",
    "currentOperation.user.organization.name": "string",
    "currentOperation.user.organization.thirdPartyOrgName": "string",
    "currentOperation.user.selfUri": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "deleted": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "enableManualAssignment": "string",
    "enableTranscription": "string",
    "id": "string",
    "joinedMemberCount": "string",
    "lockedUser.id": "string",
    "lockedUser.name": "string",
    "lockedUser.selfUri": "string",
    "mediaSettings.call.alertingTimeoutSeconds": "string",
    "mediaSettings.call.serviceLevel.durationMs": "string",
    "mediaSettings.call.serviceLevel.percentage": "string",
    "mediaSettings.callback.alertingTimeoutSeconds": "string",
    "mediaSettings.callback.autoDialDelaySeconds": "string",
    "mediaSettings.callback.autoEndDelaySeconds": "string",
    "mediaSettings.callback.enableAutoDialAndEnd": "string",
    "mediaSettings.callback.serviceLevel.durationMs": "string",
    "mediaSettings.callback.serviceLevel.percentage": "string",
    "mediaSettings.chat.alertingTimeoutSeconds": "string",
    "mediaSettings.chat.serviceLevel.durationMs": "string",
    "mediaSettings.chat.serviceLevel.percentage": "string",
    "mediaSettings.email.alertingTimeoutSeconds": "string",
    "mediaSettings.email.serviceLevel.durationMs": "string",
    "mediaSettings.email.serviceLevel.percentage": "string",
    "mediaSettings.message.alertingTimeoutSeconds": "string",
    "mediaSettings.message.serviceLevel.durationMs": "string",
    "mediaSettings.message.serviceLevel.percentage": "string",
    "mediaSettings.workitem.alertingTimeoutSeconds": "string",
    "mediaSettings.workitem.serviceLevel.durationMs": "string",
    "mediaSettings.workitem.serviceLevel.percentage": "string",
    "memberCount": "string",
    "modifiedBy": "string",
    "name": "string",
    "outboundMessagingAddresses.smsAddress.id": "string",
    "outboundMessagingAddresses.smsAddress.name": "string",
    "outboundMessagingAddresses.smsAddress.selfUri": "string",
    "publishedVersion.commitVersion": "string",
    "publishedVersion.configurationUri": "string",
    "publishedVersion.configurationVersion": "string",
    "publishedVersion.createdBy.id": "string",
    "publishedVersion.createdBy.organization.id": "string",
    "publishedVersion.createdBy.organization.name": "string",
    "publishedVersion.createdBy.organization.thirdPartyOrgName": "string",
    "publishedVersion.createdBy.selfUri": "string",
    "publishedVersion.dateCheckedIn": "string",
    "publishedVersion.dateCreated": "string",
    "publishedVersion.dateSaved": "string",
    "publishedVersion.debug": "string",
    "publishedVersion.generationId": "string",
    "publishedVersion.id": "string",
    "publishedVersion.inputSchema._schema": "string",
    "publishedVersion.inputSchema.additionalProperties": "string",
    "publishedVersion.inputSchema.description": "string",
    "publishedVersion.inputSchema.title": "string",
    "publishedVersion.inputSchema.type": "string",
    "publishedVersion.name": "string",
    "publishedVersion.outputSchema._schema": "string",
    "publishedVersion.outputSchema.additionalProperties": "string",
    "publishedVersion.outputSchema.description": "string",
    "publishedVersion.outputSchema.title": "string",
    "publishedVersion.outputSchema.type": "string",
    "publishedVersion.secure": "string",
    "publishedVersion.selfUri": "string",
    "publishedVersion.supportedLanguages": [
        {
            "isDefault": "string",
            "language": "string"
        }
    ],
    "queueFlow.id": "string",
    "queueFlow.name": "string",
    "queueFlow.selfUri": "string",
    "routingRules": [
        "string"
    ],
    "savedVersion.commitVersion": "string",
    "savedVersion.configurationUri": "string",
    "savedVersion.configurationVersion": "string",
    "savedVersion.dateSaved": "string",
    "savedVersion.id": "string",
    "savedVersion.name": "string",
    "savedVersion.selfUri": "string",
    "scoringMethod": "string",
    "selfUri": "string",
    "skillEvaluationMethod": "string",
    "suppressInQueueCallRecording": "string",
    "system": "string",
    "type": "string",
    "userMemberCount": "string",
    "whisperPrompt.id": "string",
    "whisperPrompt.name": "string",
    "whisperPrompt.selfUri": "string"
}

schema_name_id: 2207
schema_scan_id: 6489849
updated: 2024-05-13 12:48:29

Schema Scans: 3

Last at 2024-08-14 09:46:50

Scan 6564808
- duration: 0:00:14.055231
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6564808
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-dev",
        "hive_path": "s3://sfdl-manual-genesys-dev/raw/queues/2024-08-14/1723646710",
        "key": "raw/queues/2024-08-14/1723646710/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 2207
- start_time: 2024-08-14 09:46:50
- success: True
- trace_id: 15947154897387378673

Scan 6490559
- duration: 0:00:16.670978
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6490559
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-dev",
        "hive_path": "s3://sfdl-manual-genesys-dev/raw/queues/2024-05-14/1715675816",
        "key": "raw/queues/2024-05-14/1715675816/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 2207
- start_time: 2024-05-14 03:37:46
- success: True
- trace_id: 17891693178578278934

Scan 6489849
- duration: 0:00:14.344311
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6489849
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-dev",
        "hive_path": "s3://sfdl-manual-genesys-dev/raw/queues/2024-05-13/1715622304",
        "key": "raw/queues/2024-05-13/1715622304/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_queues",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 2207
- start_time: 2024-05-13 12:48:15
- success: True
- trace_id: 5661563024682257494

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "active": "string",
    "acwSettings.timeoutMs": "string",
    "acwSettings.wrapupPrompt": "string",
    "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
    "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
    "agentOwnedRouting.maxOwnedCallbackHours": "string",
    "autoAnswerOnly": "string",
    "bullseye.rings": [
        {
            "actions.skillsToRemove": [
                {
                    "id": "string",
                    "name": "string",
                    "selfUri": "string"
                }
            ],
            "expansionCriteria": [
                {
                    "threshold": "string",
                    "type": "string"
                }
            ]
        }
    ],
    "callingPartyName": "string",
    "callingPartyNumber": "string",
    "checkedInVersion.commitVersion": "string",
    "checkedInVersion.configurationUri": "string",
    "checkedInVersion.configurationVersion": "string",
    "checkedInVersion.dateCheckedIn": "string",
    "checkedInVersion.dateSaved": "string",
    "checkedInVersion.id": "string",
    "checkedInVersion.name": "string",
    "checkedInVersion.secure": "string",
    "checkedInVersion.selfUri": "string",
    "createdBy": "string",
    "currentOperation.actionName": "string",
    "currentOperation.actionStatus": "string",
    "currentOperation.complete": "string",
    "currentOperation.errorDetails": [
        "string"
    ],
    "currentOperation.id": "string",
    "currentOperation.user.id": "string",
    "currentOperation.user.name": "string",
    "currentOperation.user.organization.id": "string",
    "currentOperation.user.organization.name": "string",
    "currentOperation.user.organization.thirdPartyOrgName": "string",
    "currentOperation.user.selfUri": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "deleted": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "enableManualAssignment": "string",
    "enableTranscription": "string",
    "id": "string",
    "joinedMemberCount": "string",
    "lockedUser.id": "string",
    "lockedUser.name": "string",
    "lockedUser.selfUri": "string",
    "mediaSettings.call.alertingTimeoutSeconds": "string",
    "mediaSettings.call.serviceLevel.durationMs": "string",
    "mediaSettings.call.serviceLevel.percentage": "string",
    "mediaSettings.callback.alertingTimeoutSeconds": "string",
    "mediaSettings.callback.autoDialDelaySeconds": "string",
    "mediaSettings.callback.autoEndDelaySeconds": "string",
    "mediaSettings.callback.enableAutoDialAndEnd": "string",
    "mediaSettings.callback.serviceLevel.durationMs": "string",
    "mediaSettings.callback.serviceLevel.percentage": "string",
    "mediaSettings.chat.alertingTimeoutSeconds": "string",
    "mediaSettings.chat.serviceLevel.durationMs": "string",
    "mediaSettings.chat.serviceLevel.percentage": "string",
    "mediaSettings.email.alertingTimeoutSeconds": "string",
    "mediaSettings.email.serviceLevel.durationMs": "string",
    "mediaSettings.email.serviceLevel.percentage": "string",
    "mediaSettings.message.alertingTimeoutSeconds": "string",
    "mediaSettings.message.serviceLevel.durationMs": "string",
    "mediaSettings.message.serviceLevel.percentage": "string",
    "mediaSettings.workitem.alertingTimeoutSeconds": "string",
    "mediaSettings.workitem.serviceLevel.durationMs": "string",
    "mediaSettings.workitem.serviceLevel.percentage": "string",
    "memberCount": "string",
    "modifiedBy": "string",
    "name": "string",
    "outboundMessagingAddresses.smsAddress.id": "string",
    "outboundMessagingAddresses.smsAddress.name": "string",
    "outboundMessagingAddresses.smsAddress.selfUri": "string",
    "publishedVersion.commitVersion": "string",
    "publishedVersion.configurationUri": "string",
    "publishedVersion.configurationVersion": "string",
    "publishedVersion.createdBy.id": "string",
    "publishedVersion.createdBy.organization.id": "string",
    "publishedVersion.createdBy.organization.name": "string",
    "publishedVersion.createdBy.organization.thirdPartyOrgName": "string",
    "publishedVersion.createdBy.selfUri": "string",
    "publishedVersion.dateCheckedIn": "string",
    "publishedVersion.dateCreated": "string",
    "publishedVersion.dateSaved": "string",
    "publishedVersion.debug": "string",
    "publishedVersion.generationId": "string",
    "publishedVersion.id": "string",
    "publishedVersion.inputSchema._schema": "string",
    "publishedVersion.inputSchema.additionalProperties": "string",
    "publishedVersion.inputSchema.description": "string",
    "publishedVersion.inputSchema.title": "string",
    "publishedVersion.inputSchema.type": "string",
    "publishedVersion.name": "string",
    "publishedVersion.outputSchema._schema": "string",
    "publishedVersion.outputSchema.additionalProperties": "string",
    "publishedVersion.outputSchema.description": "string",
    "publishedVersion.outputSchema.title": "string",
    "publishedVersion.outputSchema.type": "string",
    "publishedVersion.secure": "string",
    "publishedVersion.selfUri": "string",
    "publishedVersion.supportedLanguages": [
        {
            "isDefault": "string",
            "language": "string"
        }
    ],
    "queueFlow.id": "string",
    "queueFlow.name": "string",
    "queueFlow.selfUri": "string",
    "routingRules": [
        "string"
    ],
    "savedVersion.commitVersion": "string",
    "savedVersion.configurationUri": "string",
    "savedVersion.configurationVersion": "string",
    "savedVersion.dateSaved": "string",
    "savedVersion.id": "string",
    "savedVersion.name": "string",
    "savedVersion.selfUri": "string",
    "scoringMethod": "string",
    "selfUri": "string",
    "skillEvaluationMethod": "string",
    "suppressInQueueCallRecording": "string",
    "system": "string",
    "type": "string",
    "userMemberCount": "string",
    "whisperPrompt.id": "string",
    "whisperPrompt.name": "string",
    "whisperPrompt.selfUri": "string"
}

created: 2024-08-14 09:46:53

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoDialAndEnd`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`scoringMethod`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`autoAnswerOnly`STRING,`enableTranscription`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`callingPartyNumber`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`enableManualAssignment`STRING,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`routingRules`array,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`: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-manual-genesys-dev/raw/queues/2024-08-14/1723646710'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_queues`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_manual.genesys_queues"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-03-07 11:49:12",
        "disabled": false,
        "format": "raw",
        "id": 2207,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_dev_manual",
            "table": "genesys_queues"
        },
        "type": "manual"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "active": "string",
            "acwSettings.timeoutMs": "string",
            "acwSettings.wrapupPrompt": "string",
            "agentOwnedRouting.enableAgentOwnedCallbacks": "string",
            "agentOwnedRouting.maxOwnedCallbackDelayHours": "string",
            "agentOwnedRouting.maxOwnedCallbackHours": "string",
            "autoAnswerOnly": "string",
            "bullseye.rings": [
                {
                    "actions.skillsToRemove": [
                        {
                            "id": "string",
                            "name": "string",
                            "selfUri": "string"
                        }
                    ],
                    "expansionCriteria": [
                        {
                            "threshold": "string",
                            "type": "string"
                        }
                    ]
                }
            ],
            "callingPartyName": "string",
            "callingPartyNumber": "string",
            "checkedInVersion.commitVersion": "string",
            "checkedInVersion.configurationUri": "string",
            "checkedInVersion.configurationVersion": "string",
            "checkedInVersion.dateCheckedIn": "string",
            "checkedInVersion.dateSaved": "string",
            "checkedInVersion.id": "string",
            "checkedInVersion.name": "string",
            "checkedInVersion.secure": "string",
            "checkedInVersion.selfUri": "string",
            "createdBy": "string",
            "currentOperation.actionName": "string",
            "currentOperation.actionStatus": "string",
            "currentOperation.complete": "string",
            "currentOperation.errorDetails": [
                "string"
            ],
            "currentOperation.id": "string",
            "currentOperation.user.id": "string",
            "currentOperation.user.name": "string",
            "currentOperation.user.organization.id": "string",
            "currentOperation.user.organization.name": "string",
            "currentOperation.user.organization.thirdPartyOrgName": "string",
            "currentOperation.user.selfUri": "string",
            "dateCreated": "string",
            "dateModified": "string",
            "deleted": "string",
            "description": "string",
            "division.id": "string",
            "division.name": "string",
            "division.selfUri": "string",
            "enableManualAssignment": "string",
            "enableTranscription": "string",
            "id": "string",
            "joinedMemberCount": "string",
            "lockedUser.id": "string",
            "lockedUser.name": "string",
            "lockedUser.selfUri": "string",
            "mediaSettings.call.alertingTimeoutSeconds": "string",
            "mediaSettings.call.serviceLevel.durationMs": "string",
            "mediaSettings.call.serviceLevel.percentage": "string",
            "mediaSettings.callback.alertingTimeoutSeconds": "string",
            "mediaSettings.callback.autoDialDelaySeconds": "string",
            "mediaSettings.callback.autoEndDelaySeconds": "string",
            "mediaSettings.callback.enableAutoDialAndEnd": "string",
            "mediaSettings.callback.serviceLevel.durationMs": "string",
            "mediaSettings.callback.serviceLevel.percentage": "string",
            "mediaSettings.chat.alertingTimeoutSeconds": "string",
            "mediaSettings.chat.serviceLevel.durationMs": "string",
            "mediaSettings.chat.serviceLevel.percentage": "string",
            "mediaSettings.email.alertingTimeoutSeconds": "string",
            "mediaSettings.email.serviceLevel.durationMs": "string",
            "mediaSettings.email.serviceLevel.percentage": "string",
            "mediaSettings.message.alertingTimeoutSeconds": "string",
            "mediaSettings.message.serviceLevel.durationMs": "string",
            "mediaSettings.message.serviceLevel.percentage": "string",
            "mediaSettings.workitem.alertingTimeoutSeconds": "string",
            "mediaSettings.workitem.serviceLevel.durationMs": "string",
            "mediaSettings.workitem.serviceLevel.percentage": "string",
            "memberCount": "string",
            "modifiedBy": "string",
            "name": "string",
            "outboundMessagingAddresses.smsAddress.id": "string",
            "outboundMessagingAddresses.smsAddress.name": "string",
            "outboundMessagingAddresses.smsAddress.selfUri": "string",
            "publishedVersion.commitVersion": "string",
            "publishedVersion.configurationUri": "string",
            "publishedVersion.configurationVersion": "string",
            "publishedVersion.createdBy.id": "string",
            "publishedVersion.createdBy.organization.id": "string",
            "publishedVersion.createdBy.organization.name": "string",
            "publishedVersion.createdBy.organization.thirdPartyOrgName": "string",
            "publishedVersion.createdBy.selfUri": "string",
            "publishedVersion.dateCheckedIn": "string",
            "publishedVersion.dateCreated": "string",
            "publishedVersion.dateSaved": "string",
            "publishedVersion.debug": "string",
            "publishedVersion.generationId": "string",
            "publishedVersion.id": "string",
            "publishedVersion.inputSchema._schema": "string",
            "publishedVersion.inputSchema.additionalProperties": "string",
            "publishedVersion.inputSchema.description": "string",
            "publishedVersion.inputSchema.title": "string",
            "publishedVersion.inputSchema.type": "string",
            "publishedVersion.name": "string",
            "publishedVersion.outputSchema._schema": "string",
            "publishedVersion.outputSchema.additionalProperties": "string",
            "publishedVersion.outputSchema.description": "string",
            "publishedVersion.outputSchema.title": "string",
            "publishedVersion.outputSchema.type": "string",
            "publishedVersion.secure": "string",
            "publishedVersion.selfUri": "string",
            "publishedVersion.supportedLanguages": [
                {
                    "isDefault": "string",
                    "language": "string"
                }
            ],
            "queueFlow.id": "string",
            "queueFlow.name": "string",
            "queueFlow.selfUri": "string",
            "routingRules": [
                "string"
            ],
            "savedVersion.commitVersion": "string",
            "savedVersion.configurationUri": "string",
            "savedVersion.configurationVersion": "string",
            "savedVersion.dateSaved": "string",
            "savedVersion.id": "string",
            "savedVersion.name": "string",
            "savedVersion.selfUri": "string",
            "scoringMethod": "string",
            "selfUri": "string",
            "skillEvaluationMethod": "string",
            "suppressInQueueCallRecording": "string",
            "system": "string",
            "type": "string",
            "userMemberCount": "string",
            "whisperPrompt.id": "string",
            "whisperPrompt.name": "string",
            "whisperPrompt.selfUri": "string"
        },
        "created": "2024-08-14 09:46:53",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_manual.genesys_queues`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`dateCreated`STRING,`dateModified`STRING,`modifiedBy`STRING,`createdBy`STRING,`memberCount`STRING,`userMemberCount`STRING,`joinedMemberCount`STRING,`mediaSettings`struct<`call`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`callback`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>,`enableAutoDialAndEnd`:STRING,`autoDialDelaySeconds`:STRING,`autoEndDelaySeconds`:STRING>,`chat`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`email`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`message`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>,`workitem`:struct<`alertingTimeoutSeconds`:STRING,`serviceLevel`:struct<`percentage`:STRING,`durationMs`:STRING>>>,`scoringMethod`STRING,`acwSettings`struct<`wrapupPrompt`:STRING,`timeoutMs`:STRING>,`skillEvaluationMethod`STRING,`autoAnswerOnly`STRING,`enableTranscription`STRING,`agentOwnedRouting`struct<`enableAgentOwnedCallbacks`:STRING,`maxOwnedCallbackHours`:STRING,`maxOwnedCallbackDelayHours`:STRING>,`suppressInQueueCallRecording`STRING,`selfUri`STRING,`_origin`STRING,`callingPartyNumber`STRING,`queueFlow`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`enableManualAssignment`STRING,`bullseye`struct<`rings`:array>,`actions`:struct<`skillsToRemove`:array>>>>>,`routingRules`array,`whisperPrompt`struct<`id`:STRING,`name`:STRING,`selfUri`: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-manual-genesys-dev/raw/queues/2024-08-14/1723646710'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_queues`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_manual.genesys_queues"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}