Schema Info

Schema Name: sfdl_prod_drivethru.molo_molosv_partset

created: 2023-10-17 02:00:28
disabled: False
format: raw
id: 1746
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717809

created: 2026-04-17 03:12:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_partset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_partset`\n(\n `Id`  string , `Code`  string , `Name`  string , `Price`  string , `Quantity`  string , `Stock`  string , `Discount`  string , `ItemMaster_Id`  string , `SV_Manufacturer_Id`  string , `SV_Inventory_Id`  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_moloSV_PartSet/2026-04-17/1776413125'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_partset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_PartSet/2026-04-17/1776413125
id: 1717809
processed: 1

raw_data:

{
    "Code": 1,
    "Discount": 6,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 2,
    "Price": 3,
    "Quantity": 4,
    "SV_Inventory_Id": 9,
    "SV_Manufacturer_Id": 8,
    "Stock": 5
}

schema_attributes:

{
    "Code": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "SV_Inventory_Id": "string",
    "SV_Manufacturer_Id": "string",
    "Stock": "string"
}

schema_name_id: 1746
schema_scan_id: 162167845
updated: 2026-04-17 03:12:50

Version 1716544

created: 2026-04-16 03:13:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_partset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_partset`\n(\n `Id`  string , `Code`  string , `Name`  string , `Price`  string , `Quantity`  string , `Stock`  string , `Discount`  string , `ItemMaster_Id`  string , `SV_Manufacturer_Id`  string , `SV_Inventory_Id`  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_moloSV_PartSet/2026-04-16/1776326730'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_partset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_PartSet/2026-04-16/1776326730
id: 1716544
processed: 1

raw_data:

{
    "Code": 1,
    "Discount": 6,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 2,
    "Price": 3,
    "Quantity": 4,
    "SV_Inventory_Id": 9,
    "SV_Manufacturer_Id": 8,
    "Stock": 5
}

schema_attributes:

{
    "Code": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "SV_Inventory_Id": "string",
    "SV_Manufacturer_Id": "string",
    "Stock": "string"
}

schema_name_id: 1746
schema_scan_id: 162111998
updated: 2026-04-16 03:13:29

Version 1715334

created: 2026-04-15 03:10:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_partset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_partset`\n(\n `Id`  string , `Code`  string , `Name`  string , `Price`  string , `Quantity`  string , `Stock`  string , `Discount`  string , `ItemMaster_Id`  string , `SV_Manufacturer_Id`  string , `SV_Inventory_Id`  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_moloSV_PartSet/2026-04-15/1776240197'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_partset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_PartSet/2026-04-15/1776240197
id: 1715334
processed: 1

raw_data:

{
    "Code": 1,
    "Discount": 6,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 2,
    "Price": 3,
    "Quantity": 4,
    "SV_Inventory_Id": 9,
    "SV_Manufacturer_Id": 8,
    "Stock": 5
}

schema_attributes:

{
    "Code": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "SV_Inventory_Id": "string",
    "SV_Manufacturer_Id": "string",
    "Stock": "string"
}

schema_name_id: 1746
schema_scan_id: 162056126
updated: 2026-04-15 03:10:56

Version 1714118

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_partset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_partset`\n(\n `Id`  string , `Code`  string , `Name`  string , `Price`  string , `Quantity`  string , `Stock`  string , `Discount`  string , `ItemMaster_Id`  string , `SV_Manufacturer_Id`  string , `SV_Inventory_Id`  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_moloSV_PartSet/2026-04-14/1776154163'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_partset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_PartSet/2026-04-14/1776154163
id: 1714118
processed: 1

raw_data:

{
    "Code": 1,
    "Discount": 6,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 2,
    "Price": 3,
    "Quantity": 4,
    "SV_Inventory_Id": 9,
    "SV_Manufacturer_Id": 8,
    "Stock": 5
}

schema_attributes:

{
    "Code": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "SV_Inventory_Id": "string",
    "SV_Manufacturer_Id": "string",
    "Stock": "string"
}

schema_name_id: 1746
schema_scan_id: 162000634
updated: 2026-04-14 03:10:13

Version 1712893

created: 2026-04-13 03:03:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_partset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_partset`\n(\n `Id`  string , `Code`  string , `Name`  string , `Price`  string , `Quantity`  string , `Stock`  string , `Discount`  string , `ItemMaster_Id`  string , `SV_Manufacturer_Id`  string , `SV_Inventory_Id`  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_moloSV_PartSet/2026-04-13/1776067159'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_partset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_PartSet/2026-04-13/1776067159
id: 1712893
processed: 1

raw_data:

{
    "Code": 1,
    "Discount": 6,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 2,
    "Price": 3,
    "Quantity": 4,
    "SV_Inventory_Id": 9,
    "SV_Manufacturer_Id": 8,
    "Stock": 5
}

schema_attributes:

{
    "Code": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "SV_Inventory_Id": "string",
    "SV_Manufacturer_Id": "string",
    "Stock": "string"
}

schema_name_id: 1746
schema_scan_id: 161942571
updated: 2026-04-13 03:03:35

Version 1711699

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_partset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_partset`\n(\n `Id`  string , `Code`  string , `Name`  string , `Price`  string , `Quantity`  string , `Stock`  string , `Discount`  string , `ItemMaster_Id`  string , `SV_Manufacturer_Id`  string , `SV_Inventory_Id`  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_moloSV_PartSet/2026-04-12/1775980857'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_partset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_PartSet/2026-04-12/1775980857
id: 1711699
processed: 1

raw_data:

{
    "Code": 1,
    "Discount": 6,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 2,
    "Price": 3,
    "Quantity": 4,
    "SV_Inventory_Id": 9,
    "SV_Manufacturer_Id": 8,
    "Stock": 5
}

schema_attributes:

{
    "Code": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "SV_Inventory_Id": "string",
    "SV_Manufacturer_Id": "string",
    "Stock": "string"
}

schema_name_id: 1746
schema_scan_id: 161893339
updated: 2026-04-12 03:05:44

Version 1710450

created: 2026-04-11 03:06:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_partset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_partset`\n(\n `Id`  string , `Code`  string , `Name`  string , `Price`  string , `Quantity`  string , `Stock`  string , `Discount`  string , `ItemMaster_Id`  string , `SV_Manufacturer_Id`  string , `SV_Inventory_Id`  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_moloSV_PartSet/2026-04-11/1775894626'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_partset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_PartSet/2026-04-11/1775894626
id: 1710450
processed: 1

raw_data:

{
    "Code": 1,
    "Discount": 6,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 2,
    "Price": 3,
    "Quantity": 4,
    "SV_Inventory_Id": 9,
    "SV_Manufacturer_Id": 8,
    "Stock": 5
}

schema_attributes:

{
    "Code": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "SV_Inventory_Id": "string",
    "SV_Manufacturer_Id": "string",
    "Stock": "string"
}

schema_name_id: 1746
schema_scan_id: 161841238
updated: 2026-04-11 03:06:45

Version 1709364

created: 2026-04-10 03:10:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_partset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_partset`\n(\n `Id`  string , `Code`  string , `Name`  string , `Price`  string , `Quantity`  string , `Stock`  string , `Discount`  string , `ItemMaster_Id`  string , `SV_Manufacturer_Id`  string , `SV_Inventory_Id`  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_moloSV_PartSet/2026-04-10/1775808387'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_partset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_PartSet/2026-04-10/1775808387
id: 1709364
processed: 1

raw_data:

{
    "Code": 1,
    "Discount": 6,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 2,
    "Price": 3,
    "Quantity": 4,
    "SV_Inventory_Id": 9,
    "SV_Manufacturer_Id": 8,
    "Stock": 5
}

schema_attributes:

{
    "Code": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "SV_Inventory_Id": "string",
    "SV_Manufacturer_Id": "string",
    "Stock": "string"
}

schema_name_id: 1746
schema_scan_id: 161786064
updated: 2026-04-10 03:10:52

Version 1708136

created: 2026-04-09 03:03:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_partset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_partset`\n(\n `Id`  string , `Code`  string , `Name`  string , `Price`  string , `Quantity`  string , `Stock`  string , `Discount`  string , `ItemMaster_Id`  string , `SV_Manufacturer_Id`  string , `SV_Inventory_Id`  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_moloSV_PartSet/2026-04-09/1775721716'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_partset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_PartSet/2026-04-09/1775721716
id: 1708136
processed: 1

raw_data:

{
    "Code": 1,
    "Discount": 6,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 2,
    "Price": 3,
    "Quantity": 4,
    "SV_Inventory_Id": 9,
    "SV_Manufacturer_Id": 8,
    "Stock": 5
}

schema_attributes:

{
    "Code": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "SV_Inventory_Id": "string",
    "SV_Manufacturer_Id": "string",
    "Stock": "string"
}

schema_name_id: 1746
schema_scan_id: 161730298
updated: 2026-04-09 03:04:03

Version 1707049

created: 2026-04-08 03:11:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_partset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_partset`\n(\n `Id`  string , `Code`  string , `Name`  string , `Price`  string , `Quantity`  string , `Stock`  string , `Discount`  string , `ItemMaster_Id`  string , `SV_Manufacturer_Id`  string , `SV_Inventory_Id`  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_moloSV_PartSet/2026-04-08/1775635548'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_partset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_PartSet/2026-04-08/1775635548
id: 1707049
processed: 1

raw_data:

{
    "Code": 1,
    "Discount": 6,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 2,
    "Price": 3,
    "Quantity": 4,
    "SV_Inventory_Id": 9,
    "SV_Manufacturer_Id": 8,
    "Stock": 5
}

schema_attributes:

{
    "Code": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "SV_Inventory_Id": "string",
    "SV_Manufacturer_Id": "string",
    "Stock": "string"
}

schema_name_id: 1746
schema_scan_id: 161675717
updated: 2026-04-08 03:11:45

Version 1705836

created: 2026-04-07 03:02:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_partset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_partset`\n(\n `Id`  string , `Code`  string , `Name`  string , `Price`  string , `Quantity`  string , `Stock`  string , `Discount`  string , `ItemMaster_Id`  string , `SV_Manufacturer_Id`  string , `SV_Inventory_Id`  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_moloSV_PartSet/2026-04-07/1775548709'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_partset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_PartSet/2026-04-07/1775548709
id: 1705836
processed: 1

raw_data:

{
    "Code": 1,
    "Discount": 6,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 2,
    "Price": 3,
    "Quantity": 4,
    "SV_Inventory_Id": 9,
    "SV_Manufacturer_Id": 8,
    "Stock": 5
}

schema_attributes:

{
    "Code": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "SV_Inventory_Id": "string",
    "SV_Manufacturer_Id": "string",
    "Stock": "string"
}

schema_name_id: 1746
schema_scan_id: 161619308
updated: 2026-04-07 03:03:02

Version 1704498

created: 2026-04-06 03:06:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_partset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_partset`\n(\n `Id`  string , `Code`  string , `Name`  string , `Price`  string , `Quantity`  string , `Stock`  string , `Discount`  string , `ItemMaster_Id`  string , `SV_Manufacturer_Id`  string , `SV_Inventory_Id`  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_moloSV_PartSet/2026-04-06/1775462660'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_partset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_PartSet/2026-04-06/1775462660
id: 1704498
processed: 1

raw_data:

{
    "Code": 1,
    "Discount": 6,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 2,
    "Price": 3,
    "Quantity": 4,
    "SV_Inventory_Id": 9,
    "SV_Manufacturer_Id": 8,
    "Stock": 5
}

schema_attributes:

{
    "Code": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "SV_Inventory_Id": "string",
    "SV_Manufacturer_Id": "string",
    "Stock": "string"
}

schema_name_id: 1746
schema_scan_id: 161561587
updated: 2026-04-06 03:06:18

Version 1703430

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_partset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_partset`\n(\n `Id`  string , `Code`  string , `Name`  string , `Price`  string , `Quantity`  string , `Stock`  string , `Discount`  string , `ItemMaster_Id`  string , `SV_Manufacturer_Id`  string , `SV_Inventory_Id`  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_moloSV_PartSet/2026-04-05/1775376291'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_partset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_PartSet/2026-04-05/1775376291
id: 1703430
processed: 1

raw_data:

{
    "Code": 1,
    "Discount": 6,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 2,
    "Price": 3,
    "Quantity": 4,
    "SV_Inventory_Id": 9,
    "SV_Manufacturer_Id": 8,
    "Stock": 5
}

schema_attributes:

{
    "Code": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "SV_Inventory_Id": "string",
    "SV_Manufacturer_Id": "string",
    "Stock": "string"
}

schema_name_id: 1746
schema_scan_id: 161515018
updated: 2026-04-05 03:10:26

Version 1702177

created: 2026-04-04 03:06:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_partset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_partset`\n(\n `Id`  string , `Code`  string , `Name`  string , `Price`  string , `Quantity`  string , `Stock`  string , `Discount`  string , `ItemMaster_Id`  string , `SV_Manufacturer_Id`  string , `SV_Inventory_Id`  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_moloSV_PartSet/2026-04-04/1775289772'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_partset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_PartSet/2026-04-04/1775289772
id: 1702177
processed: 1

raw_data:

{
    "Code": 1,
    "Discount": 6,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 2,
    "Price": 3,
    "Quantity": 4,
    "SV_Inventory_Id": 9,
    "SV_Manufacturer_Id": 8,
    "Stock": 5
}

schema_attributes:

{
    "Code": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "SV_Inventory_Id": "string",
    "SV_Manufacturer_Id": "string",
    "Stock": "string"
}

schema_name_id: 1746
schema_scan_id: 161460416
updated: 2026-04-04 03:06:26

Version 1701056

created: 2026-04-03 03:15:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_partset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_partset`\n(\n `Id`  string , `Code`  string , `Name`  string , `Price`  string , `Quantity`  string , `Stock`  string , `Discount`  string , `ItemMaster_Id`  string , `SV_Manufacturer_Id`  string , `SV_Inventory_Id`  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_moloSV_PartSet/2026-04-03/1775203539'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_partset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_PartSet/2026-04-03/1775203539
id: 1701056
processed: 1

raw_data:

{
    "Code": 1,
    "Discount": 6,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 2,
    "Price": 3,
    "Quantity": 4,
    "SV_Inventory_Id": 9,
    "SV_Manufacturer_Id": 8,
    "Stock": 5
}

schema_attributes:

{
    "Code": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "SV_Inventory_Id": "string",
    "SV_Manufacturer_Id": "string",
    "Stock": "string"
}

schema_name_id: 1746
schema_scan_id: 161402045
updated: 2026-04-03 03:15:21

Schema Scans: 15

Last at 2026-04-17 03:12:38

Scan 162167845

duration: 0:00:11.923943

exit_message:

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

id: 162167845

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_moloSV_PartSet/2026-04-17/1776413125",
        "key": "raw/molo_moloSV_PartSet/2026-04-17/1776413125/SV_PartSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_PartSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17944903516640928415,
        "service_name": "drive-thru",
        "span_id": 9627353771812709752,
        "trace_id": 10159423962056622212
    }
}

running: False
schema_name_id: 1746
start_time: 2026-04-17 03:12:38
success: True
trace_id: 10159423962056622212

Scan 162111998

duration: 0:00:12.082099

exit_message:

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

id: 162111998

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_moloSV_PartSet/2026-04-16/1776326730",
        "key": "raw/molo_moloSV_PartSet/2026-04-16/1776326730/SV_PartSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_PartSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14510076444465638121,
        "service_name": "drive-thru",
        "span_id": 15446936560632286512,
        "trace_id": 4443496913236355191
    }
}

running: False
schema_name_id: 1746
start_time: 2026-04-16 03:13:17
success: True
trace_id: 4443496913236355191

Scan 162056126

duration: 0:00:12.034225

exit_message:

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

id: 162056126

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_moloSV_PartSet/2026-04-15/1776240197",
        "key": "raw/molo_moloSV_PartSet/2026-04-15/1776240197/SV_PartSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_PartSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5420340054911594753,
        "service_name": "drive-thru",
        "span_id": 8255036333057465368,
        "trace_id": 7742687047241374540
    }
}

running: False
schema_name_id: 1746
start_time: 2026-04-15 03:10:44
success: True
trace_id: 7742687047241374540

Scan 162000634

duration: 0:00:12.039877

exit_message:

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

id: 162000634

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_moloSV_PartSet/2026-04-14/1776154163",
        "key": "raw/molo_moloSV_PartSet/2026-04-14/1776154163/SV_PartSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_PartSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16361390101262710458,
        "service_name": "drive-thru",
        "span_id": 1098629921047441235,
        "trace_id": 457471876389861777
    }
}

running: False
schema_name_id: 1746
start_time: 2026-04-14 03:10:01
success: True
trace_id: 457471876389861777

Scan 161942571

duration: 0:00:12.049914

exit_message:

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

id: 161942571

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_moloSV_PartSet/2026-04-13/1776067159",
        "key": "raw/molo_moloSV_PartSet/2026-04-13/1776067159/SV_PartSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_PartSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9812001865969508012,
        "service_name": "drive-thru",
        "span_id": 3002580527421592261,
        "trace_id": 7776679712373711012
    }
}

running: False
schema_name_id: 1746
start_time: 2026-04-13 03:03:23
success: True
trace_id: 7776679712373711012

Scan 161893339

duration: 0:00:14.417272

exit_message:

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

id: 161893339

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_moloSV_PartSet/2026-04-12/1775980857",
        "key": "raw/molo_moloSV_PartSet/2026-04-12/1775980857/SV_PartSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_PartSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15968858572155066733,
        "service_name": "drive-thru",
        "span_id": 4755214651792344963,
        "trace_id": 3514096979999912776
    }
}

running: False
schema_name_id: 1746
start_time: 2026-04-12 03:05:29
success: True
trace_id: 3514096979999912776

Scan 161841238

duration: 0:00:14.378546

exit_message:

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

id: 161841238

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_moloSV_PartSet/2026-04-11/1775894626",
        "key": "raw/molo_moloSV_PartSet/2026-04-11/1775894626/SV_PartSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_PartSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5367336489791943374,
        "service_name": "drive-thru",
        "span_id": 16895639794419030281,
        "trace_id": 12318059605443083265
    }
}

running: False
schema_name_id: 1746
start_time: 2026-04-11 03:06:31
success: True
trace_id: 12318059605443083265

Scan 161786064

duration: 0:00:11.839325

exit_message:

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

id: 161786064

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_moloSV_PartSet/2026-04-10/1775808387",
        "key": "raw/molo_moloSV_PartSet/2026-04-10/1775808387/SV_PartSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_PartSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17391628998767404163,
        "service_name": "drive-thru",
        "span_id": 3657348706206084661,
        "trace_id": 1975798783052914162
    }
}

running: False
schema_name_id: 1746
start_time: 2026-04-10 03:10:40
success: True
trace_id: 1975798783052914162

Scan 161730298

duration: 0:00:11.923842

exit_message:

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

id: 161730298

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_moloSV_PartSet/2026-04-09/1775721716",
        "key": "raw/molo_moloSV_PartSet/2026-04-09/1775721716/SV_PartSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_PartSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 398331826422410912,
        "service_name": "drive-thru",
        "span_id": 7532225147315215613,
        "trace_id": 18001992799172460223
    }
}

running: False
schema_name_id: 1746
start_time: 2026-04-09 03:03:51
success: True
trace_id: 18001992799172460223

Scan 161675717

duration: 0:00:14.760960

exit_message:

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

id: 161675717

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_moloSV_PartSet/2026-04-08/1775635548",
        "key": "raw/molo_moloSV_PartSet/2026-04-08/1775635548/SV_PartSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_PartSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15632287328757534306,
        "service_name": "drive-thru",
        "span_id": 11524704236628495222,
        "trace_id": 14774290726109006562
    }
}

running: False
schema_name_id: 1746
start_time: 2026-04-08 03:11:30
success: True
trace_id: 14774290726109006562

Scan 161619308

duration: 0:00:11.778001

exit_message:

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

id: 161619308

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_moloSV_PartSet/2026-04-07/1775548709",
        "key": "raw/molo_moloSV_PartSet/2026-04-07/1775548709/SV_PartSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_PartSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9692620173376998548,
        "service_name": "drive-thru",
        "span_id": 272771735775376339,
        "trace_id": 9552079631224681306
    }
}

running: False
schema_name_id: 1746
start_time: 2026-04-07 03:02:50
success: True
trace_id: 9552079631224681306

Scan 161561587

duration: 0:00:14.400326

exit_message:

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

id: 161561587

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_moloSV_PartSet/2026-04-06/1775462660",
        "key": "raw/molo_moloSV_PartSet/2026-04-06/1775462660/SV_PartSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_PartSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12476633901588694256,
        "service_name": "drive-thru",
        "span_id": 5388171925697975218,
        "trace_id": 12133686962646063575
    }
}

running: False
schema_name_id: 1746
start_time: 2026-04-06 03:06:04
success: True
trace_id: 12133686962646063575

Scan 161515018

duration: 0:00:11.831502

exit_message:

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

id: 161515018

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_moloSV_PartSet/2026-04-05/1775376291",
        "key": "raw/molo_moloSV_PartSet/2026-04-05/1775376291/SV_PartSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_PartSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2111570344059641374,
        "service_name": "drive-thru",
        "span_id": 896856156720709560,
        "trace_id": 17160523404005396776
    }
}

running: False
schema_name_id: 1746
start_time: 2026-04-05 03:10:14
success: True
trace_id: 17160523404005396776

Scan 161460416

duration: 0:00:14.336282

exit_message:

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

id: 161460416

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_moloSV_PartSet/2026-04-04/1775289772",
        "key": "raw/molo_moloSV_PartSet/2026-04-04/1775289772/SV_PartSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_PartSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2363370427120369039,
        "service_name": "drive-thru",
        "span_id": 12747483250152228414,
        "trace_id": 6464174785579663950
    }
}

running: False
schema_name_id: 1746
start_time: 2026-04-04 03:06:12
success: True
trace_id: 6464174785579663950

Scan 161402045

duration: 0:00:11.928718

exit_message:

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

id: 161402045

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_moloSV_PartSet/2026-04-03/1775203539",
        "key": "raw/molo_moloSV_PartSet/2026-04-03/1775203539/SV_PartSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_PartSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15050366773820928886,
        "service_name": "drive-thru",
        "span_id": 5727320522068089516,
        "trace_id": 11833134919411747716
    }
}

running: False
schema_name_id: 1746
start_time: 2026-04-03 03:15:09
success: True
trace_id: 11833134919411747716

Partitions:

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

Schema:

attributes:

{
    "Code": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "SV_Inventory_Id": "string",
    "SV_Manufacturer_Id": "string",
    "Stock": "string"
}

created: 2026-04-17 03:12:39

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_partset`\n(\n `Id`  string , `Code`  string , `Name`  string , `Price`  string , `Quantity`  string , `Stock`  string , `Discount`  string , `ItemMaster_Id`  string , `SV_Manufacturer_Id`  string , `SV_Inventory_Id`  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_moloSV_PartSet/2026-04-17/1776413125'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_partset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_partset"
}

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-10-17 02:00:28",
        "disabled": false,
        "format": "raw",
        "id": 1746,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molosv_partset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Code": "string",
            "Discount": "string",
            "Id": "string",
            "ItemMaster_Id": "string",
            "Name": "string",
            "Price": "string",
            "Quantity": "string",
            "SV_Inventory_Id": "string",
            "SV_Manufacturer_Id": "string",
            "Stock": "string"
        },
        "created": "2026-04-17 03:12:39",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_partset`\n(\n `Id`  string , `Code`  string , `Name`  string , `Price`  string , `Quantity`  string , `Stock`  string , `Discount`  string , `ItemMaster_Id`  string , `SV_Manufacturer_Id`  string , `SV_Inventory_Id`  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_moloSV_PartSet/2026-04-17/1776413125'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_partset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_partset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}