Schema Info

Schema Name: sfdl_prod_drivethru.molo_molosv_chargeinstanceset

created: 2023-10-17 02:02:18
disabled: False
format: raw
id: 1793
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717750

created: 2026-04-17 03:09:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeinstanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeinstanceset`\n(\n `Id`  string , `CommentsInternal`  string , `CommentsCustomer`  string , `CommentsUpdatedAt`  string , `Discount`  string , `CommentsCreatedAt`  string , `PriceOverride`  string , `Quantity`  string , `DiscountType`  string , `DiscountAmount`  string , `PurchasePriceWhenAdded`  string , `SalesPriceWhenAdded`  string , `SV_Job_Id`  string , `SV_Charge_Id`  string , `Total`  string , `Profit`  string , `ProfitPercentage`  string , `TotalCost`  string , `CreationDateTime`  string , `CreationUser_Id`  string , `OverrideDays`  string , `ChargeMethod`  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_ChargeInstanceSet/2026-04-17/1776412994'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeinstanceset"
]

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

raw_data:

{
    "ChargeMethod": 21,
    "CommentsCreatedAt": 5,
    "CommentsCustomer": 2,
    "CommentsInternal": 1,
    "CommentsUpdatedAt": 3,
    "CreationDateTime": 18,
    "CreationUser_Id": 19,
    "Discount": 4,
    "DiscountAmount": 9,
    "DiscountType": 8,
    "Id": 0,
    "OverrideDays": 20,
    "PriceOverride": 6,
    "Profit": 15,
    "ProfitPercentage": 16,
    "PurchasePriceWhenAdded": 10,
    "Quantity": 7,
    "SV_Charge_Id": 13,
    "SV_Job_Id": 12,
    "SalesPriceWhenAdded": 11,
    "Total": 14,
    "TotalCost": 17
}

schema_attributes:

{
    "ChargeMethod": "string",
    "CommentsCreatedAt": "string",
    "CommentsCustomer": "string",
    "CommentsInternal": "string",
    "CommentsUpdatedAt": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Discount": "string",
    "DiscountAmount": "string",
    "DiscountType": "string",
    "Id": "string",
    "OverrideDays": "string",
    "PriceOverride": "string",
    "Profit": "string",
    "ProfitPercentage": "string",
    "PurchasePriceWhenAdded": "string",
    "Quantity": "string",
    "SV_Charge_Id": "string",
    "SV_Job_Id": "string",
    "SalesPriceWhenAdded": "string",
    "Total": "string",
    "TotalCost": "string"
}

schema_name_id: 1793
schema_scan_id: 162167760
updated: 2026-04-17 03:09:42

Version 1716553

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_chargeinstanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeinstanceset`\n(\n `Id`  string , `CommentsInternal`  string , `CommentsCustomer`  string , `CommentsUpdatedAt`  string , `Discount`  string , `CommentsCreatedAt`  string , `PriceOverride`  string , `Quantity`  string , `DiscountType`  string , `DiscountAmount`  string , `PurchasePriceWhenAdded`  string , `SalesPriceWhenAdded`  string , `SV_Job_Id`  string , `SV_Charge_Id`  string , `Total`  string , `Profit`  string , `ProfitPercentage`  string , `TotalCost`  string , `CreationDateTime`  string , `CreationUser_Id`  string , `OverrideDays`  string , `ChargeMethod`  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_ChargeInstanceSet/2026-04-16/1776326694'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeinstanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeInstanceSet/2026-04-16/1776326694
id: 1716553
processed: 1

raw_data:

{
    "ChargeMethod": 21,
    "CommentsCreatedAt": 5,
    "CommentsCustomer": 2,
    "CommentsInternal": 1,
    "CommentsUpdatedAt": 3,
    "CreationDateTime": 18,
    "CreationUser_Id": 19,
    "Discount": 4,
    "DiscountAmount": 9,
    "DiscountType": 8,
    "Id": 0,
    "OverrideDays": 20,
    "PriceOverride": 6,
    "Profit": 15,
    "ProfitPercentage": 16,
    "PurchasePriceWhenAdded": 10,
    "Quantity": 7,
    "SV_Charge_Id": 13,
    "SV_Job_Id": 12,
    "SalesPriceWhenAdded": 11,
    "Total": 14,
    "TotalCost": 17
}

schema_attributes:

{
    "ChargeMethod": "string",
    "CommentsCreatedAt": "string",
    "CommentsCustomer": "string",
    "CommentsInternal": "string",
    "CommentsUpdatedAt": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Discount": "string",
    "DiscountAmount": "string",
    "DiscountType": "string",
    "Id": "string",
    "OverrideDays": "string",
    "PriceOverride": "string",
    "Profit": "string",
    "ProfitPercentage": "string",
    "PurchasePriceWhenAdded": "string",
    "Quantity": "string",
    "SV_Charge_Id": "string",
    "SV_Job_Id": "string",
    "SalesPriceWhenAdded": "string",
    "Total": "string",
    "TotalCost": "string"
}

schema_name_id: 1793
schema_scan_id: 162112010
updated: 2026-04-16 03:13:51

Version 1715282

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeinstanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeinstanceset`\n(\n `Id`  string , `CommentsInternal`  string , `CommentsCustomer`  string , `CommentsUpdatedAt`  string , `Discount`  string , `CommentsCreatedAt`  string , `PriceOverride`  string , `Quantity`  string , `DiscountType`  string , `DiscountAmount`  string , `PurchasePriceWhenAdded`  string , `SalesPriceWhenAdded`  string , `SV_Job_Id`  string , `SV_Charge_Id`  string , `Total`  string , `Profit`  string , `ProfitPercentage`  string , `TotalCost`  string , `CreationDateTime`  string , `CreationUser_Id`  string , `OverrideDays`  string , `ChargeMethod`  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_ChargeInstanceSet/2026-04-15/1776240184'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeinstanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeInstanceSet/2026-04-15/1776240184
id: 1715282
processed: 1

raw_data:

{
    "ChargeMethod": 21,
    "CommentsCreatedAt": 5,
    "CommentsCustomer": 2,
    "CommentsInternal": 1,
    "CommentsUpdatedAt": 3,
    "CreationDateTime": 18,
    "CreationUser_Id": 19,
    "Discount": 4,
    "DiscountAmount": 9,
    "DiscountType": 8,
    "Id": 0,
    "OverrideDays": 20,
    "PriceOverride": 6,
    "Profit": 15,
    "ProfitPercentage": 16,
    "PurchasePriceWhenAdded": 10,
    "Quantity": 7,
    "SV_Charge_Id": 13,
    "SV_Job_Id": 12,
    "SalesPriceWhenAdded": 11,
    "Total": 14,
    "TotalCost": 17
}

schema_attributes:

{
    "ChargeMethod": "string",
    "CommentsCreatedAt": "string",
    "CommentsCustomer": "string",
    "CommentsInternal": "string",
    "CommentsUpdatedAt": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Discount": "string",
    "DiscountAmount": "string",
    "DiscountType": "string",
    "Id": "string",
    "OverrideDays": "string",
    "PriceOverride": "string",
    "Profit": "string",
    "ProfitPercentage": "string",
    "PurchasePriceWhenAdded": "string",
    "Quantity": "string",
    "SV_Charge_Id": "string",
    "SV_Job_Id": "string",
    "SalesPriceWhenAdded": "string",
    "Total": "string",
    "TotalCost": "string"
}

schema_name_id: 1793
schema_scan_id: 162056036
updated: 2026-04-15 03:08:21

Version 1714105

created: 2026-04-14 03:09:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeinstanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeinstanceset`\n(\n `Id`  string , `CommentsInternal`  string , `CommentsCustomer`  string , `CommentsUpdatedAt`  string , `Discount`  string , `CommentsCreatedAt`  string , `PriceOverride`  string , `Quantity`  string , `DiscountType`  string , `DiscountAmount`  string , `PurchasePriceWhenAdded`  string , `SalesPriceWhenAdded`  string , `SV_Job_Id`  string , `SV_Charge_Id`  string , `Total`  string , `Profit`  string , `ProfitPercentage`  string , `TotalCost`  string , `CreationDateTime`  string , `CreationUser_Id`  string , `OverrideDays`  string , `ChargeMethod`  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_ChargeInstanceSet/2026-04-14/1776154136'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeinstanceset"
]

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

raw_data:

{
    "ChargeMethod": 21,
    "CommentsCreatedAt": 5,
    "CommentsCustomer": 2,
    "CommentsInternal": 1,
    "CommentsUpdatedAt": 3,
    "CreationDateTime": 18,
    "CreationUser_Id": 19,
    "Discount": 4,
    "DiscountAmount": 9,
    "DiscountType": 8,
    "Id": 0,
    "OverrideDays": 20,
    "PriceOverride": 6,
    "Profit": 15,
    "ProfitPercentage": 16,
    "PurchasePriceWhenAdded": 10,
    "Quantity": 7,
    "SV_Charge_Id": 13,
    "SV_Job_Id": 12,
    "SalesPriceWhenAdded": 11,
    "Total": 14,
    "TotalCost": 17
}

schema_attributes:

{
    "ChargeMethod": "string",
    "CommentsCreatedAt": "string",
    "CommentsCustomer": "string",
    "CommentsInternal": "string",
    "CommentsUpdatedAt": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Discount": "string",
    "DiscountAmount": "string",
    "DiscountType": "string",
    "Id": "string",
    "OverrideDays": "string",
    "PriceOverride": "string",
    "Profit": "string",
    "ProfitPercentage": "string",
    "PurchasePriceWhenAdded": "string",
    "Quantity": "string",
    "SV_Charge_Id": "string",
    "SV_Job_Id": "string",
    "SalesPriceWhenAdded": "string",
    "Total": "string",
    "TotalCost": "string"
}

schema_name_id: 1793
schema_scan_id: 162000618
updated: 2026-04-14 03:09:45

Version 1712874

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeinstanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeinstanceset`\n(\n `Id`  string , `CommentsInternal`  string , `CommentsCustomer`  string , `CommentsUpdatedAt`  string , `Discount`  string , `CommentsCreatedAt`  string , `PriceOverride`  string , `Quantity`  string , `DiscountType`  string , `DiscountAmount`  string , `PurchasePriceWhenAdded`  string , `SalesPriceWhenAdded`  string , `SV_Job_Id`  string , `SV_Charge_Id`  string , `Total`  string , `Profit`  string , `ProfitPercentage`  string , `TotalCost`  string , `CreationDateTime`  string , `CreationUser_Id`  string , `OverrideDays`  string , `ChargeMethod`  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_ChargeInstanceSet/2026-04-13/1776067131'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeinstanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeInstanceSet/2026-04-13/1776067131
id: 1712874
processed: 1

raw_data:

{
    "ChargeMethod": 21,
    "CommentsCreatedAt": 5,
    "CommentsCustomer": 2,
    "CommentsInternal": 1,
    "CommentsUpdatedAt": 3,
    "CreationDateTime": 18,
    "CreationUser_Id": 19,
    "Discount": 4,
    "DiscountAmount": 9,
    "DiscountType": 8,
    "Id": 0,
    "OverrideDays": 20,
    "PriceOverride": 6,
    "Profit": 15,
    "ProfitPercentage": 16,
    "PurchasePriceWhenAdded": 10,
    "Quantity": 7,
    "SV_Charge_Id": 13,
    "SV_Job_Id": 12,
    "SalesPriceWhenAdded": 11,
    "Total": 14,
    "TotalCost": 17
}

schema_attributes:

{
    "ChargeMethod": "string",
    "CommentsCreatedAt": "string",
    "CommentsCustomer": "string",
    "CommentsInternal": "string",
    "CommentsUpdatedAt": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Discount": "string",
    "DiscountAmount": "string",
    "DiscountType": "string",
    "Id": "string",
    "OverrideDays": "string",
    "PriceOverride": "string",
    "Profit": "string",
    "ProfitPercentage": "string",
    "PurchasePriceWhenAdded": "string",
    "Quantity": "string",
    "SV_Charge_Id": "string",
    "SV_Job_Id": "string",
    "SalesPriceWhenAdded": "string",
    "Total": "string",
    "TotalCost": "string"
}

schema_name_id: 1793
schema_scan_id: 161942370
updated: 2026-04-13 03:02:37

Version 1711757

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeinstanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeinstanceset`\n(\n `Id`  string , `CommentsInternal`  string , `CommentsCustomer`  string , `CommentsUpdatedAt`  string , `Discount`  string , `CommentsCreatedAt`  string , `PriceOverride`  string , `Quantity`  string , `DiscountType`  string , `DiscountAmount`  string , `PurchasePriceWhenAdded`  string , `SalesPriceWhenAdded`  string , `SV_Job_Id`  string , `SV_Charge_Id`  string , `Total`  string , `Profit`  string , `ProfitPercentage`  string , `TotalCost`  string , `CreationDateTime`  string , `CreationUser_Id`  string , `OverrideDays`  string , `ChargeMethod`  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_ChargeInstanceSet/2026-04-12/1775980826'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeinstanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeInstanceSet/2026-04-12/1775980826
id: 1711757
processed: 1

raw_data:

{
    "ChargeMethod": 21,
    "CommentsCreatedAt": 5,
    "CommentsCustomer": 2,
    "CommentsInternal": 1,
    "CommentsUpdatedAt": 3,
    "CreationDateTime": 18,
    "CreationUser_Id": 19,
    "Discount": 4,
    "DiscountAmount": 9,
    "DiscountType": 8,
    "Id": 0,
    "OverrideDays": 20,
    "PriceOverride": 6,
    "Profit": 15,
    "ProfitPercentage": 16,
    "PurchasePriceWhenAdded": 10,
    "Quantity": 7,
    "SV_Charge_Id": 13,
    "SV_Job_Id": 12,
    "SalesPriceWhenAdded": 11,
    "Total": 14,
    "TotalCost": 17
}

schema_attributes:

{
    "ChargeMethod": "string",
    "CommentsCreatedAt": "string",
    "CommentsCustomer": "string",
    "CommentsInternal": "string",
    "CommentsUpdatedAt": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Discount": "string",
    "DiscountAmount": "string",
    "DiscountType": "string",
    "Id": "string",
    "OverrideDays": "string",
    "PriceOverride": "string",
    "Profit": "string",
    "ProfitPercentage": "string",
    "PurchasePriceWhenAdded": "string",
    "Quantity": "string",
    "SV_Charge_Id": "string",
    "SV_Job_Id": "string",
    "SalesPriceWhenAdded": "string",
    "Total": "string",
    "TotalCost": "string"
}

schema_name_id: 1793
schema_scan_id: 161893458
updated: 2026-04-12 03:08:22

Version 1710546

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeinstanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeinstanceset`\n(\n `Id`  string , `CommentsInternal`  string , `CommentsCustomer`  string , `CommentsUpdatedAt`  string , `Discount`  string , `CommentsCreatedAt`  string , `PriceOverride`  string , `Quantity`  string , `DiscountType`  string , `DiscountAmount`  string , `PurchasePriceWhenAdded`  string , `SalesPriceWhenAdded`  string , `SV_Job_Id`  string , `SV_Charge_Id`  string , `Total`  string , `Profit`  string , `ProfitPercentage`  string , `TotalCost`  string , `CreationDateTime`  string , `CreationUser_Id`  string , `OverrideDays`  string , `ChargeMethod`  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_ChargeInstanceSet/2026-04-11/1775894597'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeinstanceset"
]

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

raw_data:

{
    "ChargeMethod": 21,
    "CommentsCreatedAt": 5,
    "CommentsCustomer": 2,
    "CommentsInternal": 1,
    "CommentsUpdatedAt": 3,
    "CreationDateTime": 18,
    "CreationUser_Id": 19,
    "Discount": 4,
    "DiscountAmount": 9,
    "DiscountType": 8,
    "Id": 0,
    "OverrideDays": 20,
    "PriceOverride": 6,
    "Profit": 15,
    "ProfitPercentage": 16,
    "PurchasePriceWhenAdded": 10,
    "Quantity": 7,
    "SV_Charge_Id": 13,
    "SV_Job_Id": 12,
    "SalesPriceWhenAdded": 11,
    "Total": 14,
    "TotalCost": 17
}

schema_attributes:

{
    "ChargeMethod": "string",
    "CommentsCreatedAt": "string",
    "CommentsCustomer": "string",
    "CommentsInternal": "string",
    "CommentsUpdatedAt": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Discount": "string",
    "DiscountAmount": "string",
    "DiscountType": "string",
    "Id": "string",
    "OverrideDays": "string",
    "PriceOverride": "string",
    "Profit": "string",
    "ProfitPercentage": "string",
    "PurchasePriceWhenAdded": "string",
    "Quantity": "string",
    "SV_Charge_Id": "string",
    "SV_Job_Id": "string",
    "SalesPriceWhenAdded": "string",
    "Total": "string",
    "TotalCost": "string"
}

schema_name_id: 1793
schema_scan_id: 161841346
updated: 2026-04-11 03:10:26

Version 1709387

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeinstanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeinstanceset`\n(\n `Id`  string , `CommentsInternal`  string , `CommentsCustomer`  string , `CommentsUpdatedAt`  string , `Discount`  string , `CommentsCreatedAt`  string , `PriceOverride`  string , `Quantity`  string , `DiscountType`  string , `DiscountAmount`  string , `PurchasePriceWhenAdded`  string , `SalesPriceWhenAdded`  string , `SV_Job_Id`  string , `SV_Charge_Id`  string , `Total`  string , `Profit`  string , `ProfitPercentage`  string , `TotalCost`  string , `CreationDateTime`  string , `CreationUser_Id`  string , `OverrideDays`  string , `ChargeMethod`  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_ChargeInstanceSet/2026-04-10/1775808359'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeinstanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeInstanceSet/2026-04-10/1775808359
id: 1709387
processed: 1

raw_data:

{
    "ChargeMethod": 21,
    "CommentsCreatedAt": 5,
    "CommentsCustomer": 2,
    "CommentsInternal": 1,
    "CommentsUpdatedAt": 3,
    "CreationDateTime": 18,
    "CreationUser_Id": 19,
    "Discount": 4,
    "DiscountAmount": 9,
    "DiscountType": 8,
    "Id": 0,
    "OverrideDays": 20,
    "PriceOverride": 6,
    "Profit": 15,
    "ProfitPercentage": 16,
    "PurchasePriceWhenAdded": 10,
    "Quantity": 7,
    "SV_Charge_Id": 13,
    "SV_Job_Id": 12,
    "SalesPriceWhenAdded": 11,
    "Total": 14,
    "TotalCost": 17
}

schema_attributes:

{
    "ChargeMethod": "string",
    "CommentsCreatedAt": "string",
    "CommentsCustomer": "string",
    "CommentsInternal": "string",
    "CommentsUpdatedAt": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Discount": "string",
    "DiscountAmount": "string",
    "DiscountType": "string",
    "Id": "string",
    "OverrideDays": "string",
    "PriceOverride": "string",
    "Profit": "string",
    "ProfitPercentage": "string",
    "PurchasePriceWhenAdded": "string",
    "Quantity": "string",
    "SV_Charge_Id": "string",
    "SV_Job_Id": "string",
    "SalesPriceWhenAdded": "string",
    "Total": "string",
    "TotalCost": "string"
}

schema_name_id: 1793
schema_scan_id: 161786090
updated: 2026-04-10 03:11:43

Version 1708231

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeinstanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeinstanceset`\n(\n `Id`  string , `CommentsInternal`  string , `CommentsCustomer`  string , `CommentsUpdatedAt`  string , `Discount`  string , `CommentsCreatedAt`  string , `PriceOverride`  string , `Quantity`  string , `DiscountType`  string , `DiscountAmount`  string , `PurchasePriceWhenAdded`  string , `SalesPriceWhenAdded`  string , `SV_Job_Id`  string , `SV_Charge_Id`  string , `Total`  string , `Profit`  string , `ProfitPercentage`  string , `TotalCost`  string , `CreationDateTime`  string , `CreationUser_Id`  string , `OverrideDays`  string , `ChargeMethod`  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_ChargeInstanceSet/2026-04-09/1775721685'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeinstanceset"
]

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

raw_data:

{
    "ChargeMethod": 21,
    "CommentsCreatedAt": 5,
    "CommentsCustomer": 2,
    "CommentsInternal": 1,
    "CommentsUpdatedAt": 3,
    "CreationDateTime": 18,
    "CreationUser_Id": 19,
    "Discount": 4,
    "DiscountAmount": 9,
    "DiscountType": 8,
    "Id": 0,
    "OverrideDays": 20,
    "PriceOverride": 6,
    "Profit": 15,
    "ProfitPercentage": 16,
    "PurchasePriceWhenAdded": 10,
    "Quantity": 7,
    "SV_Charge_Id": 13,
    "SV_Job_Id": 12,
    "SalesPriceWhenAdded": 11,
    "Total": 14,
    "TotalCost": 17
}

schema_attributes:

{
    "ChargeMethod": "string",
    "CommentsCreatedAt": "string",
    "CommentsCustomer": "string",
    "CommentsInternal": "string",
    "CommentsUpdatedAt": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Discount": "string",
    "DiscountAmount": "string",
    "DiscountType": "string",
    "Id": "string",
    "OverrideDays": "string",
    "PriceOverride": "string",
    "Profit": "string",
    "ProfitPercentage": "string",
    "PurchasePriceWhenAdded": "string",
    "Quantity": "string",
    "SV_Charge_Id": "string",
    "SV_Job_Id": "string",
    "SalesPriceWhenAdded": "string",
    "Total": "string",
    "TotalCost": "string"
}

schema_name_id: 1793
schema_scan_id: 161730495
updated: 2026-04-09 03:08:24

Version 1706921

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeinstanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeinstanceset`\n(\n `Id`  string , `CommentsInternal`  string , `CommentsCustomer`  string , `CommentsUpdatedAt`  string , `Discount`  string , `CommentsCreatedAt`  string , `PriceOverride`  string , `Quantity`  string , `DiscountType`  string , `DiscountAmount`  string , `PurchasePriceWhenAdded`  string , `SalesPriceWhenAdded`  string , `SV_Job_Id`  string , `SV_Charge_Id`  string , `Total`  string , `Profit`  string , `ProfitPercentage`  string , `TotalCost`  string , `CreationDateTime`  string , `CreationUser_Id`  string , `OverrideDays`  string , `ChargeMethod`  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_ChargeInstanceSet/2026-04-08/1775635521'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeinstanceset"
]

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

raw_data:

{
    "ChargeMethod": 21,
    "CommentsCreatedAt": 5,
    "CommentsCustomer": 2,
    "CommentsInternal": 1,
    "CommentsUpdatedAt": 3,
    "CreationDateTime": 18,
    "CreationUser_Id": 19,
    "Discount": 4,
    "DiscountAmount": 9,
    "DiscountType": 8,
    "Id": 0,
    "OverrideDays": 20,
    "PriceOverride": 6,
    "Profit": 15,
    "ProfitPercentage": 16,
    "PurchasePriceWhenAdded": 10,
    "Quantity": 7,
    "SV_Charge_Id": 13,
    "SV_Job_Id": 12,
    "SalesPriceWhenAdded": 11,
    "Total": 14,
    "TotalCost": 17
}

schema_attributes:

{
    "ChargeMethod": "string",
    "CommentsCreatedAt": "string",
    "CommentsCustomer": "string",
    "CommentsInternal": "string",
    "CommentsUpdatedAt": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Discount": "string",
    "DiscountAmount": "string",
    "DiscountType": "string",
    "Id": "string",
    "OverrideDays": "string",
    "PriceOverride": "string",
    "Profit": "string",
    "ProfitPercentage": "string",
    "PurchasePriceWhenAdded": "string",
    "Quantity": "string",
    "SV_Charge_Id": "string",
    "SV_Job_Id": "string",
    "SalesPriceWhenAdded": "string",
    "Total": "string",
    "TotalCost": "string"
}

schema_name_id: 1793
schema_scan_id: 161675555
updated: 2026-04-08 03:06:36

Version 1705810

created: 2026-04-07 03:01:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeinstanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeinstanceset`\n(\n `Id`  string , `CommentsInternal`  string , `CommentsCustomer`  string , `CommentsUpdatedAt`  string , `Discount`  string , `CommentsCreatedAt`  string , `PriceOverride`  string , `Quantity`  string , `DiscountType`  string , `DiscountAmount`  string , `PurchasePriceWhenAdded`  string , `SalesPriceWhenAdded`  string , `SV_Job_Id`  string , `SV_Charge_Id`  string , `Total`  string , `Profit`  string , `ProfitPercentage`  string , `TotalCost`  string , `CreationDateTime`  string , `CreationUser_Id`  string , `OverrideDays`  string , `ChargeMethod`  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_ChargeInstanceSet/2026-04-07/1775548684'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeinstanceset"
]

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

raw_data:

{
    "ChargeMethod": 21,
    "CommentsCreatedAt": 5,
    "CommentsCustomer": 2,
    "CommentsInternal": 1,
    "CommentsUpdatedAt": 3,
    "CreationDateTime": 18,
    "CreationUser_Id": 19,
    "Discount": 4,
    "DiscountAmount": 9,
    "DiscountType": 8,
    "Id": 0,
    "OverrideDays": 20,
    "PriceOverride": 6,
    "Profit": 15,
    "ProfitPercentage": 16,
    "PurchasePriceWhenAdded": 10,
    "Quantity": 7,
    "SV_Charge_Id": 13,
    "SV_Job_Id": 12,
    "SalesPriceWhenAdded": 11,
    "Total": 14,
    "TotalCost": 17
}

schema_attributes:

{
    "ChargeMethod": "string",
    "CommentsCreatedAt": "string",
    "CommentsCustomer": "string",
    "CommentsInternal": "string",
    "CommentsUpdatedAt": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Discount": "string",
    "DiscountAmount": "string",
    "DiscountType": "string",
    "Id": "string",
    "OverrideDays": "string",
    "PriceOverride": "string",
    "Profit": "string",
    "ProfitPercentage": "string",
    "PurchasePriceWhenAdded": "string",
    "Quantity": "string",
    "SV_Charge_Id": "string",
    "SV_Job_Id": "string",
    "SalesPriceWhenAdded": "string",
    "Total": "string",
    "TotalCost": "string"
}

schema_name_id: 1793
schema_scan_id: 161619171
updated: 2026-04-07 03:01:57

Version 1704477

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeinstanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeinstanceset`\n(\n `Id`  string , `CommentsInternal`  string , `CommentsCustomer`  string , `CommentsUpdatedAt`  string , `Discount`  string , `CommentsCreatedAt`  string , `PriceOverride`  string , `Quantity`  string , `DiscountType`  string , `DiscountAmount`  string , `PurchasePriceWhenAdded`  string , `SalesPriceWhenAdded`  string , `SV_Job_Id`  string , `SV_Charge_Id`  string , `Total`  string , `Profit`  string , `ProfitPercentage`  string , `TotalCost`  string , `CreationDateTime`  string , `CreationUser_Id`  string , `OverrideDays`  string , `ChargeMethod`  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_ChargeInstanceSet/2026-04-06/1775462634'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeinstanceset"
]

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

raw_data:

{
    "ChargeMethod": 21,
    "CommentsCreatedAt": 5,
    "CommentsCustomer": 2,
    "CommentsInternal": 1,
    "CommentsUpdatedAt": 3,
    "CreationDateTime": 18,
    "CreationUser_Id": 19,
    "Discount": 4,
    "DiscountAmount": 9,
    "DiscountType": 8,
    "Id": 0,
    "OverrideDays": 20,
    "PriceOverride": 6,
    "Profit": 15,
    "ProfitPercentage": 16,
    "PurchasePriceWhenAdded": 10,
    "Quantity": 7,
    "SV_Charge_Id": 13,
    "SV_Job_Id": 12,
    "SalesPriceWhenAdded": 11,
    "Total": 14,
    "TotalCost": 17
}

schema_attributes:

{
    "ChargeMethod": "string",
    "CommentsCreatedAt": "string",
    "CommentsCustomer": "string",
    "CommentsInternal": "string",
    "CommentsUpdatedAt": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Discount": "string",
    "DiscountAmount": "string",
    "DiscountType": "string",
    "Id": "string",
    "OverrideDays": "string",
    "PriceOverride": "string",
    "Profit": "string",
    "ProfitPercentage": "string",
    "PurchasePriceWhenAdded": "string",
    "Quantity": "string",
    "SV_Charge_Id": "string",
    "SV_Job_Id": "string",
    "SalesPriceWhenAdded": "string",
    "Total": "string",
    "TotalCost": "string"
}

schema_name_id: 1793
schema_scan_id: 161561558
updated: 2026-04-06 03:05:23

Version 1703362

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeinstanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeinstanceset`\n(\n `Id`  string , `CommentsInternal`  string , `CommentsCustomer`  string , `CommentsUpdatedAt`  string , `Discount`  string , `CommentsCreatedAt`  string , `PriceOverride`  string , `Quantity`  string , `DiscountType`  string , `DiscountAmount`  string , `PurchasePriceWhenAdded`  string , `SalesPriceWhenAdded`  string , `SV_Job_Id`  string , `SV_Charge_Id`  string , `Total`  string , `Profit`  string , `ProfitPercentage`  string , `TotalCost`  string , `CreationDateTime`  string , `CreationUser_Id`  string , `OverrideDays`  string , `ChargeMethod`  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_ChargeInstanceSet/2026-04-05/1775376263'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeinstanceset"
]

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

raw_data:

{
    "ChargeMethod": 21,
    "CommentsCreatedAt": 5,
    "CommentsCustomer": 2,
    "CommentsInternal": 1,
    "CommentsUpdatedAt": 3,
    "CreationDateTime": 18,
    "CreationUser_Id": 19,
    "Discount": 4,
    "DiscountAmount": 9,
    "DiscountType": 8,
    "Id": 0,
    "OverrideDays": 20,
    "PriceOverride": 6,
    "Profit": 15,
    "ProfitPercentage": 16,
    "PurchasePriceWhenAdded": 10,
    "Quantity": 7,
    "SV_Charge_Id": 13,
    "SV_Job_Id": 12,
    "SalesPriceWhenAdded": 11,
    "Total": 14,
    "TotalCost": 17
}

schema_attributes:

{
    "ChargeMethod": "string",
    "CommentsCreatedAt": "string",
    "CommentsCustomer": "string",
    "CommentsInternal": "string",
    "CommentsUpdatedAt": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Discount": "string",
    "DiscountAmount": "string",
    "DiscountType": "string",
    "Id": "string",
    "OverrideDays": "string",
    "PriceOverride": "string",
    "Profit": "string",
    "ProfitPercentage": "string",
    "PurchasePriceWhenAdded": "string",
    "Quantity": "string",
    "SV_Charge_Id": "string",
    "SV_Job_Id": "string",
    "SalesPriceWhenAdded": "string",
    "Total": "string",
    "TotalCost": "string"
}

schema_name_id: 1793
schema_scan_id: 161514943
updated: 2026-04-05 03:07:49

Version 1702268

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeinstanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeinstanceset`\n(\n `Id`  string , `CommentsInternal`  string , `CommentsCustomer`  string , `CommentsUpdatedAt`  string , `Discount`  string , `CommentsCreatedAt`  string , `PriceOverride`  string , `Quantity`  string , `DiscountType`  string , `DiscountAmount`  string , `PurchasePriceWhenAdded`  string , `SalesPriceWhenAdded`  string , `SV_Job_Id`  string , `SV_Charge_Id`  string , `Total`  string , `Profit`  string , `ProfitPercentage`  string , `TotalCost`  string , `CreationDateTime`  string , `CreationUser_Id`  string , `OverrideDays`  string , `ChargeMethod`  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_ChargeInstanceSet/2026-04-04/1775289746'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeinstanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeInstanceSet/2026-04-04/1775289746
id: 1702268
processed: 1

raw_data:

{
    "ChargeMethod": 21,
    "CommentsCreatedAt": 5,
    "CommentsCustomer": 2,
    "CommentsInternal": 1,
    "CommentsUpdatedAt": 3,
    "CreationDateTime": 18,
    "CreationUser_Id": 19,
    "Discount": 4,
    "DiscountAmount": 9,
    "DiscountType": 8,
    "Id": 0,
    "OverrideDays": 20,
    "PriceOverride": 6,
    "Profit": 15,
    "ProfitPercentage": 16,
    "PurchasePriceWhenAdded": 10,
    "Quantity": 7,
    "SV_Charge_Id": 13,
    "SV_Job_Id": 12,
    "SalesPriceWhenAdded": 11,
    "Total": 14,
    "TotalCost": 17
}

schema_attributes:

{
    "ChargeMethod": "string",
    "CommentsCreatedAt": "string",
    "CommentsCustomer": "string",
    "CommentsInternal": "string",
    "CommentsUpdatedAt": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Discount": "string",
    "DiscountAmount": "string",
    "DiscountType": "string",
    "Id": "string",
    "OverrideDays": "string",
    "PriceOverride": "string",
    "Profit": "string",
    "ProfitPercentage": "string",
    "PurchasePriceWhenAdded": "string",
    "Quantity": "string",
    "SV_Charge_Id": "string",
    "SV_Job_Id": "string",
    "SalesPriceWhenAdded": "string",
    "Total": "string",
    "TotalCost": "string"
}

schema_name_id: 1793
schema_scan_id: 161460575
updated: 2026-04-04 03:10:41

Version 1700997

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeinstanceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_chargeinstanceset`\n(\n `Id`  string , `CommentsInternal`  string , `CommentsCustomer`  string , `CommentsUpdatedAt`  string , `Discount`  string , `CommentsCreatedAt`  string , `PriceOverride`  string , `Quantity`  string , `DiscountType`  string , `DiscountAmount`  string , `PurchasePriceWhenAdded`  string , `SalesPriceWhenAdded`  string , `SV_Job_Id`  string , `SV_Charge_Id`  string , `Total`  string , `Profit`  string , `ProfitPercentage`  string , `TotalCost`  string , `CreationDateTime`  string , `CreationUser_Id`  string , `OverrideDays`  string , `ChargeMethod`  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_ChargeInstanceSet/2026-04-03/1775203513'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeinstanceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ChargeInstanceSet/2026-04-03/1775203513
id: 1700997
processed: 1

raw_data:

{
    "ChargeMethod": 21,
    "CommentsCreatedAt": 5,
    "CommentsCustomer": 2,
    "CommentsInternal": 1,
    "CommentsUpdatedAt": 3,
    "CreationDateTime": 18,
    "CreationUser_Id": 19,
    "Discount": 4,
    "DiscountAmount": 9,
    "DiscountType": 8,
    "Id": 0,
    "OverrideDays": 20,
    "PriceOverride": 6,
    "Profit": 15,
    "ProfitPercentage": 16,
    "PurchasePriceWhenAdded": 10,
    "Quantity": 7,
    "SV_Charge_Id": 13,
    "SV_Job_Id": 12,
    "SalesPriceWhenAdded": 11,
    "Total": 14,
    "TotalCost": 17
}

schema_attributes:

{
    "ChargeMethod": "string",
    "CommentsCreatedAt": "string",
    "CommentsCustomer": "string",
    "CommentsInternal": "string",
    "CommentsUpdatedAt": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Discount": "string",
    "DiscountAmount": "string",
    "DiscountType": "string",
    "Id": "string",
    "OverrideDays": "string",
    "PriceOverride": "string",
    "Profit": "string",
    "ProfitPercentage": "string",
    "PurchasePriceWhenAdded": "string",
    "Quantity": "string",
    "SV_Charge_Id": "string",
    "SV_Job_Id": "string",
    "SalesPriceWhenAdded": "string",
    "Total": "string",
    "TotalCost": "string"
}

schema_name_id: 1793
schema_scan_id: 161401969
updated: 2026-04-03 03:12:16

Schema Scans: 15

Last at 2026-04-17 03:09:27

Scan 162167760

duration: 0:00:14.890023

exit_message:

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

id: 162167760

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_ChargeInstanceSet/2026-04-17/1776412994",
        "key": "raw/molo_moloSV_ChargeInstanceSet/2026-04-17/1776412994/SV_ChargeInstanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeInstanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7081947520738617166,
        "service_name": "drive-thru",
        "span_id": 11692568359949688875,
        "trace_id": 3362777940499073703
    }
}

running: False
schema_name_id: 1793
start_time: 2026-04-17 03:09:27
success: True
trace_id: 3362777940499073703

Scan 162112010

duration: 0:00:14.776130

exit_message:

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

id: 162112010

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_ChargeInstanceSet/2026-04-16/1776326694",
        "key": "raw/molo_moloSV_ChargeInstanceSet/2026-04-16/1776326694/SV_ChargeInstanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeInstanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5919521552772158947,
        "service_name": "drive-thru",
        "span_id": 17840725311818513087,
        "trace_id": 404139264354768925
    }
}

running: False
schema_name_id: 1793
start_time: 2026-04-16 03:13:37
success: True
trace_id: 404139264354768925

Scan 162056036

duration: 0:00:14.709437

exit_message:

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

id: 162056036

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_ChargeInstanceSet/2026-04-15/1776240184",
        "key": "raw/molo_moloSV_ChargeInstanceSet/2026-04-15/1776240184/SV_ChargeInstanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeInstanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16324143687237248009,
        "service_name": "drive-thru",
        "span_id": 14444016073648540471,
        "trace_id": 18134197069834144935
    }
}

running: False
schema_name_id: 1793
start_time: 2026-04-15 03:08:06
success: True
trace_id: 18134197069834144935

Scan 162000618

duration: 0:00:12.200841

exit_message:

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

id: 162000618

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_ChargeInstanceSet/2026-04-14/1776154136",
        "key": "raw/molo_moloSV_ChargeInstanceSet/2026-04-14/1776154136/SV_ChargeInstanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeInstanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9209858536833746242,
        "service_name": "drive-thru",
        "span_id": 1712743848680123425,
        "trace_id": 9315199773997343432
    }
}

running: False
schema_name_id: 1793
start_time: 2026-04-14 03:09:33
success: True
trace_id: 9315199773997343432

Scan 161942370

duration: 0:00:12.323118

exit_message:

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

id: 161942370

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_ChargeInstanceSet/2026-04-13/1776067131",
        "key": "raw/molo_moloSV_ChargeInstanceSet/2026-04-13/1776067131/SV_ChargeInstanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeInstanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12214024863059696722,
        "service_name": "drive-thru",
        "span_id": 4710118313316946436,
        "trace_id": 11898329071221082107
    }
}

running: False
schema_name_id: 1793
start_time: 2026-04-13 03:02:25
success: True
trace_id: 11898329071221082107

Scan 161893458

duration: 0:00:14.823090

exit_message:

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

id: 161893458

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_ChargeInstanceSet/2026-04-12/1775980826",
        "key": "raw/molo_moloSV_ChargeInstanceSet/2026-04-12/1775980826/SV_ChargeInstanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeInstanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15069639441928842500,
        "service_name": "drive-thru",
        "span_id": 8503686520726417481,
        "trace_id": 15971851670692977255
    }
}

running: False
schema_name_id: 1793
start_time: 2026-04-12 03:08:08
success: True
trace_id: 15971851670692977255

Scan 161841346

duration: 0:00:12.312365

exit_message:

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

id: 161841346

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_ChargeInstanceSet/2026-04-11/1775894597",
        "key": "raw/molo_moloSV_ChargeInstanceSet/2026-04-11/1775894597/SV_ChargeInstanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeInstanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10602104179720292896,
        "service_name": "drive-thru",
        "span_id": 6021800833822050221,
        "trace_id": 15459318652758298397
    }
}

running: False
schema_name_id: 1793
start_time: 2026-04-11 03:10:14
success: True
trace_id: 15459318652758298397

Scan 161786090

duration: 0:00:14.767557

exit_message:

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

id: 161786090

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_ChargeInstanceSet/2026-04-10/1775808359",
        "key": "raw/molo_moloSV_ChargeInstanceSet/2026-04-10/1775808359/SV_ChargeInstanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeInstanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6848924587571979328,
        "service_name": "drive-thru",
        "span_id": 8075676080211928772,
        "trace_id": 568274811490982702
    }
}

running: False
schema_name_id: 1793
start_time: 2026-04-10 03:11:29
success: True
trace_id: 568274811490982702

Scan 161730495

duration: 0:00:12.133392

exit_message:

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

id: 161730495

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_ChargeInstanceSet/2026-04-09/1775721685",
        "key": "raw/molo_moloSV_ChargeInstanceSet/2026-04-09/1775721685/SV_ChargeInstanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeInstanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7145733336909542927,
        "service_name": "drive-thru",
        "span_id": 18378052732028799819,
        "trace_id": 1782343317255148804
    }
}

running: False
schema_name_id: 1793
start_time: 2026-04-09 03:08:12
success: True
trace_id: 1782343317255148804

Scan 161675555

duration: 0:00:12.161064

exit_message:

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

id: 161675555

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_ChargeInstanceSet/2026-04-08/1775635521",
        "key": "raw/molo_moloSV_ChargeInstanceSet/2026-04-08/1775635521/SV_ChargeInstanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeInstanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 46959998400554059,
        "service_name": "drive-thru",
        "span_id": 11488971768574167644,
        "trace_id": 5096023374653219634
    }
}

running: False
schema_name_id: 1793
start_time: 2026-04-08 03:06:24
success: True
trace_id: 5096023374653219634

Scan 161619171

duration: 0:00:12.224997

exit_message:

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

id: 161619171

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_ChargeInstanceSet/2026-04-07/1775548684",
        "key": "raw/molo_moloSV_ChargeInstanceSet/2026-04-07/1775548684/SV_ChargeInstanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeInstanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3972244936247579248,
        "service_name": "drive-thru",
        "span_id": 6417393972759921421,
        "trace_id": 8081499827737120046
    }
}

running: False
schema_name_id: 1793
start_time: 2026-04-07 03:01:45
success: True
trace_id: 8081499827737120046

Scan 161561558

duration: 0:00:12.193869

exit_message:

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

id: 161561558

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_ChargeInstanceSet/2026-04-06/1775462634",
        "key": "raw/molo_moloSV_ChargeInstanceSet/2026-04-06/1775462634/SV_ChargeInstanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeInstanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11049763412808571065,
        "service_name": "drive-thru",
        "span_id": 13541815221749487930,
        "trace_id": 12654827497492263614
    }
}

running: False
schema_name_id: 1793
start_time: 2026-04-06 03:05:11
success: True
trace_id: 12654827497492263614

Scan 161514943

duration: 0:00:14.771220

exit_message:

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

id: 161514943

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_ChargeInstanceSet/2026-04-05/1775376263",
        "key": "raw/molo_moloSV_ChargeInstanceSet/2026-04-05/1775376263/SV_ChargeInstanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeInstanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3730478679285781145,
        "service_name": "drive-thru",
        "span_id": 7711392821726062229,
        "trace_id": 7797060231308756142
    }
}

running: False
schema_name_id: 1793
start_time: 2026-04-05 03:07:34
success: True
trace_id: 7797060231308756142

Scan 161460575

duration: 0:00:14.859300

exit_message:

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

id: 161460575

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_ChargeInstanceSet/2026-04-04/1775289746",
        "key": "raw/molo_moloSV_ChargeInstanceSet/2026-04-04/1775289746/SV_ChargeInstanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeInstanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15382954935190194896,
        "service_name": "drive-thru",
        "span_id": 3905505733078903890,
        "trace_id": 15992428968616889083
    }
}

running: False
schema_name_id: 1793
start_time: 2026-04-04 03:10:26
success: True
trace_id: 15992428968616889083

Scan 161401969

duration: 0:00:14.864007

exit_message:

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

id: 161401969

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_ChargeInstanceSet/2026-04-03/1775203513",
        "key": "raw/molo_moloSV_ChargeInstanceSet/2026-04-03/1775203513/SV_ChargeInstanceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ChargeInstanceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18362577970398660190,
        "service_name": "drive-thru",
        "span_id": 4518665292706740859,
        "trace_id": 14189871967981159137
    }
}

running: False
schema_name_id: 1793
start_time: 2026-04-03 03:12:01
success: True
trace_id: 14189871967981159137

Partitions:

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

Schema:

attributes:

{
    "ChargeMethod": "string",
    "CommentsCreatedAt": "string",
    "CommentsCustomer": "string",
    "CommentsInternal": "string",
    "CommentsUpdatedAt": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "Discount": "string",
    "DiscountAmount": "string",
    "DiscountType": "string",
    "Id": "string",
    "OverrideDays": "string",
    "PriceOverride": "string",
    "Profit": "string",
    "ProfitPercentage": "string",
    "PurchasePriceWhenAdded": "string",
    "Quantity": "string",
    "SV_Charge_Id": "string",
    "SV_Job_Id": "string",
    "SalesPriceWhenAdded": "string",
    "Total": "string",
    "TotalCost": "string"
}

created: 2026-04-17 03:09:28

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_chargeinstanceset`\n(\n `Id`  string , `CommentsInternal`  string , `CommentsCustomer`  string , `CommentsUpdatedAt`  string , `Discount`  string , `CommentsCreatedAt`  string , `PriceOverride`  string , `Quantity`  string , `DiscountType`  string , `DiscountAmount`  string , `PurchasePriceWhenAdded`  string , `SalesPriceWhenAdded`  string , `SV_Job_Id`  string , `SV_Charge_Id`  string , `Total`  string , `Profit`  string , `ProfitPercentage`  string , `TotalCost`  string , `CreationDateTime`  string , `CreationUser_Id`  string , `OverrideDays`  string , `ChargeMethod`  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_ChargeInstanceSet/2026-04-17/1776412994'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeinstanceset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeinstanceset"
}

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:02:18",
        "disabled": false,
        "format": "raw",
        "id": 1793,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molosv_chargeinstanceset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "ChargeMethod": "string",
            "CommentsCreatedAt": "string",
            "CommentsCustomer": "string",
            "CommentsInternal": "string",
            "CommentsUpdatedAt": "string",
            "CreationDateTime": "string",
            "CreationUser_Id": "string",
            "Discount": "string",
            "DiscountAmount": "string",
            "DiscountType": "string",
            "Id": "string",
            "OverrideDays": "string",
            "PriceOverride": "string",
            "Profit": "string",
            "ProfitPercentage": "string",
            "PurchasePriceWhenAdded": "string",
            "Quantity": "string",
            "SV_Charge_Id": "string",
            "SV_Job_Id": "string",
            "SalesPriceWhenAdded": "string",
            "Total": "string",
            "TotalCost": "string"
        },
        "created": "2026-04-17 03:09:28",
        "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_chargeinstanceset`\n(\n `Id`  string , `CommentsInternal`  string , `CommentsCustomer`  string , `CommentsUpdatedAt`  string , `Discount`  string , `CommentsCreatedAt`  string , `PriceOverride`  string , `Quantity`  string , `DiscountType`  string , `DiscountAmount`  string , `PurchasePriceWhenAdded`  string , `SalesPriceWhenAdded`  string , `SV_Job_Id`  string , `SV_Charge_Id`  string , `Total`  string , `Profit`  string , `ProfitPercentage`  string , `TotalCost`  string , `CreationDateTime`  string , `CreationUser_Id`  string , `OverrideDays`  string , `ChargeMethod`  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_ChargeInstanceSet/2026-04-17/1776412994'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_chargeinstanceset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_chargeinstanceset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}