Schema Info

Schema Name: sfdl_stage_csv.salesforce_leads
  • created: 2022-10-24 15:14:18
  • disabled: False
  • format: raw
  • id: 1435
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_stage_csv",
    "table": "salesforce_leads"
}
  • type: csv
Schema Versions: 3
    • created: 2026-02-27 09:13:36
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_leads`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.salesforce_leads`\n(\n `Id`  string , `IsDeleted`  string , `MasterRecordId`  string , `LastName`  string , `FirstName`  string , `Salutation`  string , `Name`  string , `RecordTypeId`  string , `Title`  string , `Company`  string , `Street`  string , `City`  string , `State`  string , `PostalCode`  string , `Country`  string , `Latitude`  string , `Longitude`  string , `GeocodeAccuracy`  string , `Phone`  string , `MobilePhone`  string , `Fax`  string , `Email`  string , `Website`  string , `PhotoUrl`  string , `Description`  string , `LeadSource`  string , `Status`  string , `Industry`  string , `Rating`  string , `CurrencyIsoCode`  string , `AnnualRevenue`  string , `NumberOfEmployees`  string , `OwnerId`  string , `HasOptedOutOfEmail`  string , `IsConverted`  string , `ConvertedDate`  string , `ConvertedAccountId`  string , `ConvertedContactId`  string , `ConvertedOpportunityId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `DoNotCall`  string , `HasOptedOutOfFax`  string , `LastTransferDate`  string , `Jigsaw`  string , `JigsawContactId`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `EmailBouncedReason`  string , `EmailBouncedDate`  string , `IndividualId`  string , `Pronouns`  string , `GenderIdentity`  string , `IsPriorityRecord`  string , `SFGA__CorrelationID__c`  string , `SFGA__Correlation_Data__c`  string , `SFGA__Web_Source__c`  string , `Product_Interest__c`  string , `Old_Account_Id__c`  string , `ExporttoHubspot__c`  string , `of_Databases__c`  string , `of_Units__c`  string , `Accounting_Interface__c`  string , `CC_Interface__c`  string , `EMail_Interface__c`  string , `Old_Contact_Id__c`  string , `Account_Type__c`  string , `Feature_Code__c`  string , `Feature_Code_Initial__c`  string , `Home_Office_Copy_Number__c`  string , `Lead_Source_Email__c`  string , `Current_FMS__c`  string , `Units__c`  string , `Locations__c`  string , `Internet__c`  string , `CC_Processing__c`  string , `Invoicing__c`  string , `Accounting_Software__c`  string , `Offsite_Reporting__c`  string , `Last_Rate_Change__c`  string , `Occupancy__c`  string , `Access_Anywhere__c`  string , `Billing_Cycle__c`  string , `Needs__c`  string , `Timeframe__c`  string , `Authority__c`  string , `Home_Office_Key_Code__c`  string , `Kiosk__c`  string , `Channel__c`  string , `Pre_Call_Email__c`  string , `Demo_Link__c`  string , `pi__Needs_Score_Synced__c`  string , `pi__Pardot_Last_Scored_At__c`  string , `Pardot_Campaign__c`  string , `Pardot_Primary_Campaign_Source__c`  string , `Vanilla__ForumUrl__c`  string , `Lead_Source_SF__c`  string , `Last_Upgrade__c`  string , `Last_Upgrade_Version__c`  string , `MultiUser__c`  string , `Registration_Code__c`  string , `Revenue_Mgmt__c`  string , `SiteLink_Lite__c`  string , `SiteLink_PC_Copy_Number__c`  string , `SiteLink_PC_Key_Code__c`  string , `SLPC_Send_to_Corp_Office__c`  string , `SLWE_Billing_Day__c`  string , `SLWE_Billing_Frequency__c`  string , `SLWE_Billing_Rate__c`  string , `SLWE_Paid_by_Credit_Card__c`  string , `SMD_Contract_ID__c`  string , `Gate_Interface__c`  string , `pi__campaign__c`  string , `utm_source__c`  string , `Interest__c`  string , `LDR_Lists__c`  string , `Web_Lead_Comments__c`  string , `Corp_Code__c`  string , `Location_Code__c`  string , `Source_Page_URL__c`  string , `Lead_Source_Text__c`  string , `Please_provide_more_info__c`  string , `Not_Interested__c`  string , `IGD__Collection_Id__c`  string , `Reason_for_contacting_u__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 , `Online_Listing_Service__c`  string , `Promotion__c`  string , `Best_day_time__c`  string , `How_did_you_hear_about_us__c`  string , `pi__pardot_hard_bounced__c`  string , `utm_campaign__c`  string , `utm_ad__c`  string , `utm_keyword__c`  string , `Trash_Reason__c`  string , `SF_Lead_ID__c`  string , `Lead_Notes__c`  string , `Hot_Lead__c`  string , `System_of_Origin__c`  string , `SE_SF_Lead_ID__c`  string , `FormSource__c`  string , `FacilityID__c`  string , `GCLID__c`  string , `Current_Website__c`  string , `Current_Gate__c`  string , `Current_Insurance__c`  string , `Current_Marketplace__c`  string , `Current_Payment__c`  string , `Projected_MRR__c`  string , `KronologicCampaigns__c`  string , `KronologicStatus__c`  string , `Opportunity_Business_Segment_Detail__c`  string , `dupcheck__dc3DisableDuplicateCheck__c`  string , `dupcheck__dc3Index__c`  string , `dupcheck__dc3Web2Lead__c`  string , `Web_Form_Date__c`  string , `HubspotPhone__c`  string , `RecentCampaign__c`  string , `Most_Recent_HubSpot_Message__c`  string , `HubspotRecordid__c`  string , `Sells_Used_Boats__c`  string , `Trade_Show_High_Intent__c`  string , `Software_Usage_Marine_Boat_Club__c`  string , `Software_Usage_Marine_Boat_Sales__c`  string , `Software_Usage_Marine_Rentals__c`  string , `Software_Usage_Marine_Service__c`  string , `Technicians__c`  string , `Webinar_High_Intent__c`  string , `Work_Orders__c`  string , `Account__c`  string , `Allowed_to_Auto_Convert__c`  string , `Contact_Match__c`  string , `Contact__c`  string , `Last_Attempted_Match_to_Existing_Account__c`  string , `Last_Attempted_Match_to_Existing_Contact__c`  string , `UTM_term__c`  string , `utm_content__c`  string , `utm_medium__c`  string , `Webinar_Low_intent__c`  string , `Webinar_Opportunity_Notes__c`  string , `Trade_Show_Low_Intent__c`  string , `Trade_Show_Opportunity_Notess__c`  string , `Trial_Product__c`  string , `Trial_Sites__c`  string , `Gong__Active_Engage_Flow_Names__c`  string , `Gong__Actively_Being_in_a_Flow__c`  string , `Gong__Added_to_Flow_Date__c`  string , `Gong__Current_Flow_ID__c`  string , `Gong__Current_Flow_Name__c`  string , `Gong__Current_Flow_Step_Number__c`  string , `Gong__Current_Flow_Step_Type__c`  string , `Gong__Current_Flow_Task_Due_Date__c`  string , `Gong__Current_Flow_User_Name__c`  string , `Gong__Engage_Flow_Owner__c`  string , `Gong__Flow_Execution_ID__c`  string , `Gong__Flow_Status__c`  string , `Gong__Number_of_Active_Engage_Flows__c`  string , `Ready_to_Sync__c`  string , `Storage_Auctions_Lead__c`  string , `Hubspot_Form_Action_Type__c`  string , `Hubspot_Latest_Traffic_Source__c`  string , `Gong__Engage_Last_Step_Completed_Date__c`  string , `Gong__NumberofLocations__c`  string , `Data_Load_By__c`  string , `Marine_Product_Interest__c`  string , `smartystreets__Address_Do_Not_Verify__c`  string , `smartystreets__Address_Footnotes__c`  string , `smartystreets__Address_Last_Verified__c`  string , `smartystreets__Address_Latitude__c`  string , `smartystreets__Address_Longitude__c`  string , `smartystreets__Address_Return_Code__c`  string , `smartystreets__Address_Verified__c`  string , `smartystreets__Clean_Street__c`  string , `smartystreets__In_Batch__c`  string , `smartystreets__VerificationUsed__c`  string , `Lead_Handling__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 , `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 , `Opportunity_Type__c`  string , `Trade_Show_Support_Issue__c`  string , `Lead_Quality__c`  string , `AC_Product_Interest_Score__c`  string , `DMS_Product_Interest_Score__c`  string , `DateTimeLastFormFill__c`  string , `ESS_Product_Interest_Score__c`  string , `Hubspot_Customer_Location__c`  string , `Lead_Score__c`  string , `NumberOfFormFills__c`  string , `P_C_Product_Interest_Score__c`  string , `Reason_for_non_compliance__c`  string , `SiteLink_Product_Interest_Score__c`  string , `storEDGE_Product_Interest_Score__c`  string , `TPP_Product_Interest_Score__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 , `Converted_Lead__c`  string , `Annual_Boat_Club_Revenue__c`  string , `Annual_Boat_Sales_Revenue__c`  string , `Annual_Marine_Rentals_Revenue__c`  string , `Annual_Marine_Service_Revenue__c`  string , `Annual_Marine_Storage_Revenue__c`  string , `Annual_RV_Campsite_Revenue__c`  string , `Marine_HubSpot_ID__c`  string , `Num_Boats__c`  string , `Num_Houseboats__c`  string , `Num_Jet_Skis__c`  string , `Num_Lodging_Cabins__c`  string , `Num_Non_Powered__c`  string , `Num_Rack_Storage_Valet__c`  string , `Num_Snowmobiles__c`  string , `Referral_Entity__c`  string , `Referral_Partner_Type__c`  string , `Sells_New_Boats__c`  string , `Software_Usage_Marine_Storage__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-stage/raw/leads/2026-02-27/1772205050'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_leads"
]
    • hive_path: s3://sfdl-csv-salesforce-stage/raw/leads/2026-02-27/1772205050
    • id: 896368
    • processed: 1
    • raw_data: 
      {
    "AC_Product_Interest_Score__c": 255,
    "Access_Anywhere__c": 85,
    "Account_Type__c": 70,
    "Account__c": 191,
    "Accounting_Interface__c": 66,
    "Accounting_Software__c": 81,
    "Allowed_to_Auto_Convert__c": 192,
    "AnnualRevenue": 30,
    "Annual_Boat_Club_Revenue__c": 276,
    "Annual_Boat_Sales_Revenue__c": 277,
    "Annual_Marine_Rentals_Revenue__c": 278,
    "Annual_Marine_Service_Revenue__c": 279,
    "Annual_Marine_Storage_Revenue__c": 280,
    "Annual_RV_Campsite_Revenue__c": 281,
    "Authority__c": 89,
    "Best_day_time__c": 150,
    "Billing_Cycle__c": 86,
    "CC_Interface__c": 67,
    "CC_Processing__c": 79,
    "CP_Hubspot_Record_ID__c": 267,
    "Channel__c": 92,
    "City": 11,
    "Company": 9,
    "ConnectionReceivedId": 50,
    "ConnectionSentId": 51,
    "Contact_Match__c": 193,
    "Contact__c": 194,
    "ConvertedAccountId": 36,
    "ConvertedContactId": 37,
    "ConvertedDate": 35,
    "ConvertedOpportunityId": 38,
    "Converted_Lead__c": 275,
    "Corp_Code__c": 121,
    "Country": 14,
    "CreatedById": 40,
    "CreatedDate": 39,
    "CurrencyIsoCode": 29,
    "Current_FMS__c": 75,
    "Current_Gate__c": 166,
    "Current_Insurance__c": 167,
    "Current_Marketplace__c": 168,
    "Current_Payment__c": 169,
    "Current_Website__c": 165,
    "DMS_Product_Interest_Score__c": 256,
    "Data_Load_By__c": 225,
    "DateTimeLastFormFill__c": 257,
    "Demo_Link__c": 94,
    "Description": 24,
    "Dialpad__IsCreatedFromDialpad__c": 268,
    "Dialpad__Powerdialer_Assigned_List__c": 269,
    "Dialpad__Powerdialer_Dialed_List__c": 270,
    "Dialpad__Powerdialer_Last_Dialed_via__c": 271,
    "Dialpad__Timezone__c": 272,
    "Dialpad__TotalNumberOfTimesDialed__c": 273,
    "DoNotCall": 45,
    "EMail_Interface__c": 68,
    "ESS_Product_Interest_Score__c": 258,
    "Email": 21,
    "EmailBouncedDate": 53,
    "EmailBouncedReason": 52,
    "ExporttoHubspot__c": 63,
    "FacilityID__c": 163,
    "Fax": 20,
    "Feature_Code_Initial__c": 72,
    "Feature_Code__c": 71,
    "FirstName": 4,
    "FormSource__c": 162,
    "GCLID__c": 164,
    "Gate_Interface__c": 115,
    "GenderIdentity": 56,
    "GeocodeAccuracy": 17,
    "Gong__Active_Engage_Flow_Names__c": 206,
    "Gong__Actively_Being_in_a_Flow__c": 207,
    "Gong__Added_to_Flow_Date__c": 208,
    "Gong__Current_Flow_ID__c": 209,
    "Gong__Current_Flow_Name__c": 210,
    "Gong__Current_Flow_Step_Number__c": 211,
    "Gong__Current_Flow_Step_Type__c": 212,
    "Gong__Current_Flow_Task_Due_Date__c": 213,
    "Gong__Current_Flow_User_Name__c": 214,
    "Gong__Engage_Flow_Owner__c": 215,
    "Gong__Engage_Last_Step_Completed_Date__c": 223,
    "Gong__Flow_Execution_ID__c": 216,
    "Gong__Flow_Status__c": 217,
    "Gong__Number_of_Active_Engage_Flows__c": 218,
    "Gong__NumberofLocations__c": 224,
    "HasOptedOutOfEmail": 33,
    "HasOptedOutOfFax": 46,
    "Home_Office_Copy_Number__c": 73,
    "Home_Office_Key_Code__c": 90,
    "Hot_Lead__c": 159,
    "How_did_you_hear_about_us__c": 151,
    "HubspotPhone__c": 178,
    "HubspotRecordid__c": 181,
    "Hubspot_Customer_Location__c": 259,
    "Hubspot_Form_Action_Type__c": 221,
    "Hubspot_Latest_Traffic_Source__c": 222,
    "IGD__Collection_Id__c": 127,
    "Id": 0,
    "IndividualId": 54,
    "Industry": 27,
    "Interest__c": 118,
    "Internet__c": 78,
    "Invoicing__c": 80,
    "IsConverted": 34,
    "IsDeleted": 1,
    "IsPriorityRecord": 57,
    "Jigsaw": 48,
    "JigsawContactId": 49,
    "Kiosk__c": 91,
    "KronologicCampaigns__c": 171,
    "KronologicStatus__c": 172,
    "LDR_Lists__c": 119,
    "LastActivityDate": 44,
    "LastModifiedById": 42,
    "LastModifiedDate": 41,
    "LastName": 3,
    "LastTransferDate": 47,
    "Last_Attempted_Match_to_Existing_Account__c": 195,
    "Last_Attempted_Match_to_Existing_Contact__c": 196,
    "Last_Rate_Change__c": 83,
    "Last_Upgrade_Version__c": 102,
    "Last_Upgrade__c": 101,
    "Latitude": 15,
    "LeadSource": 25,
    "Lead_Handling__c": 237,
    "Lead_Notes__c": 158,
    "Lead_Quality__c": 254,
    "Lead_Score__c": 260,
    "Lead_Source_Email__c": 74,
    "Lead_Source_SF__c": 100,
    "Lead_Source_Text__c": 124,
    "Leadliaison__LLBounced__c": 238,
    "Leadliaison__LLFirstTouchCampaignName__c": 239,
    "Leadliaison__LLFirstTouchProgramName__c": 240,
    "Leadliaison__LLLastSearchEngine__c": 241,
    "Leadliaison__LLLastSearchPhrase__c": 242,
    "Leadliaison__LLLastSyncToLeadLiaisonWebApp__c": 243,
    "Leadliaison__LLLastVisitTime__c": 244,
    "Leadliaison__LLLastWebVisit__c": 245,
    "Leadliaison__LLLeadLiaisonGrade__c": 246,
    "Leadliaison__LLLeadLiaisonScore__c": 247,
    "Leadliaison__LLOriginalReferralSource__c": 248,
    "Leadliaison__LLTotalWebVisits__c": 249,
    "Leadliaison__LL_Profile_ID__c": 250,
    "Leadliaison__LL_Total_Activity__c": 251,
    "Location_Code__c": 122,
    "Locations__c": 77,
    "Longitude": 16,
    "Marine_HubSpot_ID__c": 282,
    "Marine_Product_Interest__c": 226,
    "MasterRecordId": 2,
    "MobilePhone": 19,
    "Most_Recent_HubSpot_Message__c": 180,
    "MultiUser__c": 103,
    "Name": 6,
    "Needs__c": 87,
    "Not_Interested__c": 126,
    "Num_Boats__c": 283,
    "Num_Houseboats__c": 284,
    "Num_Jet_Skis__c": 285,
    "Num_Lodging_Cabins__c": 286,
    "Num_Non_Powered__c": 287,
    "Num_Rack_Storage_Valet__c": 288,
    "Num_Snowmobiles__c": 289,
    "NumberOfEmployees": 31,
    "NumberOfFormFills__c": 261,
    "Occupancy__c": 84,
    "Offsite_Reporting__c": 82,
    "Old_Account_Id__c": 62,
    "Old_Contact_Id__c": 69,
    "Online_Listing_Service__c": 148,
    "Opportunity_Business_Segment_Detail__c": 173,
    "Opportunity_Type__c": 252,
    "OwnerId": 32,
    "P_C_Product_Interest_Score__c": 262,
    "Pardot_Campaign__c": 97,
    "Pardot_Primary_Campaign_Source__c": 98,
    "Phone": 18,
    "PhotoUrl": 23,
    "Please_provide_more_info__c": 125,
    "PostalCode": 13,
    "Pre_Call_Email__c": 93,
    "Product_Interest__c": 61,
    "Projected_MRR__c": 170,
    "Promotion__c": 149,
    "Pronouns": 55,
    "Rating": 28,
    "Ready_to_Sync__c": 219,
    "Reason_for_contacting_u__c": 128,
    "Reason_for_non_compliance__c": 263,
    "RecentCampaign__c": 179,
    "RecordTypeId": 7,
    "Referral_Entity__c": 290,
    "Referral_Partner_Type__c": 291,
    "Registration_Code__c": 104,
    "Revenue_Mgmt__c": 105,
    "SE_SF_Lead_ID__c": 161,
    "SFGA__CorrelationID__c": 58,
    "SFGA__Correlation_Data__c": 59,
    "SFGA__Web_Source__c": 60,
    "SF_Lead_ID__c": 157,
    "SLPC_Send_to_Corp_Office__c": 109,
    "SLWE_Billing_Day__c": 110,
    "SLWE_Billing_Frequency__c": 111,
    "SLWE_Billing_Rate__c": 112,
    "SLWE_Paid_by_Credit_Card__c": 113,
    "SMD_Contract_ID__c": 114,
    "Salutation": 5,
    "Sells_New_Boats__c": 292,
    "Sells_Used_Boats__c": 182,
    "SiteLink_Lite__c": 106,
    "SiteLink_PC_Copy_Number__c": 107,
    "SiteLink_PC_Key_Code__c": 108,
    "SiteLink_Product_Interest_Score__c": 264,
    "Software_Usage_Marine_Boat_Club__c": 184,
    "Software_Usage_Marine_Boat_Sales__c": 185,
    "Software_Usage_Marine_Rentals__c": 186,
    "Software_Usage_Marine_Service__c": 187,
    "Software_Usage_Marine_Storage__c": 293,
    "Source_Page_URL__c": 123,
    "State": 12,
    "Status": 26,
    "Storage_Auctions_Lead__c": 220,
    "Street": 10,
    "SystemModstamp": 43,
    "System_of_Origin__c": 160,
    "TPP_Product_Interest_Score__c": 266,
    "Technicians__c": 188,
    "Timeframe__c": 88,
    "Title": 8,
    "Trade_Show_High_Intent__c": 183,
    "Trade_Show_Low_Intent__c": 202,
    "Trade_Show_Opportunity_Notess__c": 203,
    "Trade_Show_Support_Issue__c": 253,
    "Trash_Reason__c": 156,
    "Trial_Product__c": 204,
    "Trial_Sites__c": 205,
    "UConference__UberConferenceId__c": 274,
    "UTM_term__c": 197,
    "Units__c": 76,
    "Vanilla__ForumUrl__c": 99,
    "Web_Form_Date__c": 177,
    "Web_Lead_Comments__c": 120,
    "Webinar_High_Intent__c": 189,
    "Webinar_Low_intent__c": 200,
    "Webinar_Opportunity_Notes__c": 201,
    "Website": 22,
    "Work_Orders__c": 190,
    "dupcheck__dc3DisableDuplicateCheck__c": 174,
    "dupcheck__dc3Index__c": 175,
    "dupcheck__dc3Web2Lead__c": 176,
    "of_Databases__c": 64,
    "of_Units__c": 65,
    "pi__Needs_Score_Synced__c": 95,
    "pi__Pardot_Last_Scored_At__c": 96,
    "pi__campaign__c": 116,
    "pi__comments__c": 129,
    "pi__conversion_date__c": 130,
    "pi__conversion_object_name__c": 131,
    "pi__conversion_object_type__c": 132,
    "pi__created_date__c": 133,
    "pi__first_activity__c": 134,
    "pi__first_search_term__c": 135,
    "pi__first_search_type__c": 136,
    "pi__first_touch_url__c": 137,
    "pi__grade__c": 138,
    "pi__last_activity__c": 139,
    "pi__notes__c": 140,
    "pi__pardot_hard_bounced__c": 152,
    "pi__score__c": 141,
    "pi__url__c": 142,
    "pi__utm_campaign__c": 143,
    "pi__utm_content__c": 144,
    "pi__utm_medium__c": 145,
    "pi__utm_source__c": 146,
    "pi__utm_term__c": 147,
    "smartystreets__Address_Do_Not_Verify__c": 227,
    "smartystreets__Address_Footnotes__c": 228,
    "smartystreets__Address_Last_Verified__c": 229,
    "smartystreets__Address_Latitude__c": 230,
    "smartystreets__Address_Longitude__c": 231,
    "smartystreets__Address_Return_Code__c": 232,
    "smartystreets__Address_Verified__c": 233,
    "smartystreets__Clean_Street__c": 234,
    "smartystreets__In_Batch__c": 235,
    "smartystreets__VerificationUsed__c": 236,
    "storEDGE_Product_Interest_Score__c": 265,
    "utm_ad__c": 154,
    "utm_campaign__c": 153,
    "utm_content__c": 198,
    "utm_keyword__c": 155,
    "utm_medium__c": 199,
    "utm_source__c": 117
}
    • schema_attributes: 
      {
    "AC_Product_Interest_Score__c": "string",
    "ATV_s__c": "string",
    "Access_Anywhere__c": "string",
    "Account_Type__c": "string",
    "Account__c": "string",
    "Accounting_Interface__c": "string",
    "Accounting_Software__c": "string",
    "Allowed_to_Auto_Convert__c": "string",
    "Amount": "string",
    "AnnualRevenue": "string",
    "Annual_Boat_Club_Revenue__c": "string",
    "Annual_Boat_Sales_Revenue__c": "string",
    "Annual_Marine_Rentals_Revenue__c": "string",
    "Annual_Marine_Service_Revenue__c": "string",
    "Annual_Marine_Storage_Revenue__c": "string",
    "Annual_RV_Campsite_Revenue__c": "string",
    "Authority__c": "string",
    "Best_day_time__c": "string",
    "Billing_Cycle__c": "string",
    "Boats__c": "string",
    "CC_Interface__c": "string",
    "CC_Processing__c": "string",
    "CP_Hubspot_Record_ID__c": "string",
    "Campgrounds__c": "string",
    "Channel__c": "string",
    "Charters_Cruises_Tours__c": "string",
    "City": "string",
    "CloseDate": "string",
    "Club_Boats__c": "string",
    "Company": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact_Match__c": "string",
    "Contact__c": "string",
    "ConvertedAccountId": "string",
    "ConvertedContactId": "string",
    "ConvertedDate": "string",
    "ConvertedOpportunityId": "string",
    "Converted_Lead__c": "string",
    "Corp_Code__c": "string",
    "Country": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Current_FMS__c": "string",
    "Current_Gate__c": "string",
    "Current_Insurance__c": "string",
    "Current_Marketplace__c": "string",
    "Current_Payment__c": "string",
    "Current_Website__c": "string",
    "DMS_Product_Interest_Score__c": "string",
    "Data_Load_By__c": "string",
    "DateTimeLastFormFill__c": "string",
    "Demo_Link__c": "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",
    "EMail_Interface__c": "string",
    "ESS_Product_Interest_Score__c": "string",
    "Email": "string",
    "EmailBouncedDate": "string",
    "EmailBouncedReason": "string",
    "ExpectedRevenue": "string",
    "ExporttoHubspot__c": "string",
    "FacilityID__c": "string",
    "Fax": "string",
    "Feature_Code_Initial__c": "string",
    "Feature_Code__c": "string",
    "FirstName": "string",
    "ForecastCategory": "string",
    "FormSource__c": "string",
    "GCLID__c": "string",
    "Gate_Interface__c": "string",
    "GenderIdentity": "string",
    "GeocodeAccuracy": "string",
    "Gong__Active_Engage_Flow_Names__c": "string",
    "Gong__Actively_Being_in_a_Flow__c": "string",
    "Gong__Added_to_Flow_Date__c": "string",
    "Gong__Current_Flow_ID__c": "string",
    "Gong__Current_Flow_Name__c": "string",
    "Gong__Current_Flow_Step_Number__c": "string",
    "Gong__Current_Flow_Step_Type__c": "string",
    "Gong__Current_Flow_Task_Due_Date__c": "string",
    "Gong__Current_Flow_User_Name__c": "string",
    "Gong__Engage_Flow_Owner__c": "string",
    "Gong__Engage_Last_Step_Completed_Date__c": "string",
    "Gong__Flow_Execution_ID__c": "string",
    "Gong__Flow_Status__c": "string",
    "Gong__Number_of_Active_Engage_Flows__c": "string",
    "Gong__NumberofLocations__c": "string",
    "HasOptedOutOfEmail": "string",
    "HasOptedOutOfFax": "string",
    "Has_Service_Manager__c": "string",
    "Home_Office_Copy_Number__c": "string",
    "Home_Office_Key_Code__c": "string",
    "Hot_Lead__c": "string",
    "Houseboats__c": "string",
    "How_did_you_hear_about_us__c": "string",
    "HubspotPhone__c": "string",
    "HubspotRecordid__c": "string",
    "Hubspot_Customer_Location__c": "string",
    "Hubspot_Form_Action_Type__c": "string",
    "Hubspot_Latest_Traffic_Source__c": "string",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "IndividualId": "string",
    "Indoor_Heated_Winter__c": "string",
    "Industry": "string",
    "Interest__c": "string",
    "Internet__c": "string",
    "Invoicing__c": "string",
    "IsConverted": "string",
    "IsDeleted": "string",
    "IsPriorityRecord": "string",
    "Jet_Skis__c": "string",
    "Jigsaw": "string",
    "JigsawContactId": "string",
    "Kiosk__c": "string",
    "KronologicCampaigns__c": "string",
    "KronologicStatus__c": "string",
    "LDR_Lists__c": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LastName": "string",
    "LastTransferDate": "string",
    "Last_Attempted_Match_to_Existing_Account__c": "string",
    "Last_Attempted_Match_to_Existing_Contact__c": "string",
    "Last_Rate_Change__c": "string",
    "Last_Upgrade_Version__c": "string",
    "Last_Upgrade__c": "string",
    "Latitude": "string",
    "LeadSource": "string",
    "Lead_Handling__c": "string",
    "Lead_Notes__c": "string",
    "Lead_Quality__c": "string",
    "Lead_Score__c": "string",
    "Lead_Source_Email__c": "string",
    "Lead_Source_SF__c": "string",
    "Lead_Source_Text__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",
    "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",
    "Location_Code__c": "string",
    "Locations__c": "string",
    "Lodging_Cabins__c": "string",
    "Longitude": "string",
    "Marine_Boat_Club__c": "string",
    "Marine_Boat_Sales__c": "string",
    "Marine_HubSpot_ID__c": "string",
    "Marine_Product_Interest__c": "string",
    "Marine_Rentals__c": "string",
    "Marine_Service__c": "string",
    "Marine_Storage__c": "string",
    "MasterRecordId": "string",
    "MobilePhone": "string",
    "Mobile_Service__c": "string",
    "Most_Recent_HubSpot_Message__c": "string",
    "MultiUser__c": "string",
    "Name": "string",
    "Needs__c": "string",
    "Non_Powered__c": "string",
    "Not_Interested__c": "string",
    "Num_ATV_s__c": "string",
    "Num_Boats__c": "string",
    "Num_Campgrounds__c": "string",
    "Num_Charters_Cruises_Tours__c": "string",
    "Num_Club_Boats__c": "string",
    "Num_Houseboats__c": "string",
    "Num_Indoor_Heated_Winter__c": "string",
    "Num_Jet_Skis__c": "string",
    "Num_Lodging_Cabins__c": "string",
    "Num_Non_Powered__c": "string",
    "Num_Outdoor_Parking_Lot_Winter__c": "string",
    "Num_RV_Sites__c": "string",
    "Num_Rack_Storage_Valet__c": "string",
    "Num_Snowmobiles__c": "string",
    "Num_Wet_Slips__c": "string",
    "Num_Yacht_Club_Slips__c": "string",
    "NumberOfEmployees": "string",
    "NumberOfFormFills__c": "string",
    "Occupancy__c": "string",
    "Offsite_Reporting__c": "string",
    "Old_Account_Id__c": "string",
    "Old_Contact_Id__c": "string",
    "Online_Listing_Service__c": "string",
    "OpportunityId": "string",
    "Opportunity_Business_Segment_Detail__c": "string",
    "Opportunity_Type__c": "string",
    "Outdoor_Parking_Lot_Winter__c": "string",
    "OwnerId": "string",
    "P_C_Product_Interest_Score__c": "string",
    "Pardot_Campaign__c": "string",
    "Pardot_Primary_Campaign_Source__c": "string",
    "Phone": "string",
    "PhotoUrl": "string",
    "Please_provide_more_info__c": "string",
    "PostalCode": "string",
    "Pre_Call_Email__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Interest__c": "string",
    "Projected_MRR__c": "string",
    "Promotion__c": "string",
    "Pronouns": "string",
    "RV_Campsite__c": "string",
    "RV_Sites__c": "string",
    "Rack_Storage_Valet__c": "string",
    "Rating": "string",
    "Ready_to_Sync__c": "string",
    "Reason_for_contacting_u__c": "string",
    "Reason_for_non_compliance__c": "string",
    "RecentCampaign__c": "string",
    "RecordTypeId": "string",
    "Referral_Entity__c": "string",
    "Referral_Partner_Type__c": "string",
    "Registration_Code__c": "string",
    "Revenue_Mgmt__c": "string",
    "SE_SF_Lead_ID__c": "string",
    "SFGA__CorrelationID__c": "string",
    "SFGA__Correlation_Data__c": "string",
    "SFGA__Web_Source__c": "string",
    "SF_Lead_ID__c": "string",
    "SLPC_Send_to_Corp_Office__c": "string",
    "SLWE_Billing_Day__c": "string",
    "SLWE_Billing_Frequency__c": "string",
    "SLWE_Billing_Rate__c": "string",
    "SLWE_Paid_by_Credit_Card__c": "string",
    "SMD_Contract_ID__c": "string",
    "Salutation": "string",
    "Sells_New_Boats__c": "string",
    "Sells_Used_Boats__c": "string",
    "Shop_Service__c": "string",
    "SiteLink_Lite__c": "string",
    "SiteLink_PC_Copy_Number__c": "string",
    "SiteLink_PC_Key_Code__c": "string",
    "SiteLink_Product_Interest_Score__c": "string",
    "Snowmobiles__c": "string",
    "Software_Usage_Marine_Boat_Club__c": "string",
    "Software_Usage_Marine_Boat_Sales__c": "string",
    "Software_Usage_Marine_Rentals__c": "string",
    "Software_Usage_Marine_Service__c": "string",
    "Software_Usage_Marine_Storage__c": "string",
    "Software_Usage_RV_Campsite__c": "string",
    "Source_Page_URL__c": "string",
    "StageName": "string",
    "State": "string",
    "Status": "string",
    "Storage_Auctions_Lead__c": "string",
    "Street": "string",
    "SystemModstamp": "string",
    "System_of_Origin__c": "string",
    "TPP_Product_Interest_Score__c": "string",
    "Technicians__c": "string",
    "Timeframe__c": "string",
    "Title": "string",
    "Trade_Show_High_Intent__c": "string",
    "Trade_Show_Low_Intent__c": "string",
    "Trade_Show_Opportunity_Notess__c": "string",
    "Trade_Show_Support_Issue__c": "string",
    "Trash_Reason__c": "string",
    "Trial_Product__c": "string",
    "Trial_Sites__c": "string",
    "UConference__UberConferenceId__c": "string",
    "UTM_term__c": "string",
    "Units__c": "string",
    "Vanilla__ForumUrl__c": "string",
    "Web_Form_Date__c": "string",
    "Web_Lead_Comments__c": "string",
    "Webinar_High_Intent__c": "string",
    "Webinar_Low_intent__c": "string",
    "Webinar_Opportunity_Notes__c": "string",
    "Website": "string",
    "Wet_Slips__c": "string",
    "Work_Orders__c": "string",
    "Yacht_Club_Slips__c": "string",
    "dupcheck__dc3DisableDuplicateCheck__c": "string",
    "dupcheck__dc3Index__c": "string",
    "dupcheck__dc3Web2Lead__c": "string",
    "of_Databases__c": "string",
    "of_Units__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",
    "smartystreets__Address_Do_Not_Verify__c": "string",
    "smartystreets__Address_Footnotes__c": "string",
    "smartystreets__Address_Last_Verified__c": "string",
    "smartystreets__Address_Latitude__c": "string",
    "smartystreets__Address_Longitude__c": "string",
    "smartystreets__Address_Return_Code__c": "string",
    "smartystreets__Address_Verified__c": "string",
    "smartystreets__Clean_Street__c": "string",
    "smartystreets__In_Batch__c": "string",
    "smartystreets__VerificationUsed__c": "string",
    "storEDGE_Product_Interest_Score__c": "string",
    "utm_ad__c": "string",
    "utm_campaign__c": "string",
    "utm_content__c": "string",
    "utm_keyword__c": "string",
    "utm_medium__c": "string",
    "utm_source__c": "string"
}
    • schema_name_id: 1435
    • schema_scan_id: 6391699
    • updated: 2026-02-27 09:13:47
    • created: 2025-01-09 15:15:46
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_leads`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.salesforce_leads`\n(\n `Id`  string , `IsDeleted`  string , `MasterRecordId`  string , `LastName`  string , `FirstName`  string , `Salutation`  string , `Name`  string , `RecordTypeId`  string , `Title`  string , `Company`  string , `Street`  string , `City`  string , `State`  string , `PostalCode`  string , `Country`  string , `Latitude`  string , `Longitude`  string , `GeocodeAccuracy`  string , `Phone`  string , `MobilePhone`  string , `Fax`  string , `Email`  string , `Website`  string , `PhotoUrl`  string , `Description`  string , `LeadSource`  string , `Status`  string , `Industry`  string , `Rating`  string , `CurrencyIsoCode`  string , `AnnualRevenue`  string , `NumberOfEmployees`  string , `OwnerId`  string , `HasOptedOutOfEmail`  string , `IsConverted`  string , `ConvertedDate`  string , `ConvertedAccountId`  string , `ConvertedContactId`  string , `ConvertedOpportunityId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `DoNotCall`  string , `HasOptedOutOfFax`  string , `LastTransferDate`  string , `Jigsaw`  string , `JigsawContactId`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `EmailBouncedReason`  string , `EmailBouncedDate`  string , `IndividualId`  string , `Pronouns`  string , `GenderIdentity`  string , `IsPriorityRecord`  string , `SFGA__CorrelationID__c`  string , `SFGA__Correlation_Data__c`  string , `SFGA__Web_Source__c`  string , `Product_Interest__c`  string , `Old_Account_Id__c`  string , `ExporttoHubspot__c`  string , `of_Databases__c`  string , `of_Units__c`  string , `Accounting_Interface__c`  string , `CC_Interface__c`  string , `EMail_Interface__c`  string , `Old_Contact_Id__c`  string , `Account_Type__c`  string , `Feature_Code__c`  string , `Feature_Code_Initial__c`  string , `Home_Office_Copy_Number__c`  string , `Lead_Source_Email__c`  string , `Current_FMS__c`  string , `Units__c`  string , `Locations__c`  string , `Internet__c`  string , `CC_Processing__c`  string , `Invoicing__c`  string , `Accounting_Software__c`  string , `Offsite_Reporting__c`  string , `Last_Rate_Change__c`  string , `Occupancy__c`  string , `Access_Anywhere__c`  string , `Billing_Cycle__c`  string , `Needs__c`  string , `Timeframe__c`  string , `Authority__c`  string , `Home_Office_Key_Code__c`  string , `Kiosk__c`  string , `Channel__c`  string , `Pre_Call_Email__c`  string , `Demo_Link__c`  string , `pi__Needs_Score_Synced__c`  string , `pi__Pardot_Last_Scored_At__c`  string , `Pardot_Campaign__c`  string , `Pardot_Primary_Campaign_Source__c`  string , `Vanilla__ForumUrl__c`  string , `Lead_Source_SF__c`  string , `Last_Upgrade__c`  string , `Last_Upgrade_Version__c`  string , `MultiUser__c`  string , `Registration_Code__c`  string , `Revenue_Mgmt__c`  string , `SiteLink_Lite__c`  string , `SiteLink_PC_Copy_Number__c`  string , `SiteLink_PC_Key_Code__c`  string , `SLPC_Send_to_Corp_Office__c`  string , `SLWE_Billing_Day__c`  string , `SLWE_Billing_Frequency__c`  string , `SLWE_Billing_Rate__c`  string , `SLWE_Paid_by_Credit_Card__c`  string , `SMD_Contract_ID__c`  string , `Gate_Interface__c`  string , `pi__campaign__c`  string , `utm_source__c`  string , `Interest__c`  string , `LDR_Lists__c`  string , `Web_Lead_Comments__c`  string , `Corp_Code__c`  string , `Location_Code__c`  string , `Source_Page_URL__c`  string , `Lead_Source_Text__c`  string , `Please_provide_more_info__c`  string , `Not_Interested__c`  string , `IGD__Collection_Id__c`  string , `Reason_for_contacting_u__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 , `Online_Listing_Service__c`  string , `Promotion__c`  string , `Best_day_time__c`  string , `How_did_you_hear_about_us__c`  string , `pi__pardot_hard_bounced__c`  string , `utm_campaign__c`  string , `utm_ad__c`  string , `utm_keyword__c`  string , `Trash_Reason__c`  string , `SF_Lead_ID__c`  string , `Lead_Notes__c`  string , `Hot_Lead__c`  string , `System_of_Origin__c`  string , `SE_SF_Lead_ID__c`  string , `FormSource__c`  string , `FacilityID__c`  string , `GCLID__c`  string , `Current_Website__c`  string , `Current_Gate__c`  string , `Current_Insurance__c`  string , `Current_Marketplace__c`  string , `Current_Payment__c`  string , `Projected_MRR__c`  string , `KronologicCampaigns__c`  string , `KronologicStatus__c`  string , `Opportunity_Business_Segment_Detail__c`  string , `dupcheck__dc3DisableDuplicateCheck__c`  string , `dupcheck__dc3Index__c`  string , `dupcheck__dc3Web2Lead__c`  string , `Web_Form_Date__c`  string , `HubspotPhone__c`  string , `RecentCampaign__c`  string , `Most_Recent_HubSpot_Message__c`  string , `HubspotRecordid__c`  string , `Sells_Used_Boats__c`  string , `Shop_Service__c`  string , `Snowmobiles__c`  string , `Software_Usage_Marine_Boat_Club__c`  string , `Software_Usage_Marine_Boat_Sales__c`  string , `Software_Usage_Marine_Rentals__c`  string , `Software_Usage_Marine_Service__c`  string , `Software_Usage_RV_Campsite__c`  string , `Technicians__c`  string , `Wet_Slips__c`  string , `Work_Orders__c`  string , `Yacht_Club_Slips__c`  string , `Account__c`  string , `Allowed_to_Auto_Convert__c`  string , `Contact_Match__c`  string , `Contact__c`  string , `Last_Attempted_Match_to_Existing_Account__c`  string , `Last_Attempted_Match_to_Existing_Contact__c`  string , `UTM_term__c`  string , `utm_content__c`  string , `utm_medium__c`  string , `smartystreets__Address_Do_Not_Verify__c`  string , `smartystreets__Address_Footnotes__c`  string , `smartystreets__Address_Last_Verified__c`  string , `smartystreets__Address_Latitude__c`  string , `smartystreets__Address_Longitude__c`  string , `smartystreets__Address_Return_Code__c`  string , `smartystreets__Address_Verified__c`  string , `smartystreets__Clean_Street__c`  string , `smartystreets__In_Batch__c`  string , `smartystreets__VerificationUsed__c`  string , `Lead_Handling__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 , `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 , `Opportunity_Type__c`  string , `Trade_Show_Support_Issue__c`  string , `Lead_Quality__c`  string , `AC_Product_Interest_Score__c`  string , `DMS_Product_Interest_Score__c`  string , `DateTimeLastFormFill__c`  string , `ESS_Product_Interest_Score__c`  string , `Hubspot_Customer_Location__c`  string , `Lead_Score__c`  string , `NumberOfFormFills__c`  string , `P_C_Product_Interest_Score__c`  string , `Reason_for_non_compliance__c`  string , `SiteLink_Product_Interest_Score__c`  string , `storEDGE_Product_Interest_Score__c`  string , `TPP_Product_Interest_Score__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 , `ATV_s__c`  string , `Annual_Boat_Club_Revenue__c`  string , `Annual_Boat_Sales_Revenue__c`  string , `Annual_Marine_Rentals_Revenue__c`  string , `Annual_Marine_Service_Revenue__c`  string , `Annual_Marine_Storage_Revenue__c`  string , `Annual_RV_Campsite_Revenue__c`  string , `Boats__c`  string , `Campgrounds__c`  string , `Charters_Cruises_Tours__c`  string , `Club_Boats__c`  string , `Has_Service_Manager__c`  string , `Houseboats__c`  string , `Indoor_Heated_Winter__c`  string , `Jet_Skis__c`  string , `Lodging_Cabins__c`  string , `Marine_Boat_Club__c`  string , `Marine_Boat_Sales__c`  string , `Marine_HubSpot_ID__c`  string , `Marine_Rentals__c`  string , `Marine_Service__c`  string , `Marine_Storage__c`  string , `Mobile_Service__c`  string , `Non_Powered__c`  string , `Num_ATV_s__c`  string , `Num_Boats__c`  string , `Num_Campgrounds__c`  string , `Num_Charters_Cruises_Tours__c`  string , `Num_Club_Boats__c`  string , `Num_Houseboats__c`  string , `Num_Indoor_Heated_Winter__c`  string , `Num_Jet_Skis__c`  string , `Num_Lodging_Cabins__c`  string , `Num_Non_Powered__c`  string , `Num_Outdoor_Parking_Lot_Winter__c`  string , `Num_RV_Sites__c`  string , `Num_Rack_Storage_Valet__c`  string , `Num_Snowmobiles__c`  string , `Num_Wet_Slips__c`  string , `Num_Yacht_Club_Slips__c`  string , `Outdoor_Parking_Lot_Winter__c`  string , `RV_Campsite__c`  string , `RV_Sites__c`  string , `Rack_Storage_Valet__c`  string , `Referral_Entity__c`  string , `Referral_Partner_Type__c`  string , `Sells_New_Boats__c`  string , `Software_Usage_Marine_Storage__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-stage/raw/leads/2025-01-09/1736457270'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_leads"
]
    • hive_path: s3://sfdl-csv-salesforce-stage/raw/leads/2025-01-09/1736457270
    • id: 797906
    • processed: 1
    • raw_data: 
      {
    "AC_Product_Interest_Score__c": 231,
    "ATV_s__c": 251,
    "Access_Anywhere__c": 85,
    "Account_Type__c": 70,
    "Account__c": 194,
    "Accounting_Interface__c": 66,
    "Accounting_Software__c": 81,
    "Allowed_to_Auto_Convert__c": 195,
    "AnnualRevenue": 30,
    "Annual_Boat_Club_Revenue__c": 252,
    "Annual_Boat_Sales_Revenue__c": 253,
    "Annual_Marine_Rentals_Revenue__c": 254,
    "Annual_Marine_Service_Revenue__c": 255,
    "Annual_Marine_Storage_Revenue__c": 256,
    "Annual_RV_Campsite_Revenue__c": 257,
    "Authority__c": 89,
    "Best_day_time__c": 150,
    "Billing_Cycle__c": 86,
    "Boats__c": 258,
    "CC_Interface__c": 67,
    "CC_Processing__c": 79,
    "CP_Hubspot_Record_ID__c": 243,
    "Campgrounds__c": 259,
    "Channel__c": 92,
    "Charters_Cruises_Tours__c": 260,
    "City": 11,
    "Club_Boats__c": 261,
    "Company": 9,
    "ConnectionReceivedId": 50,
    "ConnectionSentId": 51,
    "Contact_Match__c": 196,
    "Contact__c": 197,
    "ConvertedAccountId": 36,
    "ConvertedContactId": 37,
    "ConvertedDate": 35,
    "ConvertedOpportunityId": 38,
    "Corp_Code__c": 121,
    "Country": 14,
    "CreatedById": 40,
    "CreatedDate": 39,
    "CurrencyIsoCode": 29,
    "Current_FMS__c": 75,
    "Current_Gate__c": 166,
    "Current_Insurance__c": 167,
    "Current_Marketplace__c": 168,
    "Current_Payment__c": 169,
    "Current_Website__c": 165,
    "DMS_Product_Interest_Score__c": 232,
    "DateTimeLastFormFill__c": 233,
    "Demo_Link__c": 94,
    "Description": 24,
    "Dialpad__IsCreatedFromDialpad__c": 244,
    "Dialpad__Powerdialer_Assigned_List__c": 245,
    "Dialpad__Powerdialer_Dialed_List__c": 246,
    "Dialpad__Powerdialer_Last_Dialed_via__c": 247,
    "Dialpad__Timezone__c": 248,
    "Dialpad__TotalNumberOfTimesDialed__c": 249,
    "DoNotCall": 45,
    "EMail_Interface__c": 68,
    "ESS_Product_Interest_Score__c": 234,
    "Email": 21,
    "EmailBouncedDate": 53,
    "EmailBouncedReason": 52,
    "ExporttoHubspot__c": 63,
    "FacilityID__c": 163,
    "Fax": 20,
    "Feature_Code_Initial__c": 72,
    "Feature_Code__c": 71,
    "FirstName": 4,
    "FormSource__c": 162,
    "GCLID__c": 164,
    "Gate_Interface__c": 115,
    "GenderIdentity": 56,
    "GeocodeAccuracy": 17,
    "HasOptedOutOfEmail": 33,
    "HasOptedOutOfFax": 46,
    "Has_Service_Manager__c": 262,
    "Home_Office_Copy_Number__c": 73,
    "Home_Office_Key_Code__c": 90,
    "Hot_Lead__c": 159,
    "Houseboats__c": 263,
    "How_did_you_hear_about_us__c": 151,
    "HubspotPhone__c": 178,
    "HubspotRecordid__c": 181,
    "Hubspot_Customer_Location__c": 235,
    "IGD__Collection_Id__c": 127,
    "Id": 0,
    "IndividualId": 54,
    "Indoor_Heated_Winter__c": 264,
    "Industry": 27,
    "Interest__c": 118,
    "Internet__c": 78,
    "Invoicing__c": 80,
    "IsConverted": 34,
    "IsDeleted": 1,
    "IsPriorityRecord": 57,
    "Jet_Skis__c": 265,
    "Jigsaw": 48,
    "JigsawContactId": 49,
    "Kiosk__c": 91,
    "KronologicCampaigns__c": 171,
    "KronologicStatus__c": 172,
    "LDR_Lists__c": 119,
    "LastActivityDate": 44,
    "LastModifiedById": 42,
    "LastModifiedDate": 41,
    "LastName": 3,
    "LastTransferDate": 47,
    "Last_Attempted_Match_to_Existing_Account__c": 198,
    "Last_Attempted_Match_to_Existing_Contact__c": 199,
    "Last_Rate_Change__c": 83,
    "Last_Upgrade_Version__c": 102,
    "Last_Upgrade__c": 101,
    "Latitude": 15,
    "LeadSource": 25,
    "Lead_Handling__c": 213,
    "Lead_Notes__c": 158,
    "Lead_Quality__c": 230,
    "Lead_Score__c": 236,
    "Lead_Source_Email__c": 74,
    "Lead_Source_SF__c": 100,
    "Lead_Source_Text__c": 124,
    "Leadliaison__LLBounced__c": 214,
    "Leadliaison__LLFirstTouchCampaignName__c": 215,
    "Leadliaison__LLFirstTouchProgramName__c": 216,
    "Leadliaison__LLLastSearchEngine__c": 217,
    "Leadliaison__LLLastSearchPhrase__c": 218,
    "Leadliaison__LLLastSyncToLeadLiaisonWebApp__c": 219,
    "Leadliaison__LLLastVisitTime__c": 220,
    "Leadliaison__LLLastWebVisit__c": 221,
    "Leadliaison__LLLeadLiaisonGrade__c": 222,
    "Leadliaison__LLLeadLiaisonScore__c": 223,
    "Leadliaison__LLOriginalReferralSource__c": 224,
    "Leadliaison__LLTotalWebVisits__c": 225,
    "Leadliaison__LL_Profile_ID__c": 226,
    "Leadliaison__LL_Total_Activity__c": 227,
    "Location_Code__c": 122,
    "Locations__c": 77,
    "Lodging_Cabins__c": 266,
    "Longitude": 16,
    "Marine_Boat_Club__c": 267,
    "Marine_Boat_Sales__c": 268,
    "Marine_HubSpot_ID__c": 269,
    "Marine_Rentals__c": 270,
    "Marine_Service__c": 271,
    "Marine_Storage__c": 272,
    "MasterRecordId": 2,
    "MobilePhone": 19,
    "Mobile_Service__c": 273,
    "Most_Recent_HubSpot_Message__c": 180,
    "MultiUser__c": 103,
    "Name": 6,
    "Needs__c": 87,
    "Non_Powered__c": 274,
    "Not_Interested__c": 126,
    "Num_ATV_s__c": 275,
    "Num_Boats__c": 276,
    "Num_Campgrounds__c": 277,
    "Num_Charters_Cruises_Tours__c": 278,
    "Num_Club_Boats__c": 279,
    "Num_Houseboats__c": 280,
    "Num_Indoor_Heated_Winter__c": 281,
    "Num_Jet_Skis__c": 282,
    "Num_Lodging_Cabins__c": 283,
    "Num_Non_Powered__c": 284,
    "Num_Outdoor_Parking_Lot_Winter__c": 285,
    "Num_RV_Sites__c": 286,
    "Num_Rack_Storage_Valet__c": 287,
    "Num_Snowmobiles__c": 288,
    "Num_Wet_Slips__c": 289,
    "Num_Yacht_Club_Slips__c": 290,
    "NumberOfEmployees": 31,
    "NumberOfFormFills__c": 237,
    "Occupancy__c": 84,
    "Offsite_Reporting__c": 82,
    "Old_Account_Id__c": 62,
    "Old_Contact_Id__c": 69,
    "Online_Listing_Service__c": 148,
    "Opportunity_Business_Segment_Detail__c": 173,
    "Opportunity_Type__c": 228,
    "Outdoor_Parking_Lot_Winter__c": 291,
    "OwnerId": 32,
    "P_C_Product_Interest_Score__c": 238,
    "Pardot_Campaign__c": 97,
    "Pardot_Primary_Campaign_Source__c": 98,
    "Phone": 18,
    "PhotoUrl": 23,
    "Please_provide_more_info__c": 125,
    "PostalCode": 13,
    "Pre_Call_Email__c": 93,
    "Product_Interest__c": 61,
    "Projected_MRR__c": 170,
    "Promotion__c": 149,
    "Pronouns": 55,
    "RV_Campsite__c": 292,
    "RV_Sites__c": 293,
    "Rack_Storage_Valet__c": 294,
    "Rating": 28,
    "Reason_for_contacting_u__c": 128,
    "Reason_for_non_compliance__c": 239,
    "RecentCampaign__c": 179,
    "RecordTypeId": 7,
    "Referral_Entity__c": 295,
    "Referral_Partner_Type__c": 296,
    "Registration_Code__c": 104,
    "Revenue_Mgmt__c": 105,
    "SE_SF_Lead_ID__c": 161,
    "SFGA__CorrelationID__c": 58,
    "SFGA__Correlation_Data__c": 59,
    "SFGA__Web_Source__c": 60,
    "SF_Lead_ID__c": 157,
    "SLPC_Send_to_Corp_Office__c": 109,
    "SLWE_Billing_Day__c": 110,
    "SLWE_Billing_Frequency__c": 111,
    "SLWE_Billing_Rate__c": 112,
    "SLWE_Paid_by_Credit_Card__c": 113,
    "SMD_Contract_ID__c": 114,
    "Salutation": 5,
    "Sells_New_Boats__c": 297,
    "Sells_Used_Boats__c": 182,
    "Shop_Service__c": 183,
    "SiteLink_Lite__c": 106,
    "SiteLink_PC_Copy_Number__c": 107,
    "SiteLink_PC_Key_Code__c": 108,
    "SiteLink_Product_Interest_Score__c": 240,
    "Snowmobiles__c": 184,
    "Software_Usage_Marine_Boat_Club__c": 185,
    "Software_Usage_Marine_Boat_Sales__c": 186,
    "Software_Usage_Marine_Rentals__c": 187,
    "Software_Usage_Marine_Service__c": 188,
    "Software_Usage_Marine_Storage__c": 298,
    "Software_Usage_RV_Campsite__c": 189,
    "Source_Page_URL__c": 123,
    "State": 12,
    "Status": 26,
    "Street": 10,
    "SystemModstamp": 43,
    "System_of_Origin__c": 160,
    "TPP_Product_Interest_Score__c": 242,
    "Technicians__c": 190,
    "Timeframe__c": 88,
    "Title": 8,
    "Trade_Show_Support_Issue__c": 229,
    "Trash_Reason__c": 156,
    "UConference__UberConferenceId__c": 250,
    "UTM_term__c": 200,
    "Units__c": 76,
    "Vanilla__ForumUrl__c": 99,
    "Web_Form_Date__c": 177,
    "Web_Lead_Comments__c": 120,
    "Website": 22,
    "Wet_Slips__c": 191,
    "Work_Orders__c": 192,
    "Yacht_Club_Slips__c": 193,
    "dupcheck__dc3DisableDuplicateCheck__c": 174,
    "dupcheck__dc3Index__c": 175,
    "dupcheck__dc3Web2Lead__c": 176,
    "of_Databases__c": 64,
    "of_Units__c": 65,
    "pi__Needs_Score_Synced__c": 95,
    "pi__Pardot_Last_Scored_At__c": 96,
    "pi__campaign__c": 116,
    "pi__comments__c": 129,
    "pi__conversion_date__c": 130,
    "pi__conversion_object_name__c": 131,
    "pi__conversion_object_type__c": 132,
    "pi__created_date__c": 133,
    "pi__first_activity__c": 134,
    "pi__first_search_term__c": 135,
    "pi__first_search_type__c": 136,
    "pi__first_touch_url__c": 137,
    "pi__grade__c": 138,
    "pi__last_activity__c": 139,
    "pi__notes__c": 140,
    "pi__pardot_hard_bounced__c": 152,
    "pi__score__c": 141,
    "pi__url__c": 142,
    "pi__utm_campaign__c": 143,
    "pi__utm_content__c": 144,
    "pi__utm_medium__c": 145,
    "pi__utm_source__c": 146,
    "pi__utm_term__c": 147,
    "smartystreets__Address_Do_Not_Verify__c": 203,
    "smartystreets__Address_Footnotes__c": 204,
    "smartystreets__Address_Last_Verified__c": 205,
    "smartystreets__Address_Latitude__c": 206,
    "smartystreets__Address_Longitude__c": 207,
    "smartystreets__Address_Return_Code__c": 208,
    "smartystreets__Address_Verified__c": 209,
    "smartystreets__Clean_Street__c": 210,
    "smartystreets__In_Batch__c": 211,
    "smartystreets__VerificationUsed__c": 212,
    "storEDGE_Product_Interest_Score__c": 241,
    "utm_ad__c": 154,
    "utm_campaign__c": 153,
    "utm_content__c": 201,
    "utm_keyword__c": 155,
    "utm_medium__c": 202,
    "utm_source__c": 117
}
    • schema_attributes: 
      {
    "AC_Product_Interest_Score__c": "string",
    "ATV_s__c": "string",
    "Access_Anywhere__c": "string",
    "Account_Type__c": "string",
    "Account__c": "string",
    "Accounting_Interface__c": "string",
    "Accounting_Software__c": "string",
    "Allowed_to_Auto_Convert__c": "string",
    "Amount": "string",
    "AnnualRevenue": "string",
    "Annual_Boat_Club_Revenue__c": "string",
    "Annual_Boat_Sales_Revenue__c": "string",
    "Annual_Marine_Rentals_Revenue__c": "string",
    "Annual_Marine_Service_Revenue__c": "string",
    "Annual_Marine_Storage_Revenue__c": "string",
    "Annual_RV_Campsite_Revenue__c": "string",
    "Authority__c": "string",
    "Best_day_time__c": "string",
    "Billing_Cycle__c": "string",
    "Boats__c": "string",
    "CC_Interface__c": "string",
    "CC_Processing__c": "string",
    "CP_Hubspot_Record_ID__c": "string",
    "Campgrounds__c": "string",
    "Channel__c": "string",
    "Charters_Cruises_Tours__c": "string",
    "City": "string",
    "CloseDate": "string",
    "Club_Boats__c": "string",
    "Company": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact_Match__c": "string",
    "Contact__c": "string",
    "ConvertedAccountId": "string",
    "ConvertedContactId": "string",
    "ConvertedDate": "string",
    "ConvertedOpportunityId": "string",
    "Converted_Lead__c": "string",
    "Corp_Code__c": "string",
    "Country": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Current_FMS__c": "string",
    "Current_Gate__c": "string",
    "Current_Insurance__c": "string",
    "Current_Marketplace__c": "string",
    "Current_Payment__c": "string",
    "Current_Website__c": "string",
    "DMS_Product_Interest_Score__c": "string",
    "DateTimeLastFormFill__c": "string",
    "Demo_Link__c": "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",
    "EMail_Interface__c": "string",
    "ESS_Product_Interest_Score__c": "string",
    "Email": "string",
    "EmailBouncedDate": "string",
    "EmailBouncedReason": "string",
    "ExpectedRevenue": "string",
    "ExporttoHubspot__c": "string",
    "FacilityID__c": "string",
    "Fax": "string",
    "Feature_Code_Initial__c": "string",
    "Feature_Code__c": "string",
    "FirstName": "string",
    "ForecastCategory": "string",
    "FormSource__c": "string",
    "GCLID__c": "string",
    "Gate_Interface__c": "string",
    "GenderIdentity": "string",
    "GeocodeAccuracy": "string",
    "HasOptedOutOfEmail": "string",
    "HasOptedOutOfFax": "string",
    "Has_Service_Manager__c": "string",
    "Home_Office_Copy_Number__c": "string",
    "Home_Office_Key_Code__c": "string",
    "Hot_Lead__c": "string",
    "Houseboats__c": "string",
    "How_did_you_hear_about_us__c": "string",
    "HubspotPhone__c": "string",
    "HubspotRecordid__c": "string",
    "Hubspot_Customer_Location__c": "string",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "IndividualId": "string",
    "Indoor_Heated_Winter__c": "string",
    "Industry": "string",
    "Interest__c": "string",
    "Internet__c": "string",
    "Invoicing__c": "string",
    "IsConverted": "string",
    "IsDeleted": "string",
    "IsPriorityRecord": "string",
    "Jet_Skis__c": "string",
    "Jigsaw": "string",
    "JigsawContactId": "string",
    "Kiosk__c": "string",
    "KronologicCampaigns__c": "string",
    "KronologicStatus__c": "string",
    "LDR_Lists__c": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LastName": "string",
    "LastTransferDate": "string",
    "Last_Attempted_Match_to_Existing_Account__c": "string",
    "Last_Attempted_Match_to_Existing_Contact__c": "string",
    "Last_Rate_Change__c": "string",
    "Last_Upgrade_Version__c": "string",
    "Last_Upgrade__c": "string",
    "Latitude": "string",
    "LeadSource": "string",
    "Lead_Handling__c": "string",
    "Lead_Notes__c": "string",
    "Lead_Quality__c": "string",
    "Lead_Score__c": "string",
    "Lead_Source_Email__c": "string",
    "Lead_Source_SF__c": "string",
    "Lead_Source_Text__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",
    "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",
    "Location_Code__c": "string",
    "Locations__c": "string",
    "Lodging_Cabins__c": "string",
    "Longitude": "string",
    "Marine_Boat_Club__c": "string",
    "Marine_Boat_Sales__c": "string",
    "Marine_HubSpot_ID__c": "string",
    "Marine_Rentals__c": "string",
    "Marine_Service__c": "string",
    "Marine_Storage__c": "string",
    "MasterRecordId": "string",
    "MobilePhone": "string",
    "Mobile_Service__c": "string",
    "Most_Recent_HubSpot_Message__c": "string",
    "MultiUser__c": "string",
    "Name": "string",
    "Needs__c": "string",
    "Non_Powered__c": "string",
    "Not_Interested__c": "string",
    "Num_ATV_s__c": "string",
    "Num_Boats__c": "string",
    "Num_Campgrounds__c": "string",
    "Num_Charters_Cruises_Tours__c": "string",
    "Num_Club_Boats__c": "string",
    "Num_Houseboats__c": "string",
    "Num_Indoor_Heated_Winter__c": "string",
    "Num_Jet_Skis__c": "string",
    "Num_Lodging_Cabins__c": "string",
    "Num_Non_Powered__c": "string",
    "Num_Outdoor_Parking_Lot_Winter__c": "string",
    "Num_RV_Sites__c": "string",
    "Num_Rack_Storage_Valet__c": "string",
    "Num_Snowmobiles__c": "string",
    "Num_Wet_Slips__c": "string",
    "Num_Yacht_Club_Slips__c": "string",
    "NumberOfEmployees": "string",
    "NumberOfFormFills__c": "string",
    "Occupancy__c": "string",
    "Offsite_Reporting__c": "string",
    "Old_Account_Id__c": "string",
    "Old_Contact_Id__c": "string",
    "Online_Listing_Service__c": "string",
    "OpportunityId": "string",
    "Opportunity_Business_Segment_Detail__c": "string",
    "Opportunity_Type__c": "string",
    "Outdoor_Parking_Lot_Winter__c": "string",
    "OwnerId": "string",
    "P_C_Product_Interest_Score__c": "string",
    "Pardot_Campaign__c": "string",
    "Pardot_Primary_Campaign_Source__c": "string",
    "Phone": "string",
    "PhotoUrl": "string",
    "Please_provide_more_info__c": "string",
    "PostalCode": "string",
    "Pre_Call_Email__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Interest__c": "string",
    "Projected_MRR__c": "string",
    "Promotion__c": "string",
    "Pronouns": "string",
    "RV_Campsite__c": "string",
    "RV_Sites__c": "string",
    "Rack_Storage_Valet__c": "string",
    "Rating": "string",
    "Reason_for_contacting_u__c": "string",
    "Reason_for_non_compliance__c": "string",
    "RecentCampaign__c": "string",
    "RecordTypeId": "string",
    "Referral_Entity__c": "string",
    "Referral_Partner_Type__c": "string",
    "Registration_Code__c": "string",
    "Revenue_Mgmt__c": "string",
    "SE_SF_Lead_ID__c": "string",
    "SFGA__CorrelationID__c": "string",
    "SFGA__Correlation_Data__c": "string",
    "SFGA__Web_Source__c": "string",
    "SF_Lead_ID__c": "string",
    "SLPC_Send_to_Corp_Office__c": "string",
    "SLWE_Billing_Day__c": "string",
    "SLWE_Billing_Frequency__c": "string",
    "SLWE_Billing_Rate__c": "string",
    "SLWE_Paid_by_Credit_Card__c": "string",
    "SMD_Contract_ID__c": "string",
    "Salutation": "string",
    "Sells_New_Boats__c": "string",
    "Sells_Used_Boats__c": "string",
    "Shop_Service__c": "string",
    "SiteLink_Lite__c": "string",
    "SiteLink_PC_Copy_Number__c": "string",
    "SiteLink_PC_Key_Code__c": "string",
    "SiteLink_Product_Interest_Score__c": "string",
    "Snowmobiles__c": "string",
    "Software_Usage_Marine_Boat_Club__c": "string",
    "Software_Usage_Marine_Boat_Sales__c": "string",
    "Software_Usage_Marine_Rentals__c": "string",
    "Software_Usage_Marine_Service__c": "string",
    "Software_Usage_Marine_Storage__c": "string",
    "Software_Usage_RV_Campsite__c": "string",
    "Source_Page_URL__c": "string",
    "StageName": "string",
    "State": "string",
    "Status": "string",
    "Street": "string",
    "SystemModstamp": "string",
    "System_of_Origin__c": "string",
    "TPP_Product_Interest_Score__c": "string",
    "Technicians__c": "string",
    "Timeframe__c": "string",
    "Title": "string",
    "Trade_Show_Support_Issue__c": "string",
    "Trash_Reason__c": "string",
    "UConference__UberConferenceId__c": "string",
    "UTM_term__c": "string",
    "Units__c": "string",
    "Vanilla__ForumUrl__c": "string",
    "Web_Form_Date__c": "string",
    "Web_Lead_Comments__c": "string",
    "Website": "string",
    "Wet_Slips__c": "string",
    "Work_Orders__c": "string",
    "Yacht_Club_Slips__c": "string",
    "dupcheck__dc3DisableDuplicateCheck__c": "string",
    "dupcheck__dc3Index__c": "string",
    "dupcheck__dc3Web2Lead__c": "string",
    "of_Databases__c": "string",
    "of_Units__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",
    "smartystreets__Address_Do_Not_Verify__c": "string",
    "smartystreets__Address_Footnotes__c": "string",
    "smartystreets__Address_Last_Verified__c": "string",
    "smartystreets__Address_Latitude__c": "string",
    "smartystreets__Address_Longitude__c": "string",
    "smartystreets__Address_Return_Code__c": "string",
    "smartystreets__Address_Verified__c": "string",
    "smartystreets__Clean_Street__c": "string",
    "smartystreets__In_Batch__c": "string",
    "smartystreets__VerificationUsed__c": "string",
    "storEDGE_Product_Interest_Score__c": "string",
    "utm_ad__c": "string",
    "utm_campaign__c": "string",
    "utm_content__c": "string",
    "utm_keyword__c": "string",
    "utm_medium__c": "string",
    "utm_source__c": "string"
}
    • schema_name_id: 1435
    • schema_scan_id: 6197219
    • updated: 2025-01-09 15:16:00
    • created: 2024-05-01 08:55:34
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_leads`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.salesforce_leads`\n(\n `Id`  string , `IsDeleted`  string , `MasterRecordId`  string , `LastName`  string , `FirstName`  string , `Salutation`  string , `Name`  string , `RecordTypeId`  string , `Title`  string , `Company`  string , `Street`  string , `City`  string , `State`  string , `PostalCode`  string , `Country`  string , `Latitude`  string , `Longitude`  string , `GeocodeAccuracy`  string , `Phone`  string , `MobilePhone`  string , `Fax`  string , `Email`  string , `Website`  string , `PhotoUrl`  string , `Description`  string , `LeadSource`  string , `Status`  string , `Industry`  string , `Rating`  string , `CurrencyIsoCode`  string , `AnnualRevenue`  string , `NumberOfEmployees`  string , `OwnerId`  string , `HasOptedOutOfEmail`  string , `IsConverted`  string , `ConvertedDate`  string , `ConvertedAccountId`  string , `ConvertedContactId`  string , `ConvertedOpportunityId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `DoNotCall`  string , `HasOptedOutOfFax`  string , `LastTransferDate`  string , `Jigsaw`  string , `JigsawContactId`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `EmailBouncedReason`  string , `EmailBouncedDate`  string , `IndividualId`  string , `Pronouns`  string , `GenderIdentity`  string , `SFGA__CorrelationID__c`  string , `SFGA__Correlation_Data__c`  string , `SFGA__Web_Source__c`  string , `Product_Interest__c`  string , `Old_Account_Id__c`  string , `ExporttoHubspot__c`  string , `of_Databases__c`  string , `of_Units__c`  string , `Accounting_Interface__c`  string , `CC_Interface__c`  string , `EMail_Interface__c`  string , `Old_Contact_Id__c`  string , `Account_Type__c`  string , `Feature_Code__c`  string , `Feature_Code_Initial__c`  string , `Home_Office_Copy_Number__c`  string , `Lead_Source_Email__c`  string , `Current_FMS__c`  string , `Units__c`  string , `Locations__c`  string , `Internet__c`  string , `CC_Processing__c`  string , `Invoicing__c`  string , `Accounting_Software__c`  string , `Offsite_Reporting__c`  string , `Last_Rate_Change__c`  string , `Occupancy__c`  string , `Access_Anywhere__c`  string , `Billing_Cycle__c`  string , `Needs__c`  string , `Timeframe__c`  string , `Authority__c`  string , `Home_Office_Key_Code__c`  string , `Kiosk__c`  string , `Channel__c`  string , `Pre_Call_Email__c`  string , `Demo_Link__c`  string , `pi__Needs_Score_Synced__c`  string , `pi__Pardot_Last_Scored_At__c`  string , `Pardot_Campaign__c`  string , `Pardot_Primary_Campaign_Source__c`  string , `Vanilla__ForumUrl__c`  string , `Lead_Source_SF__c`  string , `Last_Upgrade__c`  string , `Last_Upgrade_Version__c`  string , `MultiUser__c`  string , `Registration_Code__c`  string , `Revenue_Mgmt__c`  string , `SiteLink_Lite__c`  string , `SiteLink_PC_Copy_Number__c`  string , `SiteLink_PC_Key_Code__c`  string , `SLPC_Send_to_Corp_Office__c`  string , `SLWE_Billing_Day__c`  string , `SLWE_Billing_Frequency__c`  string , `SLWE_Billing_Rate__c`  string , `SLWE_Paid_by_Credit_Card__c`  string , `SMD_Contract_ID__c`  string , `Gate_Interface__c`  string , `pi__campaign__c`  string , `utm_source__c`  string , `Interest__c`  string , `LDR_Lists__c`  string , `Web_Lead_Comments__c`  string , `Corp_Code__c`  string , `Location_Code__c`  string , `Source_Page_URL__c`  string , `Lead_Source_Text__c`  string , `Please_provide_more_info__c`  string , `Not_Interested__c`  string , `IGD__Collection_Id__c`  string , `Reason_for_contacting_u__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 , `Online_Listing_Service__c`  string , `Promotion__c`  string , `Best_day_time__c`  string , `How_did_you_hear_about_us__c`  string , `pi__pardot_hard_bounced__c`  string , `utm_campaign__c`  string , `utm_ad__c`  string , `utm_keyword__c`  string , `Trash_Reason__c`  string , `SF_Lead_ID__c`  string , `Lead_Notes__c`  string , `Hot_Lead__c`  string , `System_of_Origin__c`  string , `SE_SF_Lead_ID__c`  string , `FormSource__c`  string , `FacilityID__c`  string , `GCLID__c`  string , `Current_Website__c`  string , `Current_Gate__c`  string , `Current_Insurance__c`  string , `Current_Marketplace__c`  string , `Current_Payment__c`  string , `Projected_MRR__c`  string , `KronologicCampaigns__c`  string , `KronologicStatus__c`  string , `Opportunity_Business_Segment_Detail__c`  string , `dupcheck__dc3DisableDuplicateCheck__c`  string , `dupcheck__dc3Index__c`  string , `dupcheck__dc3Web2Lead__c`  string , `Web_Form_Date__c`  string , `HubspotPhone__c`  string , `RecentCampaign__c`  string , `Most_Recent_HubSpot_Message__c`  string , `HubspotRecordid__c`  string , `smartystreets__Address_Do_Not_Verify__c`  string , `smartystreets__Address_Footnotes__c`  string , `smartystreets__Address_Last_Verified__c`  string , `smartystreets__Address_Latitude__c`  string , `smartystreets__Address_Longitude__c`  string , `smartystreets__Address_Return_Code__c`  string , `smartystreets__Address_Verified__c`  string , `smartystreets__Clean_Street__c`  string , `smartystreets__In_Batch__c`  string , `smartystreets__VerificationUsed__c`  string , `Lead_Handling__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 , `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 , `Opportunity_Type__c`  string , `Trade_Show_Support_Issue__c`  string , `Lead_Quality__c`  string , `AC_Product_Interest_Score__c`  string , `DMS_Product_Interest_Score__c`  string , `DateTimeLastFormFill__c`  string , `ESS_Product_Interest_Score__c`  string , `Hubspot_Customer_Location__c`  string , `Lead_Score__c`  string , `NumberOfFormFills__c`  string , `P_C_Product_Interest_Score__c`  string , `Reason_for_non_compliance__c`  string , `SiteLink_Product_Interest_Score__c`  string , `storEDGE_Product_Interest_Score__c`  string , `TPP_Product_Interest_Score__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 , `Converted_Lead__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-stage/raw/leads/2024-05-01/1714571569'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_leads"
]
    • hive_path: s3://sfdl-csv-salesforce-stage/raw/leads/2024-05-01/1714571569
    • id: 693453
    • processed: 1
    • raw_data: 
      {
    "AC_Product_Interest_Score__c": 209,
    "Access_Anywhere__c": 84,
    "Account_Type__c": 69,
    "Accounting_Interface__c": 65,
    "Accounting_Software__c": 80,
    "AnnualRevenue": 30,
    "Authority__c": 88,
    "Best_day_time__c": 149,
    "Billing_Cycle__c": 85,
    "CC_Interface__c": 66,
    "CC_Processing__c": 78,
    "CP_Hubspot_Record_ID__c": 221,
    "Channel__c": 91,
    "City": 11,
    "Company": 9,
    "ConnectionReceivedId": 50,
    "ConnectionSentId": 51,
    "ConvertedAccountId": 36,
    "ConvertedContactId": 37,
    "ConvertedDate": 35,
    "ConvertedOpportunityId": 38,
    "Converted_Lead__c": 229,
    "Corp_Code__c": 120,
    "Country": 14,
    "CreatedById": 40,
    "CreatedDate": 39,
    "CurrencyIsoCode": 29,
    "Current_FMS__c": 74,
    "Current_Gate__c": 165,
    "Current_Insurance__c": 166,
    "Current_Marketplace__c": 167,
    "Current_Payment__c": 168,
    "Current_Website__c": 164,
    "DMS_Product_Interest_Score__c": 210,
    "DateTimeLastFormFill__c": 211,
    "Demo_Link__c": 93,
    "Description": 24,
    "Dialpad__IsCreatedFromDialpad__c": 222,
    "Dialpad__Powerdialer_Assigned_List__c": 223,
    "Dialpad__Powerdialer_Dialed_List__c": 224,
    "Dialpad__Powerdialer_Last_Dialed_via__c": 225,
    "Dialpad__Timezone__c": 226,
    "Dialpad__TotalNumberOfTimesDialed__c": 227,
    "DoNotCall": 45,
    "EMail_Interface__c": 67,
    "ESS_Product_Interest_Score__c": 212,
    "Email": 21,
    "EmailBouncedDate": 53,
    "EmailBouncedReason": 52,
    "ExporttoHubspot__c": 62,
    "FacilityID__c": 162,
    "Fax": 20,
    "Feature_Code_Initial__c": 71,
    "Feature_Code__c": 70,
    "FirstName": 4,
    "FormSource__c": 161,
    "GCLID__c": 163,
    "Gate_Interface__c": 114,
    "GenderIdentity": 56,
    "GeocodeAccuracy": 17,
    "HasOptedOutOfEmail": 33,
    "HasOptedOutOfFax": 46,
    "Home_Office_Copy_Number__c": 72,
    "Home_Office_Key_Code__c": 89,
    "Hot_Lead__c": 158,
    "How_did_you_hear_about_us__c": 150,
    "HubspotPhone__c": 177,
    "HubspotRecordid__c": 180,
    "Hubspot_Customer_Location__c": 213,
    "IGD__Collection_Id__c": 126,
    "Id": 0,
    "IndividualId": 54,
    "Industry": 27,
    "Interest__c": 117,
    "Internet__c": 77,
    "Invoicing__c": 79,
    "IsConverted": 34,
    "IsDeleted": 1,
    "Jigsaw": 48,
    "JigsawContactId": 49,
    "Kiosk__c": 90,
    "KronologicCampaigns__c": 170,
    "KronologicStatus__c": 171,
    "LDR_Lists__c": 118,
    "LastActivityDate": 44,
    "LastModifiedById": 42,
    "LastModifiedDate": 41,
    "LastName": 3,
    "LastTransferDate": 47,
    "Last_Rate_Change__c": 82,
    "Last_Upgrade_Version__c": 101,
    "Last_Upgrade__c": 100,
    "Latitude": 15,
    "LeadSource": 25,
    "Lead_Handling__c": 191,
    "Lead_Notes__c": 157,
    "Lead_Quality__c": 208,
    "Lead_Score__c": 214,
    "Lead_Source_Email__c": 73,
    "Lead_Source_SF__c": 99,
    "Lead_Source_Text__c": 123,
    "Leadliaison__LLBounced__c": 192,
    "Leadliaison__LLFirstTouchCampaignName__c": 193,
    "Leadliaison__LLFirstTouchProgramName__c": 194,
    "Leadliaison__LLLastSearchEngine__c": 195,
    "Leadliaison__LLLastSearchPhrase__c": 196,
    "Leadliaison__LLLastSyncToLeadLiaisonWebApp__c": 197,
    "Leadliaison__LLLastVisitTime__c": 198,
    "Leadliaison__LLLastWebVisit__c": 199,
    "Leadliaison__LLLeadLiaisonGrade__c": 200,
    "Leadliaison__LLLeadLiaisonScore__c": 201,
    "Leadliaison__LLOriginalReferralSource__c": 202,
    "Leadliaison__LLTotalWebVisits__c": 203,
    "Leadliaison__LL_Profile_ID__c": 204,
    "Leadliaison__LL_Total_Activity__c": 205,
    "Location_Code__c": 121,
    "Locations__c": 76,
    "Longitude": 16,
    "MasterRecordId": 2,
    "MobilePhone": 19,
    "Most_Recent_HubSpot_Message__c": 179,
    "MultiUser__c": 102,
    "Name": 6,
    "Needs__c": 86,
    "Not_Interested__c": 125,
    "NumberOfEmployees": 31,
    "NumberOfFormFills__c": 215,
    "Occupancy__c": 83,
    "Offsite_Reporting__c": 81,
    "Old_Account_Id__c": 61,
    "Old_Contact_Id__c": 68,
    "Online_Listing_Service__c": 147,
    "Opportunity_Business_Segment_Detail__c": 172,
    "Opportunity_Type__c": 206,
    "OwnerId": 32,
    "P_C_Product_Interest_Score__c": 216,
    "Pardot_Campaign__c": 96,
    "Pardot_Primary_Campaign_Source__c": 97,
    "Phone": 18,
    "PhotoUrl": 23,
    "Please_provide_more_info__c": 124,
    "PostalCode": 13,
    "Pre_Call_Email__c": 92,
    "Product_Interest__c": 60,
    "Projected_MRR__c": 169,
    "Promotion__c": 148,
    "Pronouns": 55,
    "Rating": 28,
    "Reason_for_contacting_u__c": 127,
    "Reason_for_non_compliance__c": 217,
    "RecentCampaign__c": 178,
    "RecordTypeId": 7,
    "Registration_Code__c": 103,
    "Revenue_Mgmt__c": 104,
    "SE_SF_Lead_ID__c": 160,
    "SFGA__CorrelationID__c": 57,
    "SFGA__Correlation_Data__c": 58,
    "SFGA__Web_Source__c": 59,
    "SF_Lead_ID__c": 156,
    "SLPC_Send_to_Corp_Office__c": 108,
    "SLWE_Billing_Day__c": 109,
    "SLWE_Billing_Frequency__c": 110,
    "SLWE_Billing_Rate__c": 111,
    "SLWE_Paid_by_Credit_Card__c": 112,
    "SMD_Contract_ID__c": 113,
    "Salutation": 5,
    "SiteLink_Lite__c": 105,
    "SiteLink_PC_Copy_Number__c": 106,
    "SiteLink_PC_Key_Code__c": 107,
    "SiteLink_Product_Interest_Score__c": 218,
    "Source_Page_URL__c": 122,
    "State": 12,
    "Status": 26,
    "Street": 10,
    "SystemModstamp": 43,
    "System_of_Origin__c": 159,
    "TPP_Product_Interest_Score__c": 220,
    "Timeframe__c": 87,
    "Title": 8,
    "Trade_Show_Support_Issue__c": 207,
    "Trash_Reason__c": 155,
    "UConference__UberConferenceId__c": 228,
    "Units__c": 75,
    "Vanilla__ForumUrl__c": 98,
    "Web_Form_Date__c": 176,
    "Web_Lead_Comments__c": 119,
    "Website": 22,
    "dupcheck__dc3DisableDuplicateCheck__c": 173,
    "dupcheck__dc3Index__c": 174,
    "dupcheck__dc3Web2Lead__c": 175,
    "of_Databases__c": 63,
    "of_Units__c": 64,
    "pi__Needs_Score_Synced__c": 94,
    "pi__Pardot_Last_Scored_At__c": 95,
    "pi__campaign__c": 115,
    "pi__comments__c": 128,
    "pi__conversion_date__c": 129,
    "pi__conversion_object_name__c": 130,
    "pi__conversion_object_type__c": 131,
    "pi__created_date__c": 132,
    "pi__first_activity__c": 133,
    "pi__first_search_term__c": 134,
    "pi__first_search_type__c": 135,
    "pi__first_touch_url__c": 136,
    "pi__grade__c": 137,
    "pi__last_activity__c": 138,
    "pi__notes__c": 139,
    "pi__pardot_hard_bounced__c": 151,
    "pi__score__c": 140,
    "pi__url__c": 141,
    "pi__utm_campaign__c": 142,
    "pi__utm_content__c": 143,
    "pi__utm_medium__c": 144,
    "pi__utm_source__c": 145,
    "pi__utm_term__c": 146,
    "smartystreets__Address_Do_Not_Verify__c": 181,
    "smartystreets__Address_Footnotes__c": 182,
    "smartystreets__Address_Last_Verified__c": 183,
    "smartystreets__Address_Latitude__c": 184,
    "smartystreets__Address_Longitude__c": 185,
    "smartystreets__Address_Return_Code__c": 186,
    "smartystreets__Address_Verified__c": 187,
    "smartystreets__Clean_Street__c": 188,
    "smartystreets__In_Batch__c": 189,
    "smartystreets__VerificationUsed__c": 190,
    "storEDGE_Product_Interest_Score__c": 219,
    "utm_ad__c": 153,
    "utm_campaign__c": 152,
    "utm_keyword__c": 154,
    "utm_source__c": 116
}
    • schema_attributes: 
      {
    "AC_Product_Interest_Score__c": "string",
    "Access_Anywhere__c": "string",
    "Account_Type__c": "string",
    "Accounting_Interface__c": "string",
    "Accounting_Software__c": "string",
    "Amount": "string",
    "AnnualRevenue": "string",
    "Authority__c": "string",
    "Best_day_time__c": "string",
    "Billing_Cycle__c": "string",
    "CC_Interface__c": "string",
    "CC_Processing__c": "string",
    "CP_Hubspot_Record_ID__c": "string",
    "Channel__c": "string",
    "City": "string",
    "CloseDate": "string",
    "Company": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ConvertedAccountId": "string",
    "ConvertedContactId": "string",
    "ConvertedDate": "string",
    "ConvertedOpportunityId": "string",
    "Converted_Lead__c": "string",
    "Corp_Code__c": "string",
    "Country": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Current_FMS__c": "string",
    "Current_Gate__c": "string",
    "Current_Insurance__c": "string",
    "Current_Marketplace__c": "string",
    "Current_Payment__c": "string",
    "Current_Website__c": "string",
    "DMS_Product_Interest_Score__c": "string",
    "DateTimeLastFormFill__c": "string",
    "Demo_Link__c": "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",
    "EMail_Interface__c": "string",
    "ESS_Product_Interest_Score__c": "string",
    "Email": "string",
    "EmailBouncedDate": "string",
    "EmailBouncedReason": "string",
    "ExpectedRevenue": "string",
    "ExporttoHubspot__c": "string",
    "FacilityID__c": "string",
    "Fax": "string",
    "Feature_Code_Initial__c": "string",
    "Feature_Code__c": "string",
    "FirstName": "string",
    "ForecastCategory": "string",
    "FormSource__c": "string",
    "GCLID__c": "string",
    "Gate_Interface__c": "string",
    "GenderIdentity": "string",
    "GeocodeAccuracy": "string",
    "HasOptedOutOfEmail": "string",
    "HasOptedOutOfFax": "string",
    "Home_Office_Copy_Number__c": "string",
    "Home_Office_Key_Code__c": "string",
    "Hot_Lead__c": "string",
    "How_did_you_hear_about_us__c": "string",
    "HubspotPhone__c": "string",
    "HubspotRecordid__c": "string",
    "Hubspot_Customer_Location__c": "string",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "IndividualId": "string",
    "Industry": "string",
    "Interest__c": "string",
    "Internet__c": "string",
    "Invoicing__c": "string",
    "IsConverted": "string",
    "IsDeleted": "string",
    "Jigsaw": "string",
    "JigsawContactId": "string",
    "Kiosk__c": "string",
    "KronologicCampaigns__c": "string",
    "KronologicStatus__c": "string",
    "LDR_Lists__c": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LastName": "string",
    "LastTransferDate": "string",
    "Last_Rate_Change__c": "string",
    "Last_Upgrade_Version__c": "string",
    "Last_Upgrade__c": "string",
    "Latitude": "string",
    "LeadSource": "string",
    "Lead_Handling__c": "string",
    "Lead_Notes__c": "string",
    "Lead_Quality__c": "string",
    "Lead_Score__c": "string",
    "Lead_Source_Email__c": "string",
    "Lead_Source_SF__c": "string",
    "Lead_Source_Text__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",
    "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",
    "Location_Code__c": "string",
    "Locations__c": "string",
    "Longitude": "string",
    "MasterRecordId": "string",
    "MobilePhone": "string",
    "Most_Recent_HubSpot_Message__c": "string",
    "MultiUser__c": "string",
    "Name": "string",
    "Needs__c": "string",
    "Not_Interested__c": "string",
    "NumberOfEmployees": "string",
    "NumberOfFormFills__c": "string",
    "Occupancy__c": "string",
    "Offsite_Reporting__c": "string",
    "Old_Account_Id__c": "string",
    "Old_Contact_Id__c": "string",
    "Online_Listing_Service__c": "string",
    "OpportunityId": "string",
    "Opportunity_Business_Segment_Detail__c": "string",
    "Opportunity_Type__c": "string",
    "OwnerId": "string",
    "P_C_Product_Interest_Score__c": "string",
    "Pardot_Campaign__c": "string",
    "Pardot_Primary_Campaign_Source__c": "string",
    "Phone": "string",
    "PhotoUrl": "string",
    "Please_provide_more_info__c": "string",
    "PostalCode": "string",
    "Pre_Call_Email__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Interest__c": "string",
    "Projected_MRR__c": "string",
    "Promotion__c": "string",
    "Pronouns": "string",
    "Rating": "string",
    "Reason_for_contacting_u__c": "string",
    "Reason_for_non_compliance__c": "string",
    "RecentCampaign__c": "string",
    "RecordTypeId": "string",
    "Registration_Code__c": "string",
    "Revenue_Mgmt__c": "string",
    "SE_SF_Lead_ID__c": "string",
    "SFGA__CorrelationID__c": "string",
    "SFGA__Correlation_Data__c": "string",
    "SFGA__Web_Source__c": "string",
    "SF_Lead_ID__c": "string",
    "SLPC_Send_to_Corp_Office__c": "string",
    "SLWE_Billing_Day__c": "string",
    "SLWE_Billing_Frequency__c": "string",
    "SLWE_Billing_Rate__c": "string",
    "SLWE_Paid_by_Credit_Card__c": "string",
    "SMD_Contract_ID__c": "string",
    "Salutation": "string",
    "SiteLink_Lite__c": "string",
    "SiteLink_PC_Copy_Number__c": "string",
    "SiteLink_PC_Key_Code__c": "string",
    "SiteLink_Product_Interest_Score__c": "string",
    "Source_Page_URL__c": "string",
    "StageName": "string",
    "State": "string",
    "Status": "string",
    "Street": "string",
    "SystemModstamp": "string",
    "System_of_Origin__c": "string",
    "TPP_Product_Interest_Score__c": "string",
    "Timeframe__c": "string",
    "Title": "string",
    "Trade_Show_Support_Issue__c": "string",
    "Trash_Reason__c": "string",
    "UConference__UberConferenceId__c": "string",
    "Units__c": "string",
    "Vanilla__ForumUrl__c": "string",
    "Web_Form_Date__c": "string",
    "Web_Lead_Comments__c": "string",
    "Website": "string",
    "dupcheck__dc3DisableDuplicateCheck__c": "string",
    "dupcheck__dc3Index__c": "string",
    "dupcheck__dc3Web2Lead__c": "string",
    "of_Databases__c": "string",
    "of_Units__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",
    "smartystreets__Address_Do_Not_Verify__c": "string",
    "smartystreets__Address_Footnotes__c": "string",
    "smartystreets__Address_Last_Verified__c": "string",
    "smartystreets__Address_Latitude__c": "string",
    "smartystreets__Address_Longitude__c": "string",
    "smartystreets__Address_Return_Code__c": "string",
    "smartystreets__Address_Verified__c": "string",
    "smartystreets__Clean_Street__c": "string",
    "smartystreets__In_Batch__c": "string",
    "smartystreets__VerificationUsed__c": "string",
    "storEDGE_Product_Interest_Score__c": "string",
    "utm_ad__c": "string",
    "utm_campaign__c": "string",
    "utm_keyword__c": "string",
    "utm_source__c": "string"
}
    • schema_name_id: 1435
    • schema_scan_id: 5671850
    • updated: 2024-05-01 08:55:47
