Schema Info

Schema Name: sfdl_prod_drivethru.molo_molosv_chargeset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717685

created: 2026-04-17 03:06:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeset`\n(\n `Id`  string , `Name`  string , `Price`  string , `PriceType`  string , `ApplyTo`  string , `Discount`  string , `SV_WorkOrder_Id`  string , `ItemMaster_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_ChargeSet/2026-04-17/1776412994'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeSet/2026-04-17/1776412994
id: 1717685
processed: 1

raw_data:

{
    "ApplyTo": 4,
    "Discount": 5,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 1,
    "Price": 2,
    "PriceType": 3,
    "SV_Inventory_Id": 8,
    "SV_WorkOrder_Id": 6
}

schema_attributes:

{
    "ApplyTo": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "PriceType": "string",
    "SV_Inventory_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1747
schema_scan_id: 162167668
updated: 2026-04-17 03:07:06

Version 1716552

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeset`\n(\n `Id`  string , `Name`  string , `Price`  string , `PriceType`  string , `ApplyTo`  string , `Discount`  string , `SV_WorkOrder_Id`  string , `ItemMaster_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_ChargeSet/2026-04-16/1776326695'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeSet/2026-04-16/1776326695
id: 1716552
processed: 1

raw_data:

{
    "ApplyTo": 4,
    "Discount": 5,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 1,
    "Price": 2,
    "PriceType": 3,
    "SV_Inventory_Id": 8,
    "SV_WorkOrder_Id": 6
}

schema_attributes:

{
    "ApplyTo": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "PriceType": "string",
    "SV_Inventory_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1747
schema_scan_id: 162112011
updated: 2026-04-16 03:13:49

Version 1715370

created: 2026-04-15 03:12:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeset`\n(\n `Id`  string , `Name`  string , `Price`  string , `PriceType`  string , `ApplyTo`  string , `Discount`  string , `SV_WorkOrder_Id`  string , `ItemMaster_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_ChargeSet/2026-04-15/1776240182'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeSet/2026-04-15/1776240182
id: 1715370
processed: 1

raw_data:

{
    "ApplyTo": 4,
    "Discount": 5,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 1,
    "Price": 2,
    "PriceType": 3,
    "SV_Inventory_Id": 8,
    "SV_WorkOrder_Id": 6
}

schema_attributes:

{
    "ApplyTo": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "PriceType": "string",
    "SV_Inventory_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1747
schema_scan_id: 162056169
updated: 2026-04-15 03:12:48

Version 1714126

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeset`\n(\n `Id`  string , `Name`  string , `Price`  string , `PriceType`  string , `ApplyTo`  string , `Discount`  string , `SV_WorkOrder_Id`  string , `ItemMaster_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_ChargeSet/2026-04-14/1776154136'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeSet/2026-04-14/1776154136
id: 1714126
processed: 1

raw_data:

{
    "ApplyTo": 4,
    "Discount": 5,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 1,
    "Price": 2,
    "PriceType": 3,
    "SV_Inventory_Id": 8,
    "SV_WorkOrder_Id": 6
}

schema_attributes:

{
    "ApplyTo": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "PriceType": "string",
    "SV_Inventory_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1747
schema_scan_id: 162000643
updated: 2026-04-14 03:10:36

Version 1712906

created: 2026-04-13 03:03:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeset`\n(\n `Id`  string , `Name`  string , `Price`  string , `PriceType`  string , `ApplyTo`  string , `Discount`  string , `SV_WorkOrder_Id`  string , `ItemMaster_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_ChargeSet/2026-04-13/1776067132'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeSet/2026-04-13/1776067132
id: 1712906
processed: 1

raw_data:

{
    "ApplyTo": 4,
    "Discount": 5,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 1,
    "Price": 2,
    "PriceType": 3,
    "SV_Inventory_Id": 8,
    "SV_WorkOrder_Id": 6
}

schema_attributes:

{
    "ApplyTo": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "PriceType": "string",
    "SV_Inventory_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1747
schema_scan_id: 161942600
updated: 2026-04-13 03:04:08

Version 1711706

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeset`\n(\n `Id`  string , `Name`  string , `Price`  string , `PriceType`  string , `ApplyTo`  string , `Discount`  string , `SV_WorkOrder_Id`  string , `ItemMaster_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_ChargeSet/2026-04-12/1775980827'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeSet/2026-04-12/1775980827
id: 1711706
processed: 1

raw_data:

{
    "ApplyTo": 4,
    "Discount": 5,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 1,
    "Price": 2,
    "PriceType": 3,
    "SV_Inventory_Id": 8,
    "SV_WorkOrder_Id": 6
}

schema_attributes:

{
    "ApplyTo": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "PriceType": "string",
    "SV_Inventory_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1747
schema_scan_id: 161893363
updated: 2026-04-12 03:06:07

Version 1710502

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeset`\n(\n `Id`  string , `Name`  string , `Price`  string , `PriceType`  string , `ApplyTo`  string , `Discount`  string , `SV_WorkOrder_Id`  string , `ItemMaster_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_ChargeSet/2026-04-11/1775894597'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeSet/2026-04-11/1775894597
id: 1710502
processed: 1

raw_data:

{
    "ApplyTo": 4,
    "Discount": 5,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 1,
    "Price": 2,
    "PriceType": 3,
    "SV_Inventory_Id": 8,
    "SV_WorkOrder_Id": 6
}

schema_attributes:

{
    "ApplyTo": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "PriceType": "string",
    "SV_Inventory_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1747
schema_scan_id: 161841291
updated: 2026-04-11 03:08:41

Version 1709296

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeset`\n(\n `Id`  string , `Name`  string , `Price`  string , `PriceType`  string , `ApplyTo`  string , `Discount`  string , `SV_WorkOrder_Id`  string , `ItemMaster_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_ChargeSet/2026-04-10/1775808360'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeSet/2026-04-10/1775808360
id: 1709296
processed: 1

raw_data:

{
    "ApplyTo": 4,
    "Discount": 5,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 1,
    "Price": 2,
    "PriceType": 3,
    "SV_Inventory_Id": 8,
    "SV_WorkOrder_Id": 6
}

schema_attributes:

{
    "ApplyTo": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "PriceType": "string",
    "SV_Inventory_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1747
schema_scan_id: 161785991
updated: 2026-04-10 03:08:15

Version 1708130

created: 2026-04-09 03:03:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeset`\n(\n `Id`  string , `Name`  string , `Price`  string , `PriceType`  string , `ApplyTo`  string , `Discount`  string , `SV_WorkOrder_Id`  string , `ItemMaster_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_ChargeSet/2026-04-09/1775721685'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeSet/2026-04-09/1775721685
id: 1708130
processed: 1

raw_data:

{
    "ApplyTo": 4,
    "Discount": 5,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 1,
    "Price": 2,
    "PriceType": 3,
    "SV_Inventory_Id": 8,
    "SV_WorkOrder_Id": 6
}

schema_attributes:

{
    "ApplyTo": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "PriceType": "string",
    "SV_Inventory_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1747
schema_scan_id: 161730273
updated: 2026-04-09 03:03:42

Version 1707008

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeset`\n(\n `Id`  string , `Name`  string , `Price`  string , `PriceType`  string , `ApplyTo`  string , `Discount`  string , `SV_WorkOrder_Id`  string , `ItemMaster_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_ChargeSet/2026-04-08/1775635521'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeSet/2026-04-08/1775635521
id: 1707008
processed: 1

raw_data:

{
    "ApplyTo": 4,
    "Discount": 5,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 1,
    "Price": 2,
    "PriceType": 3,
    "SV_Inventory_Id": 8,
    "SV_WorkOrder_Id": 6
}

schema_attributes:

{
    "ApplyTo": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "PriceType": "string",
    "SV_Inventory_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1747
schema_scan_id: 161675671
updated: 2026-04-08 03:09:57

Version 1705847

created: 2026-04-07 03:03:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeset`\n(\n `Id`  string , `Name`  string , `Price`  string , `PriceType`  string , `ApplyTo`  string , `Discount`  string , `SV_WorkOrder_Id`  string , `ItemMaster_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_ChargeSet/2026-04-07/1775548684'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeSet/2026-04-07/1775548684
id: 1705847
processed: 1

raw_data:

{
    "ApplyTo": 4,
    "Discount": 5,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 1,
    "Price": 2,
    "PriceType": 3,
    "SV_Inventory_Id": 8,
    "SV_WorkOrder_Id": 6
}

schema_attributes:

{
    "ApplyTo": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "PriceType": "string",
    "SV_Inventory_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1747
schema_scan_id: 161619333
updated: 2026-04-07 03:03:29

Version 1704635

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeset`\n(\n `Id`  string , `Name`  string , `Price`  string , `PriceType`  string , `ApplyTo`  string , `Discount`  string , `SV_WorkOrder_Id`  string , `ItemMaster_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_ChargeSet/2026-04-06/1775462634'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeSet/2026-04-06/1775462634
id: 1704635
processed: 1

raw_data:

{
    "ApplyTo": 4,
    "Discount": 5,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 1,
    "Price": 2,
    "PriceType": 3,
    "SV_Inventory_Id": 8,
    "SV_WorkOrder_Id": 6
}

schema_attributes:

{
    "ApplyTo": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "PriceType": "string",
    "SV_Inventory_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1747
schema_scan_id: 161561784
updated: 2026-04-06 03:11:41

Version 1703359

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeset`\n(\n `Id`  string , `Name`  string , `Price`  string , `PriceType`  string , `ApplyTo`  string , `Discount`  string , `SV_WorkOrder_Id`  string , `ItemMaster_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_ChargeSet/2026-04-05/1775376263'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeSet/2026-04-05/1775376263
id: 1703359
processed: 1

raw_data:

{
    "ApplyTo": 4,
    "Discount": 5,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 1,
    "Price": 2,
    "PriceType": 3,
    "SV_Inventory_Id": 8,
    "SV_WorkOrder_Id": 6
}

schema_attributes:

{
    "ApplyTo": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "PriceType": "string",
    "SV_Inventory_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1747
schema_scan_id: 161514941
updated: 2026-04-05 03:07:46

Version 1702261

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeset`\n(\n `Id`  string , `Name`  string , `Price`  string , `PriceType`  string , `ApplyTo`  string , `Discount`  string , `SV_WorkOrder_Id`  string , `ItemMaster_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_ChargeSet/2026-04-04/1775289747'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeSet/2026-04-04/1775289747
id: 1702261
processed: 1

raw_data:

{
    "ApplyTo": 4,
    "Discount": 5,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 1,
    "Price": 2,
    "PriceType": 3,
    "SV_Inventory_Id": 8,
    "SV_WorkOrder_Id": 6
}

schema_attributes:

{
    "ApplyTo": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "PriceType": "string",
    "SV_Inventory_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1747
schema_scan_id: 161460565
updated: 2026-04-04 03:10:23

Version 1701042

created: 2026-04-03 03:14:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeset`\n(\n `Id`  string , `Name`  string , `Price`  string , `PriceType`  string , `ApplyTo`  string , `Discount`  string , `SV_WorkOrder_Id`  string , `ItemMaster_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_ChargeSet/2026-04-03/1775203514'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeSet/2026-04-03/1775203514
id: 1701042
processed: 1

raw_data:

{
    "ApplyTo": 4,
    "Discount": 5,
    "Id": 0,
    "ItemMaster_Id": 7,
    "Name": 1,
    "Price": 2,
    "PriceType": 3,
    "SV_Inventory_Id": 8,
    "SV_WorkOrder_Id": 6
}

schema_attributes:

{
    "ApplyTo": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "PriceType": "string",
    "SV_Inventory_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1747
schema_scan_id: 161402022
updated: 2026-04-03 03:14:33

Schema Scans: 15

Last at 2026-04-17 03:06:52

Scan 162167668

duration: 0:00:14.346165

exit_message:

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

id: 162167668

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_ChargeSet/2026-04-17/1776412994",
        "key": "raw/molo_moloSV_ChargeSet/2026-04-17/1776412994/SV_ChargeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 665313479869113363,
        "service_name": "drive-thru",
        "span_id": 6190770799267431330,
        "trace_id": 9817621375502575701
    }
}

running: False
schema_name_id: 1747
start_time: 2026-04-17 03:06:52
success: True
trace_id: 9817621375502575701

Scan 162112011

duration: 0:00:11.839495

exit_message:

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

id: 162112011

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_ChargeSet/2026-04-16/1776326695",
        "key": "raw/molo_moloSV_ChargeSet/2026-04-16/1776326695/SV_ChargeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13043827707043967795,
        "service_name": "drive-thru",
        "span_id": 5162142580489883516,
        "trace_id": 3373666523012427085
    }
}

running: False
schema_name_id: 1747
start_time: 2026-04-16 03:13:37
success: True
trace_id: 3373666523012427085

Scan 162056169

duration: 0:00:14.376931

exit_message:

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

id: 162056169

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_ChargeSet/2026-04-15/1776240182",
        "key": "raw/molo_moloSV_ChargeSet/2026-04-15/1776240182/SV_ChargeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14536334103011732417,
        "service_name": "drive-thru",
        "span_id": 7578563724721398147,
        "trace_id": 18275154545101476353
    }
}

running: False
schema_name_id: 1747
start_time: 2026-04-15 03:12:34
success: True
trace_id: 18275154545101476353

Scan 162000643

duration: 0:00:14.340414

exit_message:

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

id: 162000643

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_ChargeSet/2026-04-14/1776154136",
        "key": "raw/molo_moloSV_ChargeSet/2026-04-14/1776154136/SV_ChargeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11043192373109175651,
        "service_name": "drive-thru",
        "span_id": 3736101852499412683,
        "trace_id": 6996544442712786321
    }
}

running: False
schema_name_id: 1747
start_time: 2026-04-14 03:10:22
success: True
trace_id: 6996544442712786321

Scan 161942600

duration: 0:00:14.260484

exit_message:

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

id: 161942600

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_ChargeSet/2026-04-13/1776067132",
        "key": "raw/molo_moloSV_ChargeSet/2026-04-13/1776067132/SV_ChargeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13812272519556836025,
        "service_name": "drive-thru",
        "span_id": 12881429875977077858,
        "trace_id": 13691256425255550491
    }
}

running: False
schema_name_id: 1747
start_time: 2026-04-13 03:03:53
success: True
trace_id: 13691256425255550491

Scan 161893363

duration: 0:00:14.425310

exit_message:

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

id: 161893363

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_ChargeSet/2026-04-12/1775980827",
        "key": "raw/molo_moloSV_ChargeSet/2026-04-12/1775980827/SV_ChargeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6303624439897810152,
        "service_name": "drive-thru",
        "span_id": 17456087527018082822,
        "trace_id": 491258036563575029
    }
}

running: False
schema_name_id: 1747
start_time: 2026-04-12 03:05:52
success: True
trace_id: 491258036563575029

Scan 161841291

duration: 0:00:14.358680

exit_message:

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

id: 161841291

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_ChargeSet/2026-04-11/1775894597",
        "key": "raw/molo_moloSV_ChargeSet/2026-04-11/1775894597/SV_ChargeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12932316106696555956,
        "service_name": "drive-thru",
        "span_id": 17689944577757177874,
        "trace_id": 4008438511718461856
    }
}

running: False
schema_name_id: 1747
start_time: 2026-04-11 03:08:26
success: True
trace_id: 4008438511718461856

Scan 161785991

duration: 0:00:14.615095

exit_message:

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

id: 161785991

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_ChargeSet/2026-04-10/1775808360",
        "key": "raw/molo_moloSV_ChargeSet/2026-04-10/1775808360/SV_ChargeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17424131062433411057,
        "service_name": "drive-thru",
        "span_id": 1643083403138636742,
        "trace_id": 9250938972653611224
    }
}

running: False
schema_name_id: 1747
start_time: 2026-04-10 03:08:00
success: True
trace_id: 9250938972653611224

Scan 161730273

duration: 0:00:11.860496

exit_message:

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

id: 161730273

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_ChargeSet/2026-04-09/1775721685",
        "key": "raw/molo_moloSV_ChargeSet/2026-04-09/1775721685/SV_ChargeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15096512981092863661,
        "service_name": "drive-thru",
        "span_id": 9290503536620242828,
        "trace_id": 10749649146551060418
    }
}

running: False
schema_name_id: 1747
start_time: 2026-04-09 03:03:30
success: True
trace_id: 10749649146551060418

Scan 161675671

duration: 0:00:11.790483

exit_message:

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

id: 161675671

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_ChargeSet/2026-04-08/1775635521",
        "key": "raw/molo_moloSV_ChargeSet/2026-04-08/1775635521/SV_ChargeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4421305158630412997,
        "service_name": "drive-thru",
        "span_id": 9399076294167582713,
        "trace_id": 15619366588245288317
    }
}

running: False
schema_name_id: 1747
start_time: 2026-04-08 03:09:45
success: True
trace_id: 15619366588245288317

Scan 161619333

duration: 0:00:14.452666

exit_message:

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

id: 161619333

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_ChargeSet/2026-04-07/1775548684",
        "key": "raw/molo_moloSV_ChargeSet/2026-04-07/1775548684/SV_ChargeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11116727682367843235,
        "service_name": "drive-thru",
        "span_id": 3218941254649828044,
        "trace_id": 6753593651097694165
    }
}

