Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imstest_questions

created: 2023-02-07 01:47:50
disabled: False
format: raw
id: 1487
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_drivethru",
    "table": "stellar_imstest_questions"
}

type: drivethrucsv

Schema Versions: 15

Version 1718009

created: 2026-04-17 04:58:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_questions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_questions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `question`  string , `answer_a`  string , `answer_b`  string , `answer_c`  string , `answer_d`  string , `answer_e`  string , `correct_answer`  string , `position`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-17/1776419654'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_questions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-17/1776419654
id: 1718009
processed: 1

raw_data:

{
    "answer_a": 5,
    "answer_b": 6,
    "answer_c": 7,
    "answer_d": 8,
    "answer_e": 9,
    "correct_answer": 10,
    "created_at": 12,
    "id": 1,
    "location_id": 2,
    "position": 11,
    "question": 4,
    "style_group_id": 3,
    "tenant": 0,
    "updated_at": 13
}

schema_attributes:

{
    "answer_a": "string",
    "answer_b": "string",
    "answer_c": "string",
    "answer_d": "string",
    "answer_e": "string",
    "correct_answer": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "position": "string",
    "question": "string",
    "style_group_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1487
schema_scan_id: 162169357
updated: 2026-04-17 04:58:37

Version 1716794

created: 2026-04-16 05:20:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_questions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_questions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `question`  string , `answer_a`  string , `answer_b`  string , `answer_c`  string , `answer_d`  string , `answer_e`  string , `correct_answer`  string , `position`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-16/1776334555'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_questions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-16/1776334555
id: 1716794
processed: 1

raw_data:

{
    "answer_a": 5,
    "answer_b": 6,
    "answer_c": 7,
    "answer_d": 8,
    "answer_e": 9,
    "correct_answer": 10,
    "created_at": 12,
    "id": 1,
    "location_id": 2,
    "position": 11,
    "question": 4,
    "style_group_id": 3,
    "tenant": 0,
    "updated_at": 13
}

schema_attributes:

{
    "answer_a": "string",
    "answer_b": "string",
    "answer_c": "string",
    "answer_d": "string",
    "answer_e": "string",
    "correct_answer": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "position": "string",
    "question": "string",
    "style_group_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1487
schema_scan_id: 162114470
updated: 2026-04-16 05:20:16

Version 1715526

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_questions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_questions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `question`  string , `answer_a`  string , `answer_b`  string , `answer_c`  string , `answer_d`  string , `answer_e`  string , `correct_answer`  string , `position`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-15/1776242368'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_questions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-15/1776242368
id: 1715526
processed: 1

raw_data:

{
    "answer_a": 5,
    "answer_b": 6,
    "answer_c": 7,
    "answer_d": 8,
    "answer_e": 9,
    "correct_answer": 10,
    "created_at": 12,
    "id": 1,
    "location_id": 2,
    "position": 11,
    "question": 4,
    "style_group_id": 3,
    "tenant": 0,
    "updated_at": 13
}

schema_attributes:

{
    "answer_a": "string",
    "answer_b": "string",
    "answer_c": "string",
    "answer_d": "string",
    "answer_e": "string",
    "correct_answer": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "position": "string",
    "question": "string",
    "style_group_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1487
schema_scan_id: 162056413
updated: 2026-04-15 03:42:54

Version 1714386

created: 2026-04-14 05:04:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_questions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_questions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `question`  string , `answer_a`  string , `answer_b`  string , `answer_c`  string , `answer_d`  string , `answer_e`  string , `correct_answer`  string , `position`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-14/1776160763'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_questions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-14/1776160763
id: 1714386
processed: 1

raw_data:

{
    "answer_a": 5,
    "answer_b": 6,
    "answer_c": 7,
    "answer_d": 8,
    "answer_e": 9,
    "correct_answer": 10,
    "created_at": 12,
    "id": 1,
    "location_id": 2,
    "position": 11,
    "question": 4,
    "style_group_id": 3,
    "tenant": 0,
    "updated_at": 13
}

schema_attributes:

{
    "answer_a": "string",
    "answer_b": "string",
    "answer_c": "string",
    "answer_d": "string",
    "answer_e": "string",
    "correct_answer": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "position": "string",
    "question": "string",
    "style_group_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1487
schema_scan_id: 162003116
updated: 2026-04-14 05:04:24

Version 1713141

created: 2026-04-13 05:09:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_questions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_questions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `question`  string , `answer_a`  string , `answer_b`  string , `answer_c`  string , `answer_d`  string , `answer_e`  string , `correct_answer`  string , `position`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-13/1776074809'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_questions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-13/1776074809
id: 1713141
processed: 1

raw_data:

{
    "answer_a": 5,
    "answer_b": 6,
    "answer_c": 7,
    "answer_d": 8,
    "answer_e": 9,
    "correct_answer": 10,
    "created_at": 12,
    "id": 1,
    "location_id": 2,
    "position": 11,
    "question": 4,
    "style_group_id": 3,
    "tenant": 0,
    "updated_at": 13
}

schema_attributes:

{
    "answer_a": "string",
    "answer_b": "string",
    "answer_c": "string",
    "answer_d": "string",
    "answer_e": "string",
    "correct_answer": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "position": "string",
    "question": "string",
    "style_group_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1487
schema_scan_id: 161945348
updated: 2026-04-13 05:10:05

Version 1711962

created: 2026-04-12 05:07:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_questions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_questions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `question`  string , `answer_a`  string , `answer_b`  string , `answer_c`  string , `answer_d`  string , `answer_e`  string , `correct_answer`  string , `position`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-12/1775988166'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_questions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-12/1775988166
id: 1711962
processed: 1

raw_data:

{
    "answer_a": 5,
    "answer_b": 6,
    "answer_c": 7,
    "answer_d": 8,
    "answer_e": 9,
    "correct_answer": 10,
    "created_at": 12,
    "id": 1,
    "location_id": 2,
    "position": 11,
    "question": 4,
    "style_group_id": 3,
    "tenant": 0,
    "updated_at": 13
}

schema_attributes:

{
    "answer_a": "string",
    "answer_b": "string",
    "answer_c": "string",
    "answer_d": "string",
    "answer_e": "string",
    "correct_answer": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "position": "string",
    "question": "string",
    "style_group_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1487
schema_scan_id: 161896419
updated: 2026-04-12 05:07:30

Version 1710729

created: 2026-04-11 05:18:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_questions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_questions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `question`  string , `answer_a`  string , `answer_b`  string , `answer_c`  string , `answer_d`  string , `answer_e`  string , `correct_answer`  string , `position`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-11/1775902581'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_questions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-11/1775902581
id: 1710729
processed: 1

raw_data:

{
    "answer_a": 5,
    "answer_b": 6,
    "answer_c": 7,
    "answer_d": 8,
    "answer_e": 9,
    "correct_answer": 10,
    "created_at": 12,
    "id": 1,
    "location_id": 2,
    "position": 11,
    "question": 4,
    "style_group_id": 3,
    "tenant": 0,
    "updated_at": 13
}

schema_attributes:

{
    "answer_a": "string",
    "answer_b": "string",
    "answer_c": "string",
    "answer_d": "string",
    "answer_e": "string",
    "correct_answer": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "position": "string",
    "question": "string",
    "style_group_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1487
schema_scan_id: 161843948
updated: 2026-04-11 05:18:43

Version 1709610

created: 2026-04-10 05:04:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_questions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_questions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `question`  string , `answer_a`  string , `answer_b`  string , `answer_c`  string , `answer_d`  string , `answer_e`  string , `correct_answer`  string , `position`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-10/1775815222'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_questions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-10/1775815222
id: 1709610
processed: 1

raw_data:

{
    "answer_a": 5,
    "answer_b": 6,
    "answer_c": 7,
    "answer_d": 8,
    "answer_e": 9,
    "correct_answer": 10,
    "created_at": 12,
    "id": 1,
    "location_id": 2,
    "position": 11,
    "question": 4,
    "style_group_id": 3,
    "tenant": 0,
    "updated_at": 13
}

schema_attributes:

{
    "answer_a": "string",
    "answer_b": "string",
    "answer_c": "string",
    "answer_d": "string",
    "answer_e": "string",
    "correct_answer": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "position": "string",
    "question": "string",
    "style_group_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1487
schema_scan_id: 161788674
updated: 2026-04-10 05:05:04

Version 1708451

created: 2026-04-09 05:04:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_questions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_questions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `question`  string , `answer_a`  string , `answer_b`  string , `answer_c`  string , `answer_d`  string , `answer_e`  string , `correct_answer`  string , `position`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-09/1775728844'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_questions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-09/1775728844
id: 1708451
processed: 1

raw_data:

{
    "answer_a": 5,
    "answer_b": 6,
    "answer_c": 7,
    "answer_d": 8,
    "answer_e": 9,
    "correct_answer": 10,
    "created_at": 12,
    "id": 1,
    "location_id": 2,
    "position": 11,
    "question": 4,
    "style_group_id": 3,
    "tenant": 0,
    "updated_at": 13
}

schema_attributes:

{
    "answer_a": "string",
    "answer_b": "string",
    "answer_c": "string",
    "answer_d": "string",
    "answer_e": "string",
    "correct_answer": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "position": "string",
    "question": "string",
    "style_group_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1487
schema_scan_id: 161733014
updated: 2026-04-09 05:04:32

Version 1707171

created: 2026-04-08 05:10:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_questions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_questions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `question`  string , `answer_a`  string , `answer_b`  string , `answer_c`  string , `answer_d`  string , `answer_e`  string , `correct_answer`  string , `position`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-08/1775642994'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_questions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-08/1775642994
id: 1707171
processed: 1

raw_data:

{
    "answer_a": 5,
    "answer_b": 6,
    "answer_c": 7,
    "answer_d": 8,
    "answer_e": 9,
    "correct_answer": 10,
    "created_at": 12,
    "id": 1,
    "location_id": 2,
    "position": 11,
    "question": 4,
    "style_group_id": 3,
    "tenant": 0,
    "updated_at": 13
}

schema_attributes:

{
    "answer_a": "string",
    "answer_b": "string",
    "answer_c": "string",
    "answer_d": "string",
    "answer_e": "string",
    "correct_answer": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "position": "string",
    "question": "string",
    "style_group_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1487
schema_scan_id: 161678330
updated: 2026-04-08 05:10:57

Version 1706058

created: 2026-04-07 05:17:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_questions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_questions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `question`  string , `answer_a`  string , `answer_b`  string , `answer_c`  string , `answer_d`  string , `answer_e`  string , `correct_answer`  string , `position`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-07/1775556863'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_questions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-07/1775556863
id: 1706058
processed: 1

raw_data:

{
    "answer_a": 5,
    "answer_b": 6,
    "answer_c": 7,
    "answer_d": 8,
    "answer_e": 9,
    "correct_answer": 10,
    "created_at": 12,
    "id": 1,
    "location_id": 2,
    "position": 11,
    "question": 4,
    "style_group_id": 3,
    "tenant": 0,
    "updated_at": 13
}

schema_attributes:

{
    "answer_a": "string",
    "answer_b": "string",
    "answer_c": "string",
    "answer_d": "string",
    "answer_e": "string",
    "correct_answer": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "position": "string",
    "question": "string",
    "style_group_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1487
schema_scan_id: 161622137
updated: 2026-04-07 05:18:00

Version 1704842

created: 2026-04-06 05:19:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_questions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_questions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `question`  string , `answer_a`  string , `answer_b`  string , `answer_c`  string , `answer_d`  string , `answer_e`  string , `correct_answer`  string , `position`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-06/1775470539'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_questions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-06/1775470539
id: 1704842
processed: 1

raw_data:

{
    "answer_a": 5,
    "answer_b": 6,
    "answer_c": 7,
    "answer_d": 8,
    "answer_e": 9,
    "correct_answer": 10,
    "created_at": 12,
    "id": 1,
    "location_id": 2,
    "position": 11,
    "question": 4,
    "style_group_id": 3,
    "tenant": 0,
    "updated_at": 13
}

schema_attributes:

{
    "answer_a": "string",
    "answer_b": "string",
    "answer_c": "string",
    "answer_d": "string",
    "answer_e": "string",
    "correct_answer": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "position": "string",
    "question": "string",
    "style_group_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1487
schema_scan_id: 161564318
updated: 2026-04-06 05:19:40

Version 1703635

created: 2026-04-05 04:59:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_questions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_questions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `question`  string , `answer_a`  string , `answer_b`  string , `answer_c`  string , `answer_d`  string , `answer_e`  string , `correct_answer`  string , `position`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-05/1775382952'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_questions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-05/1775382952
id: 1703635
processed: 1

raw_data:

{
    "answer_a": 5,
    "answer_b": 6,
    "answer_c": 7,
    "answer_d": 8,
    "answer_e": 9,
    "correct_answer": 10,
    "created_at": 12,
    "id": 1,
    "location_id": 2,
    "position": 11,
    "question": 4,
    "style_group_id": 3,
    "tenant": 0,
    "updated_at": 13
}

schema_attributes:

{
    "answer_a": "string",
    "answer_b": "string",
    "answer_c": "string",
    "answer_d": "string",
    "answer_e": "string",
    "correct_answer": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "position": "string",
    "question": "string",
    "style_group_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1487
schema_scan_id: 161516672
updated: 2026-04-05 04:59:55

Version 1702459

created: 2026-04-04 04:57:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_questions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_questions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `question`  string , `answer_a`  string , `answer_b`  string , `answer_c`  string , `answer_d`  string , `answer_e`  string , `correct_answer`  string , `position`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-04/1775296474'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_questions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-04/1775296474
id: 1702459
processed: 1

raw_data:

{
    "answer_a": 5,
    "answer_b": 6,
    "answer_c": 7,
    "answer_d": 8,
    "answer_e": 9,
    "correct_answer": 10,
    "created_at": 12,
    "id": 1,
    "location_id": 2,
    "position": 11,
    "question": 4,
    "style_group_id": 3,
    "tenant": 0,
    "updated_at": 13
}

schema_attributes:

{
    "answer_a": "string",
    "answer_b": "string",
    "answer_c": "string",
    "answer_d": "string",
    "answer_e": "string",
    "correct_answer": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "position": "string",
    "question": "string",
    "style_group_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1487
schema_scan_id: 161462168
updated: 2026-04-04 04:57:53

Version 1701275

created: 2026-04-03 05:14:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_questions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_questions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `question`  string , `answer_a`  string , `answer_b`  string , `answer_c`  string , `answer_d`  string , `answer_e`  string , `correct_answer`  string , `position`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-03/1775211041'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_questions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-03/1775211041
id: 1701275
processed: 1

raw_data:

{
    "answer_a": 5,
    "answer_b": 6,
    "answer_c": 7,
    "answer_d": 8,
    "answer_e": 9,
    "correct_answer": 10,
    "created_at": 12,
    "id": 1,
    "location_id": 2,
    "position": 11,
    "question": 4,
    "style_group_id": 3,
    "tenant": 0,
    "updated_at": 13
}

schema_attributes:

{
    "answer_a": "string",
    "answer_b": "string",
    "answer_c": "string",
    "answer_d": "string",
    "answer_e": "string",
    "correct_answer": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "position": "string",
    "question": "string",
    "style_group_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1487
schema_scan_id: 161404875
updated: 2026-04-03 05:14:23

Schema Scans: 15

Last at 2026-04-17 04:58:25

Scan 162169357

duration: 0:00:12.001412

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162169357

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-17/1776419654",
        "key": "raw/stellar_imstest_questions/2026-04-17/1776419654/test_questions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstest_questions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7674074872879355637,
        "service_name": "drive-thru",
        "span_id": 16656105211171784561,
        "trace_id": 10072845387573825529
    }
}

running: False
schema_name_id: 1487
start_time: 2026-04-17 04:58:25
success: True
trace_id: 10072845387573825529

Scan 162114470

duration: 0:00:14.548515

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162114470

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-16/1776334555",
        "key": "raw/stellar_imstest_questions/2026-04-16/1776334555/test_questions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstest_questions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9035209991044756076,
        "service_name": "drive-thru",
        "span_id": 13915649672180568864,
        "trace_id": 12526436601497922317
    }
}

running: False
schema_name_id: 1487
start_time: 2026-04-16 05:20:02
success: True
trace_id: 12526436601497922317

Scan 162056413

duration: 0:00:11.939324

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162056413

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-15/1776242368",
        "key": "raw/stellar_imstest_questions/2026-04-15/1776242368/test_questions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstest_questions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6046541968591019528,
        "service_name": "drive-thru",
        "span_id": 336432205305980654,
        "trace_id": 12912188029434316046
    }
}

running: False
schema_name_id: 1487
start_time: 2026-04-15 03:42:42
success: True
trace_id: 12912188029434316046

Scan 162003116

duration: 0:00:14.527806

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162003116

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-14/1776160763",
        "key": "raw/stellar_imstest_questions/2026-04-14/1776160763/test_questions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstest_questions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14170407518445826763,
        "service_name": "drive-thru",
        "span_id": 17871360600627969968,
        "trace_id": 4779143124000344679
    }
}

running: False
schema_name_id: 1487
start_time: 2026-04-14 05:04:09
success: True
trace_id: 4779143124000344679

Scan 161945348

duration: 0:00:14.520057

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161945348

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-13/1776074809",
        "key": "raw/stellar_imstest_questions/2026-04-13/1776074809/test_questions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstest_questions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9369503117962512777,
        "service_name": "drive-thru",
        "span_id": 18424688450055344546,
        "trace_id": 12412674686163423131
    }
}

running: False
schema_name_id: 1487
start_time: 2026-04-13 05:09:50
success: True
trace_id: 12412674686163423131

Scan 161896419

duration: 0:00:14.440726

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161896419

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-12/1775988166",
        "key": "raw/stellar_imstest_questions/2026-04-12/1775988166/test_questions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstest_questions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15780735220802711001,
        "service_name": "drive-thru",
        "span_id": 12936030144877488524,
        "trace_id": 3464549860920589748
    }
}

running: False
schema_name_id: 1487
start_time: 2026-04-12 05:07:15
success: True
trace_id: 3464549860920589748

Scan 161843948

duration: 0:00:11.884454

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161843948

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-11/1775902581",
        "key": "raw/stellar_imstest_questions/2026-04-11/1775902581/test_questions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstest_questions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11751105520931781865,
        "service_name": "drive-thru",
        "span_id": 7647106456979358247,
        "trace_id": 37693723623274208
    }
}

running: False
schema_name_id: 1487
start_time: 2026-04-11 05:18:32
success: True
trace_id: 37693723623274208

Scan 161788674

duration: 0:00:14.498111

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161788674

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-10/1775815222",
        "key": "raw/stellar_imstest_questions/2026-04-10/1775815222/test_questions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstest_questions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6093903518874216667,
        "service_name": "drive-thru",
        "span_id": 18111534336161077316,
        "trace_id": 10147842431382181643
    }
}

running: False
schema_name_id: 1487
start_time: 2026-04-10 05:04:49
success: True
trace_id: 10147842431382181643

Scan 161733014

duration: 0:00:14.475438

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161733014

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-09/1775728844",
        "key": "raw/stellar_imstest_questions/2026-04-09/1775728844/test_questions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstest_questions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16332576506235146338,
        "service_name": "drive-thru",
        "span_id": 3488005919097802106,
        "trace_id": 358123858518285672
    }
}

running: False
schema_name_id: 1487
start_time: 2026-04-09 05:04:17
success: True
trace_id: 358123858518285672

Scan 161678330

duration: 0:00:14.508724

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161678330

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-08/1775642994",
        "key": "raw/stellar_imstest_questions/2026-04-08/1775642994/test_questions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstest_questions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17782686769782351413,
        "service_name": "drive-thru",
        "span_id": 11482734040167587260,
        "trace_id": 8929688072757161527
    }
}

running: False
schema_name_id: 1487
start_time: 2026-04-08 05:10:42
success: True
trace_id: 8929688072757161527

Scan 161622137

duration: 0:00:14.810444

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161622137

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-07/1775556863",
        "key": "raw/stellar_imstest_questions/2026-04-07/1775556863/test_questions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstest_questions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9889026199923279520,
        "service_name": "drive-thru",
        "span_id": 17494890405125038221,
        "trace_id": 12472115819671717442
    }
}

running: False
schema_name_id: 1487
start_time: 2026-04-07 05:17:46
success: True
trace_id: 12472115819671717442

Scan 161564318

duration: 0:00:14.527407

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161564318

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-06/1775470539",
        "key": "raw/stellar_imstest_questions/2026-04-06/1775470539/test_questions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstest_questions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8316824542655724965,
        "service_name": "drive-thru",
        "span_id": 9039306745621223630,
        "trace_id": 5683851398738792354
    }
}

running: False
schema_name_id: 1487
start_time: 2026-04-06 05:19:25
success: True
trace_id: 5683851398738792354

Scan 161516672

duration: 0:00:14.442038

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161516672

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-05/1775382952",
        "key": "raw/stellar_imstest_questions/2026-04-05/1775382952/test_questions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstest_questions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17252768586254012416,
        "service_name": "drive-thru",
        "span_id": 16185984689377612493,
        "trace_id": 11053203650387489896
    }
}

running: False
schema_name_id: 1487
start_time: 2026-04-05 04:59:40
success: True
trace_id: 11053203650387489896

Scan 161462168

duration: 0:00:11.878250

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161462168

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-04/1775296474",
        "key": "raw/stellar_imstest_questions/2026-04-04/1775296474/test_questions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstest_questions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3104820634455949310,
        "service_name": "drive-thru",
        "span_id": 13538299717461459618,
        "trace_id": 4811377501754093497
    }
}

running: False
schema_name_id: 1487
start_time: 2026-04-04 04:57:41
success: True
trace_id: 4811377501754093497

Scan 161404875

duration: 0:00:14.513869

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161404875

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-03/1775211041",
        "key": "raw/stellar_imstest_questions/2026-04-03/1775211041/test_questions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imstest_questions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2944236347127970541,
        "service_name": "drive-thru",
        "span_id": 4475055620351695542,
        "trace_id": 240664417820965981
    }
}

running: False
schema_name_id: 1487
start_time: 2026-04-03 05:14:09
success: True
trace_id: 240664417820965981

Partitions:

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

Schema:

attributes:

{
    "answer_a": "string",
    "answer_b": "string",
    "answer_c": "string",
    "answer_d": "string",
    "answer_e": "string",
    "correct_answer": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "position": "string",
    "question": "string",
    "style_group_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

created: 2026-04-17 04:58:26

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_questions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `question`  string , `answer_a`  string , `answer_b`  string , `answer_c`  string , `answer_d`  string , `answer_e`  string , `correct_answer`  string , `position`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-17/1776419654'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_questions`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_questions"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-02-07 01:47:50",
        "disabled": false,
        "format": "raw",
        "id": 1487,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imstest_questions"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "answer_a": "string",
            "answer_b": "string",
            "answer_c": "string",
            "answer_d": "string",
            "answer_e": "string",
            "correct_answer": "string",
            "created_at": "string",
            "id": "string",
            "location_id": "string",
            "position": "string",
            "question": "string",
            "style_group_id": "string",
            "tenant": "string",
            "updated_at": "string"
        },
        "created": "2026-04-17 04:58:26",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_questions`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_group_id`  string , `question`  string , `answer_a`  string , `answer_b`  string , `answer_c`  string , `answer_d`  string , `answer_e`  string , `correct_answer`  string , `position`  string , `created_at`  string , `updated_at`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_questions/2026-04-17/1776419654'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_questions`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_questions"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}