Schema Scans: 3
Last at 2026-02-27 09:13:26
    • duration: 0:00:21.394565
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6391699
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-stage",
        "hive_path": "s3://sfdl-csv-salesforce-stage/raw/leads/2026-02-27/1772205050",
        "key": "raw/leads/2026-02-27/1772205050/leads.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.salesforce_leads",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10001868199846145315,
        "service_name": "drive-thru",
        "span_id": 13452999231240667941,
        "trace_id": 4801613170023876689
    }
}
    • running: False
    • schema_name_id: 1435
    • start_time: 2026-02-27 09:13:26
    • success: True
    • trace_id: 4801613170023876689
    • duration: 0:00:22.498855
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6197219
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-stage",
        "hive_path": "s3://sfdl-csv-salesforce-stage/raw/leads/2025-01-09/1736457270",
        "key": "raw/leads/2025-01-09/1736457270/leads.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.salesforce_leads",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2805749637152221305,
        "service_name": "drive-thru",
        "span_id": 5914002137329653633,
        "trace_id": 11596670466984691810
    }
}
    • running: False
    • schema_name_id: 1435
    • start_time: 2025-01-09 15:15:37
    • success: True
    • trace_id: 11596670466984691810
    • duration: 0:00:21.085096
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 5671850
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-stage",
        "hive_path": "s3://sfdl-csv-salesforce-stage/raw/leads/2024-05-01/1714571569",
        "key": "raw/leads/2024-05-01/1714571569/leads.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.salesforce_leads",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6196735062636115307,
        "service_name": "drive-thru",
        "span_id": 8712556898598952808,
        "trace_id": 5397875299617057895
    }
}
    • running: False
    • schema_name_id: 1435
    • start_time: 2024-05-01 08:55:26
    • success: True
    • trace_id: 5397875299617057895
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "AC_Product_Interest_Score__c": "string",
    "ATV_s__c": "string",
    "Access_Anywhere__c": "string",
    "Account_Type__c": "string",
    "Account__c": "string",
    "Accounting_Interface__c": "string",
    "Accounting_Software__c": "string",
    "Allowed_to_Auto_Convert__c": "string",
    "Amount": "string",
    "AnnualRevenue": "string",
    "Annual_Boat_Club_Revenue__c": "string",
    "Annual_Boat_Sales_Revenue__c": "string",
    "Annual_Marine_Rentals_Revenue__c": "string",
    "Annual_Marine_Service_Revenue__c": "string",
    "Annual_Marine_Storage_Revenue__c": "string",
    "Annual_RV_Campsite_Revenue__c": "string",
    "Authority__c": "string",
    "Best_day_time__c": "string",
    "Billing_Cycle__c": "string",
    "Boats__c": "string",
    "CC_Interface__c": "string",
    "CC_Processing__c": "string",
    "CP_Hubspot_Record_ID__c": "string",
    "Campgrounds__c": "string",
    "Channel__c": "string",
    "Charters_Cruises_Tours__c": "string",
    "City": "string",
    "CloseDate": "string",
    "Club_Boats__c": "string",
    "Company": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact_Match__c": "string",
    "Contact__c": "string",
    "ConvertedAccountId": "string",
    "ConvertedContactId": "string",
    "ConvertedDate": "string",
    "ConvertedOpportunityId": "string",
    "Converted_Lead__c": "string",
    "Corp_Code__c": "string",
    "Country": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Current_FMS__c": "string",
    "Current_Gate__c": "string",
    "Current_Insurance__c": "string",
    "Current_Marketplace__c": "string",
    "Current_Payment__c": "string",
    "Current_Website__c": "string",
    "DMS_Product_Interest_Score__c": "string",
    "Data_Load_By__c": "string",
    "DateTimeLastFormFill__c": "string",
    "Demo_Link__c": "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",
    "EMail_Interface__c": "string",
    "ESS_Product_Interest_Score__c": "string",
    "Email": "string",
    "EmailBouncedDate": "string",
    "EmailBouncedReason": "string",
    "ExpectedRevenue": "string",
    "ExporttoHubspot__c": "string",
    "FacilityID__c": "string",
    "Fax": "string",
    "Feature_Code_Initial__c": "string",
    "Feature_Code__c": "string",
    "FirstName": "string",
    "ForecastCategory": "string",
    "FormSource__c": "string",
    "GCLID__c": "string",
    "Gate_Interface__c": "string",
    "GenderIdentity": "string",
    "GeocodeAccuracy": "string",
    "Gong__Active_Engage_Flow_Names__c": "string",
    "Gong__Actively_Being_in_a_Flow__c": "string",
    "Gong__Added_to_Flow_Date__c": "string",
    "Gong__Current_Flow_ID__c": "string",
    "Gong__Current_Flow_Name__c": "string",
    "Gong__Current_Flow_Step_Number__c": "string",
    "Gong__Current_Flow_Step_Type__c": "string",
    "Gong__Current_Flow_Task_Due_Date__c": "string",
    "Gong__Current_Flow_User_Name__c": "string",
    "Gong__Engage_Flow_Owner__c": "string",
    "Gong__Engage_Last_Step_Completed_Date__c": "string",
    "Gong__Flow_Execution_ID__c": "string",
    "Gong__Flow_Status__c": "string",
    "Gong__Number_of_Active_Engage_Flows__c": "string",
    "Gong__NumberofLocations__c": "string",
    "HasOptedOutOfEmail": "string",
    "HasOptedOutOfFax": "string",
    "Has_Service_Manager__c": "string",
    "Home_Office_Copy_Number__c": "string",
    "Home_Office_Key_Code__c": "string",
    "Hot_Lead__c": "string",
    "Houseboats__c": "string",
    "How_did_you_hear_about_us__c": "string",
    "HubspotPhone__c": "string",
    "HubspotRecordid__c": "string",
    "Hubspot_Customer_Location__c": "string",
    "Hubspot_Form_Action_Type__c": "string",
    "Hubspot_Latest_Traffic_Source__c": "string",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "IndividualId": "string",
    "Indoor_Heated_Winter__c": "string",
    "Industry": "string",
    "Interest__c": "string",
    "Internet__c": "string",
    "Invoicing__c": "string",
    "IsConverted": "string",
    "IsDeleted": "string",
    "IsPriorityRecord": "string",
    "Jet_Skis__c": "string",
    "Jigsaw": "string",
    "JigsawContactId": "string",
    "Kiosk__c": "string",
    "KronologicCampaigns__c": "string",
    "KronologicStatus__c": "string",
    "LDR_Lists__c": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LastName": "string",
    "LastTransferDate": "string",
    "Last_Attempted_Match_to_Existing_Account__c": "string",
    "Last_Attempted_Match_to_Existing_Contact__c": "string",
    "Last_Rate_Change__c": "string",
    "Last_Upgrade_Version__c": "string",
    "Last_Upgrade__c": "string",
    "Latitude": "string",
    "LeadSource": "string",
    "Lead_Handling__c": "string",
    "Lead_Notes__c": "string",
    "Lead_Quality__c": "string",
    "Lead_Score__c": "string",
    "Lead_Source_Email__c": "string",
    "Lead_Source_SF__c": "string",
    "Lead_Source_Text__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",
    "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",
    "Location_Code__c": "string",
    "Locations__c": "string",
    "Lodging_Cabins__c": "string",
    "Longitude": "string",
    "Marine_Boat_Club__c": "string",
    "Marine_Boat_Sales__c": "string",
    "Marine_HubSpot_ID__c": "string",
    "Marine_Product_Interest__c": "string",
    "Marine_Rentals__c": "string",
    "Marine_Service__c": "string",
    "Marine_Storage__c": "string",
    "MasterRecordId": "string",
    "MobilePhone": "string",
    "Mobile_Service__c": "string",
    "Most_Recent_HubSpot_Message__c": "string",
    "MultiUser__c": "string",
    "Name": "string",
    "Needs__c": "string",
    "Non_Powered__c": "string",
    "Not_Interested__c": "string",
    "Num_ATV_s__c": "string",
    "Num_Boats__c": "string",
    "Num_Campgrounds__c": "string",
    "Num_Charters_Cruises_Tours__c": "string",
    "Num_Club_Boats__c": "string",
    "Num_Houseboats__c": "string",
    "Num_Indoor_Heated_Winter__c": "string",
    "Num_Jet_Skis__c": "string",
    "Num_Lodging_Cabins__c": "string",
    "Num_Non_Powered__c": "string",
    "Num_Outdoor_Parking_Lot_Winter__c": "string",
    "Num_RV_Sites__c": "string",
    "Num_Rack_Storage_Valet__c": "string",
    "Num_Snowmobiles__c": "string",
    "Num_Wet_Slips__c": "string",
    "Num_Yacht_Club_Slips__c": "string",
    "NumberOfEmployees": "string",
    "NumberOfFormFills__c": "string",
    "Occupancy__c": "string",
    "Offsite_Reporting__c": "string",
    "Old_Account_Id__c": "string",
    "Old_Contact_Id__c": "string",
    "Online_Listing_Service__c": "string",
    "OpportunityId": "string",
    "Opportunity_Business_Segment_Detail__c": "string",
    "Opportunity_Type__c": "string",
    "Outdoor_Parking_Lot_Winter__c": "string",
    "OwnerId": "string",
    "P_C_Product_Interest_Score__c": "string",
    "Pardot_Campaign__c": "string",
    "Pardot_Primary_Campaign_Source__c": "string",
    "Phone": "string",
    "PhotoUrl": "string",
    "Please_provide_more_info__c": "string",
    "PostalCode": "string",
    "Pre_Call_Email__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Interest__c": "string",
    "Projected_MRR__c": "string",
    "Promotion__c": "string",
    "Pronouns": "string",
    "RV_Campsite__c": "string",
    "RV_Sites__c": "string",
    "Rack_Storage_Valet__c": "string",
    "Rating": "string",
    "Ready_to_Sync__c": "string",
    "Reason_for_contacting_u__c": "string",
    "Reason_for_non_compliance__c": "string",
    "RecentCampaign__c": "string",
    "RecordTypeId": "string",
    "Referral_Entity__c": "string",
    "Referral_Partner_Type__c": "string",
    "Registration_Code__c": "string",
    "Revenue_Mgmt__c": "string",
    "SE_SF_Lead_ID__c": "string",
    "SFGA__CorrelationID__c": "string",
    "SFGA__Correlation_Data__c": "string",
    "SFGA__Web_Source__c": "string",
    "SF_Lead_ID__c": "string",
    "SLPC_Send_to_Corp_Office__c": "string",
    "SLWE_Billing_Day__c": "string",
    "SLWE_Billing_Frequency__c": "string",
    "SLWE_Billing_Rate__c": "string",
    "SLWE_Paid_by_Credit_Card__c": "string",
    "SMD_Contract_ID__c": "string",
    "Salutation": "string",
    "Sells_New_Boats__c": "string",
    "Sells_Used_Boats__c": "string",
    "Shop_Service__c": "string",
    "SiteLink_Lite__c": "string",
    "SiteLink_PC_Copy_Number__c": "string",
    "SiteLink_PC_Key_Code__c": "string",
    "SiteLink_Product_Interest_Score__c": "string",
    "Snowmobiles__c": "string",
    "Software_Usage_Marine_Boat_Club__c": "string",
    "Software_Usage_Marine_Boat_Sales__c": "string",
    "Software_Usage_Marine_Rentals__c": "string",
    "Software_Usage_Marine_Service__c": "string",
    "Software_Usage_Marine_Storage__c": "string",
    "Software_Usage_RV_Campsite__c": "string",
    "Source_Page_URL__c": "string",
    "StageName": "string",
    "State": "string",
    "Status": "string",
    "Storage_Auctions_Lead__c": "string",
    "Street": "string",
    "SystemModstamp": "string",
    "System_of_Origin__c": "string",
    "TPP_Product_Interest_Score__c": "string",
    "Technicians__c": "string",
    "Timeframe__c": "string",
    "Title": "string",
    "Trade_Show_High_Intent__c": "string",
    "Trade_Show_Low_Intent__c": "string",
    "Trade_Show_Opportunity_Notess__c": "string",
    "Trade_Show_Support_Issue__c": "string",
    "Trash_Reason__c": "string",
    "Trial_Product__c": "string",
    "Trial_Sites__c": "string",
    "UConference__UberConferenceId__c": "string",
    "UTM_term__c": "string",
    "Units__c": "string",
    "Vanilla__ForumUrl__c": "string",
    "Web_Form_Date__c": "string",
    "Web_Lead_Comments__c": "string",
    "Webinar_High_Intent__c": "string",
    "Webinar_Low_intent__c": "string",
    "Webinar_Opportunity_Notes__c": "string",
    "Website": "string",
    "Wet_Slips__c": "string",
    "Work_Orders__c": "string",
    "Yacht_Club_Slips__c": "string",
    "dupcheck__dc3DisableDuplicateCheck__c": "string",
    "dupcheck__dc3Index__c": "string",
    "dupcheck__dc3Web2Lead__c": "string",
    "of_Databases__c": "string",
    "of_Units__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",
    "smartystreets__Address_Do_Not_Verify__c": "string",
    "smartystreets__Address_Footnotes__c": "string",
    "smartystreets__Address_Last_Verified__c": "string",
    "smartystreets__Address_Latitude__c": "string",
    "smartystreets__Address_Longitude__c": "string",
    "smartystreets__Address_Return_Code__c": "string",
    "smartystreets__Address_Verified__c": "string",
    "smartystreets__Clean_Street__c": "string",
    "smartystreets__In_Batch__c": "string",
    "smartystreets__VerificationUsed__c": "string",
    "storEDGE_Product_Interest_Score__c": "string",
    "utm_ad__c": "string",
    "utm_campaign__c": "string",
    "utm_content__c": "string",
    "utm_keyword__c": "string",
    "utm_medium__c": "string",
    "utm_source__c": "string"
}
  • created: 2026-02-27 09:13:36
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.salesforce_leads`\n(\n `Id`  string , `IsDeleted`  string , `MasterRecordId`  string , `LastName`  string , `FirstName`  string , `Salutation`  string , `Name`  string , `RecordTypeId`  string , `Title`  string , `Company`  string , `Street`  string , `City`  string , `State`  string , `PostalCode`  string , `Country`  string , `Latitude`  string , `Longitude`  string , `GeocodeAccuracy`  string , `Phone`  string , `MobilePhone`  string , `Fax`  string , `Email`  string , `Website`  string , `PhotoUrl`  string , `Description`  string , `LeadSource`  string , `Status`  string , `Industry`  string , `Rating`  string , `CurrencyIsoCode`  string , `AnnualRevenue`  string , `NumberOfEmployees`  string , `OwnerId`  string , `HasOptedOutOfEmail`  string , `IsConverted`  string , `ConvertedDate`  string , `ConvertedAccountId`  string , `ConvertedContactId`  string , `ConvertedOpportunityId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `DoNotCall`  string , `HasOptedOutOfFax`  string , `LastTransferDate`  string , `Jigsaw`  string , `JigsawContactId`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `EmailBouncedReason`  string , `EmailBouncedDate`  string , `IndividualId`  string , `Pronouns`  string , `GenderIdentity`  string , `IsPriorityRecord`  string , `SFGA__CorrelationID__c`  string , `SFGA__Correlation_Data__c`  string , `SFGA__Web_Source__c`  string , `Product_Interest__c`  string , `Old_Account_Id__c`  string , `ExporttoHubspot__c`  string , `of_Databases__c`  string , `of_Units__c`  string , `Accounting_Interface__c`  string , `CC_Interface__c`  string , `EMail_Interface__c`  string , `Old_Contact_Id__c`  string , `Account_Type__c`  string , `Feature_Code__c`  string , `Feature_Code_Initial__c`  string , `Home_Office_Copy_Number__c`  string , `Lead_Source_Email__c`  string , `Current_FMS__c`  string , `Units__c`  string , `Locations__c`  string , `Internet__c`  string , `CC_Processing__c`  string , `Invoicing__c`  string , `Accounting_Software__c`  string , `Offsite_Reporting__c`  string , `Last_Rate_Change__c`  string , `Occupancy__c`  string , `Access_Anywhere__c`  string , `Billing_Cycle__c`  string , `Needs__c`  string , `Timeframe__c`  string , `Authority__c`  string , `Home_Office_Key_Code__c`  string , `Kiosk__c`  string , `Channel__c`  string , `Pre_Call_Email__c`  string , `Demo_Link__c`  string , `pi__Needs_Score_Synced__c`  string , `pi__Pardot_Last_Scored_At__c`  string , `Pardot_Campaign__c`  string , `Pardot_Primary_Campaign_Source__c`  string , `Vanilla__ForumUrl__c`  string , `Lead_Source_SF__c`  string , `Last_Upgrade__c`  string , `Last_Upgrade_Version__c`  string , `MultiUser__c`  string , `Registration_Code__c`  string , `Revenue_Mgmt__c`  string , `SiteLink_Lite__c`  string , `SiteLink_PC_Copy_Number__c`  string , `SiteLink_PC_Key_Code__c`  string , `SLPC_Send_to_Corp_Office__c`  string , `SLWE_Billing_Day__c`  string , `SLWE_Billing_Frequency__c`  string , `SLWE_Billing_Rate__c`  string , `SLWE_Paid_by_Credit_Card__c`  string , `SMD_Contract_ID__c`  string , `Gate_Interface__c`  string , `pi__campaign__c`  string , `utm_source__c`  string , `Interest__c`  string , `LDR_Lists__c`  string , `Web_Lead_Comments__c`  string , `Corp_Code__c`  string , `Location_Code__c`  string , `Source_Page_URL__c`  string , `Lead_Source_Text__c`  string , `Please_provide_more_info__c`  string , `Not_Interested__c`  string , `IGD__Collection_Id__c`  string , `Reason_for_contacting_u__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 , `Online_Listing_Service__c`  string , `Promotion__c`  string , `Best_day_time__c`  string , `How_did_you_hear_about_us__c`  string , `pi__pardot_hard_bounced__c`  string , `utm_campaign__c`  string , `utm_ad__c`  string , `utm_keyword__c`  string , `Trash_Reason__c`  string , `SF_Lead_ID__c`  string , `Lead_Notes__c`  string , `Hot_Lead__c`  string , `System_of_Origin__c`  string , `SE_SF_Lead_ID__c`  string , `FormSource__c`  string , `FacilityID__c`  string , `GCLID__c`  string , `Current_Website__c`  string , `Current_Gate__c`  string , `Current_Insurance__c`  string , `Current_Marketplace__c`  string , `Current_Payment__c`  string , `Projected_MRR__c`  string , `KronologicCampaigns__c`  string , `KronologicStatus__c`  string , `Opportunity_Business_Segment_Detail__c`  string , `dupcheck__dc3DisableDuplicateCheck__c`  string , `dupcheck__dc3Index__c`  string , `dupcheck__dc3Web2Lead__c`  string , `Web_Form_Date__c`  string , `HubspotPhone__c`  string , `RecentCampaign__c`  string , `Most_Recent_HubSpot_Message__c`  string , `HubspotRecordid__c`  string , `Sells_Used_Boats__c`  string , `Trade_Show_High_Intent__c`  string , `Software_Usage_Marine_Boat_Club__c`  string , `Software_Usage_Marine_Boat_Sales__c`  string , `Software_Usage_Marine_Rentals__c`  string , `Software_Usage_Marine_Service__c`  string , `Technicians__c`  string , `Webinar_High_Intent__c`  string , `Work_Orders__c`  string , `Account__c`  string , `Allowed_to_Auto_Convert__c`  string , `Contact_Match__c`  string , `Contact__c`  string , `Last_Attempted_Match_to_Existing_Account__c`  string , `Last_Attempted_Match_to_Existing_Contact__c`  string , `UTM_term__c`  string , `utm_content__c`  string , `utm_medium__c`  string , `Webinar_Low_intent__c`  string , `Webinar_Opportunity_Notes__c`  string , `Trade_Show_Low_Intent__c`  string , `Trade_Show_Opportunity_Notess__c`  string , `Trial_Product__c`  string , `Trial_Sites__c`  string , `Gong__Active_Engage_Flow_Names__c`  string , `Gong__Actively_Being_in_a_Flow__c`  string , `Gong__Added_to_Flow_Date__c`  string , `Gong__Current_Flow_ID__c`  string , `Gong__Current_Flow_Name__c`  string , `Gong__Current_Flow_Step_Number__c`  string , `Gong__Current_Flow_Step_Type__c`  string , `Gong__Current_Flow_Task_Due_Date__c`  string , `Gong__Current_Flow_User_Name__c`  string , `Gong__Engage_Flow_Owner__c`  string , `Gong__Flow_Execution_ID__c`  string , `Gong__Flow_Status__c`  string , `Gong__Number_of_Active_Engage_Flows__c`  string , `Ready_to_Sync__c`  string , `Storage_Auctions_Lead__c`  string , `Hubspot_Form_Action_Type__c`  string , `Hubspot_Latest_Traffic_Source__c`  string , `Gong__Engage_Last_Step_Completed_Date__c`  string , `Gong__NumberofLocations__c`  string , `Data_Load_By__c`  string , `Marine_Product_Interest__c`  string , `smartystreets__Address_Do_Not_Verify__c`  string , `smartystreets__Address_Footnotes__c`  string , `smartystreets__Address_Last_Verified__c`  string , `smartystreets__Address_Latitude__c`  string , `smartystreets__Address_Longitude__c`  string , `smartystreets__Address_Return_Code__c`  string , `smartystreets__Address_Verified__c`  string , `smartystreets__Clean_Street__c`  string , `smartystreets__In_Batch__c`  string , `smartystreets__VerificationUsed__c`  string , `Lead_Handling__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 , `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 , `Opportunity_Type__c`  string , `Trade_Show_Support_Issue__c`  string , `Lead_Quality__c`  string , `AC_Product_Interest_Score__c`  string , `DMS_Product_Interest_Score__c`  string , `DateTimeLastFormFill__c`  string , `ESS_Product_Interest_Score__c`  string , `Hubspot_Customer_Location__c`  string , `Lead_Score__c`  string , `NumberOfFormFills__c`  string , `P_C_Product_Interest_Score__c`  string , `Reason_for_non_compliance__c`  string , `SiteLink_Product_Interest_Score__c`  string , `storEDGE_Product_Interest_Score__c`  string , `TPP_Product_Interest_Score__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 , `Converted_Lead__c`  string , `Annual_Boat_Club_Revenue__c`  string , `Annual_Boat_Sales_Revenue__c`  string , `Annual_Marine_Rentals_Revenue__c`  string , `Annual_Marine_Service_Revenue__c`  string , `Annual_Marine_Storage_Revenue__c`  string , `Annual_RV_Campsite_Revenue__c`  string , `Marine_HubSpot_ID__c`  string , `Num_Boats__c`  string , `Num_Houseboats__c`  string , `Num_Jet_Skis__c`  string , `Num_Lodging_Cabins__c`  string , `Num_Non_Powered__c`  string , `Num_Rack_Storage_Valet__c`  string , `Num_Snowmobiles__c`  string , `Referral_Entity__c`  string , `Referral_Partner_Type__c`  string , `Sells_New_Boats__c`  string , `Software_Usage_Marine_Storage__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-stage/raw/leads/2026-02-27/1772205050'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_leads`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_leads"
}
Server:
  • hostname: schemamanager-5c55c886bf-h2ts4
  • name: schema_manager
  • process_start: 2025-10-21 13:03:27
  • sf_env: stage
  • version: 2112174301
Raw: 
{
    "name": {
        "created": "2022-10-24 15:14:18",
        "disabled": false,
        "format": "raw",
        "id": 1435,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_csv",
            "table": "salesforce_leads"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AC_Product_Interest_Score__c": "string",
            "ATV_s__c": "string",
            "Access_Anywhere__c": "string",
            "Account_Type__c": "string",
            "Account__c": "string",
            "Accounting_Interface__c": "string",
            "Accounting_Software__c": "string",
            "Allowed_to_Auto_Convert__c": "string",
            "Amount": "string",
            "AnnualRevenue": "string",
            "Annual_Boat_Club_Revenue__c": "string",
            "Annual_Boat_Sales_Revenue__c": "string",
            "Annual_Marine_Rentals_Revenue__c": "string",
            "Annual_Marine_Service_Revenue__c": "string",
            "Annual_Marine_Storage_Revenue__c": "string",
            "Annual_RV_Campsite_Revenue__c": "string",
            "Authority__c": "string",
            "Best_day_time__c": "string",
            "Billing_Cycle__c": "string",
            "Boats__c": "string",
            "CC_Interface__c": "string",
            "CC_Processing__c": "string",
            "CP_Hubspot_Record_ID__c": "string",
            "Campgrounds__c": "string",
            "Channel__c": "string",
            "Charters_Cruises_Tours__c": "string",
            "City": "string",
            "CloseDate": "string",
            "Club_Boats__c": "string",
            "Company": "string",
            "ConnectionReceivedId": "string",
            "ConnectionSentId": "string",
            "Contact_Match__c": "string",
            "Contact__c": "string",
            "ConvertedAccountId": "string",
            "ConvertedContactId": "string",
            "ConvertedDate": "string",
            "ConvertedOpportunityId": "string",
            "Converted_Lead__c": "string",
            "Corp_Code__c": "string",
            "Country": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "CurrencyIsoCode": "string",
            "Current_FMS__c": "string",
            "Current_Gate__c": "string",
            "Current_Insurance__c": "string",
            "Current_Marketplace__c": "string",
            "Current_Payment__c": "string",
            "Current_Website__c": "string",
            "DMS_Product_Interest_Score__c": "string",
            "Data_Load_By__c": "string",
            "DateTimeLastFormFill__c": "string",
            "Demo_Link__c": "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",
            "EMail_Interface__c": "string",
            "ESS_Product_Interest_Score__c": "string",
            "Email": "string",
            "EmailBouncedDate": "string",
            "EmailBouncedReason": "string",
            "ExpectedRevenue": "string",
            "ExporttoHubspot__c": "string",
            "FacilityID__c": "string",
            "Fax": "string",
            "Feature_Code_Initial__c": "string",
            "Feature_Code__c": "string",
            "FirstName": "string",
            "ForecastCategory": "string",
            "FormSource__c": "string",
            "GCLID__c": "string",
            "Gate_Interface__c": "string",
            "GenderIdentity": "string",
            "GeocodeAccuracy": "string",
            "Gong__Active_Engage_Flow_Names__c": "string",
            "Gong__Actively_Being_in_a_Flow__c": "string",
            "Gong__Added_to_Flow_Date__c": "string",
            "Gong__Current_Flow_ID__c": "string",
            "Gong__Current_Flow_Name__c": "string",
            "Gong__Current_Flow_Step_Number__c": "string",
            "Gong__Current_Flow_Step_Type__c": "string",
            "Gong__Current_Flow_Task_Due_Date__c": "string",
            "Gong__Current_Flow_User_Name__c": "string",
            "Gong__Engage_Flow_Owner__c": "string",
            "Gong__Engage_Last_Step_Completed_Date__c": "string",
            "Gong__Flow_Execution_ID__c": "string",
            "Gong__Flow_Status__c": "string",
            "Gong__Number_of_Active_Engage_Flows__c": "string",
            "Gong__NumberofLocations__c": "string",
            "HasOptedOutOfEmail": "string",
            "HasOptedOutOfFax": "string",
            "Has_Service_Manager__c": "string",
            "Home_Office_Copy_Number__c": "string",
            "Home_Office_Key_Code__c": "string",
            "Hot_Lead__c": "string",
            "Houseboats__c": "string",
            "How_did_you_hear_about_us__c": "string",
            "HubspotPhone__c": "string",
            "HubspotRecordid__c": "string",
            "Hubspot_Customer_Location__c": "string",
            "Hubspot_Form_Action_Type__c": "string",
            "Hubspot_Latest_Traffic_Source__c": "string",
            "IGD__Collection_Id__c": "string",
            "Id": "string",
            "IndividualId": "string",
            "Indoor_Heated_Winter__c": "string",
            "Industry": "string",
            "Interest__c": "string",
            "Internet__c": "string",
            "Invoicing__c": "string",
            "IsConverted": "string",
            "IsDeleted": "string",
            "IsPriorityRecord": "string",
            "Jet_Skis__c": "string",
            "Jigsaw": "string",
            "JigsawContactId": "string",
            "Kiosk__c": "string",
            "KronologicCampaigns__c": "string",
            "KronologicStatus__c": "string",
            "LDR_Lists__c": "string",
            "LastActivityDate": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "LastName": "string",
            "LastTransferDate": "string",
            "Last_Attempted_Match_to_Existing_Account__c": "string",
            "Last_Attempted_Match_to_Existing_Contact__c": "string",
            "Last_Rate_Change__c": "string",
            "Last_Upgrade_Version__c": "string",
            "Last_Upgrade__c": "string",
            "Latitude": "string",
            "LeadSource": "string",
            "Lead_Handling__c": "string",
            "Lead_Notes__c": "string",
            "Lead_Quality__c": "string",
            "Lead_Score__c": "string",
            "Lead_Source_Email__c": "string",
            "Lead_Source_SF__c": "string",
            "Lead_Source_Text__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",
            "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",
            "Location_Code__c": "string",
            "Locations__c": "string",
            "Lodging_Cabins__c": "string",
            "Longitude": "string",
            "Marine_Boat_Club__c": "string",
            "Marine_Boat_Sales__c": "string",
            "Marine_HubSpot_ID__c": "string",
            "Marine_Product_Interest__c": "string",
            "Marine_Rentals__c": "string",
            "Marine_Service__c": "string",
            "Marine_Storage__c": "string",
            "MasterRecordId": "string",
            "MobilePhone": "string",
            "Mobile_Service__c": "string",
            "Most_Recent_HubSpot_Message__c": "string",
            "MultiUser__c": "string",
            "Name": "string",
            "Needs__c": "string",
            "Non_Powered__c": "string",
            "Not_Interested__c": "string",
            "Num_ATV_s__c": "string",
            "Num_Boats__c": "string",
            "Num_Campgrounds__c": "string",
            "Num_Charters_Cruises_Tours__c": "string",
            "Num_Club_Boats__c": "string",
            "Num_Houseboats__c": "string",
            "Num_Indoor_Heated_Winter__c": "string",
            "Num_Jet_Skis__c": "string",
            "Num_Lodging_Cabins__c": "string",
            "Num_Non_Powered__c": "string",
            "Num_Outdoor_Parking_Lot_Winter__c": "string",
            "Num_RV_Sites__c": "string",
            "Num_Rack_Storage_Valet__c": "string",
            "Num_Snowmobiles__c": "string",
            "Num_Wet_Slips__c": "string",
            "Num_Yacht_Club_Slips__c": "string",
            "NumberOfEmployees": "string",
            "NumberOfFormFills__c": "string",
            "Occupancy__c": "string",
            "Offsite_Reporting__c": "string",
            "Old_Account_Id__c": "string",
            "Old_Contact_Id__c": "string",
            "Online_Listing_Service__c": "string",
            "OpportunityId": "string",
            "Opportunity_Business_Segment_Detail__c": "string",
            "Opportunity_Type__c": "string",
            "Outdoor_Parking_Lot_Winter__c": "string",
            "OwnerId": "string",
            "P_C_Product_Interest_Score__c": "string",
            "Pardot_Campaign__c": "string",
            "Pardot_Primary_Campaign_Source__c": "string",
            "Phone": "string",
            "PhotoUrl": "string",
            "Please_provide_more_info__c": "string",
            "PostalCode": "string",
            "Pre_Call_Email__c": "string",
            "PrevAmount": "string",
            "PrevCloseDate": "string",
            "Probability": "string",
            "Product_Interest__c": "string",
            "Projected_MRR__c": "string",
            "Promotion__c": "string",
            "Pronouns": "string",
            "RV_Campsite__c": "string",
            "RV_Sites__c": "string",
            "Rack_Storage_Valet__c": "string",
            "Rating": "string",
            "Ready_to_Sync__c": "string",
            "Reason_for_contacting_u__c": "string",
            "Reason_for_non_compliance__c": "string",
            "RecentCampaign__c": "string",
            "RecordTypeId": "string",
            "Referral_Entity__c": "string",
            "Referral_Partner_Type__c": "string",
            "Registration_Code__c": "string",
            "Revenue_Mgmt__c": "string",
            "SE_SF_Lead_ID__c": "string",
            "SFGA__CorrelationID__c": "string",
            "SFGA__Correlation_Data__c": "string",
            "SFGA__Web_Source__c": "string",
            "SF_Lead_ID__c": "string",
            "SLPC_Send_to_Corp_Office__c": "string",
            "SLWE_Billing_Day__c": "string",
            "SLWE_Billing_Frequency__c": "string",
            "SLWE_Billing_Rate__c": "string",
            "SLWE_Paid_by_Credit_Card__c": "string",
            "SMD_Contract_ID__c": "string",
            "Salutation": "string",
            "Sells_New_Boats__c": "string",
            "Sells_Used_Boats__c": "string",
            "Shop_Service__c": "string",
            "SiteLink_Lite__c": "string",
            "SiteLink_PC_Copy_Number__c": "string",
            "SiteLink_PC_Key_Code__c": "string",
            "SiteLink_Product_Interest_Score__c": "string",
            "Snowmobiles__c": "string",
            "Software_Usage_Marine_Boat_Club__c": "string",
            "Software_Usage_Marine_Boat_Sales__c": "string",
            "Software_Usage_Marine_Rentals__c": "string",
            "Software_Usage_Marine_Service__c": "string",
            "Software_Usage_Marine_Storage__c": "string",
            "Software_Usage_RV_Campsite__c": "string",
            "Source_Page_URL__c": "string",
            "StageName": "string",
            "State": "string",
            "Status": "string",
            "Storage_Auctions_Lead__c": "string",
            "Street": "string",
            "SystemModstamp": "string",
            "System_of_Origin__c": "string",
            "TPP_Product_Interest_Score__c": "string",
            "Technicians__c": "string",
            "Timeframe__c": "string",
            "Title": "string",
            "Trade_Show_High_Intent__c": "string",
            "Trade_Show_Low_Intent__c": "string",
            "Trade_Show_Opportunity_Notess__c": "string",
            "Trade_Show_Support_Issue__c": "string",
            "Trash_Reason__c": "string",
            "Trial_Product__c": "string",
            "Trial_Sites__c": "string",
            "UConference__UberConferenceId__c": "string",
            "UTM_term__c": "string",
            "Units__c": "string",
            "Vanilla__ForumUrl__c": "string",
            "Web_Form_Date__c": "string",
            "Web_Lead_Comments__c": "string",
            "Webinar_High_Intent__c": "string",
            "Webinar_Low_intent__c": "string",
            "Webinar_Opportunity_Notes__c": "string",
            "Website": "string",
            "Wet_Slips__c": "string",
            "Work_Orders__c": "string",
            "Yacht_Club_Slips__c": "string",
            "dupcheck__dc3DisableDuplicateCheck__c": "string",
            "dupcheck__dc3Index__c": "string",
            "dupcheck__dc3Web2Lead__c": "string",
            "of_Databases__c": "string",
            "of_Units__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",
            "smartystreets__Address_Do_Not_Verify__c": "string",
            "smartystreets__Address_Footnotes__c": "string",
            "smartystreets__Address_Last_Verified__c": "string",
            "smartystreets__Address_Latitude__c": "string",
            "smartystreets__Address_Longitude__c": "string",
            "smartystreets__Address_Return_Code__c": "string",
            "smartystreets__Address_Verified__c": "string",
            "smartystreets__Clean_Street__c": "string",
            "smartystreets__In_Batch__c": "string",
            "smartystreets__VerificationUsed__c": "string",
            "storEDGE_Product_Interest_Score__c": "string",
            "utm_ad__c": "string",
            "utm_campaign__c": "string",
            "utm_content__c": "string",
            "utm_keyword__c": "string",
            "utm_medium__c": "string",
            "utm_source__c": "string"
        },
        "created": "2026-02-27 09:13:36",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.salesforce_leads`\n(\n `Id`  string , `IsDeleted`  string , `MasterRecordId`  string , `LastName`  string , `FirstName`  string , `Salutation`  string , `Name`  string , `RecordTypeId`  string , `Title`  string , `Company`  string , `Street`  string , `City`  string , `State`  string , `PostalCode`  string , `Country`  string , `Latitude`  string , `Longitude`  string , `GeocodeAccuracy`  string , `Phone`  string , `MobilePhone`  string , `Fax`  string , `Email`  string , `Website`  string , `PhotoUrl`  string , `Description`  string , `LeadSource`  string , `Status`  string , `Industry`  string , `Rating`  string , `CurrencyIsoCode`  string , `AnnualRevenue`  string , `NumberOfEmployees`  string , `OwnerId`  string , `HasOptedOutOfEmail`  string , `IsConverted`  string , `ConvertedDate`  string , `ConvertedAccountId`  string , `ConvertedContactId`  string , `ConvertedOpportunityId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `DoNotCall`  string , `HasOptedOutOfFax`  string , `LastTransferDate`  string , `Jigsaw`  string , `JigsawContactId`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `EmailBouncedReason`  string , `EmailBouncedDate`  string , `IndividualId`  string , `Pronouns`  string , `GenderIdentity`  string , `IsPriorityRecord`  string , `SFGA__CorrelationID__c`  string , `SFGA__Correlation_Data__c`  string , `SFGA__Web_Source__c`  string , `Product_Interest__c`  string , `Old_Account_Id__c`  string , `ExporttoHubspot__c`  string , `of_Databases__c`  string , `of_Units__c`  string , `Accounting_Interface__c`  string , `CC_Interface__c`  string , `EMail_Interface__c`  string , `Old_Contact_Id__c`  string , `Account_Type__c`  string , `Feature_Code__c`  string , `Feature_Code_Initial__c`  string , `Home_Office_Copy_Number__c`  string , `Lead_Source_Email__c`  string , `Current_FMS__c`  string , `Units__c`  string , `Locations__c`  string , `Internet__c`  string , `CC_Processing__c`  string , `Invoicing__c`  string , `Accounting_Software__c`  string , `Offsite_Reporting__c`  string , `Last_Rate_Change__c`  string , `Occupancy__c`  string , `Access_Anywhere__c`  string , `Billing_Cycle__c`  string , `Needs__c`  string , `Timeframe__c`  string , `Authority__c`  string , `Home_Office_Key_Code__c`  string , `Kiosk__c`  string , `Channel__c`  string , `Pre_Call_Email__c`  string , `Demo_Link__c`  string , `pi__Needs_Score_Synced__c`  string , `pi__Pardot_Last_Scored_At__c`  string , `Pardot_Campaign__c`  string , `Pardot_Primary_Campaign_Source__c`  string , `Vanilla__ForumUrl__c`  string , `Lead_Source_SF__c`  string , `Last_Upgrade__c`  string , `Last_Upgrade_Version__c`  string , `MultiUser__c`  string , `Registration_Code__c`  string , `Revenue_Mgmt__c`  string , `SiteLink_Lite__c`  string , `SiteLink_PC_Copy_Number__c`  string , `SiteLink_PC_Key_Code__c`  string , `SLPC_Send_to_Corp_Office__c`  string , `SLWE_Billing_Day__c`  string , `SLWE_Billing_Frequency__c`  string , `SLWE_Billing_Rate__c`  string , `SLWE_Paid_by_Credit_Card__c`  string , `SMD_Contract_ID__c`  string , `Gate_Interface__c`  string , `pi__campaign__c`  string , `utm_source__c`  string , `Interest__c`  string , `LDR_Lists__c`  string , `Web_Lead_Comments__c`  string , `Corp_Code__c`  string , `Location_Code__c`  string , `Source_Page_URL__c`  string , `Lead_Source_Text__c`  string , `Please_provide_more_info__c`  string , `Not_Interested__c`  string , `IGD__Collection_Id__c`  string , `Reason_for_contacting_u__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 , `Online_Listing_Service__c`  string , `Promotion__c`  string , `Best_day_time__c`  string , `How_did_you_hear_about_us__c`  string , `pi__pardot_hard_bounced__c`  string , `utm_campaign__c`  string , `utm_ad__c`  string , `utm_keyword__c`  string , `Trash_Reason__c`  string , `SF_Lead_ID__c`  string , `Lead_Notes__c`  string , `Hot_Lead__c`  string , `System_of_Origin__c`  string , `SE_SF_Lead_ID__c`  string , `FormSource__c`  string , `FacilityID__c`  string , `GCLID__c`  string , `Current_Website__c`  string , `Current_Gate__c`  string , `Current_Insurance__c`  string , `Current_Marketplace__c`  string , `Current_Payment__c`  string , `Projected_MRR__c`  string , `KronologicCampaigns__c`  string , `KronologicStatus__c`  string , `Opportunity_Business_Segment_Detail__c`  string , `dupcheck__dc3DisableDuplicateCheck__c`  string , `dupcheck__dc3Index__c`  string , `dupcheck__dc3Web2Lead__c`  string , `Web_Form_Date__c`  string , `HubspotPhone__c`  string , `RecentCampaign__c`  string , `Most_Recent_HubSpot_Message__c`  string , `HubspotRecordid__c`  string , `Sells_Used_Boats__c`  string , `Trade_Show_High_Intent__c`  string , `Software_Usage_Marine_Boat_Club__c`  string , `Software_Usage_Marine_Boat_Sales__c`  string , `Software_Usage_Marine_Rentals__c`  string , `Software_Usage_Marine_Service__c`  string , `Technicians__c`  string , `Webinar_High_Intent__c`  string , `Work_Orders__c`  string , `Account__c`  string , `Allowed_to_Auto_Convert__c`  string , `Contact_Match__c`  string , `Contact__c`  string , `Last_Attempted_Match_to_Existing_Account__c`  string , `Last_Attempted_Match_to_Existing_Contact__c`  string , `UTM_term__c`  string , `utm_content__c`  string , `utm_medium__c`  string , `Webinar_Low_intent__c`  string , `Webinar_Opportunity_Notes__c`  string , `Trade_Show_Low_Intent__c`  string , `Trade_Show_Opportunity_Notess__c`  string , `Trial_Product__c`  string , `Trial_Sites__c`  string , `Gong__Active_Engage_Flow_Names__c`  string , `Gong__Actively_Being_in_a_Flow__c`  string , `Gong__Added_to_Flow_Date__c`  string , `Gong__Current_Flow_ID__c`  string , `Gong__Current_Flow_Name__c`  string , `Gong__Current_Flow_Step_Number__c`  string , `Gong__Current_Flow_Step_Type__c`  string , `Gong__Current_Flow_Task_Due_Date__c`  string , `Gong__Current_Flow_User_Name__c`  string , `Gong__Engage_Flow_Owner__c`  string , `Gong__Flow_Execution_ID__c`  string , `Gong__Flow_Status__c`  string , `Gong__Number_of_Active_Engage_Flows__c`  string , `Ready_to_Sync__c`  string , `Storage_Auctions_Lead__c`  string , `Hubspot_Form_Action_Type__c`  string , `Hubspot_Latest_Traffic_Source__c`  string , `Gong__Engage_Last_Step_Completed_Date__c`  string , `Gong__NumberofLocations__c`  string , `Data_Load_By__c`  string , `Marine_Product_Interest__c`  string , `smartystreets__Address_Do_Not_Verify__c`  string , `smartystreets__Address_Footnotes__c`  string , `smartystreets__Address_Last_Verified__c`  string , `smartystreets__Address_Latitude__c`  string , `smartystreets__Address_Longitude__c`  string , `smartystreets__Address_Return_Code__c`  string , `smartystreets__Address_Verified__c`  string , `smartystreets__Clean_Street__c`  string , `smartystreets__In_Batch__c`  string , `smartystreets__VerificationUsed__c`  string , `Lead_Handling__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 , `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 , `Opportunity_Type__c`  string , `Trade_Show_Support_Issue__c`  string , `Lead_Quality__c`  string , `AC_Product_Interest_Score__c`  string , `DMS_Product_Interest_Score__c`  string , `DateTimeLastFormFill__c`  string , `ESS_Product_Interest_Score__c`  string , `Hubspot_Customer_Location__c`  string , `Lead_Score__c`  string , `NumberOfFormFills__c`  string , `P_C_Product_Interest_Score__c`  string , `Reason_for_non_compliance__c`  string , `SiteLink_Product_Interest_Score__c`  string , `storEDGE_Product_Interest_Score__c`  string , `TPP_Product_Interest_Score__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 , `Converted_Lead__c`  string , `Annual_Boat_Club_Revenue__c`  string , `Annual_Boat_Sales_Revenue__c`  string , `Annual_Marine_Rentals_Revenue__c`  string , `Annual_Marine_Service_Revenue__c`  string , `Annual_Marine_Storage_Revenue__c`  string , `Annual_RV_Campsite_Revenue__c`  string , `Marine_HubSpot_ID__c`  string , `Num_Boats__c`  string , `Num_Houseboats__c`  string , `Num_Jet_Skis__c`  string , `Num_Lodging_Cabins__c`  string , `Num_Non_Powered__c`  string , `Num_Rack_Storage_Valet__c`  string , `Num_Snowmobiles__c`  string , `Referral_Entity__c`  string , `Referral_Partner_Type__c`  string , `Sells_New_Boats__c`  string , `Software_Usage_Marine_Storage__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-stage/raw/leads/2026-02-27/1772205050'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_leads`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_leads"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform