Schema Info

Schema Name: sfdl_stage_manual.genesys_flows
  • created: 2023-03-08 01:03:53
  • disabled: False
  • format: raw
  • id: 1790
  • is_partitioned: False
  • is_schema_datatyped: False
  • name: 
    {
    "database": "sfdl_stage_manual",
    "table": "genesys_flows"
}
  • type: manual
Schema Versions: 15
    • created: 2026-04-17 00:58:31
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/flows/2026-04-17/1776405483'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_flows"
]
    • hive_path: s3://sfdl-manual-genesys-stage/raw/flows/2026-04-17/1776405483
    • id: 906594
    • processed: 1
    • raw_data: 
      {
    "_origin": "2026-04-17T00:58:07Z|raw/flows/2026-04-16/1776405487/data.json.gz|airflow_genesys_stage",
    "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: 1790
    • schema_scan_id: 6415162
    • updated: 2026-04-17 00:58:43
    • created: 2026-04-16 00:57:46
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/flows/2026-04-16/1776319040'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_flows"
]
    • hive_path: s3://sfdl-manual-genesys-stage/raw/flows/2026-04-16/1776319040
    • id: 906379
    • processed: 1
    • raw_data: 
      {
    "_origin": "2026-04-16T00:57:23Z|raw/flows/2026-04-15/1776319043/data.json.gz|airflow_genesys_stage",
    "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: 1790
    • schema_scan_id: 6414618
    • updated: 2026-04-16 00:58:00
    • created: 2026-04-15 01:00:47
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/flows/2026-04-15/1776232819'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_flows"
]
    • hive_path: s3://sfdl-manual-genesys-stage/raw/flows/2026-04-15/1776232819
    • id: 906165
    • processed: 1
    • raw_data: 
      {
    "_origin": "2026-04-15T01:00:23Z|raw/flows/2026-04-14/1776232823/data.json.gz|airflow_genesys_stage",
    "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: 1790
    • schema_scan_id: 6414129
    • updated: 2026-04-15 01:00:59
    • created: 2026-04-14 01:01:17
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/flows/2026-04-14/1776146458'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_flows"
]
    • hive_path: s3://sfdl-manual-genesys-stage/raw/flows/2026-04-14/1776146458
    • id: 905950
    • processed: 1
    • raw_data: 
      {
    "_origin": "2026-04-14T01:01:03Z|raw/flows/2026-04-13/1776146463/data.json.gz|airflow_genesys_stage",
    "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: 1790
    • schema_scan_id: 6413619
    • updated: 2026-04-14 01:01:28
    • created: 2026-04-13 01:06:18
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/flows/2026-04-13/1776060332'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_flows"
]
    • hive_path: s3://sfdl-manual-genesys-stage/raw/flows/2026-04-13/1776060332
    • id: 905736
    • processed: 1
    • raw_data: 
      {
    "_origin": "2026-04-13T01:05:35Z|raw/flows/2026-04-12/1776060335/data.json.gz|airflow_genesys_stage",
    "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: 1790
    • schema_scan_id: 6413085
    • updated: 2026-04-13 01:06:32
    • created: 2026-04-12 00:58:27
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/flows/2026-04-12/1775973487'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_flows"
]
    • hive_path: s3://sfdl-manual-genesys-stage/raw/flows/2026-04-12/1775973487
    • id: 905532
    • processed: 1
    • raw_data: 
      {
    "_origin": "2026-04-12T00:58:11Z|raw/flows/2026-04-11/1775973491/data.json.gz|airflow_genesys_stage",
    "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: 1790
    • schema_scan_id: 6412684
    • updated: 2026-04-12 00:58:38
    • created: 2026-04-11 00:56:43
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/flows/2026-04-11/1775886967'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_flows"
]
    • hive_path: s3://sfdl-manual-genesys-stage/raw/flows/2026-04-11/1775886967
    • id: 905332
    • processed: 1
    • raw_data: 
      {
    "_origin": "2026-04-11T00:56:10Z|raw/flows/2026-04-10/1775886970/data.json.gz|airflow_genesys_stage",
    "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: 1790
    • schema_scan_id: 6412307
    • updated: 2026-04-11 00:56:57
    • created: 2026-04-10 00:57:32
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/flows/2026-04-10/1775800640'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_flows"
]
    • hive_path: s3://sfdl-manual-genesys-stage/raw/flows/2026-04-10/1775800640
    • id: 905116
    • processed: 1
    • raw_data: 
      {
    "_origin": "2026-04-10T00:57:24Z|raw/flows/2026-04-09/1775800644/data.json.gz|airflow_genesys_stage",
    "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: 1790
    • schema_scan_id: 6411805
    • updated: 2026-04-10 00:57:43
    • created: 2026-04-09 00:59:28
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/flows/2026-04-09/1775714339'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_flows"
]
    • hive_path: s3://sfdl-manual-genesys-stage/raw/flows/2026-04-09/1775714339
    • id: 904903
    • processed: 1
    • raw_data: 
      {
    "_origin": "2026-04-09T00:59:03Z|raw/flows/2026-04-08/1775714343/data.json.gz|airflow_genesys_stage",
    "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: 1790
    • schema_scan_id: 6411290
    • updated: 2026-04-09 00:59:39
    • created: 2026-04-08 00:58:33
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/flows/2026-04-08/1775627900'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_flows"
]
    • hive_path: s3://sfdl-manual-genesys-stage/raw/flows/2026-04-08/1775627900
    • id: 904689
    • processed: 1
    • raw_data: 
      {
    "_origin": "2026-04-08T00:58:23Z|raw/flows/2026-04-07/1775627903/data.json.gz|airflow_genesys_stage",
    "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: 1790
    • schema_scan_id: 6410792
    • updated: 2026-04-08 00:58:45
    • created: 2026-04-07 00:57:50
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/flows/2026-04-07/1775541458'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_flows"
]
    • hive_path: s3://sfdl-manual-genesys-stage/raw/flows/2026-04-07/1775541458
    • id: 904474
    • processed: 1
    • raw_data: 
      {
    "_origin": "2026-04-07T00:57:41Z|raw/flows/2026-04-06/1775541461/data.json.gz|airflow_genesys_stage",
    "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: 1790
    • schema_scan_id: 6410278
    • updated: 2026-04-07 00:58:01
    • created: 2026-04-06 00:58:42
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/flows/2026-04-06/1775455100'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_flows"
]
    • hive_path: s3://sfdl-manual-genesys-stage/raw/flows/2026-04-06/1775455100
    • id: 904261
    • processed: 1
    • raw_data: 
      {
    "_origin": "2026-04-06T00:58:24Z|raw/flows/2026-04-05/1775455104/data.json.gz|airflow_genesys_stage",
    "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: 1790
    • schema_scan_id: 6409740
    • updated: 2026-04-06 00:58:56
    • created: 2026-04-05 00:58:28
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/flows/2026-04-05/1775368677'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_flows"
]
    • hive_path: s3://sfdl-manual-genesys-stage/raw/flows/2026-04-05/1775368677
    • id: 904059
    • processed: 1
    • raw_data: 
      {
    "_origin": "2026-04-05T00:58:01Z|raw/flows/2026-04-04/1775368681/data.json.gz|airflow_genesys_stage",
    "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: 1790
    • schema_scan_id: 6409355
    • updated: 2026-04-05 00:58:42
    • created: 2026-04-04 00:57:21
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/flows/2026-04-04/1775282224'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_flows"
]
    • hive_path: s3://sfdl-manual-genesys-stage/raw/flows/2026-04-04/1775282224
    • id: 903857
    • processed: 1
    • raw_data: 
      {
    "_origin": "2026-04-04T00:57:08Z|raw/flows/2026-04-03/1775282228/data.json.gz|airflow_genesys_stage",
    "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: 1790
    • schema_scan_id: 6408974
    • updated: 2026-04-04 00:57:32
    • created: 2026-04-03 00:58:06
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/flows/2026-04-03/1775195865'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_flows"
]
    • hive_path: s3://sfdl-manual-genesys-stage/raw/flows/2026-04-03/1775195865
    • id: 903644
    • processed: 1
    • raw_data: 
      {
    "_origin": "2026-04-03T00:57:49Z|raw/flows/2026-04-02/1775195869/data.json.gz|airflow_genesys_stage",
    "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: 1790
    • schema_scan_id: 6408482
    • updated: 2026-04-03 00:58:18
Schema Scans: 15
Last at 2026-04-17 00:58:29
    • duration: 0:00:14.107819
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6415162
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/flows/2026-04-17/1776405483",
        "key": "raw/flows/2026-04-17/1776405483/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_flows",
        "type": "manual"
    }
}
    • running: False
    • schema_name_id: 1790
    • start_time: 2026-04-17 00:58:29
    • success: True
    • trace_id: 16345311770112026785
    • duration: 0:00:16.897158
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6414618
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/flows/2026-04-16/1776319040",
        "key": "raw/flows/2026-04-16/1776319040/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_flows",
        "type": "manual"
    }
}
    • running: False
    • schema_name_id: 1790
    • start_time: 2026-04-16 00:57:43
    • success: True
    • trace_id: 513536823865325782
    • duration: 0:00:14.548891
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6414129
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/flows/2026-04-15/1776232819",
        "key": "raw/flows/2026-04-15/1776232819/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_flows",
        "type": "manual"
    }
}
    • running: False
    • schema_name_id: 1790
    • start_time: 2026-04-15 01:00:44
    • success: True
    • trace_id: 16790451881117613482
    • duration: 0:00:14.227380
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6413619
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/flows/2026-04-14/1776146458",
        "key": "raw/flows/2026-04-14/1776146458/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_flows",
        "type": "manual"
    }
}
    • running: False
    • schema_name_id: 1790
    • start_time: 2026-04-14 01:01:14
    • success: True
    • trace_id: 17578936782528760105
    • duration: 0:00:16.794072
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6413085
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/flows/2026-04-13/1776060332",
        "key": "raw/flows/2026-04-13/1776060332/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_flows",
        "type": "manual"
    }
}
    • running: False
    • schema_name_id: 1790
    • start_time: 2026-04-13 01:06:16
    • success: True
    • trace_id: 9214627777398706879
    • duration: 0:00:14.184464
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6412684
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/flows/2026-04-12/1775973487",
        "key": "raw/flows/2026-04-12/1775973487/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_flows",
        "type": "manual"
    }
}
    • running: False
    • schema_name_id: 1790
    • start_time: 2026-04-12 00:58:24
    • success: True
    • trace_id: 18085411205003656780
    • duration: 0:00:16.716797
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6412307
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/flows/2026-04-11/1775886967",
        "key": "raw/flows/2026-04-11/1775886967/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_flows",
        "type": "manual"
    }
}
    • running: False
    • schema_name_id: 1790
    • start_time: 2026-04-11 00:56:40
    • success: True
    • trace_id: 8248852948356472492
    • duration: 0:00:14.129266
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6411805
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/flows/2026-04-10/1775800640",
        "key": "raw/flows/2026-04-10/1775800640/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_flows",
        "type": "manual"
    }
}
    • running: False
    • schema_name_id: 1790
    • start_time: 2026-04-10 00:57:29
    • success: True
    • trace_id: 11272834728756685300
    • duration: 0:00:14.142166
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6411290
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/flows/2026-04-09/1775714339",
        "key": "raw/flows/2026-04-09/1775714339/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_flows",
        "type": "manual"
    }
}
    • running: False
    • schema_name_id: 1790
    • start_time: 2026-04-09 00:59:25
    • success: True
    • trace_id: 7128818891069624008
    • duration: 0:00:14.291729
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6410792
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/flows/2026-04-08/1775627900",
        "key": "raw/flows/2026-04-08/1775627900/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_flows",
        "type": "manual"
    }
}
    • running: False
    • schema_name_id: 1790
    • start_time: 2026-04-08 00:58:30
    • success: True
    • trace_id: 7415446751217254427
    • duration: 0:00:14.116694
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6410278
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/flows/2026-04-07/1775541458",
        "key": "raw/flows/2026-04-07/1775541458/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_flows",
        "type": "manual"
    }
}
    • running: False
    • schema_name_id: 1790
    • start_time: 2026-04-07 00:57:47
    • success: True
    • trace_id: 13071682167568836172
    • duration: 0:00:16.903725
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6409740
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/flows/2026-04-06/1775455100",
        "key": "raw/flows/2026-04-06/1775455100/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_flows",
        "type": "manual"
    }
}
    • running: False
    • schema_name_id: 1790
    • start_time: 2026-04-06 00:58:39
    • success: True
    • trace_id: 17481937260055633367
    • duration: 0:00:16.865847
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6409355
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/flows/2026-04-05/1775368677",
        "key": "raw/flows/2026-04-05/1775368677/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_flows",
        "type": "manual"
    }
}
    • running: False
    • schema_name_id: 1790
    • start_time: 2026-04-05 00:58:25
    • success: True
    • trace_id: 15209484476624989847
    • duration: 0:00:14.489563
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6408974
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/flows/2026-04-04/1775282224",
        "key": "raw/flows/2026-04-04/1775282224/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_flows",
        "type": "manual"
    }
}
    • running: False
    • schema_name_id: 1790
    • start_time: 2026-04-04 00:57:18
    • success: True
    • trace_id: 17957933974420974787
    • duration: 0:00:14.425439
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6408482
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/flows/2026-04-03/1775195865",
        "key": "raw/flows/2026-04-03/1775195865/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_flows",
        "type": "manual"
    }
}
    • running: False
    • schema_name_id: 1790
    • start_time: 2026-04-03 00:58:04
    • success: True
    • trace_id: 320851952318393359
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:58:31
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/flows/2026-04-17/1776405483'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_flows`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_manual.genesys_flows"
}
Server:
  • hostname: schemamanager-5c55c886bf-h2ts4
  • name: schema_manager
  • process_start: 2025-10-21 13:03:27
  • sf_env: stage
  • version: 2112174301
Raw: 
{
    "name": {
        "created": "2023-03-08 01:03:53",
        "disabled": false,
        "format": "raw",
        "id": 1790,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_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:58:31",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/flows/2026-04-17/1776405483'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_flows`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_manual.genesys_flows"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform