Schema Info

Schema Name: sfdl_dev_manual.genesys_flows
  • created: 2023-03-07 13:09:38
  • disabled: False
  • format: raw
  • id: 2208
  • is_partitioned: False
  • is_schema_datatyped: False
  • name: 
    {
    "database": "sfdl_dev_manual",
    "table": "genesys_flows"
}
  • type: manual
Schema Versions: 3
    • created: 2024-08-14 09:46:39
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/flows/2024-08-14/1723646699'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_flows"
]
    • hive_path: s3://sfdl-manual-genesys-dev/raw/flows/2024-08-14/1723646699
    • id: 4708737
    • processed: 1
    • raw_data: 
      {
    "_origin": "2024-08-14T09:45:03Z|raw/flows/2024-08-13/1723646703/data.json.gz|airflow_genesys_dev",
    "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": "PUBLISH",
        "actionStatus": "SUCCESS",
        "complete": true,
        "errorCode": "ARCHITECT_FLOW_CANNOT_DELETE_USED_IN_IVR_CONFIGS",
        "errorDetails": [
            {
                "entityId": "914216d4-528f-4a84-8511-5235c9770b18",
                "entityName": "Bobby's Route",
                "errorCode": "ARCHITECT_RESOURCE_IS_USED_BY_ANOTHER_RESOURCE"
            }
        ],
        "errorMessage": "Flow 'Bobby's World' cannot be deleted due to being used by 1 IVR configuration(s).",
        "errorMessageParams": {
            "count": "1",
            "name": "Bobby's World"
        },
        "id": "e7fea704-60e4-44b7-ba1a-8d6a4dd855db",
        "user": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "name": "Pierre LeFebvre",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        }
    },
    "deleted": false,
    "description": "Test Call Flow for Marketplace Product Team - Copy of Marketplace Open Call Flow",
    "division": {
        "id": "fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0",
        "name": "TOG Marine",
        "selfUri": "/api/v2/authorization/divisions/fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0"
    },
    "id": "0ab34c10-154b-4e43-b0cd-c835111954b9",
    "lockedUser": {
        "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
        "name": "Pierre LeFebvre",
        "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
    },
    "name": "Marketplace Test Call 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_9d89c954-b4f2-4b95-b8e9-9018edf2dc2b",
        "configurationUri": "/api/v2/flows/16af1eaa-60f6-4414-aec2-447fc24f43d2/versions/saved_version_9d89c954-b4f2-4b95-b8e9-9018edf2dc2b/configuration",
        "configurationVersion": "2.0",
        "dateSaved": 1718894004490,
        "id": "saved_version_9d89c954-b4f2-4b95-b8e9-9018edf2dc2b",
        "name": "saved_version_9d89c954-b4f2-4b95-b8e9-9018edf2dc2b",
        "selfUri": "/api/v2/flows/0ab34c10-154b-4e43-b0cd-c835111954b9/versions/saved_version_063a80b3-2eed-4b7c-8834-93c45e431ae0"
    },
    "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a",
    "system": false,
    "type": "INBOUNDCALL"
}
    • 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: 2208
    • schema_scan_id: 6564805
    • updated: 2024-08-14 09:46:50
    • created: 2024-05-14 03:38:07
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/flows/2024-05-14/1715675811'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_flows"
]
    • hive_path: s3://sfdl-manual-genesys-dev/raw/flows/2024-05-14/1715675811
    • id: 4705881
    • processed: 1
    • raw_data: 
      {
    "_origin": "2024-05-14T03:36:54Z|raw/flows/2024-05-13/1715675814/data.json.gz|airflow_genesys_dev",
    "active": true,
    "checkedInVersion": {
        "commitVersion": "6.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/6.0/configuration",
        "configurationVersion": "2.0",
        "dateCheckedIn": 1713900883837,
        "dateSaved": 1713900882519,
        "id": "6.0",
        "name": "6.0",
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/6.0"
    },
    "currentOperation": {
        "actionName": "VALIDATE",
        "actionStatus": "SUCCESS",
        "complete": true,
        "errorCode": "ARCHITECT_FLOW_CANNOT_DELETE_USED_IN_IVR_CONFIGS",
        "errorDetails": [
            {
                "entityId": "914216d4-528f-4a84-8511-5235c9770b18",
                "entityName": "Bobby's Route",
                "errorCode": "ARCHITECT_RESOURCE_IS_USED_BY_ANOTHER_RESOURCE"
            }
        ],
        "errorMessage": "Flow 'Bobby's World' cannot be deleted due to being used by 1 IVR configuration(s).",
        "errorMessageParams": {
            "count": "1",
            "name": "Bobby's World"
        },
        "id": "e7fea704-60e4-44b7-ba1a-8d6a4dd855db",
        "user": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "name": "Pierre LeFebvre",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        }
    },
    "deleted": false,
    "description": "Test Call Flow for Marketplace Product Team - Copy of Marketplace Open Call Flow",
    "division": {
        "id": "fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0",
        "name": "TOG Marinas",
        "selfUri": "/api/v2/authorization/divisions/fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0"
    },
    "id": "0ab34c10-154b-4e43-b0cd-c835111954b9",
    "lockedUser": {
        "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
        "name": "Pierre LeFebvre",
        "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
    },
    "name": "Marketplace Test Call Flow",
    "publishedVersion": {
        "commitVersion": "6.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/6.0/configuration",
        "configurationVersion": "2.0",
        "createdBy": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        },
        "dateCheckedIn": 1713900883837,
        "dateCreated": 1713900883826,
        "datePublished": "2024-04-23T19:34:43.943Z",
        "dateSaved": 1713900882519,
        "debug": false,
        "generationId": "53339c00-7b5e-4992-a1f1-40396d9dfe7b",
        "id": "6.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": "6.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/6.0",
        "supportedLanguages": [
            {
                "isDefault": true,
                "language": "en-us"
            }
        ]
    },
    "savedVersion": {
        "commitVersion": "saved_version_d2316167-30c3-4c34-a0c3-bca5e63993d6",
        "configurationUri": "/api/v2/flows/314bb988-6917-4051-8591-b7dfe0ab6f14/versions/saved_version_d2316167-30c3-4c34-a0c3-bca5e63993d6/configuration",
        "configurationVersion": "2.0",
        "dateSaved": 1695219028352,
        "id": "saved_version_d2316167-30c3-4c34-a0c3-bca5e63993d6",
        "name": "saved_version_d2316167-30c3-4c34-a0c3-bca5e63993d6",
        "selfUri": "/api/v2/flows/0ab34c10-154b-4e43-b0cd-c835111954b9/versions/saved_version_063a80b3-2eed-4b7c-8834-93c45e431ae0"
    },
    "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a",
    "system": false,
    "type": "INBOUNDCALL"
}
    • 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: 2208
    • schema_scan_id: 6490562
    • updated: 2024-05-14 03:38:19
    • created: 2024-05-13 12:48:01
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_flows`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/flows/2024-05-13/1715622298'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_flows"
]
    • hive_path: s3://sfdl-manual-genesys-dev/raw/flows/2024-05-13/1715622298
    • id: 4705693
    • processed: 1
    • raw_data: 
      {
    "_origin": "2024-05-13T12:45:01Z|raw/flows/2024-05-12/1715622301/data.json.gz|airflow_genesys_dev",
    "active": true,
    "checkedInVersion": {
        "commitVersion": "6.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/6.0/configuration",
        "configurationVersion": "2.0",
        "dateCheckedIn": 1713900883837,
        "dateSaved": 1713900882519,
        "id": "6.0",
        "name": "6.0",
        "secure": false,
        "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/6.0"
    },
    "currentOperation": {
        "actionName": "VALIDATE",
        "actionStatus": "SUCCESS",
        "complete": true,
        "errorCode": "ARCHITECT_FLOW_CANNOT_DELETE_USED_IN_IVR_CONFIGS",
        "errorDetails": [
            {
                "entityId": "914216d4-528f-4a84-8511-5235c9770b18",
                "entityName": "Bobby's Route",
                "errorCode": "ARCHITECT_RESOURCE_IS_USED_BY_ANOTHER_RESOURCE"
            }
        ],
        "errorMessage": "Flow 'Bobby's World' cannot be deleted due to being used by 1 IVR configuration(s).",
        "errorMessageParams": {
            "count": "1",
            "name": "Bobby's World"
        },
        "id": "e7fea704-60e4-44b7-ba1a-8d6a4dd855db",
        "user": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "name": "Pierre LeFebvre",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        }
    },
    "deleted": false,
    "description": "Test Call Flow for Marketplace Product Team - Copy of Marketplace Open Call Flow",
    "division": {
        "id": "fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0",
        "name": "TOG Marinas",
        "selfUri": "/api/v2/authorization/divisions/fb2b7a9e-c8b0-4a69-9fbb-10db8ba9d9e0"
    },
    "id": "0ab34c10-154b-4e43-b0cd-c835111954b9",
    "lockedUser": {
        "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
        "name": "Pierre LeFebvre",
        "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
    },
    "name": "Marketplace Test Call Flow",
    "publishedVersion": {
        "commitVersion": "6.0",
        "configurationUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a/versions/6.0/configuration",
        "configurationVersion": "2.0",
        "createdBy": {
            "id": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
            "selfUri": "/api/v2/users/18fa05bb-8a6c-48b1-ba10-907b132549fa"
        },
        "dateCheckedIn": 1713900883837,
        "dateCreated": 1713900883826,
        "datePublished": "2024-04-23T19:34:43.943Z",
        "dateSaved": 1713900882519,
        "debug": false,
        "generationId": "53339c00-7b5e-4992-a1f1-40396d9dfe7b",
        "id": "6.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": "6.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/6.0",
        "supportedLanguages": [
            {
                "isDefault": true,
                "language": "en-us"
            }
        ]
    },
    "savedVersion": {
        "commitVersion": "saved_version_d2316167-30c3-4c34-a0c3-bca5e63993d6",
        "configurationUri": "/api/v2/flows/314bb988-6917-4051-8591-b7dfe0ab6f14/versions/saved_version_d2316167-30c3-4c34-a0c3-bca5e63993d6/configuration",
        "configurationVersion": "2.0",
        "dateSaved": 1695219028352,
        "id": "saved_version_d2316167-30c3-4c34-a0c3-bca5e63993d6",
        "name": "saved_version_d2316167-30c3-4c34-a0c3-bca5e63993d6",
        "selfUri": "/api/v2/flows/0ab34c10-154b-4e43-b0cd-c835111954b9/versions/saved_version_063a80b3-2eed-4b7c-8834-93c45e431ae0"
    },
    "selfUri": "/api/v2/flows/0030cc98-2f1e-4d4e-8b72-2a509146b43a",
    "system": false,
    "type": "INBOUNDCALL"
}
    • 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: 2208
    • schema_scan_id: 6489848
    • updated: 2024-05-13 12:48:15
Schema Scans: 3
Last at 2024-08-14 09:46:36
    • duration: 0:00:13.955241
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6564805
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-dev",
        "hive_path": "s3://sfdl-manual-genesys-dev/raw/flows/2024-08-14/1723646699",
        "key": "raw/flows/2024-08-14/1723646699/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_flows",
        "type": "manual"
    }
}
    • running: False
    • schema_name_id: 2208
    • start_time: 2024-08-14 09:46:36
    • success: True
    • trace_id: 11175303125591491054
    • duration: 0:00:14.142306
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6490562
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-dev",
        "hive_path": "s3://sfdl-manual-genesys-dev/raw/flows/2024-05-14/1715675811",
        "key": "raw/flows/2024-05-14/1715675811/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_flows",
        "type": "manual"
    }
}
    • running: False
    • schema_name_id: 2208
    • start_time: 2024-05-14 03:38:05
    • success: True
    • trace_id: 4833939858907159898
    • duration: 0:00:16.928643
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6489848
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-dev",
        "hive_path": "s3://sfdl-manual-genesys-dev/raw/flows/2024-05-13/1715622298",
        "key": "raw/flows/2024-05-13/1715622298/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_flows",
        "type": "manual"
    }
}
    • running: False
    • schema_name_id: 2208
    • start_time: 2024-05-13 12:47:58
    • success: True
    • trace_id: 10548110151829772721
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: 2024-08-14 09:46:39
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/flows/2024-08-14/1723646699'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_flows`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_manual.genesys_flows"
}
Server:
  • hostname: schemamanager-5447774fc6-4w58v
  • name: schema_manager
  • process_start: 2026-04-02 21:43:44
  • sf_env: dev
  • version: 2427328685
Raw: 
{
    "name": {
        "created": "2023-03-07 13:09:38",
        "disabled": false,
        "format": "raw",
        "id": 2208,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_dev_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": "2024-08-14 09:46:39",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/flows/2024-08-14/1723646699'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_flows`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_manual.genesys_flows"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}
©2019 SpareFoot Data Platform