Schemas dev - Schema Manager

Schema Name: sfdl_dev_manual.genesys_wrapup_codes

created: 2023-03-14 15:11:48
disabled: False
format: raw
id: 2209
is_partitioned: False
is_schema_datatyped: False

name:

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

type: manual

Schema Versions: 3

Version 4708736

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`dateModified`STRING,`modifiedBy`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/wrapup_codes/2024-08-14/1723646692'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-dev/raw/wrapup_codes/2024-08-14/1723646692
id: 4708736
processed: 1

raw_data:

{
    "_origin": "2024-08-14T09:44:53Z|raw/wrapup_codes/2024-08-13/1723646693/data.json.gz|airflow_genesys_dev",
    "createdBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "dateCreated": "2021-08-16T18:22:12.825Z",
    "dateModified": "2021-08-16T20:53:51.635Z",
    "division": {
        "id": "*"
    },
    "id": "975296f5-e5d2-47df-a2df-4e9154233b56",
    "modifiedBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "name": "B2C Support  - Gift card",
    "selfUri": "/api/v2/routing/wrapupcodes/52e0283e-2284-4452-8e6f-0ff9ef68fda2"
}

schema_attributes:

{
    "_origin": "string",
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "division.id": "string",
    "id": "string",
    "modifiedBy": "string",
    "name": "string",
    "selfUri": "string"
}

schema_name_id: 2209
schema_scan_id: 6564803
updated: 2024-08-14 09:46:35

Version 4705879

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`dateModified`STRING,`modifiedBy`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/wrapup_codes/2024-05-14/1715675820'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-dev/raw/wrapup_codes/2024-05-14/1715675820
id: 4705879
processed: 1

raw_data:

{
    "_origin": "2024-05-14T03:37:01Z|raw/wrapup_codes/2024-05-13/1715675821/data.json.gz|airflow_genesys_dev",
    "createdBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "dateCreated": "2021-08-16T18:22:12.825Z",
    "dateModified": "2021-08-16T20:53:51.635Z",
    "division": {
        "id": "*"
    },
    "id": "975296f5-e5d2-47df-a2df-4e9154233b56",
    "modifiedBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "name": "B2C Support  - Gift card",
    "selfUri": "/api/v2/routing/wrapupcodes/52e0283e-2284-4452-8e6f-0ff9ef68fda2"
}

schema_attributes:

{
    "_origin": "string",
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "division.id": "string",
    "id": "string",
    "modifiedBy": "string",
    "name": "string",
    "selfUri": "string"
}

schema_name_id: 2209
schema_scan_id: 6490558
updated: 2024-05-14 03:37:46

Version 4705691

created: 2024-05-13 12:46:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_wrapup_codes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`dateModified`STRING,`modifiedBy`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/wrapup_codes/2024-05-13/1715622290'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_wrapup_codes"
]

hive_path: s3://sfdl-manual-genesys-dev/raw/wrapup_codes/2024-05-13/1715622290
id: 4705691
processed: 1

raw_data:

{
    "_origin": "2024-05-13T12:44:51Z|raw/wrapup_codes/2024-05-12/1715622291/data.json.gz|airflow_genesys_dev",
    "createdBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "dateCreated": "2021-08-16T18:22:12.825Z",
    "dateModified": "2021-08-16T20:53:51.635Z",
    "division": {
        "id": "*"
    },
    "id": "975296f5-e5d2-47df-a2df-4e9154233b56",
    "modifiedBy": "18fa05bb-8a6c-48b1-ba10-907b132549fa",
    "name": "B2C Support  - Gift card",
    "selfUri": "/api/v2/routing/wrapupcodes/52e0283e-2284-4452-8e6f-0ff9ef68fda2"
}

schema_attributes:

{
    "_origin": "string",
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "division.id": "string",
    "id": "string",
    "modifiedBy": "string",
    "name": "string",
    "selfUri": "string"
}

schema_name_id: 2209
schema_scan_id: 6489844
updated: 2024-05-13 12:46:49

Schema Scans: 3

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

Scan 6564803
- duration: 0:00:14.318426
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6564803
- 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/wrapup_codes/2024-08-14/1723646692",
        "key": "raw/wrapup_codes/2024-08-14/1723646692/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 2209
- start_time: 2024-08-14 09:46:20
- success: True
- trace_id: 14108907686397612967

Scan 6490558
- duration: 0:00:11.915656
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6490558
- 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/wrapup_codes/2024-05-14/1715675820",
        "key": "raw/wrapup_codes/2024-05-14/1715675820/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 2209
- start_time: 2024-05-14 03:37:34
- success: True
- trace_id: 9614282650796468206

Scan 6489844
- duration: 0:00:11.943252
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6489844
- 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/wrapup_codes/2024-05-13/1715622290",
        "key": "raw/wrapup_codes/2024-05-13/1715622290/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_wrapup_codes",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 2209
- start_time: 2024-05-13 12:46:37
- success: True
- trace_id: 17364634682770290449

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "createdBy": "string",
    "dateCreated": "string",
    "dateModified": "string",
    "division.id": "string",
    "id": "string",
    "modifiedBy": "string",
    "name": "string",
    "selfUri": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`dateModified`STRING,`modifiedBy`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/wrapup_codes/2024-08-14/1723646692'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_wrapup_codes`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_manual.genesys_wrapup_codes"
}

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-14 15:11:48",
        "disabled": false,
        "format": "raw",
        "id": 2209,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_dev_manual",
            "table": "genesys_wrapup_codes"
        },
        "type": "manual"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "createdBy": "string",
            "dateCreated": "string",
            "dateModified": "string",
            "division.id": "string",
            "id": "string",
            "modifiedBy": "string",
            "name": "string",
            "selfUri": "string"
        },
        "created": "2024-08-14 09:46:21",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_manual.genesys_wrapup_codes`\n(\n`id`STRING,`name`STRING,`division`struct<`id`:STRING>,`dateCreated`STRING,`createdBy`STRING,`selfUri`STRING,`_origin`STRING,`dateModified`STRING,`modifiedBy`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/wrapup_codes/2024-08-14/1723646692'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_wrapup_codes`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_manual.genesys_wrapup_codes"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}

Schema Info