running: False
schema_name_id: 1747
start_time: 2026-04-07 03:03:15
success: True
trace_id: 6753593651097694165

Scan 161561784

duration: 0:00:11.876096

exit_message:

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

id: 161561784

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_ChargeSet/2026-04-06/1775462634",
        "key": "raw/molo_moloSV_ChargeSet/2026-04-06/1775462634/SV_ChargeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14507187060094340845,
        "service_name": "drive-thru",
        "span_id": 6331247116846342827,
        "trace_id": 668856248859983913
    }
}

running: False
schema_name_id: 1747
start_time: 2026-04-06 03:11:30
success: True
trace_id: 668856248859983913

Scan 161514941

duration: 0:00:14.292372

exit_message:

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

id: 161514941

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_ChargeSet/2026-04-05/1775376263",
        "key": "raw/molo_moloSV_ChargeSet/2026-04-05/1775376263/SV_ChargeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7352921705928069680,
        "service_name": "drive-thru",
        "span_id": 3693084161123915585,
        "trace_id": 7376222646877200149
    }
}

running: False
schema_name_id: 1747
start_time: 2026-04-05 03:07:31
success: True
trace_id: 7376222646877200149

Scan 161460565

duration: 0:00:14.426945

exit_message:

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

id: 161460565

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_ChargeSet/2026-04-04/1775289747",
        "key": "raw/molo_moloSV_ChargeSet/2026-04-04/1775289747/SV_ChargeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1339628053862565258,
        "service_name": "drive-thru",
        "span_id": 15579030073514768914,
        "trace_id": 16656002774380578025
    }
}

running: False
schema_name_id: 1747
start_time: 2026-04-04 03:10:09
success: True
trace_id: 16656002774380578025

Scan 161402022

duration: 0:00:14.419612

exit_message:

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

id: 161402022

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_ChargeSet/2026-04-03/1775203514",
        "key": "raw/molo_moloSV_ChargeSet/2026-04-03/1775203514/SV_ChargeSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17241537056429628206,
        "service_name": "drive-thru",
        "span_id": 3673027962577067195,
        "trace_id": 2234575352775469978
    }
}

running: False
schema_name_id: 1747
start_time: 2026-04-03 03:14:19
success: True
trace_id: 2234575352775469978

Partitions:

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

Schema:

attributes:

{
    "ApplyTo": "string",
    "Discount": "string",
    "Id": "string",
    "ItemMaster_Id": "string",
    "Name": "string",
    "Price": "string",
    "PriceType": "string",
    "SV_Inventory_Id": "string",
    "SV_WorkOrder_Id": "string"
}

created: 2026-04-17 03:06:52

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_chargeset`\n(\n `Id`  string , `Name`  string , `Price`  string , `PriceType`  string , `ApplyTo`  string , `Discount`  string , `SV_WorkOrder_Id`  string , `ItemMaster_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_ChargeSet/2026-04-17/1776412994'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeset"
}

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:32",
        "disabled": false,
        "format": "raw",
        "id": 1747,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molosv_chargeset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "ApplyTo": "string",
            "Discount": "string",
            "Id": "string",
            "ItemMaster_Id": "string",
            "Name": "string",
            "Price": "string",
            "PriceType": "string",
            "SV_Inventory_Id": "string",
            "SV_WorkOrder_Id": "string"
        },
        "created": "2026-04-17 03:06:52",
        "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_chargeset`\n(\n `Id`  string , `Name`  string , `Price`  string , `PriceType`  string , `ApplyTo`  string , `Discount`  string , `SV_WorkOrder_Id`  string , `ItemMaster_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_ChargeSet/2026-04-17/1776412994'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}