Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imspos_items

created: 2023-02-07 01:46:12
disabled: False
format: raw
id: 1453
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1718012

created: 2026-04-17 04:58:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `sku`  string , `item_name`  string , `cost`  string , `price`  string , `tax_exempt`  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_imspos_items/2026-04-17/1776419649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_items/2026-04-17/1776419649
id: 1718012
processed: 1

raw_data:

{
    "cost": 5,
    "created_at": 8,
    "id": 1,
    "item_name": 4,
    "location_id": 2,
    "price": 6,
    "sku": 3,
    "tax_exempt": 7,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "cost": "string",
    "created_at": "string",
    "id": "string",
    "item_name": "string",
    "location_id": "string",
    "price": "string",
    "sku": "string",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1453
schema_scan_id: 162169363
updated: 2026-04-17 04:58:48

Version 1716728

created: 2026-04-16 05:17:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `sku`  string , `item_name`  string , `cost`  string , `price`  string , `tax_exempt`  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_imspos_items/2026-04-16/1776334550'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_items/2026-04-16/1776334550
id: 1716728
processed: 1

raw_data:

{
    "cost": 5,
    "created_at": 8,
    "id": 1,
    "item_name": 4,
    "location_id": 2,
    "price": 6,
    "sku": 3,
    "tax_exempt": 7,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "cost": "string",
    "created_at": "string",
    "id": "string",
    "item_name": "string",
    "location_id": "string",
    "price": "string",
    "sku": "string",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1453
schema_scan_id: 162114398
updated: 2026-04-16 05:17:33

Version 1715529

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `sku`  string , `item_name`  string , `cost`  string , `price`  string , `tax_exempt`  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_imspos_items/2026-04-15/1776242363'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_items/2026-04-15/1776242363
id: 1715529
processed: 1

raw_data:

{
    "cost": 5,
    "created_at": 8,
    "id": 1,
    "item_name": 4,
    "location_id": 2,
    "price": 6,
    "sku": 3,
    "tax_exempt": 7,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "cost": "string",
    "created_at": "string",
    "id": "string",
    "item_name": "string",
    "location_id": "string",
    "price": "string",
    "sku": "string",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1453
schema_scan_id: 162056415
updated: 2026-04-15 03:43:04

Version 1714393

created: 2026-04-14 05:04:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `sku`  string , `item_name`  string , `cost`  string , `price`  string , `tax_exempt`  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_imspos_items/2026-04-14/1776160759'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_items/2026-04-14/1776160759
id: 1714393
processed: 1

raw_data:

{
    "cost": 5,
    "created_at": 8,
    "id": 1,
    "item_name": 4,
    "location_id": 2,
    "price": 6,
    "sku": 3,
    "tax_exempt": 7,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "cost": "string",
    "created_at": "string",
    "id": "string",
    "item_name": "string",
    "location_id": "string",
    "price": "string",
    "sku": "string",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1453
schema_scan_id: 162003127
updated: 2026-04-14 05:04:44

Version 1713143

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `sku`  string , `item_name`  string , `cost`  string , `price`  string , `tax_exempt`  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_imspos_items/2026-04-13/1776074804'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_items/2026-04-13/1776074804
id: 1713143
processed: 1

raw_data:

{
    "cost": 5,
    "created_at": 8,
    "id": 1,
    "item_name": 4,
    "location_id": 2,
    "price": 6,
    "sku": 3,
    "tax_exempt": 7,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "cost": "string",
    "created_at": "string",
    "id": "string",
    "item_name": "string",
    "location_id": "string",
    "price": "string",
    "sku": "string",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1453
schema_scan_id: 161945352
updated: 2026-04-13 05:10:09

Version 1711956

created: 2026-04-12 05:06:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `sku`  string , `item_name`  string , `cost`  string , `price`  string , `tax_exempt`  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_imspos_items/2026-04-12/1775988161'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_items/2026-04-12/1775988161
id: 1711956
processed: 1

raw_data:

{
    "cost": 5,
    "created_at": 8,
    "id": 1,
    "item_name": 4,
    "location_id": 2,
    "price": 6,
    "sku": 3,
    "tax_exempt": 7,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "cost": "string",
    "created_at": "string",
    "id": "string",
    "item_name": "string",
    "location_id": "string",
    "price": "string",
    "sku": "string",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1453
schema_scan_id: 161896409
updated: 2026-04-12 05:07:10

Version 1710785

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `sku`  string , `item_name`  string , `cost`  string , `price`  string , `tax_exempt`  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_imspos_items/2026-04-11/1775902577'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_items"
]

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

raw_data:

{
    "cost": 5,
    "created_at": 8,
    "id": 1,
    "item_name": 4,
    "location_id": 2,
    "price": 6,
    "sku": 3,
    "tax_exempt": 7,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "cost": "string",
    "created_at": "string",
    "id": "string",
    "item_name": "string",
    "location_id": "string",
    "price": "string",
    "sku": "string",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1453
schema_scan_id: 161844010
updated: 2026-04-11 05:20:55

Version 1709568

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `sku`  string , `item_name`  string , `cost`  string , `price`  string , `tax_exempt`  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_imspos_items/2026-04-10/1775815219'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_items/2026-04-10/1775815219
id: 1709568
processed: 1

raw_data:

{
    "cost": 5,
    "created_at": 8,
    "id": 1,
    "item_name": 4,
    "location_id": 2,
    "price": 6,
    "sku": 3,
    "tax_exempt": 7,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "cost": "string",
    "created_at": "string",
    "id": "string",
    "item_name": "string",
    "location_id": "string",
    "price": "string",
    "sku": "string",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1453
schema_scan_id: 161788610
updated: 2026-04-10 05:03:13

Version 1708418

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `sku`  string , `item_name`  string , `cost`  string , `price`  string , `tax_exempt`  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_imspos_items/2026-04-09/1775728840'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_items/2026-04-09/1775728840
id: 1708418
processed: 1

raw_data:

{
    "cost": 5,
    "created_at": 8,
    "id": 1,
    "item_name": 4,
    "location_id": 2,
    "price": 6,
    "sku": 3,
    "tax_exempt": 7,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "cost": "string",
    "created_at": "string",
    "id": "string",
    "item_name": "string",
    "location_id": "string",
    "price": "string",
    "sku": "string",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1453
schema_scan_id: 161732978
updated: 2026-04-09 05:03:12

Version 1707269

created: 2026-04-08 05:15:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `sku`  string , `item_name`  string , `cost`  string , `price`  string , `tax_exempt`  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_imspos_items/2026-04-08/1775642999'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_items/2026-04-08/1775642999
id: 1707269
processed: 1

raw_data:

{
    "cost": 5,
    "created_at": 8,
    "id": 1,
    "item_name": 4,
    "location_id": 2,
    "price": 6,
    "sku": 3,
    "tax_exempt": 7,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "cost": "string",
    "created_at": "string",
    "id": "string",
    "item_name": "string",
    "location_id": "string",
    "price": "string",
    "sku": "string",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1453
schema_scan_id: 161678429
updated: 2026-04-08 05:15:44

Version 1706068

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `sku`  string , `item_name`  string , `cost`  string , `price`  string , `tax_exempt`  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_imspos_items/2026-04-07/1775556859'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_items/2026-04-07/1775556859
id: 1706068
processed: 1

raw_data:

{
    "cost": 5,
    "created_at": 8,
    "id": 1,
    "item_name": 4,
    "location_id": 2,
    "price": 6,
    "sku": 3,
    "tax_exempt": 7,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "cost": "string",
    "created_at": "string",
    "id": "string",
    "item_name": "string",
    "location_id": "string",
    "price": "string",
    "sku": "string",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1453
schema_scan_id: 161622154
updated: 2026-04-07 05:18:31

Version 1704848

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `sku`  string , `item_name`  string , `cost`  string , `price`  string , `tax_exempt`  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_imspos_items/2026-04-06/1775470534'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_items/2026-04-06/1775470534
id: 1704848
processed: 1

raw_data:

{
    "cost": 5,
    "created_at": 8,
    "id": 1,
    "item_name": 4,
    "location_id": 2,
    "price": 6,
    "sku": 3,
    "tax_exempt": 7,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "cost": "string",
    "created_at": "string",
    "id": "string",
    "item_name": "string",
    "location_id": "string",
    "price": "string",
    "sku": "string",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1453
schema_scan_id: 161564325
updated: 2026-04-06 05:19:54

Version 1703587

created: 2026-04-05 04:58:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `sku`  string , `item_name`  string , `cost`  string , `price`  string , `tax_exempt`  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_imspos_items/2026-04-05/1775382947'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_items/2026-04-05/1775382947
id: 1703587
processed: 1

raw_data:

{
    "cost": 5,
    "created_at": 8,
    "id": 1,
    "item_name": 4,
    "location_id": 2,
    "price": 6,
    "sku": 3,
    "tax_exempt": 7,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "cost": "string",
    "created_at": "string",
    "id": "string",
    "item_name": "string",
    "location_id": "string",
    "price": "string",
    "sku": "string",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1453
schema_scan_id: 161516585
updated: 2026-04-05 04:58:25

Version 1702382

created: 2026-04-04 04:54:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `sku`  string , `item_name`  string , `cost`  string , `price`  string , `tax_exempt`  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_imspos_items/2026-04-04/1775296461'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_items/2026-04-04/1775296461
id: 1702382
processed: 1

raw_data:

{
    "cost": 5,
    "created_at": 8,
    "id": 1,
    "item_name": 4,
    "location_id": 2,
    "price": 6,
    "sku": 3,
    "tax_exempt": 7,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "cost": "string",
    "created_at": "string",
    "id": "string",
    "item_name": "string",
    "location_id": "string",
    "price": "string",
    "sku": "string",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1453
schema_scan_id: 161462083
updated: 2026-04-04 04:55:03

Version 1701273

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `sku`  string , `item_name`  string , `cost`  string , `price`  string , `tax_exempt`  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_imspos_items/2026-04-03/1775211037'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_items"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_items/2026-04-03/1775211037
id: 1701273
processed: 1

raw_data:

{
    "cost": 5,
    "created_at": 8,
    "id": 1,
    "item_name": 4,
    "location_id": 2,
    "price": 6,
    "sku": 3,
    "tax_exempt": 7,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "cost": "string",
    "created_at": "string",
    "id": "string",
    "item_name": "string",
    "location_id": "string",
    "price": "string",
    "sku": "string",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1453
schema_scan_id: 161404872
updated: 2026-04-03 05:14:13

Schema Scans: 15

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

Scan 162169363

duration: 0:00:11.750971

exit_message:

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

id: 162169363

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_imspos_items/2026-04-17/1776419649",
        "key": "raw/stellar_imspos_items/2026-04-17/1776419649/pos_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4696780112817795621,
        "service_name": "drive-thru",
        "span_id": 6888302064340566657,
        "trace_id": 8106101462350132643
    }
}

running: False
schema_name_id: 1453
start_time: 2026-04-17 04:58:36
success: True
trace_id: 8106101462350132643

Scan 162114398

duration: 0:00:11.828063

exit_message:

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

id: 162114398

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_imspos_items/2026-04-16/1776334550",
        "key": "raw/stellar_imspos_items/2026-04-16/1776334550/pos_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13738192578967582185,
        "service_name": "drive-thru",
        "span_id": 3588941371339911481,
        "trace_id": 11575464812899023771
    }
}

running: False
schema_name_id: 1453
start_time: 2026-04-16 05:17:21
success: True
trace_id: 11575464812899023771

Scan 162056415

duration: 0:00:14.431525

exit_message:

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

id: 162056415

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_imspos_items/2026-04-15/1776242363",
        "key": "raw/stellar_imspos_items/2026-04-15/1776242363/pos_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18140082784619383131,
        "service_name": "drive-thru",
        "span_id": 4314222632212472540,
        "trace_id": 6931053391655721915
    }
}

running: False
schema_name_id: 1453
start_time: 2026-04-15 03:42:50
success: True
trace_id: 6931053391655721915

Scan 162003127

duration: 0:00:14.348494

exit_message:

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

id: 162003127

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_imspos_items/2026-04-14/1776160759",
        "key": "raw/stellar_imspos_items/2026-04-14/1776160759/pos_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13838963167814319412,
        "service_name": "drive-thru",
        "span_id": 6369400668963947374,
        "trace_id": 12052443915035224564
    }
}

running: False
schema_name_id: 1453
start_time: 2026-04-14 05:04:29
success: True
trace_id: 12052443915035224564

Scan 161945352

duration: 0:00:11.716359

exit_message:

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

id: 161945352

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_imspos_items/2026-04-13/1776074804",
        "key": "raw/stellar_imspos_items/2026-04-13/1776074804/pos_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16415109448927406103,
        "service_name": "drive-thru",
        "span_id": 2819697191377197489,
        "trace_id": 6267783145267971542
    }
}

running: False
schema_name_id: 1453
start_time: 2026-04-13 05:09:58
success: True
trace_id: 6267783145267971542

Scan 161896409

duration: 0:00:14.356087

exit_message:

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

id: 161896409

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_imspos_items/2026-04-12/1775988161",
        "key": "raw/stellar_imspos_items/2026-04-12/1775988161/pos_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6251041804995021809,
        "service_name": "drive-thru",
        "span_id": 10046065198839030061,
        "trace_id": 4115245028276916821
    }
}

running: False
schema_name_id: 1453
start_time: 2026-04-12 05:06:55
success: True
trace_id: 4115245028276916821

Scan 161844010

duration: 0:00:11.785371

exit_message:

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

id: 161844010

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_imspos_items/2026-04-11/1775902577",
        "key": "raw/stellar_imspos_items/2026-04-11/1775902577/pos_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9792988021025557237,
        "service_name": "drive-thru",
        "span_id": 1476773778955298509,
        "trace_id": 13707267794615976610
    }
}

running: False
schema_name_id: 1453
start_time: 2026-04-11 05:20:43
success: True
trace_id: 13707267794615976610

Scan 161788610

duration: 0:00:12.004081

exit_message:

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

id: 161788610

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_imspos_items/2026-04-10/1775815219",
        "key": "raw/stellar_imspos_items/2026-04-10/1775815219/pos_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6090527768555563686,
        "service_name": "drive-thru",
        "span_id": 544300419324766699,
        "trace_id": 12591927260849697843
    }
}

running: False
schema_name_id: 1453
start_time: 2026-04-10 05:03:01
success: True
trace_id: 12591927260849697843

Scan 161732978

duration: 0:00:12.169977

exit_message:

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

id: 161732978

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_imspos_items/2026-04-09/1775728840",
        "key": "raw/stellar_imspos_items/2026-04-09/1775728840/pos_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14271926880307217732,
        "service_name": "drive-thru",
        "span_id": 9829496777598328271,
        "trace_id": 6599876970920050159
    }
}

running: False
schema_name_id: 1453
start_time: 2026-04-09 05:03:00
success: True
trace_id: 6599876970920050159

Scan 161678429

duration: 0:00:11.941920

exit_message:

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

id: 161678429

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_imspos_items/2026-04-08/1775642999",
        "key": "raw/stellar_imspos_items/2026-04-08/1775642999/pos_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14533087390293843729,
        "service_name": "drive-thru",
        "span_id": 3605268660734112991,
        "trace_id": 12131727308574738364
    }
}

running: False
schema_name_id: 1453
start_time: 2026-04-08 05:15:32
success: True
trace_id: 12131727308574738364

Scan 161622154

duration: 0:00:14.346961

exit_message:

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

id: 161622154

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_imspos_items/2026-04-07/1775556859",
        "key": "raw/stellar_imspos_items/2026-04-07/1775556859/pos_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10553897311620961433,
        "service_name": "drive-thru",
        "span_id": 10683918342495245571,
        "trace_id": 7122672149342489481
    }
}

running: False
schema_name_id: 1453
start_time: 2026-04-07 05:18:16
success: True
trace_id: 7122672149342489481

Scan 161564325

duration: 0:00:14.421072

exit_message:

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

id: 161564325

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_imspos_items/2026-04-06/1775470534",
        "key": "raw/stellar_imspos_items/2026-04-06/1775470534/pos_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7599394975177938598,
        "service_name": "drive-thru",
        "span_id": 2516186907200023863,
        "trace_id": 10251291938655458571
    }
}

running: False
schema_name_id: 1453
start_time: 2026-04-06 05:19:40
success: True
trace_id: 10251291938655458571

Scan 161516585

duration: 0:00:11.763406

exit_message:

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

id: 161516585

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_imspos_items/2026-04-05/1775382947",
        "key": "raw/stellar_imspos_items/2026-04-05/1775382947/pos_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2187010019764655385,
        "service_name": "drive-thru",
        "span_id": 4138598322277375458,
        "trace_id": 15926950609429867677
    }
}

running: False
schema_name_id: 1453
start_time: 2026-04-05 04:58:14
success: True
trace_id: 15926950609429867677

Scan 161462083

duration: 0:00:14.357645

exit_message:

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

id: 161462083

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_imspos_items/2026-04-04/1775296461",
        "key": "raw/stellar_imspos_items/2026-04-04/1775296461/pos_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6220422846215756364,
        "service_name": "drive-thru",
        "span_id": 1492303260694324876,
        "trace_id": 12748867417744591509
    }
}

running: False
schema_name_id: 1453
start_time: 2026-04-04 04:54:49
success: True
trace_id: 12748867417744591509

Scan 161404872

duration: 0:00:11.830066

exit_message:

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

id: 161404872

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_imspos_items/2026-04-03/1775211037",
        "key": "raw/stellar_imspos_items/2026-04-03/1775211037/pos_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_items",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15543334679002855825,
        "service_name": "drive-thru",
        "span_id": 17008086221701032903,
        "trace_id": 4883538487862743114
    }
}

running: False
schema_name_id: 1453
start_time: 2026-04-03 05:14:01
success: True
trace_id: 4883538487862743114

Partitions:

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

Schema:

attributes:

{
    "cost": "string",
    "created_at": "string",
    "id": "string",
    "item_name": "string",
    "location_id": "string",
    "price": "string",
    "sku": "string",
    "tax_exempt": "string",
    "tenant": "string",
    "updated_at": "string"
}

created: 2026-04-17 04:58:36

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `sku`  string , `item_name`  string , `cost`  string , `price`  string , `tax_exempt`  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_imspos_items/2026-04-17/1776419649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_items`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_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:46:12",
        "disabled": false,
        "format": "raw",
        "id": 1453,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imspos_items"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "cost": "string",
            "created_at": "string",
            "id": "string",
            "item_name": "string",
            "location_id": "string",
            "price": "string",
            "sku": "string",
            "tax_exempt": "string",
            "tenant": "string",
            "updated_at": "string"
        },
        "created": "2026-04-17 04:58:36",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_items`\n(\n `tenant`  string , `id`  string , `location_id`  string , `sku`  string , `item_name`  string , `cost`  string , `price`  string , `tax_exempt`  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_imspos_items/2026-04-17/1776419649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_items`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_items"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}