Schema Info

Schema Name: sfdl_prod_manual.genesys_evaluation_forms

created: 2021-04-08 14:45:25
disabled: False
format: raw
id: 851
is_partitioned: False
is_schema_datatyped: False

name:

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

type: manual

Schema Versions: 15

Version 1718346

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_evaluation_forms`\n(\n`form_context_id`STRING,`evaluation_form_id`STRING,`evaluation_form_name`STRING,`question_group_name`STRING,`question_group_id`STRING,`question_text`STRING,`question_id`STRING,`answer_option_id`STRING,`answer_option_text`STRING,`answer_option_value`STRING,`question_weight`STRING,`question_manual_weight`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/evaluation_forms/2026-04-17/1776448872'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/evaluation_forms/2026-04-17/1776448872
id: 1718346
processed: 1

raw_data:

{
    "_origin": "2026-04-17T13:01:12Z|raw/evaluation_forms/2026-04-17/1776448872/data.json.gz|airflow_genesys_prod",
    "answer_option_id": "a40dad1b-a76c-4101-aaff-eb4852a9468d",
    "answer_option_text": "Yes",
    "answer_option_value": 2,
    "evaluation_form_id": "0a1031e9-20b9-4674-9e49-4e44ae95199c",
    "evaluation_form_name": "Adapted Sales Process Quality Form",
    "form_context_id": "af0a5ce4-4e58-41a1-b9d2-0a4a6bda859f",
    "question_group_id": "3f8f8dc2-b87c-41c6-9deb-0297711426af",
    "question_group_name": "Intake",
    "question_id": "64b4f67b-cb8e-43ef-bdba-313076dae5b5",
    "question_manual_weight": false,
    "question_text": "Did the agent ask the customer if they were looking at a specific location or if they just needed help finding the best deal? ",
    "question_weight": 100.0
}

schema_attributes:

{
    "_origin": "string",
    "answer_option_id": "string",
    "answer_option_text": "string",
    "answer_option_value": "string",
    "evaluation_form_id": "string",
    "evaluation_form_name": "string",
    "form_context_id": "string",
    "question_group_id": "string",
    "question_group_name": "string",
    "question_id": "string",
    "question_manual_weight": "string",
    "question_text": "string",
    "question_weight": "string"
}

schema_name_id: 851
schema_scan_id: 162190398
updated: 2026-04-17 13:03:21

Version 1718310

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_evaluation_forms`\n(\n`form_context_id`STRING,`evaluation_form_id`STRING,`evaluation_form_name`STRING,`question_group_name`STRING,`question_group_id`STRING,`question_text`STRING,`question_id`STRING,`answer_option_id`STRING,`answer_option_text`STRING,`answer_option_value`STRING,`question_weight`STRING,`question_manual_weight`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/evaluation_forms/2026-04-17/1776441668'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/evaluation_forms/2026-04-17/1776441668
id: 1718310
processed: 1

raw_data:

{
    "_origin": "2026-04-17T11:01:08Z|raw/evaluation_forms/2026-04-17/1776441668/data.json.gz|airflow_genesys_prod",
    "answer_option_id": "a40dad1b-a76c-4101-aaff-eb4852a9468d",
    "answer_option_text": "Yes",
    "answer_option_value": 2,
    "evaluation_form_id": "0a1031e9-20b9-4674-9e49-4e44ae95199c",
    "evaluation_form_name": "Adapted Sales Process Quality Form",
    "form_context_id": "af0a5ce4-4e58-41a1-b9d2-0a4a6bda859f",
    "question_group_id": "3f8f8dc2-b87c-41c6-9deb-0297711426af",
    "question_group_name": "Intake",
    "question_id": "64b4f67b-cb8e-43ef-bdba-313076dae5b5",
    "question_manual_weight": false,
    "question_text": "Did the agent ask the customer if they were looking at a specific location or if they just needed help finding the best deal? ",
    "question_weight": 100.0
}

schema_attributes:

{
    "_origin": "string",
    "answer_option_id": "string",
    "answer_option_text": "string",
    "answer_option_value": "string",
    "evaluation_form_id": "string",
    "evaluation_form_name": "string",
    "form_context_id": "string",
    "question_group_id": "string",
    "question_group_name": "string",
    "question_id": "string",
    "question_manual_weight": "string",
    "question_text": "string",
    "question_weight": "string"
}

schema_name_id: 851
schema_scan_id: 162184009
updated: 2026-04-17 11:04:17

Version 1718171

created: 2026-04-17 09:04:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_evaluation_forms`\n(\n`form_context_id`STRING,`evaluation_form_id`STRING,`evaluation_form_name`STRING,`question_group_name`STRING,`question_group_id`STRING,`question_text`STRING,`question_id`STRING,`answer_option_id`STRING,`answer_option_text`STRING,`answer_option_value`STRING,`question_weight`STRING,`question_manual_weight`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/evaluation_forms/2026-04-17/1776434477'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/evaluation_forms/2026-04-17/1776434477
id: 1718171
processed: 1

raw_data:

{
    "_origin": "2026-04-17T09:01:17Z|raw/evaluation_forms/2026-04-17/1776434477/data.json.gz|airflow_genesys_prod",
    "answer_option_id": "a40dad1b-a76c-4101-aaff-eb4852a9468d",
    "answer_option_text": "Yes",
    "answer_option_value": 2,
    "evaluation_form_id": "0a1031e9-20b9-4674-9e49-4e44ae95199c",
    "evaluation_form_name": "Adapted Sales Process Quality Form",
    "form_context_id": "af0a5ce4-4e58-41a1-b9d2-0a4a6bda859f",
    "question_group_id": "3f8f8dc2-b87c-41c6-9deb-0297711426af",
    "question_group_name": "Intake",
    "question_id": "64b4f67b-cb8e-43ef-bdba-313076dae5b5",
    "question_manual_weight": false,
    "question_text": "Did the agent ask the customer if they were looking at a specific location or if they just needed help finding the best deal? ",
    "question_weight": 100.0
}

schema_attributes:

{
    "_origin": "string",
    "answer_option_id": "string",
    "answer_option_text": "string",
    "answer_option_value": "string",
    "evaluation_form_id": "string",
    "evaluation_form_name": "string",
    "form_context_id": "string",
    "question_group_id": "string",
    "question_group_name": "string",
    "question_id": "string",
    "question_manual_weight": "string",
    "question_text": "string",
    "question_weight": "string"
}

schema_name_id: 851
schema_scan_id: 162177827
updated: 2026-04-17 09:04:41

Version 1718055

created: 2026-04-17 07:01:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_evaluation_forms`\n(\n`form_context_id`STRING,`evaluation_form_id`STRING,`evaluation_form_name`STRING,`question_group_name`STRING,`question_group_id`STRING,`question_text`STRING,`question_id`STRING,`answer_option_id`STRING,`answer_option_text`STRING,`answer_option_value`STRING,`question_weight`STRING,`question_manual_weight`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/evaluation_forms/2026-04-17/1776427277'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/evaluation_forms/2026-04-17/1776427277
id: 1718055
processed: 1

raw_data:

{
    "_origin": "2026-04-17T07:01:17Z|raw/evaluation_forms/2026-04-16/1776427277/data.json.gz|airflow_genesys_prod",
    "answer_option_id": "a40dad1b-a76c-4101-aaff-eb4852a9468d",
    "answer_option_text": "Yes",
    "answer_option_value": 2,
    "evaluation_form_id": "0a1031e9-20b9-4674-9e49-4e44ae95199c",
    "evaluation_form_name": "Adapted Sales Process Quality Form",
    "form_context_id": "af0a5ce4-4e58-41a1-b9d2-0a4a6bda859f",
    "question_group_id": "3f8f8dc2-b87c-41c6-9deb-0297711426af",
    "question_group_name": "Intake",
    "question_id": "64b4f67b-cb8e-43ef-bdba-313076dae5b5",
    "question_manual_weight": false,
    "question_text": "Did the agent ask the customer if they were looking at a specific location or if they just needed help finding the best deal? ",
    "question_weight": 100.0
}

schema_attributes:

{
    "_origin": "string",
    "answer_option_id": "string",
    "answer_option_text": "string",
    "answer_option_value": "string",
    "evaluation_form_id": "string",
    "evaluation_form_name": "string",
    "form_context_id": "string",
    "question_group_id": "string",
    "question_group_name": "string",
    "question_id": "string",
    "question_manual_weight": "string",
    "question_text": "string",
    "question_weight": "string"
}

schema_name_id: 851
schema_scan_id: 162172995
updated: 2026-04-17 07:01:52

Version 1717244

created: 2026-04-16 17:01:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_evaluation_forms`\n(\n`form_context_id`STRING,`evaluation_form_id`STRING,`evaluation_form_name`STRING,`question_group_name`STRING,`question_group_id`STRING,`question_text`STRING,`question_id`STRING,`answer_option_id`STRING,`answer_option_text`STRING,`answer_option_value`STRING,`question_weight`STRING,`question_manual_weight`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/evaluation_forms/2026-04-16/1776376869'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/evaluation_forms/2026-04-16/1776376869
id: 1717244
processed: 1

raw_data:

{
    "_origin": "2026-04-16T17:01:09Z|raw/evaluation_forms/2026-04-16/1776376869/data.json.gz|airflow_genesys_prod",
    "answer_option_id": "a40dad1b-a76c-4101-aaff-eb4852a9468d",
    "answer_option_text": "Yes",
    "answer_option_value": 2,
    "evaluation_form_id": "0a1031e9-20b9-4674-9e49-4e44ae95199c",
    "evaluation_form_name": "Adapted Sales Process Quality Form",
    "form_context_id": "af0a5ce4-4e58-41a1-b9d2-0a4a6bda859f",
    "question_group_id": "3f8f8dc2-b87c-41c6-9deb-0297711426af",
    "question_group_name": "Intake",
    "question_id": "64b4f67b-cb8e-43ef-bdba-313076dae5b5",
    "question_manual_weight": false,
    "question_text": "Did the agent ask the customer if they were looking at a specific location or if they just needed help finding the best deal? ",
    "question_weight": 100.0
}

schema_attributes:

{
    "_origin": "string",
    "answer_option_id": "string",
    "answer_option_text": "string",
    "answer_option_value": "string",
    "evaluation_form_id": "string",
    "evaluation_form_name": "string",
    "form_context_id": "string",
    "question_group_id": "string",
    "question_group_name": "string",
    "question_id": "string",
    "question_manual_weight": "string",
    "question_text": "string",
    "question_weight": "string"
}

schema_name_id: 851
schema_scan_id: 162146831
updated: 2026-04-16 17:02:00

Version 1717215

created: 2026-04-16 15:04:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_evaluation_forms`\n(\n`form_context_id`STRING,`evaluation_form_id`STRING,`evaluation_form_name`STRING,`question_group_name`STRING,`question_group_id`STRING,`question_text`STRING,`question_id`STRING,`answer_option_id`STRING,`answer_option_text`STRING,`answer_option_value`STRING,`question_weight`STRING,`question_manual_weight`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/evaluation_forms/2026-04-16/1776369671'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/evaluation_forms/2026-04-16/1776369671
id: 1717215
processed: 1

raw_data:

{
    "_origin": "2026-04-16T15:01:11Z|raw/evaluation_forms/2026-04-16/1776369671/data.json.gz|airflow_genesys_prod",
    "answer_option_id": "a40dad1b-a76c-4101-aaff-eb4852a9468d",
    "answer_option_text": "Yes",
    "answer_option_value": 2,
    "evaluation_form_id": "0a1031e9-20b9-4674-9e49-4e44ae95199c",
    "evaluation_form_name": "Adapted Sales Process Quality Form",
    "form_context_id": "af0a5ce4-4e58-41a1-b9d2-0a4a6bda859f",
    "question_group_id": "3f8f8dc2-b87c-41c6-9deb-0297711426af",
    "question_group_name": "Intake",
    "question_id": "64b4f67b-cb8e-43ef-bdba-313076dae5b5",
    "question_manual_weight": false,
    "question_text": "Did the agent ask the customer if they were looking at a specific location or if they just needed help finding the best deal? ",
    "question_weight": 100.0
}

schema_attributes:

{
    "_origin": "string",
    "answer_option_id": "string",
    "answer_option_text": "string",
    "answer_option_value": "string",
    "evaluation_form_id": "string",
    "evaluation_form_name": "string",
    "form_context_id": "string",
    "question_group_id": "string",
    "question_group_name": "string",
    "question_id": "string",
    "question_manual_weight": "string",
    "question_text": "string",
    "question_weight": "string"
}

schema_name_id: 851
schema_scan_id: 162140815
updated: 2026-04-16 15:05:07

Version 1717113

created: 2026-04-16 13:04:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_evaluation_forms`\n(\n`form_context_id`STRING,`evaluation_form_id`STRING,`evaluation_form_name`STRING,`question_group_name`STRING,`question_group_id`STRING,`question_text`STRING,`question_id`STRING,`answer_option_id`STRING,`answer_option_text`STRING,`answer_option_value`STRING,`question_weight`STRING,`question_manual_weight`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/evaluation_forms/2026-04-16/1776362470'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/evaluation_forms/2026-04-16/1776362470
id: 1717113
processed: 1

raw_data:

{
    "_origin": "2026-04-16T13:01:10Z|raw/evaluation_forms/2026-04-16/1776362470/data.json.gz|airflow_genesys_prod",
    "answer_option_id": "a40dad1b-a76c-4101-aaff-eb4852a9468d",
    "answer_option_text": "Yes",
    "answer_option_value": 2,
    "evaluation_form_id": "0a1031e9-20b9-4674-9e49-4e44ae95199c",
    "evaluation_form_name": "Adapted Sales Process Quality Form",
    "form_context_id": "af0a5ce4-4e58-41a1-b9d2-0a4a6bda859f",
    "question_group_id": "3f8f8dc2-b87c-41c6-9deb-0297711426af",
    "question_group_name": "Intake",
    "question_id": "64b4f67b-cb8e-43ef-bdba-313076dae5b5",
    "question_manual_weight": false,
    "question_text": "Did the agent ask the customer if they were looking at a specific location or if they just needed help finding the best deal? ",
    "question_weight": 100.0
}

schema_attributes:

{
    "_origin": "string",
    "answer_option_id": "string",
    "answer_option_text": "string",
    "answer_option_value": "string",
    "evaluation_form_id": "string",
    "evaluation_form_name": "string",
    "form_context_id": "string",
    "question_group_id": "string",
    "question_group_name": "string",
    "question_id": "string",
    "question_manual_weight": "string",
    "question_text": "string",
    "question_weight": "string"
}

schema_name_id: 851
schema_scan_id: 162134678
updated: 2026-04-16 13:04:18

Version 1717075

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_evaluation_forms`\n(\n`form_context_id`STRING,`evaluation_form_id`STRING,`evaluation_form_name`STRING,`question_group_name`STRING,`question_group_id`STRING,`question_text`STRING,`question_id`STRING,`answer_option_id`STRING,`answer_option_text`STRING,`answer_option_value`STRING,`question_weight`STRING,`question_manual_weight`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/evaluation_forms/2026-04-16/1776355271'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/evaluation_forms/2026-04-16/1776355271
id: 1717075
processed: 1

raw_data:

{
    "_origin": "2026-04-16T11:01:11Z|raw/evaluation_forms/2026-04-16/1776355271/data.json.gz|airflow_genesys_prod",
    "answer_option_id": "a40dad1b-a76c-4101-aaff-eb4852a9468d",
    "answer_option_text": "Yes",
    "answer_option_value": 2,
    "evaluation_form_id": "0a1031e9-20b9-4674-9e49-4e44ae95199c",
    "evaluation_form_name": "Adapted Sales Process Quality Form",
    "form_context_id": "af0a5ce4-4e58-41a1-b9d2-0a4a6bda859f",
    "question_group_id": "3f8f8dc2-b87c-41c6-9deb-0297711426af",
    "question_group_name": "Intake",
    "question_id": "64b4f67b-cb8e-43ef-bdba-313076dae5b5",
    "question_manual_weight": false,
    "question_text": "Did the agent ask the customer if they were looking at a specific location or if they just needed help finding the best deal? ",
    "question_weight": 100.0
}

schema_attributes:

{
    "_origin": "string",
    "answer_option_id": "string",
    "answer_option_text": "string",
    "answer_option_value": "string",
    "evaluation_form_id": "string",
    "evaluation_form_name": "string",
    "form_context_id": "string",
    "question_group_id": "string",
    "question_group_name": "string",
    "question_id": "string",
    "question_manual_weight": "string",
    "question_text": "string",
    "question_weight": "string"
}

schema_name_id: 851
schema_scan_id: 162127877
updated: 2026-04-16 11:03:10

Version 1716952

created: 2026-04-16 09:04:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_evaluation_forms`\n(\n`form_context_id`STRING,`evaluation_form_id`STRING,`evaluation_form_name`STRING,`question_group_name`STRING,`question_group_id`STRING,`question_text`STRING,`question_id`STRING,`answer_option_id`STRING,`answer_option_text`STRING,`answer_option_value`STRING,`question_weight`STRING,`question_manual_weight`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/evaluation_forms/2026-04-16/1776348076'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/evaluation_forms/2026-04-16/1776348076
id: 1716952
processed: 1

raw_data:

{
    "_origin": "2026-04-16T09:01:16Z|raw/evaluation_forms/2026-04-16/1776348076/data.json.gz|airflow_genesys_prod",
    "answer_option_id": "a40dad1b-a76c-4101-aaff-eb4852a9468d",
    "answer_option_text": "Yes",
    "answer_option_value": 2,
    "evaluation_form_id": "0a1031e9-20b9-4674-9e49-4e44ae95199c",
    "evaluation_form_name": "Adapted Sales Process Quality Form",
    "form_context_id": "af0a5ce4-4e58-41a1-b9d2-0a4a6bda859f",
    "question_group_id": "3f8f8dc2-b87c-41c6-9deb-0297711426af",
    "question_group_name": "Intake",
    "question_id": "64b4f67b-cb8e-43ef-bdba-313076dae5b5",
    "question_manual_weight": false,
    "question_text": "Did the agent ask the customer if they were looking at a specific location or if they just needed help finding the best deal? ",
    "question_weight": 100.0
}

schema_attributes:

{
    "_origin": "string",
    "answer_option_id": "string",
    "answer_option_text": "string",
    "answer_option_value": "string",
    "evaluation_form_id": "string",
    "evaluation_form_name": "string",
    "form_context_id": "string",
    "question_group_id": "string",
    "question_group_name": "string",
    "question_id": "string",
    "question_manual_weight": "string",
    "question_text": "string",
    "question_weight": "string"
}

schema_name_id: 851
schema_scan_id: 162122127
updated: 2026-04-16 09:04:15

Version 1716827

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_evaluation_forms`\n(\n`form_context_id`STRING,`evaluation_form_id`STRING,`evaluation_form_name`STRING,`question_group_name`STRING,`question_group_id`STRING,`question_text`STRING,`question_id`STRING,`answer_option_id`STRING,`answer_option_text`STRING,`answer_option_value`STRING,`question_weight`STRING,`question_manual_weight`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/evaluation_forms/2026-04-16/1776340874'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/evaluation_forms/2026-04-16/1776340874
id: 1716827
processed: 1

raw_data:

{
    "_origin": "2026-04-16T07:01:14Z|raw/evaluation_forms/2026-04-15/1776340874/data.json.gz|airflow_genesys_prod",
    "answer_option_id": "a40dad1b-a76c-4101-aaff-eb4852a9468d",
    "answer_option_text": "Yes",
    "answer_option_value": 2,
    "evaluation_form_id": "0a1031e9-20b9-4674-9e49-4e44ae95199c",
    "evaluation_form_name": "Adapted Sales Process Quality Form",
    "form_context_id": "af0a5ce4-4e58-41a1-b9d2-0a4a6bda859f",
    "question_group_id": "3f8f8dc2-b87c-41c6-9deb-0297711426af",
    "question_group_name": "Intake",
    "question_id": "64b4f67b-cb8e-43ef-bdba-313076dae5b5",
    "question_manual_weight": false,
    "question_text": "Did the agent ask the customer if they were looking at a specific location or if they just needed help finding the best deal? ",
    "question_weight": 100.0
}

schema_attributes:

{
    "_origin": "string",
    "answer_option_id": "string",
    "answer_option_text": "string",
    "answer_option_value": "string",
    "evaluation_form_id": "string",
    "evaluation_form_name": "string",
    "form_context_id": "string",
    "question_group_id": "string",
    "question_group_name": "string",
    "question_id": "string",
    "question_manual_weight": "string",
    "question_text": "string",
    "question_weight": "string"
}

schema_name_id: 851
schema_scan_id: 162117226
updated: 2026-04-16 07:01:53

Version 1716033

created: 2026-04-15 17:05:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_evaluation_forms`\n(\n`form_context_id`STRING,`evaluation_form_id`STRING,`evaluation_form_name`STRING,`question_group_name`STRING,`question_group_id`STRING,`question_text`STRING,`question_id`STRING,`answer_option_id`STRING,`answer_option_text`STRING,`answer_option_value`STRING,`question_weight`STRING,`question_manual_weight`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/evaluation_forms/2026-04-15/1776290470'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/evaluation_forms/2026-04-15/1776290470
id: 1716033
processed: 1

raw_data:

{
    "_origin": "2026-04-15T17:01:10Z|raw/evaluation_forms/2026-04-15/1776290470/data.json.gz|airflow_genesys_prod",
    "answer_option_id": "a40dad1b-a76c-4101-aaff-eb4852a9468d",
    "answer_option_text": "Yes",
    "answer_option_value": 2,
    "evaluation_form_id": "0a1031e9-20b9-4674-9e49-4e44ae95199c",
    "evaluation_form_name": "Adapted Sales Process Quality Form",
    "form_context_id": "af0a5ce4-4e58-41a1-b9d2-0a4a6bda859f",
    "question_group_id": "3f8f8dc2-b87c-41c6-9deb-0297711426af",
    "question_group_name": "Intake",
    "question_id": "64b4f67b-cb8e-43ef-bdba-313076dae5b5",
    "question_manual_weight": false,
    "question_text": "Did the agent ask the customer if they were looking at a specific location or if they just needed help finding the best deal? ",
    "question_weight": 100.0
}

schema_attributes:

{
    "_origin": "string",
    "answer_option_id": "string",
    "answer_option_text": "string",
    "answer_option_value": "string",
    "evaluation_form_id": "string",
    "evaluation_form_name": "string",
    "form_context_id": "string",
    "question_group_id": "string",
    "question_group_name": "string",
    "question_id": "string",
    "question_manual_weight": "string",
    "question_text": "string",
    "question_weight": "string"
}

schema_name_id: 851
schema_scan_id: 162090687
updated: 2026-04-15 17:05:42

Version 1716016

created: 2026-04-15 15:02:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_evaluation_forms`\n(\n`form_context_id`STRING,`evaluation_form_id`STRING,`evaluation_form_name`STRING,`question_group_name`STRING,`question_group_id`STRING,`question_text`STRING,`question_id`STRING,`answer_option_id`STRING,`answer_option_text`STRING,`answer_option_value`STRING,`question_weight`STRING,`question_manual_weight`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/evaluation_forms/2026-04-15/1776283270'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/evaluation_forms/2026-04-15/1776283270
id: 1716016
processed: 1

raw_data:

{
    "_origin": "2026-04-15T15:01:10Z|raw/evaluation_forms/2026-04-15/1776283270/data.json.gz|airflow_genesys_prod",
    "answer_option_id": "a40dad1b-a76c-4101-aaff-eb4852a9468d",
    "answer_option_text": "Yes",
    "answer_option_value": 2,
    "evaluation_form_id": "0a1031e9-20b9-4674-9e49-4e44ae95199c",
    "evaluation_form_name": "Adapted Sales Process Quality Form",
    "form_context_id": "af0a5ce4-4e58-41a1-b9d2-0a4a6bda859f",
    "question_group_id": "3f8f8dc2-b87c-41c6-9deb-0297711426af",
    "question_group_name": "Intake",
    "question_id": "64b4f67b-cb8e-43ef-bdba-313076dae5b5",
    "question_manual_weight": false,
    "question_text": "Did the agent ask the customer if they were looking at a specific location or if they just needed help finding the best deal? ",
    "question_weight": 100.0
}

schema_attributes:

{
    "_origin": "string",
    "answer_option_id": "string",
    "answer_option_text": "string",
    "answer_option_value": "string",
    "evaluation_form_id": "string",
    "evaluation_form_name": "string",
    "form_context_id": "string",
    "question_group_id": "string",
    "question_group_name": "string",
    "question_id": "string",
    "question_manual_weight": "string",
    "question_text": "string",
    "question_weight": "string"
}

schema_name_id: 851
schema_scan_id: 162084453
updated: 2026-04-15 15:02:18

Version 1715912

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_evaluation_forms`\n(\n`form_context_id`STRING,`evaluation_form_id`STRING,`evaluation_form_name`STRING,`question_group_name`STRING,`question_group_id`STRING,`question_text`STRING,`question_id`STRING,`answer_option_id`STRING,`answer_option_text`STRING,`answer_option_value`STRING,`question_weight`STRING,`question_manual_weight`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/evaluation_forms/2026-04-15/1776276071'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/evaluation_forms/2026-04-15/1776276071
id: 1715912
processed: 1

raw_data:

{
    "_origin": "2026-04-15T13:01:11Z|raw/evaluation_forms/2026-04-15/1776276071/data.json.gz|airflow_genesys_prod",
    "answer_option_id": "a40dad1b-a76c-4101-aaff-eb4852a9468d",
    "answer_option_text": "Yes",
    "answer_option_value": 2,
    "evaluation_form_id": "0a1031e9-20b9-4674-9e49-4e44ae95199c",
    "evaluation_form_name": "Adapted Sales Process Quality Form",
    "form_context_id": "af0a5ce4-4e58-41a1-b9d2-0a4a6bda859f",
    "question_group_id": "3f8f8dc2-b87c-41c6-9deb-0297711426af",
    "question_group_name": "Intake",
    "question_id": "64b4f67b-cb8e-43ef-bdba-313076dae5b5",
    "question_manual_weight": false,
    "question_text": "Did the agent ask the customer if they were looking at a specific location or if they just needed help finding the best deal? ",
    "question_weight": 100.0
}

schema_attributes:

{
    "_origin": "string",
    "answer_option_id": "string",
    "answer_option_text": "string",
    "answer_option_value": "string",
    "evaluation_form_id": "string",
    "evaluation_form_name": "string",
    "form_context_id": "string",
    "question_group_id": "string",
    "question_group_name": "string",
    "question_id": "string",
    "question_manual_weight": "string",
    "question_text": "string",
    "question_weight": "string"
}

schema_name_id: 851
schema_scan_id: 162078365
updated: 2026-04-15 13:03:06

Version 1715866

created: 2026-04-15 11:04:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_evaluation_forms`\n(\n`form_context_id`STRING,`evaluation_form_id`STRING,`evaluation_form_name`STRING,`question_group_name`STRING,`question_group_id`STRING,`question_text`STRING,`question_id`STRING,`answer_option_id`STRING,`answer_option_text`STRING,`answer_option_value`STRING,`question_weight`STRING,`question_manual_weight`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/evaluation_forms/2026-04-15/1776268871'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/evaluation_forms/2026-04-15/1776268871
id: 1715866
processed: 1

raw_data:

{
    "_origin": "2026-04-15T11:01:11Z|raw/evaluation_forms/2026-04-15/1776268871/data.json.gz|airflow_genesys_prod",
    "answer_option_id": "a40dad1b-a76c-4101-aaff-eb4852a9468d",
    "answer_option_text": "Yes",
    "answer_option_value": 2,
    "evaluation_form_id": "0a1031e9-20b9-4674-9e49-4e44ae95199c",
    "evaluation_form_name": "Adapted Sales Process Quality Form",
    "form_context_id": "af0a5ce4-4e58-41a1-b9d2-0a4a6bda859f",
    "question_group_id": "3f8f8dc2-b87c-41c6-9deb-0297711426af",
    "question_group_name": "Intake",
    "question_id": "64b4f67b-cb8e-43ef-bdba-313076dae5b5",
    "question_manual_weight": false,
    "question_text": "Did the agent ask the customer if they were looking at a specific location or if they just needed help finding the best deal? ",
    "question_weight": 100.0
}

schema_attributes:

{
    "_origin": "string",
    "answer_option_id": "string",
    "answer_option_text": "string",
    "answer_option_value": "string",
    "evaluation_form_id": "string",
    "evaluation_form_name": "string",
    "form_context_id": "string",
    "question_group_id": "string",
    "question_group_name": "string",
    "question_id": "string",
    "question_manual_weight": "string",
    "question_text": "string",
    "question_weight": "string"
}

schema_name_id: 851
schema_scan_id: 162072322
updated: 2026-04-15 11:04:55

Version 1715811

created: 2026-04-15 09:07:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_evaluation_forms`\n(\n`form_context_id`STRING,`evaluation_form_id`STRING,`evaluation_form_name`STRING,`question_group_name`STRING,`question_group_id`STRING,`question_text`STRING,`question_id`STRING,`answer_option_id`STRING,`answer_option_text`STRING,`answer_option_value`STRING,`question_weight`STRING,`question_manual_weight`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/evaluation_forms/2026-04-15/1776261676'\n",
    "MSCK REPAIR TABLE sfdl_prod_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-prod/raw/evaluation_forms/2026-04-15/1776261676
id: 1715811
processed: 1

raw_data:

{
    "_origin": "2026-04-15T09:01:16Z|raw/evaluation_forms/2026-04-15/1776261676/data.json.gz|airflow_genesys_prod",
    "answer_option_id": "a40dad1b-a76c-4101-aaff-eb4852a9468d",
    "answer_option_text": "Yes",
    "answer_option_value": 2,
    "evaluation_form_id": "0a1031e9-20b9-4674-9e49-4e44ae95199c",
    "evaluation_form_name": "Adapted Sales Process Quality Form",
    "form_context_id": "af0a5ce4-4e58-41a1-b9d2-0a4a6bda859f",
    "question_group_id": "3f8f8dc2-b87c-41c6-9deb-0297711426af",
    "question_group_name": "Intake",
    "question_id": "64b4f67b-cb8e-43ef-bdba-313076dae5b5",
    "question_manual_weight": false,
    "question_text": "Did the agent ask the customer if they were looking at a specific location or if they just needed help finding the best deal? ",
    "question_weight": 100.0
}

schema_attributes:

{
    "_origin": "string",
    "answer_option_id": "string",
    "answer_option_text": "string",
    "answer_option_value": "string",
    "evaluation_form_id": "string",
    "evaluation_form_name": "string",
    "form_context_id": "string",
    "question_group_id": "string",
    "question_group_name": "string",
    "question_id": "string",
    "question_manual_weight": "string",
    "question_text": "string",
    "question_weight": "string"
}

schema_name_id: 851
schema_scan_id: 162066458
updated: 2026-04-15 09:07:51

Schema Scans: 15

Last at 2026-04-17 13:02:59

Scan 162190398
- duration: 0:00:21.387979
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162190398
- 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/evaluation_forms/2026-04-17/1776448872",
        "key": "raw/evaluation_forms/2026-04-17/1776448872/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 851
- start_time: 2026-04-17 13:02:59
- success: True
- trace_id: 1374335769831834873

Scan 162184009
- duration: 0:00:32.252195
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162184009
- 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/evaluation_forms/2026-04-17/1776441668",
        "key": "raw/evaluation_forms/2026-04-17/1776441668/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 851
- start_time: 2026-04-17 11:03:44
- success: True
- trace_id: 17273957145697584019

Scan 162177827
- duration: 0:00:25.601218
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162177827
- 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/evaluation_forms/2026-04-17/1776434477",
        "key": "raw/evaluation_forms/2026-04-17/1776434477/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 851
- start_time: 2026-04-17 09:04:16
- success: True
- trace_id: 12832229494863084014

Scan 162172995
- duration: 0:00:22.676752
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162172995
- 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/evaluation_forms/2026-04-17/1776427277",
        "key": "raw/evaluation_forms/2026-04-17/1776427277/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 851
- start_time: 2026-04-17 07:01:30
- success: True
- trace_id: 7756904140493393763

Scan 162146831
- duration: 0:00:25.589916
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162146831
- 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/evaluation_forms/2026-04-16/1776376869",
        "key": "raw/evaluation_forms/2026-04-16/1776376869/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 851
- start_time: 2026-04-16 17:01:34
- success: True
- trace_id: 2760068497559992187

Scan 162140815
- duration: 0:00:22.090057
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162140815
- 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/evaluation_forms/2026-04-16/1776369671",
        "key": "raw/evaluation_forms/2026-04-16/1776369671/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 851
- start_time: 2026-04-16 15:04:44
- success: True
- trace_id: 13297266348541123948

Scan 162134678
- duration: 0:00:22.860045
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162134678
- 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/evaluation_forms/2026-04-16/1776362470",
        "key": "raw/evaluation_forms/2026-04-16/1776362470/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 851
- start_time: 2026-04-16 13:03:55
- success: True
- trace_id: 5524444690348700924

Scan 162127877
- duration: 0:00:22.426875
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162127877
- 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/evaluation_forms/2026-04-16/1776355271",
        "key": "raw/evaluation_forms/2026-04-16/1776355271/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 851
- start_time: 2026-04-16 11:02:47
- success: True
- trace_id: 16136083152623535394

Scan 162122127
- duration: 0:00:26.945526
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162122127
- 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/evaluation_forms/2026-04-16/1776348076",
        "key": "raw/evaluation_forms/2026-04-16/1776348076/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 851
- start_time: 2026-04-16 09:03:48
- success: True
- trace_id: 3126272825828599863

Scan 162117226
- duration: 0:00:25.732011
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162117226
- 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/evaluation_forms/2026-04-16/1776340874",
        "key": "raw/evaluation_forms/2026-04-16/1776340874/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 851
- start_time: 2026-04-16 07:01:28
- success: True
- trace_id: 2972215709181883118

Scan 162090687
- duration: 0:00:25.259410
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162090687
- 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/evaluation_forms/2026-04-15/1776290470",
        "key": "raw/evaluation_forms/2026-04-15/1776290470/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 851
- start_time: 2026-04-15 17:05:17
- success: True
- trace_id: 12547453587724374317

Scan 162084453
- duration: 0:00:22.145451
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162084453
- 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/evaluation_forms/2026-04-15/1776283270",
        "key": "raw/evaluation_forms/2026-04-15/1776283270/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 851
- start_time: 2026-04-15 15:01:56
- success: True
- trace_id: 12066522173632342819

Scan 162078365
- duration: 0:00:23.209814
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162078365
- 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/evaluation_forms/2026-04-15/1776276071",
        "key": "raw/evaluation_forms/2026-04-15/1776276071/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 851
- start_time: 2026-04-15 13:02:43
- success: True
- trace_id: 460899275036489758

Scan 162072322
- duration: 0:00:23.122634
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162072322
- 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/evaluation_forms/2026-04-15/1776268871",
        "key": "raw/evaluation_forms/2026-04-15/1776268871/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 851
- start_time: 2026-04-15 11:04:32
- success: True
- trace_id: 14962405881655102609

Scan 162066458
- duration: 0:00:25.758305
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 162066458
- 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/evaluation_forms/2026-04-15/1776261676",
        "key": "raw/evaluation_forms/2026-04-15/1776261676/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 851
- start_time: 2026-04-15 09:07:25
- success: True
- trace_id: 17406544711497046948

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "answer_option_id": "string",
    "answer_option_text": "string",
    "answer_option_value": "string",
    "evaluation_form_id": "string",
    "evaluation_form_name": "string",
    "form_context_id": "string",
    "question_group_id": "string",
    "question_group_name": "string",
    "question_id": "string",
    "question_manual_weight": "string",
    "question_text": "string",
    "question_weight": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_evaluation_forms`\n(\n`form_context_id`STRING,`evaluation_form_id`STRING,`evaluation_form_name`STRING,`question_group_name`STRING,`question_group_id`STRING,`question_text`STRING,`question_id`STRING,`answer_option_id`STRING,`answer_option_text`STRING,`answer_option_value`STRING,`question_weight`STRING,`question_manual_weight`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/evaluation_forms/2026-04-17/1776448872'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_evaluation_forms`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_manual.genesys_evaluation_forms"
}

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:25",
        "disabled": false,
        "format": "raw",
        "id": 851,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_manual",
            "table": "genesys_evaluation_forms"
        },
        "type": "manual"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "answer_option_id": "string",
            "answer_option_text": "string",
            "answer_option_value": "string",
            "evaluation_form_id": "string",
            "evaluation_form_name": "string",
            "form_context_id": "string",
            "question_group_id": "string",
            "question_group_name": "string",
            "question_id": "string",
            "question_manual_weight": "string",
            "question_text": "string",
            "question_weight": "string"
        },
        "created": "2026-04-17 13:03:09",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_manual`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_manual.genesys_evaluation_forms`\n(\n`form_context_id`STRING,`evaluation_form_id`STRING,`evaluation_form_name`STRING,`question_group_name`STRING,`question_group_id`STRING,`question_text`STRING,`question_id`STRING,`answer_option_id`STRING,`answer_option_text`STRING,`answer_option_value`STRING,`question_weight`STRING,`question_manual_weight`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/evaluation_forms/2026-04-17/1776448872'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_manual.genesys_evaluation_forms`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_manual.genesys_evaluation_forms"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}