Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloseasonalprices

created: 2023-10-17 01:58:07
disabled: False
format: raw
id: 1678
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717726

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalprices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalprices`\n(\n `Id`  string , `SeasonName`  string , `StartDate`  string , `EndDate`  string , `SeasonalChargeMethodId`  string , `PricePerFoot`  string , `FlatRate`  string , `Taxable`  string , `MarinaLocationId`  string , `Active`  string , `Tax`  string , `RateDetails`  string , `RateShortName`  string , `OnlinePaymentPlaceholder`  string , `XeroItemCode`  string , `XeroId`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `SeasonalInvoicingMethod_Id`  string , `SV_InventoryCategory_Id`  string , `SV_InventorySubCategory_Id`  string , `CreationDateTime`  string , `AspNetUser_Id`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `DueDateDays`  string , `DueDateSettings_Id`  string , `ChargeCategory`  string , `IntroText`  string , `RevenueGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `DeletionDatetime`  string , `DeletionAspNetUser_Id`  string , `RecordStatus_Id`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `XeroRecognitionAccountId`  string , `RevenueXeroAccountId`  string , `AllowPostingtoNonIncomeAccounts`  string , `MinimumFlatRatePerPeriod`  string , `ServicePackageSplit`  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_moloSeasonalPrices/2026-04-17/1776412849'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalprices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalPrices/2026-04-17/1776412849
id: 1717726
processed: 1

raw_data:

{
    "ARGLCode": 31,
    "Active": 9,
    "AllowPostingtoNonIncomeAccounts": 41,
    "AspNetUser_Id": 22,
    "ChargeCategory": 28,
    "CheckInTerms": 23,
    "CheckOutTerms": 24,
    "CreationDateTime": 21,
    "DeferredRecognitionGLCode": 37,
    "DeferredRevenueRecognition": 36,
    "DeletionAspNetUser_Id": 34,
    "DeletionDatetime": 33,
    "DueDateDays": 26,
    "DueDateSettings_Id": 27,
    "EndDate": 3,
    "FirstTrackingCategory": 16,
    "FlatRate": 6,
    "Id": 0,
    "IntroText": 29,
    "MarinaLocationId": 8,
    "MinimumFlatRatePerPeriod": 42,
    "OnlinePaymentCompletion": 25,
    "OnlinePaymentPlaceholder": 13,
    "PricePerFoot": 5,
    "RateDetails": 11,
    "RateShortName": 12,
    "RecordStatus_Id": 35,
    "RevenueGLCode": 30,
    "RevenueXeroAccountId": 40,
    "SV_InventoryCategory_Id": 19,
    "SV_InventorySubCategory_Id": 20,
    "SalesTaxGLCode": 32,
    "SeasonName": 1,
    "SeasonalChargeMethodId": 4,
    "SeasonalInvoicingMethod_Id": 18,
    "SecondTrackingCategory": 17,
    "ServicePackageSplit": 43,
    "StartDate": 2,
    "Tax": 10,
    "Taxable": 7,
    "TrackingCode": 38,
    "XeroId": 15,
    "XeroItemCode": 14,
    "XeroRecognitionAccountId": 39
}

schema_attributes:

{
    "ARGLCode": "string",
    "Active": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AspNetUser_Id": "string",
    "ChargeCategory": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDatetime": "string",
    "DueDateDays": "string",
    "DueDateSettings_Id": "string",
    "EndDate": "string",
    "FirstTrackingCategory": "string",
    "FlatRate": "string",
    "Id": "string",
    "IntroText": "string",
    "MarinaLocationId": "string",
    "MinimumFlatRatePerPeriod": "string",
    "OnlinePaymentCompletion": "string",
    "OnlinePaymentPlaceholder": "string",
    "PricePerFoot": "string",
    "RateDetails": "string",
    "RateShortName": "string",
    "RecordStatus_Id": "string",
    "RevenueGLCode": "string",
    "RevenueXeroAccountId": "string",
    "SV_InventoryCategory_Id": "string",
    "SV_InventorySubCategory_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonName": "string",
    "SeasonalChargeMethodId": "string",
    "SeasonalInvoicingMethod_Id": "string",
    "SecondTrackingCategory": "string",
    "ServicePackageSplit": "string",
    "StartDate": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackingCode": "string",
    "XeroId": "string",
    "XeroItemCode": "string",
    "XeroRecognitionAccountId": "string"
}

schema_name_id: 1678
schema_scan_id: 162167726
updated: 2026-04-17 03:08:44

Version 1716465

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalprices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalprices`\n(\n `Id`  string , `SeasonName`  string , `StartDate`  string , `EndDate`  string , `SeasonalChargeMethodId`  string , `PricePerFoot`  string , `FlatRate`  string , `Taxable`  string , `MarinaLocationId`  string , `Active`  string , `Tax`  string , `RateDetails`  string , `RateShortName`  string , `OnlinePaymentPlaceholder`  string , `XeroItemCode`  string , `XeroId`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `SeasonalInvoicingMethod_Id`  string , `SV_InventoryCategory_Id`  string , `SV_InventorySubCategory_Id`  string , `CreationDateTime`  string , `AspNetUser_Id`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `DueDateDays`  string , `DueDateSettings_Id`  string , `ChargeCategory`  string , `IntroText`  string , `RevenueGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `DeletionDatetime`  string , `DeletionAspNetUser_Id`  string , `RecordStatus_Id`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `XeroRecognitionAccountId`  string , `RevenueXeroAccountId`  string , `AllowPostingtoNonIncomeAccounts`  string , `MinimumFlatRatePerPeriod`  string , `ServicePackageSplit`  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_moloSeasonalPrices/2026-04-16/1776326603'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalprices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalPrices/2026-04-16/1776326603
id: 1716465
processed: 1

raw_data:

{
    "ARGLCode": 31,
    "Active": 9,
    "AllowPostingtoNonIncomeAccounts": 41,
    "AspNetUser_Id": 22,
    "ChargeCategory": 28,
    "CheckInTerms": 23,
    "CheckOutTerms": 24,
    "CreationDateTime": 21,
    "DeferredRecognitionGLCode": 37,
    "DeferredRevenueRecognition": 36,
    "DeletionAspNetUser_Id": 34,
    "DeletionDatetime": 33,
    "DueDateDays": 26,
    "DueDateSettings_Id": 27,
    "EndDate": 3,
    "FirstTrackingCategory": 16,
    "FlatRate": 6,
    "Id": 0,
    "IntroText": 29,
    "MarinaLocationId": 8,
    "MinimumFlatRatePerPeriod": 42,
    "OnlinePaymentCompletion": 25,
    "OnlinePaymentPlaceholder": 13,
    "PricePerFoot": 5,
    "RateDetails": 11,
    "RateShortName": 12,
    "RecordStatus_Id": 35,
    "RevenueGLCode": 30,
    "RevenueXeroAccountId": 40,
    "SV_InventoryCategory_Id": 19,
    "SV_InventorySubCategory_Id": 20,
    "SalesTaxGLCode": 32,
    "SeasonName": 1,
    "SeasonalChargeMethodId": 4,
    "SeasonalInvoicingMethod_Id": 18,
    "SecondTrackingCategory": 17,
    "ServicePackageSplit": 43,
    "StartDate": 2,
    "Tax": 10,
    "Taxable": 7,
    "TrackingCode": 38,
    "XeroId": 15,
    "XeroItemCode": 14,
    "XeroRecognitionAccountId": 39
}

schema_attributes:

{
    "ARGLCode": "string",
    "Active": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AspNetUser_Id": "string",
    "ChargeCategory": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDatetime": "string",
    "DueDateDays": "string",
    "DueDateSettings_Id": "string",
    "EndDate": "string",
    "FirstTrackingCategory": "string",
    "FlatRate": "string",
    "Id": "string",
    "IntroText": "string",
    "MarinaLocationId": "string",
    "MinimumFlatRatePerPeriod": "string",
    "OnlinePaymentCompletion": "string",
    "OnlinePaymentPlaceholder": "string",
    "PricePerFoot": "string",
    "RateDetails": "string",
    "RateShortName": "string",
    "RecordStatus_Id": "string",
    "RevenueGLCode": "string",
    "RevenueXeroAccountId": "string",
    "SV_InventoryCategory_Id": "string",
    "SV_InventorySubCategory_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonName": "string",
    "SeasonalChargeMethodId": "string",
    "SeasonalInvoicingMethod_Id": "string",
    "SecondTrackingCategory": "string",
    "ServicePackageSplit": "string",
    "StartDate": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackingCode": "string",
    "XeroId": "string",
    "XeroItemCode": "string",
    "XeroRecognitionAccountId": "string"
}

schema_name_id: 1678
schema_scan_id: 162111901
updated: 2026-04-16 03:10:27

Version 1715306

created: 2026-04-15 03:09:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalprices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalprices`\n(\n `Id`  string , `SeasonName`  string , `StartDate`  string , `EndDate`  string , `SeasonalChargeMethodId`  string , `PricePerFoot`  string , `FlatRate`  string , `Taxable`  string , `MarinaLocationId`  string , `Active`  string , `Tax`  string , `RateDetails`  string , `RateShortName`  string , `OnlinePaymentPlaceholder`  string , `XeroItemCode`  string , `XeroId`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `SeasonalInvoicingMethod_Id`  string , `SV_InventoryCategory_Id`  string , `SV_InventorySubCategory_Id`  string , `CreationDateTime`  string , `AspNetUser_Id`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `DueDateDays`  string , `DueDateSettings_Id`  string , `ChargeCategory`  string , `IntroText`  string , `RevenueGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `DeletionDatetime`  string , `DeletionAspNetUser_Id`  string , `RecordStatus_Id`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `XeroRecognitionAccountId`  string , `RevenueXeroAccountId`  string , `AllowPostingtoNonIncomeAccounts`  string , `MinimumFlatRatePerPeriod`  string , `ServicePackageSplit`  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_moloSeasonalPrices/2026-04-15/1776240073'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalprices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalPrices/2026-04-15/1776240073
id: 1715306
processed: 1

