Schema Info

Schema Name: sfdl_dev_manual.genesys_evaluation_forms

created: 2021-04-05 12:52:56
disabled: False
format: raw
id: 1561
is_partitioned: False
is_schema_datatyped: False

name:

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

type: manual

Schema Versions: 15

Version 4773379

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/evaluation_forms/2026-04-17/1776456090'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-dev/raw/evaluation_forms/2026-04-17/1776456090
id: 4773379
processed: 1

raw_data:

{
    "_origin": "2026-04-17T15:01:30Z|raw/evaluation_forms/2026-04-17/1776456090/data.json.gz|airflow_genesys_dev",
    "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: 1561
schema_scan_id: 6867857
updated: 2026-04-17 15:02:19

Version 4773377

created: 2026-04-17 13:01:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/evaluation_forms/2026-04-17/1776448894'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-dev/raw/evaluation_forms/2026-04-17/1776448894
id: 4773377
processed: 1

raw_data:

{
    "_origin": "2026-04-17T13:01:34Z|raw/evaluation_forms/2026-04-17/1776448894/data.json.gz|airflow_genesys_dev",
    "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: 1561
schema_scan_id: 6867842
updated: 2026-04-17 13:02:02

Version 4773371

created: 2026-04-17 11:01:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/evaluation_forms/2026-04-17/1776441678'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-dev/raw/evaluation_forms/2026-04-17/1776441678
id: 4773371
processed: 1

raw_data:

{
    "_origin": "2026-04-17T11:01:18Z|raw/evaluation_forms/2026-04-17/1776441678/data.json.gz|airflow_genesys_dev",
    "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: 1561
schema_scan_id: 6867820
updated: 2026-04-17 11:02:03

Version 4773368

created: 2026-04-17 09:54:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/evaluation_forms/2026-04-17/1776437665'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-dev/raw/evaluation_forms/2026-04-17/1776437665
id: 4773368
processed: 1

raw_data:

{
    "_origin": "2026-04-17T09:54:25Z|raw/evaluation_forms/2026-04-17/1776437665/data.json.gz|airflow_genesys_dev",
    "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: 1561
schema_scan_id: 6867812
updated: 2026-04-17 09:54:58

Version 4773331

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/evaluation_forms/2026-04-17/1776427273'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-dev/raw/evaluation_forms/2026-04-17/1776427273
id: 4773331
processed: 1

raw_data:

{
    "_origin": "2026-04-17T07:01:13Z|raw/evaluation_forms/2026-04-16/1776427273/data.json.gz|airflow_genesys_dev",
    "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: 1561
schema_scan_id: 6867635
updated: 2026-04-17 07:01:39

Version 4773320

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/evaluation_forms/2026-04-16/1776376871'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-dev/raw/evaluation_forms/2026-04-16/1776376871
id: 4773320
processed: 1

raw_data:

{
    "_origin": "2026-04-16T17:01:11Z|raw/evaluation_forms/2026-04-16/1776376871/data.json.gz|airflow_genesys_dev",
    "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: 1561
schema_scan_id: 6867609
updated: 2026-04-16 17:01:42

Version 4773318

created: 2026-04-16 15:01:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/evaluation_forms/2026-04-16/1776369672'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-dev/raw/evaluation_forms/2026-04-16/1776369672
id: 4773318
processed: 1

raw_data:

{
    "_origin": "2026-04-16T15:01:12Z|raw/evaluation_forms/2026-04-16/1776369672/data.json.gz|airflow_genesys_dev",
    "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: 1561
schema_scan_id: 6867594
updated: 2026-04-16 15:01:40

Version 4773316

created: 2026-04-16 13:01:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/evaluation_forms/2026-04-16/1776362472'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-dev/raw/evaluation_forms/2026-04-16/1776362472
id: 4773316
processed: 1

raw_data:

{
    "_origin": "2026-04-16T13:01:12Z|raw/evaluation_forms/2026-04-16/1776362472/data.json.gz|airflow_genesys_dev",
    "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: 1561
schema_scan_id: 6867579
updated: 2026-04-16 13:01:38

Version 4773310

created: 2026-04-16 11:01:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/evaluation_forms/2026-04-16/1776355271'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_evaluation_forms"
]

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

raw_data:

{
    "_origin": "2026-04-16T11:01:11Z|raw/evaluation_forms/2026-04-16/1776355271/data.json.gz|airflow_genesys_dev",
    "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: 1561
schema_scan_id: 6867557
updated: 2026-04-16 11:01:44

Version 4773272

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/evaluation_forms/2026-04-16/1776348110'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-dev/raw/evaluation_forms/2026-04-16/1776348110
id: 4773272
processed: 1

raw_data:

{
    "_origin": "2026-04-16T09:01:50Z|raw/evaluation_forms/2026-04-16/1776348110/data.json.gz|airflow_genesys_dev",
    "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: 1561
schema_scan_id: 6867387
updated: 2026-04-16 09:02:20

Version 4773270

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/evaluation_forms/2026-04-16/1776340871'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-dev/raw/evaluation_forms/2026-04-16/1776340871
id: 4773270
processed: 1

raw_data:

{
    "_origin": "2026-04-16T07:01:11Z|raw/evaluation_forms/2026-04-15/1776340871/data.json.gz|airflow_genesys_dev",
    "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: 1561
schema_scan_id: 6867372
updated: 2026-04-16 07:02:08

Version 4773259

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/evaluation_forms/2026-04-15/1776290471'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-dev/raw/evaluation_forms/2026-04-15/1776290471
id: 4773259
processed: 1

raw_data:

{
    "_origin": "2026-04-15T17:01:11Z|raw/evaluation_forms/2026-04-15/1776290471/data.json.gz|airflow_genesys_dev",
    "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: 1561
schema_scan_id: 6867346
updated: 2026-04-15 17:01:42

Version 4773257

created: 2026-04-15 15:01:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/evaluation_forms/2026-04-15/1776283279'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-dev/raw/evaluation_forms/2026-04-15/1776283279
id: 4773257
processed: 1

raw_data:

{
    "_origin": "2026-04-15T15:01:19Z|raw/evaluation_forms/2026-04-15/1776283279/data.json.gz|airflow_genesys_dev",
    "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: 1561
schema_scan_id: 6867331
updated: 2026-04-15 15:01:45

Version 4773255

created: 2026-04-15 13:01:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/evaluation_forms/2026-04-15/1776276075'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-dev/raw/evaluation_forms/2026-04-15/1776276075
id: 4773255
processed: 1

raw_data:

{
    "_origin": "2026-04-15T13:01:15Z|raw/evaluation_forms/2026-04-15/1776276075/data.json.gz|airflow_genesys_dev",
    "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: 1561
schema_scan_id: 6867316
updated: 2026-04-15 13:02:07

Version 4773249

created: 2026-04-15 11:01:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/evaluation_forms/2026-04-15/1776268871'\n",
    "MSCK REPAIR TABLE sfdl_dev_manual.genesys_evaluation_forms"
]

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

raw_data:

{
    "_origin": "2026-04-15T11:01:11Z|raw/evaluation_forms/2026-04-15/1776268871/data.json.gz|airflow_genesys_dev",
    "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: 1561
schema_scan_id: 6867294
updated: 2026-04-15 11:01:41

Schema Scans: 15

Last at 2026-04-17 15:01:53

Scan 6867857
- duration: 0:00:26.292342
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6867857
- 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/evaluation_forms/2026-04-17/1776456090",
        "key": "raw/evaluation_forms/2026-04-17/1776456090/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1561
- start_time: 2026-04-17 15:01:53
- success: True
- trace_id: 15769159874556208316

Scan 6867842
- duration: 0:00:26.235254
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6867842
- 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/evaluation_forms/2026-04-17/1776448894",
        "key": "raw/evaluation_forms/2026-04-17/1776448894/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1561
- start_time: 2026-04-17 13:01:35
- success: True
- trace_id: 12816554777147395551

Scan 6867820
- duration: 0:00:26.745084
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6867820
- 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/evaluation_forms/2026-04-17/1776441678",
        "key": "raw/evaluation_forms/2026-04-17/1776441678/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1561
- start_time: 2026-04-17 11:01:36
- success: True
- trace_id: 12364057882050144733

Scan 6867812
- duration: 0:00:23.960439
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6867812
- 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/evaluation_forms/2026-04-17/1776437665",
        "key": "raw/evaluation_forms/2026-04-17/1776437665/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1561
- start_time: 2026-04-17 09:54:34
- success: True
- trace_id: 3291211899640145915

Scan 6867635
- duration: 0:00:23.600473
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6867635
- 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/evaluation_forms/2026-04-17/1776427273",
        "key": "raw/evaluation_forms/2026-04-17/1776427273/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1561
- start_time: 2026-04-17 07:01:15
- success: True
- trace_id: 11187322598589636990

Scan 6867609
- duration: 0:00:23.772846
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6867609
- 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/evaluation_forms/2026-04-16/1776376871",
        "key": "raw/evaluation_forms/2026-04-16/1776376871/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1561
- start_time: 2026-04-16 17:01:18
- success: True
- trace_id: 12208732707636048187

Scan 6867594
- duration: 0:00:26.260787
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6867594
- 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/evaluation_forms/2026-04-16/1776369672",
        "key": "raw/evaluation_forms/2026-04-16/1776369672/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1561
- start_time: 2026-04-16 15:01:14
- success: True
- trace_id: 3329251082121480013

Scan 6867579
- duration: 0:00:24.029522
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6867579
- 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/evaluation_forms/2026-04-16/1776362472",
        "key": "raw/evaluation_forms/2026-04-16/1776362472/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1561
- start_time: 2026-04-16 13:01:14
- success: True
- trace_id: 5215966442801636285

Scan 6867557
- duration: 0:00:27.092838
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6867557
- 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/evaluation_forms/2026-04-16/1776355271",
        "key": "raw/evaluation_forms/2026-04-16/1776355271/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1561
- start_time: 2026-04-16 11:01:17
- success: True
- trace_id: 11579253326232631916

Scan 6867387
- duration: 0:00:23.424244
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6867387
- 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/evaluation_forms/2026-04-16/1776348110",
        "key": "raw/evaluation_forms/2026-04-16/1776348110/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1561
- start_time: 2026-04-16 09:01:57
- success: True
- trace_id: 17582704338755455472

Scan 6867372
- duration: 0:00:25.910655
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6867372
- 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/evaluation_forms/2026-04-16/1776340871",
        "key": "raw/evaluation_forms/2026-04-16/1776340871/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1561
- start_time: 2026-04-16 07:01:42
- success: True
- trace_id: 15452985567374556086

Scan 6867346
- duration: 0:00:26.842487
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6867346
- 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/evaluation_forms/2026-04-15/1776290471",
        "key": "raw/evaluation_forms/2026-04-15/1776290471/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1561
- start_time: 2026-04-15 17:01:15
- success: True
- trace_id: 1324444412719444376

Scan 6867331
- duration: 0:00:23.244511
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6867331
- 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/evaluation_forms/2026-04-15/1776283279",
        "key": "raw/evaluation_forms/2026-04-15/1776283279/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1561
- start_time: 2026-04-15 15:01:22
- success: True
- trace_id: 6295337063287601021

Scan 6867316
- duration: 0:00:23.559092
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6867316
- 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/evaluation_forms/2026-04-15/1776276075",
        "key": "raw/evaluation_forms/2026-04-15/1776276075/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1561
- start_time: 2026-04-15 13:01:44
- success: True
- trace_id: 194080381579158619

Scan 6867294
- duration: 0:00:27.969881
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6867294
- 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/evaluation_forms/2026-04-15/1776268871",
        "key": "raw/evaluation_forms/2026-04-15/1776268871/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1561
- start_time: 2026-04-15 11:01:13
- success: True
- trace_id: 15558832023717160767

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 15:02:05

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/evaluation_forms/2026-04-17/1776456090'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_evaluation_forms`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_manual.genesys_evaluation_forms"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2021-04-05 12:52:56",
        "disabled": false,
        "format": "raw",
        "id": 1561,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_dev_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 15:02:05",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_manual`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/evaluation_forms/2026-04-17/1776456090'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_manual.genesys_evaluation_forms`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_manual.genesys_evaluation_forms"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}