Schema Info

Schema Name: sfdl_stage_drivethru.molo_molomarinalocations
  • created: 2023-08-10 13:57:33
  • disabled: False
  • format: raw
  • id: 1925
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_stage_drivethru",
    "table": "molo_molomarinalocations"
}
  • type: drivethrucsv
Schema Versions: 3
    • created: 2023-10-16 01:58:11
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.molo_molomarinalocations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.molo_molomarinalocations`\n(\n `Id`  string , `Name`  string , `PrimaryPhoneNumber`  string , `PrimaryFaxNumber`  string , `Rules`  string , `ArivalGuide`  string , `DepositPercentage`  string , `City_Id`  string , `Organization_Id`  string , `MarinaHash`  string , `UnitSystem`  string , `SafetyDistanceW`  string , `SafetyDistanceL`  string , `DefaultArrivalTime`  string , `DefaultDepartureTime`  string , `Policy`  string , `Map`  string , `ReturnsRefundsPolicy`  string , `DefaultTaxRate`  string , `EmailAddress`  string , `InvoiceWarningDayCount`  string , `MarinaWebsite`  string , `VesselDimensionsOptions`  string , `AllowMoloOnlinePayment`  string , `TaxCalculationMethod`  string , `XeroOrganizationShortCode`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `DiscoverClearingAccount`  string , `AmericanExpressClearingAccount`  string , `BankAccountClearingAccount`  string , `MarinaWalkInCustomerPOSBatchTime`  string , `EnableXero`  string , `AllowOfflineCCPayment`  string , `TimeZone`  string , `SendPartialPaymentsToXero`  string , `OnlinePaymentDefaultEnabled`  string , `NotificationEmailAddress`  string , `SendOnlinePaymentNotifications`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `UseInchesinCalculations`  string , `OnlinePaymentsasPrepayments`  string , `LockDate`  string , `CurrenciesId`  string , `FuelCloudEnabled`  string , `FuelCloudAccessToken`  string , `FuelCloudRefreshToken`  string , `SecurityDepositAccount`  string , `LocationCoordinates`  string , `HashID`  string , `TaxExemptRate`  string , `FinanceCharge_Id`  string , `FinanceChargeId`  string , `FinanceCharge_MarinaLocation_Id`  string , `MOPStatementsOptional`  string , `DueDateDays`  string , `ShowOverrideTaxRate`  string , `OverpaymentAccount`  string , `OnlinePaymentDisabled`  string , `AutoSetLockDate`  string , `AutoLockDateSetting`  string , `InventoryCronActive`  string , `InventoryAdjustmentContact_Id`  string , `XeroErrorNotificationEmail`  string , `DueDateSettingsId`  string , `CurrentlyRunningFinanceCharge`  string , `ShowServiceDinUI`  string , `ShowIDForCustomerPrintout`  string , `WireTransferPaymentAccount`  string , `ShowPastDepartureCheckedIn`  string , `OfferActivityNotificationAddress`  string , `PublicAPIBookingNotificationAddress`  string , `ReceiveFailedOfferNotifications`  string , `HideBillingSummaryInCheckInSheet`  string , `HideBillingSummaryInConfirmation`  string , `MoloLite`  string , `PreArrivalEmailCC`  string , `StripeActive`  string , `StripeApproved`  string , `DefaultAccountLimit`  string , `ShowWebsiteOnPrint`  string , `HiddenDaysCalendar`  string , `ElectricReadingTriggersMinimum`  string , `WaterReadingTriggersMinimum`  string , `MinimumElectricCharge_Id`  string , `MinimumWaterCharge_Id`  string , `DisableFileUpload`  string , `ShowWOCreationDateForCustomer`  string , `AddFinanceChargeToOpenInvoice`  string , `PDFAlwaysOn`  string , `BookingName`  string , `BookingLogo`  string , `BookingBackground`  string , `MoloOnlineBookingDisabled`  string , `BookingIntroductionTextFirstLine`  string , `BookingIntroductionTextSecondLine`  string , `StripeCustomer_Id`  string , `RecordStatus_Id`  string , `StripePayoutTime`  string , `PercentCCFee`  string , `FlatCCFee`  string , `AlwaysPrintTwoCopies`  string , `SendContactIdToXero`  string , `TechnicianRoundingMethod`  string , `SpacesTimelineCustom`  string , `SpacesTimelineCustomButtonText`  string , `ShowMaxDimensions`  string , `TechnicianRoundingValue`  string , `StatementDescriptor`  string , `ShowPaymentAccount`  string , `VesselInsuranceRequired`  string , `OverrideTaxCaption`  string , `ShowContactNameOnSpaces`  string , `FreshdeskCompanyId`  string , `IsTestMarina`  string , `XeroLaborCOGS_Id`  string , `XeroLaborAsset_Id`  string , `XeroSubletCOGS_Id`  string , `XeroSubletAsset_Id`  string , `InternalLaborCOGS_Id`  string , `InternalLaborRevenue_Id`  string , `InternalPartsCOGS_Id`  string , `InternalPartsRevenue_Id`  string , `InternalChargesCOGS_Id`  string , `InternalChargesRevenue_Id`  string , `FallbackSalesAccount_Id`  string , `FallbackSalesTaxRate_Id`  string , `LaborCOSCronActive`  string , `SubletCOSCronActive`  string , `ShowPastDueWarning`  string , `PayoutDescriptor`  string , `SV_Labor_Id`  string , `FinaleInventoryActive`  string , `FinaleUsername`  string , `FinalePassword`  string , `FinaleReportURL`  string , `FinalePhysicalInventoryURL`  string , `FinaleFacilityURL`  string , `FinaleActionURLCancel`  string , `FinaleUserLoginURL`  string , `ShowAutoChargeNotice`  string , `AllowAcceptTermsWithoutPayment`  string , `PrimaryColor`  string , `SecondaryColor`  string , `SeasonStart`  string , `SeasonEnd`  string , `MaxInstantPayout`  string , `InstantPayoutsEnabled`  string , `CashGLCode`  string , `CheckGLCode`  string , `ChipTerminalGLCode`  string , `CreditCardGLCode`  string , `StripeGLCode`  string , `BankAccountGLCode`  string , `WireTransferGLCode`  string , `PrepaymentGLCode`  string , `SecurityDepositGLCode`  string , `OverpaymentGLCode`  string , `ARGLCode`  string , `IDSEndpoint`  string , `IDSAuthorizationToken`  string , `AllowIDSContactImport`  string , `MoloAppPaymentsProvider_Id`  string , `MoloOnlinePaymentsProvider_Id`  string , `MoloOnlineBookingPaymentsProvider_Id`  string , `SalesTaxGLCode`  string , `DiscountGLCode`  string , `FiscalYearStart`  string , `DoNotAutoAllocateOnlinePayments`  string , `GLCodesRequired`  string , `OnlinePaymentFeeCap`  string , `OnlinePaymentFeeCapMethod`  string , `InvoiceFees`  string , `HideReservationDatesOnPrintedMaterials`  string , `LegacyInchesMath`  string , `TrackingCodeActive`  string , `MoloContactId`  string , `OnlinePaymentCurrency`  string , `OnlinePaymentXeroTaxRate`  string , `ShowPassengerCapacityResourceGrid`  string , `Country_Id`  string , `StripePayoutDelayDays`  string , `HideAllResourceOffersInitially`  string , `SortContactsByLastName`  string , `DisplayLastNameFirst`  string , `MaxOnlineResourceBookingsPerPersonPerDay`  string , `NewXeroToken_Id`  string , `APGLCode`  string , `XeroTenantId`  string , `Tip1Amount`  string , `Tip2Amount`  string , `Tip3Amount`  string , `Tip4Amount`  string , `Tip1Setting`  string , `Tip2Setting`  string , `Tip3Setting`  string , `Tip4Setting`  string , `InstallmentsDisabled`  string , `EmailSendingDomain`  string , `EnableProgressInvoicing`  string , `HideShorePower`  string , `DisregardForReporting`  string , `MarinaManagement`  string , `ServiceManagement`  string , `RVOrCampgroundManagement`  string , `VariableInvoicing`  string , `FinanceChargeMinimumBalance`  string , `FinanceChargeMinimumItem_Id`  string , `TaxCodeRefOverride`  string , `CustomerOnlinePaymentFee`  string , `CustomerOnlinePaymentPercentFee`  string , `CustomerOnlinePaymentMinimumFee`  string , `CustomerOnlinePaymentFeeItem`  string , `InProcessTextColor`  string , `PendingTextColor`  string , `ConfirmedTextColor`  string , `CheckedInTextColor`  string , `OnLeaveTextColor`  string , `CheckedOutTextColor`  string , `CancelledTextColor`  string , `InProcessColor`  string , `PendingColor`  string , `ConfirmedColor`  string , `CheckedInColor`  string , `OnLeaveColor`  string , `CheckedOutColor`  string , `CancelledColor`  string , `MarineSyncApiKey`  string , `MarineSyncBatchEnabled`  string , `MarineSyncIntegrationEnabled`  string , `DataExportEntityId`  string , `MarinaStellarInstanceURL`  string , `UseQBOTaxOverride`  string , `CompanyLevelContacts`  string , `SkipOnlinePaymentFees`  string , `SnagASlipPartnerAdminAccess`  string , `DeferralLogic`  string , `DisableVoidRefund`  string , `EnableOnReceiptTipping`  string , `EnableOnReaderTipping`  string , `TippingMode`  string , `SmartThreshold`  string , `IgnoreTaxAmountForTipBasis`  string , `TerminalConfigurationId`  string , `Tip1Percent`  string , `Tip2Percent`  string , `Tip3Percent`  string , `Tip1AmountWeb`  string , `Tip2AmountWeb`  string , `Tip3AmountWeb`  string , `HideGLTaxOverride`  string , `ContactCountryRequired`  string , `DisableFullViewEdits`  string , `DisableSecurityDepositRefundVoid`  string , `LastEditedTime`  string , `LastModifiedAspNetUser`  string , `DisableContactMergeOutsideLockDate`  string , `DisableFutureDatedStandaloneInvoice`  string , `ShowInvoiceDates`  string , `DisableNewReservationInvoice`  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-stage/raw/molo_moloMarinaLocations/2023-10-16/1697439311'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.molo_molomarinalocations"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-stage/raw/molo_moloMarinaLocations/2023-10-16/1697439311
    • id: 611754
    • processed: 1
    • raw_data: 
      {
    "APGLCode": 190,
    "ARGLCode": 161,
    "AddFinanceChargeToOpenInvoice": 91,
    "AllowAcceptTermsWithoutPayment": 144,
    "AllowIDSContactImport": 164,
    "AllowMoloOnlinePayment": 23,
    "AllowOfflineCCPayment": 35,
    "AlwaysPrintTwoCopies": 104,
    "AmericanExpressClearingAccount": 31,
    "ArivalGuide": 5,
    "AutoLockDateSetting": 63,
    "AutoSetLockDate": 62,
    "BankAccountClearingAccount": 32,
    "BankAccountGLCode": 156,
    "BookingBackground": 95,
    "BookingIntroductionTextFirstLine": 97,
    "BookingIntroductionTextSecondLine": 98,
    "BookingLogo": 94,
    "BookingName": 93,
    "CancelledColor": 229,
    "CancelledTextColor": 222,
    "CashClearingAccount": 26,
    "CashGLCode": 151,
    "CheckClearingAccount": 27,
    "CheckGLCode": 152,
    "CheckedInColor": 226,
    "CheckedInTextColor": 219,
    "CheckedOutColor": 228,
    "CheckedOutTextColor": 221,
    "ChipTerminalGLCode": 153,
    "City_Id": 7,
    "CompanyLevelContacts": 236,
    "ConfirmedColor": 225,
    "ConfirmedTextColor": 218,
    "ContactCountryRequired": 254,
    "Country_Id": 183,
    "CreditCardGLCode": 154,
    "CurrenciesId": 46,
    "CurrentlyRunningFinanceCharge": 68,
    "CustomerOnlinePaymentFee": 212,
    "CustomerOnlinePaymentFeeItem": 215,
    "CustomerOnlinePaymentMinimumFee": 214,
    "CustomerOnlinePaymentPercentFee": 213,
    "DataExportEntityId": 233,
    "DefaultAccountLimit": 82,
    "DefaultArrivalTime": 13,
    "DefaultDepartureTime": 14,
    "DefaultTaxRate": 18,
    "DeferralLogic": 239,
    "DepositPercentage": 6,
    "DisableContactMergeOutsideLockDate": 259,
    "DisableFileUpload": 89,
    "DisableFullViewEdits": 255,
    "DisableFutureDatedStandaloneInvoice": 260,
    "DisableNewReservationInvoice": 262,
    "DisableSecurityDepositRefundVoid": 256,
    "DisableVoidRefund": 240,
    "DiscountGLCode": 169,
    "DiscountsAccount": 41,
    "DiscoverClearingAccount": 30,
    "DisplayLastNameFirst": 187,
    "DisregardForReporting": 204,
    "DoNotAutoAllocateOnlinePayments": 171,
    "DueDateDays": 58,
    "DueDateSettingsId": 67,
    "ElectricReadingTriggersMinimum": 85,
    "EmailAddress": 19,
    "EmailSendingDomain": 201,
    "EnableOnReaderTipping": 242,
    "EnableOnReceiptTipping": 241,
    "EnableProgressInvoicing": 202,
    "EnableXero": 34,
    "FallbackSalesAccount_Id": 128,
    "FallbackSalesTaxRate_Id": 129,
    "FinaleActionURLCancel": 141,
    "FinaleFacilityURL": 140,
    "FinaleInventoryActive": 135,
    "FinalePassword": 137,
    "FinalePhysicalInventoryURL": 139,
    "FinaleReportURL": 138,
    "FinaleUserLoginURL": 142,
    "FinaleUsername": 136,
    "FinanceChargeId": 55,
    "FinanceChargeMinimumBalance": 209,
    "FinanceChargeMinimumItem_Id": 210,
    "FinanceCharge_Id": 54,
    "FinanceCharge_MarinaLocation_Id": 56,
    "FiscalYearStart": 170,
    "FlatCCFee": 103,
    "FreshdeskCompanyId": 116,
    "FuelCloudAccessToken": 48,
    "FuelCloudEnabled": 47,
    "FuelCloudRefreshToken": 49,
    "GLCodesRequired": 172,
    "HashID": 52,
    "HiddenDaysCalendar": 84,
    "HideAllResourceOffersInitially": 185,
    "HideBillingSummaryInCheckInSheet": 76,
    "HideBillingSummaryInConfirmation": 77,
    "HideGLTaxOverride": 253,
    "HideReservationDatesOnPrintedMaterials": 176,
    "HideShorePower": 203,
    "IDSAuthorizationToken": 163,
    "IDSEndpoint": 162,
    "Id": 0,
    "IgnoreTaxAmountForTipBasis": 245,
    "InProcessColor": 223,
    "InProcessTextColor": 216,
    "InstallmentsDisabled": 200,
    "InstantPayoutsEnabled": 150,
    "InternalChargesCOGS_Id": 126,
    "InternalChargesRevenue_Id": 127,
    "InternalLaborCOGS_Id": 122,
    "InternalLaborRevenue_Id": 123,
    "InternalPartsCOGS_Id": 124,
    "InternalPartsRevenue_Id": 125,
    "InventoryAdjustmentContact_Id": 65,
    "InventoryCronActive": 64,
    "InvoiceFees": 175,
    "InvoiceWarningDayCount": 20,
    "IsTestMarina": 117,
    "LaborCOSCronActive": 130,
    "LastEditedTime": 257,
    "LastModifiedAspNetUser": 258,
    "LegacyInchesMath": 177,
    "LocationCoordinates": 51,
    "LockDate": 45,
    "MOPStatementsOptional": 57,
    "Map": 16,
    "MarinaHash": 9,
    "MarinaManagement": 205,
    "MarinaStellarInstanceURL": 234,
    "MarinaWalkInCustomerPOSBatchTime": 33,
    "MarinaWebsite": 21,
    "MarineSyncApiKey": 230,
    "MarineSyncBatchEnabled": 231,
    "MarineSyncIntegrationEnabled": 232,
    "MastercardClearingAccount": 29,
    "MaxInstantPayout": 149,
    "MaxOnlineResourceBookingsPerPersonPerDay": 188,
    "MinimumElectricCharge_Id": 87,
    "MinimumWaterCharge_Id": 88,
    "MoloAppPaymentsProvider_Id": 165,
    "MoloContactId": 179,
    "MoloLite": 78,
    "MoloOnlineBookingDisabled": 96,
    "MoloOnlineBookingPaymentsProvider_Id": 167,
    "MoloOnlinePaymentsProvider_Id": 166,
    "Name": 1,
    "NewXeroToken_Id": 189,
    "NotificationEmailAddress": 39,
    "OfferActivityNotificationAddress": 73,
    "OnLeaveColor": 227,
    "OnLeaveTextColor": 220,
    "OnlinePaymentCurrency": 180,
    "OnlinePaymentDefaultEnabled": 38,
    "OnlinePaymentDisabled": 61,
    "OnlinePaymentFeeCap": 173,
    "OnlinePaymentFeeCapMethod": 174,
    "OnlinePaymentXeroTaxRate": 181,
    "OnlinePaymentsasPrepayments": 44,
    "Organization_Id": 8,
    "OverpaymentAccount": 60,
    "OverpaymentGLCode": 160,
    "OverrideTaxCaption": 114,
    "PDFAlwaysOn": 92,
    "PayoutDescriptor": 133,
    "PendingColor": 224,
    "PendingTextColor": 217,
    "PercentCCFee": 102,
    "Policy": 15,
    "PreArrivalEmailCC": 79,
    "PrepaymentAccount": 42,
    "PrepaymentGLCode": 158,
    "PrimaryColor": 145,
    "PrimaryFaxNumber": 3,
    "PrimaryPhoneNumber": 2,
    "PublicAPIBookingNotificationAddress": 74,
    "RVOrCampgroundManagement": 207,
    "ReceiveFailedOfferNotifications": 75,
    "RecordStatus_Id": 100,
    "ReturnsRefundsPolicy": 17,
    "Rules": 4,
    "SV_Labor_Id": 134,
    "SafetyDistanceL": 12,
    "SafetyDistanceW": 11,
    "SalesTaxGLCode": 168,
    "SeasonEnd": 148,
    "SeasonStart": 147,
    "SecondaryColor": 146,
    "SecurityDepositAccount": 50,
    "SecurityDepositGLCode": 159,
    "SendContactIdToXero": 105,
    "SendOnlinePaymentNotifications": 40,
    "SendPartialPaymentsToXero": 37,
    "ServiceManagement": 206,
    "ShowAutoChargeNotice": 143,
    "ShowContactNameOnSpaces": 115,
    "ShowIDForCustomerPrintout": 70,
    "ShowInvoiceDates": 261,
    "ShowMaxDimensions": 109,
    "ShowOverrideTaxRate": 59,
    "ShowPassengerCapacityResourceGrid": 182,
    "ShowPastDepartureCheckedIn": 72,
    "ShowPastDueWarning": 132,
    "ShowPaymentAccount": 112,
    "ShowServiceDinUI": 69,
    "ShowWOCreationDateForCustomer": 90,
    "ShowWebsiteOnPrint": 83,
    "SkipOnlinePaymentFees": 237,
    "SmartThreshold": 244,
    "SnagASlipPartnerAdminAccess": 238,
    "SortContactsByLastName": 186,
    "SpacesTimelineCustom": 107,
    "SpacesTimelineCustomButtonText": 108,
    "StatementDescriptor": 111,
    "StripeActive": 80,
    "StripeApproved": 81,
    "StripeCustomer_Id": 99,
    "StripeGLCode": 155,
    "StripePayoutDelayDays": 184,
    "StripePayoutTime": 101,
    "SubletCOSCronActive": 131,
    "TaxCalculationMethod": 24,
    "TaxCodeRefOverride": 211,
    "TaxExemptRate": 53,
    "TechnicianRoundingMethod": 106,
    "TechnicianRoundingValue": 110,
    "TerminalConfigurationId": 246,
    "TimeZone": 36,
    "Tip1Amount": 192,
    "Tip1AmountWeb": 250,
    "Tip1Percent": 247,
    "Tip1Setting": 196,
    "Tip2Amount": 193,
    "Tip2AmountWeb": 251,
    "Tip2Percent": 248,
    "Tip2Setting": 197,
    "Tip3Amount": 194,
    "Tip3AmountWeb": 252,
    "Tip3Percent": 249,
    "Tip3Setting": 198,
    "Tip4Amount": 195,
    "Tip4Setting": 199,
    "TippingMode": 243,
    "TrackingCodeActive": 178,
    "UnitSystem": 10,
    "UseInchesinCalculations": 43,
    "UseQBOTaxOverride": 235,
    "VariableInvoicing": 208,
    "VesselDimensionsOptions": 22,
    "VesselInsuranceRequired": 113,
    "VisaClearingAccount": 28,
    "WaterReadingTriggersMinimum": 86,
    "WireTransferGLCode": 157,
    "WireTransferPaymentAccount": 71,
    "XeroErrorNotificationEmail": 66,
    "XeroLaborAsset_Id": 119,
    "XeroLaborCOGS_Id": 118,
    "XeroOrganizationShortCode": 25,
    "XeroSubletAsset_Id": 121,
    "XeroSubletCOGS_Id": 120,
    "XeroTenantId": 191
}
    • schema_attributes: 
      {
    "APGLCode": "string",
    "ARGLCode": "string",
    "AddFinanceChargeToOpenInvoice": "string",
    "AllowAcceptTermsWithoutPayment": "string",
    "AllowIDSContactImport": "string",
    "AllowMoloOnlinePayment": "string",
    "AllowOfflineCCPayment": "string",
    "AlwaysPrintTwoCopies": "string",
    "AmericanExpressClearingAccount": "string",
    "ArivalGuide": "string",
    "AutoLockDateSetting": "string",
    "AutoSetLockDate": "string",
    "BankAccountClearingAccount": "string",
    "BankAccountGLCode": "string",
    "BookingBackground": "string",
    "BookingIntroductionTextFirstLine": "string",
    "BookingIntroductionTextSecondLine": "string",
    "BookingLogo": "string",
    "BookingName": "string",
    "CancelledColor": "string",
    "CancelledTextColor": "string",
    "CashClearingAccount": "string",
    "CashGLCode": "string",
    "CheckClearingAccount": "string",
    "CheckGLCode": "string",
    "CheckedInColor": "string",
    "CheckedInTextColor": "string",
    "CheckedOutColor": "string",
    "CheckedOutTextColor": "string",
    "ChipTerminalGLCode": "string",
    "City_Id": "string",
    "CompanyLevelContacts": "string",
    "ConfirmedColor": "string",
    "ConfirmedTextColor": "string",
    "ContactCountryRequired": "string",
    "Country_Id": "string",
    "CreditCardGLCode": "string",
    "CurrenciesId": "string",
    "CurrentlyRunningFinanceCharge": "string",
    "CustomerOnlinePaymentFee": "string",
    "CustomerOnlinePaymentFeeItem": "string",
    "CustomerOnlinePaymentMinimumFee": "string",
    "CustomerOnlinePaymentPercentFee": "string",
    "DataExportEntityId": "string",
    "DefaultAccountLimit": "string",
    "DefaultArrivalTime": "string",
    "DefaultDepartureTime": "string",
    "DefaultTaxRate": "string",
    "DeferralLogic": "string",
    "DepositPercentage": "string",
    "DisableContactMergeOutsideLockDate": "string",
    "DisableFileUpload": "string",
    "DisableFullViewEdits": "string",
    "DisableFutureDatedStandaloneInvoice": "string",
    "DisableNewReservationInvoice": "string",
    "DisableSecurityDepositRefundVoid": "string",
    "DisableVoidRefund": "string",
    "DiscountGLCode": "string",
    "DiscountsAccount": "string",
    "DiscoverClearingAccount": "string",
    "DisplayLastNameFirst": "string",
    "DisregardForReporting": "string",
    "DoNotAutoAllocateOnlinePayments": "string",
    "DueDateDays": "string",
    "DueDateSettingsId": "string",
    "ElectricReadingTriggersMinimum": "string",
    "EmailAddress": "string",
    "EmailSendingDomain": "string",
    "EnableOnReaderTipping": "string",
    "EnableOnReceiptTipping": "string",
    "EnableProgressInvoicing": "string",
    "EnableXero": "string",
    "FallbackSalesAccount_Id": "string",
    "FallbackSalesTaxRate_Id": "string",
    "FinaleActionURLCancel": "string",
    "FinaleFacilityURL": "string",
    "FinaleInventoryActive": "string",
    "FinalePassword": "string",
    "FinalePhysicalInventoryURL": "string",
    "FinaleReportURL": "string",
    "FinaleUserLoginURL": "string",
    "FinaleUsername": "string",
    "FinanceChargeId": "string",
    "FinanceChargeMinimumBalance": "string",
    "FinanceChargeMinimumItem_Id": "string",
    "FinanceCharge_Id": "string",
    "FinanceCharge_MarinaLocation_Id": "string",
    "FiscalYearStart": "string",
    "FlatCCFee": "string",
    "FreshdeskCompanyId": "string",
    "FuelCloudAccessToken": "string",
    "FuelCloudEnabled": "string",
    "FuelCloudRefreshToken": "string",
    "GLCodesRequired": "string",
    "HashID": "string",
    "HiddenDaysCalendar": "string",
    "HideAllResourceOffersInitially": "string",
    "HideBillingSummaryInCheckInSheet": "string",
    "HideBillingSummaryInConfirmation": "string",
    "HideGLTaxOverride": "string",
    "HideReservationDatesOnPrintedMaterials": "string",
    "HideShorePower": "string",
    "IDSAuthorizationToken": "string",
    "IDSEndpoint": "string",
    "Id": "string",
    "IgnoreTaxAmountForTipBasis": "string",
    "InProcessColor": "string",
    "InProcessTextColor": "string",
    "InstallmentsDisabled": "string",
    "InstantPayoutsEnabled": "string",
    "InternalChargesCOGS_Id": "string",
    "InternalChargesRevenue_Id": "string",
    "InternalLaborCOGS_Id": "string",
    "InternalLaborRevenue_Id": "string",
    "InternalPartsCOGS_Id": "string",
    "InternalPartsRevenue_Id": "string",
    "InventoryAdjustmentContact_Id": "string",
    "InventoryCronActive": "string",
    "InvoiceFees": "string",
    "InvoiceWarningDayCount": "string",
    "IsTestMarina": "string",
    "LaborCOSCronActive": "string",
    "LastEditedTime": "string",
    "LastModifiedAspNetUser": "string",
    "LegacyInchesMath": "string",
    "LocationCoordinates": "string",
    "LockDate": "string",
    "MOPStatementsOptional": "string",
    "Map": "string",
    "MarinaHash": "string",
    "MarinaManagement": "string",
    "MarinaStellarInstanceURL": "string",
    "MarinaWalkInCustomerPOSBatchTime": "string",
    "MarinaWebsite": "string",
    "MarineSyncApiKey": "string",
    "MarineSyncBatchEnabled": "string",
    "MarineSyncIntegrationEnabled": "string",
    "MastercardClearingAccount": "string",
    "MaxInstantPayout": "string",
    "MaxOnlineResourceBookingsPerPersonPerDay": "string",
    "MinimumElectricCharge_Id": "string",
    "MinimumWaterCharge_Id": "string",
    "MoloAppPaymentsProvider_Id": "string",
    "MoloContactId": "string",
    "MoloLite": "string",
    "MoloOnlineBookingDisabled": "string",
    "MoloOnlineBookingPaymentsProvider_Id": "string",
    "MoloOnlinePaymentsProvider_Id": "string",
    "Name": "string",
    "NewXeroToken_Id": "string",
    "NotificationEmailAddress": "string",
    "OfferActivityNotificationAddress": "string",
    "OnLeaveColor": "string",
    "OnLeaveTextColor": "string",
    "OnlinePaymentCurrency": "string",
    "OnlinePaymentDefaultEnabled": "string",
    "OnlinePaymentDisabled": "string",
    "OnlinePaymentFeeCap": "string",
    "OnlinePaymentFeeCapMethod": "string",
    "OnlinePaymentXeroTaxRate": "string",
    "OnlinePaymentsasPrepayments": "string",
    "Organization_Id": "string",
    "OverpaymentAccount": "string",
    "OverpaymentGLCode": "string",
    "OverrideTaxCaption": "string",
    "PDFAlwaysOn": "string",
    "PayoutDescriptor": "string",
    "PendingColor": "string",
    "PendingTextColor": "string",
    "PercentCCFee": "string",
    "Policy": "string",
    "PreArrivalEmailCC": "string",
    "PrepaymentAccount": "string",
    "PrepaymentGLCode": "string",
    "PrimaryColor": "string",
    "PrimaryFaxNumber": "string",
    "PrimaryPhoneNumber": "string",
    "PublicAPIBookingNotificationAddress": "string",
    "RVOrCampgroundManagement": "string",
    "ReceiveFailedOfferNotifications": "string",
    "RecordStatus_Id": "string",
    "ReturnsRefundsPolicy": "string",
    "Rules": "string",
    "SV_Labor_Id": "string",
    "SafetyDistanceL": "string",
    "SafetyDistanceW": "string",
    "SalesTaxGLCode": "string",
    "SeasonEnd": "string",
    "SeasonStart": "string",
    "SecondaryColor": "string",
    "SecurityDepositAccount": "string",
    "SecurityDepositGLCode": "string",
    "SendContactIdToXero": "string",
    "SendOnlinePaymentNotifications": "string",
    "SendPartialPaymentsToXero": "string",
    "ServiceManagement": "string",
    "ShowAutoChargeNotice": "string",
    "ShowContactNameOnSpaces": "string",
    "ShowIDForCustomerPrintout": "string",
    "ShowInvoiceDates": "string",
    "ShowMaxDimensions": "string",
    "ShowOverrideTaxRate": "string",
    "ShowPassengerCapacityResourceGrid": "string",
    "ShowPastDepartureCheckedIn": "string",
    "ShowPastDueWarning": "string",
    "ShowPaymentAccount": "string",
    "ShowServiceDinUI": "string",
    "ShowWOCreationDateForCustomer": "string",
    "ShowWebsiteOnPrint": "string",
    "SkipOnlinePaymentFees": "string",
    "SmartThreshold": "string",
    "SnagASlipPartnerAdminAccess": "string",
    "SortContactsByLastName": "string",
    "SpacesTimelineCustom": "string",
    "SpacesTimelineCustomButtonText": "string",
    "StatementDescriptor": "string",
    "StripeActive": "string",
    "StripeApproved": "string",
    "StripeCustomer_Id": "string",
    "StripeGLCode": "string",
    "StripePayoutDelayDays": "string",
    "StripePayoutTime": "string",
    "SubletCOSCronActive": "string",
    "TaxCalculationMethod": "string",
    "TaxCodeRefOverride": "string",
    "TaxExemptRate": "string",
    "TechnicianRoundingMethod": "string",
    "TechnicianRoundingValue": "string",
    "TerminalConfigurationId": "string",
    "TimeZone": "string",
    "Tip1Amount": "string",
    "Tip1AmountWeb": "string",
    "Tip1Percent": "string",
    "Tip1Setting": "string",
    "Tip2Amount": "string",
    "Tip2AmountWeb": "string",
    "Tip2Percent": "string",
    "Tip2Setting": "string",
    "Tip3Amount": "string",
    "Tip3AmountWeb": "string",
    "Tip3Percent": "string",
    "Tip3Setting": "string",
    "Tip4Amount": "string",
    "Tip4Setting": "string",
    "TippingMode": "string",
    "TrackingCodeActive": "string",
    "UnitSystem": "string",
    "UseInchesinCalculations": "string",
    "UseQBOTaxOverride": "string",
    "VariableInvoicing": "string",
    "VesselDimensionsOptions": "string",
    "VesselInsuranceRequired": "string",
    "VisaClearingAccount": "string",
    "WaterReadingTriggersMinimum": "string",
    "WireTransferGLCode": "string",
    "WireTransferPaymentAccount": "string",
    "XeroErrorNotificationEmail": "string",
    "XeroLaborAsset_Id": "string",
    "XeroLaborCOGS_Id": "string",
    "XeroOrganizationShortCode": "string",
    "XeroSubletAsset_Id": "string",
    "XeroSubletCOGS_Id": "string",
    "XeroTenantId": "string"
}
    • schema_name_id: 1925
    • schema_scan_id: 5253267
    • updated: 2023-10-16 01:58:23
    • created: 2023-10-15 01:59:49
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.molo_molomarinalocations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.molo_molomarinalocations`\n(\n `Id`  string , `Name`  string , `PrimaryPhoneNumber`  string , `PrimaryFaxNumber`  string , `Rules`  string , `ArivalGuide`  string , `DepositPercentage`  string , `City_Id`  string , `Organization_Id`  string , `MarinaHash`  string , `UnitSystem`  string , `SafetyDistanceW`  string , `SafetyDistanceL`  string , `DefaultArrivalTime`  string , `DefaultDepartureTime`  string , `Policy`  string , `Map`  string , `ReturnsRefundsPolicy`  string , `DefaultTaxRate`  string , `EmailAddress`  string , `InvoiceWarningDayCount`  string , `MarinaWebsite`  string , `VesselDimensionsOptions`  string , `AllowMoloOnlinePayment`  string , `TaxCalculationMethod`  string , `XeroOrganizationShortCode`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `DiscoverClearingAccount`  string , `AmericanExpressClearingAccount`  string , `BankAccountClearingAccount`  string , `MarinaWalkInCustomerPOSBatchTime`  string , `EnableXero`  string , `AllowOfflineCCPayment`  string , `TimeZone`  string , `SendPartialPaymentsToXero`  string , `OnlinePaymentDefaultEnabled`  string , `NotificationEmailAddress`  string , `SendOnlinePaymentNotifications`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `UseInchesinCalculations`  string , `OnlinePaymentsasPrepayments`  string , `LockDate`  string , `CurrenciesId`  string , `FuelCloudEnabled`  string , `FuelCloudAccessToken`  string , `FuelCloudRefreshToken`  string , `SecurityDepositAccount`  string , `LocationCoordinates`  string , `HashID`  string , `TaxExemptRate`  string , `FinanceCharge_Id`  string , `FinanceChargeId`  string , `FinanceCharge_MarinaLocation_Id`  string , `MOPStatementsOptional`  string , `DueDateDays`  string , `ShowOverrideTaxRate`  string , `OverpaymentAccount`  string , `OnlinePaymentDisabled`  string , `AutoSetLockDate`  string , `AutoLockDateSetting`  string , `InventoryCronActive`  string , `InventoryAdjustmentContact_Id`  string , `XeroErrorNotificationEmail`  string , `DueDateSettingsId`  string , `CurrentlyRunningFinanceCharge`  string , `ShowServiceDinUI`  string , `ShowIDForCustomerPrintout`  string , `WireTransferPaymentAccount`  string , `ShowPastDepartureCheckedIn`  string , `OfferActivityNotificationAddress`  string , `PublicAPIBookingNotificationAddress`  string , `ReceiveFailedOfferNotifications`  string , `HideBillingSummaryInCheckInSheet`  string , `HideBillingSummaryInConfirmation`  string , `MoloLite`  string , `PreArrivalEmailCC`  string , `StripeActive`  string , `StripeApproved`  string , `DefaultAccountLimit`  string , `ShowWebsiteOnPrint`  string , `HiddenDaysCalendar`  string , `ElectricReadingTriggersMinimum`  string , `WaterReadingTriggersMinimum`  string , `MinimumElectricCharge_Id`  string , `MinimumWaterCharge_Id`  string , `DisableFileUpload`  string , `ShowWOCreationDateForCustomer`  string , `AddFinanceChargeToOpenInvoice`  string , `PDFAlwaysOn`  string , `BookingName`  string , `BookingLogo`  string , `BookingBackground`  string , `MoloOnlineBookingDisabled`  string , `BookingIntroductionTextFirstLine`  string , `BookingIntroductionTextSecondLine`  string , `StripeCustomer_Id`  string , `RecordStatus_Id`  string , `StripePayoutTime`  string , `PercentCCFee`  string , `FlatCCFee`  string , `AlwaysPrintTwoCopies`  string , `SendContactIdToXero`  string , `TechnicianRoundingMethod`  string , `SpacesTimelineCustom`  string , `SpacesTimelineCustomButtonText`  string , `ShowMaxDimensions`  string , `TechnicianRoundingValue`  string , `StatementDescriptor`  string , `ShowPaymentAccount`  string , `VesselInsuranceRequired`  string , `OverrideTaxCaption`  string , `ShowContactNameOnSpaces`  string , `FreshdeskCompanyId`  string , `IsTestMarina`  string , `XeroLaborCOGS_Id`  string , `XeroLaborAsset_Id`  string , `XeroSubletCOGS_Id`  string , `XeroSubletAsset_Id`  string , `InternalLaborCOGS_Id`  string , `InternalLaborRevenue_Id`  string , `InternalPartsCOGS_Id`  string , `InternalPartsRevenue_Id`  string , `InternalChargesCOGS_Id`  string , `InternalChargesRevenue_Id`  string , `FallbackSalesAccount_Id`  string , `FallbackSalesTaxRate_Id`  string , `LaborCOSCronActive`  string , `SubletCOSCronActive`  string , `ShowPastDueWarning`  string , `PayoutDescriptor`  string , `SV_Labor_Id`  string , `FinaleInventoryActive`  string , `FinaleUsername`  string , `FinalePassword`  string , `FinaleReportURL`  string , `FinalePhysicalInventoryURL`  string , `FinaleFacilityURL`  string , `FinaleActionURLCancel`  string , `FinaleUserLoginURL`  string , `ShowAutoChargeNotice`  string , `AllowAcceptTermsWithoutPayment`  string , `PrimaryColor`  string , `SecondaryColor`  string , `SeasonStart`  string , `SeasonEnd`  string , `MaxInstantPayout`  string , `InstantPayoutsEnabled`  string , `CashGLCode`  string , `CheckGLCode`  string , `ChipTerminalGLCode`  string , `CreditCardGLCode`  string , `StripeGLCode`  string , `BankAccountGLCode`  string , `WireTransferGLCode`  string , `PrepaymentGLCode`  string , `SecurityDepositGLCode`  string , `OverpaymentGLCode`  string , `ARGLCode`  string , `IDSEndpoint`  string , `IDSAuthorizationToken`  string , `AllowIDSContactImport`  string , `MoloAppPaymentsProvider_Id`  string , `MoloOnlinePaymentsProvider_Id`  string , `MoloOnlineBookingPaymentsProvider_Id`  string , `SalesTaxGLCode`  string , `DiscountGLCode`  string , `FiscalYearStart`  string , `DoNotAutoAllocateOnlinePayments`  string , `GLCodesRequired`  string , `OnlinePaymentFeeCap`  string , `OnlinePaymentFeeCapMethod`  string , `InvoiceFees`  string , `HideReservationDatesOnPrintedMaterials`  string , `LegacyInchesMath`  string , `TrackingCodeActive`  string , `MoloContactId`  string , `OnlinePaymentCurrency`  string , `OnlinePaymentXeroTaxRate`  string , `ShowPassengerCapacityResourceGrid`  string , `Country_Id`  string , `StripePayoutDelayDays`  string , `HideAllResourceOffersInitially`  string , `SortContactsByLastName`  string , `DisplayLastNameFirst`  string , `MaxOnlineResourceBookingsPerPersonPerDay`  string , `NewXeroToken_Id`  string , `APGLCode`  string , `XeroTenantId`  string , `Tip1Amount`  string , `Tip2Amount`  string , `Tip3Amount`  string , `Tip4Amount`  string , `Tip1Setting`  string , `Tip2Setting`  string , `Tip3Setting`  string , `Tip4Setting`  string , `InstallmentsDisabled`  string , `EmailSendingDomain`  string , `EnableProgressInvoicing`  string , `HideShorePower`  string , `DisregardForReporting`  string , `MarinaManagement`  string , `ServiceManagement`  string , `RVOrCampgroundManagement`  string , `VariableInvoicing`  string , `FinanceChargeMinimumBalance`  string , `FinanceChargeMinimumItem_Id`  string , `TaxCodeRefOverride`  string , `CustomerOnlinePaymentFee`  string , `CustomerOnlinePaymentPercentFee`  string , `CustomerOnlinePaymentMinimumFee`  string , `CustomerOnlinePaymentFeeItem`  string , `InProcessTextColor`  string , `PendingTextColor`  string , `ConfirmedTextColor`  string , `CheckedInTextColor`  string , `OnLeaveTextColor`  string , `CheckedOutTextColor`  string , `CancelledTextColor`  string , `InProcessColor`  string , `PendingColor`  string , `ConfirmedColor`  string , `CheckedInColor`  string , `OnLeaveColor`  string , `CheckedOutColor`  string , `CancelledColor`  string , `MarineSyncApiKey`  string , `MarineSyncBatchEnabled`  string , `MarineSyncIntegrationEnabled`  string , `DataExportEntityId`  string , `MarinaStellarInstanceURL`  string , `UseQBOTaxOverride`  string , `CompanyLevelContacts`  string , `SkipOnlinePaymentFees`  string , `SnagASlipPartnerAdminAccess`  string , `DeferralLogic`  string , `DisableVoidRefund`  string , `EnableOnReceiptTipping`  string , `EnableOnReaderTipping`  string , `TippingMode`  string , `SmartThreshold`  string , `IgnoreTaxAmountForTipBasis`  string , `TerminalConfigurationId`  string , `Tip1Percent`  string , `Tip2Percent`  string , `Tip3Percent`  string , `Tip1AmountWeb`  string , `Tip2AmountWeb`  string , `Tip3AmountWeb`  string , `HideGLTaxOverride`  string , `ContactCountryRequired`  string , `DisableFullViewEdits`  string , `DisableSecurityDepositRefundVoid`  string , `LastEditedTime`  string , `LastModifiedAspNetUser`  string , `DisableContactMergeOutsideLockDate`  string , `DisableFutureDatedStandaloneInvoice`  string , `ShowInvoiceDates`  string , `DisableNewReservationInvoice`  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-stage/raw/molo_moloMarinaLocations/2023-10-15/1697352859'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.molo_molomarinalocations"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-stage/raw/molo_moloMarinaLocations/2023-10-15/1697352859
    • id: 611127
    • processed: 1
    • raw_data: 
      {
    "APGLCode": 190,
    "ARGLCode": 161,
    "AddFinanceChargeToOpenInvoice": 91,
    "AllowAcceptTermsWithoutPayment": 144,
    "AllowIDSContactImport": 164,
    "AllowMoloOnlinePayment": 23,
    "AllowOfflineCCPayment": 35,
    "AlwaysPrintTwoCopies": 104,
    "AmericanExpressClearingAccount": 31,
    "ArivalGuide": 5,
    "AutoLockDateSetting": 63,
    "AutoSetLockDate": 62,
    "BankAccountClearingAccount": 32,
    "BankAccountGLCode": 156,
    "BookingBackground": 95,
    "BookingIntroductionTextFirstLine": 97,
    "BookingIntroductionTextSecondLine": 98,
    "BookingLogo": 94,
    "BookingName": 93,
    "CancelledColor": 229,
    "CancelledTextColor": 222,
    "CashClearingAccount": 26,
    "CashGLCode": 151,
    "CheckClearingAccount": 27,
    "CheckGLCode": 152,
    "CheckedInColor": 226,
    "CheckedInTextColor": 219,
    "CheckedOutColor": 228,
    "CheckedOutTextColor": 221,
    "ChipTerminalGLCode": 153,
    "City_Id": 7,
    "CompanyLevelContacts": 236,
    "ConfirmedColor": 225,
    "ConfirmedTextColor": 218,
    "ContactCountryRequired": 254,
    "Country_Id": 183,
    "CreditCardGLCode": 154,
    "CurrenciesId": 46,
    "CurrentlyRunningFinanceCharge": 68,
    "CustomerOnlinePaymentFee": 212,
    "CustomerOnlinePaymentFeeItem": 215,
    "CustomerOnlinePaymentMinimumFee": 214,
    "CustomerOnlinePaymentPercentFee": 213,
    "DataExportEntityId": 233,
    "DefaultAccountLimit": 82,
    "DefaultArrivalTime": 13,
    "DefaultDepartureTime": 14,
    "DefaultTaxRate": 18,
    "DeferralLogic": 239,
    "DepositPercentage": 6,
    "DisableContactMergeOutsideLockDate": 259,
    "DisableFileUpload": 89,
    "DisableFullViewEdits": 255,
    "DisableFutureDatedStandaloneInvoice": 260,
    "DisableNewReservationInvoice": 262,
    "DisableSecurityDepositRefundVoid": 256,
    "DisableVoidRefund": 240,
    "DiscountGLCode": 169,
    "DiscountsAccount": 41,
    "DiscoverClearingAccount": 30,
    "DisplayLastNameFirst": 187,
    "DisregardForReporting": 204,
    "DoNotAutoAllocateOnlinePayments": 171,
    "DueDateDays": 58,
    "DueDateSettingsId": 67,
    "ElectricReadingTriggersMinimum": 85,
    "EmailAddress": 19,
    "EmailSendingDomain": 201,
    "EnableOnReaderTipping": 242,
    "EnableOnReceiptTipping": 241,
    "EnableProgressInvoicing": 202,
    "EnableXero": 34,
    "FallbackSalesAccount_Id": 128,
    "FallbackSalesTaxRate_Id": 129,
    "FinaleActionURLCancel": 141,
    "FinaleFacilityURL": 140,
    "FinaleInventoryActive": 135,
    "FinalePassword": 137,
    "FinalePhysicalInventoryURL": 139,
    "FinaleReportURL": 138,
    "FinaleUserLoginURL": 142,
    "FinaleUsername": 136,
    "FinanceChargeId": 55,
    "FinanceChargeMinimumBalance": 209,
    "FinanceChargeMinimumItem_Id": 210,
    "FinanceCharge_Id": 54,
    "FinanceCharge_MarinaLocation_Id": 56,
    "FiscalYearStart": 170,
    "FlatCCFee": 103,
    "FreshdeskCompanyId": 116,
    "FuelCloudAccessToken": 48,
    "FuelCloudEnabled": 47,
    "FuelCloudRefreshToken": 49,
    "GLCodesRequired": 172,
    "HashID": 52,
    "HiddenDaysCalendar": 84,
    "HideAllResourceOffersInitially": 185,
    "HideBillingSummaryInCheckInSheet": 76,
    "HideBillingSummaryInConfirmation": 77,
    "HideGLTaxOverride": 253,
    "HideReservationDatesOnPrintedMaterials": 176,
    "HideShorePower": 203,
    "IDSAuthorizationToken": 163,
    "IDSEndpoint": 162,
    "Id": 0,
    "IgnoreTaxAmountForTipBasis": 245,
    "InProcessColor": 223,
    "InProcessTextColor": 216,
    "InstallmentsDisabled": 200,
    "InstantPayoutsEnabled": 150,
    "InternalChargesCOGS_Id": 126,
    "InternalChargesRevenue_Id": 127,
    "InternalLaborCOGS_Id": 122,
    "InternalLaborRevenue_Id": 123,
    "InternalPartsCOGS_Id": 124,
    "InternalPartsRevenue_Id": 125,
    "InventoryAdjustmentContact_Id": 65,
    "InventoryCronActive": 64,
    "InvoiceFees": 175,
    "InvoiceWarningDayCount": 20,
    "IsTestMarina": 117,
    "LaborCOSCronActive": 130,
    "LastEditedTime": 257,
    "LastModifiedAspNetUser": 258,
    "LegacyInchesMath": 177,
    "LocationCoordinates": 51,
    "LockDate": 45,
    "MOPStatementsOptional": 57,
    "Map": 16,
    "MarinaHash": 9,
    "MarinaManagement": 205,
    "MarinaStellarInstanceURL": 234,
    "MarinaWalkInCustomerPOSBatchTime": 33,
    "MarinaWebsite": 21,
    "MarineSyncApiKey": 230,
    "MarineSyncBatchEnabled": 231,
    "MarineSyncIntegrationEnabled": 232,
    "MastercardClearingAccount": 29,
    "MaxInstantPayout": 149,
    "MaxOnlineResourceBookingsPerPersonPerDay": 188,
    "MinimumElectricCharge_Id": 87,
    "MinimumWaterCharge_Id": 88,
    "MoloAppPaymentsProvider_Id": 165,
    "MoloContactId": 179,
    "MoloLite": 78,
    "MoloOnlineBookingDisabled": 96,
    "MoloOnlineBookingPaymentsProvider_Id": 167,
    "MoloOnlinePaymentsProvider_Id": 166,
    "Name": 1,
    "NewXeroToken_Id": 189,
    "NotificationEmailAddress": 39,
    "OfferActivityNotificationAddress": 73,
    "OnLeaveColor": 227,
    "OnLeaveTextColor": 220,
    "OnlinePaymentCurrency": 180,
    "OnlinePaymentDefaultEnabled": 38,
    "OnlinePaymentDisabled": 61,
    "OnlinePaymentFeeCap": 173,
    "OnlinePaymentFeeCapMethod": 174,
    "OnlinePaymentXeroTaxRate": 181,
    "OnlinePaymentsasPrepayments": 44,
    "Organization_Id": 8,
    "OverpaymentAccount": 60,
    "OverpaymentGLCode": 160,
    "OverrideTaxCaption": 114,
    "PDFAlwaysOn": 92,
    "PayoutDescriptor": 133,
    "PendingColor": 224,
    "PendingTextColor": 217,
    "PercentCCFee": 102,
    "Policy": 15,
    "PreArrivalEmailCC": 79,
    "PrepaymentAccount": 42,
    "PrepaymentGLCode": 158,
    "PrimaryColor": 145,
    "PrimaryFaxNumber": 3,
    "PrimaryPhoneNumber": 2,
    "PublicAPIBookingNotificationAddress": 74,
    "RVOrCampgroundManagement": 207,
    "ReceiveFailedOfferNotifications": 75,
    "RecordStatus_Id": 100,
    "ReturnsRefundsPolicy": 17,
    "Rules": 4,
    "SV_Labor_Id": 134,
    "SafetyDistanceL": 12,
    "SafetyDistanceW": 11,
    "SalesTaxGLCode": 168,
    "SeasonEnd": 148,
    "SeasonStart": 147,
    "SecondaryColor": 146,
    "SecurityDepositAccount": 50,
    "SecurityDepositGLCode": 159,
    "SendContactIdToXero": 105,
    "SendOnlinePaymentNotifications": 40,
    "SendPartialPaymentsToXero": 37,
    "ServiceManagement": 206,
    "ShowAutoChargeNotice": 143,
    "ShowContactNameOnSpaces": 115,
    "ShowIDForCustomerPrintout": 70,
    "ShowInvoiceDates": 261,
    "ShowMaxDimensions": 109,
    "ShowOverrideTaxRate": 59,
    "ShowPassengerCapacityResourceGrid": 182,
    "ShowPastDepartureCheckedIn": 72,
    "ShowPastDueWarning": 132,
    "ShowPaymentAccount": 112,
    "ShowServiceDinUI": 69,
    "ShowWOCreationDateForCustomer": 90,
    "ShowWebsiteOnPrint": 83,
    "SkipOnlinePaymentFees": 237,
    "SmartThreshold": 244,
    "SnagASlipPartnerAdminAccess": 238,
    "SortContactsByLastName": 186,
    "SpacesTimelineCustom": 107,
    "SpacesTimelineCustomButtonText": 108,
    "StatementDescriptor": 111,
    "StripeActive": 80,
    "StripeApproved": 81,
    "StripeCustomer_Id": 99,
    "StripeGLCode": 155,
    "StripePayoutDelayDays": 184,
    "StripePayoutTime": 101,
    "SubletCOSCronActive": 131,
    "TaxCalculationMethod": 24,
    "TaxCodeRefOverride": 211,
    "TaxExemptRate": 53,
    "TechnicianRoundingMethod": 106,
    "TechnicianRoundingValue": 110,
    "TerminalConfigurationId": 246,
    "TimeZone": 36,
    "Tip1Amount": 192,
    "Tip1AmountWeb": 250,
    "Tip1Percent": 247,
    "Tip1Setting": 196,
    "Tip2Amount": 193,
    "Tip2AmountWeb": 251,
    "Tip2Percent": 248,
    "Tip2Setting": 197,
    "Tip3Amount": 194,
    "Tip3AmountWeb": 252,
    "Tip3Percent": 249,
    "Tip3Setting": 198,
    "Tip4Amount": 195,
    "Tip4Setting": 199,
    "TippingMode": 243,
    "TrackingCodeActive": 178,
    "UnitSystem": 10,
    "UseInchesinCalculations": 43,
    "UseQBOTaxOverride": 235,
    "VariableInvoicing": 208,
    "VesselDimensionsOptions": 22,
    "VesselInsuranceRequired": 113,
    "VisaClearingAccount": 28,
    "WaterReadingTriggersMinimum": 86,
    "WireTransferGLCode": 157,
    "WireTransferPaymentAccount": 71,
    "XeroErrorNotificationEmail": 66,
    "XeroLaborAsset_Id": 119,
    "XeroLaborCOGS_Id": 118,
    "XeroOrganizationShortCode": 25,
    "XeroSubletAsset_Id": 121,
    "XeroSubletCOGS_Id": 120,
    "XeroTenantId": 191
}
    • schema_attributes: 
      {
    "APGLCode": "string",
    "ARGLCode": "string",
    "AddFinanceChargeToOpenInvoice": "string",
    "AllowAcceptTermsWithoutPayment": "string",
    "AllowIDSContactImport": "string",
    "AllowMoloOnlinePayment": "string",
    "AllowOfflineCCPayment": "string",
    "AlwaysPrintTwoCopies": "string",
    "AmericanExpressClearingAccount": "string",
    "ArivalGuide": "string",
    "AutoLockDateSetting": "string",
    "AutoSetLockDate": "string",
    "BankAccountClearingAccount": "string",
    "BankAccountGLCode": "string",
    "BookingBackground": "string",
    "BookingIntroductionTextFirstLine": "string",
    "BookingIntroductionTextSecondLine": "string",
    "BookingLogo": "string",
    "BookingName": "string",
    "CancelledColor": "string",
    "CancelledTextColor": "string",
    "CashClearingAccount": "string",
    "CashGLCode": "string",
    "CheckClearingAccount": "string",
    "CheckGLCode": "string",
    "CheckedInColor": "string",
    "CheckedInTextColor": "string",
    "CheckedOutColor": "string",
    "CheckedOutTextColor": "string",
    "ChipTerminalGLCode": "string",
    "City_Id": "string",
    "CompanyLevelContacts": "string",
    "ConfirmedColor": "string",
    "ConfirmedTextColor": "string",
    "ContactCountryRequired": "string",
    "Country_Id": "string",
    "CreditCardGLCode": "string",
    "CurrenciesId": "string",
    "CurrentlyRunningFinanceCharge": "string",
    "CustomerOnlinePaymentFee": "string",
    "CustomerOnlinePaymentFeeItem": "string",
    "CustomerOnlinePaymentMinimumFee": "string",
    "CustomerOnlinePaymentPercentFee": "string",
    "DataExportEntityId": "string",
    "DefaultAccountLimit": "string",
    "DefaultArrivalTime": "string",
    "DefaultDepartureTime": "string",
    "DefaultTaxRate": "string",
    "DeferralLogic": "string",
    "DepositPercentage": "string",
    "DisableContactMergeOutsideLockDate": "string",
    "DisableFileUpload": "string",
    "DisableFullViewEdits": "string",
    "DisableFutureDatedStandaloneInvoice": "string",
    "DisableNewReservationInvoice": "string",
    "DisableSecurityDepositRefundVoid": "string",
    "DisableVoidRefund": "string",
    "DiscountGLCode": "string",
    "DiscountsAccount": "string",
    "DiscoverClearingAccount": "string",
    "DisplayLastNameFirst": "string",
    "DisregardForReporting": "string",
    "DoNotAutoAllocateOnlinePayments": "string",
    "DueDateDays": "string",
    "DueDateSettingsId": "string",
    "ElectricReadingTriggersMinimum": "string",
    "EmailAddress": "string",
    "EmailSendingDomain": "string",
    "EnableOnReaderTipping": "string",
    "EnableOnReceiptTipping": "string",
    "EnableProgressInvoicing": "string",
    "EnableXero": "string",
    "FallbackSalesAccount_Id": "string",
    "FallbackSalesTaxRate_Id": "string",
    "FinaleActionURLCancel": "string",
    "FinaleFacilityURL": "string",
    "FinaleInventoryActive": "string",
    "FinalePassword": "string",
    "FinalePhysicalInventoryURL": "string",
    "FinaleReportURL": "string",
    "FinaleUserLoginURL": "string",
    "FinaleUsername": "string",
    "FinanceChargeId": "string",
    "FinanceChargeMinimumBalance": "string",
    "FinanceChargeMinimumItem_Id": "string",
    "FinanceCharge_Id": "string",
    "FinanceCharge_MarinaLocation_Id": "string",
    "FiscalYearStart": "string",
    "FlatCCFee": "string",
    "FreshdeskCompanyId": "string",
    "FuelCloudAccessToken": "string",
    "FuelCloudEnabled": "string",
    "FuelCloudRefreshToken": "string",
    "GLCodesRequired": "string",
    "HashID": "string",
    "HiddenDaysCalendar": "string",
    "HideAllResourceOffersInitially": "string",
    "HideBillingSummaryInCheckInSheet": "string",
    "HideBillingSummaryInConfirmation": "string",
    "HideGLTaxOverride": "string",
    "HideReservationDatesOnPrintedMaterials": "string",
    "HideShorePower": "string",
    "IDSAuthorizationToken": "string",
    "IDSEndpoint": "string",
    "Id": "string",
    "IgnoreTaxAmountForTipBasis": "string",
    "InProcessColor": "string",
    "InProcessTextColor": "string",
    "InstallmentsDisabled": "string",
    "InstantPayoutsEnabled": "string",
    "InternalChargesCOGS_Id": "string",
    "InternalChargesRevenue_Id": "string",
    "InternalLaborCOGS_Id": "string",
    "InternalLaborRevenue_Id": "string",
    "InternalPartsCOGS_Id": "string",
    "InternalPartsRevenue_Id": "string",
    "InventoryAdjustmentContact_Id": "string",
    "InventoryCronActive": "string",
    "InvoiceFees": "string",
    "InvoiceWarningDayCount": "string",
    "IsTestMarina": "string",
    "LaborCOSCronActive": "string",
    "LastEditedTime": "string",
    "LastModifiedAspNetUser": "string",
    "LegacyInchesMath": "string",
    "LocationCoordinates": "string",
    "LockDate": "string",
    "MOPStatementsOptional": "string",
    "Map": "string",
    "MarinaHash": "string",
    "MarinaManagement": "string",
    "MarinaStellarInstanceURL": "string",
    "MarinaWalkInCustomerPOSBatchTime": "string",
    "MarinaWebsite": "string",
    "MarineSyncApiKey": "string",
    "MarineSyncBatchEnabled": "string",
    "MarineSyncIntegrationEnabled": "string",
    "MastercardClearingAccount": "string",
    "MaxInstantPayout": "string",
    "MaxOnlineResourceBookingsPerPersonPerDay": "string",
    "MinimumElectricCharge_Id": "string",
    "MinimumWaterCharge_Id": "string",
    "MoloAppPaymentsProvider_Id": "string",
    "MoloContactId": "string",
    "MoloLite": "string",
    "MoloOnlineBookingDisabled": "string",
    "MoloOnlineBookingPaymentsProvider_Id": "string",
    "MoloOnlinePaymentsProvider_Id": "string",
    "Name": "string",
    "NewXeroToken_Id": "string",
    "NotificationEmailAddress": "string",
    "OfferActivityNotificationAddress": "string",
    "OnLeaveColor": "string",
    "OnLeaveTextColor": "string",
    "OnlinePaymentCurrency": "string",
    "OnlinePaymentDefaultEnabled": "string",
    "OnlinePaymentDisabled": "string",
    "OnlinePaymentFeeCap": "string",
    "OnlinePaymentFeeCapMethod": "string",
    "OnlinePaymentXeroTaxRate": "string",
    "OnlinePaymentsasPrepayments": "string",
    "Organization_Id": "string",
    "OverpaymentAccount": "string",
    "OverpaymentGLCode": "string",
    "OverrideTaxCaption": "string",
    "PDFAlwaysOn": "string",
    "PayoutDescriptor": "string",
    "PendingColor": "string",
    "PendingTextColor": "string",
    "PercentCCFee": "string",
    "Policy": "string",
    "PreArrivalEmailCC": "string",
    "PrepaymentAccount": "string",
    "PrepaymentGLCode": "string",
    "PrimaryColor": "string",
    "PrimaryFaxNumber": "string",
    "PrimaryPhoneNumber": "string",
    "PublicAPIBookingNotificationAddress": "string",
    "RVOrCampgroundManagement": "string",
    "ReceiveFailedOfferNotifications": "string",
    "RecordStatus_Id": "string",
    "ReturnsRefundsPolicy": "string",
    "Rules": "string",
    "SV_Labor_Id": "string",
    "SafetyDistanceL": "string",
    "SafetyDistanceW": "string",
    "SalesTaxGLCode": "string",
    "SeasonEnd": "string",
    "SeasonStart": "string",
    "SecondaryColor": "string",
    "SecurityDepositAccount": "string",
    "SecurityDepositGLCode": "string",
    "SendContactIdToXero": "string",
    "SendOnlinePaymentNotifications": "string",
    "SendPartialPaymentsToXero": "string",
    "ServiceManagement": "string",
    "ShowAutoChargeNotice": "string",
    "ShowContactNameOnSpaces": "string",
    "ShowIDForCustomerPrintout": "string",
    "ShowInvoiceDates": "string",
    "ShowMaxDimensions": "string",
    "ShowOverrideTaxRate": "string",
    "ShowPassengerCapacityResourceGrid": "string",
    "ShowPastDepartureCheckedIn": "string",
    "ShowPastDueWarning": "string",
    "ShowPaymentAccount": "string",
    "ShowServiceDinUI": "string",
    "ShowWOCreationDateForCustomer": "string",
    "ShowWebsiteOnPrint": "string",
    "SkipOnlinePaymentFees": "string",
    "SmartThreshold": "string",
    "SnagASlipPartnerAdminAccess": "string",
    "SortContactsByLastName": "string",
    "SpacesTimelineCustom": "string",
    "SpacesTimelineCustomButtonText": "string",
    "StatementDescriptor": "string",
    "StripeActive": "string",
    "StripeApproved": "string",
    "StripeCustomer_Id": "string",
    "StripeGLCode": "string",
    "StripePayoutDelayDays": "string",
    "StripePayoutTime": "string",
    "SubletCOSCronActive": "string",
    "TaxCalculationMethod": "string",
    "TaxCodeRefOverride": "string",
    "TaxExemptRate": "string",
    "TechnicianRoundingMethod": "string",
    "TechnicianRoundingValue": "string",
    "TerminalConfigurationId": "string",
    "TimeZone": "string",
    "Tip1Amount": "string",
    "Tip1AmountWeb": "string",
    "Tip1Percent": "string",
    "Tip1Setting": "string",
    "Tip2Amount": "string",
    "Tip2AmountWeb": "string",
    "Tip2Percent": "string",
    "Tip2Setting": "string",
    "Tip3Amount": "string",
    "Tip3AmountWeb": "string",
    "Tip3Percent": "string",
    "Tip3Setting": "string",
    "Tip4Amount": "string",
    "Tip4Setting": "string",
    "TippingMode": "string",
    "TrackingCodeActive": "string",
    "UnitSystem": "string",
    "UseInchesinCalculations": "string",
    "UseQBOTaxOverride": "string",
    "VariableInvoicing": "string",
    "VesselDimensionsOptions": "string",
    "VesselInsuranceRequired": "string",
    "VisaClearingAccount": "string",
    "WaterReadingTriggersMinimum": "string",
    "WireTransferGLCode": "string",
    "WireTransferPaymentAccount": "string",
    "XeroErrorNotificationEmail": "string",
    "XeroLaborAsset_Id": "string",
    "XeroLaborCOGS_Id": "string",
    "XeroOrganizationShortCode": "string",
    "XeroSubletAsset_Id": "string",
    "XeroSubletCOGS_Id": "string",
    "XeroTenantId": "string"
}
    • schema_name_id: 1925
    • schema_scan_id: 5251460
    • updated: 2023-10-15 02:00:00
    • created: 2023-10-14 01:58:25
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.molo_molomarinalocations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.molo_molomarinalocations`\n(\n `Id`  string , `Name`  string , `PrimaryPhoneNumber`  string , `PrimaryFaxNumber`  string , `Rules`  string , `ArivalGuide`  string , `DepositPercentage`  string , `City_Id`  string , `Organization_Id`  string , `MarinaHash`  string , `UnitSystem`  string , `SafetyDistanceW`  string , `SafetyDistanceL`  string , `DefaultArrivalTime`  string , `DefaultDepartureTime`  string , `Policy`  string , `Map`  string , `ReturnsRefundsPolicy`  string , `DefaultTaxRate`  string , `EmailAddress`  string , `InvoiceWarningDayCount`  string , `MarinaWebsite`  string , `VesselDimensionsOptions`  string , `AllowMoloOnlinePayment`  string , `TaxCalculationMethod`  string , `XeroOrganizationShortCode`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `DiscoverClearingAccount`  string , `AmericanExpressClearingAccount`  string , `BankAccountClearingAccount`  string , `MarinaWalkInCustomerPOSBatchTime`  string , `EnableXero`  string , `AllowOfflineCCPayment`  string , `TimeZone`  string , `SendPartialPaymentsToXero`  string , `OnlinePaymentDefaultEnabled`  string , `NotificationEmailAddress`  string , `SendOnlinePaymentNotifications`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `UseInchesinCalculations`  string , `OnlinePaymentsasPrepayments`  string , `LockDate`  string , `CurrenciesId`  string , `FuelCloudEnabled`  string , `FuelCloudAccessToken`  string , `FuelCloudRefreshToken`  string , `SecurityDepositAccount`  string , `LocationCoordinates`  string , `HashID`  string , `TaxExemptRate`  string , `FinanceCharge_Id`  string , `FinanceChargeId`  string , `FinanceCharge_MarinaLocation_Id`  string , `MOPStatementsOptional`  string , `DueDateDays`  string , `ShowOverrideTaxRate`  string , `OverpaymentAccount`  string , `OnlinePaymentDisabled`  string , `AutoSetLockDate`  string , `AutoLockDateSetting`  string , `InventoryCronActive`  string , `InventoryAdjustmentContact_Id`  string , `XeroErrorNotificationEmail`  string , `DueDateSettingsId`  string , `CurrentlyRunningFinanceCharge`  string , `ShowServiceDinUI`  string , `ShowIDForCustomerPrintout`  string , `WireTransferPaymentAccount`  string , `ShowPastDepartureCheckedIn`  string , `OfferActivityNotificationAddress`  string , `PublicAPIBookingNotificationAddress`  string , `ReceiveFailedOfferNotifications`  string , `HideBillingSummaryInCheckInSheet`  string , `HideBillingSummaryInConfirmation`  string , `MoloLite`  string , `PreArrivalEmailCC`  string , `StripeActive`  string , `StripeApproved`  string , `DefaultAccountLimit`  string , `ShowWebsiteOnPrint`  string , `HiddenDaysCalendar`  string , `ElectricReadingTriggersMinimum`  string , `WaterReadingTriggersMinimum`  string , `MinimumElectricCharge_Id`  string , `MinimumWaterCharge_Id`  string , `DisableFileUpload`  string , `ShowWOCreationDateForCustomer`  string , `AddFinanceChargeToOpenInvoice`  string , `PDFAlwaysOn`  string , `BookingName`  string , `BookingLogo`  string , `BookingBackground`  string , `MoloOnlineBookingDisabled`  string , `BookingIntroductionTextFirstLine`  string , `BookingIntroductionTextSecondLine`  string , `StripeCustomer_Id`  string , `RecordStatus_Id`  string , `StripePayoutTime`  string , `PercentCCFee`  string , `FlatCCFee`  string , `AlwaysPrintTwoCopies`  string , `SendContactIdToXero`  string , `TechnicianRoundingMethod`  string , `SpacesTimelineCustom`  string , `SpacesTimelineCustomButtonText`  string , `ShowMaxDimensions`  string , `TechnicianRoundingValue`  string , `StatementDescriptor`  string , `ShowPaymentAccount`  string , `VesselInsuranceRequired`  string , `OverrideTaxCaption`  string , `ShowContactNameOnSpaces`  string , `FreshdeskCompanyId`  string , `IsTestMarina`  string , `XeroLaborCOGS_Id`  string , `XeroLaborAsset_Id`  string , `XeroSubletCOGS_Id`  string , `XeroSubletAsset_Id`  string , `InternalLaborCOGS_Id`  string , `InternalLaborRevenue_Id`  string , `InternalPartsCOGS_Id`  string , `InternalPartsRevenue_Id`  string , `InternalChargesCOGS_Id`  string , `InternalChargesRevenue_Id`  string , `FallbackSalesAccount_Id`  string , `FallbackSalesTaxRate_Id`  string , `LaborCOSCronActive`  string , `SubletCOSCronActive`  string , `ShowPastDueWarning`  string , `PayoutDescriptor`  string , `SV_Labor_Id`  string , `FinaleInventoryActive`  string , `FinaleUsername`  string , `FinalePassword`  string , `FinaleReportURL`  string , `FinalePhysicalInventoryURL`  string , `FinaleFacilityURL`  string , `FinaleActionURLCancel`  string , `FinaleUserLoginURL`  string , `ShowAutoChargeNotice`  string , `AllowAcceptTermsWithoutPayment`  string , `PrimaryColor`  string , `SecondaryColor`  string , `SeasonStart`  string , `SeasonEnd`  string , `MaxInstantPayout`  string , `InstantPayoutsEnabled`  string , `CashGLCode`  string , `CheckGLCode`  string , `ChipTerminalGLCode`  string , `CreditCardGLCode`  string , `StripeGLCode`  string , `BankAccountGLCode`  string , `WireTransferGLCode`  string , `PrepaymentGLCode`  string , `SecurityDepositGLCode`  string , `OverpaymentGLCode`  string , `ARGLCode`  string , `IDSEndpoint`  string , `IDSAuthorizationToken`  string , `AllowIDSContactImport`  string , `MoloAppPaymentsProvider_Id`  string , `MoloOnlinePaymentsProvider_Id`  string , `MoloOnlineBookingPaymentsProvider_Id`  string , `SalesTaxGLCode`  string , `DiscountGLCode`  string , `FiscalYearStart`  string , `DoNotAutoAllocateOnlinePayments`  string , `GLCodesRequired`  string , `OnlinePaymentFeeCap`  string , `OnlinePaymentFeeCapMethod`  string , `InvoiceFees`  string , `HideReservationDatesOnPrintedMaterials`  string , `LegacyInchesMath`  string , `TrackingCodeActive`  string , `MoloContactId`  string , `OnlinePaymentCurrency`  string , `OnlinePaymentXeroTaxRate`  string , `ShowPassengerCapacityResourceGrid`  string , `Country_Id`  string , `StripePayoutDelayDays`  string , `HideAllResourceOffersInitially`  string , `SortContactsByLastName`  string , `DisplayLastNameFirst`  string , `MaxOnlineResourceBookingsPerPersonPerDay`  string , `NewXeroToken_Id`  string , `APGLCode`  string , `XeroTenantId`  string , `Tip1Amount`  string , `Tip2Amount`  string , `Tip3Amount`  string , `Tip4Amount`  string , `Tip1Setting`  string , `Tip2Setting`  string , `Tip3Setting`  string , `Tip4Setting`  string , `InstallmentsDisabled`  string , `EmailSendingDomain`  string , `EnableProgressInvoicing`  string , `HideShorePower`  string , `DisregardForReporting`  string , `MarinaManagement`  string , `ServiceManagement`  string , `RVOrCampgroundManagement`  string , `VariableInvoicing`  string , `FinanceChargeMinimumBalance`  string , `FinanceChargeMinimumItem_Id`  string , `TaxCodeRefOverride`  string , `CustomerOnlinePaymentFee`  string , `CustomerOnlinePaymentPercentFee`  string , `CustomerOnlinePaymentMinimumFee`  string , `CustomerOnlinePaymentFeeItem`  string , `InProcessTextColor`  string , `PendingTextColor`  string , `ConfirmedTextColor`  string , `CheckedInTextColor`  string , `OnLeaveTextColor`  string , `CheckedOutTextColor`  string , `CancelledTextColor`  string , `InProcessColor`  string , `PendingColor`  string , `ConfirmedColor`  string , `CheckedInColor`  string , `OnLeaveColor`  string , `CheckedOutColor`  string , `CancelledColor`  string , `MarineSyncApiKey`  string , `MarineSyncBatchEnabled`  string , `MarineSyncIntegrationEnabled`  string , `DataExportEntityId`  string , `MarinaStellarInstanceURL`  string , `UseQBOTaxOverride`  string , `CompanyLevelContacts`  string , `SkipOnlinePaymentFees`  string , `SnagASlipPartnerAdminAccess`  string , `DeferralLogic`  string , `DisableVoidRefund`  string , `EnableOnReceiptTipping`  string , `EnableOnReaderTipping`  string , `TippingMode`  string , `SmartThreshold`  string , `IgnoreTaxAmountForTipBasis`  string , `TerminalConfigurationId`  string , `Tip1Percent`  string , `Tip2Percent`  string , `Tip3Percent`  string , `Tip1AmountWeb`  string , `Tip2AmountWeb`  string , `Tip3AmountWeb`  string , `HideGLTaxOverride`  string , `ContactCountryRequired`  string , `DisableFullViewEdits`  string , `DisableSecurityDepositRefundVoid`  string , `LastEditedTime`  string , `LastModifiedAspNetUser`  string , `DisableContactMergeOutsideLockDate`  string , `DisableFutureDatedStandaloneInvoice`  string , `ShowInvoiceDates`  string , `DisableNewReservationInvoice`  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-stage/raw/molo_moloMarinaLocations/2023-10-14/1697266537'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.molo_molomarinalocations"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-stage/raw/molo_moloMarinaLocations/2023-10-14/1697266537
    • id: 610395
    • processed: 1
    • raw_data: 
      {
    "APGLCode": 190,
    "ARGLCode": 161,
    "AddFinanceChargeToOpenInvoice": 91,
    "AllowAcceptTermsWithoutPayment": 144,
    "AllowIDSContactImport": 164,
    "AllowMoloOnlinePayment": 23,
    "AllowOfflineCCPayment": 35,
    "AlwaysPrintTwoCopies": 104,
    "AmericanExpressClearingAccount": 31,
    "ArivalGuide": 5,
    "AutoLockDateSetting": 63,
    "AutoSetLockDate": 62,
    "BankAccountClearingAccount": 32,
    "BankAccountGLCode": 156,
    "BookingBackground": 95,
    "BookingIntroductionTextFirstLine": 97,
    "BookingIntroductionTextSecondLine": 98,
    "BookingLogo": 94,
    "BookingName": 93,
    "CancelledColor": 229,
    "CancelledTextColor": 222,
    "CashClearingAccount": 26,
    "CashGLCode": 151,
    "CheckClearingAccount": 27,
    "CheckGLCode": 152,
    "CheckedInColor": 226,
    "CheckedInTextColor": 219,
    "CheckedOutColor": 228,
    "CheckedOutTextColor": 221,
    "ChipTerminalGLCode": 153,
    "City_Id": 7,
    "CompanyLevelContacts": 236,
    "ConfirmedColor": 225,
    "ConfirmedTextColor": 218,
    "ContactCountryRequired": 254,
    "Country_Id": 183,
    "CreditCardGLCode": 154,
    "CurrenciesId": 46,
    "CurrentlyRunningFinanceCharge": 68,
    "CustomerOnlinePaymentFee": 212,
    "CustomerOnlinePaymentFeeItem": 215,
    "CustomerOnlinePaymentMinimumFee": 214,
    "CustomerOnlinePaymentPercentFee": 213,
    "DataExportEntityId": 233,
    "DefaultAccountLimit": 82,
    "DefaultArrivalTime": 13,
    "DefaultDepartureTime": 14,
    "DefaultTaxRate": 18,
    "DeferralLogic": 239,
    "DepositPercentage": 6,
    "DisableContactMergeOutsideLockDate": 259,
    "DisableFileUpload": 89,
    "DisableFullViewEdits": 255,
    "DisableFutureDatedStandaloneInvoice": 260,
    "DisableNewReservationInvoice": 262,
    "DisableSecurityDepositRefundVoid": 256,
    "DisableVoidRefund": 240,
    "DiscountGLCode": 169,
    "DiscountsAccount": 41,
    "DiscoverClearingAccount": 30,
    "DisplayLastNameFirst": 187,
    "DisregardForReporting": 204,
    "DoNotAutoAllocateOnlinePayments": 171,
    "DueDateDays": 58,
    "DueDateSettingsId": 67,
    "ElectricReadingTriggersMinimum": 85,
    "EmailAddress": 19,
    "EmailSendingDomain": 201,
    "EnableOnReaderTipping": 242,
    "EnableOnReceiptTipping": 241,
    "EnableProgressInvoicing": 202,
    "EnableXero": 34,
    "FallbackSalesAccount_Id": 128,
    "FallbackSalesTaxRate_Id": 129,
    "FinaleActionURLCancel": 141,
    "FinaleFacilityURL": 140,
    "FinaleInventoryActive": 135,
    "FinalePassword": 137,
    "FinalePhysicalInventoryURL": 139,
    "FinaleReportURL": 138,
    "FinaleUserLoginURL": 142,
    "FinaleUsername": 136,
    "FinanceChargeId": 55,
    "FinanceChargeMinimumBalance": 209,
    "FinanceChargeMinimumItem_Id": 210,
    "FinanceCharge_Id": 54,
    "FinanceCharge_MarinaLocation_Id": 56,
    "FiscalYearStart": 170,
    "FlatCCFee": 103,
    "FreshdeskCompanyId": 116,
    "FuelCloudAccessToken": 48,
    "FuelCloudEnabled": 47,
    "FuelCloudRefreshToken": 49,
    "GLCodesRequired": 172,
    "HashID": 52,
    "HiddenDaysCalendar": 84,
    "HideAllResourceOffersInitially": 185,
    "HideBillingSummaryInCheckInSheet": 76,
    "HideBillingSummaryInConfirmation": 77,
    "HideGLTaxOverride": 253,
    "HideReservationDatesOnPrintedMaterials": 176,
    "HideShorePower": 203,
    "IDSAuthorizationToken": 163,
    "IDSEndpoint": 162,
    "Id": 0,
    "IgnoreTaxAmountForTipBasis": 245,
    "InProcessColor": 223,
    "InProcessTextColor": 216,
    "InstallmentsDisabled": 200,
    "InstantPayoutsEnabled": 150,
    "InternalChargesCOGS_Id": 126,
    "InternalChargesRevenue_Id": 127,
    "InternalLaborCOGS_Id": 122,
    "InternalLaborRevenue_Id": 123,
    "InternalPartsCOGS_Id": 124,
    "InternalPartsRevenue_Id": 125,
    "InventoryAdjustmentContact_Id": 65,
    "InventoryCronActive": 64,
    "InvoiceFees": 175,
    "InvoiceWarningDayCount": 20,
    "IsTestMarina": 117,
    "LaborCOSCronActive": 130,
    "LastEditedTime": 257,
    "LastModifiedAspNetUser": 258,
    "LegacyInchesMath": 177,
    "LocationCoordinates": 51,
    "LockDate": 45,
    "MOPStatementsOptional": 57,
    "Map": 16,
    "MarinaHash": 9,
    "MarinaManagement": 205,
    "MarinaStellarInstanceURL": 234,
    "MarinaWalkInCustomerPOSBatchTime": 33,
    "MarinaWebsite": 21,
    "MarineSyncApiKey": 230,
    "MarineSyncBatchEnabled": 231,
    "MarineSyncIntegrationEnabled": 232,
    "MastercardClearingAccount": 29,
    "MaxInstantPayout": 149,
    "MaxOnlineResourceBookingsPerPersonPerDay": 188,
    "MinimumElectricCharge_Id": 87,
    "MinimumWaterCharge_Id": 88,
    "MoloAppPaymentsProvider_Id": 165,
    "MoloContactId": 179,
    "MoloLite": 78,
    "MoloOnlineBookingDisabled": 96,
    "MoloOnlineBookingPaymentsProvider_Id": 167,
    "MoloOnlinePaymentsProvider_Id": 166,
    "Name": 1,
    "NewXeroToken_Id": 189,
    "NotificationEmailAddress": 39,
    "OfferActivityNotificationAddress": 73,
    "OnLeaveColor": 227,
    "OnLeaveTextColor": 220,
    "OnlinePaymentCurrency": 180,
    "OnlinePaymentDefaultEnabled": 38,
    "OnlinePaymentDisabled": 61,
    "OnlinePaymentFeeCap": 173,
    "OnlinePaymentFeeCapMethod": 174,
    "OnlinePaymentXeroTaxRate": 181,
    "OnlinePaymentsasPrepayments": 44,
    "Organization_Id": 8,
    "OverpaymentAccount": 60,
    "OverpaymentGLCode": 160,
    "OverrideTaxCaption": 114,
    "PDFAlwaysOn": 92,
    "PayoutDescriptor": 133,
    "PendingColor": 224,
    "PendingTextColor": 217,
    "PercentCCFee": 102,
    "Policy": 15,
    "PreArrivalEmailCC": 79,
    "PrepaymentAccount": 42,
    "PrepaymentGLCode": 158,
    "PrimaryColor": 145,
    "PrimaryFaxNumber": 3,
    "PrimaryPhoneNumber": 2,
    "PublicAPIBookingNotificationAddress": 74,
    "RVOrCampgroundManagement": 207,
    "ReceiveFailedOfferNotifications": 75,
    "RecordStatus_Id": 100,
    "ReturnsRefundsPolicy": 17,
    "Rules": 4,
    "SV_Labor_Id": 134,
    "SafetyDistanceL": 12,
    "SafetyDistanceW": 11,
    "SalesTaxGLCode": 168,
    "SeasonEnd": 148,
    "SeasonStart": 147,
    "SecondaryColor": 146,
    "SecurityDepositAccount": 50,
    "SecurityDepositGLCode": 159,
    "SendContactIdToXero": 105,
    "SendOnlinePaymentNotifications": 40,
    "SendPartialPaymentsToXero": 37,
    "ServiceManagement": 206,
    "ShowAutoChargeNotice": 143,
    "ShowContactNameOnSpaces": 115,
    "ShowIDForCustomerPrintout": 70,
    "ShowInvoiceDates": 261,
    "ShowMaxDimensions": 109,
    "ShowOverrideTaxRate": 59,
    "ShowPassengerCapacityResourceGrid": 182,
    "ShowPastDepartureCheckedIn": 72,
    "ShowPastDueWarning": 132,
    "ShowPaymentAccount": 112,
    "ShowServiceDinUI": 69,
    "ShowWOCreationDateForCustomer": 90,
    "ShowWebsiteOnPrint": 83,
    "SkipOnlinePaymentFees": 237,
    "SmartThreshold": 244,
    "SnagASlipPartnerAdminAccess": 238,
    "SortContactsByLastName": 186,
    "SpacesTimelineCustom": 107,
    "SpacesTimelineCustomButtonText": 108,
    "StatementDescriptor": 111,
    "StripeActive": 80,
    "StripeApproved": 81,
    "StripeCustomer_Id": 99,
    "StripeGLCode": 155,
    "StripePayoutDelayDays": 184,
    "StripePayoutTime": 101,
    "SubletCOSCronActive": 131,
    "TaxCalculationMethod": 24,
    "TaxCodeRefOverride": 211,
    "TaxExemptRate": 53,
    "TechnicianRoundingMethod": 106,
    "TechnicianRoundingValue": 110,
    "TerminalConfigurationId": 246,
    "TimeZone": 36,
    "Tip1Amount": 192,
    "Tip1AmountWeb": 250,
    "Tip1Percent": 247,
    "Tip1Setting": 196,
    "Tip2Amount": 193,
    "Tip2AmountWeb": 251,
    "Tip2Percent": 248,
    "Tip2Setting": 197,
    "Tip3Amount": 194,
    "Tip3AmountWeb": 252,
    "Tip3Percent": 249,
    "Tip3Setting": 198,
    "Tip4Amount": 195,
    "Tip4Setting": 199,
    "TippingMode": 243,
    "TrackingCodeActive": 178,
    "UnitSystem": 10,
    "UseInchesinCalculations": 43,
    "UseQBOTaxOverride": 235,
    "VariableInvoicing": 208,
    "VesselDimensionsOptions": 22,
    "VesselInsuranceRequired": 113,
    "VisaClearingAccount": 28,
    "WaterReadingTriggersMinimum": 86,
    "WireTransferGLCode": 157,
    "WireTransferPaymentAccount": 71,
    "XeroErrorNotificationEmail": 66,
    "XeroLaborAsset_Id": 119,
    "XeroLaborCOGS_Id": 118,
    "XeroOrganizationShortCode": 25,
    "XeroSubletAsset_Id": 121,
    "XeroSubletCOGS_Id": 120,
    "XeroTenantId": 191
}
    • schema_attributes: 
      {
    "APGLCode": "string",
    "ARGLCode": "string",
    "AddFinanceChargeToOpenInvoice": "string",
    "AllowAcceptTermsWithoutPayment": "string",
    "AllowIDSContactImport": "string",
    "AllowMoloOnlinePayment": "string",
    "AllowOfflineCCPayment": "string",
    "AlwaysPrintTwoCopies": "string",
    "AmericanExpressClearingAccount": "string",
    "ArivalGuide": "string",
    "AutoLockDateSetting": "string",
    "AutoSetLockDate": "string",
    "BankAccountClearingAccount": "string",
    "BankAccountGLCode": "string",
    "BookingBackground": "string",
    "BookingIntroductionTextFirstLine": "string",
    "BookingIntroductionTextSecondLine": "string",
    "BookingLogo": "string",
    "BookingName": "string",
    "CancelledColor": "string",
    "CancelledTextColor": "string",
    "CashClearingAccount": "string",
    "CashGLCode": "string",
    "CheckClearingAccount": "string",
    "CheckGLCode": "string",
    "CheckedInColor": "string",
    "CheckedInTextColor": "string",
    "CheckedOutColor": "string",
    "CheckedOutTextColor": "string",
    "ChipTerminalGLCode": "string",
    "City_Id": "string",
    "CompanyLevelContacts": "string",
    "ConfirmedColor": "string",
    "ConfirmedTextColor": "string",
    "ContactCountryRequired": "string",
    "Country_Id": "string",
    "CreditCardGLCode": "string",
    "CurrenciesId": "string",
    "CurrentlyRunningFinanceCharge": "string",
    "CustomerOnlinePaymentFee": "string",
    "CustomerOnlinePaymentFeeItem": "string",
    "CustomerOnlinePaymentMinimumFee": "string",
    "CustomerOnlinePaymentPercentFee": "string",
    "DataExportEntityId": "string",
    "DefaultAccountLimit": "string",
    "DefaultArrivalTime": "string",
    "DefaultDepartureTime": "string",
    "DefaultTaxRate": "string",
    "DeferralLogic": "string",
    "DepositPercentage": "string",
    "DisableContactMergeOutsideLockDate": "string",
    "DisableFileUpload": "string",
    "DisableFullViewEdits": "string",
    "DisableFutureDatedStandaloneInvoice": "string",
    "DisableNewReservationInvoice": "string",
    "DisableSecurityDepositRefundVoid": "string",
    "DisableVoidRefund": "string",
    "DiscountGLCode": "string",
    "DiscountsAccount": "string",
    "DiscoverClearingAccount": "string",
    "DisplayLastNameFirst": "string",
    "DisregardForReporting": "string",
    "DoNotAutoAllocateOnlinePayments": "string",
    "DueDateDays": "string",
    "DueDateSettingsId": "string",
    "ElectricReadingTriggersMinimum": "string",
    "EmailAddress": "string",
    "EmailSendingDomain": "string",
    "EnableOnReaderTipping": "string",
    "EnableOnReceiptTipping": "string",
    "EnableProgressInvoicing": "string",
    "EnableXero": "string",
    "FallbackSalesAccount_Id": "string",
    "FallbackSalesTaxRate_Id": "string",
    "FinaleActionURLCancel": "string",
    "FinaleFacilityURL": "string",
    "FinaleInventoryActive": "string",
    "FinalePassword": "string",
    "FinalePhysicalInventoryURL": "string",
    "FinaleReportURL": "string",
    "FinaleUserLoginURL": "string",
    "FinaleUsername": "string",
    "FinanceChargeId": "string",
    "FinanceChargeMinimumBalance": "string",
    "FinanceChargeMinimumItem_Id": "string",
    "FinanceCharge_Id": "string",
    "FinanceCharge_MarinaLocation_Id": "string",
    "FiscalYearStart": "string",
    "FlatCCFee": "string",
    "FreshdeskCompanyId": "string",
    "FuelCloudAccessToken": "string",
    "FuelCloudEnabled": "string",
    "FuelCloudRefreshToken": "string",
    "GLCodesRequired": "string",
    "HashID": "string",
    "HiddenDaysCalendar": "string",
    "HideAllResourceOffersInitially": "string",
    "HideBillingSummaryInCheckInSheet": "string",
    "HideBillingSummaryInConfirmation": "string",
    "HideGLTaxOverride": "string",
    "HideReservationDatesOnPrintedMaterials": "string",
    "HideShorePower": "string",
    "IDSAuthorizationToken": "string",
    "IDSEndpoint": "string",
    "Id": "string",
    "IgnoreTaxAmountForTipBasis": "string",
    "InProcessColor": "string",
    "InProcessTextColor": "string",
    "InstallmentsDisabled": "string",
    "InstantPayoutsEnabled": "string",
    "InternalChargesCOGS_Id": "string",
    "InternalChargesRevenue_Id": "string",
    "InternalLaborCOGS_Id": "string",
    "InternalLaborRevenue_Id": "string",
    "InternalPartsCOGS_Id": "string",
    "InternalPartsRevenue_Id": "string",
    "InventoryAdjustmentContact_Id": "string",
    "InventoryCronActive": "string",
    "InvoiceFees": "string",
    "InvoiceWarningDayCount": "string",
    "IsTestMarina": "string",
    "LaborCOSCronActive": "string",
    "LastEditedTime": "string",
    "LastModifiedAspNetUser": "string",
    "LegacyInchesMath": "string",
    "LocationCoordinates": "string",
    "LockDate": "string",
    "MOPStatementsOptional": "string",
    "Map": "string",
    "MarinaHash": "string",
    "MarinaManagement": "string",
    "MarinaStellarInstanceURL": "string",
    "MarinaWalkInCustomerPOSBatchTime": "string",
    "MarinaWebsite": "string",
    "MarineSyncApiKey": "string",
    "MarineSyncBatchEnabled": "string",
    "MarineSyncIntegrationEnabled": "string",
    "MastercardClearingAccount": "string",
    "MaxInstantPayout": "string",
    "MaxOnlineResourceBookingsPerPersonPerDay": "string",
    "MinimumElectricCharge_Id": "string",
    "MinimumWaterCharge_Id": "string",
    "MoloAppPaymentsProvider_Id": "string",
    "MoloContactId": "string",
    "MoloLite": "string",
    "MoloOnlineBookingDisabled": "string",
    "MoloOnlineBookingPaymentsProvider_Id": "string",
    "MoloOnlinePaymentsProvider_Id": "string",
    "Name": "string",
    "NewXeroToken_Id": "string",
    "NotificationEmailAddress": "string",
    "OfferActivityNotificationAddress": "string",
    "OnLeaveColor": "string",
    "OnLeaveTextColor": "string",
    "OnlinePaymentCurrency": "string",
    "OnlinePaymentDefaultEnabled": "string",
    "OnlinePaymentDisabled": "string",
    "OnlinePaymentFeeCap": "string",
    "OnlinePaymentFeeCapMethod": "string",
    "OnlinePaymentXeroTaxRate": "string",
    "OnlinePaymentsasPrepayments": "string",
    "Organization_Id": "string",
    "OverpaymentAccount": "string",
    "OverpaymentGLCode": "string",
    "OverrideTaxCaption": "string",
    "PDFAlwaysOn": "string",
    "PayoutDescriptor": "string",
    "PendingColor": "string",
    "PendingTextColor": "string",
    "PercentCCFee": "string",
    "Policy": "string",
    "PreArrivalEmailCC": "string",
    "PrepaymentAccount": "string",
    "PrepaymentGLCode": "string",
    "PrimaryColor": "string",
    "PrimaryFaxNumber": "string",
    "PrimaryPhoneNumber": "string",
    "PublicAPIBookingNotificationAddress": "string",
    "RVOrCampgroundManagement": "string",
    "ReceiveFailedOfferNotifications": "string",
    "RecordStatus_Id": "string",
    "ReturnsRefundsPolicy": "string",
    "Rules": "string",
    "SV_Labor_Id": "string",
    "SafetyDistanceL": "string",
    "SafetyDistanceW": "string",
    "SalesTaxGLCode": "string",
    "SeasonEnd": "string",
    "SeasonStart": "string",
    "SecondaryColor": "string",
    "SecurityDepositAccount": "string",
    "SecurityDepositGLCode": "string",
    "SendContactIdToXero": "string",
    "SendOnlinePaymentNotifications": "string",
    "SendPartialPaymentsToXero": "string",
    "ServiceManagement": "string",
    "ShowAutoChargeNotice": "string",
    "ShowContactNameOnSpaces": "string",
    "ShowIDForCustomerPrintout": "string",
    "ShowInvoiceDates": "string",
    "ShowMaxDimensions": "string",
    "ShowOverrideTaxRate": "string",
    "ShowPassengerCapacityResourceGrid": "string",
    "ShowPastDepartureCheckedIn": "string",
    "ShowPastDueWarning": "string",
    "ShowPaymentAccount": "string",
    "ShowServiceDinUI": "string",
    "ShowWOCreationDateForCustomer": "string",
    "ShowWebsiteOnPrint": "string",
    "SkipOnlinePaymentFees": "string",
    "SmartThreshold": "string",
    "SnagASlipPartnerAdminAccess": "string",
    "SortContactsByLastName": "string",
    "SpacesTimelineCustom": "string",
    "SpacesTimelineCustomButtonText": "string",
    "StatementDescriptor": "string",
    "StripeActive": "string",
    "StripeApproved": "string",
    "StripeCustomer_Id": "string",
    "StripeGLCode": "string",
    "StripePayoutDelayDays": "string",
    "StripePayoutTime": "string",
    "SubletCOSCronActive": "string",
    "TaxCalculationMethod": "string",
    "TaxCodeRefOverride": "string",
    "TaxExemptRate": "string",
    "TechnicianRoundingMethod": "string",
    "TechnicianRoundingValue": "string",
    "TerminalConfigurationId": "string",
    "TimeZone": "string",
    "Tip1Amount": "string",
    "Tip1AmountWeb": "string",
    "Tip1Percent": "string",
    "Tip1Setting": "string",
    "Tip2Amount": "string",
    "Tip2AmountWeb": "string",
    "Tip2Percent": "string",
    "Tip2Setting": "string",
    "Tip3Amount": "string",
    "Tip3AmountWeb": "string",
    "Tip3Percent": "string",
    "Tip3Setting": "string",
    "Tip4Amount": "string",
    "Tip4Setting": "string",
    "TippingMode": "string",
    "TrackingCodeActive": "string",
    "UnitSystem": "string",
    "UseInchesinCalculations": "string",
    "UseQBOTaxOverride": "string",
    "VariableInvoicing": "string",
    "VesselDimensionsOptions": "string",
    "VesselInsuranceRequired": "string",
    "VisaClearingAccount": "string",
    "WaterReadingTriggersMinimum": "string",
    "WireTransferGLCode": "string",
    "WireTransferPaymentAccount": "string",
    "XeroErrorNotificationEmail": "string",
    "XeroLaborAsset_Id": "string",
    "XeroLaborCOGS_Id": "string",
    "XeroOrganizationShortCode": "string",
    "XeroSubletAsset_Id": "string",
    "XeroSubletCOGS_Id": "string",
    "XeroTenantId": "string"
}
    • schema_name_id: 1925
    • schema_scan_id: 5249354
    • updated: 2023-10-14 01:58:36
Schema Scans: 3
Last at 2023-10-16 01:58:04
    • duration: 0:00:18.368977
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 5253267
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-stage/raw/molo_moloMarinaLocations/2023-10-16/1697439311",
        "key": "raw/molo_moloMarinaLocations/2023-10-16/1697439311/MarinaLocations.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.molo_moloMarinaLocations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5225363321681784374,
        "service_name": "drive-thru",
        "span_id": 334318727661812102,
        "trace_id": 7889086529421669205
    }
}
    • running: False
    • schema_name_id: 1925
    • start_time: 2023-10-16 01:58:04
    • success: True
    • trace_id: 7889086529421669205
    • duration: 0:00:19.606982
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 5251460
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-stage/raw/molo_moloMarinaLocations/2023-10-15/1697352859",
        "key": "raw/molo_moloMarinaLocations/2023-10-15/1697352859/MarinaLocations.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.molo_moloMarinaLocations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16012017619818253525,
        "service_name": "drive-thru",
        "span_id": 6239281905747875849,
        "trace_id": 10769761365061691276
    }
}
    • running: False
    • schema_name_id: 1925
    • start_time: 2023-10-15 01:59:40
    • success: True
    • trace_id: 10769761365061691276
    • duration: 0:00:18.421188
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 5249354
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-stage/raw/molo_moloMarinaLocations/2023-10-14/1697266537",
        "key": "raw/molo_moloMarinaLocations/2023-10-14/1697266537/MarinaLocations.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.molo_moloMarinaLocations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11927869862282054970,
        "service_name": "drive-thru",
        "span_id": 10360306092032965841,
        "trace_id": 9554638751684936589
    }
}
    • running: False
    • schema_name_id: 1925
    • start_time: 2023-10-14 01:58:18
    • success: True
    • trace_id: 9554638751684936589
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "APGLCode": "string",
    "ARGLCode": "string",
    "AddFinanceChargeToOpenInvoice": "string",
    "AllowAcceptTermsWithoutPayment": "string",
    "AllowIDSContactImport": "string",
    "AllowMoloOnlinePayment": "string",
    "AllowOfflineCCPayment": "string",
    "AlwaysPrintTwoCopies": "string",
    "AmericanExpressClearingAccount": "string",
    "ArivalGuide": "string",
    "AutoLockDateSetting": "string",
    "AutoSetLockDate": "string",
    "BankAccountClearingAccount": "string",
    "BankAccountGLCode": "string",
    "BookingBackground": "string",
    "BookingIntroductionTextFirstLine": "string",
    "BookingIntroductionTextSecondLine": "string",
    "BookingLogo": "string",
    "BookingName": "string",
    "CancelledColor": "string",
    "CancelledTextColor": "string",
    "CashClearingAccount": "string",
    "CashGLCode": "string",
    "CheckClearingAccount": "string",
    "CheckGLCode": "string",
    "CheckedInColor": "string",
    "CheckedInTextColor": "string",
    "CheckedOutColor": "string",
    "CheckedOutTextColor": "string",
    "ChipTerminalGLCode": "string",
    "City_Id": "string",
    "CompanyLevelContacts": "string",
    "ConfirmedColor": "string",
    "ConfirmedTextColor": "string",
    "ContactCountryRequired": "string",
    "Country_Id": "string",
    "CreditCardGLCode": "string",
    "CurrenciesId": "string",
    "CurrentlyRunningFinanceCharge": "string",
    "CustomerOnlinePaymentFee": "string",
    "CustomerOnlinePaymentFeeItem": "string",
    "CustomerOnlinePaymentMinimumFee": "string",
    "CustomerOnlinePaymentPercentFee": "string",
    "DataExportEntityId": "string",
    "DefaultAccountLimit": "string",
    "DefaultArrivalTime": "string",
    "DefaultDepartureTime": "string",
    "DefaultTaxRate": "string",
    "DeferralLogic": "string",
    "DepositPercentage": "string",
    "DisableContactMergeOutsideLockDate": "string",
    "DisableFileUpload": "string",
    "DisableFullViewEdits": "string",
    "DisableFutureDatedStandaloneInvoice": "string",
    "DisableNewReservationInvoice": "string",
    "DisableSecurityDepositRefundVoid": "string",
    "DisableVoidRefund": "string",
    "DiscountGLCode": "string",
    "DiscountsAccount": "string",
    "DiscoverClearingAccount": "string",
    "DisplayLastNameFirst": "string",
    "DisregardForReporting": "string",
    "DoNotAutoAllocateOnlinePayments": "string",
    "DueDateDays": "string",
    "DueDateSettingsId": "string",
    "ElectricReadingTriggersMinimum": "string",
    "EmailAddress": "string",
    "EmailSendingDomain": "string",
    "EnableOnReaderTipping": "string",
    "EnableOnReceiptTipping": "string",
    "EnableProgressInvoicing": "string",
    "EnableXero": "string",
    "FallbackSalesAccount_Id": "string",
    "FallbackSalesTaxRate_Id": "string",
    "FinaleActionURLCancel": "string",
    "FinaleFacilityURL": "string",
    "FinaleInventoryActive": "string",
    "FinalePassword": "string",
    "FinalePhysicalInventoryURL": "string",
    "FinaleReportURL": "string",
    "FinaleUserLoginURL": "string",
    "FinaleUsername": "string",
    "FinanceChargeId": "string",
    "FinanceChargeMinimumBalance": "string",
    "FinanceChargeMinimumItem_Id": "string",
    "FinanceCharge_Id": "string",
    "FinanceCharge_MarinaLocation_Id": "string",
    "FiscalYearStart": "string",
    "FlatCCFee": "string",
    "FreshdeskCompanyId": "string",
    "FuelCloudAccessToken": "string",
    "FuelCloudEnabled": "string",
    "FuelCloudRefreshToken": "string",
    "GLCodesRequired": "string",
    "HashID": "string",
    "HiddenDaysCalendar": "string",
    "HideAllResourceOffersInitially": "string",
    "HideBillingSummaryInCheckInSheet": "string",
    "HideBillingSummaryInConfirmation": "string",
    "HideGLTaxOverride": "string",
    "HideReservationDatesOnPrintedMaterials": "string",
    "HideShorePower": "string",
    "IDSAuthorizationToken": "string",
    "IDSEndpoint": "string",
    "Id": "string",
    "IgnoreTaxAmountForTipBasis": "string",
    "InProcessColor": "string",
    "InProcessTextColor": "string",
    "InstallmentsDisabled": "string",
    "InstantPayoutsEnabled": "string",
    "InternalChargesCOGS_Id": "string",
    "InternalChargesRevenue_Id": "string",
    "InternalLaborCOGS_Id": "string",
    "InternalLaborRevenue_Id": "string",
    "InternalPartsCOGS_Id": "string",
    "InternalPartsRevenue_Id": "string",
    "InventoryAdjustmentContact_Id": "string",
    "InventoryCronActive": "string",
    "InvoiceFees": "string",
    "InvoiceWarningDayCount": "string",
    "IsTestMarina": "string",
    "LaborCOSCronActive": "string",
    "LastEditedTime": "string",
    "LastModifiedAspNetUser": "string",
    "LegacyInchesMath": "string",
    "LocationCoordinates": "string",
    "LockDate": "string",
    "MOPStatementsOptional": "string",
    "Map": "string",
    "MarinaHash": "string",
    "MarinaManagement": "string",
    "MarinaStellarInstanceURL": "string",
    "MarinaWalkInCustomerPOSBatchTime": "string",
    "MarinaWebsite": "string",
    "MarineSyncApiKey": "string",
    "MarineSyncBatchEnabled": "string",
    "MarineSyncIntegrationEnabled": "string",
    "MastercardClearingAccount": "string",
    "MaxInstantPayout": "string",
    "MaxOnlineResourceBookingsPerPersonPerDay": "string",
    "MinimumElectricCharge_Id": "string",
    "MinimumWaterCharge_Id": "string",
    "MoloAppPaymentsProvider_Id": "string",
    "MoloContactId": "string",
    "MoloLite": "string",
    "MoloOnlineBookingDisabled": "string",
    "MoloOnlineBookingPaymentsProvider_Id": "string",
    "MoloOnlinePaymentsProvider_Id": "string",
    "Name": "string",
    "NewXeroToken_Id": "string",
    "NotificationEmailAddress": "string",
    "OfferActivityNotificationAddress": "string",
    "OnLeaveColor": "string",
    "OnLeaveTextColor": "string",
    "OnlinePaymentCurrency": "string",
    "OnlinePaymentDefaultEnabled": "string",
    "OnlinePaymentDisabled": "string",
    "OnlinePaymentFeeCap": "string",
    "OnlinePaymentFeeCapMethod": "string",
    "OnlinePaymentXeroTaxRate": "string",
    "OnlinePaymentsasPrepayments": "string",
    "Organization_Id": "string",
    "OverpaymentAccount": "string",
    "OverpaymentGLCode": "string",
    "OverrideTaxCaption": "string",
    "PDFAlwaysOn": "string",
    "PayoutDescriptor": "string",
    "PendingColor": "string",
    "PendingTextColor": "string",
    "PercentCCFee": "string",
    "Policy": "string",
    "PreArrivalEmailCC": "string",
    "PrepaymentAccount": "string",
    "PrepaymentGLCode": "string",
    "PrimaryColor": "string",
    "PrimaryFaxNumber": "string",
    "PrimaryPhoneNumber": "string",
    "PublicAPIBookingNotificationAddress": "string",
    "RVOrCampgroundManagement": "string",
    "ReceiveFailedOfferNotifications": "string",
    "RecordStatus_Id": "string",
    "ReturnsRefundsPolicy": "string",
    "Rules": "string",
    "SV_Labor_Id": "string",
    "SafetyDistanceL": "string",
    "SafetyDistanceW": "string",
    "SalesTaxGLCode": "string",
    "SeasonEnd": "string",
    "SeasonStart": "string",
    "SecondaryColor": "string",
    "SecurityDepositAccount": "string",
    "SecurityDepositGLCode": "string",
    "SendContactIdToXero": "string",
    "SendOnlinePaymentNotifications": "string",
    "SendPartialPaymentsToXero": "string",
    "ServiceManagement": "string",
    "ShowAutoChargeNotice": "string",
    "ShowContactNameOnSpaces": "string",
    "ShowIDForCustomerPrintout": "string",
    "ShowInvoiceDates": "string",
    "ShowMaxDimensions": "string",
    "ShowOverrideTaxRate": "string",
    "ShowPassengerCapacityResourceGrid": "string",
    "ShowPastDepartureCheckedIn": "string",
    "ShowPastDueWarning": "string",
    "ShowPaymentAccount": "string",
    "ShowServiceDinUI": "string",
    "ShowWOCreationDateForCustomer": "string",
    "ShowWebsiteOnPrint": "string",
    "SkipOnlinePaymentFees": "string",
    "SmartThreshold": "string",
    "SnagASlipPartnerAdminAccess": "string",
    "SortContactsByLastName": "string",
    "SpacesTimelineCustom": "string",
    "SpacesTimelineCustomButtonText": "string",
    "StatementDescriptor": "string",
    "StripeActive": "string",
    "StripeApproved": "string",
    "StripeCustomer_Id": "string",
    "StripeGLCode": "string",
    "StripePayoutDelayDays": "string",
    "StripePayoutTime": "string",
    "SubletCOSCronActive": "string",
    "TaxCalculationMethod": "string",
    "TaxCodeRefOverride": "string",
    "TaxExemptRate": "string",
    "TechnicianRoundingMethod": "string",
    "TechnicianRoundingValue": "string",
    "TerminalConfigurationId": "string",
    "TimeZone": "string",
    "Tip1Amount": "string",
    "Tip1AmountWeb": "string",
    "Tip1Percent": "string",
    "Tip1Setting": "string",
    "Tip2Amount": "string",
    "Tip2AmountWeb": "string",
    "Tip2Percent": "string",
    "Tip2Setting": "string",
    "Tip3Amount": "string",
    "Tip3AmountWeb": "string",
    "Tip3Percent": "string",
    "Tip3Setting": "string",
    "Tip4Amount": "string",
    "Tip4Setting": "string",
    "TippingMode": "string",
    "TrackingCodeActive": "string",
    "UnitSystem": "string",
    "UseInchesinCalculations": "string",
    "UseQBOTaxOverride": "string",
    "VariableInvoicing": "string",
    "VesselDimensionsOptions": "string",
    "VesselInsuranceRequired": "string",
    "VisaClearingAccount": "string",
    "WaterReadingTriggersMinimum": "string",
    "WireTransferGLCode": "string",
    "WireTransferPaymentAccount": "string",
    "XeroErrorNotificationEmail": "string",
    "XeroLaborAsset_Id": "string",
    "XeroLaborCOGS_Id": "string",
    "XeroOrganizationShortCode": "string",
    "XeroSubletAsset_Id": "string",
    "XeroSubletCOGS_Id": "string",
    "XeroTenantId": "string"
}
  • created: 2023-10-16 01:58:11
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.molo_molomarinalocations`\n(\n `Id`  string , `Name`  string , `PrimaryPhoneNumber`  string , `PrimaryFaxNumber`  string , `Rules`  string , `ArivalGuide`  string , `DepositPercentage`  string , `City_Id`  string , `Organization_Id`  string , `MarinaHash`  string , `UnitSystem`  string , `SafetyDistanceW`  string , `SafetyDistanceL`  string , `DefaultArrivalTime`  string , `DefaultDepartureTime`  string , `Policy`  string , `Map`  string , `ReturnsRefundsPolicy`  string , `DefaultTaxRate`  string , `EmailAddress`  string , `InvoiceWarningDayCount`  string , `MarinaWebsite`  string , `VesselDimensionsOptions`  string , `AllowMoloOnlinePayment`  string , `TaxCalculationMethod`  string , `XeroOrganizationShortCode`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `DiscoverClearingAccount`  string , `AmericanExpressClearingAccount`  string , `BankAccountClearingAccount`  string , `MarinaWalkInCustomerPOSBatchTime`  string , `EnableXero`  string , `AllowOfflineCCPayment`  string , `TimeZone`  string , `SendPartialPaymentsToXero`  string , `OnlinePaymentDefaultEnabled`  string , `NotificationEmailAddress`  string , `SendOnlinePaymentNotifications`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `UseInchesinCalculations`  string , `OnlinePaymentsasPrepayments`  string , `LockDate`  string , `CurrenciesId`  string , `FuelCloudEnabled`  string , `FuelCloudAccessToken`  string , `FuelCloudRefreshToken`  string , `SecurityDepositAccount`  string , `LocationCoordinates`  string , `HashID`  string , `TaxExemptRate`  string , `FinanceCharge_Id`  string , `FinanceChargeId`  string , `FinanceCharge_MarinaLocation_Id`  string , `MOPStatementsOptional`  string , `DueDateDays`  string , `ShowOverrideTaxRate`  string , `OverpaymentAccount`  string , `OnlinePaymentDisabled`  string , `AutoSetLockDate`  string , `AutoLockDateSetting`  string , `InventoryCronActive`  string , `InventoryAdjustmentContact_Id`  string , `XeroErrorNotificationEmail`  string , `DueDateSettingsId`  string , `CurrentlyRunningFinanceCharge`  string , `ShowServiceDinUI`  string , `ShowIDForCustomerPrintout`  string , `WireTransferPaymentAccount`  string , `ShowPastDepartureCheckedIn`  string , `OfferActivityNotificationAddress`  string , `PublicAPIBookingNotificationAddress`  string , `ReceiveFailedOfferNotifications`  string , `HideBillingSummaryInCheckInSheet`  string , `HideBillingSummaryInConfirmation`  string , `MoloLite`  string , `PreArrivalEmailCC`  string , `StripeActive`  string , `StripeApproved`  string , `DefaultAccountLimit`  string , `ShowWebsiteOnPrint`  string , `HiddenDaysCalendar`  string , `ElectricReadingTriggersMinimum`  string , `WaterReadingTriggersMinimum`  string , `MinimumElectricCharge_Id`  string , `MinimumWaterCharge_Id`  string , `DisableFileUpload`  string , `ShowWOCreationDateForCustomer`  string , `AddFinanceChargeToOpenInvoice`  string , `PDFAlwaysOn`  string , `BookingName`  string , `BookingLogo`  string , `BookingBackground`  string , `MoloOnlineBookingDisabled`  string , `BookingIntroductionTextFirstLine`  string , `BookingIntroductionTextSecondLine`  string , `StripeCustomer_Id`  string , `RecordStatus_Id`  string , `StripePayoutTime`  string , `PercentCCFee`  string , `FlatCCFee`  string , `AlwaysPrintTwoCopies`  string , `SendContactIdToXero`  string , `TechnicianRoundingMethod`  string , `SpacesTimelineCustom`  string , `SpacesTimelineCustomButtonText`  string , `ShowMaxDimensions`  string , `TechnicianRoundingValue`  string , `StatementDescriptor`  string , `ShowPaymentAccount`  string , `VesselInsuranceRequired`  string , `OverrideTaxCaption`  string , `ShowContactNameOnSpaces`  string , `FreshdeskCompanyId`  string , `IsTestMarina`  string , `XeroLaborCOGS_Id`  string , `XeroLaborAsset_Id`  string , `XeroSubletCOGS_Id`  string , `XeroSubletAsset_Id`  string , `InternalLaborCOGS_Id`  string , `InternalLaborRevenue_Id`  string , `InternalPartsCOGS_Id`  string , `InternalPartsRevenue_Id`  string , `InternalChargesCOGS_Id`  string , `InternalChargesRevenue_Id`  string , `FallbackSalesAccount_Id`  string , `FallbackSalesTaxRate_Id`  string , `LaborCOSCronActive`  string , `SubletCOSCronActive`  string , `ShowPastDueWarning`  string , `PayoutDescriptor`  string , `SV_Labor_Id`  string , `FinaleInventoryActive`  string , `FinaleUsername`  string , `FinalePassword`  string , `FinaleReportURL`  string , `FinalePhysicalInventoryURL`  string , `FinaleFacilityURL`  string , `FinaleActionURLCancel`  string , `FinaleUserLoginURL`  string , `ShowAutoChargeNotice`  string , `AllowAcceptTermsWithoutPayment`  string , `PrimaryColor`  string , `SecondaryColor`  string , `SeasonStart`  string , `SeasonEnd`  string , `MaxInstantPayout`  string , `InstantPayoutsEnabled`  string , `CashGLCode`  string , `CheckGLCode`  string , `ChipTerminalGLCode`  string , `CreditCardGLCode`  string , `StripeGLCode`  string , `BankAccountGLCode`  string , `WireTransferGLCode`  string , `PrepaymentGLCode`  string , `SecurityDepositGLCode`  string , `OverpaymentGLCode`  string , `ARGLCode`  string , `IDSEndpoint`  string , `IDSAuthorizationToken`  string , `AllowIDSContactImport`  string , `MoloAppPaymentsProvider_Id`  string , `MoloOnlinePaymentsProvider_Id`  string , `MoloOnlineBookingPaymentsProvider_Id`  string , `SalesTaxGLCode`  string , `DiscountGLCode`  string , `FiscalYearStart`  string , `DoNotAutoAllocateOnlinePayments`  string , `GLCodesRequired`  string , `OnlinePaymentFeeCap`  string , `OnlinePaymentFeeCapMethod`  string , `InvoiceFees`  string , `HideReservationDatesOnPrintedMaterials`  string , `LegacyInchesMath`  string , `TrackingCodeActive`  string , `MoloContactId`  string , `OnlinePaymentCurrency`  string , `OnlinePaymentXeroTaxRate`  string , `ShowPassengerCapacityResourceGrid`  string , `Country_Id`  string , `StripePayoutDelayDays`  string , `HideAllResourceOffersInitially`  string , `SortContactsByLastName`  string , `DisplayLastNameFirst`  string , `MaxOnlineResourceBookingsPerPersonPerDay`  string , `NewXeroToken_Id`  string , `APGLCode`  string , `XeroTenantId`  string , `Tip1Amount`  string , `Tip2Amount`  string , `Tip3Amount`  string , `Tip4Amount`  string , `Tip1Setting`  string , `Tip2Setting`  string , `Tip3Setting`  string , `Tip4Setting`  string , `InstallmentsDisabled`  string , `EmailSendingDomain`  string , `EnableProgressInvoicing`  string , `HideShorePower`  string , `DisregardForReporting`  string , `MarinaManagement`  string , `ServiceManagement`  string , `RVOrCampgroundManagement`  string , `VariableInvoicing`  string , `FinanceChargeMinimumBalance`  string , `FinanceChargeMinimumItem_Id`  string , `TaxCodeRefOverride`  string , `CustomerOnlinePaymentFee`  string , `CustomerOnlinePaymentPercentFee`  string , `CustomerOnlinePaymentMinimumFee`  string , `CustomerOnlinePaymentFeeItem`  string , `InProcessTextColor`  string , `PendingTextColor`  string , `ConfirmedTextColor`  string , `CheckedInTextColor`  string , `OnLeaveTextColor`  string , `CheckedOutTextColor`  string , `CancelledTextColor`  string , `InProcessColor`  string , `PendingColor`  string , `ConfirmedColor`  string , `CheckedInColor`  string , `OnLeaveColor`  string , `CheckedOutColor`  string , `CancelledColor`  string , `MarineSyncApiKey`  string , `MarineSyncBatchEnabled`  string , `MarineSyncIntegrationEnabled`  string , `DataExportEntityId`  string , `MarinaStellarInstanceURL`  string , `UseQBOTaxOverride`  string , `CompanyLevelContacts`  string , `SkipOnlinePaymentFees`  string , `SnagASlipPartnerAdminAccess`  string , `DeferralLogic`  string , `DisableVoidRefund`  string , `EnableOnReceiptTipping`  string , `EnableOnReaderTipping`  string , `TippingMode`  string , `SmartThreshold`  string , `IgnoreTaxAmountForTipBasis`  string , `TerminalConfigurationId`  string , `Tip1Percent`  string , `Tip2Percent`  string , `Tip3Percent`  string , `Tip1AmountWeb`  string , `Tip2AmountWeb`  string , `Tip3AmountWeb`  string , `HideGLTaxOverride`  string , `ContactCountryRequired`  string , `DisableFullViewEdits`  string , `DisableSecurityDepositRefundVoid`  string , `LastEditedTime`  string , `LastModifiedAspNetUser`  string , `DisableContactMergeOutsideLockDate`  string , `DisableFutureDatedStandaloneInvoice`  string , `ShowInvoiceDates`  string , `DisableNewReservationInvoice`  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-stage/raw/molo_moloMarinaLocations/2023-10-16/1697439311'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.molo_molomarinalocations`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.molo_molomarinalocations"
}
Server:
  • hostname: schemamanager-5c55c886bf-h2ts4
  • name: schema_manager
  • process_start: 2025-10-21 13:03:27
  • sf_env: stage
  • version: 2112174301
Raw: 
{
    "name": {
        "created": "2023-08-10 13:57:33",
        "disabled": false,
        "format": "raw",
        "id": 1925,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_drivethru",
            "table": "molo_molomarinalocations"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "APGLCode": "string",
            "ARGLCode": "string",
            "AddFinanceChargeToOpenInvoice": "string",
            "AllowAcceptTermsWithoutPayment": "string",
            "AllowIDSContactImport": "string",
            "AllowMoloOnlinePayment": "string",
            "AllowOfflineCCPayment": "string",
            "AlwaysPrintTwoCopies": "string",
            "AmericanExpressClearingAccount": "string",
            "ArivalGuide": "string",
            "AutoLockDateSetting": "string",
            "AutoSetLockDate": "string",
            "BankAccountClearingAccount": "string",
            "BankAccountGLCode": "string",
            "BookingBackground": "string",
            "BookingIntroductionTextFirstLine": "string",
            "BookingIntroductionTextSecondLine": "string",
            "BookingLogo": "string",
            "BookingName": "string",
            "CancelledColor": "string",
            "CancelledTextColor": "string",
            "CashClearingAccount": "string",
            "CashGLCode": "string",
            "CheckClearingAccount": "string",
            "CheckGLCode": "string",
            "CheckedInColor": "string",
            "CheckedInTextColor": "string",
            "CheckedOutColor": "string",
            "CheckedOutTextColor": "string",
            "ChipTerminalGLCode": "string",
            "City_Id": "string",
            "CompanyLevelContacts": "string",
            "ConfirmedColor": "string",
            "ConfirmedTextColor": "string",
            "ContactCountryRequired": "string",
            "Country_Id": "string",
            "CreditCardGLCode": "string",
            "CurrenciesId": "string",
            "CurrentlyRunningFinanceCharge": "string",
            "CustomerOnlinePaymentFee": "string",
            "CustomerOnlinePaymentFeeItem": "string",
            "CustomerOnlinePaymentMinimumFee": "string",
            "CustomerOnlinePaymentPercentFee": "string",
            "DataExportEntityId": "string",
            "DefaultAccountLimit": "string",
            "DefaultArrivalTime": "string",
            "DefaultDepartureTime": "string",
            "DefaultTaxRate": "string",
            "DeferralLogic": "string",
            "DepositPercentage": "string",
            "DisableContactMergeOutsideLockDate": "string",
            "DisableFileUpload": "string",
            "DisableFullViewEdits": "string",
            "DisableFutureDatedStandaloneInvoice": "string",
            "DisableNewReservationInvoice": "string",
            "DisableSecurityDepositRefundVoid": "string",
            "DisableVoidRefund": "string",
            "DiscountGLCode": "string",
            "DiscountsAccount": "string",
            "DiscoverClearingAccount": "string",
            "DisplayLastNameFirst": "string",
            "DisregardForReporting": "string",
            "DoNotAutoAllocateOnlinePayments": "string",
            "DueDateDays": "string",
            "DueDateSettingsId": "string",
            "ElectricReadingTriggersMinimum": "string",
            "EmailAddress": "string",
            "EmailSendingDomain": "string",
            "EnableOnReaderTipping": "string",
            "EnableOnReceiptTipping": "string",
            "EnableProgressInvoicing": "string",
            "EnableXero": "string",
            "FallbackSalesAccount_Id": "string",
            "FallbackSalesTaxRate_Id": "string",
            "FinaleActionURLCancel": "string",
            "FinaleFacilityURL": "string",
            "FinaleInventoryActive": "string",
            "FinalePassword": "string",
            "FinalePhysicalInventoryURL": "string",
            "FinaleReportURL": "string",
            "FinaleUserLoginURL": "string",
            "FinaleUsername": "string",
            "FinanceChargeId": "string",
            "FinanceChargeMinimumBalance": "string",
            "FinanceChargeMinimumItem_Id": "string",
            "FinanceCharge_Id": "string",
            "FinanceCharge_MarinaLocation_Id": "string",
            "FiscalYearStart": "string",
            "FlatCCFee": "string",
            "FreshdeskCompanyId": "string",
            "FuelCloudAccessToken": "string",
            "FuelCloudEnabled": "string",
            "FuelCloudRefreshToken": "string",
            "GLCodesRequired": "string",
            "HashID": "string",
            "HiddenDaysCalendar": "string",
            "HideAllResourceOffersInitially": "string",
            "HideBillingSummaryInCheckInSheet": "string",
            "HideBillingSummaryInConfirmation": "string",
            "HideGLTaxOverride": "string",
            "HideReservationDatesOnPrintedMaterials": "string",
            "HideShorePower": "string",
            "IDSAuthorizationToken": "string",
            "IDSEndpoint": "string",
            "Id": "string",
            "IgnoreTaxAmountForTipBasis": "string",
            "InProcessColor": "string",
            "InProcessTextColor": "string",
            "InstallmentsDisabled": "string",
            "InstantPayoutsEnabled": "string",
            "InternalChargesCOGS_Id": "string",
            "InternalChargesRevenue_Id": "string",
            "InternalLaborCOGS_Id": "string",
            "InternalLaborRevenue_Id": "string",
            "InternalPartsCOGS_Id": "string",
            "InternalPartsRevenue_Id": "string",
            "InventoryAdjustmentContact_Id": "string",
            "InventoryCronActive": "string",
            "InvoiceFees": "string",
            "InvoiceWarningDayCount": "string",
            "IsTestMarina": "string",
            "LaborCOSCronActive": "string",
            "LastEditedTime": "string",
            "LastModifiedAspNetUser": "string",
            "LegacyInchesMath": "string",
            "LocationCoordinates": "string",
            "LockDate": "string",
            "MOPStatementsOptional": "string",
            "Map": "string",
            "MarinaHash": "string",
            "MarinaManagement": "string",
            "MarinaStellarInstanceURL": "string",
            "MarinaWalkInCustomerPOSBatchTime": "string",
            "MarinaWebsite": "string",
            "MarineSyncApiKey": "string",
            "MarineSyncBatchEnabled": "string",
            "MarineSyncIntegrationEnabled": "string",
            "MastercardClearingAccount": "string",
            "MaxInstantPayout": "string",
            "MaxOnlineResourceBookingsPerPersonPerDay": "string",
            "MinimumElectricCharge_Id": "string",
            "MinimumWaterCharge_Id": "string",
            "MoloAppPaymentsProvider_Id": "string",
            "MoloContactId": "string",
            "MoloLite": "string",
            "MoloOnlineBookingDisabled": "string",
            "MoloOnlineBookingPaymentsProvider_Id": "string",
            "MoloOnlinePaymentsProvider_Id": "string",
            "Name": "string",
            "NewXeroToken_Id": "string",
            "NotificationEmailAddress": "string",
            "OfferActivityNotificationAddress": "string",
            "OnLeaveColor": "string",
            "OnLeaveTextColor": "string",
            "OnlinePaymentCurrency": "string",
            "OnlinePaymentDefaultEnabled": "string",
            "OnlinePaymentDisabled": "string",
            "OnlinePaymentFeeCap": "string",
            "OnlinePaymentFeeCapMethod": "string",
            "OnlinePaymentXeroTaxRate": "string",
            "OnlinePaymentsasPrepayments": "string",
            "Organization_Id": "string",
            "OverpaymentAccount": "string",
            "OverpaymentGLCode": "string",
            "OverrideTaxCaption": "string",
            "PDFAlwaysOn": "string",
            "PayoutDescriptor": "string",
            "PendingColor": "string",
            "PendingTextColor": "string",
            "PercentCCFee": "string",
            "Policy": "string",
            "PreArrivalEmailCC": "string",
            "PrepaymentAccount": "string",
            "PrepaymentGLCode": "string",
            "PrimaryColor": "string",
            "PrimaryFaxNumber": "string",
            "PrimaryPhoneNumber": "string",
            "PublicAPIBookingNotificationAddress": "string",
            "RVOrCampgroundManagement": "string",
            "ReceiveFailedOfferNotifications": "string",
            "RecordStatus_Id": "string",
            "ReturnsRefundsPolicy": "string",
            "Rules": "string",
            "SV_Labor_Id": "string",
            "SafetyDistanceL": "string",
            "SafetyDistanceW": "string",
            "SalesTaxGLCode": "string",
            "SeasonEnd": "string",
            "SeasonStart": "string",
            "SecondaryColor": "string",
            "SecurityDepositAccount": "string",
            "SecurityDepositGLCode": "string",
            "SendContactIdToXero": "string",
            "SendOnlinePaymentNotifications": "string",
            "SendPartialPaymentsToXero": "string",
            "ServiceManagement": "string",
            "ShowAutoChargeNotice": "string",
            "ShowContactNameOnSpaces": "string",
            "ShowIDForCustomerPrintout": "string",
            "ShowInvoiceDates": "string",
            "ShowMaxDimensions": "string",
            "ShowOverrideTaxRate": "string",
            "ShowPassengerCapacityResourceGrid": "string",
            "ShowPastDepartureCheckedIn": "string",
            "ShowPastDueWarning": "string",
            "ShowPaymentAccount": "string",
            "ShowServiceDinUI": "string",
            "ShowWOCreationDateForCustomer": "string",
            "ShowWebsiteOnPrint": "string",
            "SkipOnlinePaymentFees": "string",
            "SmartThreshold": "string",
            "SnagASlipPartnerAdminAccess": "string",
            "SortContactsByLastName": "string",
            "SpacesTimelineCustom": "string",
            "SpacesTimelineCustomButtonText": "string",
            "StatementDescriptor": "string",
            "StripeActive": "string",
            "StripeApproved": "string",
            "StripeCustomer_Id": "string",
            "StripeGLCode": "string",
            "StripePayoutDelayDays": "string",
            "StripePayoutTime": "string",
            "SubletCOSCronActive": "string",
            "TaxCalculationMethod": "string",
            "TaxCodeRefOverride": "string",
            "TaxExemptRate": "string",
            "TechnicianRoundingMethod": "string",
            "TechnicianRoundingValue": "string",
            "TerminalConfigurationId": "string",
            "TimeZone": "string",
            "Tip1Amount": "string",
            "Tip1AmountWeb": "string",
            "Tip1Percent": "string",
            "Tip1Setting": "string",
            "Tip2Amount": "string",
            "Tip2AmountWeb": "string",
            "Tip2Percent": "string",
            "Tip2Setting": "string",
            "Tip3Amount": "string",
            "Tip3AmountWeb": "string",
            "Tip3Percent": "string",
            "Tip3Setting": "string",
            "Tip4Amount": "string",
            "Tip4Setting": "string",
            "TippingMode": "string",
            "TrackingCodeActive": "string",
            "UnitSystem": "string",
            "UseInchesinCalculations": "string",
            "UseQBOTaxOverride": "string",
            "VariableInvoicing": "string",
            "VesselDimensionsOptions": "string",
            "VesselInsuranceRequired": "string",
            "VisaClearingAccount": "string",
            "WaterReadingTriggersMinimum": "string",
            "WireTransferGLCode": "string",
            "WireTransferPaymentAccount": "string",
            "XeroErrorNotificationEmail": "string",
            "XeroLaborAsset_Id": "string",
            "XeroLaborCOGS_Id": "string",
            "XeroOrganizationShortCode": "string",
            "XeroSubletAsset_Id": "string",
            "XeroSubletCOGS_Id": "string",
            "XeroTenantId": "string"
        },
        "created": "2023-10-16 01:58:11",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.molo_molomarinalocations`\n(\n `Id`  string , `Name`  string , `PrimaryPhoneNumber`  string , `PrimaryFaxNumber`  string , `Rules`  string , `ArivalGuide`  string , `DepositPercentage`  string , `City_Id`  string , `Organization_Id`  string , `MarinaHash`  string , `UnitSystem`  string , `SafetyDistanceW`  string , `SafetyDistanceL`  string , `DefaultArrivalTime`  string , `DefaultDepartureTime`  string , `Policy`  string , `Map`  string , `ReturnsRefundsPolicy`  string , `DefaultTaxRate`  string , `EmailAddress`  string , `InvoiceWarningDayCount`  string , `MarinaWebsite`  string , `VesselDimensionsOptions`  string , `AllowMoloOnlinePayment`  string , `TaxCalculationMethod`  string , `XeroOrganizationShortCode`  string , `CashClearingAccount`  string , `CheckClearingAccount`  string , `VisaClearingAccount`  string , `MastercardClearingAccount`  string , `DiscoverClearingAccount`  string , `AmericanExpressClearingAccount`  string , `BankAccountClearingAccount`  string , `MarinaWalkInCustomerPOSBatchTime`  string , `EnableXero`  string , `AllowOfflineCCPayment`  string , `TimeZone`  string , `SendPartialPaymentsToXero`  string , `OnlinePaymentDefaultEnabled`  string , `NotificationEmailAddress`  string , `SendOnlinePaymentNotifications`  string , `DiscountsAccount`  string , `PrepaymentAccount`  string , `UseInchesinCalculations`  string , `OnlinePaymentsasPrepayments`  string , `LockDate`  string , `CurrenciesId`  string , `FuelCloudEnabled`  string , `FuelCloudAccessToken`  string , `FuelCloudRefreshToken`  string , `SecurityDepositAccount`  string , `LocationCoordinates`  string , `HashID`  string , `TaxExemptRate`  string , `FinanceCharge_Id`  string , `FinanceChargeId`  string , `FinanceCharge_MarinaLocation_Id`  string , `MOPStatementsOptional`  string , `DueDateDays`  string , `ShowOverrideTaxRate`  string , `OverpaymentAccount`  string , `OnlinePaymentDisabled`  string , `AutoSetLockDate`  string , `AutoLockDateSetting`  string , `InventoryCronActive`  string , `InventoryAdjustmentContact_Id`  string , `XeroErrorNotificationEmail`  string , `DueDateSettingsId`  string , `CurrentlyRunningFinanceCharge`  string , `ShowServiceDinUI`  string , `ShowIDForCustomerPrintout`  string , `WireTransferPaymentAccount`  string , `ShowPastDepartureCheckedIn`  string , `OfferActivityNotificationAddress`  string , `PublicAPIBookingNotificationAddress`  string , `ReceiveFailedOfferNotifications`  string , `HideBillingSummaryInCheckInSheet`  string , `HideBillingSummaryInConfirmation`  string , `MoloLite`  string , `PreArrivalEmailCC`  string , `StripeActive`  string , `StripeApproved`  string , `DefaultAccountLimit`  string , `ShowWebsiteOnPrint`  string , `HiddenDaysCalendar`  string , `ElectricReadingTriggersMinimum`  string , `WaterReadingTriggersMinimum`  string , `MinimumElectricCharge_Id`  string , `MinimumWaterCharge_Id`  string , `DisableFileUpload`  string , `ShowWOCreationDateForCustomer`  string , `AddFinanceChargeToOpenInvoice`  string , `PDFAlwaysOn`  string , `BookingName`  string , `BookingLogo`  string , `BookingBackground`  string , `MoloOnlineBookingDisabled`  string , `BookingIntroductionTextFirstLine`  string , `BookingIntroductionTextSecondLine`  string , `StripeCustomer_Id`  string , `RecordStatus_Id`  string , `StripePayoutTime`  string , `PercentCCFee`  string , `FlatCCFee`  string , `AlwaysPrintTwoCopies`  string , `SendContactIdToXero`  string , `TechnicianRoundingMethod`  string , `SpacesTimelineCustom`  string , `SpacesTimelineCustomButtonText`  string , `ShowMaxDimensions`  string , `TechnicianRoundingValue`  string , `StatementDescriptor`  string , `ShowPaymentAccount`  string , `VesselInsuranceRequired`  string , `OverrideTaxCaption`  string , `ShowContactNameOnSpaces`  string , `FreshdeskCompanyId`  string , `IsTestMarina`  string , `XeroLaborCOGS_Id`  string , `XeroLaborAsset_Id`  string , `XeroSubletCOGS_Id`  string , `XeroSubletAsset_Id`  string , `InternalLaborCOGS_Id`  string , `InternalLaborRevenue_Id`  string , `InternalPartsCOGS_Id`  string , `InternalPartsRevenue_Id`  string , `InternalChargesCOGS_Id`  string , `InternalChargesRevenue_Id`  string , `FallbackSalesAccount_Id`  string , `FallbackSalesTaxRate_Id`  string , `LaborCOSCronActive`  string , `SubletCOSCronActive`  string , `ShowPastDueWarning`  string , `PayoutDescriptor`  string , `SV_Labor_Id`  string , `FinaleInventoryActive`  string , `FinaleUsername`  string , `FinalePassword`  string , `FinaleReportURL`  string , `FinalePhysicalInventoryURL`  string , `FinaleFacilityURL`  string , `FinaleActionURLCancel`  string , `FinaleUserLoginURL`  string , `ShowAutoChargeNotice`  string , `AllowAcceptTermsWithoutPayment`  string , `PrimaryColor`  string , `SecondaryColor`  string , `SeasonStart`  string , `SeasonEnd`  string , `MaxInstantPayout`  string , `InstantPayoutsEnabled`  string , `CashGLCode`  string , `CheckGLCode`  string , `ChipTerminalGLCode`  string , `CreditCardGLCode`  string , `StripeGLCode`  string , `BankAccountGLCode`  string , `WireTransferGLCode`  string , `PrepaymentGLCode`  string , `SecurityDepositGLCode`  string , `OverpaymentGLCode`  string , `ARGLCode`  string , `IDSEndpoint`  string , `IDSAuthorizationToken`  string , `AllowIDSContactImport`  string , `MoloAppPaymentsProvider_Id`  string , `MoloOnlinePaymentsProvider_Id`  string , `MoloOnlineBookingPaymentsProvider_Id`  string , `SalesTaxGLCode`  string , `DiscountGLCode`  string , `FiscalYearStart`  string , `DoNotAutoAllocateOnlinePayments`  string , `GLCodesRequired`  string , `OnlinePaymentFeeCap`  string , `OnlinePaymentFeeCapMethod`  string , `InvoiceFees`  string , `HideReservationDatesOnPrintedMaterials`  string , `LegacyInchesMath`  string , `TrackingCodeActive`  string , `MoloContactId`  string , `OnlinePaymentCurrency`  string , `OnlinePaymentXeroTaxRate`  string , `ShowPassengerCapacityResourceGrid`  string , `Country_Id`  string , `StripePayoutDelayDays`  string , `HideAllResourceOffersInitially`  string , `SortContactsByLastName`  string , `DisplayLastNameFirst`  string , `MaxOnlineResourceBookingsPerPersonPerDay`  string , `NewXeroToken_Id`  string , `APGLCode`  string , `XeroTenantId`  string , `Tip1Amount`  string , `Tip2Amount`  string , `Tip3Amount`  string , `Tip4Amount`  string , `Tip1Setting`  string , `Tip2Setting`  string , `Tip3Setting`  string , `Tip4Setting`  string , `InstallmentsDisabled`  string , `EmailSendingDomain`  string , `EnableProgressInvoicing`  string , `HideShorePower`  string , `DisregardForReporting`  string , `MarinaManagement`  string , `ServiceManagement`  string , `RVOrCampgroundManagement`  string , `VariableInvoicing`  string , `FinanceChargeMinimumBalance`  string , `FinanceChargeMinimumItem_Id`  string , `TaxCodeRefOverride`  string , `CustomerOnlinePaymentFee`  string , `CustomerOnlinePaymentPercentFee`  string , `CustomerOnlinePaymentMinimumFee`  string , `CustomerOnlinePaymentFeeItem`  string , `InProcessTextColor`  string , `PendingTextColor`  string , `ConfirmedTextColor`  string , `CheckedInTextColor`  string , `OnLeaveTextColor`  string , `CheckedOutTextColor`  string , `CancelledTextColor`  string , `InProcessColor`  string , `PendingColor`  string , `ConfirmedColor`  string , `CheckedInColor`  string , `OnLeaveColor`  string , `CheckedOutColor`  string , `CancelledColor`  string , `MarineSyncApiKey`  string , `MarineSyncBatchEnabled`  string , `MarineSyncIntegrationEnabled`  string , `DataExportEntityId`  string , `MarinaStellarInstanceURL`  string , `UseQBOTaxOverride`  string , `CompanyLevelContacts`  string , `SkipOnlinePaymentFees`  string , `SnagASlipPartnerAdminAccess`  string , `DeferralLogic`  string , `DisableVoidRefund`  string , `EnableOnReceiptTipping`  string , `EnableOnReaderTipping`  string , `TippingMode`  string , `SmartThreshold`  string , `IgnoreTaxAmountForTipBasis`  string , `TerminalConfigurationId`  string , `Tip1Percent`  string , `Tip2Percent`  string , `Tip3Percent`  string , `Tip1AmountWeb`  string , `Tip2AmountWeb`  string , `Tip3AmountWeb`  string , `HideGLTaxOverride`  string , `ContactCountryRequired`  string , `DisableFullViewEdits`  string , `DisableSecurityDepositRefundVoid`  string , `LastEditedTime`  string , `LastModifiedAspNetUser`  string , `DisableContactMergeOutsideLockDate`  string , `DisableFutureDatedStandaloneInvoice`  string , `ShowInvoiceDates`  string , `DisableNewReservationInvoice`  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-stage/raw/molo_moloMarinaLocations/2023-10-16/1697439311'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.molo_molomarinalocations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.molo_molomarinalocations"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform