Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloinvoiceset

created: 2023-10-17 01:57:03
disabled: False
format: raw
id: 1649
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717642

created: 2026-04-17 03:04:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceset`\n(\n `Id`  string , `Date`  string , `DolarDiscount`  string , `PercentDiscount`  string , `Active`  string , `ClosingDate`  string , `DiscountTotal`  string , `Opened`  string , `Payed`  string , `Subtotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Title`  string , `Total`  string , `ReservationId`  string , `AccountId`  string , `ServicePaidAmount`  string , `MarinaPaidAmount`  string , `GasPaidAmount`  string , `InvoiceStatusId`  string , `StartDate`  string , `InstalmentsPaymentMethodId`  string , `ScheduledForCron`  string , `OriginalInvoice`  string , `PaymentsSentToXero`  string , `WorkOrderId`  string , `IsInstallmentInvoice`  string , `VoidUser`  string , `VoidDateTime`  string , `CreationUser`  string , `Payment_Id`  string , `QB_Invoice_Id`  string , `InvoiceType_Id`  string , `InvoiceDate`  string , `DueDate`  string , `CurrencyCode`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `VoidReason`  string , `CreatePartnerId`  string , `VoidPartnerId`  string , `UpdateHash`  string , `ScheduledForInventoryCron`  string , `ScheduledForSubletCron`  string , `ScheduledForLaborCron`  string , `CreatedOnMobile`  string , `StripeInvoiceId`  string , `SentToStripe`  string , `ResourceBookingId`  string , `ModifiedOnMobile`  string , `Note`  string , `QuickbooksInvoiceId`  string , `TaxCap`  string , `IsSurcharge`  string , `HashCheck`  string , `IsReversed`  string , `SurchargeInvoiceId`  string , `MarinaLocationId`  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_moloInvoiceSet/2026-04-17/1776412797'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceSet/2026-04-17/1776412797
id: 1717642
processed: 1

raw_data:

{
    "AccountId": 15,
    "Active": 4,
    "ClosingDate": 5,
    "CreatePartnerId": 39,
    "CreatedOnMobile": 45,
    "CreationUser": 29,
    "CurrencyCode": 35,
    "Date": 1,
    "DiscountTotal": 6,
    "DolarDiscount": 2,
    "DueDate": 34,
    "GasPaidAmount": 18,
    "HashCheck": 54,
    "Id": 0,
    "InstalmentsPaymentMethodId": 21,
    "InvoiceDate": 33,
    "InvoiceStatusId": 19,
    "InvoiceType_Id": 32,
    "IsInstallmentInvoice": 26,
    "IsReversed": 55,
    "IsSurcharge": 53,
    "LastModifiedAspNetUser": 37,
    "LastModifiedDateTime": 36,
    "MarinaLocationId": 57,
    "MarinaPaidAmount": 17,
    "ModifiedOnMobile": 49,
    "Note": 50,
    "Opened": 7,
    "OriginalInvoice": 23,
    "Payed": 8,
    "Payment_Id": 30,
    "PaymentsSentToXero": 24,
    "PercentDiscount": 3,
    "QB_Invoice_Id": 31,
    "QuickbooksInvoiceId": 51,
    "ReservationId": 14,
    "ResourceBookingId": 48,
    "ScheduledForCron": 22,
    "ScheduledForInventoryCron": 42,
    "ScheduledForLaborCron": 44,
    "ScheduledForSubletCron": 43,
    "SentToStripe": 47,
    "ServicePaidAmount": 16,
    "StartDate": 20,
    "StripeInvoiceId": 46,
    "Subtotal": 9,
    "SubtotalWoDiscount": 10,
    "SurchargeInvoiceId": 56,
    "TaxCap": 52,
    "TaxTotal": 11,
    "Title": 12,
    "Total": 13,
    "UpdateHash": 41,
    "VoidDateTime": 28,
    "VoidPartnerId": 40,
    "VoidReason": 38,
    "VoidUser": 27,
    "WorkOrderId": 25
}

schema_attributes:

{
    "AccountId": "string",
    "Active": "string",
    "ClosingDate": "string",
    "CreatePartnerId": "string",
    "CreatedOnMobile": "string",
    "CreationUser": "string",
    "CurrencyCode": "string",
    "Date": "string",
    "DiscountTotal": "string",
    "DolarDiscount": "string",
    "DueDate": "string",
    "GasPaidAmount": "string",
    "HashCheck": "string",
    "Id": "string",
    "InstalmentsPaymentMethodId": "string",
    "InvoiceDate": "string",
    "InvoiceStatusId": "string",
    "InvoiceType_Id": "string",
    "IsInstallmentInvoice": "string",
    "IsReversed": "string",
    "IsSurcharge": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "MarinaLocationId": "string",
    "MarinaPaidAmount": "string",
    "ModifiedOnMobile": "string",
    "Note": "string",
    "Opened": "string",
    "OriginalInvoice": "string",
    "Payed": "string",
    "Payment_Id": "string",
    "PaymentsSentToXero": "string",
    "PercentDiscount": "string",
    "QB_Invoice_Id": "string",
    "QuickbooksInvoiceId": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string",
    "ScheduledForCron": "string",
    "ScheduledForInventoryCron": "string",
    "ScheduledForLaborCron": "string",
    "ScheduledForSubletCron": "string",
    "SentToStripe": "string",
    "ServicePaidAmount": "string",
    "StartDate": "string",
    "StripeInvoiceId": "string",
    "Subtotal": "string",
    "SubtotalWoDiscount": "string",
    "SurchargeInvoiceId": "string",
    "TaxCap": "string",
    "TaxTotal": "string",
    "Title": "string",
    "Total": "string",
    "UpdateHash": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string",
    "WorkOrderId": "string"
}

schema_name_id: 1649
schema_scan_id: 162167600
updated: 2026-04-17 03:04:59

Version 1716367

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceset`\n(\n `Id`  string , `Date`  string , `DolarDiscount`  string , `PercentDiscount`  string , `Active`  string , `ClosingDate`  string , `DiscountTotal`  string , `Opened`  string , `Payed`  string , `Subtotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Title`  string , `Total`  string , `ReservationId`  string , `AccountId`  string , `ServicePaidAmount`  string , `MarinaPaidAmount`  string , `GasPaidAmount`  string , `InvoiceStatusId`  string , `StartDate`  string , `InstalmentsPaymentMethodId`  string , `ScheduledForCron`  string , `OriginalInvoice`  string , `PaymentsSentToXero`  string , `WorkOrderId`  string , `IsInstallmentInvoice`  string , `VoidUser`  string , `VoidDateTime`  string , `CreationUser`  string , `Payment_Id`  string , `QB_Invoice_Id`  string , `InvoiceType_Id`  string , `InvoiceDate`  string , `DueDate`  string , `CurrencyCode`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `VoidReason`  string , `CreatePartnerId`  string , `VoidPartnerId`  string , `UpdateHash`  string , `ScheduledForInventoryCron`  string , `ScheduledForSubletCron`  string , `ScheduledForLaborCron`  string , `CreatedOnMobile`  string , `StripeInvoiceId`  string , `SentToStripe`  string , `ResourceBookingId`  string , `ModifiedOnMobile`  string , `Note`  string , `QuickbooksInvoiceId`  string , `TaxCap`  string , `IsSurcharge`  string , `HashCheck`  string , `IsReversed`  string , `SurchargeInvoiceId`  string , `MarinaLocationId`  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_moloInvoiceSet/2026-04-16/1776326554'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceSet/2026-04-16/1776326554
id: 1716367
processed: 1

raw_data:

{
    "AccountId": 15,
    "Active": 4,
    "ClosingDate": 5,
    "CreatePartnerId": 39,
    "CreatedOnMobile": 45,
    "CreationUser": 29,
    "CurrencyCode": 35,
    "Date": 1,
    "DiscountTotal": 6,
    "DolarDiscount": 2,
    "DueDate": 34,
    "GasPaidAmount": 18,
    "HashCheck": 54,
    "Id": 0,
    "InstalmentsPaymentMethodId": 21,
    "InvoiceDate": 33,
    "InvoiceStatusId": 19,
    "InvoiceType_Id": 32,
    "IsInstallmentInvoice": 26,
    "IsReversed": 55,
    "IsSurcharge": 53,
    "LastModifiedAspNetUser": 37,
    "LastModifiedDateTime": 36,
    "MarinaLocationId": 57,
    "MarinaPaidAmount": 17,
    "ModifiedOnMobile": 49,
    "Note": 50,
    "Opened": 7,
    "OriginalInvoice": 23,
    "Payed": 8,
    "Payment_Id": 30,
    "PaymentsSentToXero": 24,
    "PercentDiscount": 3,
    "QB_Invoice_Id": 31,
    "QuickbooksInvoiceId": 51,
    "ReservationId": 14,
    "ResourceBookingId": 48,
    "ScheduledForCron": 22,
    "ScheduledForInventoryCron": 42,
    "ScheduledForLaborCron": 44,
    "ScheduledForSubletCron": 43,
    "SentToStripe": 47,
    "ServicePaidAmount": 16,
    "StartDate": 20,
    "StripeInvoiceId": 46,
    "Subtotal": 9,
    "SubtotalWoDiscount": 10,
    "SurchargeInvoiceId": 56,
    "TaxCap": 52,
    "TaxTotal": 11,
    "Title": 12,
    "Total": 13,
    "UpdateHash": 41,
    "VoidDateTime": 28,
    "VoidPartnerId": 40,
    "VoidReason": 38,
    "VoidUser": 27,
    "WorkOrderId": 25
}

schema_attributes:

{
    "AccountId": "string",
    "Active": "string",
    "ClosingDate": "string",
    "CreatePartnerId": "string",
    "CreatedOnMobile": "string",
    "CreationUser": "string",
    "CurrencyCode": "string",
    "Date": "string",
    "DiscountTotal": "string",
    "DolarDiscount": "string",
    "DueDate": "string",
    "GasPaidAmount": "string",
    "HashCheck": "string",
    "Id": "string",
    "InstalmentsPaymentMethodId": "string",
    "InvoiceDate": "string",
    "InvoiceStatusId": "string",
    "InvoiceType_Id": "string",
    "IsInstallmentInvoice": "string",
    "IsReversed": "string",
    "IsSurcharge": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "MarinaLocationId": "string",
    "MarinaPaidAmount": "string",
    "ModifiedOnMobile": "string",
    "Note": "string",
    "Opened": "string",
    "OriginalInvoice": "string",
    "Payed": "string",
    "Payment_Id": "string",
    "PaymentsSentToXero": "string",
    "PercentDiscount": "string",
    "QB_Invoice_Id": "string",
    "QuickbooksInvoiceId": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string",
    "ScheduledForCron": "string",
    "ScheduledForInventoryCron": "string",
    "ScheduledForLaborCron": "string",
    "ScheduledForSubletCron": "string",
    "SentToStripe": "string",
    "ServicePaidAmount": "string",
    "StartDate": "string",
    "StripeInvoiceId": "string",
    "Subtotal": "string",
    "SubtotalWoDiscount": "string",
    "SurchargeInvoiceId": "string",
    "TaxCap": "string",
    "TaxTotal": "string",
    "Title": "string",
    "Total": "string",
    "UpdateHash": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string",
    "WorkOrderId": "string"
}

schema_name_id: 1649
schema_scan_id: 162111763
updated: 2026-04-16 03:06:27

Version 1715211

created: 2026-04-15 03:05:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceset`\n(\n `Id`  string , `Date`  string , `DolarDiscount`  string , `PercentDiscount`  string , `Active`  string , `ClosingDate`  string , `DiscountTotal`  string , `Opened`  string , `Payed`  string , `Subtotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Title`  string , `Total`  string , `ReservationId`  string , `AccountId`  string , `ServicePaidAmount`  string , `MarinaPaidAmount`  string , `GasPaidAmount`  string , `InvoiceStatusId`  string , `StartDate`  string , `InstalmentsPaymentMethodId`  string , `ScheduledForCron`  string , `OriginalInvoice`  string , `PaymentsSentToXero`  string , `WorkOrderId`  string , `IsInstallmentInvoice`  string , `VoidUser`  string , `VoidDateTime`  string , `CreationUser`  string , `Payment_Id`  string , `QB_Invoice_Id`  string , `InvoiceType_Id`  string , `InvoiceDate`  string , `DueDate`  string , `CurrencyCode`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `VoidReason`  string , `CreatePartnerId`  string , `VoidPartnerId`  string , `UpdateHash`  string , `ScheduledForInventoryCron`  string , `ScheduledForSubletCron`  string , `ScheduledForLaborCron`  string , `CreatedOnMobile`  string , `StripeInvoiceId`  string , `SentToStripe`  string , `ResourceBookingId`  string , `ModifiedOnMobile`  string , `Note`  string , `QuickbooksInvoiceId`  string , `TaxCap`  string , `IsSurcharge`  string , `HashCheck`  string , `IsReversed`  string , `SurchargeInvoiceId`  string , `MarinaLocationId`  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_moloInvoiceSet/2026-04-15/1776240023'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceSet/2026-04-15/1776240023
id: 1715211
processed: 1

raw_data:

{
    "AccountId": 15,
    "Active": 4,
    "ClosingDate": 5,
    "CreatePartnerId": 39,
    "CreatedOnMobile": 45,
    "CreationUser": 29,
    "CurrencyCode": 35,
    "Date": 1,
    "DiscountTotal": 6,
    "DolarDiscount": 2,
    "DueDate": 34,
    "GasPaidAmount": 18,
    "HashCheck": 54,
    "Id": 0,
    "InstalmentsPaymentMethodId": 21,
    "InvoiceDate": 33,
    "InvoiceStatusId": 19,
    "InvoiceType_Id": 32,
    "IsInstallmentInvoice": 26,
    "IsReversed": 55,
    "IsSurcharge": 53,
    "LastModifiedAspNetUser": 37,
    "LastModifiedDateTime": 36,
    "MarinaLocationId": 57,
    "MarinaPaidAmount": 17,
    "ModifiedOnMobile": 49,
    "Note": 50,
    "Opened": 7,
    "OriginalInvoice": 23,
    "Payed": 8,
    "Payment_Id": 30,
    "PaymentsSentToXero": 24,
    "PercentDiscount": 3,
    "QB_Invoice_Id": 31,
    "QuickbooksInvoiceId": 51,
    "ReservationId": 14,
    "ResourceBookingId": 48,
    "ScheduledForCron": 22,
    "ScheduledForInventoryCron": 42,
    "ScheduledForLaborCron": 44,
    "ScheduledForSubletCron": 43,
    "SentToStripe": 47,
    "ServicePaidAmount": 16,
    "StartDate": 20,
    "StripeInvoiceId": 46,
    "Subtotal": 9,
    "SubtotalWoDiscount": 10,
    "SurchargeInvoiceId": 56,
    "TaxCap": 52,
    "TaxTotal": 11,
    "Title": 12,
    "Total": 13,
    "UpdateHash": 41,
    "VoidDateTime": 28,
    "VoidPartnerId": 40,
    "VoidReason": 38,
    "VoidUser": 27,
    "WorkOrderId": 25
}

schema_attributes:

{
    "AccountId": "string",
    "Active": "string",
    "ClosingDate": "string",
    "CreatePartnerId": "string",
    "CreatedOnMobile": "string",
    "CreationUser": "string",
    "CurrencyCode": "string",
    "Date": "string",
    "DiscountTotal": "string",
    "DolarDiscount": "string",
    "DueDate": "string",
    "GasPaidAmount": "string",
    "HashCheck": "string",
    "Id": "string",
    "InstalmentsPaymentMethodId": "string",
    "InvoiceDate": "string",
    "InvoiceStatusId": "string",
    "InvoiceType_Id": "string",
    "IsInstallmentInvoice": "string",
    "IsReversed": "string",
    "IsSurcharge": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "MarinaLocationId": "string",
    "MarinaPaidAmount": "string",
    "ModifiedOnMobile": "string",
    "Note": "string",
    "Opened": "string",
    "OriginalInvoice": "string",
    "Payed": "string",
    "Payment_Id": "string",
    "PaymentsSentToXero": "string",
    "PercentDiscount": "string",
    "QB_Invoice_Id": "string",
    "QuickbooksInvoiceId": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string",
    "ScheduledForCron": "string",
    "ScheduledForInventoryCron": "string",
    "ScheduledForLaborCron": "string",
    "ScheduledForSubletCron": "string",
    "SentToStripe": "string",
    "ServicePaidAmount": "string",
    "StartDate": "string",
    "StripeInvoiceId": "string",
    "Subtotal": "string",
    "SubtotalWoDiscount": "string",
    "SurchargeInvoiceId": "string",
    "TaxCap": "string",
    "TaxTotal": "string",
    "Title": "string",
    "Total": "string",
    "UpdateHash": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string",
    "WorkOrderId": "string"
}

schema_name_id: 1649
schema_scan_id: 162055928
updated: 2026-04-15 03:05:30

Version 1713978

created: 2026-04-14 03:04:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceset`\n(\n `Id`  string , `Date`  string , `DolarDiscount`  string , `PercentDiscount`  string , `Active`  string , `ClosingDate`  string , `DiscountTotal`  string , `Opened`  string , `Payed`  string , `Subtotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Title`  string , `Total`  string , `ReservationId`  string , `AccountId`  string , `ServicePaidAmount`  string , `MarinaPaidAmount`  string , `GasPaidAmount`  string , `InvoiceStatusId`  string , `StartDate`  string , `InstalmentsPaymentMethodId`  string , `ScheduledForCron`  string , `OriginalInvoice`  string , `PaymentsSentToXero`  string , `WorkOrderId`  string , `IsInstallmentInvoice`  string , `VoidUser`  string , `VoidDateTime`  string , `CreationUser`  string , `Payment_Id`  string , `QB_Invoice_Id`  string , `InvoiceType_Id`  string , `InvoiceDate`  string , `DueDate`  string , `CurrencyCode`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `VoidReason`  string , `CreatePartnerId`  string , `VoidPartnerId`  string , `UpdateHash`  string , `ScheduledForInventoryCron`  string , `ScheduledForSubletCron`  string , `ScheduledForLaborCron`  string , `CreatedOnMobile`  string , `StripeInvoiceId`  string , `SentToStripe`  string , `ResourceBookingId`  string , `ModifiedOnMobile`  string , `Note`  string , `QuickbooksInvoiceId`  string , `TaxCap`  string , `IsSurcharge`  string , `HashCheck`  string , `IsReversed`  string , `SurchargeInvoiceId`  string , `MarinaLocationId`  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_moloInvoiceSet/2026-04-14/1776153750'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceSet/2026-04-14/1776153750
id: 1713978
processed: 1

raw_data:

{
    "AccountId": 15,
    "Active": 4,
    "ClosingDate": 5,
    "CreatePartnerId": 39,
    "CreatedOnMobile": 45,
    "CreationUser": 29,
    "CurrencyCode": 35,
    "Date": 1,
    "DiscountTotal": 6,
    "DolarDiscount": 2,
    "DueDate": 34,
    "GasPaidAmount": 18,
    "HashCheck": 54,
    "Id": 0,
    "InstalmentsPaymentMethodId": 21,
    "InvoiceDate": 33,
    "InvoiceStatusId": 19,
    "InvoiceType_Id": 32,
    "IsInstallmentInvoice": 26,
    "IsReversed": 55,
    "IsSurcharge": 53,
    "LastModifiedAspNetUser": 37,
    "LastModifiedDateTime": 36,
    "MarinaLocationId": 57,
    "MarinaPaidAmount": 17,
    "ModifiedOnMobile": 49,
    "Note": 50,
    "Opened": 7,
    "OriginalInvoice": 23,
    "Payed": 8,
    "Payment_Id": 30,
    "PaymentsSentToXero": 24,
    "PercentDiscount": 3,
    "QB_Invoice_Id": 31,
    "QuickbooksInvoiceId": 51,
    "ReservationId": 14,
    "ResourceBookingId": 48,
    "ScheduledForCron": 22,
    "ScheduledForInventoryCron": 42,
    "ScheduledForLaborCron": 44,
    "ScheduledForSubletCron": 43,
    "SentToStripe": 47,
    "ServicePaidAmount": 16,
    "StartDate": 20,
    "StripeInvoiceId": 46,
    "Subtotal": 9,
    "SubtotalWoDiscount": 10,
    "SurchargeInvoiceId": 56,
    "TaxCap": 52,
    "TaxTotal": 11,
    "Title": 12,
    "Total": 13,
    "UpdateHash": 41,
    "VoidDateTime": 28,
    "VoidPartnerId": 40,
    "VoidReason": 38,
    "VoidUser": 27,
    "WorkOrderId": 25
}

schema_attributes:

{
    "AccountId": "string",
    "Active": "string",
    "ClosingDate": "string",
    "CreatePartnerId": "string",
    "CreatedOnMobile": "string",
    "CreationUser": "string",
    "CurrencyCode": "string",
    "Date": "string",
    "DiscountTotal": "string",
    "DolarDiscount": "string",
    "DueDate": "string",
    "GasPaidAmount": "string",
    "HashCheck": "string",
    "Id": "string",
    "InstalmentsPaymentMethodId": "string",
    "InvoiceDate": "string",
    "InvoiceStatusId": "string",
    "InvoiceType_Id": "string",
    "IsInstallmentInvoice": "string",
    "IsReversed": "string",
    "IsSurcharge": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "MarinaLocationId": "string",
    "MarinaPaidAmount": "string",
    "ModifiedOnMobile": "string",
    "Note": "string",
    "Opened": "string",
    "OriginalInvoice": "string",
    "Payed": "string",
    "Payment_Id": "string",
    "PaymentsSentToXero": "string",
    "PercentDiscount": "string",
    "QB_Invoice_Id": "string",
    "QuickbooksInvoiceId": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string",
    "ScheduledForCron": "string",
    "ScheduledForInventoryCron": "string",
    "ScheduledForLaborCron": "string",
    "ScheduledForSubletCron": "string",
    "SentToStripe": "string",
    "ServicePaidAmount": "string",
    "StartDate": "string",
    "StripeInvoiceId": "string",
    "Subtotal": "string",
    "SubtotalWoDiscount": "string",
    "SurchargeInvoiceId": "string",
    "TaxCap": "string",
    "TaxTotal": "string",
    "Title": "string",
    "Total": "string",
    "UpdateHash": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string",
    "WorkOrderId": "string"
}

schema_name_id: 1649
schema_scan_id: 162000409
updated: 2026-04-14 03:04:32

Version 1712819

created: 2026-04-13 02:59:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceset`\n(\n `Id`  string , `Date`  string , `DolarDiscount`  string , `PercentDiscount`  string , `Active`  string , `ClosingDate`  string , `DiscountTotal`  string , `Opened`  string , `Payed`  string , `Subtotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Title`  string , `Total`  string , `ReservationId`  string , `AccountId`  string , `ServicePaidAmount`  string , `MarinaPaidAmount`  string , `GasPaidAmount`  string , `InvoiceStatusId`  string , `StartDate`  string , `InstalmentsPaymentMethodId`  string , `ScheduledForCron`  string , `OriginalInvoice`  string , `PaymentsSentToXero`  string , `WorkOrderId`  string , `IsInstallmentInvoice`  string , `VoidUser`  string , `VoidDateTime`  string , `CreationUser`  string , `Payment_Id`  string , `QB_Invoice_Id`  string , `InvoiceType_Id`  string , `InvoiceDate`  string , `DueDate`  string , `CurrencyCode`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `VoidReason`  string , `CreatePartnerId`  string , `VoidPartnerId`  string , `UpdateHash`  string , `ScheduledForInventoryCron`  string , `ScheduledForSubletCron`  string , `ScheduledForLaborCron`  string , `CreatedOnMobile`  string , `StripeInvoiceId`  string , `SentToStripe`  string , `ResourceBookingId`  string , `ModifiedOnMobile`  string , `Note`  string , `QuickbooksInvoiceId`  string , `TaxCap`  string , `IsSurcharge`  string , `HashCheck`  string , `IsReversed`  string , `SurchargeInvoiceId`  string , `MarinaLocationId`  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_moloInvoiceSet/2026-04-13/1776066946'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceSet/2026-04-13/1776066946
id: 1712819
processed: 1

raw_data:

{
    "AccountId": 15,
    "Active": 4,
    "ClosingDate": 5,
    "CreatePartnerId": 39,
    "CreatedOnMobile": 45,
    "CreationUser": 29,
    "CurrencyCode": 35,
    "Date": 1,
    "DiscountTotal": 6,
    "DolarDiscount": 2,
    "DueDate": 34,
    "GasPaidAmount": 18,
    "HashCheck": 54,
    "Id": 0,
    "InstalmentsPaymentMethodId": 21,
    "InvoiceDate": 33,
    "InvoiceStatusId": 19,
    "InvoiceType_Id": 32,
    "IsInstallmentInvoice": 26,
    "IsReversed": 55,
    "IsSurcharge": 53,
    "LastModifiedAspNetUser": 37,
    "LastModifiedDateTime": 36,
    "MarinaLocationId": 57,
    "MarinaPaidAmount": 17,
    "ModifiedOnMobile": 49,
    "Note": 50,
    "Opened": 7,
    "OriginalInvoice": 23,
    "Payed": 8,
    "Payment_Id": 30,
    "PaymentsSentToXero": 24,
    "PercentDiscount": 3,
    "QB_Invoice_Id": 31,
    "QuickbooksInvoiceId": 51,
    "ReservationId": 14,
    "ResourceBookingId": 48,
    "ScheduledForCron": 22,
    "ScheduledForInventoryCron": 42,
    "ScheduledForLaborCron": 44,
    "ScheduledForSubletCron": 43,
    "SentToStripe": 47,
    "ServicePaidAmount": 16,
    "StartDate": 20,
    "StripeInvoiceId": 46,
    "Subtotal": 9,
    "SubtotalWoDiscount": 10,
    "SurchargeInvoiceId": 56,
    "TaxCap": 52,
    "TaxTotal": 11,
    "Title": 12,
    "Total": 13,
    "UpdateHash": 41,
    "VoidDateTime": 28,
    "VoidPartnerId": 40,
    "VoidReason": 38,
    "VoidUser": 27,
    "WorkOrderId": 25
}

schema_attributes:

{
    "AccountId": "string",
    "Active": "string",
    "ClosingDate": "string",
    "CreatePartnerId": "string",
    "CreatedOnMobile": "string",
    "CreationUser": "string",
    "CurrencyCode": "string",
    "Date": "string",
    "DiscountTotal": "string",
    "DolarDiscount": "string",
    "DueDate": "string",
    "GasPaidAmount": "string",
    "HashCheck": "string",
    "Id": "string",
    "InstalmentsPaymentMethodId": "string",
    "InvoiceDate": "string",
    "InvoiceStatusId": "string",
    "InvoiceType_Id": "string",
    "IsInstallmentInvoice": "string",
    "IsReversed": "string",
    "IsSurcharge": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "MarinaLocationId": "string",
    "MarinaPaidAmount": "string",
    "ModifiedOnMobile": "string",
    "Note": "string",
    "Opened": "string",
    "OriginalInvoice": "string",
    "Payed": "string",
    "Payment_Id": "string",
    "PaymentsSentToXero": "string",
    "PercentDiscount": "string",
    "QB_Invoice_Id": "string",
    "QuickbooksInvoiceId": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string",
    "ScheduledForCron": "string",
    "ScheduledForInventoryCron": "string",
    "ScheduledForLaborCron": "string",
    "ScheduledForSubletCron": "string",
    "SentToStripe": "string",
    "ServicePaidAmount": "string",
    "StartDate": "string",
    "StripeInvoiceId": "string",
    "Subtotal": "string",
    "SubtotalWoDiscount": "string",
    "SurchargeInvoiceId": "string",
    "TaxCap": "string",
    "TaxTotal": "string",
    "Title": "string",
    "Total": "string",
    "UpdateHash": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string",
    "WorkOrderId": "string"
}

schema_name_id: 1649
schema_scan_id: 161941810
updated: 2026-04-13 03:00:01

Version 1711598

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceset`\n(\n `Id`  string , `Date`  string , `DolarDiscount`  string , `PercentDiscount`  string , `Active`  string , `ClosingDate`  string , `DiscountTotal`  string , `Opened`  string , `Payed`  string , `Subtotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Title`  string , `Total`  string , `ReservationId`  string , `AccountId`  string , `ServicePaidAmount`  string , `MarinaPaidAmount`  string , `GasPaidAmount`  string , `InvoiceStatusId`  string , `StartDate`  string , `InstalmentsPaymentMethodId`  string , `ScheduledForCron`  string , `OriginalInvoice`  string , `PaymentsSentToXero`  string , `WorkOrderId`  string , `IsInstallmentInvoice`  string , `VoidUser`  string , `VoidDateTime`  string , `CreationUser`  string , `Payment_Id`  string , `QB_Invoice_Id`  string , `InvoiceType_Id`  string , `InvoiceDate`  string , `DueDate`  string , `CurrencyCode`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `VoidReason`  string , `CreatePartnerId`  string , `VoidPartnerId`  string , `UpdateHash`  string , `ScheduledForInventoryCron`  string , `ScheduledForSubletCron`  string , `ScheduledForLaborCron`  string , `CreatedOnMobile`  string , `StripeInvoiceId`  string , `SentToStripe`  string , `ResourceBookingId`  string , `ModifiedOnMobile`  string , `Note`  string , `QuickbooksInvoiceId`  string , `TaxCap`  string , `IsSurcharge`  string , `HashCheck`  string , `IsReversed`  string , `SurchargeInvoiceId`  string , `MarinaLocationId`  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_moloInvoiceSet/2026-04-12/1775980658'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceSet/2026-04-12/1775980658
id: 1711598
processed: 1

raw_data:

{
    "AccountId": 15,
    "Active": 4,
    "ClosingDate": 5,
    "CreatePartnerId": 39,
    "CreatedOnMobile": 45,
    "CreationUser": 29,
    "CurrencyCode": 35,
    "Date": 1,
    "DiscountTotal": 6,
    "DolarDiscount": 2,
    "DueDate": 34,
    "GasPaidAmount": 18,
    "HashCheck": 54,
    "Id": 0,
    "InstalmentsPaymentMethodId": 21,
    "InvoiceDate": 33,
    "InvoiceStatusId": 19,
    "InvoiceType_Id": 32,
    "IsInstallmentInvoice": 26,
    "IsReversed": 55,
    "IsSurcharge": 53,
    "LastModifiedAspNetUser": 37,
    "LastModifiedDateTime": 36,
    "MarinaLocationId": 57,
    "MarinaPaidAmount": 17,
    "ModifiedOnMobile": 49,
    "Note": 50,
    "Opened": 7,
    "OriginalInvoice": 23,
    "Payed": 8,
    "Payment_Id": 30,
    "PaymentsSentToXero": 24,
    "PercentDiscount": 3,
    "QB_Invoice_Id": 31,
    "QuickbooksInvoiceId": 51,
    "ReservationId": 14,
    "ResourceBookingId": 48,
    "ScheduledForCron": 22,
    "ScheduledForInventoryCron": 42,
    "ScheduledForLaborCron": 44,
    "ScheduledForSubletCron": 43,
    "SentToStripe": 47,
    "ServicePaidAmount": 16,
    "StartDate": 20,
    "StripeInvoiceId": 46,
    "Subtotal": 9,
    "SubtotalWoDiscount": 10,
    "SurchargeInvoiceId": 56,
    "TaxCap": 52,
    "TaxTotal": 11,
    "Title": 12,
    "Total": 13,
    "UpdateHash": 41,
    "VoidDateTime": 28,
    "VoidPartnerId": 40,
    "VoidReason": 38,
    "VoidUser": 27,
    "WorkOrderId": 25
}

schema_attributes:

{
    "AccountId": "string",
    "Active": "string",
    "ClosingDate": "string",
    "CreatePartnerId": "string",
    "CreatedOnMobile": "string",
    "CreationUser": "string",
    "CurrencyCode": "string",
    "Date": "string",
    "DiscountTotal": "string",
    "DolarDiscount": "string",
    "DueDate": "string",
    "GasPaidAmount": "string",
    "HashCheck": "string",
    "Id": "string",
    "InstalmentsPaymentMethodId": "string",
    "InvoiceDate": "string",
    "InvoiceStatusId": "string",
    "InvoiceType_Id": "string",
    "IsInstallmentInvoice": "string",
    "IsReversed": "string",
    "IsSurcharge": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "MarinaLocationId": "string",
    "MarinaPaidAmount": "string",
    "ModifiedOnMobile": "string",
    "Note": "string",
    "Opened": "string",
    "OriginalInvoice": "string",
    "Payed": "string",
    "Payment_Id": "string",
    "PaymentsSentToXero": "string",
    "PercentDiscount": "string",
    "QB_Invoice_Id": "string",
    "QuickbooksInvoiceId": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string",
    "ScheduledForCron": "string",
    "ScheduledForInventoryCron": "string",
    "ScheduledForLaborCron": "string",
    "ScheduledForSubletCron": "string",
    "SentToStripe": "string",
    "ServicePaidAmount": "string",
    "StartDate": "string",
    "StripeInvoiceId": "string",
    "Subtotal": "string",
    "SubtotalWoDiscount": "string",
    "SurchargeInvoiceId": "string",
    "TaxCap": "string",
    "TaxTotal": "string",
    "Title": "string",
    "Total": "string",
    "UpdateHash": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string",
    "WorkOrderId": "string"
}

schema_name_id: 1649
schema_scan_id: 161892687
updated: 2026-04-12 03:01:13

Version 1710402

created: 2026-04-11 03:04:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceset`\n(\n `Id`  string , `Date`  string , `DolarDiscount`  string , `PercentDiscount`  string , `Active`  string , `ClosingDate`  string , `DiscountTotal`  string , `Opened`  string , `Payed`  string , `Subtotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Title`  string , `Total`  string , `ReservationId`  string , `AccountId`  string , `ServicePaidAmount`  string , `MarinaPaidAmount`  string , `GasPaidAmount`  string , `InvoiceStatusId`  string , `StartDate`  string , `InstalmentsPaymentMethodId`  string , `ScheduledForCron`  string , `OriginalInvoice`  string , `PaymentsSentToXero`  string , `WorkOrderId`  string , `IsInstallmentInvoice`  string , `VoidUser`  string , `VoidDateTime`  string , `CreationUser`  string , `Payment_Id`  string , `QB_Invoice_Id`  string , `InvoiceType_Id`  string , `InvoiceDate`  string , `DueDate`  string , `CurrencyCode`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `VoidReason`  string , `CreatePartnerId`  string , `VoidPartnerId`  string , `UpdateHash`  string , `ScheduledForInventoryCron`  string , `ScheduledForSubletCron`  string , `ScheduledForLaborCron`  string , `CreatedOnMobile`  string , `StripeInvoiceId`  string , `SentToStripe`  string , `ResourceBookingId`  string , `ModifiedOnMobile`  string , `Note`  string , `QuickbooksInvoiceId`  string , `TaxCap`  string , `IsSurcharge`  string , `HashCheck`  string , `IsReversed`  string , `SurchargeInvoiceId`  string , `MarinaLocationId`  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_moloInvoiceSet/2026-04-11/1775894419'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceSet/2026-04-11/1775894419
id: 1710402
processed: 1

raw_data:

{
    "AccountId": 15,
    "Active": 4,
    "ClosingDate": 5,
    "CreatePartnerId": 39,
    "CreatedOnMobile": 45,
    "CreationUser": 29,
    "CurrencyCode": 35,
    "Date": 1,
    "DiscountTotal": 6,
    "DolarDiscount": 2,
    "DueDate": 34,
    "GasPaidAmount": 18,
    "HashCheck": 54,
    "Id": 0,
    "InstalmentsPaymentMethodId": 21,
    "InvoiceDate": 33,
    "InvoiceStatusId": 19,
    "InvoiceType_Id": 32,
    "IsInstallmentInvoice": 26,
    "IsReversed": 55,
    "IsSurcharge": 53,
    "LastModifiedAspNetUser": 37,
    "LastModifiedDateTime": 36,
    "MarinaLocationId": 57,
    "MarinaPaidAmount": 17,
    "ModifiedOnMobile": 49,
    "Note": 50,
    "Opened": 7,
    "OriginalInvoice": 23,
    "Payed": 8,
    "Payment_Id": 30,
    "PaymentsSentToXero": 24,
    "PercentDiscount": 3,
    "QB_Invoice_Id": 31,
    "QuickbooksInvoiceId": 51,
    "ReservationId": 14,
    "ResourceBookingId": 48,
    "ScheduledForCron": 22,
    "ScheduledForInventoryCron": 42,
    "ScheduledForLaborCron": 44,
    "ScheduledForSubletCron": 43,
    "SentToStripe": 47,
    "ServicePaidAmount": 16,
    "StartDate": 20,
    "StripeInvoiceId": 46,
    "Subtotal": 9,
    "SubtotalWoDiscount": 10,
    "SurchargeInvoiceId": 56,
    "TaxCap": 52,
    "TaxTotal": 11,
    "Title": 12,
    "Total": 13,
    "UpdateHash": 41,
    "VoidDateTime": 28,
    "VoidPartnerId": 40,
    "VoidReason": 38,
    "VoidUser": 27,
    "WorkOrderId": 25
}

schema_attributes:

{
    "AccountId": "string",
    "Active": "string",
    "ClosingDate": "string",
    "CreatePartnerId": "string",
    "CreatedOnMobile": "string",
    "CreationUser": "string",
    "CurrencyCode": "string",
    "Date": "string",
    "DiscountTotal": "string",
    "DolarDiscount": "string",
    "DueDate": "string",
    "GasPaidAmount": "string",
    "HashCheck": "string",
    "Id": "string",
    "InstalmentsPaymentMethodId": "string",
    "InvoiceDate": "string",
    "InvoiceStatusId": "string",
    "InvoiceType_Id": "string",
    "IsInstallmentInvoice": "string",
    "IsReversed": "string",
    "IsSurcharge": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "MarinaLocationId": "string",
    "MarinaPaidAmount": "string",
    "ModifiedOnMobile": "string",
    "Note": "string",
    "Opened": "string",
    "OriginalInvoice": "string",
    "Payed": "string",
    "Payment_Id": "string",
    "PaymentsSentToXero": "string",
    "PercentDiscount": "string",
    "QB_Invoice_Id": "string",
    "QuickbooksInvoiceId": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string",
    "ScheduledForCron": "string",
    "ScheduledForInventoryCron": "string",
    "ScheduledForLaborCron": "string",
    "ScheduledForSubletCron": "string",
    "SentToStripe": "string",
    "ServicePaidAmount": "string",
    "StartDate": "string",
    "StripeInvoiceId": "string",
    "Subtotal": "string",
    "SubtotalWoDiscount": "string",
    "SurchargeInvoiceId": "string",
    "TaxCap": "string",
    "TaxTotal": "string",
    "Title": "string",
    "Total": "string",
    "UpdateHash": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string",
    "WorkOrderId": "string"
}

schema_name_id: 1649
schema_scan_id: 161841170
updated: 2026-04-11 03:04:49

Version 1709388

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceset`\n(\n `Id`  string , `Date`  string , `DolarDiscount`  string , `PercentDiscount`  string , `Active`  string , `ClosingDate`  string , `DiscountTotal`  string , `Opened`  string , `Payed`  string , `Subtotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Title`  string , `Total`  string , `ReservationId`  string , `AccountId`  string , `ServicePaidAmount`  string , `MarinaPaidAmount`  string , `GasPaidAmount`  string , `InvoiceStatusId`  string , `StartDate`  string , `InstalmentsPaymentMethodId`  string , `ScheduledForCron`  string , `OriginalInvoice`  string , `PaymentsSentToXero`  string , `WorkOrderId`  string , `IsInstallmentInvoice`  string , `VoidUser`  string , `VoidDateTime`  string , `CreationUser`  string , `Payment_Id`  string , `QB_Invoice_Id`  string , `InvoiceType_Id`  string , `InvoiceDate`  string , `DueDate`  string , `CurrencyCode`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `VoidReason`  string , `CreatePartnerId`  string , `VoidPartnerId`  string , `UpdateHash`  string , `ScheduledForInventoryCron`  string , `ScheduledForSubletCron`  string , `ScheduledForLaborCron`  string , `CreatedOnMobile`  string , `StripeInvoiceId`  string , `SentToStripe`  string , `ResourceBookingId`  string , `ModifiedOnMobile`  string , `Note`  string , `QuickbooksInvoiceId`  string , `TaxCap`  string , `IsSurcharge`  string , `HashCheck`  string , `IsReversed`  string , `SurchargeInvoiceId`  string , `MarinaLocationId`  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_moloInvoiceSet/2026-04-10/1775808176'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceSet/2026-04-10/1775808176
id: 1709388
processed: 1

raw_data:

{
    "AccountId": 15,
    "Active": 4,
    "ClosingDate": 5,
    "CreatePartnerId": 39,
    "CreatedOnMobile": 45,
    "CreationUser": 29,
    "CurrencyCode": 35,
    "Date": 1,
    "DiscountTotal": 6,
    "DolarDiscount": 2,
    "DueDate": 34,
    "GasPaidAmount": 18,
    "HashCheck": 54,
    "Id": 0,
    "InstalmentsPaymentMethodId": 21,
    "InvoiceDate": 33,
    "InvoiceStatusId": 19,
    "InvoiceType_Id": 32,
    "IsInstallmentInvoice": 26,
    "IsReversed": 55,
    "IsSurcharge": 53,
    "LastModifiedAspNetUser": 37,
    "LastModifiedDateTime": 36,
    "MarinaLocationId": 57,
    "MarinaPaidAmount": 17,
    "ModifiedOnMobile": 49,
    "Note": 50,
    "Opened": 7,
    "OriginalInvoice": 23,
    "Payed": 8,
    "Payment_Id": 30,
    "PaymentsSentToXero": 24,
    "PercentDiscount": 3,
    "QB_Invoice_Id": 31,
    "QuickbooksInvoiceId": 51,
    "ReservationId": 14,
    "ResourceBookingId": 48,
    "ScheduledForCron": 22,
    "ScheduledForInventoryCron": 42,
    "ScheduledForLaborCron": 44,
    "ScheduledForSubletCron": 43,
    "SentToStripe": 47,
    "ServicePaidAmount": 16,
    "StartDate": 20,
    "StripeInvoiceId": 46,
    "Subtotal": 9,
    "SubtotalWoDiscount": 10,
    "SurchargeInvoiceId": 56,
    "TaxCap": 52,
    "TaxTotal": 11,
    "Title": 12,
    "Total": 13,
    "UpdateHash": 41,
    "VoidDateTime": 28,
    "VoidPartnerId": 40,
    "VoidReason": 38,
    "VoidUser": 27,
    "WorkOrderId": 25
}

schema_attributes:

{
    "AccountId": "string",
    "Active": "string",
    "ClosingDate": "string",
    "CreatePartnerId": "string",
    "CreatedOnMobile": "string",
    "CreationUser": "string",
    "CurrencyCode": "string",
    "Date": "string",
    "DiscountTotal": "string",
    "DolarDiscount": "string",
    "DueDate": "string",
    "GasPaidAmount": "string",
    "HashCheck": "string",
    "Id": "string",
    "InstalmentsPaymentMethodId": "string",
    "InvoiceDate": "string",
    "InvoiceStatusId": "string",
    "InvoiceType_Id": "string",
    "IsInstallmentInvoice": "string",
    "IsReversed": "string",
    "IsSurcharge": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "MarinaLocationId": "string",
    "MarinaPaidAmount": "string",
    "ModifiedOnMobile": "string",
    "Note": "string",
    "Opened": "string",
    "OriginalInvoice": "string",
    "Payed": "string",
    "Payment_Id": "string",
    "PaymentsSentToXero": "string",
    "PercentDiscount": "string",
    "QB_Invoice_Id": "string",
    "QuickbooksInvoiceId": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string",
    "ScheduledForCron": "string",
    "ScheduledForInventoryCron": "string",
    "ScheduledForLaborCron": "string",
    "ScheduledForSubletCron": "string",
    "SentToStripe": "string",
    "ServicePaidAmount": "string",
    "StartDate": "string",
    "StripeInvoiceId": "string",
    "Subtotal": "string",
    "SubtotalWoDiscount": "string",
    "SurchargeInvoiceId": "string",
    "TaxCap": "string",
    "TaxTotal": "string",
    "Title": "string",
    "Total": "string",
    "UpdateHash": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string",
    "WorkOrderId": "string"
}

schema_name_id: 1649
schema_scan_id: 161786091
updated: 2026-04-10 03:11:46

Version 1708095

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceset`\n(\n `Id`  string , `Date`  string , `DolarDiscount`  string , `PercentDiscount`  string , `Active`  string , `ClosingDate`  string , `DiscountTotal`  string , `Opened`  string , `Payed`  string , `Subtotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Title`  string , `Total`  string , `ReservationId`  string , `AccountId`  string , `ServicePaidAmount`  string , `MarinaPaidAmount`  string , `GasPaidAmount`  string , `InvoiceStatusId`  string , `StartDate`  string , `InstalmentsPaymentMethodId`  string , `ScheduledForCron`  string , `OriginalInvoice`  string , `PaymentsSentToXero`  string , `WorkOrderId`  string , `IsInstallmentInvoice`  string , `VoidUser`  string , `VoidDateTime`  string , `CreationUser`  string , `Payment_Id`  string , `QB_Invoice_Id`  string , `InvoiceType_Id`  string , `InvoiceDate`  string , `DueDate`  string , `CurrencyCode`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `VoidReason`  string , `CreatePartnerId`  string , `VoidPartnerId`  string , `UpdateHash`  string , `ScheduledForInventoryCron`  string , `ScheduledForSubletCron`  string , `ScheduledForLaborCron`  string , `CreatedOnMobile`  string , `StripeInvoiceId`  string , `SentToStripe`  string , `ResourceBookingId`  string , `ModifiedOnMobile`  string , `Note`  string , `QuickbooksInvoiceId`  string , `TaxCap`  string , `IsSurcharge`  string , `HashCheck`  string , `IsReversed`  string , `SurchargeInvoiceId`  string , `MarinaLocationId`  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_moloInvoiceSet/2026-04-09/1775721513'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceSet/2026-04-09/1775721513
id: 1708095
processed: 1

raw_data:

{
    "AccountId": 15,
    "Active": 4,
    "ClosingDate": 5,
    "CreatePartnerId": 39,
    "CreatedOnMobile": 45,
    "CreationUser": 29,
    "CurrencyCode": 35,
    "Date": 1,
    "DiscountTotal": 6,
    "DolarDiscount": 2,
    "DueDate": 34,
    "GasPaidAmount": 18,
    "HashCheck": 54,
    "Id": 0,
    "InstalmentsPaymentMethodId": 21,
    "InvoiceDate": 33,
    "InvoiceStatusId": 19,
    "InvoiceType_Id": 32,
    "IsInstallmentInvoice": 26,
    "IsReversed": 55,
    "IsSurcharge": 53,
    "LastModifiedAspNetUser": 37,
    "LastModifiedDateTime": 36,
    "MarinaLocationId": 57,
    "MarinaPaidAmount": 17,
    "ModifiedOnMobile": 49,
    "Note": 50,
    "Opened": 7,
    "OriginalInvoice": 23,
    "Payed": 8,
    "Payment_Id": 30,
    "PaymentsSentToXero": 24,
    "PercentDiscount": 3,
    "QB_Invoice_Id": 31,
    "QuickbooksInvoiceId": 51,
    "ReservationId": 14,
    "ResourceBookingId": 48,
    "ScheduledForCron": 22,
    "ScheduledForInventoryCron": 42,
    "ScheduledForLaborCron": 44,
    "ScheduledForSubletCron": 43,
    "SentToStripe": 47,
    "ServicePaidAmount": 16,
    "StartDate": 20,
    "StripeInvoiceId": 46,
    "Subtotal": 9,
    "SubtotalWoDiscount": 10,
    "SurchargeInvoiceId": 56,
    "TaxCap": 52,
    "TaxTotal": 11,
    "Title": 12,
    "Total": 13,
    "UpdateHash": 41,
    "VoidDateTime": 28,
    "VoidPartnerId": 40,
    "VoidReason": 38,
    "VoidUser": 27,
    "WorkOrderId": 25
}

schema_attributes:

{
    "AccountId": "string",
    "Active": "string",
    "ClosingDate": "string",
    "CreatePartnerId": "string",
    "CreatedOnMobile": "string",
    "CreationUser": "string",
    "CurrencyCode": "string",
    "Date": "string",
    "DiscountTotal": "string",
    "DolarDiscount": "string",
    "DueDate": "string",
    "GasPaidAmount": "string",
    "HashCheck": "string",
    "Id": "string",
    "InstalmentsPaymentMethodId": "string",
    "InvoiceDate": "string",
    "InvoiceStatusId": "string",
    "InvoiceType_Id": "string",
    "IsInstallmentInvoice": "string",
    "IsReversed": "string",
    "IsSurcharge": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "MarinaLocationId": "string",
    "MarinaPaidAmount": "string",
    "ModifiedOnMobile": "string",
    "Note": "string",
    "Opened": "string",
    "OriginalInvoice": "string",
    "Payed": "string",
    "Payment_Id": "string",
    "PaymentsSentToXero": "string",
    "PercentDiscount": "string",
    "QB_Invoice_Id": "string",
    "QuickbooksInvoiceId": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string",
    "ScheduledForCron": "string",
    "ScheduledForInventoryCron": "string",
    "ScheduledForLaborCron": "string",
    "ScheduledForSubletCron": "string",
    "SentToStripe": "string",
    "ServicePaidAmount": "string",
    "StartDate": "string",
    "StripeInvoiceId": "string",
    "Subtotal": "string",
    "SubtotalWoDiscount": "string",
    "SurchargeInvoiceId": "string",
    "TaxCap": "string",
    "TaxTotal": "string",
    "Title": "string",
    "Total": "string",
    "UpdateHash": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string",
    "WorkOrderId": "string"
}

schema_name_id: 1649
schema_scan_id: 161730139
updated: 2026-04-09 03:02:19

Version 1706996

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceset`\n(\n `Id`  string , `Date`  string , `DolarDiscount`  string , `PercentDiscount`  string , `Active`  string , `ClosingDate`  string , `DiscountTotal`  string , `Opened`  string , `Payed`  string , `Subtotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Title`  string , `Total`  string , `ReservationId`  string , `AccountId`  string , `ServicePaidAmount`  string , `MarinaPaidAmount`  string , `GasPaidAmount`  string , `InvoiceStatusId`  string , `StartDate`  string , `InstalmentsPaymentMethodId`  string , `ScheduledForCron`  string , `OriginalInvoice`  string , `PaymentsSentToXero`  string , `WorkOrderId`  string , `IsInstallmentInvoice`  string , `VoidUser`  string , `VoidDateTime`  string , `CreationUser`  string , `Payment_Id`  string , `QB_Invoice_Id`  string , `InvoiceType_Id`  string , `InvoiceDate`  string , `DueDate`  string , `CurrencyCode`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `VoidReason`  string , `CreatePartnerId`  string , `VoidPartnerId`  string , `UpdateHash`  string , `ScheduledForInventoryCron`  string , `ScheduledForSubletCron`  string , `ScheduledForLaborCron`  string , `CreatedOnMobile`  string , `StripeInvoiceId`  string , `SentToStripe`  string , `ResourceBookingId`  string , `ModifiedOnMobile`  string , `Note`  string , `QuickbooksInvoiceId`  string , `TaxCap`  string , `IsSurcharge`  string , `HashCheck`  string , `IsReversed`  string , `SurchargeInvoiceId`  string , `MarinaLocationId`  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_moloInvoiceSet/2026-04-08/1775635344'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceSet/2026-04-08/1775635344
id: 1706996
processed: 1

raw_data:

{
    "AccountId": 15,
    "Active": 4,
    "ClosingDate": 5,
    "CreatePartnerId": 39,
    "CreatedOnMobile": 45,
    "CreationUser": 29,
    "CurrencyCode": 35,
    "Date": 1,
    "DiscountTotal": 6,
    "DolarDiscount": 2,
    "DueDate": 34,
    "GasPaidAmount": 18,
    "HashCheck": 54,
    "Id": 0,
    "InstalmentsPaymentMethodId": 21,
    "InvoiceDate": 33,
    "InvoiceStatusId": 19,
    "InvoiceType_Id": 32,
    "IsInstallmentInvoice": 26,
    "IsReversed": 55,
    "IsSurcharge": 53,
    "LastModifiedAspNetUser": 37,
    "LastModifiedDateTime": 36,
    "MarinaLocationId": 57,
    "MarinaPaidAmount": 17,
    "ModifiedOnMobile": 49,
    "Note": 50,
    "Opened": 7,
    "OriginalInvoice": 23,
    "Payed": 8,
    "Payment_Id": 30,
    "PaymentsSentToXero": 24,
    "PercentDiscount": 3,
    "QB_Invoice_Id": 31,
    "QuickbooksInvoiceId": 51,
    "ReservationId": 14,
    "ResourceBookingId": 48,
    "ScheduledForCron": 22,
    "ScheduledForInventoryCron": 42,
    "ScheduledForLaborCron": 44,
    "ScheduledForSubletCron": 43,
    "SentToStripe": 47,
    "ServicePaidAmount": 16,
    "StartDate": 20,
    "StripeInvoiceId": 46,
    "Subtotal": 9,
    "SubtotalWoDiscount": 10,
    "SurchargeInvoiceId": 56,
    "TaxCap": 52,
    "TaxTotal": 11,
    "Title": 12,
    "Total": 13,
    "UpdateHash": 41,
    "VoidDateTime": 28,
    "VoidPartnerId": 40,
    "VoidReason": 38,
    "VoidUser": 27,
    "WorkOrderId": 25
}

schema_attributes:

{
    "AccountId": "string",
    "Active": "string",
    "ClosingDate": "string",
    "CreatePartnerId": "string",
    "CreatedOnMobile": "string",
    "CreationUser": "string",
    "CurrencyCode": "string",
    "Date": "string",
    "DiscountTotal": "string",
    "DolarDiscount": "string",
    "DueDate": "string",
    "GasPaidAmount": "string",
    "HashCheck": "string",
    "Id": "string",
    "InstalmentsPaymentMethodId": "string",
    "InvoiceDate": "string",
    "InvoiceStatusId": "string",
    "InvoiceType_Id": "string",
    "IsInstallmentInvoice": "string",
    "IsReversed": "string",
    "IsSurcharge": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "MarinaLocationId": "string",
    "MarinaPaidAmount": "string",
    "ModifiedOnMobile": "string",
    "Note": "string",
    "Opened": "string",
    "OriginalInvoice": "string",
    "Payed": "string",
    "Payment_Id": "string",
    "PaymentsSentToXero": "string",
    "PercentDiscount": "string",
    "QB_Invoice_Id": "string",
    "QuickbooksInvoiceId": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string",
    "ScheduledForCron": "string",
    "ScheduledForInventoryCron": "string",
    "ScheduledForLaborCron": "string",
    "ScheduledForSubletCron": "string",
    "SentToStripe": "string",
    "ServicePaidAmount": "string",
    "StartDate": "string",
    "StripeInvoiceId": "string",
    "Subtotal": "string",
    "SubtotalWoDiscount": "string",
    "SurchargeInvoiceId": "string",
    "TaxCap": "string",
    "TaxTotal": "string",
    "Title": "string",
    "Total": "string",
    "UpdateHash": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string",
    "WorkOrderId": "string"
}

schema_name_id: 1649
schema_scan_id: 161675653
updated: 2026-04-08 03:09:33

Version 1705699

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceset`\n(\n `Id`  string , `Date`  string , `DolarDiscount`  string , `PercentDiscount`  string , `Active`  string , `ClosingDate`  string , `DiscountTotal`  string , `Opened`  string , `Payed`  string , `Subtotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Title`  string , `Total`  string , `ReservationId`  string , `AccountId`  string , `ServicePaidAmount`  string , `MarinaPaidAmount`  string , `GasPaidAmount`  string , `InvoiceStatusId`  string , `StartDate`  string , `InstalmentsPaymentMethodId`  string , `ScheduledForCron`  string , `OriginalInvoice`  string , `PaymentsSentToXero`  string , `WorkOrderId`  string , `IsInstallmentInvoice`  string , `VoidUser`  string , `VoidDateTime`  string , `CreationUser`  string , `Payment_Id`  string , `QB_Invoice_Id`  string , `InvoiceType_Id`  string , `InvoiceDate`  string , `DueDate`  string , `CurrencyCode`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `VoidReason`  string , `CreatePartnerId`  string , `VoidPartnerId`  string , `UpdateHash`  string , `ScheduledForInventoryCron`  string , `ScheduledForSubletCron`  string , `ScheduledForLaborCron`  string , `CreatedOnMobile`  string , `StripeInvoiceId`  string , `SentToStripe`  string , `ResourceBookingId`  string , `ModifiedOnMobile`  string , `Note`  string , `QuickbooksInvoiceId`  string , `TaxCap`  string , `IsSurcharge`  string , `HashCheck`  string , `IsReversed`  string , `SurchargeInvoiceId`  string , `MarinaLocationId`  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_moloInvoiceSet/2026-04-07/1775548495'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceSet/2026-04-07/1775548495
id: 1705699
processed: 1

raw_data:

{
    "AccountId": 15,
    "Active": 4,
    "ClosingDate": 5,
    "CreatePartnerId": 39,
    "CreatedOnMobile": 45,
    "CreationUser": 29,
    "CurrencyCode": 35,
    "Date": 1,
    "DiscountTotal": 6,
    "DolarDiscount": 2,
    "DueDate": 34,
    "GasPaidAmount": 18,
    "HashCheck": 54,
    "Id": 0,
    "InstalmentsPaymentMethodId": 21,
    "InvoiceDate": 33,
    "InvoiceStatusId": 19,
    "InvoiceType_Id": 32,
    "IsInstallmentInvoice": 26,
    "IsReversed": 55,
    "IsSurcharge": 53,
    "LastModifiedAspNetUser": 37,
    "LastModifiedDateTime": 36,
    "MarinaLocationId": 57,
    "MarinaPaidAmount": 17,
    "ModifiedOnMobile": 49,
    "Note": 50,
    "Opened": 7,
    "OriginalInvoice": 23,
    "Payed": 8,
    "Payment_Id": 30,
    "PaymentsSentToXero": 24,
    "PercentDiscount": 3,
    "QB_Invoice_Id": 31,
    "QuickbooksInvoiceId": 51,
    "ReservationId": 14,
    "ResourceBookingId": 48,
    "ScheduledForCron": 22,
    "ScheduledForInventoryCron": 42,
    "ScheduledForLaborCron": 44,
    "ScheduledForSubletCron": 43,
    "SentToStripe": 47,
    "ServicePaidAmount": 16,
    "StartDate": 20,
    "StripeInvoiceId": 46,
    "Subtotal": 9,
    "SubtotalWoDiscount": 10,
    "SurchargeInvoiceId": 56,
    "TaxCap": 52,
    "TaxTotal": 11,
    "Title": 12,
    "Total": 13,
    "UpdateHash": 41,
    "VoidDateTime": 28,
    "VoidPartnerId": 40,
    "VoidReason": 38,
    "VoidUser": 27,
    "WorkOrderId": 25
}

schema_attributes:

{
    "AccountId": "string",
    "Active": "string",
    "ClosingDate": "string",
    "CreatePartnerId": "string",
    "CreatedOnMobile": "string",
    "CreationUser": "string",
    "CurrencyCode": "string",
    "Date": "string",
    "DiscountTotal": "string",
    "DolarDiscount": "string",
    "DueDate": "string",
    "GasPaidAmount": "string",
    "HashCheck": "string",
    "Id": "string",
    "InstalmentsPaymentMethodId": "string",
    "InvoiceDate": "string",
    "InvoiceStatusId": "string",
    "InvoiceType_Id": "string",
    "IsInstallmentInvoice": "string",
    "IsReversed": "string",
    "IsSurcharge": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "MarinaLocationId": "string",
    "MarinaPaidAmount": "string",
    "ModifiedOnMobile": "string",
    "Note": "string",
    "Opened": "string",
    "OriginalInvoice": "string",
    "Payed": "string",
    "Payment_Id": "string",
    "PaymentsSentToXero": "string",
    "PercentDiscount": "string",
    "QB_Invoice_Id": "string",
    "QuickbooksInvoiceId": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string",
    "ScheduledForCron": "string",
    "ScheduledForInventoryCron": "string",
    "ScheduledForLaborCron": "string",
    "ScheduledForSubletCron": "string",
    "SentToStripe": "string",
    "ServicePaidAmount": "string",
    "StartDate": "string",
    "StripeInvoiceId": "string",
    "Subtotal": "string",
    "SubtotalWoDiscount": "string",
    "SurchargeInvoiceId": "string",
    "TaxCap": "string",
    "TaxTotal": "string",
    "Title": "string",
    "Total": "string",
    "UpdateHash": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string",
    "WorkOrderId": "string"
}

schema_name_id: 1649
schema_scan_id: 161618397
updated: 2026-04-07 02:57:02

Version 1704601

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceset`\n(\n `Id`  string , `Date`  string , `DolarDiscount`  string , `PercentDiscount`  string , `Active`  string , `ClosingDate`  string , `DiscountTotal`  string , `Opened`  string , `Payed`  string , `Subtotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Title`  string , `Total`  string , `ReservationId`  string , `AccountId`  string , `ServicePaidAmount`  string , `MarinaPaidAmount`  string , `GasPaidAmount`  string , `InvoiceStatusId`  string , `StartDate`  string , `InstalmentsPaymentMethodId`  string , `ScheduledForCron`  string , `OriginalInvoice`  string , `PaymentsSentToXero`  string , `WorkOrderId`  string , `IsInstallmentInvoice`  string , `VoidUser`  string , `VoidDateTime`  string , `CreationUser`  string , `Payment_Id`  string , `QB_Invoice_Id`  string , `InvoiceType_Id`  string , `InvoiceDate`  string , `DueDate`  string , `CurrencyCode`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `VoidReason`  string , `CreatePartnerId`  string , `VoidPartnerId`  string , `UpdateHash`  string , `ScheduledForInventoryCron`  string , `ScheduledForSubletCron`  string , `ScheduledForLaborCron`  string , `CreatedOnMobile`  string , `StripeInvoiceId`  string , `SentToStripe`  string , `ResourceBookingId`  string , `ModifiedOnMobile`  string , `Note`  string , `QuickbooksInvoiceId`  string , `TaxCap`  string , `IsSurcharge`  string , `HashCheck`  string , `IsReversed`  string , `SurchargeInvoiceId`  string , `MarinaLocationId`  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_moloInvoiceSet/2026-04-06/1775462460'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceSet/2026-04-06/1775462460
id: 1704601
processed: 1

raw_data:

{
    "AccountId": 15,
    "Active": 4,
    "ClosingDate": 5,
    "CreatePartnerId": 39,
    "CreatedOnMobile": 45,
    "CreationUser": 29,
    "CurrencyCode": 35,
    "Date": 1,
    "DiscountTotal": 6,
    "DolarDiscount": 2,
    "DueDate": 34,
    "GasPaidAmount": 18,
    "HashCheck": 54,
    "Id": 0,
    "InstalmentsPaymentMethodId": 21,
    "InvoiceDate": 33,
    "InvoiceStatusId": 19,
    "InvoiceType_Id": 32,
    "IsInstallmentInvoice": 26,
    "IsReversed": 55,
    "IsSurcharge": 53,
    "LastModifiedAspNetUser": 37,
    "LastModifiedDateTime": 36,
    "MarinaLocationId": 57,
    "MarinaPaidAmount": 17,
    "ModifiedOnMobile": 49,
    "Note": 50,
    "Opened": 7,
    "OriginalInvoice": 23,
    "Payed": 8,
    "Payment_Id": 30,
    "PaymentsSentToXero": 24,
    "PercentDiscount": 3,
    "QB_Invoice_Id": 31,
    "QuickbooksInvoiceId": 51,
    "ReservationId": 14,
    "ResourceBookingId": 48,
    "ScheduledForCron": 22,
    "ScheduledForInventoryCron": 42,
    "ScheduledForLaborCron": 44,
    "ScheduledForSubletCron": 43,
    "SentToStripe": 47,
    "ServicePaidAmount": 16,
    "StartDate": 20,
    "StripeInvoiceId": 46,
    "Subtotal": 9,
    "SubtotalWoDiscount": 10,
    "SurchargeInvoiceId": 56,
    "TaxCap": 52,
    "TaxTotal": 11,
    "Title": 12,
    "Total": 13,
    "UpdateHash": 41,
    "VoidDateTime": 28,
    "VoidPartnerId": 40,
    "VoidReason": 38,
    "VoidUser": 27,
    "WorkOrderId": 25
}

schema_attributes:

{
    "AccountId": "string",
    "Active": "string",
    "ClosingDate": "string",
    "CreatePartnerId": "string",
    "CreatedOnMobile": "string",
    "CreationUser": "string",
    "CurrencyCode": "string",
    "Date": "string",
    "DiscountTotal": "string",
    "DolarDiscount": "string",
    "DueDate": "string",
    "GasPaidAmount": "string",
    "HashCheck": "string",
    "Id": "string",
    "InstalmentsPaymentMethodId": "string",
    "InvoiceDate": "string",
    "InvoiceStatusId": "string",
    "InvoiceType_Id": "string",
    "IsInstallmentInvoice": "string",
    "IsReversed": "string",
    "IsSurcharge": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "MarinaLocationId": "string",
    "MarinaPaidAmount": "string",
    "ModifiedOnMobile": "string",
    "Note": "string",
    "Opened": "string",
    "OriginalInvoice": "string",
    "Payed": "string",
    "Payment_Id": "string",
    "PaymentsSentToXero": "string",
    "PercentDiscount": "string",
    "QB_Invoice_Id": "string",
    "QuickbooksInvoiceId": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string",
    "ScheduledForCron": "string",
    "ScheduledForInventoryCron": "string",
    "ScheduledForLaborCron": "string",
    "ScheduledForSubletCron": "string",
    "SentToStripe": "string",
    "ServicePaidAmount": "string",
    "StartDate": "string",
    "StripeInvoiceId": "string",
    "Subtotal": "string",
    "SubtotalWoDiscount": "string",
    "SurchargeInvoiceId": "string",
    "TaxCap": "string",
    "TaxTotal": "string",
    "Title": "string",
    "Total": "string",
    "UpdateHash": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string",
    "WorkOrderId": "string"
}

schema_name_id: 1649
schema_scan_id: 161561745
updated: 2026-04-06 03:10:27

Version 1703252

created: 2026-04-05 03:03:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceset`\n(\n `Id`  string , `Date`  string , `DolarDiscount`  string , `PercentDiscount`  string , `Active`  string , `ClosingDate`  string , `DiscountTotal`  string , `Opened`  string , `Payed`  string , `Subtotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Title`  string , `Total`  string , `ReservationId`  string , `AccountId`  string , `ServicePaidAmount`  string , `MarinaPaidAmount`  string , `GasPaidAmount`  string , `InvoiceStatusId`  string , `StartDate`  string , `InstalmentsPaymentMethodId`  string , `ScheduledForCron`  string , `OriginalInvoice`  string , `PaymentsSentToXero`  string , `WorkOrderId`  string , `IsInstallmentInvoice`  string , `VoidUser`  string , `VoidDateTime`  string , `CreationUser`  string , `Payment_Id`  string , `QB_Invoice_Id`  string , `InvoiceType_Id`  string , `InvoiceDate`  string , `DueDate`  string , `CurrencyCode`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `VoidReason`  string , `CreatePartnerId`  string , `VoidPartnerId`  string , `UpdateHash`  string , `ScheduledForInventoryCron`  string , `ScheduledForSubletCron`  string , `ScheduledForLaborCron`  string , `CreatedOnMobile`  string , `StripeInvoiceId`  string , `SentToStripe`  string , `ResourceBookingId`  string , `ModifiedOnMobile`  string , `Note`  string , `QuickbooksInvoiceId`  string , `TaxCap`  string , `IsSurcharge`  string , `HashCheck`  string , `IsReversed`  string , `SurchargeInvoiceId`  string , `MarinaLocationId`  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_moloInvoiceSet/2026-04-05/1775376087'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceSet/2026-04-05/1775376087
id: 1703252
processed: 1

raw_data:

{
    "AccountId": 15,
    "Active": 4,
    "ClosingDate": 5,
    "CreatePartnerId": 39,
    "CreatedOnMobile": 45,
    "CreationUser": 29,
    "CurrencyCode": 35,
    "Date": 1,
    "DiscountTotal": 6,
    "DolarDiscount": 2,
    "DueDate": 34,
    "GasPaidAmount": 18,
    "HashCheck": 54,
    "Id": 0,
    "InstalmentsPaymentMethodId": 21,
    "InvoiceDate": 33,
    "InvoiceStatusId": 19,
    "InvoiceType_Id": 32,
    "IsInstallmentInvoice": 26,
    "IsReversed": 55,
    "IsSurcharge": 53,
    "LastModifiedAspNetUser": 37,
    "LastModifiedDateTime": 36,
    "MarinaLocationId": 57,
    "MarinaPaidAmount": 17,
    "ModifiedOnMobile": 49,
    "Note": 50,
    "Opened": 7,
    "OriginalInvoice": 23,
    "Payed": 8,
    "Payment_Id": 30,
    "PaymentsSentToXero": 24,
    "PercentDiscount": 3,
    "QB_Invoice_Id": 31,
    "QuickbooksInvoiceId": 51,
    "ReservationId": 14,
    "ResourceBookingId": 48,
    "ScheduledForCron": 22,
    "ScheduledForInventoryCron": 42,
    "ScheduledForLaborCron": 44,
    "ScheduledForSubletCron": 43,
    "SentToStripe": 47,
    "ServicePaidAmount": 16,
    "StartDate": 20,
    "StripeInvoiceId": 46,
    "Subtotal": 9,
    "SubtotalWoDiscount": 10,
    "SurchargeInvoiceId": 56,
    "TaxCap": 52,
    "TaxTotal": 11,
    "Title": 12,
    "Total": 13,
    "UpdateHash": 41,
    "VoidDateTime": 28,
    "VoidPartnerId": 40,
    "VoidReason": 38,
    "VoidUser": 27,
    "WorkOrderId": 25
}

schema_attributes:

{
    "AccountId": "string",
    "Active": "string",
    "ClosingDate": "string",
    "CreatePartnerId": "string",
    "CreatedOnMobile": "string",
    "CreationUser": "string",
    "CurrencyCode": "string",
    "Date": "string",
    "DiscountTotal": "string",
    "DolarDiscount": "string",
    "DueDate": "string",
    "GasPaidAmount": "string",
    "HashCheck": "string",
    "Id": "string",
    "InstalmentsPaymentMethodId": "string",
    "InvoiceDate": "string",
    "InvoiceStatusId": "string",
    "InvoiceType_Id": "string",
    "IsInstallmentInvoice": "string",
    "IsReversed": "string",
    "IsSurcharge": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "MarinaLocationId": "string",
    "MarinaPaidAmount": "string",
    "ModifiedOnMobile": "string",
    "Note": "string",
    "Opened": "string",
    "OriginalInvoice": "string",
    "Payed": "string",
    "Payment_Id": "string",
    "PaymentsSentToXero": "string",
    "PercentDiscount": "string",
    "QB_Invoice_Id": "string",
    "QuickbooksInvoiceId": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string",
    "ScheduledForCron": "string",
    "ScheduledForInventoryCron": "string",
    "ScheduledForLaborCron": "string",
    "ScheduledForSubletCron": "string",
    "SentToStripe": "string",
    "ServicePaidAmount": "string",
    "StartDate": "string",
    "StripeInvoiceId": "string",
    "Subtotal": "string",
    "SubtotalWoDiscount": "string",
    "SurchargeInvoiceId": "string",
    "TaxCap": "string",
    "TaxTotal": "string",
    "Title": "string",
    "Total": "string",
    "UpdateHash": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string",
    "WorkOrderId": "string"
}

schema_name_id: 1649
schema_scan_id: 161514822
updated: 2026-04-05 03:03:25

Version 1702143

created: 2026-04-04 03:04:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceset`\n(\n `Id`  string , `Date`  string , `DolarDiscount`  string , `PercentDiscount`  string , `Active`  string , `ClosingDate`  string , `DiscountTotal`  string , `Opened`  string , `Payed`  string , `Subtotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Title`  string , `Total`  string , `ReservationId`  string , `AccountId`  string , `ServicePaidAmount`  string , `MarinaPaidAmount`  string , `GasPaidAmount`  string , `InvoiceStatusId`  string , `StartDate`  string , `InstalmentsPaymentMethodId`  string , `ScheduledForCron`  string , `OriginalInvoice`  string , `PaymentsSentToXero`  string , `WorkOrderId`  string , `IsInstallmentInvoice`  string , `VoidUser`  string , `VoidDateTime`  string , `CreationUser`  string , `Payment_Id`  string , `QB_Invoice_Id`  string , `InvoiceType_Id`  string , `InvoiceDate`  string , `DueDate`  string , `CurrencyCode`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `VoidReason`  string , `CreatePartnerId`  string , `VoidPartnerId`  string , `UpdateHash`  string , `ScheduledForInventoryCron`  string , `ScheduledForSubletCron`  string , `ScheduledForLaborCron`  string , `CreatedOnMobile`  string , `StripeInvoiceId`  string , `SentToStripe`  string , `ResourceBookingId`  string , `ModifiedOnMobile`  string , `Note`  string , `QuickbooksInvoiceId`  string , `TaxCap`  string , `IsSurcharge`  string , `HashCheck`  string , `IsReversed`  string , `SurchargeInvoiceId`  string , `MarinaLocationId`  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_moloInvoiceSet/2026-04-04/1775289570'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceSet/2026-04-04/1775289570
id: 1702143
processed: 1

raw_data:

{
    "AccountId": 15,
    "Active": 4,
    "ClosingDate": 5,
    "CreatePartnerId": 39,
    "CreatedOnMobile": 45,
    "CreationUser": 29,
    "CurrencyCode": 35,
    "Date": 1,
    "DiscountTotal": 6,
    "DolarDiscount": 2,
    "DueDate": 34,
    "GasPaidAmount": 18,
    "HashCheck": 54,
    "Id": 0,
    "InstalmentsPaymentMethodId": 21,
    "InvoiceDate": 33,
    "InvoiceStatusId": 19,
    "InvoiceType_Id": 32,
    "IsInstallmentInvoice": 26,
    "IsReversed": 55,
    "IsSurcharge": 53,
    "LastModifiedAspNetUser": 37,
    "LastModifiedDateTime": 36,
    "MarinaLocationId": 57,
    "MarinaPaidAmount": 17,
    "ModifiedOnMobile": 49,
    "Note": 50,
    "Opened": 7,
    "OriginalInvoice": 23,
    "Payed": 8,
    "Payment_Id": 30,
    "PaymentsSentToXero": 24,
    "PercentDiscount": 3,
    "QB_Invoice_Id": 31,
    "QuickbooksInvoiceId": 51,
    "ReservationId": 14,
    "ResourceBookingId": 48,
    "ScheduledForCron": 22,
    "ScheduledForInventoryCron": 42,
    "ScheduledForLaborCron": 44,
    "ScheduledForSubletCron": 43,
    "SentToStripe": 47,
    "ServicePaidAmount": 16,
    "StartDate": 20,
    "StripeInvoiceId": 46,
    "Subtotal": 9,
    "SubtotalWoDiscount": 10,
    "SurchargeInvoiceId": 56,
    "TaxCap": 52,
    "TaxTotal": 11,
    "Title": 12,
    "Total": 13,
    "UpdateHash": 41,
    "VoidDateTime": 28,
    "VoidPartnerId": 40,
    "VoidReason": 38,
    "VoidUser": 27,
    "WorkOrderId": 25
}

schema_attributes:

{
    "AccountId": "string",
    "Active": "string",
    "ClosingDate": "string",
    "CreatePartnerId": "string",
    "CreatedOnMobile": "string",
    "CreationUser": "string",
    "CurrencyCode": "string",
    "Date": "string",
    "DiscountTotal": "string",
    "DolarDiscount": "string",
    "DueDate": "string",
    "GasPaidAmount": "string",
    "HashCheck": "string",
    "Id": "string",
    "InstalmentsPaymentMethodId": "string",
    "InvoiceDate": "string",
    "InvoiceStatusId": "string",
    "InvoiceType_Id": "string",
    "IsInstallmentInvoice": "string",
    "IsReversed": "string",
    "IsSurcharge": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "MarinaLocationId": "string",
    "MarinaPaidAmount": "string",
    "ModifiedOnMobile": "string",
    "Note": "string",
    "Opened": "string",
    "OriginalInvoice": "string",
    "Payed": "string",
    "Payment_Id": "string",
    "PaymentsSentToXero": "string",
    "PercentDiscount": "string",
    "QB_Invoice_Id": "string",
    "QuickbooksInvoiceId": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string",
    "ScheduledForCron": "string",
    "ScheduledForInventoryCron": "string",
    "ScheduledForLaborCron": "string",
    "ScheduledForSubletCron": "string",
    "SentToStripe": "string",
    "ServicePaidAmount": "string",
    "StartDate": "string",
    "StripeInvoiceId": "string",
    "Subtotal": "string",
    "SubtotalWoDiscount": "string",
    "SurchargeInvoiceId": "string",
    "TaxCap": "string",
    "TaxTotal": "string",
    "Title": "string",
    "Total": "string",
    "UpdateHash": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string",
    "WorkOrderId": "string"
}

schema_name_id: 1649
schema_scan_id: 161460327
updated: 2026-04-04 03:04:51

Version 1700921

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceset`\n(\n `Id`  string , `Date`  string , `DolarDiscount`  string , `PercentDiscount`  string , `Active`  string , `ClosingDate`  string , `DiscountTotal`  string , `Opened`  string , `Payed`  string , `Subtotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Title`  string , `Total`  string , `ReservationId`  string , `AccountId`  string , `ServicePaidAmount`  string , `MarinaPaidAmount`  string , `GasPaidAmount`  string , `InvoiceStatusId`  string , `StartDate`  string , `InstalmentsPaymentMethodId`  string , `ScheduledForCron`  string , `OriginalInvoice`  string , `PaymentsSentToXero`  string , `WorkOrderId`  string , `IsInstallmentInvoice`  string , `VoidUser`  string , `VoidDateTime`  string , `CreationUser`  string , `Payment_Id`  string , `QB_Invoice_Id`  string , `InvoiceType_Id`  string , `InvoiceDate`  string , `DueDate`  string , `CurrencyCode`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `VoidReason`  string , `CreatePartnerId`  string , `VoidPartnerId`  string , `UpdateHash`  string , `ScheduledForInventoryCron`  string , `ScheduledForSubletCron`  string , `ScheduledForLaborCron`  string , `CreatedOnMobile`  string , `StripeInvoiceId`  string , `SentToStripe`  string , `ResourceBookingId`  string , `ModifiedOnMobile`  string , `Note`  string , `QuickbooksInvoiceId`  string , `TaxCap`  string , `IsSurcharge`  string , `HashCheck`  string , `IsReversed`  string , `SurchargeInvoiceId`  string , `MarinaLocationId`  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_moloInvoiceSet/2026-04-03/1775203342'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceSet/2026-04-03/1775203342
id: 1700921
processed: 1

raw_data:

{
    "AccountId": 15,
    "Active": 4,
    "ClosingDate": 5,
    "CreatePartnerId": 39,
    "CreatedOnMobile": 45,
    "CreationUser": 29,
    "CurrencyCode": 35,
    "Date": 1,
    "DiscountTotal": 6,
    "DolarDiscount": 2,
    "DueDate": 34,
    "GasPaidAmount": 18,
    "HashCheck": 54,
    "Id": 0,
    "InstalmentsPaymentMethodId": 21,
    "InvoiceDate": 33,
    "InvoiceStatusId": 19,
    "InvoiceType_Id": 32,
    "IsInstallmentInvoice": 26,
    "IsReversed": 55,
    "IsSurcharge": 53,
    "LastModifiedAspNetUser": 37,
    "LastModifiedDateTime": 36,
    "MarinaLocationId": 57,
    "MarinaPaidAmount": 17,
    "ModifiedOnMobile": 49,
    "Note": 50,
    "Opened": 7,
    "OriginalInvoice": 23,
    "Payed": 8,
    "Payment_Id": 30,
    "PaymentsSentToXero": 24,
    "PercentDiscount": 3,
    "QB_Invoice_Id": 31,
    "QuickbooksInvoiceId": 51,
    "ReservationId": 14,
    "ResourceBookingId": 48,
    "ScheduledForCron": 22,
    "ScheduledForInventoryCron": 42,
    "ScheduledForLaborCron": 44,
    "ScheduledForSubletCron": 43,
    "SentToStripe": 47,
    "ServicePaidAmount": 16,
    "StartDate": 20,
    "StripeInvoiceId": 46,
    "Subtotal": 9,
    "SubtotalWoDiscount": 10,
    "SurchargeInvoiceId": 56,
    "TaxCap": 52,
    "TaxTotal": 11,
    "Title": 12,
    "Total": 13,
    "UpdateHash": 41,
    "VoidDateTime": 28,
    "VoidPartnerId": 40,
    "VoidReason": 38,
    "VoidUser": 27,
    "WorkOrderId": 25
}

schema_attributes:

{
    "AccountId": "string",
    "Active": "string",
    "ClosingDate": "string",
    "CreatePartnerId": "string",
    "CreatedOnMobile": "string",
    "CreationUser": "string",
    "CurrencyCode": "string",
    "Date": "string",
    "DiscountTotal": "string",
    "DolarDiscount": "string",
    "DueDate": "string",
    "GasPaidAmount": "string",
    "HashCheck": "string",
    "Id": "string",
    "InstalmentsPaymentMethodId": "string",
    "InvoiceDate": "string",
    "InvoiceStatusId": "string",
    "InvoiceType_Id": "string",
    "IsInstallmentInvoice": "string",
    "IsReversed": "string",
    "IsSurcharge": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "MarinaLocationId": "string",
    "MarinaPaidAmount": "string",
    "ModifiedOnMobile": "string",
    "Note": "string",
    "Opened": "string",
    "OriginalInvoice": "string",
    "Payed": "string",
    "Payment_Id": "string",
    "PaymentsSentToXero": "string",
    "PercentDiscount": "string",
    "QB_Invoice_Id": "string",
    "QuickbooksInvoiceId": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string",
    "ScheduledForCron": "string",
    "ScheduledForInventoryCron": "string",
    "ScheduledForLaborCron": "string",
    "ScheduledForSubletCron": "string",
    "SentToStripe": "string",
    "ServicePaidAmount": "string",
    "StartDate": "string",
    "StripeInvoiceId": "string",
    "Subtotal": "string",
    "SubtotalWoDiscount": "string",
    "SurchargeInvoiceId": "string",
    "TaxCap": "string",
    "TaxTotal": "string",
    "Title": "string",
    "Total": "string",
    "UpdateHash": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string",
    "WorkOrderId": "string"
}

schema_name_id: 1649
schema_scan_id: 161401875
updated: 2026-04-03 03:09:15

Schema Scans: 15

Last at 2026-04-17 03:04:46

Scan 162167600

duration: 0:00:13.183997

exit_message:

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

id: 162167600

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_moloInvoiceSet/2026-04-17/1776412797",
        "key": "raw/molo_moloInvoiceSet/2026-04-17/1776412797/InvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6395711043494092746,
        "service_name": "drive-thru",
        "span_id": 5801479642920273967,
        "trace_id": 6759565194191677615
    }
}

running: False
schema_name_id: 1649
start_time: 2026-04-17 03:04:46
success: True
trace_id: 6759565194191677615

Scan 162111763

duration: 0:00:13.121436

exit_message:

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

id: 162111763

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_moloInvoiceSet/2026-04-16/1776326554",
        "key": "raw/molo_moloInvoiceSet/2026-04-16/1776326554/InvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9034911701794712983,
        "service_name": "drive-thru",
        "span_id": 11930857303842670659,
        "trace_id": 7800617833985675679
    }
}

running: False
schema_name_id: 1649
start_time: 2026-04-16 03:06:14
success: True
trace_id: 7800617833985675679

Scan 162055928

duration: 0:00:15.670137

exit_message:

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

id: 162055928

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_moloInvoiceSet/2026-04-15/1776240023",
        "key": "raw/molo_moloInvoiceSet/2026-04-15/1776240023/InvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14168165621274039014,
        "service_name": "drive-thru",
        "span_id": 12418164101725756862,
        "trace_id": 14311434634485230163
    }
}

running: False
schema_name_id: 1649
start_time: 2026-04-15 03:05:14
success: True
trace_id: 14311434634485230163

Scan 162000409

duration: 0:00:15.786996

exit_message:

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

id: 162000409

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_moloInvoiceSet/2026-04-14/1776153750",
        "key": "raw/molo_moloInvoiceSet/2026-04-14/1776153750/InvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16719912889797508598,
        "service_name": "drive-thru",
        "span_id": 6101223468228018496,
        "trace_id": 1527827535676031148
    }
}

running: False
schema_name_id: 1649
start_time: 2026-04-14 03:04:16
success: True
trace_id: 1527827535676031148

Scan 161941810

duration: 0:00:13.231334

exit_message:

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

id: 161941810

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_moloInvoiceSet/2026-04-13/1776066946",
        "key": "raw/molo_moloInvoiceSet/2026-04-13/1776066946/InvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7130446431780318730,
        "service_name": "drive-thru",
        "span_id": 9491811972593000471,
        "trace_id": 17484419839730761239
    }
}

running: False
schema_name_id: 1649
start_time: 2026-04-13 02:59:48
success: True
trace_id: 17484419839730761239

Scan 161892687

duration: 0:00:15.730079

exit_message:

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

id: 161892687

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_moloInvoiceSet/2026-04-12/1775980658",
        "key": "raw/molo_moloInvoiceSet/2026-04-12/1775980658/InvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6715010943293367389,
        "service_name": "drive-thru",
        "span_id": 13253524250413277667,
        "trace_id": 13116652064807077695
    }
}

running: False
schema_name_id: 1649
start_time: 2026-04-12 03:00:57
success: True
trace_id: 13116652064807077695

Scan 161841170

duration: 0:00:15.710970

exit_message:

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

id: 161841170

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_moloInvoiceSet/2026-04-11/1775894419",
        "key": "raw/molo_moloInvoiceSet/2026-04-11/1775894419/InvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3867106647007165191,
        "service_name": "drive-thru",
        "span_id": 12486019145806464266,
        "trace_id": 17081371255093363572
    }
}

running: False
schema_name_id: 1649
start_time: 2026-04-11 03:04:34
success: True
trace_id: 17081371255093363572

Scan 161786091

duration: 0:00:15.842563

exit_message:

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

id: 161786091

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_moloInvoiceSet/2026-04-10/1775808176",
        "key": "raw/molo_moloInvoiceSet/2026-04-10/1775808176/InvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18076743305570093887,
        "service_name": "drive-thru",
        "span_id": 6452726985319626354,
        "trace_id": 16880777949172911430
    }
}

running: False
schema_name_id: 1649
start_time: 2026-04-10 03:11:30
success: True
trace_id: 16880777949172911430

Scan 161730139

duration: 0:00:13.274587

exit_message:

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

id: 161730139

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_moloInvoiceSet/2026-04-09/1775721513",
        "key": "raw/molo_moloInvoiceSet/2026-04-09/1775721513/InvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9995804362197216011,
        "service_name": "drive-thru",
        "span_id": 4080770335861234940,
        "trace_id": 5878397859098442035
    }
}

running: False
schema_name_id: 1649
start_time: 2026-04-09 03:02:06
success: True
trace_id: 5878397859098442035

Scan 161675653

duration: 0:00:15.937897

exit_message:

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

id: 161675653

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_moloInvoiceSet/2026-04-08/1775635344",
        "key": "raw/molo_moloInvoiceSet/2026-04-08/1775635344/InvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17559142774707287938,
        "service_name": "drive-thru",
        "span_id": 7767173655116820891,
        "trace_id": 13928383231228769531
    }
}

running: False
schema_name_id: 1649
start_time: 2026-04-08 03:09:17
success: True
trace_id: 13928383231228769531

Scan 161618397

duration: 0:00:13.052585

exit_message:

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

id: 161618397

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_moloInvoiceSet/2026-04-07/1775548495",
        "key": "raw/molo_moloInvoiceSet/2026-04-07/1775548495/InvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13827606386722839799,
        "service_name": "drive-thru",
        "span_id": 8203093687910294684,
        "trace_id": 2773253427515448710
    }
}

running: False
schema_name_id: 1649
start_time: 2026-04-07 02:56:49
success: True
trace_id: 2773253427515448710

Scan 161561745

duration: 0:00:13.232604

exit_message:

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

id: 161561745

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_moloInvoiceSet/2026-04-06/1775462460",
        "key": "raw/molo_moloInvoiceSet/2026-04-06/1775462460/InvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16181038213298148113,
        "service_name": "drive-thru",
        "span_id": 8503796611412213007,
        "trace_id": 11344809515641682790
    }
}

running: False
schema_name_id: 1649
start_time: 2026-04-06 03:10:14
success: True
trace_id: 11344809515641682790

Scan 161514822

duration: 0:00:15.592806

exit_message:

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

id: 161514822

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_moloInvoiceSet/2026-04-05/1775376087",
        "key": "raw/molo_moloInvoiceSet/2026-04-05/1775376087/InvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3278263028685379792,
        "service_name": "drive-thru",
        "span_id": 1177207020625403914,
        "trace_id": 6646919930233783155
    }
}

running: False
schema_name_id: 1649
start_time: 2026-04-05 03:03:09
success: True
trace_id: 6646919930233783155

Scan 161460327

duration: 0:00:15.642320

exit_message:

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

id: 161460327

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_moloInvoiceSet/2026-04-04/1775289570",
        "key": "raw/molo_moloInvoiceSet/2026-04-04/1775289570/InvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14132821460666790685,
        "service_name": "drive-thru",
        "span_id": 3903530540825938207,
        "trace_id": 5542778468135358608
    }
}

running: False
schema_name_id: 1649
start_time: 2026-04-04 03:04:35
success: True
trace_id: 5542778468135358608

Scan 161401875

duration: 0:00:13.255750

exit_message:

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

id: 161401875

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_moloInvoiceSet/2026-04-03/1775203342",
        "key": "raw/molo_moloInvoiceSet/2026-04-03/1775203342/InvoiceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5789248611596133552,
        "service_name": "drive-thru",
        "span_id": 4129023599905700128,
        "trace_id": 10422755151855381821
    }
}

running: False
schema_name_id: 1649
start_time: 2026-04-03 03:09:02
success: True
trace_id: 10422755151855381821

Partitions:

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

Schema:

attributes:

{
    "AccountId": "string",
    "Active": "string",
    "ClosingDate": "string",
    "CreatePartnerId": "string",
    "CreatedOnMobile": "string",
    "CreationUser": "string",
    "CurrencyCode": "string",
    "Date": "string",
    "DiscountTotal": "string",
    "DolarDiscount": "string",
    "DueDate": "string",
    "GasPaidAmount": "string",
    "HashCheck": "string",
    "Id": "string",
    "InstalmentsPaymentMethodId": "string",
    "InvoiceDate": "string",
    "InvoiceStatusId": "string",
    "InvoiceType_Id": "string",
    "IsInstallmentInvoice": "string",
    "IsReversed": "string",
    "IsSurcharge": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "MarinaLocationId": "string",
    "MarinaPaidAmount": "string",
    "ModifiedOnMobile": "string",
    "Note": "string",
    "Opened": "string",
    "OriginalInvoice": "string",
    "Payed": "string",
    "Payment_Id": "string",
    "PaymentsSentToXero": "string",
    "PercentDiscount": "string",
    "QB_Invoice_Id": "string",
    "QuickbooksInvoiceId": "string",
    "ReservationId": "string",
    "ResourceBookingId": "string",
    "ScheduledForCron": "string",
    "ScheduledForInventoryCron": "string",
    "ScheduledForLaborCron": "string",
    "ScheduledForSubletCron": "string",
    "SentToStripe": "string",
    "ServicePaidAmount": "string",
    "StartDate": "string",
    "StripeInvoiceId": "string",
    "Subtotal": "string",
    "SubtotalWoDiscount": "string",
    "SurchargeInvoiceId": "string",
    "TaxCap": "string",
    "TaxTotal": "string",
    "Title": "string",
    "Total": "string",
    "UpdateHash": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string",
    "WorkOrderId": "string"
}

created: 2026-04-17 03:04:48

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceset`\n(\n `Id`  string , `Date`  string , `DolarDiscount`  string , `PercentDiscount`  string , `Active`  string , `ClosingDate`  string , `DiscountTotal`  string , `Opened`  string , `Payed`  string , `Subtotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Title`  string , `Total`  string , `ReservationId`  string , `AccountId`  string , `ServicePaidAmount`  string , `MarinaPaidAmount`  string , `GasPaidAmount`  string , `InvoiceStatusId`  string , `StartDate`  string , `InstalmentsPaymentMethodId`  string , `ScheduledForCron`  string , `OriginalInvoice`  string , `PaymentsSentToXero`  string , `WorkOrderId`  string , `IsInstallmentInvoice`  string , `VoidUser`  string , `VoidDateTime`  string , `CreationUser`  string , `Payment_Id`  string , `QB_Invoice_Id`  string , `InvoiceType_Id`  string , `InvoiceDate`  string , `DueDate`  string , `CurrencyCode`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `VoidReason`  string , `CreatePartnerId`  string , `VoidPartnerId`  string , `UpdateHash`  string , `ScheduledForInventoryCron`  string , `ScheduledForSubletCron`  string , `ScheduledForLaborCron`  string , `CreatedOnMobile`  string , `StripeInvoiceId`  string , `SentToStripe`  string , `ResourceBookingId`  string , `ModifiedOnMobile`  string , `Note`  string , `QuickbooksInvoiceId`  string , `TaxCap`  string , `IsSurcharge`  string , `HashCheck`  string , `IsReversed`  string , `SurchargeInvoiceId`  string , `MarinaLocationId`  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_moloInvoiceSet/2026-04-17/1776412797'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceset"
}

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:57:03",
        "disabled": false,
        "format": "raw",
        "id": 1649,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloinvoiceset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AccountId": "string",
            "Active": "string",
            "ClosingDate": "string",
            "CreatePartnerId": "string",
            "CreatedOnMobile": "string",
            "CreationUser": "string",
            "CurrencyCode": "string",
            "Date": "string",
            "DiscountTotal": "string",
            "DolarDiscount": "string",
            "DueDate": "string",
            "GasPaidAmount": "string",
            "HashCheck": "string",
            "Id": "string",
            "InstalmentsPaymentMethodId": "string",
            "InvoiceDate": "string",
            "InvoiceStatusId": "string",
            "InvoiceType_Id": "string",
            "IsInstallmentInvoice": "string",
            "IsReversed": "string",
            "IsSurcharge": "string",
            "LastModifiedAspNetUser": "string",
            "LastModifiedDateTime": "string",
            "MarinaLocationId": "string",
            "MarinaPaidAmount": "string",
            "ModifiedOnMobile": "string",
            "Note": "string",
            "Opened": "string",
            "OriginalInvoice": "string",
            "Payed": "string",
            "Payment_Id": "string",
            "PaymentsSentToXero": "string",
            "PercentDiscount": "string",
            "QB_Invoice_Id": "string",
            "QuickbooksInvoiceId": "string",
            "ReservationId": "string",
            "ResourceBookingId": "string",
            "ScheduledForCron": "string",
            "ScheduledForInventoryCron": "string",
            "ScheduledForLaborCron": "string",
            "ScheduledForSubletCron": "string",
            "SentToStripe": "string",
            "ServicePaidAmount": "string",
            "StartDate": "string",
            "StripeInvoiceId": "string",
            "Subtotal": "string",
            "SubtotalWoDiscount": "string",
            "SurchargeInvoiceId": "string",
            "TaxCap": "string",
            "TaxTotal": "string",
            "Title": "string",
            "Total": "string",
            "UpdateHash": "string",
            "VoidDateTime": "string",
            "VoidPartnerId": "string",
            "VoidReason": "string",
            "VoidUser": "string",
            "WorkOrderId": "string"
        },
        "created": "2026-04-17 03:04:48",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceset`\n(\n `Id`  string , `Date`  string , `DolarDiscount`  string , `PercentDiscount`  string , `Active`  string , `ClosingDate`  string , `DiscountTotal`  string , `Opened`  string , `Payed`  string , `Subtotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Title`  string , `Total`  string , `ReservationId`  string , `AccountId`  string , `ServicePaidAmount`  string , `MarinaPaidAmount`  string , `GasPaidAmount`  string , `InvoiceStatusId`  string , `StartDate`  string , `InstalmentsPaymentMethodId`  string , `ScheduledForCron`  string , `OriginalInvoice`  string , `PaymentsSentToXero`  string , `WorkOrderId`  string , `IsInstallmentInvoice`  string , `VoidUser`  string , `VoidDateTime`  string , `CreationUser`  string , `Payment_Id`  string , `QB_Invoice_Id`  string , `InvoiceType_Id`  string , `InvoiceDate`  string , `DueDate`  string , `CurrencyCode`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `VoidReason`  string , `CreatePartnerId`  string , `VoidPartnerId`  string , `UpdateHash`  string , `ScheduledForInventoryCron`  string , `ScheduledForSubletCron`  string , `ScheduledForLaborCron`  string , `CreatedOnMobile`  string , `StripeInvoiceId`  string , `SentToStripe`  string , `ResourceBookingId`  string , `ModifiedOnMobile`  string , `Note`  string , `QuickbooksInvoiceId`  string , `TaxCap`  string , `IsSurcharge`  string , `HashCheck`  string , `IsReversed`  string , `SurchargeInvoiceId`  string , `MarinaLocationId`  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_moloInvoiceSet/2026-04-17/1776412797'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}