Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloitemmasters
  • created: 2023-10-17 01:56:55
  • disabled: False
  • format: raw
  • id: 1644
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_prod_drivethru",
    "table": "molo_moloitemmasters"
}
  • type: drivethrucsv
Schema Versions: 15
    • created: 2026-04-17 03:04:38
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloitemmasters`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloitemmasters`\n(\n `Id`  string , `Name`  string , `Amount`  string , `ItemChargeMethodId`  string , `Taxable`  string , `AvailableAsAddOn`  string , `MarinaLocationId`  string , `Price`  string , `Tax`  string , `Single`  string , `ChargeCategory`  string , `AmountIsDecimal`  string , `NumberOfDecimals`  string , `ItemShortName`  string , `ItemCode`  string , `TrackedInventory`  string , `QuantityOnHand`  string , `PurchasePrice`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `XeroID`  string , `SaleFrequency`  string , `LowQuantityWarning`  string , `MarinaLocation1_Id`  string , `MarinaLocation2_Id`  string , `Pedestal_Id`  string , `Pedestal1_Id`  string , `QB_Item_Id`  string , `XeroItem_Id`  string , `Barcode`  string , `DistributeToOwners`  string , `FuelCloudProductId`  string , `HashId`  string , `RequiresAgeVerification`  string , `MinimumAge`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `RecordStatusId`  string , `UpdateHash`  string , `SubletItem`  string , `InternalRevenueXeroAccount_Id`  string , `InternalCOGSXeroAccount_Id`  string , `WIPXeroAccount_Id`  string , `InventoryRevaluation_Id`  string , `MarinaLocation6_Id`  string , `FinaleProductUrl`  string , `RevenueGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `OnlyUseLast2Average`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `AddDescriptionToInvoiceNote`  string , `MarinaLocation7_Id`  string , `IgnoreInventoryQOH`  string , `QOHCommitted`  string , `QOHOnOrder`  string , `AllowTotalPriceEntry`  string , `MarinaLocation9_Id`  string , `AllowPostingtoNonIncomeAccounts`  string , `Order`  string , `EnableNegativeInventory`  string , `WIP`  string , `RecognizeOverContractPeriod`  string , `AvailableAsRevenueItem`  string , `IsSerializedInventory`  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_moloItemMasters/2026-04-17/1776412800'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloitemmasters"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloItemMasters/2026-04-17/1776412800
    • id: 1717639
    • processed: 1
    • raw_data: 
      {
    "ARGLCode": 49,
    "AddDescriptionToInvoiceNote": 55,
    "AllowPostingtoNonIncomeAccounts": 62,
    "AllowTotalPriceEntry": 60,
    "Amount": 2,
    "AmountIsDecimal": 11,
    "AvailableAsAddOn": 5,
    "AvailableAsRevenueItem": 67,
    "Barcode": 29,
    "COGSGLCode": 47,
    "ChargeCategory": 10,
    "CreationAspNetUser_Id": 36,
    "CreationDateTime": 35,
    "DeferredRecognitionGLCode": 53,
    "DeferredRevenueRecognition": 52,
    "DistributeToOwners": 30,
    "EnableNegativeInventory": 64,
    "FinaleProductUrl": 45,
    "FirstTrackingCategory": 18,
    "FuelCloudProductId": 31,
    "HashId": 32,
    "Id": 0,
    "IgnoreInventoryQOH": 57,
    "InternalCOGSXeroAccount_Id": 41,
    "InternalRevenueXeroAccount_Id": 40,
    "InventoryGLCode": 48,
    "InventoryRevaluation_Id": 43,
    "IsSerializedInventory": 68,
    "ItemChargeMethodId": 3,
    "ItemCode": 14,
    "ItemShortName": 13,
    "LowQuantityWarning": 22,
    "MarinaLocation1_Id": 23,
    "MarinaLocation2_Id": 24,
    "MarinaLocation6_Id": 44,
    "MarinaLocation7_Id": 56,
    "MarinaLocation9_Id": 61,
    "MarinaLocationId": 6,
    "MinimumAge": 34,
    "Name": 1,
    "NumberOfDecimals": 12,
    "OnlyUseLast2Average": 51,
    "Order": 63,
    "Pedestal1_Id": 26,
    "Pedestal_Id": 25,
    "Price": 7,
    "PurchasePrice": 17,
    "QB_Item_Id": 27,
    "QOHCommitted": 58,
    "QOHOnOrder": 59,
    "QuantityOnHand": 16,
    "RecognizeOverContractPeriod": 66,
    "RecordStatusId": 37,
    "RequiresAgeVerification": 33,
    "RevenueGLCode": 46,
    "SaleFrequency": 21,
    "SalesTaxGLCode": 50,
    "SecondTrackingCategory": 19,
    "Single": 9,
    "SubletItem": 39,
    "Tax": 8,
    "Taxable": 4,
    "TrackedInventory": 15,
    "TrackingCode": 54,
    "UpdateHash": 38,
    "WIP": 65,
    "WIPXeroAccount_Id": 42,
    "XeroID": 20,
    "XeroItem_Id": 28
}
    • schema_attributes: 
      {
    "ARGLCode": "string",
    "AddDescriptionToInvoiceNote": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AllowTotalPriceEntry": "string",
    "Amount": "string",
    "AmountIsDecimal": "string",
    "AvailableAsAddOn": "string",
    "AvailableAsRevenueItem": "string",
    "Barcode": "string",
    "COGSGLCode": "string",
    "ChargeCategory": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DistributeToOwners": "string",
    "EnableNegativeInventory": "string",
    "FinaleProductUrl": "string",
    "FirstTrackingCategory": "string",
    "FuelCloudProductId": "string",
    "HashId": "string",
    "Id": "string",
    "IgnoreInventoryQOH": "string",
    "InternalCOGSXeroAccount_Id": "string",
    "InternalRevenueXeroAccount_Id": "string",
    "InventoryGLCode": "string",
    "InventoryRevaluation_Id": "string",
    "IsSerializedInventory": "string",
    "ItemChargeMethodId": "string",
    "ItemCode": "string",
    "ItemShortName": "string",
    "LowQuantityWarning": "string",
    "MarinaLocation1_Id": "string",
    "MarinaLocation2_Id": "string",
    "MarinaLocation6_Id": "string",
    "MarinaLocation7_Id": "string",
    "MarinaLocation9_Id": "string",
    "MarinaLocationId": "string",
    "MinimumAge": "string",
    "Name": "string",
    "NumberOfDecimals": "string",
    "OnlyUseLast2Average": "string",
    "Order": "string",
    "Pedestal1_Id": "string",
    "Pedestal_Id": "string",
    "Price": "string",
    "PurchasePrice": "string",
    "QB_Item_Id": "string",
    "QOHCommitted": "string",
    "QOHOnOrder": "string",
    "QuantityOnHand": "string",
    "RecognizeOverContractPeriod": "string",
    "RecordStatusId": "string",
    "RequiresAgeVerification": "string",
    "RevenueGLCode": "string",
    "SaleFrequency": "string",
    "SalesTaxGLCode": "string",
    "SecondTrackingCategory": "string",
    "Single": "string",
    "SubletItem": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackedInventory": "string",
    "TrackingCode": "string",
    "UpdateHash": "string",
    "WIP": "string",
    "WIPXeroAccount_Id": "string",
    "XeroID": "string",
    "XeroItem_Id": "string"
}
    • schema_name_id: 1644
    • schema_scan_id: 162167589
    • updated: 2026-04-17 03:04:52
    • created: 2026-04-16 03:09:44
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloitemmasters`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloitemmasters`\n(\n `Id`  string , `Name`  string , `Amount`  string , `ItemChargeMethodId`  string , `Taxable`  string , `AvailableAsAddOn`  string , `MarinaLocationId`  string , `Price`  string , `Tax`  string , `Single`  string , `ChargeCategory`  string , `AmountIsDecimal`  string , `NumberOfDecimals`  string , `ItemShortName`  string , `ItemCode`  string , `TrackedInventory`  string , `QuantityOnHand`  string , `PurchasePrice`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `XeroID`  string , `SaleFrequency`  string , `LowQuantityWarning`  string , `MarinaLocation1_Id`  string , `MarinaLocation2_Id`  string , `Pedestal_Id`  string , `Pedestal1_Id`  string , `QB_Item_Id`  string , `XeroItem_Id`  string , `Barcode`  string , `DistributeToOwners`  string , `FuelCloudProductId`  string , `HashId`  string , `RequiresAgeVerification`  string , `MinimumAge`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `RecordStatusId`  string , `UpdateHash`  string , `SubletItem`  string , `InternalRevenueXeroAccount_Id`  string , `InternalCOGSXeroAccount_Id`  string , `WIPXeroAccount_Id`  string , `InventoryRevaluation_Id`  string , `MarinaLocation6_Id`  string , `FinaleProductUrl`  string , `RevenueGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `OnlyUseLast2Average`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `AddDescriptionToInvoiceNote`  string , `MarinaLocation7_Id`  string , `IgnoreInventoryQOH`  string , `QOHCommitted`  string , `QOHOnOrder`  string , `AllowTotalPriceEntry`  string , `MarinaLocation9_Id`  string , `AllowPostingtoNonIncomeAccounts`  string , `Order`  string , `EnableNegativeInventory`  string , `WIP`  string , `RecognizeOverContractPeriod`  string , `AvailableAsRevenueItem`  string , `IsSerializedInventory`  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_moloItemMasters/2026-04-16/1776326557'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloitemmasters"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloItemMasters/2026-04-16/1776326557
    • id: 1716452
    • processed: 1
    • raw_data: 
      {
    "ARGLCode": 49,
    "AddDescriptionToInvoiceNote": 55,
    "AllowPostingtoNonIncomeAccounts": 62,
    "AllowTotalPriceEntry": 60,
    "Amount": 2,
    "AmountIsDecimal": 11,
    "AvailableAsAddOn": 5,
    "AvailableAsRevenueItem": 67,
    "Barcode": 29,
    "COGSGLCode": 47,
    "ChargeCategory": 10,
    "CreationAspNetUser_Id": 36,
    "CreationDateTime": 35,
    "DeferredRecognitionGLCode": 53,
    "DeferredRevenueRecognition": 52,
    "DistributeToOwners": 30,
    "EnableNegativeInventory": 64,
    "FinaleProductUrl": 45,
    "FirstTrackingCategory": 18,
    "FuelCloudProductId": 31,
    "HashId": 32,
    "Id": 0,
    "IgnoreInventoryQOH": 57,
    "InternalCOGSXeroAccount_Id": 41,
    "InternalRevenueXeroAccount_Id": 40,
    "InventoryGLCode": 48,
    "InventoryRevaluation_Id": 43,
    "IsSerializedInventory": 68,
    "ItemChargeMethodId": 3,
    "ItemCode": 14,
    "ItemShortName": 13,
    "LowQuantityWarning": 22,
    "MarinaLocation1_Id": 23,
    "MarinaLocation2_Id": 24,
    "MarinaLocation6_Id": 44,
    "MarinaLocation7_Id": 56,
    "MarinaLocation9_Id": 61,
    "MarinaLocationId": 6,
    "MinimumAge": 34,
    "Name": 1,
    "NumberOfDecimals": 12,
    "OnlyUseLast2Average": 51,
    "Order": 63,
    "Pedestal1_Id": 26,
    "Pedestal_Id": 25,
    "Price": 7,
    "PurchasePrice": 17,
    "QB_Item_Id": 27,
    "QOHCommitted": 58,
    "QOHOnOrder": 59,
    "QuantityOnHand": 16,
    "RecognizeOverContractPeriod": 66,
    "RecordStatusId": 37,
    "RequiresAgeVerification": 33,
    "RevenueGLCode": 46,
    "SaleFrequency": 21,
    "SalesTaxGLCode": 50,
    "SecondTrackingCategory": 19,
    "Single": 9,
    "SubletItem": 39,
    "Tax": 8,
    "Taxable": 4,
    "TrackedInventory": 15,
    "TrackingCode": 54,
    "UpdateHash": 38,
    "WIP": 65,
    "WIPXeroAccount_Id": 42,
    "XeroID": 20,
    "XeroItem_Id": 28
}
    • schema_attributes: 
      {
    "ARGLCode": "string",
    "AddDescriptionToInvoiceNote": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AllowTotalPriceEntry": "string",
    "Amount": "string",
    "AmountIsDecimal": "string",
    "AvailableAsAddOn": "string",
    "AvailableAsRevenueItem": "string",
    "Barcode": "string",
    "COGSGLCode": "string",
    "ChargeCategory": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DistributeToOwners": "string",
    "EnableNegativeInventory": "string",
    "FinaleProductUrl": "string",
    "FirstTrackingCategory": "string",
    "FuelCloudProductId": "string",
    "HashId": "string",
    "Id": "string",
    "IgnoreInventoryQOH": "string",
    "InternalCOGSXeroAccount_Id": "string",
    "InternalRevenueXeroAccount_Id": "string",
    "InventoryGLCode": "string",
    "InventoryRevaluation_Id": "string",
    "IsSerializedInventory": "string",
    "ItemChargeMethodId": "string",
    "ItemCode": "string",
    "ItemShortName": "string",
    "LowQuantityWarning": "string",
    "MarinaLocation1_Id": "string",
    "MarinaLocation2_Id": "string",
    "MarinaLocation6_Id": "string",
    "MarinaLocation7_Id": "string",
    "MarinaLocation9_Id": "string",
    "MarinaLocationId": "string",
    "MinimumAge": "string",
    "Name": "string",
    "NumberOfDecimals": "string",
    "OnlyUseLast2Average": "string",
    "Order": "string",
    "Pedestal1_Id": "string",
    "Pedestal_Id": "string",
    "Price": "string",
    "PurchasePrice": "string",
    "QB_Item_Id": "string",
    "QOHCommitted": "string",
    "QOHOnOrder": "string",
    "QuantityOnHand": "string",
    "RecognizeOverContractPeriod": "string",
    "RecordStatusId": "string",
    "RequiresAgeVerification": "string",
    "RevenueGLCode": "string",
    "SaleFrequency": "string",
    "SalesTaxGLCode": "string",
    "SecondTrackingCategory": "string",
    "Single": "string",
    "SubletItem": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackedInventory": "string",
    "TrackingCode": "string",
    "UpdateHash": "string",
    "WIP": "string",
    "WIPXeroAccount_Id": "string",
    "XeroID": "string",
    "XeroItem_Id": "string"
}
    • schema_name_id: 1644
    • schema_scan_id: 162111887
    • updated: 2026-04-16 03:09:58
    • created: 2026-04-15 03:03:33
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloitemmasters`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloitemmasters`\n(\n `Id`  string , `Name`  string , `Amount`  string , `ItemChargeMethodId`  string , `Taxable`  string , `AvailableAsAddOn`  string , `MarinaLocationId`  string , `Price`  string , `Tax`  string , `Single`  string , `ChargeCategory`  string , `AmountIsDecimal`  string , `NumberOfDecimals`  string , `ItemShortName`  string , `ItemCode`  string , `TrackedInventory`  string , `QuantityOnHand`  string , `PurchasePrice`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `XeroID`  string , `SaleFrequency`  string , `LowQuantityWarning`  string , `MarinaLocation1_Id`  string , `MarinaLocation2_Id`  string , `Pedestal_Id`  string , `Pedestal1_Id`  string , `QB_Item_Id`  string , `XeroItem_Id`  string , `Barcode`  string , `DistributeToOwners`  string , `FuelCloudProductId`  string , `HashId`  string , `RequiresAgeVerification`  string , `MinimumAge`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `RecordStatusId`  string , `UpdateHash`  string , `SubletItem`  string , `InternalRevenueXeroAccount_Id`  string , `InternalCOGSXeroAccount_Id`  string , `WIPXeroAccount_Id`  string , `InventoryRevaluation_Id`  string , `MarinaLocation6_Id`  string , `FinaleProductUrl`  string , `RevenueGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `OnlyUseLast2Average`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `AddDescriptionToInvoiceNote`  string , `MarinaLocation7_Id`  string , `IgnoreInventoryQOH`  string , `QOHCommitted`  string , `QOHOnOrder`  string , `AllowTotalPriceEntry`  string , `MarinaLocation9_Id`  string , `AllowPostingtoNonIncomeAccounts`  string , `Order`  string , `EnableNegativeInventory`  string , `WIP`  string , `RecognizeOverContractPeriod`  string , `AvailableAsRevenueItem`  string , `IsSerializedInventory`  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_moloItemMasters/2026-04-15/1776240025'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloitemmasters"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloItemMasters/2026-04-15/1776240025
    • id: 1715180
    • processed: 1
    • raw_data: 
      {
    "ARGLCode": 49,
    "AddDescriptionToInvoiceNote": 55,
    "AllowPostingtoNonIncomeAccounts": 62,
    "AllowTotalPriceEntry": 60,
    "Amount": 2,
    "AmountIsDecimal": 11,
    "AvailableAsAddOn": 5,
    "AvailableAsRevenueItem": 67,
    "Barcode": 29,
    "COGSGLCode": 47,
    "ChargeCategory": 10,
    "CreationAspNetUser_Id": 36,
    "CreationDateTime": 35,
    "DeferredRecognitionGLCode": 53,
    "DeferredRevenueRecognition": 52,
    "DistributeToOwners": 30,
    "EnableNegativeInventory": 64,
    "FinaleProductUrl": 45,
    "FirstTrackingCategory": 18,
    "FuelCloudProductId": 31,
    "HashId": 32,
    "Id": 0,
    "IgnoreInventoryQOH": 57,
    "InternalCOGSXeroAccount_Id": 41,
    "InternalRevenueXeroAccount_Id": 40,
    "InventoryGLCode": 48,
    "InventoryRevaluation_Id": 43,
    "IsSerializedInventory": 68,
    "ItemChargeMethodId": 3,
    "ItemCode": 14,
    "ItemShortName": 13,
    "LowQuantityWarning": 22,
    "MarinaLocation1_Id": 23,
    "MarinaLocation2_Id": 24,
    "MarinaLocation6_Id": 44,
    "MarinaLocation7_Id": 56,
    "MarinaLocation9_Id": 61,
    "MarinaLocationId": 6,
    "MinimumAge": 34,
    "Name": 1,
    "NumberOfDecimals": 12,
    "OnlyUseLast2Average": 51,
    "Order": 63,
    "Pedestal1_Id": 26,
    "Pedestal_Id": 25,
    "Price": 7,
    "PurchasePrice": 17,
    "QB_Item_Id": 27,
    "QOHCommitted": 58,
    "QOHOnOrder": 59,
    "QuantityOnHand": 16,
    "RecognizeOverContractPeriod": 66,
    "RecordStatusId": 37,
    "RequiresAgeVerification": 33,
    "RevenueGLCode": 46,
    "SaleFrequency": 21,
    "SalesTaxGLCode": 50,
    "SecondTrackingCategory": 19,
    "Single": 9,
    "SubletItem": 39,
    "Tax": 8,
    "Taxable": 4,
    "TrackedInventory": 15,
    "TrackingCode": 54,
    "UpdateHash": 38,
    "WIP": 65,
    "WIPXeroAccount_Id": 42,
    "XeroID": 20,
    "XeroItem_Id": 28
}
    • schema_attributes: 
      {
    "ARGLCode": "string",
    "AddDescriptionToInvoiceNote": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AllowTotalPriceEntry": "string",
    "Amount": "string",
    "AmountIsDecimal": "string",
    "AvailableAsAddOn": "string",
    "AvailableAsRevenueItem": "string",
    "Barcode": "string",
    "COGSGLCode": "string",
    "ChargeCategory": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DistributeToOwners": "string",
    "EnableNegativeInventory": "string",
    "FinaleProductUrl": "string",
    "FirstTrackingCategory": "string",
    "FuelCloudProductId": "string",
    "HashId": "string",
    "Id": "string",
    "IgnoreInventoryQOH": "string",
    "InternalCOGSXeroAccount_Id": "string",
    "InternalRevenueXeroAccount_Id": "string",
    "InventoryGLCode": "string",
    "InventoryRevaluation_Id": "string",
    "IsSerializedInventory": "string",
    "ItemChargeMethodId": "string",
    "ItemCode": "string",
    "ItemShortName": "string",
    "LowQuantityWarning": "string",
    "MarinaLocation1_Id": "string",
    "MarinaLocation2_Id": "string",
    "MarinaLocation6_Id": "string",
    "MarinaLocation7_Id": "string",
    "MarinaLocation9_Id": "string",
    "MarinaLocationId": "string",
    "MinimumAge": "string",
    "Name": "string",
    "NumberOfDecimals": "string",
    "OnlyUseLast2Average": "string",
    "Order": "string",
    "Pedestal1_Id": "string",
    "Pedestal_Id": "string",
    "Price": "string",
    "PurchasePrice": "string",
    "QB_Item_Id": "string",
    "QOHCommitted": "string",
    "QOHOnOrder": "string",
    "QuantityOnHand": "string",
    "RecognizeOverContractPeriod": "string",
    "RecordStatusId": "string",
    "RequiresAgeVerification": "string",
    "RevenueGLCode": "string",
    "SaleFrequency": "string",
    "SalesTaxGLCode": "string",
    "SecondTrackingCategory": "string",
    "Single": "string",
    "SubletItem": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackedInventory": "string",
    "TrackingCode": "string",
    "UpdateHash": "string",
    "WIP": "string",
    "WIPXeroAccount_Id": "string",
    "XeroID": "string",
    "XeroItem_Id": "string"
}
    • schema_name_id: 1644
    • schema_scan_id: 162055852
    • updated: 2026-04-15 03:03:44
    • created: 2026-04-14 03:06:26
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloitemmasters`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloitemmasters`\n(\n `Id`  string , `Name`  string , `Amount`  string , `ItemChargeMethodId`  string , `Taxable`  string , `AvailableAsAddOn`  string , `MarinaLocationId`  string , `Price`  string , `Tax`  string , `Single`  string , `ChargeCategory`  string , `AmountIsDecimal`  string , `NumberOfDecimals`  string , `ItemShortName`  string , `ItemCode`  string , `TrackedInventory`  string , `QuantityOnHand`  string , `PurchasePrice`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `XeroID`  string , `SaleFrequency`  string , `LowQuantityWarning`  string , `MarinaLocation1_Id`  string , `MarinaLocation2_Id`  string , `Pedestal_Id`  string , `Pedestal1_Id`  string , `QB_Item_Id`  string , `XeroItem_Id`  string , `Barcode`  string , `DistributeToOwners`  string , `FuelCloudProductId`  string , `HashId`  string , `RequiresAgeVerification`  string , `MinimumAge`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `RecordStatusId`  string , `UpdateHash`  string , `SubletItem`  string , `InternalRevenueXeroAccount_Id`  string , `InternalCOGSXeroAccount_Id`  string , `WIPXeroAccount_Id`  string , `InventoryRevaluation_Id`  string , `MarinaLocation6_Id`  string , `FinaleProductUrl`  string , `RevenueGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `OnlyUseLast2Average`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `AddDescriptionToInvoiceNote`  string , `MarinaLocation7_Id`  string , `IgnoreInventoryQOH`  string , `QOHCommitted`  string , `QOHOnOrder`  string , `AllowTotalPriceEntry`  string , `MarinaLocation9_Id`  string , `AllowPostingtoNonIncomeAccounts`  string , `Order`  string , `EnableNegativeInventory`  string , `WIP`  string , `RecognizeOverContractPeriod`  string , `AvailableAsRevenueItem`  string , `IsSerializedInventory`  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_moloItemMasters/2026-04-14/1776153754'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloitemmasters"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloItemMasters/2026-04-14/1776153754
    • id: 1714026
    • processed: 1
    • raw_data: 
      {
    "ARGLCode": 49,
    "AddDescriptionToInvoiceNote": 55,
    "AllowPostingtoNonIncomeAccounts": 62,
    "AllowTotalPriceEntry": 60,
    "Amount": 2,
    "AmountIsDecimal": 11,
    "AvailableAsAddOn": 5,
    "AvailableAsRevenueItem": 67,
    "Barcode": 29,
    "COGSGLCode": 47,
    "ChargeCategory": 10,
    "CreationAspNetUser_Id": 36,
    "CreationDateTime": 35,
    "DeferredRecognitionGLCode": 53,
    "DeferredRevenueRecognition": 52,
    "DistributeToOwners": 30,
    "EnableNegativeInventory": 64,
    "FinaleProductUrl": 45,
    "FirstTrackingCategory": 18,
    "FuelCloudProductId": 31,
    "HashId": 32,
    "Id": 0,
    "IgnoreInventoryQOH": 57,
    "InternalCOGSXeroAccount_Id": 41,
    "InternalRevenueXeroAccount_Id": 40,
    "InventoryGLCode": 48,
    "InventoryRevaluation_Id": 43,
    "IsSerializedInventory": 68,
    "ItemChargeMethodId": 3,
    "ItemCode": 14,
    "ItemShortName": 13,
    "LowQuantityWarning": 22,
    "MarinaLocation1_Id": 23,
    "MarinaLocation2_Id": 24,
    "MarinaLocation6_Id": 44,
    "MarinaLocation7_Id": 56,
    "MarinaLocation9_Id": 61,
    "MarinaLocationId": 6,
    "MinimumAge": 34,
    "Name": 1,
    "NumberOfDecimals": 12,
    "OnlyUseLast2Average": 51,
    "Order": 63,
    "Pedestal1_Id": 26,
    "Pedestal_Id": 25,
    "Price": 7,
    "PurchasePrice": 17,
    "QB_Item_Id": 27,
    "QOHCommitted": 58,
    "QOHOnOrder": 59,
    "QuantityOnHand": 16,
    "RecognizeOverContractPeriod": 66,
    "RecordStatusId": 37,
    "RequiresAgeVerification": 33,
    "RevenueGLCode": 46,
    "SaleFrequency": 21,
    "SalesTaxGLCode": 50,
    "SecondTrackingCategory": 19,
    "Single": 9,
    "SubletItem": 39,
    "Tax": 8,
    "Taxable": 4,
    "TrackedInventory": 15,
    "TrackingCode": 54,
    "UpdateHash": 38,
    "WIP": 65,
    "WIPXeroAccount_Id": 42,
    "XeroID": 20,
    "XeroItem_Id": 28
}
    • schema_attributes: 
      {
    "ARGLCode": "string",
    "AddDescriptionToInvoiceNote": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AllowTotalPriceEntry": "string",
    "Amount": "string",
    "AmountIsDecimal": "string",
    "AvailableAsAddOn": "string",
    "AvailableAsRevenueItem": "string",
    "Barcode": "string",
    "COGSGLCode": "string",
    "ChargeCategory": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DistributeToOwners": "string",
    "EnableNegativeInventory": "string",
    "FinaleProductUrl": "string",
    "FirstTrackingCategory": "string",
    "FuelCloudProductId": "string",
    "HashId": "string",
    "Id": "string",
    "IgnoreInventoryQOH": "string",
    "InternalCOGSXeroAccount_Id": "string",
    "InternalRevenueXeroAccount_Id": "string",
    "InventoryGLCode": "string",
    "InventoryRevaluation_Id": "string",
    "IsSerializedInventory": "string",
    "ItemChargeMethodId": "string",
    "ItemCode": "string",
    "ItemShortName": "string",
    "LowQuantityWarning": "string",
    "MarinaLocation1_Id": "string",
    "MarinaLocation2_Id": "string",
    "MarinaLocation6_Id": "string",
    "MarinaLocation7_Id": "string",
    "MarinaLocation9_Id": "string",
    "MarinaLocationId": "string",
    "MinimumAge": "string",
    "Name": "string",
    "NumberOfDecimals": "string",
    "OnlyUseLast2Average": "string",
    "Order": "string",
    "Pedestal1_Id": "string",
    "Pedestal_Id": "string",
    "Price": "string",
    "PurchasePrice": "string",
    "QB_Item_Id": "string",
    "QOHCommitted": "string",
    "QOHOnOrder": "string",
    "QuantityOnHand": "string",
    "RecognizeOverContractPeriod": "string",
    "RecordStatusId": "string",
    "RequiresAgeVerification": "string",
    "RevenueGLCode": "string",
    "SaleFrequency": "string",
    "SalesTaxGLCode": "string",
    "SecondTrackingCategory": "string",
    "Single": "string",
    "SubletItem": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackedInventory": "string",
    "TrackingCode": "string",
    "UpdateHash": "string",
    "WIP": "string",
    "WIPXeroAccount_Id": "string",
    "XeroID": "string",
    "XeroItem_Id": "string"
}
    • schema_name_id: 1644
    • schema_scan_id: 162000509
    • updated: 2026-04-14 03:06:39
    • created: 2026-04-13 02:59:03
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloitemmasters`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloitemmasters`\n(\n `Id`  string , `Name`  string , `Amount`  string , `ItemChargeMethodId`  string , `Taxable`  string , `AvailableAsAddOn`  string , `MarinaLocationId`  string , `Price`  string , `Tax`  string , `Single`  string , `ChargeCategory`  string , `AmountIsDecimal`  string , `NumberOfDecimals`  string , `ItemShortName`  string , `ItemCode`  string , `TrackedInventory`  string , `QuantityOnHand`  string , `PurchasePrice`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `XeroID`  string , `SaleFrequency`  string , `LowQuantityWarning`  string , `MarinaLocation1_Id`  string , `MarinaLocation2_Id`  string , `Pedestal_Id`  string , `Pedestal1_Id`  string , `QB_Item_Id`  string , `XeroItem_Id`  string , `Barcode`  string , `DistributeToOwners`  string , `FuelCloudProductId`  string , `HashId`  string , `RequiresAgeVerification`  string , `MinimumAge`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `RecordStatusId`  string , `UpdateHash`  string , `SubletItem`  string , `InternalRevenueXeroAccount_Id`  string , `InternalCOGSXeroAccount_Id`  string , `WIPXeroAccount_Id`  string , `InventoryRevaluation_Id`  string , `MarinaLocation6_Id`  string , `FinaleProductUrl`  string , `RevenueGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `OnlyUseLast2Average`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `AddDescriptionToInvoiceNote`  string , `MarinaLocation7_Id`  string , `IgnoreInventoryQOH`  string , `QOHCommitted`  string , `QOHOnOrder`  string , `AllowTotalPriceEntry`  string , `MarinaLocation9_Id`  string , `AllowPostingtoNonIncomeAccounts`  string , `Order`  string , `EnableNegativeInventory`  string , `WIP`  string , `RecognizeOverContractPeriod`  string , `AvailableAsRevenueItem`  string , `IsSerializedInventory`  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_moloItemMasters/2026-04-13/1776066948'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloitemmasters"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloItemMasters/2026-04-13/1776066948
    • id: 1712792
    • processed: 1
    • raw_data: 
      {
    "ARGLCode": 49,
    "AddDescriptionToInvoiceNote": 55,
    "AllowPostingtoNonIncomeAccounts": 62,
    "AllowTotalPriceEntry": 60,
    "Amount": 2,
    "AmountIsDecimal": 11,
    "AvailableAsAddOn": 5,
    "AvailableAsRevenueItem": 67,
    "Barcode": 29,
    "COGSGLCode": 47,
    "ChargeCategory": 10,
    "CreationAspNetUser_Id": 36,
    "CreationDateTime": 35,
    "DeferredRecognitionGLCode": 53,
    "DeferredRevenueRecognition": 52,
    "DistributeToOwners": 30,
    "EnableNegativeInventory": 64,
    "FinaleProductUrl": 45,
    "FirstTrackingCategory": 18,
    "FuelCloudProductId": 31,
    "HashId": 32,
    "Id": 0,
    "IgnoreInventoryQOH": 57,
    "InternalCOGSXeroAccount_Id": 41,
    "InternalRevenueXeroAccount_Id": 40,
    "InventoryGLCode": 48,
    "InventoryRevaluation_Id": 43,
    "IsSerializedInventory": 68,
    "ItemChargeMethodId": 3,
    "ItemCode": 14,
    "ItemShortName": 13,
    "LowQuantityWarning": 22,
    "MarinaLocation1_Id": 23,
    "MarinaLocation2_Id": 24,
    "MarinaLocation6_Id": 44,
    "MarinaLocation7_Id": 56,
    "MarinaLocation9_Id": 61,
    "MarinaLocationId": 6,
    "MinimumAge": 34,
    "Name": 1,
    "NumberOfDecimals": 12,
    "OnlyUseLast2Average": 51,
    "Order": 63,
    "Pedestal1_Id": 26,
    "Pedestal_Id": 25,
    "Price": 7,
    "PurchasePrice": 17,
    "QB_Item_Id": 27,
    "QOHCommitted": 58,
    "QOHOnOrder": 59,
    "QuantityOnHand": 16,
    "RecognizeOverContractPeriod": 66,
    "RecordStatusId": 37,
    "RequiresAgeVerification": 33,
    "RevenueGLCode": 46,
    "SaleFrequency": 21,
    "SalesTaxGLCode": 50,
    "SecondTrackingCategory": 19,
    "Single": 9,
    "SubletItem": 39,
    "Tax": 8,
    "Taxable": 4,
    "TrackedInventory": 15,
    "TrackingCode": 54,
    "UpdateHash": 38,
    "WIP": 65,
    "WIPXeroAccount_Id": 42,
    "XeroID": 20,
    "XeroItem_Id": 28
}
    • schema_attributes: 
      {
    "ARGLCode": "string",
    "AddDescriptionToInvoiceNote": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AllowTotalPriceEntry": "string",
    "Amount": "string",
    "AmountIsDecimal": "string",
    "AvailableAsAddOn": "string",
    "AvailableAsRevenueItem": "string",
    "Barcode": "string",
    "COGSGLCode": "string",
    "ChargeCategory": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DistributeToOwners": "string",
    "EnableNegativeInventory": "string",
    "FinaleProductUrl": "string",
    "FirstTrackingCategory": "string",
    "FuelCloudProductId": "string",
    "HashId": "string",
    "Id": "string",
    "IgnoreInventoryQOH": "string",
    "InternalCOGSXeroAccount_Id": "string",
    "InternalRevenueXeroAccount_Id": "string",
    "InventoryGLCode": "string",
    "InventoryRevaluation_Id": "string",
    "IsSerializedInventory": "string",
    "ItemChargeMethodId": "string",
    "ItemCode": "string",
    "ItemShortName": "string",
    "LowQuantityWarning": "string",
    "MarinaLocation1_Id": "string",
    "MarinaLocation2_Id": "string",
    "MarinaLocation6_Id": "string",
    "MarinaLocation7_Id": "string",
    "MarinaLocation9_Id": "string",
    "MarinaLocationId": "string",
    "MinimumAge": "string",
    "Name": "string",
    "NumberOfDecimals": "string",
    "OnlyUseLast2Average": "string",
    "Order": "string",
    "Pedestal1_Id": "string",
    "Pedestal_Id": "string",
    "Price": "string",
    "PurchasePrice": "string",
    "QB_Item_Id": "string",
    "QOHCommitted": "string",
    "QOHOnOrder": "string",
    "QuantityOnHand": "string",
    "RecognizeOverContractPeriod": "string",
    "RecordStatusId": "string",
    "RequiresAgeVerification": "string",
    "RevenueGLCode": "string",
    "SaleFrequency": "string",
    "SalesTaxGLCode": "string",
    "SecondTrackingCategory": "string",
    "Single": "string",
    "SubletItem": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackedInventory": "string",
    "TrackingCode": "string",
    "UpdateHash": "string",
    "WIP": "string",
    "WIPXeroAccount_Id": "string",
    "XeroID": "string",
    "XeroItem_Id": "string"
}
    • schema_name_id: 1644
    • schema_scan_id: 161941730
    • updated: 2026-04-13 02:59:17
    • created: 2026-04-12 03:00:27
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloitemmasters`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloitemmasters`\n(\n `Id`  string , `Name`  string , `Amount`  string , `ItemChargeMethodId`  string , `Taxable`  string , `AvailableAsAddOn`  string , `MarinaLocationId`  string , `Price`  string , `Tax`  string , `Single`  string , `ChargeCategory`  string , `AmountIsDecimal`  string , `NumberOfDecimals`  string , `ItemShortName`  string , `ItemCode`  string , `TrackedInventory`  string , `QuantityOnHand`  string , `PurchasePrice`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `XeroID`  string , `SaleFrequency`  string , `LowQuantityWarning`  string , `MarinaLocation1_Id`  string , `MarinaLocation2_Id`  string , `Pedestal_Id`  string , `Pedestal1_Id`  string , `QB_Item_Id`  string , `XeroItem_Id`  string , `Barcode`  string , `DistributeToOwners`  string , `FuelCloudProductId`  string , `HashId`  string , `RequiresAgeVerification`  string , `MinimumAge`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `RecordStatusId`  string , `UpdateHash`  string , `SubletItem`  string , `InternalRevenueXeroAccount_Id`  string , `InternalCOGSXeroAccount_Id`  string , `WIPXeroAccount_Id`  string , `InventoryRevaluation_Id`  string , `MarinaLocation6_Id`  string , `FinaleProductUrl`  string , `RevenueGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `OnlyUseLast2Average`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `AddDescriptionToInvoiceNote`  string , `MarinaLocation7_Id`  string , `IgnoreInventoryQOH`  string , `QOHCommitted`  string , `QOHOnOrder`  string , `AllowTotalPriceEntry`  string , `MarinaLocation9_Id`  string , `AllowPostingtoNonIncomeAccounts`  string , `Order`  string , `EnableNegativeInventory`  string , `WIP`  string , `RecognizeOverContractPeriod`  string , `AvailableAsRevenueItem`  string , `IsSerializedInventory`  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_moloItemMasters/2026-04-12/1775980661'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloitemmasters"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloItemMasters/2026-04-12/1775980661
    • id: 1711583
    • processed: 1
    • raw_data: 
      {
    "ARGLCode": 49,
    "AddDescriptionToInvoiceNote": 55,
    "AllowPostingtoNonIncomeAccounts": 62,
    "AllowTotalPriceEntry": 60,
    "Amount": 2,
    "AmountIsDecimal": 11,
    "AvailableAsAddOn": 5,
    "AvailableAsRevenueItem": 67,
    "Barcode": 29,
    "COGSGLCode": 47,
    "ChargeCategory": 10,
    "CreationAspNetUser_Id": 36,
    "CreationDateTime": 35,
    "DeferredRecognitionGLCode": 53,
    "DeferredRevenueRecognition": 52,
    "DistributeToOwners": 30,
    "EnableNegativeInventory": 64,
    "FinaleProductUrl": 45,
    "FirstTrackingCategory": 18,
    "FuelCloudProductId": 31,
    "HashId": 32,
    "Id": 0,
    "IgnoreInventoryQOH": 57,
    "InternalCOGSXeroAccount_Id": 41,
    "InternalRevenueXeroAccount_Id": 40,
    "InventoryGLCode": 48,
    "InventoryRevaluation_Id": 43,
    "IsSerializedInventory": 68,
    "ItemChargeMethodId": 3,
    "ItemCode": 14,
    "ItemShortName": 13,
    "LowQuantityWarning": 22,
    "MarinaLocation1_Id": 23,
    "MarinaLocation2_Id": 24,
    "MarinaLocation6_Id": 44,
    "MarinaLocation7_Id": 56,
    "MarinaLocation9_Id": 61,
    "MarinaLocationId": 6,
    "MinimumAge": 34,
    "Name": 1,
    "NumberOfDecimals": 12,
    "OnlyUseLast2Average": 51,
    "Order": 63,
    "Pedestal1_Id": 26,
    "Pedestal_Id": 25,
    "Price": 7,
    "PurchasePrice": 17,
    "QB_Item_Id": 27,
    "QOHCommitted": 58,
    "QOHOnOrder": 59,
    "QuantityOnHand": 16,
    "RecognizeOverContractPeriod": 66,
    "RecordStatusId": 37,
    "RequiresAgeVerification": 33,
    "RevenueGLCode": 46,
    "SaleFrequency": 21,
    "SalesTaxGLCode": 50,
    "SecondTrackingCategory": 19,
    "Single": 9,
    "SubletItem": 39,
    "Tax": 8,
    "Taxable": 4,
    "TrackedInventory": 15,
    "TrackingCode": 54,
    "UpdateHash": 38,
    "WIP": 65,
    "WIPXeroAccount_Id": 42,
    "XeroID": 20,
    "XeroItem_Id": 28
}
    • schema_attributes: 
      {
    "ARGLCode": "string",
    "AddDescriptionToInvoiceNote": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AllowTotalPriceEntry": "string",
    "Amount": "string",
    "AmountIsDecimal": "string",
    "AvailableAsAddOn": "string",
    "AvailableAsRevenueItem": "string",
    "Barcode": "string",
    "COGSGLCode": "string",
    "ChargeCategory": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DistributeToOwners": "string",
    "EnableNegativeInventory": "string",
    "FinaleProductUrl": "string",
    "FirstTrackingCategory": "string",
    "FuelCloudProductId": "string",
    "HashId": "string",
    "Id": "string",
    "IgnoreInventoryQOH": "string",
    "InternalCOGSXeroAccount_Id": "string",
    "InternalRevenueXeroAccount_Id": "string",
    "InventoryGLCode": "string",
    "InventoryRevaluation_Id": "string",
    "IsSerializedInventory": "string",
    "ItemChargeMethodId": "string",
    "ItemCode": "string",
    "ItemShortName": "string",
    "LowQuantityWarning": "string",
    "MarinaLocation1_Id": "string",
    "MarinaLocation2_Id": "string",
    "MarinaLocation6_Id": "string",
    "MarinaLocation7_Id": "string",
    "MarinaLocation9_Id": "string",
    "MarinaLocationId": "string",
    "MinimumAge": "string",
    "Name": "string",
    "NumberOfDecimals": "string",
    "OnlyUseLast2Average": "string",
    "Order": "string",
    "Pedestal1_Id": "string",
    "Pedestal_Id": "string",
    "Price": "string",
    "PurchasePrice": "string",
    "QB_Item_Id": "string",
    "QOHCommitted": "string",
    "QOHOnOrder": "string",
    "QuantityOnHand": "string",
    "RecognizeOverContractPeriod": "string",
    "RecordStatusId": "string",
    "RequiresAgeVerification": "string",
    "RevenueGLCode": "string",
    "SaleFrequency": "string",
    "SalesTaxGLCode": "string",
    "SecondTrackingCategory": "string",
    "Single": "string",
    "SubletItem": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackedInventory": "string",
    "TrackingCode": "string",
    "UpdateHash": "string",
    "WIP": "string",
    "WIPXeroAccount_Id": "string",
    "XeroID": "string",
    "XeroItem_Id": "string"
}
    • schema_name_id: 1644
    • schema_scan_id: 161892598
    • updated: 2026-04-12 03:00:38
    • created: 2026-04-11 03:03:34
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloitemmasters`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloitemmasters`\n(\n `Id`  string , `Name`  string , `Amount`  string , `ItemChargeMethodId`  string , `Taxable`  string , `AvailableAsAddOn`  string , `MarinaLocationId`  string , `Price`  string , `Tax`  string , `Single`  string , `ChargeCategory`  string , `AmountIsDecimal`  string , `NumberOfDecimals`  string , `ItemShortName`  string , `ItemCode`  string , `TrackedInventory`  string , `QuantityOnHand`  string , `PurchasePrice`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `XeroID`  string , `SaleFrequency`  string , `LowQuantityWarning`  string , `MarinaLocation1_Id`  string , `MarinaLocation2_Id`  string , `Pedestal_Id`  string , `Pedestal1_Id`  string , `QB_Item_Id`  string , `XeroItem_Id`  string , `Barcode`  string , `DistributeToOwners`  string , `FuelCloudProductId`  string , `HashId`  string , `RequiresAgeVerification`  string , `MinimumAge`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `RecordStatusId`  string , `UpdateHash`  string , `SubletItem`  string , `InternalRevenueXeroAccount_Id`  string , `InternalCOGSXeroAccount_Id`  string , `WIPXeroAccount_Id`  string , `InventoryRevaluation_Id`  string , `MarinaLocation6_Id`  string , `FinaleProductUrl`  string , `RevenueGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `OnlyUseLast2Average`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `AddDescriptionToInvoiceNote`  string , `MarinaLocation7_Id`  string , `IgnoreInventoryQOH`  string , `QOHCommitted`  string , `QOHOnOrder`  string , `AllowTotalPriceEntry`  string , `MarinaLocation9_Id`  string , `AllowPostingtoNonIncomeAccounts`  string , `Order`  string , `EnableNegativeInventory`  string , `WIP`  string , `RecognizeOverContractPeriod`  string , `AvailableAsRevenueItem`  string , `IsSerializedInventory`  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_moloItemMasters/2026-04-11/1775894422'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloitemmasters"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloItemMasters/2026-04-11/1775894422
    • id: 1710379
    • processed: 1
    • raw_data: 
      {
    "ARGLCode": 49,
    "AddDescriptionToInvoiceNote": 55,
    "AllowPostingtoNonIncomeAccounts": 62,
    "AllowTotalPriceEntry": 60,
    "Amount": 2,
    "AmountIsDecimal": 11,
    "AvailableAsAddOn": 5,
    "AvailableAsRevenueItem": 67,
    "Barcode": 29,
    "COGSGLCode": 47,
    "ChargeCategory": 10,
    "CreationAspNetUser_Id": 36,
    "CreationDateTime": 35,
    "DeferredRecognitionGLCode": 53,
    "DeferredRevenueRecognition": 52,
    "DistributeToOwners": 30,
    "EnableNegativeInventory": 64,
    "FinaleProductUrl": 45,
    "FirstTrackingCategory": 18,
    "FuelCloudProductId": 31,
    "HashId": 32,
    "Id": 0,
    "IgnoreInventoryQOH": 57,
    "InternalCOGSXeroAccount_Id": 41,
    "InternalRevenueXeroAccount_Id": 40,
    "InventoryGLCode": 48,
    "InventoryRevaluation_Id": 43,
    "IsSerializedInventory": 68,
    "ItemChargeMethodId": 3,
    "ItemCode": 14,
    "ItemShortName": 13,
    "LowQuantityWarning": 22,
    "MarinaLocation1_Id": 23,
    "MarinaLocation2_Id": 24,
    "MarinaLocation6_Id": 44,
    "MarinaLocation7_Id": 56,
    "MarinaLocation9_Id": 61,
    "MarinaLocationId": 6,
    "MinimumAge": 34,
    "Name": 1,
    "NumberOfDecimals": 12,
    "OnlyUseLast2Average": 51,
    "Order": 63,
    "Pedestal1_Id": 26,
    "Pedestal_Id": 25,
    "Price": 7,
    "PurchasePrice": 17,
    "QB_Item_Id": 27,
    "QOHCommitted": 58,
    "QOHOnOrder": 59,
    "QuantityOnHand": 16,
    "RecognizeOverContractPeriod": 66,
    "RecordStatusId": 37,
    "RequiresAgeVerification": 33,
    "RevenueGLCode": 46,
    "SaleFrequency": 21,
    "SalesTaxGLCode": 50,
    "SecondTrackingCategory": 19,
    "Single": 9,
    "SubletItem": 39,
    "Tax": 8,
    "Taxable": 4,
    "TrackedInventory": 15,
    "TrackingCode": 54,
    "UpdateHash": 38,
    "WIP": 65,
    "WIPXeroAccount_Id": 42,
    "XeroID": 20,
    "XeroItem_Id": 28
}
    • schema_attributes: 
      {
    "ARGLCode": "string",
    "AddDescriptionToInvoiceNote": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AllowTotalPriceEntry": "string",
    "Amount": "string",
    "AmountIsDecimal": "string",
    "AvailableAsAddOn": "string",
    "AvailableAsRevenueItem": "string",
    "Barcode": "string",
    "COGSGLCode": "string",
    "ChargeCategory": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DistributeToOwners": "string",
    "EnableNegativeInventory": "string",
    "FinaleProductUrl": "string",
    "FirstTrackingCategory": "string",
    "FuelCloudProductId": "string",
    "HashId": "string",
    "Id": "string",
    "IgnoreInventoryQOH": "string",
    "InternalCOGSXeroAccount_Id": "string",
    "InternalRevenueXeroAccount_Id": "string",
    "InventoryGLCode": "string",
    "InventoryRevaluation_Id": "string",
    "IsSerializedInventory": "string",
    "ItemChargeMethodId": "string",
    "ItemCode": "string",
    "ItemShortName": "string",
    "LowQuantityWarning": "string",
    "MarinaLocation1_Id": "string",
    "MarinaLocation2_Id": "string",
    "MarinaLocation6_Id": "string",
    "MarinaLocation7_Id": "string",
    "MarinaLocation9_Id": "string",
    "MarinaLocationId": "string",
    "MinimumAge": "string",
    "Name": "string",
    "NumberOfDecimals": "string",
    "OnlyUseLast2Average": "string",
    "Order": "string",
    "Pedestal1_Id": "string",
    "Pedestal_Id": "string",
    "Price": "string",
    "PurchasePrice": "string",
    "QB_Item_Id": "string",
    "QOHCommitted": "string",
    "QOHOnOrder": "string",
    "QuantityOnHand": "string",
    "RecognizeOverContractPeriod": "string",
    "RecordStatusId": "string",
    "RequiresAgeVerification": "string",
    "RevenueGLCode": "string",
    "SaleFrequency": "string",
    "SalesTaxGLCode": "string",
    "SecondTrackingCategory": "string",
    "Single": "string",
    "SubletItem": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackedInventory": "string",
    "TrackingCode": "string",
    "UpdateHash": "string",
    "WIP": "string",
    "WIPXeroAccount_Id": "string",
    "XeroID": "string",
    "XeroItem_Id": "string"
}
    • schema_name_id: 1644
    • schema_scan_id: 161841122
    • updated: 2026-04-11 03:03:45
    • created: 2026-04-10 03:04:10
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloitemmasters`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloitemmasters`\n(\n `Id`  string , `Name`  string , `Amount`  string , `ItemChargeMethodId`  string , `Taxable`  string , `AvailableAsAddOn`  string , `MarinaLocationId`  string , `Price`  string , `Tax`  string , `Single`  string , `ChargeCategory`  string , `AmountIsDecimal`  string , `NumberOfDecimals`  string , `ItemShortName`  string , `ItemCode`  string , `TrackedInventory`  string , `QuantityOnHand`  string , `PurchasePrice`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `XeroID`  string , `SaleFrequency`  string , `LowQuantityWarning`  string , `MarinaLocation1_Id`  string , `MarinaLocation2_Id`  string , `Pedestal_Id`  string , `Pedestal1_Id`  string , `QB_Item_Id`  string , `XeroItem_Id`  string , `Barcode`  string , `DistributeToOwners`  string , `FuelCloudProductId`  string , `HashId`  string , `RequiresAgeVerification`  string , `MinimumAge`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `RecordStatusId`  string , `UpdateHash`  string , `SubletItem`  string , `InternalRevenueXeroAccount_Id`  string , `InternalCOGSXeroAccount_Id`  string , `WIPXeroAccount_Id`  string , `InventoryRevaluation_Id`  string , `MarinaLocation6_Id`  string , `FinaleProductUrl`  string , `RevenueGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `OnlyUseLast2Average`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `AddDescriptionToInvoiceNote`  string , `MarinaLocation7_Id`  string , `IgnoreInventoryQOH`  string , `QOHCommitted`  string , `QOHOnOrder`  string , `AllowTotalPriceEntry`  string , `MarinaLocation9_Id`  string , `AllowPostingtoNonIncomeAccounts`  string , `Order`  string , `EnableNegativeInventory`  string , `WIP`  string , `RecognizeOverContractPeriod`  string , `AvailableAsRevenueItem`  string , `IsSerializedInventory`  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_moloItemMasters/2026-04-10/1775808179'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloitemmasters"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloItemMasters/2026-04-10/1775808179
    • id: 1709193
    • processed: 1
    • raw_data: 
      {
    "ARGLCode": 49,
    "AddDescriptionToInvoiceNote": 55,
    "AllowPostingtoNonIncomeAccounts": 62,
    "AllowTotalPriceEntry": 60,
    "Amount": 2,
    "AmountIsDecimal": 11,
    "AvailableAsAddOn": 5,
    "AvailableAsRevenueItem": 67,
    "Barcode": 29,
    "COGSGLCode": 47,
    "ChargeCategory": 10,
    "CreationAspNetUser_Id": 36,
    "CreationDateTime": 35,
    "DeferredRecognitionGLCode": 53,
    "DeferredRevenueRecognition": 52,
    "DistributeToOwners": 30,
    "EnableNegativeInventory": 64,
    "FinaleProductUrl": 45,
    "FirstTrackingCategory": 18,
    "FuelCloudProductId": 31,
    "HashId": 32,
    "Id": 0,
    "IgnoreInventoryQOH": 57,
    "InternalCOGSXeroAccount_Id": 41,
    "InternalRevenueXeroAccount_Id": 40,
    "InventoryGLCode": 48,
    "InventoryRevaluation_Id": 43,
    "IsSerializedInventory": 68,
    "ItemChargeMethodId": 3,
    "ItemCode": 14,
    "ItemShortName": 13,
    "LowQuantityWarning": 22,
    "MarinaLocation1_Id": 23,
    "MarinaLocation2_Id": 24,
    "MarinaLocation6_Id": 44,
    "MarinaLocation7_Id": 56,
    "MarinaLocation9_Id": 61,
    "MarinaLocationId": 6,
    "MinimumAge": 34,
    "Name": 1,
    "NumberOfDecimals": 12,
    "OnlyUseLast2Average": 51,
    "Order": 63,
    "Pedestal1_Id": 26,
    "Pedestal_Id": 25,
    "Price": 7,
    "PurchasePrice": 17,
    "QB_Item_Id": 27,
    "QOHCommitted": 58,
    "QOHOnOrder": 59,
    "QuantityOnHand": 16,
    "RecognizeOverContractPeriod": 66,
    "RecordStatusId": 37,
    "RequiresAgeVerification": 33,
    "RevenueGLCode": 46,
    "SaleFrequency": 21,
    "SalesTaxGLCode": 50,
    "SecondTrackingCategory": 19,
    "Single": 9,
    "SubletItem": 39,
    "Tax": 8,
    "Taxable": 4,
    "TrackedInventory": 15,
    "TrackingCode": 54,
    "UpdateHash": 38,
    "WIP": 65,
    "WIPXeroAccount_Id": 42,
    "XeroID": 20,
    "XeroItem_Id": 28
}
    • schema_attributes: 
      {
    "ARGLCode": "string",
    "AddDescriptionToInvoiceNote": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AllowTotalPriceEntry": "string",
    "Amount": "string",
    "AmountIsDecimal": "string",
    "AvailableAsAddOn": "string",
    "AvailableAsRevenueItem": "string",
    "Barcode": "string",
    "COGSGLCode": "string",
    "ChargeCategory": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DistributeToOwners": "string",
    "EnableNegativeInventory": "string",
    "FinaleProductUrl": "string",
    "FirstTrackingCategory": "string",
    "FuelCloudProductId": "string",
    "HashId": "string",
    "Id": "string",
    "IgnoreInventoryQOH": "string",
    "InternalCOGSXeroAccount_Id": "string",
    "InternalRevenueXeroAccount_Id": "string",
    "InventoryGLCode": "string",
    "InventoryRevaluation_Id": "string",
    "IsSerializedInventory": "string",
    "ItemChargeMethodId": "string",
    "ItemCode": "string",
    "ItemShortName": "string",
    "LowQuantityWarning": "string",
    "MarinaLocation1_Id": "string",
    "MarinaLocation2_Id": "string",
    "MarinaLocation6_Id": "string",
    "MarinaLocation7_Id": "string",
    "MarinaLocation9_Id": "string",
    "MarinaLocationId": "string",
    "MinimumAge": "string",
    "Name": "string",
    "NumberOfDecimals": "string",
    "OnlyUseLast2Average": "string",
    "Order": "string",
    "Pedestal1_Id": "string",
    "Pedestal_Id": "string",
    "Price": "string",
    "PurchasePrice": "string",
    "QB_Item_Id": "string",
    "QOHCommitted": "string",
    "QOHOnOrder": "string",
    "QuantityOnHand": "string",
    "RecognizeOverContractPeriod": "string",
    "RecordStatusId": "string",
    "RequiresAgeVerification": "string",
    "RevenueGLCode": "string",
    "SaleFrequency": "string",
    "SalesTaxGLCode": "string",
    "SecondTrackingCategory": "string",
    "Single": "string",
    "SubletItem": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackedInventory": "string",
    "TrackingCode": "string",
    "UpdateHash": "string",
    "WIP": "string",
    "WIPXeroAccount_Id": "string",
    "XeroID": "string",
    "XeroItem_Id": "string"
}
    • schema_name_id: 1644
    • schema_scan_id: 161785874
    • updated: 2026-04-10 03:04:24
    • created: 2026-04-09 03:01:41
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloitemmasters`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloitemmasters`\n(\n `Id`  string , `Name`  string , `Amount`  string , `ItemChargeMethodId`  string , `Taxable`  string , `AvailableAsAddOn`  string , `MarinaLocationId`  string , `Price`  string , `Tax`  string , `Single`  string , `ChargeCategory`  string , `AmountIsDecimal`  string , `NumberOfDecimals`  string , `ItemShortName`  string , `ItemCode`  string , `TrackedInventory`  string , `QuantityOnHand`  string , `PurchasePrice`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `XeroID`  string , `SaleFrequency`  string , `LowQuantityWarning`  string , `MarinaLocation1_Id`  string , `MarinaLocation2_Id`  string , `Pedestal_Id`  string , `Pedestal1_Id`  string , `QB_Item_Id`  string , `XeroItem_Id`  string , `Barcode`  string , `DistributeToOwners`  string , `FuelCloudProductId`  string , `HashId`  string , `RequiresAgeVerification`  string , `MinimumAge`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `RecordStatusId`  string , `UpdateHash`  string , `SubletItem`  string , `InternalRevenueXeroAccount_Id`  string , `InternalCOGSXeroAccount_Id`  string , `WIPXeroAccount_Id`  string , `InventoryRevaluation_Id`  string , `MarinaLocation6_Id`  string , `FinaleProductUrl`  string , `RevenueGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `OnlyUseLast2Average`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `AddDescriptionToInvoiceNote`  string , `MarinaLocation7_Id`  string , `IgnoreInventoryQOH`  string , `QOHCommitted`  string , `QOHOnOrder`  string , `AllowTotalPriceEntry`  string , `MarinaLocation9_Id`  string , `AllowPostingtoNonIncomeAccounts`  string , `Order`  string , `EnableNegativeInventory`  string , `WIP`  string , `RecognizeOverContractPeriod`  string , `AvailableAsRevenueItem`  string , `IsSerializedInventory`  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_moloItemMasters/2026-04-09/1775721518'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloitemmasters"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloItemMasters/2026-04-09/1775721518
    • id: 1708080
    • processed: 1
    • raw_data: 
      {
    "ARGLCode": 49,
    "AddDescriptionToInvoiceNote": 55,
    "AllowPostingtoNonIncomeAccounts": 62,
    "AllowTotalPriceEntry": 60,
    "Amount": 2,
    "AmountIsDecimal": 11,
    "AvailableAsAddOn": 5,
    "AvailableAsRevenueItem": 67,
    "Barcode": 29,
    "COGSGLCode": 47,
    "ChargeCategory": 10,
    "CreationAspNetUser_Id": 36,
    "CreationDateTime": 35,
    "DeferredRecognitionGLCode": 53,
    "DeferredRevenueRecognition": 52,
    "DistributeToOwners": 30,
    "EnableNegativeInventory": 64,
    "FinaleProductUrl": 45,
    "FirstTrackingCategory": 18,
    "FuelCloudProductId": 31,
    "HashId": 32,
    "Id": 0,
    "IgnoreInventoryQOH": 57,
    "InternalCOGSXeroAccount_Id": 41,
    "InternalRevenueXeroAccount_Id": 40,
    "InventoryGLCode": 48,
    "InventoryRevaluation_Id": 43,
    "IsSerializedInventory": 68,
    "ItemChargeMethodId": 3,
    "ItemCode": 14,
    "ItemShortName": 13,
    "LowQuantityWarning": 22,
    "MarinaLocation1_Id": 23,
    "MarinaLocation2_Id": 24,
    "MarinaLocation6_Id": 44,
    "MarinaLocation7_Id": 56,
    "MarinaLocation9_Id": 61,
    "MarinaLocationId": 6,
    "MinimumAge": 34,
    "Name": 1,
    "NumberOfDecimals": 12,
    "OnlyUseLast2Average": 51,
    "Order": 63,
    "Pedestal1_Id": 26,
    "Pedestal_Id": 25,
    "Price": 7,
    "PurchasePrice": 17,
    "QB_Item_Id": 27,
    "QOHCommitted": 58,
    "QOHOnOrder": 59,
    "QuantityOnHand": 16,
    "RecognizeOverContractPeriod": 66,
    "RecordStatusId": 37,
    "RequiresAgeVerification": 33,
    "RevenueGLCode": 46,
    "SaleFrequency": 21,
    "SalesTaxGLCode": 50,
    "SecondTrackingCategory": 19,
    "Single": 9,
    "SubletItem": 39,
    "Tax": 8,
    "Taxable": 4,
    "TrackedInventory": 15,
    "TrackingCode": 54,
    "UpdateHash": 38,
    "WIP": 65,
    "WIPXeroAccount_Id": 42,
    "XeroID": 20,
    "XeroItem_Id": 28
}
    • schema_attributes: 
      {
    "ARGLCode": "string",
    "AddDescriptionToInvoiceNote": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AllowTotalPriceEntry": "string",
    "Amount": "string",
    "AmountIsDecimal": "string",
    "AvailableAsAddOn": "string",
    "AvailableAsRevenueItem": "string",
    "Barcode": "string",
    "COGSGLCode": "string",
    "ChargeCategory": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DistributeToOwners": "string",
    "EnableNegativeInventory": "string",
    "FinaleProductUrl": "string",
    "FirstTrackingCategory": "string",
    "FuelCloudProductId": "string",
    "HashId": "string",
    "Id": "string",
    "IgnoreInventoryQOH": "string",
    "InternalCOGSXeroAccount_Id": "string",
    "InternalRevenueXeroAccount_Id": "string",
    "InventoryGLCode": "string",
    "InventoryRevaluation_Id": "string",
    "IsSerializedInventory": "string",
    "ItemChargeMethodId": "string",
    "ItemCode": "string",
    "ItemShortName": "string",
    "LowQuantityWarning": "string",
    "MarinaLocation1_Id": "string",
    "MarinaLocation2_Id": "string",
    "MarinaLocation6_Id": "string",
    "MarinaLocation7_Id": "string",
    "MarinaLocation9_Id": "string",
    "MarinaLocationId": "string",
    "MinimumAge": "string",
    "Name": "string",
    "NumberOfDecimals": "string",
    "OnlyUseLast2Average": "string",
    "Order": "string",
    "Pedestal1_Id": "string",
    "Pedestal_Id": "string",
    "Price": "string",
    "PurchasePrice": "string",
    "QB_Item_Id": "string",
    "QOHCommitted": "string",
    "QOHOnOrder": "string",
    "QuantityOnHand": "string",
    "RecognizeOverContractPeriod": "string",
    "RecordStatusId": "string",
    "RequiresAgeVerification": "string",
    "RevenueGLCode": "string",
    "SaleFrequency": "string",
    "SalesTaxGLCode": "string",
    "SecondTrackingCategory": "string",
    "Single": "string",
    "SubletItem": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackedInventory": "string",
    "TrackingCode": "string",
    "UpdateHash": "string",
    "WIP": "string",
    "WIPXeroAccount_Id": "string",
    "XeroID": "string",
    "XeroItem_Id": "string"
}
    • schema_name_id: 1644
    • schema_scan_id: 161730084
    • updated: 2026-04-09 03:01:55
    • created: 2026-04-08 03:05:18
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloitemmasters`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloitemmasters`\n(\n `Id`  string , `Name`  string , `Amount`  string , `ItemChargeMethodId`  string , `Taxable`  string , `AvailableAsAddOn`  string , `MarinaLocationId`  string , `Price`  string , `Tax`  string , `Single`  string , `ChargeCategory`  string , `AmountIsDecimal`  string , `NumberOfDecimals`  string , `ItemShortName`  string , `ItemCode`  string , `TrackedInventory`  string , `QuantityOnHand`  string , `PurchasePrice`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `XeroID`  string , `SaleFrequency`  string , `LowQuantityWarning`  string , `MarinaLocation1_Id`  string , `MarinaLocation2_Id`  string , `Pedestal_Id`  string , `Pedestal1_Id`  string , `QB_Item_Id`  string , `XeroItem_Id`  string , `Barcode`  string , `DistributeToOwners`  string , `FuelCloudProductId`  string , `HashId`  string , `RequiresAgeVerification`  string , `MinimumAge`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `RecordStatusId`  string , `UpdateHash`  string , `SubletItem`  string , `InternalRevenueXeroAccount_Id`  string , `InternalCOGSXeroAccount_Id`  string , `WIPXeroAccount_Id`  string , `InventoryRevaluation_Id`  string , `MarinaLocation6_Id`  string , `FinaleProductUrl`  string , `RevenueGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `OnlyUseLast2Average`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `AddDescriptionToInvoiceNote`  string , `MarinaLocation7_Id`  string , `IgnoreInventoryQOH`  string , `QOHCommitted`  string , `QOHOnOrder`  string , `AllowTotalPriceEntry`  string , `MarinaLocation9_Id`  string , `AllowPostingtoNonIncomeAccounts`  string , `Order`  string , `EnableNegativeInventory`  string , `WIP`  string , `RecognizeOverContractPeriod`  string , `AvailableAsRevenueItem`  string , `IsSerializedInventory`  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_moloItemMasters/2026-04-08/1775635346'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloitemmasters"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloItemMasters/2026-04-08/1775635346
    • id: 1706898
    • processed: 1
    • raw_data: 
      {
    "ARGLCode": 49,
    "AddDescriptionToInvoiceNote": 55,
    "AllowPostingtoNonIncomeAccounts": 62,
    "AllowTotalPriceEntry": 60,
    "Amount": 2,
    "AmountIsDecimal": 11,
    "AvailableAsAddOn": 5,
    "AvailableAsRevenueItem": 67,
    "Barcode": 29,
    "COGSGLCode": 47,
    "ChargeCategory": 10,
    "CreationAspNetUser_Id": 36,
    "CreationDateTime": 35,
    "DeferredRecognitionGLCode": 53,
    "DeferredRevenueRecognition": 52,
    "DistributeToOwners": 30,
    "EnableNegativeInventory": 64,
    "FinaleProductUrl": 45,
    "FirstTrackingCategory": 18,
    "FuelCloudProductId": 31,
    "HashId": 32,
    "Id": 0,
    "IgnoreInventoryQOH": 57,
    "InternalCOGSXeroAccount_Id": 41,
    "InternalRevenueXeroAccount_Id": 40,
    "InventoryGLCode": 48,
    "InventoryRevaluation_Id": 43,
    "IsSerializedInventory": 68,
    "ItemChargeMethodId": 3,
    "ItemCode": 14,
    "ItemShortName": 13,
    "LowQuantityWarning": 22,
    "MarinaLocation1_Id": 23,
    "MarinaLocation2_Id": 24,
    "MarinaLocation6_Id": 44,
    "MarinaLocation7_Id": 56,
    "MarinaLocation9_Id": 61,
    "MarinaLocationId": 6,
    "MinimumAge": 34,
    "Name": 1,
    "NumberOfDecimals": 12,
    "OnlyUseLast2Average": 51,
    "Order": 63,
    "Pedestal1_Id": 26,
    "Pedestal_Id": 25,
    "Price": 7,
    "PurchasePrice": 17,
    "QB_Item_Id": 27,
    "QOHCommitted": 58,
    "QOHOnOrder": 59,
    "QuantityOnHand": 16,
    "RecognizeOverContractPeriod": 66,
    "RecordStatusId": 37,
    "RequiresAgeVerification": 33,
    "RevenueGLCode": 46,
    "SaleFrequency": 21,
    "SalesTaxGLCode": 50,
    "SecondTrackingCategory": 19,
    "Single": 9,
    "SubletItem": 39,
    "Tax": 8,
    "Taxable": 4,
    "TrackedInventory": 15,
    "TrackingCode": 54,
    "UpdateHash": 38,
    "WIP": 65,
    "WIPXeroAccount_Id": 42,
    "XeroID": 20,
    "XeroItem_Id": 28
}
    • schema_attributes: 
      {
    "ARGLCode": "string",
    "AddDescriptionToInvoiceNote": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AllowTotalPriceEntry": "string",
    "Amount": "string",
    "AmountIsDecimal": "string",
    "AvailableAsAddOn": "string",
    "AvailableAsRevenueItem": "string",
    "Barcode": "string",
    "COGSGLCode": "string",
    "ChargeCategory": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DistributeToOwners": "string",
    "EnableNegativeInventory": "string",
    "FinaleProductUrl": "string",
    "FirstTrackingCategory": "string",
    "FuelCloudProductId": "string",
    "HashId": "string",
    "Id": "string",
    "IgnoreInventoryQOH": "string",
    "InternalCOGSXeroAccount_Id": "string",
    "InternalRevenueXeroAccount_Id": "string",
    "InventoryGLCode": "string",
    "InventoryRevaluation_Id": "string",
    "IsSerializedInventory": "string",
    "ItemChargeMethodId": "string",
    "ItemCode": "string",
    "ItemShortName": "string",
    "LowQuantityWarning": "string",
    "MarinaLocation1_Id": "string",
    "MarinaLocation2_Id": "string",
    "MarinaLocation6_Id": "string",
    "MarinaLocation7_Id": "string",
    "MarinaLocation9_Id": "string",
    "MarinaLocationId": "string",
    "MinimumAge": "string",
    "Name": "string",
    "NumberOfDecimals": "string",
    "OnlyUseLast2Average": "string",
    "Order": "string",
    "Pedestal1_Id": "string",
    "Pedestal_Id": "string",
    "Price": "string",
    "PurchasePrice": "string",
    "QB_Item_Id": "string",
    "QOHCommitted": "string",
    "QOHOnOrder": "string",
    "QuantityOnHand": "string",
    "RecognizeOverContractPeriod": "string",
    "RecordStatusId": "string",
    "RequiresAgeVerification": "string",
    "RevenueGLCode": "string",
    "SaleFrequency": "string",
    "SalesTaxGLCode": "string",
    "SecondTrackingCategory": "string",
    "Single": "string",
    "SubletItem": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackedInventory": "string",
    "TrackingCode": "string",
    "UpdateHash": "string",
    "WIP": "string",
    "WIPXeroAccount_Id": "string",
    "XeroID": "string",
    "XeroItem_Id": "string"
}
    • schema_name_id: 1644
    • schema_scan_id: 161675515
    • updated: 2026-04-08 03:05:32
    • created: 2026-04-07 02:56:19
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloitemmasters`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloitemmasters`\n(\n `Id`  string , `Name`  string , `Amount`  string , `ItemChargeMethodId`  string , `Taxable`  string , `AvailableAsAddOn`  string , `MarinaLocationId`  string , `Price`  string , `Tax`  string , `Single`  string , `ChargeCategory`  string , `AmountIsDecimal`  string , `NumberOfDecimals`  string , `ItemShortName`  string , `ItemCode`  string , `TrackedInventory`  string , `QuantityOnHand`  string , `PurchasePrice`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `XeroID`  string , `SaleFrequency`  string , `LowQuantityWarning`  string , `MarinaLocation1_Id`  string , `MarinaLocation2_Id`  string , `Pedestal_Id`  string , `Pedestal1_Id`  string , `QB_Item_Id`  string , `XeroItem_Id`  string , `Barcode`  string , `DistributeToOwners`  string , `FuelCloudProductId`  string , `HashId`  string , `RequiresAgeVerification`  string , `MinimumAge`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `RecordStatusId`  string , `UpdateHash`  string , `SubletItem`  string , `InternalRevenueXeroAccount_Id`  string , `InternalCOGSXeroAccount_Id`  string , `WIPXeroAccount_Id`  string , `InventoryRevaluation_Id`  string , `MarinaLocation6_Id`  string , `FinaleProductUrl`  string , `RevenueGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `OnlyUseLast2Average`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `AddDescriptionToInvoiceNote`  string , `MarinaLocation7_Id`  string , `IgnoreInventoryQOH`  string , `QOHCommitted`  string , `QOHOnOrder`  string , `AllowTotalPriceEntry`  string , `MarinaLocation9_Id`  string , `AllowPostingtoNonIncomeAccounts`  string , `Order`  string , `EnableNegativeInventory`  string , `WIP`  string , `RecognizeOverContractPeriod`  string , `AvailableAsRevenueItem`  string , `IsSerializedInventory`  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_moloItemMasters/2026-04-07/1775548496'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloitemmasters"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloItemMasters/2026-04-07/1775548496
    • id: 1705685
    • processed: 1
    • raw_data: 
      {
    "ARGLCode": 49,
    "AddDescriptionToInvoiceNote": 55,
    "AllowPostingtoNonIncomeAccounts": 62,
    "AllowTotalPriceEntry": 60,
    "Amount": 2,
    "AmountIsDecimal": 11,
    "AvailableAsAddOn": 5,
    "AvailableAsRevenueItem": 67,
    "Barcode": 29,
    "COGSGLCode": 47,
    "ChargeCategory": 10,
    "CreationAspNetUser_Id": 36,
    "CreationDateTime": 35,
    "DeferredRecognitionGLCode": 53,
    "DeferredRevenueRecognition": 52,
    "DistributeToOwners": 30,
    "EnableNegativeInventory": 64,
    "FinaleProductUrl": 45,
    "FirstTrackingCategory": 18,
    "FuelCloudProductId": 31,
    "HashId": 32,
    "Id": 0,
    "IgnoreInventoryQOH": 57,
    "InternalCOGSXeroAccount_Id": 41,
    "InternalRevenueXeroAccount_Id": 40,
    "InventoryGLCode": 48,
    "InventoryRevaluation_Id": 43,
    "IsSerializedInventory": 68,
    "ItemChargeMethodId": 3,
    "ItemCode": 14,
    "ItemShortName": 13,
    "LowQuantityWarning": 22,
    "MarinaLocation1_Id": 23,
    "MarinaLocation2_Id": 24,
    "MarinaLocation6_Id": 44,
    "MarinaLocation7_Id": 56,
    "MarinaLocation9_Id": 61,
    "MarinaLocationId": 6,
    "MinimumAge": 34,
    "Name": 1,
    "NumberOfDecimals": 12,
    "OnlyUseLast2Average": 51,
    "Order": 63,
    "Pedestal1_Id": 26,
    "Pedestal_Id": 25,
    "Price": 7,
    "PurchasePrice": 17,
    "QB_Item_Id": 27,
    "QOHCommitted": 58,
    "QOHOnOrder": 59,
    "QuantityOnHand": 16,
    "RecognizeOverContractPeriod": 66,
    "RecordStatusId": 37,
    "RequiresAgeVerification": 33,
    "RevenueGLCode": 46,
    "SaleFrequency": 21,
    "SalesTaxGLCode": 50,
    "SecondTrackingCategory": 19,
    "Single": 9,
    "SubletItem": 39,
    "Tax": 8,
    "Taxable": 4,
    "TrackedInventory": 15,
    "TrackingCode": 54,
    "UpdateHash": 38,
    "WIP": 65,
    "WIPXeroAccount_Id": 42,
    "XeroID": 20,
    "XeroItem_Id": 28
}
    • schema_attributes: 
      {
    "ARGLCode": "string",
    "AddDescriptionToInvoiceNote": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AllowTotalPriceEntry": "string",
    "Amount": "string",
    "AmountIsDecimal": "string",
    "AvailableAsAddOn": "string",
    "AvailableAsRevenueItem": "string",
    "Barcode": "string",
    "COGSGLCode": "string",
    "ChargeCategory": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DistributeToOwners": "string",
    "EnableNegativeInventory": "string",
    "FinaleProductUrl": "string",
    "FirstTrackingCategory": "string",
    "FuelCloudProductId": "string",
    "HashId": "string",
    "Id": "string",
    "IgnoreInventoryQOH": "string",
    "InternalCOGSXeroAccount_Id": "string",
    "InternalRevenueXeroAccount_Id": "string",
    "InventoryGLCode": "string",
    "InventoryRevaluation_Id": "string",
    "IsSerializedInventory": "string",
    "ItemChargeMethodId": "string",
    "ItemCode": "string",
    "ItemShortName": "string",
    "LowQuantityWarning": "string",
    "MarinaLocation1_Id": "string",
    "MarinaLocation2_Id": "string",
    "MarinaLocation6_Id": "string",
    "MarinaLocation7_Id": "string",
    "MarinaLocation9_Id": "string",
    "MarinaLocationId": "string",
    "MinimumAge": "string",
    "Name": "string",
    "NumberOfDecimals": "string",
    "OnlyUseLast2Average": "string",
    "Order": "string",
    "Pedestal1_Id": "string",
    "Pedestal_Id": "string",
    "Price": "string",
    "PurchasePrice": "string",
    "QB_Item_Id": "string",
    "QOHCommitted": "string",
    "QOHOnOrder": "string",
    "QuantityOnHand": "string",
    "RecognizeOverContractPeriod": "string",
    "RecordStatusId": "string",
    "RequiresAgeVerification": "string",
    "RevenueGLCode": "string",
    "SaleFrequency": "string",
    "SalesTaxGLCode": "string",
    "SecondTrackingCategory": "string",
    "Single": "string",
    "SubletItem": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackedInventory": "string",
    "TrackingCode": "string",
    "UpdateHash": "string",
    "WIP": "string",
    "WIPXeroAccount_Id": "string",
    "XeroID": "string",
    "XeroItem_Id": "string"
}
    • schema_name_id: 1644
    • schema_scan_id: 161618373
    • updated: 2026-04-07 02:56:33
    • created: 2026-04-06 03:09:02
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloitemmasters`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloitemmasters`\n(\n `Id`  string , `Name`  string , `Amount`  string , `ItemChargeMethodId`  string , `Taxable`  string , `AvailableAsAddOn`  string , `MarinaLocationId`  string , `Price`  string , `Tax`  string , `Single`  string , `ChargeCategory`  string , `AmountIsDecimal`  string , `NumberOfDecimals`  string , `ItemShortName`  string , `ItemCode`  string , `TrackedInventory`  string , `QuantityOnHand`  string , `PurchasePrice`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `XeroID`  string , `SaleFrequency`  string , `LowQuantityWarning`  string , `MarinaLocation1_Id`  string , `MarinaLocation2_Id`  string , `Pedestal_Id`  string , `Pedestal1_Id`  string , `QB_Item_Id`  string , `XeroItem_Id`  string , `Barcode`  string , `DistributeToOwners`  string , `FuelCloudProductId`  string , `HashId`  string , `RequiresAgeVerification`  string , `MinimumAge`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `RecordStatusId`  string , `UpdateHash`  string , `SubletItem`  string , `InternalRevenueXeroAccount_Id`  string , `InternalCOGSXeroAccount_Id`  string , `WIPXeroAccount_Id`  string , `InventoryRevaluation_Id`  string , `MarinaLocation6_Id`  string , `FinaleProductUrl`  string , `RevenueGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `OnlyUseLast2Average`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `AddDescriptionToInvoiceNote`  string , `MarinaLocation7_Id`  string , `IgnoreInventoryQOH`  string , `QOHCommitted`  string , `QOHOnOrder`  string , `AllowTotalPriceEntry`  string , `MarinaLocation9_Id`  string , `AllowPostingtoNonIncomeAccounts`  string , `Order`  string , `EnableNegativeInventory`  string , `WIP`  string , `RecognizeOverContractPeriod`  string , `AvailableAsRevenueItem`  string , `IsSerializedInventory`  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_moloItemMasters/2026-04-06/1775462464'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloitemmasters"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloItemMasters/2026-04-06/1775462464
    • id: 1704572
    • processed: 1
    • raw_data: 
      {
    "ARGLCode": 49,
    "AddDescriptionToInvoiceNote": 55,
    "AllowPostingtoNonIncomeAccounts": 62,
    "AllowTotalPriceEntry": 60,
    "Amount": 2,
    "AmountIsDecimal": 11,
    "AvailableAsAddOn": 5,
    "AvailableAsRevenueItem": 67,
    "Barcode": 29,
    "COGSGLCode": 47,
    "ChargeCategory": 10,
    "CreationAspNetUser_Id": 36,
    "CreationDateTime": 35,
    "DeferredRecognitionGLCode": 53,
    "DeferredRevenueRecognition": 52,
    "DistributeToOwners": 30,
    "EnableNegativeInventory": 64,
    "FinaleProductUrl": 45,
    "FirstTrackingCategory": 18,
    "FuelCloudProductId": 31,
    "HashId": 32,
    "Id": 0,
    "IgnoreInventoryQOH": 57,
    "InternalCOGSXeroAccount_Id": 41,
    "InternalRevenueXeroAccount_Id": 40,
    "InventoryGLCode": 48,
    "InventoryRevaluation_Id": 43,
    "IsSerializedInventory": 68,
    "ItemChargeMethodId": 3,
    "ItemCode": 14,
    "ItemShortName": 13,
    "LowQuantityWarning": 22,
    "MarinaLocation1_Id": 23,
    "MarinaLocation2_Id": 24,
    "MarinaLocation6_Id": 44,
    "MarinaLocation7_Id": 56,
    "MarinaLocation9_Id": 61,
    "MarinaLocationId": 6,
    "MinimumAge": 34,
    "Name": 1,
    "NumberOfDecimals": 12,
    "OnlyUseLast2Average": 51,
    "Order": 63,
    "Pedestal1_Id": 26,
    "Pedestal_Id": 25,
    "Price": 7,
    "PurchasePrice": 17,
    "QB_Item_Id": 27,
    "QOHCommitted": 58,
    "QOHOnOrder": 59,
    "QuantityOnHand": 16,
    "RecognizeOverContractPeriod": 66,
    "RecordStatusId": 37,
    "RequiresAgeVerification": 33,
    "RevenueGLCode": 46,
    "SaleFrequency": 21,
    "SalesTaxGLCode": 50,
    "SecondTrackingCategory": 19,
    "Single": 9,
    "SubletItem": 39,
    "Tax": 8,
    "Taxable": 4,
    "TrackedInventory": 15,
    "TrackingCode": 54,
    "UpdateHash": 38,
    "WIP": 65,
    "WIPXeroAccount_Id": 42,
    "XeroID": 20,
    "XeroItem_Id": 28
}
    • schema_attributes: 
      {
    "ARGLCode": "string",
    "AddDescriptionToInvoiceNote": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AllowTotalPriceEntry": "string",
    "Amount": "string",
    "AmountIsDecimal": "string",
    "AvailableAsAddOn": "string",
    "AvailableAsRevenueItem": "string",
    "Barcode": "string",
    "COGSGLCode": "string",
    "ChargeCategory": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DistributeToOwners": "string",
    "EnableNegativeInventory": "string",
    "FinaleProductUrl": "string",
    "FirstTrackingCategory": "string",
    "FuelCloudProductId": "string",
    "HashId": "string",
    "Id": "string",
    "IgnoreInventoryQOH": "string",
    "InternalCOGSXeroAccount_Id": "string",
    "InternalRevenueXeroAccount_Id": "string",
    "InventoryGLCode": "string",
    "InventoryRevaluation_Id": "string",
    "IsSerializedInventory": "string",
    "ItemChargeMethodId": "string",
    "ItemCode": "string",
    "ItemShortName": "string",
    "LowQuantityWarning": "string",
    "MarinaLocation1_Id": "string",
    "MarinaLocation2_Id": "string",
    "MarinaLocation6_Id": "string",
    "MarinaLocation7_Id": "string",
    "MarinaLocation9_Id": "string",
    "MarinaLocationId": "string",
    "MinimumAge": "string",
    "Name": "string",
    "NumberOfDecimals": "string",
    "OnlyUseLast2Average": "string",
    "Order": "string",
    "Pedestal1_Id": "string",
    "Pedestal_Id": "string",
    "Price": "string",
    "PurchasePrice": "string",
    "QB_Item_Id": "string",
    "QOHCommitted": "string",
    "QOHOnOrder": "string",
    "QuantityOnHand": "string",
    "RecognizeOverContractPeriod": "string",
    "RecordStatusId": "string",
    "RequiresAgeVerification": "string",
    "RevenueGLCode": "string",
    "SaleFrequency": "string",
    "SalesTaxGLCode": "string",
    "SecondTrackingCategory": "string",
    "Single": "string",
    "SubletItem": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackedInventory": "string",
    "TrackingCode": "string",
    "UpdateHash": "string",
    "WIP": "string",
    "WIPXeroAccount_Id": "string",
    "XeroID": "string",
    "XeroItem_Id": "string"
}
    • schema_name_id: 1644
    • schema_scan_id: 161561695
    • updated: 2026-04-06 03:09:16
    • created: 2026-04-05 03:06:22
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloitemmasters`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloitemmasters`\n(\n `Id`  string , `Name`  string , `Amount`  string , `ItemChargeMethodId`  string , `Taxable`  string , `AvailableAsAddOn`  string , `MarinaLocationId`  string , `Price`  string , `Tax`  string , `Single`  string , `ChargeCategory`  string , `AmountIsDecimal`  string , `NumberOfDecimals`  string , `ItemShortName`  string , `ItemCode`  string , `TrackedInventory`  string , `QuantityOnHand`  string , `PurchasePrice`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `XeroID`  string , `SaleFrequency`  string , `LowQuantityWarning`  string , `MarinaLocation1_Id`  string , `MarinaLocation2_Id`  string , `Pedestal_Id`  string , `Pedestal1_Id`  string , `QB_Item_Id`  string , `XeroItem_Id`  string , `Barcode`  string , `DistributeToOwners`  string , `FuelCloudProductId`  string , `HashId`  string , `RequiresAgeVerification`  string , `MinimumAge`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `RecordStatusId`  string , `UpdateHash`  string , `SubletItem`  string , `InternalRevenueXeroAccount_Id`  string , `InternalCOGSXeroAccount_Id`  string , `WIPXeroAccount_Id`  string , `InventoryRevaluation_Id`  string , `MarinaLocation6_Id`  string , `FinaleProductUrl`  string , `RevenueGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `OnlyUseLast2Average`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `AddDescriptionToInvoiceNote`  string , `MarinaLocation7_Id`  string , `IgnoreInventoryQOH`  string , `QOHCommitted`  string , `QOHOnOrder`  string , `AllowTotalPriceEntry`  string , `MarinaLocation9_Id`  string , `AllowPostingtoNonIncomeAccounts`  string , `Order`  string , `EnableNegativeInventory`  string , `WIP`  string , `RecognizeOverContractPeriod`  string , `AvailableAsRevenueItem`  string , `IsSerializedInventory`  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_moloItemMasters/2026-04-05/1775376090'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloitemmasters"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloItemMasters/2026-04-05/1775376090
    • id: 1703328
    • processed: 1
    • raw_data: 
      {
    "ARGLCode": 49,
    "AddDescriptionToInvoiceNote": 55,
    "AllowPostingtoNonIncomeAccounts": 62,
    "AllowTotalPriceEntry": 60,
    "Amount": 2,
    "AmountIsDecimal": 11,
    "AvailableAsAddOn": 5,
    "AvailableAsRevenueItem": 67,
    "Barcode": 29,
    "COGSGLCode": 47,
    "ChargeCategory": 10,
    "CreationAspNetUser_Id": 36,
    "CreationDateTime": 35,
    "DeferredRecognitionGLCode": 53,
    "DeferredRevenueRecognition": 52,
    "DistributeToOwners": 30,
    "EnableNegativeInventory": 64,
    "FinaleProductUrl": 45,
    "FirstTrackingCategory": 18,
    "FuelCloudProductId": 31,
    "HashId": 32,
    "Id": 0,
    "IgnoreInventoryQOH": 57,
    "InternalCOGSXeroAccount_Id": 41,
    "InternalRevenueXeroAccount_Id": 40,
    "InventoryGLCode": 48,
    "InventoryRevaluation_Id": 43,
    "IsSerializedInventory": 68,
    "ItemChargeMethodId": 3,
    "ItemCode": 14,
    "ItemShortName": 13,
    "LowQuantityWarning": 22,
    "MarinaLocation1_Id": 23,
    "MarinaLocation2_Id": 24,
    "MarinaLocation6_Id": 44,
    "MarinaLocation7_Id": 56,
    "MarinaLocation9_Id": 61,
    "MarinaLocationId": 6,
    "MinimumAge": 34,
    "Name": 1,
    "NumberOfDecimals": 12,
    "OnlyUseLast2Average": 51,
    "Order": 63,
    "Pedestal1_Id": 26,
    "Pedestal_Id": 25,
    "Price": 7,
    "PurchasePrice": 17,
    "QB_Item_Id": 27,
    "QOHCommitted": 58,
    "QOHOnOrder": 59,
    "QuantityOnHand": 16,
    "RecognizeOverContractPeriod": 66,
    "RecordStatusId": 37,
    "RequiresAgeVerification": 33,
    "RevenueGLCode": 46,
    "SaleFrequency": 21,
    "SalesTaxGLCode": 50,
    "SecondTrackingCategory": 19,
    "Single": 9,
    "SubletItem": 39,
    "Tax": 8,
    "Taxable": 4,
    "TrackedInventory": 15,
    "TrackingCode": 54,
    "UpdateHash": 38,
    "WIP": 65,
    "WIPXeroAccount_Id": 42,
    "XeroID": 20,
    "XeroItem_Id": 28
}
    • schema_attributes: 
      {
    "ARGLCode": "string",
    "AddDescriptionToInvoiceNote": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AllowTotalPriceEntry": "string",
    "Amount": "string",
    "AmountIsDecimal": "string",
    "AvailableAsAddOn": "string",
    "AvailableAsRevenueItem": "string",
    "Barcode": "string",
    "COGSGLCode": "string",
    "ChargeCategory": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DistributeToOwners": "string",
    "EnableNegativeInventory": "string",
    "FinaleProductUrl": "string",
    "FirstTrackingCategory": "string",
    "FuelCloudProductId": "string",
    "HashId": "string",
    "Id": "string",
    "IgnoreInventoryQOH": "string",
    "InternalCOGSXeroAccount_Id": "string",
    "InternalRevenueXeroAccount_Id": "string",
    "InventoryGLCode": "string",
    "InventoryRevaluation_Id": "string",
    "IsSerializedInventory": "string",
    "ItemChargeMethodId": "string",
    "ItemCode": "string",
    "ItemShortName": "string",
    "LowQuantityWarning": "string",
    "MarinaLocation1_Id": "string",
    "MarinaLocation2_Id": "string",
    "MarinaLocation6_Id": "string",
    "MarinaLocation7_Id": "string",
    "MarinaLocation9_Id": "string",
    "MarinaLocationId": "string",
    "MinimumAge": "string",
    "Name": "string",
    "NumberOfDecimals": "string",
    "OnlyUseLast2Average": "string",
    "Order": "string",
    "Pedestal1_Id": "string",
    "Pedestal_Id": "string",
    "Price": "string",
    "PurchasePrice": "string",
    "QB_Item_Id": "string",
    "QOHCommitted": "string",
    "QOHOnOrder": "string",
    "QuantityOnHand": "string",
    "RecognizeOverContractPeriod": "string",
    "RecordStatusId": "string",
    "RequiresAgeVerification": "string",
    "RevenueGLCode": "string",
    "SaleFrequency": "string",
    "SalesTaxGLCode": "string",
    "SecondTrackingCategory": "string",
    "Single": "string",
    "SubletItem": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackedInventory": "string",
    "TrackingCode": "string",
    "UpdateHash": "string",
    "WIP": "string",
    "WIPXeroAccount_Id": "string",
    "XeroID": "string",
    "XeroItem_Id": "string"
}
    • schema_name_id: 1644
    • schema_scan_id: 161514908
    • updated: 2026-04-05 03:06:33
    • created: 2026-04-04 03:05:07
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloitemmasters`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloitemmasters`\n(\n `Id`  string , `Name`  string , `Amount`  string , `ItemChargeMethodId`  string , `Taxable`  string , `AvailableAsAddOn`  string , `MarinaLocationId`  string , `Price`  string , `Tax`  string , `Single`  string , `ChargeCategory`  string , `AmountIsDecimal`  string , `NumberOfDecimals`  string , `ItemShortName`  string , `ItemCode`  string , `TrackedInventory`  string , `QuantityOnHand`  string , `PurchasePrice`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `XeroID`  string , `SaleFrequency`  string , `LowQuantityWarning`  string , `MarinaLocation1_Id`  string , `MarinaLocation2_Id`  string , `Pedestal_Id`  string , `Pedestal1_Id`  string , `QB_Item_Id`  string , `XeroItem_Id`  string , `Barcode`  string , `DistributeToOwners`  string , `FuelCloudProductId`  string , `HashId`  string , `RequiresAgeVerification`  string , `MinimumAge`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `RecordStatusId`  string , `UpdateHash`  string , `SubletItem`  string , `InternalRevenueXeroAccount_Id`  string , `InternalCOGSXeroAccount_Id`  string , `WIPXeroAccount_Id`  string , `InventoryRevaluation_Id`  string , `MarinaLocation6_Id`  string , `FinaleProductUrl`  string , `RevenueGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `OnlyUseLast2Average`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `AddDescriptionToInvoiceNote`  string , `MarinaLocation7_Id`  string , `IgnoreInventoryQOH`  string , `QOHCommitted`  string , `QOHOnOrder`  string , `AllowTotalPriceEntry`  string , `MarinaLocation9_Id`  string , `AllowPostingtoNonIncomeAccounts`  string , `Order`  string , `EnableNegativeInventory`  string , `WIP`  string , `RecognizeOverContractPeriod`  string , `AvailableAsRevenueItem`  string , `IsSerializedInventory`  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_moloItemMasters/2026-04-04/1775289572'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloitemmasters"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloItemMasters/2026-04-04/1775289572
    • id: 1702154
    • processed: 1
    • raw_data: 
      {
    "ARGLCode": 49,
    "AddDescriptionToInvoiceNote": 55,
    "AllowPostingtoNonIncomeAccounts": 62,
    "AllowTotalPriceEntry": 60,
    "Amount": 2,
    "AmountIsDecimal": 11,
    "AvailableAsAddOn": 5,
    "AvailableAsRevenueItem": 67,
    "Barcode": 29,
    "COGSGLCode": 47,
    "ChargeCategory": 10,
    "CreationAspNetUser_Id": 36,
    "CreationDateTime": 35,
    "DeferredRecognitionGLCode": 53,
    "DeferredRevenueRecognition": 52,
    "DistributeToOwners": 30,
    "EnableNegativeInventory": 64,
    "FinaleProductUrl": 45,
    "FirstTrackingCategory": 18,
    "FuelCloudProductId": 31,
    "HashId": 32,
    "Id": 0,
    "IgnoreInventoryQOH": 57,
    "InternalCOGSXeroAccount_Id": 41,
    "InternalRevenueXeroAccount_Id": 40,
    "InventoryGLCode": 48,
    "InventoryRevaluation_Id": 43,
    "IsSerializedInventory": 68,
    "ItemChargeMethodId": 3,
    "ItemCode": 14,
    "ItemShortName": 13,
    "LowQuantityWarning": 22,
    "MarinaLocation1_Id": 23,
    "MarinaLocation2_Id": 24,
    "MarinaLocation6_Id": 44,
    "MarinaLocation7_Id": 56,
    "MarinaLocation9_Id": 61,
    "MarinaLocationId": 6,
    "MinimumAge": 34,
    "Name": 1,
    "NumberOfDecimals": 12,
    "OnlyUseLast2Average": 51,
    "Order": 63,
    "Pedestal1_Id": 26,
    "Pedestal_Id": 25,
    "Price": 7,
    "PurchasePrice": 17,
    "QB_Item_Id": 27,
    "QOHCommitted": 58,
    "QOHOnOrder": 59,
    "QuantityOnHand": 16,
    "RecognizeOverContractPeriod": 66,
    "RecordStatusId": 37,
    "RequiresAgeVerification": 33,
    "RevenueGLCode": 46,
    "SaleFrequency": 21,
    "SalesTaxGLCode": 50,
    "SecondTrackingCategory": 19,
    "Single": 9,
    "SubletItem": 39,
    "Tax": 8,
    "Taxable": 4,
    "TrackedInventory": 15,
    "TrackingCode": 54,
    "UpdateHash": 38,
    "WIP": 65,
    "WIPXeroAccount_Id": 42,
    "XeroID": 20,
    "XeroItem_Id": 28
}
    • schema_attributes: 
      {
    "ARGLCode": "string",
    "AddDescriptionToInvoiceNote": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AllowTotalPriceEntry": "string",
    "Amount": "string",
    "AmountIsDecimal": "string",
    "AvailableAsAddOn": "string",
    "AvailableAsRevenueItem": "string",
    "Barcode": "string",
    "COGSGLCode": "string",
    "ChargeCategory": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DistributeToOwners": "string",
    "EnableNegativeInventory": "string",
    "FinaleProductUrl": "string",
    "FirstTrackingCategory": "string",
    "FuelCloudProductId": "string",
    "HashId": "string",
    "Id": "string",
    "IgnoreInventoryQOH": "string",
    "InternalCOGSXeroAccount_Id": "string",
    "InternalRevenueXeroAccount_Id": "string",
    "InventoryGLCode": "string",
    "InventoryRevaluation_Id": "string",
    "IsSerializedInventory": "string",
    "ItemChargeMethodId": "string",
    "ItemCode": "string",
    "ItemShortName": "string",
    "LowQuantityWarning": "string",
    "MarinaLocation1_Id": "string",
    "MarinaLocation2_Id": "string",
    "MarinaLocation6_Id": "string",
    "MarinaLocation7_Id": "string",
    "MarinaLocation9_Id": "string",
    "MarinaLocationId": "string",
    "MinimumAge": "string",
    "Name": "string",
    "NumberOfDecimals": "string",
    "OnlyUseLast2Average": "string",
    "Order": "string",
    "Pedestal1_Id": "string",
    "Pedestal_Id": "string",
    "Price": "string",
    "PurchasePrice": "string",
    "QB_Item_Id": "string",
    "QOHCommitted": "string",
    "QOHOnOrder": "string",
    "QuantityOnHand": "string",
    "RecognizeOverContractPeriod": "string",
    "RecordStatusId": "string",
    "RequiresAgeVerification": "string",
    "RevenueGLCode": "string",
    "SaleFrequency": "string",
    "SalesTaxGLCode": "string",
    "SecondTrackingCategory": "string",
    "Single": "string",
    "SubletItem": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackedInventory": "string",
    "TrackingCode": "string",
    "UpdateHash": "string",
    "WIP": "string",
    "WIPXeroAccount_Id": "string",
    "XeroID": "string",
    "XeroItem_Id": "string"
}
    • schema_name_id: 1644
    • schema_scan_id: 161460350
    • updated: 2026-04-04 03:05:21
    • created: 2026-04-03 03:04:41
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloitemmasters`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloitemmasters`\n(\n `Id`  string , `Name`  string , `Amount`  string , `ItemChargeMethodId`  string , `Taxable`  string , `AvailableAsAddOn`  string , `MarinaLocationId`  string , `Price`  string , `Tax`  string , `Single`  string , `ChargeCategory`  string , `AmountIsDecimal`  string , `NumberOfDecimals`  string , `ItemShortName`  string , `ItemCode`  string , `TrackedInventory`  string , `QuantityOnHand`  string , `PurchasePrice`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `XeroID`  string , `SaleFrequency`  string , `LowQuantityWarning`  string , `MarinaLocation1_Id`  string , `MarinaLocation2_Id`  string , `Pedestal_Id`  string , `Pedestal1_Id`  string , `QB_Item_Id`  string , `XeroItem_Id`  string , `Barcode`  string , `DistributeToOwners`  string , `FuelCloudProductId`  string , `HashId`  string , `RequiresAgeVerification`  string , `MinimumAge`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `RecordStatusId`  string , `UpdateHash`  string , `SubletItem`  string , `InternalRevenueXeroAccount_Id`  string , `InternalCOGSXeroAccount_Id`  string , `WIPXeroAccount_Id`  string , `InventoryRevaluation_Id`  string , `MarinaLocation6_Id`  string , `FinaleProductUrl`  string , `RevenueGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `OnlyUseLast2Average`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `AddDescriptionToInvoiceNote`  string , `MarinaLocation7_Id`  string , `IgnoreInventoryQOH`  string , `QOHCommitted`  string , `QOHOnOrder`  string , `AllowTotalPriceEntry`  string , `MarinaLocation9_Id`  string , `AllowPostingtoNonIncomeAccounts`  string , `Order`  string , `EnableNegativeInventory`  string , `WIP`  string , `RecognizeOverContractPeriod`  string , `AvailableAsRevenueItem`  string , `IsSerializedInventory`  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_moloItemMasters/2026-04-03/1775203346'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloitemmasters"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloItemMasters/2026-04-03/1775203346
    • id: 1700832
    • processed: 1
    • raw_data: 
      {
    "ARGLCode": 49,
    "AddDescriptionToInvoiceNote": 55,
    "AllowPostingtoNonIncomeAccounts": 62,
    "AllowTotalPriceEntry": 60,
    "Amount": 2,
    "AmountIsDecimal": 11,
    "AvailableAsAddOn": 5,
    "AvailableAsRevenueItem": 67,
    "Barcode": 29,
    "COGSGLCode": 47,
    "ChargeCategory": 10,
    "CreationAspNetUser_Id": 36,
    "CreationDateTime": 35,
    "DeferredRecognitionGLCode": 53,
    "DeferredRevenueRecognition": 52,
    "DistributeToOwners": 30,
    "EnableNegativeInventory": 64,
    "FinaleProductUrl": 45,
    "FirstTrackingCategory": 18,
    "FuelCloudProductId": 31,
    "HashId": 32,
    "Id": 0,
    "IgnoreInventoryQOH": 57,
    "InternalCOGSXeroAccount_Id": 41,
    "InternalRevenueXeroAccount_Id": 40,
    "InventoryGLCode": 48,
    "InventoryRevaluation_Id": 43,
    "IsSerializedInventory": 68,
    "ItemChargeMethodId": 3,
    "ItemCode": 14,
    "ItemShortName": 13,
    "LowQuantityWarning": 22,
    "MarinaLocation1_Id": 23,
    "MarinaLocation2_Id": 24,
    "MarinaLocation6_Id": 44,
    "MarinaLocation7_Id": 56,
    "MarinaLocation9_Id": 61,
    "MarinaLocationId": 6,
    "MinimumAge": 34,
    "Name": 1,
    "NumberOfDecimals": 12,
    "OnlyUseLast2Average": 51,
    "Order": 63,
    "Pedestal1_Id": 26,
    "Pedestal_Id": 25,
    "Price": 7,
    "PurchasePrice": 17,
    "QB_Item_Id": 27,
    "QOHCommitted": 58,
    "QOHOnOrder": 59,
    "QuantityOnHand": 16,
    "RecognizeOverContractPeriod": 66,
    "RecordStatusId": 37,
    "RequiresAgeVerification": 33,
    "RevenueGLCode": 46,
    "SaleFrequency": 21,
    "SalesTaxGLCode": 50,
    "SecondTrackingCategory": 19,
    "Single": 9,
    "SubletItem": 39,
    "Tax": 8,
    "Taxable": 4,
    "TrackedInventory": 15,
    "TrackingCode": 54,
    "UpdateHash": 38,
    "WIP": 65,
    "WIPXeroAccount_Id": 42,
    "XeroID": 20,
    "XeroItem_Id": 28
}
    • schema_attributes: 
      {
    "ARGLCode": "string",
    "AddDescriptionToInvoiceNote": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AllowTotalPriceEntry": "string",
    "Amount": "string",
    "AmountIsDecimal": "string",
    "AvailableAsAddOn": "string",
    "AvailableAsRevenueItem": "string",
    "Barcode": "string",
    "COGSGLCode": "string",
    "ChargeCategory": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DistributeToOwners": "string",
    "EnableNegativeInventory": "string",
    "FinaleProductUrl": "string",
    "FirstTrackingCategory": "string",
    "FuelCloudProductId": "string",
    "HashId": "string",
    "Id": "string",
    "IgnoreInventoryQOH": "string",
    "InternalCOGSXeroAccount_Id": "string",
    "InternalRevenueXeroAccount_Id": "string",
    "InventoryGLCode": "string",
    "InventoryRevaluation_Id": "string",
    "IsSerializedInventory": "string",
    "ItemChargeMethodId": "string",
    "ItemCode": "string",
    "ItemShortName": "string",
    "LowQuantityWarning": "string",
    "MarinaLocation1_Id": "string",
    "MarinaLocation2_Id": "string",
    "MarinaLocation6_Id": "string",
    "MarinaLocation7_Id": "string",
    "MarinaLocation9_Id": "string",
    "MarinaLocationId": "string",
    "MinimumAge": "string",
    "Name": "string",
    "NumberOfDecimals": "string",
    "OnlyUseLast2Average": "string",
    "Order": "string",
    "Pedestal1_Id": "string",
    "Pedestal_Id": "string",
    "Price": "string",
    "PurchasePrice": "string",
    "QB_Item_Id": "string",
    "QOHCommitted": "string",
    "QOHOnOrder": "string",
    "QuantityOnHand": "string",
    "RecognizeOverContractPeriod": "string",
    "RecordStatusId": "string",
    "RequiresAgeVerification": "string",
    "RevenueGLCode": "string",
    "SaleFrequency": "string",
    "SalesTaxGLCode": "string",
    "SecondTrackingCategory": "string",
    "Single": "string",
    "SubletItem": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackedInventory": "string",
    "TrackingCode": "string",
    "UpdateHash": "string",
    "WIP": "string",
    "WIPXeroAccount_Id": "string",
    "XeroID": "string",
    "XeroItem_Id": "string"
}
    • schema_name_id: 1644
    • schema_scan_id: 161401707
    • updated: 2026-04-03 03:04:55
Schema Scans: 15
Last at 2026-04-17 03:04:35
    • duration: 0:00:16.418408
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162167589
    • 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_moloItemMasters/2026-04-17/1776412800",
        "key": "raw/molo_moloItemMasters/2026-04-17/1776412800/ItemMasters.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloItemMasters",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17951938773129643450,
        "service_name": "drive-thru",
        "span_id": 3763190000700475064,
        "trace_id": 6097930129697058435
    }
}
    • running: False
    • schema_name_id: 1644
    • start_time: 2026-04-17 03:04:35
    • success: True
    • trace_id: 6097930129697058435
    • duration: 0:00:15.920754
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162111887
    • 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_moloItemMasters/2026-04-16/1776326557",
        "key": "raw/molo_moloItemMasters/2026-04-16/1776326557/ItemMasters.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloItemMasters",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5583324937740084510,
        "service_name": "drive-thru",
        "span_id": 3145356867198407411,
        "trace_id": 11917502357216487278
    }
}
    • running: False
    • schema_name_id: 1644
    • start_time: 2026-04-16 03:09:42
    • success: True
    • trace_id: 11917502357216487278
    • duration: 0:00:13.571187
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162055852
    • 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_moloItemMasters/2026-04-15/1776240025",
        "key": "raw/molo_moloItemMasters/2026-04-15/1776240025/ItemMasters.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloItemMasters",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1785262522213552412,
        "service_name": "drive-thru",
        "span_id": 7728192964100272498,
        "trace_id": 4226209547295943710
    }
}
    • running: False
    • schema_name_id: 1644
    • start_time: 2026-04-15 03:03:30
    • success: True
    • trace_id: 4226209547295943710
    • duration: 0:00:16.069319
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162000509
    • 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_moloItemMasters/2026-04-14/1776153754",
        "key": "raw/molo_moloItemMasters/2026-04-14/1776153754/ItemMasters.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloItemMasters",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5572245834542525974,
        "service_name": "drive-thru",
        "span_id": 6941626260446817914,
        "trace_id": 1150553465592817298
    }
}
    • running: False
    • schema_name_id: 1644
    • start_time: 2026-04-14 03:06:23
    • success: True
    • trace_id: 1150553465592817298
    • duration: 0:00:16.302179
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161941730
    • 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_moloItemMasters/2026-04-13/1776066948",
        "key": "raw/molo_moloItemMasters/2026-04-13/1776066948/ItemMasters.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloItemMasters",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16331419303132384152,
        "service_name": "drive-thru",
        "span_id": 17514976006632132846,
        "trace_id": 11597280292826883230
    }
}
    • running: False
    • schema_name_id: 1644
    • start_time: 2026-04-13 02:59:00
    • success: True
    • trace_id: 11597280292826883230
    • duration: 0:00:13.392363
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161892598
    • 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_moloItemMasters/2026-04-12/1775980661",
        "key": "raw/molo_moloItemMasters/2026-04-12/1775980661/ItemMasters.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloItemMasters",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9320803764557485975,
        "service_name": "drive-thru",
        "span_id": 17507701096187958687,
        "trace_id": 9711969470463670395
    }
}
    • running: False
    • schema_name_id: 1644
    • start_time: 2026-04-12 03:00:25
    • success: True
    • trace_id: 9711969470463670395
    • duration: 0:00:13.464158
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161841122
    • 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_moloItemMasters/2026-04-11/1775894422",
        "key": "raw/molo_moloItemMasters/2026-04-11/1775894422/ItemMasters.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloItemMasters",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3300962792677819036,
        "service_name": "drive-thru",
        "span_id": 7445996119634021143,
        "trace_id": 17818856120257374258
    }
}
    • running: False
    • schema_name_id: 1644
    • start_time: 2026-04-11 03:03:31
    • success: True
    • trace_id: 17818856120257374258
    • duration: 0:00:16.248415
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161785874
    • 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_moloItemMasters/2026-04-10/1775808179",
        "key": "raw/molo_moloItemMasters/2026-04-10/1775808179/ItemMasters.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloItemMasters",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11080677334658058733,
        "service_name": "drive-thru",
        "span_id": 5586769444083929103,
        "trace_id": 3828005054877247008
    }
}
    • running: False
    • schema_name_id: 1644
    • start_time: 2026-04-10 03:04:08
    • success: True
    • trace_id: 3828005054877247008
    • duration: 0:00:16.000658
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161730084
    • 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_moloItemMasters/2026-04-09/1775721518",
        "key": "raw/molo_moloItemMasters/2026-04-09/1775721518/ItemMasters.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloItemMasters",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5342596569445292470,
        "service_name": "drive-thru",
        "span_id": 11452032803588855965,
        "trace_id": 6637812015683920356
    }
}
    • running: False
    • schema_name_id: 1644
    • start_time: 2026-04-09 03:01:39
    • success: True
    • trace_id: 6637812015683920356
    • duration: 0:00:16.087028
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161675515
    • 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_moloItemMasters/2026-04-08/1775635346",
        "key": "raw/molo_moloItemMasters/2026-04-08/1775635346/ItemMasters.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloItemMasters",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1915206043974286029,
        "service_name": "drive-thru",
        "span_id": 330276758064929191,
        "trace_id": 14975617650830304687
    }
}
    • running: False
    • schema_name_id: 1644
    • start_time: 2026-04-08 03:05:16
    • success: True
    • trace_id: 14975617650830304687
    • duration: 0:00:16.146533
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161618373
    • 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_moloItemMasters/2026-04-07/1775548496",
        "key": "raw/molo_moloItemMasters/2026-04-07/1775548496/ItemMasters.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloItemMasters",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5671926412830023532,
        "service_name": "drive-thru",
        "span_id": 4338883553365147,
        "trace_id": 10302159601168766629
    }
}
    • running: False
    • schema_name_id: 1644
    • start_time: 2026-04-07 02:56:16
    • success: True
    • trace_id: 10302159601168766629
    • duration: 0:00:16.164929
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161561695
    • 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_moloItemMasters/2026-04-06/1775462464",
        "key": "raw/molo_moloItemMasters/2026-04-06/1775462464/ItemMasters.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloItemMasters",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1083361617744441905,
        "service_name": "drive-thru",
        "span_id": 7798595323404978698,
        "trace_id": 485356684784276831
    }
}
    • running: False
    • schema_name_id: 1644
    • start_time: 2026-04-06 03:09:00
    • success: True
    • trace_id: 485356684784276831
    • duration: 0:00:13.273348
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161514908
    • 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_moloItemMasters/2026-04-05/1775376090",
        "key": "raw/molo_moloItemMasters/2026-04-05/1775376090/ItemMasters.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloItemMasters",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7312065668206432405,
        "service_name": "drive-thru",
        "span_id": 7067249857320081202,
        "trace_id": 15013223990419462394
    }
}
    • running: False
    • schema_name_id: 1644
    • start_time: 2026-04-05 03:06:20
    • success: True
    • trace_id: 15013223990419462394
    • duration: 0:00:15.917234
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161460350
    • 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_moloItemMasters/2026-04-04/1775289572",
        "key": "raw/molo_moloItemMasters/2026-04-04/1775289572/ItemMasters.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloItemMasters",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12761354030259496520,
        "service_name": "drive-thru",
        "span_id": 2575302932014494447,
        "trace_id": 16444493396438548868
    }
}
    • running: False
    • schema_name_id: 1644
    • start_time: 2026-04-04 03:05:05
    • success: True
    • trace_id: 16444493396438548868
    • duration: 0:00:16.213288
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161401707
    • 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_moloItemMasters/2026-04-03/1775203346",
        "key": "raw/molo_moloItemMasters/2026-04-03/1775203346/ItemMasters.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloItemMasters",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14501573685586036424,
        "service_name": "drive-thru",
        "span_id": 1803900125599936537,
        "trace_id": 15415562167340014429
    }
}
    • running: False
    • schema_name_id: 1644
    • start_time: 2026-04-03 03:04:38
    • success: True
    • trace_id: 15415562167340014429
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "ARGLCode": "string",
    "AddDescriptionToInvoiceNote": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AllowTotalPriceEntry": "string",
    "Amount": "string",
    "AmountIsDecimal": "string",
    "AvailableAsAddOn": "string",
    "AvailableAsRevenueItem": "string",
    "Barcode": "string",
    "COGSGLCode": "string",
    "ChargeCategory": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DistributeToOwners": "string",
    "EnableNegativeInventory": "string",
    "FinaleProductUrl": "string",
    "FirstTrackingCategory": "string",
    "FuelCloudProductId": "string",
    "HashId": "string",
    "Id": "string",
    "IgnoreInventoryQOH": "string",
    "InternalCOGSXeroAccount_Id": "string",
    "InternalRevenueXeroAccount_Id": "string",
    "InventoryGLCode": "string",
    "InventoryRevaluation_Id": "string",
    "IsSerializedInventory": "string",
    "ItemChargeMethodId": "string",
    "ItemCode": "string",
    "ItemShortName": "string",
    "LowQuantityWarning": "string",
    "MarinaLocation1_Id": "string",
    "MarinaLocation2_Id": "string",
    "MarinaLocation6_Id": "string",
    "MarinaLocation7_Id": "string",
    "MarinaLocation9_Id": "string",
    "MarinaLocationId": "string",
    "MinimumAge": "string",
    "Name": "string",
    "NumberOfDecimals": "string",
    "OnlyUseLast2Average": "string",
    "Order": "string",
    "Pedestal1_Id": "string",
    "Pedestal_Id": "string",
    "Price": "string",
    "PurchasePrice": "string",
    "QB_Item_Id": "string",
    "QOHCommitted": "string",
    "QOHOnOrder": "string",
    "QuantityOnHand": "string",
    "RecognizeOverContractPeriod": "string",
    "RecordStatusId": "string",
    "RequiresAgeVerification": "string",
    "RevenueGLCode": "string",
    "SaleFrequency": "string",
    "SalesTaxGLCode": "string",
    "SecondTrackingCategory": "string",
    "Single": "string",
    "SubletItem": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackedInventory": "string",
    "TrackingCode": "string",
    "UpdateHash": "string",
    "WIP": "string",
    "WIPXeroAccount_Id": "string",
    "XeroID": "string",
    "XeroItem_Id": "string"
}
  • created: 2026-04-17 03:04:38
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloitemmasters`\n(\n `Id`  string , `Name`  string , `Amount`  string , `ItemChargeMethodId`  string , `Taxable`  string , `AvailableAsAddOn`  string , `MarinaLocationId`  string , `Price`  string , `Tax`  string , `Single`  string , `ChargeCategory`  string , `AmountIsDecimal`  string , `NumberOfDecimals`  string , `ItemShortName`  string , `ItemCode`  string , `TrackedInventory`  string , `QuantityOnHand`  string , `PurchasePrice`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `XeroID`  string , `SaleFrequency`  string , `LowQuantityWarning`  string , `MarinaLocation1_Id`  string , `MarinaLocation2_Id`  string , `Pedestal_Id`  string , `Pedestal1_Id`  string , `QB_Item_Id`  string , `XeroItem_Id`  string , `Barcode`  string , `DistributeToOwners`  string , `FuelCloudProductId`  string , `HashId`  string , `RequiresAgeVerification`  string , `MinimumAge`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `RecordStatusId`  string , `UpdateHash`  string , `SubletItem`  string , `InternalRevenueXeroAccount_Id`  string , `InternalCOGSXeroAccount_Id`  string , `WIPXeroAccount_Id`  string , `InventoryRevaluation_Id`  string , `MarinaLocation6_Id`  string , `FinaleProductUrl`  string , `RevenueGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `OnlyUseLast2Average`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `AddDescriptionToInvoiceNote`  string , `MarinaLocation7_Id`  string , `IgnoreInventoryQOH`  string , `QOHCommitted`  string , `QOHOnOrder`  string , `AllowTotalPriceEntry`  string , `MarinaLocation9_Id`  string , `AllowPostingtoNonIncomeAccounts`  string , `Order`  string , `EnableNegativeInventory`  string , `WIP`  string , `RecognizeOverContractPeriod`  string , `AvailableAsRevenueItem`  string , `IsSerializedInventory`  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_moloItemMasters/2026-04-17/1776412800'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloitemmasters`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloitemmasters"
}
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 01:56:55",
        "disabled": false,
        "format": "raw",
        "id": 1644,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloitemmasters"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "ARGLCode": "string",
            "AddDescriptionToInvoiceNote": "string",
            "AllowPostingtoNonIncomeAccounts": "string",
            "AllowTotalPriceEntry": "string",
            "Amount": "string",
            "AmountIsDecimal": "string",
            "AvailableAsAddOn": "string",
            "AvailableAsRevenueItem": "string",
            "Barcode": "string",
            "COGSGLCode": "string",
            "ChargeCategory": "string",
            "CreationAspNetUser_Id": "string",
            "CreationDateTime": "string",
            "DeferredRecognitionGLCode": "string",
            "DeferredRevenueRecognition": "string",
            "DistributeToOwners": "string",
            "EnableNegativeInventory": "string",
            "FinaleProductUrl": "string",
            "FirstTrackingCategory": "string",
            "FuelCloudProductId": "string",
            "HashId": "string",
            "Id": "string",
            "IgnoreInventoryQOH": "string",
            "InternalCOGSXeroAccount_Id": "string",
            "InternalRevenueXeroAccount_Id": "string",
            "InventoryGLCode": "string",
            "InventoryRevaluation_Id": "string",
            "IsSerializedInventory": "string",
            "ItemChargeMethodId": "string",
            "ItemCode": "string",
            "ItemShortName": "string",
            "LowQuantityWarning": "string",
            "MarinaLocation1_Id": "string",
            "MarinaLocation2_Id": "string",
            "MarinaLocation6_Id": "string",
            "MarinaLocation7_Id": "string",
            "MarinaLocation9_Id": "string",
            "MarinaLocationId": "string",
            "MinimumAge": "string",
            "Name": "string",
            "NumberOfDecimals": "string",
            "OnlyUseLast2Average": "string",
            "Order": "string",
            "Pedestal1_Id": "string",
            "Pedestal_Id": "string",
            "Price": "string",
            "PurchasePrice": "string",
            "QB_Item_Id": "string",
            "QOHCommitted": "string",
            "QOHOnOrder": "string",
            "QuantityOnHand": "string",
            "RecognizeOverContractPeriod": "string",
            "RecordStatusId": "string",
            "RequiresAgeVerification": "string",
            "RevenueGLCode": "string",
            "SaleFrequency": "string",
            "SalesTaxGLCode": "string",
            "SecondTrackingCategory": "string",
            "Single": "string",
            "SubletItem": "string",
            "Tax": "string",
            "Taxable": "string",
            "TrackedInventory": "string",
            "TrackingCode": "string",
            "UpdateHash": "string",
            "WIP": "string",
            "WIPXeroAccount_Id": "string",
            "XeroID": "string",
            "XeroItem_Id": "string"
        },
        "created": "2026-04-17 03:04:38",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloitemmasters`\n(\n `Id`  string , `Name`  string , `Amount`  string , `ItemChargeMethodId`  string , `Taxable`  string , `AvailableAsAddOn`  string , `MarinaLocationId`  string , `Price`  string , `Tax`  string , `Single`  string , `ChargeCategory`  string , `AmountIsDecimal`  string , `NumberOfDecimals`  string , `ItemShortName`  string , `ItemCode`  string , `TrackedInventory`  string , `QuantityOnHand`  string , `PurchasePrice`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `XeroID`  string , `SaleFrequency`  string , `LowQuantityWarning`  string , `MarinaLocation1_Id`  string , `MarinaLocation2_Id`  string , `Pedestal_Id`  string , `Pedestal1_Id`  string , `QB_Item_Id`  string , `XeroItem_Id`  string , `Barcode`  string , `DistributeToOwners`  string , `FuelCloudProductId`  string , `HashId`  string , `RequiresAgeVerification`  string , `MinimumAge`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `RecordStatusId`  string , `UpdateHash`  string , `SubletItem`  string , `InternalRevenueXeroAccount_Id`  string , `InternalCOGSXeroAccount_Id`  string , `WIPXeroAccount_Id`  string , `InventoryRevaluation_Id`  string , `MarinaLocation6_Id`  string , `FinaleProductUrl`  string , `RevenueGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `OnlyUseLast2Average`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `AddDescriptionToInvoiceNote`  string , `MarinaLocation7_Id`  string , `IgnoreInventoryQOH`  string , `QOHCommitted`  string , `QOHOnOrder`  string , `AllowTotalPriceEntry`  string , `MarinaLocation9_Id`  string , `AllowPostingtoNonIncomeAccounts`  string , `Order`  string , `EnableNegativeInventory`  string , `WIP`  string , `RecognizeOverContractPeriod`  string , `AvailableAsRevenueItem`  string , `IsSerializedInventory`  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_moloItemMasters/2026-04-17/1776412800'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloitemmasters`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloitemmasters"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform