Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imschecklist_items

created: 2023-02-07 01:48:37
disabled: False
format: raw
id: 1500
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717927

created: 2026-04-17 04:55:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imschecklist_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imschecklist_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_id`  string , `item_type`  string , `heading`  string , `description`  string , `input_type`  string , `select_options`  string , `item_sort`  string , `status`  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_imschecklist_items/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imschecklist_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imschecklist_items/2026-04-17/1776419647
id: 1717927
processed: 1

raw_data:

{
    "created_at": 11,
    "description": 6,
    "heading": 5,
    "id": 1,
    "input_type": 7,
    "item_sort": 9,
    "item_type": 4,
    "location_id": 2,
    "select_options": 8,
    "status": 10,
    "style_id": 3,
    "tenant": 0,
    "updated_at": 12
}

schema_attributes:

{
    "created_at": "string",
    "description": "string",
    "heading": "string",
    "id": "string",
    "input_type": "string",
    "item_sort": "string",
    "item_type": "string",
    "location_id": "string",
    "select_options": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1500
schema_scan_id: 162169263
updated: 2026-04-17 04:55:26

Version 1716779

created: 2026-04-16 05:19:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imschecklist_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imschecklist_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_id`  string , `item_type`  string , `heading`  string , `description`  string , `input_type`  string , `select_options`  string , `item_sort`  string , `status`  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_imschecklist_items/2026-04-16/1776334546'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imschecklist_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imschecklist_items/2026-04-16/1776334546
id: 1716779
processed: 1

raw_data:

{
    "created_at": 11,
    "description": 6,
    "heading": 5,
    "id": 1,
    "input_type": 7,
    "item_sort": 9,
    "item_type": 4,
    "location_id": 2,
    "select_options": 8,
    "status": 10,
    "style_id": 3,
    "tenant": 0,
    "updated_at": 12
}

schema_attributes:

{
    "created_at": "string",
    "description": "string",
    "heading": "string",
    "id": "string",
    "input_type": "string",
    "item_sort": "string",
    "item_type": "string",
    "location_id": "string",
    "select_options": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1500
schema_scan_id: 162114450
updated: 2026-04-16 05:19:31

Version 1715460

created: 2026-04-15 03:40:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imschecklist_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imschecklist_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_id`  string , `item_type`  string , `heading`  string , `description`  string , `input_type`  string , `select_options`  string , `item_sort`  string , `status`  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_imschecklist_items/2026-04-15/1776242357'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imschecklist_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imschecklist_items/2026-04-15/1776242357
id: 1715460
processed: 1

raw_data:

{
    "created_at": 11,
    "description": 6,
    "heading": 5,
    "id": 1,
    "input_type": 7,
    "item_sort": 9,
    "item_type": 4,
    "location_id": 2,
    "select_options": 8,
    "status": 10,
    "style_id": 3,
    "tenant": 0,
    "updated_at": 12
}

schema_attributes:

{
    "created_at": "string",
    "description": "string",
    "heading": "string",
    "id": "string",
    "input_type": "string",
    "item_sort": "string",
    "item_type": "string",
    "location_id": "string",
    "select_options": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1500
schema_scan_id: 162056343
updated: 2026-04-15 03:40:22

Version 1714318

created: 2026-04-14 05:01:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imschecklist_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imschecklist_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_id`  string , `item_type`  string , `heading`  string , `description`  string , `input_type`  string , `select_options`  string , `item_sort`  string , `status`  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_imschecklist_items/2026-04-14/1776160757'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imschecklist_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imschecklist_items/2026-04-14/1776160757
id: 1714318
processed: 1

raw_data:

{
    "created_at": 11,
    "description": 6,
    "heading": 5,
    "id": 1,
    "input_type": 7,
    "item_sort": 9,
    "item_type": 4,
    "location_id": 2,
    "select_options": 8,
    "status": 10,
    "style_id": 3,
    "tenant": 0,
    "updated_at": 12
}

schema_attributes:

{
    "created_at": "string",
    "description": "string",
    "heading": "string",
    "id": "string",
    "input_type": "string",
    "item_sort": "string",
    "item_type": "string",
    "location_id": "string",
    "select_options": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1500
schema_scan_id: 162002966
updated: 2026-04-14 05:01:21

Version 1713122

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imschecklist_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imschecklist_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_id`  string , `item_type`  string , `heading`  string , `description`  string , `input_type`  string , `select_options`  string , `item_sort`  string , `status`  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_imschecklist_items/2026-04-13/1776074798'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imschecklist_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imschecklist_items/2026-04-13/1776074798
id: 1713122
processed: 1

raw_data:

{
    "created_at": 11,
    "description": 6,
    "heading": 5,
    "id": 1,
    "input_type": 7,
    "item_sort": 9,
    "item_type": 4,
    "location_id": 2,
    "select_options": 8,
    "status": 10,
    "style_id": 3,
    "tenant": 0,
    "updated_at": 12
}

schema_attributes:

{
    "created_at": "string",
    "description": "string",
    "heading": "string",
    "id": "string",
    "input_type": "string",
    "item_sort": "string",
    "item_type": "string",
    "location_id": "string",
    "select_options": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1500
schema_scan_id: 161945328
updated: 2026-04-13 05:09:19

Version 1711925

created: 2026-04-12 05:05:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imschecklist_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imschecklist_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_id`  string , `item_type`  string , `heading`  string , `description`  string , `input_type`  string , `select_options`  string , `item_sort`  string , `status`  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_imschecklist_items/2026-04-12/1775988155'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imschecklist_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imschecklist_items/2026-04-12/1775988155
id: 1711925
processed: 1

raw_data:

{
    "created_at": 11,
    "description": 6,
    "heading": 5,
    "id": 1,
    "input_type": 7,
    "item_sort": 9,
    "item_type": 4,
    "location_id": 2,
    "select_options": 8,
    "status": 10,
    "style_id": 3,
    "tenant": 0,
    "updated_at": 12
}

schema_attributes:

{
    "created_at": "string",
    "description": "string",
    "heading": "string",
    "id": "string",
    "input_type": "string",
    "item_sort": "string",
    "item_type": "string",
    "location_id": "string",
    "select_options": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1500
schema_scan_id: 161896374
updated: 2026-04-12 05:05:39

Version 1710784

created: 2026-04-11 05:20:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imschecklist_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imschecklist_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_id`  string , `item_type`  string , `heading`  string , `description`  string , `input_type`  string , `select_options`  string , `item_sort`  string , `status`  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_imschecklist_items/2026-04-11/1775902577'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imschecklist_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imschecklist_items/2026-04-11/1775902577
id: 1710784
processed: 1

raw_data:

{
    "created_at": 11,
    "description": 6,
    "heading": 5,
    "id": 1,
    "input_type": 7,
    "item_sort": 9,
    "item_type": 4,
    "location_id": 2,
    "select_options": 8,
    "status": 10,
    "style_id": 3,
    "tenant": 0,
    "updated_at": 12
}

schema_attributes:

{
    "created_at": "string",
    "description": "string",
    "heading": "string",
    "id": "string",
    "input_type": "string",
    "item_sort": "string",
    "item_type": "string",
    "location_id": "string",
    "select_options": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1500
schema_scan_id: 161844009
updated: 2026-04-11 05:20:53

Version 1709511

created: 2026-04-10 05:00:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imschecklist_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imschecklist_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_id`  string , `item_type`  string , `heading`  string , `description`  string , `input_type`  string , `select_options`  string , `item_sort`  string , `status`  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_imschecklist_items/2026-04-10/1775815216'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imschecklist_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imschecklist_items/2026-04-10/1775815216
id: 1709511
processed: 1

raw_data:

{
    "created_at": 11,
    "description": 6,
    "heading": 5,
    "id": 1,
    "input_type": 7,
    "item_sort": 9,
    "item_type": 4,
    "location_id": 2,
    "select_options": 8,
    "status": 10,
    "style_id": 3,
    "tenant": 0,
    "updated_at": 12
}

schema_attributes:

{
    "created_at": "string",
    "description": "string",
    "heading": "string",
    "id": "string",
    "input_type": "string",
    "item_sort": "string",
    "item_type": "string",
    "location_id": "string",
    "select_options": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1500
schema_scan_id: 161788549
updated: 2026-04-10 05:01:07

Version 1708388

created: 2026-04-09 05:01:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imschecklist_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imschecklist_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_id`  string , `item_type`  string , `heading`  string , `description`  string , `input_type`  string , `select_options`  string , `item_sort`  string , `status`  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_imschecklist_items/2026-04-09/1775728837'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imschecklist_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imschecklist_items/2026-04-09/1775728837
id: 1708388
processed: 1

raw_data:

{
    "created_at": 11,
    "description": 6,
    "heading": 5,
    "id": 1,
    "input_type": 7,
    "item_sort": 9,
    "item_type": 4,
    "location_id": 2,
    "select_options": 8,
    "status": 10,
    "style_id": 3,
    "tenant": 0,
    "updated_at": 12
}

schema_attributes:

{
    "created_at": "string",
    "description": "string",
    "heading": "string",
    "id": "string",
    "input_type": "string",
    "item_sort": "string",
    "item_type": "string",
    "location_id": "string",
    "select_options": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1500
schema_scan_id: 161732946
updated: 2026-04-09 05:02:06

Version 1707242

created: 2026-04-08 05:14:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imschecklist_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imschecklist_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_id`  string , `item_type`  string , `heading`  string , `description`  string , `input_type`  string , `select_options`  string , `item_sort`  string , `status`  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_imschecklist_items/2026-04-08/1775643000'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imschecklist_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imschecklist_items/2026-04-08/1775643000
id: 1707242
processed: 1

raw_data:

{
    "created_at": 11,
    "description": 6,
    "heading": 5,
    "id": 1,
    "input_type": 7,
    "item_sort": 9,
    "item_type": 4,
    "location_id": 2,
    "select_options": 8,
    "status": 10,
    "style_id": 3,
    "tenant": 0,
    "updated_at": 12
}

schema_attributes:

{
    "created_at": "string",
    "description": "string",
    "heading": "string",
    "id": "string",
    "input_type": "string",
    "item_sort": "string",
    "item_type": "string",
    "location_id": "string",
    "select_options": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1500
schema_scan_id: 161678401
updated: 2026-04-08 05:14:39

Version 1705981

created: 2026-04-07 05:14:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imschecklist_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imschecklist_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_id`  string , `item_type`  string , `heading`  string , `description`  string , `input_type`  string , `select_options`  string , `item_sort`  string , `status`  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_imschecklist_items/2026-04-07/1775556857'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imschecklist_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imschecklist_items/2026-04-07/1775556857
id: 1705981
processed: 1

raw_data:

{
    "created_at": 11,
    "description": 6,
    "heading": 5,
    "id": 1,
    "input_type": 7,
    "item_sort": 9,
    "item_type": 4,
    "location_id": 2,
    "select_options": 8,
    "status": 10,
    "style_id": 3,
    "tenant": 0,
    "updated_at": 12
}

schema_attributes:

{
    "created_at": "string",
    "description": "string",
    "heading": "string",
    "id": "string",
    "input_type": "string",
    "item_sort": "string",
    "item_type": "string",
    "location_id": "string",
    "select_options": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1500
schema_scan_id: 161622060
updated: 2026-04-07 05:15:06

Version 1704759

created: 2026-04-06 05:16:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imschecklist_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imschecklist_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_id`  string , `item_type`  string , `heading`  string , `description`  string , `input_type`  string , `select_options`  string , `item_sort`  string , `status`  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_imschecklist_items/2026-04-06/1775470528'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imschecklist_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imschecklist_items/2026-04-06/1775470528
id: 1704759
processed: 1

raw_data:

{
    "created_at": 11,
    "description": 6,
    "heading": 5,
    "id": 1,
    "input_type": 7,
    "item_sort": 9,
    "item_type": 4,
    "location_id": 2,
    "select_options": 8,
    "status": 10,
    "style_id": 3,
    "tenant": 0,
    "updated_at": 12
}

schema_attributes:

{
    "created_at": "string",
    "description": "string",
    "heading": "string",
    "id": "string",
    "input_type": "string",
    "item_sort": "string",
    "item_type": "string",
    "location_id": "string",
    "select_options": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1500
schema_scan_id: 161564230
updated: 2026-04-06 05:16:29

Version 1703542

created: 2026-04-05 04:56:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imschecklist_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imschecklist_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_id`  string , `item_type`  string , `heading`  string , `description`  string , `input_type`  string , `select_options`  string , `item_sort`  string , `status`  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_imschecklist_items/2026-04-05/1775382943'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imschecklist_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imschecklist_items/2026-04-05/1775382943
id: 1703542
processed: 1

raw_data:

{
    "created_at": 11,
    "description": 6,
    "heading": 5,
    "id": 1,
    "input_type": 7,
    "item_sort": 9,
    "item_type": 4,
    "location_id": 2,
    "select_options": 8,
    "status": 10,
    "style_id": 3,
    "tenant": 0,
    "updated_at": 12
}

schema_attributes:

{
    "created_at": "string",
    "description": "string",
    "heading": "string",
    "id": "string",
    "input_type": "string",
    "item_sort": "string",
    "item_type": "string",
    "location_id": "string",
    "select_options": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1500
schema_scan_id: 161516508
updated: 2026-04-05 04:56:30

Version 1702442

created: 2026-04-04 04:56:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imschecklist_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imschecklist_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_id`  string , `item_type`  string , `heading`  string , `description`  string , `input_type`  string , `select_options`  string , `item_sort`  string , `status`  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_imschecklist_items/2026-04-04/1775296469'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imschecklist_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imschecklist_items/2026-04-04/1775296469
id: 1702442
processed: 1

raw_data:

{
    "created_at": 11,
    "description": 6,
    "heading": 5,
    "id": 1,
    "input_type": 7,
    "item_sort": 9,
    "item_type": 4,
    "location_id": 2,
    "select_options": 8,
    "status": 10,
    "style_id": 3,
    "tenant": 0,
    "updated_at": 12
}

schema_attributes:

{
    "created_at": "string",
    "description": "string",
    "heading": "string",
    "id": "string",
    "input_type": "string",
    "item_sort": "string",
    "item_type": "string",
    "location_id": "string",
    "select_options": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1500
schema_scan_id: 161462143
updated: 2026-04-04 04:57:13

Version 1701232

created: 2026-04-03 05:12:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imschecklist_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imschecklist_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_id`  string , `item_type`  string , `heading`  string , `description`  string , `input_type`  string , `select_options`  string , `item_sort`  string , `status`  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_imschecklist_items/2026-04-03/1775211034'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imschecklist_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imschecklist_items/2026-04-03/1775211034
id: 1701232
processed: 1

raw_data:

{
    "created_at": 11,
    "description": 6,
    "heading": 5,
    "id": 1,
    "input_type": 7,
    "item_sort": 9,
    "item_type": 4,
    "location_id": 2,
    "select_options": 8,
    "status": 10,
    "style_id": 3,
    "tenant": 0,
    "updated_at": 12
}

schema_attributes:

{
    "created_at": "string",
    "description": "string",
    "heading": "string",
    "id": "string",
    "input_type": "string",
    "item_sort": "string",
    "item_type": "string",
    "location_id": "string",
    "select_options": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1500
schema_scan_id: 161404829
updated: 2026-04-03 05:12:46

Schema Scans: 15

Last at 2026-04-17 04:55:12

Scan 162169263

duration: 0:00:14.326937

exit_message:

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

id: 162169263

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_imschecklist_items/2026-04-17/1776419647",
        "key": "raw/stellar_imschecklist_items/2026-04-17/1776419647/checklist_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imschecklist_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4213844214615239749,
        "service_name": "drive-thru",
        "span_id": 12885031732929052013,
        "trace_id": 11043243176664961877
    }
}

running: False
schema_name_id: 1500
start_time: 2026-04-17 04:55:12
success: True
trace_id: 11043243176664961877

Scan 162114450

duration: 0:00:14.505858

exit_message:

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

id: 162114450

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_imschecklist_items/2026-04-16/1776334546",
        "key": "raw/stellar_imschecklist_items/2026-04-16/1776334546/checklist_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imschecklist_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 804418380691594242,
        "service_name": "drive-thru",
        "span_id": 8712253653522052052,
        "trace_id": 12528271451782579856
    }
}

running: False
schema_name_id: 1500
start_time: 2026-04-16 05:19:17
success: True
trace_id: 12528271451782579856

Scan 162056343

duration: 0:00:14.479894

exit_message:

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

id: 162056343

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_imschecklist_items/2026-04-15/1776242357",
        "key": "raw/stellar_imschecklist_items/2026-04-15/1776242357/checklist_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imschecklist_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18168348594293792528,
        "service_name": "drive-thru",
        "span_id": 14006348185019966048,
        "trace_id": 692078646885033146
    }
}

running: False
schema_name_id: 1500
start_time: 2026-04-15 03:40:08
success: True
trace_id: 692078646885033146

Scan 162002966

duration: 0:00:14.420888

exit_message:

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

id: 162002966

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_imschecklist_items/2026-04-14/1776160757",
        "key": "raw/stellar_imschecklist_items/2026-04-14/1776160757/checklist_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imschecklist_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5204926164219980831,
        "service_name": "drive-thru",
        "span_id": 2395227947423207429,
        "trace_id": 2958627576363182292
    }
}

running: False
schema_name_id: 1500
start_time: 2026-04-14 05:01:06
success: True
trace_id: 2958627576363182292

Scan 161945328

duration: 0:00:11.969117

exit_message:

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

id: 161945328

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_imschecklist_items/2026-04-13/1776074798",
        "key": "raw/stellar_imschecklist_items/2026-04-13/1776074798/checklist_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imschecklist_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13792110279034707228,
        "service_name": "drive-thru",
        "span_id": 13629456408252166685,
        "trace_id": 17613338935477039685
    }
}

running: False
schema_name_id: 1500
start_time: 2026-04-13 05:09:07
success: True
trace_id: 17613338935477039685

Scan 161896374

duration: 0:00:14.503662

exit_message:

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

id: 161896374

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_imschecklist_items/2026-04-12/1775988155",
        "key": "raw/stellar_imschecklist_items/2026-04-12/1775988155/checklist_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imschecklist_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14940687379993374812,
        "service_name": "drive-thru",
        "span_id": 8410099947689019780,
        "trace_id": 10425552117519727027
    }
}

running: False
schema_name_id: 1500
start_time: 2026-04-12 05:05:24
success: True
trace_id: 10425552117519727027

Scan 161844009

duration: 0:00:11.944200

exit_message:

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

id: 161844009

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_imschecklist_items/2026-04-11/1775902577",
        "key": "raw/stellar_imschecklist_items/2026-04-11/1775902577/checklist_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imschecklist_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12881523903799124355,
        "service_name": "drive-thru",
        "span_id": 2401531076653180311,
        "trace_id": 9703070463973894434
    }
}

running: False
schema_name_id: 1500
start_time: 2026-04-11 05:20:41
success: True
trace_id: 9703070463973894434

Scan 161788549

duration: 0:00:11.980374

exit_message:

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

id: 161788549

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_imschecklist_items/2026-04-10/1775815216",
        "key": "raw/stellar_imschecklist_items/2026-04-10/1775815216/checklist_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imschecklist_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16781635554502609533,
        "service_name": "drive-thru",
        "span_id": 10576793211060997720,
        "trace_id": 14719183998960951816
    }
}

running: False
schema_name_id: 1500
start_time: 2026-04-10 05:00:56
success: True
trace_id: 14719183998960951816

Scan 161732946

duration: 0:00:11.859718

exit_message:

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

id: 161732946

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_imschecklist_items/2026-04-09/1775728837",
        "key": "raw/stellar_imschecklist_items/2026-04-09/1775728837/checklist_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imschecklist_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1057436764136947979,
        "service_name": "drive-thru",
        "span_id": 7706998256661940007,
        "trace_id": 9344817142289484463
    }
}

running: False
schema_name_id: 1500
start_time: 2026-04-09 05:01:54
success: True
trace_id: 9344817142289484463

Scan 161678401

duration: 0:00:11.865271

exit_message:

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

id: 161678401

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_imschecklist_items/2026-04-08/1775643000",
        "key": "raw/stellar_imschecklist_items/2026-04-08/1775643000/checklist_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imschecklist_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9119739265586604099,
        "service_name": "drive-thru",
        "span_id": 17472463679750788578,
        "trace_id": 6139225202170077147
    }
}

running: False
schema_name_id: 1500
start_time: 2026-04-08 05:14:28
success: True
trace_id: 6139225202170077147

Scan 161622060

duration: 0:00:14.588618

exit_message:

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

id: 161622060

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_imschecklist_items/2026-04-07/1775556857",
        "key": "raw/stellar_imschecklist_items/2026-04-07/1775556857/checklist_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imschecklist_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 312503850171155471,
        "service_name": "drive-thru",
        "span_id": 16525177326275934293,
        "trace_id": 4079078383181378059
    }
}

running: False
schema_name_id: 1500
start_time: 2026-04-07 05:14:52
success: True
trace_id: 4079078383181378059

Scan 161564230

duration: 0:00:11.992140

exit_message:

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

id: 161564230

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_imschecklist_items/2026-04-06/1775470528",
        "key": "raw/stellar_imschecklist_items/2026-04-06/1775470528/checklist_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imschecklist_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12380792542252867210,
        "service_name": "drive-thru",
        "span_id": 8559097803036630144,
        "trace_id": 10839121967282806679
    }
}

running: False
schema_name_id: 1500
start_time: 2026-04-06 05:16:17
success: True
trace_id: 10839121967282806679

Scan 161516508

duration: 0:00:11.940637

exit_message:

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

id: 161516508

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_imschecklist_items/2026-04-05/1775382943",
        "key": "raw/stellar_imschecklist_items/2026-04-05/1775382943/checklist_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imschecklist_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17810229004185167570,
        "service_name": "drive-thru",
        "span_id": 17543556918261325924,
        "trace_id": 4717196723855975110
    }
}

running: False
schema_name_id: 1500
start_time: 2026-04-05 04:56:18
success: True
trace_id: 4717196723855975110

Scan 161462143

duration: 0:00:14.433033

exit_message:

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

id: 161462143

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_imschecklist_items/2026-04-04/1775296469",
        "key": "raw/stellar_imschecklist_items/2026-04-04/1775296469/checklist_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imschecklist_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8352548587208279107,
        "service_name": "drive-thru",
        "span_id": 16350935380412529456,
        "trace_id": 17262617360924808550
    }
}

running: False
schema_name_id: 1500
start_time: 2026-04-04 04:56:58
success: True
trace_id: 17262617360924808550

Scan 161404829

duration: 0:00:14.679361

exit_message:

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

id: 161404829

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_imschecklist_items/2026-04-03/1775211034",
        "key": "raw/stellar_imschecklist_items/2026-04-03/1775211034/checklist_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imschecklist_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4637043177074596383,
        "service_name": "drive-thru",
        "span_id": 10905834856392689711,
        "trace_id": 907962525750883390
    }
}

running: False
schema_name_id: 1500
start_time: 2026-04-03 05:12:31
success: True
trace_id: 907962525750883390

Partitions:

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

Schema:

attributes:

{
    "created_at": "string",
    "description": "string",
    "heading": "string",
    "id": "string",
    "input_type": "string",
    "item_sort": "string",
    "item_type": "string",
    "location_id": "string",
    "select_options": "string",
    "status": "string",
    "style_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

created: 2026-04-17 04:55:12

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imschecklist_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_id`  string , `item_type`  string , `heading`  string , `description`  string , `input_type`  string , `select_options`  string , `item_sort`  string , `status`  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_imschecklist_items/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imschecklist_items`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imschecklist_items"
}

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:48:37",
        "disabled": false,
        "format": "raw",
        "id": 1500,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imschecklist_items"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "created_at": "string",
            "description": "string",
            "heading": "string",
            "id": "string",
            "input_type": "string",
            "item_sort": "string",
            "item_type": "string",
            "location_id": "string",
            "select_options": "string",
            "status": "string",
            "style_id": "string",
            "tenant": "string",
            "updated_at": "string"
        },
        "created": "2026-04-17 04:55:12",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imschecklist_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `style_id`  string , `item_type`  string , `heading`  string , `description`  string , `input_type`  string , `select_options`  string , `item_sort`  string , `status`  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_imschecklist_items/2026-04-17/1776419647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imschecklist_items`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imschecklist_items"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}