raw_data:

{
    "ARGLCode": 31,
    "Active": 9,
    "AllowPostingtoNonIncomeAccounts": 41,
    "AspNetUser_Id": 22,
    "ChargeCategory": 28,
    "CheckInTerms": 23,
    "CheckOutTerms": 24,
    "CreationDateTime": 21,
    "DeferredRecognitionGLCode": 37,
    "DeferredRevenueRecognition": 36,
    "DeletionAspNetUser_Id": 34,
    "DeletionDatetime": 33,
    "DueDateDays": 26,
    "DueDateSettings_Id": 27,
    "EndDate": 3,
    "FirstTrackingCategory": 16,
    "FlatRate": 6,
    "Id": 0,
    "IntroText": 29,
    "MarinaLocationId": 8,
    "MinimumFlatRatePerPeriod": 42,
    "OnlinePaymentCompletion": 25,
    "OnlinePaymentPlaceholder": 13,
    "PricePerFoot": 5,
    "RateDetails": 11,
    "RateShortName": 12,
    "RecordStatus_Id": 35,
    "RevenueGLCode": 30,
    "RevenueXeroAccountId": 40,
    "SV_InventoryCategory_Id": 19,
    "SV_InventorySubCategory_Id": 20,
    "SalesTaxGLCode": 32,
    "SeasonName": 1,
    "SeasonalChargeMethodId": 4,
    "SeasonalInvoicingMethod_Id": 18,
    "SecondTrackingCategory": 17,
    "ServicePackageSplit": 43,
    "StartDate": 2,
    "Tax": 10,
    "Taxable": 7,
    "TrackingCode": 38,
    "XeroId": 15,
    "XeroItemCode": 14,
    "XeroRecognitionAccountId": 39
}

schema_attributes:

{
    "ARGLCode": "string",
    "Active": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AspNetUser_Id": "string",
    "ChargeCategory": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDatetime": "string",
    "DueDateDays": "string",
    "DueDateSettings_Id": "string",
    "EndDate": "string",
    "FirstTrackingCategory": "string",
    "FlatRate": "string",
    "Id": "string",
    "IntroText": "string",
    "MarinaLocationId": "string",
    "MinimumFlatRatePerPeriod": "string",
    "OnlinePaymentCompletion": "string",
    "OnlinePaymentPlaceholder": "string",
    "PricePerFoot": "string",
    "RateDetails": "string",
    "RateShortName": "string",
    "RecordStatus_Id": "string",
    "RevenueGLCode": "string",
    "RevenueXeroAccountId": "string",
    "SV_InventoryCategory_Id": "string",
    "SV_InventorySubCategory_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonName": "string",
    "SeasonalChargeMethodId": "string",
    "SeasonalInvoicingMethod_Id": "string",
    "SecondTrackingCategory": "string",
    "ServicePackageSplit": "string",
    "StartDate": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackingCode": "string",
    "XeroId": "string",
    "XeroItemCode": "string",
    "XeroRecognitionAccountId": "string"
}

schema_name_id: 1678
schema_scan_id: 162056091
updated: 2026-04-15 03:09:38

Version 1714103

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalprices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalprices`\n(\n `Id`  string , `SeasonName`  string , `StartDate`  string , `EndDate`  string , `SeasonalChargeMethodId`  string , `PricePerFoot`  string , `FlatRate`  string , `Taxable`  string , `MarinaLocationId`  string , `Active`  string , `Tax`  string , `RateDetails`  string , `RateShortName`  string , `OnlinePaymentPlaceholder`  string , `XeroItemCode`  string , `XeroId`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `SeasonalInvoicingMethod_Id`  string , `SV_InventoryCategory_Id`  string , `SV_InventorySubCategory_Id`  string , `CreationDateTime`  string , `AspNetUser_Id`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `DueDateDays`  string , `DueDateSettings_Id`  string , `ChargeCategory`  string , `IntroText`  string , `RevenueGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `DeletionDatetime`  string , `DeletionAspNetUser_Id`  string , `RecordStatus_Id`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `XeroRecognitionAccountId`  string , `RevenueXeroAccountId`  string , `AllowPostingtoNonIncomeAccounts`  string , `MinimumFlatRatePerPeriod`  string , `ServicePackageSplit`  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_moloSeasonalPrices/2026-04-14/1776153838'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalprices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalPrices/2026-04-14/1776153838
id: 1714103
processed: 1

raw_data:

{
    "ARGLCode": 31,
    "Active": 9,
    "AllowPostingtoNonIncomeAccounts": 41,
    "AspNetUser_Id": 22,
    "ChargeCategory": 28,
    "CheckInTerms": 23,
    "CheckOutTerms": 24,
    "CreationDateTime": 21,
    "DeferredRecognitionGLCode": 37,
    "DeferredRevenueRecognition": 36,
    "DeletionAspNetUser_Id": 34,
    "DeletionDatetime": 33,
    "DueDateDays": 26,
    "DueDateSettings_Id": 27,
    "EndDate": 3,
    "FirstTrackingCategory": 16,
    "FlatRate": 6,
    "Id": 0,
    "IntroText": 29,
    "MarinaLocationId": 8,
    "MinimumFlatRatePerPeriod": 42,
    "OnlinePaymentCompletion": 25,
    "OnlinePaymentPlaceholder": 13,
    "PricePerFoot": 5,
    "RateDetails": 11,
    "RateShortName": 12,
    "RecordStatus_Id": 35,
    "RevenueGLCode": 30,
    "RevenueXeroAccountId": 40,
    "SV_InventoryCategory_Id": 19,
    "SV_InventorySubCategory_Id": 20,
    "SalesTaxGLCode": 32,
    "SeasonName": 1,
    "SeasonalChargeMethodId": 4,
    "SeasonalInvoicingMethod_Id": 18,
    "SecondTrackingCategory": 17,
    "ServicePackageSplit": 43,
    "StartDate": 2,
    "Tax": 10,
    "Taxable": 7,
    "TrackingCode": 38,
    "XeroId": 15,
    "XeroItemCode": 14,
    "XeroRecognitionAccountId": 39
}

schema_attributes:

{
    "ARGLCode": "string",
    "Active": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AspNetUser_Id": "string",
    "ChargeCategory": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDatetime": "string",
    "DueDateDays": "string",
    "DueDateSettings_Id": "string",
    "EndDate": "string",
    "FirstTrackingCategory": "string",
    "FlatRate": "string",
    "Id": "string",
    "IntroText": "string",
    "MarinaLocationId": "string",
    "MinimumFlatRatePerPeriod": "string",
    "OnlinePaymentCompletion": "string",
    "OnlinePaymentPlaceholder": "string",
    "PricePerFoot": "string",
    "RateDetails": "string",
    "RateShortName": "string",
    "RecordStatus_Id": "string",
    "RevenueGLCode": "string",
    "RevenueXeroAccountId": "string",
    "SV_InventoryCategory_Id": "string",
    "SV_InventorySubCategory_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonName": "string",
    "SeasonalChargeMethodId": "string",
    "SeasonalInvoicingMethod_Id": "string",
    "SecondTrackingCategory": "string",
    "ServicePackageSplit": "string",
    "StartDate": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackingCode": "string",
    "XeroId": "string",
    "XeroItemCode": "string",
    "XeroRecognitionAccountId": "string"
}

schema_name_id: 1678
schema_scan_id: 162000615
updated: 2026-04-14 03:09:39

Version 1712869

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalprices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalprices`\n(\n `Id`  string , `SeasonName`  string , `StartDate`  string , `EndDate`  string , `SeasonalChargeMethodId`  string , `PricePerFoot`  string , `FlatRate`  string , `Taxable`  string , `MarinaLocationId`  string , `Active`  string , `Tax`  string , `RateDetails`  string , `RateShortName`  string , `OnlinePaymentPlaceholder`  string , `XeroItemCode`  string , `XeroId`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `SeasonalInvoicingMethod_Id`  string , `SV_InventoryCategory_Id`  string , `SV_InventorySubCategory_Id`  string , `CreationDateTime`  string , `AspNetUser_Id`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `DueDateDays`  string , `DueDateSettings_Id`  string , `ChargeCategory`  string , `IntroText`  string , `RevenueGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `DeletionDatetime`  string , `DeletionAspNetUser_Id`  string , `RecordStatus_Id`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `XeroRecognitionAccountId`  string , `RevenueXeroAccountId`  string , `AllowPostingtoNonIncomeAccounts`  string , `MinimumFlatRatePerPeriod`  string , `ServicePackageSplit`  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_moloSeasonalPrices/2026-04-13/1776066997'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalprices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalPrices/2026-04-13/1776066997
id: 1712869
processed: 1

raw_data:

{
    "ARGLCode": 31,
    "Active": 9,
    "AllowPostingtoNonIncomeAccounts": 41,
    "AspNetUser_Id": 22,
    "ChargeCategory": 28,
    "CheckInTerms": 23,
    "CheckOutTerms": 24,
    "CreationDateTime": 21,
    "DeferredRecognitionGLCode": 37,
    "DeferredRevenueRecognition": 36,
    "DeletionAspNetUser_Id": 34,
    "DeletionDatetime": 33,
    "DueDateDays": 26,
    "DueDateSettings_Id": 27,
    "EndDate": 3,
    "FirstTrackingCategory": 16,
    "FlatRate": 6,
    "Id": 0,
    "IntroText": 29,
    "MarinaLocationId": 8,
    "MinimumFlatRatePerPeriod": 42,
    "OnlinePaymentCompletion": 25,
    "OnlinePaymentPlaceholder": 13,
    "PricePerFoot": 5,
    "RateDetails": 11,
    "RateShortName": 12,
    "RecordStatus_Id": 35,
    "RevenueGLCode": 30,
    "RevenueXeroAccountId": 40,
    "SV_InventoryCategory_Id": 19,
    "SV_InventorySubCategory_Id": 20,
    "SalesTaxGLCode": 32,
    "SeasonName": 1,
    "SeasonalChargeMethodId": 4,
    "SeasonalInvoicingMethod_Id": 18,
    "SecondTrackingCategory": 17,
    "ServicePackageSplit": 43,
    "StartDate": 2,
    "Tax": 10,
    "Taxable": 7,
    "TrackingCode": 38,
    "XeroId": 15,
    "XeroItemCode": 14,
    "XeroRecognitionAccountId": 39
}

schema_attributes:

{
    "ARGLCode": "string",
    "Active": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AspNetUser_Id": "string",
    "ChargeCategory": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDatetime": "string",
    "DueDateDays": "string",
    "DueDateSettings_Id": "string",
    "EndDate": "string",
    "FirstTrackingCategory": "string",
    "FlatRate": "string",
    "Id": "string",
    "IntroText": "string",
    "MarinaLocationId": "string",
    "MinimumFlatRatePerPeriod": "string",
    "OnlinePaymentCompletion": "string",
    "OnlinePaymentPlaceholder": "string",
    "PricePerFoot": "string",
    "RateDetails": "string",
    "RateShortName": "string",
    "RecordStatus_Id": "string",
    "RevenueGLCode": "string",
    "RevenueXeroAccountId": "string",
    "SV_InventoryCategory_Id": "string",
    "SV_InventorySubCategory_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonName": "string",
    "SeasonalChargeMethodId": "string",
    "SeasonalInvoicingMethod_Id": "string",
    "SecondTrackingCategory": "string",
    "ServicePackageSplit": "string",
    "StartDate": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackingCode": "string",
    "XeroId": "string",
    "XeroItemCode": "string",
    "XeroRecognitionAccountId": "string"
}

schema_name_id: 1678
schema_scan_id: 161942019
updated: 2026-04-13 03:01:30

Version 1711634

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalprices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalprices`\n(\n `Id`  string , `SeasonName`  string , `StartDate`  string , `EndDate`  string , `SeasonalChargeMethodId`  string , `PricePerFoot`  string , `FlatRate`  string , `Taxable`  string , `MarinaLocationId`  string , `Active`  string , `Tax`  string , `RateDetails`  string , `RateShortName`  string , `OnlinePaymentPlaceholder`  string , `XeroItemCode`  string , `XeroId`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `SeasonalInvoicingMethod_Id`  string , `SV_InventoryCategory_Id`  string , `SV_InventorySubCategory_Id`  string , `CreationDateTime`  string , `AspNetUser_Id`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `DueDateDays`  string , `DueDateSettings_Id`  string , `ChargeCategory`  string , `IntroText`  string , `RevenueGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `DeletionDatetime`  string , `DeletionAspNetUser_Id`  string , `RecordStatus_Id`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `XeroRecognitionAccountId`  string , `RevenueXeroAccountId`  string , `AllowPostingtoNonIncomeAccounts`  string , `MinimumFlatRatePerPeriod`  string , `ServicePackageSplit`  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_moloSeasonalPrices/2026-04-12/1775980708'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalprices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalPrices/2026-04-12/1775980708
id: 1711634
processed: 1

raw_data:

{
    "ARGLCode": 31,
    "Active": 9,
    "AllowPostingtoNonIncomeAccounts": 41,
    "AspNetUser_Id": 22,
    "ChargeCategory": 28,
    "CheckInTerms": 23,
    "CheckOutTerms": 24,
    "CreationDateTime": 21,
    "DeferredRecognitionGLCode": 37,
    "DeferredRevenueRecognition": 36,
    "DeletionAspNetUser_Id": 34,
    "DeletionDatetime": 33,
    "DueDateDays": 26,
    "DueDateSettings_Id": 27,
    "EndDate": 3,
    "FirstTrackingCategory": 16,
    "FlatRate": 6,
    "Id": 0,
    "IntroText": 29,
    "MarinaLocationId": 8,
    "MinimumFlatRatePerPeriod": 42,
    "OnlinePaymentCompletion": 25,
    "OnlinePaymentPlaceholder": 13,
    "PricePerFoot": 5,
    "RateDetails": 11,
    "RateShortName": 12,
    "RecordStatus_Id": 35,
    "RevenueGLCode": 30,
    "RevenueXeroAccountId": 40,
    "SV_InventoryCategory_Id": 19,
    "SV_InventorySubCategory_Id": 20,
    "SalesTaxGLCode": 32,
    "SeasonName": 1,
    "SeasonalChargeMethodId": 4,
    "SeasonalInvoicingMethod_Id": 18,
    "SecondTrackingCategory": 17,
    "ServicePackageSplit": 43,
    "StartDate": 2,
    "Tax": 10,
    "Taxable": 7,
    "TrackingCode": 38,
    "XeroId": 15,
    "XeroItemCode": 14,
    "XeroRecognitionAccountId": 39
}

schema_attributes:

{
    "ARGLCode": "string",
    "Active": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AspNetUser_Id": "string",
    "ChargeCategory": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDatetime": "string",
    "DueDateDays": "string",
    "DueDateSettings_Id": "string",
    "EndDate": "string",
    "FirstTrackingCategory": "string",
    "FlatRate": "string",
    "Id": "string",
    "IntroText": "string",
    "MarinaLocationId": "string",
    "MinimumFlatRatePerPeriod": "string",
    "OnlinePaymentCompletion": "string",
    "OnlinePaymentPlaceholder": "string",
    "PricePerFoot": "string",
    "RateDetails": "string",
    "RateShortName": "string",
    "RecordStatus_Id": "string",
    "RevenueGLCode": "string",
    "RevenueXeroAccountId": "string",
    "SV_InventoryCategory_Id": "string",
    "SV_InventorySubCategory_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonName": "string",
    "SeasonalChargeMethodId": "string",
    "SeasonalInvoicingMethod_Id": "string",
    "SecondTrackingCategory": "string",
    "ServicePackageSplit": "string",
    "StartDate": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackingCode": "string",
    "XeroId": "string",
    "XeroItemCode": "string",
    "XeroRecognitionAccountId": "string"
}

schema_name_id: 1678
schema_scan_id: 161892810
updated: 2026-04-12 03:02:14

Version 1710469

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalprices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalprices`\n(\n `Id`  string , `SeasonName`  string , `StartDate`  string , `EndDate`  string , `SeasonalChargeMethodId`  string , `PricePerFoot`  string , `FlatRate`  string , `Taxable`  string , `MarinaLocationId`  string , `Active`  string , `Tax`  string , `RateDetails`  string , `RateShortName`  string , `OnlinePaymentPlaceholder`  string , `XeroItemCode`  string , `XeroId`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `SeasonalInvoicingMethod_Id`  string , `SV_InventoryCategory_Id`  string , `SV_InventorySubCategory_Id`  string , `CreationDateTime`  string , `AspNetUser_Id`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `DueDateDays`  string , `DueDateSettings_Id`  string , `ChargeCategory`  string , `IntroText`  string , `RevenueGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `DeletionDatetime`  string , `DeletionAspNetUser_Id`  string , `RecordStatus_Id`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `XeroRecognitionAccountId`  string , `RevenueXeroAccountId`  string , `AllowPostingtoNonIncomeAccounts`  string , `MinimumFlatRatePerPeriod`  string , `ServicePackageSplit`  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_moloSeasonalPrices/2026-04-11/1775894475'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalprices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalPrices/2026-04-11/1775894475
id: 1710469
processed: 1

raw_data:

{
    "ARGLCode": 31,
    "Active": 9,
    "AllowPostingtoNonIncomeAccounts": 41,
    "AspNetUser_Id": 22,
    "ChargeCategory": 28,
    "CheckInTerms": 23,
    "CheckOutTerms": 24,
    "CreationDateTime": 21,
    "DeferredRecognitionGLCode": 37,
    "DeferredRevenueRecognition": 36,
    "DeletionAspNetUser_Id": 34,
    "DeletionDatetime": 33,
    "DueDateDays": 26,
    "DueDateSettings_Id": 27,
    "EndDate": 3,
    "FirstTrackingCategory": 16,
    "FlatRate": 6,
    "Id": 0,
    "IntroText": 29,
    "MarinaLocationId": 8,
    "MinimumFlatRatePerPeriod": 42,
    "OnlinePaymentCompletion": 25,
    "OnlinePaymentPlaceholder": 13,
    "PricePerFoot": 5,
    "RateDetails": 11,
    "RateShortName": 12,
    "RecordStatus_Id": 35,
    "RevenueGLCode": 30,
    "RevenueXeroAccountId": 40,
    "SV_InventoryCategory_Id": 19,
    "SV_InventorySubCategory_Id": 20,
    "SalesTaxGLCode": 32,
    "SeasonName": 1,
    "SeasonalChargeMethodId": 4,
    "SeasonalInvoicingMethod_Id": 18,
    "SecondTrackingCategory": 17,
    "ServicePackageSplit": 43,
    "StartDate": 2,
    "Tax": 10,
    "Taxable": 7,
    "TrackingCode": 38,
    "XeroId": 15,
    "XeroItemCode": 14,
    "XeroRecognitionAccountId": 39
}

schema_attributes:

{
    "ARGLCode": "string",
    "Active": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AspNetUser_Id": "string",
    "ChargeCategory": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDatetime": "string",
    "DueDateDays": "string",
    "DueDateSettings_Id": "string",
    "EndDate": "string",
    "FirstTrackingCategory": "string",
    "FlatRate": "string",
    "Id": "string",
    "IntroText": "string",
    "MarinaLocationId": "string",
    "MinimumFlatRatePerPeriod": "string",
    "OnlinePaymentCompletion": "string",
    "OnlinePaymentPlaceholder": "string",
    "PricePerFoot": "string",
    "RateDetails": "string",
    "RateShortName": "string",
    "RecordStatus_Id": "string",
    "RevenueGLCode": "string",
    "RevenueXeroAccountId": "string",
    "SV_InventoryCategory_Id": "string",
    "SV_InventorySubCategory_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonName": "string",
    "SeasonalChargeMethodId": "string",
    "SeasonalInvoicingMethod_Id": "string",
    "SecondTrackingCategory": "string",
    "ServicePackageSplit": "string",
    "StartDate": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackingCode": "string",
    "XeroId": "string",
    "XeroItemCode": "string",
    "XeroRecognitionAccountId": "string"
}

schema_name_id: 1678
schema_scan_id: 161841258
updated: 2026-04-11 03:07:29

Version 1709243

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalprices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalprices`\n(\n `Id`  string , `SeasonName`  string , `StartDate`  string , `EndDate`  string , `SeasonalChargeMethodId`  string , `PricePerFoot`  string , `FlatRate`  string , `Taxable`  string , `MarinaLocationId`  string , `Active`  string , `Tax`  string , `RateDetails`  string , `RateShortName`  string , `OnlinePaymentPlaceholder`  string , `XeroItemCode`  string , `XeroId`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `SeasonalInvoicingMethod_Id`  string , `SV_InventoryCategory_Id`  string , `SV_InventorySubCategory_Id`  string , `CreationDateTime`  string , `AspNetUser_Id`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `DueDateDays`  string , `DueDateSettings_Id`  string , `ChargeCategory`  string , `IntroText`  string , `RevenueGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `DeletionDatetime`  string , `DeletionAspNetUser_Id`  string , `RecordStatus_Id`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `XeroRecognitionAccountId`  string , `RevenueXeroAccountId`  string , `AllowPostingtoNonIncomeAccounts`  string , `MinimumFlatRatePerPeriod`  string , `ServicePackageSplit`  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_moloSeasonalPrices/2026-04-10/1775808233'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalprices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalPrices/2026-04-10/1775808233
id: 1709243
processed: 1

raw_data:

{
    "ARGLCode": 31,
    "Active": 9,
    "AllowPostingtoNonIncomeAccounts": 41,
    "AspNetUser_Id": 22,
    "ChargeCategory": 28,
    "CheckInTerms": 23,
    "CheckOutTerms": 24,
    "CreationDateTime": 21,
    "DeferredRecognitionGLCode": 37,
    "DeferredRevenueRecognition": 36,
    "DeletionAspNetUser_Id": 34,
    "DeletionDatetime": 33,
    "DueDateDays": 26,
    "DueDateSettings_Id": 27,
    "EndDate": 3,
    "FirstTrackingCategory": 16,
    "FlatRate": 6,
    "Id": 0,
    "IntroText": 29,
    "MarinaLocationId": 8,
    "MinimumFlatRatePerPeriod": 42,
    "OnlinePaymentCompletion": 25,
    "OnlinePaymentPlaceholder": 13,
    "PricePerFoot": 5,
    "RateDetails": 11,
    "RateShortName": 12,
    "RecordStatus_Id": 35,
    "RevenueGLCode": 30,
    "RevenueXeroAccountId": 40,
    "SV_InventoryCategory_Id": 19,
    "SV_InventorySubCategory_Id": 20,
    "SalesTaxGLCode": 32,
    "SeasonName": 1,
    "SeasonalChargeMethodId": 4,
    "SeasonalInvoicingMethod_Id": 18,
    "SecondTrackingCategory": 17,
    "ServicePackageSplit": 43,
    "StartDate": 2,
    "Tax": 10,
    "Taxable": 7,
    "TrackingCode": 38,
    "XeroId": 15,
    "XeroItemCode": 14,
    "XeroRecognitionAccountId": 39
}

schema_attributes:

{
    "ARGLCode": "string",
    "Active": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AspNetUser_Id": "string",
    "ChargeCategory": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDatetime": "string",
    "DueDateDays": "string",
    "DueDateSettings_Id": "string",
    "EndDate": "string",
    "FirstTrackingCategory": "string",
    "FlatRate": "string",
    "Id": "string",
    "IntroText": "string",
    "MarinaLocationId": "string",
    "MinimumFlatRatePerPeriod": "string",
    "OnlinePaymentCompletion": "string",
    "OnlinePaymentPlaceholder": "string",
    "PricePerFoot": "string",
    "RateDetails": "string",
    "RateShortName": "string",
    "RecordStatus_Id": "string",
    "RevenueGLCode": "string",
    "RevenueXeroAccountId": "string",
    "SV_InventoryCategory_Id": "string",
    "SV_InventorySubCategory_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonName": "string",
    "SeasonalChargeMethodId": "string",
    "SeasonalInvoicingMethod_Id": "string",
    "SecondTrackingCategory": "string",
    "ServicePackageSplit": "string",
    "StartDate": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackingCode": "string",
    "XeroId": "string",
    "XeroItemCode": "string",
    "XeroRecognitionAccountId": "string"
}

schema_name_id: 1678
schema_scan_id: 161785929
updated: 2026-04-10 03:06:15

Version 1708119

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalprices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalprices`\n(\n `Id`  string , `SeasonName`  string , `StartDate`  string , `EndDate`  string , `SeasonalChargeMethodId`  string , `PricePerFoot`  string , `FlatRate`  string , `Taxable`  string , `MarinaLocationId`  string , `Active`  string , `Tax`  string , `RateDetails`  string , `RateShortName`  string , `OnlinePaymentPlaceholder`  string , `XeroItemCode`  string , `XeroId`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `SeasonalInvoicingMethod_Id`  string , `SV_InventoryCategory_Id`  string , `SV_InventorySubCategory_Id`  string , `CreationDateTime`  string , `AspNetUser_Id`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `DueDateDays`  string , `DueDateSettings_Id`  string , `ChargeCategory`  string , `IntroText`  string , `RevenueGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `DeletionDatetime`  string , `DeletionAspNetUser_Id`  string , `RecordStatus_Id`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `XeroRecognitionAccountId`  string , `RevenueXeroAccountId`  string , `AllowPostingtoNonIncomeAccounts`  string , `MinimumFlatRatePerPeriod`  string , `ServicePackageSplit`  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_moloSeasonalPrices/2026-04-09/1775721566'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalprices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalPrices/2026-04-09/1775721566
id: 1708119
processed: 1

raw_data:

{
    "ARGLCode": 31,
    "Active": 9,
    "AllowPostingtoNonIncomeAccounts": 41,
    "AspNetUser_Id": 22,
    "ChargeCategory": 28,
    "CheckInTerms": 23,
    "CheckOutTerms": 24,
    "CreationDateTime": 21,
    "DeferredRecognitionGLCode": 37,
    "DeferredRevenueRecognition": 36,
    "DeletionAspNetUser_Id": 34,
    "DeletionDatetime": 33,
    "DueDateDays": 26,
    "DueDateSettings_Id": 27,
    "EndDate": 3,
    "FirstTrackingCategory": 16,
    "FlatRate": 6,
    "Id": 0,
    "IntroText": 29,
    "MarinaLocationId": 8,
    "MinimumFlatRatePerPeriod": 42,
    "OnlinePaymentCompletion": 25,
    "OnlinePaymentPlaceholder": 13,
    "PricePerFoot": 5,
    "RateDetails": 11,
    "RateShortName": 12,
    "RecordStatus_Id": 35,
    "RevenueGLCode": 30,
    "RevenueXeroAccountId": 40,
    "SV_InventoryCategory_Id": 19,
    "SV_InventorySubCategory_Id": 20,
    "SalesTaxGLCode": 32,
    "SeasonName": 1,
    "SeasonalChargeMethodId": 4,
    "SeasonalInvoicingMethod_Id": 18,
    "SecondTrackingCategory": 17,
    "ServicePackageSplit": 43,
    "StartDate": 2,
    "Tax": 10,
    "Taxable": 7,
    "TrackingCode": 38,
    "XeroId": 15,
    "XeroItemCode": 14,
    "XeroRecognitionAccountId": 39
}

schema_attributes:

{
    "ARGLCode": "string",
    "Active": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AspNetUser_Id": "string",
    "ChargeCategory": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDatetime": "string",
    "DueDateDays": "string",
    "DueDateSettings_Id": "string",
    "EndDate": "string",
    "FirstTrackingCategory": "string",
    "FlatRate": "string",
    "Id": "string",
    "IntroText": "string",
    "MarinaLocationId": "string",
    "MinimumFlatRatePerPeriod": "string",
    "OnlinePaymentCompletion": "string",
    "OnlinePaymentPlaceholder": "string",
    "PricePerFoot": "string",
    "RateDetails": "string",
    "RateShortName": "string",
    "RecordStatus_Id": "string",
    "RevenueGLCode": "string",
    "RevenueXeroAccountId": "string",
    "SV_InventoryCategory_Id": "string",
    "SV_InventorySubCategory_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonName": "string",
    "SeasonalChargeMethodId": "string",
    "SeasonalInvoicingMethod_Id": "string",
    "SecondTrackingCategory": "string",
    "ServicePackageSplit": "string",
    "StartDate": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackingCode": "string",
    "XeroId": "string",
    "XeroItemCode": "string",
    "XeroRecognitionAccountId": "string"
}

schema_name_id: 1678
schema_scan_id: 161730234
updated: 2026-04-09 03:03:20

Version 1707016

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalprices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalprices`\n(\n `Id`  string , `SeasonName`  string , `StartDate`  string , `EndDate`  string , `SeasonalChargeMethodId`  string , `PricePerFoot`  string , `FlatRate`  string , `Taxable`  string , `MarinaLocationId`  string , `Active`  string , `Tax`  string , `RateDetails`  string , `RateShortName`  string , `OnlinePaymentPlaceholder`  string , `XeroItemCode`  string , `XeroId`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `SeasonalInvoicingMethod_Id`  string , `SV_InventoryCategory_Id`  string , `SV_InventorySubCategory_Id`  string , `CreationDateTime`  string , `AspNetUser_Id`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `DueDateDays`  string , `DueDateSettings_Id`  string , `ChargeCategory`  string , `IntroText`  string , `RevenueGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `DeletionDatetime`  string , `DeletionAspNetUser_Id`  string , `RecordStatus_Id`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `XeroRecognitionAccountId`  string , `RevenueXeroAccountId`  string , `AllowPostingtoNonIncomeAccounts`  string , `MinimumFlatRatePerPeriod`  string , `ServicePackageSplit`  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_moloSeasonalPrices/2026-04-08/1775635395'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalprices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalPrices/2026-04-08/1775635395
id: 1707016
processed: 1

raw_data:

{
    "ARGLCode": 31,
    "Active": 9,
    "AllowPostingtoNonIncomeAccounts": 41,
    "AspNetUser_Id": 22,
    "ChargeCategory": 28,
    "CheckInTerms": 23,
    "CheckOutTerms": 24,
    "CreationDateTime": 21,
    "DeferredRecognitionGLCode": 37,
    "DeferredRevenueRecognition": 36,
    "DeletionAspNetUser_Id": 34,
    "DeletionDatetime": 33,
    "DueDateDays": 26,
    "DueDateSettings_Id": 27,
    "EndDate": 3,
    "FirstTrackingCategory": 16,
    "FlatRate": 6,
    "Id": 0,
    "IntroText": 29,
    "MarinaLocationId": 8,
    "MinimumFlatRatePerPeriod": 42,
    "OnlinePaymentCompletion": 25,
    "OnlinePaymentPlaceholder": 13,
    "PricePerFoot": 5,
    "RateDetails": 11,
    "RateShortName": 12,
    "RecordStatus_Id": 35,
    "RevenueGLCode": 30,
    "RevenueXeroAccountId": 40,
    "SV_InventoryCategory_Id": 19,
    "SV_InventorySubCategory_Id": 20,
    "SalesTaxGLCode": 32,
    "SeasonName": 1,
    "SeasonalChargeMethodId": 4,
    "SeasonalInvoicingMethod_Id": 18,
    "SecondTrackingCategory": 17,
    "ServicePackageSplit": 43,
    "StartDate": 2,
    "Tax": 10,
    "Taxable": 7,
    "TrackingCode": 38,
    "XeroId": 15,
    "XeroItemCode": 14,
    "XeroRecognitionAccountId": 39
}

schema_attributes:

{
    "ARGLCode": "string",
    "Active": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AspNetUser_Id": "string",
    "ChargeCategory": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDatetime": "string",
    "DueDateDays": "string",
    "DueDateSettings_Id": "string",
    "EndDate": "string",
    "FirstTrackingCategory": "string",
    "FlatRate": "string",
    "Id": "string",
    "IntroText": "string",
    "MarinaLocationId": "string",
    "MinimumFlatRatePerPeriod": "string",
    "OnlinePaymentCompletion": "string",
    "OnlinePaymentPlaceholder": "string",
    "PricePerFoot": "string",
    "RateDetails": "string",
    "RateShortName": "string",
    "RecordStatus_Id": "string",
    "RevenueGLCode": "string",
    "RevenueXeroAccountId": "string",
    "SV_InventoryCategory_Id": "string",
    "SV_InventorySubCategory_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonName": "string",
    "SeasonalChargeMethodId": "string",
    "SeasonalInvoicingMethod_Id": "string",
    "SecondTrackingCategory": "string",
    "ServicePackageSplit": "string",
    "StartDate": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackingCode": "string",
    "XeroId": "string",
    "XeroItemCode": "string",
    "XeroRecognitionAccountId": "string"
}

schema_name_id: 1678
schema_scan_id: 161675680
updated: 2026-04-08 03:10:20

Version 1705778

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalprices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalprices`\n(\n `Id`  string , `SeasonName`  string , `StartDate`  string , `EndDate`  string , `SeasonalChargeMethodId`  string , `PricePerFoot`  string , `FlatRate`  string , `Taxable`  string , `MarinaLocationId`  string , `Active`  string , `Tax`  string , `RateDetails`  string , `RateShortName`  string , `OnlinePaymentPlaceholder`  string , `XeroItemCode`  string , `XeroId`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `SeasonalInvoicingMethod_Id`  string , `SV_InventoryCategory_Id`  string , `SV_InventorySubCategory_Id`  string , `CreationDateTime`  string , `AspNetUser_Id`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `DueDateDays`  string , `DueDateSettings_Id`  string , `ChargeCategory`  string , `IntroText`  string , `RevenueGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `DeletionDatetime`  string , `DeletionAspNetUser_Id`  string , `RecordStatus_Id`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `XeroRecognitionAccountId`  string , `RevenueXeroAccountId`  string , `AllowPostingtoNonIncomeAccounts`  string , `MinimumFlatRatePerPeriod`  string , `ServicePackageSplit`  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_moloSeasonalPrices/2026-04-07/1775548551'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalprices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalPrices/2026-04-07/1775548551
id: 1705778
processed: 1

raw_data:

{
    "ARGLCode": 31,
    "Active": 9,
    "AllowPostingtoNonIncomeAccounts": 41,
    "AspNetUser_Id": 22,
    "ChargeCategory": 28,
    "CheckInTerms": 23,
    "CheckOutTerms": 24,
    "CreationDateTime": 21,
    "DeferredRecognitionGLCode": 37,
    "DeferredRevenueRecognition": 36,
    "DeletionAspNetUser_Id": 34,
    "DeletionDatetime": 33,
    "DueDateDays": 26,
    "DueDateSettings_Id": 27,
    "EndDate": 3,
    "FirstTrackingCategory": 16,
    "FlatRate": 6,
    "Id": 0,
    "IntroText": 29,
    "MarinaLocationId": 8,
    "MinimumFlatRatePerPeriod": 42,
    "OnlinePaymentCompletion": 25,
    "OnlinePaymentPlaceholder": 13,
    "PricePerFoot": 5,
    "RateDetails": 11,
    "RateShortName": 12,
    "RecordStatus_Id": 35,
    "RevenueGLCode": 30,
    "RevenueXeroAccountId": 40,
    "SV_InventoryCategory_Id": 19,
    "SV_InventorySubCategory_Id": 20,
    "SalesTaxGLCode": 32,
    "SeasonName": 1,
    "SeasonalChargeMethodId": 4,
    "SeasonalInvoicingMethod_Id": 18,
    "SecondTrackingCategory": 17,
    "ServicePackageSplit": 43,
    "StartDate": 2,
    "Tax": 10,
    "Taxable": 7,
    "TrackingCode": 38,
    "XeroId": 15,
    "XeroItemCode": 14,
    "XeroRecognitionAccountId": 39
}

schema_attributes:

{
    "ARGLCode": "string",
    "Active": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AspNetUser_Id": "string",
    "ChargeCategory": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDatetime": "string",
    "DueDateDays": "string",
    "DueDateSettings_Id": "string",
    "EndDate": "string",
    "FirstTrackingCategory": "string",
    "FlatRate": "string",
    "Id": "string",
    "IntroText": "string",
    "MarinaLocationId": "string",
    "MinimumFlatRatePerPeriod": "string",
    "OnlinePaymentCompletion": "string",
    "OnlinePaymentPlaceholder": "string",
    "PricePerFoot": "string",
    "RateDetails": "string",
    "RateShortName": "string",
    "RecordStatus_Id": "string",
    "RevenueGLCode": "string",
    "RevenueXeroAccountId": "string",
    "SV_InventoryCategory_Id": "string",
    "SV_InventorySubCategory_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonName": "string",
    "SeasonalChargeMethodId": "string",
    "SeasonalInvoicingMethod_Id": "string",
    "SecondTrackingCategory": "string",
    "ServicePackageSplit": "string",
    "StartDate": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackingCode": "string",
    "XeroId": "string",
    "XeroItemCode": "string",
    "XeroRecognitionAccountId": "string"
}

schema_name_id: 1678
schema_scan_id: 161618685
updated: 2026-04-07 03:00:05

Version 1704626

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalprices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalprices`\n(\n `Id`  string , `SeasonName`  string , `StartDate`  string , `EndDate`  string , `SeasonalChargeMethodId`  string , `PricePerFoot`  string , `FlatRate`  string , `Taxable`  string , `MarinaLocationId`  string , `Active`  string , `Tax`  string , `RateDetails`  string , `RateShortName`  string , `OnlinePaymentPlaceholder`  string , `XeroItemCode`  string , `XeroId`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `SeasonalInvoicingMethod_Id`  string , `SV_InventoryCategory_Id`  string , `SV_InventorySubCategory_Id`  string , `CreationDateTime`  string , `AspNetUser_Id`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `DueDateDays`  string , `DueDateSettings_Id`  string , `ChargeCategory`  string , `IntroText`  string , `RevenueGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `DeletionDatetime`  string , `DeletionAspNetUser_Id`  string , `RecordStatus_Id`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `XeroRecognitionAccountId`  string , `RevenueXeroAccountId`  string , `AllowPostingtoNonIncomeAccounts`  string , `MinimumFlatRatePerPeriod`  string , `ServicePackageSplit`  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_moloSeasonalPrices/2026-04-06/1775462510'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalprices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalPrices/2026-04-06/1775462510
id: 1704626
processed: 1

raw_data:

{
    "ARGLCode": 31,
    "Active": 9,
    "AllowPostingtoNonIncomeAccounts": 41,
    "AspNetUser_Id": 22,
    "ChargeCategory": 28,
    "CheckInTerms": 23,
    "CheckOutTerms": 24,
    "CreationDateTime": 21,
    "DeferredRecognitionGLCode": 37,
    "DeferredRevenueRecognition": 36,
    "DeletionAspNetUser_Id": 34,
    "DeletionDatetime": 33,
    "DueDateDays": 26,
    "DueDateSettings_Id": 27,
    "EndDate": 3,
    "FirstTrackingCategory": 16,
    "FlatRate": 6,
    "Id": 0,
    "IntroText": 29,
    "MarinaLocationId": 8,
    "MinimumFlatRatePerPeriod": 42,
    "OnlinePaymentCompletion": 25,
    "OnlinePaymentPlaceholder": 13,
    "PricePerFoot": 5,
    "RateDetails": 11,
    "RateShortName": 12,
    "RecordStatus_Id": 35,
    "RevenueGLCode": 30,
    "RevenueXeroAccountId": 40,
    "SV_InventoryCategory_Id": 19,
    "SV_InventorySubCategory_Id": 20,
    "SalesTaxGLCode": 32,
    "SeasonName": 1,
    "SeasonalChargeMethodId": 4,
    "SeasonalInvoicingMethod_Id": 18,
    "SecondTrackingCategory": 17,
    "ServicePackageSplit": 43,
    "StartDate": 2,
    "Tax": 10,
    "Taxable": 7,
    "TrackingCode": 38,
    "XeroId": 15,
    "XeroItemCode": 14,
    "XeroRecognitionAccountId": 39
}

schema_attributes:

{
    "ARGLCode": "string",
    "Active": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AspNetUser_Id": "string",
    "ChargeCategory": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDatetime": "string",
    "DueDateDays": "string",
    "DueDateSettings_Id": "string",
    "EndDate": "string",
    "FirstTrackingCategory": "string",
    "FlatRate": "string",
    "Id": "string",
    "IntroText": "string",
    "MarinaLocationId": "string",
    "MinimumFlatRatePerPeriod": "string",
    "OnlinePaymentCompletion": "string",
    "OnlinePaymentPlaceholder": "string",
    "PricePerFoot": "string",
    "RateDetails": "string",
    "RateShortName": "string",
    "RecordStatus_Id": "string",
    "RevenueGLCode": "string",
    "RevenueXeroAccountId": "string",
    "SV_InventoryCategory_Id": "string",
    "SV_InventorySubCategory_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonName": "string",
    "SeasonalChargeMethodId": "string",
    "SeasonalInvoicingMethod_Id": "string",
    "SecondTrackingCategory": "string",
    "ServicePackageSplit": "string",
    "StartDate": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackingCode": "string",
    "XeroId": "string",
    "XeroItemCode": "string",
    "XeroRecognitionAccountId": "string"
}

schema_name_id: 1678
schema_scan_id: 161561773
updated: 2026-04-06 03:11:21

Version 1703289

created: 2026-04-05 03:04:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalprices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalprices`\n(\n `Id`  string , `SeasonName`  string , `StartDate`  string , `EndDate`  string , `SeasonalChargeMethodId`  string , `PricePerFoot`  string , `FlatRate`  string , `Taxable`  string , `MarinaLocationId`  string , `Active`  string , `Tax`  string , `RateDetails`  string , `RateShortName`  string , `OnlinePaymentPlaceholder`  string , `XeroItemCode`  string , `XeroId`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `SeasonalInvoicingMethod_Id`  string , `SV_InventoryCategory_Id`  string , `SV_InventorySubCategory_Id`  string , `CreationDateTime`  string , `AspNetUser_Id`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `DueDateDays`  string , `DueDateSettings_Id`  string , `ChargeCategory`  string , `IntroText`  string , `RevenueGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `DeletionDatetime`  string , `DeletionAspNetUser_Id`  string , `RecordStatus_Id`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `XeroRecognitionAccountId`  string , `RevenueXeroAccountId`  string , `AllowPostingtoNonIncomeAccounts`  string , `MinimumFlatRatePerPeriod`  string , `ServicePackageSplit`  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_moloSeasonalPrices/2026-04-05/1775376137'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalprices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalPrices/2026-04-05/1775376137
id: 1703289
processed: 1

raw_data:

{
    "ARGLCode": 31,
    "Active": 9,
    "AllowPostingtoNonIncomeAccounts": 41,
    "AspNetUser_Id": 22,
    "ChargeCategory": 28,
    "CheckInTerms": 23,
    "CheckOutTerms": 24,
    "CreationDateTime": 21,
    "DeferredRecognitionGLCode": 37,
    "DeferredRevenueRecognition": 36,
    "DeletionAspNetUser_Id": 34,
    "DeletionDatetime": 33,
    "DueDateDays": 26,
    "DueDateSettings_Id": 27,
    "EndDate": 3,
    "FirstTrackingCategory": 16,
    "FlatRate": 6,
    "Id": 0,
    "IntroText": 29,
    "MarinaLocationId": 8,
    "MinimumFlatRatePerPeriod": 42,
    "OnlinePaymentCompletion": 25,
    "OnlinePaymentPlaceholder": 13,
    "PricePerFoot": 5,
    "RateDetails": 11,
    "RateShortName": 12,
    "RecordStatus_Id": 35,
    "RevenueGLCode": 30,
    "RevenueXeroAccountId": 40,
    "SV_InventoryCategory_Id": 19,
    "SV_InventorySubCategory_Id": 20,
    "SalesTaxGLCode": 32,
    "SeasonName": 1,
    "SeasonalChargeMethodId": 4,
    "SeasonalInvoicingMethod_Id": 18,
    "SecondTrackingCategory": 17,
    "ServicePackageSplit": 43,
    "StartDate": 2,
    "Tax": 10,
    "Taxable": 7,
    "TrackingCode": 38,
    "XeroId": 15,
    "XeroItemCode": 14,
    "XeroRecognitionAccountId": 39
}

schema_attributes:

{
    "ARGLCode": "string",
    "Active": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AspNetUser_Id": "string",
    "ChargeCategory": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDatetime": "string",
    "DueDateDays": "string",
    "DueDateSettings_Id": "string",
    "EndDate": "string",
    "FirstTrackingCategory": "string",
    "FlatRate": "string",
    "Id": "string",
    "IntroText": "string",
    "MarinaLocationId": "string",
    "MinimumFlatRatePerPeriod": "string",
    "OnlinePaymentCompletion": "string",
    "OnlinePaymentPlaceholder": "string",
    "PricePerFoot": "string",
    "RateDetails": "string",
    "RateShortName": "string",
    "RecordStatus_Id": "string",
    "RevenueGLCode": "string",
    "RevenueXeroAccountId": "string",
    "SV_InventoryCategory_Id": "string",
    "SV_InventorySubCategory_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonName": "string",
    "SeasonalChargeMethodId": "string",
    "SeasonalInvoicingMethod_Id": "string",
    "SecondTrackingCategory": "string",
    "ServicePackageSplit": "string",
    "StartDate": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackingCode": "string",
    "XeroId": "string",
    "XeroItemCode": "string",
    "XeroRecognitionAccountId": "string"
}

schema_name_id: 1678
schema_scan_id: 161514866
updated: 2026-04-05 03:04:54

Version 1702212

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalprices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalprices`\n(\n `Id`  string , `SeasonName`  string , `StartDate`  string , `EndDate`  string , `SeasonalChargeMethodId`  string , `PricePerFoot`  string , `FlatRate`  string , `Taxable`  string , `MarinaLocationId`  string , `Active`  string , `Tax`  string , `RateDetails`  string , `RateShortName`  string , `OnlinePaymentPlaceholder`  string , `XeroItemCode`  string , `XeroId`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `SeasonalInvoicingMethod_Id`  string , `SV_InventoryCategory_Id`  string , `SV_InventorySubCategory_Id`  string , `CreationDateTime`  string , `AspNetUser_Id`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `DueDateDays`  string , `DueDateSettings_Id`  string , `ChargeCategory`  string , `IntroText`  string , `RevenueGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `DeletionDatetime`  string , `DeletionAspNetUser_Id`  string , `RecordStatus_Id`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `XeroRecognitionAccountId`  string , `RevenueXeroAccountId`  string , `AllowPostingtoNonIncomeAccounts`  string , `MinimumFlatRatePerPeriod`  string , `ServicePackageSplit`  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_moloSeasonalPrices/2026-04-04/1775289620'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalprices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalPrices/2026-04-04/1775289620
id: 1702212
processed: 1

raw_data:

{
    "ARGLCode": 31,
    "Active": 9,
    "AllowPostingtoNonIncomeAccounts": 41,
    "AspNetUser_Id": 22,
    "ChargeCategory": 28,
    "CheckInTerms": 23,
    "CheckOutTerms": 24,
    "CreationDateTime": 21,
    "DeferredRecognitionGLCode": 37,
    "DeferredRevenueRecognition": 36,
    "DeletionAspNetUser_Id": 34,
    "DeletionDatetime": 33,
    "DueDateDays": 26,
    "DueDateSettings_Id": 27,
    "EndDate": 3,
    "FirstTrackingCategory": 16,
    "FlatRate": 6,
    "Id": 0,
    "IntroText": 29,
    "MarinaLocationId": 8,
    "MinimumFlatRatePerPeriod": 42,
    "OnlinePaymentCompletion": 25,
    "OnlinePaymentPlaceholder": 13,
    "PricePerFoot": 5,
    "RateDetails": 11,
    "RateShortName": 12,
    "RecordStatus_Id": 35,
    "RevenueGLCode": 30,
    "RevenueXeroAccountId": 40,
    "SV_InventoryCategory_Id": 19,
    "SV_InventorySubCategory_Id": 20,
    "SalesTaxGLCode": 32,
    "SeasonName": 1,
    "SeasonalChargeMethodId": 4,
    "SeasonalInvoicingMethod_Id": 18,
    "SecondTrackingCategory": 17,
    "ServicePackageSplit": 43,
    "StartDate": 2,
    "Tax": 10,
    "Taxable": 7,
    "TrackingCode": 38,
    "XeroId": 15,
    "XeroItemCode": 14,
    "XeroRecognitionAccountId": 39
}

schema_attributes:

{
    "ARGLCode": "string",
    "Active": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AspNetUser_Id": "string",
    "ChargeCategory": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDatetime": "string",
    "DueDateDays": "string",
    "DueDateSettings_Id": "string",
    "EndDate": "string",
    "FirstTrackingCategory": "string",
    "FlatRate": "string",
    "Id": "string",
    "IntroText": "string",
    "MarinaLocationId": "string",
    "MinimumFlatRatePerPeriod": "string",
    "OnlinePaymentCompletion": "string",
    "OnlinePaymentPlaceholder": "string",
    "PricePerFoot": "string",
    "RateDetails": "string",
    "RateShortName": "string",
    "RecordStatus_Id": "string",
    "RevenueGLCode": "string",
    "RevenueXeroAccountId": "string",
    "SV_InventoryCategory_Id": "string",
    "SV_InventorySubCategory_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonName": "string",
    "SeasonalChargeMethodId": "string",
    "SeasonalInvoicingMethod_Id": "string",
    "SecondTrackingCategory": "string",
    "ServicePackageSplit": "string",
    "StartDate": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackingCode": "string",
    "XeroId": "string",
    "XeroItemCode": "string",
    "XeroRecognitionAccountId": "string"
}

schema_name_id: 1678
schema_scan_id: 161460498
updated: 2026-04-04 03:08:20

Version 1701015

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalprices`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalprices`\n(\n `Id`  string , `SeasonName`  string , `StartDate`  string , `EndDate`  string , `SeasonalChargeMethodId`  string , `PricePerFoot`  string , `FlatRate`  string , `Taxable`  string , `MarinaLocationId`  string , `Active`  string , `Tax`  string , `RateDetails`  string , `RateShortName`  string , `OnlinePaymentPlaceholder`  string , `XeroItemCode`  string , `XeroId`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `SeasonalInvoicingMethod_Id`  string , `SV_InventoryCategory_Id`  string , `SV_InventorySubCategory_Id`  string , `CreationDateTime`  string , `AspNetUser_Id`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `DueDateDays`  string , `DueDateSettings_Id`  string , `ChargeCategory`  string , `IntroText`  string , `RevenueGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `DeletionDatetime`  string , `DeletionAspNetUser_Id`  string , `RecordStatus_Id`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `XeroRecognitionAccountId`  string , `RevenueXeroAccountId`  string , `AllowPostingtoNonIncomeAccounts`  string , `MinimumFlatRatePerPeriod`  string , `ServicePackageSplit`  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_moloSeasonalPrices/2026-04-03/1775203393'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalprices"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalPrices/2026-04-03/1775203393
id: 1701015
processed: 1

raw_data:

{
    "ARGLCode": 31,
    "Active": 9,
    "AllowPostingtoNonIncomeAccounts": 41,
    "AspNetUser_Id": 22,
    "ChargeCategory": 28,
    "CheckInTerms": 23,
    "CheckOutTerms": 24,
    "CreationDateTime": 21,
    "DeferredRecognitionGLCode": 37,
    "DeferredRevenueRecognition": 36,
    "DeletionAspNetUser_Id": 34,
    "DeletionDatetime": 33,
    "DueDateDays": 26,
    "DueDateSettings_Id": 27,
    "EndDate": 3,
    "FirstTrackingCategory": 16,
    "FlatRate": 6,
    "Id": 0,
    "IntroText": 29,
    "MarinaLocationId": 8,
    "MinimumFlatRatePerPeriod": 42,
    "OnlinePaymentCompletion": 25,
    "OnlinePaymentPlaceholder": 13,
    "PricePerFoot": 5,
    "RateDetails": 11,
    "RateShortName": 12,
    "RecordStatus_Id": 35,
    "RevenueGLCode": 30,
    "RevenueXeroAccountId": 40,
    "SV_InventoryCategory_Id": 19,
    "SV_InventorySubCategory_Id": 20,
    "SalesTaxGLCode": 32,
    "SeasonName": 1,
    "SeasonalChargeMethodId": 4,
    "SeasonalInvoicingMethod_Id": 18,
    "SecondTrackingCategory": 17,
    "ServicePackageSplit": 43,
    "StartDate": 2,
    "Tax": 10,
    "Taxable": 7,
    "TrackingCode": 38,
    "XeroId": 15,
    "XeroItemCode": 14,
    "XeroRecognitionAccountId": 39
}

schema_attributes:

{
    "ARGLCode": "string",
    "Active": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AspNetUser_Id": "string",
    "ChargeCategory": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDatetime": "string",
    "DueDateDays": "string",
    "DueDateSettings_Id": "string",
    "EndDate": "string",
    "FirstTrackingCategory": "string",
    "FlatRate": "string",
    "Id": "string",
    "IntroText": "string",
    "MarinaLocationId": "string",
    "MinimumFlatRatePerPeriod": "string",
    "OnlinePaymentCompletion": "string",
    "OnlinePaymentPlaceholder": "string",
    "PricePerFoot": "string",
    "RateDetails": "string",
    "RateShortName": "string",
    "RecordStatus_Id": "string",
    "RevenueGLCode": "string",
    "RevenueXeroAccountId": "string",
    "SV_InventoryCategory_Id": "string",
    "SV_InventorySubCategory_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonName": "string",
    "SeasonalChargeMethodId": "string",
    "SeasonalInvoicingMethod_Id": "string",
    "SecondTrackingCategory": "string",
    "ServicePackageSplit": "string",
    "StartDate": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackingCode": "string",
    "XeroId": "string",
    "XeroItemCode": "string",
    "XeroRecognitionAccountId": "string"
}

schema_name_id: 1678
schema_scan_id: 161401989
updated: 2026-04-03 03:13:11

Schema Scans: 15

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

Scan 162167726

duration: 0:00:15.589252

exit_message:

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

id: 162167726

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_moloSeasonalPrices/2026-04-17/1776412849",
        "key": "raw/molo_moloSeasonalPrices/2026-04-17/1776412849/SeasonalPrices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalPrices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1106948323564316457,
        "service_name": "drive-thru",
        "span_id": 16034272651512909749,
        "trace_id": 13274892000461867295
    }
}

running: False
schema_name_id: 1678
start_time: 2026-04-17 03:08:29
success: True
trace_id: 13274892000461867295

Scan 162111901

duration: 0:00:15.290353

exit_message:

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

id: 162111901

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_moloSeasonalPrices/2026-04-16/1776326603",
        "key": "raw/molo_moloSeasonalPrices/2026-04-16/1776326603/SeasonalPrices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalPrices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13831589472994359594,
        "service_name": "drive-thru",
        "span_id": 6735342237209567263,
        "trace_id": 6449848404926350305
    }
}

running: False
schema_name_id: 1678
start_time: 2026-04-16 03:10:12
success: True
trace_id: 6449848404926350305

Scan 162056091

duration: 0:00:17.859402

exit_message:

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

id: 162056091

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_moloSeasonalPrices/2026-04-15/1776240073",
        "key": "raw/molo_moloSeasonalPrices/2026-04-15/1776240073/SeasonalPrices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalPrices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14854385070233020264,
        "service_name": "drive-thru",
        "span_id": 17289628256262341939,
        "trace_id": 11018780703726441736
    }
}

running: False
schema_name_id: 1678
start_time: 2026-04-15 03:09:20
success: True
trace_id: 11018780703726441736

Scan 162000615

duration: 0:00:12.708816

exit_message:

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

id: 162000615

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_moloSeasonalPrices/2026-04-14/1776153838",
        "key": "raw/molo_moloSeasonalPrices/2026-04-14/1776153838/SeasonalPrices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalPrices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9121427399550918691,
        "service_name": "drive-thru",
        "span_id": 12291251988528776680,
        "trace_id": 10206659596244717740
    }
}

running: False
schema_name_id: 1678
start_time: 2026-04-14 03:09:27
success: True
trace_id: 10206659596244717740

Scan 161942019

duration: 0:00:15.235329

exit_message:

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

id: 161942019

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_moloSeasonalPrices/2026-04-13/1776066997",
        "key": "raw/molo_moloSeasonalPrices/2026-04-13/1776066997/SeasonalPrices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalPrices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6195082898806925304,
        "service_name": "drive-thru",
        "span_id": 9359108105914813753,
        "trace_id": 6460465478246461759
    }
}

running: False
schema_name_id: 1678
start_time: 2026-04-13 03:01:14
success: True
trace_id: 6460465478246461759

Scan 161892810

duration: 0:00:15.707472

exit_message:

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

id: 161892810

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_moloSeasonalPrices/2026-04-12/1775980708",
        "key": "raw/molo_moloSeasonalPrices/2026-04-12/1775980708/SeasonalPrices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalPrices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6449395388234921,
        "service_name": "drive-thru",
        "span_id": 9316334142247126763,
        "trace_id": 18009249413126402708
    }
}

running: False
schema_name_id: 1678
start_time: 2026-04-12 03:01:58
success: True
trace_id: 18009249413126402708

Scan 161841258

duration: 0:00:15.390262

exit_message:

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

id: 161841258

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_moloSeasonalPrices/2026-04-11/1775894475",
        "key": "raw/molo_moloSeasonalPrices/2026-04-11/1775894475/SeasonalPrices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalPrices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2055655850370572788,
        "service_name": "drive-thru",
        "span_id": 9081802659037765142,
        "trace_id": 11739601594292061413
    }
}

running: False
schema_name_id: 1678
start_time: 2026-04-11 03:07:14
success: True
trace_id: 11739601594292061413

Scan 161785929

duration: 0:00:15.612245

exit_message:

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

id: 161785929

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_moloSeasonalPrices/2026-04-10/1775808233",
        "key": "raw/molo_moloSeasonalPrices/2026-04-10/1775808233/SeasonalPrices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalPrices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1144176930123887774,
        "service_name": "drive-thru",
        "span_id": 9199704372234107003,
        "trace_id": 14082891553786867303
    }
}

running: False
schema_name_id: 1678
start_time: 2026-04-10 03:05:59
success: True
trace_id: 14082891553786867303

Scan 161730234

duration: 0:00:15.421736

exit_message:

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

id: 161730234

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_moloSeasonalPrices/2026-04-09/1775721566",
        "key": "raw/molo_moloSeasonalPrices/2026-04-09/1775721566/SeasonalPrices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalPrices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9786135512181106545,
        "service_name": "drive-thru",
        "span_id": 9995101560632423510,
        "trace_id": 1029816214930826423
    }
}

running: False
schema_name_id: 1678
start_time: 2026-04-09 03:03:05
success: True
trace_id: 1029816214930826423

Scan 161675680

duration: 0:00:12.908019

exit_message:

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

id: 161675680

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_moloSeasonalPrices/2026-04-08/1775635395",
        "key": "raw/molo_moloSeasonalPrices/2026-04-08/1775635395/SeasonalPrices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalPrices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 575721151480787831,
        "service_name": "drive-thru",
        "span_id": 8225581418929249184,
        "trace_id": 14536626699912920328
    }
}

running: False
schema_name_id: 1678
start_time: 2026-04-08 03:10:08
success: True
trace_id: 14536626699912920328

Scan 161618685

duration: 0:00:15.345616

exit_message:

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

id: 161618685

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_moloSeasonalPrices/2026-04-07/1775548551",
        "key": "raw/molo_moloSeasonalPrices/2026-04-07/1775548551/SeasonalPrices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalPrices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2180910094213087862,
        "service_name": "drive-thru",
        "span_id": 5801255822847647660,
        "trace_id": 469437050175172090
    }
}

running: False
schema_name_id: 1678
start_time: 2026-04-07 02:59:49
success: True
trace_id: 469437050175172090

Scan 161561773

duration: 0:00:15.320773

exit_message:

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

id: 161561773

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_moloSeasonalPrices/2026-04-06/1775462510",
        "key": "raw/molo_moloSeasonalPrices/2026-04-06/1775462510/SeasonalPrices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalPrices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7182242534584507348,
        "service_name": "drive-thru",
        "span_id": 17248650947147431122,
        "trace_id": 8381387652877932082
    }
}

running: False
schema_name_id: 1678
start_time: 2026-04-06 03:11:06
success: True
trace_id: 8381387652877932082

Scan 161514866

duration: 0:00:15.510012

exit_message:

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

id: 161514866

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_moloSeasonalPrices/2026-04-05/1775376137",
        "key": "raw/molo_moloSeasonalPrices/2026-04-05/1775376137/SeasonalPrices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalPrices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8368297900225229301,
        "service_name": "drive-thru",
        "span_id": 465949225324124210,
        "trace_id": 5735926297459910394
    }
}

running: False
schema_name_id: 1678
start_time: 2026-04-05 03:04:39
success: True
trace_id: 5735926297459910394

Scan 161460498

duration: 0:00:13.056565

exit_message:

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

id: 161460498

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_moloSeasonalPrices/2026-04-04/1775289620",
        "key": "raw/molo_moloSeasonalPrices/2026-04-04/1775289620/SeasonalPrices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalPrices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1665668796922157117,
        "service_name": "drive-thru",
        "span_id": 3939401797457752748,
        "trace_id": 10081346107115516298
    }
}

running: False
schema_name_id: 1678
start_time: 2026-04-04 03:08:07
success: True
trace_id: 10081346107115516298

Scan 161401989

duration: 0:00:15.321648

exit_message:

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

id: 161401989

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_moloSeasonalPrices/2026-04-03/1775203393",
        "key": "raw/molo_moloSeasonalPrices/2026-04-03/1775203393/SeasonalPrices.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSeasonalPrices",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 814979679491176694,
        "service_name": "drive-thru",
        "span_id": 2979726241595685487,
        "trace_id": 1854117045629381399
    }
}

running: False
schema_name_id: 1678
start_time: 2026-04-03 03:12:56
success: True
trace_id: 1854117045629381399

Partitions:

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

Schema:

attributes:

{
    "ARGLCode": "string",
    "Active": "string",
    "AllowPostingtoNonIncomeAccounts": "string",
    "AspNetUser_Id": "string",
    "ChargeCategory": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "CreationDateTime": "string",
    "DeferredRecognitionGLCode": "string",
    "DeferredRevenueRecognition": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDatetime": "string",
    "DueDateDays": "string",
    "DueDateSettings_Id": "string",
    "EndDate": "string",
    "FirstTrackingCategory": "string",
    "FlatRate": "string",
    "Id": "string",
    "IntroText": "string",
    "MarinaLocationId": "string",
    "MinimumFlatRatePerPeriod": "string",
    "OnlinePaymentCompletion": "string",
    "OnlinePaymentPlaceholder": "string",
    "PricePerFoot": "string",
    "RateDetails": "string",
    "RateShortName": "string",
    "RecordStatus_Id": "string",
    "RevenueGLCode": "string",
    "RevenueXeroAccountId": "string",
    "SV_InventoryCategory_Id": "string",
    "SV_InventorySubCategory_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonName": "string",
    "SeasonalChargeMethodId": "string",
    "SeasonalInvoicingMethod_Id": "string",
    "SecondTrackingCategory": "string",
    "ServicePackageSplit": "string",
    "StartDate": "string",
    "Tax": "string",
    "Taxable": "string",
    "TrackingCode": "string",
    "XeroId": "string",
    "XeroItemCode": "string",
    "XeroRecognitionAccountId": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalprices`\n(\n `Id`  string , `SeasonName`  string , `StartDate`  string , `EndDate`  string , `SeasonalChargeMethodId`  string , `PricePerFoot`  string , `FlatRate`  string , `Taxable`  string , `MarinaLocationId`  string , `Active`  string , `Tax`  string , `RateDetails`  string , `RateShortName`  string , `OnlinePaymentPlaceholder`  string , `XeroItemCode`  string , `XeroId`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `SeasonalInvoicingMethod_Id`  string , `SV_InventoryCategory_Id`  string , `SV_InventorySubCategory_Id`  string , `CreationDateTime`  string , `AspNetUser_Id`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `DueDateDays`  string , `DueDateSettings_Id`  string , `ChargeCategory`  string , `IntroText`  string , `RevenueGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `DeletionDatetime`  string , `DeletionAspNetUser_Id`  string , `RecordStatus_Id`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `XeroRecognitionAccountId`  string , `RevenueXeroAccountId`  string , `AllowPostingtoNonIncomeAccounts`  string , `MinimumFlatRatePerPeriod`  string , `ServicePackageSplit`  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_moloSeasonalPrices/2026-04-17/1776412849'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalprices`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalprices"
}

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:58:07",
        "disabled": false,
        "format": "raw",
        "id": 1678,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloseasonalprices"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "ARGLCode": "string",
            "Active": "string",
            "AllowPostingtoNonIncomeAccounts": "string",
            "AspNetUser_Id": "string",
            "ChargeCategory": "string",
            "CheckInTerms": "string",
            "CheckOutTerms": "string",
            "CreationDateTime": "string",
            "DeferredRecognitionGLCode": "string",
            "DeferredRevenueRecognition": "string",
            "DeletionAspNetUser_Id": "string",
            "DeletionDatetime": "string",
            "DueDateDays": "string",
            "DueDateSettings_Id": "string",
            "EndDate": "string",
            "FirstTrackingCategory": "string",
            "FlatRate": "string",
            "Id": "string",
            "IntroText": "string",
            "MarinaLocationId": "string",
            "MinimumFlatRatePerPeriod": "string",
            "OnlinePaymentCompletion": "string",
            "OnlinePaymentPlaceholder": "string",
            "PricePerFoot": "string",
            "RateDetails": "string",
            "RateShortName": "string",
            "RecordStatus_Id": "string",
            "RevenueGLCode": "string",
            "RevenueXeroAccountId": "string",
            "SV_InventoryCategory_Id": "string",
            "SV_InventorySubCategory_Id": "string",
            "SalesTaxGLCode": "string",
            "SeasonName": "string",
            "SeasonalChargeMethodId": "string",
            "SeasonalInvoicingMethod_Id": "string",
            "SecondTrackingCategory": "string",
            "ServicePackageSplit": "string",
            "StartDate": "string",
            "Tax": "string",
            "Taxable": "string",
            "TrackingCode": "string",
            "XeroId": "string",
            "XeroItemCode": "string",
            "XeroRecognitionAccountId": "string"
        },
        "created": "2026-04-17 03:08:30",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalprices`\n(\n `Id`  string , `SeasonName`  string , `StartDate`  string , `EndDate`  string , `SeasonalChargeMethodId`  string , `PricePerFoot`  string , `FlatRate`  string , `Taxable`  string , `MarinaLocationId`  string , `Active`  string , `Tax`  string , `RateDetails`  string , `RateShortName`  string , `OnlinePaymentPlaceholder`  string , `XeroItemCode`  string , `XeroId`  string , `FirstTrackingCategory`  string , `SecondTrackingCategory`  string , `SeasonalInvoicingMethod_Id`  string , `SV_InventoryCategory_Id`  string , `SV_InventorySubCategory_Id`  string , `CreationDateTime`  string , `AspNetUser_Id`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `DueDateDays`  string , `DueDateSettings_Id`  string , `ChargeCategory`  string , `IntroText`  string , `RevenueGLCode`  string , `ARGLCode`  string , `SalesTaxGLCode`  string , `DeletionDatetime`  string , `DeletionAspNetUser_Id`  string , `RecordStatus_Id`  string , `DeferredRevenueRecognition`  string , `DeferredRecognitionGLCode`  string , `TrackingCode`  string , `XeroRecognitionAccountId`  string , `RevenueXeroAccountId`  string , `AllowPostingtoNonIncomeAccounts`  string , `MinimumFlatRatePerPeriod`  string , `ServicePackageSplit`  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_moloSeasonalPrices/2026-04-17/1776412849'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalprices`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalprices"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}