Schema Info

Schema Name: sfdl_prod_drivethru.molo_molotransientinventoryitems

created: 2025-07-11 02:18:21
disabled: False
format: raw
id: 4260
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717740

created: 2026-04-17 03:08:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientinventoryitems`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientinventoryitems`\n(\n `Id`  string , `TransientPriceId`  string , `ItemMasterId`  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/molo_moloTransientInventoryItems/2026-04-17/1776413222'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientinventoryitems"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientInventoryItems/2026-04-17/1776413222
id: 1717740
processed: 1

raw_data:

{
    "Id": 0,
    "ItemMasterId": 2,
    "TransientPriceId": 1
}

schema_attributes:

{
    "Id": "string",
    "ItemMasterId": "string",
    "TransientPriceId": "string"
}

schema_name_id: 4260
schema_scan_id: 162167745
updated: 2026-04-17 03:09:13

Version 1716469

created: 2026-04-16 03:10:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientinventoryitems`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientinventoryitems`\n(\n `Id`  string , `TransientPriceId`  string , `ItemMasterId`  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/molo_moloTransientInventoryItems/2026-04-16/1776326746'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientinventoryitems"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientInventoryItems/2026-04-16/1776326746
id: 1716469
processed: 1

raw_data:

{
    "Id": 0,
    "ItemMasterId": 2,
    "TransientPriceId": 1
}

schema_attributes:

{
    "Id": "string",
    "ItemMasterId": "string",
    "TransientPriceId": "string"
}

schema_name_id: 4260
schema_scan_id: 162111906
updated: 2026-04-16 03:10:36

Version 1715387

created: 2026-04-15 03:13:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientinventoryitems`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientinventoryitems`\n(\n `Id`  string , `TransientPriceId`  string , `ItemMasterId`  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/molo_moloTransientInventoryItems/2026-04-15/1776240205'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientinventoryitems"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientInventoryItems/2026-04-15/1776240205
id: 1715387
processed: 1

raw_data:

{
    "Id": 0,
    "ItemMasterId": 2,
    "TransientPriceId": 1
}

schema_attributes:

{
    "Id": "string",
    "ItemMasterId": "string",
    "TransientPriceId": "string"
}

schema_name_id: 4260
schema_scan_id: 162056197
updated: 2026-04-15 03:13:36

Version 1714167

created: 2026-04-14 03:11:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientinventoryitems`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientinventoryitems`\n(\n `Id`  string , `TransientPriceId`  string , `ItemMasterId`  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/molo_moloTransientInventoryItems/2026-04-14/1776154171'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientinventoryitems"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientInventoryItems/2026-04-14/1776154171
id: 1714167
processed: 1

raw_data:

{
    "Id": 0,
    "ItemMasterId": 2,
    "TransientPriceId": 1
}

schema_attributes:

{
    "Id": "string",
    "ItemMasterId": "string",
    "TransientPriceId": "string"
}

schema_name_id: 4260
schema_scan_id: 162000690
updated: 2026-04-14 03:12:06

Version 1712934

created: 2026-04-13 03:05:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientinventoryitems`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientinventoryitems`\n(\n `Id`  string , `TransientPriceId`  string , `ItemMasterId`  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/molo_moloTransientInventoryItems/2026-04-13/1776067165'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientinventoryitems"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientInventoryItems/2026-04-13/1776067165
id: 1712934
processed: 1

raw_data:

{
    "Id": 0,
    "ItemMasterId": 2,
    "TransientPriceId": 1
}

schema_attributes:

{
    "Id": "string",
    "ItemMasterId": "string",
    "TransientPriceId": "string"
}

schema_name_id: 4260
schema_scan_id: 161942719
updated: 2026-04-13 03:05:40

Version 1711750

created: 2026-04-12 03:07:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientinventoryitems`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientinventoryitems`\n(\n `Id`  string , `TransientPriceId`  string , `ItemMasterId`  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/molo_moloTransientInventoryItems/2026-04-12/1775980866'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientinventoryitems"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientInventoryItems/2026-04-12/1775980866
id: 1711750
processed: 1

raw_data:

{
    "Id": 0,
    "ItemMasterId": 2,
    "TransientPriceId": 1
}

schema_attributes:

{
    "Id": "string",
    "ItemMasterId": "string",
    "TransientPriceId": "string"
}

schema_name_id: 4260
schema_scan_id: 161893449
updated: 2026-04-12 03:08:07

Version 1710523

created: 2026-04-11 03:09:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientinventoryitems`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientinventoryitems`\n(\n `Id`  string , `TransientPriceId`  string , `ItemMasterId`  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/molo_moloTransientInventoryItems/2026-04-11/1775894641'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientinventoryitems"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientInventoryItems/2026-04-11/1775894641
id: 1710523
processed: 1

raw_data:

{
    "Id": 0,
    "ItemMasterId": 2,
    "TransientPriceId": 1
}

schema_attributes:

{
    "Id": "string",
    "ItemMasterId": "string",
    "TransientPriceId": "string"
}

schema_name_id: 4260
schema_scan_id: 161841318
updated: 2026-04-11 03:09:33

Version 1709330

created: 2026-04-10 03:09:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientinventoryitems`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientinventoryitems`\n(\n `Id`  string , `TransientPriceId`  string , `ItemMasterId`  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/molo_moloTransientInventoryItems/2026-04-10/1775808398'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientinventoryitems"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientInventoryItems/2026-04-10/1775808398
id: 1709330
processed: 1

raw_data:

{
    "Id": 0,
    "ItemMasterId": 2,
    "TransientPriceId": 1
}

schema_attributes:

{
    "Id": "string",
    "ItemMasterId": "string",
    "TransientPriceId": "string"
}

schema_name_id: 4260
schema_scan_id: 161786029
updated: 2026-04-10 03:09:37

Version 1708281

created: 2026-04-09 03:10:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientinventoryitems`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientinventoryitems`\n(\n `Id`  string , `TransientPriceId`  string , `ItemMasterId`  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/molo_moloTransientInventoryItems/2026-04-09/1775721727'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientinventoryitems"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientInventoryItems/2026-04-09/1775721727
id: 1708281
processed: 1

raw_data:

{
    "Id": 0,
    "ItemMasterId": 2,
    "TransientPriceId": 1
}

schema_attributes:

{
    "Id": "string",
    "ItemMasterId": "string",
    "TransientPriceId": "string"
}

schema_name_id: 4260
schema_scan_id: 161730577
updated: 2026-04-09 03:10:38

Version 1706962

created: 2026-04-08 03:08:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientinventoryitems`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientinventoryitems`\n(\n `Id`  string , `TransientPriceId`  string , `ItemMasterId`  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/molo_moloTransientInventoryItems/2026-04-08/1775635558'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientinventoryitems"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientInventoryItems/2026-04-08/1775635558
id: 1706962
processed: 1

raw_data:

{
    "Id": 0,
    "ItemMasterId": 2,
    "TransientPriceId": 1
}

schema_attributes:

{
    "Id": "string",
    "ItemMasterId": "string",
    "TransientPriceId": "string"
}

schema_name_id: 4260
schema_scan_id: 161675613
updated: 2026-04-08 03:08:13

Version 1705882

created: 2026-04-07 03:05:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientinventoryitems`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientinventoryitems`\n(\n `Id`  string , `TransientPriceId`  string , `ItemMasterId`  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/molo_moloTransientInventoryItems/2026-04-07/1775548717'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientinventoryitems"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientInventoryItems/2026-04-07/1775548717
id: 1705882
processed: 1

raw_data:

{
    "Id": 0,
    "ItemMasterId": 2,
    "TransientPriceId": 1
}

schema_attributes:

{
    "Id": "string",
    "ItemMasterId": "string",
    "TransientPriceId": "string"
}

schema_name_id: 4260
schema_scan_id: 161619481
updated: 2026-04-07 03:05:29

Version 1704564

created: 2026-04-06 03:08:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientinventoryitems`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientinventoryitems`\n(\n `Id`  string , `TransientPriceId`  string , `ItemMasterId`  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/molo_moloTransientInventoryItems/2026-04-06/1775462669'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientinventoryitems"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientInventoryItems/2026-04-06/1775462669
id: 1704564
processed: 1

raw_data:

{
    "Id": 0,
    "ItemMasterId": 2,
    "TransientPriceId": 1
}

schema_attributes:

{
    "Id": "string",
    "ItemMasterId": "string",
    "TransientPriceId": "string"
}

schema_name_id: 4260
schema_scan_id: 161561684
updated: 2026-04-06 03:08:58

Version 1703449

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientinventoryitems`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientinventoryitems`\n(\n `Id`  string , `TransientPriceId`  string , `ItemMasterId`  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/molo_moloTransientInventoryItems/2026-04-05/1775376299'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientinventoryitems"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientInventoryItems/2026-04-05/1775376299
id: 1703449
processed: 1

raw_data:

{
    "Id": 0,
    "ItemMasterId": 2,
    "TransientPriceId": 1
}

schema_attributes:

{
    "Id": "string",
    "ItemMasterId": "string",
    "TransientPriceId": "string"
}

schema_name_id: 4260
schema_scan_id: 161515039
updated: 2026-04-05 03:11:07

Version 1702300

created: 2026-04-04 03:12:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientinventoryitems`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientinventoryitems`\n(\n `Id`  string , `TransientPriceId`  string , `ItemMasterId`  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/molo_moloTransientInventoryItems/2026-04-04/1775289783'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientinventoryitems"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientInventoryItems/2026-04-04/1775289783
id: 1702300
processed: 1

raw_data:

{
    "Id": 0,
    "ItemMasterId": 2,
    "TransientPriceId": 1
}

schema_attributes:

{
    "Id": "string",
    "ItemMasterId": "string",
    "TransientPriceId": "string"
}

schema_name_id: 4260
schema_scan_id: 161460629
updated: 2026-04-04 03:12:17

Version 1701019

created: 2026-04-03 03:13:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientinventoryitems`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientinventoryitems`\n(\n `Id`  string , `TransientPriceId`  string , `ItemMasterId`  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/molo_moloTransientInventoryItems/2026-04-03/1775203548'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientinventoryitems"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTransientInventoryItems/2026-04-03/1775203548
id: 1701019
processed: 1

raw_data:

{
    "Id": 0,
    "ItemMasterId": 2,
    "TransientPriceId": 1
}

schema_attributes:

{
    "Id": "string",
    "ItemMasterId": "string",
    "TransientPriceId": "string"
}

schema_name_id: 4260
schema_scan_id: 161401994
updated: 2026-04-03 03:13:24

Schema Scans: 15

Last at 2026-04-17 03:08:59

Scan 162167745

duration: 0:00:14.131480

exit_message:

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

id: 162167745

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/molo_moloTransientInventoryItems/2026-04-17/1776413222",
        "key": "raw/molo_moloTransientInventoryItems/2026-04-17/1776413222/TransientInventoryItems.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInventoryItems",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10348298124125173674,
        "service_name": "drive-thru",
        "span_id": 1913961160597406224,
        "trace_id": 11822625007045851681
    }
}

running: False
schema_name_id: 4260
start_time: 2026-04-17 03:08:59
success: True
trace_id: 11822625007045851681

Scan 162111906

duration: 0:00:11.702098

exit_message:

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

id: 162111906

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/molo_moloTransientInventoryItems/2026-04-16/1776326746",
        "key": "raw/molo_moloTransientInventoryItems/2026-04-16/1776326746/TransientInventoryItems.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInventoryItems",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16260279262250771877,
        "service_name": "drive-thru",
        "span_id": 94007413953718311,
        "trace_id": 13813940787276372520
    }
}

running: False
schema_name_id: 4260
start_time: 2026-04-16 03:10:24
success: True
trace_id: 13813940787276372520

Scan 162056197

duration: 0:00:11.581574

exit_message:

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

id: 162056197

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/molo_moloTransientInventoryItems/2026-04-15/1776240205",
        "key": "raw/molo_moloTransientInventoryItems/2026-04-15/1776240205/TransientInventoryItems.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInventoryItems",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14403617382717160797,
        "service_name": "drive-thru",
        "span_id": 15396091878136258608,
        "trace_id": 4608187655279948415
    }
}

running: False
schema_name_id: 4260
start_time: 2026-04-15 03:13:24
success: True
trace_id: 4608187655279948415

Scan 162000690

duration: 0:00:14.111676

exit_message:

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

id: 162000690

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/molo_moloTransientInventoryItems/2026-04-14/1776154171",
        "key": "raw/molo_moloTransientInventoryItems/2026-04-14/1776154171/TransientInventoryItems.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInventoryItems",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5173151558191015331,
        "service_name": "drive-thru",
        "span_id": 12092720060010201632,
        "trace_id": 6202643364398974286
    }
}

running: False
schema_name_id: 4260
start_time: 2026-04-14 03:11:51
success: True
trace_id: 6202643364398974286

Scan 161942719

duration: 0:00:14.008506

exit_message:

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

id: 161942719

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/molo_moloTransientInventoryItems/2026-04-13/1776067165",
        "key": "raw/molo_moloTransientInventoryItems/2026-04-13/1776067165/TransientInventoryItems.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInventoryItems",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13376933637050748791,
        "service_name": "drive-thru",
        "span_id": 13119142219945371434,
        "trace_id": 14776073575812508609
    }
}

running: False
schema_name_id: 4260
start_time: 2026-04-13 03:05:26
success: True
trace_id: 14776073575812508609

Scan 161893449

duration: 0:00:14.072148

exit_message:

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

id: 161893449

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/molo_moloTransientInventoryItems/2026-04-12/1775980866",
        "key": "raw/molo_moloTransientInventoryItems/2026-04-12/1775980866/TransientInventoryItems.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInventoryItems",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9356612196774089983,
        "service_name": "drive-thru",
        "span_id": 2326619824120670618,
        "trace_id": 15014857729837217157
    }
}

running: False
schema_name_id: 4260
start_time: 2026-04-12 03:07:53
success: True
trace_id: 15014857729837217157

Scan 161841318

duration: 0:00:13.986701

exit_message:

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

id: 161841318

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/molo_moloTransientInventoryItems/2026-04-11/1775894641",
        "key": "raw/molo_moloTransientInventoryItems/2026-04-11/1775894641/TransientInventoryItems.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInventoryItems",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5591991940295589346,
        "service_name": "drive-thru",
        "span_id": 10883790351249194776,
        "trace_id": 18034727042742872614
    }
}

running: False
schema_name_id: 4260
start_time: 2026-04-11 03:09:19
success: True
trace_id: 18034727042742872614

Scan 161786029

duration: 0:00:14.232080

exit_message:

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

id: 161786029

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/molo_moloTransientInventoryItems/2026-04-10/1775808398",
        "key": "raw/molo_moloTransientInventoryItems/2026-04-10/1775808398/TransientInventoryItems.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInventoryItems",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3045279045147916239,
        "service_name": "drive-thru",
        "span_id": 1828568253395680303,
        "trace_id": 9165029667095904880
    }
}

running: False
schema_name_id: 4260
start_time: 2026-04-10 03:09:23
success: True
trace_id: 9165029667095904880

Scan 161730577

duration: 0:00:14.050814

exit_message:

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

id: 161730577

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/molo_moloTransientInventoryItems/2026-04-09/1775721727",
        "key": "raw/molo_moloTransientInventoryItems/2026-04-09/1775721727/TransientInventoryItems.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInventoryItems",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 589257514100777330,
        "service_name": "drive-thru",
        "span_id": 45487162113027820,
        "trace_id": 3531001174869149044
    }
}

running: False
schema_name_id: 4260
start_time: 2026-04-09 03:10:24
success: True
trace_id: 3531001174869149044

Scan 161675613

duration: 0:00:11.522784

exit_message:

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

id: 161675613

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/molo_moloTransientInventoryItems/2026-04-08/1775635558",
        "key": "raw/molo_moloTransientInventoryItems/2026-04-08/1775635558/TransientInventoryItems.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInventoryItems",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10752419576260893414,
        "service_name": "drive-thru",
        "span_id": 11375150257493178171,
        "trace_id": 4254061427878581577
    }
}

running: False
schema_name_id: 4260
start_time: 2026-04-08 03:08:01
success: True
trace_id: 4254061427878581577

Scan 161619481

duration: 0:00:14.268619

exit_message:

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

id: 161619481

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/molo_moloTransientInventoryItems/2026-04-07/1775548717",
        "key": "raw/molo_moloTransientInventoryItems/2026-04-07/1775548717/TransientInventoryItems.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInventoryItems",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15758812404506650994,
        "service_name": "drive-thru",
        "span_id": 14260759316559615614,
        "trace_id": 14213258316155961035
    }
}

running: False
schema_name_id: 4260
start_time: 2026-04-07 03:05:15
success: True
trace_id: 14213258316155961035

Scan 161561684

duration: 0:00:14.137660

exit_message:

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

id: 161561684

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/molo_moloTransientInventoryItems/2026-04-06/1775462669",
        "key": "raw/molo_moloTransientInventoryItems/2026-04-06/1775462669/TransientInventoryItems.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInventoryItems",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10099816443475283708,
        "service_name": "drive-thru",
        "span_id": 16297822297942086201,
        "trace_id": 14498756721915461815
    }
}

running: False
schema_name_id: 4260
start_time: 2026-04-06 03:08:44
success: True
trace_id: 14498756721915461815

Scan 161515039

duration: 0:00:14.028129

exit_message:

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

id: 161515039

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/molo_moloTransientInventoryItems/2026-04-05/1775376299",
        "key": "raw/molo_moloTransientInventoryItems/2026-04-05/1775376299/TransientInventoryItems.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInventoryItems",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1155914396819427663,
        "service_name": "drive-thru",
        "span_id": 13343949908211284768,
        "trace_id": 5748903320629109503
    }
}

running: False
schema_name_id: 4260
start_time: 2026-04-05 03:10:53
success: True
trace_id: 5748903320629109503

Scan 161460629

duration: 0:00:14.082355

exit_message:

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

id: 161460629

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/molo_moloTransientInventoryItems/2026-04-04/1775289783",
        "key": "raw/molo_moloTransientInventoryItems/2026-04-04/1775289783/TransientInventoryItems.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInventoryItems",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11394212927302856710,
        "service_name": "drive-thru",
        "span_id": 7636110987559302972,
        "trace_id": 9578332949151121690
    }
}

running: False
schema_name_id: 4260
start_time: 2026-04-04 03:12:03
success: True
trace_id: 9578332949151121690

Scan 161401994

duration: 0:00:14.095467

exit_message:

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

id: 161401994

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/molo_moloTransientInventoryItems/2026-04-03/1775203548",
        "key": "raw/molo_moloTransientInventoryItems/2026-04-03/1775203548/TransientInventoryItems.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTransientInventoryItems",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17000297300091375271,
        "service_name": "drive-thru",
        "span_id": 16160669668579675242,
        "trace_id": 8313753235094844604
    }
}

running: False
schema_name_id: 4260
start_time: 2026-04-03 03:13:10
success: True
trace_id: 8313753235094844604

Partitions:

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

Schema:

attributes:

{
    "Id": "string",
    "ItemMasterId": "string",
    "TransientPriceId": "string"
}

created: 2026-04-17 03:08:59

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientinventoryitems`\n(\n `Id`  string , `TransientPriceId`  string , `ItemMasterId`  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/molo_moloTransientInventoryItems/2026-04-17/1776413222'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientinventoryitems`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientinventoryitems"
}

Server:

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

Raw:

{
    "name": {
        "created": "2025-07-11 02:18:21",
        "disabled": false,
        "format": "raw",
        "id": 4260,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molotransientinventoryitems"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Id": "string",
            "ItemMasterId": "string",
            "TransientPriceId": "string"
        },
        "created": "2026-04-17 03:08:59",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotransientinventoryitems`\n(\n `Id`  string , `TransientPriceId`  string , `ItemMasterId`  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/molo_moloTransientInventoryItems/2026-04-17/1776413222'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotransientinventoryitems`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotransientinventoryitems"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}