Schema Info
Schema Name: sfdl_prod_drivethru.molo_molocontacts
- created: 2023-10-17 01:54:30
- disabled: False
- format: raw
- id: 1578
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_molocontacts" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717590
- created: 2026-04-17 03:01:15
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocontacts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocontacts`\n(\n `Id` string , `Emails` string , `FirstName` string , `MiddleName` string , `LastName` string , `MarinaLocationId` string , `Notes` string , `RecordStatusId` string , `IsSupplier` string , `IsCustomer` string , `XeroId` string , `CompanyContactName` string , `CreationUser` string , `CreationDateTime` string , `CIM_Id` string , `MarinaLocation1_Id` string , `QB_Customer_Id` string , `StatementsPreference_Id` string , `HashID` string , `MoloAPI_PartnerId` string , `TaxExemptStatus` string , `AutomaticDiscountPercent` string , `CostPlusDiscount` string , `LinkedParentContact` string , `ContactAutoChargeId` string , `LastEditedDateTime` string , `LastEditedUser_Id` string , `LastEditedMoloAPIPartner_Id` string , `StripeCustomer_Id` string , `AccountLimit` string , `Filestack_Id` string , `ShowCompanyNamePrinted` string , `BookingMergingDone` string , `DateOfBirth` string , `IDSCustomerID` string , `DoNotLaunch` string , `DoNotLaunchReason` string , `DriverLicenseId` string , `QuickbooksId` string , `QuickbooksName` string , `QBOVendorId` string , `SkipForFinanceCharges` string , `MainContactId` string , `PreventMerge` string , `AllowPartialPayments` string , `PortalEnabled` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-17/1776412697'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocontacts" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-17/1776412697
- id: 1717590
- processed: 1
- raw_data:
{ "AccountLimit": 29, "AllowPartialPayments": 44, "AutomaticDiscountPercent": 21, "BookingMergingDone": 32, "CIM_Id": 14, "CompanyContactName": 11, "ContactAutoChargeId": 24, "CostPlusDiscount": 22, "CreationDateTime": 13, "CreationUser": 12, "DateOfBirth": 33, "DoNotLaunch": 35, "DoNotLaunchReason": 36, "DriverLicenseId": 37, "Emails": 1, "Filestack_Id": 30, "FirstName": 2, "HashID": 18, "IDSCustomerID": 34, "Id": 0, "IsCustomer": 9, "IsSupplier": 8, "LastEditedDateTime": 25, "LastEditedMoloAPIPartner_Id": 27, "LastEditedUser_Id": 26, "LastName": 4, "LinkedParentContact": 23, "MainContactId": 42, "MarinaLocation1_Id": 15, "MarinaLocationId": 5, "MiddleName": 3, "MoloAPI_PartnerId": 19, "Notes": 6, "PortalEnabled": 45, "PreventMerge": 43, "QBOVendorId": 40, "QB_Customer_Id": 16, "QuickbooksId": 38, "QuickbooksName": 39, "RecordStatusId": 7, "ShowCompanyNamePrinted": 31, "SkipForFinanceCharges": 41, "StatementsPreference_Id": 17, "StripeCustomer_Id": 28, "TaxExemptStatus": 20, "XeroId": 10 } - schema_attributes:
{ "AccountLimit": "string", "AllowPartialPayments": "string", "AutomaticDiscountPercent": "string", "BookingMergingDone": "string", "CIM_Id": "string", "CompanyContactName": "string", "ContactAutoChargeId": "string", "CostPlusDiscount": "string", "CreationDateTime": "string", "CreationUser": "string", "DateOfBirth": "string", "DoNotLaunch": "string", "DoNotLaunchReason": "string", "DriverLicenseId": "string", "Emails": "string", "Filestack_Id": "string", "FirstName": "string", "HashID": "string", "IDSCustomerID": "string", "Id": "string", "IsCustomer": "string", "IsSupplier": "string", "LastEditedDateTime": "string", "LastEditedMoloAPIPartner_Id": "string", "LastEditedUser_Id": "string", "LastName": "string", "LinkedParentContact": "string", "MainContactId": "string", "MarinaLocation1_Id": "string", "MarinaLocationId": "string", "MiddleName": "string", "MoloAPI_PartnerId": "string", "Notes": "string", "PortalEnabled": "string", "PreventMerge": "string", "QBOVendorId": "string", "QB_Customer_Id": "string", "QuickbooksId": "string", "QuickbooksName": "string", "RecordStatusId": "string", "ShowCompanyNamePrinted": "string", "SkipForFinanceCharges": "string", "StatementsPreference_Id": "string", "StripeCustomer_Id": "string", "TaxExemptStatus": "string", "XeroId": "string" } - schema_name_id: 1578
- schema_scan_id: 162167253
- updated: 2026-04-17 03:01:29
-
Version 1716444
- created: 2026-04-16 03:09:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocontacts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocontacts`\n(\n `Id` string , `Emails` string , `FirstName` string , `MiddleName` string , `LastName` string , `MarinaLocationId` string , `Notes` string , `RecordStatusId` string , `IsSupplier` string , `IsCustomer` string , `XeroId` string , `CompanyContactName` string , `CreationUser` string , `CreationDateTime` string , `CIM_Id` string , `MarinaLocation1_Id` string , `QB_Customer_Id` string , `StatementsPreference_Id` string , `HashID` string , `MoloAPI_PartnerId` string , `TaxExemptStatus` string , `AutomaticDiscountPercent` string , `CostPlusDiscount` string , `LinkedParentContact` string , `ContactAutoChargeId` string , `LastEditedDateTime` string , `LastEditedUser_Id` string , `LastEditedMoloAPIPartner_Id` string , `StripeCustomer_Id` string , `AccountLimit` string , `Filestack_Id` string , `ShowCompanyNamePrinted` string , `BookingMergingDone` string , `DateOfBirth` string , `IDSCustomerID` string , `DoNotLaunch` string , `DoNotLaunchReason` string , `DriverLicenseId` string , `QuickbooksId` string , `QuickbooksName` string , `QBOVendorId` string , `SkipForFinanceCharges` string , `MainContactId` string , `PreventMerge` string , `AllowPartialPayments` string , `PortalEnabled` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-16/1776326461'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocontacts" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-16/1776326461
- id: 1716444
- processed: 1
- raw_data:
{ "AccountLimit": 29, "AllowPartialPayments": 44, "AutomaticDiscountPercent": 21, "BookingMergingDone": 32, "CIM_Id": 14, "CompanyContactName": 11, "ContactAutoChargeId": 24, "CostPlusDiscount": 22, "CreationDateTime": 13, "CreationUser": 12, "DateOfBirth": 33, "DoNotLaunch": 35, "DoNotLaunchReason": 36, "DriverLicenseId": 37, "Emails": 1, "Filestack_Id": 30, "FirstName": 2, "HashID": 18, "IDSCustomerID": 34, "Id": 0, "IsCustomer": 9, "IsSupplier": 8, "LastEditedDateTime": 25, "LastEditedMoloAPIPartner_Id": 27, "LastEditedUser_Id": 26, "LastName": 4, "LinkedParentContact": 23, "MainContactId": 42, "MarinaLocation1_Id": 15, "MarinaLocationId": 5, "MiddleName": 3, "MoloAPI_PartnerId": 19, "Notes": 6, "PortalEnabled": 45, "PreventMerge": 43, "QBOVendorId": 40, "QB_Customer_Id": 16, "QuickbooksId": 38, "QuickbooksName": 39, "RecordStatusId": 7, "ShowCompanyNamePrinted": 31, "SkipForFinanceCharges": 41, "StatementsPreference_Id": 17, "StripeCustomer_Id": 28, "TaxExemptStatus": 20, "XeroId": 10 } - schema_attributes:
{ "AccountLimit": "string", "AllowPartialPayments": "string", "AutomaticDiscountPercent": "string", "BookingMergingDone": "string", "CIM_Id": "string", "CompanyContactName": "string", "ContactAutoChargeId": "string", "CostPlusDiscount": "string", "CreationDateTime": "string", "CreationUser": "string", "DateOfBirth": "string", "DoNotLaunch": "string", "DoNotLaunchReason": "string", "DriverLicenseId": "string", "Emails": "string", "Filestack_Id": "string", "FirstName": "string", "HashID": "string", "IDSCustomerID": "string", "Id": "string", "IsCustomer": "string", "IsSupplier": "string", "LastEditedDateTime": "string", "LastEditedMoloAPIPartner_Id": "string", "LastEditedUser_Id": "string", "LastName": "string", "LinkedParentContact": "string", "MainContactId": "string", "MarinaLocation1_Id": "string", "MarinaLocationId": "string", "MiddleName": "string", "MoloAPI_PartnerId": "string", "Notes": "string", "PortalEnabled": "string", "PreventMerge": "string", "QBOVendorId": "string", "QB_Customer_Id": "string", "QuickbooksId": "string", "QuickbooksName": "string", "RecordStatusId": "string", "ShowCompanyNamePrinted": "string", "SkipForFinanceCharges": "string", "StatementsPreference_Id": "string", "StripeCustomer_Id": "string", "TaxExemptStatus": "string", "XeroId": "string" } - schema_name_id: 1578
- schema_scan_id: 162111879
- updated: 2026-04-16 03:09:39
-
Version 1715164
- created: 2026-04-15 03:02:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocontacts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocontacts`\n(\n `Id` string , `Emails` string , `FirstName` string , `MiddleName` string , `LastName` string , `MarinaLocationId` string , `Notes` string , `RecordStatusId` string , `IsSupplier` string , `IsCustomer` string , `XeroId` string , `CompanyContactName` string , `CreationUser` string , `CreationDateTime` string , `CIM_Id` string , `MarinaLocation1_Id` string , `QB_Customer_Id` string , `StatementsPreference_Id` string , `HashID` string , `MoloAPI_PartnerId` string , `TaxExemptStatus` string , `AutomaticDiscountPercent` string , `CostPlusDiscount` string , `LinkedParentContact` string , `ContactAutoChargeId` string , `LastEditedDateTime` string , `LastEditedUser_Id` string , `LastEditedMoloAPIPartner_Id` string , `StripeCustomer_Id` string , `AccountLimit` string , `Filestack_Id` string , `ShowCompanyNamePrinted` string , `BookingMergingDone` string , `DateOfBirth` string , `IDSCustomerID` string , `DoNotLaunch` string , `DoNotLaunchReason` string , `DriverLicenseId` string , `QuickbooksId` string , `QuickbooksName` string , `QBOVendorId` string , `SkipForFinanceCharges` string , `MainContactId` string , `PreventMerge` string , `AllowPartialPayments` string , `PortalEnabled` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-15/1776239932'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocontacts" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-15/1776239932
- id: 1715164
- processed: 1
- raw_data:
{ "AccountLimit": 29, "AllowPartialPayments": 44, "AutomaticDiscountPercent": 21, "BookingMergingDone": 32, "CIM_Id": 14, "CompanyContactName": 11, "ContactAutoChargeId": 24, "CostPlusDiscount": 22, "CreationDateTime": 13, "CreationUser": 12, "DateOfBirth": 33, "DoNotLaunch": 35, "DoNotLaunchReason": 36, "DriverLicenseId": 37, "Emails": 1, "Filestack_Id": 30, "FirstName": 2, "HashID": 18, "IDSCustomerID": 34, "Id": 0, "IsCustomer": 9, "IsSupplier": 8, "LastEditedDateTime": 25, "LastEditedMoloAPIPartner_Id": 27, "LastEditedUser_Id": 26, "LastName": 4, "LinkedParentContact": 23, "MainContactId": 42, "MarinaLocation1_Id": 15, "MarinaLocationId": 5, "MiddleName": 3, "MoloAPI_PartnerId": 19, "Notes": 6, "PortalEnabled": 45, "PreventMerge": 43, "QBOVendorId": 40, "QB_Customer_Id": 16, "QuickbooksId": 38, "QuickbooksName": 39, "RecordStatusId": 7, "ShowCompanyNamePrinted": 31, "SkipForFinanceCharges": 41, "StatementsPreference_Id": 17, "StripeCustomer_Id": 28, "TaxExemptStatus": 20, "XeroId": 10 } - schema_attributes:
{ "AccountLimit": "string", "AllowPartialPayments": "string", "AutomaticDiscountPercent": "string", "BookingMergingDone": "string", "CIM_Id": "string", "CompanyContactName": "string", "ContactAutoChargeId": "string", "CostPlusDiscount": "string", "CreationDateTime": "string", "CreationUser": "string", "DateOfBirth": "string", "DoNotLaunch": "string", "DoNotLaunchReason": "string", "DriverLicenseId": "string", "Emails": "string", "Filestack_Id": "string", "FirstName": "string", "HashID": "string", "IDSCustomerID": "string", "Id": "string", "IsCustomer": "string", "IsSupplier": "string", "LastEditedDateTime": "string", "LastEditedMoloAPIPartner_Id": "string", "LastEditedUser_Id": "string", "LastName": "string", "LinkedParentContact": "string", "MainContactId": "string", "MarinaLocation1_Id": "string", "MarinaLocationId": "string", "MiddleName": "string", "MoloAPI_PartnerId": "string", "Notes": "string", "PortalEnabled": "string", "PreventMerge": "string", "QBOVendorId": "string", "QB_Customer_Id": "string", "QuickbooksId": "string", "QuickbooksName": "string", "RecordStatusId": "string", "ShowCompanyNamePrinted": "string", "SkipForFinanceCharges": "string", "StatementsPreference_Id": "string", "StripeCustomer_Id": "string", "TaxExemptStatus": "string", "XeroId": "string" } - schema_name_id: 1578
- schema_scan_id: 162055762
- updated: 2026-04-15 03:02:43
-
Version 1714009
- created: 2026-04-14 03:05:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocontacts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocontacts`\n(\n `Id` string , `Emails` string , `FirstName` string , `MiddleName` string , `LastName` string , `MarinaLocationId` string , `Notes` string , `RecordStatusId` string , `IsSupplier` string , `IsCustomer` string , `XeroId` string , `CompanyContactName` string , `CreationUser` string , `CreationDateTime` string , `CIM_Id` string , `MarinaLocation1_Id` string , `QB_Customer_Id` string , `StatementsPreference_Id` string , `HashID` string , `MoloAPI_PartnerId` string , `TaxExemptStatus` string , `AutomaticDiscountPercent` string , `CostPlusDiscount` string , `LinkedParentContact` string , `ContactAutoChargeId` string , `LastEditedDateTime` string , `LastEditedUser_Id` string , `LastEditedMoloAPIPartner_Id` string , `StripeCustomer_Id` string , `AccountLimit` string , `Filestack_Id` string , `ShowCompanyNamePrinted` string , `BookingMergingDone` string , `DateOfBirth` string , `IDSCustomerID` string , `DoNotLaunch` string , `DoNotLaunchReason` string , `DriverLicenseId` string , `QuickbooksId` string , `QuickbooksName` string , `QBOVendorId` string , `SkipForFinanceCharges` string , `MainContactId` string , `PreventMerge` string , `AllowPartialPayments` string , `PortalEnabled` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-14/1776153657'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocontacts" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-14/1776153657
- id: 1714009
- processed: 1
- raw_data:
{ "AccountLimit": 29, "AllowPartialPayments": 44, "AutomaticDiscountPercent": 21, "BookingMergingDone": 32, "CIM_Id": 14, "CompanyContactName": 11, "ContactAutoChargeId": 24, "CostPlusDiscount": 22, "CreationDateTime": 13, "CreationUser": 12, "DateOfBirth": 33, "DoNotLaunch": 35, "DoNotLaunchReason": 36, "DriverLicenseId": 37, "Emails": 1, "Filestack_Id": 30, "FirstName": 2, "HashID": 18, "IDSCustomerID": 34, "Id": 0, "IsCustomer": 9, "IsSupplier": 8, "LastEditedDateTime": 25, "LastEditedMoloAPIPartner_Id": 27, "LastEditedUser_Id": 26, "LastName": 4, "LinkedParentContact": 23, "MainContactId": 42, "MarinaLocation1_Id": 15, "MarinaLocationId": 5, "MiddleName": 3, "MoloAPI_PartnerId": 19, "Notes": 6, "PortalEnabled": 45, "PreventMerge": 43, "QBOVendorId": 40, "QB_Customer_Id": 16, "QuickbooksId": 38, "QuickbooksName": 39, "RecordStatusId": 7, "ShowCompanyNamePrinted": 31, "SkipForFinanceCharges": 41, "StatementsPreference_Id": 17, "StripeCustomer_Id": 28, "TaxExemptStatus": 20, "XeroId": 10 } - schema_attributes:
{ "AccountLimit": "string", "AllowPartialPayments": "string", "AutomaticDiscountPercent": "string", "BookingMergingDone": "string", "CIM_Id": "string", "CompanyContactName": "string", "ContactAutoChargeId": "string", "CostPlusDiscount": "string", "CreationDateTime": "string", "CreationUser": "string", "DateOfBirth": "string", "DoNotLaunch": "string", "DoNotLaunchReason": "string", "DriverLicenseId": "string", "Emails": "string", "Filestack_Id": "string", "FirstName": "string", "HashID": "string", "IDSCustomerID": "string", "Id": "string", "IsCustomer": "string", "IsSupplier": "string", "LastEditedDateTime": "string", "LastEditedMoloAPIPartner_Id": "string", "LastEditedUser_Id": "string", "LastName": "string", "LinkedParentContact": "string", "MainContactId": "string", "MarinaLocation1_Id": "string", "MarinaLocationId": "string", "MiddleName": "string", "MoloAPI_PartnerId": "string", "Notes": "string", "PortalEnabled": "string", "PreventMerge": "string", "QBOVendorId": "string", "QB_Customer_Id": "string", "QuickbooksId": "string", "QuickbooksName": "string", "RecordStatusId": "string", "ShowCompanyNamePrinted": "string", "SkipForFinanceCharges": "string", "StatementsPreference_Id": "string", "StripeCustomer_Id": "string", "TaxExemptStatus": "string", "XeroId": "string" } - schema_name_id: 1578
- schema_scan_id: 162000477
- updated: 2026-04-14 03:05:54
-
Version 1712729
- created: 2026-04-13 02:56:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocontacts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocontacts`\n(\n `Id` string , `Emails` string , `FirstName` string , `MiddleName` string , `LastName` string , `MarinaLocationId` string , `Notes` string , `RecordStatusId` string , `IsSupplier` string , `IsCustomer` string , `XeroId` string , `CompanyContactName` string , `CreationUser` string , `CreationDateTime` string , `CIM_Id` string , `MarinaLocation1_Id` string , `QB_Customer_Id` string , `StatementsPreference_Id` string , `HashID` string , `MoloAPI_PartnerId` string , `TaxExemptStatus` string , `AutomaticDiscountPercent` string , `CostPlusDiscount` string , `LinkedParentContact` string , `ContactAutoChargeId` string , `LastEditedDateTime` string , `LastEditedUser_Id` string , `LastEditedMoloAPIPartner_Id` string , `StripeCustomer_Id` string , `AccountLimit` string , `Filestack_Id` string , `ShowCompanyNamePrinted` string , `BookingMergingDone` string , `DateOfBirth` string , `IDSCustomerID` string , `DoNotLaunch` string , `DoNotLaunchReason` string , `DriverLicenseId` string , `QuickbooksId` string , `QuickbooksName` string , `QBOVendorId` string , `SkipForFinanceCharges` string , `MainContactId` string , `PreventMerge` string , `AllowPartialPayments` string , `PortalEnabled` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-13/1776066850'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocontacts" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-13/1776066850
- id: 1712729
- processed: 1
- raw_data:
{ "AccountLimit": 29, "AllowPartialPayments": 44, "AutomaticDiscountPercent": 21, "BookingMergingDone": 32, "CIM_Id": 14, "CompanyContactName": 11, "ContactAutoChargeId": 24, "CostPlusDiscount": 22, "CreationDateTime": 13, "CreationUser": 12, "DateOfBirth": 33, "DoNotLaunch": 35, "DoNotLaunchReason": 36, "DriverLicenseId": 37, "Emails": 1, "Filestack_Id": 30, "FirstName": 2, "HashID": 18, "IDSCustomerID": 34, "Id": 0, "IsCustomer": 9, "IsSupplier": 8, "LastEditedDateTime": 25, "LastEditedMoloAPIPartner_Id": 27, "LastEditedUser_Id": 26, "LastName": 4, "LinkedParentContact": 23, "MainContactId": 42, "MarinaLocation1_Id": 15, "MarinaLocationId": 5, "MiddleName": 3, "MoloAPI_PartnerId": 19, "Notes": 6, "PortalEnabled": 45, "PreventMerge": 43, "QBOVendorId": 40, "QB_Customer_Id": 16, "QuickbooksId": 38, "QuickbooksName": 39, "RecordStatusId": 7, "ShowCompanyNamePrinted": 31, "SkipForFinanceCharges": 41, "StatementsPreference_Id": 17, "StripeCustomer_Id": 28, "TaxExemptStatus": 20, "XeroId": 10 } - schema_attributes:
{ "AccountLimit": "string", "AllowPartialPayments": "string", "AutomaticDiscountPercent": "string", "BookingMergingDone": "string", "CIM_Id": "string", "CompanyContactName": "string", "ContactAutoChargeId": "string", "CostPlusDiscount": "string", "CreationDateTime": "string", "CreationUser": "string", "DateOfBirth": "string", "DoNotLaunch": "string", "DoNotLaunchReason": "string", "DriverLicenseId": "string", "Emails": "string", "Filestack_Id": "string", "FirstName": "string", "HashID": "string", "IDSCustomerID": "string", "Id": "string", "IsCustomer": "string", "IsSupplier": "string", "LastEditedDateTime": "string", "LastEditedMoloAPIPartner_Id": "string", "LastEditedUser_Id": "string", "LastName": "string", "LinkedParentContact": "string", "MainContactId": "string", "MarinaLocation1_Id": "string", "MarinaLocationId": "string", "MiddleName": "string", "MoloAPI_PartnerId": "string", "Notes": "string", "PortalEnabled": "string", "PreventMerge": "string", "QBOVendorId": "string", "QB_Customer_Id": "string", "QuickbooksId": "string", "QuickbooksName": "string", "RecordStatusId": "string", "ShowCompanyNamePrinted": "string", "SkipForFinanceCharges": "string", "StatementsPreference_Id": "string", "StripeCustomer_Id": "string", "TaxExemptStatus": "string", "XeroId": "string" } - schema_name_id: 1578
- schema_scan_id: 161941507
- updated: 2026-04-13 02:56:23
-
Version 1711541
- created: 2026-04-12 02:58:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocontacts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocontacts`\n(\n `Id` string , `Emails` string , `FirstName` string , `MiddleName` string , `LastName` string , `MarinaLocationId` string , `Notes` string , `RecordStatusId` string , `IsSupplier` string , `IsCustomer` string , `XeroId` string , `CompanyContactName` string , `CreationUser` string , `CreationDateTime` string , `CIM_Id` string , `MarinaLocation1_Id` string , `QB_Customer_Id` string , `StatementsPreference_Id` string , `HashID` string , `MoloAPI_PartnerId` string , `TaxExemptStatus` string , `AutomaticDiscountPercent` string , `CostPlusDiscount` string , `LinkedParentContact` string , `ContactAutoChargeId` string , `LastEditedDateTime` string , `LastEditedUser_Id` string , `LastEditedMoloAPIPartner_Id` string , `StripeCustomer_Id` string , `AccountLimit` string , `Filestack_Id` string , `ShowCompanyNamePrinted` string , `BookingMergingDone` string , `DateOfBirth` string , `IDSCustomerID` string , `DoNotLaunch` string , `DoNotLaunchReason` string , `DriverLicenseId` string , `QuickbooksId` string , `QuickbooksName` string , `QBOVendorId` string , `SkipForFinanceCharges` string , `MainContactId` string , `PreventMerge` string , `AllowPartialPayments` string , `PortalEnabled` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-12/1775980566'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocontacts" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-12/1775980566
- id: 1711541
- processed: 1
- raw_data:
{ "AccountLimit": 29, "AllowPartialPayments": 44, "AutomaticDiscountPercent": 21, "BookingMergingDone": 32, "CIM_Id": 14, "CompanyContactName": 11, "ContactAutoChargeId": 24, "CostPlusDiscount": 22, "CreationDateTime": 13, "CreationUser": 12, "DateOfBirth": 33, "DoNotLaunch": 35, "DoNotLaunchReason": 36, "DriverLicenseId": 37, "Emails": 1, "Filestack_Id": 30, "FirstName": 2, "HashID": 18, "IDSCustomerID": 34, "Id": 0, "IsCustomer": 9, "IsSupplier": 8, "LastEditedDateTime": 25, "LastEditedMoloAPIPartner_Id": 27, "LastEditedUser_Id": 26, "LastName": 4, "LinkedParentContact": 23, "MainContactId": 42, "MarinaLocation1_Id": 15, "MarinaLocationId": 5, "MiddleName": 3, "MoloAPI_PartnerId": 19, "Notes": 6, "PortalEnabled": 45, "PreventMerge": 43, "QBOVendorId": 40, "QB_Customer_Id": 16, "QuickbooksId": 38, "QuickbooksName": 39, "RecordStatusId": 7, "ShowCompanyNamePrinted": 31, "SkipForFinanceCharges": 41, "StatementsPreference_Id": 17, "StripeCustomer_Id": 28, "TaxExemptStatus": 20, "XeroId": 10 } - schema_attributes:
{ "AccountLimit": "string", "AllowPartialPayments": "string", "AutomaticDiscountPercent": "string", "BookingMergingDone": "string", "CIM_Id": "string", "CompanyContactName": "string", "ContactAutoChargeId": "string", "CostPlusDiscount": "string", "CreationDateTime": "string", "CreationUser": "string", "DateOfBirth": "string", "DoNotLaunch": "string", "DoNotLaunchReason": "string", "DriverLicenseId": "string", "Emails": "string", "Filestack_Id": "string", "FirstName": "string", "HashID": "string", "IDSCustomerID": "string", "Id": "string", "IsCustomer": "string", "IsSupplier": "string", "LastEditedDateTime": "string", "LastEditedMoloAPIPartner_Id": "string", "LastEditedUser_Id": "string", "LastName": "string", "LinkedParentContact": "string", "MainContactId": "string", "MarinaLocation1_Id": "string", "MarinaLocationId": "string", "MiddleName": "string", "MoloAPI_PartnerId": "string", "Notes": "string", "PortalEnabled": "string", "PreventMerge": "string", "QBOVendorId": "string", "QB_Customer_Id": "string", "QuickbooksId": "string", "QuickbooksName": "string", "RecordStatusId": "string", "ShowCompanyNamePrinted": "string", "SkipForFinanceCharges": "string", "StatementsPreference_Id": "string", "StripeCustomer_Id": "string", "TaxExemptStatus": "string", "XeroId": "string" } - schema_name_id: 1578
- schema_scan_id: 161892361
- updated: 2026-04-12 02:58:37
-
Version 1710353
- created: 2026-04-11 03:02:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocontacts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocontacts`\n(\n `Id` string , `Emails` string , `FirstName` string , `MiddleName` string , `LastName` string , `MarinaLocationId` string , `Notes` string , `RecordStatusId` string , `IsSupplier` string , `IsCustomer` string , `XeroId` string , `CompanyContactName` string , `CreationUser` string , `CreationDateTime` string , `CIM_Id` string , `MarinaLocation1_Id` string , `QB_Customer_Id` string , `StatementsPreference_Id` string , `HashID` string , `MoloAPI_PartnerId` string , `TaxExemptStatus` string , `AutomaticDiscountPercent` string , `CostPlusDiscount` string , `LinkedParentContact` string , `ContactAutoChargeId` string , `LastEditedDateTime` string , `LastEditedUser_Id` string , `LastEditedMoloAPIPartner_Id` string , `StripeCustomer_Id` string , `AccountLimit` string , `Filestack_Id` string , `ShowCompanyNamePrinted` string , `BookingMergingDone` string , `DateOfBirth` string , `IDSCustomerID` string , `DoNotLaunch` string , `DoNotLaunchReason` string , `DriverLicenseId` string , `QuickbooksId` string , `QuickbooksName` string , `QBOVendorId` string , `SkipForFinanceCharges` string , `MainContactId` string , `PreventMerge` string , `AllowPartialPayments` string , `PortalEnabled` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-11/1775894326'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocontacts" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-11/1775894326
- id: 1710353
- processed: 1
- raw_data:
{ "AccountLimit": 29, "AllowPartialPayments": 44, "AutomaticDiscountPercent": 21, "BookingMergingDone": 32, "CIM_Id": 14, "CompanyContactName": 11, "ContactAutoChargeId": 24, "CostPlusDiscount": 22, "CreationDateTime": 13, "CreationUser": 12, "DateOfBirth": 33, "DoNotLaunch": 35, "DoNotLaunchReason": 36, "DriverLicenseId": 37, "Emails": 1, "Filestack_Id": 30, "FirstName": 2, "HashID": 18, "IDSCustomerID": 34, "Id": 0, "IsCustomer": 9, "IsSupplier": 8, "LastEditedDateTime": 25, "LastEditedMoloAPIPartner_Id": 27, "LastEditedUser_Id": 26, "LastName": 4, "LinkedParentContact": 23, "MainContactId": 42, "MarinaLocation1_Id": 15, "MarinaLocationId": 5, "MiddleName": 3, "MoloAPI_PartnerId": 19, "Notes": 6, "PortalEnabled": 45, "PreventMerge": 43, "QBOVendorId": 40, "QB_Customer_Id": 16, "QuickbooksId": 38, "QuickbooksName": 39, "RecordStatusId": 7, "ShowCompanyNamePrinted": 31, "SkipForFinanceCharges": 41, "StatementsPreference_Id": 17, "StripeCustomer_Id": 28, "TaxExemptStatus": 20, "XeroId": 10 } - schema_attributes:
{ "AccountLimit": "string", "AllowPartialPayments": "string", "AutomaticDiscountPercent": "string", "BookingMergingDone": "string", "CIM_Id": "string", "CompanyContactName": "string", "ContactAutoChargeId": "string", "CostPlusDiscount": "string", "CreationDateTime": "string", "CreationUser": "string", "DateOfBirth": "string", "DoNotLaunch": "string", "DoNotLaunchReason": "string", "DriverLicenseId": "string", "Emails": "string", "Filestack_Id": "string", "FirstName": "string", "HashID": "string", "IDSCustomerID": "string", "Id": "string", "IsCustomer": "string", "IsSupplier": "string", "LastEditedDateTime": "string", "LastEditedMoloAPIPartner_Id": "string", "LastEditedUser_Id": "string", "LastName": "string", "LinkedParentContact": "string", "MainContactId": "string", "MarinaLocation1_Id": "string", "MarinaLocationId": "string", "MiddleName": "string", "MoloAPI_PartnerId": "string", "Notes": "string", "PortalEnabled": "string", "PreventMerge": "string", "QBOVendorId": "string", "QB_Customer_Id": "string", "QuickbooksId": "string", "QuickbooksName": "string", "RecordStatusId": "string", "ShowCompanyNamePrinted": "string", "SkipForFinanceCharges": "string", "StatementsPreference_Id": "string", "StripeCustomer_Id": "string", "TaxExemptStatus": "string", "XeroId": "string" } - schema_name_id: 1578
- schema_scan_id: 161841054
- updated: 2026-04-11 03:02:37
-
Version 1709231
- created: 2026-04-10 03:05:33
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocontacts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocontacts`\n(\n `Id` string , `Emails` string , `FirstName` string , `MiddleName` string , `LastName` string , `MarinaLocationId` string , `Notes` string , `RecordStatusId` string , `IsSupplier` string , `IsCustomer` string , `XeroId` string , `CompanyContactName` string , `CreationUser` string , `CreationDateTime` string , `CIM_Id` string , `MarinaLocation1_Id` string , `QB_Customer_Id` string , `StatementsPreference_Id` string , `HashID` string , `MoloAPI_PartnerId` string , `TaxExemptStatus` string , `AutomaticDiscountPercent` string , `CostPlusDiscount` string , `LinkedParentContact` string , `ContactAutoChargeId` string , `LastEditedDateTime` string , `LastEditedUser_Id` string , `LastEditedMoloAPIPartner_Id` string , `StripeCustomer_Id` string , `AccountLimit` string , `Filestack_Id` string , `ShowCompanyNamePrinted` string , `BookingMergingDone` string , `DateOfBirth` string , `IDSCustomerID` string , `DoNotLaunch` string , `DoNotLaunchReason` string , `DriverLicenseId` string , `QuickbooksId` string , `QuickbooksName` string , `QBOVendorId` string , `SkipForFinanceCharges` string , `MainContactId` string , `PreventMerge` string , `AllowPartialPayments` string , `PortalEnabled` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-10/1775808082'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocontacts" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-10/1775808082
- id: 1709231
- processed: 1
- raw_data:
{ "AccountLimit": 29, "AllowPartialPayments": 44, "AutomaticDiscountPercent": 21, "BookingMergingDone": 32, "CIM_Id": 14, "CompanyContactName": 11, "ContactAutoChargeId": 24, "CostPlusDiscount": 22, "CreationDateTime": 13, "CreationUser": 12, "DateOfBirth": 33, "DoNotLaunch": 35, "DoNotLaunchReason": 36, "DriverLicenseId": 37, "Emails": 1, "Filestack_Id": 30, "FirstName": 2, "HashID": 18, "IDSCustomerID": 34, "Id": 0, "IsCustomer": 9, "IsSupplier": 8, "LastEditedDateTime": 25, "LastEditedMoloAPIPartner_Id": 27, "LastEditedUser_Id": 26, "LastName": 4, "LinkedParentContact": 23, "MainContactId": 42, "MarinaLocation1_Id": 15, "MarinaLocationId": 5, "MiddleName": 3, "MoloAPI_PartnerId": 19, "Notes": 6, "PortalEnabled": 45, "PreventMerge": 43, "QBOVendorId": 40, "QB_Customer_Id": 16, "QuickbooksId": 38, "QuickbooksName": 39, "RecordStatusId": 7, "ShowCompanyNamePrinted": 31, "SkipForFinanceCharges": 41, "StatementsPreference_Id": 17, "StripeCustomer_Id": 28, "TaxExemptStatus": 20, "XeroId": 10 } - schema_attributes:
{ "AccountLimit": "string", "AllowPartialPayments": "string", "AutomaticDiscountPercent": "string", "BookingMergingDone": "string", "CIM_Id": "string", "CompanyContactName": "string", "ContactAutoChargeId": "string", "CostPlusDiscount": "string", "CreationDateTime": "string", "CreationUser": "string", "DateOfBirth": "string", "DoNotLaunch": "string", "DoNotLaunchReason": "string", "DriverLicenseId": "string", "Emails": "string", "Filestack_Id": "string", "FirstName": "string", "HashID": "string", "IDSCustomerID": "string", "Id": "string", "IsCustomer": "string", "IsSupplier": "string", "LastEditedDateTime": "string", "LastEditedMoloAPIPartner_Id": "string", "LastEditedUser_Id": "string", "LastName": "string", "LinkedParentContact": "string", "MainContactId": "string", "MarinaLocation1_Id": "string", "MarinaLocationId": "string", "MiddleName": "string", "MoloAPI_PartnerId": "string", "Notes": "string", "PortalEnabled": "string", "PreventMerge": "string", "QBOVendorId": "string", "QB_Customer_Id": "string", "QuickbooksId": "string", "QuickbooksName": "string", "RecordStatusId": "string", "ShowCompanyNamePrinted": "string", "SkipForFinanceCharges": "string", "StatementsPreference_Id": "string", "StripeCustomer_Id": "string", "TaxExemptStatus": "string", "XeroId": "string" } - schema_name_id: 1578
- schema_scan_id: 161785912
- updated: 2026-04-10 03:05:44
-
Version 1708060
- created: 2026-04-09 03:00:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocontacts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocontacts`\n(\n `Id` string , `Emails` string , `FirstName` string , `MiddleName` string , `LastName` string , `MarinaLocationId` string , `Notes` string , `RecordStatusId` string , `IsSupplier` string , `IsCustomer` string , `XeroId` string , `CompanyContactName` string , `CreationUser` string , `CreationDateTime` string , `CIM_Id` string , `MarinaLocation1_Id` string , `QB_Customer_Id` string , `StatementsPreference_Id` string , `HashID` string , `MoloAPI_PartnerId` string , `TaxExemptStatus` string , `AutomaticDiscountPercent` string , `CostPlusDiscount` string , `LinkedParentContact` string , `ContactAutoChargeId` string , `LastEditedDateTime` string , `LastEditedUser_Id` string , `LastEditedMoloAPIPartner_Id` string , `StripeCustomer_Id` string , `AccountLimit` string , `Filestack_Id` string , `ShowCompanyNamePrinted` string , `BookingMergingDone` string , `DateOfBirth` string , `IDSCustomerID` string , `DoNotLaunch` string , `DoNotLaunchReason` string , `DriverLicenseId` string , `QuickbooksId` string , `QuickbooksName` string , `QBOVendorId` string , `SkipForFinanceCharges` string , `MainContactId` string , `PreventMerge` string , `AllowPartialPayments` string , `PortalEnabled` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-09/1775721421'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocontacts" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-09/1775721421
- id: 1708060
- processed: 1
- raw_data:
{ "AccountLimit": 29, "AllowPartialPayments": 44, "AutomaticDiscountPercent": 21, "BookingMergingDone": 32, "CIM_Id": 14, "CompanyContactName": 11, "ContactAutoChargeId": 24, "CostPlusDiscount": 22, "CreationDateTime": 13, "CreationUser": 12, "DateOfBirth": 33, "DoNotLaunch": 35, "DoNotLaunchReason": 36, "DriverLicenseId": 37, "Emails": 1, "Filestack_Id": 30, "FirstName": 2, "HashID": 18, "IDSCustomerID": 34, "Id": 0, "IsCustomer": 9, "IsSupplier": 8, "LastEditedDateTime": 25, "LastEditedMoloAPIPartner_Id": 27, "LastEditedUser_Id": 26, "LastName": 4, "LinkedParentContact": 23, "MainContactId": 42, "MarinaLocation1_Id": 15, "MarinaLocationId": 5, "MiddleName": 3, "MoloAPI_PartnerId": 19, "Notes": 6, "PortalEnabled": 45, "PreventMerge": 43, "QBOVendorId": 40, "QB_Customer_Id": 16, "QuickbooksId": 38, "QuickbooksName": 39, "RecordStatusId": 7, "ShowCompanyNamePrinted": 31, "SkipForFinanceCharges": 41, "StatementsPreference_Id": 17, "StripeCustomer_Id": 28, "TaxExemptStatus": 20, "XeroId": 10 } - schema_attributes:
{ "AccountLimit": "string", "AllowPartialPayments": "string", "AutomaticDiscountPercent": "string", "BookingMergingDone": "string", "CIM_Id": "string", "CompanyContactName": "string", "ContactAutoChargeId": "string", "CostPlusDiscount": "string", "CreationDateTime": "string", "CreationUser": "string", "DateOfBirth": "string", "DoNotLaunch": "string", "DoNotLaunchReason": "string", "DriverLicenseId": "string", "Emails": "string", "Filestack_Id": "string", "FirstName": "string", "HashID": "string", "IDSCustomerID": "string", "Id": "string", "IsCustomer": "string", "IsSupplier": "string", "LastEditedDateTime": "string", "LastEditedMoloAPIPartner_Id": "string", "LastEditedUser_Id": "string", "LastName": "string", "LinkedParentContact": "string", "MainContactId": "string", "MarinaLocation1_Id": "string", "MarinaLocationId": "string", "MiddleName": "string", "MoloAPI_PartnerId": "string", "Notes": "string", "PortalEnabled": "string", "PreventMerge": "string", "QBOVendorId": "string", "QB_Customer_Id": "string", "QuickbooksId": "string", "QuickbooksName": "string", "RecordStatusId": "string", "ShowCompanyNamePrinted": "string", "SkipForFinanceCharges": "string", "StatementsPreference_Id": "string", "StripeCustomer_Id": "string", "TaxExemptStatus": "string", "XeroId": "string" } - schema_name_id: 1578
- schema_scan_id: 161729965
- updated: 2026-04-09 03:01:00
-
Version 1706816
- created: 2026-04-08 03:01:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocontacts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocontacts`\n(\n `Id` string , `Emails` string , `FirstName` string , `MiddleName` string , `LastName` string , `MarinaLocationId` string , `Notes` string , `RecordStatusId` string , `IsSupplier` string , `IsCustomer` string , `XeroId` string , `CompanyContactName` string , `CreationUser` string , `CreationDateTime` string , `CIM_Id` string , `MarinaLocation1_Id` string , `QB_Customer_Id` string , `StatementsPreference_Id` string , `HashID` string , `MoloAPI_PartnerId` string , `TaxExemptStatus` string , `AutomaticDiscountPercent` string , `CostPlusDiscount` string , `LinkedParentContact` string , `ContactAutoChargeId` string , `LastEditedDateTime` string , `LastEditedUser_Id` string , `LastEditedMoloAPIPartner_Id` string , `StripeCustomer_Id` string , `AccountLimit` string , `Filestack_Id` string , `ShowCompanyNamePrinted` string , `BookingMergingDone` string , `DateOfBirth` string , `IDSCustomerID` string , `DoNotLaunch` string , `DoNotLaunchReason` string , `DriverLicenseId` string , `QuickbooksId` string , `QuickbooksName` string , `QBOVendorId` string , `SkipForFinanceCharges` string , `MainContactId` string , `PreventMerge` string , `AllowPartialPayments` string , `PortalEnabled` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-08/1775635229'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocontacts" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-08/1775635229
- id: 1706816
- processed: 1
- raw_data:
{ "AccountLimit": 29, "AllowPartialPayments": 44, "AutomaticDiscountPercent": 21, "BookingMergingDone": 32, "CIM_Id": 14, "CompanyContactName": 11, "ContactAutoChargeId": 24, "CostPlusDiscount": 22, "CreationDateTime": 13, "CreationUser": 12, "DateOfBirth": 33, "DoNotLaunch": 35, "DoNotLaunchReason": 36, "DriverLicenseId": 37, "Emails": 1, "Filestack_Id": 30, "FirstName": 2, "HashID": 18, "IDSCustomerID": 34, "Id": 0, "IsCustomer": 9, "IsSupplier": 8, "LastEditedDateTime": 25, "LastEditedMoloAPIPartner_Id": 27, "LastEditedUser_Id": 26, "LastName": 4, "LinkedParentContact": 23, "MainContactId": 42, "MarinaLocation1_Id": 15, "MarinaLocationId": 5, "MiddleName": 3, "MoloAPI_PartnerId": 19, "Notes": 6, "PortalEnabled": 45, "PreventMerge": 43, "QBOVendorId": 40, "QB_Customer_Id": 16, "QuickbooksId": 38, "QuickbooksName": 39, "RecordStatusId": 7, "ShowCompanyNamePrinted": 31, "SkipForFinanceCharges": 41, "StatementsPreference_Id": 17, "StripeCustomer_Id": 28, "TaxExemptStatus": 20, "XeroId": 10 } - schema_attributes:
{ "AccountLimit": "string", "AllowPartialPayments": "string", "AutomaticDiscountPercent": "string", "BookingMergingDone": "string", "CIM_Id": "string", "CompanyContactName": "string", "ContactAutoChargeId": "string", "CostPlusDiscount": "string", "CreationDateTime": "string", "CreationUser": "string", "DateOfBirth": "string", "DoNotLaunch": "string", "DoNotLaunchReason": "string", "DriverLicenseId": "string", "Emails": "string", "Filestack_Id": "string", "FirstName": "string", "HashID": "string", "IDSCustomerID": "string", "Id": "string", "IsCustomer": "string", "IsSupplier": "string", "LastEditedDateTime": "string", "LastEditedMoloAPIPartner_Id": "string", "LastEditedUser_Id": "string", "LastName": "string", "LinkedParentContact": "string", "MainContactId": "string", "MarinaLocation1_Id": "string", "MarinaLocationId": "string", "MiddleName": "string", "MoloAPI_PartnerId": "string", "Notes": "string", "PortalEnabled": "string", "PreventMerge": "string", "QBOVendorId": "string", "QB_Customer_Id": "string", "QuickbooksId": "string", "QuickbooksName": "string", "RecordStatusId": "string", "ShowCompanyNamePrinted": "string", "SkipForFinanceCharges": "string", "StatementsPreference_Id": "string", "StripeCustomer_Id": "string", "TaxExemptStatus": "string", "XeroId": "string" } - schema_name_id: 1578
- schema_scan_id: 161675349
- updated: 2026-04-08 03:01:59
-
Version 1705649
- created: 2026-04-07 02:54:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocontacts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocontacts`\n(\n `Id` string , `Emails` string , `FirstName` string , `MiddleName` string , `LastName` string , `MarinaLocationId` string , `Notes` string , `RecordStatusId` string , `IsSupplier` string , `IsCustomer` string , `XeroId` string , `CompanyContactName` string , `CreationUser` string , `CreationDateTime` string , `CIM_Id` string , `MarinaLocation1_Id` string , `QB_Customer_Id` string , `StatementsPreference_Id` string , `HashID` string , `MoloAPI_PartnerId` string , `TaxExemptStatus` string , `AutomaticDiscountPercent` string , `CostPlusDiscount` string , `LinkedParentContact` string , `ContactAutoChargeId` string , `LastEditedDateTime` string , `LastEditedUser_Id` string , `LastEditedMoloAPIPartner_Id` string , `StripeCustomer_Id` string , `AccountLimit` string , `Filestack_Id` string , `ShowCompanyNamePrinted` string , `BookingMergingDone` string , `DateOfBirth` string , `IDSCustomerID` string , `DoNotLaunch` string , `DoNotLaunchReason` string , `DriverLicenseId` string , `QuickbooksId` string , `QuickbooksName` string , `QBOVendorId` string , `SkipForFinanceCharges` string , `MainContactId` string , `PreventMerge` string , `AllowPartialPayments` string , `PortalEnabled` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-07/1775548403'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocontacts" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-07/1775548403
- id: 1705649
- processed: 1
- raw_data:
{ "AccountLimit": 29, "AllowPartialPayments": 44, "AutomaticDiscountPercent": 21, "BookingMergingDone": 32, "CIM_Id": 14, "CompanyContactName": 11, "ContactAutoChargeId": 24, "CostPlusDiscount": 22, "CreationDateTime": 13, "CreationUser": 12, "DateOfBirth": 33, "DoNotLaunch": 35, "DoNotLaunchReason": 36, "DriverLicenseId": 37, "Emails": 1, "Filestack_Id": 30, "FirstName": 2, "HashID": 18, "IDSCustomerID": 34, "Id": 0, "IsCustomer": 9, "IsSupplier": 8, "LastEditedDateTime": 25, "LastEditedMoloAPIPartner_Id": 27, "LastEditedUser_Id": 26, "LastName": 4, "LinkedParentContact": 23, "MainContactId": 42, "MarinaLocation1_Id": 15, "MarinaLocationId": 5, "MiddleName": 3, "MoloAPI_PartnerId": 19, "Notes": 6, "PortalEnabled": 45, "PreventMerge": 43, "QBOVendorId": 40, "QB_Customer_Id": 16, "QuickbooksId": 38, "QuickbooksName": 39, "RecordStatusId": 7, "ShowCompanyNamePrinted": 31, "SkipForFinanceCharges": 41, "StatementsPreference_Id": 17, "StripeCustomer_Id": 28, "TaxExemptStatus": 20, "XeroId": 10 } - schema_attributes:
{ "AccountLimit": "string", "AllowPartialPayments": "string", "AutomaticDiscountPercent": "string", "BookingMergingDone": "string", "CIM_Id": "string", "CompanyContactName": "string", "ContactAutoChargeId": "string", "CostPlusDiscount": "string", "CreationDateTime": "string", "CreationUser": "string", "DateOfBirth": "string", "DoNotLaunch": "string", "DoNotLaunchReason": "string", "DriverLicenseId": "string", "Emails": "string", "Filestack_Id": "string", "FirstName": "string", "HashID": "string", "IDSCustomerID": "string", "Id": "string", "IsCustomer": "string", "IsSupplier": "string", "LastEditedDateTime": "string", "LastEditedMoloAPIPartner_Id": "string", "LastEditedUser_Id": "string", "LastName": "string", "LinkedParentContact": "string", "MainContactId": "string", "MarinaLocation1_Id": "string", "MarinaLocationId": "string", "MiddleName": "string", "MoloAPI_PartnerId": "string", "Notes": "string", "PortalEnabled": "string", "PreventMerge": "string", "QBOVendorId": "string", "QB_Customer_Id": "string", "QuickbooksId": "string", "QuickbooksName": "string", "RecordStatusId": "string", "ShowCompanyNamePrinted": "string", "SkipForFinanceCharges": "string", "StatementsPreference_Id": "string", "StripeCustomer_Id": "string", "TaxExemptStatus": "string", "XeroId": "string" } - schema_name_id: 1578
- schema_scan_id: 161618326
- updated: 2026-04-07 02:55:07
-
Version 1704411
- created: 2026-04-06 03:01:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocontacts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocontacts`\n(\n `Id` string , `Emails` string , `FirstName` string , `MiddleName` string , `LastName` string , `MarinaLocationId` string , `Notes` string , `RecordStatusId` string , `IsSupplier` string , `IsCustomer` string , `XeroId` string , `CompanyContactName` string , `CreationUser` string , `CreationDateTime` string , `CIM_Id` string , `MarinaLocation1_Id` string , `QB_Customer_Id` string , `StatementsPreference_Id` string , `HashID` string , `MoloAPI_PartnerId` string , `TaxExemptStatus` string , `AutomaticDiscountPercent` string , `CostPlusDiscount` string , `LinkedParentContact` string , `ContactAutoChargeId` string , `LastEditedDateTime` string , `LastEditedUser_Id` string , `LastEditedMoloAPIPartner_Id` string , `StripeCustomer_Id` string , `AccountLimit` string , `Filestack_Id` string , `ShowCompanyNamePrinted` string , `BookingMergingDone` string , `DateOfBirth` string , `IDSCustomerID` string , `DoNotLaunch` string , `DoNotLaunchReason` string , `DriverLicenseId` string , `QuickbooksId` string , `QuickbooksName` string , `QBOVendorId` string , `SkipForFinanceCharges` string , `MainContactId` string , `PreventMerge` string , `AllowPartialPayments` string , `PortalEnabled` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-06/1775462365'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocontacts" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-06/1775462365
- id: 1704411
- processed: 1
- raw_data:
{ "AccountLimit": 29, "AllowPartialPayments": 44, "AutomaticDiscountPercent": 21, "BookingMergingDone": 32, "CIM_Id": 14, "CompanyContactName": 11, "ContactAutoChargeId": 24, "CostPlusDiscount": 22, "CreationDateTime": 13, "CreationUser": 12, "DateOfBirth": 33, "DoNotLaunch": 35, "DoNotLaunchReason": 36, "DriverLicenseId": 37, "Emails": 1, "Filestack_Id": 30, "FirstName": 2, "HashID": 18, "IDSCustomerID": 34, "Id": 0, "IsCustomer": 9, "IsSupplier": 8, "LastEditedDateTime": 25, "LastEditedMoloAPIPartner_Id": 27, "LastEditedUser_Id": 26, "LastName": 4, "LinkedParentContact": 23, "MainContactId": 42, "MarinaLocation1_Id": 15, "MarinaLocationId": 5, "MiddleName": 3, "MoloAPI_PartnerId": 19, "Notes": 6, "PortalEnabled": 45, "PreventMerge": 43, "QBOVendorId": 40, "QB_Customer_Id": 16, "QuickbooksId": 38, "QuickbooksName": 39, "RecordStatusId": 7, "ShowCompanyNamePrinted": 31, "SkipForFinanceCharges": 41, "StatementsPreference_Id": 17, "StripeCustomer_Id": 28, "TaxExemptStatus": 20, "XeroId": 10 } - schema_attributes:
{ "AccountLimit": "string", "AllowPartialPayments": "string", "AutomaticDiscountPercent": "string", "BookingMergingDone": "string", "CIM_Id": "string", "CompanyContactName": "string", "ContactAutoChargeId": "string", "CostPlusDiscount": "string", "CreationDateTime": "string", "CreationUser": "string", "DateOfBirth": "string", "DoNotLaunch": "string", "DoNotLaunchReason": "string", "DriverLicenseId": "string", "Emails": "string", "Filestack_Id": "string", "FirstName": "string", "HashID": "string", "IDSCustomerID": "string", "Id": "string", "IsCustomer": "string", "IsSupplier": "string", "LastEditedDateTime": "string", "LastEditedMoloAPIPartner_Id": "string", "LastEditedUser_Id": "string", "LastName": "string", "LinkedParentContact": "string", "MainContactId": "string", "MarinaLocation1_Id": "string", "MarinaLocationId": "string", "MiddleName": "string", "MoloAPI_PartnerId": "string", "Notes": "string", "PortalEnabled": "string", "PreventMerge": "string", "QBOVendorId": "string", "QB_Customer_Id": "string", "QuickbooksId": "string", "QuickbooksName": "string", "RecordStatusId": "string", "ShowCompanyNamePrinted": "string", "SkipForFinanceCharges": "string", "StatementsPreference_Id": "string", "StripeCustomer_Id": "string", "TaxExemptStatus": "string", "XeroId": "string" } - schema_name_id: 1578
- schema_scan_id: 161561390
- updated: 2026-04-06 03:02:12
-
Version 1703223
- created: 2026-04-05 03:02:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocontacts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocontacts`\n(\n `Id` string , `Emails` string , `FirstName` string , `MiddleName` string , `LastName` string , `MarinaLocationId` string , `Notes` string , `RecordStatusId` string , `IsSupplier` string , `IsCustomer` string , `XeroId` string , `CompanyContactName` string , `CreationUser` string , `CreationDateTime` string , `CIM_Id` string , `MarinaLocation1_Id` string , `QB_Customer_Id` string , `StatementsPreference_Id` string , `HashID` string , `MoloAPI_PartnerId` string , `TaxExemptStatus` string , `AutomaticDiscountPercent` string , `CostPlusDiscount` string , `LinkedParentContact` string , `ContactAutoChargeId` string , `LastEditedDateTime` string , `LastEditedUser_Id` string , `LastEditedMoloAPIPartner_Id` string , `StripeCustomer_Id` string , `AccountLimit` string , `Filestack_Id` string , `ShowCompanyNamePrinted` string , `BookingMergingDone` string , `DateOfBirth` string , `IDSCustomerID` string , `DoNotLaunch` string , `DoNotLaunchReason` string , `DriverLicenseId` string , `QuickbooksId` string , `QuickbooksName` string , `QBOVendorId` string , `SkipForFinanceCharges` string , `MainContactId` string , `PreventMerge` string , `AllowPartialPayments` string , `PortalEnabled` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-05/1775375993'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocontacts" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-05/1775375993
- id: 1703223
- processed: 1
- raw_data:
{ "AccountLimit": 29, "AllowPartialPayments": 44, "AutomaticDiscountPercent": 21, "BookingMergingDone": 32, "CIM_Id": 14, "CompanyContactName": 11, "ContactAutoChargeId": 24, "CostPlusDiscount": 22, "CreationDateTime": 13, "CreationUser": 12, "DateOfBirth": 33, "DoNotLaunch": 35, "DoNotLaunchReason": 36, "DriverLicenseId": 37, "Emails": 1, "Filestack_Id": 30, "FirstName": 2, "HashID": 18, "IDSCustomerID": 34, "Id": 0, "IsCustomer": 9, "IsSupplier": 8, "LastEditedDateTime": 25, "LastEditedMoloAPIPartner_Id": 27, "LastEditedUser_Id": 26, "LastName": 4, "LinkedParentContact": 23, "MainContactId": 42, "MarinaLocation1_Id": 15, "MarinaLocationId": 5, "MiddleName": 3, "MoloAPI_PartnerId": 19, "Notes": 6, "PortalEnabled": 45, "PreventMerge": 43, "QBOVendorId": 40, "QB_Customer_Id": 16, "QuickbooksId": 38, "QuickbooksName": 39, "RecordStatusId": 7, "ShowCompanyNamePrinted": 31, "SkipForFinanceCharges": 41, "StatementsPreference_Id": 17, "StripeCustomer_Id": 28, "TaxExemptStatus": 20, "XeroId": 10 } - schema_attributes:
{ "AccountLimit": "string", "AllowPartialPayments": "string", "AutomaticDiscountPercent": "string", "BookingMergingDone": "string", "CIM_Id": "string", "CompanyContactName": "string", "ContactAutoChargeId": "string", "CostPlusDiscount": "string", "CreationDateTime": "string", "CreationUser": "string", "DateOfBirth": "string", "DoNotLaunch": "string", "DoNotLaunchReason": "string", "DriverLicenseId": "string", "Emails": "string", "Filestack_Id": "string", "FirstName": "string", "HashID": "string", "IDSCustomerID": "string", "Id": "string", "IsCustomer": "string", "IsSupplier": "string", "LastEditedDateTime": "string", "LastEditedMoloAPIPartner_Id": "string", "LastEditedUser_Id": "string", "LastName": "string", "LinkedParentContact": "string", "MainContactId": "string", "MarinaLocation1_Id": "string", "MarinaLocationId": "string", "MiddleName": "string", "MoloAPI_PartnerId": "string", "Notes": "string", "PortalEnabled": "string", "PreventMerge": "string", "QBOVendorId": "string", "QB_Customer_Id": "string", "QuickbooksId": "string", "QuickbooksName": "string", "RecordStatusId": "string", "ShowCompanyNamePrinted": "string", "SkipForFinanceCharges": "string", "StatementsPreference_Id": "string", "StripeCustomer_Id": "string", "TaxExemptStatus": "string", "XeroId": "string" } - schema_name_id: 1578
- schema_scan_id: 161514786
- updated: 2026-04-05 03:02:12
-
Version 1702028
- created: 2026-04-04 02:59:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocontacts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocontacts`\n(\n `Id` string , `Emails` string , `FirstName` string , `MiddleName` string , `LastName` string , `MarinaLocationId` string , `Notes` string , `RecordStatusId` string , `IsSupplier` string , `IsCustomer` string , `XeroId` string , `CompanyContactName` string , `CreationUser` string , `CreationDateTime` string , `CIM_Id` string , `MarinaLocation1_Id` string , `QB_Customer_Id` string , `StatementsPreference_Id` string , `HashID` string , `MoloAPI_PartnerId` string , `TaxExemptStatus` string , `AutomaticDiscountPercent` string , `CostPlusDiscount` string , `LinkedParentContact` string , `ContactAutoChargeId` string , `LastEditedDateTime` string , `LastEditedUser_Id` string , `LastEditedMoloAPIPartner_Id` string , `StripeCustomer_Id` string , `AccountLimit` string , `Filestack_Id` string , `ShowCompanyNamePrinted` string , `BookingMergingDone` string , `DateOfBirth` string , `IDSCustomerID` string , `DoNotLaunch` string , `DoNotLaunchReason` string , `DriverLicenseId` string , `QuickbooksId` string , `QuickbooksName` string , `QBOVendorId` string , `SkipForFinanceCharges` string , `MainContactId` string , `PreventMerge` string , `AllowPartialPayments` string , `PortalEnabled` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-04/1775289477'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocontacts" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-04/1775289477
- id: 1702028
- processed: 1
- raw_data:
{ "AccountLimit": 29, "AllowPartialPayments": 44, "AutomaticDiscountPercent": 21, "BookingMergingDone": 32, "CIM_Id": 14, "CompanyContactName": 11, "ContactAutoChargeId": 24, "CostPlusDiscount": 22, "CreationDateTime": 13, "CreationUser": 12, "DateOfBirth": 33, "DoNotLaunch": 35, "DoNotLaunchReason": 36, "DriverLicenseId": 37, "Emails": 1, "Filestack_Id": 30, "FirstName": 2, "HashID": 18, "IDSCustomerID": 34, "Id": 0, "IsCustomer": 9, "IsSupplier": 8, "LastEditedDateTime": 25, "LastEditedMoloAPIPartner_Id": 27, "LastEditedUser_Id": 26, "LastName": 4, "LinkedParentContact": 23, "MainContactId": 42, "MarinaLocation1_Id": 15, "MarinaLocationId": 5, "MiddleName": 3, "MoloAPI_PartnerId": 19, "Notes": 6, "PortalEnabled": 45, "PreventMerge": 43, "QBOVendorId": 40, "QB_Customer_Id": 16, "QuickbooksId": 38, "QuickbooksName": 39, "RecordStatusId": 7, "ShowCompanyNamePrinted": 31, "SkipForFinanceCharges": 41, "StatementsPreference_Id": 17, "StripeCustomer_Id": 28, "TaxExemptStatus": 20, "XeroId": 10 } - schema_attributes:
{ "AccountLimit": "string", "AllowPartialPayments": "string", "AutomaticDiscountPercent": "string", "BookingMergingDone": "string", "CIM_Id": "string", "CompanyContactName": "string", "ContactAutoChargeId": "string", "CostPlusDiscount": "string", "CreationDateTime": "string", "CreationUser": "string", "DateOfBirth": "string", "DoNotLaunch": "string", "DoNotLaunchReason": "string", "DriverLicenseId": "string", "Emails": "string", "Filestack_Id": "string", "FirstName": "string", "HashID": "string", "IDSCustomerID": "string", "Id": "string", "IsCustomer": "string", "IsSupplier": "string", "LastEditedDateTime": "string", "LastEditedMoloAPIPartner_Id": "string", "LastEditedUser_Id": "string", "LastName": "string", "LinkedParentContact": "string", "MainContactId": "string", "MarinaLocation1_Id": "string", "MarinaLocationId": "string", "MiddleName": "string", "MoloAPI_PartnerId": "string", "Notes": "string", "PortalEnabled": "string", "PreventMerge": "string", "QBOVendorId": "string", "QB_Customer_Id": "string", "QuickbooksId": "string", "QuickbooksName": "string", "RecordStatusId": "string", "ShowCompanyNamePrinted": "string", "SkipForFinanceCharges": "string", "StatementsPreference_Id": "string", "StripeCustomer_Id": "string", "TaxExemptStatus": "string", "XeroId": "string" } - schema_name_id: 1578
- schema_scan_id: 161459795
- updated: 2026-04-04 02:59:47
-
Version 1700963
- created: 2026-04-03 03:10:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocontacts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocontacts`\n(\n `Id` string , `Emails` string , `FirstName` string , `MiddleName` string , `LastName` string , `MarinaLocationId` string , `Notes` string , `RecordStatusId` string , `IsSupplier` string , `IsCustomer` string , `XeroId` string , `CompanyContactName` string , `CreationUser` string , `CreationDateTime` string , `CIM_Id` string , `MarinaLocation1_Id` string , `QB_Customer_Id` string , `StatementsPreference_Id` string , `HashID` string , `MoloAPI_PartnerId` string , `TaxExemptStatus` string , `AutomaticDiscountPercent` string , `CostPlusDiscount` string , `LinkedParentContact` string , `ContactAutoChargeId` string , `LastEditedDateTime` string , `LastEditedUser_Id` string , `LastEditedMoloAPIPartner_Id` string , `StripeCustomer_Id` string , `AccountLimit` string , `Filestack_Id` string , `ShowCompanyNamePrinted` string , `BookingMergingDone` string , `DateOfBirth` string , `IDSCustomerID` string , `DoNotLaunch` string , `DoNotLaunchReason` string , `DriverLicenseId` string , `QuickbooksId` string , `QuickbooksName` string , `QBOVendorId` string , `SkipForFinanceCharges` string , `MainContactId` string , `PreventMerge` string , `AllowPartialPayments` string , `PortalEnabled` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-03/1775203250'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocontacts" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-03/1775203250
- id: 1700963
- processed: 1
- raw_data:
{ "AccountLimit": 29, "AllowPartialPayments": 44, "AutomaticDiscountPercent": 21, "BookingMergingDone": 32, "CIM_Id": 14, "CompanyContactName": 11, "ContactAutoChargeId": 24, "CostPlusDiscount": 22, "CreationDateTime": 13, "CreationUser": 12, "DateOfBirth": 33, "DoNotLaunch": 35, "DoNotLaunchReason": 36, "DriverLicenseId": 37, "Emails": 1, "Filestack_Id": 30, "FirstName": 2, "HashID": 18, "IDSCustomerID": 34, "Id": 0, "IsCustomer": 9, "IsSupplier": 8, "LastEditedDateTime": 25, "LastEditedMoloAPIPartner_Id": 27, "LastEditedUser_Id": 26, "LastName": 4, "LinkedParentContact": 23, "MainContactId": 42, "MarinaLocation1_Id": 15, "MarinaLocationId": 5, "MiddleName": 3, "MoloAPI_PartnerId": 19, "Notes": 6, "PortalEnabled": 45, "PreventMerge": 43, "QBOVendorId": 40, "QB_Customer_Id": 16, "QuickbooksId": 38, "QuickbooksName": 39, "RecordStatusId": 7, "ShowCompanyNamePrinted": 31, "SkipForFinanceCharges": 41, "StatementsPreference_Id": 17, "StripeCustomer_Id": 28, "TaxExemptStatus": 20, "XeroId": 10 } - schema_attributes:
{ "AccountLimit": "string", "AllowPartialPayments": "string", "AutomaticDiscountPercent": "string", "BookingMergingDone": "string", "CIM_Id": "string", "CompanyContactName": "string", "ContactAutoChargeId": "string", "CostPlusDiscount": "string", "CreationDateTime": "string", "CreationUser": "string", "DateOfBirth": "string", "DoNotLaunch": "string", "DoNotLaunchReason": "string", "DriverLicenseId": "string", "Emails": "string", "Filestack_Id": "string", "FirstName": "string", "HashID": "string", "IDSCustomerID": "string", "Id": "string", "IsCustomer": "string", "IsSupplier": "string", "LastEditedDateTime": "string", "LastEditedMoloAPIPartner_Id": "string", "LastEditedUser_Id": "string", "LastName": "string", "LinkedParentContact": "string", "MainContactId": "string", "MarinaLocation1_Id": "string", "MarinaLocationId": "string", "MiddleName": "string", "MoloAPI_PartnerId": "string", "Notes": "string", "PortalEnabled": "string", "PreventMerge": "string", "QBOVendorId": "string", "QB_Customer_Id": "string", "QuickbooksId": "string", "QuickbooksName": "string", "RecordStatusId": "string", "ShowCompanyNamePrinted": "string", "SkipForFinanceCharges": "string", "StatementsPreference_Id": "string", "StripeCustomer_Id": "string", "TaxExemptStatus": "string", "XeroId": "string" } - schema_name_id: 1578
- schema_scan_id: 161401925
- updated: 2026-04-03 03:10:51
Schema Scans: 15
Last at 2026-04-17 03:01:14
-
Scan 162167253
- duration: 0:00:15.403859
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167253
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-17/1776412697", "key": "raw/molo_moloContacts/2026-04-17/1776412697/Contacts.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloContacts", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14376710570820396818, "service_name": "drive-thru", "span_id": 10241834220715619083, "trace_id": 16797033287324098504 } } - running: False
- schema_name_id: 1578
- start_time: 2026-04-17 03:01:14
- success: True
- trace_id: 16797033287324098504
-
Scan 162111879
- duration: 0:00:13.025889
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162111879
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-16/1776326461", "key": "raw/molo_moloContacts/2026-04-16/1776326461/Contacts.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloContacts", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9759004712934902202, "service_name": "drive-thru", "span_id": 13097813343543637264, "trace_id": 16693428130179132675 } } - running: False
- schema_name_id: 1578
- start_time: 2026-04-16 03:09:26
- success: True
- trace_id: 16693428130179132675
-
Scan 162055762
- duration: 0:00:12.791340
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162055762
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-15/1776239932", "key": "raw/molo_moloContacts/2026-04-15/1776239932/Contacts.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloContacts", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18233594843309585932, "service_name": "drive-thru", "span_id": 15816334963367380165, "trace_id": 7541098813686515653 } } - running: False
- schema_name_id: 1578
- start_time: 2026-04-15 03:02:31
- success: True
- trace_id: 7541098813686515653
-
Scan 162000477
- duration: 0:00:15.456050
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000477
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-14/1776153657", "key": "raw/molo_moloContacts/2026-04-14/1776153657/Contacts.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloContacts", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11244106802527423696, "service_name": "drive-thru", "span_id": 9437847452396675936, "trace_id": 10531508763292497297 } } - running: False
- schema_name_id: 1578
- start_time: 2026-04-14 03:05:39
- success: True
- trace_id: 10531508763292497297
-
Scan 161941507
- duration: 0:00:15.369627
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161941507
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-13/1776066850", "key": "raw/molo_moloContacts/2026-04-13/1776066850/Contacts.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloContacts", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17152989387218550631, "service_name": "drive-thru", "span_id": 11377465371180103242, "trace_id": 8188886103849652185 } } - running: False
- schema_name_id: 1578
- start_time: 2026-04-13 02:56:07
- success: True
- trace_id: 8188886103849652185
-
Scan 161892361
- duration: 0:00:12.858427
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161892361
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-12/1775980566", "key": "raw/molo_moloContacts/2026-04-12/1775980566/Contacts.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloContacts", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9946772623146052515, "service_name": "drive-thru", "span_id": 12688585944707204821, "trace_id": 13536543970263058662 } } - running: False
- schema_name_id: 1578
- start_time: 2026-04-12 02:58:24
- success: True
- trace_id: 13536543970263058662
-
Scan 161841054
- duration: 0:00:15.385480
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841054
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-11/1775894326", "key": "raw/molo_moloContacts/2026-04-11/1775894326/Contacts.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloContacts", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11955818807505858967, "service_name": "drive-thru", "span_id": 16631540420080761367, "trace_id": 14957561776853398002 } } - running: False
- schema_name_id: 1578
- start_time: 2026-04-11 03:02:22
- success: True
- trace_id: 14957561776853398002
-
Scan 161785912
- duration: 0:00:13.140900
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161785912
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-10/1775808082", "key": "raw/molo_moloContacts/2026-04-10/1775808082/Contacts.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloContacts", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5908841815179789371, "service_name": "drive-thru", "span_id": 6626003499125117899, "trace_id": 14208908984901712961 } } - running: False
- schema_name_id: 1578
- start_time: 2026-04-10 03:05:31
- success: True
- trace_id: 14208908984901712961
-
Scan 161729965
- duration: 0:00:15.500809
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161729965
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-09/1775721421", "key": "raw/molo_moloContacts/2026-04-09/1775721421/Contacts.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloContacts", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13442627727939276963, "service_name": "drive-thru", "span_id": 15230863400460351581, "trace_id": 10659009591615667021 } } - running: False
- schema_name_id: 1578
- start_time: 2026-04-09 03:00:44
- success: True
- trace_id: 10659009591615667021
-
Scan 161675349
- duration: 0:00:12.845321
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675349
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-08/1775635229", "key": "raw/molo_moloContacts/2026-04-08/1775635229/Contacts.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloContacts", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1392562055221327206, "service_name": "drive-thru", "span_id": 15778896256126099468, "trace_id": 12432963526035894225 } } - running: False
- schema_name_id: 1578
- start_time: 2026-04-08 03:01:46
- success: True
- trace_id: 12432963526035894225
-
Scan 161618326
- duration: 0:00:15.506063
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161618326
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-07/1775548403", "key": "raw/molo_moloContacts/2026-04-07/1775548403/Contacts.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloContacts", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10731289159241312418, "service_name": "drive-thru", "span_id": 14722805824073460933, "trace_id": 13897273089389456461 } } - running: False
- schema_name_id: 1578
- start_time: 2026-04-07 02:54:52
- success: True
- trace_id: 13897273089389456461
-
Scan 161561390
- duration: 0:00:15.539531
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561390
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-06/1775462365", "key": "raw/molo_moloContacts/2026-04-06/1775462365/Contacts.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloContacts", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6277774127660524450, "service_name": "drive-thru", "span_id": 15154336058073038763, "trace_id": 13431419767992622298 } } - running: False
- schema_name_id: 1578
- start_time: 2026-04-06 03:01:56
- success: True
- trace_id: 13431419767992622298
-
Scan 161514786
- duration: 0:00:12.902983
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161514786
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-05/1775375993", "key": "raw/molo_moloContacts/2026-04-05/1775375993/Contacts.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloContacts", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15070634881225470408, "service_name": "drive-thru", "span_id": 5934793227898791654, "trace_id": 11265535290077750658 } } - running: False
- schema_name_id: 1578
- start_time: 2026-04-05 03:01:59
- success: True
- trace_id: 11265535290077750658
-
Scan 161459795
- duration: 0:00:12.858263
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161459795
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-04/1775289477", "key": "raw/molo_moloContacts/2026-04-04/1775289477/Contacts.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloContacts", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10631331172496170558, "service_name": "drive-thru", "span_id": 8711399810676308942, "trace_id": 18056523613183814948 } } - running: False
- schema_name_id: 1578
- start_time: 2026-04-04 02:59:34
- success: True
- trace_id: 18056523613183814948
-
Scan 161401925
- duration: 0:00:12.782067
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161401925
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-03/1775203250", "key": "raw/molo_moloContacts/2026-04-03/1775203250/Contacts.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloContacts", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8246811754336312384, "service_name": "drive-thru", "span_id": 10457629603176806221, "trace_id": 6207528774252455020 } } - running: False
- schema_name_id: 1578
- start_time: 2026-04-03 03:10:38
- success: True
- trace_id: 6207528774252455020
- attributes:
{ "AccountLimit": "string", "AllowPartialPayments": "string", "AutomaticDiscountPercent": "string", "BookingMergingDone": "string", "CIM_Id": "string", "CompanyContactName": "string", "ContactAutoChargeId": "string", "CostPlusDiscount": "string", "CreationDateTime": "string", "CreationUser": "string", "DateOfBirth": "string", "DoNotLaunch": "string", "DoNotLaunchReason": "string", "DriverLicenseId": "string", "Emails": "string", "Filestack_Id": "string", "FirstName": "string", "HashID": "string", "IDSCustomerID": "string", "Id": "string", "IsCustomer": "string", "IsSupplier": "string", "LastEditedDateTime": "string", "LastEditedMoloAPIPartner_Id": "string", "LastEditedUser_Id": "string", "LastName": "string", "LinkedParentContact": "string", "MainContactId": "string", "MarinaLocation1_Id": "string", "MarinaLocationId": "string", "MiddleName": "string", "MoloAPI_PartnerId": "string", "Notes": "string", "PortalEnabled": "string", "PreventMerge": "string", "QBOVendorId": "string", "QB_Customer_Id": "string", "QuickbooksId": "string", "QuickbooksName": "string", "RecordStatusId": "string", "ShowCompanyNamePrinted": "string", "SkipForFinanceCharges": "string", "StatementsPreference_Id": "string", "StripeCustomer_Id": "string", "TaxExemptStatus": "string", "XeroId": "string" } - created: 2026-04-17 03:01:15
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocontacts`\n(\n `Id` string , `Emails` string , `FirstName` string , `MiddleName` string , `LastName` string , `MarinaLocationId` string , `Notes` string , `RecordStatusId` string , `IsSupplier` string , `IsCustomer` string , `XeroId` string , `CompanyContactName` string , `CreationUser` string , `CreationDateTime` string , `CIM_Id` string , `MarinaLocation1_Id` string , `QB_Customer_Id` string , `StatementsPreference_Id` string , `HashID` string , `MoloAPI_PartnerId` string , `TaxExemptStatus` string , `AutomaticDiscountPercent` string , `CostPlusDiscount` string , `LinkedParentContact` string , `ContactAutoChargeId` string , `LastEditedDateTime` string , `LastEditedUser_Id` string , `LastEditedMoloAPIPartner_Id` string , `StripeCustomer_Id` string , `AccountLimit` string , `Filestack_Id` string , `ShowCompanyNamePrinted` string , `BookingMergingDone` string , `DateOfBirth` string , `IDSCustomerID` string , `DoNotLaunch` string , `DoNotLaunchReason` string , `DriverLicenseId` string , `QuickbooksId` string , `QuickbooksName` string , `QBOVendorId` string , `SkipForFinanceCharges` string , `MainContactId` string , `PreventMerge` string , `AllowPartialPayments` string , `PortalEnabled` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-17/1776412697'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocontacts`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocontacts" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2023-10-17 01:54:30",
"disabled": false,
"format": "raw",
"id": 1578,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_molocontacts"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"AccountLimit": "string",
"AllowPartialPayments": "string",
"AutomaticDiscountPercent": "string",
"BookingMergingDone": "string",
"CIM_Id": "string",
"CompanyContactName": "string",
"ContactAutoChargeId": "string",
"CostPlusDiscount": "string",
"CreationDateTime": "string",
"CreationUser": "string",
"DateOfBirth": "string",
"DoNotLaunch": "string",
"DoNotLaunchReason": "string",
"DriverLicenseId": "string",
"Emails": "string",
"Filestack_Id": "string",
"FirstName": "string",
"HashID": "string",
"IDSCustomerID": "string",
"Id": "string",
"IsCustomer": "string",
"IsSupplier": "string",
"LastEditedDateTime": "string",
"LastEditedMoloAPIPartner_Id": "string",
"LastEditedUser_Id": "string",
"LastName": "string",
"LinkedParentContact": "string",
"MainContactId": "string",
"MarinaLocation1_Id": "string",
"MarinaLocationId": "string",
"MiddleName": "string",
"MoloAPI_PartnerId": "string",
"Notes": "string",
"PortalEnabled": "string",
"PreventMerge": "string",
"QBOVendorId": "string",
"QB_Customer_Id": "string",
"QuickbooksId": "string",
"QuickbooksName": "string",
"RecordStatusId": "string",
"ShowCompanyNamePrinted": "string",
"SkipForFinanceCharges": "string",
"StatementsPreference_Id": "string",
"StripeCustomer_Id": "string",
"TaxExemptStatus": "string",
"XeroId": "string"
},
"created": "2026-04-17 03:01:15",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocontacts`\n(\n `Id` string , `Emails` string , `FirstName` string , `MiddleName` string , `LastName` string , `MarinaLocationId` string , `Notes` string , `RecordStatusId` string , `IsSupplier` string , `IsCustomer` string , `XeroId` string , `CompanyContactName` string , `CreationUser` string , `CreationDateTime` string , `CIM_Id` string , `MarinaLocation1_Id` string , `QB_Customer_Id` string , `StatementsPreference_Id` string , `HashID` string , `MoloAPI_PartnerId` string , `TaxExemptStatus` string , `AutomaticDiscountPercent` string , `CostPlusDiscount` string , `LinkedParentContact` string , `ContactAutoChargeId` string , `LastEditedDateTime` string , `LastEditedUser_Id` string , `LastEditedMoloAPIPartner_Id` string , `StripeCustomer_Id` string , `AccountLimit` string , `Filestack_Id` string , `ShowCompanyNamePrinted` string , `BookingMergingDone` string , `DateOfBirth` string , `IDSCustomerID` string , `DoNotLaunch` string , `DoNotLaunchReason` string , `DriverLicenseId` string , `QuickbooksId` string , `QuickbooksName` string , `QBOVendorId` string , `SkipForFinanceCharges` string , `MainContactId` string , `PreventMerge` string , `AllowPartialPayments` string , `PortalEnabled` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloContacts/2026-04-17/1776412697'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocontacts`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocontacts"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}