Schema Info

Schema Name: sfdl_prod_manual.genesys_users

created: 2021-04-08 14:45:23
disabled: False
format: raw
id: 850
is_partitioned: False
is_schema_datatyped: False

name:

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

type: manual

Schema Versions: 15

Version 1718347

created: 2026-04-17 13:03:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_users`\n(\n`user_id`STRING,`user_name`STRING,`user_department`STRING,`user_email`STRING,`user_title`STRING,`manager`STRING,`_origin`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-prod/raw/users/2026-04-17/1776448809'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_users"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/users/2026-04-17/1776448809
id: 1718347
processed: 1

raw_data:

{
    "_origin": "2026-04-17T13:00:09Z|raw/users/2026-04-17/1776448809/data.json.gz|airflow_genesys_prod",
    "manager": null,
    "user_department": null,
    "user_email": "[email protected]",
    "user_id": "6866f932-4f7b-4dd8-a57c-382d01c59960",
    "user_name": "Adam Panek",
    "user_title": null
}

schema_attributes:

{
    "_origin": "string",
    "manager": "string",
    "user_department": "string",
    "user_email": "string",
    "user_id": "string",
    "user_name": "string",
    "user_title": "string"
}

schema_name_id: 850
schema_scan_id: 162190490
updated: 2026-04-17 13:03:37

Version 1718308

created: 2026-04-17 11:03:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_users`\n(\n`user_id`STRING,`user_name`STRING,`user_department`STRING,`user_email`STRING,`user_title`STRING,`manager`STRING,`_origin`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-prod/raw/users/2026-04-17/1776441609'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_users"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/users/2026-04-17/1776441609
id: 1718308
processed: 1

raw_data:

{
    "_origin": "2026-04-17T11:00:09Z|raw/users/2026-04-17/1776441609/data.json.gz|airflow_genesys_prod",
    "manager": null,
    "user_department": null,
    "user_email": "[email protected]",
    "user_id": "6866f932-4f7b-4dd8-a57c-382d01c59960",
    "user_name": "Adam Panek",
    "user_title": null
}

schema_attributes:

{
    "_origin": "string",
    "manager": "string",
    "user_department": "string",
    "user_email": "string",
    "user_id": "string",
    "user_name": "string",
    "user_title": "string"
}

schema_name_id: 850
schema_scan_id: 162183895
updated: 2026-04-17 11:03:19

Version 1718168

created: 2026-04-17 09:03:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_users`\n(\n`user_id`STRING,`user_name`STRING,`user_department`STRING,`user_email`STRING,`user_title`STRING,`manager`STRING,`_origin`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-prod/raw/users/2026-04-17/1776434415'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_users"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/users/2026-04-17/1776434415
id: 1718168
processed: 1

raw_data:

{
    "_origin": "2026-04-17T09:00:15Z|raw/users/2026-04-17/1776434415/data.json.gz|airflow_genesys_prod",
    "manager": null,
    "user_department": null,
    "user_email": "[email protected]",
    "user_id": "6866f932-4f7b-4dd8-a57c-382d01c59960",
    "user_name": "Adam Panek",
    "user_title": null
}

schema_attributes:

{
    "_origin": "string",
    "manager": "string",
    "user_department": "string",
    "user_email": "string",
    "user_id": "string",
    "user_name": "string",
    "user_title": "string"
}

schema_name_id: 850
schema_scan_id: 162177538
updated: 2026-04-17 09:03:20

Version 1718050

created: 2026-04-17 07:00:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_users`\n(\n`user_id`STRING,`user_name`STRING,`user_department`STRING,`user_email`STRING,`user_title`STRING,`manager`STRING,`_origin`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-prod/raw/users/2026-04-17/1776427215'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_users"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/users/2026-04-17/1776427215
id: 1718050
processed: 1

raw_data:

{
    "_origin": "2026-04-17T07:00:15Z|raw/users/2026-04-16/1776427215/data.json.gz|airflow_genesys_prod",
    "manager": null,
    "user_department": null,
    "user_email": "[email protected]",
    "user_id": "6866f932-4f7b-4dd8-a57c-382d01c59960",
    "user_name": "Adam Panek",
    "user_title": null
}

schema_attributes:

{
    "_origin": "string",
    "manager": "string",
    "user_department": "string",
    "user_email": "string",
    "user_id": "string",
    "user_name": "string",
    "user_title": "string"
}

schema_name_id: 850
schema_scan_id: 162172907
updated: 2026-04-17 07:01:06

Version 1717245

created: 2026-04-16 17:02:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_users`\n(\n`user_id`STRING,`user_name`STRING,`user_department`STRING,`user_email`STRING,`user_title`STRING,`manager`STRING,`_origin`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-prod/raw/users/2026-04-16/1776376806'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_users"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/users/2026-04-16/1776376806
id: 1717245
processed: 1

raw_data:

{
    "_origin": "2026-04-16T17:00:06Z|raw/users/2026-04-16/1776376806/data.json.gz|airflow_genesys_prod",
    "manager": null,
    "user_department": null,
    "user_email": "[email protected]",
    "user_id": "6866f932-4f7b-4dd8-a57c-382d01c59960",
    "user_name": "Adam Panek",
    "user_title": null
}

schema_attributes:

{
    "_origin": "string",
    "manager": "string",
    "user_department": "string",
    "user_email": "string",
    "user_id": "string",
    "user_name": "string",
    "user_title": "string"
}

schema_name_id: 850
schema_scan_id: 162146889
updated: 2026-04-16 17:02:12

Version 1717212

created: 2026-04-16 15:03:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_users`\n(\n`user_id`STRING,`user_name`STRING,`user_department`STRING,`user_email`STRING,`user_title`STRING,`manager`STRING,`_origin`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-prod/raw/users/2026-04-16/1776369609'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_users"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/users/2026-04-16/1776369609
id: 1717212
processed: 1

raw_data:

{
    "_origin": "2026-04-16T15:00:09Z|raw/users/2026-04-16/1776369609/data.json.gz|airflow_genesys_prod",
    "manager": null,
    "user_department": null,
    "user_email": "[email protected]",
    "user_id": "6866f932-4f7b-4dd8-a57c-382d01c59960",
    "user_name": "Adam Panek",
    "user_title": null
}

schema_attributes:

{
    "_origin": "string",
    "manager": "string",
    "user_department": "string",
    "user_email": "string",
    "user_id": "string",
    "user_name": "string",
    "user_title": "string"
}

schema_name_id: 850
schema_scan_id: 162140646
updated: 2026-04-16 15:03:54

Version 1717112

created: 2026-04-16 13:02:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_users`\n(\n`user_id`STRING,`user_name`STRING,`user_department`STRING,`user_email`STRING,`user_title`STRING,`manager`STRING,`_origin`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-prod/raw/users/2026-04-16/1776362409'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_users"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/users/2026-04-16/1776362409
id: 1717112
processed: 1

raw_data:

{
    "_origin": "2026-04-16T13:00:09Z|raw/users/2026-04-16/1776362409/data.json.gz|airflow_genesys_prod",
    "manager": null,
    "user_department": null,
    "user_email": "[email protected]",
    "user_id": "6866f932-4f7b-4dd8-a57c-382d01c59960",
    "user_name": "Adam Panek",
    "user_title": null
}

schema_attributes:

{
    "_origin": "string",
    "manager": "string",
    "user_department": "string",
    "user_email": "string",
    "user_id": "string",
    "user_name": "string",
    "user_title": "string"
}

schema_name_id: 850
schema_scan_id: 162134305
updated: 2026-04-16 13:02:28

Version 1717074

created: 2026-04-16 11:02:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_users`\n(\n`user_id`STRING,`user_name`STRING,`user_department`STRING,`user_email`STRING,`user_title`STRING,`manager`STRING,`_origin`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-prod/raw/users/2026-04-16/1776355209'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_users"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/users/2026-04-16/1776355209
id: 1717074
processed: 1

raw_data:

{
    "_origin": "2026-04-16T11:00:09Z|raw/users/2026-04-16/1776355209/data.json.gz|airflow_genesys_prod",
    "manager": null,
    "user_department": null,
    "user_email": "[email protected]",
    "user_id": "6866f932-4f7b-4dd8-a57c-382d01c59960",
    "user_name": "Adam Panek",
    "user_title": null
}

schema_attributes:

{
    "_origin": "string",
    "manager": "string",
    "user_department": "string",
    "user_email": "string",
    "user_id": "string",
    "user_name": "string",
    "user_title": "string"
}

schema_name_id: 850
schema_scan_id: 162127746
updated: 2026-04-16 11:02:32

Version 1716951

created: 2026-04-16 09:03:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_users`\n(\n`user_id`STRING,`user_name`STRING,`user_department`STRING,`user_email`STRING,`user_title`STRING,`manager`STRING,`_origin`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-prod/raw/users/2026-04-16/1776348013'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_users"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/users/2026-04-16/1776348013
id: 1716951
processed: 1

raw_data:

{
    "_origin": "2026-04-16T09:00:13Z|raw/users/2026-04-16/1776348013/data.json.gz|airflow_genesys_prod",
    "manager": null,
    "user_department": null,
    "user_email": "[email protected]",
    "user_id": "6866f932-4f7b-4dd8-a57c-382d01c59960",
    "user_name": "Adam Panek",
    "user_title": null
}

schema_attributes:

{
    "_origin": "string",
    "manager": "string",
    "user_department": "string",
    "user_email": "string",
    "user_id": "string",
    "user_name": "string",
    "user_title": "string"
}

schema_name_id: 850
schema_scan_id: 162122131
updated: 2026-04-16 09:04:04

Version 1716825

created: 2026-04-16 07:01:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_users`\n(\n`user_id`STRING,`user_name`STRING,`user_department`STRING,`user_email`STRING,`user_title`STRING,`manager`STRING,`_origin`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-prod/raw/users/2026-04-16/1776340813'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_users"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/users/2026-04-16/1776340813
id: 1716825
processed: 1

raw_data:

{
    "_origin": "2026-04-16T07:00:13Z|raw/users/2026-04-15/1776340813/data.json.gz|airflow_genesys_prod",
    "manager": null,
    "user_department": null,
    "user_email": "[email protected]",
    "user_id": "6866f932-4f7b-4dd8-a57c-382d01c59960",
    "user_name": "Adam Panek",
    "user_title": null
}

schema_attributes:

{
    "_origin": "string",
    "manager": "string",
    "user_department": "string",
    "user_email": "string",
    "user_id": "string",
    "user_name": "string",
    "user_title": "string"
}

schema_name_id: 850
schema_scan_id: 162117234
updated: 2026-04-16 07:01:43

Version 1716031

created: 2026-04-15 17:04:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_users`\n(\n`user_id`STRING,`user_name`STRING,`user_department`STRING,`user_email`STRING,`user_title`STRING,`manager`STRING,`_origin`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-prod/raw/users/2026-04-15/1776290407'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_users"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/users/2026-04-15/1776290407
id: 1716031
processed: 1

raw_data:

{
    "_origin": "2026-04-15T17:00:07Z|raw/users/2026-04-15/1776290407/data.json.gz|airflow_genesys_prod",
    "manager": null,
    "user_department": null,
    "user_email": "[email protected]",
    "user_id": "6866f932-4f7b-4dd8-a57c-382d01c59960",
    "user_name": "Adam Panek",
    "user_title": null
}

schema_attributes:

{
    "_origin": "string",
    "manager": "string",
    "user_department": "string",
    "user_email": "string",
    "user_id": "string",
    "user_name": "string",
    "user_title": "string"
}

schema_name_id: 850
schema_scan_id: 162090562
updated: 2026-04-15 17:04:22

Version 1716015

created: 2026-04-15 15:01:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_users`\n(\n`user_id`STRING,`user_name`STRING,`user_department`STRING,`user_email`STRING,`user_title`STRING,`manager`STRING,`_origin`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-prod/raw/users/2026-04-15/1776283210'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_users"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/users/2026-04-15/1776283210
id: 1716015
processed: 1

raw_data:

{
    "_origin": "2026-04-15T15:00:10Z|raw/users/2026-04-15/1776283210/data.json.gz|airflow_genesys_prod",
    "manager": null,
    "user_department": null,
    "user_email": "[email protected]",
    "user_id": "6866f932-4f7b-4dd8-a57c-382d01c59960",
    "user_name": "Adam Panek",
    "user_title": null
}

schema_attributes:

{
    "_origin": "string",
    "manager": "string",
    "user_department": "string",
    "user_email": "string",
    "user_id": "string",
    "user_name": "string",
    "user_title": "string"
}

schema_name_id: 850
schema_scan_id: 162084392
updated: 2026-04-15 15:01:44

Version 1715910

created: 2026-04-15 13:02:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_users`\n(\n`user_id`STRING,`user_name`STRING,`user_department`STRING,`user_email`STRING,`user_title`STRING,`manager`STRING,`_origin`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-prod/raw/users/2026-04-15/1776276009'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_users"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/users/2026-04-15/1776276009
id: 1715910
processed: 1

raw_data:

{
    "_origin": "2026-04-15T13:00:09Z|raw/users/2026-04-15/1776276009/data.json.gz|airflow_genesys_prod",
    "manager": null,
    "user_department": null,
    "user_email": "[email protected]",
    "user_id": "6866f932-4f7b-4dd8-a57c-382d01c59960",
    "user_name": "Adam Panek",
    "user_title": null
}

schema_attributes:

{
    "_origin": "string",
    "manager": "string",
    "user_department": "string",
    "user_email": "string",
    "user_id": "string",
    "user_name": "string",
    "user_title": "string"
}

schema_name_id: 850
schema_scan_id: 162078277
updated: 2026-04-15 13:02:22

Version 1715864

created: 2026-04-15 11:03:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_users`\n(\n`user_id`STRING,`user_name`STRING,`user_department`STRING,`user_email`STRING,`user_title`STRING,`manager`STRING,`_origin`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-prod/raw/users/2026-04-15/1776268809'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_users"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/users/2026-04-15/1776268809
id: 1715864
processed: 1

raw_data:

{
    "_origin": "2026-04-15T11:00:09Z|raw/users/2026-04-15/1776268809/data.json.gz|airflow_genesys_prod",
    "manager": null,
    "user_department": null,
    "user_email": "[email protected]",
    "user_id": "6866f932-4f7b-4dd8-a57c-382d01c59960",
    "user_name": "Adam Panek",
    "user_title": null
}

schema_attributes:

{
    "_origin": "string",
    "manager": "string",
    "user_department": "string",
    "user_email": "string",
    "user_id": "string",
    "user_name": "string",
    "user_title": "string"
}

schema_name_id: 850
schema_scan_id: 162072202
updated: 2026-04-15 11:03:45

Version 1715809

created: 2026-04-15 09:04:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_users`\n(\n`user_id`STRING,`user_name`STRING,`user_department`STRING,`user_email`STRING,`user_title`STRING,`manager`STRING,`_origin`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-prod/raw/users/2026-04-15/1776261613'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_users"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/users/2026-04-15/1776261613
id: 1715809
processed: 1

raw_data:

{
    "_origin": "2026-04-15T09:00:13Z|raw/users/2026-04-15/1776261613/data.json.gz|airflow_genesys_prod",
    "manager": null,
    "user_department": null,
    "user_email": "[email protected]",
    "user_id": "6866f932-4f7b-4dd8-a57c-382d01c59960",
    "user_name": "Adam Panek",
    "user_title": null
}

schema_attributes:

{
    "_origin": "string",
    "manager": "string",
    "user_department": "string",
    "user_email": "string",
    "user_id": "string",
    "user_name": "string",
    "user_title": "string"
}

schema_name_id: 850
schema_scan_id: 162066378
updated: 2026-04-15 09:04:29

Schema Scans: 15

Last at 2026-04-17 13:03:25

Scan 162190490
- duration: 0:00:11.897175
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162190490
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/users/2026-04-17/1776448809",
        "key": "raw/users/2026-04-17/1776448809/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_users",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 850
- start_time: 2026-04-17 13:03:25
- success: True
- trace_id: 16981989218302269765

Scan 162183895
- duration: 0:00:12.076480
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162183895
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/users/2026-04-17/1776441609",
        "key": "raw/users/2026-04-17/1776441609/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_users",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 850
- start_time: 2026-04-17 11:03:07
- success: True
- trace_id: 4160659292999779035

Scan 162177538
- duration: 0:00:14.492501
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162177538
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/users/2026-04-17/1776434415",
        "key": "raw/users/2026-04-17/1776434415/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_users",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 850
- start_time: 2026-04-17 09:03:06
- success: True
- trace_id: 4837055154652059071

Scan 162172907
- duration: 0:00:14.521235
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162172907
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/users/2026-04-17/1776427215",
        "key": "raw/users/2026-04-17/1776427215/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_users",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 850
- start_time: 2026-04-17 07:00:51
- success: True
- trace_id: 3934255367169307610

Scan 162146889
- duration: 0:00:11.936064
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162146889
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/users/2026-04-16/1776376806",
        "key": "raw/users/2026-04-16/1776376806/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_users",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 850
- start_time: 2026-04-16 17:02:00
- success: True
- trace_id: 1095128328862564027

Scan 162140646
- duration: 0:00:12.131493
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162140646
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/users/2026-04-16/1776369609",
        "key": "raw/users/2026-04-16/1776369609/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_users",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 850
- start_time: 2026-04-16 15:03:42
- success: True
- trace_id: 16062044466301409756

Scan 162134305
- duration: 0:00:19.654205
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162134305
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/users/2026-04-16/1776362409",
        "key": "raw/users/2026-04-16/1776362409/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_users",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 850
- start_time: 2026-04-16 13:02:08
- success: True
- trace_id: 8522052266069908179

Scan 162127746
- duration: 0:00:14.604605
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162127746
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/users/2026-04-16/1776355209",
        "key": "raw/users/2026-04-16/1776355209/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_users",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 850
- start_time: 2026-04-16 11:02:17
- success: True
- trace_id: 4278540991798399512

Scan 162122131
- duration: 0:00:14.397621
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162122131
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/users/2026-04-16/1776348013",
        "key": "raw/users/2026-04-16/1776348013/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_users",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 850
- start_time: 2026-04-16 09:03:49
- success: True
- trace_id: 8011674414350834445

Scan 162117234
- duration: 0:00:11.862763
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162117234
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/users/2026-04-16/1776340813",
        "key": "raw/users/2026-04-16/1776340813/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_users",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 850
- start_time: 2026-04-16 07:01:31
- success: True
- trace_id: 6073475452773717842

Scan 162090562
- duration: 0:00:11.905811
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162090562
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/users/2026-04-15/1776290407",
        "key": "raw/users/2026-04-15/1776290407/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_users",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 850
- start_time: 2026-04-15 17:04:10
- success: True
- trace_id: 17063615253343094415

Scan 162084392
- duration: 0:00:14.546271
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162084392
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/users/2026-04-15/1776283210",
        "key": "raw/users/2026-04-15/1776283210/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_users",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 850
- start_time: 2026-04-15 15:01:29
- success: True
- trace_id: 676528887951916980

Scan 162078277
- duration: 0:00:11.930775
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162078277
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/users/2026-04-15/1776276009",
        "key": "raw/users/2026-04-15/1776276009/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_users",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 850
- start_time: 2026-04-15 13:02:10
- success: True
- trace_id: 15392859325670785462

Scan 162072202
- duration: 0:00:12.101309
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162072202
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/users/2026-04-15/1776268809",
        "key": "raw/users/2026-04-15/1776268809/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_users",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 850
- start_time: 2026-04-15 11:03:33
- success: True
- trace_id: 11791729710101304291

Scan 162066378
- duration: 0:00:14.508058
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162066378
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-prod",
        "hive_path": "s3://sfdl-manual-genesys-prod/raw/users/2026-04-15/1776261613",
        "key": "raw/users/2026-04-15/1776261613/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_users",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 850
- start_time: 2026-04-15 09:04:15
- success: True
- trace_id: 15226159404151420519

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "manager": "string",
    "user_department": "string",
    "user_email": "string",
    "user_id": "string",
    "user_name": "string",
    "user_title": "string"
}

created: 2026-04-17 13:03:25

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_users`\n(\n`user_id`STRING,`user_name`STRING,`user_department`STRING,`user_email`STRING,`user_title`STRING,`manager`STRING,`_origin`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-prod/raw/users/2026-04-17/1776448809'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_users`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_manual.genesys_users"
}

Server:

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

Raw:

{
    "name": {
        "created": "2021-04-08 14:45:23",
        "disabled": false,
        "format": "raw",
        "id": 850,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_manual",
            "table": "genesys_users"
        },
        "type": "manual"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "manager": "string",
            "user_department": "string",
            "user_email": "string",
            "user_id": "string",
            "user_name": "string",
            "user_title": "string"
        },
        "created": "2026-04-17 13:03:25",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_users`\n(\n`user_id`STRING,`user_name`STRING,`user_department`STRING,`user_email`STRING,`user_title`STRING,`manager`STRING,`_origin`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-manual-genesys-prod/raw/users/2026-04-17/1776448809'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_users`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_manual.genesys_users"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}