Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloreservations
  • created: 2023-10-17 01:59:59
  • disabled: False
  • format: raw
  • id: 1732
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_prod_drivethru",
    "table": "molo_moloreservations"
}
  • type: drivethrucsv
Schema Versions: 15
    • created: 2026-04-17 03:05:19
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreservations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreservations`\n(\n `Id`  string , `MarinaLocationId`  string , `CreationTime`  string , `ReservationStatusId`  string , `ReservationTypeId`  string , `AspNetUserId`  string , `ContactId`  string , `BoatId`  string , `ScheduledArrivalTime`  string , `ScheduledDepartureTime`  string , `CancellationTime`  string , `AccountId`  string , `SlipId`  string , `SlipSlotIndex`  string , `DistanceFromTheStart`  string , `Rate`  string , `Name`  string , `HasInstallments`  string , `InstallmentFrequency`  string , `InstallmentNumber`  string , `InstallmentPaymentMethod`  string , `OnlyReservationInstallments`  string , `Notes`  string , `ActualArrivalDateTime`  string , `ActualDepartureDateTime`  string , `ConfirmationEmailDateTime`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedLocation`  string , `CustomerIPAddress`  string , `CustomerDevice`  string , `ConfirmationEmailAspUser_Id`  string , `RatePriceOverride`  string , `HashID`  string , `ReservationSource`  string , `ReservationMedium_Id`  string , `ReservationCampaign_Id`  string , `MoloAPI_Partner_Id`  string , `CancelationUserId`  string , `ContactMerged`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `PrintedTerms`  string , `OnlineTerms`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `MoloOnlineBooking`  string , `BookingContactMerged`  string , `SlipBlockSet_Id`  string , `OffersId`  string , `RecurringInvoiceDay`  string , `AlternateReservationName`  string , `RecurringDiscountPercent`  string , `RecurringRateOverride`  string , `OnlineBookingNotes`  string , `OriginalOfferHoldId`  string , `ScheduledForStatusChange`  string , `TermsOffline`  string , `TermsUser`  string , `OriginalStartDate`  string , `OriginalEndDate`  string , `ContractTypeId`  string , `MinimumChargeMethod`  string , `OnlineBookingOptIn`  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_moloReservations/2026-04-17/1776412846'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreservations"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReservations/2026-04-17/1776412846
    • id: 1717653
    • processed: 1
    • raw_data: 
      {
    "AccountId": 11,
    "ActualArrivalDateTime": 23,
    "ActualDepartureDateTime": 24,
    "AlternateReservationName": 51,
    "AspNetUserId": 5,
    "BoatId": 7,
    "BookingContactMerged": 47,
    "CancelationUserId": 37,
    "CancellationTime": 10,
    "CheckInTerms": 43,
    "CheckOutTerms": 44,
    "ConfirmationEmailAspUser_Id": 30,
    "ConfirmationEmailDateTime": 25,
    "ContactId": 6,
    "ContactMerged": 38,
    "ContractTypeId": 61,
    "CreationTime": 2,
    "CustomerDevice": 29,
    "CustomerIPAddress": 28,
    "DistanceFromTheStart": 14,
    "HasInstallments": 17,
    "HashID": 32,
    "Id": 0,
    "InstallmentFrequency": 18,
    "InstallmentNumber": 19,
    "InstallmentPaymentMethod": 20,
    "MarinaLocationId": 1,
    "MinimumChargeMethod": 62,
    "MoloAPI_Partner_Id": 36,
    "MoloOnlineBooking": 46,
    "Name": 16,
    "Notes": 22,
    "OffersId": 49,
    "OnlineBookingNotes": 54,
    "OnlineBookingOptIn": 63,
    "OnlinePaymentCompletion": 45,
    "OnlineTerms": 42,
    "OnlyReservationInstallments": 21,
    "OriginalEndDate": 60,
    "OriginalOfferHoldId": 55,
    "OriginalStartDate": 59,
    "PrintedTerms": 41,
    "Rate": 15,
    "RatePriceOverride": 31,
    "RecurringDiscountPercent": 52,
    "RecurringInvoiceDay": 50,
    "RecurringRateOverride": 53,
    "ReservationCampaign_Id": 35,
    "ReservationMedium_Id": 34,
    "ReservationSource": 33,
    "ReservationStatusId": 3,
    "ReservationTypeId": 4,
    "ScheduledArrivalTime": 8,
    "ScheduledDepartureTime": 9,
    "ScheduledForStatusChange": 56,
    "SeasonalPriceId": 40,
    "SlipBlockSet_Id": 48,
    "SlipId": 12,
    "SlipSlotIndex": 13,
    "TermsAcceptedDateTime": 26,
    "TermsAcceptedLocation": 27,
    "TermsOffline": 57,
    "TermsUser": 58,
    "TransientPriceId": 39
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActualArrivalDateTime": "string",
    "ActualDepartureDateTime": "string",
    "AlternateReservationName": "string",
    "AspNetUserId": "string",
    "BoatId": "string",
    "BookingContactMerged": "string",
    "CancelationUserId": "string",
    "CancellationTime": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "ConfirmationEmailAspUser_Id": "string",
    "ConfirmationEmailDateTime": "string",
    "ContactId": "string",
    "ContactMerged": "string",
    "ContractTypeId": "string",
    "CreationTime": "string",
    "CustomerDevice": "string",
    "CustomerIPAddress": "string",
    "DistanceFromTheStart": "string",
    "HasInstallments": "string",
    "HashID": "string",
    "Id": "string",
    "InstallmentFrequency": "string",
    "InstallmentNumber": "string",
    "InstallmentPaymentMethod": "string",
    "MarinaLocationId": "string",
    "MinimumChargeMethod": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloOnlineBooking": "string",
    "Name": "string",
    "Notes": "string",
    "OffersId": "string",
    "OnlineBookingNotes": "string",
    "OnlineBookingOptIn": "string",
    "OnlinePaymentCompletion": "string",
    "OnlineTerms": "string",
    "OnlyReservationInstallments": "string",
    "OriginalEndDate": "string",
    "OriginalOfferHoldId": "string",
    "OriginalStartDate": "string",
    "PrintedTerms": "string",
    "Rate": "string",
    "RatePriceOverride": "string",
    "RecurringDiscountPercent": "string",
    "RecurringInvoiceDay": "string",
    "RecurringRateOverride": "string",
    "ReservationCampaign_Id": "string",
    "ReservationMedium_Id": "string",
    "ReservationSource": "string",
    "ReservationStatusId": "string",
    "ReservationTypeId": "string",
    "ScheduledArrivalTime": "string",
    "ScheduledDepartureTime": "string",
    "ScheduledForStatusChange": "string",
    "SeasonalPriceId": "string",
    "SlipBlockSet_Id": "string",
    "SlipId": "string",
    "SlipSlotIndex": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedLocation": "string",
    "TermsOffline": "string",
    "TermsUser": "string",
    "TransientPriceId": "string"
}
    • schema_name_id: 1732
    • schema_scan_id: 162167616
    • updated: 2026-04-17 03:05:33
    • created: 2026-04-16 03:13:57
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreservations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreservations`\n(\n `Id`  string , `MarinaLocationId`  string , `CreationTime`  string , `ReservationStatusId`  string , `ReservationTypeId`  string , `AspNetUserId`  string , `ContactId`  string , `BoatId`  string , `ScheduledArrivalTime`  string , `ScheduledDepartureTime`  string , `CancellationTime`  string , `AccountId`  string , `SlipId`  string , `SlipSlotIndex`  string , `DistanceFromTheStart`  string , `Rate`  string , `Name`  string , `HasInstallments`  string , `InstallmentFrequency`  string , `InstallmentNumber`  string , `InstallmentPaymentMethod`  string , `OnlyReservationInstallments`  string , `Notes`  string , `ActualArrivalDateTime`  string , `ActualDepartureDateTime`  string , `ConfirmationEmailDateTime`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedLocation`  string , `CustomerIPAddress`  string , `CustomerDevice`  string , `ConfirmationEmailAspUser_Id`  string , `RatePriceOverride`  string , `HashID`  string , `ReservationSource`  string , `ReservationMedium_Id`  string , `ReservationCampaign_Id`  string , `MoloAPI_Partner_Id`  string , `CancelationUserId`  string , `ContactMerged`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `PrintedTerms`  string , `OnlineTerms`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `MoloOnlineBooking`  string , `BookingContactMerged`  string , `SlipBlockSet_Id`  string , `OffersId`  string , `RecurringInvoiceDay`  string , `AlternateReservationName`  string , `RecurringDiscountPercent`  string , `RecurringRateOverride`  string , `OnlineBookingNotes`  string , `OriginalOfferHoldId`  string , `ScheduledForStatusChange`  string , `TermsOffline`  string , `TermsUser`  string , `OriginalStartDate`  string , `OriginalEndDate`  string , `ContractTypeId`  string , `MinimumChargeMethod`  string , `OnlineBookingOptIn`  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_moloReservations/2026-04-16/1776326599'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreservations"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReservations/2026-04-16/1776326599
    • id: 1716562
    • processed: 1
    • raw_data: 
      {
    "AccountId": 11,
    "ActualArrivalDateTime": 23,
    "ActualDepartureDateTime": 24,
    "AlternateReservationName": 51,
    "AspNetUserId": 5,
    "BoatId": 7,
    "BookingContactMerged": 47,
    "CancelationUserId": 37,
    "CancellationTime": 10,
    "CheckInTerms": 43,
    "CheckOutTerms": 44,
    "ConfirmationEmailAspUser_Id": 30,
    "ConfirmationEmailDateTime": 25,
    "ContactId": 6,
    "ContactMerged": 38,
    "ContractTypeId": 61,
    "CreationTime": 2,
    "CustomerDevice": 29,
    "CustomerIPAddress": 28,
    "DistanceFromTheStart": 14,
    "HasInstallments": 17,
    "HashID": 32,
    "Id": 0,
    "InstallmentFrequency": 18,
    "InstallmentNumber": 19,
    "InstallmentPaymentMethod": 20,
    "MarinaLocationId": 1,
    "MinimumChargeMethod": 62,
    "MoloAPI_Partner_Id": 36,
    "MoloOnlineBooking": 46,
    "Name": 16,
    "Notes": 22,
    "OffersId": 49,
    "OnlineBookingNotes": 54,
    "OnlineBookingOptIn": 63,
    "OnlinePaymentCompletion": 45,
    "OnlineTerms": 42,
    "OnlyReservationInstallments": 21,
    "OriginalEndDate": 60,
    "OriginalOfferHoldId": 55,
    "OriginalStartDate": 59,
    "PrintedTerms": 41,
    "Rate": 15,
    "RatePriceOverride": 31,
    "RecurringDiscountPercent": 52,
    "RecurringInvoiceDay": 50,
    "RecurringRateOverride": 53,
    "ReservationCampaign_Id": 35,
    "ReservationMedium_Id": 34,
    "ReservationSource": 33,
    "ReservationStatusId": 3,
    "ReservationTypeId": 4,
    "ScheduledArrivalTime": 8,
    "ScheduledDepartureTime": 9,
    "ScheduledForStatusChange": 56,
    "SeasonalPriceId": 40,
    "SlipBlockSet_Id": 48,
    "SlipId": 12,
    "SlipSlotIndex": 13,
    "TermsAcceptedDateTime": 26,
    "TermsAcceptedLocation": 27,
    "TermsOffline": 57,
    "TermsUser": 58,
    "TransientPriceId": 39
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActualArrivalDateTime": "string",
    "ActualDepartureDateTime": "string",
    "AlternateReservationName": "string",
    "AspNetUserId": "string",
    "BoatId": "string",
    "BookingContactMerged": "string",
    "CancelationUserId": "string",
    "CancellationTime": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "ConfirmationEmailAspUser_Id": "string",
    "ConfirmationEmailDateTime": "string",
    "ContactId": "string",
    "ContactMerged": "string",
    "ContractTypeId": "string",
    "CreationTime": "string",
    "CustomerDevice": "string",
    "CustomerIPAddress": "string",
    "DistanceFromTheStart": "string",
    "HasInstallments": "string",
    "HashID": "string",
    "Id": "string",
    "InstallmentFrequency": "string",
    "InstallmentNumber": "string",
    "InstallmentPaymentMethod": "string",
    "MarinaLocationId": "string",
    "MinimumChargeMethod": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloOnlineBooking": "string",
    "Name": "string",
    "Notes": "string",
    "OffersId": "string",
    "OnlineBookingNotes": "string",
    "OnlineBookingOptIn": "string",
    "OnlinePaymentCompletion": "string",
    "OnlineTerms": "string",
    "OnlyReservationInstallments": "string",
    "OriginalEndDate": "string",
    "OriginalOfferHoldId": "string",
    "OriginalStartDate": "string",
    "PrintedTerms": "string",
    "Rate": "string",
    "RatePriceOverride": "string",
    "RecurringDiscountPercent": "string",
    "RecurringInvoiceDay": "string",
    "RecurringRateOverride": "string",
    "ReservationCampaign_Id": "string",
    "ReservationMedium_Id": "string",
    "ReservationSource": "string",
    "ReservationStatusId": "string",
    "ReservationTypeId": "string",
    "ScheduledArrivalTime": "string",
    "ScheduledDepartureTime": "string",
    "ScheduledForStatusChange": "string",
    "SeasonalPriceId": "string",
    "SlipBlockSet_Id": "string",
    "SlipId": "string",
    "SlipSlotIndex": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedLocation": "string",
    "TermsOffline": "string",
    "TermsUser": "string",
    "TransientPriceId": "string"
}
    • schema_name_id: 1732
    • schema_scan_id: 162112021
    • updated: 2026-04-16 03:14:08
    • created: 2026-04-15 03:07:08
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreservations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreservations`\n(\n `Id`  string , `MarinaLocationId`  string , `CreationTime`  string , `ReservationStatusId`  string , `ReservationTypeId`  string , `AspNetUserId`  string , `ContactId`  string , `BoatId`  string , `ScheduledArrivalTime`  string , `ScheduledDepartureTime`  string , `CancellationTime`  string , `AccountId`  string , `SlipId`  string , `SlipSlotIndex`  string , `DistanceFromTheStart`  string , `Rate`  string , `Name`  string , `HasInstallments`  string , `InstallmentFrequency`  string , `InstallmentNumber`  string , `InstallmentPaymentMethod`  string , `OnlyReservationInstallments`  string , `Notes`  string , `ActualArrivalDateTime`  string , `ActualDepartureDateTime`  string , `ConfirmationEmailDateTime`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedLocation`  string , `CustomerIPAddress`  string , `CustomerDevice`  string , `ConfirmationEmailAspUser_Id`  string , `RatePriceOverride`  string , `HashID`  string , `ReservationSource`  string , `ReservationMedium_Id`  string , `ReservationCampaign_Id`  string , `MoloAPI_Partner_Id`  string , `CancelationUserId`  string , `ContactMerged`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `PrintedTerms`  string , `OnlineTerms`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `MoloOnlineBooking`  string , `BookingContactMerged`  string , `SlipBlockSet_Id`  string , `OffersId`  string , `RecurringInvoiceDay`  string , `AlternateReservationName`  string , `RecurringDiscountPercent`  string , `RecurringRateOverride`  string , `OnlineBookingNotes`  string , `OriginalOfferHoldId`  string , `ScheduledForStatusChange`  string , `TermsOffline`  string , `TermsUser`  string , `OriginalStartDate`  string , `OriginalEndDate`  string , `ContractTypeId`  string , `MinimumChargeMethod`  string , `OnlineBookingOptIn`  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_moloReservations/2026-04-15/1776240069'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreservations"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReservations/2026-04-15/1776240069
    • id: 1715257
    • processed: 1
    • raw_data: 
      {
    "AccountId": 11,
    "ActualArrivalDateTime": 23,
    "ActualDepartureDateTime": 24,
    "AlternateReservationName": 51,
    "AspNetUserId": 5,
    "BoatId": 7,
    "BookingContactMerged": 47,
    "CancelationUserId": 37,
    "CancellationTime": 10,
    "CheckInTerms": 43,
    "CheckOutTerms": 44,
    "ConfirmationEmailAspUser_Id": 30,
    "ConfirmationEmailDateTime": 25,
    "ContactId": 6,
    "ContactMerged": 38,
    "ContractTypeId": 61,
    "CreationTime": 2,
    "CustomerDevice": 29,
    "CustomerIPAddress": 28,
    "DistanceFromTheStart": 14,
    "HasInstallments": 17,
    "HashID": 32,
    "Id": 0,
    "InstallmentFrequency": 18,
    "InstallmentNumber": 19,
    "InstallmentPaymentMethod": 20,
    "MarinaLocationId": 1,
    "MinimumChargeMethod": 62,
    "MoloAPI_Partner_Id": 36,
    "MoloOnlineBooking": 46,
    "Name": 16,
    "Notes": 22,
    "OffersId": 49,
    "OnlineBookingNotes": 54,
    "OnlineBookingOptIn": 63,
    "OnlinePaymentCompletion": 45,
    "OnlineTerms": 42,
    "OnlyReservationInstallments": 21,
    "OriginalEndDate": 60,
    "OriginalOfferHoldId": 55,
    "OriginalStartDate": 59,
    "PrintedTerms": 41,
    "Rate": 15,
    "RatePriceOverride": 31,
    "RecurringDiscountPercent": 52,
    "RecurringInvoiceDay": 50,
    "RecurringRateOverride": 53,
    "ReservationCampaign_Id": 35,
    "ReservationMedium_Id": 34,
    "ReservationSource": 33,
    "ReservationStatusId": 3,
    "ReservationTypeId": 4,
    "ScheduledArrivalTime": 8,
    "ScheduledDepartureTime": 9,
    "ScheduledForStatusChange": 56,
    "SeasonalPriceId": 40,
    "SlipBlockSet_Id": 48,
    "SlipId": 12,
    "SlipSlotIndex": 13,
    "TermsAcceptedDateTime": 26,
    "TermsAcceptedLocation": 27,
    "TermsOffline": 57,
    "TermsUser": 58,
    "TransientPriceId": 39
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActualArrivalDateTime": "string",
    "ActualDepartureDateTime": "string",
    "AlternateReservationName": "string",
    "AspNetUserId": "string",
    "BoatId": "string",
    "BookingContactMerged": "string",
    "CancelationUserId": "string",
    "CancellationTime": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "ConfirmationEmailAspUser_Id": "string",
    "ConfirmationEmailDateTime": "string",
    "ContactId": "string",
    "ContactMerged": "string",
    "ContractTypeId": "string",
    "CreationTime": "string",
    "CustomerDevice": "string",
    "CustomerIPAddress": "string",
    "DistanceFromTheStart": "string",
    "HasInstallments": "string",
    "HashID": "string",
    "Id": "string",
    "InstallmentFrequency": "string",
    "InstallmentNumber": "string",
    "InstallmentPaymentMethod": "string",
    "MarinaLocationId": "string",
    "MinimumChargeMethod": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloOnlineBooking": "string",
    "Name": "string",
    "Notes": "string",
    "OffersId": "string",
    "OnlineBookingNotes": "string",
    "OnlineBookingOptIn": "string",
    "OnlinePaymentCompletion": "string",
    "OnlineTerms": "string",
    "OnlyReservationInstallments": "string",
    "OriginalEndDate": "string",
    "OriginalOfferHoldId": "string",
    "OriginalStartDate": "string",
    "PrintedTerms": "string",
    "Rate": "string",
    "RatePriceOverride": "string",
    "RecurringDiscountPercent": "string",
    "RecurringInvoiceDay": "string",
    "RecurringRateOverride": "string",
    "ReservationCampaign_Id": "string",
    "ReservationMedium_Id": "string",
    "ReservationSource": "string",
    "ReservationStatusId": "string",
    "ReservationTypeId": "string",
    "ScheduledArrivalTime": "string",
    "ScheduledDepartureTime": "string",
    "ScheduledForStatusChange": "string",
    "SeasonalPriceId": "string",
    "SlipBlockSet_Id": "string",
    "SlipId": "string",
    "SlipSlotIndex": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedLocation": "string",
    "TermsOffline": "string",
    "TermsUser": "string",
    "TransientPriceId": "string"
}
    • schema_name_id: 1732
    • schema_scan_id: 162056002
    • updated: 2026-04-15 03:07:19
    • created: 2026-04-14 03:09:21
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreservations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreservations`\n(\n `Id`  string , `MarinaLocationId`  string , `CreationTime`  string , `ReservationStatusId`  string , `ReservationTypeId`  string , `AspNetUserId`  string , `ContactId`  string , `BoatId`  string , `ScheduledArrivalTime`  string , `ScheduledDepartureTime`  string , `CancellationTime`  string , `AccountId`  string , `SlipId`  string , `SlipSlotIndex`  string , `DistanceFromTheStart`  string , `Rate`  string , `Name`  string , `HasInstallments`  string , `InstallmentFrequency`  string , `InstallmentNumber`  string , `InstallmentPaymentMethod`  string , `OnlyReservationInstallments`  string , `Notes`  string , `ActualArrivalDateTime`  string , `ActualDepartureDateTime`  string , `ConfirmationEmailDateTime`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedLocation`  string , `CustomerIPAddress`  string , `CustomerDevice`  string , `ConfirmationEmailAspUser_Id`  string , `RatePriceOverride`  string , `HashID`  string , `ReservationSource`  string , `ReservationMedium_Id`  string , `ReservationCampaign_Id`  string , `MoloAPI_Partner_Id`  string , `CancelationUserId`  string , `ContactMerged`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `PrintedTerms`  string , `OnlineTerms`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `MoloOnlineBooking`  string , `BookingContactMerged`  string , `SlipBlockSet_Id`  string , `OffersId`  string , `RecurringInvoiceDay`  string , `AlternateReservationName`  string , `RecurringDiscountPercent`  string , `RecurringRateOverride`  string , `OnlineBookingNotes`  string , `OriginalOfferHoldId`  string , `ScheduledForStatusChange`  string , `TermsOffline`  string , `TermsUser`  string , `OriginalStartDate`  string , `OriginalEndDate`  string , `ContractTypeId`  string , `MinimumChargeMethod`  string , `OnlineBookingOptIn`  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_moloReservations/2026-04-14/1776153834'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreservations"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReservations/2026-04-14/1776153834
    • id: 1714100
    • processed: 1
    • raw_data: 
      {
    "AccountId": 11,
    "ActualArrivalDateTime": 23,
    "ActualDepartureDateTime": 24,
    "AlternateReservationName": 51,
    "AspNetUserId": 5,
    "BoatId": 7,
    "BookingContactMerged": 47,
    "CancelationUserId": 37,
    "CancellationTime": 10,
    "CheckInTerms": 43,
    "CheckOutTerms": 44,
    "ConfirmationEmailAspUser_Id": 30,
    "ConfirmationEmailDateTime": 25,
    "ContactId": 6,
    "ContactMerged": 38,
    "ContractTypeId": 61,
    "CreationTime": 2,
    "CustomerDevice": 29,
    "CustomerIPAddress": 28,
    "DistanceFromTheStart": 14,
    "HasInstallments": 17,
    "HashID": 32,
    "Id": 0,
    "InstallmentFrequency": 18,
    "InstallmentNumber": 19,
    "InstallmentPaymentMethod": 20,
    "MarinaLocationId": 1,
    "MinimumChargeMethod": 62,
    "MoloAPI_Partner_Id": 36,
    "MoloOnlineBooking": 46,
    "Name": 16,
    "Notes": 22,
    "OffersId": 49,
    "OnlineBookingNotes": 54,
    "OnlineBookingOptIn": 63,
    "OnlinePaymentCompletion": 45,
    "OnlineTerms": 42,
    "OnlyReservationInstallments": 21,
    "OriginalEndDate": 60,
    "OriginalOfferHoldId": 55,
    "OriginalStartDate": 59,
    "PrintedTerms": 41,
    "Rate": 15,
    "RatePriceOverride": 31,
    "RecurringDiscountPercent": 52,
    "RecurringInvoiceDay": 50,
    "RecurringRateOverride": 53,
    "ReservationCampaign_Id": 35,
    "ReservationMedium_Id": 34,
    "ReservationSource": 33,
    "ReservationStatusId": 3,
    "ReservationTypeId": 4,
    "ScheduledArrivalTime": 8,
    "ScheduledDepartureTime": 9,
    "ScheduledForStatusChange": 56,
    "SeasonalPriceId": 40,
    "SlipBlockSet_Id": 48,
    "SlipId": 12,
    "SlipSlotIndex": 13,
    "TermsAcceptedDateTime": 26,
    "TermsAcceptedLocation": 27,
    "TermsOffline": 57,
    "TermsUser": 58,
    "TransientPriceId": 39
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActualArrivalDateTime": "string",
    "ActualDepartureDateTime": "string",
    "AlternateReservationName": "string",
    "AspNetUserId": "string",
    "BoatId": "string",
    "BookingContactMerged": "string",
    "CancelationUserId": "string",
    "CancellationTime": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "ConfirmationEmailAspUser_Id": "string",
    "ConfirmationEmailDateTime": "string",
    "ContactId": "string",
    "ContactMerged": "string",
    "ContractTypeId": "string",
    "CreationTime": "string",
    "CustomerDevice": "string",
    "CustomerIPAddress": "string",
    "DistanceFromTheStart": "string",
    "HasInstallments": "string",
    "HashID": "string",
    "Id": "string",
    "InstallmentFrequency": "string",
    "InstallmentNumber": "string",
    "InstallmentPaymentMethod": "string",
    "MarinaLocationId": "string",
    "MinimumChargeMethod": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloOnlineBooking": "string",
    "Name": "string",
    "Notes": "string",
    "OffersId": "string",
    "OnlineBookingNotes": "string",
    "OnlineBookingOptIn": "string",
    "OnlinePaymentCompletion": "string",
    "OnlineTerms": "string",
    "OnlyReservationInstallments": "string",
    "OriginalEndDate": "string",
    "OriginalOfferHoldId": "string",
    "OriginalStartDate": "string",
    "PrintedTerms": "string",
    "Rate": "string",
    "RatePriceOverride": "string",
    "RecurringDiscountPercent": "string",
    "RecurringInvoiceDay": "string",
    "RecurringRateOverride": "string",
    "ReservationCampaign_Id": "string",
    "ReservationMedium_Id": "string",
    "ReservationSource": "string",
    "ReservationStatusId": "string",
    "ReservationTypeId": "string",
    "ScheduledArrivalTime": "string",
    "ScheduledDepartureTime": "string",
    "ScheduledForStatusChange": "string",
    "SeasonalPriceId": "string",
    "SlipBlockSet_Id": "string",
    "SlipId": "string",
    "SlipSlotIndex": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedLocation": "string",
    "TermsOffline": "string",
    "TermsUser": "string",
    "TransientPriceId": "string"
}
    • schema_name_id: 1732
    • schema_scan_id: 162000608
    • updated: 2026-04-14 03:09:35
    • created: 2026-04-13 03:00:56
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreservations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreservations`\n(\n `Id`  string , `MarinaLocationId`  string , `CreationTime`  string , `ReservationStatusId`  string , `ReservationTypeId`  string , `AspNetUserId`  string , `ContactId`  string , `BoatId`  string , `ScheduledArrivalTime`  string , `ScheduledDepartureTime`  string , `CancellationTime`  string , `AccountId`  string , `SlipId`  string , `SlipSlotIndex`  string , `DistanceFromTheStart`  string , `Rate`  string , `Name`  string , `HasInstallments`  string , `InstallmentFrequency`  string , `InstallmentNumber`  string , `InstallmentPaymentMethod`  string , `OnlyReservationInstallments`  string , `Notes`  string , `ActualArrivalDateTime`  string , `ActualDepartureDateTime`  string , `ConfirmationEmailDateTime`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedLocation`  string , `CustomerIPAddress`  string , `CustomerDevice`  string , `ConfirmationEmailAspUser_Id`  string , `RatePriceOverride`  string , `HashID`  string , `ReservationSource`  string , `ReservationMedium_Id`  string , `ReservationCampaign_Id`  string , `MoloAPI_Partner_Id`  string , `CancelationUserId`  string , `ContactMerged`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `PrintedTerms`  string , `OnlineTerms`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `MoloOnlineBooking`  string , `BookingContactMerged`  string , `SlipBlockSet_Id`  string , `OffersId`  string , `RecurringInvoiceDay`  string , `AlternateReservationName`  string , `RecurringDiscountPercent`  string , `RecurringRateOverride`  string , `OnlineBookingNotes`  string , `OriginalOfferHoldId`  string , `ScheduledForStatusChange`  string , `TermsOffline`  string , `TermsUser`  string , `OriginalStartDate`  string , `OriginalEndDate`  string , `ContractTypeId`  string , `MinimumChargeMethod`  string , `OnlineBookingOptIn`  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_moloReservations/2026-04-13/1776066995'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreservations"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReservations/2026-04-13/1776066995
    • id: 1712857
    • processed: 1
    • raw_data: 
      {
    "AccountId": 11,
    "ActualArrivalDateTime": 23,
    "ActualDepartureDateTime": 24,
    "AlternateReservationName": 51,
    "AspNetUserId": 5,
    "BoatId": 7,
    "BookingContactMerged": 47,
    "CancelationUserId": 37,
    "CancellationTime": 10,
    "CheckInTerms": 43,
    "CheckOutTerms": 44,
    "ConfirmationEmailAspUser_Id": 30,
    "ConfirmationEmailDateTime": 25,
    "ContactId": 6,
    "ContactMerged": 38,
    "ContractTypeId": 61,
    "CreationTime": 2,
    "CustomerDevice": 29,
    "CustomerIPAddress": 28,
    "DistanceFromTheStart": 14,
    "HasInstallments": 17,
    "HashID": 32,
    "Id": 0,
    "InstallmentFrequency": 18,
    "InstallmentNumber": 19,
    "InstallmentPaymentMethod": 20,
    "MarinaLocationId": 1,
    "MinimumChargeMethod": 62,
    "MoloAPI_Partner_Id": 36,
    "MoloOnlineBooking": 46,
    "Name": 16,
    "Notes": 22,
    "OffersId": 49,
    "OnlineBookingNotes": 54,
    "OnlineBookingOptIn": 63,
    "OnlinePaymentCompletion": 45,
    "OnlineTerms": 42,
    "OnlyReservationInstallments": 21,
    "OriginalEndDate": 60,
    "OriginalOfferHoldId": 55,
    "OriginalStartDate": 59,
    "PrintedTerms": 41,
    "Rate": 15,
    "RatePriceOverride": 31,
    "RecurringDiscountPercent": 52,
    "RecurringInvoiceDay": 50,
    "RecurringRateOverride": 53,
    "ReservationCampaign_Id": 35,
    "ReservationMedium_Id": 34,
    "ReservationSource": 33,
    "ReservationStatusId": 3,
    "ReservationTypeId": 4,
    "ScheduledArrivalTime": 8,
    "ScheduledDepartureTime": 9,
    "ScheduledForStatusChange": 56,
    "SeasonalPriceId": 40,
    "SlipBlockSet_Id": 48,
    "SlipId": 12,
    "SlipSlotIndex": 13,
    "TermsAcceptedDateTime": 26,
    "TermsAcceptedLocation": 27,
    "TermsOffline": 57,
    "TermsUser": 58,
    "TransientPriceId": 39
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActualArrivalDateTime": "string",
    "ActualDepartureDateTime": "string",
    "AlternateReservationName": "string",
    "AspNetUserId": "string",
    "BoatId": "string",
    "BookingContactMerged": "string",
    "CancelationUserId": "string",
    "CancellationTime": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "ConfirmationEmailAspUser_Id": "string",
    "ConfirmationEmailDateTime": "string",
    "ContactId": "string",
    "ContactMerged": "string",
    "ContractTypeId": "string",
    "CreationTime": "string",
    "CustomerDevice": "string",
    "CustomerIPAddress": "string",
    "DistanceFromTheStart": "string",
    "HasInstallments": "string",
    "HashID": "string",
    "Id": "string",
    "InstallmentFrequency": "string",
    "InstallmentNumber": "string",
    "InstallmentPaymentMethod": "string",
    "MarinaLocationId": "string",
    "MinimumChargeMethod": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloOnlineBooking": "string",
    "Name": "string",
    "Notes": "string",
    "OffersId": "string",
    "OnlineBookingNotes": "string",
    "OnlineBookingOptIn": "string",
    "OnlinePaymentCompletion": "string",
    "OnlineTerms": "string",
    "OnlyReservationInstallments": "string",
    "OriginalEndDate": "string",
    "OriginalOfferHoldId": "string",
    "OriginalStartDate": "string",
    "PrintedTerms": "string",
    "Rate": "string",
    "RatePriceOverride": "string",
    "RecurringDiscountPercent": "string",
    "RecurringInvoiceDay": "string",
    "RecurringRateOverride": "string",
    "ReservationCampaign_Id": "string",
    "ReservationMedium_Id": "string",
    "ReservationSource": "string",
    "ReservationStatusId": "string",
    "ReservationTypeId": "string",
    "ScheduledArrivalTime": "string",
    "ScheduledDepartureTime": "string",
    "ScheduledForStatusChange": "string",
    "SeasonalPriceId": "string",
    "SlipBlockSet_Id": "string",
    "SlipId": "string",
    "SlipSlotIndex": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedLocation": "string",
    "TermsOffline": "string",
    "TermsUser": "string",
    "TransientPriceId": "string"
}
    • schema_name_id: 1732
    • schema_scan_id: 161941961
    • updated: 2026-04-13 03:01:07
    • created: 2026-04-12 03:03:12
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreservations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreservations`\n(\n `Id`  string , `MarinaLocationId`  string , `CreationTime`  string , `ReservationStatusId`  string , `ReservationTypeId`  string , `AspNetUserId`  string , `ContactId`  string , `BoatId`  string , `ScheduledArrivalTime`  string , `ScheduledDepartureTime`  string , `CancellationTime`  string , `AccountId`  string , `SlipId`  string , `SlipSlotIndex`  string , `DistanceFromTheStart`  string , `Rate`  string , `Name`  string , `HasInstallments`  string , `InstallmentFrequency`  string , `InstallmentNumber`  string , `InstallmentPaymentMethod`  string , `OnlyReservationInstallments`  string , `Notes`  string , `ActualArrivalDateTime`  string , `ActualDepartureDateTime`  string , `ConfirmationEmailDateTime`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedLocation`  string , `CustomerIPAddress`  string , `CustomerDevice`  string , `ConfirmationEmailAspUser_Id`  string , `RatePriceOverride`  string , `HashID`  string , `ReservationSource`  string , `ReservationMedium_Id`  string , `ReservationCampaign_Id`  string , `MoloAPI_Partner_Id`  string , `CancelationUserId`  string , `ContactMerged`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `PrintedTerms`  string , `OnlineTerms`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `MoloOnlineBooking`  string , `BookingContactMerged`  string , `SlipBlockSet_Id`  string , `OffersId`  string , `RecurringInvoiceDay`  string , `AlternateReservationName`  string , `RecurringDiscountPercent`  string , `RecurringRateOverride`  string , `OnlineBookingNotes`  string , `OriginalOfferHoldId`  string , `ScheduledForStatusChange`  string , `TermsOffline`  string , `TermsUser`  string , `OriginalStartDate`  string , `OriginalEndDate`  string , `ContractTypeId`  string , `MinimumChargeMethod`  string , `OnlineBookingOptIn`  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_moloReservations/2026-04-12/1775980704'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreservations"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReservations/2026-04-12/1775980704
    • id: 1711664
    • processed: 1
    • raw_data: 
      {
    "AccountId": 11,
    "ActualArrivalDateTime": 23,
    "ActualDepartureDateTime": 24,
    "AlternateReservationName": 51,
    "AspNetUserId": 5,
    "BoatId": 7,
    "BookingContactMerged": 47,
    "CancelationUserId": 37,
    "CancellationTime": 10,
    "CheckInTerms": 43,
    "CheckOutTerms": 44,
    "ConfirmationEmailAspUser_Id": 30,
    "ConfirmationEmailDateTime": 25,
    "ContactId": 6,
    "ContactMerged": 38,
    "ContractTypeId": 61,
    "CreationTime": 2,
    "CustomerDevice": 29,
    "CustomerIPAddress": 28,
    "DistanceFromTheStart": 14,
    "HasInstallments": 17,
    "HashID": 32,
    "Id": 0,
    "InstallmentFrequency": 18,
    "InstallmentNumber": 19,
    "InstallmentPaymentMethod": 20,
    "MarinaLocationId": 1,
    "MinimumChargeMethod": 62,
    "MoloAPI_Partner_Id": 36,
    "MoloOnlineBooking": 46,
    "Name": 16,
    "Notes": 22,
    "OffersId": 49,
    "OnlineBookingNotes": 54,
    "OnlineBookingOptIn": 63,
    "OnlinePaymentCompletion": 45,
    "OnlineTerms": 42,
    "OnlyReservationInstallments": 21,
    "OriginalEndDate": 60,
    "OriginalOfferHoldId": 55,
    "OriginalStartDate": 59,
    "PrintedTerms": 41,
    "Rate": 15,
    "RatePriceOverride": 31,
    "RecurringDiscountPercent": 52,
    "RecurringInvoiceDay": 50,
    "RecurringRateOverride": 53,
    "ReservationCampaign_Id": 35,
    "ReservationMedium_Id": 34,
    "ReservationSource": 33,
    "ReservationStatusId": 3,
    "ReservationTypeId": 4,
    "ScheduledArrivalTime": 8,
    "ScheduledDepartureTime": 9,
    "ScheduledForStatusChange": 56,
    "SeasonalPriceId": 40,
    "SlipBlockSet_Id": 48,
    "SlipId": 12,
    "SlipSlotIndex": 13,
    "TermsAcceptedDateTime": 26,
    "TermsAcceptedLocation": 27,
    "TermsOffline": 57,
    "TermsUser": 58,
    "TransientPriceId": 39
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActualArrivalDateTime": "string",
    "ActualDepartureDateTime": "string",
    "AlternateReservationName": "string",
    "AspNetUserId": "string",
    "BoatId": "string",
    "BookingContactMerged": "string",
    "CancelationUserId": "string",
    "CancellationTime": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "ConfirmationEmailAspUser_Id": "string",
    "ConfirmationEmailDateTime": "string",
    "ContactId": "string",
    "ContactMerged": "string",
    "ContractTypeId": "string",
    "CreationTime": "string",
    "CustomerDevice": "string",
    "CustomerIPAddress": "string",
    "DistanceFromTheStart": "string",
    "HasInstallments": "string",
    "HashID": "string",
    "Id": "string",
    "InstallmentFrequency": "string",
    "InstallmentNumber": "string",
    "InstallmentPaymentMethod": "string",
    "MarinaLocationId": "string",
    "MinimumChargeMethod": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloOnlineBooking": "string",
    "Name": "string",
    "Notes": "string",
    "OffersId": "string",
    "OnlineBookingNotes": "string",
    "OnlineBookingOptIn": "string",
    "OnlinePaymentCompletion": "string",
    "OnlineTerms": "string",
    "OnlyReservationInstallments": "string",
    "OriginalEndDate": "string",
    "OriginalOfferHoldId": "string",
    "OriginalStartDate": "string",
    "PrintedTerms": "string",
    "Rate": "string",
    "RatePriceOverride": "string",
    "RecurringDiscountPercent": "string",
    "RecurringInvoiceDay": "string",
    "RecurringRateOverride": "string",
    "ReservationCampaign_Id": "string",
    "ReservationMedium_Id": "string",
    "ReservationSource": "string",
    "ReservationStatusId": "string",
    "ReservationTypeId": "string",
    "ScheduledArrivalTime": "string",
    "ScheduledDepartureTime": "string",
    "ScheduledForStatusChange": "string",
    "SeasonalPriceId": "string",
    "SlipBlockSet_Id": "string",
    "SlipId": "string",
    "SlipSlotIndex": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedLocation": "string",
    "TermsOffline": "string",
    "TermsUser": "string",
    "TransientPriceId": "string"
}
    • schema_name_id: 1732
    • schema_scan_id: 161893040
    • updated: 2026-04-12 03:03:26
    • created: 2026-04-11 03:04:52
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreservations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreservations`\n(\n `Id`  string , `MarinaLocationId`  string , `CreationTime`  string , `ReservationStatusId`  string , `ReservationTypeId`  string , `AspNetUserId`  string , `ContactId`  string , `BoatId`  string , `ScheduledArrivalTime`  string , `ScheduledDepartureTime`  string , `CancellationTime`  string , `AccountId`  string , `SlipId`  string , `SlipSlotIndex`  string , `DistanceFromTheStart`  string , `Rate`  string , `Name`  string , `HasInstallments`  string , `InstallmentFrequency`  string , `InstallmentNumber`  string , `InstallmentPaymentMethod`  string , `OnlyReservationInstallments`  string , `Notes`  string , `ActualArrivalDateTime`  string , `ActualDepartureDateTime`  string , `ConfirmationEmailDateTime`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedLocation`  string , `CustomerIPAddress`  string , `CustomerDevice`  string , `ConfirmationEmailAspUser_Id`  string , `RatePriceOverride`  string , `HashID`  string , `ReservationSource`  string , `ReservationMedium_Id`  string , `ReservationCampaign_Id`  string , `MoloAPI_Partner_Id`  string , `CancelationUserId`  string , `ContactMerged`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `PrintedTerms`  string , `OnlineTerms`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `MoloOnlineBooking`  string , `BookingContactMerged`  string , `SlipBlockSet_Id`  string , `OffersId`  string , `RecurringInvoiceDay`  string , `AlternateReservationName`  string , `RecurringDiscountPercent`  string , `RecurringRateOverride`  string , `OnlineBookingNotes`  string , `OriginalOfferHoldId`  string , `ScheduledForStatusChange`  string , `TermsOffline`  string , `TermsUser`  string , `OriginalStartDate`  string , `OriginalEndDate`  string , `ContractTypeId`  string , `MinimumChargeMethod`  string , `OnlineBookingOptIn`  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_moloReservations/2026-04-11/1775894471'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreservations"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReservations/2026-04-11/1775894471
    • id: 1710410
    • processed: 1
    • raw_data: 
      {
    "AccountId": 11,
    "ActualArrivalDateTime": 23,
    "ActualDepartureDateTime": 24,
    "AlternateReservationName": 51,
    "AspNetUserId": 5,
    "BoatId": 7,
    "BookingContactMerged": 47,
    "CancelationUserId": 37,
    "CancellationTime": 10,
    "CheckInTerms": 43,
    "CheckOutTerms": 44,
    "ConfirmationEmailAspUser_Id": 30,
    "ConfirmationEmailDateTime": 25,
    "ContactId": 6,
    "ContactMerged": 38,
    "ContractTypeId": 61,
    "CreationTime": 2,
    "CustomerDevice": 29,
    "CustomerIPAddress": 28,
    "DistanceFromTheStart": 14,
    "HasInstallments": 17,
    "HashID": 32,
    "Id": 0,
    "InstallmentFrequency": 18,
    "InstallmentNumber": 19,
    "InstallmentPaymentMethod": 20,
    "MarinaLocationId": 1,
    "MinimumChargeMethod": 62,
    "MoloAPI_Partner_Id": 36,
    "MoloOnlineBooking": 46,
    "Name": 16,
    "Notes": 22,
    "OffersId": 49,
    "OnlineBookingNotes": 54,
    "OnlineBookingOptIn": 63,
    "OnlinePaymentCompletion": 45,
    "OnlineTerms": 42,
    "OnlyReservationInstallments": 21,
    "OriginalEndDate": 60,
    "OriginalOfferHoldId": 55,
    "OriginalStartDate": 59,
    "PrintedTerms": 41,
    "Rate": 15,
    "RatePriceOverride": 31,
    "RecurringDiscountPercent": 52,
    "RecurringInvoiceDay": 50,
    "RecurringRateOverride": 53,
    "ReservationCampaign_Id": 35,
    "ReservationMedium_Id": 34,
    "ReservationSource": 33,
    "ReservationStatusId": 3,
    "ReservationTypeId": 4,
    "ScheduledArrivalTime": 8,
    "ScheduledDepartureTime": 9,
    "ScheduledForStatusChange": 56,
    "SeasonalPriceId": 40,
    "SlipBlockSet_Id": 48,
    "SlipId": 12,
    "SlipSlotIndex": 13,
    "TermsAcceptedDateTime": 26,
    "TermsAcceptedLocation": 27,
    "TermsOffline": 57,
    "TermsUser": 58,
    "TransientPriceId": 39
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActualArrivalDateTime": "string",
    "ActualDepartureDateTime": "string",
    "AlternateReservationName": "string",
    "AspNetUserId": "string",
    "BoatId": "string",
    "BookingContactMerged": "string",
    "CancelationUserId": "string",
    "CancellationTime": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "ConfirmationEmailAspUser_Id": "string",
    "ConfirmationEmailDateTime": "string",
    "ContactId": "string",
    "ContactMerged": "string",
    "ContractTypeId": "string",
    "CreationTime": "string",
    "CustomerDevice": "string",
    "CustomerIPAddress": "string",
    "DistanceFromTheStart": "string",
    "HasInstallments": "string",
    "HashID": "string",
    "Id": "string",
    "InstallmentFrequency": "string",
    "InstallmentNumber": "string",
    "InstallmentPaymentMethod": "string",
    "MarinaLocationId": "string",
    "MinimumChargeMethod": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloOnlineBooking": "string",
    "Name": "string",
    "Notes": "string",
    "OffersId": "string",
    "OnlineBookingNotes": "string",
    "OnlineBookingOptIn": "string",
    "OnlinePaymentCompletion": "string",
    "OnlineTerms": "string",
    "OnlyReservationInstallments": "string",
    "OriginalEndDate": "string",
    "OriginalOfferHoldId": "string",
    "OriginalStartDate": "string",
    "PrintedTerms": "string",
    "Rate": "string",
    "RatePriceOverride": "string",
    "RecurringDiscountPercent": "string",
    "RecurringInvoiceDay": "string",
    "RecurringRateOverride": "string",
    "ReservationCampaign_Id": "string",
    "ReservationMedium_Id": "string",
    "ReservationSource": "string",
    "ReservationStatusId": "string",
    "ReservationTypeId": "string",
    "ScheduledArrivalTime": "string",
    "ScheduledDepartureTime": "string",
    "ScheduledForStatusChange": "string",
    "SeasonalPriceId": "string",
    "SlipBlockSet_Id": "string",
    "SlipId": "string",
    "SlipSlotIndex": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedLocation": "string",
    "TermsOffline": "string",
    "TermsUser": "string",
    "TransientPriceId": "string"
}
    • schema_name_id: 1732
    • schema_scan_id: 161841183
    • updated: 2026-04-11 03:05:06
    • created: 2026-04-10 03:06:50
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreservations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreservations`\n(\n `Id`  string , `MarinaLocationId`  string , `CreationTime`  string , `ReservationStatusId`  string , `ReservationTypeId`  string , `AspNetUserId`  string , `ContactId`  string , `BoatId`  string , `ScheduledArrivalTime`  string , `ScheduledDepartureTime`  string , `CancellationTime`  string , `AccountId`  string , `SlipId`  string , `SlipSlotIndex`  string , `DistanceFromTheStart`  string , `Rate`  string , `Name`  string , `HasInstallments`  string , `InstallmentFrequency`  string , `InstallmentNumber`  string , `InstallmentPaymentMethod`  string , `OnlyReservationInstallments`  string , `Notes`  string , `ActualArrivalDateTime`  string , `ActualDepartureDateTime`  string , `ConfirmationEmailDateTime`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedLocation`  string , `CustomerIPAddress`  string , `CustomerDevice`  string , `ConfirmationEmailAspUser_Id`  string , `RatePriceOverride`  string , `HashID`  string , `ReservationSource`  string , `ReservationMedium_Id`  string , `ReservationCampaign_Id`  string , `MoloAPI_Partner_Id`  string , `CancelationUserId`  string , `ContactMerged`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `PrintedTerms`  string , `OnlineTerms`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `MoloOnlineBooking`  string , `BookingContactMerged`  string , `SlipBlockSet_Id`  string , `OffersId`  string , `RecurringInvoiceDay`  string , `AlternateReservationName`  string , `RecurringDiscountPercent`  string , `RecurringRateOverride`  string , `OnlineBookingNotes`  string , `OriginalOfferHoldId`  string , `ScheduledForStatusChange`  string , `TermsOffline`  string , `TermsUser`  string , `OriginalStartDate`  string , `OriginalEndDate`  string , `ContractTypeId`  string , `MinimumChargeMethod`  string , `OnlineBookingOptIn`  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_moloReservations/2026-04-10/1775808229'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreservations"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReservations/2026-04-10/1775808229
    • id: 1709265
    • processed: 1
    • raw_data: 
      {
    "AccountId": 11,
    "ActualArrivalDateTime": 23,
    "ActualDepartureDateTime": 24,
    "AlternateReservationName": 51,
    "AspNetUserId": 5,
    "BoatId": 7,
    "BookingContactMerged": 47,
    "CancelationUserId": 37,
    "CancellationTime": 10,
    "CheckInTerms": 43,
    "CheckOutTerms": 44,
    "ConfirmationEmailAspUser_Id": 30,
    "ConfirmationEmailDateTime": 25,
    "ContactId": 6,
    "ContactMerged": 38,
    "ContractTypeId": 61,
    "CreationTime": 2,
    "CustomerDevice": 29,
    "CustomerIPAddress": 28,
    "DistanceFromTheStart": 14,
    "HasInstallments": 17,
    "HashID": 32,
    "Id": 0,
    "InstallmentFrequency": 18,
    "InstallmentNumber": 19,
    "InstallmentPaymentMethod": 20,
    "MarinaLocationId": 1,
    "MinimumChargeMethod": 62,
    "MoloAPI_Partner_Id": 36,
    "MoloOnlineBooking": 46,
    "Name": 16,
    "Notes": 22,
    "OffersId": 49,
    "OnlineBookingNotes": 54,
    "OnlineBookingOptIn": 63,
    "OnlinePaymentCompletion": 45,
    "OnlineTerms": 42,
    "OnlyReservationInstallments": 21,
    "OriginalEndDate": 60,
    "OriginalOfferHoldId": 55,
    "OriginalStartDate": 59,
    "PrintedTerms": 41,
    "Rate": 15,
    "RatePriceOverride": 31,
    "RecurringDiscountPercent": 52,
    "RecurringInvoiceDay": 50,
    "RecurringRateOverride": 53,
    "ReservationCampaign_Id": 35,
    "ReservationMedium_Id": 34,
    "ReservationSource": 33,
    "ReservationStatusId": 3,
    "ReservationTypeId": 4,
    "ScheduledArrivalTime": 8,
    "ScheduledDepartureTime": 9,
    "ScheduledForStatusChange": 56,
    "SeasonalPriceId": 40,
    "SlipBlockSet_Id": 48,
    "SlipId": 12,
    "SlipSlotIndex": 13,
    "TermsAcceptedDateTime": 26,
    "TermsAcceptedLocation": 27,
    "TermsOffline": 57,
    "TermsUser": 58,
    "TransientPriceId": 39
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActualArrivalDateTime": "string",
    "ActualDepartureDateTime": "string",
    "AlternateReservationName": "string",
    "AspNetUserId": "string",
    "BoatId": "string",
    "BookingContactMerged": "string",
    "CancelationUserId": "string",
    "CancellationTime": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "ConfirmationEmailAspUser_Id": "string",
    "ConfirmationEmailDateTime": "string",
    "ContactId": "string",
    "ContactMerged": "string",
    "ContractTypeId": "string",
    "CreationTime": "string",
    "CustomerDevice": "string",
    "CustomerIPAddress": "string",
    "DistanceFromTheStart": "string",
    "HasInstallments": "string",
    "HashID": "string",
    "Id": "string",
    "InstallmentFrequency": "string",
    "InstallmentNumber": "string",
    "InstallmentPaymentMethod": "string",
    "MarinaLocationId": "string",
    "MinimumChargeMethod": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloOnlineBooking": "string",
    "Name": "string",
    "Notes": "string",
    "OffersId": "string",
    "OnlineBookingNotes": "string",
    "OnlineBookingOptIn": "string",
    "OnlinePaymentCompletion": "string",
    "OnlineTerms": "string",
    "OnlyReservationInstallments": "string",
    "OriginalEndDate": "string",
    "OriginalOfferHoldId": "string",
    "OriginalStartDate": "string",
    "PrintedTerms": "string",
    "Rate": "string",
    "RatePriceOverride": "string",
    "RecurringDiscountPercent": "string",
    "RecurringInvoiceDay": "string",
    "RecurringRateOverride": "string",
    "ReservationCampaign_Id": "string",
    "ReservationMedium_Id": "string",
    "ReservationSource": "string",
    "ReservationStatusId": "string",
    "ReservationTypeId": "string",
    "ScheduledArrivalTime": "string",
    "ScheduledDepartureTime": "string",
    "ScheduledForStatusChange": "string",
    "SeasonalPriceId": "string",
    "SlipBlockSet_Id": "string",
    "SlipId": "string",
    "SlipSlotIndex": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedLocation": "string",
    "TermsOffline": "string",
    "TermsUser": "string",
    "TransientPriceId": "string"
}
    • schema_name_id: 1732
    • schema_scan_id: 161785953
    • updated: 2026-04-10 03:07:01
    • created: 2026-04-09 03:06:50
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreservations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreservations`\n(\n `Id`  string , `MarinaLocationId`  string , `CreationTime`  string , `ReservationStatusId`  string , `ReservationTypeId`  string , `AspNetUserId`  string , `ContactId`  string , `BoatId`  string , `ScheduledArrivalTime`  string , `ScheduledDepartureTime`  string , `CancellationTime`  string , `AccountId`  string , `SlipId`  string , `SlipSlotIndex`  string , `DistanceFromTheStart`  string , `Rate`  string , `Name`  string , `HasInstallments`  string , `InstallmentFrequency`  string , `InstallmentNumber`  string , `InstallmentPaymentMethod`  string , `OnlyReservationInstallments`  string , `Notes`  string , `ActualArrivalDateTime`  string , `ActualDepartureDateTime`  string , `ConfirmationEmailDateTime`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedLocation`  string , `CustomerIPAddress`  string , `CustomerDevice`  string , `ConfirmationEmailAspUser_Id`  string , `RatePriceOverride`  string , `HashID`  string , `ReservationSource`  string , `ReservationMedium_Id`  string , `ReservationCampaign_Id`  string , `MoloAPI_Partner_Id`  string , `CancelationUserId`  string , `ContactMerged`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `PrintedTerms`  string , `OnlineTerms`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `MoloOnlineBooking`  string , `BookingContactMerged`  string , `SlipBlockSet_Id`  string , `OffersId`  string , `RecurringInvoiceDay`  string , `AlternateReservationName`  string , `RecurringDiscountPercent`  string , `RecurringRateOverride`  string , `OnlineBookingNotes`  string , `OriginalOfferHoldId`  string , `ScheduledForStatusChange`  string , `TermsOffline`  string , `TermsUser`  string , `OriginalStartDate`  string , `OriginalEndDate`  string , `ContractTypeId`  string , `MinimumChargeMethod`  string , `OnlineBookingOptIn`  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_moloReservations/2026-04-09/1775721562'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreservations"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReservations/2026-04-09/1775721562
    • id: 1708198
    • processed: 1
    • raw_data: 
      {
    "AccountId": 11,
    "ActualArrivalDateTime": 23,
    "ActualDepartureDateTime": 24,
    "AlternateReservationName": 51,
    "AspNetUserId": 5,
    "BoatId": 7,
    "BookingContactMerged": 47,
    "CancelationUserId": 37,
    "CancellationTime": 10,
    "CheckInTerms": 43,
    "CheckOutTerms": 44,
    "ConfirmationEmailAspUser_Id": 30,
    "ConfirmationEmailDateTime": 25,
    "ContactId": 6,
    "ContactMerged": 38,
    "ContractTypeId": 61,
    "CreationTime": 2,
    "CustomerDevice": 29,
    "CustomerIPAddress": 28,
    "DistanceFromTheStart": 14,
    "HasInstallments": 17,
    "HashID": 32,
    "Id": 0,
    "InstallmentFrequency": 18,
    "InstallmentNumber": 19,
    "InstallmentPaymentMethod": 20,
    "MarinaLocationId": 1,
    "MinimumChargeMethod": 62,
    "MoloAPI_Partner_Id": 36,
    "MoloOnlineBooking": 46,
    "Name": 16,
    "Notes": 22,
    "OffersId": 49,
    "OnlineBookingNotes": 54,
    "OnlineBookingOptIn": 63,
    "OnlinePaymentCompletion": 45,
    "OnlineTerms": 42,
    "OnlyReservationInstallments": 21,
    "OriginalEndDate": 60,
    "OriginalOfferHoldId": 55,
    "OriginalStartDate": 59,
    "PrintedTerms": 41,
    "Rate": 15,
    "RatePriceOverride": 31,
    "RecurringDiscountPercent": 52,
    "RecurringInvoiceDay": 50,
    "RecurringRateOverride": 53,
    "ReservationCampaign_Id": 35,
    "ReservationMedium_Id": 34,
    "ReservationSource": 33,
    "ReservationStatusId": 3,
    "ReservationTypeId": 4,
    "ScheduledArrivalTime": 8,
    "ScheduledDepartureTime": 9,
    "ScheduledForStatusChange": 56,
    "SeasonalPriceId": 40,
    "SlipBlockSet_Id": 48,
    "SlipId": 12,
    "SlipSlotIndex": 13,
    "TermsAcceptedDateTime": 26,
    "TermsAcceptedLocation": 27,
    "TermsOffline": 57,
    "TermsUser": 58,
    "TransientPriceId": 39
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActualArrivalDateTime": "string",
    "ActualDepartureDateTime": "string",
    "AlternateReservationName": "string",
    "AspNetUserId": "string",
    "BoatId": "string",
    "BookingContactMerged": "string",
    "CancelationUserId": "string",
    "CancellationTime": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "ConfirmationEmailAspUser_Id": "string",
    "ConfirmationEmailDateTime": "string",
    "ContactId": "string",
    "ContactMerged": "string",
    "ContractTypeId": "string",
    "CreationTime": "string",
    "CustomerDevice": "string",
    "CustomerIPAddress": "string",
    "DistanceFromTheStart": "string",
    "HasInstallments": "string",
    "HashID": "string",
    "Id": "string",
    "InstallmentFrequency": "string",
    "InstallmentNumber": "string",
    "InstallmentPaymentMethod": "string",
    "MarinaLocationId": "string",
    "MinimumChargeMethod": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloOnlineBooking": "string",
    "Name": "string",
    "Notes": "string",
    "OffersId": "string",
    "OnlineBookingNotes": "string",
    "OnlineBookingOptIn": "string",
    "OnlinePaymentCompletion": "string",
    "OnlineTerms": "string",
    "OnlyReservationInstallments": "string",
    "OriginalEndDate": "string",
    "OriginalOfferHoldId": "string",
    "OriginalStartDate": "string",
    "PrintedTerms": "string",
    "Rate": "string",
    "RatePriceOverride": "string",
    "RecurringDiscountPercent": "string",
    "RecurringInvoiceDay": "string",
    "RecurringRateOverride": "string",
    "ReservationCampaign_Id": "string",
    "ReservationMedium_Id": "string",
    "ReservationSource": "string",
    "ReservationStatusId": "string",
    "ReservationTypeId": "string",
    "ScheduledArrivalTime": "string",
    "ScheduledDepartureTime": "string",
    "ScheduledForStatusChange": "string",
    "SeasonalPriceId": "string",
    "SlipBlockSet_Id": "string",
    "SlipId": "string",
    "SlipSlotIndex": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedLocation": "string",
    "TermsOffline": "string",
    "TermsUser": "string",
    "TransientPriceId": "string"
}
    • schema_name_id: 1732
    • schema_scan_id: 161730439
    • updated: 2026-04-09 03:07:02
    • created: 2026-04-08 03:04:33
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreservations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreservations`\n(\n `Id`  string , `MarinaLocationId`  string , `CreationTime`  string , `ReservationStatusId`  string , `ReservationTypeId`  string , `AspNetUserId`  string , `ContactId`  string , `BoatId`  string , `ScheduledArrivalTime`  string , `ScheduledDepartureTime`  string , `CancellationTime`  string , `AccountId`  string , `SlipId`  string , `SlipSlotIndex`  string , `DistanceFromTheStart`  string , `Rate`  string , `Name`  string , `HasInstallments`  string , `InstallmentFrequency`  string , `InstallmentNumber`  string , `InstallmentPaymentMethod`  string , `OnlyReservationInstallments`  string , `Notes`  string , `ActualArrivalDateTime`  string , `ActualDepartureDateTime`  string , `ConfirmationEmailDateTime`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedLocation`  string , `CustomerIPAddress`  string , `CustomerDevice`  string , `ConfirmationEmailAspUser_Id`  string , `RatePriceOverride`  string , `HashID`  string , `ReservationSource`  string , `ReservationMedium_Id`  string , `ReservationCampaign_Id`  string , `MoloAPI_Partner_Id`  string , `CancelationUserId`  string , `ContactMerged`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `PrintedTerms`  string , `OnlineTerms`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `MoloOnlineBooking`  string , `BookingContactMerged`  string , `SlipBlockSet_Id`  string , `OffersId`  string , `RecurringInvoiceDay`  string , `AlternateReservationName`  string , `RecurringDiscountPercent`  string , `RecurringRateOverride`  string , `OnlineBookingNotes`  string , `OriginalOfferHoldId`  string , `ScheduledForStatusChange`  string , `TermsOffline`  string , `TermsUser`  string , `OriginalStartDate`  string , `OriginalEndDate`  string , `ContractTypeId`  string , `MinimumChargeMethod`  string , `OnlineBookingOptIn`  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_moloReservations/2026-04-08/1775635391'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreservations"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReservations/2026-04-08/1775635391
    • id: 1706881
    • processed: 1
    • raw_data: 
      {
    "AccountId": 11,
    "ActualArrivalDateTime": 23,
    "ActualDepartureDateTime": 24,
    "AlternateReservationName": 51,
    "AspNetUserId": 5,
    "BoatId": 7,
    "BookingContactMerged": 47,
    "CancelationUserId": 37,
    "CancellationTime": 10,
    "CheckInTerms": 43,
    "CheckOutTerms": 44,
    "ConfirmationEmailAspUser_Id": 30,
    "ConfirmationEmailDateTime": 25,
    "ContactId": 6,
    "ContactMerged": 38,
    "ContractTypeId": 61,
    "CreationTime": 2,
    "CustomerDevice": 29,
    "CustomerIPAddress": 28,
    "DistanceFromTheStart": 14,
    "HasInstallments": 17,
    "HashID": 32,
    "Id": 0,
    "InstallmentFrequency": 18,
    "InstallmentNumber": 19,
    "InstallmentPaymentMethod": 20,
    "MarinaLocationId": 1,
    "MinimumChargeMethod": 62,
    "MoloAPI_Partner_Id": 36,
    "MoloOnlineBooking": 46,
    "Name": 16,
    "Notes": 22,
    "OffersId": 49,
    "OnlineBookingNotes": 54,
    "OnlineBookingOptIn": 63,
    "OnlinePaymentCompletion": 45,
    "OnlineTerms": 42,
    "OnlyReservationInstallments": 21,
    "OriginalEndDate": 60,
    "OriginalOfferHoldId": 55,
    "OriginalStartDate": 59,
    "PrintedTerms": 41,
    "Rate": 15,
    "RatePriceOverride": 31,
    "RecurringDiscountPercent": 52,
    "RecurringInvoiceDay": 50,
    "RecurringRateOverride": 53,
    "ReservationCampaign_Id": 35,
    "ReservationMedium_Id": 34,
    "ReservationSource": 33,
    "ReservationStatusId": 3,
    "ReservationTypeId": 4,
    "ScheduledArrivalTime": 8,
    "ScheduledDepartureTime": 9,
    "ScheduledForStatusChange": 56,
    "SeasonalPriceId": 40,
    "SlipBlockSet_Id": 48,
    "SlipId": 12,
    "SlipSlotIndex": 13,
    "TermsAcceptedDateTime": 26,
    "TermsAcceptedLocation": 27,
    "TermsOffline": 57,
    "TermsUser": 58,
    "TransientPriceId": 39
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActualArrivalDateTime": "string",
    "ActualDepartureDateTime": "string",
    "AlternateReservationName": "string",
    "AspNetUserId": "string",
    "BoatId": "string",
    "BookingContactMerged": "string",
    "CancelationUserId": "string",
    "CancellationTime": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "ConfirmationEmailAspUser_Id": "string",
    "ConfirmationEmailDateTime": "string",
    "ContactId": "string",
    "ContactMerged": "string",
    "ContractTypeId": "string",
    "CreationTime": "string",
    "CustomerDevice": "string",
    "CustomerIPAddress": "string",
    "DistanceFromTheStart": "string",
    "HasInstallments": "string",
    "HashID": "string",
    "Id": "string",
    "InstallmentFrequency": "string",
    "InstallmentNumber": "string",
    "InstallmentPaymentMethod": "string",
    "MarinaLocationId": "string",
    "MinimumChargeMethod": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloOnlineBooking": "string",
    "Name": "string",
    "Notes": "string",
    "OffersId": "string",
    "OnlineBookingNotes": "string",
    "OnlineBookingOptIn": "string",
    "OnlinePaymentCompletion": "string",
    "OnlineTerms": "string",
    "OnlyReservationInstallments": "string",
    "OriginalEndDate": "string",
    "OriginalOfferHoldId": "string",
    "OriginalStartDate": "string",
    "PrintedTerms": "string",
    "Rate": "string",
    "RatePriceOverride": "string",
    "RecurringDiscountPercent": "string",
    "RecurringInvoiceDay": "string",
    "RecurringRateOverride": "string",
    "ReservationCampaign_Id": "string",
    "ReservationMedium_Id": "string",
    "ReservationSource": "string",
    "ReservationStatusId": "string",
    "ReservationTypeId": "string",
    "ScheduledArrivalTime": "string",
    "ScheduledDepartureTime": "string",
    "ScheduledForStatusChange": "string",
    "SeasonalPriceId": "string",
    "SlipBlockSet_Id": "string",
    "SlipId": "string",
    "SlipSlotIndex": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedLocation": "string",
    "TermsOffline": "string",
    "TermsUser": "string",
    "TransientPriceId": "string"
}
    • schema_name_id: 1732
    • schema_scan_id: 161675480
    • updated: 2026-04-08 03:04:44
    • created: 2026-04-07 02:59:52
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreservations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreservations`\n(\n `Id`  string , `MarinaLocationId`  string , `CreationTime`  string , `ReservationStatusId`  string , `ReservationTypeId`  string , `AspNetUserId`  string , `ContactId`  string , `BoatId`  string , `ScheduledArrivalTime`  string , `ScheduledDepartureTime`  string , `CancellationTime`  string , `AccountId`  string , `SlipId`  string , `SlipSlotIndex`  string , `DistanceFromTheStart`  string , `Rate`  string , `Name`  string , `HasInstallments`  string , `InstallmentFrequency`  string , `InstallmentNumber`  string , `InstallmentPaymentMethod`  string , `OnlyReservationInstallments`  string , `Notes`  string , `ActualArrivalDateTime`  string , `ActualDepartureDateTime`  string , `ConfirmationEmailDateTime`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedLocation`  string , `CustomerIPAddress`  string , `CustomerDevice`  string , `ConfirmationEmailAspUser_Id`  string , `RatePriceOverride`  string , `HashID`  string , `ReservationSource`  string , `ReservationMedium_Id`  string , `ReservationCampaign_Id`  string , `MoloAPI_Partner_Id`  string , `CancelationUserId`  string , `ContactMerged`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `PrintedTerms`  string , `OnlineTerms`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `MoloOnlineBooking`  string , `BookingContactMerged`  string , `SlipBlockSet_Id`  string , `OffersId`  string , `RecurringInvoiceDay`  string , `AlternateReservationName`  string , `RecurringDiscountPercent`  string , `RecurringRateOverride`  string , `OnlineBookingNotes`  string , `OriginalOfferHoldId`  string , `ScheduledForStatusChange`  string , `TermsOffline`  string , `TermsUser`  string , `OriginalStartDate`  string , `OriginalEndDate`  string , `ContractTypeId`  string , `MinimumChargeMethod`  string , `OnlineBookingOptIn`  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_moloReservations/2026-04-07/1775548547'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreservations"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReservations/2026-04-07/1775548547
    • id: 1705779
    • processed: 1
    • raw_data: 
      {
    "AccountId": 11,
    "ActualArrivalDateTime": 23,
    "ActualDepartureDateTime": 24,
    "AlternateReservationName": 51,
    "AspNetUserId": 5,
    "BoatId": 7,
    "BookingContactMerged": 47,
    "CancelationUserId": 37,
    "CancellationTime": 10,
    "CheckInTerms": 43,
    "CheckOutTerms": 44,
    "ConfirmationEmailAspUser_Id": 30,
    "ConfirmationEmailDateTime": 25,
    "ContactId": 6,
    "ContactMerged": 38,
    "ContractTypeId": 61,
    "CreationTime": 2,
    "CustomerDevice": 29,
    "CustomerIPAddress": 28,
    "DistanceFromTheStart": 14,
    "HasInstallments": 17,
    "HashID": 32,
    "Id": 0,
    "InstallmentFrequency": 18,
    "InstallmentNumber": 19,
    "InstallmentPaymentMethod": 20,
    "MarinaLocationId": 1,
    "MinimumChargeMethod": 62,
    "MoloAPI_Partner_Id": 36,
    "MoloOnlineBooking": 46,
    "Name": 16,
    "Notes": 22,
    "OffersId": 49,
    "OnlineBookingNotes": 54,
    "OnlineBookingOptIn": 63,
    "OnlinePaymentCompletion": 45,
    "OnlineTerms": 42,
    "OnlyReservationInstallments": 21,
    "OriginalEndDate": 60,
    "OriginalOfferHoldId": 55,
    "OriginalStartDate": 59,
    "PrintedTerms": 41,
    "Rate": 15,
    "RatePriceOverride": 31,
    "RecurringDiscountPercent": 52,
    "RecurringInvoiceDay": 50,
    "RecurringRateOverride": 53,
    "ReservationCampaign_Id": 35,
    "ReservationMedium_Id": 34,
    "ReservationSource": 33,
    "ReservationStatusId": 3,
    "ReservationTypeId": 4,
    "ScheduledArrivalTime": 8,
    "ScheduledDepartureTime": 9,
    "ScheduledForStatusChange": 56,
    "SeasonalPriceId": 40,
    "SlipBlockSet_Id": 48,
    "SlipId": 12,
    "SlipSlotIndex": 13,
    "TermsAcceptedDateTime": 26,
    "TermsAcceptedLocation": 27,
    "TermsOffline": 57,
    "TermsUser": 58,
    "TransientPriceId": 39
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActualArrivalDateTime": "string",
    "ActualDepartureDateTime": "string",
    "AlternateReservationName": "string",
    "AspNetUserId": "string",
    "BoatId": "string",
    "BookingContactMerged": "string",
    "CancelationUserId": "string",
    "CancellationTime": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "ConfirmationEmailAspUser_Id": "string",
    "ConfirmationEmailDateTime": "string",
    "ContactId": "string",
    "ContactMerged": "string",
    "ContractTypeId": "string",
    "CreationTime": "string",
    "CustomerDevice": "string",
    "CustomerIPAddress": "string",
    "DistanceFromTheStart": "string",
    "HasInstallments": "string",
    "HashID": "string",
    "Id": "string",
    "InstallmentFrequency": "string",
    "InstallmentNumber": "string",
    "InstallmentPaymentMethod": "string",
    "MarinaLocationId": "string",
    "MinimumChargeMethod": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloOnlineBooking": "string",
    "Name": "string",
    "Notes": "string",
    "OffersId": "string",
    "OnlineBookingNotes": "string",
    "OnlineBookingOptIn": "string",
    "OnlinePaymentCompletion": "string",
    "OnlineTerms": "string",
    "OnlyReservationInstallments": "string",
    "OriginalEndDate": "string",
    "OriginalOfferHoldId": "string",
    "OriginalStartDate": "string",
    "PrintedTerms": "string",
    "Rate": "string",
    "RatePriceOverride": "string",
    "RecurringDiscountPercent": "string",
    "RecurringInvoiceDay": "string",
    "RecurringRateOverride": "string",
    "ReservationCampaign_Id": "string",
    "ReservationMedium_Id": "string",
    "ReservationSource": "string",
    "ReservationStatusId": "string",
    "ReservationTypeId": "string",
    "ScheduledArrivalTime": "string",
    "ScheduledDepartureTime": "string",
    "ScheduledForStatusChange": "string",
    "SeasonalPriceId": "string",
    "SlipBlockSet_Id": "string",
    "SlipId": "string",
    "SlipSlotIndex": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedLocation": "string",
    "TermsOffline": "string",
    "TermsUser": "string",
    "TransientPriceId": "string"
}
    • schema_name_id: 1732
    • schema_scan_id: 161618686
    • updated: 2026-04-07 03:00:06
    • created: 2026-04-06 03:04:07
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreservations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreservations`\n(\n `Id`  string , `MarinaLocationId`  string , `CreationTime`  string , `ReservationStatusId`  string , `ReservationTypeId`  string , `AspNetUserId`  string , `ContactId`  string , `BoatId`  string , `ScheduledArrivalTime`  string , `ScheduledDepartureTime`  string , `CancellationTime`  string , `AccountId`  string , `SlipId`  string , `SlipSlotIndex`  string , `DistanceFromTheStart`  string , `Rate`  string , `Name`  string , `HasInstallments`  string , `InstallmentFrequency`  string , `InstallmentNumber`  string , `InstallmentPaymentMethod`  string , `OnlyReservationInstallments`  string , `Notes`  string , `ActualArrivalDateTime`  string , `ActualDepartureDateTime`  string , `ConfirmationEmailDateTime`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedLocation`  string , `CustomerIPAddress`  string , `CustomerDevice`  string , `ConfirmationEmailAspUser_Id`  string , `RatePriceOverride`  string , `HashID`  string , `ReservationSource`  string , `ReservationMedium_Id`  string , `ReservationCampaign_Id`  string , `MoloAPI_Partner_Id`  string , `CancelationUserId`  string , `ContactMerged`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `PrintedTerms`  string , `OnlineTerms`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `MoloOnlineBooking`  string , `BookingContactMerged`  string , `SlipBlockSet_Id`  string , `OffersId`  string , `RecurringInvoiceDay`  string , `AlternateReservationName`  string , `RecurringDiscountPercent`  string , `RecurringRateOverride`  string , `OnlineBookingNotes`  string , `OriginalOfferHoldId`  string , `ScheduledForStatusChange`  string , `TermsOffline`  string , `TermsUser`  string , `OriginalStartDate`  string , `OriginalEndDate`  string , `ContractTypeId`  string , `MinimumChargeMethod`  string , `OnlineBookingOptIn`  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_moloReservations/2026-04-06/1775462508'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreservations"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReservations/2026-04-06/1775462508
    • id: 1704456
    • processed: 1
    • raw_data: 
      {
    "AccountId": 11,
    "ActualArrivalDateTime": 23,
    "ActualDepartureDateTime": 24,
    "AlternateReservationName": 51,
    "AspNetUserId": 5,
    "BoatId": 7,
    "BookingContactMerged": 47,
    "CancelationUserId": 37,
    "CancellationTime": 10,
    "CheckInTerms": 43,
    "CheckOutTerms": 44,
    "ConfirmationEmailAspUser_Id": 30,
    "ConfirmationEmailDateTime": 25,
    "ContactId": 6,
    "ContactMerged": 38,
    "ContractTypeId": 61,
    "CreationTime": 2,
    "CustomerDevice": 29,
    "CustomerIPAddress": 28,
    "DistanceFromTheStart": 14,
    "HasInstallments": 17,
    "HashID": 32,
    "Id": 0,
    "InstallmentFrequency": 18,
    "InstallmentNumber": 19,
    "InstallmentPaymentMethod": 20,
    "MarinaLocationId": 1,
    "MinimumChargeMethod": 62,
    "MoloAPI_Partner_Id": 36,
    "MoloOnlineBooking": 46,
    "Name": 16,
    "Notes": 22,
    "OffersId": 49,
    "OnlineBookingNotes": 54,
    "OnlineBookingOptIn": 63,
    "OnlinePaymentCompletion": 45,
    "OnlineTerms": 42,
    "OnlyReservationInstallments": 21,
    "OriginalEndDate": 60,
    "OriginalOfferHoldId": 55,
    "OriginalStartDate": 59,
    "PrintedTerms": 41,
    "Rate": 15,
    "RatePriceOverride": 31,
    "RecurringDiscountPercent": 52,
    "RecurringInvoiceDay": 50,
    "RecurringRateOverride": 53,
    "ReservationCampaign_Id": 35,
    "ReservationMedium_Id": 34,
    "ReservationSource": 33,
    "ReservationStatusId": 3,
    "ReservationTypeId": 4,
    "ScheduledArrivalTime": 8,
    "ScheduledDepartureTime": 9,
    "ScheduledForStatusChange": 56,
    "SeasonalPriceId": 40,
    "SlipBlockSet_Id": 48,
    "SlipId": 12,
    "SlipSlotIndex": 13,
    "TermsAcceptedDateTime": 26,
    "TermsAcceptedLocation": 27,
    "TermsOffline": 57,
    "TermsUser": 58,
    "TransientPriceId": 39
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActualArrivalDateTime": "string",
    "ActualDepartureDateTime": "string",
    "AlternateReservationName": "string",
    "AspNetUserId": "string",
    "BoatId": "string",
    "BookingContactMerged": "string",
    "CancelationUserId": "string",
    "CancellationTime": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "ConfirmationEmailAspUser_Id": "string",
    "ConfirmationEmailDateTime": "string",
    "ContactId": "string",
    "ContactMerged": "string",
    "ContractTypeId": "string",
    "CreationTime": "string",
    "CustomerDevice": "string",
    "CustomerIPAddress": "string",
    "DistanceFromTheStart": "string",
    "HasInstallments": "string",
    "HashID": "string",
    "Id": "string",
    "InstallmentFrequency": "string",
    "InstallmentNumber": "string",
    "InstallmentPaymentMethod": "string",
    "MarinaLocationId": "string",
    "MinimumChargeMethod": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloOnlineBooking": "string",
    "Name": "string",
    "Notes": "string",
    "OffersId": "string",
    "OnlineBookingNotes": "string",
    "OnlineBookingOptIn": "string",
    "OnlinePaymentCompletion": "string",
    "OnlineTerms": "string",
    "OnlyReservationInstallments": "string",
    "OriginalEndDate": "string",
    "OriginalOfferHoldId": "string",
    "OriginalStartDate": "string",
    "PrintedTerms": "string",
    "Rate": "string",
    "RatePriceOverride": "string",
    "RecurringDiscountPercent": "string",
    "RecurringInvoiceDay": "string",
    "RecurringRateOverride": "string",
    "ReservationCampaign_Id": "string",
    "ReservationMedium_Id": "string",
    "ReservationSource": "string",
    "ReservationStatusId": "string",
    "ReservationTypeId": "string",
    "ScheduledArrivalTime": "string",
    "ScheduledDepartureTime": "string",
    "ScheduledForStatusChange": "string",
    "SeasonalPriceId": "string",
    "SlipBlockSet_Id": "string",
    "SlipId": "string",
    "SlipSlotIndex": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedLocation": "string",
    "TermsOffline": "string",
    "TermsUser": "string",
    "TransientPriceId": "string"
}
    • schema_name_id: 1732
    • schema_scan_id: 161561521
    • updated: 2026-04-06 03:04:20
    • created: 2026-04-05 03:04:37
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreservations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreservations`\n(\n `Id`  string , `MarinaLocationId`  string , `CreationTime`  string , `ReservationStatusId`  string , `ReservationTypeId`  string , `AspNetUserId`  string , `ContactId`  string , `BoatId`  string , `ScheduledArrivalTime`  string , `ScheduledDepartureTime`  string , `CancellationTime`  string , `AccountId`  string , `SlipId`  string , `SlipSlotIndex`  string , `DistanceFromTheStart`  string , `Rate`  string , `Name`  string , `HasInstallments`  string , `InstallmentFrequency`  string , `InstallmentNumber`  string , `InstallmentPaymentMethod`  string , `OnlyReservationInstallments`  string , `Notes`  string , `ActualArrivalDateTime`  string , `ActualDepartureDateTime`  string , `ConfirmationEmailDateTime`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedLocation`  string , `CustomerIPAddress`  string , `CustomerDevice`  string , `ConfirmationEmailAspUser_Id`  string , `RatePriceOverride`  string , `HashID`  string , `ReservationSource`  string , `ReservationMedium_Id`  string , `ReservationCampaign_Id`  string , `MoloAPI_Partner_Id`  string , `CancelationUserId`  string , `ContactMerged`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `PrintedTerms`  string , `OnlineTerms`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `MoloOnlineBooking`  string , `BookingContactMerged`  string , `SlipBlockSet_Id`  string , `OffersId`  string , `RecurringInvoiceDay`  string , `AlternateReservationName`  string , `RecurringDiscountPercent`  string , `RecurringRateOverride`  string , `OnlineBookingNotes`  string , `OriginalOfferHoldId`  string , `ScheduledForStatusChange`  string , `TermsOffline`  string , `TermsUser`  string , `OriginalStartDate`  string , `OriginalEndDate`  string , `ContractTypeId`  string , `MinimumChargeMethod`  string , `OnlineBookingOptIn`  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_moloReservations/2026-04-05/1775376133'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreservations"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReservations/2026-04-05/1775376133
    • id: 1703287
    • processed: 1
    • raw_data: 
      {
    "AccountId": 11,
    "ActualArrivalDateTime": 23,
    "ActualDepartureDateTime": 24,
    "AlternateReservationName": 51,
    "AspNetUserId": 5,
    "BoatId": 7,
    "BookingContactMerged": 47,
    "CancelationUserId": 37,
    "CancellationTime": 10,
    "CheckInTerms": 43,
    "CheckOutTerms": 44,
    "ConfirmationEmailAspUser_Id": 30,
    "ConfirmationEmailDateTime": 25,
    "ContactId": 6,
    "ContactMerged": 38,
    "ContractTypeId": 61,
    "CreationTime": 2,
    "CustomerDevice": 29,
    "CustomerIPAddress": 28,
    "DistanceFromTheStart": 14,
    "HasInstallments": 17,
    "HashID": 32,
    "Id": 0,
    "InstallmentFrequency": 18,
    "InstallmentNumber": 19,
    "InstallmentPaymentMethod": 20,
    "MarinaLocationId": 1,
    "MinimumChargeMethod": 62,
    "MoloAPI_Partner_Id": 36,
    "MoloOnlineBooking": 46,
    "Name": 16,
    "Notes": 22,
    "OffersId": 49,
    "OnlineBookingNotes": 54,
    "OnlineBookingOptIn": 63,
    "OnlinePaymentCompletion": 45,
    "OnlineTerms": 42,
    "OnlyReservationInstallments": 21,
    "OriginalEndDate": 60,
    "OriginalOfferHoldId": 55,
    "OriginalStartDate": 59,
    "PrintedTerms": 41,
    "Rate": 15,
    "RatePriceOverride": 31,
    "RecurringDiscountPercent": 52,
    "RecurringInvoiceDay": 50,
    "RecurringRateOverride": 53,
    "ReservationCampaign_Id": 35,
    "ReservationMedium_Id": 34,
    "ReservationSource": 33,
    "ReservationStatusId": 3,
    "ReservationTypeId": 4,
    "ScheduledArrivalTime": 8,
    "ScheduledDepartureTime": 9,
    "ScheduledForStatusChange": 56,
    "SeasonalPriceId": 40,
    "SlipBlockSet_Id": 48,
    "SlipId": 12,
    "SlipSlotIndex": 13,
    "TermsAcceptedDateTime": 26,
    "TermsAcceptedLocation": 27,
    "TermsOffline": 57,
    "TermsUser": 58,
    "TransientPriceId": 39
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActualArrivalDateTime": "string",
    "ActualDepartureDateTime": "string",
    "AlternateReservationName": "string",
    "AspNetUserId": "string",
    "BoatId": "string",
    "BookingContactMerged": "string",
    "CancelationUserId": "string",
    "CancellationTime": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "ConfirmationEmailAspUser_Id": "string",
    "ConfirmationEmailDateTime": "string",
    "ContactId": "string",
    "ContactMerged": "string",
    "ContractTypeId": "string",
    "CreationTime": "string",
    "CustomerDevice": "string",
    "CustomerIPAddress": "string",
    "DistanceFromTheStart": "string",
    "HasInstallments": "string",
    "HashID": "string",
    "Id": "string",
    "InstallmentFrequency": "string",
    "InstallmentNumber": "string",
    "InstallmentPaymentMethod": "string",
    "MarinaLocationId": "string",
    "MinimumChargeMethod": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloOnlineBooking": "string",
    "Name": "string",
    "Notes": "string",
    "OffersId": "string",
    "OnlineBookingNotes": "string",
    "OnlineBookingOptIn": "string",
    "OnlinePaymentCompletion": "string",
    "OnlineTerms": "string",
    "OnlyReservationInstallments": "string",
    "OriginalEndDate": "string",
    "OriginalOfferHoldId": "string",
    "OriginalStartDate": "string",
    "PrintedTerms": "string",
    "Rate": "string",
    "RatePriceOverride": "string",
    "RecurringDiscountPercent": "string",
    "RecurringInvoiceDay": "string",
    "RecurringRateOverride": "string",
    "ReservationCampaign_Id": "string",
    "ReservationMedium_Id": "string",
    "ReservationSource": "string",
    "ReservationStatusId": "string",
    "ReservationTypeId": "string",
    "ScheduledArrivalTime": "string",
    "ScheduledDepartureTime": "string",
    "ScheduledForStatusChange": "string",
    "SeasonalPriceId": "string",
    "SlipBlockSet_Id": "string",
    "SlipId": "string",
    "SlipSlotIndex": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedLocation": "string",
    "TermsOffline": "string",
    "TermsUser": "string",
    "TransientPriceId": "string"
}
    • schema_name_id: 1732
    • schema_scan_id: 161514864
    • updated: 2026-04-05 03:04:48
    • created: 2026-04-04 03:08:14
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreservations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreservations`\n(\n `Id`  string , `MarinaLocationId`  string , `CreationTime`  string , `ReservationStatusId`  string , `ReservationTypeId`  string , `AspNetUserId`  string , `ContactId`  string , `BoatId`  string , `ScheduledArrivalTime`  string , `ScheduledDepartureTime`  string , `CancellationTime`  string , `AccountId`  string , `SlipId`  string , `SlipSlotIndex`  string , `DistanceFromTheStart`  string , `Rate`  string , `Name`  string , `HasInstallments`  string , `InstallmentFrequency`  string , `InstallmentNumber`  string , `InstallmentPaymentMethod`  string , `OnlyReservationInstallments`  string , `Notes`  string , `ActualArrivalDateTime`  string , `ActualDepartureDateTime`  string , `ConfirmationEmailDateTime`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedLocation`  string , `CustomerIPAddress`  string , `CustomerDevice`  string , `ConfirmationEmailAspUser_Id`  string , `RatePriceOverride`  string , `HashID`  string , `ReservationSource`  string , `ReservationMedium_Id`  string , `ReservationCampaign_Id`  string , `MoloAPI_Partner_Id`  string , `CancelationUserId`  string , `ContactMerged`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `PrintedTerms`  string , `OnlineTerms`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `MoloOnlineBooking`  string , `BookingContactMerged`  string , `SlipBlockSet_Id`  string , `OffersId`  string , `RecurringInvoiceDay`  string , `AlternateReservationName`  string , `RecurringDiscountPercent`  string , `RecurringRateOverride`  string , `OnlineBookingNotes`  string , `OriginalOfferHoldId`  string , `ScheduledForStatusChange`  string , `TermsOffline`  string , `TermsUser`  string , `OriginalStartDate`  string , `OriginalEndDate`  string , `ContractTypeId`  string , `MinimumChargeMethod`  string , `OnlineBookingOptIn`  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_moloReservations/2026-04-04/1775289616'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreservations"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReservations/2026-04-04/1775289616
    • id: 1702215
    • processed: 1
    • raw_data: 
      {
    "AccountId": 11,
    "ActualArrivalDateTime": 23,
    "ActualDepartureDateTime": 24,
    "AlternateReservationName": 51,
    "AspNetUserId": 5,
    "BoatId": 7,
    "BookingContactMerged": 47,
    "CancelationUserId": 37,
    "CancellationTime": 10,
    "CheckInTerms": 43,
    "CheckOutTerms": 44,
    "ConfirmationEmailAspUser_Id": 30,
    "ConfirmationEmailDateTime": 25,
    "ContactId": 6,
    "ContactMerged": 38,
    "ContractTypeId": 61,
    "CreationTime": 2,
    "CustomerDevice": 29,
    "CustomerIPAddress": 28,
    "DistanceFromTheStart": 14,
    "HasInstallments": 17,
    "HashID": 32,
    "Id": 0,
    "InstallmentFrequency": 18,
    "InstallmentNumber": 19,
    "InstallmentPaymentMethod": 20,
    "MarinaLocationId": 1,
    "MinimumChargeMethod": 62,
    "MoloAPI_Partner_Id": 36,
    "MoloOnlineBooking": 46,
    "Name": 16,
    "Notes": 22,
    "OffersId": 49,
    "OnlineBookingNotes": 54,
    "OnlineBookingOptIn": 63,
    "OnlinePaymentCompletion": 45,
    "OnlineTerms": 42,
    "OnlyReservationInstallments": 21,
    "OriginalEndDate": 60,
    "OriginalOfferHoldId": 55,
    "OriginalStartDate": 59,
    "PrintedTerms": 41,
    "Rate": 15,
    "RatePriceOverride": 31,
    "RecurringDiscountPercent": 52,
    "RecurringInvoiceDay": 50,
    "RecurringRateOverride": 53,
    "ReservationCampaign_Id": 35,
    "ReservationMedium_Id": 34,
    "ReservationSource": 33,
    "ReservationStatusId": 3,
    "ReservationTypeId": 4,
    "ScheduledArrivalTime": 8,
    "ScheduledDepartureTime": 9,
    "ScheduledForStatusChange": 56,
    "SeasonalPriceId": 40,
    "SlipBlockSet_Id": 48,
    "SlipId": 12,
    "SlipSlotIndex": 13,
    "TermsAcceptedDateTime": 26,
    "TermsAcceptedLocation": 27,
    "TermsOffline": 57,
    "TermsUser": 58,
    "TransientPriceId": 39
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActualArrivalDateTime": "string",
    "ActualDepartureDateTime": "string",
    "AlternateReservationName": "string",
    "AspNetUserId": "string",
    "BoatId": "string",
    "BookingContactMerged": "string",
    "CancelationUserId": "string",
    "CancellationTime": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "ConfirmationEmailAspUser_Id": "string",
    "ConfirmationEmailDateTime": "string",
    "ContactId": "string",
    "ContactMerged": "string",
    "ContractTypeId": "string",
    "CreationTime": "string",
    "CustomerDevice": "string",
    "CustomerIPAddress": "string",
    "DistanceFromTheStart": "string",
    "HasInstallments": "string",
    "HashID": "string",
    "Id": "string",
    "InstallmentFrequency": "string",
    "InstallmentNumber": "string",
    "InstallmentPaymentMethod": "string",
    "MarinaLocationId": "string",
    "MinimumChargeMethod": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloOnlineBooking": "string",
    "Name": "string",
    "Notes": "string",
    "OffersId": "string",
    "OnlineBookingNotes": "string",
    "OnlineBookingOptIn": "string",
    "OnlinePaymentCompletion": "string",
    "OnlineTerms": "string",
    "OnlyReservationInstallments": "string",
    "OriginalEndDate": "string",
    "OriginalOfferHoldId": "string",
    "OriginalStartDate": "string",
    "PrintedTerms": "string",
    "Rate": "string",
    "RatePriceOverride": "string",
    "RecurringDiscountPercent": "string",
    "RecurringInvoiceDay": "string",
    "RecurringRateOverride": "string",
    "ReservationCampaign_Id": "string",
    "ReservationMedium_Id": "string",
    "ReservationSource": "string",
    "ReservationStatusId": "string",
    "ReservationTypeId": "string",
    "ScheduledArrivalTime": "string",
    "ScheduledDepartureTime": "string",
    "ScheduledForStatusChange": "string",
    "SeasonalPriceId": "string",
    "SlipBlockSet_Id": "string",
    "SlipId": "string",
    "SlipSlotIndex": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedLocation": "string",
    "TermsOffline": "string",
    "TermsUser": "string",
    "TransientPriceId": "string"
}
    • schema_name_id: 1732
    • schema_scan_id: 161460500
    • updated: 2026-04-04 03:08:28
    • created: 2026-04-03 03:10:25
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreservations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreservations`\n(\n `Id`  string , `MarinaLocationId`  string , `CreationTime`  string , `ReservationStatusId`  string , `ReservationTypeId`  string , `AspNetUserId`  string , `ContactId`  string , `BoatId`  string , `ScheduledArrivalTime`  string , `ScheduledDepartureTime`  string , `CancellationTime`  string , `AccountId`  string , `SlipId`  string , `SlipSlotIndex`  string , `DistanceFromTheStart`  string , `Rate`  string , `Name`  string , `HasInstallments`  string , `InstallmentFrequency`  string , `InstallmentNumber`  string , `InstallmentPaymentMethod`  string , `OnlyReservationInstallments`  string , `Notes`  string , `ActualArrivalDateTime`  string , `ActualDepartureDateTime`  string , `ConfirmationEmailDateTime`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedLocation`  string , `CustomerIPAddress`  string , `CustomerDevice`  string , `ConfirmationEmailAspUser_Id`  string , `RatePriceOverride`  string , `HashID`  string , `ReservationSource`  string , `ReservationMedium_Id`  string , `ReservationCampaign_Id`  string , `MoloAPI_Partner_Id`  string , `CancelationUserId`  string , `ContactMerged`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `PrintedTerms`  string , `OnlineTerms`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `MoloOnlineBooking`  string , `BookingContactMerged`  string , `SlipBlockSet_Id`  string , `OffersId`  string , `RecurringInvoiceDay`  string , `AlternateReservationName`  string , `RecurringDiscountPercent`  string , `RecurringRateOverride`  string , `OnlineBookingNotes`  string , `OriginalOfferHoldId`  string , `ScheduledForStatusChange`  string , `TermsOffline`  string , `TermsUser`  string , `OriginalStartDate`  string , `OriginalEndDate`  string , `ContractTypeId`  string , `MinimumChargeMethod`  string , `OnlineBookingOptIn`  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_moloReservations/2026-04-03/1775203389'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreservations"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloReservations/2026-04-03/1775203389
    • id: 1700957
    • processed: 1
    • raw_data: 
      {
    "AccountId": 11,
    "ActualArrivalDateTime": 23,
    "ActualDepartureDateTime": 24,
    "AlternateReservationName": 51,
    "AspNetUserId": 5,
    "BoatId": 7,
    "BookingContactMerged": 47,
    "CancelationUserId": 37,
    "CancellationTime": 10,
    "CheckInTerms": 43,
    "CheckOutTerms": 44,
    "ConfirmationEmailAspUser_Id": 30,
    "ConfirmationEmailDateTime": 25,
    "ContactId": 6,
    "ContactMerged": 38,
    "ContractTypeId": 61,
    "CreationTime": 2,
    "CustomerDevice": 29,
    "CustomerIPAddress": 28,
    "DistanceFromTheStart": 14,
    "HasInstallments": 17,
    "HashID": 32,
    "Id": 0,
    "InstallmentFrequency": 18,
    "InstallmentNumber": 19,
    "InstallmentPaymentMethod": 20,
    "MarinaLocationId": 1,
    "MinimumChargeMethod": 62,
    "MoloAPI_Partner_Id": 36,
    "MoloOnlineBooking": 46,
    "Name": 16,
    "Notes": 22,
    "OffersId": 49,
    "OnlineBookingNotes": 54,
    "OnlineBookingOptIn": 63,
    "OnlinePaymentCompletion": 45,
    "OnlineTerms": 42,
    "OnlyReservationInstallments": 21,
    "OriginalEndDate": 60,
    "OriginalOfferHoldId": 55,
    "OriginalStartDate": 59,
    "PrintedTerms": 41,
    "Rate": 15,
    "RatePriceOverride": 31,
    "RecurringDiscountPercent": 52,
    "RecurringInvoiceDay": 50,
    "RecurringRateOverride": 53,
    "ReservationCampaign_Id": 35,
    "ReservationMedium_Id": 34,
    "ReservationSource": 33,
    "ReservationStatusId": 3,
    "ReservationTypeId": 4,
    "ScheduledArrivalTime": 8,
    "ScheduledDepartureTime": 9,
    "ScheduledForStatusChange": 56,
    "SeasonalPriceId": 40,
    "SlipBlockSet_Id": 48,
    "SlipId": 12,
    "SlipSlotIndex": 13,
    "TermsAcceptedDateTime": 26,
    "TermsAcceptedLocation": 27,
    "TermsOffline": 57,
    "TermsUser": 58,
    "TransientPriceId": 39
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActualArrivalDateTime": "string",
    "ActualDepartureDateTime": "string",
    "AlternateReservationName": "string",
    "AspNetUserId": "string",
    "BoatId": "string",
    "BookingContactMerged": "string",
    "CancelationUserId": "string",
    "CancellationTime": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "ConfirmationEmailAspUser_Id": "string",
    "ConfirmationEmailDateTime": "string",
    "ContactId": "string",
    "ContactMerged": "string",
    "ContractTypeId": "string",
    "CreationTime": "string",
    "CustomerDevice": "string",
    "CustomerIPAddress": "string",
    "DistanceFromTheStart": "string",
    "HasInstallments": "string",
    "HashID": "string",
    "Id": "string",
    "InstallmentFrequency": "string",
    "InstallmentNumber": "string",
    "InstallmentPaymentMethod": "string",
    "MarinaLocationId": "string",
    "MinimumChargeMethod": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloOnlineBooking": "string",
    "Name": "string",
    "Notes": "string",
    "OffersId": "string",
    "OnlineBookingNotes": "string",
    "OnlineBookingOptIn": "string",
    "OnlinePaymentCompletion": "string",
    "OnlineTerms": "string",
    "OnlyReservationInstallments": "string",
    "OriginalEndDate": "string",
    "OriginalOfferHoldId": "string",
    "OriginalStartDate": "string",
    "PrintedTerms": "string",
    "Rate": "string",
    "RatePriceOverride": "string",
    "RecurringDiscountPercent": "string",
    "RecurringInvoiceDay": "string",
    "RecurringRateOverride": "string",
    "ReservationCampaign_Id": "string",
    "ReservationMedium_Id": "string",
    "ReservationSource": "string",
    "ReservationStatusId": "string",
    "ReservationTypeId": "string",
    "ScheduledArrivalTime": "string",
    "ScheduledDepartureTime": "string",
    "ScheduledForStatusChange": "string",
    "SeasonalPriceId": "string",
    "SlipBlockSet_Id": "string",
    "SlipId": "string",
    "SlipSlotIndex": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedLocation": "string",
    "TermsOffline": "string",
    "TermsUser": "string",
    "TransientPriceId": "string"
}
    • schema_name_id: 1732
    • schema_scan_id: 161401915
    • updated: 2026-04-03 03:10:36
Schema Scans: 15
Last at 2026-04-17 03:05:17
    • duration: 0:00:15.976934
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162167616
    • 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_moloReservations/2026-04-17/1776412846",
        "key": "raw/molo_moloReservations/2026-04-17/1776412846/Reservations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloReservations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17546051959580880788,
        "service_name": "drive-thru",
        "span_id": 5204506164405666213,
        "trace_id": 16912448850676567237
    }
}
    • running: False
    • schema_name_id: 1732
    • start_time: 2026-04-17 03:05:17
    • success: True
    • trace_id: 16912448850676567237
    • duration: 0:00:13.370388
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162112021
    • 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_moloReservations/2026-04-16/1776326599",
        "key": "raw/molo_moloReservations/2026-04-16/1776326599/Reservations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloReservations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7397343754243157343,
        "service_name": "drive-thru",
        "span_id": 8758940114319024675,
        "trace_id": 14950898758548969715
    }
}
    • running: False
    • schema_name_id: 1732
    • start_time: 2026-04-16 03:13:55
    • success: True
    • trace_id: 14950898758548969715
    • duration: 0:00:13.284894
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162056002
    • 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_moloReservations/2026-04-15/1776240069",
        "key": "raw/molo_moloReservations/2026-04-15/1776240069/Reservations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloReservations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17146820224246926248,
        "service_name": "drive-thru",
        "span_id": 2754022468173684391,
        "trace_id": 7126385443003322531
    }
}
    • running: False
    • schema_name_id: 1732
    • start_time: 2026-04-15 03:07:06
    • success: True
    • trace_id: 7126385443003322531
    • duration: 0:00:16.252529
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162000608
    • 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_moloReservations/2026-04-14/1776153834",
        "key": "raw/molo_moloReservations/2026-04-14/1776153834/Reservations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloReservations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10489543836038949005,
        "service_name": "drive-thru",
        "span_id": 17591723161088189472,
        "trace_id": 403665885996571743
    }
}
    • running: False
    • schema_name_id: 1732
    • start_time: 2026-04-14 03:09:18
    • success: True
    • trace_id: 403665885996571743
    • duration: 0:00:13.305834
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161941961
    • 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_moloReservations/2026-04-13/1776066995",
        "key": "raw/molo_moloReservations/2026-04-13/1776066995/Reservations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloReservations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16681996854211584741,
        "service_name": "drive-thru",
        "span_id": 565863646840786609,
        "trace_id": 5429189935072768399
    }
}
    • running: False
    • schema_name_id: 1732
    • start_time: 2026-04-13 03:00:54
    • success: True
    • trace_id: 5429189935072768399
    • duration: 0:00:16.053859
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161893040
    • 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_moloReservations/2026-04-12/1775980704",
        "key": "raw/molo_moloReservations/2026-04-12/1775980704/Reservations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloReservations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11417806242286025356,
        "service_name": "drive-thru",
        "span_id": 17097524415305546405,
        "trace_id": 18139675947484792225
    }
}
    • running: False
    • schema_name_id: 1732
    • start_time: 2026-04-12 03:03:10
    • success: True
    • trace_id: 18139675947484792225
    • duration: 0:00:16.007643
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161841183
    • 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_moloReservations/2026-04-11/1775894471",
        "key": "raw/molo_moloReservations/2026-04-11/1775894471/Reservations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloReservations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8550576806971438469,
        "service_name": "drive-thru",
        "span_id": 5041187197735802644,
        "trace_id": 12610805353594340635
    }
}
    • running: False
    • schema_name_id: 1732
    • start_time: 2026-04-11 03:04:50
    • success: True
    • trace_id: 12610805353594340635
    • duration: 0:00:13.291296
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161785953
    • 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_moloReservations/2026-04-10/1775808229",
        "key": "raw/molo_moloReservations/2026-04-10/1775808229/Reservations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloReservations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17798743302614927338,
        "service_name": "drive-thru",
        "span_id": 3140391204952836137,
        "trace_id": 76608610606075027
    }
}
    • running: False
    • schema_name_id: 1732
    • start_time: 2026-04-10 03:06:48
    • success: True
    • trace_id: 76608610606075027
    • duration: 0:00:13.584807
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161730439
    • 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_moloReservations/2026-04-09/1775721562",
        "key": "raw/molo_moloReservations/2026-04-09/1775721562/Reservations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloReservations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11080397722560027638,
        "service_name": "drive-thru",
        "span_id": 2446197859601935661,
        "trace_id": 17387754279020674483
    }
}
    • running: False
    • schema_name_id: 1732
    • start_time: 2026-04-09 03:06:48
    • success: True
    • trace_id: 17387754279020674483
    • duration: 0:00:13.380413
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161675480
    • 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_moloReservations/2026-04-08/1775635391",
        "key": "raw/molo_moloReservations/2026-04-08/1775635391/Reservations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloReservations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3905485557295817964,
        "service_name": "drive-thru",
        "span_id": 7285886344426016045,
        "trace_id": 2783712294799720012
    }
}
    • running: False
    • schema_name_id: 1732
    • start_time: 2026-04-08 03:04:31
    • success: True
    • trace_id: 2783712294799720012
    • duration: 0:00:16.081274
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161618686
    • 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_moloReservations/2026-04-07/1775548547",
        "key": "raw/molo_moloReservations/2026-04-07/1775548547/Reservations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloReservations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10282698887226965249,
        "service_name": "drive-thru",
        "span_id": 1880696683010493710,
        "trace_id": 17704154920035905811
    }
}
    • running: False
    • schema_name_id: 1732
    • start_time: 2026-04-07 02:59:49
    • success: True
    • trace_id: 17704154920035905811
    • duration: 0:00:15.952032
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161561521
    • 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_moloReservations/2026-04-06/1775462508",
        "key": "raw/molo_moloReservations/2026-04-06/1775462508/Reservations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloReservations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14034348620831803535,
        "service_name": "drive-thru",
        "span_id": 15707972285467691325,
        "trace_id": 776466591244053227
    }
}
    • running: False
    • schema_name_id: 1732
    • start_time: 2026-04-06 03:04:04
    • success: True
    • trace_id: 776466591244053227
    • duration: 0:00:13.306370
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161514864
    • 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_moloReservations/2026-04-05/1775376133",
        "key": "raw/molo_moloReservations/2026-04-05/1775376133/Reservations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloReservations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13219747773394175920,
        "service_name": "drive-thru",
        "span_id": 11228611269582591418,
        "trace_id": 6569549655684394737
    }
}
    • running: False
    • schema_name_id: 1732
    • start_time: 2026-04-05 03:04:35
    • success: True
    • trace_id: 6569549655684394737
    • duration: 0:00:15.977219
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161460500
    • 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_moloReservations/2026-04-04/1775289616",
        "key": "raw/molo_moloReservations/2026-04-04/1775289616/Reservations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloReservations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11276077387778276975,
        "service_name": "drive-thru",
        "span_id": 15895706909751670730,
        "trace_id": 9674845991685537644
    }
}
    • running: False
    • schema_name_id: 1732
    • start_time: 2026-04-04 03:08:12
    • success: True
    • trace_id: 9674845991685537644
    • duration: 0:00:13.631466
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161401915
    • 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_moloReservations/2026-04-03/1775203389",
        "key": "raw/molo_moloReservations/2026-04-03/1775203389/Reservations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloReservations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 990779196869854762,
        "service_name": "drive-thru",
        "span_id": 15735665346539936684,
        "trace_id": 15878793977303812348
    }
}
    • running: False
    • schema_name_id: 1732
    • start_time: 2026-04-03 03:10:22
    • success: True
    • trace_id: 15878793977303812348
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "AccountId": "string",
    "ActualArrivalDateTime": "string",
    "ActualDepartureDateTime": "string",
    "AlternateReservationName": "string",
    "AspNetUserId": "string",
    "BoatId": "string",
    "BookingContactMerged": "string",
    "CancelationUserId": "string",
    "CancellationTime": "string",
    "CheckInTerms": "string",
    "CheckOutTerms": "string",
    "ConfirmationEmailAspUser_Id": "string",
    "ConfirmationEmailDateTime": "string",
    "ContactId": "string",
    "ContactMerged": "string",
    "ContractTypeId": "string",
    "CreationTime": "string",
    "CustomerDevice": "string",
    "CustomerIPAddress": "string",
    "DistanceFromTheStart": "string",
    "HasInstallments": "string",
    "HashID": "string",
    "Id": "string",
    "InstallmentFrequency": "string",
    "InstallmentNumber": "string",
    "InstallmentPaymentMethod": "string",
    "MarinaLocationId": "string",
    "MinimumChargeMethod": "string",
    "MoloAPI_Partner_Id": "string",
    "MoloOnlineBooking": "string",
    "Name": "string",
    "Notes": "string",
    "OffersId": "string",
    "OnlineBookingNotes": "string",
    "OnlineBookingOptIn": "string",
    "OnlinePaymentCompletion": "string",
    "OnlineTerms": "string",
    "OnlyReservationInstallments": "string",
    "OriginalEndDate": "string",
    "OriginalOfferHoldId": "string",
    "OriginalStartDate": "string",
    "PrintedTerms": "string",
    "Rate": "string",
    "RatePriceOverride": "string",
    "RecurringDiscountPercent": "string",
    "RecurringInvoiceDay": "string",
    "RecurringRateOverride": "string",
    "ReservationCampaign_Id": "string",
    "ReservationMedium_Id": "string",
    "ReservationSource": "string",
    "ReservationStatusId": "string",
    "ReservationTypeId": "string",
    "ScheduledArrivalTime": "string",
    "ScheduledDepartureTime": "string",
    "ScheduledForStatusChange": "string",
    "SeasonalPriceId": "string",
    "SlipBlockSet_Id": "string",
    "SlipId": "string",
    "SlipSlotIndex": "string",
    "TermsAcceptedDateTime": "string",
    "TermsAcceptedLocation": "string",
    "TermsOffline": "string",
    "TermsUser": "string",
    "TransientPriceId": "string"
}
  • created: 2026-04-17 03:05:19
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreservations`\n(\n `Id`  string , `MarinaLocationId`  string , `CreationTime`  string , `ReservationStatusId`  string , `ReservationTypeId`  string , `AspNetUserId`  string , `ContactId`  string , `BoatId`  string , `ScheduledArrivalTime`  string , `ScheduledDepartureTime`  string , `CancellationTime`  string , `AccountId`  string , `SlipId`  string , `SlipSlotIndex`  string , `DistanceFromTheStart`  string , `Rate`  string , `Name`  string , `HasInstallments`  string , `InstallmentFrequency`  string , `InstallmentNumber`  string , `InstallmentPaymentMethod`  string , `OnlyReservationInstallments`  string , `Notes`  string , `ActualArrivalDateTime`  string , `ActualDepartureDateTime`  string , `ConfirmationEmailDateTime`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedLocation`  string , `CustomerIPAddress`  string , `CustomerDevice`  string , `ConfirmationEmailAspUser_Id`  string , `RatePriceOverride`  string , `HashID`  string , `ReservationSource`  string , `ReservationMedium_Id`  string , `ReservationCampaign_Id`  string , `MoloAPI_Partner_Id`  string , `CancelationUserId`  string , `ContactMerged`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `PrintedTerms`  string , `OnlineTerms`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `MoloOnlineBooking`  string , `BookingContactMerged`  string , `SlipBlockSet_Id`  string , `OffersId`  string , `RecurringInvoiceDay`  string , `AlternateReservationName`  string , `RecurringDiscountPercent`  string , `RecurringRateOverride`  string , `OnlineBookingNotes`  string , `OriginalOfferHoldId`  string , `ScheduledForStatusChange`  string , `TermsOffline`  string , `TermsUser`  string , `OriginalStartDate`  string , `OriginalEndDate`  string , `ContractTypeId`  string , `MinimumChargeMethod`  string , `OnlineBookingOptIn`  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_moloReservations/2026-04-17/1776412846'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreservations`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreservations"
}
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:59:59",
        "disabled": false,
        "format": "raw",
        "id": 1732,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloreservations"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AccountId": "string",
            "ActualArrivalDateTime": "string",
            "ActualDepartureDateTime": "string",
            "AlternateReservationName": "string",
            "AspNetUserId": "string",
            "BoatId": "string",
            "BookingContactMerged": "string",
            "CancelationUserId": "string",
            "CancellationTime": "string",
            "CheckInTerms": "string",
            "CheckOutTerms": "string",
            "ConfirmationEmailAspUser_Id": "string",
            "ConfirmationEmailDateTime": "string",
            "ContactId": "string",
            "ContactMerged": "string",
            "ContractTypeId": "string",
            "CreationTime": "string",
            "CustomerDevice": "string",
            "CustomerIPAddress": "string",
            "DistanceFromTheStart": "string",
            "HasInstallments": "string",
            "HashID": "string",
            "Id": "string",
            "InstallmentFrequency": "string",
            "InstallmentNumber": "string",
            "InstallmentPaymentMethod": "string",
            "MarinaLocationId": "string",
            "MinimumChargeMethod": "string",
            "MoloAPI_Partner_Id": "string",
            "MoloOnlineBooking": "string",
            "Name": "string",
            "Notes": "string",
            "OffersId": "string",
            "OnlineBookingNotes": "string",
            "OnlineBookingOptIn": "string",
            "OnlinePaymentCompletion": "string",
            "OnlineTerms": "string",
            "OnlyReservationInstallments": "string",
            "OriginalEndDate": "string",
            "OriginalOfferHoldId": "string",
            "OriginalStartDate": "string",
            "PrintedTerms": "string",
            "Rate": "string",
            "RatePriceOverride": "string",
            "RecurringDiscountPercent": "string",
            "RecurringInvoiceDay": "string",
            "RecurringRateOverride": "string",
            "ReservationCampaign_Id": "string",
            "ReservationMedium_Id": "string",
            "ReservationSource": "string",
            "ReservationStatusId": "string",
            "ReservationTypeId": "string",
            "ScheduledArrivalTime": "string",
            "ScheduledDepartureTime": "string",
            "ScheduledForStatusChange": "string",
            "SeasonalPriceId": "string",
            "SlipBlockSet_Id": "string",
            "SlipId": "string",
            "SlipSlotIndex": "string",
            "TermsAcceptedDateTime": "string",
            "TermsAcceptedLocation": "string",
            "TermsOffline": "string",
            "TermsUser": "string",
            "TransientPriceId": "string"
        },
        "created": "2026-04-17 03:05:19",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloreservations`\n(\n `Id`  string , `MarinaLocationId`  string , `CreationTime`  string , `ReservationStatusId`  string , `ReservationTypeId`  string , `AspNetUserId`  string , `ContactId`  string , `BoatId`  string , `ScheduledArrivalTime`  string , `ScheduledDepartureTime`  string , `CancellationTime`  string , `AccountId`  string , `SlipId`  string , `SlipSlotIndex`  string , `DistanceFromTheStart`  string , `Rate`  string , `Name`  string , `HasInstallments`  string , `InstallmentFrequency`  string , `InstallmentNumber`  string , `InstallmentPaymentMethod`  string , `OnlyReservationInstallments`  string , `Notes`  string , `ActualArrivalDateTime`  string , `ActualDepartureDateTime`  string , `ConfirmationEmailDateTime`  string , `TermsAcceptedDateTime`  string , `TermsAcceptedLocation`  string , `CustomerIPAddress`  string , `CustomerDevice`  string , `ConfirmationEmailAspUser_Id`  string , `RatePriceOverride`  string , `HashID`  string , `ReservationSource`  string , `ReservationMedium_Id`  string , `ReservationCampaign_Id`  string , `MoloAPI_Partner_Id`  string , `CancelationUserId`  string , `ContactMerged`  string , `TransientPriceId`  string , `SeasonalPriceId`  string , `PrintedTerms`  string , `OnlineTerms`  string , `CheckInTerms`  string , `CheckOutTerms`  string , `OnlinePaymentCompletion`  string , `MoloOnlineBooking`  string , `BookingContactMerged`  string , `SlipBlockSet_Id`  string , `OffersId`  string , `RecurringInvoiceDay`  string , `AlternateReservationName`  string , `RecurringDiscountPercent`  string , `RecurringRateOverride`  string , `OnlineBookingNotes`  string , `OriginalOfferHoldId`  string , `ScheduledForStatusChange`  string , `TermsOffline`  string , `TermsUser`  string , `OriginalStartDate`  string , `OriginalEndDate`  string , `ContractTypeId`  string , `MinimumChargeMethod`  string , `OnlineBookingOptIn`  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_moloReservations/2026-04-17/1776412846'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloreservations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloreservations"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform