Schema Info

Schema Name: sfdl_dev_csv.salesforce_contacts
  • created: 2022-10-24 14:51:55
  • disabled: False
  • format: raw
  • id: 2055
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_dev_csv",
    "table": "salesforce_contacts"
}
  • type: csv
Schema Versions: 5
    • created: 2024-06-10 15:35:53
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_contacts`\n(\n `Id`  string , `IsDeleted`  string , `MasterRecordId`  string , `AccountId`  string , `LastName`  string , `FirstName`  string , `Salutation`  string , `Name`  string , `RecordTypeId`  string , `OtherStreet`  string , `OtherCity`  string , `OtherState`  string , `OtherPostalCode`  string , `OtherCountry`  string , `OtherLatitude`  string , `OtherLongitude`  string , `OtherGeocodeAccuracy`  string , `MailingStreet`  string , `MailingCity`  string , `MailingState`  string , `MailingPostalCode`  string , `MailingCountry`  string , `MailingLatitude`  string , `MailingLongitude`  string , `MailingGeocodeAccuracy`  string , `Phone`  string , `Fax`  string , `MobilePhone`  string , `HomePhone`  string , `OtherPhone`  string , `AssistantPhone`  string , `ReportsToId`  string , `Email`  string , `Title`  string , `Department`  string , `AssistantName`  string , `LeadSource`  string , `Birthdate`  string , `Description`  string , `CurrencyIsoCode`  string , `OwnerId`  string , `HasOptedOutOfEmail`  string , `HasOptedOutOfFax`  string , `DoNotCall`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `LastCURequestDate`  string , `LastCUUpdateDate`  string , `EmailBouncedReason`  string , `EmailBouncedDate`  string , `IsEmailBounced`  string , `Jigsaw`  string , `JigsawContactId`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `IndividualId`  string , `Pronouns`  string , `GenderIdentity`  string , `Receives_Call_Center_API__c`  string , `Home_Phone_1__c`  string , `Address_Type__c`  string , `Email_1__c`  string , `Email_2__c`  string , `Email_3__c`  string , `Receives_Reporting_API__c`  string , `Contact_Outlook_Category__c`  string , `Marketing_Contact_Method__c`  string , `ExporttoHubspot__c`  string , `HasOptedOutOfMail__c`  string , `Technical_Contact__c`  string , `Middle_Name__c`  string , `Marketing__c`  string , `TIMBASURVEYS__Survey__c`  string , `Authority__c`  string , `No_Longer_with_Company__c`  string , `Attended__c`  string , `IGD__Collection_Id__c`  string , `pi__pardot_hard_bounced__c`  string , `pi__campaign__c`  string , `pi__comments__c`  string , `pi__conversion_date__c`  string , `pi__conversion_object_name__c`  string , `pi__conversion_object_type__c`  string , `pi__created_date__c`  string , `pi__first_activity__c`  string , `pi__first_search_term__c`  string , `pi__first_search_type__c`  string , `pi__first_touch_url__c`  string , `pi__grade__c`  string , `pi__last_activity__c`  string , `pi__notes__c`  string , `pi__score__c`  string , `pi__url__c`  string , `pi__utm_campaign__c`  string , `pi__utm_content__c`  string , `pi__utm_medium__c`  string , `pi__utm_source__c`  string , `pi__utm_term__c`  string , `Web_Comments__c`  string , `Current_Feature_Interest__c`  string , `Receives_SOC_1_Type_2_Report__c`  string , `pi__Needs_Score_Synced__c`  string , `pi__Pardot_Last_Scored_At__c`  string , `business_owner_checkbox__c`  string , `sales_contact__c`  string , `Needs__c`  string , `MS_Contact__c`  string , `Sparefoot_Lead_Sent__c`  string , `Sent_to_SpareFoot_By__c`  string , `Sent_to_SpareFoot__c`  string , `utm_campaign__c`  string , `utm_ad__c`  string , `utm_keyword__c`  string , `utm_source__c`  string , `rh2__Currency_Test__c`  string , `rh2__Describe__c`  string , `rh2__Integer_Test__c`  string , `SourceLeadID__c`  string , `Internal_Referral__c`  string , `utm_medium__c`  string , `Web_Source__c`  string , `Phoneextension__c`  string , `FormSource__c`  string , `storEDGE_Salesforce_ID__c`  string , `KronologicCampaigns__c`  string , `KronologicStatus__c`  string , `CSAT_Most_Recent_Combined_Score__c`  string , `CSAT_Most_Recent_Support_Score__c`  string , `CSAT_Most_Recent_Product_Score__c`  string , `CSAT_Most_Recent_NPS__c`  string , `CSAT_Date_Time_Most_Recently_Completed__c`  string , `CSAT_Most_Recent_Comment__c`  string , `dupcheck__dc3DisableDuplicateCheck__c`  string , `dupcheck__dc3Index__c`  string , `Opportunity__c`  string , `Nickname__c`  string , `Dupe_Check_Unique_Matched_ID__c`  string , `Dupe_Check_Master_Record__c`  string , `Dupe_Check_Merge_Cohort__c`  string , `Most_Recent_HubSpot_Message__c`  string , `Genesys_Phone__c`  string , `Total_Launchable_AC_Facilities__c`  string , `of_New_or_Cross_sell_Oppty__c`  string , `MySpareFoot_User_ID__c`  string , `Contact_Name_1__c`  string , `Contact_Name_2__c`  string , `Contact_Name_3__c`  string , `Billing_System_Email__c`  string , `Billing_System_Sync_Time__c`  string , `Leadliaison__LLBounced__c`  string , `Leadliaison__LLFirstTouchCampaignName__c`  string , `Leadliaison__LLFirstTouchProgramName__c`  string , `Leadliaison__LLLastSearchEngine__c`  string , `Leadliaison__LLLastSearchPhrase__c`  string , `Leadliaison__LLLastSyncToLeadLiaisonWebApp__c`  string , `Leadliaison__LLLastVisitTime__c`  string , `Live_ESS_CA_Facilities__c`  string , `Live_ESS_FMS_Facilities__c`  string , `Live_ESS_SEO_Facilities__c`  string , `Live_TPP_Facilities__c`  string , `Date_Time_Last_Data_Lake_Sync__c`  string , `MySpareFoot_User_Email__c`  string , `MySpareFoot_User_Phone__c`  string , `System_of_Origin__c`  string , `Contact_CSM__c`  string , `Leadliaison__LLLastWebVisit__c`  string , `Leadliaison__LLLeadLiaisonGrade__c`  string , `Leadliaison__LLLeadLiaisonScore__c`  string , `Leadliaison__LLOriginalReferralSource__c`  string , `Leadliaison__LLTotalWebVisits__c`  string , `Leadliaison__LL_Profile_ID__c`  string , `Leadliaison__LL_Total_Activity__c`  string , `Date_Time_Most_Recent_Imp_CSAT_Completed__c`  string , `Most_Recent_Imp_Combined_CSAT_Score__c`  string , `Most_Recent_Imp_CSAT_Comment__c`  string , `Most_Recent_Imp_CSAT_Product_Score__c`  string , `Contact_Info_Confirmed__c`  string , `Date_Contact_Info_Confirmed__c`  string , `Most_Recent_Imp_CSAT_Support_Score__c`  string , `DateTimeLastFormFill__c`  string , `FormFillRegion__c`  string , `LeadScore__c`  string , `NumberOfFormFills__c`  string , `ProductInterestScoreAC__c`  string , `ProductInterestScoreDMS__c`  string , `ProductInterestScoreESS__c`  string , `ProductInterestScorePC__c`  string , `ProductInterestScoreSE__c`  string , `ProductInterestScoreSL__c`  string , `ProductInterestScoreTPP__c`  string , `CP_Hubspot_Record_ID__c`  string , `Dialpad__IsCreatedFromDialpad__c`  string , `Dialpad__Powerdialer_Assigned_List__c`  string , `Dialpad__Powerdialer_Dialed_List__c`  string , `Dialpad__Powerdialer_Last_Dialed_via__c`  string , `Dialpad__Timezone__c`  string , `Dialpad__TotalNumberOfTimesDialed__c`  string , `UConference__UberConferenceId__c`  string , `Tenant_Insurance_CSM_Involved__c`  string , `Testing_Contact__c`  string , `Smartleads_Contact__c`  string , `RND_Last_Purge_Date__c`  string , `RND_Last_Check_Date__c`  string , `Responsibilities__c`  string , `Product_Discovery_Opt_In__c`  string , `Product_Discovery_Comments__c`  string , `Product_Discovery_Feedback_Rating__c`  string , `Total_Relationships__c`  string , `Active_Relationships__c`  string , `HubSpot_Locations__c`  string , `HubSpot_Units__c`  string , `HubSpot_Product_Interest__c`  string , `HubSpot_Web_Comments__c`  string , `IsVIP__c`  string , `MapPhone__c`  string , `Web_Form_Date__c`  string , `HubspotPhone__c`  string , `StorageForum_Username__c`  string , `RecentCampaign__c`  string , `HubspotRecordid__c`  string , `Channel__c`  string , `Transactional_Email_Opt_Out__c`  string , `Live_AC_Facilities__c`  string , `Live_PMS_Facilities__c`  string , `Live_SBOA_Facilities__c`  string , `Live_SE_FMS_Facilities__c`  string , `Live_SE_Web_Facilities__c`  string , `Live_SMS_Facilities__c`  string , `Live_SF_Facilities__c`  string , `Live_SLMS_Facilities__c`  string , `Live_SLWE_Facilities__c`  string , `Live_SP_Facilities__c`  string , `CSL1_Invoice_Recieved__c`  string , `CO_Invoice_Recieved__c`  string , `CSM__c`  string , `smartystreets__In_Batch__c`  string , `smartystreets__MailingVerificationUsed__c`  string , `smartystreets__Mailing_Clean_Street__c`  string , `smartystreets__Mailing_Do_Not_Verify__c`  string , `smartystreets__Mailing_Footnotes__c`  string , `smartystreets__Mailing_Last_Verified__c`  string , `smartystreets__Mailing_Latitude__c`  string , `smartystreets__Mailing_Longitude__c`  string , `smartystreets__Mailing_Return_Code__c`  string , `smartystreets__Mailing_Verified__c`  string , `smartystreets__OtherVerificationUsed__c`  string , `smartystreets__Other_Clean_Street__c`  string , `smartystreets__Other_Do_Not_Verify__c`  string , `smartystreets__Other_Footnotes__c`  string , `smartystreets__Other_Last_Verified__c`  string , `smartystreets__Other_Latitude__c`  string , `smartystreets__Other_Longitude__c`  string , `smartystreets__Other_Return_Code__c`  string , `smartystreets__Other_Verified__c`  string , `ESS_Followup_Date__c`  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-csv-salesforce-dev/raw/contacts/2024-06-10/1718051388'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_contacts"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/contacts/2024-06-10/1718051388
    • id: 4706475
    • processed: 1
    • raw_data: 
      {
    "AccountId": 3,
    "Active_Relationships__c": 212,
    "Address_Type__c": 64,
    "AssistantName": 35,
    "AssistantPhone": 30,
    "Attended__c": 79,
    "Authority__c": 77,
    "Billing_System_Email__c": 151,
    "Billing_System_Sync_Time__c": 152,
    "Birthdate": 37,
    "CO_Invoice_Recieved__c": 237,
    "CP_Hubspot_Record_ID__c": 194,
    "CSAT_Date_Time_Most_Recently_Completed__c": 134,
    "CSAT_Most_Recent_Combined_Score__c": 130,
    "CSAT_Most_Recent_Comment__c": 135,
    "CSAT_Most_Recent_NPS__c": 133,
    "CSAT_Most_Recent_Product_Score__c": 132,
    "CSAT_Most_Recent_Support_Score__c": 131,
    "CSL1_Invoice_Recieved__c": 236,
    "CSM__c": 238,
    "Channel__c": 224,
    "ConnectionReceivedId": 57,
    "ConnectionSentId": 58,
    "Contact_CSM__c": 168,
    "Contact_Info_Confirmed__c": 180,
    "Contact_Name_1__c": 148,
    "Contact_Name_2__c": 149,
    "Contact_Name_3__c": 150,
    "Contact_Outlook_Category__c": 69,
    "CreatedById": 45,
    "CreatedDate": 44,
    "CurrencyIsoCode": 39,
    "Current_Feature_Interest__c": 103,
    "DateTimeLastFormFill__c": 183,
    "Date_Contact_Info_Confirmed__c": 181,
    "Date_Time_Last_Data_Lake_Sync__c": 164,
    "Date_Time_Most_Recent_Imp_CSAT_Completed__c": 176,
    "Department": 34,
    "Description": 38,
    "Dialpad__IsCreatedFromDialpad__c": 195,
    "Dialpad__Powerdialer_Assigned_List__c": 196,
    "Dialpad__Powerdialer_Dialed_List__c": 197,
    "Dialpad__Powerdialer_Last_Dialed_via__c": 198,
    "Dialpad__Timezone__c": 199,
    "Dialpad__TotalNumberOfTimesDialed__c": 200,
    "DoNotCall": 43,
    "Dupe_Check_Master_Record__c": 141,
    "Dupe_Check_Merge_Cohort__c": 142,
    "Dupe_Check_Unique_Matched_ID__c": 140,
    "ESS_Followup_Date__c": 258,
    "Email": 32,
    "EmailBouncedDate": 53,
    "EmailBouncedReason": 52,
    "Email_1__c": 65,
    "Email_2__c": 66,
    "Email_3__c": 67,
    "ExporttoHubspot__c": 71,
    "Fax": 26,
    "FirstName": 5,
    "FormFillRegion__c": 184,
    "FormSource__c": 126,
    "GenderIdentity": 61,
    "Genesys_Phone__c": 144,
    "HasOptedOutOfEmail": 41,
    "HasOptedOutOfFax": 42,
    "HasOptedOutOfMail__c": 72,
    "HomePhone": 28,
    "Home_Phone_1__c": 63,
    "HubSpot_Locations__c": 213,
    "HubSpot_Product_Interest__c": 215,
    "HubSpot_Units__c": 214,
    "HubSpot_Web_Comments__c": 216,
    "HubspotPhone__c": 220,
    "HubspotRecordid__c": 223,
    "IGD__Collection_Id__c": 80,
    "Id": 0,
    "IndividualId": 59,
    "Internal_Referral__c": 122,
    "IsDeleted": 1,
    "IsEmailBounced": 54,
    "IsVIP__c": 217,
    "Jigsaw": 55,
    "JigsawContactId": 56,
    "KronologicCampaigns__c": 128,
    "KronologicStatus__c": 129,
    "LastActivityDate": 49,
    "LastCURequestDate": 50,
    "LastCUUpdateDate": 51,
    "LastModifiedById": 47,
    "LastModifiedDate": 46,
    "LastName": 4,
    "LeadScore__c": 185,
    "LeadSource": 36,
    "Leadliaison__LLBounced__c": 153,
    "Leadliaison__LLFirstTouchCampaignName__c": 154,
    "Leadliaison__LLFirstTouchProgramName__c": 155,
    "Leadliaison__LLLastSearchEngine__c": 156,
    "Leadliaison__LLLastSearchPhrase__c": 157,
    "Leadliaison__LLLastSyncToLeadLiaisonWebApp__c": 158,
    "Leadliaison__LLLastVisitTime__c": 159,
    "Leadliaison__LLLastWebVisit__c": 169,
    "Leadliaison__LLLeadLiaisonGrade__c": 170,
    "Leadliaison__LLLeadLiaisonScore__c": 171,
    "Leadliaison__LLOriginalReferralSource__c": 172,
    "Leadliaison__LLTotalWebVisits__c": 173,
    "Leadliaison__LL_Profile_ID__c": 174,
    "Leadliaison__LL_Total_Activity__c": 175,
    "Live_AC_Facilities__c": 226,
    "Live_ESS_CA_Facilities__c": 160,
    "Live_ESS_FMS_Facilities__c": 161,
    "Live_ESS_SEO_Facilities__c": 162,
    "Live_PMS_Facilities__c": 227,
    "Live_SBOA_Facilities__c": 228,
    "Live_SE_FMS_Facilities__c": 229,
    "Live_SE_Web_Facilities__c": 230,
    "Live_SF_Facilities__c": 232,
    "Live_SLMS_Facilities__c": 233,
    "Live_SLWE_Facilities__c": 234,
    "Live_SMS_Facilities__c": 231,
    "Live_SP_Facilities__c": 235,
    "Live_TPP_Facilities__c": 163,
    "MS_Contact__c": 110,
    "MailingCity": 18,
    "MailingCountry": 21,
    "MailingGeocodeAccuracy": 24,
    "MailingLatitude": 22,
    "MailingLongitude": 23,
    "MailingPostalCode": 20,
    "MailingState": 19,
    "MailingStreet": 17,
    "MapPhone__c": 218,
    "Marketing_Contact_Method__c": 70,
    "Marketing__c": 75,
    "MasterRecordId": 2,
    "Middle_Name__c": 74,
    "MobilePhone": 27,
    "Most_Recent_HubSpot_Message__c": 143,
    "Most_Recent_Imp_CSAT_Comment__c": 178,
    "Most_Recent_Imp_CSAT_Product_Score__c": 179,
    "Most_Recent_Imp_CSAT_Support_Score__c": 182,
    "Most_Recent_Imp_Combined_CSAT_Score__c": 177,
    "MySpareFoot_User_Email__c": 165,
    "MySpareFoot_User_ID__c": 147,
    "MySpareFoot_User_Phone__c": 166,
    "Name": 7,
    "Needs__c": 109,
    "Nickname__c": 139,
    "No_Longer_with_Company__c": 78,
    "NumberOfFormFills__c": 186,
    "Opportunity__c": 138,
    "OtherCity": 10,
    "OtherCountry": 13,
    "OtherGeocodeAccuracy": 16,
    "OtherLatitude": 14,
    "OtherLongitude": 15,
    "OtherPhone": 29,
    "OtherPostalCode": 12,
    "OtherState": 11,
    "OtherStreet": 9,
    "OwnerId": 40,
    "Phone": 25,
    "Phoneextension__c": 125,
    "ProductInterestScoreAC__c": 187,
    "ProductInterestScoreDMS__c": 188,
    "ProductInterestScoreESS__c": 189,
    "ProductInterestScorePC__c": 190,
    "ProductInterestScoreSE__c": 191,
    "ProductInterestScoreSL__c": 192,
    "ProductInterestScoreTPP__c": 193,
    "Product_Discovery_Comments__c": 209,
    "Product_Discovery_Feedback_Rating__c": 210,
    "Product_Discovery_Opt_In__c": 208,
    "Pronouns": 60,
    "RND_Last_Check_Date__c": 206,
    "RND_Last_Purge_Date__c": 205,
    "Receives_Call_Center_API__c": 62,
    "Receives_Reporting_API__c": 68,
    "Receives_SOC_1_Type_2_Report__c": 104,
    "RecentCampaign__c": 222,
    "RecordTypeId": 8,
    "ReportsToId": 31,
    "Responsibilities__c": 207,
    "Salutation": 6,
    "Sent_to_SpareFoot_By__c": 112,
    "Sent_to_SpareFoot__c": 113,
    "Smartleads_Contact__c": 204,
    "SourceLeadID__c": 121,
    "Sparefoot_Lead_Sent__c": 111,
    "StorageForum_Username__c": 221,
    "SystemModstamp": 48,
    "System_of_Origin__c": 167,
    "TIMBASURVEYS__Survey__c": 76,
    "Technical_Contact__c": 73,
    "Tenant_Insurance_CSM_Involved__c": 202,
    "Testing_Contact__c": 203,
    "Title": 33,
    "Total_Launchable_AC_Facilities__c": 145,
    "Total_Relationships__c": 211,
    "Transactional_Email_Opt_Out__c": 225,
    "UConference__UberConferenceId__c": 201,
    "Web_Comments__c": 102,
    "Web_Form_Date__c": 219,
    "Web_Source__c": 124,
    "business_owner_checkbox__c": 107,
    "dupcheck__dc3DisableDuplicateCheck__c": 136,
    "dupcheck__dc3Index__c": 137,
    "of_New_or_Cross_sell_Oppty__c": 146,
    "pi__Needs_Score_Synced__c": 105,
    "pi__Pardot_Last_Scored_At__c": 106,
    "pi__campaign__c": 82,
    "pi__comments__c": 83,
    "pi__conversion_date__c": 84,
    "pi__conversion_object_name__c": 85,
    "pi__conversion_object_type__c": 86,
    "pi__created_date__c": 87,
    "pi__first_activity__c": 88,
    "pi__first_search_term__c": 89,
    "pi__first_search_type__c": 90,
    "pi__first_touch_url__c": 91,
    "pi__grade__c": 92,
    "pi__last_activity__c": 93,
    "pi__notes__c": 94,
    "pi__pardot_hard_bounced__c": 81,
    "pi__score__c": 95,
    "pi__url__c": 96,
    "pi__utm_campaign__c": 97,
    "pi__utm_content__c": 98,
    "pi__utm_medium__c": 99,
    "pi__utm_source__c": 100,
    "pi__utm_term__c": 101,
    "rh2__Currency_Test__c": 118,
    "rh2__Describe__c": 119,
    "rh2__Integer_Test__c": 120,
    "sales_contact__c": 108,
    "smartystreets__In_Batch__c": 239,
    "smartystreets__MailingVerificationUsed__c": 240,
    "smartystreets__Mailing_Clean_Street__c": 241,
    "smartystreets__Mailing_Do_Not_Verify__c": 242,
    "smartystreets__Mailing_Footnotes__c": 243,
    "smartystreets__Mailing_Last_Verified__c": 244,
    "smartystreets__Mailing_Latitude__c": 245,
    "smartystreets__Mailing_Longitude__c": 246,
    "smartystreets__Mailing_Return_Code__c": 247,
    "smartystreets__Mailing_Verified__c": 248,
    "smartystreets__OtherVerificationUsed__c": 249,
    "smartystreets__Other_Clean_Street__c": 250,
    "smartystreets__Other_Do_Not_Verify__c": 251,
    "smartystreets__Other_Footnotes__c": 252,
    "smartystreets__Other_Last_Verified__c": 253,
    "smartystreets__Other_Latitude__c": 254,
    "smartystreets__Other_Longitude__c": 255,
    "smartystreets__Other_Return_Code__c": 256,
    "smartystreets__Other_Verified__c": 257,
    "storEDGE_Salesforce_ID__c": 127,
    "utm_ad__c": 115,
    "utm_campaign__c": 114,
    "utm_keyword__c": 116,
    "utm_medium__c": 123,
    "utm_source__c": 117
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "Active_Relationships__c": "string",
    "Address_Type__c": "string",
    "Amount": "string",
    "AssistantName": "string",
    "AssistantPhone": "string",
    "Attended__c": "string",
    "Authority__c": "string",
    "Billing_System_Email__c": "string",
    "Billing_System_Sync_Time__c": "string",
    "Birthdate": "string",
    "CO_Invoice_Recieved__c": "string",
    "CP_Hubspot_Record_ID__c": "string",
    "CSAT_Date_Time_Most_Recently_Completed__c": "string",
    "CSAT_Most_Recent_Combined_Score__c": "string",
    "CSAT_Most_Recent_Comment__c": "string",
    "CSAT_Most_Recent_NPS__c": "string",
    "CSAT_Most_Recent_Product_Score__c": "string",
    "CSAT_Most_Recent_Support_Score__c": "string",
    "CSL1_Invoice_Recieved__c": "string",
    "CSM__c": "string",
    "Channel__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact_CSM__c": "string",
    "Contact_Info_Confirmed__c": "string",
    "Contact_Name_1__c": "string",
    "Contact_Name_2__c": "string",
    "Contact_Name_3__c": "string",
    "Contact_Outlook_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Current_Feature_Interest__c": "string",
    "DateTimeLastFormFill__c": "string",
    "Date_Contact_Info_Confirmed__c": "string",
    "Date_Time_Last_Data_Lake_Sync__c": "string",
    "Date_Time_Most_Recent_Imp_CSAT_Completed__c": "string",
    "Department": "string",
    "Description": "string",
    "Dialpad__IsCreatedFromDialpad__c": "string",
    "Dialpad__Powerdialer_Assigned_List__c": "string",
    "Dialpad__Powerdialer_Dialed_List__c": "string",
    "Dialpad__Powerdialer_Last_Dialed_via__c": "string",
    "Dialpad__Timezone__c": "string",
    "Dialpad__TotalNumberOfTimesDialed__c": "string",
    "DoNotCall": "string",
    "Dupe_Check_Master_Record__c": "string",
    "Dupe_Check_Merge_Cohort__c": "string",
    "Dupe_Check_Unique_Matched_ID__c": "string",
    "ESS_Followup_Date__c": "string",
    "Email": "string",
    "EmailBouncedDate": "string",
    "EmailBouncedReason": "string",
    "Email_1__c": "string",
    "Email_2__c": "string",
    "Email_3__c": "string",
    "ExpectedRevenue": "string",
    "ExporttoHubspot__c": "string",
    "Fax": "string",
    "FirstName": "string",
    "ForecastCategory": "string",
    "FormFillRegion__c": "string",
    "FormSource__c": "string",
    "GenderIdentity": "string",
    "Genesys_Phone__c": "string",
    "HasOptedOutOfEmail": "string",
    "HasOptedOutOfFax": "string",
    "HasOptedOutOfMail__c": "string",
    "HomePhone": "string",
    "Home_Phone_1__c": "string",
    "HubSpot_Locations__c": "string",
    "HubSpot_Product_Interest__c": "string",
    "HubSpot_Units__c": "string",
    "HubSpot_Web_Comments__c": "string",
    "HubspotPhone__c": "string",
    "HubspotRecordid__c": "string",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "IndividualId": "string",
    "Internal_Referral__c": "string",
    "IsDeleted": "string",
    "IsEmailBounced": "string",
    "IsVIP__c": "string",
    "Jigsaw": "string",
    "JigsawContactId": "string",
    "KronologicCampaigns__c": "string",
    "KronologicStatus__c": "string",
    "LastActivityDate": "string",
    "LastCURequestDate": "string",
    "LastCUUpdateDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LastName": "string",
    "LeadScore__c": "string",
    "LeadSource": "string",
    "Leadliaison__LLBounced__c": "string",
    "Leadliaison__LLFirstTouchCampaignName__c": "string",
    "Leadliaison__LLFirstTouchProgramName__c": "string",
    "Leadliaison__LLLastSearchEngine__c": "string",
    "Leadliaison__LLLastSearchPhrase__c": "string",
    "Leadliaison__LLLastSyncToLeadLiaisonWebApp__c": "string",
    "Leadliaison__LLLastVisitTime__c": "string",
    "Leadliaison__LLLastWebVisit__c": "string",
    "Leadliaison__LLLeadLiaisonGrade__c": "string",
    "Leadliaison__LLLeadLiaisonScore__c": "string",
    "Leadliaison__LLOriginalReferralSource__c": "string",
    "Leadliaison__LLTotalWebVisits__c": "string",
    "Leadliaison__LL_Profile_ID__c": "string",
    "Leadliaison__LL_Total_Activity__c": "string",
    "Live_AC_Facilities__c": "string",
    "Live_ESS_CA_Facilities__c": "string",
    "Live_ESS_FMS_Facilities__c": "string",
    "Live_ESS_SEO_Facilities__c": "string",
    "Live_PMS_Facilities__c": "string",
    "Live_SBOA_Facilities__c": "string",
    "Live_SE_FMS_Facilities__c": "string",
    "Live_SE_Web_Facilities__c": "string",
    "Live_SF_Facilities__c": "string",
    "Live_SLMS_Facilities__c": "string",
    "Live_SLWE_Facilities__c": "string",
    "Live_SMS_Facilities__c": "string",
    "Live_SP_Facilities__c": "string",
    "Live_TPP_Facilities__c": "string",
    "MS_Contact__c": "string",
    "MailingCity": "string",
    "MailingCountry": "string",
    "MailingGeocodeAccuracy": "string",
    "MailingLatitude": "string",
    "MailingLongitude": "string",
    "MailingPostalCode": "string",
    "MailingState": "string",
    "MailingStreet": "string",
    "MapPhone__c": "string",
    "Marketing_Contact_Method__c": "string",
    "Marketing__c": "string",
    "MasterRecordId": "string",
    "Middle_Name__c": "string",
    "MobilePhone": "string",
    "Most_Recent_HubSpot_Message__c": "string",
    "Most_Recent_Imp_CSAT_Comment__c": "string",
    "Most_Recent_Imp_CSAT_Product_Score__c": "string",
    "Most_Recent_Imp_CSAT_Support_Score__c": "string",
    "Most_Recent_Imp_Combined_CSAT_Score__c": "string",
    "MySpareFoot_User_Email__c": "string",
    "MySpareFoot_User_ID__c": "string",
    "MySpareFoot_User_Phone__c": "string",
    "Name": "string",
    "Needs__c": "string",
    "Nickname__c": "string",
    "No_Longer_with_Company__c": "string",
    "NumberOfFormFills__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "OtherCity": "string",
    "OtherCountry": "string",
    "OtherGeocodeAccuracy": "string",
    "OtherLatitude": "string",
    "OtherLongitude": "string",
    "OtherPhone": "string",
    "OtherPostalCode": "string",
    "OtherState": "string",
    "OtherStreet": "string",
    "OwnerId": "string",
    "Phone": "string",
    "Phoneextension__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "ProductInterestScoreAC__c": "string",
    "ProductInterestScoreDMS__c": "string",
    "ProductInterestScoreESS__c": "string",
    "ProductInterestScorePC__c": "string",
    "ProductInterestScoreSE__c": "string",
    "ProductInterestScoreSL__c": "string",
    "ProductInterestScoreTPP__c": "string",
    "Product_Discovery_Comments__c": "string",
    "Product_Discovery_Feedback_Rating__c": "string",
    "Product_Discovery_Opt_In__c": "string",
    "Pronouns": "string",
    "RND_Last_Check_Date__c": "string",
    "RND_Last_Purge_Date__c": "string",
    "Receives_Call_Center_API__c": "string",
    "Receives_Reporting_API__c": "string",
    "Receives_SOC_1_Type_2_Report__c": "string",
    "RecentCampaign__c": "string",
    "RecordTypeId": "string",
    "ReportsToId": "string",
    "Responsibilities__c": "string",
    "Salutation": "string",
    "Sent_to_SpareFoot_By__c": "string",
    "Sent_to_SpareFoot__c": "string",
    "Smartleads_Contact__c": "string",
    "SourceLeadID__c": "string",
    "Sparefoot_Lead_Sent__c": "string",
    "StageName": "string",
    "StorageForum_Username__c": "string",
    "SystemModstamp": "string",
    "System_of_Origin__c": "string",
    "TIMBASURVEYS__Survey__c": "string",
    "Technical_Contact__c": "string",
    "Tenant_Insurance_CSM_Involved__c": "string",
    "Testing_Contact__c": "string",
    "Title": "string",
    "Total_Launchable_AC_Facilities__c": "string",
    "Total_Relationships__c": "string",
    "Transactional_Email_Opt_Out__c": "string",
    "UConference__UberConferenceId__c": "string",
    "VersaPay_Email__c": "string",
    "Versapay_Sync_Time__c": "string",
    "Web_Comments__c": "string",
    "Web_Form_Date__c": "string",
    "Web_Source__c": "string",
    "business_owner_checkbox__c": "string",
    "dupcheck__dc3DisableDuplicateCheck__c": "string",
    "dupcheck__dc3Index__c": "string",
    "of_New_or_Cross_sell_Oppty__c": "string",
    "pi__Needs_Score_Synced__c": "string",
    "pi__Pardot_Last_Scored_At__c": "string",
    "pi__campaign__c": "string",
    "pi__comments__c": "string",
    "pi__conversion_date__c": "string",
    "pi__conversion_object_name__c": "string",
    "pi__conversion_object_type__c": "string",
    "pi__created_date__c": "string",
    "pi__first_activity__c": "string",
    "pi__first_search_term__c": "string",
    "pi__first_search_type__c": "string",
    "pi__first_touch_url__c": "string",
    "pi__grade__c": "string",
    "pi__last_activity__c": "string",
    "pi__notes__c": "string",
    "pi__pardot_hard_bounced__c": "string",
    "pi__score__c": "string",
    "pi__url__c": "string",
    "pi__utm_campaign__c": "string",
    "pi__utm_content__c": "string",
    "pi__utm_medium__c": "string",
    "pi__utm_source__c": "string",
    "pi__utm_term__c": "string",
    "rh2__Currency_Test__c": "string",
    "rh2__Describe__c": "string",
    "rh2__Integer_Test__c": "string",
    "sales_contact__c": "string",
    "smartystreets__In_Batch__c": "string",
    "smartystreets__MailingVerificationUsed__c": "string",
    "smartystreets__Mailing_Clean_Street__c": "string",
    "smartystreets__Mailing_Do_Not_Verify__c": "string",
    "smartystreets__Mailing_Footnotes__c": "string",
    "smartystreets__Mailing_Last_Verified__c": "string",
    "smartystreets__Mailing_Latitude__c": "string",
    "smartystreets__Mailing_Longitude__c": "string",
    "smartystreets__Mailing_Return_Code__c": "string",
    "smartystreets__Mailing_Verified__c": "string",
    "smartystreets__OtherVerificationUsed__c": "string",
    "smartystreets__Other_Clean_Street__c": "string",
    "smartystreets__Other_Do_Not_Verify__c": "string",
    "smartystreets__Other_Footnotes__c": "string",
    "smartystreets__Other_Last_Verified__c": "string",
    "smartystreets__Other_Latitude__c": "string",
    "smartystreets__Other_Longitude__c": "string",
    "smartystreets__Other_Return_Code__c": "string",
    "smartystreets__Other_Verified__c": "string",
    "storEDGE_Salesforce_ID__c": "string",
    "utm_ad__c": "string",
    "utm_campaign__c": "string",
    "utm_keyword__c": "string",
    "utm_medium__c": "string",
    "utm_source__c": "string"
}
    • schema_name_id: 2055
    • schema_scan_id: 6510752
    • updated: 2024-06-10 15:36:07
    • created: 2024-01-11 09:11:25
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_contacts`\n(\n `Id`  string , `IsDeleted`  string , `MasterRecordId`  string , `AccountId`  string , `LastName`  string , `FirstName`  string , `Salutation`  string , `Name`  string , `RecordTypeId`  string , `OtherStreet`  string , `OtherCity`  string , `OtherState`  string , `OtherPostalCode`  string , `OtherCountry`  string , `OtherLatitude`  string , `OtherLongitude`  string , `OtherGeocodeAccuracy`  string , `MailingStreet`  string , `MailingCity`  string , `MailingState`  string , `MailingPostalCode`  string , `MailingCountry`  string , `MailingLatitude`  string , `MailingLongitude`  string , `MailingGeocodeAccuracy`  string , `Phone`  string , `Fax`  string , `MobilePhone`  string , `HomePhone`  string , `OtherPhone`  string , `AssistantPhone`  string , `ReportsToId`  string , `Email`  string , `Title`  string , `Department`  string , `AssistantName`  string , `LeadSource`  string , `Birthdate`  string , `Description`  string , `CurrencyIsoCode`  string , `OwnerId`  string , `HasOptedOutOfEmail`  string , `HasOptedOutOfFax`  string , `DoNotCall`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `LastCURequestDate`  string , `LastCUUpdateDate`  string , `EmailBouncedReason`  string , `EmailBouncedDate`  string , `IsEmailBounced`  string , `Jigsaw`  string , `JigsawContactId`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `IndividualId`  string , `Pronouns`  string , `GenderIdentity`  string , `Receives_Call_Center_API__c`  string , `Home_Phone_1__c`  string , `Address_Type__c`  string , `Email_1__c`  string , `Email_2__c`  string , `Email_3__c`  string , `Receives_Reporting_API__c`  string , `Contact_Outlook_Category__c`  string , `Marketing_Contact_Method__c`  string , `ExporttoHubspot__c`  string , `HasOptedOutOfMail__c`  string , `Technical_Contact__c`  string , `Middle_Name__c`  string , `Marketing__c`  string , `TIMBASURVEYS__Survey__c`  string , `Authority__c`  string , `No_Longer_with_Company__c`  string , `Attended__c`  string , `IGD__Collection_Id__c`  string , `pi__pardot_hard_bounced__c`  string , `pi__campaign__c`  string , `pi__comments__c`  string , `pi__conversion_date__c`  string , `pi__conversion_object_name__c`  string , `pi__conversion_object_type__c`  string , `pi__created_date__c`  string , `pi__first_activity__c`  string , `pi__first_search_term__c`  string , `pi__first_search_type__c`  string , `pi__first_touch_url__c`  string , `pi__grade__c`  string , `pi__last_activity__c`  string , `pi__notes__c`  string , `pi__score__c`  string , `pi__url__c`  string , `pi__utm_campaign__c`  string , `pi__utm_content__c`  string , `pi__utm_medium__c`  string , `pi__utm_source__c`  string , `pi__utm_term__c`  string , `Web_Comments__c`  string , `Current_Feature_Interest__c`  string , `Receives_SOC_1_Type_2_Report__c`  string , `pi__Needs_Score_Synced__c`  string , `pi__Pardot_Last_Scored_At__c`  string , `business_owner_checkbox__c`  string , `sales_contact__c`  string , `Needs__c`  string , `MS_Contact__c`  string , `Sparefoot_Lead_Sent__c`  string , `Sent_to_SpareFoot_By__c`  string , `Sent_to_SpareFoot__c`  string , `utm_campaign__c`  string , `utm_ad__c`  string , `utm_keyword__c`  string , `utm_source__c`  string , `rh2__Currency_Test__c`  string , `rh2__Describe__c`  string , `rh2__Integer_Test__c`  string , `SourceLeadID__c`  string , `Internal_Referral__c`  string , `utm_medium__c`  string , `Web_Source__c`  string , `Phoneextension__c`  string , `FormSource__c`  string , `storEDGE_Salesforce_ID__c`  string , `KronologicCampaigns__c`  string , `KronologicStatus__c`  string , `CSAT_Most_Recent_Combined_Score__c`  string , `CSAT_Most_Recent_Support_Score__c`  string , `CSAT_Most_Recent_Product_Score__c`  string , `CSAT_Most_Recent_NPS__c`  string , `CSAT_Date_Time_Most_Recently_Completed__c`  string , `CSAT_Most_Recent_Comment__c`  string , `dupcheck__dc3DisableDuplicateCheck__c`  string , `dupcheck__dc3Index__c`  string , `Opportunity__c`  string , `Nickname__c`  string , `Dupe_Check_Unique_Matched_ID__c`  string , `Dupe_Check_Master_Record__c`  string , `Dupe_Check_Merge_Cohort__c`  string , `Most_Recent_HubSpot_Message__c`  string , `Genesys_Phone__c`  string , `Total_Launchable_AC_Facilities__c`  string , `of_New_or_Cross_sell_Oppty__c`  string , `MySpareFoot_User_ID__c`  string , `Contact_Name_1__c`  string , `Contact_Name_2__c`  string , `Contact_Name_3__c`  string , `VersaPay_Email__c`  string , `Versapay_Sync_Time__c`  string , `Leadliaison__LLBounced__c`  string , `Leadliaison__LLFirstTouchCampaignName__c`  string , `Leadliaison__LLFirstTouchProgramName__c`  string , `Leadliaison__LLLastSearchEngine__c`  string , `Leadliaison__LLLastSearchPhrase__c`  string , `Leadliaison__LLLastSyncToLeadLiaisonWebApp__c`  string , `Leadliaison__LLLastVisitTime__c`  string , `Live_ESS_CA_Facilities__c`  string , `Live_ESS_FMS_Facilities__c`  string , `Live_ESS_SEO_Facilities__c`  string , `Live_TPP_Facilities__c`  string , `Date_Time_Last_Data_Lake_Sync__c`  string , `MySpareFoot_User_Email__c`  string , `MySpareFoot_User_Phone__c`  string , `System_of_Origin__c`  string , `Contact_CSM__c`  string , `Leadliaison__LLLastWebVisit__c`  string , `Leadliaison__LLLeadLiaisonGrade__c`  string , `Leadliaison__LLLeadLiaisonScore__c`  string , `Leadliaison__LLOriginalReferralSource__c`  string , `Leadliaison__LLTotalWebVisits__c`  string , `Leadliaison__LL_Profile_ID__c`  string , `Leadliaison__LL_Total_Activity__c`  string , `Date_Time_Most_Recent_Imp_CSAT_Completed__c`  string , `Most_Recent_Imp_Combined_CSAT_Score__c`  string , `Most_Recent_Imp_CSAT_Comment__c`  string , `Most_Recent_Imp_CSAT_Product_Score__c`  string , `Contact_Info_Confirmed__c`  string , `Date_Contact_Info_Confirmed__c`  string , `Most_Recent_Imp_CSAT_Support_Score__c`  string , `DateTimeLastFormFill__c`  string , `FormFillRegion__c`  string , `LeadScore__c`  string , `NumberOfFormFills__c`  string , `ProductInterestScoreAC__c`  string , `ProductInterestScoreDMS__c`  string , `ProductInterestScoreESS__c`  string , `ProductInterestScorePC__c`  string , `ProductInterestScoreSE__c`  string , `ProductInterestScoreSL__c`  string , `ProductInterestScoreTPP__c`  string , `CP_Hubspot_Record_ID__c`  string , `Dialpad__IsCreatedFromDialpad__c`  string , `Dialpad__Powerdialer_Assigned_List__c`  string , `Dialpad__Powerdialer_Dialed_List__c`  string , `Dialpad__Powerdialer_Last_Dialed_via__c`  string , `Dialpad__Timezone__c`  string , `Dialpad__TotalNumberOfTimesDialed__c`  string , `UConference__UberConferenceId__c`  string , `Tenant_Insurance_CSM_Involved__c`  string , `Testing_Contact__c`  string , `Smartleads_Contact__c`  string , `RND_Last_Purge_Date__c`  string , `RND_Last_Check_Date__c`  string , `Product_Discovery_Opt_In__c`  string , `Product_Discovery_Comments__c`  string , `Product_Discovery_Feedback_Rating__c`  string , `Total_Relationships__c`  string , `Active_Relationships__c`  string , `HubSpot_Locations__c`  string , `HubSpot_Units__c`  string , `HubSpot_Product_Interest__c`  string , `HubSpot_Web_Comments__c`  string , `IsVIP__c`  string , `MapPhone__c`  string , `Web_Form_Date__c`  string , `HubspotPhone__c`  string , `StorageForum_Username__c`  string , `RecentCampaign__c`  string , `HubspotRecordid__c`  string , `Channel__c`  string , `Transactional_Email_Opt_Out__c`  string , `Live_AC_Facilities__c`  string , `Live_PMS_Facilities__c`  string , `Live_SBOA_Facilities__c`  string , `Live_SE_FMS_Facilities__c`  string , `Live_SE_Web_Facilities__c`  string , `Live_SMS_Facilities__c`  string , `Live_SF_Facilities__c`  string , `Live_SLMS_Facilities__c`  string , `Live_SLWE_Facilities__c`  string , `Live_SP_Facilities__c`  string , `CSL1_Invoice_Recieved__c`  string , `CO_Invoice_Recieved__c`  string , `CSM__c`  string , `smartystreets__In_Batch__c`  string , `smartystreets__MailingVerificationUsed__c`  string , `smartystreets__Mailing_Clean_Street__c`  string , `smartystreets__Mailing_Do_Not_Verify__c`  string , `smartystreets__Mailing_Footnotes__c`  string , `smartystreets__Mailing_Last_Verified__c`  string , `smartystreets__Mailing_Latitude__c`  string , `smartystreets__Mailing_Longitude__c`  string , `smartystreets__Mailing_Return_Code__c`  string , `smartystreets__Mailing_Verified__c`  string , `smartystreets__OtherVerificationUsed__c`  string , `smartystreets__Other_Clean_Street__c`  string , `smartystreets__Other_Do_Not_Verify__c`  string , `smartystreets__Other_Footnotes__c`  string , `smartystreets__Other_Last_Verified__c`  string , `smartystreets__Other_Latitude__c`  string , `smartystreets__Other_Longitude__c`  string , `smartystreets__Other_Return_Code__c`  string , `smartystreets__Other_Verified__c`  string , `ESS_Followup_Date__c`  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-csv-salesforce-dev/raw/contacts/2024-01-11/1704985746'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_contacts"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/contacts/2024-01-11/1704985746
    • id: 4700488
    • processed: 1
    • raw_data: 
      {
    "AccountId": 3,
    "Active_Relationships__c": 211,
    "Address_Type__c": 64,
    "AssistantName": 35,
    "AssistantPhone": 30,
    "Attended__c": 79,
    "Authority__c": 77,
    "Birthdate": 37,
    "CO_Invoice_Recieved__c": 236,
    "CP_Hubspot_Record_ID__c": 194,
    "CSAT_Date_Time_Most_Recently_Completed__c": 134,
    "CSAT_Most_Recent_Combined_Score__c": 130,
    "CSAT_Most_Recent_Comment__c": 135,
    "CSAT_Most_Recent_NPS__c": 133,
    "CSAT_Most_Recent_Product_Score__c": 132,
    "CSAT_Most_Recent_Support_Score__c": 131,
    "CSL1_Invoice_Recieved__c": 235,
    "CSM__c": 237,
    "Channel__c": 223,
    "ConnectionReceivedId": 57,
    "ConnectionSentId": 58,
    "Contact_CSM__c": 168,
    "Contact_Info_Confirmed__c": 180,
    "Contact_Name_1__c": 148,
    "Contact_Name_2__c": 149,
    "Contact_Name_3__c": 150,
    "Contact_Outlook_Category__c": 69,
    "CreatedById": 45,
    "CreatedDate": 44,
    "CurrencyIsoCode": 39,
    "Current_Feature_Interest__c": 103,
    "DateTimeLastFormFill__c": 183,
    "Date_Contact_Info_Confirmed__c": 181,
    "Date_Time_Last_Data_Lake_Sync__c": 164,
    "Date_Time_Most_Recent_Imp_CSAT_Completed__c": 176,
    "Department": 34,
    "Description": 38,
    "Dialpad__IsCreatedFromDialpad__c": 195,
    "Dialpad__Powerdialer_Assigned_List__c": 196,
    "Dialpad__Powerdialer_Dialed_List__c": 197,
    "Dialpad__Powerdialer_Last_Dialed_via__c": 198,
    "Dialpad__Timezone__c": 199,
    "Dialpad__TotalNumberOfTimesDialed__c": 200,
    "DoNotCall": 43,
    "Dupe_Check_Master_Record__c": 141,
    "Dupe_Check_Merge_Cohort__c": 142,
    "Dupe_Check_Unique_Matched_ID__c": 140,
    "ESS_Followup_Date__c": 257,
    "Email": 32,
    "EmailBouncedDate": 53,
    "EmailBouncedReason": 52,
    "Email_1__c": 65,
    "Email_2__c": 66,
    "Email_3__c": 67,
    "ExporttoHubspot__c": 71,
    "Fax": 26,
    "FirstName": 5,
    "FormFillRegion__c": 184,
    "FormSource__c": 126,
    "GenderIdentity": 61,
    "Genesys_Phone__c": 144,
    "HasOptedOutOfEmail": 41,
    "HasOptedOutOfFax": 42,
    "HasOptedOutOfMail__c": 72,
    "HomePhone": 28,
    "Home_Phone_1__c": 63,
    "HubSpot_Locations__c": 212,
    "HubSpot_Product_Interest__c": 214,
    "HubSpot_Units__c": 213,
    "HubSpot_Web_Comments__c": 215,
    "HubspotPhone__c": 219,
    "HubspotRecordid__c": 222,
    "IGD__Collection_Id__c": 80,
    "Id": 0,
    "IndividualId": 59,
    "Internal_Referral__c": 122,
    "IsDeleted": 1,
    "IsEmailBounced": 54,
    "IsVIP__c": 216,
    "Jigsaw": 55,
    "JigsawContactId": 56,
    "KronologicCampaigns__c": 128,
    "KronologicStatus__c": 129,
    "LastActivityDate": 49,
    "LastCURequestDate": 50,
    "LastCUUpdateDate": 51,
    "LastModifiedById": 47,
    "LastModifiedDate": 46,
    "LastName": 4,
    "LeadScore__c": 185,
    "LeadSource": 36,
    "Leadliaison__LLBounced__c": 153,
    "Leadliaison__LLFirstTouchCampaignName__c": 154,
    "Leadliaison__LLFirstTouchProgramName__c": 155,
    "Leadliaison__LLLastSearchEngine__c": 156,
    "Leadliaison__LLLastSearchPhrase__c": 157,
    "Leadliaison__LLLastSyncToLeadLiaisonWebApp__c": 158,
    "Leadliaison__LLLastVisitTime__c": 159,
    "Leadliaison__LLLastWebVisit__c": 169,
    "Leadliaison__LLLeadLiaisonGrade__c": 170,
    "Leadliaison__LLLeadLiaisonScore__c": 171,
    "Leadliaison__LLOriginalReferralSource__c": 172,
    "Leadliaison__LLTotalWebVisits__c": 173,
    "Leadliaison__LL_Profile_ID__c": 174,
    "Leadliaison__LL_Total_Activity__c": 175,
    "Live_AC_Facilities__c": 225,
    "Live_ESS_CA_Facilities__c": 160,
    "Live_ESS_FMS_Facilities__c": 161,
    "Live_ESS_SEO_Facilities__c": 162,
    "Live_PMS_Facilities__c": 226,
    "Live_SBOA_Facilities__c": 227,
    "Live_SE_FMS_Facilities__c": 228,
    "Live_SE_Web_Facilities__c": 229,
    "Live_SF_Facilities__c": 231,
    "Live_SLMS_Facilities__c": 232,
    "Live_SLWE_Facilities__c": 233,
    "Live_SMS_Facilities__c": 230,
    "Live_SP_Facilities__c": 234,
    "Live_TPP_Facilities__c": 163,
    "MS_Contact__c": 110,
    "MailingCity": 18,
    "MailingCountry": 21,
    "MailingGeocodeAccuracy": 24,
    "MailingLatitude": 22,
    "MailingLongitude": 23,
    "MailingPostalCode": 20,
    "MailingState": 19,
    "MailingStreet": 17,
    "MapPhone__c": 217,
    "Marketing_Contact_Method__c": 70,
    "Marketing__c": 75,
    "MasterRecordId": 2,
    "Middle_Name__c": 74,
    "MobilePhone": 27,
    "Most_Recent_HubSpot_Message__c": 143,
    "Most_Recent_Imp_CSAT_Comment__c": 178,
    "Most_Recent_Imp_CSAT_Product_Score__c": 179,
    "Most_Recent_Imp_CSAT_Support_Score__c": 182,
    "Most_Recent_Imp_Combined_CSAT_Score__c": 177,
    "MySpareFoot_User_Email__c": 165,
    "MySpareFoot_User_ID__c": 147,
    "MySpareFoot_User_Phone__c": 166,
    "Name": 7,
    "Needs__c": 109,
    "Nickname__c": 139,
    "No_Longer_with_Company__c": 78,
    "NumberOfFormFills__c": 186,
    "Opportunity__c": 138,
    "OtherCity": 10,
    "OtherCountry": 13,
    "OtherGeocodeAccuracy": 16,
    "OtherLatitude": 14,
    "OtherLongitude": 15,
    "OtherPhone": 29,
    "OtherPostalCode": 12,
    "OtherState": 11,
    "OtherStreet": 9,
    "OwnerId": 40,
    "Phone": 25,
    "Phoneextension__c": 125,
    "ProductInterestScoreAC__c": 187,
    "ProductInterestScoreDMS__c": 188,
    "ProductInterestScoreESS__c": 189,
    "ProductInterestScorePC__c": 190,
    "ProductInterestScoreSE__c": 191,
    "ProductInterestScoreSL__c": 192,
    "ProductInterestScoreTPP__c": 193,
    "Product_Discovery_Comments__c": 208,
    "Product_Discovery_Feedback_Rating__c": 209,
    "Product_Discovery_Opt_In__c": 207,
    "Pronouns": 60,
    "RND_Last_Check_Date__c": 206,
    "RND_Last_Purge_Date__c": 205,
    "Receives_Call_Center_API__c": 62,
    "Receives_Reporting_API__c": 68,
    "Receives_SOC_1_Type_2_Report__c": 104,
    "RecentCampaign__c": 221,
    "RecordTypeId": 8,
    "ReportsToId": 31,
    "Salutation": 6,
    "Sent_to_SpareFoot_By__c": 112,
    "Sent_to_SpareFoot__c": 113,
    "Smartleads_Contact__c": 204,
    "SourceLeadID__c": 121,
    "Sparefoot_Lead_Sent__c": 111,
    "StorageForum_Username__c": 220,
    "SystemModstamp": 48,
    "System_of_Origin__c": 167,
    "TIMBASURVEYS__Survey__c": 76,
    "Technical_Contact__c": 73,
    "Tenant_Insurance_CSM_Involved__c": 202,
    "Testing_Contact__c": 203,
    "Title": 33,
    "Total_Launchable_AC_Facilities__c": 145,
    "Total_Relationships__c": 210,
    "Transactional_Email_Opt_Out__c": 224,
    "UConference__UberConferenceId__c": 201,
    "VersaPay_Email__c": 151,
    "Versapay_Sync_Time__c": 152,
    "Web_Comments__c": 102,
    "Web_Form_Date__c": 218,
    "Web_Source__c": 124,
    "business_owner_checkbox__c": 107,
    "dupcheck__dc3DisableDuplicateCheck__c": 136,
    "dupcheck__dc3Index__c": 137,
    "of_New_or_Cross_sell_Oppty__c": 146,
    "pi__Needs_Score_Synced__c": 105,
    "pi__Pardot_Last_Scored_At__c": 106,
    "pi__campaign__c": 82,
    "pi__comments__c": 83,
    "pi__conversion_date__c": 84,
    "pi__conversion_object_name__c": 85,
    "pi__conversion_object_type__c": 86,
    "pi__created_date__c": 87,
    "pi__first_activity__c": 88,
    "pi__first_search_term__c": 89,
    "pi__first_search_type__c": 90,
    "pi__first_touch_url__c": 91,
    "pi__grade__c": 92,
    "pi__last_activity__c": 93,
    "pi__notes__c": 94,
    "pi__pardot_hard_bounced__c": 81,
    "pi__score__c": 95,
    "pi__url__c": 96,
    "pi__utm_campaign__c": 97,
    "pi__utm_content__c": 98,
    "pi__utm_medium__c": 99,
    "pi__utm_source__c": 100,
    "pi__utm_term__c": 101,
    "rh2__Currency_Test__c": 118,
    "rh2__Describe__c": 119,
    "rh2__Integer_Test__c": 120,
    "sales_contact__c": 108,
    "smartystreets__In_Batch__c": 238,
    "smartystreets__MailingVerificationUsed__c": 239,
    "smartystreets__Mailing_Clean_Street__c": 240,
    "smartystreets__Mailing_Do_Not_Verify__c": 241,
    "smartystreets__Mailing_Footnotes__c": 242,
    "smartystreets__Mailing_Last_Verified__c": 243,
    "smartystreets__Mailing_Latitude__c": 244,
    "smartystreets__Mailing_Longitude__c": 245,
    "smartystreets__Mailing_Return_Code__c": 246,
    "smartystreets__Mailing_Verified__c": 247,
    "smartystreets__OtherVerificationUsed__c": 248,
    "smartystreets__Other_Clean_Street__c": 249,
    "smartystreets__Other_Do_Not_Verify__c": 250,
    "smartystreets__Other_Footnotes__c": 251,
    "smartystreets__Other_Last_Verified__c": 252,
    "smartystreets__Other_Latitude__c": 253,
    "smartystreets__Other_Longitude__c": 254,
    "smartystreets__Other_Return_Code__c": 255,
    "smartystreets__Other_Verified__c": 256,
    "storEDGE_Salesforce_ID__c": 127,
    "utm_ad__c": 115,
    "utm_campaign__c": 114,
    "utm_keyword__c": 116,
    "utm_medium__c": 123,
    "utm_source__c": 117
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "Active_Relationships__c": "string",
    "Address_Type__c": "string",
    "Amount": "string",
    "AssistantName": "string",
    "AssistantPhone": "string",
    "Attended__c": "string",
    "Authority__c": "string",
    "Birthdate": "string",
    "CO_Invoice_Recieved__c": "string",
    "CP_Hubspot_Record_ID__c": "string",
    "CSAT_Date_Time_Most_Recently_Completed__c": "string",
    "CSAT_Most_Recent_Combined_Score__c": "string",
    "CSAT_Most_Recent_Comment__c": "string",
    "CSAT_Most_Recent_NPS__c": "string",
    "CSAT_Most_Recent_Product_Score__c": "string",
    "CSAT_Most_Recent_Support_Score__c": "string",
    "CSL1_Invoice_Recieved__c": "string",
    "CSM__c": "string",
    "Channel__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact_CSM__c": "string",
    "Contact_Info_Confirmed__c": "string",
    "Contact_Name_1__c": "string",
    "Contact_Name_2__c": "string",
    "Contact_Name_3__c": "string",
    "Contact_Outlook_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Current_Feature_Interest__c": "string",
    "DateTimeLastFormFill__c": "string",
    "Date_Contact_Info_Confirmed__c": "string",
    "Date_Time_Last_Data_Lake_Sync__c": "string",
    "Date_Time_Most_Recent_Imp_CSAT_Completed__c": "string",
    "Department": "string",
    "Description": "string",
    "Dialpad__IsCreatedFromDialpad__c": "string",
    "Dialpad__Powerdialer_Assigned_List__c": "string",
    "Dialpad__Powerdialer_Dialed_List__c": "string",
    "Dialpad__Powerdialer_Last_Dialed_via__c": "string",
    "Dialpad__Timezone__c": "string",
    "Dialpad__TotalNumberOfTimesDialed__c": "string",
    "DoNotCall": "string",
    "Dupe_Check_Master_Record__c": "string",
    "Dupe_Check_Merge_Cohort__c": "string",
    "Dupe_Check_Unique_Matched_ID__c": "string",
    "ESS_Followup_Date__c": "string",
    "Email": "string",
    "EmailBouncedDate": "string",
    "EmailBouncedReason": "string",
    "Email_1__c": "string",
    "Email_2__c": "string",
    "Email_3__c": "string",
    "ExpectedRevenue": "string",
    "ExporttoHubspot__c": "string",
    "Fax": "string",
    "FirstName": "string",
    "ForecastCategory": "string",
    "FormFillRegion__c": "string",
    "FormSource__c": "string",
    "GenderIdentity": "string",
    "Genesys_Phone__c": "string",
    "HasOptedOutOfEmail": "string",
    "HasOptedOutOfFax": "string",
    "HasOptedOutOfMail__c": "string",
    "HomePhone": "string",
    "Home_Phone_1__c": "string",
    "HubSpot_Locations__c": "string",
    "HubSpot_Product_Interest__c": "string",
    "HubSpot_Units__c": "string",
    "HubSpot_Web_Comments__c": "string",
    "HubspotPhone__c": "string",
    "HubspotRecordid__c": "string",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "IndividualId": "string",
    "Internal_Referral__c": "string",
    "IsDeleted": "string",
    "IsEmailBounced": "string",
    "IsVIP__c": "string",
    "Jigsaw": "string",
    "JigsawContactId": "string",
    "KronologicCampaigns__c": "string",
    "KronologicStatus__c": "string",
    "LastActivityDate": "string",
    "LastCURequestDate": "string",
    "LastCUUpdateDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LastName": "string",
    "LeadScore__c": "string",
    "LeadSource": "string",
    "Leadliaison__LLBounced__c": "string",
    "Leadliaison__LLFirstTouchCampaignName__c": "string",
    "Leadliaison__LLFirstTouchProgramName__c": "string",
    "Leadliaison__LLLastSearchEngine__c": "string",
    "Leadliaison__LLLastSearchPhrase__c": "string",
    "Leadliaison__LLLastSyncToLeadLiaisonWebApp__c": "string",
    "Leadliaison__LLLastVisitTime__c": "string",
    "Leadliaison__LLLastWebVisit__c": "string",
    "Leadliaison__LLLeadLiaisonGrade__c": "string",
    "Leadliaison__LLLeadLiaisonScore__c": "string",
    "Leadliaison__LLOriginalReferralSource__c": "string",
    "Leadliaison__LLTotalWebVisits__c": "string",
    "Leadliaison__LL_Profile_ID__c": "string",
    "Leadliaison__LL_Total_Activity__c": "string",
    "Live_AC_Facilities__c": "string",
    "Live_ESS_CA_Facilities__c": "string",
    "Live_ESS_FMS_Facilities__c": "string",
    "Live_ESS_SEO_Facilities__c": "string",
    "Live_PMS_Facilities__c": "string",
    "Live_SBOA_Facilities__c": "string",
    "Live_SE_FMS_Facilities__c": "string",
    "Live_SE_Web_Facilities__c": "string",
    "Live_SF_Facilities__c": "string",
    "Live_SLMS_Facilities__c": "string",
    "Live_SLWE_Facilities__c": "string",
    "Live_SMS_Facilities__c": "string",
    "Live_SP_Facilities__c": "string",
    "Live_TPP_Facilities__c": "string",
    "MS_Contact__c": "string",
    "MailingCity": "string",
    "MailingCountry": "string",
    "MailingGeocodeAccuracy": "string",
    "MailingLatitude": "string",
    "MailingLongitude": "string",
    "MailingPostalCode": "string",
    "MailingState": "string",
    "MailingStreet": "string",
    "MapPhone__c": "string",
    "Marketing_Contact_Method__c": "string",
    "Marketing__c": "string",
    "MasterRecordId": "string",
    "Middle_Name__c": "string",
    "MobilePhone": "string",
    "Most_Recent_HubSpot_Message__c": "string",
    "Most_Recent_Imp_CSAT_Comment__c": "string",
    "Most_Recent_Imp_CSAT_Product_Score__c": "string",
    "Most_Recent_Imp_CSAT_Support_Score__c": "string",
    "Most_Recent_Imp_Combined_CSAT_Score__c": "string",
    "MySpareFoot_User_Email__c": "string",
    "MySpareFoot_User_ID__c": "string",
    "MySpareFoot_User_Phone__c": "string",
    "Name": "string",
    "Needs__c": "string",
    "Nickname__c": "string",
    "No_Longer_with_Company__c": "string",
    "NumberOfFormFills__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "OtherCity": "string",
    "OtherCountry": "string",
    "OtherGeocodeAccuracy": "string",
    "OtherLatitude": "string",
    "OtherLongitude": "string",
    "OtherPhone": "string",
    "OtherPostalCode": "string",
    "OtherState": "string",
    "OtherStreet": "string",
    "OwnerId": "string",
    "Phone": "string",
    "Phoneextension__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "ProductInterestScoreAC__c": "string",
    "ProductInterestScoreDMS__c": "string",
    "ProductInterestScoreESS__c": "string",
    "ProductInterestScorePC__c": "string",
    "ProductInterestScoreSE__c": "string",
    "ProductInterestScoreSL__c": "string",
    "ProductInterestScoreTPP__c": "string",
    "Product_Discovery_Comments__c": "string",
    "Product_Discovery_Feedback_Rating__c": "string",
    "Product_Discovery_Opt_In__c": "string",
    "Pronouns": "string",
    "RND_Last_Check_Date__c": "string",
    "RND_Last_Purge_Date__c": "string",
    "Receives_Call_Center_API__c": "string",
    "Receives_Reporting_API__c": "string",
    "Receives_SOC_1_Type_2_Report__c": "string",
    "RecentCampaign__c": "string",
    "RecordTypeId": "string",
    "ReportsToId": "string",
    "Salutation": "string",
    "Sent_to_SpareFoot_By__c": "string",
    "Sent_to_SpareFoot__c": "string",
    "Smartleads_Contact__c": "string",
    "SourceLeadID__c": "string",
    "Sparefoot_Lead_Sent__c": "string",
    "StageName": "string",
    "StorageForum_Username__c": "string",
    "SystemModstamp": "string",
    "System_of_Origin__c": "string",
    "TIMBASURVEYS__Survey__c": "string",
    "Technical_Contact__c": "string",
    "Tenant_Insurance_CSM_Involved__c": "string",
    "Testing_Contact__c": "string",
    "Title": "string",
    "Total_Launchable_AC_Facilities__c": "string",
    "Total_Relationships__c": "string",
    "Transactional_Email_Opt_Out__c": "string",
    "UConference__UberConferenceId__c": "string",
    "VersaPay_Email__c": "string",
    "Versapay_Sync_Time__c": "string",
    "Web_Comments__c": "string",
    "Web_Form_Date__c": "string",
    "Web_Source__c": "string",
    "business_owner_checkbox__c": "string",
    "dupcheck__dc3DisableDuplicateCheck__c": "string",
    "dupcheck__dc3Index__c": "string",
    "of_New_or_Cross_sell_Oppty__c": "string",
    "pi__Needs_Score_Synced__c": "string",
    "pi__Pardot_Last_Scored_At__c": "string",
    "pi__campaign__c": "string",
    "pi__comments__c": "string",
    "pi__conversion_date__c": "string",
    "pi__conversion_object_name__c": "string",
    "pi__conversion_object_type__c": "string",
    "pi__created_date__c": "string",
    "pi__first_activity__c": "string",
    "pi__first_search_term__c": "string",
    "pi__first_search_type__c": "string",
    "pi__first_touch_url__c": "string",
    "pi__grade__c": "string",
    "pi__last_activity__c": "string",
    "pi__notes__c": "string",
    "pi__pardot_hard_bounced__c": "string",
    "pi__score__c": "string",
    "pi__url__c": "string",
    "pi__utm_campaign__c": "string",
    "pi__utm_content__c": "string",
    "pi__utm_medium__c": "string",
    "pi__utm_source__c": "string",
    "pi__utm_term__c": "string",
    "rh2__Currency_Test__c": "string",
    "rh2__Describe__c": "string",
    "rh2__Integer_Test__c": "string",
    "sales_contact__c": "string",
    "smartystreets__In_Batch__c": "string",
    "smartystreets__MailingVerificationUsed__c": "string",
    "smartystreets__Mailing_Clean_Street__c": "string",
    "smartystreets__Mailing_Do_Not_Verify__c": "string",
    "smartystreets__Mailing_Footnotes__c": "string",
    "smartystreets__Mailing_Last_Verified__c": "string",
    "smartystreets__Mailing_Latitude__c": "string",
    "smartystreets__Mailing_Longitude__c": "string",
    "smartystreets__Mailing_Return_Code__c": "string",
    "smartystreets__Mailing_Verified__c": "string",
    "smartystreets__OtherVerificationUsed__c": "string",
    "smartystreets__Other_Clean_Street__c": "string",
    "smartystreets__Other_Do_Not_Verify__c": "string",
    "smartystreets__Other_Footnotes__c": "string",
    "smartystreets__Other_Last_Verified__c": "string",
    "smartystreets__Other_Latitude__c": "string",
    "smartystreets__Other_Longitude__c": "string",
    "smartystreets__Other_Return_Code__c": "string",
    "smartystreets__Other_Verified__c": "string",
    "storEDGE_Salesforce_ID__c": "string",
    "utm_ad__c": "string",
    "utm_campaign__c": "string",
    "utm_keyword__c": "string",
    "utm_medium__c": "string",
    "utm_source__c": "string"
}
    • schema_name_id: 2055
    • schema_scan_id: 6402631
    • updated: 2024-01-11 09:11:39
    • created: 2023-08-16 11:15:38
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_contacts`\n(\n `Id`  string , `IsDeleted`  string , `MasterRecordId`  string , `AccountId`  string , `LastName`  string , `FirstName`  string , `Salutation`  string , `Name`  string , `RecordTypeId`  string , `OtherStreet`  string , `OtherCity`  string , `OtherState`  string , `OtherPostalCode`  string , `OtherCountry`  string , `OtherLatitude`  string , `OtherLongitude`  string , `OtherGeocodeAccuracy`  string , `MailingStreet`  string , `MailingCity`  string , `MailingState`  string , `MailingPostalCode`  string , `MailingCountry`  string , `MailingLatitude`  string , `MailingLongitude`  string , `MailingGeocodeAccuracy`  string , `Phone`  string , `Fax`  string , `MobilePhone`  string , `HomePhone`  string , `OtherPhone`  string , `AssistantPhone`  string , `ReportsToId`  string , `Email`  string , `Title`  string , `Department`  string , `AssistantName`  string , `LeadSource`  string , `Birthdate`  string , `Description`  string , `CurrencyIsoCode`  string , `OwnerId`  string , `HasOptedOutOfEmail`  string , `HasOptedOutOfFax`  string , `DoNotCall`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `LastCURequestDate`  string , `LastCUUpdateDate`  string , `EmailBouncedReason`  string , `EmailBouncedDate`  string , `IsEmailBounced`  string , `Jigsaw`  string , `JigsawContactId`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `IndividualId`  string , `Receives_Call_Center_API__c`  string , `Home_Phone_1__c`  string , `Address_Type__c`  string , `Email_1__c`  string , `Email_2__c`  string , `Email_3__c`  string , `Receives_Reporting_API__c`  string , `Contact_Outlook_Category__c`  string , `Marketing_Contact_Method__c`  string , `ExporttoHubspot__c`  string , `HasOptedOutOfMail__c`  string , `Technical_Contact__c`  string , `Middle_Name__c`  string , `Marketing__c`  string , `TIMBASURVEYS__Survey__c`  string , `Authority__c`  string , `No_Longer_with_Company__c`  string , `Attended__c`  string , `IGD__Collection_Id__c`  string , `pi__pardot_hard_bounced__c`  string , `pi__campaign__c`  string , `pi__comments__c`  string , `pi__conversion_date__c`  string , `pi__conversion_object_name__c`  string , `pi__conversion_object_type__c`  string , `pi__created_date__c`  string , `pi__first_activity__c`  string , `pi__first_search_term__c`  string , `pi__first_search_type__c`  string , `pi__first_touch_url__c`  string , `pi__grade__c`  string , `pi__last_activity__c`  string , `pi__notes__c`  string , `pi__score__c`  string , `pi__url__c`  string , `pi__utm_campaign__c`  string , `pi__utm_content__c`  string , `pi__utm_medium__c`  string , `pi__utm_source__c`  string , `pi__utm_term__c`  string , `Web_Comments__c`  string , `Current_Feature_Interest__c`  string , `Receives_SOC_1_Type_2_Report__c`  string , `pi__Needs_Score_Synced__c`  string , `pi__Pardot_Last_Scored_At__c`  string , `business_owner_checkbox__c`  string , `sales_contact__c`  string , `Needs__c`  string , `MS_Contact__c`  string , `Sparefoot_Lead_Sent__c`  string , `Sent_to_SpareFoot_By__c`  string , `Sent_to_SpareFoot__c`  string , `utm_campaign__c`  string , `utm_ad__c`  string , `utm_keyword__c`  string , `utm_source__c`  string , `rh2__Currency_Test__c`  string , `rh2__Describe__c`  string , `rh2__Integer_Test__c`  string , `SourceLeadID__c`  string , `Internal_Referral__c`  string , `utm_medium__c`  string , `Web_Source__c`  string , `Phoneextension__c`  string , `FormSource__c`  string , `storEDGE_Salesforce_ID__c`  string , `KronologicCampaigns__c`  string , `KronologicStatus__c`  string , `CSAT_Most_Recent_Combined_Score__c`  string , `CSAT_Most_Recent_Support_Score__c`  string , `CSAT_Most_Recent_Product_Score__c`  string , `CSAT_Most_Recent_NPS__c`  string , `CSAT_Date_Time_Most_Recently_Completed__c`  string , `CSAT_Most_Recent_Comment__c`  string , `dupcheck__dc3DisableDuplicateCheck__c`  string , `dupcheck__dc3Index__c`  string , `Opportunity__c`  string , `Nickname__c`  string , `Dupe_Check_Unique_Matched_ID__c`  string , `Dupe_Check_Master_Record__c`  string , `Dupe_Check_Merge_Cohort__c`  string , `Most_Recent_HubSpot_Message__c`  string , `Genesys_Phone__c`  string , `Total_Launchable_AC_Facilities__c`  string , `of_New_or_Cross_sell_Oppty__c`  string , `MySpareFoot_User_ID__c`  string , `Contact_Name_1__c`  string , `Contact_Name_2__c`  string , `Contact_Name_3__c`  string , `VersaPay_Email__c`  string , `Versapay_Sync_Time__c`  string , `Leadliaison__LLBounced__c`  string , `Leadliaison__LLFirstTouchCampaignName__c`  string , `Leadliaison__LLFirstTouchProgramName__c`  string , `Leadliaison__LLLastSearchEngine__c`  string , `Leadliaison__LLLastSearchPhrase__c`  string , `Leadliaison__LLLastSyncToLeadLiaisonWebApp__c`  string , `Leadliaison__LLLastVisitTime__c`  string , `Live_ESS_CA_Facilities__c`  string , `Live_ESS_FMS_Facilities__c`  string , `Live_ESS_SEO_Facilities__c`  string , `Live_TPP_Facilities__c`  string , `Date_Time_Last_Data_Lake_Sync__c`  string , `MySpareFoot_User_Email__c`  string , `MySpareFoot_User_Phone__c`  string , `System_of_Origin__c`  string , `Contact_CSM__c`  string , `Leadliaison__LLLastWebVisit__c`  string , `Leadliaison__LLLeadLiaisonGrade__c`  string , `Leadliaison__LLLeadLiaisonScore__c`  string , `Leadliaison__LLOriginalReferralSource__c`  string , `Leadliaison__LLTotalWebVisits__c`  string , `Leadliaison__LL_Profile_ID__c`  string , `Leadliaison__LL_Total_Activity__c`  string , `Date_Time_Most_Recent_Imp_CSAT_Completed__c`  string , `Most_Recent_Imp_Combined_CSAT_Score__c`  string , `Most_Recent_Imp_CSAT_Comment__c`  string , `Most_Recent_Imp_CSAT_Product_Score__c`  string , `Contact_Info_Confirmed__c`  string , `Date_Contact_Info_Confirmed__c`  string , `Most_Recent_Imp_CSAT_Support_Score__c`  string , `Product_Discovery_Opt_In__c`  string , `Product_Discovery_Comments__c`  string , `Product_Discovery_Feedback_Rating__c`  string , `Total_Relationships__c`  string , `Active_Relationships__c`  string , `HubSpot_Locations__c`  string , `HubSpot_Units__c`  string , `HubSpot_Product_Interest__c`  string , `HubSpot_Web_Comments__c`  string , `IsVIP__c`  string , `MapPhone__c`  string , `Web_Form_Date__c`  string , `HubspotPhone__c`  string , `StorageForum_Username__c`  string , `RecentCampaign__c`  string , `HubspotRecordid__c`  string , `Channel__c`  string , `Transactional_Email_Opt_Out__c`  string , `Live_AC_Facilities__c`  string , `Live_PMS_Facilities__c`  string , `Live_SBOA_Facilities__c`  string , `Live_SE_FMS_Facilities__c`  string , `Live_SE_Web_Facilities__c`  string , `Live_SMS_Facilities__c`  string , `Live_SF_Facilities__c`  string , `Live_SLMS_Facilities__c`  string , `Live_SLWE_Facilities__c`  string , `Live_SP_Facilities__c`  string , `CSL1_Invoice_Recieved__c`  string , `CO_Invoice_Recieved__c`  string , `CSM__c`  string , `smartystreets__In_Batch__c`  string , `smartystreets__MailingVerificationUsed__c`  string , `smartystreets__Mailing_Clean_Street__c`  string , `smartystreets__Mailing_Do_Not_Verify__c`  string , `smartystreets__Mailing_Footnotes__c`  string , `smartystreets__Mailing_Last_Verified__c`  string , `smartystreets__Mailing_Latitude__c`  string , `smartystreets__Mailing_Longitude__c`  string , `smartystreets__Mailing_Return_Code__c`  string , `smartystreets__Mailing_Verified__c`  string , `smartystreets__OtherVerificationUsed__c`  string , `smartystreets__Other_Clean_Street__c`  string , `smartystreets__Other_Do_Not_Verify__c`  string , `smartystreets__Other_Footnotes__c`  string , `smartystreets__Other_Last_Verified__c`  string , `smartystreets__Other_Latitude__c`  string , `smartystreets__Other_Longitude__c`  string , `smartystreets__Other_Return_Code__c`  string , `smartystreets__Other_Verified__c`  string , `ESS_Followup_Date__c`  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-csv-salesforce-dev/raw/contacts/2023-08-16/1692202302'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_contacts"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/contacts/2023-08-16/1692202302
    • id: 4697502
    • processed: 1
    • raw_data: 
      {
    "AccountId": 3,
    "Active_Relationships__c": 185,
    "Address_Type__c": 62,
    "AssistantName": 35,
    "AssistantPhone": 30,
    "Attended__c": 77,
    "Authority__c": 75,
    "Birthdate": 37,
    "CO_Invoice_Recieved__c": 210,
    "CSAT_Date_Time_Most_Recently_Completed__c": 132,
    "CSAT_Most_Recent_Combined_Score__c": 128,
    "CSAT_Most_Recent_Comment__c": 133,
    "CSAT_Most_Recent_NPS__c": 131,
    "CSAT_Most_Recent_Product_Score__c": 130,
    "CSAT_Most_Recent_Support_Score__c": 129,
    "CSL1_Invoice_Recieved__c": 209,
    "CSM__c": 211,
    "Channel__c": 197,
    "ConnectionReceivedId": 57,
    "ConnectionSentId": 58,
    "Contact_CSM__c": 166,
    "Contact_Info_Confirmed__c": 178,
    "Contact_Name_1__c": 146,
    "Contact_Name_2__c": 147,
    "Contact_Name_3__c": 148,
    "Contact_Outlook_Category__c": 67,
    "CreatedById": 45,
    "CreatedDate": 44,
    "CurrencyIsoCode": 39,
    "Current_Feature_Interest__c": 101,
    "Date_Contact_Info_Confirmed__c": 179,
    "Date_Time_Last_Data_Lake_Sync__c": 162,
    "Date_Time_Most_Recent_Imp_CSAT_Completed__c": 174,
    "Department": 34,
    "Description": 38,
    "DoNotCall": 43,
    "Dupe_Check_Master_Record__c": 139,
    "Dupe_Check_Merge_Cohort__c": 140,
    "Dupe_Check_Unique_Matched_ID__c": 138,
    "ESS_Followup_Date__c": 231,
    "Email": 32,
    "EmailBouncedDate": 53,
    "EmailBouncedReason": 52,
    "Email_1__c": 63,
    "Email_2__c": 64,
    "Email_3__c": 65,
    "ExporttoHubspot__c": 69,
    "Fax": 26,
    "FirstName": 5,
    "FormSource__c": 124,
    "Genesys_Phone__c": 142,
    "HasOptedOutOfEmail": 41,
    "HasOptedOutOfFax": 42,
    "HasOptedOutOfMail__c": 70,
    "HomePhone": 28,
    "Home_Phone_1__c": 61,
    "HubSpot_Locations__c": 186,
    "HubSpot_Product_Interest__c": 188,
    "HubSpot_Units__c": 187,
    "HubSpot_Web_Comments__c": 189,
    "HubspotPhone__c": 193,
    "HubspotRecordid__c": 196,
    "IGD__Collection_Id__c": 78,
    "Id": 0,
    "IndividualId": 59,
    "Internal_Referral__c": 120,
    "IsDeleted": 1,
    "IsEmailBounced": 54,
    "IsVIP__c": 190,
    "Jigsaw": 55,
    "JigsawContactId": 56,
    "KronologicCampaigns__c": 126,
    "KronologicStatus__c": 127,
    "LastActivityDate": 49,
    "LastCURequestDate": 50,
    "LastCUUpdateDate": 51,
    "LastModifiedById": 47,
    "LastModifiedDate": 46,
    "LastName": 4,
    "LeadSource": 36,
    "Leadliaison__LLBounced__c": 151,
    "Leadliaison__LLFirstTouchCampaignName__c": 152,
    "Leadliaison__LLFirstTouchProgramName__c": 153,
    "Leadliaison__LLLastSearchEngine__c": 154,
    "Leadliaison__LLLastSearchPhrase__c": 155,
    "Leadliaison__LLLastSyncToLeadLiaisonWebApp__c": 156,
    "Leadliaison__LLLastVisitTime__c": 157,
    "Leadliaison__LLLastWebVisit__c": 167,
    "Leadliaison__LLLeadLiaisonGrade__c": 168,
    "Leadliaison__LLLeadLiaisonScore__c": 169,
    "Leadliaison__LLOriginalReferralSource__c": 170,
    "Leadliaison__LLTotalWebVisits__c": 171,
    "Leadliaison__LL_Profile_ID__c": 172,
    "Leadliaison__LL_Total_Activity__c": 173,
    "Live_AC_Facilities__c": 199,
    "Live_ESS_CA_Facilities__c": 158,
    "Live_ESS_FMS_Facilities__c": 159,
    "Live_ESS_SEO_Facilities__c": 160,
    "Live_PMS_Facilities__c": 200,
    "Live_SBOA_Facilities__c": 201,
    "Live_SE_FMS_Facilities__c": 202,
    "Live_SE_Web_Facilities__c": 203,
    "Live_SF_Facilities__c": 205,
    "Live_SLMS_Facilities__c": 206,
    "Live_SLWE_Facilities__c": 207,
    "Live_SMS_Facilities__c": 204,
    "Live_SP_Facilities__c": 208,
    "Live_TPP_Facilities__c": 161,
    "MS_Contact__c": 108,
    "MailingCity": 18,
    "MailingCountry": 21,
    "MailingGeocodeAccuracy": 24,
    "MailingLatitude": 22,
    "MailingLongitude": 23,
    "MailingPostalCode": 20,
    "MailingState": 19,
    "MailingStreet": 17,
    "MapPhone__c": 191,
    "Marketing_Contact_Method__c": 68,
    "Marketing__c": 73,
    "MasterRecordId": 2,
    "Middle_Name__c": 72,
    "MobilePhone": 27,
    "Most_Recent_HubSpot_Message__c": 141,
    "Most_Recent_Imp_CSAT_Comment__c": 176,
    "Most_Recent_Imp_CSAT_Product_Score__c": 177,
    "Most_Recent_Imp_CSAT_Support_Score__c": 180,
    "Most_Recent_Imp_Combined_CSAT_Score__c": 175,
    "MySpareFoot_User_Email__c": 163,
    "MySpareFoot_User_ID__c": 145,
    "MySpareFoot_User_Phone__c": 164,
    "Name": 7,
    "Needs__c": 107,
    "Nickname__c": 137,
    "No_Longer_with_Company__c": 76,
    "Opportunity__c": 136,
    "OtherCity": 10,
    "OtherCountry": 13,
    "OtherGeocodeAccuracy": 16,
    "OtherLatitude": 14,
    "OtherLongitude": 15,
    "OtherPhone": 29,
    "OtherPostalCode": 12,
    "OtherState": 11,
    "OtherStreet": 9,
    "OwnerId": 40,
    "Phone": 25,
    "Phoneextension__c": 123,
    "Product_Discovery_Comments__c": 182,
    "Product_Discovery_Feedback_Rating__c": 183,
    "Product_Discovery_Opt_In__c": 181,
    "Receives_Call_Center_API__c": 60,
    "Receives_Reporting_API__c": 66,
    "Receives_SOC_1_Type_2_Report__c": 102,
    "RecentCampaign__c": 195,
    "RecordTypeId": 8,
    "ReportsToId": 31,
    "Salutation": 6,
    "Sent_to_SpareFoot_By__c": 110,
    "Sent_to_SpareFoot__c": 111,
    "SourceLeadID__c": 119,
    "Sparefoot_Lead_Sent__c": 109,
    "StorageForum_Username__c": 194,
    "SystemModstamp": 48,
    "System_of_Origin__c": 165,
    "TIMBASURVEYS__Survey__c": 74,
    "Technical_Contact__c": 71,
    "Title": 33,
    "Total_Launchable_AC_Facilities__c": 143,
    "Total_Relationships__c": 184,
    "Transactional_Email_Opt_Out__c": 198,
    "VersaPay_Email__c": 149,
    "Versapay_Sync_Time__c": 150,
    "Web_Comments__c": 100,
    "Web_Form_Date__c": 192,
    "Web_Source__c": 122,
    "business_owner_checkbox__c": 105,
    "dupcheck__dc3DisableDuplicateCheck__c": 134,
    "dupcheck__dc3Index__c": 135,
    "of_New_or_Cross_sell_Oppty__c": 144,
    "pi__Needs_Score_Synced__c": 103,
    "pi__Pardot_Last_Scored_At__c": 104,
    "pi__campaign__c": 80,
    "pi__comments__c": 81,
    "pi__conversion_date__c": 82,
    "pi__conversion_object_name__c": 83,
    "pi__conversion_object_type__c": 84,
    "pi__created_date__c": 85,
    "pi__first_activity__c": 86,
    "pi__first_search_term__c": 87,
    "pi__first_search_type__c": 88,
    "pi__first_touch_url__c": 89,
    "pi__grade__c": 90,
    "pi__last_activity__c": 91,
    "pi__notes__c": 92,
    "pi__pardot_hard_bounced__c": 79,
    "pi__score__c": 93,
    "pi__url__c": 94,
    "pi__utm_campaign__c": 95,
    "pi__utm_content__c": 96,
    "pi__utm_medium__c": 97,
    "pi__utm_source__c": 98,
    "pi__utm_term__c": 99,
    "rh2__Currency_Test__c": 116,
    "rh2__Describe__c": 117,
    "rh2__Integer_Test__c": 118,
    "sales_contact__c": 106,
    "smartystreets__In_Batch__c": 212,
    "smartystreets__MailingVerificationUsed__c": 213,
    "smartystreets__Mailing_Clean_Street__c": 214,
    "smartystreets__Mailing_Do_Not_Verify__c": 215,
    "smartystreets__Mailing_Footnotes__c": 216,
    "smartystreets__Mailing_Last_Verified__c": 217,
    "smartystreets__Mailing_Latitude__c": 218,
    "smartystreets__Mailing_Longitude__c": 219,
    "smartystreets__Mailing_Return_Code__c": 220,
    "smartystreets__Mailing_Verified__c": 221,
    "smartystreets__OtherVerificationUsed__c": 222,
    "smartystreets__Other_Clean_Street__c": 223,
    "smartystreets__Other_Do_Not_Verify__c": 224,
    "smartystreets__Other_Footnotes__c": 225,
    "smartystreets__Other_Last_Verified__c": 226,
    "smartystreets__Other_Latitude__c": 227,
    "smartystreets__Other_Longitude__c": 228,
    "smartystreets__Other_Return_Code__c": 229,
    "smartystreets__Other_Verified__c": 230,
    "storEDGE_Salesforce_ID__c": 125,
    "utm_ad__c": 113,
    "utm_campaign__c": 112,
    "utm_keyword__c": 114,
    "utm_medium__c": 121,
    "utm_source__c": 115
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "Active_Relationships__c": "string",
    "Address_Type__c": "string",
    "Amount": "string",
    "AssistantName": "string",
    "AssistantPhone": "string",
    "Attended__c": "string",
    "Authority__c": "string",
    "Birthdate": "string",
    "CO_Invoice_Recieved__c": "string",
    "CSAT_Date_Time_Most_Recently_Completed__c": "string",
    "CSAT_Most_Recent_Combined_Score__c": "string",
    "CSAT_Most_Recent_Comment__c": "string",
    "CSAT_Most_Recent_NPS__c": "string",
    "CSAT_Most_Recent_Product_Score__c": "string",
    "CSAT_Most_Recent_Support_Score__c": "string",
    "CSL1_Invoice_Recieved__c": "string",
    "CSM__c": "string",
    "Channel__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact_CSM__c": "string",
    "Contact_Info_Confirmed__c": "string",
    "Contact_Name_1__c": "string",
    "Contact_Name_2__c": "string",
    "Contact_Name_3__c": "string",
    "Contact_Outlook_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Current_Feature_Interest__c": "string",
    "Date_Contact_Info_Confirmed__c": "string",
    "Date_Time_Last_Data_Lake_Sync__c": "string",
    "Date_Time_Most_Recent_Imp_CSAT_Completed__c": "string",
    "Department": "string",
    "Description": "string",
    "DoNotCall": "string",
    "Dupe_Check_Master_Record__c": "string",
    "Dupe_Check_Merge_Cohort__c": "string",
    "Dupe_Check_Unique_Matched_ID__c": "string",
    "ESS_Followup_Date__c": "string",
    "Email": "string",
    "EmailBouncedDate": "string",
    "EmailBouncedReason": "string",
    "Email_1__c": "string",
    "Email_2__c": "string",
    "Email_3__c": "string",
    "ExpectedRevenue": "string",
    "ExporttoHubspot__c": "string",
    "Fax": "string",
    "FirstName": "string",
    "ForecastCategory": "string",
    "FormSource__c": "string",
    "Genesys_Phone__c": "string",
    "HasOptedOutOfEmail": "string",
    "HasOptedOutOfFax": "string",
    "HasOptedOutOfMail__c": "string",
    "HomePhone": "string",
    "Home_Phone_1__c": "string",
    "HubSpot_Locations__c": "string",
    "HubSpot_Product_Interest__c": "string",
    "HubSpot_Units__c": "string",
    "HubSpot_Web_Comments__c": "string",
    "HubspotPhone__c": "string",
    "HubspotRecordid__c": "string",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "IndividualId": "string",
    "Internal_Referral__c": "string",
    "IsDeleted": "string",
    "IsEmailBounced": "string",
    "IsVIP__c": "string",
    "Jigsaw": "string",
    "JigsawContactId": "string",
    "KronologicCampaigns__c": "string",
    "KronologicStatus__c": "string",
    "LastActivityDate": "string",
    "LastCURequestDate": "string",
    "LastCUUpdateDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LastName": "string",
    "LeadSource": "string",
    "Leadliaison__LLBounced__c": "string",
    "Leadliaison__LLFirstTouchCampaignName__c": "string",
    "Leadliaison__LLFirstTouchProgramName__c": "string",
    "Leadliaison__LLLastSearchEngine__c": "string",
    "Leadliaison__LLLastSearchPhrase__c": "string",
    "Leadliaison__LLLastSyncToLeadLiaisonWebApp__c": "string",
    "Leadliaison__LLLastVisitTime__c": "string",
    "Leadliaison__LLLastWebVisit__c": "string",
    "Leadliaison__LLLeadLiaisonGrade__c": "string",
    "Leadliaison__LLLeadLiaisonScore__c": "string",
    "Leadliaison__LLOriginalReferralSource__c": "string",
    "Leadliaison__LLTotalWebVisits__c": "string",
    "Leadliaison__LL_Profile_ID__c": "string",
    "Leadliaison__LL_Total_Activity__c": "string",
    "Live_AC_Facilities__c": "string",
    "Live_ESS_CA_Facilities__c": "string",
    "Live_ESS_FMS_Facilities__c": "string",
    "Live_ESS_SEO_Facilities__c": "string",
    "Live_PMS_Facilities__c": "string",
    "Live_SBOA_Facilities__c": "string",
    "Live_SE_FMS_Facilities__c": "string",
    "Live_SE_Web_Facilities__c": "string",
    "Live_SF_Facilities__c": "string",
    "Live_SLMS_Facilities__c": "string",
    "Live_SLWE_Facilities__c": "string",
    "Live_SMS_Facilities__c": "string",
    "Live_SP_Facilities__c": "string",
    "Live_TPP_Facilities__c": "string",
    "MS_Contact__c": "string",
    "MailingCity": "string",
    "MailingCountry": "string",
    "MailingGeocodeAccuracy": "string",
    "MailingLatitude": "string",
    "MailingLongitude": "string",
    "MailingPostalCode": "string",
    "MailingState": "string",
    "MailingStreet": "string",
    "MapPhone__c": "string",
    "Marketing_Contact_Method__c": "string",
    "Marketing__c": "string",
    "MasterRecordId": "string",
    "Middle_Name__c": "string",
    "MobilePhone": "string",
    "Most_Recent_HubSpot_Message__c": "string",
    "Most_Recent_Imp_CSAT_Comment__c": "string",
    "Most_Recent_Imp_CSAT_Product_Score__c": "string",
    "Most_Recent_Imp_CSAT_Support_Score__c": "string",
    "Most_Recent_Imp_Combined_CSAT_Score__c": "string",
    "MySpareFoot_User_Email__c": "string",
    "MySpareFoot_User_ID__c": "string",
    "MySpareFoot_User_Phone__c": "string",
    "Name": "string",
    "Needs__c": "string",
    "Nickname__c": "string",
    "No_Longer_with_Company__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "OtherCity": "string",
    "OtherCountry": "string",
    "OtherGeocodeAccuracy": "string",
    "OtherLatitude": "string",
    "OtherLongitude": "string",
    "OtherPhone": "string",
    "OtherPostalCode": "string",
    "OtherState": "string",
    "OtherStreet": "string",
    "OwnerId": "string",
    "Phone": "string",
    "Phoneextension__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Discovery_Comments__c": "string",
    "Product_Discovery_Feedback_Rating__c": "string",
    "Product_Discovery_Opt_In__c": "string",
    "Receives_Call_Center_API__c": "string",
    "Receives_Reporting_API__c": "string",
    "Receives_SOC_1_Type_2_Report__c": "string",
    "RecentCampaign__c": "string",
    "RecordTypeId": "string",
    "ReportsToId": "string",
    "Salutation": "string",
    "Sent_to_SpareFoot_By__c": "string",
    "Sent_to_SpareFoot__c": "string",
    "SourceLeadID__c": "string",
    "Sparefoot_Lead_Sent__c": "string",
    "StageName": "string",
    "StorageForum_Username__c": "string",
    "SystemModstamp": "string",
    "System_of_Origin__c": "string",
    "TIMBASURVEYS__Survey__c": "string",
    "Technical_Contact__c": "string",
    "Title": "string",
    "Total_Launchable_AC_Facilities__c": "string",
    "Total_Relationships__c": "string",
    "Transactional_Email_Opt_Out__c": "string",
    "VersaPay_Email__c": "string",
    "Versapay_Sync_Time__c": "string",
    "Web_Comments__c": "string",
    "Web_Form_Date__c": "string",
    "Web_Source__c": "string",
    "business_owner_checkbox__c": "string",
    "dupcheck__dc3DisableDuplicateCheck__c": "string",
    "dupcheck__dc3Index__c": "string",
    "of_New_or_Cross_sell_Oppty__c": "string",
    "pi__Needs_Score_Synced__c": "string",
    "pi__Pardot_Last_Scored_At__c": "string",
    "pi__campaign__c": "string",
    "pi__comments__c": "string",
    "pi__conversion_date__c": "string",
    "pi__conversion_object_name__c": "string",
    "pi__conversion_object_type__c": "string",
    "pi__created_date__c": "string",
    "pi__first_activity__c": "string",
    "pi__first_search_term__c": "string",
    "pi__first_search_type__c": "string",
    "pi__first_touch_url__c": "string",
    "pi__grade__c": "string",
    "pi__last_activity__c": "string",
    "pi__notes__c": "string",
    "pi__pardot_hard_bounced__c": "string",
    "pi__score__c": "string",
    "pi__url__c": "string",
    "pi__utm_campaign__c": "string",
    "pi__utm_content__c": "string",
    "pi__utm_medium__c": "string",
    "pi__utm_source__c": "string",
    "pi__utm_term__c": "string",
    "rh2__Currency_Test__c": "string",
    "rh2__Describe__c": "string",
    "rh2__Integer_Test__c": "string",
    "sales_contact__c": "string",
    "smartystreets__In_Batch__c": "string",
    "smartystreets__MailingVerificationUsed__c": "string",
    "smartystreets__Mailing_Clean_Street__c": "string",
    "smartystreets__Mailing_Do_Not_Verify__c": "string",
    "smartystreets__Mailing_Footnotes__c": "string",
    "smartystreets__Mailing_Last_Verified__c": "string",
    "smartystreets__Mailing_Latitude__c": "string",
    "smartystreets__Mailing_Longitude__c": "string",
    "smartystreets__Mailing_Return_Code__c": "string",
    "smartystreets__Mailing_Verified__c": "string",
    "smartystreets__OtherVerificationUsed__c": "string",
    "smartystreets__Other_Clean_Street__c": "string",
    "smartystreets__Other_Do_Not_Verify__c": "string",
    "smartystreets__Other_Footnotes__c": "string",
    "smartystreets__Other_Last_Verified__c": "string",
    "smartystreets__Other_Latitude__c": "string",
    "smartystreets__Other_Longitude__c": "string",
    "smartystreets__Other_Return_Code__c": "string",
    "smartystreets__Other_Verified__c": "string",
    "storEDGE_Salesforce_ID__c": "string",
    "utm_ad__c": "string",
    "utm_campaign__c": "string",
    "utm_keyword__c": "string",
    "utm_medium__c": "string",
    "utm_source__c": "string"
}
    • schema_name_id: 2055
    • schema_scan_id: 6251507
    • updated: 2023-08-16 11:15:50
    • created: 2023-08-16 10:28:13
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_contacts`\n(\n `Id`  string , `IsDeleted`  string , `MasterRecordId`  string , `AccountId`  string , `LastName`  string , `FirstName`  string , `Salutation`  string , `Name`  string , `RecordTypeId`  string , `OtherStreet`  string , `OtherCity`  string , `OtherState`  string , `OtherPostalCode`  string , `OtherCountry`  string , `OtherLatitude`  string , `OtherLongitude`  string , `OtherGeocodeAccuracy`  string , `MailingStreet`  string , `MailingCity`  string , `MailingState`  string , `MailingPostalCode`  string , `MailingCountry`  string , `MailingLatitude`  string , `MailingLongitude`  string , `MailingGeocodeAccuracy`  string , `Phone`  string , `Fax`  string , `MobilePhone`  string , `HomePhone`  string , `OtherPhone`  string , `AssistantPhone`  string , `ReportsToId`  string , `Email`  string , `Title`  string , `Department`  string , `AssistantName`  string , `LeadSource`  string , `Birthdate`  string , `Description`  string , `CurrencyIsoCode`  string , `OwnerId`  string , `HasOptedOutOfEmail`  string , `HasOptedOutOfFax`  string , `DoNotCall`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `LastCURequestDate`  string , `LastCUUpdateDate`  string , `EmailBouncedReason`  string , `EmailBouncedDate`  string , `IsEmailBounced`  string , `Jigsaw`  string , `JigsawContactId`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `IndividualId`  string , `Receives_Call_Center_API__c`  string , `Home_Phone_1__c`  string , `Address_Type__c`  string , `Email_1__c`  string , `Email_2__c`  string , `Email_3__c`  string , `Receives_Reporting_API__c`  string , `Contact_Outlook_Category__c`  string , `Marketing_Contact_Method__c`  string , `ExporttoHubspot__c`  string , `HasOptedOutOfMail__c`  string , `Technical_Contact__c`  string , `Middle_Name__c`  string , `Marketing__c`  string , `TIMBASURVEYS__Survey__c`  string , `Authority__c`  string , `No_Longer_with_Company__c`  string , `Attended__c`  string , `IGD__Collection_Id__c`  string , `pi__pardot_hard_bounced__c`  string , `pi__campaign__c`  string , `pi__comments__c`  string , `pi__conversion_date__c`  string , `pi__conversion_object_name__c`  string , `pi__conversion_object_type__c`  string , `pi__created_date__c`  string , `pi__first_activity__c`  string , `pi__first_search_term__c`  string , `pi__first_search_type__c`  string , `pi__first_touch_url__c`  string , `pi__grade__c`  string , `pi__last_activity__c`  string , `pi__notes__c`  string , `pi__score__c`  string , `pi__url__c`  string , `pi__utm_campaign__c`  string , `pi__utm_content__c`  string , `pi__utm_medium__c`  string , `pi__utm_source__c`  string , `pi__utm_term__c`  string , `Web_Comments__c`  string , `Current_Feature_Interest__c`  string , `Receives_SOC_1_Type_2_Report__c`  string , `pi__Needs_Score_Synced__c`  string , `pi__Pardot_Last_Scored_At__c`  string , `business_owner_checkbox__c`  string , `sales_contact__c`  string , `Needs__c`  string , `MS_Contact__c`  string , `Sparefoot_Lead_Sent__c`  string , `Sent_to_SpareFoot_By__c`  string , `Sent_to_SpareFoot__c`  string , `utm_campaign__c`  string , `utm_ad__c`  string , `utm_keyword__c`  string , `utm_source__c`  string , `rh2__Currency_Test__c`  string , `rh2__Describe__c`  string , `rh2__Integer_Test__c`  string , `SourceLeadID__c`  string , `Internal_Referral__c`  string , `utm_medium__c`  string , `Web_Source__c`  string , `Phoneextension__c`  string , `FormSource__c`  string , `storEDGE_Salesforce_ID__c`  string , `KronologicCampaigns__c`  string , `KronologicStatus__c`  string , `CSAT_Most_Recent_Combined_Score__c`  string , `CSAT_Most_Recent_Support_Score__c`  string , `CSAT_Most_Recent_Product_Score__c`  string , `CSAT_Most_Recent_NPS__c`  string , `CSAT_Date_Time_Most_Recently_Completed__c`  string , `CSAT_Most_Recent_Comment__c`  string , `dupcheck__dc3DisableDuplicateCheck__c`  string , `dupcheck__dc3Index__c`  string , `Opportunity__c`  string , `Nickname__c`  string , `Dupe_Check_Unique_Matched_ID__c`  string , `Dupe_Check_Master_Record__c`  string , `Dupe_Check_Merge_Cohort__c`  string , `Most_Recent_HubSpot_Message__c`  string , `Genesys_Phone__c`  string , `Total_Launchable_AC_Facilities__c`  string , `of_New_or_Cross_sell_Oppty__c`  string , `MySpareFoot_User_ID__c`  string , `Contact_Name_1__c`  string , `Contact_Name_2__c`  string , `Contact_Name_3__c`  string , `VersaPay_Email__c`  string , `Versapay_Sync_Time__c`  string , `Leadliaison__LLBounced__c`  string , `Leadliaison__LLFirstTouchCampaignName__c`  string , `Leadliaison__LLFirstTouchProgramName__c`  string , `Leadliaison__LLLastSearchEngine__c`  string , `Leadliaison__LLLastSearchPhrase__c`  string , `Leadliaison__LLLastSyncToLeadLiaisonWebApp__c`  string , `Leadliaison__LLLastVisitTime__c`  string , `Live_ESS_CA_Facilities__c`  string , `Live_ESS_FMS_Facilities__c`  string , `Live_ESS_SEO_Facilities__c`  string , `Live_TPP_Facilities__c`  string , `Date_Time_Last_Data_Lake_Sync__c`  string , `MySpareFoot_User_Email__c`  string , `MySpareFoot_User_Phone__c`  string , `System_of_Origin__c`  string , `Contact_CSM__c`  string , `Leadliaison__LLLastWebVisit__c`  string , `Leadliaison__LLLeadLiaisonGrade__c`  string , `Leadliaison__LLLeadLiaisonScore__c`  string , `Leadliaison__LLOriginalReferralSource__c`  string , `Leadliaison__LLTotalWebVisits__c`  string , `Leadliaison__LL_Profile_ID__c`  string , `Leadliaison__LL_Total_Activity__c`  string , `Date_Time_Most_Recent_Imp_CSAT_Completed__c`  string , `Most_Recent_Imp_Combined_CSAT_Score__c`  string , `Most_Recent_Imp_CSAT_Comment__c`  string , `Most_Recent_Imp_CSAT_Product_Score__c`  string , `Contact_Info_Confirmed__c`  string , `Date_Contact_Info_Confirmed__c`  string , `Most_Recent_Imp_CSAT_Support_Score__c`  string , `Product_Discovery_Opt_In__c`  string , `Product_Discovery_Comments__c`  string , `Product_Discovery_Feedback_Rating__c`  string , `Total_Relationships__c`  string , `Active_Relationships__c`  string , `HubSpot_Locations__c`  string , `HubSpot_Units__c`  string , `HubSpot_Product_Interest__c`  string , `HubSpot_Web_Comments__c`  string , `IsVIP__c`  string , `MapPhone__c`  string , `Web_Form_Date__c`  string , `HubspotPhone__c`  string , `StorageForum_Username__c`  string , `RecentCampaign__c`  string , `HubspotRecordid__c`  string , `Channel__c`  string , `Transactional_Email_Opt_Out__c`  string , `Live_AC_Facilities__c`  string , `Live_PMS_Facilities__c`  string , `Live_SBOA_Facilities__c`  string , `Live_SE_FMS_Facilities__c`  string , `Live_SE_Web_Facilities__c`  string , `Live_SMS_Facilities__c`  string , `Live_SF_Facilities__c`  string , `Live_SLMS_Facilities__c`  string , `Live_SLWE_Facilities__c`  string , `Live_SP_Facilities__c`  string , `CSL1_Invoice_Recieved__c`  string , `CO_Invoice_Recieved__c`  string , `CSM__c`  string , `smartystreets__In_Batch__c`  string , `smartystreets__MailingVerificationUsed__c`  string , `smartystreets__Mailing_Clean_Street__c`  string , `smartystreets__Mailing_Do_Not_Verify__c`  string , `smartystreets__Mailing_Footnotes__c`  string , `smartystreets__Mailing_Last_Verified__c`  string , `smartystreets__Mailing_Latitude__c`  string , `smartystreets__Mailing_Longitude__c`  string , `smartystreets__Mailing_Return_Code__c`  string , `smartystreets__Mailing_Verified__c`  string , `smartystreets__OtherVerificationUsed__c`  string , `smartystreets__Other_Clean_Street__c`  string , `smartystreets__Other_Do_Not_Verify__c`  string , `smartystreets__Other_Footnotes__c`  string , `smartystreets__Other_Last_Verified__c`  string , `smartystreets__Other_Latitude__c`  string , `smartystreets__Other_Longitude__c`  string , `smartystreets__Other_Return_Code__c`  string , `smartystreets__Other_Verified__c`  string , `ESS_Followup_Date__c`  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-csv-salesforce-dev/raw/contacts/2023-08-16/1692199558'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_contacts"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/contacts/2023-08-16/1692199558
    • id: 4697432
    • processed: 1
    • raw_data: 
      {
    "AccountId": 3,
    "Active_Relationships__c": 185,
    "Address_Type__c": 62,
    "AssistantName": 35,
    "AssistantPhone": 30,
    "Attended__c": 77,
    "Authority__c": 75,
    "Birthdate": 37,
    "CO_Invoice_Recieved__c": 210,
    "CSAT_Date_Time_Most_Recently_Completed__c": 132,
    "CSAT_Most_Recent_Combined_Score__c": 128,
    "CSAT_Most_Recent_Comment__c": 133,
    "CSAT_Most_Recent_NPS__c": 131,
    "CSAT_Most_Recent_Product_Score__c": 130,
    "CSAT_Most_Recent_Support_Score__c": 129,
    "CSL1_Invoice_Recieved__c": 209,
    "CSM__c": 211,
    "Channel__c": 197,
    "ConnectionReceivedId": 57,
    "ConnectionSentId": 58,
    "Contact_CSM__c": 166,
    "Contact_Info_Confirmed__c": 178,
    "Contact_Name_1__c": 146,
    "Contact_Name_2__c": 147,
    "Contact_Name_3__c": 148,
    "Contact_Outlook_Category__c": 67,
    "CreatedById": 45,
    "CreatedDate": 44,
    "CurrencyIsoCode": 39,
    "Current_Feature_Interest__c": 101,
    "Date_Contact_Info_Confirmed__c": 179,
    "Date_Time_Last_Data_Lake_Sync__c": 162,
    "Date_Time_Most_Recent_Imp_CSAT_Completed__c": 174,
    "Department": 34,
    "Description": 38,
    "DoNotCall": 43,
    "Dupe_Check_Master_Record__c": 139,
    "Dupe_Check_Merge_Cohort__c": 140,
    "Dupe_Check_Unique_Matched_ID__c": 138,
    "ESS_Followup_Date__c": 231,
    "Email": 32,
    "EmailBouncedDate": 53,
    "EmailBouncedReason": 52,
    "Email_1__c": 63,
    "Email_2__c": 64,
    "Email_3__c": 65,
    "ExporttoHubspot__c": 69,
    "Fax": 26,
    "FirstName": 5,
    "FormSource__c": 124,
    "Genesys_Phone__c": 142,
    "HasOptedOutOfEmail": 41,
    "HasOptedOutOfFax": 42,
    "HasOptedOutOfMail__c": 70,
    "HomePhone": 28,
    "Home_Phone_1__c": 61,
    "HubSpot_Locations__c": 186,
    "HubSpot_Product_Interest__c": 188,
    "HubSpot_Units__c": 187,
    "HubSpot_Web_Comments__c": 189,
    "HubspotPhone__c": 193,
    "HubspotRecordid__c": 196,
    "IGD__Collection_Id__c": 78,
    "Id": 0,
    "IndividualId": 59,
    "Internal_Referral__c": 120,
    "IsDeleted": 1,
    "IsEmailBounced": 54,
    "IsVIP__c": 190,
    "Jigsaw": 55,
    "JigsawContactId": 56,
    "KronologicCampaigns__c": 126,
    "KronologicStatus__c": 127,
    "LastActivityDate": 49,
    "LastCURequestDate": 50,
    "LastCUUpdateDate": 51,
    "LastModifiedById": 47,
    "LastModifiedDate": 46,
    "LastName": 4,
    "LeadSource": 36,
    "Leadliaison__LLBounced__c": 151,
    "Leadliaison__LLFirstTouchCampaignName__c": 152,
    "Leadliaison__LLFirstTouchProgramName__c": 153,
    "Leadliaison__LLLastSearchEngine__c": 154,
    "Leadliaison__LLLastSearchPhrase__c": 155,
    "Leadliaison__LLLastSyncToLeadLiaisonWebApp__c": 156,
    "Leadliaison__LLLastVisitTime__c": 157,
    "Leadliaison__LLLastWebVisit__c": 167,
    "Leadliaison__LLLeadLiaisonGrade__c": 168,
    "Leadliaison__LLLeadLiaisonScore__c": 169,
    "Leadliaison__LLOriginalReferralSource__c": 170,
    "Leadliaison__LLTotalWebVisits__c": 171,
    "Leadliaison__LL_Profile_ID__c": 172,
    "Leadliaison__LL_Total_Activity__c": 173,
    "Live_AC_Facilities__c": 199,
    "Live_ESS_CA_Facilities__c": 158,
    "Live_ESS_FMS_Facilities__c": 159,
    "Live_ESS_SEO_Facilities__c": 160,
    "Live_PMS_Facilities__c": 200,
    "Live_SBOA_Facilities__c": 201,
    "Live_SE_FMS_Facilities__c": 202,
    "Live_SE_Web_Facilities__c": 203,
    "Live_SF_Facilities__c": 205,
    "Live_SLMS_Facilities__c": 206,
    "Live_SLWE_Facilities__c": 207,
    "Live_SMS_Facilities__c": 204,
    "Live_SP_Facilities__c": 208,
    "Live_TPP_Facilities__c": 161,
    "MS_Contact__c": 108,
    "MailingCity": 18,
    "MailingCountry": 21,
    "MailingGeocodeAccuracy": 24,
    "MailingLatitude": 22,
    "MailingLongitude": 23,
    "MailingPostalCode": 20,
    "MailingState": 19,
    "MailingStreet": 17,
    "MapPhone__c": 191,
    "Marketing_Contact_Method__c": 68,
    "Marketing__c": 73,
    "MasterRecordId": 2,
    "Middle_Name__c": 72,
    "MobilePhone": 27,
    "Most_Recent_HubSpot_Message__c": 141,
    "Most_Recent_Imp_CSAT_Comment__c": 176,
    "Most_Recent_Imp_CSAT_Product_Score__c": 177,
    "Most_Recent_Imp_CSAT_Support_Score__c": 180,
    "Most_Recent_Imp_Combined_CSAT_Score__c": 175,
    "MySpareFoot_User_Email__c": 163,
    "MySpareFoot_User_ID__c": 145,
    "MySpareFoot_User_Phone__c": 164,
    "Name": 7,
    "Needs__c": 107,
    "Nickname__c": 137,
    "No_Longer_with_Company__c": 76,
    "Opportunity__c": 136,
    "OtherCity": 10,
    "OtherCountry": 13,
    "OtherGeocodeAccuracy": 16,
    "OtherLatitude": 14,
    "OtherLongitude": 15,
    "OtherPhone": 29,
    "OtherPostalCode": 12,
    "OtherState": 11,
    "OtherStreet": 9,
    "OwnerId": 40,
    "Phone": 25,
    "Phoneextension__c": 123,
    "Product_Discovery_Comments__c": 182,
    "Product_Discovery_Feedback_Rating__c": 183,
    "Product_Discovery_Opt_In__c": 181,
    "Receives_Call_Center_API__c": 60,
    "Receives_Reporting_API__c": 66,
    "Receives_SOC_1_Type_2_Report__c": 102,
    "RecentCampaign__c": 195,
    "RecordTypeId": 8,
    "ReportsToId": 31,
    "Salutation": 6,
    "Sent_to_SpareFoot_By__c": 110,
    "Sent_to_SpareFoot__c": 111,
    "SourceLeadID__c": 119,
    "Sparefoot_Lead_Sent__c": 109,
    "StorageForum_Username__c": 194,
    "SystemModstamp": 48,
    "System_of_Origin__c": 165,
    "TIMBASURVEYS__Survey__c": 74,
    "Technical_Contact__c": 71,
    "Title": 33,
    "Total_Launchable_AC_Facilities__c": 143,
    "Total_Relationships__c": 184,
    "Transactional_Email_Opt_Out__c": 198,
    "VersaPay_Email__c": 149,
    "Versapay_Sync_Time__c": 150,
    "Web_Comments__c": 100,
    "Web_Form_Date__c": 192,
    "Web_Source__c": 122,
    "business_owner_checkbox__c": 105,
    "dupcheck__dc3DisableDuplicateCheck__c": 134,
    "dupcheck__dc3Index__c": 135,
    "of_New_or_Cross_sell_Oppty__c": 144,
    "pi__Needs_Score_Synced__c": 103,
    "pi__Pardot_Last_Scored_At__c": 104,
    "pi__campaign__c": 80,
    "pi__comments__c": 81,
    "pi__conversion_date__c": 82,
    "pi__conversion_object_name__c": 83,
    "pi__conversion_object_type__c": 84,
    "pi__created_date__c": 85,
    "pi__first_activity__c": 86,
    "pi__first_search_term__c": 87,
    "pi__first_search_type__c": 88,
    "pi__first_touch_url__c": 89,
    "pi__grade__c": 90,
    "pi__last_activity__c": 91,
    "pi__notes__c": 92,
    "pi__pardot_hard_bounced__c": 79,
    "pi__score__c": 93,
    "pi__url__c": 94,
    "pi__utm_campaign__c": 95,
    "pi__utm_content__c": 96,
    "pi__utm_medium__c": 97,
    "pi__utm_source__c": 98,
    "pi__utm_term__c": 99,
    "rh2__Currency_Test__c": 116,
    "rh2__Describe__c": 117,
    "rh2__Integer_Test__c": 118,
    "sales_contact__c": 106,
    "smartystreets__In_Batch__c": 212,
    "smartystreets__MailingVerificationUsed__c": 213,
    "smartystreets__Mailing_Clean_Street__c": 214,
    "smartystreets__Mailing_Do_Not_Verify__c": 215,
    "smartystreets__Mailing_Footnotes__c": 216,
    "smartystreets__Mailing_Last_Verified__c": 217,
    "smartystreets__Mailing_Latitude__c": 218,
    "smartystreets__Mailing_Longitude__c": 219,
    "smartystreets__Mailing_Return_Code__c": 220,
    "smartystreets__Mailing_Verified__c": 221,
    "smartystreets__OtherVerificationUsed__c": 222,
    "smartystreets__Other_Clean_Street__c": 223,
    "smartystreets__Other_Do_Not_Verify__c": 224,
    "smartystreets__Other_Footnotes__c": 225,
    "smartystreets__Other_Last_Verified__c": 226,
    "smartystreets__Other_Latitude__c": 227,
    "smartystreets__Other_Longitude__c": 228,
    "smartystreets__Other_Return_Code__c": 229,
    "smartystreets__Other_Verified__c": 230,
    "storEDGE_Salesforce_ID__c": 125,
    "utm_ad__c": 113,
    "utm_campaign__c": 112,
    "utm_keyword__c": 114,
    "utm_medium__c": 121,
    "utm_source__c": 115
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "Active_Relationships__c": "string",
    "Address_Type__c": "string",
    "Amount": "string",
    "AssistantName": "string",
    "AssistantPhone": "string",
    "Attended__c": "string",
    "Authority__c": "string",
    "Birthdate": "string",
    "CO_Invoice_Recieved__c": "string",
    "CSAT_Date_Time_Most_Recently_Completed__c": "string",
    "CSAT_Most_Recent_Combined_Score__c": "string",
    "CSAT_Most_Recent_Comment__c": "string",
    "CSAT_Most_Recent_NPS__c": "string",
    "CSAT_Most_Recent_Product_Score__c": "string",
    "CSAT_Most_Recent_Support_Score__c": "string",
    "CSL1_Invoice_Recieved__c": "string",
    "CSM__c": "string",
    "Channel__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact_CSM__c": "string",
    "Contact_Info_Confirmed__c": "string",
    "Contact_Name_1__c": "string",
    "Contact_Name_2__c": "string",
    "Contact_Name_3__c": "string",
    "Contact_Outlook_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Current_Feature_Interest__c": "string",
    "Date_Contact_Info_Confirmed__c": "string",
    "Date_Time_Last_Data_Lake_Sync__c": "string",
    "Date_Time_Most_Recent_Imp_CSAT_Completed__c": "string",
    "Department": "string",
    "Description": "string",
    "DoNotCall": "string",
    "Dupe_Check_Master_Record__c": "string",
    "Dupe_Check_Merge_Cohort__c": "string",
    "Dupe_Check_Unique_Matched_ID__c": "string",
    "ESS_Followup_Date__c": "string",
    "Email": "string",
    "EmailBouncedDate": "string",
    "EmailBouncedReason": "string",
    "Email_1__c": "string",
    "Email_2__c": "string",
    "Email_3__c": "string",
    "ExpectedRevenue": "string",
    "ExporttoHubspot__c": "string",
    "Fax": "string",
    "FirstName": "string",
    "ForecastCategory": "string",
    "FormSource__c": "string",
    "Genesys_Phone__c": "string",
    "HasOptedOutOfEmail": "string",
    "HasOptedOutOfFax": "string",
    "HasOptedOutOfMail__c": "string",
    "HomePhone": "string",
    "Home_Phone_1__c": "string",
    "HubSpot_Locations__c": "string",
    "HubSpot_Product_Interest__c": "string",
    "HubSpot_Units__c": "string",
    "HubSpot_Web_Comments__c": "string",
    "HubspotPhone__c": "string",
    "HubspotRecordid__c": "string",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "IndividualId": "string",
    "Internal_Referral__c": "string",
    "IsDeleted": "string",
    "IsEmailBounced": "string",
    "IsVIP__c": "string",
    "Jigsaw": "string",
    "JigsawContactId": "string",
    "KronologicCampaigns__c": "string",
    "KronologicStatus__c": "string",
    "LastActivityDate": "string",
    "LastCURequestDate": "string",
    "LastCUUpdateDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LastName": "string",
    "LeadSource": "string",
    "Leadliaison__LLBounced__c": "string",
    "Leadliaison__LLFirstTouchCampaignName__c": "string",
    "Leadliaison__LLFirstTouchProgramName__c": "string",
    "Leadliaison__LLLastSearchEngine__c": "string",
    "Leadliaison__LLLastSearchPhrase__c": "string",
    "Leadliaison__LLLastSyncToLeadLiaisonWebApp__c": "string",
    "Leadliaison__LLLastVisitTime__c": "string",
    "Leadliaison__LLLastWebVisit__c": "string",
    "Leadliaison__LLLeadLiaisonGrade__c": "string",
    "Leadliaison__LLLeadLiaisonScore__c": "string",
    "Leadliaison__LLOriginalReferralSource__c": "string",
    "Leadliaison__LLTotalWebVisits__c": "string",
    "Leadliaison__LL_Profile_ID__c": "string",
    "Leadliaison__LL_Total_Activity__c": "string",
    "Live_AC_Facilities__c": "string",
    "Live_ESS_CA_Facilities__c": "string",
    "Live_ESS_FMS_Facilities__c": "string",
    "Live_ESS_SEO_Facilities__c": "string",
    "Live_PMS_Facilities__c": "string",
    "Live_SBOA_Facilities__c": "string",
    "Live_SE_FMS_Facilities__c": "string",
    "Live_SE_Web_Facilities__c": "string",
    "Live_SF_Facilities__c": "string",
    "Live_SLMS_Facilities__c": "string",
    "Live_SLWE_Facilities__c": "string",
    "Live_SMS_Facilities__c": "string",
    "Live_SP_Facilities__c": "string",
    "Live_TPP_Facilities__c": "string",
    "MS_Contact__c": "string",
    "MailingCity": "string",
    "MailingCountry": "string",
    "MailingGeocodeAccuracy": "string",
    "MailingLatitude": "string",
    "MailingLongitude": "string",
    "MailingPostalCode": "string",
    "MailingState": "string",
    "MailingStreet": "string",
    "MapPhone__c": "string",
    "Marketing_Contact_Method__c": "string",
    "Marketing__c": "string",
    "MasterRecordId": "string",
    "Middle_Name__c": "string",
    "MobilePhone": "string",
    "Most_Recent_HubSpot_Message__c": "string",
    "Most_Recent_Imp_CSAT_Comment__c": "string",
    "Most_Recent_Imp_CSAT_Product_Score__c": "string",
    "Most_Recent_Imp_CSAT_Support_Score__c": "string",
    "Most_Recent_Imp_Combined_CSAT_Score__c": "string",
    "MySpareFoot_User_Email__c": "string",
    "MySpareFoot_User_ID__c": "string",
    "MySpareFoot_User_Phone__c": "string",
    "Name": "string",
    "Needs__c": "string",
    "Nickname__c": "string",
    "No_Longer_with_Company__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "OtherCity": "string",
    "OtherCountry": "string",
    "OtherGeocodeAccuracy": "string",
    "OtherLatitude": "string",
    "OtherLongitude": "string",
    "OtherPhone": "string",
    "OtherPostalCode": "string",
    "OtherState": "string",
    "OtherStreet": "string",
    "OwnerId": "string",
    "Phone": "string",
    "Phoneextension__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Discovery_Comments__c": "string",
    "Product_Discovery_Feedback_Rating__c": "string",
    "Product_Discovery_Opt_In__c": "string",
    "Receives_Call_Center_API__c": "string",
    "Receives_Reporting_API__c": "string",
    "Receives_SOC_1_Type_2_Report__c": "string",
    "RecentCampaign__c": "string",
    "RecordTypeId": "string",
    "ReportsToId": "string",
    "Salutation": "string",
    "Sent_to_SpareFoot_By__c": "string",
    "Sent_to_SpareFoot__c": "string",
    "SourceLeadID__c": "string",
    "Sparefoot_Lead_Sent__c": "string",
    "StageName": "string",
    "StorageForum_Username__c": "string",
    "SystemModstamp": "string",
    "System_of_Origin__c": "string",
    "TIMBASURVEYS__Survey__c": "string",
    "Technical_Contact__c": "string",
    "Title": "string",
    "Total_Launchable_AC_Facilities__c": "string",
    "Total_Relationships__c": "string",
    "Transactional_Email_Opt_Out__c": "string",
    "VersaPay_Email__c": "string",
    "Versapay_Sync_Time__c": "string",
    "Web_Comments__c": "string",
    "Web_Form_Date__c": "string",
    "Web_Source__c": "string",
    "business_owner_checkbox__c": "string",
    "dupcheck__dc3DisableDuplicateCheck__c": "string",
    "dupcheck__dc3Index__c": "string",
    "of_New_or_Cross_sell_Oppty__c": "string",
    "pi__Needs_Score_Synced__c": "string",
    "pi__Pardot_Last_Scored_At__c": "string",
    "pi__campaign__c": "string",
    "pi__comments__c": "string",
    "pi__conversion_date__c": "string",
    "pi__conversion_object_name__c": "string",
    "pi__conversion_object_type__c": "string",
    "pi__created_date__c": "string",
    "pi__first_activity__c": "string",
    "pi__first_search_term__c": "string",
    "pi__first_search_type__c": "string",
    "pi__first_touch_url__c": "string",
    "pi__grade__c": "string",
    "pi__last_activity__c": "string",
    "pi__notes__c": "string",
    "pi__pardot_hard_bounced__c": "string",
    "pi__score__c": "string",
    "pi__url__c": "string",
    "pi__utm_campaign__c": "string",
    "pi__utm_content__c": "string",
    "pi__utm_medium__c": "string",
    "pi__utm_source__c": "string",
    "pi__utm_term__c": "string",
    "rh2__Currency_Test__c": "string",
    "rh2__Describe__c": "string",
    "rh2__Integer_Test__c": "string",
    "sales_contact__c": "string",
    "smartystreets__In_Batch__c": "string",
    "smartystreets__MailingVerificationUsed__c": "string",
    "smartystreets__Mailing_Clean_Street__c": "string",
    "smartystreets__Mailing_Do_Not_Verify__c": "string",
    "smartystreets__Mailing_Footnotes__c": "string",
    "smartystreets__Mailing_Last_Verified__c": "string",
    "smartystreets__Mailing_Latitude__c": "string",
    "smartystreets__Mailing_Longitude__c": "string",
    "smartystreets__Mailing_Return_Code__c": "string",
    "smartystreets__Mailing_Verified__c": "string",
    "smartystreets__OtherVerificationUsed__c": "string",
    "smartystreets__Other_Clean_Street__c": "string",
    "smartystreets__Other_Do_Not_Verify__c": "string",
    "smartystreets__Other_Footnotes__c": "string",
    "smartystreets__Other_Last_Verified__c": "string",
    "smartystreets__Other_Latitude__c": "string",
    "smartystreets__Other_Longitude__c": "string",
    "smartystreets__Other_Return_Code__c": "string",
    "smartystreets__Other_Verified__c": "string",
    "storEDGE_Salesforce_ID__c": "string",
    "utm_ad__c": "string",
    "utm_campaign__c": "string",
    "utm_keyword__c": "string",
    "utm_medium__c": "string",
    "utm_source__c": "string"
}
    • schema_name_id: 2055
    • schema_scan_id: 6251359
    • updated: 2023-08-16 10:28:24
    • created: 2023-08-16 09:31:42
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_contacts`\n(\n `Id`  string , `IsDeleted`  string , `MasterRecordId`  string , `AccountId`  string , `LastName`  string , `FirstName`  string , `Salutation`  string , `Name`  string , `RecordTypeId`  string , `OtherStreet`  string , `OtherCity`  string , `OtherState`  string , `OtherPostalCode`  string , `OtherCountry`  string , `OtherLatitude`  string , `OtherLongitude`  string , `OtherGeocodeAccuracy`  string , `MailingStreet`  string , `MailingCity`  string , `MailingState`  string , `MailingPostalCode`  string , `MailingCountry`  string , `MailingLatitude`  string , `MailingLongitude`  string , `MailingGeocodeAccuracy`  string , `Phone`  string , `Fax`  string , `MobilePhone`  string , `HomePhone`  string , `OtherPhone`  string , `AssistantPhone`  string , `ReportsToId`  string , `Email`  string , `Title`  string , `Department`  string , `AssistantName`  string , `LeadSource`  string , `Birthdate`  string , `Description`  string , `CurrencyIsoCode`  string , `OwnerId`  string , `HasOptedOutOfEmail`  string , `HasOptedOutOfFax`  string , `DoNotCall`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `LastCURequestDate`  string , `LastCUUpdateDate`  string , `EmailBouncedReason`  string , `EmailBouncedDate`  string , `IsEmailBounced`  string , `Jigsaw`  string , `JigsawContactId`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `IndividualId`  string , `Receives_Call_Center_API__c`  string , `Home_Phone_1__c`  string , `Address_Type__c`  string , `Email_1__c`  string , `Email_2__c`  string , `Email_3__c`  string , `Receives_Reporting_API__c`  string , `Contact_Outlook_Category__c`  string , `Marketing_Contact_Method__c`  string , `ExporttoHubspot__c`  string , `HasOptedOutOfMail__c`  string , `Technical_Contact__c`  string , `Middle_Name__c`  string , `Marketing__c`  string , `TIMBASURVEYS__Survey__c`  string , `Authority__c`  string , `No_Longer_with_Company__c`  string , `Attended__c`  string , `IGD__Collection_Id__c`  string , `pi__pardot_hard_bounced__c`  string , `pi__campaign__c`  string , `pi__comments__c`  string , `pi__conversion_date__c`  string , `pi__conversion_object_name__c`  string , `pi__conversion_object_type__c`  string , `pi__created_date__c`  string , `pi__first_activity__c`  string , `pi__first_search_term__c`  string , `pi__first_search_type__c`  string , `pi__first_touch_url__c`  string , `pi__grade__c`  string , `pi__last_activity__c`  string , `pi__notes__c`  string , `pi__score__c`  string , `pi__url__c`  string , `pi__utm_campaign__c`  string , `pi__utm_content__c`  string , `pi__utm_medium__c`  string , `pi__utm_source__c`  string , `pi__utm_term__c`  string , `Web_Comments__c`  string , `Current_Feature_Interest__c`  string , `Receives_SOC_1_Type_2_Report__c`  string , `pi__Needs_Score_Synced__c`  string , `pi__Pardot_Last_Scored_At__c`  string , `business_owner_checkbox__c`  string , `sales_contact__c`  string , `Needs__c`  string , `MS_Contact__c`  string , `Sparefoot_Lead_Sent__c`  string , `Sent_to_SpareFoot_By__c`  string , `Sent_to_SpareFoot__c`  string , `utm_campaign__c`  string , `utm_ad__c`  string , `utm_keyword__c`  string , `utm_source__c`  string , `rh2__Currency_Test__c`  string , `rh2__Describe__c`  string , `rh2__Integer_Test__c`  string , `SourceLeadID__c`  string , `Internal_Referral__c`  string , `utm_medium__c`  string , `Web_Source__c`  string , `Phoneextension__c`  string , `FormSource__c`  string , `storEDGE_Salesforce_ID__c`  string , `KronologicCampaigns__c`  string , `KronologicStatus__c`  string , `CSAT_Most_Recent_Combined_Score__c`  string , `CSAT_Most_Recent_Support_Score__c`  string , `CSAT_Most_Recent_Product_Score__c`  string , `CSAT_Most_Recent_NPS__c`  string , `CSAT_Date_Time_Most_Recently_Completed__c`  string , `CSAT_Most_Recent_Comment__c`  string , `dupcheck__dc3DisableDuplicateCheck__c`  string , `dupcheck__dc3Index__c`  string , `Opportunity__c`  string , `Nickname__c`  string , `Dupe_Check_Unique_Matched_ID__c`  string , `Dupe_Check_Master_Record__c`  string , `Dupe_Check_Merge_Cohort__c`  string , `Most_Recent_HubSpot_Message__c`  string , `Genesys_Phone__c`  string , `Total_Launchable_AC_Facilities__c`  string , `of_New_or_Cross_sell_Oppty__c`  string , `MySpareFoot_User_ID__c`  string , `Contact_Name_1__c`  string , `Contact_Name_2__c`  string , `Contact_Name_3__c`  string , `VersaPay_Email__c`  string , `Versapay_Sync_Time__c`  string , `Leadliaison__LLBounced__c`  string , `Leadliaison__LLFirstTouchCampaignName__c`  string , `Leadliaison__LLFirstTouchProgramName__c`  string , `Leadliaison__LLLastSearchEngine__c`  string , `Leadliaison__LLLastSearchPhrase__c`  string , `Leadliaison__LLLastSyncToLeadLiaisonWebApp__c`  string , `Leadliaison__LLLastVisitTime__c`  string , `Live_ESS_CA_Facilities__c`  string , `Live_ESS_FMS_Facilities__c`  string , `Live_ESS_SEO_Facilities__c`  string , `Live_TPP_Facilities__c`  string , `Date_Time_Last_Data_Lake_Sync__c`  string , `MySpareFoot_User_Email__c`  string , `MySpareFoot_User_Phone__c`  string , `System_of_Origin__c`  string , `Contact_CSM__c`  string , `Leadliaison__LLLastWebVisit__c`  string , `Leadliaison__LLLeadLiaisonGrade__c`  string , `Leadliaison__LLLeadLiaisonScore__c`  string , `Leadliaison__LLOriginalReferralSource__c`  string , `Leadliaison__LLTotalWebVisits__c`  string , `Leadliaison__LL_Profile_ID__c`  string , `Leadliaison__LL_Total_Activity__c`  string , `Date_Time_Most_Recent_Imp_CSAT_Completed__c`  string , `Most_Recent_Imp_Combined_CSAT_Score__c`  string , `Most_Recent_Imp_CSAT_Comment__c`  string , `Most_Recent_Imp_CSAT_Product_Score__c`  string , `Contact_Info_Confirmed__c`  string , `Date_Contact_Info_Confirmed__c`  string , `Most_Recent_Imp_CSAT_Support_Score__c`  string , `Product_Discovery_Opt_In__c`  string , `Product_Discovery_Comments__c`  string , `Product_Discovery_Feedback_Rating__c`  string , `Total_Relationships__c`  string , `Active_Relationships__c`  string , `HubSpot_Locations__c`  string , `HubSpot_Units__c`  string , `HubSpot_Product_Interest__c`  string , `HubSpot_Web_Comments__c`  string , `IsVIP__c`  string , `MapPhone__c`  string , `Web_Form_Date__c`  string , `HubspotPhone__c`  string , `StorageForum_Username__c`  string , `RecentCampaign__c`  string , `HubspotRecordid__c`  string , `Channel__c`  string , `Transactional_Email_Opt_Out__c`  string , `Live_AC_Facilities__c`  string , `Live_PMS_Facilities__c`  string , `Live_SBOA_Facilities__c`  string , `Live_SE_FMS_Facilities__c`  string , `Live_SE_Web_Facilities__c`  string , `Live_SMS_Facilities__c`  string , `Live_SF_Facilities__c`  string , `Live_SLMS_Facilities__c`  string , `Live_SLWE_Facilities__c`  string , `Live_SP_Facilities__c`  string , `CSL1_Invoice_Recieved__c`  string , `CO_Invoice_Recieved__c`  string , `CSM__c`  string , `smartystreets__In_Batch__c`  string , `smartystreets__MailingVerificationUsed__c`  string , `smartystreets__Mailing_Clean_Street__c`  string , `smartystreets__Mailing_Do_Not_Verify__c`  string , `smartystreets__Mailing_Footnotes__c`  string , `smartystreets__Mailing_Last_Verified__c`  string , `smartystreets__Mailing_Latitude__c`  string , `smartystreets__Mailing_Longitude__c`  string , `smartystreets__Mailing_Return_Code__c`  string , `smartystreets__Mailing_Verified__c`  string , `smartystreets__OtherVerificationUsed__c`  string , `smartystreets__Other_Clean_Street__c`  string , `smartystreets__Other_Do_Not_Verify__c`  string , `smartystreets__Other_Footnotes__c`  string , `smartystreets__Other_Last_Verified__c`  string , `smartystreets__Other_Latitude__c`  string , `smartystreets__Other_Longitude__c`  string , `smartystreets__Other_Return_Code__c`  string , `smartystreets__Other_Verified__c`  string , `ESS_Followup_Date__c`  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-csv-salesforce-dev/raw/contacts/2023-08-16/1692195984'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_contacts"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/contacts/2023-08-16/1692195984
    • id: 4697407
    • processed: 1
    • raw_data: 
      {
    "AccountId": 3,
    "Active_Relationships__c": 185,
    "Address_Type__c": 62,
    "AssistantName": 35,
    "AssistantPhone": 30,
    "Attended__c": 77,
    "Authority__c": 75,
    "Birthdate": 37,
    "CO_Invoice_Recieved__c": 210,
    "CSAT_Date_Time_Most_Recently_Completed__c": 132,
    "CSAT_Most_Recent_Combined_Score__c": 128,
    "CSAT_Most_Recent_Comment__c": 133,
    "CSAT_Most_Recent_NPS__c": 131,
    "CSAT_Most_Recent_Product_Score__c": 130,
    "CSAT_Most_Recent_Support_Score__c": 129,
    "CSL1_Invoice_Recieved__c": 209,
    "CSM__c": 211,
    "Channel__c": 197,
    "ConnectionReceivedId": 57,
    "ConnectionSentId": 58,
    "Contact_CSM__c": 166,
    "Contact_Info_Confirmed__c": 178,
    "Contact_Name_1__c": 146,
    "Contact_Name_2__c": 147,
    "Contact_Name_3__c": 148,
    "Contact_Outlook_Category__c": 67,
    "CreatedById": 45,
    "CreatedDate": 44,
    "CurrencyIsoCode": 39,
    "Current_Feature_Interest__c": 101,
    "Date_Contact_Info_Confirmed__c": 179,
    "Date_Time_Last_Data_Lake_Sync__c": 162,
    "Date_Time_Most_Recent_Imp_CSAT_Completed__c": 174,
    "Department": 34,
    "Description": 38,
    "DoNotCall": 43,
    "Dupe_Check_Master_Record__c": 139,
    "Dupe_Check_Merge_Cohort__c": 140,
    "Dupe_Check_Unique_Matched_ID__c": 138,
    "ESS_Followup_Date__c": 231,
    "Email": 32,
    "EmailBouncedDate": 53,
    "EmailBouncedReason": 52,
    "Email_1__c": 63,
    "Email_2__c": 64,
    "Email_3__c": 65,
    "ExporttoHubspot__c": 69,
    "Fax": 26,
    "FirstName": 5,
    "FormSource__c": 124,
    "Genesys_Phone__c": 142,
    "HasOptedOutOfEmail": 41,
    "HasOptedOutOfFax": 42,
    "HasOptedOutOfMail__c": 70,
    "HomePhone": 28,
    "Home_Phone_1__c": 61,
    "HubSpot_Locations__c": 186,
    "HubSpot_Product_Interest__c": 188,
    "HubSpot_Units__c": 187,
    "HubSpot_Web_Comments__c": 189,
    "HubspotPhone__c": 193,
    "HubspotRecordid__c": 196,
    "IGD__Collection_Id__c": 78,
    "Id": 0,
    "IndividualId": 59,
    "Internal_Referral__c": 120,
    "IsDeleted": 1,
    "IsEmailBounced": 54,
    "IsVIP__c": 190,
    "Jigsaw": 55,
    "JigsawContactId": 56,
    "KronologicCampaigns__c": 126,
    "KronologicStatus__c": 127,
    "LastActivityDate": 49,
    "LastCURequestDate": 50,
    "LastCUUpdateDate": 51,
    "LastModifiedById": 47,
    "LastModifiedDate": 46,
    "LastName": 4,
    "LeadSource": 36,
    "Leadliaison__LLBounced__c": 151,
    "Leadliaison__LLFirstTouchCampaignName__c": 152,
    "Leadliaison__LLFirstTouchProgramName__c": 153,
    "Leadliaison__LLLastSearchEngine__c": 154,
    "Leadliaison__LLLastSearchPhrase__c": 155,
    "Leadliaison__LLLastSyncToLeadLiaisonWebApp__c": 156,
    "Leadliaison__LLLastVisitTime__c": 157,
    "Leadliaison__LLLastWebVisit__c": 167,
    "Leadliaison__LLLeadLiaisonGrade__c": 168,
    "Leadliaison__LLLeadLiaisonScore__c": 169,
    "Leadliaison__LLOriginalReferralSource__c": 170,
    "Leadliaison__LLTotalWebVisits__c": 171,
    "Leadliaison__LL_Profile_ID__c": 172,
    "Leadliaison__LL_Total_Activity__c": 173,
    "Live_AC_Facilities__c": 199,
    "Live_ESS_CA_Facilities__c": 158,
    "Live_ESS_FMS_Facilities__c": 159,
    "Live_ESS_SEO_Facilities__c": 160,
    "Live_PMS_Facilities__c": 200,
    "Live_SBOA_Facilities__c": 201,
    "Live_SE_FMS_Facilities__c": 202,
    "Live_SE_Web_Facilities__c": 203,
    "Live_SF_Facilities__c": 205,
    "Live_SLMS_Facilities__c": 206,
    "Live_SLWE_Facilities__c": 207,
    "Live_SMS_Facilities__c": 204,
    "Live_SP_Facilities__c": 208,
    "Live_TPP_Facilities__c": 161,
    "MS_Contact__c": 108,
    "MailingCity": 18,
    "MailingCountry": 21,
    "MailingGeocodeAccuracy": 24,
    "MailingLatitude": 22,
    "MailingLongitude": 23,
    "MailingPostalCode": 20,
    "MailingState": 19,
    "MailingStreet": 17,
    "MapPhone__c": 191,
    "Marketing_Contact_Method__c": 68,
    "Marketing__c": 73,
    "MasterRecordId": 2,
    "Middle_Name__c": 72,
    "MobilePhone": 27,
    "Most_Recent_HubSpot_Message__c": 141,
    "Most_Recent_Imp_CSAT_Comment__c": 176,
    "Most_Recent_Imp_CSAT_Product_Score__c": 177,
    "Most_Recent_Imp_CSAT_Support_Score__c": 180,
    "Most_Recent_Imp_Combined_CSAT_Score__c": 175,
    "MySpareFoot_User_Email__c": 163,
    "MySpareFoot_User_ID__c": 145,
    "MySpareFoot_User_Phone__c": 164,
    "Name": 7,
    "Needs__c": 107,
    "Nickname__c": 137,
    "No_Longer_with_Company__c": 76,
    "Opportunity__c": 136,
    "OtherCity": 10,
    "OtherCountry": 13,
    "OtherGeocodeAccuracy": 16,
    "OtherLatitude": 14,
    "OtherLongitude": 15,
    "OtherPhone": 29,
    "OtherPostalCode": 12,
    "OtherState": 11,
    "OtherStreet": 9,
    "OwnerId": 40,
    "Phone": 25,
    "Phoneextension__c": 123,
    "Product_Discovery_Comments__c": 182,
    "Product_Discovery_Feedback_Rating__c": 183,
    "Product_Discovery_Opt_In__c": 181,
    "Receives_Call_Center_API__c": 60,
    "Receives_Reporting_API__c": 66,
    "Receives_SOC_1_Type_2_Report__c": 102,
    "RecentCampaign__c": 195,
    "RecordTypeId": 8,
    "ReportsToId": 31,
    "Salutation": 6,
    "Sent_to_SpareFoot_By__c": 110,
    "Sent_to_SpareFoot__c": 111,
    "SourceLeadID__c": 119,
    "Sparefoot_Lead_Sent__c": 109,
    "StorageForum_Username__c": 194,
    "SystemModstamp": 48,
    "System_of_Origin__c": 165,
    "TIMBASURVEYS__Survey__c": 74,
    "Technical_Contact__c": 71,
    "Title": 33,
    "Total_Launchable_AC_Facilities__c": 143,
    "Total_Relationships__c": 184,
    "Transactional_Email_Opt_Out__c": 198,
    "VersaPay_Email__c": 149,
    "Versapay_Sync_Time__c": 150,
    "Web_Comments__c": 100,
    "Web_Form_Date__c": 192,
    "Web_Source__c": 122,
    "business_owner_checkbox__c": 105,
    "dupcheck__dc3DisableDuplicateCheck__c": 134,
    "dupcheck__dc3Index__c": 135,
    "of_New_or_Cross_sell_Oppty__c": 144,
    "pi__Needs_Score_Synced__c": 103,
    "pi__Pardot_Last_Scored_At__c": 104,
    "pi__campaign__c": 80,
    "pi__comments__c": 81,
    "pi__conversion_date__c": 82,
    "pi__conversion_object_name__c": 83,
    "pi__conversion_object_type__c": 84,
    "pi__created_date__c": 85,
    "pi__first_activity__c": 86,
    "pi__first_search_term__c": 87,
    "pi__first_search_type__c": 88,
    "pi__first_touch_url__c": 89,
    "pi__grade__c": 90,
    "pi__last_activity__c": 91,
    "pi__notes__c": 92,
    "pi__pardot_hard_bounced__c": 79,
    "pi__score__c": 93,
    "pi__url__c": 94,
    "pi__utm_campaign__c": 95,
    "pi__utm_content__c": 96,
    "pi__utm_medium__c": 97,
    "pi__utm_source__c": 98,
    "pi__utm_term__c": 99,
    "rh2__Currency_Test__c": 116,
    "rh2__Describe__c": 117,
    "rh2__Integer_Test__c": 118,
    "sales_contact__c": 106,
    "smartystreets__In_Batch__c": 212,
    "smartystreets__MailingVerificationUsed__c": 213,
    "smartystreets__Mailing_Clean_Street__c": 214,
    "smartystreets__Mailing_Do_Not_Verify__c": 215,
    "smartystreets__Mailing_Footnotes__c": 216,
    "smartystreets__Mailing_Last_Verified__c": 217,
    "smartystreets__Mailing_Latitude__c": 218,
    "smartystreets__Mailing_Longitude__c": 219,
    "smartystreets__Mailing_Return_Code__c": 220,
    "smartystreets__Mailing_Verified__c": 221,
    "smartystreets__OtherVerificationUsed__c": 222,
    "smartystreets__Other_Clean_Street__c": 223,
    "smartystreets__Other_Do_Not_Verify__c": 224,
    "smartystreets__Other_Footnotes__c": 225,
    "smartystreets__Other_Last_Verified__c": 226,
    "smartystreets__Other_Latitude__c": 227,
    "smartystreets__Other_Longitude__c": 228,
    "smartystreets__Other_Return_Code__c": 229,
    "smartystreets__Other_Verified__c": 230,
    "storEDGE_Salesforce_ID__c": 125,
    "utm_ad__c": 113,
    "utm_campaign__c": 112,
    "utm_keyword__c": 114,
    "utm_medium__c": 121,
    "utm_source__c": 115
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "Active_Relationships__c": "string",
    "Address_Type__c": "string",
    "Amount": "string",
    "AssistantName": "string",
    "AssistantPhone": "string",
    "Attended__c": "string",
    "Authority__c": "string",
    "Birthdate": "string",
    "CO_Invoice_Recieved__c": "string",
    "CSAT_Date_Time_Most_Recently_Completed__c": "string",
    "CSAT_Most_Recent_Combined_Score__c": "string",
    "CSAT_Most_Recent_Comment__c": "string",
    "CSAT_Most_Recent_NPS__c": "string",
    "CSAT_Most_Recent_Product_Score__c": "string",
    "CSAT_Most_Recent_Support_Score__c": "string",
    "CSL1_Invoice_Recieved__c": "string",
    "CSM__c": "string",
    "Channel__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact_CSM__c": "string",
    "Contact_Info_Confirmed__c": "string",
    "Contact_Name_1__c": "string",
    "Contact_Name_2__c": "string",
    "Contact_Name_3__c": "string",
    "Contact_Outlook_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Current_Feature_Interest__c": "string",
    "Date_Contact_Info_Confirmed__c": "string",
    "Date_Time_Last_Data_Lake_Sync__c": "string",
    "Date_Time_Most_Recent_Imp_CSAT_Completed__c": "string",
    "Department": "string",
    "Description": "string",
    "DoNotCall": "string",
    "Dupe_Check_Master_Record__c": "string",
    "Dupe_Check_Merge_Cohort__c": "string",
    "Dupe_Check_Unique_Matched_ID__c": "string",
    "ESS_Followup_Date__c": "string",
    "Email": "string",
    "EmailBouncedDate": "string",
    "EmailBouncedReason": "string",
    "Email_1__c": "string",
    "Email_2__c": "string",
    "Email_3__c": "string",
    "ExpectedRevenue": "string",
    "ExporttoHubspot__c": "string",
    "Fax": "string",
    "FirstName": "string",
    "ForecastCategory": "string",
    "FormSource__c": "string",
    "Genesys_Phone__c": "string",
    "HasOptedOutOfEmail": "string",
    "HasOptedOutOfFax": "string",
    "HasOptedOutOfMail__c": "string",
    "HomePhone": "string",
    "Home_Phone_1__c": "string",
    "HubSpot_Locations__c": "string",
    "HubSpot_Product_Interest__c": "string",
    "HubSpot_Units__c": "string",
    "HubSpot_Web_Comments__c": "string",
    "HubspotPhone__c": "string",
    "HubspotRecordid__c": "string",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "IndividualId": "string",
    "Internal_Referral__c": "string",
    "IsDeleted": "string",
    "IsEmailBounced": "string",
    "IsVIP__c": "string",
    "Jigsaw": "string",
    "JigsawContactId": "string",
    "KronologicCampaigns__c": "string",
    "KronologicStatus__c": "string",
    "LastActivityDate": "string",
    "LastCURequestDate": "string",
    "LastCUUpdateDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LastName": "string",
    "LeadSource": "string",
    "Leadliaison__LLBounced__c": "string",
    "Leadliaison__LLFirstTouchCampaignName__c": "string",
    "Leadliaison__LLFirstTouchProgramName__c": "string",
    "Leadliaison__LLLastSearchEngine__c": "string",
    "Leadliaison__LLLastSearchPhrase__c": "string",
    "Leadliaison__LLLastSyncToLeadLiaisonWebApp__c": "string",
    "Leadliaison__LLLastVisitTime__c": "string",
    "Leadliaison__LLLastWebVisit__c": "string",
    "Leadliaison__LLLeadLiaisonGrade__c": "string",
    "Leadliaison__LLLeadLiaisonScore__c": "string",
    "Leadliaison__LLOriginalReferralSource__c": "string",
    "Leadliaison__LLTotalWebVisits__c": "string",
    "Leadliaison__LL_Profile_ID__c": "string",
    "Leadliaison__LL_Total_Activity__c": "string",
    "Live_AC_Facilities__c": "string",
    "Live_ESS_CA_Facilities__c": "string",
    "Live_ESS_FMS_Facilities__c": "string",
    "Live_ESS_SEO_Facilities__c": "string",
    "Live_PMS_Facilities__c": "string",
    "Live_SBOA_Facilities__c": "string",
    "Live_SE_FMS_Facilities__c": "string",
    "Live_SE_Web_Facilities__c": "string",
    "Live_SF_Facilities__c": "string",
    "Live_SLMS_Facilities__c": "string",
    "Live_SLWE_Facilities__c": "string",
    "Live_SMS_Facilities__c": "string",
    "Live_SP_Facilities__c": "string",
    "Live_TPP_Facilities__c": "string",
    "MS_Contact__c": "string",
    "MailingCity": "string",
    "MailingCountry": "string",
    "MailingGeocodeAccuracy": "string",
    "MailingLatitude": "string",
    "MailingLongitude": "string",
    "MailingPostalCode": "string",
    "MailingState": "string",
    "MailingStreet": "string",
    "MapPhone__c": "string",
    "Marketing_Contact_Method__c": "string",
    "Marketing__c": "string",
    "MasterRecordId": "string",
    "Middle_Name__c": "string",
    "MobilePhone": "string",
    "Most_Recent_HubSpot_Message__c": "string",
    "Most_Recent_Imp_CSAT_Comment__c": "string",
    "Most_Recent_Imp_CSAT_Product_Score__c": "string",
    "Most_Recent_Imp_CSAT_Support_Score__c": "string",
    "Most_Recent_Imp_Combined_CSAT_Score__c": "string",
    "MySpareFoot_User_Email__c": "string",
    "MySpareFoot_User_ID__c": "string",
    "MySpareFoot_User_Phone__c": "string",
    "Name": "string",
    "Needs__c": "string",
    "Nickname__c": "string",
    "No_Longer_with_Company__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "OtherCity": "string",
    "OtherCountry": "string",
    "OtherGeocodeAccuracy": "string",
    "OtherLatitude": "string",
    "OtherLongitude": "string",
    "OtherPhone": "string",
    "OtherPostalCode": "string",
    "OtherState": "string",
    "OtherStreet": "string",
    "OwnerId": "string",
    "Phone": "string",
    "Phoneextension__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Discovery_Comments__c": "string",
    "Product_Discovery_Feedback_Rating__c": "string",
    "Product_Discovery_Opt_In__c": "string",
    "Receives_Call_Center_API__c": "string",
    "Receives_Reporting_API__c": "string",
    "Receives_SOC_1_Type_2_Report__c": "string",
    "RecentCampaign__c": "string",
    "RecordTypeId": "string",
    "ReportsToId": "string",
    "Salutation": "string",
    "Sent_to_SpareFoot_By__c": "string",
    "Sent_to_SpareFoot__c": "string",
    "SourceLeadID__c": "string",
    "Sparefoot_Lead_Sent__c": "string",
    "StageName": "string",
    "StorageForum_Username__c": "string",
    "SystemModstamp": "string",
    "System_of_Origin__c": "string",
    "TIMBASURVEYS__Survey__c": "string",
    "Technical_Contact__c": "string",
    "Title": "string",
    "Total_Launchable_AC_Facilities__c": "string",
    "Total_Relationships__c": "string",
    "Transactional_Email_Opt_Out__c": "string",
    "VersaPay_Email__c": "string",
    "Versapay_Sync_Time__c": "string",
    "Web_Comments__c": "string",
    "Web_Form_Date__c": "string",
    "Web_Source__c": "string",
    "business_owner_checkbox__c": "string",
    "dupcheck__dc3DisableDuplicateCheck__c": "string",
    "dupcheck__dc3Index__c": "string",
    "of_New_or_Cross_sell_Oppty__c": "string",
    "pi__Needs_Score_Synced__c": "string",
    "pi__Pardot_Last_Scored_At__c": "string",
    "pi__campaign__c": "string",
    "pi__comments__c": "string",
    "pi__conversion_date__c": "string",
    "pi__conversion_object_name__c": "string",
    "pi__conversion_object_type__c": "string",
    "pi__created_date__c": "string",
    "pi__first_activity__c": "string",
    "pi__first_search_term__c": "string",
    "pi__first_search_type__c": "string",
    "pi__first_touch_url__c": "string",
    "pi__grade__c": "string",
    "pi__last_activity__c": "string",
    "pi__notes__c": "string",
    "pi__pardot_hard_bounced__c": "string",
    "pi__score__c": "string",
    "pi__url__c": "string",
    "pi__utm_campaign__c": "string",
    "pi__utm_content__c": "string",
    "pi__utm_medium__c": "string",
    "pi__utm_source__c": "string",
    "pi__utm_term__c": "string",
    "rh2__Currency_Test__c": "string",
    "rh2__Describe__c": "string",
    "rh2__Integer_Test__c": "string",
    "sales_contact__c": "string",
    "smartystreets__In_Batch__c": "string",
    "smartystreets__MailingVerificationUsed__c": "string",
    "smartystreets__Mailing_Clean_Street__c": "string",
    "smartystreets__Mailing_Do_Not_Verify__c": "string",
    "smartystreets__Mailing_Footnotes__c": "string",
    "smartystreets__Mailing_Last_Verified__c": "string",
    "smartystreets__Mailing_Latitude__c": "string",
    "smartystreets__Mailing_Longitude__c": "string",
    "smartystreets__Mailing_Return_Code__c": "string",
    "smartystreets__Mailing_Verified__c": "string",
    "smartystreets__OtherVerificationUsed__c": "string",
    "smartystreets__Other_Clean_Street__c": "string",
    "smartystreets__Other_Do_Not_Verify__c": "string",
    "smartystreets__Other_Footnotes__c": "string",
    "smartystreets__Other_Last_Verified__c": "string",
    "smartystreets__Other_Latitude__c": "string",
    "smartystreets__Other_Longitude__c": "string",
    "smartystreets__Other_Return_Code__c": "string",
    "smartystreets__Other_Verified__c": "string",
    "storEDGE_Salesforce_ID__c": "string",
    "utm_ad__c": "string",
    "utm_campaign__c": "string",
    "utm_keyword__c": "string",
    "utm_medium__c": "string",
    "utm_source__c": "string"
}
    • schema_name_id: 2055
    • schema_scan_id: 6251293
    • updated: 2023-08-16 09:31:53
Schema Scans: 5
Last at 2024-06-10 15:35:45
    • duration: 0:00:22.045164
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6510752
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-dev",
        "hive_path": "s3://sfdl-csv-salesforce-dev/raw/contacts/2024-06-10/1718051388",
        "key": "raw/contacts/2024-06-10/1718051388/contacts.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_contacts",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8110695054950494358,
        "service_name": "drive-thru",
        "span_id": 10406910123723281443,
        "trace_id": 17492445798720923110
    }
}
    • running: False
    • schema_name_id: 2055
    • start_time: 2024-06-10 15:35:45
    • success: True
    • trace_id: 17492445798720923110
    • duration: 0:00:21.411228
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6402631
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-dev",
        "hive_path": "s3://sfdl-csv-salesforce-dev/raw/contacts/2024-01-11/1704985746",
        "key": "raw/contacts/2024-01-11/1704985746/contacts.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_contacts",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12904423652970783882,
        "service_name": "drive-thru",
        "span_id": 3100315293001023799,
        "trace_id": 6875066606096505170
    }
}
    • running: False
    • schema_name_id: 2055
    • start_time: 2024-01-11 09:11:17
    • success: True
    • trace_id: 6875066606096505170
    • duration: 0:00:18.153823
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6251507
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-dev",
        "hive_path": "s3://sfdl-csv-salesforce-dev/raw/contacts/2023-08-16/1692202302",
        "key": "raw/contacts/2023-08-16/1692202302/contacts.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_contacts",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2009289651210393869,
        "service_name": "drive-thru",
        "span_id": 10933087268768182765,
        "trace_id": 4297410262142498614
    }
}
    • running: False
    • schema_name_id: 2055
    • start_time: 2023-08-16 11:15:32
    • success: True
    • trace_id: 4297410262142498614
    • duration: 0:00:18.190436
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6251359
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-dev",
        "hive_path": "s3://sfdl-csv-salesforce-dev/raw/contacts/2023-08-16/1692199558",
        "key": "raw/contacts/2023-08-16/1692199558/contacts.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_contacts",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15248650184872876398,
        "service_name": "drive-thru",
        "span_id": 12175075642359516402,
        "trace_id": 17333076087367943174
    }
}
    • running: False
    • schema_name_id: 2055
    • start_time: 2023-08-16 10:28:06
    • success: True
    • trace_id: 17333076087367943174
    • duration: 0:00:18.202957
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6251293
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-dev",
        "hive_path": "s3://sfdl-csv-salesforce-dev/raw/contacts/2023-08-16/1692195984",
        "key": "raw/contacts/2023-08-16/1692195984/contacts.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_contacts",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5874837165409376619,
        "service_name": "drive-thru",
        "span_id": 14318000046690857195,
        "trace_id": 2853166216873290313
    }
}
    • running: False
    • schema_name_id: 2055
    • start_time: 2023-08-16 09:31:35
    • success: True
    • trace_id: 2853166216873290313
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "AccountId": "string",
    "Active_Relationships__c": "string",
    "Address_Type__c": "string",
    "Amount": "string",
    "AssistantName": "string",
    "AssistantPhone": "string",
    "Attended__c": "string",
    "Authority__c": "string",
    "Billing_System_Email__c": "string",
    "Billing_System_Sync_Time__c": "string",
    "Birthdate": "string",
    "CO_Invoice_Recieved__c": "string",
    "CP_Hubspot_Record_ID__c": "string",
    "CSAT_Date_Time_Most_Recently_Completed__c": "string",
    "CSAT_Most_Recent_Combined_Score__c": "string",
    "CSAT_Most_Recent_Comment__c": "string",
    "CSAT_Most_Recent_NPS__c": "string",
    "CSAT_Most_Recent_Product_Score__c": "string",
    "CSAT_Most_Recent_Support_Score__c": "string",
    "CSL1_Invoice_Recieved__c": "string",
    "CSM__c": "string",
    "Channel__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact_CSM__c": "string",
    "Contact_Info_Confirmed__c": "string",
    "Contact_Name_1__c": "string",
    "Contact_Name_2__c": "string",
    "Contact_Name_3__c": "string",
    "Contact_Outlook_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Current_Feature_Interest__c": "string",
    "DateTimeLastFormFill__c": "string",
    "Date_Contact_Info_Confirmed__c": "string",
    "Date_Time_Last_Data_Lake_Sync__c": "string",
    "Date_Time_Most_Recent_Imp_CSAT_Completed__c": "string",
    "Department": "string",
    "Description": "string",
    "Dialpad__IsCreatedFromDialpad__c": "string",
    "Dialpad__Powerdialer_Assigned_List__c": "string",
    "Dialpad__Powerdialer_Dialed_List__c": "string",
    "Dialpad__Powerdialer_Last_Dialed_via__c": "string",
    "Dialpad__Timezone__c": "string",
    "Dialpad__TotalNumberOfTimesDialed__c": "string",
    "DoNotCall": "string",
    "Dupe_Check_Master_Record__c": "string",
    "Dupe_Check_Merge_Cohort__c": "string",
    "Dupe_Check_Unique_Matched_ID__c": "string",
    "ESS_Followup_Date__c": "string",
    "Email": "string",
    "EmailBouncedDate": "string",
    "EmailBouncedReason": "string",
    "Email_1__c": "string",
    "Email_2__c": "string",
    "Email_3__c": "string",
    "ExpectedRevenue": "string",
    "ExporttoHubspot__c": "string",
    "Fax": "string",
    "FirstName": "string",
    "ForecastCategory": "string",
    "FormFillRegion__c": "string",
    "FormSource__c": "string",
    "GenderIdentity": "string",
    "Genesys_Phone__c": "string",
    "HasOptedOutOfEmail": "string",
    "HasOptedOutOfFax": "string",
    "HasOptedOutOfMail__c": "string",
    "HomePhone": "string",
    "Home_Phone_1__c": "string",
    "HubSpot_Locations__c": "string",
    "HubSpot_Product_Interest__c": "string",
    "HubSpot_Units__c": "string",
    "HubSpot_Web_Comments__c": "string",
    "HubspotPhone__c": "string",
    "HubspotRecordid__c": "string",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "IndividualId": "string",
    "Internal_Referral__c": "string",
    "IsDeleted": "string",
    "IsEmailBounced": "string",
    "IsVIP__c": "string",
    "Jigsaw": "string",
    "JigsawContactId": "string",
    "KronologicCampaigns__c": "string",
    "KronologicStatus__c": "string",
    "LastActivityDate": "string",
    "LastCURequestDate": "string",
    "LastCUUpdateDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LastName": "string",
    "LeadScore__c": "string",
    "LeadSource": "string",
    "Leadliaison__LLBounced__c": "string",
    "Leadliaison__LLFirstTouchCampaignName__c": "string",
    "Leadliaison__LLFirstTouchProgramName__c": "string",
    "Leadliaison__LLLastSearchEngine__c": "string",
    "Leadliaison__LLLastSearchPhrase__c": "string",
    "Leadliaison__LLLastSyncToLeadLiaisonWebApp__c": "string",
    "Leadliaison__LLLastVisitTime__c": "string",
    "Leadliaison__LLLastWebVisit__c": "string",
    "Leadliaison__LLLeadLiaisonGrade__c": "string",
    "Leadliaison__LLLeadLiaisonScore__c": "string",
    "Leadliaison__LLOriginalReferralSource__c": "string",
    "Leadliaison__LLTotalWebVisits__c": "string",
    "Leadliaison__LL_Profile_ID__c": "string",
    "Leadliaison__LL_Total_Activity__c": "string",
    "Live_AC_Facilities__c": "string",
    "Live_ESS_CA_Facilities__c": "string",
    "Live_ESS_FMS_Facilities__c": "string",
    "Live_ESS_SEO_Facilities__c": "string",
    "Live_PMS_Facilities__c": "string",
    "Live_SBOA_Facilities__c": "string",
    "Live_SE_FMS_Facilities__c": "string",
    "Live_SE_Web_Facilities__c": "string",
    "Live_SF_Facilities__c": "string",
    "Live_SLMS_Facilities__c": "string",
    "Live_SLWE_Facilities__c": "string",
    "Live_SMS_Facilities__c": "string",
    "Live_SP_Facilities__c": "string",
    "Live_TPP_Facilities__c": "string",
    "MS_Contact__c": "string",
    "MailingCity": "string",
    "MailingCountry": "string",
    "MailingGeocodeAccuracy": "string",
    "MailingLatitude": "string",
    "MailingLongitude": "string",
    "MailingPostalCode": "string",
    "MailingState": "string",
    "MailingStreet": "string",
    "MapPhone__c": "string",
    "Marketing_Contact_Method__c": "string",
    "Marketing__c": "string",
    "MasterRecordId": "string",
    "Middle_Name__c": "string",
    "MobilePhone": "string",
    "Most_Recent_HubSpot_Message__c": "string",
    "Most_Recent_Imp_CSAT_Comment__c": "string",
    "Most_Recent_Imp_CSAT_Product_Score__c": "string",
    "Most_Recent_Imp_CSAT_Support_Score__c": "string",
    "Most_Recent_Imp_Combined_CSAT_Score__c": "string",
    "MySpareFoot_User_Email__c": "string",
    "MySpareFoot_User_ID__c": "string",
    "MySpareFoot_User_Phone__c": "string",
    "Name": "string",
    "Needs__c": "string",
    "Nickname__c": "string",
    "No_Longer_with_Company__c": "string",
    "NumberOfFormFills__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "OtherCity": "string",
    "OtherCountry": "string",
    "OtherGeocodeAccuracy": "string",
    "OtherLatitude": "string",
    "OtherLongitude": "string",
    "OtherPhone": "string",
    "OtherPostalCode": "string",
    "OtherState": "string",
    "OtherStreet": "string",
    "OwnerId": "string",
    "Phone": "string",
    "Phoneextension__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "ProductInterestScoreAC__c": "string",
    "ProductInterestScoreDMS__c": "string",
    "ProductInterestScoreESS__c": "string",
    "ProductInterestScorePC__c": "string",
    "ProductInterestScoreSE__c": "string",
    "ProductInterestScoreSL__c": "string",
    "ProductInterestScoreTPP__c": "string",
    "Product_Discovery_Comments__c": "string",
    "Product_Discovery_Feedback_Rating__c": "string",
    "Product_Discovery_Opt_In__c": "string",
    "Pronouns": "string",
    "RND_Last_Check_Date__c": "string",
    "RND_Last_Purge_Date__c": "string",
    "Receives_Call_Center_API__c": "string",
    "Receives_Reporting_API__c": "string",
    "Receives_SOC_1_Type_2_Report__c": "string",
    "RecentCampaign__c": "string",
    "RecordTypeId": "string",
    "ReportsToId": "string",
    "Responsibilities__c": "string",
    "Salutation": "string",
    "Sent_to_SpareFoot_By__c": "string",
    "Sent_to_SpareFoot__c": "string",
    "Smartleads_Contact__c": "string",
    "SourceLeadID__c": "string",
    "Sparefoot_Lead_Sent__c": "string",
    "StageName": "string",
    "StorageForum_Username__c": "string",
    "SystemModstamp": "string",
    "System_of_Origin__c": "string",
    "TIMBASURVEYS__Survey__c": "string",
    "Technical_Contact__c": "string",
    "Tenant_Insurance_CSM_Involved__c": "string",
    "Testing_Contact__c": "string",
    "Title": "string",
    "Total_Launchable_AC_Facilities__c": "string",
    "Total_Relationships__c": "string",
    "Transactional_Email_Opt_Out__c": "string",
    "UConference__UberConferenceId__c": "string",
    "VersaPay_Email__c": "string",
    "Versapay_Sync_Time__c": "string",
    "Web_Comments__c": "string",
    "Web_Form_Date__c": "string",
    "Web_Source__c": "string",
    "business_owner_checkbox__c": "string",
    "dupcheck__dc3DisableDuplicateCheck__c": "string",
    "dupcheck__dc3Index__c": "string",
    "of_New_or_Cross_sell_Oppty__c": "string",
    "pi__Needs_Score_Synced__c": "string",
    "pi__Pardot_Last_Scored_At__c": "string",
    "pi__campaign__c": "string",
    "pi__comments__c": "string",
    "pi__conversion_date__c": "string",
    "pi__conversion_object_name__c": "string",
    "pi__conversion_object_type__c": "string",
    "pi__created_date__c": "string",
    "pi__first_activity__c": "string",
    "pi__first_search_term__c": "string",
    "pi__first_search_type__c": "string",
    "pi__first_touch_url__c": "string",
    "pi__grade__c": "string",
    "pi__last_activity__c": "string",
    "pi__notes__c": "string",
    "pi__pardot_hard_bounced__c": "string",
    "pi__score__c": "string",
    "pi__url__c": "string",
    "pi__utm_campaign__c": "string",
    "pi__utm_content__c": "string",
    "pi__utm_medium__c": "string",
    "pi__utm_source__c": "string",
    "pi__utm_term__c": "string",
    "rh2__Currency_Test__c": "string",
    "rh2__Describe__c": "string",
    "rh2__Integer_Test__c": "string",
    "sales_contact__c": "string",
    "smartystreets__In_Batch__c": "string",
    "smartystreets__MailingVerificationUsed__c": "string",
    "smartystreets__Mailing_Clean_Street__c": "string",
    "smartystreets__Mailing_Do_Not_Verify__c": "string",
    "smartystreets__Mailing_Footnotes__c": "string",
    "smartystreets__Mailing_Last_Verified__c": "string",
    "smartystreets__Mailing_Latitude__c": "string",
    "smartystreets__Mailing_Longitude__c": "string",
    "smartystreets__Mailing_Return_Code__c": "string",
    "smartystreets__Mailing_Verified__c": "string",
    "smartystreets__OtherVerificationUsed__c": "string",
    "smartystreets__Other_Clean_Street__c": "string",
    "smartystreets__Other_Do_Not_Verify__c": "string",
    "smartystreets__Other_Footnotes__c": "string",
    "smartystreets__Other_Last_Verified__c": "string",
    "smartystreets__Other_Latitude__c": "string",
    "smartystreets__Other_Longitude__c": "string",
    "smartystreets__Other_Return_Code__c": "string",
    "smartystreets__Other_Verified__c": "string",
    "storEDGE_Salesforce_ID__c": "string",
    "utm_ad__c": "string",
    "utm_campaign__c": "string",
    "utm_keyword__c": "string",
    "utm_medium__c": "string",
    "utm_source__c": "string"
}
  • created: 2024-06-10 15:35:53
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_contacts`\n(\n `Id`  string , `IsDeleted`  string , `MasterRecordId`  string , `AccountId`  string , `LastName`  string , `FirstName`  string , `Salutation`  string , `Name`  string , `RecordTypeId`  string , `OtherStreet`  string , `OtherCity`  string , `OtherState`  string , `OtherPostalCode`  string , `OtherCountry`  string , `OtherLatitude`  string , `OtherLongitude`  string , `OtherGeocodeAccuracy`  string , `MailingStreet`  string , `MailingCity`  string , `MailingState`  string , `MailingPostalCode`  string , `MailingCountry`  string , `MailingLatitude`  string , `MailingLongitude`  string , `MailingGeocodeAccuracy`  string , `Phone`  string , `Fax`  string , `MobilePhone`  string , `HomePhone`  string , `OtherPhone`  string , `AssistantPhone`  string , `ReportsToId`  string , `Email`  string , `Title`  string , `Department`  string , `AssistantName`  string , `LeadSource`  string , `Birthdate`  string , `Description`  string , `CurrencyIsoCode`  string , `OwnerId`  string , `HasOptedOutOfEmail`  string , `HasOptedOutOfFax`  string , `DoNotCall`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `LastCURequestDate`  string , `LastCUUpdateDate`  string , `EmailBouncedReason`  string , `EmailBouncedDate`  string , `IsEmailBounced`  string , `Jigsaw`  string , `JigsawContactId`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `IndividualId`  string , `Pronouns`  string , `GenderIdentity`  string , `Receives_Call_Center_API__c`  string , `Home_Phone_1__c`  string , `Address_Type__c`  string , `Email_1__c`  string , `Email_2__c`  string , `Email_3__c`  string , `Receives_Reporting_API__c`  string , `Contact_Outlook_Category__c`  string , `Marketing_Contact_Method__c`  string , `ExporttoHubspot__c`  string , `HasOptedOutOfMail__c`  string , `Technical_Contact__c`  string , `Middle_Name__c`  string , `Marketing__c`  string , `TIMBASURVEYS__Survey__c`  string , `Authority__c`  string , `No_Longer_with_Company__c`  string , `Attended__c`  string , `IGD__Collection_Id__c`  string , `pi__pardot_hard_bounced__c`  string , `pi__campaign__c`  string , `pi__comments__c`  string , `pi__conversion_date__c`  string , `pi__conversion_object_name__c`  string , `pi__conversion_object_type__c`  string , `pi__created_date__c`  string , `pi__first_activity__c`  string , `pi__first_search_term__c`  string , `pi__first_search_type__c`  string , `pi__first_touch_url__c`  string , `pi__grade__c`  string , `pi__last_activity__c`  string , `pi__notes__c`  string , `pi__score__c`  string , `pi__url__c`  string , `pi__utm_campaign__c`  string , `pi__utm_content__c`  string , `pi__utm_medium__c`  string , `pi__utm_source__c`  string , `pi__utm_term__c`  string , `Web_Comments__c`  string , `Current_Feature_Interest__c`  string , `Receives_SOC_1_Type_2_Report__c`  string , `pi__Needs_Score_Synced__c`  string , `pi__Pardot_Last_Scored_At__c`  string , `business_owner_checkbox__c`  string , `sales_contact__c`  string , `Needs__c`  string , `MS_Contact__c`  string , `Sparefoot_Lead_Sent__c`  string , `Sent_to_SpareFoot_By__c`  string , `Sent_to_SpareFoot__c`  string , `utm_campaign__c`  string , `utm_ad__c`  string , `utm_keyword__c`  string , `utm_source__c`  string , `rh2__Currency_Test__c`  string , `rh2__Describe__c`  string , `rh2__Integer_Test__c`  string , `SourceLeadID__c`  string , `Internal_Referral__c`  string , `utm_medium__c`  string , `Web_Source__c`  string , `Phoneextension__c`  string , `FormSource__c`  string , `storEDGE_Salesforce_ID__c`  string , `KronologicCampaigns__c`  string , `KronologicStatus__c`  string , `CSAT_Most_Recent_Combined_Score__c`  string , `CSAT_Most_Recent_Support_Score__c`  string , `CSAT_Most_Recent_Product_Score__c`  string , `CSAT_Most_Recent_NPS__c`  string , `CSAT_Date_Time_Most_Recently_Completed__c`  string , `CSAT_Most_Recent_Comment__c`  string , `dupcheck__dc3DisableDuplicateCheck__c`  string , `dupcheck__dc3Index__c`  string , `Opportunity__c`  string , `Nickname__c`  string , `Dupe_Check_Unique_Matched_ID__c`  string , `Dupe_Check_Master_Record__c`  string , `Dupe_Check_Merge_Cohort__c`  string , `Most_Recent_HubSpot_Message__c`  string , `Genesys_Phone__c`  string , `Total_Launchable_AC_Facilities__c`  string , `of_New_or_Cross_sell_Oppty__c`  string , `MySpareFoot_User_ID__c`  string , `Contact_Name_1__c`  string , `Contact_Name_2__c`  string , `Contact_Name_3__c`  string , `Billing_System_Email__c`  string , `Billing_System_Sync_Time__c`  string , `Leadliaison__LLBounced__c`  string , `Leadliaison__LLFirstTouchCampaignName__c`  string , `Leadliaison__LLFirstTouchProgramName__c`  string , `Leadliaison__LLLastSearchEngine__c`  string , `Leadliaison__LLLastSearchPhrase__c`  string , `Leadliaison__LLLastSyncToLeadLiaisonWebApp__c`  string , `Leadliaison__LLLastVisitTime__c`  string , `Live_ESS_CA_Facilities__c`  string , `Live_ESS_FMS_Facilities__c`  string , `Live_ESS_SEO_Facilities__c`  string , `Live_TPP_Facilities__c`  string , `Date_Time_Last_Data_Lake_Sync__c`  string , `MySpareFoot_User_Email__c`  string , `MySpareFoot_User_Phone__c`  string , `System_of_Origin__c`  string , `Contact_CSM__c`  string , `Leadliaison__LLLastWebVisit__c`  string , `Leadliaison__LLLeadLiaisonGrade__c`  string , `Leadliaison__LLLeadLiaisonScore__c`  string , `Leadliaison__LLOriginalReferralSource__c`  string , `Leadliaison__LLTotalWebVisits__c`  string , `Leadliaison__LL_Profile_ID__c`  string , `Leadliaison__LL_Total_Activity__c`  string , `Date_Time_Most_Recent_Imp_CSAT_Completed__c`  string , `Most_Recent_Imp_Combined_CSAT_Score__c`  string , `Most_Recent_Imp_CSAT_Comment__c`  string , `Most_Recent_Imp_CSAT_Product_Score__c`  string , `Contact_Info_Confirmed__c`  string , `Date_Contact_Info_Confirmed__c`  string , `Most_Recent_Imp_CSAT_Support_Score__c`  string , `DateTimeLastFormFill__c`  string , `FormFillRegion__c`  string , `LeadScore__c`  string , `NumberOfFormFills__c`  string , `ProductInterestScoreAC__c`  string , `ProductInterestScoreDMS__c`  string , `ProductInterestScoreESS__c`  string , `ProductInterestScorePC__c`  string , `ProductInterestScoreSE__c`  string , `ProductInterestScoreSL__c`  string , `ProductInterestScoreTPP__c`  string , `CP_Hubspot_Record_ID__c`  string , `Dialpad__IsCreatedFromDialpad__c`  string , `Dialpad__Powerdialer_Assigned_List__c`  string , `Dialpad__Powerdialer_Dialed_List__c`  string , `Dialpad__Powerdialer_Last_Dialed_via__c`  string , `Dialpad__Timezone__c`  string , `Dialpad__TotalNumberOfTimesDialed__c`  string , `UConference__UberConferenceId__c`  string , `Tenant_Insurance_CSM_Involved__c`  string , `Testing_Contact__c`  string , `Smartleads_Contact__c`  string , `RND_Last_Purge_Date__c`  string , `RND_Last_Check_Date__c`  string , `Responsibilities__c`  string , `Product_Discovery_Opt_In__c`  string , `Product_Discovery_Comments__c`  string , `Product_Discovery_Feedback_Rating__c`  string , `Total_Relationships__c`  string , `Active_Relationships__c`  string , `HubSpot_Locations__c`  string , `HubSpot_Units__c`  string , `HubSpot_Product_Interest__c`  string , `HubSpot_Web_Comments__c`  string , `IsVIP__c`  string , `MapPhone__c`  string , `Web_Form_Date__c`  string , `HubspotPhone__c`  string , `StorageForum_Username__c`  string , `RecentCampaign__c`  string , `HubspotRecordid__c`  string , `Channel__c`  string , `Transactional_Email_Opt_Out__c`  string , `Live_AC_Facilities__c`  string , `Live_PMS_Facilities__c`  string , `Live_SBOA_Facilities__c`  string , `Live_SE_FMS_Facilities__c`  string , `Live_SE_Web_Facilities__c`  string , `Live_SMS_Facilities__c`  string , `Live_SF_Facilities__c`  string , `Live_SLMS_Facilities__c`  string , `Live_SLWE_Facilities__c`  string , `Live_SP_Facilities__c`  string , `CSL1_Invoice_Recieved__c`  string , `CO_Invoice_Recieved__c`  string , `CSM__c`  string , `smartystreets__In_Batch__c`  string , `smartystreets__MailingVerificationUsed__c`  string , `smartystreets__Mailing_Clean_Street__c`  string , `smartystreets__Mailing_Do_Not_Verify__c`  string , `smartystreets__Mailing_Footnotes__c`  string , `smartystreets__Mailing_Last_Verified__c`  string , `smartystreets__Mailing_Latitude__c`  string , `smartystreets__Mailing_Longitude__c`  string , `smartystreets__Mailing_Return_Code__c`  string , `smartystreets__Mailing_Verified__c`  string , `smartystreets__OtherVerificationUsed__c`  string , `smartystreets__Other_Clean_Street__c`  string , `smartystreets__Other_Do_Not_Verify__c`  string , `smartystreets__Other_Footnotes__c`  string , `smartystreets__Other_Last_Verified__c`  string , `smartystreets__Other_Latitude__c`  string , `smartystreets__Other_Longitude__c`  string , `smartystreets__Other_Return_Code__c`  string , `smartystreets__Other_Verified__c`  string , `ESS_Followup_Date__c`  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-csv-salesforce-dev/raw/contacts/2024-06-10/1718051388'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_contacts`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_contacts"
}
Server:
  • hostname: schemamanager-5447774fc6-4w58v
  • name: schema_manager
  • process_start: 2026-04-02 21:43:44
  • sf_env: dev
  • version: 2427328685
Raw: 
{
    "name": {
        "created": "2022-10-24 14:51:55",
        "disabled": false,
        "format": "raw",
        "id": 2055,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "salesforce_contacts"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AccountId": "string",
            "Active_Relationships__c": "string",
            "Address_Type__c": "string",
            "Amount": "string",
            "AssistantName": "string",
            "AssistantPhone": "string",
            "Attended__c": "string",
            "Authority__c": "string",
            "Billing_System_Email__c": "string",
            "Billing_System_Sync_Time__c": "string",
            "Birthdate": "string",
            "CO_Invoice_Recieved__c": "string",
            "CP_Hubspot_Record_ID__c": "string",
            "CSAT_Date_Time_Most_Recently_Completed__c": "string",
            "CSAT_Most_Recent_Combined_Score__c": "string",
            "CSAT_Most_Recent_Comment__c": "string",
            "CSAT_Most_Recent_NPS__c": "string",
            "CSAT_Most_Recent_Product_Score__c": "string",
            "CSAT_Most_Recent_Support_Score__c": "string",
            "CSL1_Invoice_Recieved__c": "string",
            "CSM__c": "string",
            "Channel__c": "string",
            "CloseDate": "string",
            "ConnectionReceivedId": "string",
            "ConnectionSentId": "string",
            "Contact_CSM__c": "string",
            "Contact_Info_Confirmed__c": "string",
            "Contact_Name_1__c": "string",
            "Contact_Name_2__c": "string",
            "Contact_Name_3__c": "string",
            "Contact_Outlook_Category__c": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "CurrencyIsoCode": "string",
            "Current_Feature_Interest__c": "string",
            "DateTimeLastFormFill__c": "string",
            "Date_Contact_Info_Confirmed__c": "string",
            "Date_Time_Last_Data_Lake_Sync__c": "string",
            "Date_Time_Most_Recent_Imp_CSAT_Completed__c": "string",
            "Department": "string",
            "Description": "string",
            "Dialpad__IsCreatedFromDialpad__c": "string",
            "Dialpad__Powerdialer_Assigned_List__c": "string",
            "Dialpad__Powerdialer_Dialed_List__c": "string",
            "Dialpad__Powerdialer_Last_Dialed_via__c": "string",
            "Dialpad__Timezone__c": "string",
            "Dialpad__TotalNumberOfTimesDialed__c": "string",
            "DoNotCall": "string",
            "Dupe_Check_Master_Record__c": "string",
            "Dupe_Check_Merge_Cohort__c": "string",
            "Dupe_Check_Unique_Matched_ID__c": "string",
            "ESS_Followup_Date__c": "string",
            "Email": "string",
            "EmailBouncedDate": "string",
            "EmailBouncedReason": "string",
            "Email_1__c": "string",
            "Email_2__c": "string",
            "Email_3__c": "string",
            "ExpectedRevenue": "string",
            "ExporttoHubspot__c": "string",
            "Fax": "string",
            "FirstName": "string",
            "ForecastCategory": "string",
            "FormFillRegion__c": "string",
            "FormSource__c": "string",
            "GenderIdentity": "string",
            "Genesys_Phone__c": "string",
            "HasOptedOutOfEmail": "string",
            "HasOptedOutOfFax": "string",
            "HasOptedOutOfMail__c": "string",
            "HomePhone": "string",
            "Home_Phone_1__c": "string",
            "HubSpot_Locations__c": "string",
            "HubSpot_Product_Interest__c": "string",
            "HubSpot_Units__c": "string",
            "HubSpot_Web_Comments__c": "string",
            "HubspotPhone__c": "string",
            "HubspotRecordid__c": "string",
            "IGD__Collection_Id__c": "string",
            "Id": "string",
            "IndividualId": "string",
            "Internal_Referral__c": "string",
            "IsDeleted": "string",
            "IsEmailBounced": "string",
            "IsVIP__c": "string",
            "Jigsaw": "string",
            "JigsawContactId": "string",
            "KronologicCampaigns__c": "string",
            "KronologicStatus__c": "string",
            "LastActivityDate": "string",
            "LastCURequestDate": "string",
            "LastCUUpdateDate": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "LastName": "string",
            "LeadScore__c": "string",
            "LeadSource": "string",
            "Leadliaison__LLBounced__c": "string",
            "Leadliaison__LLFirstTouchCampaignName__c": "string",
            "Leadliaison__LLFirstTouchProgramName__c": "string",
            "Leadliaison__LLLastSearchEngine__c": "string",
            "Leadliaison__LLLastSearchPhrase__c": "string",
            "Leadliaison__LLLastSyncToLeadLiaisonWebApp__c": "string",
            "Leadliaison__LLLastVisitTime__c": "string",
            "Leadliaison__LLLastWebVisit__c": "string",
            "Leadliaison__LLLeadLiaisonGrade__c": "string",
            "Leadliaison__LLLeadLiaisonScore__c": "string",
            "Leadliaison__LLOriginalReferralSource__c": "string",
            "Leadliaison__LLTotalWebVisits__c": "string",
            "Leadliaison__LL_Profile_ID__c": "string",
            "Leadliaison__LL_Total_Activity__c": "string",
            "Live_AC_Facilities__c": "string",
            "Live_ESS_CA_Facilities__c": "string",
            "Live_ESS_FMS_Facilities__c": "string",
            "Live_ESS_SEO_Facilities__c": "string",
            "Live_PMS_Facilities__c": "string",
            "Live_SBOA_Facilities__c": "string",
            "Live_SE_FMS_Facilities__c": "string",
            "Live_SE_Web_Facilities__c": "string",
            "Live_SF_Facilities__c": "string",
            "Live_SLMS_Facilities__c": "string",
            "Live_SLWE_Facilities__c": "string",
            "Live_SMS_Facilities__c": "string",
            "Live_SP_Facilities__c": "string",
            "Live_TPP_Facilities__c": "string",
            "MS_Contact__c": "string",
            "MailingCity": "string",
            "MailingCountry": "string",
            "MailingGeocodeAccuracy": "string",
            "MailingLatitude": "string",
            "MailingLongitude": "string",
            "MailingPostalCode": "string",
            "MailingState": "string",
            "MailingStreet": "string",
            "MapPhone__c": "string",
            "Marketing_Contact_Method__c": "string",
            "Marketing__c": "string",
            "MasterRecordId": "string",
            "Middle_Name__c": "string",
            "MobilePhone": "string",
            "Most_Recent_HubSpot_Message__c": "string",
            "Most_Recent_Imp_CSAT_Comment__c": "string",
            "Most_Recent_Imp_CSAT_Product_Score__c": "string",
            "Most_Recent_Imp_CSAT_Support_Score__c": "string",
            "Most_Recent_Imp_Combined_CSAT_Score__c": "string",
            "MySpareFoot_User_Email__c": "string",
            "MySpareFoot_User_ID__c": "string",
            "MySpareFoot_User_Phone__c": "string",
            "Name": "string",
            "Needs__c": "string",
            "Nickname__c": "string",
            "No_Longer_with_Company__c": "string",
            "NumberOfFormFills__c": "string",
            "OpportunityId": "string",
            "Opportunity__c": "string",
            "OtherCity": "string",
            "OtherCountry": "string",
            "OtherGeocodeAccuracy": "string",
            "OtherLatitude": "string",
            "OtherLongitude": "string",
            "OtherPhone": "string",
            "OtherPostalCode": "string",
            "OtherState": "string",
            "OtherStreet": "string",
            "OwnerId": "string",
            "Phone": "string",
            "Phoneextension__c": "string",
            "PrevAmount": "string",
            "PrevCloseDate": "string",
            "Probability": "string",
            "ProductInterestScoreAC__c": "string",
            "ProductInterestScoreDMS__c": "string",
            "ProductInterestScoreESS__c": "string",
            "ProductInterestScorePC__c": "string",
            "ProductInterestScoreSE__c": "string",
            "ProductInterestScoreSL__c": "string",
            "ProductInterestScoreTPP__c": "string",
            "Product_Discovery_Comments__c": "string",
            "Product_Discovery_Feedback_Rating__c": "string",
            "Product_Discovery_Opt_In__c": "string",
            "Pronouns": "string",
            "RND_Last_Check_Date__c": "string",
            "RND_Last_Purge_Date__c": "string",
            "Receives_Call_Center_API__c": "string",
            "Receives_Reporting_API__c": "string",
            "Receives_SOC_1_Type_2_Report__c": "string",
            "RecentCampaign__c": "string",
            "RecordTypeId": "string",
            "ReportsToId": "string",
            "Responsibilities__c": "string",
            "Salutation": "string",
            "Sent_to_SpareFoot_By__c": "string",
            "Sent_to_SpareFoot__c": "string",
            "Smartleads_Contact__c": "string",
            "SourceLeadID__c": "string",
            "Sparefoot_Lead_Sent__c": "string",
            "StageName": "string",
            "StorageForum_Username__c": "string",
            "SystemModstamp": "string",
            "System_of_Origin__c": "string",
            "TIMBASURVEYS__Survey__c": "string",
            "Technical_Contact__c": "string",
            "Tenant_Insurance_CSM_Involved__c": "string",
            "Testing_Contact__c": "string",
            "Title": "string",
            "Total_Launchable_AC_Facilities__c": "string",
            "Total_Relationships__c": "string",
            "Transactional_Email_Opt_Out__c": "string",
            "UConference__UberConferenceId__c": "string",
            "VersaPay_Email__c": "string",
            "Versapay_Sync_Time__c": "string",
            "Web_Comments__c": "string",
            "Web_Form_Date__c": "string",
            "Web_Source__c": "string",
            "business_owner_checkbox__c": "string",
            "dupcheck__dc3DisableDuplicateCheck__c": "string",
            "dupcheck__dc3Index__c": "string",
            "of_New_or_Cross_sell_Oppty__c": "string",
            "pi__Needs_Score_Synced__c": "string",
            "pi__Pardot_Last_Scored_At__c": "string",
            "pi__campaign__c": "string",
            "pi__comments__c": "string",
            "pi__conversion_date__c": "string",
            "pi__conversion_object_name__c": "string",
            "pi__conversion_object_type__c": "string",
            "pi__created_date__c": "string",
            "pi__first_activity__c": "string",
            "pi__first_search_term__c": "string",
            "pi__first_search_type__c": "string",
            "pi__first_touch_url__c": "string",
            "pi__grade__c": "string",
            "pi__last_activity__c": "string",
            "pi__notes__c": "string",
            "pi__pardot_hard_bounced__c": "string",
            "pi__score__c": "string",
            "pi__url__c": "string",
            "pi__utm_campaign__c": "string",
            "pi__utm_content__c": "string",
            "pi__utm_medium__c": "string",
            "pi__utm_source__c": "string",
            "pi__utm_term__c": "string",
            "rh2__Currency_Test__c": "string",
            "rh2__Describe__c": "string",
            "rh2__Integer_Test__c": "string",
            "sales_contact__c": "string",
            "smartystreets__In_Batch__c": "string",
            "smartystreets__MailingVerificationUsed__c": "string",
            "smartystreets__Mailing_Clean_Street__c": "string",
            "smartystreets__Mailing_Do_Not_Verify__c": "string",
            "smartystreets__Mailing_Footnotes__c": "string",
            "smartystreets__Mailing_Last_Verified__c": "string",
            "smartystreets__Mailing_Latitude__c": "string",
            "smartystreets__Mailing_Longitude__c": "string",
            "smartystreets__Mailing_Return_Code__c": "string",
            "smartystreets__Mailing_Verified__c": "string",
            "smartystreets__OtherVerificationUsed__c": "string",
            "smartystreets__Other_Clean_Street__c": "string",
            "smartystreets__Other_Do_Not_Verify__c": "string",
            "smartystreets__Other_Footnotes__c": "string",
            "smartystreets__Other_Last_Verified__c": "string",
            "smartystreets__Other_Latitude__c": "string",
            "smartystreets__Other_Longitude__c": "string",
            "smartystreets__Other_Return_Code__c": "string",
            "smartystreets__Other_Verified__c": "string",
            "storEDGE_Salesforce_ID__c": "string",
            "utm_ad__c": "string",
            "utm_campaign__c": "string",
            "utm_keyword__c": "string",
            "utm_medium__c": "string",
            "utm_source__c": "string"
        },
        "created": "2024-06-10 15:35:53",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_contacts`\n(\n `Id`  string , `IsDeleted`  string , `MasterRecordId`  string , `AccountId`  string , `LastName`  string , `FirstName`  string , `Salutation`  string , `Name`  string , `RecordTypeId`  string , `OtherStreet`  string , `OtherCity`  string , `OtherState`  string , `OtherPostalCode`  string , `OtherCountry`  string , `OtherLatitude`  string , `OtherLongitude`  string , `OtherGeocodeAccuracy`  string , `MailingStreet`  string , `MailingCity`  string , `MailingState`  string , `MailingPostalCode`  string , `MailingCountry`  string , `MailingLatitude`  string , `MailingLongitude`  string , `MailingGeocodeAccuracy`  string , `Phone`  string , `Fax`  string , `MobilePhone`  string , `HomePhone`  string , `OtherPhone`  string , `AssistantPhone`  string , `ReportsToId`  string , `Email`  string , `Title`  string , `Department`  string , `AssistantName`  string , `LeadSource`  string , `Birthdate`  string , `Description`  string , `CurrencyIsoCode`  string , `OwnerId`  string , `HasOptedOutOfEmail`  string , `HasOptedOutOfFax`  string , `DoNotCall`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `LastCURequestDate`  string , `LastCUUpdateDate`  string , `EmailBouncedReason`  string , `EmailBouncedDate`  string , `IsEmailBounced`  string , `Jigsaw`  string , `JigsawContactId`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `IndividualId`  string , `Pronouns`  string , `GenderIdentity`  string , `Receives_Call_Center_API__c`  string , `Home_Phone_1__c`  string , `Address_Type__c`  string , `Email_1__c`  string , `Email_2__c`  string , `Email_3__c`  string , `Receives_Reporting_API__c`  string , `Contact_Outlook_Category__c`  string , `Marketing_Contact_Method__c`  string , `ExporttoHubspot__c`  string , `HasOptedOutOfMail__c`  string , `Technical_Contact__c`  string , `Middle_Name__c`  string , `Marketing__c`  string , `TIMBASURVEYS__Survey__c`  string , `Authority__c`  string , `No_Longer_with_Company__c`  string , `Attended__c`  string , `IGD__Collection_Id__c`  string , `pi__pardot_hard_bounced__c`  string , `pi__campaign__c`  string , `pi__comments__c`  string , `pi__conversion_date__c`  string , `pi__conversion_object_name__c`  string , `pi__conversion_object_type__c`  string , `pi__created_date__c`  string , `pi__first_activity__c`  string , `pi__first_search_term__c`  string , `pi__first_search_type__c`  string , `pi__first_touch_url__c`  string , `pi__grade__c`  string , `pi__last_activity__c`  string , `pi__notes__c`  string , `pi__score__c`  string , `pi__url__c`  string , `pi__utm_campaign__c`  string , `pi__utm_content__c`  string , `pi__utm_medium__c`  string , `pi__utm_source__c`  string , `pi__utm_term__c`  string , `Web_Comments__c`  string , `Current_Feature_Interest__c`  string , `Receives_SOC_1_Type_2_Report__c`  string , `pi__Needs_Score_Synced__c`  string , `pi__Pardot_Last_Scored_At__c`  string , `business_owner_checkbox__c`  string , `sales_contact__c`  string , `Needs__c`  string , `MS_Contact__c`  string , `Sparefoot_Lead_Sent__c`  string , `Sent_to_SpareFoot_By__c`  string , `Sent_to_SpareFoot__c`  string , `utm_campaign__c`  string , `utm_ad__c`  string , `utm_keyword__c`  string , `utm_source__c`  string , `rh2__Currency_Test__c`  string , `rh2__Describe__c`  string , `rh2__Integer_Test__c`  string , `SourceLeadID__c`  string , `Internal_Referral__c`  string , `utm_medium__c`  string , `Web_Source__c`  string , `Phoneextension__c`  string , `FormSource__c`  string , `storEDGE_Salesforce_ID__c`  string , `KronologicCampaigns__c`  string , `KronologicStatus__c`  string , `CSAT_Most_Recent_Combined_Score__c`  string , `CSAT_Most_Recent_Support_Score__c`  string , `CSAT_Most_Recent_Product_Score__c`  string , `CSAT_Most_Recent_NPS__c`  string , `CSAT_Date_Time_Most_Recently_Completed__c`  string , `CSAT_Most_Recent_Comment__c`  string , `dupcheck__dc3DisableDuplicateCheck__c`  string , `dupcheck__dc3Index__c`  string , `Opportunity__c`  string , `Nickname__c`  string , `Dupe_Check_Unique_Matched_ID__c`  string , `Dupe_Check_Master_Record__c`  string , `Dupe_Check_Merge_Cohort__c`  string , `Most_Recent_HubSpot_Message__c`  string , `Genesys_Phone__c`  string , `Total_Launchable_AC_Facilities__c`  string , `of_New_or_Cross_sell_Oppty__c`  string , `MySpareFoot_User_ID__c`  string , `Contact_Name_1__c`  string , `Contact_Name_2__c`  string , `Contact_Name_3__c`  string , `Billing_System_Email__c`  string , `Billing_System_Sync_Time__c`  string , `Leadliaison__LLBounced__c`  string , `Leadliaison__LLFirstTouchCampaignName__c`  string , `Leadliaison__LLFirstTouchProgramName__c`  string , `Leadliaison__LLLastSearchEngine__c`  string , `Leadliaison__LLLastSearchPhrase__c`  string , `Leadliaison__LLLastSyncToLeadLiaisonWebApp__c`  string , `Leadliaison__LLLastVisitTime__c`  string , `Live_ESS_CA_Facilities__c`  string , `Live_ESS_FMS_Facilities__c`  string , `Live_ESS_SEO_Facilities__c`  string , `Live_TPP_Facilities__c`  string , `Date_Time_Last_Data_Lake_Sync__c`  string , `MySpareFoot_User_Email__c`  string , `MySpareFoot_User_Phone__c`  string , `System_of_Origin__c`  string , `Contact_CSM__c`  string , `Leadliaison__LLLastWebVisit__c`  string , `Leadliaison__LLLeadLiaisonGrade__c`  string , `Leadliaison__LLLeadLiaisonScore__c`  string , `Leadliaison__LLOriginalReferralSource__c`  string , `Leadliaison__LLTotalWebVisits__c`  string , `Leadliaison__LL_Profile_ID__c`  string , `Leadliaison__LL_Total_Activity__c`  string , `Date_Time_Most_Recent_Imp_CSAT_Completed__c`  string , `Most_Recent_Imp_Combined_CSAT_Score__c`  string , `Most_Recent_Imp_CSAT_Comment__c`  string , `Most_Recent_Imp_CSAT_Product_Score__c`  string , `Contact_Info_Confirmed__c`  string , `Date_Contact_Info_Confirmed__c`  string , `Most_Recent_Imp_CSAT_Support_Score__c`  string , `DateTimeLastFormFill__c`  string , `FormFillRegion__c`  string , `LeadScore__c`  string , `NumberOfFormFills__c`  string , `ProductInterestScoreAC__c`  string , `ProductInterestScoreDMS__c`  string , `ProductInterestScoreESS__c`  string , `ProductInterestScorePC__c`  string , `ProductInterestScoreSE__c`  string , `ProductInterestScoreSL__c`  string , `ProductInterestScoreTPP__c`  string , `CP_Hubspot_Record_ID__c`  string , `Dialpad__IsCreatedFromDialpad__c`  string , `Dialpad__Powerdialer_Assigned_List__c`  string , `Dialpad__Powerdialer_Dialed_List__c`  string , `Dialpad__Powerdialer_Last_Dialed_via__c`  string , `Dialpad__Timezone__c`  string , `Dialpad__TotalNumberOfTimesDialed__c`  string , `UConference__UberConferenceId__c`  string , `Tenant_Insurance_CSM_Involved__c`  string , `Testing_Contact__c`  string , `Smartleads_Contact__c`  string , `RND_Last_Purge_Date__c`  string , `RND_Last_Check_Date__c`  string , `Responsibilities__c`  string , `Product_Discovery_Opt_In__c`  string , `Product_Discovery_Comments__c`  string , `Product_Discovery_Feedback_Rating__c`  string , `Total_Relationships__c`  string , `Active_Relationships__c`  string , `HubSpot_Locations__c`  string , `HubSpot_Units__c`  string , `HubSpot_Product_Interest__c`  string , `HubSpot_Web_Comments__c`  string , `IsVIP__c`  string , `MapPhone__c`  string , `Web_Form_Date__c`  string , `HubspotPhone__c`  string , `StorageForum_Username__c`  string , `RecentCampaign__c`  string , `HubspotRecordid__c`  string , `Channel__c`  string , `Transactional_Email_Opt_Out__c`  string , `Live_AC_Facilities__c`  string , `Live_PMS_Facilities__c`  string , `Live_SBOA_Facilities__c`  string , `Live_SE_FMS_Facilities__c`  string , `Live_SE_Web_Facilities__c`  string , `Live_SMS_Facilities__c`  string , `Live_SF_Facilities__c`  string , `Live_SLMS_Facilities__c`  string , `Live_SLWE_Facilities__c`  string , `Live_SP_Facilities__c`  string , `CSL1_Invoice_Recieved__c`  string , `CO_Invoice_Recieved__c`  string , `CSM__c`  string , `smartystreets__In_Batch__c`  string , `smartystreets__MailingVerificationUsed__c`  string , `smartystreets__Mailing_Clean_Street__c`  string , `smartystreets__Mailing_Do_Not_Verify__c`  string , `smartystreets__Mailing_Footnotes__c`  string , `smartystreets__Mailing_Last_Verified__c`  string , `smartystreets__Mailing_Latitude__c`  string , `smartystreets__Mailing_Longitude__c`  string , `smartystreets__Mailing_Return_Code__c`  string , `smartystreets__Mailing_Verified__c`  string , `smartystreets__OtherVerificationUsed__c`  string , `smartystreets__Other_Clean_Street__c`  string , `smartystreets__Other_Do_Not_Verify__c`  string , `smartystreets__Other_Footnotes__c`  string , `smartystreets__Other_Last_Verified__c`  string , `smartystreets__Other_Latitude__c`  string , `smartystreets__Other_Longitude__c`  string , `smartystreets__Other_Return_Code__c`  string , `smartystreets__Other_Verified__c`  string , `ESS_Followup_Date__c`  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-csv-salesforce-dev/raw/contacts/2024-06-10/1718051388'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_contacts`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_contacts"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}
©2019 SpareFoot Data Platform