Schema Info

Schema Name: sfdl_prod_manual.genesys_flows

created: 2023-03-10 01:04:00
disabled: False
format: raw
id: 1521
is_partitioned: False
is_schema_datatyped: False

name:

{
    "database": "sfdl_prod_manual",
    "table": "genesys_flows"
}

type: manual

Schema Versions: 15

Version 1717500

created: 2026-04-17 00:55:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_flows`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`type`STRING,`active`STRING,`system`STRING,`deleted`STRING,`publishedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`debug`:STRING,`createdBy`:struct<`id`:STRING,`selfUri`:STRING>,`configurationUri`:STRING,`dateCreated`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`generationId`:STRING,`inputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING,`definitions`:struct<`archString`:struct<`archDataTypeId`:STRING,`oneOf`:array>>,`archInteger`:struct<`archDataTypeId`:STRING,`oneOf`:array>>>>,`outputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING>,`datePublished`:STRING,`supportedLanguages`:array>,`selfUri`:STRING>,`checkedInVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`configurationUri`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`selfUri`:STRING>,`currentOperation`struct<`id`:STRING,`complete`:STRING,`user`:struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`errorDetails`:array>,`actionName`:STRING,`actionStatus`:STRING,`errorMessage`:STRING,`errorCode`:STRING,`errorMessageParams`:struct<`name`:STRING,`count`:STRING>>,`selfUri`STRING,`_origin`STRING,`lockedUser`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`savedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`configurationUri`:STRING,`selfUri`:STRING,`dateSaved`: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-prod/raw/flows/2026-04-17/1776405284'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_flows"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/flows/2026-04-17/1776405284
id: 1717500
processed: 1

raw_data:

{
    "_origin": "2026-04-17T00:54:49Z|raw/flows/2026-04-16/1776405289/data.json.gz|airflow_genesys_prod",
    "active": true,
    "checkedInVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "dateCheckedIn": 1718894027207,
        "dateSaved": 1718894025686,
        "id": "7.0",
        "name": "7.0",
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0"
    },
    "currentOperation": {
        "actionName": "VALIDATE",
        "actionStatus": "SUCCESS",
        "complete": true,
        "errorCode": "ARCHITECT_FLOW_CANNOT_DELETE_USED_IN_EMERGENCY_GROUPS",
        "errorDetails": [
            {
                "entityId": "1fc453f0-687e-4318-a097-8499a6ea8204",
                "entityName": "Newbook AU Monday Meeting",
                "errorCode": "ARCHITECT_RESOURCE_IS_USED_BY_ANOTHER_RESOURCE"
            }
        ],
        "errorMessage": "Flow 'Test-Newbook AU Monday Meeting Emergency Flow' cannot be deleted due to being used by 1 emergency group(s).",
        "errorMessageParams": {
            "count": "1",
            "name": "Test-Newbook AU Monday Meeting Emergency Flow"
        },
        "id": "54b3d5dd-edd0-41c3-a9d0-319e50003c27",
        "user": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "name": "Pierre LeFebvre",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        }
    },
    "deleted": false,
    "description": "This flow provides handling for calls waiting in a queue.",
    "division": {
        "id": "fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0",
        "name": "TOG Marine",
        "selfUri": "/api/v2/authorization/divisions/fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0"
    },
    "id": "037f2416-0bfc-4172-afe1-18a8989cae7e",
    "lockedUser": {
        "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
        "name": "Pierre LeFebvre",
        "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
    },
    "name": "Default In-Queue Flow",
    "publishedVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "createdBy": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        },
        "dateCheckedIn": 1718894027207,
        "dateCreated": 1718894027199,
        "datePublished": "2024-06-20T14:33:47.340Z",
        "dateSaved": 1718894025686,
        "debug": false,
        "generationId": "b51a6afd-912e-4562-b635-b1ec1175c487",
        "id": "7.0",
        "inputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "definitions": {
                "archInteger": {
                    "archDataTypeId": "int",
                    "oneOf": [
                        {
                            "description": "A NOT_SET Integer value.",
                            "type": "null"
                        },
                        {
                            "description": "An integral numeric value.  Examples: -3, 0, 1736",
                            "maximum": 999999999999999,
                            "minimum": -999999999999999,
                            "type": "integer"
                        },
                        {
                            "description": "A string representation of an integral numeric value.  Examples: \"157\", \"-999999999999999\"",
                            "maxLength": 16,
                            "minLength": 1,
                            "type": "string"
                        }
                    ]
                },
                "archString": {
                    "archDataTypeId": "str",
                    "oneOf": [
                        {
                            "description": "A NOT_SET String value.",
                            "type": "null"
                        },
                        {
                            "description": "A character string.  Examples: \"\", \"Hello\", \"Just say \\\"No!\\\"\"",
                            "maxLength": 32000,
                            "type": "string"
                        }
                    ]
                }
            },
            "description": "Schema defining flow input parameters.  Property names map to flow scoped variables marked as a flow input.  If you do not supply a property value for an input variable, the variable value will be set to the initial value configured on it in the flow at flow startup.",
            "properties": {},
            "title": "Flow input schema",
            "type": "object"
        },
        "name": "7.0",
        "outputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "description": "Schema defining flow output parameters.  Property names map to flow scoped variables marked as a flow output.",
            "properties": {},
            "title": "Flow output schema",
            "type": "object"
        },
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0",
        "supportedLanguages": [
            {
                "isDefault": true,
                "language": "en-us"
            }
        ]
    },
    "savedVersion": {
        "commitVersion": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "configurationUri": "/api/v2/flows/0b62eb4f-a56f-4183-93cd-42a210c96396/versions/saved_version_372d2431-c4eb-4005-909b-535b64181df6/configuration",
        "configurationVersion": "2.0",
        "dateSaved": 1733410354061,
        "id": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "name": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "selfUri": "/api/v2/flows/037f2416-0bfc-4172-afe1-18a8989cae7e/versions/saved_version_f5bf3ff1-807b-43e3-88c0-c2bc907a3c03"
    },
    "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a",
    "system": true,
    "type": "INQUEUECALL"
}

schema_attributes:

{
    "_origin": "string",
    "active": "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",
    "currentOperation.actionName": "string",
    "currentOperation.actionStatus": "string",
    "currentOperation.complete": "string",
    "currentOperation.errorCode": "string",
    "currentOperation.errorDetails": [
        {
            "entityId": "string",
            "entityName": "string",
            "errorCode": "string"
        }
    ],
    "currentOperation.errorMessage": "string",
    "currentOperation.errorMessageParams.count": "string",
    "currentOperation.errorMessageParams.name": "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",
    "deleted": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "lockedUser.id": "string",
    "lockedUser.name": "string",
    "lockedUser.selfUri": "string",
    "name": "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.datePublished": "string",
    "publishedVersion.dateSaved": "string",
    "publishedVersion.debug": "string",
    "publishedVersion.generationId": "string",
    "publishedVersion.id": "string",
    "publishedVersion.inputSchema._schema": "string",
    "publishedVersion.inputSchema.additionalProperties": "string",
    "publishedVersion.inputSchema.definitions.archInteger.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archInteger.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "maximum": "string",
            "minLength": "string",
            "minimum": "string",
            "type": "string"
        }
    ],
    "publishedVersion.inputSchema.definitions.archString.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archString.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "type": "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"
        }
    ],
    "savedVersion.commitVersion": "string",
    "savedVersion.configurationUri": "string",
    "savedVersion.configurationVersion": "string",
    "savedVersion.dateSaved": "string",
    "savedVersion.id": "string",
    "savedVersion.name": "string",
    "savedVersion.selfUri": "string",
    "selfUri": "string",
    "system": "string",
    "type": "string"
}

schema_name_id: 1521
schema_scan_id: 162163977
updated: 2026-04-17 00:55:36

Version 1716259

created: 2026-04-16 00:57:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_flows`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`type`STRING,`active`STRING,`system`STRING,`deleted`STRING,`publishedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`debug`:STRING,`createdBy`:struct<`id`:STRING,`selfUri`:STRING>,`configurationUri`:STRING,`dateCreated`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`generationId`:STRING,`inputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING,`definitions`:struct<`archString`:struct<`archDataTypeId`:STRING,`oneOf`:array>>,`archInteger`:struct<`archDataTypeId`:STRING,`oneOf`:array>>>>,`outputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING>,`datePublished`:STRING,`supportedLanguages`:array>,`selfUri`:STRING>,`checkedInVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`configurationUri`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`selfUri`:STRING>,`currentOperation`struct<`id`:STRING,`complete`:STRING,`user`:struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`errorDetails`:array>,`actionName`:STRING,`actionStatus`:STRING,`errorMessage`:STRING,`errorCode`:STRING,`errorMessageParams`:struct<`name`:STRING,`count`:STRING>>,`selfUri`STRING,`_origin`STRING,`lockedUser`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`savedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`configurationUri`:STRING,`selfUri`:STRING,`dateSaved`: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-prod/raw/flows/2026-04-16/1776319037'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_flows"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/flows/2026-04-16/1776319037
id: 1716259
processed: 1

raw_data:

{
    "_origin": "2026-04-16T00:57:21Z|raw/flows/2026-04-15/1776319041/data.json.gz|airflow_genesys_prod",
    "active": true,
    "checkedInVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "dateCheckedIn": 1718894027207,
        "dateSaved": 1718894025686,
        "id": "7.0",
        "name": "7.0",
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0"
    },
    "currentOperation": {
        "actionName": "VALIDATE",
        "actionStatus": "SUCCESS",
        "complete": true,
        "errorCode": "ARCHITECT_FLOW_CANNOT_DELETE_USED_IN_EMERGENCY_GROUPS",
        "errorDetails": [
            {
                "entityId": "1fc453f0-687e-4318-a097-8499a6ea8204",
                "entityName": "Newbook AU Monday Meeting",
                "errorCode": "ARCHITECT_RESOURCE_IS_USED_BY_ANOTHER_RESOURCE"
            }
        ],
        "errorMessage": "Flow 'Test-Newbook AU Monday Meeting Emergency Flow' cannot be deleted due to being used by 1 emergency group(s).",
        "errorMessageParams": {
            "count": "1",
            "name": "Test-Newbook AU Monday Meeting Emergency Flow"
        },
        "id": "54b3d5dd-edd0-41c3-a9d0-319e50003c27",
        "user": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "name": "Pierre LeFebvre",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        }
    },
    "deleted": false,
    "description": "This flow provides handling for calls waiting in a queue.",
    "division": {
        "id": "fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0",
        "name": "TOG Marine",
        "selfUri": "/api/v2/authorization/divisions/fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0"
    },
    "id": "037f2416-0bfc-4172-afe1-18a8989cae7e",
    "lockedUser": {
        "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
        "name": "Pierre LeFebvre",
        "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
    },
    "name": "Default In-Queue Flow",
    "publishedVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "createdBy": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        },
        "dateCheckedIn": 1718894027207,
        "dateCreated": 1718894027199,
        "datePublished": "2024-06-20T14:33:47.340Z",
        "dateSaved": 1718894025686,
        "debug": false,
        "generationId": "b51a6afd-912e-4562-b635-b1ec1175c487",
        "id": "7.0",
        "inputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "definitions": {
                "archInteger": {
                    "archDataTypeId": "int",
                    "oneOf": [
                        {
                            "description": "A NOT_SET Integer value.",
                            "type": "null"
                        },
                        {
                            "description": "An integral numeric value.  Examples: -3, 0, 1736",
                            "maximum": 999999999999999,
                            "minimum": -999999999999999,
                            "type": "integer"
                        },
                        {
                            "description": "A string representation of an integral numeric value.  Examples: \"157\", \"-999999999999999\"",
                            "maxLength": 16,
                            "minLength": 1,
                            "type": "string"
                        }
                    ]
                },
                "archString": {
                    "archDataTypeId": "str",
                    "oneOf": [
                        {
                            "description": "A NOT_SET String value.",
                            "type": "null"
                        },
                        {
                            "description": "A character string.  Examples: \"\", \"Hello\", \"Just say \\\"No!\\\"\"",
                            "maxLength": 32000,
                            "type": "string"
                        }
                    ]
                }
            },
            "description": "Schema defining flow input parameters.  Property names map to flow scoped variables marked as a flow input.  If you do not supply a property value for an input variable, the variable value will be set to the initial value configured on it in the flow at flow startup.",
            "properties": {},
            "title": "Flow input schema",
            "type": "object"
        },
        "name": "7.0",
        "outputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "description": "Schema defining flow output parameters.  Property names map to flow scoped variables marked as a flow output.",
            "properties": {},
            "title": "Flow output schema",
            "type": "object"
        },
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0",
        "supportedLanguages": [
            {
                "isDefault": true,
                "language": "en-us"
            }
        ]
    },
    "savedVersion": {
        "commitVersion": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "configurationUri": "/api/v2/flows/0b62eb4f-a56f-4183-93cd-42a210c96396/versions/saved_version_372d2431-c4eb-4005-909b-535b64181df6/configuration",
        "configurationVersion": "2.0",
        "dateSaved": 1733410354061,
        "id": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "name": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "selfUri": "/api/v2/flows/037f2416-0bfc-4172-afe1-18a8989cae7e/versions/saved_version_f5bf3ff1-807b-43e3-88c0-c2bc907a3c03"
    },
    "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a",
    "system": true,
    "type": "INQUEUECALL"
}

schema_attributes:

{
    "_origin": "string",
    "active": "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",
    "currentOperation.actionName": "string",
    "currentOperation.actionStatus": "string",
    "currentOperation.complete": "string",
    "currentOperation.errorCode": "string",
    "currentOperation.errorDetails": [
        {
            "entityId": "string",
            "entityName": "string",
            "errorCode": "string"
        }
    ],
    "currentOperation.errorMessage": "string",
    "currentOperation.errorMessageParams.count": "string",
    "currentOperation.errorMessageParams.name": "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",
    "deleted": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "lockedUser.id": "string",
    "lockedUser.name": "string",
    "lockedUser.selfUri": "string",
    "name": "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.datePublished": "string",
    "publishedVersion.dateSaved": "string",
    "publishedVersion.debug": "string",
    "publishedVersion.generationId": "string",
    "publishedVersion.id": "string",
    "publishedVersion.inputSchema._schema": "string",
    "publishedVersion.inputSchema.additionalProperties": "string",
    "publishedVersion.inputSchema.definitions.archInteger.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archInteger.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "maximum": "string",
            "minLength": "string",
            "minimum": "string",
            "type": "string"
        }
    ],
    "publishedVersion.inputSchema.definitions.archString.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archString.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "type": "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"
        }
    ],
    "savedVersion.commitVersion": "string",
    "savedVersion.configurationUri": "string",
    "savedVersion.configurationVersion": "string",
    "savedVersion.dateSaved": "string",
    "savedVersion.id": "string",
    "savedVersion.name": "string",
    "savedVersion.selfUri": "string",
    "selfUri": "string",
    "system": "string",
    "type": "string"
}

schema_name_id: 1521
schema_scan_id: 162108425
updated: 2026-04-16 00:58:03

Version 1715063

created: 2026-04-15 00:58:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_flows`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`type`STRING,`active`STRING,`system`STRING,`deleted`STRING,`publishedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`debug`:STRING,`createdBy`:struct<`id`:STRING,`selfUri`:STRING>,`configurationUri`:STRING,`dateCreated`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`generationId`:STRING,`inputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING,`definitions`:struct<`archString`:struct<`archDataTypeId`:STRING,`oneOf`:array>>,`archInteger`:struct<`archDataTypeId`:STRING,`oneOf`:array>>>>,`outputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING>,`datePublished`:STRING,`supportedLanguages`:array>,`selfUri`:STRING>,`checkedInVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`configurationUri`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`selfUri`:STRING>,`currentOperation`struct<`id`:STRING,`complete`:STRING,`user`:struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`errorDetails`:array>,`actionName`:STRING,`actionStatus`:STRING,`errorMessage`:STRING,`errorCode`:STRING,`errorMessageParams`:struct<`name`:STRING,`count`:STRING>>,`selfUri`STRING,`_origin`STRING,`lockedUser`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`savedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`configurationUri`:STRING,`selfUri`:STRING,`dateSaved`: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-prod/raw/flows/2026-04-15/1776232698'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_flows"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/flows/2026-04-15/1776232698
id: 1715063
processed: 1

raw_data:

{
    "_origin": "2026-04-15T00:58:22Z|raw/flows/2026-04-14/1776232702/data.json.gz|airflow_genesys_prod",
    "active": true,
    "checkedInVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "dateCheckedIn": 1718894027207,
        "dateSaved": 1718894025686,
        "id": "7.0",
        "name": "7.0",
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0"
    },
    "currentOperation": {
        "actionName": "VALIDATE",
        "actionStatus": "SUCCESS",
        "complete": true,
        "errorCode": "ARCHITECT_FLOW_CANNOT_DELETE_USED_IN_EMERGENCY_GROUPS",
        "errorDetails": [
            {
                "entityId": "1fc453f0-687e-4318-a097-8499a6ea8204",
                "entityName": "Newbook AU Monday Meeting",
                "errorCode": "ARCHITECT_RESOURCE_IS_USED_BY_ANOTHER_RESOURCE"
            }
        ],
        "errorMessage": "Flow 'Test-Newbook AU Monday Meeting Emergency Flow' cannot be deleted due to being used by 1 emergency group(s).",
        "errorMessageParams": {
            "count": "1",
            "name": "Test-Newbook AU Monday Meeting Emergency Flow"
        },
        "id": "54b3d5dd-edd0-41c3-a9d0-319e50003c27",
        "user": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "name": "Pierre LeFebvre",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        }
    },
    "deleted": false,
    "description": "This flow provides handling for calls waiting in a queue.",
    "division": {
        "id": "fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0",
        "name": "TOG Marine",
        "selfUri": "/api/v2/authorization/divisions/fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0"
    },
    "id": "037f2416-0bfc-4172-afe1-18a8989cae7e",
    "lockedUser": {
        "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
        "name": "Pierre LeFebvre",
        "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
    },
    "name": "Default In-Queue Flow",
    "publishedVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "createdBy": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        },
        "dateCheckedIn": 1718894027207,
        "dateCreated": 1718894027199,
        "datePublished": "2024-06-20T14:33:47.340Z",
        "dateSaved": 1718894025686,
        "debug": false,
        "generationId": "b51a6afd-912e-4562-b635-b1ec1175c487",
        "id": "7.0",
        "inputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "definitions": {
                "archInteger": {
                    "archDataTypeId": "int",
                    "oneOf": [
                        {
                            "description": "A NOT_SET Integer value.",
                            "type": "null"
                        },
                        {
                            "description": "An integral numeric value.  Examples: -3, 0, 1736",
                            "maximum": 999999999999999,
                            "minimum": -999999999999999,
                            "type": "integer"
                        },
                        {
                            "description": "A string representation of an integral numeric value.  Examples: \"157\", \"-999999999999999\"",
                            "maxLength": 16,
                            "minLength": 1,
                            "type": "string"
                        }
                    ]
                },
                "archString": {
                    "archDataTypeId": "str",
                    "oneOf": [
                        {
                            "description": "A NOT_SET String value.",
                            "type": "null"
                        },
                        {
                            "description": "A character string.  Examples: \"\", \"Hello\", \"Just say \\\"No!\\\"\"",
                            "maxLength": 32000,
                            "type": "string"
                        }
                    ]
                }
            },
            "description": "Schema defining flow input parameters.  Property names map to flow scoped variables marked as a flow input.  If you do not supply a property value for an input variable, the variable value will be set to the initial value configured on it in the flow at flow startup.",
            "properties": {},
            "title": "Flow input schema",
            "type": "object"
        },
        "name": "7.0",
        "outputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "description": "Schema defining flow output parameters.  Property names map to flow scoped variables marked as a flow output.",
            "properties": {},
            "title": "Flow output schema",
            "type": "object"
        },
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0",
        "supportedLanguages": [
            {
                "isDefault": true,
                "language": "en-us"
            }
        ]
    },
    "savedVersion": {
        "commitVersion": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "configurationUri": "/api/v2/flows/0b62eb4f-a56f-4183-93cd-42a210c96396/versions/saved_version_372d2431-c4eb-4005-909b-535b64181df6/configuration",
        "configurationVersion": "2.0",
        "dateSaved": 1733410354061,
        "id": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "name": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "selfUri": "/api/v2/flows/037f2416-0bfc-4172-afe1-18a8989cae7e/versions/saved_version_f5bf3ff1-807b-43e3-88c0-c2bc907a3c03"
    },
    "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a",
    "system": true,
    "type": "INQUEUECALL"
}

schema_attributes:

{
    "_origin": "string",
    "active": "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",
    "currentOperation.actionName": "string",
    "currentOperation.actionStatus": "string",
    "currentOperation.complete": "string",
    "currentOperation.errorCode": "string",
    "currentOperation.errorDetails": [
        {
            "entityId": "string",
            "entityName": "string",
            "errorCode": "string"
        }
    ],
    "currentOperation.errorMessage": "string",
    "currentOperation.errorMessageParams.count": "string",
    "currentOperation.errorMessageParams.name": "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",
    "deleted": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "lockedUser.id": "string",
    "lockedUser.name": "string",
    "lockedUser.selfUri": "string",
    "name": "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.datePublished": "string",
    "publishedVersion.dateSaved": "string",
    "publishedVersion.debug": "string",
    "publishedVersion.generationId": "string",
    "publishedVersion.id": "string",
    "publishedVersion.inputSchema._schema": "string",
    "publishedVersion.inputSchema.additionalProperties": "string",
    "publishedVersion.inputSchema.definitions.archInteger.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archInteger.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "maximum": "string",
            "minLength": "string",
            "minimum": "string",
            "type": "string"
        }
    ],
    "publishedVersion.inputSchema.definitions.archString.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archString.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "type": "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"
        }
    ],
    "savedVersion.commitVersion": "string",
    "savedVersion.configurationUri": "string",
    "savedVersion.configurationVersion": "string",
    "savedVersion.dateSaved": "string",
    "savedVersion.id": "string",
    "savedVersion.name": "string",
    "savedVersion.selfUri": "string",
    "selfUri": "string",
    "system": "string",
    "type": "string"
}

schema_name_id: 1521
schema_scan_id: 162052806
updated: 2026-04-15 00:59:09

Version 1713885

created: 2026-04-14 01:02:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_flows`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`type`STRING,`active`STRING,`system`STRING,`deleted`STRING,`publishedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`debug`:STRING,`createdBy`:struct<`id`:STRING,`selfUri`:STRING>,`configurationUri`:STRING,`dateCreated`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`generationId`:STRING,`inputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING,`definitions`:struct<`archString`:struct<`archDataTypeId`:STRING,`oneOf`:array>>,`archInteger`:struct<`archDataTypeId`:STRING,`oneOf`:array>>>>,`outputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING>,`datePublished`:STRING,`supportedLanguages`:array>,`selfUri`:STRING>,`checkedInVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`configurationUri`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`selfUri`:STRING>,`currentOperation`struct<`id`:STRING,`complete`:STRING,`user`:struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`errorDetails`:array>,`actionName`:STRING,`actionStatus`:STRING,`errorMessage`:STRING,`errorCode`:STRING,`errorMessageParams`:struct<`name`:STRING,`count`:STRING>>,`selfUri`STRING,`_origin`STRING,`lockedUser`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`savedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`configurationUri`:STRING,`selfUri`:STRING,`dateSaved`: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-prod/raw/flows/2026-04-14/1776146460'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_flows"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/flows/2026-04-14/1776146460
id: 1713885
processed: 1

raw_data:

{
    "_origin": "2026-04-14T01:01:04Z|raw/flows/2026-04-13/1776146464/data.json.gz|airflow_genesys_prod",
    "active": true,
    "checkedInVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "dateCheckedIn": 1718894027207,
        "dateSaved": 1718894025686,
        "id": "7.0",
        "name": "7.0",
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0"
    },
    "currentOperation": {
        "actionName": "VALIDATE",
        "actionStatus": "SUCCESS",
        "complete": true,
        "errorCode": "ARCHITECT_FLOW_CANNOT_DELETE_USED_IN_EMERGENCY_GROUPS",
        "errorDetails": [
            {
                "entityId": "1fc453f0-687e-4318-a097-8499a6ea8204",
                "entityName": "Newbook AU Monday Meeting",
                "errorCode": "ARCHITECT_RESOURCE_IS_USED_BY_ANOTHER_RESOURCE"
            }
        ],
        "errorMessage": "Flow 'Test-Newbook AU Monday Meeting Emergency Flow' cannot be deleted due to being used by 1 emergency group(s).",
        "errorMessageParams": {
            "count": "1",
            "name": "Test-Newbook AU Monday Meeting Emergency Flow"
        },
        "id": "54b3d5dd-edd0-41c3-a9d0-319e50003c27",
        "user": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "name": "Pierre LeFebvre",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        }
    },
    "deleted": false,
    "description": "This flow provides handling for calls waiting in a queue.",
    "division": {
        "id": "fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0",
        "name": "TOG Marine",
        "selfUri": "/api/v2/authorization/divisions/fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0"
    },
    "id": "037f2416-0bfc-4172-afe1-18a8989cae7e",
    "lockedUser": {
        "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
        "name": "Pierre LeFebvre",
        "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
    },
    "name": "Default In-Queue Flow",
    "publishedVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "createdBy": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        },
        "dateCheckedIn": 1718894027207,
        "dateCreated": 1718894027199,
        "datePublished": "2024-06-20T14:33:47.340Z",
        "dateSaved": 1718894025686,
        "debug": false,
        "generationId": "b51a6afd-912e-4562-b635-b1ec1175c487",
        "id": "7.0",
        "inputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "definitions": {
                "archInteger": {
                    "archDataTypeId": "int",
                    "oneOf": [
                        {
                            "description": "A NOT_SET Integer value.",
                            "type": "null"
                        },
                        {
                            "description": "An integral numeric value.  Examples: -3, 0, 1736",
                            "maximum": 999999999999999,
                            "minimum": -999999999999999,
                            "type": "integer"
                        },
                        {
                            "description": "A string representation of an integral numeric value.  Examples: \"157\", \"-999999999999999\"",
                            "maxLength": 16,
                            "minLength": 1,
                            "type": "string"
                        }
                    ]
                },
                "archString": {
                    "archDataTypeId": "str",
                    "oneOf": [
                        {
                            "description": "A NOT_SET String value.",
                            "type": "null"
                        },
                        {
                            "description": "A character string.  Examples: \"\", \"Hello\", \"Just say \\\"No!\\\"\"",
                            "maxLength": 32000,
                            "type": "string"
                        }
                    ]
                }
            },
            "description": "Schema defining flow input parameters.  Property names map to flow scoped variables marked as a flow input.  If you do not supply a property value for an input variable, the variable value will be set to the initial value configured on it in the flow at flow startup.",
            "properties": {},
            "title": "Flow input schema",
            "type": "object"
        },
        "name": "7.0",
        "outputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "description": "Schema defining flow output parameters.  Property names map to flow scoped variables marked as a flow output.",
            "properties": {},
            "title": "Flow output schema",
            "type": "object"
        },
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0",
        "supportedLanguages": [
            {
                "isDefault": true,
                "language": "en-us"
            }
        ]
    },
    "savedVersion": {
        "commitVersion": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "configurationUri": "/api/v2/flows/0b62eb4f-a56f-4183-93cd-42a210c96396/versions/saved_version_372d2431-c4eb-4005-909b-535b64181df6/configuration",
        "configurationVersion": "2.0",
        "dateSaved": 1733410354061,
        "id": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "name": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "selfUri": "/api/v2/flows/037f2416-0bfc-4172-afe1-18a8989cae7e/versions/saved_version_f5bf3ff1-807b-43e3-88c0-c2bc907a3c03"
    },
    "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a",
    "system": true,
    "type": "INQUEUECALL"
}

schema_attributes:

{
    "_origin": "string",
    "active": "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",
    "currentOperation.actionName": "string",
    "currentOperation.actionStatus": "string",
    "currentOperation.complete": "string",
    "currentOperation.errorCode": "string",
    "currentOperation.errorDetails": [
        {
            "entityId": "string",
            "entityName": "string",
            "errorCode": "string"
        }
    ],
    "currentOperation.errorMessage": "string",
    "currentOperation.errorMessageParams.count": "string",
    "currentOperation.errorMessageParams.name": "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",
    "deleted": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "lockedUser.id": "string",
    "lockedUser.name": "string",
    "lockedUser.selfUri": "string",
    "name": "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.datePublished": "string",
    "publishedVersion.dateSaved": "string",
    "publishedVersion.debug": "string",
    "publishedVersion.generationId": "string",
    "publishedVersion.id": "string",
    "publishedVersion.inputSchema._schema": "string",
    "publishedVersion.inputSchema.additionalProperties": "string",
    "publishedVersion.inputSchema.definitions.archInteger.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archInteger.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "maximum": "string",
            "minLength": "string",
            "minimum": "string",
            "type": "string"
        }
    ],
    "publishedVersion.inputSchema.definitions.archString.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archString.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "type": "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"
        }
    ],
    "savedVersion.commitVersion": "string",
    "savedVersion.configurationUri": "string",
    "savedVersion.configurationVersion": "string",
    "savedVersion.dateSaved": "string",
    "savedVersion.id": "string",
    "savedVersion.name": "string",
    "savedVersion.selfUri": "string",
    "selfUri": "string",
    "system": "string",
    "type": "string"
}

schema_name_id: 1521
schema_scan_id: 161997602
updated: 2026-04-14 01:03:08

Version 1712644

created: 2026-04-13 01:04:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_flows`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`type`STRING,`active`STRING,`system`STRING,`deleted`STRING,`publishedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`debug`:STRING,`createdBy`:struct<`id`:STRING,`selfUri`:STRING>,`configurationUri`:STRING,`dateCreated`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`generationId`:STRING,`inputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING,`definitions`:struct<`archString`:struct<`archDataTypeId`:STRING,`oneOf`:array>>,`archInteger`:struct<`archDataTypeId`:STRING,`oneOf`:array>>>>,`outputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING>,`datePublished`:STRING,`supportedLanguages`:array>,`selfUri`:STRING>,`checkedInVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`configurationUri`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`selfUri`:STRING>,`currentOperation`struct<`id`:STRING,`complete`:STRING,`user`:struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`errorDetails`:array>,`actionName`:STRING,`actionStatus`:STRING,`errorMessage`:STRING,`errorCode`:STRING,`errorMessageParams`:struct<`name`:STRING,`count`:STRING>>,`selfUri`STRING,`_origin`STRING,`lockedUser`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`savedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`configurationUri`:STRING,`selfUri`:STRING,`dateSaved`: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-prod/raw/flows/2026-04-13/1776060221'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_flows"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/flows/2026-04-13/1776060221
id: 1712644
processed: 1

raw_data:

{
    "_origin": "2026-04-13T01:03:45Z|raw/flows/2026-04-12/1776060225/data.json.gz|airflow_genesys_prod",
    "active": true,
    "checkedInVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "dateCheckedIn": 1718894027207,
        "dateSaved": 1718894025686,
        "id": "7.0",
        "name": "7.0",
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0"
    },
    "currentOperation": {
        "actionName": "VALIDATE",
        "actionStatus": "SUCCESS",
        "complete": true,
        "errorCode": "ARCHITECT_FLOW_CANNOT_DELETE_USED_IN_EMERGENCY_GROUPS",
        "errorDetails": [
            {
                "entityId": "1fc453f0-687e-4318-a097-8499a6ea8204",
                "entityName": "Newbook AU Monday Meeting",
                "errorCode": "ARCHITECT_RESOURCE_IS_USED_BY_ANOTHER_RESOURCE"
            }
        ],
        "errorMessage": "Flow 'Test-Newbook AU Monday Meeting Emergency Flow' cannot be deleted due to being used by 1 emergency group(s).",
        "errorMessageParams": {
            "count": "1",
            "name": "Test-Newbook AU Monday Meeting Emergency Flow"
        },
        "id": "54b3d5dd-edd0-41c3-a9d0-319e50003c27",
        "user": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "name": "Pierre LeFebvre",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        }
    },
    "deleted": false,
    "description": "This flow provides handling for calls waiting in a queue.",
    "division": {
        "id": "fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0",
        "name": "TOG Marine",
        "selfUri": "/api/v2/authorization/divisions/fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0"
    },
    "id": "037f2416-0bfc-4172-afe1-18a8989cae7e",
    "lockedUser": {
        "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
        "name": "Pierre LeFebvre",
        "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
    },
    "name": "Default In-Queue Flow",
    "publishedVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "createdBy": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        },
        "dateCheckedIn": 1718894027207,
        "dateCreated": 1718894027199,
        "datePublished": "2024-06-20T14:33:47.340Z",
        "dateSaved": 1718894025686,
        "debug": false,
        "generationId": "b51a6afd-912e-4562-b635-b1ec1175c487",
        "id": "7.0",
        "inputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "definitions": {
                "archInteger": {
                    "archDataTypeId": "int",
                    "oneOf": [
                        {
                            "description": "A NOT_SET Integer value.",
                            "type": "null"
                        },
                        {
                            "description": "An integral numeric value.  Examples: -3, 0, 1736",
                            "maximum": 999999999999999,
                            "minimum": -999999999999999,
                            "type": "integer"
                        },
                        {
                            "description": "A string representation of an integral numeric value.  Examples: \"157\", \"-999999999999999\"",
                            "maxLength": 16,
                            "minLength": 1,
                            "type": "string"
                        }
                    ]
                },
                "archString": {
                    "archDataTypeId": "str",
                    "oneOf": [
                        {
                            "description": "A NOT_SET String value.",
                            "type": "null"
                        },
                        {
                            "description": "A character string.  Examples: \"\", \"Hello\", \"Just say \\\"No!\\\"\"",
                            "maxLength": 32000,
                            "type": "string"
                        }
                    ]
                }
            },
            "description": "Schema defining flow input parameters.  Property names map to flow scoped variables marked as a flow input.  If you do not supply a property value for an input variable, the variable value will be set to the initial value configured on it in the flow at flow startup.",
            "properties": {},
            "title": "Flow input schema",
            "type": "object"
        },
        "name": "7.0",
        "outputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "description": "Schema defining flow output parameters.  Property names map to flow scoped variables marked as a flow output.",
            "properties": {},
            "title": "Flow output schema",
            "type": "object"
        },
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0",
        "supportedLanguages": [
            {
                "isDefault": true,
                "language": "en-us"
            }
        ]
    },
    "savedVersion": {
        "commitVersion": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "configurationUri": "/api/v2/flows/0b62eb4f-a56f-4183-93cd-42a210c96396/versions/saved_version_372d2431-c4eb-4005-909b-535b64181df6/configuration",
        "configurationVersion": "2.0",
        "dateSaved": 1733410354061,
        "id": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "name": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "selfUri": "/api/v2/flows/037f2416-0bfc-4172-afe1-18a8989cae7e/versions/saved_version_f5bf3ff1-807b-43e3-88c0-c2bc907a3c03"
    },
    "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a",
    "system": true,
    "type": "INQUEUECALL"
}

schema_attributes:

{
    "_origin": "string",
    "active": "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",
    "currentOperation.actionName": "string",
    "currentOperation.actionStatus": "string",
    "currentOperation.complete": "string",
    "currentOperation.errorCode": "string",
    "currentOperation.errorDetails": [
        {
            "entityId": "string",
            "entityName": "string",
            "errorCode": "string"
        }
    ],
    "currentOperation.errorMessage": "string",
    "currentOperation.errorMessageParams.count": "string",
    "currentOperation.errorMessageParams.name": "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",
    "deleted": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "lockedUser.id": "string",
    "lockedUser.name": "string",
    "lockedUser.selfUri": "string",
    "name": "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.datePublished": "string",
    "publishedVersion.dateSaved": "string",
    "publishedVersion.debug": "string",
    "publishedVersion.generationId": "string",
    "publishedVersion.id": "string",
    "publishedVersion.inputSchema._schema": "string",
    "publishedVersion.inputSchema.additionalProperties": "string",
    "publishedVersion.inputSchema.definitions.archInteger.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archInteger.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "maximum": "string",
            "minLength": "string",
            "minimum": "string",
            "type": "string"
        }
    ],
    "publishedVersion.inputSchema.definitions.archString.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archString.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "type": "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"
        }
    ],
    "savedVersion.commitVersion": "string",
    "savedVersion.configurationUri": "string",
    "savedVersion.configurationVersion": "string",
    "savedVersion.dateSaved": "string",
    "savedVersion.id": "string",
    "savedVersion.name": "string",
    "savedVersion.selfUri": "string",
    "selfUri": "string",
    "system": "string",
    "type": "string"
}

schema_name_id: 1521
schema_scan_id: 161940036
updated: 2026-04-13 01:04:15

Version 1711433

created: 2026-04-12 00:54:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_flows`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`type`STRING,`active`STRING,`system`STRING,`deleted`STRING,`publishedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`debug`:STRING,`createdBy`:struct<`id`:STRING,`selfUri`:STRING>,`configurationUri`:STRING,`dateCreated`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`generationId`:STRING,`inputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING,`definitions`:struct<`archString`:struct<`archDataTypeId`:STRING,`oneOf`:array>>,`archInteger`:struct<`archDataTypeId`:STRING,`oneOf`:array>>>>,`outputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING>,`datePublished`:STRING,`supportedLanguages`:array>,`selfUri`:STRING>,`checkedInVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`configurationUri`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`selfUri`:STRING>,`currentOperation`struct<`id`:STRING,`complete`:STRING,`user`:struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`errorDetails`:array>,`actionName`:STRING,`actionStatus`:STRING,`errorMessage`:STRING,`errorCode`:STRING,`errorMessageParams`:struct<`name`:STRING,`count`:STRING>>,`selfUri`STRING,`_origin`STRING,`lockedUser`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`savedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`configurationUri`:STRING,`selfUri`:STRING,`dateSaved`: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-prod/raw/flows/2026-04-12/1775973268'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_flows"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/flows/2026-04-12/1775973268
id: 1711433
processed: 1

raw_data:

{
    "_origin": "2026-04-12T00:54:32Z|raw/flows/2026-04-11/1775973272/data.json.gz|airflow_genesys_prod",
    "active": true,
    "checkedInVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "dateCheckedIn": 1718894027207,
        "dateSaved": 1718894025686,
        "id": "7.0",
        "name": "7.0",
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0"
    },
    "currentOperation": {
        "actionName": "VALIDATE",
        "actionStatus": "SUCCESS",
        "complete": true,
        "errorCode": "ARCHITECT_FLOW_CANNOT_DELETE_USED_IN_EMERGENCY_GROUPS",
        "errorDetails": [
            {
                "entityId": "1fc453f0-687e-4318-a097-8499a6ea8204",
                "entityName": "Newbook AU Monday Meeting",
                "errorCode": "ARCHITECT_RESOURCE_IS_USED_BY_ANOTHER_RESOURCE"
            }
        ],
        "errorMessage": "Flow 'Test-Newbook AU Monday Meeting Emergency Flow' cannot be deleted due to being used by 1 emergency group(s).",
        "errorMessageParams": {
            "count": "1",
            "name": "Test-Newbook AU Monday Meeting Emergency Flow"
        },
        "id": "54b3d5dd-edd0-41c3-a9d0-319e50003c27",
        "user": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "name": "Pierre LeFebvre",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        }
    },
    "deleted": false,
    "description": "This flow provides handling for calls waiting in a queue.",
    "division": {
        "id": "fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0",
        "name": "TOG Marine",
        "selfUri": "/api/v2/authorization/divisions/fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0"
    },
    "id": "037f2416-0bfc-4172-afe1-18a8989cae7e",
    "lockedUser": {
        "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
        "name": "Pierre LeFebvre",
        "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
    },
    "name": "Default In-Queue Flow",
    "publishedVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "createdBy": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        },
        "dateCheckedIn": 1718894027207,
        "dateCreated": 1718894027199,
        "datePublished": "2024-06-20T14:33:47.340Z",
        "dateSaved": 1718894025686,
        "debug": false,
        "generationId": "b51a6afd-912e-4562-b635-b1ec1175c487",
        "id": "7.0",
        "inputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "definitions": {
                "archInteger": {
                    "archDataTypeId": "int",
                    "oneOf": [
                        {
                            "description": "A NOT_SET Integer value.",
                            "type": "null"
                        },
                        {
                            "description": "An integral numeric value.  Examples: -3, 0, 1736",
                            "maximum": 999999999999999,
                            "minimum": -999999999999999,
                            "type": "integer"
                        },
                        {
                            "description": "A string representation of an integral numeric value.  Examples: \"157\", \"-999999999999999\"",
                            "maxLength": 16,
                            "minLength": 1,
                            "type": "string"
                        }
                    ]
                },
                "archString": {
                    "archDataTypeId": "str",
                    "oneOf": [
                        {
                            "description": "A NOT_SET String value.",
                            "type": "null"
                        },
                        {
                            "description": "A character string.  Examples: \"\", \"Hello\", \"Just say \\\"No!\\\"\"",
                            "maxLength": 32000,
                            "type": "string"
                        }
                    ]
                }
            },
            "description": "Schema defining flow input parameters.  Property names map to flow scoped variables marked as a flow input.  If you do not supply a property value for an input variable, the variable value will be set to the initial value configured on it in the flow at flow startup.",
            "properties": {},
            "title": "Flow input schema",
            "type": "object"
        },
        "name": "7.0",
        "outputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "description": "Schema defining flow output parameters.  Property names map to flow scoped variables marked as a flow output.",
            "properties": {},
            "title": "Flow output schema",
            "type": "object"
        },
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0",
        "supportedLanguages": [
            {
                "isDefault": true,
                "language": "en-us"
            }
        ]
    },
    "savedVersion": {
        "commitVersion": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "configurationUri": "/api/v2/flows/0b62eb4f-a56f-4183-93cd-42a210c96396/versions/saved_version_372d2431-c4eb-4005-909b-535b64181df6/configuration",
        "configurationVersion": "2.0",
        "dateSaved": 1733410354061,
        "id": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "name": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "selfUri": "/api/v2/flows/037f2416-0bfc-4172-afe1-18a8989cae7e/versions/saved_version_f5bf3ff1-807b-43e3-88c0-c2bc907a3c03"
    },
    "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a",
    "system": true,
    "type": "INQUEUECALL"
}

schema_attributes:

{
    "_origin": "string",
    "active": "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",
    "currentOperation.actionName": "string",
    "currentOperation.actionStatus": "string",
    "currentOperation.complete": "string",
    "currentOperation.errorCode": "string",
    "currentOperation.errorDetails": [
        {
            "entityId": "string",
            "entityName": "string",
            "errorCode": "string"
        }
    ],
    "currentOperation.errorMessage": "string",
    "currentOperation.errorMessageParams.count": "string",
    "currentOperation.errorMessageParams.name": "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",
    "deleted": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "lockedUser.id": "string",
    "lockedUser.name": "string",
    "lockedUser.selfUri": "string",
    "name": "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.datePublished": "string",
    "publishedVersion.dateSaved": "string",
    "publishedVersion.debug": "string",
    "publishedVersion.generationId": "string",
    "publishedVersion.id": "string",
    "publishedVersion.inputSchema._schema": "string",
    "publishedVersion.inputSchema.additionalProperties": "string",
    "publishedVersion.inputSchema.definitions.archInteger.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archInteger.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "maximum": "string",
            "minLength": "string",
            "minimum": "string",
            "type": "string"
        }
    ],
    "publishedVersion.inputSchema.definitions.archString.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archString.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "type": "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"
        }
    ],
    "savedVersion.commitVersion": "string",
    "savedVersion.configurationUri": "string",
    "savedVersion.configurationVersion": "string",
    "savedVersion.dateSaved": "string",
    "savedVersion.id": "string",
    "savedVersion.name": "string",
    "savedVersion.selfUri": "string",
    "selfUri": "string",
    "system": "string",
    "type": "string"
}

schema_name_id: 1521
schema_scan_id: 161889202
updated: 2026-04-12 00:54:53

Version 1710245

created: 2026-04-11 00:54:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_flows`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`type`STRING,`active`STRING,`system`STRING,`deleted`STRING,`publishedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`debug`:STRING,`createdBy`:struct<`id`:STRING,`selfUri`:STRING>,`configurationUri`:STRING,`dateCreated`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`generationId`:STRING,`inputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING,`definitions`:struct<`archString`:struct<`archDataTypeId`:STRING,`oneOf`:array>>,`archInteger`:struct<`archDataTypeId`:STRING,`oneOf`:array>>>>,`outputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING>,`datePublished`:STRING,`supportedLanguages`:array>,`selfUri`:STRING>,`checkedInVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`configurationUri`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`selfUri`:STRING>,`currentOperation`struct<`id`:STRING,`complete`:STRING,`user`:struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`errorDetails`:array>,`actionName`:STRING,`actionStatus`:STRING,`errorMessage`:STRING,`errorCode`:STRING,`errorMessageParams`:struct<`name`:STRING,`count`:STRING>>,`selfUri`STRING,`_origin`STRING,`lockedUser`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`savedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`configurationUri`:STRING,`selfUri`:STRING,`dateSaved`: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-prod/raw/flows/2026-04-11/1775886847'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_flows"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/flows/2026-04-11/1775886847
id: 1710245
processed: 1

raw_data:

{
    "_origin": "2026-04-11T00:54:11Z|raw/flows/2026-04-10/1775886851/data.json.gz|airflow_genesys_prod",
    "active": true,
    "checkedInVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "dateCheckedIn": 1718894027207,
        "dateSaved": 1718894025686,
        "id": "7.0",
        "name": "7.0",
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0"
    },
    "currentOperation": {
        "actionName": "VALIDATE",
        "actionStatus": "SUCCESS",
        "complete": true,
        "errorCode": "ARCHITECT_FLOW_CANNOT_DELETE_USED_IN_EMERGENCY_GROUPS",
        "errorDetails": [
            {
                "entityId": "1fc453f0-687e-4318-a097-8499a6ea8204",
                "entityName": "Newbook AU Monday Meeting",
                "errorCode": "ARCHITECT_RESOURCE_IS_USED_BY_ANOTHER_RESOURCE"
            }
        ],
        "errorMessage": "Flow 'Test-Newbook AU Monday Meeting Emergency Flow' cannot be deleted due to being used by 1 emergency group(s).",
        "errorMessageParams": {
            "count": "1",
            "name": "Test-Newbook AU Monday Meeting Emergency Flow"
        },
        "id": "54b3d5dd-edd0-41c3-a9d0-319e50003c27",
        "user": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "name": "Pierre LeFebvre",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        }
    },
    "deleted": false,
    "description": "This flow provides handling for calls waiting in a queue.",
    "division": {
        "id": "fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0",
        "name": "TOG Marine",
        "selfUri": "/api/v2/authorization/divisions/fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0"
    },
    "id": "037f2416-0bfc-4172-afe1-18a8989cae7e",
    "lockedUser": {
        "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
        "name": "Pierre LeFebvre",
        "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
    },
    "name": "Default In-Queue Flow",
    "publishedVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "createdBy": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        },
        "dateCheckedIn": 1718894027207,
        "dateCreated": 1718894027199,
        "datePublished": "2024-06-20T14:33:47.340Z",
        "dateSaved": 1718894025686,
        "debug": false,
        "generationId": "b51a6afd-912e-4562-b635-b1ec1175c487",
        "id": "7.0",
        "inputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "definitions": {
                "archInteger": {
                    "archDataTypeId": "int",
                    "oneOf": [
                        {
                            "description": "A NOT_SET Integer value.",
                            "type": "null"
                        },
                        {
                            "description": "An integral numeric value.  Examples: -3, 0, 1736",
                            "maximum": 999999999999999,
                            "minimum": -999999999999999,
                            "type": "integer"
                        },
                        {
                            "description": "A string representation of an integral numeric value.  Examples: \"157\", \"-999999999999999\"",
                            "maxLength": 16,
                            "minLength": 1,
                            "type": "string"
                        }
                    ]
                },
                "archString": {
                    "archDataTypeId": "str",
                    "oneOf": [
                        {
                            "description": "A NOT_SET String value.",
                            "type": "null"
                        },
                        {
                            "description": "A character string.  Examples: \"\", \"Hello\", \"Just say \\\"No!\\\"\"",
                            "maxLength": 32000,
                            "type": "string"
                        }
                    ]
                }
            },
            "description": "Schema defining flow input parameters.  Property names map to flow scoped variables marked as a flow input.  If you do not supply a property value for an input variable, the variable value will be set to the initial value configured on it in the flow at flow startup.",
            "properties": {},
            "title": "Flow input schema",
            "type": "object"
        },
        "name": "7.0",
        "outputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "description": "Schema defining flow output parameters.  Property names map to flow scoped variables marked as a flow output.",
            "properties": {},
            "title": "Flow output schema",
            "type": "object"
        },
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0",
        "supportedLanguages": [
            {
                "isDefault": true,
                "language": "en-us"
            }
        ]
    },
    "savedVersion": {
        "commitVersion": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "configurationUri": "/api/v2/flows/0b62eb4f-a56f-4183-93cd-42a210c96396/versions/saved_version_372d2431-c4eb-4005-909b-535b64181df6/configuration",
        "configurationVersion": "2.0",
        "dateSaved": 1733410354061,
        "id": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "name": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "selfUri": "/api/v2/flows/037f2416-0bfc-4172-afe1-18a8989cae7e/versions/saved_version_f5bf3ff1-807b-43e3-88c0-c2bc907a3c03"
    },
    "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a",
    "system": true,
    "type": "INQUEUECALL"
}

schema_attributes:

{
    "_origin": "string",
    "active": "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",
    "currentOperation.actionName": "string",
    "currentOperation.actionStatus": "string",
    "currentOperation.complete": "string",
    "currentOperation.errorCode": "string",
    "currentOperation.errorDetails": [
        {
            "entityId": "string",
            "entityName": "string",
            "errorCode": "string"
        }
    ],
    "currentOperation.errorMessage": "string",
    "currentOperation.errorMessageParams.count": "string",
    "currentOperation.errorMessageParams.name": "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",
    "deleted": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "lockedUser.id": "string",
    "lockedUser.name": "string",
    "lockedUser.selfUri": "string",
    "name": "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.datePublished": "string",
    "publishedVersion.dateSaved": "string",
    "publishedVersion.debug": "string",
    "publishedVersion.generationId": "string",
    "publishedVersion.id": "string",
    "publishedVersion.inputSchema._schema": "string",
    "publishedVersion.inputSchema.additionalProperties": "string",
    "publishedVersion.inputSchema.definitions.archInteger.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archInteger.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "maximum": "string",
            "minLength": "string",
            "minimum": "string",
            "type": "string"
        }
    ],
    "publishedVersion.inputSchema.definitions.archString.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archString.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "type": "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"
        }
    ],
    "savedVersion.commitVersion": "string",
    "savedVersion.configurationUri": "string",
    "savedVersion.configurationVersion": "string",
    "savedVersion.dateSaved": "string",
    "savedVersion.id": "string",
    "savedVersion.name": "string",
    "savedVersion.selfUri": "string",
    "selfUri": "string",
    "system": "string",
    "type": "string"
}

schema_name_id: 1521
schema_scan_id: 161837454
updated: 2026-04-11 00:54:57

Version 1709091

created: 2026-04-10 00:58:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_flows`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`type`STRING,`active`STRING,`system`STRING,`deleted`STRING,`publishedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`debug`:STRING,`createdBy`:struct<`id`:STRING,`selfUri`:STRING>,`configurationUri`:STRING,`dateCreated`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`generationId`:STRING,`inputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING,`definitions`:struct<`archString`:struct<`archDataTypeId`:STRING,`oneOf`:array>>,`archInteger`:struct<`archDataTypeId`:STRING,`oneOf`:array>>>>,`outputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING>,`datePublished`:STRING,`supportedLanguages`:array>,`selfUri`:STRING>,`checkedInVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`configurationUri`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`selfUri`:STRING>,`currentOperation`struct<`id`:STRING,`complete`:STRING,`user`:struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`errorDetails`:array>,`actionName`:STRING,`actionStatus`:STRING,`errorMessage`:STRING,`errorCode`:STRING,`errorMessageParams`:struct<`name`:STRING,`count`:STRING>>,`selfUri`STRING,`_origin`STRING,`lockedUser`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`savedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`configurationUri`:STRING,`selfUri`:STRING,`dateSaved`: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-prod/raw/flows/2026-04-10/1775800627'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_flows"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/flows/2026-04-10/1775800627
id: 1709091
processed: 1

raw_data:

{
    "_origin": "2026-04-10T00:57:11Z|raw/flows/2026-04-09/1775800631/data.json.gz|airflow_genesys_prod",
    "active": true,
    "checkedInVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "dateCheckedIn": 1718894027207,
        "dateSaved": 1718894025686,
        "id": "7.0",
        "name": "7.0",
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0"
    },
    "currentOperation": {
        "actionName": "VALIDATE",
        "actionStatus": "SUCCESS",
        "complete": true,
        "errorCode": "ARCHITECT_FLOW_CANNOT_DELETE_USED_IN_EMERGENCY_GROUPS",
        "errorDetails": [
            {
                "entityId": "1fc453f0-687e-4318-a097-8499a6ea8204",
                "entityName": "Newbook AU Monday Meeting",
                "errorCode": "ARCHITECT_RESOURCE_IS_USED_BY_ANOTHER_RESOURCE"
            }
        ],
        "errorMessage": "Flow 'Test-Newbook AU Monday Meeting Emergency Flow' cannot be deleted due to being used by 1 emergency group(s).",
        "errorMessageParams": {
            "count": "1",
            "name": "Test-Newbook AU Monday Meeting Emergency Flow"
        },
        "id": "54b3d5dd-edd0-41c3-a9d0-319e50003c27",
        "user": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "name": "Pierre LeFebvre",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        }
    },
    "deleted": false,
    "description": "This flow provides handling for calls waiting in a queue.",
    "division": {
        "id": "fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0",
        "name": "TOG Marine",
        "selfUri": "/api/v2/authorization/divisions/fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0"
    },
    "id": "037f2416-0bfc-4172-afe1-18a8989cae7e",
    "lockedUser": {
        "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
        "name": "Pierre LeFebvre",
        "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
    },
    "name": "Default In-Queue Flow",
    "publishedVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "createdBy": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        },
        "dateCheckedIn": 1718894027207,
        "dateCreated": 1718894027199,
        "datePublished": "2024-06-20T14:33:47.340Z",
        "dateSaved": 1718894025686,
        "debug": false,
        "generationId": "b51a6afd-912e-4562-b635-b1ec1175c487",
        "id": "7.0",
        "inputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "definitions": {
                "archInteger": {
                    "archDataTypeId": "int",
                    "oneOf": [
                        {
                            "description": "A NOT_SET Integer value.",
                            "type": "null"
                        },
                        {
                            "description": "An integral numeric value.  Examples: -3, 0, 1736",
                            "maximum": 999999999999999,
                            "minimum": -999999999999999,
                            "type": "integer"
                        },
                        {
                            "description": "A string representation of an integral numeric value.  Examples: \"157\", \"-999999999999999\"",
                            "maxLength": 16,
                            "minLength": 1,
                            "type": "string"
                        }
                    ]
                },
                "archString": {
                    "archDataTypeId": "str",
                    "oneOf": [
                        {
                            "description": "A NOT_SET String value.",
                            "type": "null"
                        },
                        {
                            "description": "A character string.  Examples: \"\", \"Hello\", \"Just say \\\"No!\\\"\"",
                            "maxLength": 32000,
                            "type": "string"
                        }
                    ]
                }
            },
            "description": "Schema defining flow input parameters.  Property names map to flow scoped variables marked as a flow input.  If you do not supply a property value for an input variable, the variable value will be set to the initial value configured on it in the flow at flow startup.",
            "properties": {},
            "title": "Flow input schema",
            "type": "object"
        },
        "name": "7.0",
        "outputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "description": "Schema defining flow output parameters.  Property names map to flow scoped variables marked as a flow output.",
            "properties": {},
            "title": "Flow output schema",
            "type": "object"
        },
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0",
        "supportedLanguages": [
            {
                "isDefault": true,
                "language": "en-us"
            }
        ]
    },
    "savedVersion": {
        "commitVersion": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "configurationUri": "/api/v2/flows/0b62eb4f-a56f-4183-93cd-42a210c96396/versions/saved_version_372d2431-c4eb-4005-909b-535b64181df6/configuration",
        "configurationVersion": "2.0",
        "dateSaved": 1733410354061,
        "id": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "name": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "selfUri": "/api/v2/flows/037f2416-0bfc-4172-afe1-18a8989cae7e/versions/saved_version_f5bf3ff1-807b-43e3-88c0-c2bc907a3c03"
    },
    "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a",
    "system": true,
    "type": "INQUEUECALL"
}

schema_attributes:

{
    "_origin": "string",
    "active": "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",
    "currentOperation.actionName": "string",
    "currentOperation.actionStatus": "string",
    "currentOperation.complete": "string",
    "currentOperation.errorCode": "string",
    "currentOperation.errorDetails": [
        {
            "entityId": "string",
            "entityName": "string",
            "errorCode": "string"
        }
    ],
    "currentOperation.errorMessage": "string",
    "currentOperation.errorMessageParams.count": "string",
    "currentOperation.errorMessageParams.name": "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",
    "deleted": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "lockedUser.id": "string",
    "lockedUser.name": "string",
    "lockedUser.selfUri": "string",
    "name": "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.datePublished": "string",
    "publishedVersion.dateSaved": "string",
    "publishedVersion.debug": "string",
    "publishedVersion.generationId": "string",
    "publishedVersion.id": "string",
    "publishedVersion.inputSchema._schema": "string",
    "publishedVersion.inputSchema.additionalProperties": "string",
    "publishedVersion.inputSchema.definitions.archInteger.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archInteger.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "maximum": "string",
            "minLength": "string",
            "minimum": "string",
            "type": "string"
        }
    ],
    "publishedVersion.inputSchema.definitions.archString.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archString.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "type": "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"
        }
    ],
    "savedVersion.commitVersion": "string",
    "savedVersion.configurationUri": "string",
    "savedVersion.configurationVersion": "string",
    "savedVersion.dateSaved": "string",
    "savedVersion.id": "string",
    "savedVersion.name": "string",
    "savedVersion.selfUri": "string",
    "selfUri": "string",
    "system": "string",
    "type": "string"
}

schema_name_id: 1521
schema_scan_id: 161782417
updated: 2026-04-10 00:58:44

Version 1707966

created: 2026-04-09 00:59:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_flows`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`type`STRING,`active`STRING,`system`STRING,`deleted`STRING,`publishedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`debug`:STRING,`createdBy`:struct<`id`:STRING,`selfUri`:STRING>,`configurationUri`:STRING,`dateCreated`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`generationId`:STRING,`inputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING,`definitions`:struct<`archString`:struct<`archDataTypeId`:STRING,`oneOf`:array>>,`archInteger`:struct<`archDataTypeId`:STRING,`oneOf`:array>>>>,`outputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING>,`datePublished`:STRING,`supportedLanguages`:array>,`selfUri`:STRING>,`checkedInVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`configurationUri`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`selfUri`:STRING>,`currentOperation`struct<`id`:STRING,`complete`:STRING,`user`:struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`errorDetails`:array>,`actionName`:STRING,`actionStatus`:STRING,`errorMessage`:STRING,`errorCode`:STRING,`errorMessageParams`:struct<`name`:STRING,`count`:STRING>>,`selfUri`STRING,`_origin`STRING,`lockedUser`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`savedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`configurationUri`:STRING,`selfUri`:STRING,`dateSaved`: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-prod/raw/flows/2026-04-09/1775714272'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_flows"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/flows/2026-04-09/1775714272
id: 1707966
processed: 1

raw_data:

{
    "_origin": "2026-04-09T00:57:56Z|raw/flows/2026-04-08/1775714276/data.json.gz|airflow_genesys_prod",
    "active": true,
    "checkedInVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "dateCheckedIn": 1718894027207,
        "dateSaved": 1718894025686,
        "id": "7.0",
        "name": "7.0",
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0"
    },
    "currentOperation": {
        "actionName": "VALIDATE",
        "actionStatus": "SUCCESS",
        "complete": true,
        "errorCode": "ARCHITECT_FLOW_CANNOT_DELETE_USED_IN_EMERGENCY_GROUPS",
        "errorDetails": [
            {
                "entityId": "1fc453f0-687e-4318-a097-8499a6ea8204",
                "entityName": "Newbook AU Monday Meeting",
                "errorCode": "ARCHITECT_RESOURCE_IS_USED_BY_ANOTHER_RESOURCE"
            }
        ],
        "errorMessage": "Flow 'Test-Newbook AU Monday Meeting Emergency Flow' cannot be deleted due to being used by 1 emergency group(s).",
        "errorMessageParams": {
            "count": "1",
            "name": "Test-Newbook AU Monday Meeting Emergency Flow"
        },
        "id": "54b3d5dd-edd0-41c3-a9d0-319e50003c27",
        "user": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "name": "Pierre LeFebvre",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        }
    },
    "deleted": false,
    "description": "This flow provides handling for calls waiting in a queue.",
    "division": {
        "id": "fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0",
        "name": "TOG Marine",
        "selfUri": "/api/v2/authorization/divisions/fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0"
    },
    "id": "037f2416-0bfc-4172-afe1-18a8989cae7e",
    "lockedUser": {
        "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
        "name": "Pierre LeFebvre",
        "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
    },
    "name": "Default In-Queue Flow",
    "publishedVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "createdBy": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        },
        "dateCheckedIn": 1718894027207,
        "dateCreated": 1718894027199,
        "datePublished": "2024-06-20T14:33:47.340Z",
        "dateSaved": 1718894025686,
        "debug": false,
        "generationId": "b51a6afd-912e-4562-b635-b1ec1175c487",
        "id": "7.0",
        "inputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "definitions": {
                "archInteger": {
                    "archDataTypeId": "int",
                    "oneOf": [
                        {
                            "description": "A NOT_SET Integer value.",
                            "type": "null"
                        },
                        {
                            "description": "An integral numeric value.  Examples: -3, 0, 1736",
                            "maximum": 999999999999999,
                            "minimum": -999999999999999,
                            "type": "integer"
                        },
                        {
                            "description": "A string representation of an integral numeric value.  Examples: \"157\", \"-999999999999999\"",
                            "maxLength": 16,
                            "minLength": 1,
                            "type": "string"
                        }
                    ]
                },
                "archString": {
                    "archDataTypeId": "str",
                    "oneOf": [
                        {
                            "description": "A NOT_SET String value.",
                            "type": "null"
                        },
                        {
                            "description": "A character string.  Examples: \"\", \"Hello\", \"Just say \\\"No!\\\"\"",
                            "maxLength": 32000,
                            "type": "string"
                        }
                    ]
                }
            },
            "description": "Schema defining flow input parameters.  Property names map to flow scoped variables marked as a flow input.  If you do not supply a property value for an input variable, the variable value will be set to the initial value configured on it in the flow at flow startup.",
            "properties": {},
            "title": "Flow input schema",
            "type": "object"
        },
        "name": "7.0",
        "outputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "description": "Schema defining flow output parameters.  Property names map to flow scoped variables marked as a flow output.",
            "properties": {},
            "title": "Flow output schema",
            "type": "object"
        },
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0",
        "supportedLanguages": [
            {
                "isDefault": true,
                "language": "en-us"
            }
        ]
    },
    "savedVersion": {
        "commitVersion": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "configurationUri": "/api/v2/flows/0b62eb4f-a56f-4183-93cd-42a210c96396/versions/saved_version_372d2431-c4eb-4005-909b-535b64181df6/configuration",
        "configurationVersion": "2.0",
        "dateSaved": 1733410354061,
        "id": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "name": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "selfUri": "/api/v2/flows/037f2416-0bfc-4172-afe1-18a8989cae7e/versions/saved_version_f5bf3ff1-807b-43e3-88c0-c2bc907a3c03"
    },
    "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a",
    "system": true,
    "type": "INQUEUECALL"
}

schema_attributes:

{
    "_origin": "string",
    "active": "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",
    "currentOperation.actionName": "string",
    "currentOperation.actionStatus": "string",
    "currentOperation.complete": "string",
    "currentOperation.errorCode": "string",
    "currentOperation.errorDetails": [
        {
            "entityId": "string",
            "entityName": "string",
            "errorCode": "string"
        }
    ],
    "currentOperation.errorMessage": "string",
    "currentOperation.errorMessageParams.count": "string",
    "currentOperation.errorMessageParams.name": "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",
    "deleted": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "lockedUser.id": "string",
    "lockedUser.name": "string",
    "lockedUser.selfUri": "string",
    "name": "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.datePublished": "string",
    "publishedVersion.dateSaved": "string",
    "publishedVersion.debug": "string",
    "publishedVersion.generationId": "string",
    "publishedVersion.id": "string",
    "publishedVersion.inputSchema._schema": "string",
    "publishedVersion.inputSchema.additionalProperties": "string",
    "publishedVersion.inputSchema.definitions.archInteger.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archInteger.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "maximum": "string",
            "minLength": "string",
            "minimum": "string",
            "type": "string"
        }
    ],
    "publishedVersion.inputSchema.definitions.archString.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archString.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "type": "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"
        }
    ],
    "savedVersion.commitVersion": "string",
    "savedVersion.configurationUri": "string",
    "savedVersion.configurationVersion": "string",
    "savedVersion.dateSaved": "string",
    "savedVersion.id": "string",
    "savedVersion.name": "string",
    "savedVersion.selfUri": "string",
    "selfUri": "string",
    "system": "string",
    "type": "string"
}

schema_name_id: 1521
schema_scan_id: 161727573
updated: 2026-04-09 01:00:05

Version 1706738

created: 2026-04-08 00:58:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_flows`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`type`STRING,`active`STRING,`system`STRING,`deleted`STRING,`publishedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`debug`:STRING,`createdBy`:struct<`id`:STRING,`selfUri`:STRING>,`configurationUri`:STRING,`dateCreated`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`generationId`:STRING,`inputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING,`definitions`:struct<`archString`:struct<`archDataTypeId`:STRING,`oneOf`:array>>,`archInteger`:struct<`archDataTypeId`:STRING,`oneOf`:array>>>>,`outputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING>,`datePublished`:STRING,`supportedLanguages`:array>,`selfUri`:STRING>,`checkedInVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`configurationUri`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`selfUri`:STRING>,`currentOperation`struct<`id`:STRING,`complete`:STRING,`user`:struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`errorDetails`:array>,`actionName`:STRING,`actionStatus`:STRING,`errorMessage`:STRING,`errorCode`:STRING,`errorMessageParams`:struct<`name`:STRING,`count`:STRING>>,`selfUri`STRING,`_origin`STRING,`lockedUser`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`savedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`configurationUri`:STRING,`selfUri`:STRING,`dateSaved`: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-prod/raw/flows/2026-04-08/1775627825'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_flows"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/flows/2026-04-08/1775627825
id: 1706738
processed: 1

raw_data:

{
    "_origin": "2026-04-08T00:57:09Z|raw/flows/2026-04-07/1775627829/data.json.gz|airflow_genesys_prod",
    "active": true,
    "checkedInVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "dateCheckedIn": 1718894027207,
        "dateSaved": 1718894025686,
        "id": "7.0",
        "name": "7.0",
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0"
    },
    "currentOperation": {
        "actionName": "VALIDATE",
        "actionStatus": "SUCCESS",
        "complete": true,
        "errorCode": "ARCHITECT_FLOW_CANNOT_DELETE_USED_IN_EMERGENCY_GROUPS",
        "errorDetails": [
            {
                "entityId": "1fc453f0-687e-4318-a097-8499a6ea8204",
                "entityName": "Newbook AU Monday Meeting",
                "errorCode": "ARCHITECT_RESOURCE_IS_USED_BY_ANOTHER_RESOURCE"
            }
        ],
        "errorMessage": "Flow 'Test-Newbook AU Monday Meeting Emergency Flow' cannot be deleted due to being used by 1 emergency group(s).",
        "errorMessageParams": {
            "count": "1",
            "name": "Test-Newbook AU Monday Meeting Emergency Flow"
        },
        "id": "54b3d5dd-edd0-41c3-a9d0-319e50003c27",
        "user": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "name": "Pierre LeFebvre",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        }
    },
    "deleted": false,
    "description": "This flow provides handling for calls waiting in a queue.",
    "division": {
        "id": "fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0",
        "name": "TOG Marine",
        "selfUri": "/api/v2/authorization/divisions/fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0"
    },
    "id": "037f2416-0bfc-4172-afe1-18a8989cae7e",
    "lockedUser": {
        "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
        "name": "Pierre LeFebvre",
        "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
    },
    "name": "Default In-Queue Flow",
    "publishedVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "createdBy": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        },
        "dateCheckedIn": 1718894027207,
        "dateCreated": 1718894027199,
        "datePublished": "2024-06-20T14:33:47.340Z",
        "dateSaved": 1718894025686,
        "debug": false,
        "generationId": "b51a6afd-912e-4562-b635-b1ec1175c487",
        "id": "7.0",
        "inputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "definitions": {
                "archInteger": {
                    "archDataTypeId": "int",
                    "oneOf": [
                        {
                            "description": "A NOT_SET Integer value.",
                            "type": "null"
                        },
                        {
                            "description": "An integral numeric value.  Examples: -3, 0, 1736",
                            "maximum": 999999999999999,
                            "minimum": -999999999999999,
                            "type": "integer"
                        },
                        {
                            "description": "A string representation of an integral numeric value.  Examples: \"157\", \"-999999999999999\"",
                            "maxLength": 16,
                            "minLength": 1,
                            "type": "string"
                        }
                    ]
                },
                "archString": {
                    "archDataTypeId": "str",
                    "oneOf": [
                        {
                            "description": "A NOT_SET String value.",
                            "type": "null"
                        },
                        {
                            "description": "A character string.  Examples: \"\", \"Hello\", \"Just say \\\"No!\\\"\"",
                            "maxLength": 32000,
                            "type": "string"
                        }
                    ]
                }
            },
            "description": "Schema defining flow input parameters.  Property names map to flow scoped variables marked as a flow input.  If you do not supply a property value for an input variable, the variable value will be set to the initial value configured on it in the flow at flow startup.",
            "properties": {},
            "title": "Flow input schema",
            "type": "object"
        },
        "name": "7.0",
        "outputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "description": "Schema defining flow output parameters.  Property names map to flow scoped variables marked as a flow output.",
            "properties": {},
            "title": "Flow output schema",
            "type": "object"
        },
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0",
        "supportedLanguages": [
            {
                "isDefault": true,
                "language": "en-us"
            }
        ]
    },
    "savedVersion": {
        "commitVersion": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "configurationUri": "/api/v2/flows/0b62eb4f-a56f-4183-93cd-42a210c96396/versions/saved_version_372d2431-c4eb-4005-909b-535b64181df6/configuration",
        "configurationVersion": "2.0",
        "dateSaved": 1733410354061,
        "id": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "name": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "selfUri": "/api/v2/flows/037f2416-0bfc-4172-afe1-18a8989cae7e/versions/saved_version_f5bf3ff1-807b-43e3-88c0-c2bc907a3c03"
    },
    "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a",
    "system": true,
    "type": "INQUEUECALL"
}

schema_attributes:

{
    "_origin": "string",
    "active": "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",
    "currentOperation.actionName": "string",
    "currentOperation.actionStatus": "string",
    "currentOperation.complete": "string",
    "currentOperation.errorCode": "string",
    "currentOperation.errorDetails": [
        {
            "entityId": "string",
            "entityName": "string",
            "errorCode": "string"
        }
    ],
    "currentOperation.errorMessage": "string",
    "currentOperation.errorMessageParams.count": "string",
    "currentOperation.errorMessageParams.name": "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",
    "deleted": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "lockedUser.id": "string",
    "lockedUser.name": "string",
    "lockedUser.selfUri": "string",
    "name": "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.datePublished": "string",
    "publishedVersion.dateSaved": "string",
    "publishedVersion.debug": "string",
    "publishedVersion.generationId": "string",
    "publishedVersion.id": "string",
    "publishedVersion.inputSchema._schema": "string",
    "publishedVersion.inputSchema.additionalProperties": "string",
    "publishedVersion.inputSchema.definitions.archInteger.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archInteger.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "maximum": "string",
            "minLength": "string",
            "minimum": "string",
            "type": "string"
        }
    ],
    "publishedVersion.inputSchema.definitions.archString.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archString.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "type": "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"
        }
    ],
    "savedVersion.commitVersion": "string",
    "savedVersion.configurationUri": "string",
    "savedVersion.configurationVersion": "string",
    "savedVersion.dateSaved": "string",
    "savedVersion.id": "string",
    "savedVersion.name": "string",
    "savedVersion.selfUri": "string",
    "selfUri": "string",
    "system": "string",
    "type": "string"
}

schema_name_id: 1521
schema_scan_id: 161671892
updated: 2026-04-08 00:58:56

Version 1705554

created: 2026-04-07 00:58:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_flows`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`type`STRING,`active`STRING,`system`STRING,`deleted`STRING,`publishedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`debug`:STRING,`createdBy`:struct<`id`:STRING,`selfUri`:STRING>,`configurationUri`:STRING,`dateCreated`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`generationId`:STRING,`inputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING,`definitions`:struct<`archString`:struct<`archDataTypeId`:STRING,`oneOf`:array>>,`archInteger`:struct<`archDataTypeId`:STRING,`oneOf`:array>>>>,`outputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING>,`datePublished`:STRING,`supportedLanguages`:array>,`selfUri`:STRING>,`checkedInVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`configurationUri`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`selfUri`:STRING>,`currentOperation`struct<`id`:STRING,`complete`:STRING,`user`:struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`errorDetails`:array>,`actionName`:STRING,`actionStatus`:STRING,`errorMessage`:STRING,`errorCode`:STRING,`errorMessageParams`:struct<`name`:STRING,`count`:STRING>>,`selfUri`STRING,`_origin`STRING,`lockedUser`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`savedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`configurationUri`:STRING,`selfUri`:STRING,`dateSaved`: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-prod/raw/flows/2026-04-07/1775541436'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_flows"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/flows/2026-04-07/1775541436
id: 1705554
processed: 1

raw_data:

{
    "_origin": "2026-04-07T00:57:20Z|raw/flows/2026-04-06/1775541440/data.json.gz|airflow_genesys_prod",
    "active": true,
    "checkedInVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "dateCheckedIn": 1718894027207,
        "dateSaved": 1718894025686,
        "id": "7.0",
        "name": "7.0",
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0"
    },
    "currentOperation": {
        "actionName": "VALIDATE",
        "actionStatus": "SUCCESS",
        "complete": true,
        "errorCode": "ARCHITECT_FLOW_CANNOT_DELETE_USED_IN_EMERGENCY_GROUPS",
        "errorDetails": [
            {
                "entityId": "1fc453f0-687e-4318-a097-8499a6ea8204",
                "entityName": "Newbook AU Monday Meeting",
                "errorCode": "ARCHITECT_RESOURCE_IS_USED_BY_ANOTHER_RESOURCE"
            }
        ],
        "errorMessage": "Flow 'Test-Newbook AU Monday Meeting Emergency Flow' cannot be deleted due to being used by 1 emergency group(s).",
        "errorMessageParams": {
            "count": "1",
            "name": "Test-Newbook AU Monday Meeting Emergency Flow"
        },
        "id": "54b3d5dd-edd0-41c3-a9d0-319e50003c27",
        "user": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "name": "Pierre LeFebvre",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        }
    },
    "deleted": false,
    "description": "This flow provides handling for calls waiting in a queue.",
    "division": {
        "id": "fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0",
        "name": "TOG Marine",
        "selfUri": "/api/v2/authorization/divisions/fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0"
    },
    "id": "037f2416-0bfc-4172-afe1-18a8989cae7e",
    "lockedUser": {
        "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
        "name": "Pierre LeFebvre",
        "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
    },
    "name": "Default In-Queue Flow",
    "publishedVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "createdBy": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        },
        "dateCheckedIn": 1718894027207,
        "dateCreated": 1718894027199,
        "datePublished": "2024-06-20T14:33:47.340Z",
        "dateSaved": 1718894025686,
        "debug": false,
        "generationId": "b51a6afd-912e-4562-b635-b1ec1175c487",
        "id": "7.0",
        "inputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "definitions": {
                "archInteger": {
                    "archDataTypeId": "int",
                    "oneOf": [
                        {
                            "description": "A NOT_SET Integer value.",
                            "type": "null"
                        },
                        {
                            "description": "An integral numeric value.  Examples: -3, 0, 1736",
                            "maximum": 999999999999999,
                            "minimum": -999999999999999,
                            "type": "integer"
                        },
                        {
                            "description": "A string representation of an integral numeric value.  Examples: \"157\", \"-999999999999999\"",
                            "maxLength": 16,
                            "minLength": 1,
                            "type": "string"
                        }
                    ]
                },
                "archString": {
                    "archDataTypeId": "str",
                    "oneOf": [
                        {
                            "description": "A NOT_SET String value.",
                            "type": "null"
                        },
                        {
                            "description": "A character string.  Examples: \"\", \"Hello\", \"Just say \\\"No!\\\"\"",
                            "maxLength": 32000,
                            "type": "string"
                        }
                    ]
                }
            },
            "description": "Schema defining flow input parameters.  Property names map to flow scoped variables marked as a flow input.  If you do not supply a property value for an input variable, the variable value will be set to the initial value configured on it in the flow at flow startup.",
            "properties": {},
            "title": "Flow input schema",
            "type": "object"
        },
        "name": "7.0",
        "outputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "description": "Schema defining flow output parameters.  Property names map to flow scoped variables marked as a flow output.",
            "properties": {},
            "title": "Flow output schema",
            "type": "object"
        },
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0",
        "supportedLanguages": [
            {
                "isDefault": true,
                "language": "en-us"
            }
        ]
    },
    "savedVersion": {
        "commitVersion": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "configurationUri": "/api/v2/flows/0b62eb4f-a56f-4183-93cd-42a210c96396/versions/saved_version_372d2431-c4eb-4005-909b-535b64181df6/configuration",
        "configurationVersion": "2.0",
        "dateSaved": 1733410354061,
        "id": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "name": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "selfUri": "/api/v2/flows/037f2416-0bfc-4172-afe1-18a8989cae7e/versions/saved_version_f5bf3ff1-807b-43e3-88c0-c2bc907a3c03"
    },
    "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a",
    "system": true,
    "type": "INQUEUECALL"
}

schema_attributes:

{
    "_origin": "string",
    "active": "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",
    "currentOperation.actionName": "string",
    "currentOperation.actionStatus": "string",
    "currentOperation.complete": "string",
    "currentOperation.errorCode": "string",
    "currentOperation.errorDetails": [
        {
            "entityId": "string",
            "entityName": "string",
            "errorCode": "string"
        }
    ],
    "currentOperation.errorMessage": "string",
    "currentOperation.errorMessageParams.count": "string",
    "currentOperation.errorMessageParams.name": "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",
    "deleted": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "lockedUser.id": "string",
    "lockedUser.name": "string",
    "lockedUser.selfUri": "string",
    "name": "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.datePublished": "string",
    "publishedVersion.dateSaved": "string",
    "publishedVersion.debug": "string",
    "publishedVersion.generationId": "string",
    "publishedVersion.id": "string",
    "publishedVersion.inputSchema._schema": "string",
    "publishedVersion.inputSchema.additionalProperties": "string",
    "publishedVersion.inputSchema.definitions.archInteger.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archInteger.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "maximum": "string",
            "minLength": "string",
            "minimum": "string",
            "type": "string"
        }
    ],
    "publishedVersion.inputSchema.definitions.archString.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archString.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "type": "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"
        }
    ],
    "savedVersion.commitVersion": "string",
    "savedVersion.configurationUri": "string",
    "savedVersion.configurationVersion": "string",
    "savedVersion.dateSaved": "string",
    "savedVersion.id": "string",
    "savedVersion.name": "string",
    "savedVersion.selfUri": "string",
    "selfUri": "string",
    "system": "string",
    "type": "string"
}

schema_name_id: 1521
schema_scan_id: 161615924
updated: 2026-04-07 00:58:20

Version 1704322

created: 2026-04-06 01:01:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_flows`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`type`STRING,`active`STRING,`system`STRING,`deleted`STRING,`publishedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`debug`:STRING,`createdBy`:struct<`id`:STRING,`selfUri`:STRING>,`configurationUri`:STRING,`dateCreated`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`generationId`:STRING,`inputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING,`definitions`:struct<`archString`:struct<`archDataTypeId`:STRING,`oneOf`:array>>,`archInteger`:struct<`archDataTypeId`:STRING,`oneOf`:array>>>>,`outputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING>,`datePublished`:STRING,`supportedLanguages`:array>,`selfUri`:STRING>,`checkedInVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`configurationUri`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`selfUri`:STRING>,`currentOperation`struct<`id`:STRING,`complete`:STRING,`user`:struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`errorDetails`:array>,`actionName`:STRING,`actionStatus`:STRING,`errorMessage`:STRING,`errorCode`:STRING,`errorMessageParams`:struct<`name`:STRING,`count`:STRING>>,`selfUri`STRING,`_origin`STRING,`lockedUser`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`savedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`configurationUri`:STRING,`selfUri`:STRING,`dateSaved`: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-prod/raw/flows/2026-04-06/1775455199'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_flows"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/flows/2026-04-06/1775455199
id: 1704322
processed: 1

raw_data:

{
    "_origin": "2026-04-06T01:00:07Z|raw/flows/2026-04-05/1775455207/data.json.gz|airflow_genesys_prod",
    "active": true,
    "checkedInVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "dateCheckedIn": 1718894027207,
        "dateSaved": 1718894025686,
        "id": "7.0",
        "name": "7.0",
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0"
    },
    "currentOperation": {
        "actionName": "VALIDATE",
        "actionStatus": "SUCCESS",
        "complete": true,
        "errorCode": "ARCHITECT_FLOW_CANNOT_DELETE_USED_IN_EMERGENCY_GROUPS",
        "errorDetails": [
            {
                "entityId": "1fc453f0-687e-4318-a097-8499a6ea8204",
                "entityName": "Newbook AU Monday Meeting",
                "errorCode": "ARCHITECT_RESOURCE_IS_USED_BY_ANOTHER_RESOURCE"
            }
        ],
        "errorMessage": "Flow 'Test-Newbook AU Monday Meeting Emergency Flow' cannot be deleted due to being used by 1 emergency group(s).",
        "errorMessageParams": {
            "count": "1",
            "name": "Test-Newbook AU Monday Meeting Emergency Flow"
        },
        "id": "54b3d5dd-edd0-41c3-a9d0-319e50003c27",
        "user": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "name": "Pierre LeFebvre",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        }
    },
    "deleted": false,
    "description": "This flow provides handling for calls waiting in a queue.",
    "division": {
        "id": "fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0",
        "name": "TOG Marine",
        "selfUri": "/api/v2/authorization/divisions/fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0"
    },
    "id": "037f2416-0bfc-4172-afe1-18a8989cae7e",
    "lockedUser": {
        "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
        "name": "Pierre LeFebvre",
        "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
    },
    "name": "Default In-Queue Flow",
    "publishedVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "createdBy": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        },
        "dateCheckedIn": 1718894027207,
        "dateCreated": 1718894027199,
        "datePublished": "2024-06-20T14:33:47.340Z",
        "dateSaved": 1718894025686,
        "debug": false,
        "generationId": "b51a6afd-912e-4562-b635-b1ec1175c487",
        "id": "7.0",
        "inputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "definitions": {
                "archInteger": {
                    "archDataTypeId": "int",
                    "oneOf": [
                        {
                            "description": "A NOT_SET Integer value.",
                            "type": "null"
                        },
                        {
                            "description": "An integral numeric value.  Examples: -3, 0, 1736",
                            "maximum": 999999999999999,
                            "minimum": -999999999999999,
                            "type": "integer"
                        },
                        {
                            "description": "A string representation of an integral numeric value.  Examples: \"157\", \"-999999999999999\"",
                            "maxLength": 16,
                            "minLength": 1,
                            "type": "string"
                        }
                    ]
                },
                "archString": {
                    "archDataTypeId": "str",
                    "oneOf": [
                        {
                            "description": "A NOT_SET String value.",
                            "type": "null"
                        },
                        {
                            "description": "A character string.  Examples: \"\", \"Hello\", \"Just say \\\"No!\\\"\"",
                            "maxLength": 32000,
                            "type": "string"
                        }
                    ]
                }
            },
            "description": "Schema defining flow input parameters.  Property names map to flow scoped variables marked as a flow input.  If you do not supply a property value for an input variable, the variable value will be set to the initial value configured on it in the flow at flow startup.",
            "properties": {},
            "title": "Flow input schema",
            "type": "object"
        },
        "name": "7.0",
        "outputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "description": "Schema defining flow output parameters.  Property names map to flow scoped variables marked as a flow output.",
            "properties": {},
            "title": "Flow output schema",
            "type": "object"
        },
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0",
        "supportedLanguages": [
            {
                "isDefault": true,
                "language": "en-us"
            }
        ]
    },
    "savedVersion": {
        "commitVersion": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "configurationUri": "/api/v2/flows/0b62eb4f-a56f-4183-93cd-42a210c96396/versions/saved_version_372d2431-c4eb-4005-909b-535b64181df6/configuration",
        "configurationVersion": "2.0",
        "dateSaved": 1733410354061,
        "id": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "name": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "selfUri": "/api/v2/flows/037f2416-0bfc-4172-afe1-18a8989cae7e/versions/saved_version_f5bf3ff1-807b-43e3-88c0-c2bc907a3c03"
    },
    "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a",
    "system": true,
    "type": "INQUEUECALL"
}

schema_attributes:

{
    "_origin": "string",
    "active": "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",
    "currentOperation.actionName": "string",
    "currentOperation.actionStatus": "string",
    "currentOperation.complete": "string",
    "currentOperation.errorCode": "string",
    "currentOperation.errorDetails": [
        {
            "entityId": "string",
            "entityName": "string",
            "errorCode": "string"
        }
    ],
    "currentOperation.errorMessage": "string",
    "currentOperation.errorMessageParams.count": "string",
    "currentOperation.errorMessageParams.name": "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",
    "deleted": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "lockedUser.id": "string",
    "lockedUser.name": "string",
    "lockedUser.selfUri": "string",
    "name": "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.datePublished": "string",
    "publishedVersion.dateSaved": "string",
    "publishedVersion.debug": "string",
    "publishedVersion.generationId": "string",
    "publishedVersion.id": "string",
    "publishedVersion.inputSchema._schema": "string",
    "publishedVersion.inputSchema.additionalProperties": "string",
    "publishedVersion.inputSchema.definitions.archInteger.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archInteger.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "maximum": "string",
            "minLength": "string",
            "minimum": "string",
            "type": "string"
        }
    ],
    "publishedVersion.inputSchema.definitions.archString.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archString.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "type": "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"
        }
    ],
    "savedVersion.commitVersion": "string",
    "savedVersion.configurationUri": "string",
    "savedVersion.configurationVersion": "string",
    "savedVersion.dateSaved": "string",
    "savedVersion.id": "string",
    "savedVersion.name": "string",
    "savedVersion.selfUri": "string",
    "selfUri": "string",
    "system": "string",
    "type": "string"
}

schema_name_id: 1521
schema_scan_id: 161558543
updated: 2026-04-06 01:02:08

Version 1703157

created: 2026-04-05 00:57:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_flows`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`type`STRING,`active`STRING,`system`STRING,`deleted`STRING,`publishedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`debug`:STRING,`createdBy`:struct<`id`:STRING,`selfUri`:STRING>,`configurationUri`:STRING,`dateCreated`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`generationId`:STRING,`inputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING,`definitions`:struct<`archString`:struct<`archDataTypeId`:STRING,`oneOf`:array>>,`archInteger`:struct<`archDataTypeId`:STRING,`oneOf`:array>>>>,`outputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING>,`datePublished`:STRING,`supportedLanguages`:array>,`selfUri`:STRING>,`checkedInVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`configurationUri`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`selfUri`:STRING>,`currentOperation`struct<`id`:STRING,`complete`:STRING,`user`:struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`errorDetails`:array>,`actionName`:STRING,`actionStatus`:STRING,`errorMessage`:STRING,`errorCode`:STRING,`errorMessageParams`:struct<`name`:STRING,`count`:STRING>>,`selfUri`STRING,`_origin`STRING,`lockedUser`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`savedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`configurationUri`:STRING,`selfUri`:STRING,`dateSaved`: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-prod/raw/flows/2026-04-05/1775368625'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_flows"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/flows/2026-04-05/1775368625
id: 1703157
processed: 1

raw_data:

{
    "_origin": "2026-04-05T00:57:09Z|raw/flows/2026-04-04/1775368629/data.json.gz|airflow_genesys_prod",
    "active": true,
    "checkedInVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "dateCheckedIn": 1718894027207,
        "dateSaved": 1718894025686,
        "id": "7.0",
        "name": "7.0",
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0"
    },
    "currentOperation": {
        "actionName": "VALIDATE",
        "actionStatus": "SUCCESS",
        "complete": true,
        "errorCode": "ARCHITECT_FLOW_CANNOT_DELETE_USED_IN_EMERGENCY_GROUPS",
        "errorDetails": [
            {
                "entityId": "1fc453f0-687e-4318-a097-8499a6ea8204",
                "entityName": "Newbook AU Monday Meeting",
                "errorCode": "ARCHITECT_RESOURCE_IS_USED_BY_ANOTHER_RESOURCE"
            }
        ],
        "errorMessage": "Flow 'Test-Newbook AU Monday Meeting Emergency Flow' cannot be deleted due to being used by 1 emergency group(s).",
        "errorMessageParams": {
            "count": "1",
            "name": "Test-Newbook AU Monday Meeting Emergency Flow"
        },
        "id": "54b3d5dd-edd0-41c3-a9d0-319e50003c27",
        "user": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "name": "Pierre LeFebvre",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        }
    },
    "deleted": false,
    "description": "This flow provides handling for calls waiting in a queue.",
    "division": {
        "id": "fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0",
        "name": "TOG Marine",
        "selfUri": "/api/v2/authorization/divisions/fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0"
    },
    "id": "037f2416-0bfc-4172-afe1-18a8989cae7e",
    "lockedUser": {
        "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
        "name": "Pierre LeFebvre",
        "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
    },
    "name": "Default In-Queue Flow",
    "publishedVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "createdBy": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        },
        "dateCheckedIn": 1718894027207,
        "dateCreated": 1718894027199,
        "datePublished": "2024-06-20T14:33:47.340Z",
        "dateSaved": 1718894025686,
        "debug": false,
        "generationId": "b51a6afd-912e-4562-b635-b1ec1175c487",
        "id": "7.0",
        "inputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "definitions": {
                "archInteger": {
                    "archDataTypeId": "int",
                    "oneOf": [
                        {
                            "description": "A NOT_SET Integer value.",
                            "type": "null"
                        },
                        {
                            "description": "An integral numeric value.  Examples: -3, 0, 1736",
                            "maximum": 999999999999999,
                            "minimum": -999999999999999,
                            "type": "integer"
                        },
                        {
                            "description": "A string representation of an integral numeric value.  Examples: \"157\", \"-999999999999999\"",
                            "maxLength": 16,
                            "minLength": 1,
                            "type": "string"
                        }
                    ]
                },
                "archString": {
                    "archDataTypeId": "str",
                    "oneOf": [
                        {
                            "description": "A NOT_SET String value.",
                            "type": "null"
                        },
                        {
                            "description": "A character string.  Examples: \"\", \"Hello\", \"Just say \\\"No!\\\"\"",
                            "maxLength": 32000,
                            "type": "string"
                        }
                    ]
                }
            },
            "description": "Schema defining flow input parameters.  Property names map to flow scoped variables marked as a flow input.  If you do not supply a property value for an input variable, the variable value will be set to the initial value configured on it in the flow at flow startup.",
            "properties": {},
            "title": "Flow input schema",
            "type": "object"
        },
        "name": "7.0",
        "outputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "description": "Schema defining flow output parameters.  Property names map to flow scoped variables marked as a flow output.",
            "properties": {},
            "title": "Flow output schema",
            "type": "object"
        },
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0",
        "supportedLanguages": [
            {
                "isDefault": true,
                "language": "en-us"
            }
        ]
    },
    "savedVersion": {
        "commitVersion": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "configurationUri": "/api/v2/flows/0b62eb4f-a56f-4183-93cd-42a210c96396/versions/saved_version_372d2431-c4eb-4005-909b-535b64181df6/configuration",
        "configurationVersion": "2.0",
        "dateSaved": 1733410354061,
        "id": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "name": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "selfUri": "/api/v2/flows/037f2416-0bfc-4172-afe1-18a8989cae7e/versions/saved_version_f5bf3ff1-807b-43e3-88c0-c2bc907a3c03"
    },
    "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a",
    "system": true,
    "type": "INQUEUECALL"
}

schema_attributes:

{
    "_origin": "string",
    "active": "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",
    "currentOperation.actionName": "string",
    "currentOperation.actionStatus": "string",
    "currentOperation.complete": "string",
    "currentOperation.errorCode": "string",
    "currentOperation.errorDetails": [
        {
            "entityId": "string",
            "entityName": "string",
            "errorCode": "string"
        }
    ],
    "currentOperation.errorMessage": "string",
    "currentOperation.errorMessageParams.count": "string",
    "currentOperation.errorMessageParams.name": "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",
    "deleted": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "lockedUser.id": "string",
    "lockedUser.name": "string",
    "lockedUser.selfUri": "string",
    "name": "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.datePublished": "string",
    "publishedVersion.dateSaved": "string",
    "publishedVersion.debug": "string",
    "publishedVersion.generationId": "string",
    "publishedVersion.id": "string",
    "publishedVersion.inputSchema._schema": "string",
    "publishedVersion.inputSchema.additionalProperties": "string",
    "publishedVersion.inputSchema.definitions.archInteger.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archInteger.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "maximum": "string",
            "minLength": "string",
            "minimum": "string",
            "type": "string"
        }
    ],
    "publishedVersion.inputSchema.definitions.archString.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archString.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "type": "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"
        }
    ],
    "savedVersion.commitVersion": "string",
    "savedVersion.configurationUri": "string",
    "savedVersion.configurationVersion": "string",
    "savedVersion.dateSaved": "string",
    "savedVersion.id": "string",
    "savedVersion.name": "string",
    "savedVersion.selfUri": "string",
    "selfUri": "string",
    "system": "string",
    "type": "string"
}

schema_name_id: 1521
schema_scan_id: 161511685
updated: 2026-04-05 00:58:10

Version 1701980

created: 2026-04-04 00:58:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_flows`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`type`STRING,`active`STRING,`system`STRING,`deleted`STRING,`publishedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`debug`:STRING,`createdBy`:struct<`id`:STRING,`selfUri`:STRING>,`configurationUri`:STRING,`dateCreated`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`generationId`:STRING,`inputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING,`definitions`:struct<`archString`:struct<`archDataTypeId`:STRING,`oneOf`:array>>,`archInteger`:struct<`archDataTypeId`:STRING,`oneOf`:array>>>>,`outputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING>,`datePublished`:STRING,`supportedLanguages`:array>,`selfUri`:STRING>,`checkedInVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`configurationUri`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`selfUri`:STRING>,`currentOperation`struct<`id`:STRING,`complete`:STRING,`user`:struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`errorDetails`:array>,`actionName`:STRING,`actionStatus`:STRING,`errorMessage`:STRING,`errorCode`:STRING,`errorMessageParams`:struct<`name`:STRING,`count`:STRING>>,`selfUri`STRING,`_origin`STRING,`lockedUser`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`savedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`configurationUri`:STRING,`selfUri`:STRING,`dateSaved`: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-prod/raw/flows/2026-04-04/1775282236'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_flows"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/flows/2026-04-04/1775282236
id: 1701980
processed: 1

raw_data:

{
    "_origin": "2026-04-04T00:57:19Z|raw/flows/2026-04-03/1775282239/data.json.gz|airflow_genesys_prod",
    "active": true,
    "checkedInVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "dateCheckedIn": 1718894027207,
        "dateSaved": 1718894025686,
        "id": "7.0",
        "name": "7.0",
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0"
    },
    "currentOperation": {
        "actionName": "VALIDATE",
        "actionStatus": "SUCCESS",
        "complete": true,
        "errorCode": "ARCHITECT_FLOW_CANNOT_DELETE_USED_IN_EMERGENCY_GROUPS",
        "errorDetails": [
            {
                "entityId": "1fc453f0-687e-4318-a097-8499a6ea8204",
                "entityName": "Newbook AU Monday Meeting",
                "errorCode": "ARCHITECT_RESOURCE_IS_USED_BY_ANOTHER_RESOURCE"
            }
        ],
        "errorMessage": "Flow 'Test-Newbook AU Monday Meeting Emergency Flow' cannot be deleted due to being used by 1 emergency group(s).",
        "errorMessageParams": {
            "count": "1",
            "name": "Test-Newbook AU Monday Meeting Emergency Flow"
        },
        "id": "54b3d5dd-edd0-41c3-a9d0-319e50003c27",
        "user": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "name": "Pierre LeFebvre",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        }
    },
    "deleted": false,
    "description": "This flow provides handling for calls waiting in a queue.",
    "division": {
        "id": "fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0",
        "name": "TOG Marine",
        "selfUri": "/api/v2/authorization/divisions/fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0"
    },
    "id": "037f2416-0bfc-4172-afe1-18a8989cae7e",
    "lockedUser": {
        "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
        "name": "Pierre LeFebvre",
        "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
    },
    "name": "Default In-Queue Flow",
    "publishedVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "createdBy": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        },
        "dateCheckedIn": 1718894027207,
        "dateCreated": 1718894027199,
        "datePublished": "2024-06-20T14:33:47.340Z",
        "dateSaved": 1718894025686,
        "debug": false,
        "generationId": "b51a6afd-912e-4562-b635-b1ec1175c487",
        "id": "7.0",
        "inputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "definitions": {
                "archInteger": {
                    "archDataTypeId": "int",
                    "oneOf": [
                        {
                            "description": "A NOT_SET Integer value.",
                            "type": "null"
                        },
                        {
                            "description": "An integral numeric value.  Examples: -3, 0, 1736",
                            "maximum": 999999999999999,
                            "minimum": -999999999999999,
                            "type": "integer"
                        },
                        {
                            "description": "A string representation of an integral numeric value.  Examples: \"157\", \"-999999999999999\"",
                            "maxLength": 16,
                            "minLength": 1,
                            "type": "string"
                        }
                    ]
                },
                "archString": {
                    "archDataTypeId": "str",
                    "oneOf": [
                        {
                            "description": "A NOT_SET String value.",
                            "type": "null"
                        },
                        {
                            "description": "A character string.  Examples: \"\", \"Hello\", \"Just say \\\"No!\\\"\"",
                            "maxLength": 32000,
                            "type": "string"
                        }
                    ]
                }
            },
            "description": "Schema defining flow input parameters.  Property names map to flow scoped variables marked as a flow input.  If you do not supply a property value for an input variable, the variable value will be set to the initial value configured on it in the flow at flow startup.",
            "properties": {},
            "title": "Flow input schema",
            "type": "object"
        },
        "name": "7.0",
        "outputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "description": "Schema defining flow output parameters.  Property names map to flow scoped variables marked as a flow output.",
            "properties": {},
            "title": "Flow output schema",
            "type": "object"
        },
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0",
        "supportedLanguages": [
            {
                "isDefault": true,
                "language": "en-us"
            }
        ]
    },
    "savedVersion": {
        "commitVersion": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "configurationUri": "/api/v2/flows/0b62eb4f-a56f-4183-93cd-42a210c96396/versions/saved_version_372d2431-c4eb-4005-909b-535b64181df6/configuration",
        "configurationVersion": "2.0",
        "dateSaved": 1733410354061,
        "id": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "name": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "selfUri": "/api/v2/flows/037f2416-0bfc-4172-afe1-18a8989cae7e/versions/saved_version_f5bf3ff1-807b-43e3-88c0-c2bc907a3c03"
    },
    "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a",
    "system": true,
    "type": "INQUEUECALL"
}

schema_attributes:

{
    "_origin": "string",
    "active": "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",
    "currentOperation.actionName": "string",
    "currentOperation.actionStatus": "string",
    "currentOperation.complete": "string",
    "currentOperation.errorCode": "string",
    "currentOperation.errorDetails": [
        {
            "entityId": "string",
            "entityName": "string",
            "errorCode": "string"
        }
    ],
    "currentOperation.errorMessage": "string",
    "currentOperation.errorMessageParams.count": "string",
    "currentOperation.errorMessageParams.name": "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",
    "deleted": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "lockedUser.id": "string",
    "lockedUser.name": "string",
    "lockedUser.selfUri": "string",
    "name": "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.datePublished": "string",
    "publishedVersion.dateSaved": "string",
    "publishedVersion.debug": "string",
    "publishedVersion.generationId": "string",
    "publishedVersion.id": "string",
    "publishedVersion.inputSchema._schema": "string",
    "publishedVersion.inputSchema.additionalProperties": "string",
    "publishedVersion.inputSchema.definitions.archInteger.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archInteger.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "maximum": "string",
            "minLength": "string",
            "minimum": "string",
            "type": "string"
        }
    ],
    "publishedVersion.inputSchema.definitions.archString.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archString.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "type": "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"
        }
    ],
    "savedVersion.commitVersion": "string",
    "savedVersion.configurationUri": "string",
    "savedVersion.configurationVersion": "string",
    "savedVersion.dateSaved": "string",
    "savedVersion.id": "string",
    "savedVersion.name": "string",
    "savedVersion.selfUri": "string",
    "selfUri": "string",
    "system": "string",
    "type": "string"
}

schema_name_id: 1521
schema_scan_id: 161456534
updated: 2026-04-04 00:58:39

Version 1700752

created: 2026-04-03 00:59:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_flows`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`type`STRING,`active`STRING,`system`STRING,`deleted`STRING,`publishedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`debug`:STRING,`createdBy`:struct<`id`:STRING,`selfUri`:STRING>,`configurationUri`:STRING,`dateCreated`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`generationId`:STRING,`inputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING,`definitions`:struct<`archString`:struct<`archDataTypeId`:STRING,`oneOf`:array>>,`archInteger`:struct<`archDataTypeId`:STRING,`oneOf`:array>>>>,`outputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING>,`datePublished`:STRING,`supportedLanguages`:array>,`selfUri`:STRING>,`checkedInVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`configurationUri`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`selfUri`:STRING>,`currentOperation`struct<`id`:STRING,`complete`:STRING,`user`:struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`errorDetails`:array>,`actionName`:STRING,`actionStatus`:STRING,`errorMessage`:STRING,`errorCode`:STRING,`errorMessageParams`:struct<`name`:STRING,`count`:STRING>>,`selfUri`STRING,`_origin`STRING,`lockedUser`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`savedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`configurationUri`:STRING,`selfUri`:STRING,`dateSaved`: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-prod/raw/flows/2026-04-03/1775195841'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_flows"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/flows/2026-04-03/1775195841
id: 1700752
processed: 1

raw_data:

{
    "_origin": "2026-04-03T00:57:25Z|raw/flows/2026-04-02/1775195845/data.json.gz|airflow_genesys_prod",
    "active": true,
    "checkedInVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "dateCheckedIn": 1718894027207,
        "dateSaved": 1718894025686,
        "id": "7.0",
        "name": "7.0",
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0"
    },
    "currentOperation": {
        "actionName": "VALIDATE",
        "actionStatus": "SUCCESS",
        "complete": true,
        "errorCode": "ARCHITECT_FLOW_CANNOT_DELETE_USED_IN_EMERGENCY_GROUPS",
        "errorDetails": [
            {
                "entityId": "1fc453f0-687e-4318-a097-8499a6ea8204",
                "entityName": "Newbook AU Monday Meeting",
                "errorCode": "ARCHITECT_RESOURCE_IS_USED_BY_ANOTHER_RESOURCE"
            }
        ],
        "errorMessage": "Flow 'Test-Newbook AU Monday Meeting Emergency Flow' cannot be deleted due to being used by 1 emergency group(s).",
        "errorMessageParams": {
            "count": "1",
            "name": "Test-Newbook AU Monday Meeting Emergency Flow"
        },
        "id": "54b3d5dd-edd0-41c3-a9d0-319e50003c27",
        "user": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "name": "Pierre LeFebvre",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        }
    },
    "deleted": false,
    "description": "This flow provides handling for calls waiting in a queue.",
    "division": {
        "id": "fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0",
        "name": "TOG Marine",
        "selfUri": "/api/v2/authorization/divisions/fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0"
    },
    "id": "037f2416-0bfc-4172-afe1-18a8989cae7e",
    "lockedUser": {
        "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
        "name": "Pierre LeFebvre",
        "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
    },
    "name": "Default In-Queue Flow",
    "publishedVersion": {
        "commitVersion": "7.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0/configuration",
        "configurationVersion": "2.0",
        "createdBy": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        },
        "dateCheckedIn": 1718894027207,
        "dateCreated": 1718894027199,
        "datePublished": "2024-06-20T14:33:47.340Z",
        "dateSaved": 1718894025686,
        "debug": false,
        "generationId": "b51a6afd-912e-4562-b635-b1ec1175c487",
        "id": "7.0",
        "inputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "definitions": {
                "archInteger": {
                    "archDataTypeId": "int",
                    "oneOf": [
                        {
                            "description": "A NOT_SET Integer value.",
                            "type": "null"
                        },
                        {
                            "description": "An integral numeric value.  Examples: -3, 0, 1736",
                            "maximum": 999999999999999,
                            "minimum": -999999999999999,
                            "type": "integer"
                        },
                        {
                            "description": "A string representation of an integral numeric value.  Examples: \"157\", \"-999999999999999\"",
                            "maxLength": 16,
                            "minLength": 1,
                            "type": "string"
                        }
                    ]
                },
                "archString": {
                    "archDataTypeId": "str",
                    "oneOf": [
                        {
                            "description": "A NOT_SET String value.",
                            "type": "null"
                        },
                        {
                            "description": "A character string.  Examples: \"\", \"Hello\", \"Just say \\\"No!\\\"\"",
                            "maxLength": 32000,
                            "type": "string"
                        }
                    ]
                }
            },
            "description": "Schema defining flow input parameters.  Property names map to flow scoped variables marked as a flow input.  If you do not supply a property value for an input variable, the variable value will be set to the initial value configured on it in the flow at flow startup.",
            "properties": {},
            "title": "Flow input schema",
            "type": "object"
        },
        "name": "7.0",
        "outputSchema": {
            "$schema": "http://json-schema.org/draft-07/schema#",
            "additionalProperties": false,
            "description": "Schema defining flow output parameters.  Property names map to flow scoped variables marked as a flow output.",
            "properties": {},
            "title": "Flow output schema",
            "type": "object"
        },
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/7.0",
        "supportedLanguages": [
            {
                "isDefault": true,
                "language": "en-us"
            }
        ]
    },
    "savedVersion": {
        "commitVersion": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "configurationUri": "/api/v2/flows/0b62eb4f-a56f-4183-93cd-42a210c96396/versions/saved_version_372d2431-c4eb-4005-909b-535b64181df6/configuration",
        "configurationVersion": "2.0",
        "dateSaved": 1733410354061,
        "id": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "name": "saved_version_372d2431-c4eb-4005-909b-535b64181df6",
        "selfUri": "/api/v2/flows/037f2416-0bfc-4172-afe1-18a8989cae7e/versions/saved_version_f5bf3ff1-807b-43e3-88c0-c2bc907a3c03"
    },
    "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a",
    "system": true,
    "type": "INQUEUECALL"
}

schema_attributes:

{
    "_origin": "string",
    "active": "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",
    "currentOperation.actionName": "string",
    "currentOperation.actionStatus": "string",
    "currentOperation.complete": "string",
    "currentOperation.errorCode": "string",
    "currentOperation.errorDetails": [
        {
            "entityId": "string",
            "entityName": "string",
            "errorCode": "string"
        }
    ],
    "currentOperation.errorMessage": "string",
    "currentOperation.errorMessageParams.count": "string",
    "currentOperation.errorMessageParams.name": "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",
    "deleted": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "lockedUser.id": "string",
    "lockedUser.name": "string",
    "lockedUser.selfUri": "string",
    "name": "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.datePublished": "string",
    "publishedVersion.dateSaved": "string",
    "publishedVersion.debug": "string",
    "publishedVersion.generationId": "string",
    "publishedVersion.id": "string",
    "publishedVersion.inputSchema._schema": "string",
    "publishedVersion.inputSchema.additionalProperties": "string",
    "publishedVersion.inputSchema.definitions.archInteger.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archInteger.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "maximum": "string",
            "minLength": "string",
            "minimum": "string",
            "type": "string"
        }
    ],
    "publishedVersion.inputSchema.definitions.archString.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archString.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "type": "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"
        }
    ],
    "savedVersion.commitVersion": "string",
    "savedVersion.configurationUri": "string",
    "savedVersion.configurationVersion": "string",
    "savedVersion.dateSaved": "string",
    "savedVersion.id": "string",
    "savedVersion.name": "string",
    "savedVersion.selfUri": "string",
    "selfUri": "string",
    "system": "string",
    "type": "string"
}

schema_name_id: 1521
schema_scan_id: 161397959
updated: 2026-04-03 00:59:39

Schema Scans: 15

Last at 2026-04-17 00:55:20

Scan 162163977
- duration: 0:00:16.488287
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162163977
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/flows/2026-04-17/1776405284",
        "key": "raw/flows/2026-04-17/1776405284/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_flows",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1521
- start_time: 2026-04-17 00:55:20
- success: True
- trace_id: 14633543584785902669

Scan 162108425
- duration: 0:00:14.058937
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162108425
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/flows/2026-04-16/1776319037",
        "key": "raw/flows/2026-04-16/1776319037/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_flows",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1521
- start_time: 2026-04-16 00:57:49
- success: True
- trace_id: 13861496436851154962

Scan 162052806
- duration: 0:00:16.588441
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162052806
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/flows/2026-04-15/1776232698",
        "key": "raw/flows/2026-04-15/1776232698/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_flows",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1521
- start_time: 2026-04-15 00:58:52
- success: True
- trace_id: 17921805587907194937

Scan 161997602
- duration: 0:00:16.389070
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161997602
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/flows/2026-04-14/1776146460",
        "key": "raw/flows/2026-04-14/1776146460/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_flows",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1521
- start_time: 2026-04-14 01:02:52
- success: True
- trace_id: 13647622370341552549

Scan 161940036
- duration: 0:00:16.650124
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161940036
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/flows/2026-04-13/1776060221",
        "key": "raw/flows/2026-04-13/1776060221/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_flows",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1521
- start_time: 2026-04-13 01:03:58
- success: True
- trace_id: 1159546465823076202

Scan 161889202
- duration: 0:00:13.909660
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161889202
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/flows/2026-04-12/1775973268",
        "key": "raw/flows/2026-04-12/1775973268/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_flows",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1521
- start_time: 2026-04-12 00:54:39
- success: True
- trace_id: 514137078962158085

Scan 161837454
- duration: 0:00:16.386051
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161837454
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/flows/2026-04-11/1775886847",
        "key": "raw/flows/2026-04-11/1775886847/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_flows",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1521
- start_time: 2026-04-11 00:54:40
- success: True
- trace_id: 5110653740077500070

Scan 161782417
- duration: 0:00:16.419352
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161782417
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/flows/2026-04-10/1775800627",
        "key": "raw/flows/2026-04-10/1775800627/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_flows",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1521
- start_time: 2026-04-10 00:58:28
- success: True
- trace_id: 284569920958273341

Scan 161727573
- duration: 0:00:16.619719
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161727573
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/flows/2026-04-09/1775714272",
        "key": "raw/flows/2026-04-09/1775714272/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_flows",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1521
- start_time: 2026-04-09 00:59:48
- success: True
- trace_id: 5128037585907411695

Scan 161671892
- duration: 0:00:13.772269
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161671892
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/flows/2026-04-08/1775627825",
        "key": "raw/flows/2026-04-08/1775627825/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_flows",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1521
- start_time: 2026-04-08 00:58:42
- success: True
- trace_id: 1904709838665161346

Scan 161615924
- duration: 0:00:16.497355
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161615924
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/flows/2026-04-07/1775541436",
        "key": "raw/flows/2026-04-07/1775541436/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_flows",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1521
- start_time: 2026-04-07 00:58:04
- success: True
- trace_id: 108862984609709731

Scan 161558543
- duration: 0:00:14.378835
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161558543
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/flows/2026-04-06/1775455199",
        "key": "raw/flows/2026-04-06/1775455199/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_flows",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1521
- start_time: 2026-04-06 01:01:54
- success: True
- trace_id: 7828661564543251436

Scan 161511685
- duration: 0:00:14.195242
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161511685
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/flows/2026-04-05/1775368625",
        "key": "raw/flows/2026-04-05/1775368625/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_flows",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1521
- start_time: 2026-04-05 00:57:55
- success: True
- trace_id: 5141893016223831448

Scan 161456534
- duration: 0:00:16.594080
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161456534
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/flows/2026-04-04/1775282236",
        "key": "raw/flows/2026-04-04/1775282236/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_flows",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1521
- start_time: 2026-04-04 00:58:23
- success: True
- trace_id: 12656000597210959060

Scan 161397959
- duration: 0:00:14.224893
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 161397959
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/flows/2026-04-03/1775195841",
        "key": "raw/flows/2026-04-03/1775195841/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_flows",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1521
- start_time: 2026-04-03 00:59:24
- success: True
- trace_id: 15592162630133241230

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "active": "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",
    "currentOperation.actionName": "string",
    "currentOperation.actionStatus": "string",
    "currentOperation.complete": "string",
    "currentOperation.errorCode": "string",
    "currentOperation.errorDetails": [
        {
            "entityId": "string",
            "entityName": "string",
            "errorCode": "string"
        }
    ],
    "currentOperation.errorMessage": "string",
    "currentOperation.errorMessageParams.count": "string",
    "currentOperation.errorMessageParams.name": "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",
    "deleted": "string",
    "description": "string",
    "division.id": "string",
    "division.name": "string",
    "division.selfUri": "string",
    "id": "string",
    "lockedUser.id": "string",
    "lockedUser.name": "string",
    "lockedUser.selfUri": "string",
    "name": "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.datePublished": "string",
    "publishedVersion.dateSaved": "string",
    "publishedVersion.debug": "string",
    "publishedVersion.generationId": "string",
    "publishedVersion.id": "string",
    "publishedVersion.inputSchema._schema": "string",
    "publishedVersion.inputSchema.additionalProperties": "string",
    "publishedVersion.inputSchema.definitions.archInteger.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archInteger.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "maximum": "string",
            "minLength": "string",
            "minimum": "string",
            "type": "string"
        }
    ],
    "publishedVersion.inputSchema.definitions.archString.archDataTypeId": "string",
    "publishedVersion.inputSchema.definitions.archString.oneOf": [
        {
            "description": "string",
            "maxLength": "string",
            "type": "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"
        }
    ],
    "savedVersion.commitVersion": "string",
    "savedVersion.configurationUri": "string",
    "savedVersion.configurationVersion": "string",
    "savedVersion.dateSaved": "string",
    "savedVersion.id": "string",
    "savedVersion.name": "string",
    "savedVersion.selfUri": "string",
    "selfUri": "string",
    "system": "string",
    "type": "string"
}

created: 2026-04-17 00:55:23

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_flows`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`type`STRING,`active`STRING,`system`STRING,`deleted`STRING,`publishedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`debug`:STRING,`createdBy`:struct<`id`:STRING,`selfUri`:STRING>,`configurationUri`:STRING,`dateCreated`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`generationId`:STRING,`inputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING,`definitions`:struct<`archString`:struct<`archDataTypeId`:STRING,`oneOf`:array>>,`archInteger`:struct<`archDataTypeId`:STRING,`oneOf`:array>>>>,`outputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING>,`datePublished`:STRING,`supportedLanguages`:array>,`selfUri`:STRING>,`checkedInVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`configurationUri`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`selfUri`:STRING>,`currentOperation`struct<`id`:STRING,`complete`:STRING,`user`:struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`errorDetails`:array>,`actionName`:STRING,`actionStatus`:STRING,`errorMessage`:STRING,`errorCode`:STRING,`errorMessageParams`:struct<`name`:STRING,`count`:STRING>>,`selfUri`STRING,`_origin`STRING,`lockedUser`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`savedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`configurationUri`:STRING,`selfUri`:STRING,`dateSaved`: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-prod/raw/flows/2026-04-17/1776405284'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_flows`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_manual.genesys_flows"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2023-03-10 01:04:00",
        "disabled": false,
        "format": "raw",
        "id": 1521,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_manual",
            "table": "genesys_flows"
        },
        "type": "manual"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "active": "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",
            "currentOperation.actionName": "string",
            "currentOperation.actionStatus": "string",
            "currentOperation.complete": "string",
            "currentOperation.errorCode": "string",
            "currentOperation.errorDetails": [
                {
                    "entityId": "string",
                    "entityName": "string",
                    "errorCode": "string"
                }
            ],
            "currentOperation.errorMessage": "string",
            "currentOperation.errorMessageParams.count": "string",
            "currentOperation.errorMessageParams.name": "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",
            "deleted": "string",
            "description": "string",
            "division.id": "string",
            "division.name": "string",
            "division.selfUri": "string",
            "id": "string",
            "lockedUser.id": "string",
            "lockedUser.name": "string",
            "lockedUser.selfUri": "string",
            "name": "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.datePublished": "string",
            "publishedVersion.dateSaved": "string",
            "publishedVersion.debug": "string",
            "publishedVersion.generationId": "string",
            "publishedVersion.id": "string",
            "publishedVersion.inputSchema._schema": "string",
            "publishedVersion.inputSchema.additionalProperties": "string",
            "publishedVersion.inputSchema.definitions.archInteger.archDataTypeId": "string",
            "publishedVersion.inputSchema.definitions.archInteger.oneOf": [
                {
                    "description": "string",
                    "maxLength": "string",
                    "maximum": "string",
                    "minLength": "string",
                    "minimum": "string",
                    "type": "string"
                }
            ],
            "publishedVersion.inputSchema.definitions.archString.archDataTypeId": "string",
            "publishedVersion.inputSchema.definitions.archString.oneOf": [
                {
                    "description": "string",
                    "maxLength": "string",
                    "type": "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"
                }
            ],
            "savedVersion.commitVersion": "string",
            "savedVersion.configurationUri": "string",
            "savedVersion.configurationVersion": "string",
            "savedVersion.dateSaved": "string",
            "savedVersion.id": "string",
            "savedVersion.name": "string",
            "savedVersion.selfUri": "string",
            "selfUri": "string",
            "system": "string",
            "type": "string"
        },
        "created": "2026-04-17 00:55:23",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_flows`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`description`STRING,`type`STRING,`active`STRING,`system`STRING,`deleted`STRING,`publishedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`debug`:STRING,`createdBy`:struct<`id`:STRING,`selfUri`:STRING>,`configurationUri`:STRING,`dateCreated`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`generationId`:STRING,`inputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING,`definitions`:struct<`archString`:struct<`archDataTypeId`:STRING,`oneOf`:array>>,`archInteger`:struct<`archDataTypeId`:STRING,`oneOf`:array>>>>,`outputSchema`:struct<`_schema`:STRING,`title`:STRING,`description`:STRING,`type`:STRING,`additionalProperties`:STRING>,`datePublished`:STRING,`supportedLanguages`:array>,`selfUri`:STRING>,`checkedInVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`secure`:STRING,`configurationUri`:STRING,`dateCheckedIn`:STRING,`dateSaved`:STRING,`selfUri`:STRING>,`currentOperation`struct<`id`:STRING,`complete`:STRING,`user`:struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`errorDetails`:array>,`actionName`:STRING,`actionStatus`:STRING,`errorMessage`:STRING,`errorCode`:STRING,`errorMessageParams`:struct<`name`:STRING,`count`:STRING>>,`selfUri`STRING,`_origin`STRING,`lockedUser`struct<`id`:STRING,`name`:STRING,`selfUri`:STRING>,`savedVersion`struct<`id`:STRING,`name`:STRING,`commitVersion`:STRING,`configurationVersion`:STRING,`configurationUri`:STRING,`selfUri`:STRING,`dateSaved`: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-prod/raw/flows/2026-04-17/1776405284'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_flows`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_manual.genesys_flows"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}