Schema Info

Schema Name: sfdl_stage_manual.genesys_evaluation_forms

created: 2021-04-08 14:32:09
disabled: False
format: raw
id: 1040
is_partitioned: False
is_schema_datatyped: False

name:

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

type: manual

Schema Versions: 15

Version 906684

created: 2026-04-17 09:01:52

ddl:

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

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

raw_data:

{
    "_origin": "2026-04-17T09:01:17Z|raw/evaluation_forms/2026-04-17/1776434477/data.json.gz|airflow_genesys_stage",
    "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: 1040
schema_scan_id: 6415310
updated: 2026-04-17 09:02:06

Version 906666

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

ddl:

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

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

raw_data:

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

Version 906516

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

ddl:

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

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

raw_data:

{
    "_origin": "2026-04-16T17:01:09Z|raw/evaluation_forms/2026-04-16/1776376869/data.json.gz|airflow_genesys_stage",
    "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: 1040
schema_scan_id: 6415049
updated: 2026-04-16 17:01:44

Version 906514

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

ddl:

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

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

raw_data:

{
    "_origin": "2026-04-16T15:01:11Z|raw/evaluation_forms/2026-04-16/1776369671/data.json.gz|airflow_genesys_stage",
    "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: 1040
schema_scan_id: 6415032
updated: 2026-04-16 15:01:57

Version 906512

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

ddl:

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

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

raw_data:

{
    "_origin": "2026-04-16T13:01:10Z|raw/evaluation_forms/2026-04-16/1776362470/data.json.gz|airflow_genesys_stage",
    "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: 1040
schema_scan_id: 6415003
updated: 2026-04-16 13:01:37

Version 906506

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

ddl:

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

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

raw_data:

{
    "_origin": "2026-04-16T11:01:11Z|raw/evaluation_forms/2026-04-16/1776355271/data.json.gz|airflow_genesys_stage",
    "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: 1040
schema_scan_id: 6414969
updated: 2026-04-16 11:01:52

Version 906466

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

ddl:

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

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

raw_data:

{
    "_origin": "2026-04-16T09:01:16Z|raw/evaluation_forms/2026-04-16/1776348076/data.json.gz|airflow_genesys_stage",
    "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: 1040
schema_scan_id: 6414771
updated: 2026-04-16 09:01:56

Version 906447

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

ddl:

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

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

raw_data:

{
    "_origin": "2026-04-16T07:01:11Z|raw/evaluation_forms/2026-04-15/1776340871/data.json.gz|airflow_genesys_stage",
    "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: 1040
schema_scan_id: 6414714
updated: 2026-04-16 07:01:37

Version 906301

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

ddl:

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

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

raw_data:

{
    "_origin": "2026-04-15T17:01:10Z|raw/evaluation_forms/2026-04-15/1776290470/data.json.gz|airflow_genesys_stage",
    "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: 1040
schema_scan_id: 6414501
updated: 2026-04-15 17:01:53

Version 906299

created: 2026-04-15 15:01:38

ddl:

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

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

raw_data:

{
    "_origin": "2026-04-15T15:01:10Z|raw/evaluation_forms/2026-04-15/1776283270/data.json.gz|airflow_genesys_stage",
    "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: 1040
schema_scan_id: 6414486
updated: 2026-04-15 15:01:49

Version 906297

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

ddl:

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

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

raw_data:

{
    "_origin": "2026-04-15T13:01:11Z|raw/evaluation_forms/2026-04-15/1776276071/data.json.gz|airflow_genesys_stage",
    "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: 1040
schema_scan_id: 6414468
updated: 2026-04-15 13:01:42

Version 906291

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

ddl:

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

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

raw_data:

{
    "_origin": "2026-04-15T11:01:11Z|raw/evaluation_forms/2026-04-15/1776268871/data.json.gz|airflow_genesys_stage",
    "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: 1040
schema_scan_id: 6414441
updated: 2026-04-15 11:01:48

Version 906253

created: 2026-04-15 09:01:39

ddl:

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

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

raw_data:

{
    "_origin": "2026-04-15T09:01:16Z|raw/evaluation_forms/2026-04-15/1776261676/data.json.gz|airflow_genesys_stage",
    "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: 1040
schema_scan_id: 6414272
updated: 2026-04-15 09:01:53

Version 906234

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

ddl:

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

hive_path: s3://sfdl-manual-genesys-stage/raw/evaluation_forms/2026-04-15/1776254472
id: 906234
processed: 1

raw_data:

{
    "_origin": "2026-04-15T07:01:12Z|raw/evaluation_forms/2026-04-14/1776254472/data.json.gz|airflow_genesys_stage",
    "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: 1040
schema_scan_id: 6414227
updated: 2026-04-15 07:01:55

Version 906088

created: 2026-04-14 17:01:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
    "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_evaluation_forms`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/evaluation_forms/2026-04-14/1776204070'\n",
    "MSCK REPAIR TABLE sfdl_stage_manual.genesys_evaluation_forms"
]

hive_path: s3://sfdl-manual-genesys-stage/raw/evaluation_forms/2026-04-14/1776204070
id: 906088
processed: 1

raw_data:

{
    "_origin": "2026-04-14T17:01:10Z|raw/evaluation_forms/2026-04-14/1776204070/data.json.gz|airflow_genesys_stage",
    "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: 1040
schema_scan_id: 6414014
updated: 2026-04-14 17:01:48

Schema Scans: 15

Last at 2026-04-17 09:01:38

Scan 6415310
- duration: 0:00:28.223239
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6415310
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/evaluation_forms/2026-04-17/1776434477",
        "key": "raw/evaluation_forms/2026-04-17/1776434477/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1040
- start_time: 2026-04-17 09:01:38
- success: True
- trace_id: 9106487573566571852

Scan 6415263
- duration: 0:00:26.251256
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6415263
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/evaluation_forms/2026-04-17/1776427273",
        "key": "raw/evaluation_forms/2026-04-17/1776427273/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1040
- start_time: 2026-04-17 07:01:26
- success: True
- trace_id: 9953576534001443510

Scan 6415049
- duration: 0:00:24.508487
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6415049
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/evaluation_forms/2026-04-16/1776376869",
        "key": "raw/evaluation_forms/2026-04-16/1776376869/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1040
- start_time: 2026-04-16 17:01:19
- success: True
- trace_id: 8205103770837776531

Scan 6415032
- duration: 0:00:26.303723
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6415032
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/evaluation_forms/2026-04-16/1776369671",
        "key": "raw/evaluation_forms/2026-04-16/1776369671/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1040
- start_time: 2026-04-16 15:01:30
- success: True
- trace_id: 15032887895736338008

Scan 6415003
- duration: 0:00:25.515763
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6415003
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/evaluation_forms/2026-04-16/1776362470",
        "key": "raw/evaluation_forms/2026-04-16/1776362470/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1040
- start_time: 2026-04-16 13:01:12
- success: True
- trace_id: 14694600132995368676

Scan 6414969
- duration: 0:00:24.968136
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6414969
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/evaluation_forms/2026-04-16/1776355271",
        "key": "raw/evaluation_forms/2026-04-16/1776355271/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1040
- start_time: 2026-04-16 11:01:27
- success: True
- trace_id: 15428310383049565170

Scan 6414771
- duration: 0:00:24.678114
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6414771
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/evaluation_forms/2026-04-16/1776348076",
        "key": "raw/evaluation_forms/2026-04-16/1776348076/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1040
- start_time: 2026-04-16 09:01:31
- success: True
- trace_id: 11037243133260074223

Scan 6414714
- duration: 0:00:24.238380
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6414714
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/evaluation_forms/2026-04-16/1776340871",
        "key": "raw/evaluation_forms/2026-04-16/1776340871/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1040
- start_time: 2026-04-16 07:01:13
- success: True
- trace_id: 10199584256108043767

Scan 6414501
- duration: 0:00:27.759876
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6414501
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/evaluation_forms/2026-04-15/1776290470",
        "key": "raw/evaluation_forms/2026-04-15/1776290470/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1040
- start_time: 2026-04-15 17:01:25
- success: True
- trace_id: 12246545377966260306

Scan 6414486
- duration: 0:00:25.425949
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6414486
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/evaluation_forms/2026-04-15/1776283270",
        "key": "raw/evaluation_forms/2026-04-15/1776283270/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1040
- start_time: 2026-04-15 15:01:24
- success: True
- trace_id: 3370094074705470163

Scan 6414468
- duration: 0:00:24.650054
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6414468
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/evaluation_forms/2026-04-15/1776276071",
        "key": "raw/evaluation_forms/2026-04-15/1776276071/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1040
- start_time: 2026-04-15 13:01:17
- success: True
- trace_id: 13784321523261931408

Scan 6414441
- duration: 0:00:25.776852
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6414441
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/evaluation_forms/2026-04-15/1776268871",
        "key": "raw/evaluation_forms/2026-04-15/1776268871/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1040
- start_time: 2026-04-15 11:01:22
- success: True
- trace_id: 6544160019254914249

Scan 6414272
- duration: 0:00:27.273364
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6414272
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/evaluation_forms/2026-04-15/1776261676",
        "key": "raw/evaluation_forms/2026-04-15/1776261676/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1040
- start_time: 2026-04-15 09:01:26
- success: True
- trace_id: 13698608490579276190

Scan 6414227
- duration: 0:00:26.878394
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6414227
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/evaluation_forms/2026-04-15/1776254472",
        "key": "raw/evaluation_forms/2026-04-15/1776254472/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1040
- start_time: 2026-04-15 07:01:28
- success: True
- trace_id: 15170982786166365701

Scan 6414014
- duration: 0:00:29.225524
- exit_message:
```
{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
```
- id: 6414014
- payload:
```
{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-manual-genesys-stage",
        "hive_path": "s3://sfdl-manual-genesys-stage/raw/evaluation_forms/2026-04-14/1776204070",
        "key": "raw/evaluation_forms/2026-04-14/1776204070/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_manual.genesys_evaluation_forms",
        "type": "manual"
    }
}
```
- running: False
- schema_name_id: 1040
- start_time: 2026-04-14 17:01:19
- success: True
- trace_id: 14096624263607596512

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 09:01:52

ddl:

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

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2021-04-08 14:32:09",
        "disabled": false,
        "format": "raw",
        "id": 1040,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_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 09:01:52",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_manual`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/evaluation_forms/2026-04-17/1776434477'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_manual.genesys_evaluation_forms`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_manual.genesys_evaluation_forms"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}