Schema Info

Schema Name: sfdl_dev_csv.salesforce_form_response__cs
  • created: 2022-10-24 14:52:26
  • disabled: False
  • format: raw
  • id: 2060
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_dev_csv",
    "table": "salesforce_form_response__cs"
}
  • type: csv
Schema Versions: 5
    • created: 2024-06-10 15:35:50
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_form_response__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_form_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Access_Control_Competitor_moving_to__c`  string , `Access_Control_Products_to_Cancel__c`  string , `Anything_else_we_should_know__c`  string , `Switching_Product__c`  string , `Cancel_Single_Multiple_or_All_facility__c`  string , `Access_Hours__c`  string , `Accounting_method_use__c`  string , `Add_info_facility__c`  string , `Administrative_Fee__c`  string , `Already_have_domain__c`  string , `Amenities_Offered__c`  string , `Contact_Email__c`  string , `Contact_Name__c`  string , `Contact_Phone__c`  string , `Created_Case__c`  string , `Anticipated_Monthly_Vol_per_month__c`  string , `Facility_Cancel_List__c`  string , `Assist_Google_My_Business__c`  string , `Form_Record_Type__c`  string , `Insurance_Product_to_Cancel__c`  string , `New_Insurance_Provider_moving_to__c`  string , `New_Software_Platform_moving_to__c`  string , `New_Website_Platform_moving_to__c`  string , `Onethingwecouldhavedonedifferently__c`  string , `Other_Cancel_Access_Control__c`  string , `Other_Cancel_Insurance__c`  string , `Other_Cancel_Payment_Other_Product__c`  string , `Other_Cancel_Software_Product__c`  string , `Other_Cancel_SpareFoot__c`  string , `Other_Cancel_Website_Product__c`  string , `Payment_or_Other_Product_to_Cancel__c`  string , `Please_provide_the_name_of_the_purchaser__c`  string , `Reason_Cancel_Access_Control__c`  string , `Reason_Cancel_Insurance__c`  string , `Reason_Cancel_Payment_or_Other_Product__c`  string , `Reason_Cancel_Software_Product__c`  string , `Reason_Cancel_SpareFoot__c`  string , `Reason_Cancel_Website_Product__c`  string , `Reasonforleaving__c`  string , `Related_Record_Created__c`  string , `Auction_Units__c`  string , `Software_Products_to_Cancel__c`  string , `Source__c`  string , `SpareFoot_Product_to_Cancel__c`  string , `Subject__c`  string , `Website_Products_to_Cancel__c`  string , `Discuss_with_our_Product_Manager__c`  string , `Interest_in_Data_Archive__c`  string , `Selling_or_Transfer_of_Ownership__c`  string , `Website_URL__c`  string , `Jotform_Submission_ID__c`  string , `DocuSignStatus__c`  string , `CreditCardNumber__c`  string , `CreditCardExpiration__c`  string , `CreditCardNetwork__c`  string , `CreditCardName__c`  string , `BillingName__c`  string , `BillingCity__c`  string , `BillingCountry__c`  string , `BillingPostalCode__c`  string , `BillingRegion__c`  string , `BillingStreet__c`  string , `BillingPaymentMethod__c`  string , `OpportunityId__c`  string , `ACHAccountNumber__c`  string , `ACHRoutingNumber__c`  string , `ACHInstitutionCity__c`  string , `ACHInstitutionName__c`  string , `ACHInstitutionPostalCode__c`  string , `ACHInstitutionRegion__c`  string , `FormURL__c`  string , `Billing_Settings__c`  string , `Device_Quantity__c`  string , `Facility_ID__c`  string , `Full_Address__c`  string , `MerchantId__c`  string , `Merchant_Timezone__c`  string , `Charge_Second_Late_Fee__c`  string , `Charge_Security_Deposit__c`  string , `Contact_Person_Email__c`  string , `Contact_Person_Name__c`  string , `Contact_Person_Phone__c`  string , `Contact_Person_Title__c`  string , `Custom_document_to_use__c`  string , `DBA_City_and_State__c`  string , `DBA_Name__c`  string , `DBA_Phone__c`  string , `DBA_Physical_Address__c`  string , `DBA_Zip_Code__c`  string , `Date_start_software__c`  string , `Day_Past_Due_FirstFee__c`  string , `Day_Past_Due_Notice__c`  string , `Days_Past_Due_Lien__c`  string , `Days_Past_Due_Locktenant__c`  string , `Days_Past_Due_Overlock__c`  string , `Days_prior_send_invoice__c`  string , `Desirable_New_City__c`  string , `Doc_electronic_sign__c`  string , `Domain_Registration_Location__c`  string , `Emphasize_On_Website__c`  string , `Est_date_opening_facility__c`  string , `Explain_Auction_process__c`  string , `FMS_converting_from__c`  string , `Faciilty_Legal_Entity_Name__c`  string , `Facility_Email__c`  string , `Facility_Legal_City_and_State__c`  string , `Facility_Legal_Mailing_Street_Address__c`  string , `Facility_Legal_Phone__c`  string , `Facility_Legal_Zip_Code__c`  string , `Facility_State__c`  string , `Federal_Tax_ID__c`  string , `First_Late_Fee__c`  string , `Gate_Software_Provider__c`  string , `Gatefacility_access_hours__c`  string , `Google_Analytics__c`  string , `Google_My_Business_Listing_Question__c`  string , `Google_My_Business_Listing__c`  string , `Have_Logo_Facility__c`  string , `Holiday_Hours__c`  string , `How_much_Security_Deposit__c`  string , `How_payments_applied__c`  string , `Insuranceprotection_plan__c`  string , `JotForm_Enter_Case_Number__c`  string , `Lien_Fee__c`  string , `Link_SLSE_Software__c`  string , `List_merch_items__c`  string , `Lock_Cutting_Fee__c`  string , `Login_Credentials__c`  string , `Login_For_Domain__c`  string , `MS_Preapplication_JotForm__c`  string , `NSF_Fee__c`  string , `Name_POS_or_FMS_used__c`  string , `Nearby_Landmarks__c`  string , `Nearby_Neighborhoods__c`  string , `Office_hours__c`  string , `Other_Pastdue_Event__c`  string , `Overlock_Fee__c`  string , `Overlock_PastDue_Unit__c`  string , `Place_Lien_Units__c`  string , `Primary_User_Email__c`  string , `Primary_User__c`  string , `Promo_discount_offer__c`  string , `Prorate_Rent_moveout__c`  string , `Prorate_moveout_days__c`  string , `Recur_LateFee_OneTime__c`  string , `Reservation_Fee__c`  string , `Retail_or_Merch_sale__c`  string , `Second_Late_Fee__c`  string , `Send_monthly_rent_invoices__c`  string , `Share_login_info__c`  string , `Signer_Date_of_Birth__c`  string , `Signer_Email__c`  string , `Signer_Home_Address__c`  string , `Signer_Name__c`  string , `Signer_Percentage_Business_Owned__c`  string , `Signer_Phone__c`  string , `Signer_Title__c`  string , `Start_or_acquire_date_of_business__c`  string , `Tax_rate_on_rent__c`  string , `Temperature_Controlled_Units__c`  string , `Tenant_Insurance_Provider__c`  string , `Top_Amenity__c`  string , `UA_Code__c`  string , `UNPW_current_software__c`  string , `Unmanned_Facility__c`  string , `Upload_Business_LicenseArticle_Incorp__c`  string , `Upload_Logo_Brand__c`  string , `Upload_Logo_Website__c`  string , `Upload_Signer_Driver_License__c`  string , `Upload_Void_Check_or_Bank_Detail__c`  string , `Upload_custom_document__c`  string , `Website_Photo_Facility__c`  string , `Which_Storable_Software__c`  string , `storEDGE_integrate__c`  string , `Purchaser_Phone__c`  string , `Purchaser_Email__c`  string , `storEDGE_integrate2__c`  string , `ACS_quotehardware__c`  string , `Access_after_Transfer__c`  string , `Access_point_restrict_keypad__c`  string , `Accesspointrestrict__c`  string , `Additional_Comment__c`  string , `Any_Portable_Units__c`  string , `Archive_Option_email_address__c`  string , `Clone_softwaresetting__c`  string , `Clone_website_namefacility__c`  string , `Construction_openbusiness__c`  string , `Continue_software_service__c`  string , `Convertfromspreadsheet__c`  string , `Current_Software_Provider__c`  string , `Date_Signed__c`  string , `Date_to_be_released__c`  string , `Existing_Corp_Code__c`  string , `Facility_clone__c`  string , `Historical_Data_Selection__c`  string , `Interest_Digital_Marketing__c`  string , `Interest_Sparefoot_facility__c`  string , `License_Holder__c`  string , `Loc_Code_Preference__c`  string , `Location_Code__c`  string , `ManageCompany_Ownersame__c`  string , `Managesoftware_convert__c`  string , `Merch_Provider_Facility__c`  string , `Name_Facility_Purchase__c`  string , `NewWebsite_ExistingDomain__c`  string , `Other_Merch_Provider__c`  string , `Other_Software_Provider__c`  string , `Other_Website_Provider__c`  string , `PurchFacility_SL_SE_ESS__c`  string , `Recipient_Email__c`  string , `Recipient_Facility_Name__c`  string , `Recipient_Name__c`  string , `Release_Date__c`  string , `Release_domain_name_website__c`  string , `SLCorpCode__c`  string , `SLLocationCode__c`  string , `Software_forwardfacility__c`  string , `Tenant_Insurance_Facility__c`  string , `Transferee_Company_Name__c`  string , `Transferee_Email__c`  string , `Transferee_Phone_Number__c`  string , `Transferee_Primary_Contact__c`  string , `Units__c`  string , `Use_Gate_Software_Provider__c`  string , `Use_Sparefoot_facility__c`  string , `WebsiteProvider_Facility__c`  string , `Your_SL_CorpCode__c`  string , `New_Access_Provider__c`  string , `New_Website_Provider__c`  string , `New_Software_Provider__c`  string , `Auction_Fee_Amount__c`  string , `Days_until_second_late_fee__c`  string , `Offering_Tenant_Protection_Plans__c`  string , `Invoice_Method__c`  string , `Addtl_info_or_Qs_on_MS_account__c`  string , `Existing_SMS_account__c`  string , `Expected_FMS_start_date__c`  string , `Type_of_Business__c`  string , `Which_PoS_or_FMS_will_you_be_using__c`  string , `Please_Explain__c`  string , `Reason_Opting_Out_of_Auto_Protect__c`  string , `Preferred_Availability__c`  string , `SSO_Interest_Level__c`  string , `Preferred_Contact_Method__c`  string , `CreditCardCVV__c`  string , `GTM_ID__c`  string , `If_Other_what_is_name_of_Gate_Provider__c`  string , `What_is_your_domain__c`  string , `Facility_Phone_Number__c`  string , `Gmail_for_GA__c`  string , `SE_Company_UUID__c`  string , `SE_Facility_UUID__c`  string , `Submission_Date__c`  string , `Sales_Team_Member__c`  string , `Company_Status__c`  string , `Stock_Ticker_Exchange__c`  string , `Contact_Title__c`  string , `Account__c`  string , `Interest_in_Data_Decryption__c`  string , `Payment_Cutoff_Days__c`  string , `CallPotential_Cancellation_Reason__c`  string , `Total_of_Locations__c`  string , `of_Locations_Onboarding__c`  string , `Modules_Launching__c`  string , `Management_Software__c`  string , `CallPotential_Products_to_Cancel__c`  string , `Other_CallPotential_Cancellation_Details__c`  string , `Business_Country__c`  string , `Location_Country__c`  string , `New_Insurance_Provider_Other__c`  string , `Business_Registration_Number__c`  string , `Tracked_Recorded_Line__c`  string , `Integration_Permission_True__c`  string , `New_Insurance_Provider__c`  string , `CallPotential_going_forward_at_facility__c`  string , `CallPotential_interested_in_at_facility__c`  string , `Interest_in_CallPotential__c`  string , `Account_Record_Type__c`  string , `Account_Status__c`  string , `Account_Type__c`  string , `CP_Company_ID__c`  string , `CP_Location_ID__c`  string , `CP_Products_Being_Purchased__c`  string , `Facility_Name__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Maximum_Usage__c`  string , `Opportunity_Type__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Parent_Corp_Account_Name__c`  string , `Per_Minute_Usage__c`  string , `If_Other_Amenities__c`  string , `Other_Domain_Registration__c`  string , `Where_is_Domain_Registered__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-dev/raw/form_response__cs/2024-06-10/1718051367'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_form_response__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/form_response__cs/2024-06-10/1718051367
    • id: 4706474
    • processed: 1
    • raw_data: 
      {
    "ACHAccountNumber__c": 77,
    "ACHInstitutionCity__c": 79,
    "ACHInstitutionName__c": 80,
    "ACHInstitutionPostalCode__c": 81,
    "ACHInstitutionRegion__c": 82,
    "ACHRoutingNumber__c": 78,
    "ACS_quotehardware__c": 190,
    "Access_Control_Competitor_moving_to__c": 13,
    "Access_Control_Products_to_Cancel__c": 14,
    "Access_Hours__c": 18,
    "Access_after_Transfer__c": 191,
    "Access_point_restrict_keypad__c": 192,
    "Accesspointrestrict__c": 193,
    "Account_Record_Type__c": 290,
    "Account_Status__c": 291,
    "Account_Type__c": 292,
    "Account__c": 270,
    "Accounting_method_use__c": 19,
    "Add_info_facility__c": 20,
    "Additional_Comment__c": 194,
    "Addtl_info_or_Qs_on_MS_account__c": 247,
    "Administrative_Fee__c": 21,
    "Already_have_domain__c": 22,
    "Amenities_Offered__c": 23,
    "Anticipated_Monthly_Vol_per_month__c": 28,
    "Any_Portable_Units__c": 195,
    "Anything_else_we_should_know__c": 15,
    "Archive_Option_email_address__c": 196,
    "Assist_Google_My_Business__c": 30,
    "Auction_Fee_Amount__c": 243,
    "Auction_Units__c": 53,
    "BillingCity__c": 70,
    "BillingCountry__c": 71,
    "BillingName__c": 69,
    "BillingPaymentMethod__c": 75,
    "BillingPostalCode__c": 72,
    "BillingRegion__c": 73,
    "BillingStreet__c": 74,
    "Billing_Settings__c": 84,
    "Business_Country__c": 280,
    "Business_Registration_Number__c": 283,
    "CP_Company_ID__c": 293,
    "CP_Location_ID__c": 294,
    "CP_Products_Being_Purchased__c": 295,
    "CallPotential_Cancellation_Reason__c": 273,
    "CallPotential_Products_to_Cancel__c": 278,
    "CallPotential_going_forward_at_facility__c": 287,
    "CallPotential_interested_in_at_facility__c": 288,
    "Cancel_Single_Multiple_or_All_facility__c": 17,
    "Charge_Second_Late_Fee__c": 90,
    "Charge_Security_Deposit__c": 91,
    "Clone_softwaresetting__c": 197,
    "Clone_website_namefacility__c": 198,
    "Company_Status__c": 267,
    "ConnectionReceivedId": 11,
    "ConnectionSentId": 12,
    "Construction_openbusiness__c": 199,
    "Contact_Email__c": 24,
    "Contact_Name__c": 25,
    "Contact_Person_Email__c": 92,
    "Contact_Person_Name__c": 93,
    "Contact_Person_Phone__c": 94,
    "Contact_Person_Title__c": 95,
    "Contact_Phone__c": 26,
    "Contact_Title__c": 269,
    "Continue_software_service__c": 200,
    "Convertfromspreadsheet__c": 201,
    "CreatedById": 7,
    "CreatedDate": 6,
    "Created_Case__c": 27,
    "CreditCardCVV__c": 257,
    "CreditCardExpiration__c": 66,
    "CreditCardName__c": 68,
    "CreditCardNetwork__c": 67,
    "CreditCardNumber__c": 65,
    "CurrencyIsoCode": 4,
    "Current_Software_Provider__c": 202,
    "Custom_document_to_use__c": 96,
    "DBA_City_and_State__c": 97,
    "DBA_Name__c": 98,
    "DBA_Phone__c": 99,
    "DBA_Physical_Address__c": 100,
    "DBA_Zip_Code__c": 101,
    "Date_Signed__c": 203,
    "Date_start_software__c": 102,
    "Date_to_be_released__c": 204,
    "Day_Past_Due_FirstFee__c": 103,
    "Day_Past_Due_Notice__c": 104,
    "Days_Past_Due_Lien__c": 105,
    "Days_Past_Due_Locktenant__c": 106,
    "Days_Past_Due_Overlock__c": 107,
    "Days_prior_send_invoice__c": 108,
    "Days_until_second_late_fee__c": 244,
    "Desirable_New_City__c": 109,
    "Device_Quantity__c": 85,
    "Discuss_with_our_Product_Manager__c": 59,
    "Doc_electronic_sign__c": 110,
    "DocuSignStatus__c": 64,
    "Domain_Registration_Location__c": 111,
    "Emphasize_On_Website__c": 112,
    "Est_date_opening_facility__c": 113,
    "Existing_Corp_Code__c": 205,
    "Existing_SMS_account__c": 248,
    "Expected_FMS_start_date__c": 249,
    "Explain_Auction_process__c": 114,
    "FMS_converting_from__c": 115,
    "Faciilty_Legal_Entity_Name__c": 116,
    "Facility_Cancel_List__c": 29,
    "Facility_Email__c": 117,
    "Facility_ID__c": 86,
    "Facility_Legal_City_and_State__c": 118,
    "Facility_Legal_Mailing_Street_Address__c": 119,
    "Facility_Legal_Phone__c": 120,
    "Facility_Legal_Zip_Code__c": 121,
    "Facility_Name__c": 296,
    "Facility_Phone_Number__c": 261,
    "Facility_State__c": 122,
    "Facility_clone__c": 206,
    "Federal_Tax_ID__c": 123,
    "First_Late_Fee__c": 124,
    "FormURL__c": 83,
    "Form_Record_Type__c": 31,
    "Full_Address__c": 87,
    "GTM_ID__c": 258,
    "Gate_Software_Provider__c": 125,
    "Gatefacility_access_hours__c": 126,
    "Gmail_for_GA__c": 262,
    "Google_Analytics__c": 127,
    "Google_My_Business_Listing_Question__c": 128,
    "Google_My_Business_Listing__c": 129,
    "Have_Logo_Facility__c": 130,
    "Historical_Data_Selection__c": 207,
    "Holiday_Hours__c": 131,
    "How_much_Security_Deposit__c": 132,
    "How_payments_applied__c": 133,
    "Id": 0,
    "If_Other_Amenities__c": 305,
    "If_Other_what_is_name_of_Gate_Provider__c": 259,
    "Included_Minutes__c": 297,
    "Included_Tracking_Numbers__c": 298,
    "Insurance_Product_to_Cancel__c": 32,
    "Insuranceprotection_plan__c": 134,
    "Integration_Permission_True__c": 285,
    "Interest_Digital_Marketing__c": 208,
    "Interest_Sparefoot_facility__c": 209,
    "Interest_in_CallPotential__c": 289,
    "Interest_in_Data_Archive__c": 60,
    "Interest_in_Data_Decryption__c": 271,
    "Invoice_Method__c": 246,
    "IsDeleted": 2,
    "JotForm_Enter_Case_Number__c": 135,
    "Jotform_Submission_ID__c": 63,
    "LastModifiedById": 9,
    "LastModifiedDate": 8,
    "License_Holder__c": 210,
    "Lien_Fee__c": 136,
    "Link_SLSE_Software__c": 137,
    "List_merch_items__c": 138,
    "Loc_Code_Preference__c": 211,
    "Location_Code__c": 212,
    "Location_Country__c": 281,
    "Lock_Cutting_Fee__c": 139,
    "Login_Credentials__c": 140,
    "Login_For_Domain__c": 141,
    "MS_Preapplication_JotForm__c": 142,
    "ManageCompany_Ownersame__c": 213,
    "Management_Software__c": 277,
    "Managesoftware_convert__c": 214,
    "Maximum_Usage__c": 299,
    "Merch_Provider_Facility__c": 215,
    "MerchantId__c": 88,
    "Merchant_Timezone__c": 89,
    "Modules_Launching__c": 276,
    "NSF_Fee__c": 143,
    "Name": 3,
    "Name_Facility_Purchase__c": 216,
    "Name_POS_or_FMS_used__c": 144,
    "Nearby_Landmarks__c": 145,
    "Nearby_Neighborhoods__c": 146,
    "NewWebsite_ExistingDomain__c": 217,
    "New_Access_Provider__c": 240,
    "New_Insurance_Provider_Other__c": 282,
    "New_Insurance_Provider__c": 286,
    "New_Insurance_Provider_moving_to__c": 33,
    "New_Software_Platform_moving_to__c": 34,
    "New_Software_Provider__c": 242,
    "New_Website_Platform_moving_to__c": 35,
    "New_Website_Provider__c": 241,
    "Offering_Tenant_Protection_Plans__c": 245,
    "Office_hours__c": 147,
    "Onethingwecouldhavedonedifferently__c": 36,
    "OpportunityId__c": 76,
    "Opportunity_Type__c": 300,
    "Other_CallPotential_Cancellation_Details__c": 279,
    "Other_Cancel_Access_Control__c": 37,
    "Other_Cancel_Insurance__c": 38,
    "Other_Cancel_Payment_Other_Product__c": 39,
    "Other_Cancel_Software_Product__c": 40,
    "Other_Cancel_SpareFoot__c": 41,
    "Other_Cancel_Website_Product__c": 42,
    "Other_Domain_Registration__c": 306,
    "Other_Merch_Provider__c": 218,
    "Other_Pastdue_Event__c": 148,
    "Other_Software_Provider__c": 219,
    "Other_Website_Provider__c": 220,
    "Overage_Rate_for_Minutes__c": 301,
    "Overage_Rate_for_Tracking_Numbers__c": 302,
    "Overlock_Fee__c": 149,
    "Overlock_PastDue_Unit__c": 150,
    "OwnerId": 1,
    "Parent_Corp_Account_Name__c": 303,
    "Payment_Cutoff_Days__c": 272,
    "Payment_or_Other_Product_to_Cancel__c": 43,
    "Per_Minute_Usage__c": 304,
    "Place_Lien_Units__c": 151,
    "Please_Explain__c": 252,
    "Please_provide_the_name_of_the_purchaser__c": 44,
    "Preferred_Availability__c": 254,
    "Preferred_Contact_Method__c": 256,
    "Primary_User_Email__c": 152,
    "Primary_User__c": 153,
    "Promo_discount_offer__c": 154,
    "Prorate_Rent_moveout__c": 155,
    "Prorate_moveout_days__c": 156,
    "PurchFacility_SL_SE_ESS__c": 221,
    "Purchaser_Email__c": 188,
    "Purchaser_Phone__c": 187,
    "Reason_Cancel_Access_Control__c": 45,
    "Reason_Cancel_Insurance__c": 46,
    "Reason_Cancel_Payment_or_Other_Product__c": 47,
    "Reason_Cancel_Software_Product__c": 48,
    "Reason_Cancel_SpareFoot__c": 49,
    "Reason_Cancel_Website_Product__c": 50,
    "Reason_Opting_Out_of_Auto_Protect__c": 253,
    "Reasonforleaving__c": 51,
    "Recipient_Email__c": 222,
    "Recipient_Facility_Name__c": 223,
    "Recipient_Name__c": 224,
    "RecordTypeId": 5,
    "Recur_LateFee_OneTime__c": 157,
    "Related_Record_Created__c": 52,
    "Release_Date__c": 225,
    "Release_domain_name_website__c": 226,
    "Reservation_Fee__c": 158,
    "Retail_or_Merch_sale__c": 159,
    "SE_Company_UUID__c": 263,
    "SE_Facility_UUID__c": 264,
    "SLCorpCode__c": 227,
    "SLLocationCode__c": 228,
    "SSO_Interest_Level__c": 255,
    "Sales_Team_Member__c": 266,
    "Second_Late_Fee__c": 160,
    "Selling_or_Transfer_of_Ownership__c": 61,
    "Send_monthly_rent_invoices__c": 161,
    "Share_login_info__c": 162,
    "Signer_Date_of_Birth__c": 163,
    "Signer_Email__c": 164,
    "Signer_Home_Address__c": 165,
    "Signer_Name__c": 166,
    "Signer_Percentage_Business_Owned__c": 167,
    "Signer_Phone__c": 168,
    "Signer_Title__c": 169,
    "Software_Products_to_Cancel__c": 54,
    "Software_forwardfacility__c": 229,
    "Source__c": 55,
    "SpareFoot_Product_to_Cancel__c": 56,
    "Start_or_acquire_date_of_business__c": 170,
    "Stock_Ticker_Exchange__c": 268,
    "Subject__c": 57,
    "Submission_Date__c": 265,
    "Switching_Product__c": 16,
    "SystemModstamp": 10,
    "Tax_rate_on_rent__c": 171,
    "Temperature_Controlled_Units__c": 172,
    "Tenant_Insurance_Facility__c": 230,
    "Tenant_Insurance_Provider__c": 173,
    "Top_Amenity__c": 174,
    "Total_of_Locations__c": 274,
    "Tracked_Recorded_Line__c": 284,
    "Transferee_Company_Name__c": 231,
    "Transferee_Email__c": 232,
    "Transferee_Phone_Number__c": 233,
    "Transferee_Primary_Contact__c": 234,
    "Type_of_Business__c": 250,
    "UA_Code__c": 175,
    "UNPW_current_software__c": 176,
    "Units__c": 235,
    "Unmanned_Facility__c": 177,
    "Upload_Business_LicenseArticle_Incorp__c": 178,
    "Upload_Logo_Brand__c": 179,
    "Upload_Logo_Website__c": 180,
    "Upload_Signer_Driver_License__c": 181,
    "Upload_Void_Check_or_Bank_Detail__c": 182,
    "Upload_custom_document__c": 183,
    "Use_Gate_Software_Provider__c": 236,
    "Use_Sparefoot_facility__c": 237,
    "WebsiteProvider_Facility__c": 238,
    "Website_Photo_Facility__c": 184,
    "Website_Products_to_Cancel__c": 58,
    "Website_URL__c": 62,
    "What_is_your_domain__c": 260,
    "Where_is_Domain_Registered__c": 307,
    "Which_PoS_or_FMS_will_you_be_using__c": 251,
    "Which_Storable_Software__c": 185,
    "Your_SL_CorpCode__c": 239,
    "of_Locations_Onboarding__c": 275,
    "storEDGE_integrate2__c": 189,
    "storEDGE_integrate__c": 186
}
    • schema_attributes: 
      {
    "ACHAccountNumber__c": "string",
    "ACHInstitutionCity__c": "string",
    "ACHInstitutionName__c": "string",
    "ACHInstitutionPostalCode__c": "string",
    "ACHInstitutionRegion__c": "string",
    "ACHRoutingNumber__c": "string",
    "ACS_quotehardware__c": "string",
    "Access_Control_Competitor_moving_to__c": "string",
    "Access_Control_Products_to_Cancel__c": "string",
    "Access_Hours__c": "string",
    "Access_after_Transfer__c": "string",
    "Access_point_restrict_keypad__c": "string",
    "Accesspointrestrict__c": "string",
    "Account_Record_Type__c": "string",
    "Account_Status__c": "string",
    "Account_Type__c": "string",
    "Account__c": "string",
    "Accounting_method_use__c": "string",
    "Add_info_facility__c": "string",
    "Additional_Comment__c": "string",
    "Addtl_info_or_Qs_on_MS_account__c": "string",
    "Administrative_Fee__c": "string",
    "Already_have_domain__c": "string",
    "Amenities_Offered__c": "string",
    "Amount": "string",
    "Anticipated_Monthly_Vol_per_month__c": "string",
    "Any_Portable_Units__c": "string",
    "Anything_else_we_should_know__c": "string",
    "Archive_Option_email_address__c": "string",
    "Assist_Google_My_Business__c": "string",
    "Auction_Fee_Amount__c": "string",
    "Auction_Units__c": "string",
    "BillingCity__c": "string",
    "BillingCountry__c": "string",
    "BillingName__c": "string",
    "BillingPaymentMethod__c": "string",
    "BillingPostalCode__c": "string",
    "BillingRegion__c": "string",
    "BillingStreet__c": "string",
    "Billing_Settings__c": "string",
    "Business_Country__c": "string",
    "Business_Registration_Number__c": "string",
    "CP_Company_ID__c": "string",
    "CP_Location_ID__c": "string",
    "CP_Products_Being_Purchased__c": "string",
    "CallPotential_Cancellation_Reason__c": "string",
    "CallPotential_Products_to_Cancel__c": "string",
    "CallPotential_going_forward_at_facility__c": "string",
    "CallPotential_interested_in_at_facility__c": "string",
    "Cancel_Single_Multiple_or_All_facility__c": "string",
    "Charge_Second_Late_Fee__c": "string",
    "Charge_Security_Deposit__c": "string",
    "Clone_softwaresetting__c": "string",
    "Clone_website_namefacility__c": "string",
    "CloseDate": "string",
    "Company_Status__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Construction_openbusiness__c": "string",
    "Contact_Email__c": "string",
    "Contact_Name__c": "string",
    "Contact_Person_Email__c": "string",
    "Contact_Person_Name__c": "string",
    "Contact_Person_Phone__c": "string",
    "Contact_Person_Title__c": "string",
    "Contact_Phone__c": "string",
    "Contact_Title__c": "string",
    "Continue_software_service__c": "string",
    "Convertfromspreadsheet__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_Case__c": "string",
    "CreditCardCVV__c": "string",
    "CreditCardExpiration__c": "string",
    "CreditCardName__c": "string",
    "CreditCardNetwork__c": "string",
    "CreditCardNumber__c": "string",
    "CurrencyIsoCode": "string",
    "Current_Software_Provider__c": "string",
    "Custom_document_to_use__c": "string",
    "DBA_City_and_State__c": "string",
    "DBA_Name__c": "string",
    "DBA_Phone__c": "string",
    "DBA_Physical_Address__c": "string",
    "DBA_Zip_Code__c": "string",
    "Date_Signed__c": "string",
    "Date_start_software__c": "string",
    "Date_to_be_released__c": "string",
    "Day_Past_Due_FirstFee__c": "string",
    "Day_Past_Due_Notice__c": "string",
    "Days_Past_Due_Lien__c": "string",
    "Days_Past_Due_Locktenant__c": "string",
    "Days_Past_Due_Overlock__c": "string",
    "Days_prior_send_invoice__c": "string",
    "Days_until_second_late_fee__c": "string",
    "Desirable_New_City__c": "string",
    "Device_Quantity__c": "string",
    "Discuss_with_our_Product_Manager__c": "string",
    "Doc_electronic_sign__c": "string",
    "DocuSignStatus__c": "string",
    "Domain_Registration_Location__c": "string",
    "Emphasize_On_Website__c": "string",
    "Est_date_opening_facility__c": "string",
    "Existing_Corp_Code__c": "string",
    "Existing_SMS_account__c": "string",
    "ExpectedRevenue": "string",
    "Expected_FMS_start_date__c": "string",
    "Explain_Auction_process__c": "string",
    "FMS_converting_from__c": "string",
    "Faciilty_Legal_Entity_Name__c": "string",
    "Facility_Cancel_List__c": "string",
    "Facility_Email__c": "string",
    "Facility_ID__c": "string",
    "Facility_Legal_City_and_State__c": "string",
    "Facility_Legal_Mailing_Street_Address__c": "string",
    "Facility_Legal_Phone__c": "string",
    "Facility_Legal_Zip_Code__c": "string",
    "Facility_Name__c": "string",
    "Facility_Phone_Number__c": "string",
    "Facility_State__c": "string",
    "Facility_clone__c": "string",
    "Federal_Tax_ID__c": "string",
    "First_Late_Fee__c": "string",
    "ForecastCategory": "string",
    "FormURL__c": "string",
    "Form_Record_Type__c": "string",
    "Full_Address__c": "string",
    "GTM_ID__c": "string",
    "Gate_Software_Provider__c": "string",
    "Gatefacility_access_hours__c": "string",
    "Gmail_for_GA__c": "string",
    "Google_Analytics__c": "string",
    "Google_My_Business_Listing_Question__c": "string",
    "Google_My_Business_Listing__c": "string",
    "Have_Logo_Facility__c": "string",
    "Historical_Data_Selection__c": "string",
    "Holiday_Hours__c": "string",
    "How_much_Security_Deposit__c": "string",
    "How_payments_applied__c": "string",
    "Id": "string",
    "If_Other_Amenities__c": "string",
    "If_Other_what_is_name_of_Gate_Provider__c": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "Insurance_Product_to_Cancel__c": "string",
    "Insuranceprotection_plan__c": "string",
    "Integration_Permission_True__c": "string",
    "Interest_Digital_Marketing__c": "string",
    "Interest_Sparefoot_facility__c": "string",
    "Interest_in_CallPotential__c": "string",
    "Interest_in_Data_Archive__c": "string",
    "Interest_in_Data_Decryption__c": "string",
    "Invoice_Method__c": "string",
    "IsDeleted": "string",
    "JotForm_Enter_Case_Number__c": "string",
    "Jotform_Submission_ID__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "License_Holder__c": "string",
    "Lien_Fee__c": "string",
    "Link_SLSE_Software__c": "string",
    "List_merch_items__c": "string",
    "Loc_Code_Preference__c": "string",
    "Location_Code__c": "string",
    "Location_Country__c": "string",
    "Lock_Cutting_Fee__c": "string",
    "Login_Credentials__c": "string",
    "Login_For_Domain__c": "string",
    "MS_Preapplication_JotForm__c": "string",
    "ManageCompany_Ownersame__c": "string",
    "Management_Software__c": "string",
    "Managesoftware_convert__c": "string",
    "Maximum_Usage__c": "string",
    "Merch_Provider_Facility__c": "string",
    "MerchantId__c": "string",
    "Merchant_Timezone__c": "string",
    "Modules_Launching__c": "string",
    "NSF_Fee__c": "string",
    "Name": "string",
    "Name_Facility_Purchase__c": "string",
    "Name_POS_or_FMS_used__c": "string",
    "Nearby_Landmarks__c": "string",
    "Nearby_Neighborhoods__c": "string",
    "NewWebsite_ExistingDomain__c": "string",
    "New_Access_Provider__c": "string",
    "New_Insurance_Provider_Other__c": "string",
    "New_Insurance_Provider__c": "string",
    "New_Insurance_Provider_moving_to__c": "string",
    "New_Software_Platform_moving_to__c": "string",
    "New_Software_Provider__c": "string",
    "New_Website_Platform_moving_to__c": "string",
    "New_Website_Provider__c": "string",
    "Offering_Tenant_Protection_Plans__c": "string",
    "Office_hours__c": "string",
    "Onethingwecouldhavedonedifferently__c": "string",
    "OpportunityId": "string",
    "OpportunityId__c": "string",
    "Opportunity_Type__c": "string",
    "Other_CallPotential_Cancellation_Details__c": "string",
    "Other_Cancel_Access_Control__c": "string",
    "Other_Cancel_Insurance__c": "string",
    "Other_Cancel_Payment_Other_Product__c": "string",
    "Other_Cancel_Software_Product__c": "string",
    "Other_Cancel_SpareFoot__c": "string",
    "Other_Cancel_Website_Product__c": "string",
    "Other_Domain_Registration__c": "string",
    "Other_Merch_Provider__c": "string",
    "Other_Pastdue_Event__c": "string",
    "Other_Software_Provider__c": "string",
    "Other_Website_Provider__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "Overlock_Fee__c": "string",
    "Overlock_PastDue_Unit__c": "string",
    "OwnerId": "string",
    "Parent_Corp_Account_Name__c": "string",
    "Payment_Cutoff_Days__c": "string",
    "Payment_or_Other_Product_to_Cancel__c": "string",
    "Per_Minute_Usage__c": "string",
    "Place_Lien_Units__c": "string",
    "Please_Explain__c": "string",
    "Please_provide_the_name_of_the_purchaser__c": "string",
    "Preferred_Availability__c": "string",
    "Preferred_Contact_Method__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_User_Email__c": "string",
    "Primary_User__c": "string",
    "Probability": "string",
    "Promo_discount_offer__c": "string",
    "Prorate_Rent_moveout__c": "string",
    "Prorate_moveout_days__c": "string",
    "PurchFacility_SL_SE_ESS__c": "string",
    "Purchaser_Email__c": "string",
    "Purchaser_Phone__c": "string",
    "Reason_Cancel_Access_Control__c": "string",
    "Reason_Cancel_Insurance__c": "string",
    "Reason_Cancel_Payment_or_Other_Product__c": "string",
    "Reason_Cancel_Software_Product__c": "string",
    "Reason_Cancel_SpareFoot__c": "string",
    "Reason_Cancel_Website_Product__c": "string",
    "Reason_Opting_Out_of_Auto_Protect__c": "string",
    "Reasonforleaving__c": "string",
    "Recipient_Email__c": "string",
    "Recipient_Facility_Name__c": "string",
    "Recipient_Name__c": "string",
    "RecordTypeId": "string",
    "Recur_LateFee_OneTime__c": "string",
    "Related_Record_Created__c": "string",
    "Release_Date__c": "string",
    "Release_domain_name_website__c": "string",
    "Reservation_Fee__c": "string",
    "Retail_or_Merch_sale__c": "string",
    "SE_Company_UUID__c": "string",
    "SE_Facility_UUID__c": "string",
    "SLCorpCode__c": "string",
    "SLLocationCode__c": "string",
    "SSO_Interest_Level__c": "string",
    "Sales_Team_Member__c": "string",
    "Second_Late_Fee__c": "string",
    "Selling_or_Transfer_of_Ownership__c": "string",
    "Send_monthly_rent_invoices__c": "string",
    "Share_login_info__c": "string",
    "Signer_Date_of_Birth__c": "string",
    "Signer_Email__c": "string",
    "Signer_Home_Address__c": "string",
    "Signer_Name__c": "string",
    "Signer_Percentage_Business_Owned__c": "string",
    "Signer_Phone__c": "string",
    "Signer_Title__c": "string",
    "Software_Products_to_Cancel__c": "string",
    "Software_forwardfacility__c": "string",
    "Source__c": "string",
    "SpareFoot_Product_to_Cancel__c": "string",
    "StageName": "string",
    "Start_or_acquire_date_of_business__c": "string",
    "Stock_Ticker_Exchange__c": "string",
    "Subject__c": "string",
    "Submission_Date__c": "string",
    "Switching_Product__c": "string",
    "SystemModstamp": "string",
    "Tax_rate_on_rent__c": "string",
    "Temperature_Controlled_Units__c": "string",
    "Tenant_Insurance_Facility__c": "string",
    "Tenant_Insurance_Provider__c": "string",
    "Top_Amenity__c": "string",
    "Total_of_Locations__c": "string",
    "Tracked_Recorded_Line__c": "string",
    "Transferee_Company_Name__c": "string",
    "Transferee_Email__c": "string",
    "Transferee_Phone_Number__c": "string",
    "Transferee_Primary_Contact__c": "string",
    "Type_of_Business__c": "string",
    "UA_Code__c": "string",
    "UNPW_current_software__c": "string",
    "Units__c": "string",
    "Unmanned_Facility__c": "string",
    "Upload_Business_LicenseArticle_Incorp__c": "string",
    "Upload_Logo_Brand__c": "string",
    "Upload_Logo_Website__c": "string",
    "Upload_Signer_Driver_License__c": "string",
    "Upload_Void_Check_or_Bank_Detail__c": "string",
    "Upload_custom_document__c": "string",
    "Use_Gate_Software_Provider__c": "string",
    "Use_Sparefoot_facility__c": "string",
    "WebsiteProvider_Facility__c": "string",
    "Website_Photo_Facility__c": "string",
    "Website_Products_to_Cancel__c": "string",
    "Website_URL__c": "string",
    "What_is_your_domain__c": "string",
    "Where_is_Domain_Registered__c": "string",
    "Which_PoS_or_FMS_will_you_be_using__c": "string",
    "Which_Storable_Software__c": "string",
    "Your_SL_CorpCode__c": "string",
    "of_Locations_Onboarding__c": "string",
    "storEDGE_integrate2__c": "string",
    "storEDGE_integrate__c": "string"
}
    • schema_name_id: 2060
    • schema_scan_id: 6510750
    • updated: 2024-06-10 15:36:03
    • created: 2024-01-11 09:08:46
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_form_response__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_form_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Access_Control_Competitor_moving_to__c`  string , `Access_Control_Products_to_Cancel__c`  string , `Anything_else_we_should_know__c`  string , `Switching_Product__c`  string , `Cancel_Single_Multiple_or_All_facility__c`  string , `Access_Hours__c`  string , `Accounting_method_use__c`  string , `Add_info_facility__c`  string , `Administrative_Fee__c`  string , `Already_have_domain__c`  string , `Amenities_Offered__c`  string , `Contact_Email__c`  string , `Contact_Name__c`  string , `Contact_Phone__c`  string , `Created_Case__c`  string , `Anticipated_Monthly_Vol_per_month__c`  string , `Facility_Cancel_List__c`  string , `Assist_Google_My_Business__c`  string , `Form_Record_Type__c`  string , `Insurance_Product_to_Cancel__c`  string , `New_Insurance_Provider_moving_to__c`  string , `New_Software_Platform_moving_to__c`  string , `New_Website_Platform_moving_to__c`  string , `Onethingwecouldhavedonedifferently__c`  string , `Other_Cancel_Access_Control__c`  string , `Other_Cancel_Insurance__c`  string , `Other_Cancel_Payment_Other_Product__c`  string , `Other_Cancel_Software_Product__c`  string , `Other_Cancel_SpareFoot__c`  string , `Other_Cancel_Website_Product__c`  string , `Payment_or_Other_Product_to_Cancel__c`  string , `Please_provide_the_name_of_the_purchaser__c`  string , `Reason_Cancel_Access_Control__c`  string , `Reason_Cancel_Insurance__c`  string , `Reason_Cancel_Payment_or_Other_Product__c`  string , `Reason_Cancel_Software_Product__c`  string , `Reason_Cancel_SpareFoot__c`  string , `Reason_Cancel_Website_Product__c`  string , `Reasonforleaving__c`  string , `Related_Record_Created__c`  string , `Auction_Units__c`  string , `Software_Products_to_Cancel__c`  string , `Source__c`  string , `SpareFoot_Product_to_Cancel__c`  string , `Subject__c`  string , `Website_Products_to_Cancel__c`  string , `Discuss_with_our_Product_Manager__c`  string , `Interest_in_Data_Archive__c`  string , `Selling_or_Transfer_of_Ownership__c`  string , `Website_URL__c`  string , `Jotform_Submission_ID__c`  string , `DocuSignStatus__c`  string , `CreditCardNumber__c`  string , `CreditCardExpiration__c`  string , `CreditCardNetwork__c`  string , `CreditCardName__c`  string , `BillingName__c`  string , `BillingCity__c`  string , `BillingCountry__c`  string , `BillingPostalCode__c`  string , `BillingRegion__c`  string , `BillingStreet__c`  string , `BillingPaymentMethod__c`  string , `OpportunityId__c`  string , `ACHAccountNumber__c`  string , `ACHRoutingNumber__c`  string , `ACHInstitutionCity__c`  string , `ACHInstitutionName__c`  string , `ACHInstitutionPostalCode__c`  string , `ACHInstitutionRegion__c`  string , `FormURL__c`  string , `Billing_Settings__c`  string , `Device_Quantity__c`  string , `Facility_ID__c`  string , `Full_Address__c`  string , `MerchantId__c`  string , `Merchant_Timezone__c`  string , `Charge_Second_Late_Fee__c`  string , `Charge_Security_Deposit__c`  string , `Contact_Person_Email__c`  string , `Contact_Person_Name__c`  string , `Contact_Person_Phone__c`  string , `Contact_Person_Title__c`  string , `Custom_document_to_use__c`  string , `DBA_City_and_State__c`  string , `DBA_Name__c`  string , `DBA_Phone__c`  string , `DBA_Physical_Address__c`  string , `DBA_Zip_Code__c`  string , `Date_start_software__c`  string , `Day_Past_Due_FirstFee__c`  string , `Day_Past_Due_Notice__c`  string , `Days_Past_Due_Lien__c`  string , `Days_Past_Due_Locktenant__c`  string , `Days_Past_Due_Overlock__c`  string , `Days_prior_send_invoice__c`  string , `Desirable_New_City__c`  string , `Doc_electronic_sign__c`  string , `Domain_Registration_Location__c`  string , `Emphasize_On_Website__c`  string , `Est_date_opening_facility__c`  string , `Explain_Auction_process__c`  string , `FMS_converting_from__c`  string , `Faciilty_Legal_Entity_Name__c`  string , `Facility_Email__c`  string , `Facility_Legal_City_and_State__c`  string , `Facility_Legal_Mailing_Street_Address__c`  string , `Facility_Legal_Phone__c`  string , `Facility_Legal_Zip_Code__c`  string , `Facility_State__c`  string , `Federal_Tax_ID__c`  string , `First_Late_Fee__c`  string , `Gate_Software_Provider__c`  string , `Gatefacility_access_hours__c`  string , `Google_Analytics__c`  string , `Google_My_Business_Listing_Question__c`  string , `Google_My_Business_Listing__c`  string , `Have_Logo_Facility__c`  string , `Holiday_Hours__c`  string , `How_much_Security_Deposit__c`  string , `How_payments_applied__c`  string , `Insuranceprotection_plan__c`  string , `JotForm_Enter_Case_Number__c`  string , `Lien_Fee__c`  string , `Link_SLSE_Software__c`  string , `List_merch_items__c`  string , `Lock_Cutting_Fee__c`  string , `Login_Credentials__c`  string , `Login_For_Domain__c`  string , `MS_Preapplication_JotForm__c`  string , `NSF_Fee__c`  string , `Name_POS_or_FMS_used__c`  string , `Nearby_Landmarks__c`  string , `Nearby_Neighborhoods__c`  string , `Office_hours__c`  string , `Other_Pastdue_Event__c`  string , `Overlock_Fee__c`  string , `Overlock_PastDue_Unit__c`  string , `Place_Lien_Units__c`  string , `Primary_User_Email__c`  string , `Primary_User__c`  string , `Promo_discount_offer__c`  string , `Prorate_Rent_moveout__c`  string , `Prorate_moveout_days__c`  string , `Recur_LateFee_OneTime__c`  string , `Reservation_Fee__c`  string , `Retail_or_Merch_sale__c`  string , `Second_Late_Fee__c`  string , `Send_monthly_rent_invoices__c`  string , `Share_login_info__c`  string , `Signer_Date_of_Birth__c`  string , `Signer_Email__c`  string , `Signer_Home_Address__c`  string , `Signer_Name__c`  string , `Signer_Percentage_Business_Owned__c`  string , `Signer_Phone__c`  string , `Signer_Title__c`  string , `Start_or_acquire_date_of_business__c`  string , `Tax_rate_on_rent__c`  string , `Temperature_Controlled_Units__c`  string , `Tenant_Insurance_Provider__c`  string , `Top_Amenity__c`  string , `UA_Code__c`  string , `UNPW_current_software__c`  string , `Unmanned_Facility__c`  string , `Upload_Business_LicenseArticle_Incorp__c`  string , `Upload_Logo_Brand__c`  string , `Upload_Logo_Website__c`  string , `Upload_Signer_Driver_License__c`  string , `Upload_Void_Check_or_Bank_Detail__c`  string , `Upload_custom_document__c`  string , `Website_Photo_Facility__c`  string , `Which_Storable_Software__c`  string , `storEDGE_integrate__c`  string , `Purchaser_Phone__c`  string , `Purchaser_Email__c`  string , `storEDGE_integrate2__c`  string , `ACS_quotehardware__c`  string , `Access_after_Transfer__c`  string , `Access_point_restrict_keypad__c`  string , `Accesspointrestrict__c`  string , `Additional_Comment__c`  string , `Any_Portable_Units__c`  string , `Archive_Option_email_address__c`  string , `Clone_softwaresetting__c`  string , `Clone_website_namefacility__c`  string , `Construction_openbusiness__c`  string , `Continue_software_service__c`  string , `Convertfromspreadsheet__c`  string , `Current_Software_Provider__c`  string , `Date_Signed__c`  string , `Date_to_be_released__c`  string , `Existing_Corp_Code__c`  string , `Facility_clone__c`  string , `Historical_Data_Selection__c`  string , `Interest_Digital_Marketing__c`  string , `Interest_Sparefoot_facility__c`  string , `License_Holder__c`  string , `Loc_Code_Preference__c`  string , `Location_Code__c`  string , `ManageCompany_Ownersame__c`  string , `Managesoftware_convert__c`  string , `Merch_Provider_Facility__c`  string , `Name_Facility_Purchase__c`  string , `NewWebsite_ExistingDomain__c`  string , `Other_Merch_Provider__c`  string , `Other_Software_Provider__c`  string , `Other_Website_Provider__c`  string , `PurchFacility_SL_SE_ESS__c`  string , `Recipient_Email__c`  string , `Recipient_Facility_Name__c`  string , `Recipient_Name__c`  string , `Release_Date__c`  string , `Release_domain_name_website__c`  string , `SLCorpCode__c`  string , `SLLocationCode__c`  string , `Software_forwardfacility__c`  string , `Tenant_Insurance_Facility__c`  string , `Transferee_Company_Name__c`  string , `Transferee_Email__c`  string , `Transferee_Phone_Number__c`  string , `Transferee_Primary_Contact__c`  string , `Units__c`  string , `Use_Gate_Software_Provider__c`  string , `Use_Sparefoot_facility__c`  string , `WebsiteProvider_Facility__c`  string , `Your_SL_CorpCode__c`  string , `New_Access_Provider__c`  string , `New_Website_Provider__c`  string , `New_Software_Provider__c`  string , `Auction_Fee_Amount__c`  string , `Days_until_second_late_fee__c`  string , `Offering_Tenant_Protection_Plans__c`  string , `Invoice_Method__c`  string , `Addtl_info_or_Qs_on_MS_account__c`  string , `Existing_SMS_account__c`  string , `Expected_FMS_start_date__c`  string , `Type_of_Business__c`  string , `Which_PoS_or_FMS_will_you_be_using__c`  string , `Please_Explain__c`  string , `Reason_Opting_Out_of_Auto_Protect__c`  string , `Preferred_Availability__c`  string , `SSO_Interest_Level__c`  string , `Preferred_Contact_Method__c`  string , `CreditCardCVV__c`  string , `GTM_ID__c`  string , `If_Other_what_is_name_of_Gate_Provider__c`  string , `What_is_your_domain__c`  string , `Facility_Phone_Number__c`  string , `Gmail_for_GA__c`  string , `SE_Company_UUID__c`  string , `SE_Facility_UUID__c`  string , `Submission_Date__c`  string , `Sales_Team_Member__c`  string , `Company_Status__c`  string , `Stock_Ticker_Exchange__c`  string , `Contact_Title__c`  string , `Account__c`  string , `Payment_Cutoff_Days__c`  string , `CallPotential_Cancellation_Reason__c`  string , `Total_of_Locations__c`  string , `of_Locations_Onboarding__c`  string , `Modules_Launching__c`  string , `Management_Software__c`  string , `CallPotential_Products_to_Cancel__c`  string , `Other_CallPotential_Cancellation_Details__c`  string , `Business_Country__c`  string , `Location_Country__c`  string , `Business_Registration_Number__c`  string , `Tracked_Recorded_Line__c`  string , `Integration_Permission_True__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-dev/raw/form_response__cs/2024-01-11/1704985681'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_form_response__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/form_response__cs/2024-01-11/1704985681
    • id: 4700470
    • processed: 1
    • raw_data: 
      {
    "ACHAccountNumber__c": 77,
    "ACHInstitutionCity__c": 79,
    "ACHInstitutionName__c": 80,
    "ACHInstitutionPostalCode__c": 81,
    "ACHInstitutionRegion__c": 82,
    "ACHRoutingNumber__c": 78,
    "ACS_quotehardware__c": 190,
    "Access_Control_Competitor_moving_to__c": 13,
    "Access_Control_Products_to_Cancel__c": 14,
    "Access_Hours__c": 18,
    "Access_after_Transfer__c": 191,
    "Access_point_restrict_keypad__c": 192,
    "Accesspointrestrict__c": 193,
    "Account__c": 270,
    "Accounting_method_use__c": 19,
    "Add_info_facility__c": 20,
    "Additional_Comment__c": 194,
    "Addtl_info_or_Qs_on_MS_account__c": 247,
    "Administrative_Fee__c": 21,
    "Already_have_domain__c": 22,
    "Amenities_Offered__c": 23,
    "Anticipated_Monthly_Vol_per_month__c": 28,
    "Any_Portable_Units__c": 195,
    "Anything_else_we_should_know__c": 15,
    "Archive_Option_email_address__c": 196,
    "Assist_Google_My_Business__c": 30,
    "Auction_Fee_Amount__c": 243,
    "Auction_Units__c": 53,
    "BillingCity__c": 70,
    "BillingCountry__c": 71,
    "BillingName__c": 69,
    "BillingPaymentMethod__c": 75,
    "BillingPostalCode__c": 72,
    "BillingRegion__c": 73,
    "BillingStreet__c": 74,
    "Billing_Settings__c": 84,
    "Business_Country__c": 279,
    "Business_Registration_Number__c": 281,
    "CallPotential_Cancellation_Reason__c": 272,
    "CallPotential_Products_to_Cancel__c": 277,
    "Cancel_Single_Multiple_or_All_facility__c": 17,
    "Charge_Second_Late_Fee__c": 90,
    "Charge_Security_Deposit__c": 91,
    "Clone_softwaresetting__c": 197,
    "Clone_website_namefacility__c": 198,
    "Company_Status__c": 267,
    "ConnectionReceivedId": 11,
    "ConnectionSentId": 12,
    "Construction_openbusiness__c": 199,
    "Contact_Email__c": 24,
    "Contact_Name__c": 25,
    "Contact_Person_Email__c": 92,
    "Contact_Person_Name__c": 93,
    "Contact_Person_Phone__c": 94,
    "Contact_Person_Title__c": 95,
    "Contact_Phone__c": 26,
    "Contact_Title__c": 269,
    "Continue_software_service__c": 200,
    "Convertfromspreadsheet__c": 201,
    "CreatedById": 7,
    "CreatedDate": 6,
    "Created_Case__c": 27,
    "CreditCardCVV__c": 257,
    "CreditCardExpiration__c": 66,
    "CreditCardName__c": 68,
    "CreditCardNetwork__c": 67,
    "CreditCardNumber__c": 65,
    "CurrencyIsoCode": 4,
    "Current_Software_Provider__c": 202,
    "Custom_document_to_use__c": 96,
    "DBA_City_and_State__c": 97,
    "DBA_Name__c": 98,
    "DBA_Phone__c": 99,
    "DBA_Physical_Address__c": 100,
    "DBA_Zip_Code__c": 101,
    "Date_Signed__c": 203,
    "Date_start_software__c": 102,
    "Date_to_be_released__c": 204,
    "Day_Past_Due_FirstFee__c": 103,
    "Day_Past_Due_Notice__c": 104,
    "Days_Past_Due_Lien__c": 105,
    "Days_Past_Due_Locktenant__c": 106,
    "Days_Past_Due_Overlock__c": 107,
    "Days_prior_send_invoice__c": 108,
    "Days_until_second_late_fee__c": 244,
    "Desirable_New_City__c": 109,
    "Device_Quantity__c": 85,
    "Discuss_with_our_Product_Manager__c": 59,
    "Doc_electronic_sign__c": 110,
    "DocuSignStatus__c": 64,
    "Domain_Registration_Location__c": 111,
    "Emphasize_On_Website__c": 112,
    "Est_date_opening_facility__c": 113,
    "Existing_Corp_Code__c": 205,
    "Existing_SMS_account__c": 248,
    "Expected_FMS_start_date__c": 249,
    "Explain_Auction_process__c": 114,
    "FMS_converting_from__c": 115,
    "Faciilty_Legal_Entity_Name__c": 116,
    "Facility_Cancel_List__c": 29,
    "Facility_Email__c": 117,
    "Facility_ID__c": 86,
    "Facility_Legal_City_and_State__c": 118,
    "Facility_Legal_Mailing_Street_Address__c": 119,
    "Facility_Legal_Phone__c": 120,
    "Facility_Legal_Zip_Code__c": 121,
    "Facility_Phone_Number__c": 261,
    "Facility_State__c": 122,
    "Facility_clone__c": 206,
    "Federal_Tax_ID__c": 123,
    "First_Late_Fee__c": 124,
    "FormURL__c": 83,
    "Form_Record_Type__c": 31,
    "Full_Address__c": 87,
    "GTM_ID__c": 258,
    "Gate_Software_Provider__c": 125,
    "Gatefacility_access_hours__c": 126,
    "Gmail_for_GA__c": 262,
    "Google_Analytics__c": 127,
    "Google_My_Business_Listing_Question__c": 128,
    "Google_My_Business_Listing__c": 129,
    "Have_Logo_Facility__c": 130,
    "Historical_Data_Selection__c": 207,
    "Holiday_Hours__c": 131,
    "How_much_Security_Deposit__c": 132,
    "How_payments_applied__c": 133,
    "Id": 0,
    "If_Other_what_is_name_of_Gate_Provider__c": 259,
    "Insurance_Product_to_Cancel__c": 32,
    "Insuranceprotection_plan__c": 134,
    "Integration_Permission_True__c": 283,
    "Interest_Digital_Marketing__c": 208,
    "Interest_Sparefoot_facility__c": 209,
    "Interest_in_Data_Archive__c": 60,
    "Invoice_Method__c": 246,
    "IsDeleted": 2,
    "JotForm_Enter_Case_Number__c": 135,
    "Jotform_Submission_ID__c": 63,
    "LastModifiedById": 9,
    "LastModifiedDate": 8,
    "License_Holder__c": 210,
    "Lien_Fee__c": 136,
    "Link_SLSE_Software__c": 137,
    "List_merch_items__c": 138,
    "Loc_Code_Preference__c": 211,
    "Location_Code__c": 212,
    "Location_Country__c": 280,
    "Lock_Cutting_Fee__c": 139,
    "Login_Credentials__c": 140,
    "Login_For_Domain__c": 141,
    "MS_Preapplication_JotForm__c": 142,
    "ManageCompany_Ownersame__c": 213,
    "Management_Software__c": 276,
    "Managesoftware_convert__c": 214,
    "Merch_Provider_Facility__c": 215,
    "MerchantId__c": 88,
    "Merchant_Timezone__c": 89,
    "Modules_Launching__c": 275,
    "NSF_Fee__c": 143,
    "Name": 3,
    "Name_Facility_Purchase__c": 216,
    "Name_POS_or_FMS_used__c": 144,
    "Nearby_Landmarks__c": 145,
    "Nearby_Neighborhoods__c": 146,
    "NewWebsite_ExistingDomain__c": 217,
    "New_Access_Provider__c": 240,
    "New_Insurance_Provider_moving_to__c": 33,
    "New_Software_Platform_moving_to__c": 34,
    "New_Software_Provider__c": 242,
    "New_Website_Platform_moving_to__c": 35,
    "New_Website_Provider__c": 241,
    "Offering_Tenant_Protection_Plans__c": 245,
    "Office_hours__c": 147,
    "Onethingwecouldhavedonedifferently__c": 36,
    "OpportunityId__c": 76,
    "Other_CallPotential_Cancellation_Details__c": 278,
    "Other_Cancel_Access_Control__c": 37,
    "Other_Cancel_Insurance__c": 38,
    "Other_Cancel_Payment_Other_Product__c": 39,
    "Other_Cancel_Software_Product__c": 40,
    "Other_Cancel_SpareFoot__c": 41,
    "Other_Cancel_Website_Product__c": 42,
    "Other_Merch_Provider__c": 218,
    "Other_Pastdue_Event__c": 148,
    "Other_Software_Provider__c": 219,
    "Other_Website_Provider__c": 220,
    "Overlock_Fee__c": 149,
    "Overlock_PastDue_Unit__c": 150,
    "OwnerId": 1,
    "Payment_Cutoff_Days__c": 271,
    "Payment_or_Other_Product_to_Cancel__c": 43,
    "Place_Lien_Units__c": 151,
    "Please_Explain__c": 252,
    "Please_provide_the_name_of_the_purchaser__c": 44,
    "Preferred_Availability__c": 254,
    "Preferred_Contact_Method__c": 256,
    "Primary_User_Email__c": 152,
    "Primary_User__c": 153,
    "Promo_discount_offer__c": 154,
    "Prorate_Rent_moveout__c": 155,
    "Prorate_moveout_days__c": 156,
    "PurchFacility_SL_SE_ESS__c": 221,
    "Purchaser_Email__c": 188,
    "Purchaser_Phone__c": 187,
    "Reason_Cancel_Access_Control__c": 45,
    "Reason_Cancel_Insurance__c": 46,
    "Reason_Cancel_Payment_or_Other_Product__c": 47,
    "Reason_Cancel_Software_Product__c": 48,
    "Reason_Cancel_SpareFoot__c": 49,
    "Reason_Cancel_Website_Product__c": 50,
    "Reason_Opting_Out_of_Auto_Protect__c": 253,
    "Reasonforleaving__c": 51,
    "Recipient_Email__c": 222,
    "Recipient_Facility_Name__c": 223,
    "Recipient_Name__c": 224,
    "RecordTypeId": 5,
    "Recur_LateFee_OneTime__c": 157,
    "Related_Record_Created__c": 52,
    "Release_Date__c": 225,
    "Release_domain_name_website__c": 226,
    "Reservation_Fee__c": 158,
    "Retail_or_Merch_sale__c": 159,
    "SE_Company_UUID__c": 263,
    "SE_Facility_UUID__c": 264,
    "SLCorpCode__c": 227,
    "SLLocationCode__c": 228,
    "SSO_Interest_Level__c": 255,
    "Sales_Team_Member__c": 266,
    "Second_Late_Fee__c": 160,
    "Selling_or_Transfer_of_Ownership__c": 61,
    "Send_monthly_rent_invoices__c": 161,
    "Share_login_info__c": 162,
    "Signer_Date_of_Birth__c": 163,
    "Signer_Email__c": 164,
    "Signer_Home_Address__c": 165,
    "Signer_Name__c": 166,
    "Signer_Percentage_Business_Owned__c": 167,
    "Signer_Phone__c": 168,
    "Signer_Title__c": 169,
    "Software_Products_to_Cancel__c": 54,
    "Software_forwardfacility__c": 229,
    "Source__c": 55,
    "SpareFoot_Product_to_Cancel__c": 56,
    "Start_or_acquire_date_of_business__c": 170,
    "Stock_Ticker_Exchange__c": 268,
    "Subject__c": 57,
    "Submission_Date__c": 265,
    "Switching_Product__c": 16,
    "SystemModstamp": 10,
    "Tax_rate_on_rent__c": 171,
    "Temperature_Controlled_Units__c": 172,
    "Tenant_Insurance_Facility__c": 230,
    "Tenant_Insurance_Provider__c": 173,
    "Top_Amenity__c": 174,
    "Total_of_Locations__c": 273,
    "Tracked_Recorded_Line__c": 282,
    "Transferee_Company_Name__c": 231,
    "Transferee_Email__c": 232,
    "Transferee_Phone_Number__c": 233,
    "Transferee_Primary_Contact__c": 234,
    "Type_of_Business__c": 250,
    "UA_Code__c": 175,
    "UNPW_current_software__c": 176,
    "Units__c": 235,
    "Unmanned_Facility__c": 177,
    "Upload_Business_LicenseArticle_Incorp__c": 178,
    "Upload_Logo_Brand__c": 179,
    "Upload_Logo_Website__c": 180,
    "Upload_Signer_Driver_License__c": 181,
    "Upload_Void_Check_or_Bank_Detail__c": 182,
    "Upload_custom_document__c": 183,
    "Use_Gate_Software_Provider__c": 236,
    "Use_Sparefoot_facility__c": 237,
    "WebsiteProvider_Facility__c": 238,
    "Website_Photo_Facility__c": 184,
    "Website_Products_to_Cancel__c": 58,
    "Website_URL__c": 62,
    "What_is_your_domain__c": 260,
    "Which_PoS_or_FMS_will_you_be_using__c": 251,
    "Which_Storable_Software__c": 185,
    "Your_SL_CorpCode__c": 239,
    "of_Locations_Onboarding__c": 274,
    "storEDGE_integrate2__c": 189,
    "storEDGE_integrate__c": 186
}
    • schema_attributes: 
      {
    "ACHAccountNumber__c": "string",
    "ACHInstitutionCity__c": "string",
    "ACHInstitutionName__c": "string",
    "ACHInstitutionPostalCode__c": "string",
    "ACHInstitutionRegion__c": "string",
    "ACHRoutingNumber__c": "string",
    "ACS_quotehardware__c": "string",
    "Access_Control_Competitor_moving_to__c": "string",
    "Access_Control_Products_to_Cancel__c": "string",
    "Access_Hours__c": "string",
    "Access_after_Transfer__c": "string",
    "Access_point_restrict_keypad__c": "string",
    "Accesspointrestrict__c": "string",
    "Account__c": "string",
    "Accounting_method_use__c": "string",
    "Add_info_facility__c": "string",
    "Additional_Comment__c": "string",
    "Addtl_info_or_Qs_on_MS_account__c": "string",
    "Administrative_Fee__c": "string",
    "Already_have_domain__c": "string",
    "Amenities_Offered__c": "string",
    "Amount": "string",
    "Anticipated_Monthly_Vol_per_month__c": "string",
    "Any_Portable_Units__c": "string",
    "Anything_else_we_should_know__c": "string",
    "Archive_Option_email_address__c": "string",
    "Assist_Google_My_Business__c": "string",
    "Auction_Fee_Amount__c": "string",
    "Auction_Units__c": "string",
    "BillingCity__c": "string",
    "BillingCountry__c": "string",
    "BillingName__c": "string",
    "BillingPaymentMethod__c": "string",
    "BillingPostalCode__c": "string",
    "BillingRegion__c": "string",
    "BillingStreet__c": "string",
    "Billing_Settings__c": "string",
    "Business_Country__c": "string",
    "Business_Registration_Number__c": "string",
    "CallPotential_Cancellation_Reason__c": "string",
    "CallPotential_Products_to_Cancel__c": "string",
    "Cancel_Single_Multiple_or_All_facility__c": "string",
    "Charge_Second_Late_Fee__c": "string",
    "Charge_Security_Deposit__c": "string",
    "Clone_softwaresetting__c": "string",
    "Clone_website_namefacility__c": "string",
    "CloseDate": "string",
    "Company_Status__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Construction_openbusiness__c": "string",
    "Contact_Email__c": "string",
    "Contact_Name__c": "string",
    "Contact_Person_Email__c": "string",
    "Contact_Person_Name__c": "string",
    "Contact_Person_Phone__c": "string",
    "Contact_Person_Title__c": "string",
    "Contact_Phone__c": "string",
    "Contact_Title__c": "string",
    "Continue_software_service__c": "string",
    "Convertfromspreadsheet__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_Case__c": "string",
    "CreditCardCVV__c": "string",
    "CreditCardExpiration__c": "string",
    "CreditCardName__c": "string",
    "CreditCardNetwork__c": "string",
    "CreditCardNumber__c": "string",
    "CurrencyIsoCode": "string",
    "Current_Software_Provider__c": "string",
    "Custom_document_to_use__c": "string",
    "DBA_City_and_State__c": "string",
    "DBA_Name__c": "string",
    "DBA_Phone__c": "string",
    "DBA_Physical_Address__c": "string",
    "DBA_Zip_Code__c": "string",
    "Date_Signed__c": "string",
    "Date_start_software__c": "string",
    "Date_to_be_released__c": "string",
    "Day_Past_Due_FirstFee__c": "string",
    "Day_Past_Due_Notice__c": "string",
    "Days_Past_Due_Lien__c": "string",
    "Days_Past_Due_Locktenant__c": "string",
    "Days_Past_Due_Overlock__c": "string",
    "Days_prior_send_invoice__c": "string",
    "Days_until_second_late_fee__c": "string",
    "Desirable_New_City__c": "string",
    "Device_Quantity__c": "string",
    "Discuss_with_our_Product_Manager__c": "string",
    "Doc_electronic_sign__c": "string",
    "DocuSignStatus__c": "string",
    "Domain_Registration_Location__c": "string",
    "Emphasize_On_Website__c": "string",
    "Est_date_opening_facility__c": "string",
    "Existing_Corp_Code__c": "string",
    "Existing_SMS_account__c": "string",
    "ExpectedRevenue": "string",
    "Expected_FMS_start_date__c": "string",
    "Explain_Auction_process__c": "string",
    "FMS_converting_from__c": "string",
    "Faciilty_Legal_Entity_Name__c": "string",
    "Facility_Cancel_List__c": "string",
    "Facility_Email__c": "string",
    "Facility_ID__c": "string",
    "Facility_Legal_City_and_State__c": "string",
    "Facility_Legal_Mailing_Street_Address__c": "string",
    "Facility_Legal_Phone__c": "string",
    "Facility_Legal_Zip_Code__c": "string",
    "Facility_Phone_Number__c": "string",
    "Facility_State__c": "string",
    "Facility_clone__c": "string",
    "Federal_Tax_ID__c": "string",
    "First_Late_Fee__c": "string",
    "ForecastCategory": "string",
    "FormURL__c": "string",
    "Form_Record_Type__c": "string",
    "Full_Address__c": "string",
    "GTM_ID__c": "string",
    "Gate_Software_Provider__c": "string",
    "Gatefacility_access_hours__c": "string",
    "Gmail_for_GA__c": "string",
    "Google_Analytics__c": "string",
    "Google_My_Business_Listing_Question__c": "string",
    "Google_My_Business_Listing__c": "string",
    "Have_Logo_Facility__c": "string",
    "Historical_Data_Selection__c": "string",
    "Holiday_Hours__c": "string",
    "How_much_Security_Deposit__c": "string",
    "How_payments_applied__c": "string",
    "Id": "string",
    "If_Other_what_is_name_of_Gate_Provider__c": "string",
    "Insurance_Product_to_Cancel__c": "string",
    "Insuranceprotection_plan__c": "string",
    "Integration_Permission_True__c": "string",
    "Interest_Digital_Marketing__c": "string",
    "Interest_Sparefoot_facility__c": "string",
    "Interest_in_Data_Archive__c": "string",
    "Invoice_Method__c": "string",
    "IsDeleted": "string",
    "JotForm_Enter_Case_Number__c": "string",
    "Jotform_Submission_ID__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "License_Holder__c": "string",
    "Lien_Fee__c": "string",
    "Link_SLSE_Software__c": "string",
    "List_merch_items__c": "string",
    "Loc_Code_Preference__c": "string",
    "Location_Code__c": "string",
    "Location_Country__c": "string",
    "Lock_Cutting_Fee__c": "string",
    "Login_Credentials__c": "string",
    "Login_For_Domain__c": "string",
    "MS_Preapplication_JotForm__c": "string",
    "ManageCompany_Ownersame__c": "string",
    "Management_Software__c": "string",
    "Managesoftware_convert__c": "string",
    "Merch_Provider_Facility__c": "string",
    "MerchantId__c": "string",
    "Merchant_Timezone__c": "string",
    "Modules_Launching__c": "string",
    "NSF_Fee__c": "string",
    "Name": "string",
    "Name_Facility_Purchase__c": "string",
    "Name_POS_or_FMS_used__c": "string",
    "Nearby_Landmarks__c": "string",
    "Nearby_Neighborhoods__c": "string",
    "NewWebsite_ExistingDomain__c": "string",
    "New_Access_Provider__c": "string",
    "New_Insurance_Provider_moving_to__c": "string",
    "New_Software_Platform_moving_to__c": "string",
    "New_Software_Provider__c": "string",
    "New_Website_Platform_moving_to__c": "string",
    "New_Website_Provider__c": "string",
    "Offering_Tenant_Protection_Plans__c": "string",
    "Office_hours__c": "string",
    "Onethingwecouldhavedonedifferently__c": "string",
    "OpportunityId": "string",
    "OpportunityId__c": "string",
    "Other_CallPotential_Cancellation_Details__c": "string",
    "Other_Cancel_Access_Control__c": "string",
    "Other_Cancel_Insurance__c": "string",
    "Other_Cancel_Payment_Other_Product__c": "string",
    "Other_Cancel_Software_Product__c": "string",
    "Other_Cancel_SpareFoot__c": "string",
    "Other_Cancel_Website_Product__c": "string",
    "Other_Merch_Provider__c": "string",
    "Other_Pastdue_Event__c": "string",
    "Other_Software_Provider__c": "string",
    "Other_Website_Provider__c": "string",
    "Overlock_Fee__c": "string",
    "Overlock_PastDue_Unit__c": "string",
    "OwnerId": "string",
    "Payment_Cutoff_Days__c": "string",
    "Payment_or_Other_Product_to_Cancel__c": "string",
    "Place_Lien_Units__c": "string",
    "Please_Explain__c": "string",
    "Please_provide_the_name_of_the_purchaser__c": "string",
    "Preferred_Availability__c": "string",
    "Preferred_Contact_Method__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_User_Email__c": "string",
    "Primary_User__c": "string",
    "Probability": "string",
    "Promo_discount_offer__c": "string",
    "Prorate_Rent_moveout__c": "string",
    "Prorate_moveout_days__c": "string",
    "PurchFacility_SL_SE_ESS__c": "string",
    "Purchaser_Email__c": "string",
    "Purchaser_Phone__c": "string",
    "Reason_Cancel_Access_Control__c": "string",
    "Reason_Cancel_Insurance__c": "string",
    "Reason_Cancel_Payment_or_Other_Product__c": "string",
    "Reason_Cancel_Software_Product__c": "string",
    "Reason_Cancel_SpareFoot__c": "string",
    "Reason_Cancel_Website_Product__c": "string",
    "Reason_Opting_Out_of_Auto_Protect__c": "string",
    "Reasonforleaving__c": "string",
    "Recipient_Email__c": "string",
    "Recipient_Facility_Name__c": "string",
    "Recipient_Name__c": "string",
    "RecordTypeId": "string",
    "Recur_LateFee_OneTime__c": "string",
    "Related_Record_Created__c": "string",
    "Release_Date__c": "string",
    "Release_domain_name_website__c": "string",
    "Reservation_Fee__c": "string",
    "Retail_or_Merch_sale__c": "string",
    "SE_Company_UUID__c": "string",
    "SE_Facility_UUID__c": "string",
    "SLCorpCode__c": "string",
    "SLLocationCode__c": "string",
    "SSO_Interest_Level__c": "string",
    "Sales_Team_Member__c": "string",
    "Second_Late_Fee__c": "string",
    "Selling_or_Transfer_of_Ownership__c": "string",
    "Send_monthly_rent_invoices__c": "string",
    "Share_login_info__c": "string",
    "Signer_Date_of_Birth__c": "string",
    "Signer_Email__c": "string",
    "Signer_Home_Address__c": "string",
    "Signer_Name__c": "string",
    "Signer_Percentage_Business_Owned__c": "string",
    "Signer_Phone__c": "string",
    "Signer_Title__c": "string",
    "Software_Products_to_Cancel__c": "string",
    "Software_forwardfacility__c": "string",
    "Source__c": "string",
    "SpareFoot_Product_to_Cancel__c": "string",
    "StageName": "string",
    "Start_or_acquire_date_of_business__c": "string",
    "Stock_Ticker_Exchange__c": "string",
    "Subject__c": "string",
    "Submission_Date__c": "string",
    "Switching_Product__c": "string",
    "SystemModstamp": "string",
    "Tax_rate_on_rent__c": "string",
    "Temperature_Controlled_Units__c": "string",
    "Tenant_Insurance_Facility__c": "string",
    "Tenant_Insurance_Provider__c": "string",
    "Top_Amenity__c": "string",
    "Total_of_Locations__c": "string",
    "Tracked_Recorded_Line__c": "string",
    "Transferee_Company_Name__c": "string",
    "Transferee_Email__c": "string",
    "Transferee_Phone_Number__c": "string",
    "Transferee_Primary_Contact__c": "string",
    "Type_of_Business__c": "string",
    "UA_Code__c": "string",
    "UNPW_current_software__c": "string",
    "Units__c": "string",
    "Unmanned_Facility__c": "string",
    "Upload_Business_LicenseArticle_Incorp__c": "string",
    "Upload_Logo_Brand__c": "string",
    "Upload_Logo_Website__c": "string",
    "Upload_Signer_Driver_License__c": "string",
    "Upload_Void_Check_or_Bank_Detail__c": "string",
    "Upload_custom_document__c": "string",
    "Use_Gate_Software_Provider__c": "string",
    "Use_Sparefoot_facility__c": "string",
    "WebsiteProvider_Facility__c": "string",
    "Website_Photo_Facility__c": "string",
    "Website_Products_to_Cancel__c": "string",
    "Website_URL__c": "string",
    "What_is_your_domain__c": "string",
    "Which_PoS_or_FMS_will_you_be_using__c": "string",
    "Which_Storable_Software__c": "string",
    "Your_SL_CorpCode__c": "string",
    "of_Locations_Onboarding__c": "string",
    "storEDGE_integrate2__c": "string",
    "storEDGE_integrate__c": "string"
}
    • schema_name_id: 2060
    • schema_scan_id: 6402602
    • updated: 2024-01-11 09:09:00
    • created: 2023-08-16 11:16:37
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_form_response__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_form_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Access_Control_Competitor_moving_to__c`  string , `Access_Control_Products_to_Cancel__c`  string , `Anything_else_we_should_know__c`  string , `Switching_Product__c`  string , `Cancel_Single_Multiple_or_All_facility__c`  string , `Access_Hours__c`  string , `Accounting_method_use__c`  string , `Add_info_facility__c`  string , `Administrative_Fee__c`  string , `Already_have_domain__c`  string , `Amenities_Offered__c`  string , `Contact_Email__c`  string , `Contact_Name__c`  string , `Contact_Phone__c`  string , `Created_Case__c`  string , `Anticipated_Monthly_Vol_per_month__c`  string , `Facility_Cancel_List__c`  string , `Assist_Google_My_Business__c`  string , `Form_Record_Type__c`  string , `Insurance_Product_to_Cancel__c`  string , `New_Insurance_Provider_moving_to__c`  string , `New_Software_Platform_moving_to__c`  string , `New_Website_Platform_moving_to__c`  string , `Onethingwecouldhavedonedifferently__c`  string , `Other_Cancel_Access_Control__c`  string , `Other_Cancel_Insurance__c`  string , `Other_Cancel_Payment_Other_Product__c`  string , `Other_Cancel_Software_Product__c`  string , `Other_Cancel_SpareFoot__c`  string , `Other_Cancel_Website_Product__c`  string , `Payment_or_Other_Product_to_Cancel__c`  string , `Please_provide_the_name_of_the_purchaser__c`  string , `Reason_Cancel_Access_Control__c`  string , `Reason_Cancel_Insurance__c`  string , `Reason_Cancel_Payment_or_Other_Product__c`  string , `Reason_Cancel_Software_Product__c`  string , `Reason_Cancel_SpareFoot__c`  string , `Reason_Cancel_Website_Product__c`  string , `Reasonforleaving__c`  string , `Related_Record_Created__c`  string , `Auction_Units__c`  string , `Software_Products_to_Cancel__c`  string , `Source__c`  string , `SpareFoot_Product_to_Cancel__c`  string , `Subject__c`  string , `Website_Products_to_Cancel__c`  string , `Discuss_with_our_Product_Manager__c`  string , `Interest_in_Data_Archive__c`  string , `Selling_or_Transfer_of_Ownership__c`  string , `Website_URL__c`  string , `Jotform_Submission_ID__c`  string , `DocuSignStatus__c`  string , `CreditCardNumber__c`  string , `CreditCardExpiration__c`  string , `CreditCardNetwork__c`  string , `CreditCardName__c`  string , `BillingName__c`  string , `BillingCity__c`  string , `BillingCountry__c`  string , `BillingPostalCode__c`  string , `BillingRegion__c`  string , `BillingStreet__c`  string , `BillingPaymentMethod__c`  string , `OpportunityId__c`  string , `ACHAccountNumber__c`  string , `ACHRoutingNumber__c`  string , `ACHInstitutionCity__c`  string , `ACHInstitutionName__c`  string , `ACHInstitutionPostalCode__c`  string , `ACHInstitutionRegion__c`  string , `FormURL__c`  string , `Billing_Settings__c`  string , `Device_Quantity__c`  string , `Facility_ID__c`  string , `Full_Address__c`  string , `MerchantId__c`  string , `Merchant_Timezone__c`  string , `Charge_Second_Late_Fee__c`  string , `Charge_Security_Deposit__c`  string , `Contact_Person_Email__c`  string , `Contact_Person_Name__c`  string , `Contact_Person_Phone__c`  string , `Contact_Person_Title__c`  string , `Custom_document_to_use__c`  string , `DBA_City_and_State__c`  string , `DBA_Name__c`  string , `DBA_Phone__c`  string , `DBA_Physical_Address__c`  string , `DBA_Zip_Code__c`  string , `Date_start_software__c`  string , `Day_Past_Due_FirstFee__c`  string , `Day_Past_Due_Notice__c`  string , `Days_Past_Due_Lien__c`  string , `Days_Past_Due_Locktenant__c`  string , `Days_Past_Due_Overlock__c`  string , `Days_prior_send_invoice__c`  string , `Desirable_New_City__c`  string , `Doc_electronic_sign__c`  string , `Domain_Registration_Location__c`  string , `Emphasize_On_Website__c`  string , `Est_date_opening_facility__c`  string , `Explain_Auction_process__c`  string , `FMS_converting_from__c`  string , `Faciilty_Legal_Entity_Name__c`  string , `Facility_Email__c`  string , `Facility_Legal_City_and_State__c`  string , `Facility_Legal_Mailing_Street_Address__c`  string , `Facility_Legal_Phone__c`  string , `Facility_Legal_Zip_Code__c`  string , `Facility_State__c`  string , `Federal_Tax_ID__c`  string , `First_Late_Fee__c`  string , `Gate_Software_Provider__c`  string , `Gatefacility_access_hours__c`  string , `Google_Analytics__c`  string , `Google_My_Business_Listing_Question__c`  string , `Google_My_Business_Listing__c`  string , `Have_Logo_Facility__c`  string , `Holiday_Hours__c`  string , `How_much_Security_Deposit__c`  string , `How_payments_applied__c`  string , `Insuranceprotection_plan__c`  string , `JotForm_Enter_Case_Number__c`  string , `Lien_Fee__c`  string , `Link_SLSE_Software__c`  string , `List_merch_items__c`  string , `Lock_Cutting_Fee__c`  string , `Login_Credentials__c`  string , `Login_For_Domain__c`  string , `MS_Preapplication_JotForm__c`  string , `NSF_Fee__c`  string , `Name_POS_or_FMS_used__c`  string , `Nearby_Landmarks__c`  string , `Nearby_Neighborhoods__c`  string , `Office_hours__c`  string , `Other_Pastdue_Event__c`  string , `Overlock_Fee__c`  string , `Overlock_PastDue_Unit__c`  string , `Place_Lien_Units__c`  string , `Primary_User_Email__c`  string , `Primary_User__c`  string , `Promo_discount_offer__c`  string , `Prorate_Rent_moveout__c`  string , `Prorate_moveout_days__c`  string , `Recur_LateFee_OneTime__c`  string , `Reservation_Fee__c`  string , `Retail_or_Merch_sale__c`  string , `Second_Late_Fee__c`  string , `Send_monthly_rent_invoices__c`  string , `Share_login_info__c`  string , `Signer_Date_of_Birth__c`  string , `Signer_Email__c`  string , `Signer_Home_Address__c`  string , `Signer_Name__c`  string , `Signer_Percentage_Business_Owned__c`  string , `Signer_Phone__c`  string , `Signer_Title__c`  string , `Start_or_acquire_date_of_business__c`  string , `Tax_rate_on_rent__c`  string , `Temperature_Controlled_Units__c`  string , `Tenant_Insurance_Provider__c`  string , `Top_Amenity__c`  string , `UA_Code__c`  string , `UNPW_current_software__c`  string , `Unmanned_Facility__c`  string , `Upload_Business_LicenseArticle_Incorp__c`  string , `Upload_Logo_Brand__c`  string , `Upload_Logo_Website__c`  string , `Upload_Signer_Driver_License__c`  string , `Upload_Void_Check_or_Bank_Detail__c`  string , `Upload_custom_document__c`  string , `Website_Photo_Facility__c`  string , `Which_Storable_Software__c`  string , `storEDGE_integrate__c`  string , `Purchaser_Phone__c`  string , `Purchaser_Email__c`  string , `storEDGE_integrate2__c`  string , `ACS_quotehardware__c`  string , `Access_after_Transfer__c`  string , `Access_point_restrict_keypad__c`  string , `Accesspointrestrict__c`  string , `Additional_Comment__c`  string , `Any_Portable_Units__c`  string , `Archive_Option_email_address__c`  string , `Clone_softwaresetting__c`  string , `Clone_website_namefacility__c`  string , `Construction_openbusiness__c`  string , `Continue_software_service__c`  string , `Convertfromspreadsheet__c`  string , `Current_Software_Provider__c`  string , `Date_Signed__c`  string , `Date_to_be_released__c`  string , `Existing_Corp_Code__c`  string , `Facility_clone__c`  string , `Historical_Data_Selection__c`  string , `Interest_Digital_Marketing__c`  string , `Interest_Sparefoot_facility__c`  string , `License_Holder__c`  string , `Loc_Code_Preference__c`  string , `Location_Code__c`  string , `ManageCompany_Ownersame__c`  string , `Managesoftware_convert__c`  string , `Merch_Provider_Facility__c`  string , `Name_Facility_Purchase__c`  string , `NewWebsite_ExistingDomain__c`  string , `Other_Merch_Provider__c`  string , `Other_Software_Provider__c`  string , `Other_Website_Provider__c`  string , `PurchFacility_SL_SE_ESS__c`  string , `Recipient_Email__c`  string , `Recipient_Facility_Name__c`  string , `Recipient_Name__c`  string , `Release_Date__c`  string , `Release_domain_name_website__c`  string , `SLCorpCode__c`  string , `SLLocationCode__c`  string , `Software_forwardfacility__c`  string , `Tenant_Insurance_Facility__c`  string , `Transferee_Company_Name__c`  string , `Transferee_Email__c`  string , `Transferee_Phone_Number__c`  string , `Transferee_Primary_Contact__c`  string , `Units__c`  string , `Use_Gate_Software_Provider__c`  string , `Use_Sparefoot_facility__c`  string , `WebsiteProvider_Facility__c`  string , `Your_SL_CorpCode__c`  string , `New_Access_Provider__c`  string , `New_Website_Provider__c`  string , `New_Software_Provider__c`  string , `Auction_Fee_Amount__c`  string , `Days_until_second_late_fee__c`  string , `Offering_Tenant_Protection_Plans__c`  string , `Invoice_Method__c`  string , `Addtl_info_or_Qs_on_MS_account__c`  string , `Existing_SMS_account__c`  string , `Expected_FMS_start_date__c`  string , `Type_of_Business__c`  string , `Which_PoS_or_FMS_will_you_be_using__c`  string , `Please_Explain__c`  string , `Reason_Opting_Out_of_Auto_Protect__c`  string , `Preferred_Availability__c`  string , `SSO_Interest_Level__c`  string , `Preferred_Contact_Method__c`  string , `CreditCardCVV__c`  string , `GTM_ID__c`  string , `If_Other_what_is_name_of_Gate_Provider__c`  string , `What_is_your_domain__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-dev/raw/form_response__cs/2023-08-16/1692202316'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_form_response__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/form_response__cs/2023-08-16/1692202316
    • id: 4697510
    • processed: 1
    • raw_data: 
      {
    "ACHAccountNumber__c": 77,
    "ACHInstitutionCity__c": 79,
    "ACHInstitutionName__c": 80,
    "ACHInstitutionPostalCode__c": 81,
    "ACHInstitutionRegion__c": 82,
    "ACHRoutingNumber__c": 78,
    "ACS_quotehardware__c": 190,
    "Access_Control_Competitor_moving_to__c": 13,
    "Access_Control_Products_to_Cancel__c": 14,
    "Access_Hours__c": 18,
    "Access_after_Transfer__c": 191,
    "Access_point_restrict_keypad__c": 192,
    "Accesspointrestrict__c": 193,
    "Accounting_method_use__c": 19,
    "Add_info_facility__c": 20,
    "Additional_Comment__c": 194,
    "Addtl_info_or_Qs_on_MS_account__c": 247,
    "Administrative_Fee__c": 21,
    "Already_have_domain__c": 22,
    "Amenities_Offered__c": 23,
    "Anticipated_Monthly_Vol_per_month__c": 28,
    "Any_Portable_Units__c": 195,
    "Anything_else_we_should_know__c": 15,
    "Archive_Option_email_address__c": 196,
    "Assist_Google_My_Business__c": 30,
    "Auction_Fee_Amount__c": 243,
    "Auction_Units__c": 53,
    "BillingCity__c": 70,
    "BillingCountry__c": 71,
    "BillingName__c": 69,
    "BillingPaymentMethod__c": 75,
    "BillingPostalCode__c": 72,
    "BillingRegion__c": 73,
    "BillingStreet__c": 74,
    "Billing_Settings__c": 84,
    "Cancel_Single_Multiple_or_All_facility__c": 17,
    "Charge_Second_Late_Fee__c": 90,
    "Charge_Security_Deposit__c": 91,
    "Clone_softwaresetting__c": 197,
    "Clone_website_namefacility__c": 198,
    "ConnectionReceivedId": 11,
    "ConnectionSentId": 12,
    "Construction_openbusiness__c": 199,
    "Contact_Email__c": 24,
    "Contact_Name__c": 25,
    "Contact_Person_Email__c": 92,
    "Contact_Person_Name__c": 93,
    "Contact_Person_Phone__c": 94,
    "Contact_Person_Title__c": 95,
    "Contact_Phone__c": 26,
    "Continue_software_service__c": 200,
    "Convertfromspreadsheet__c": 201,
    "CreatedById": 7,
    "CreatedDate": 6,
    "Created_Case__c": 27,
    "CreditCardCVV__c": 257,
    "CreditCardExpiration__c": 66,
    "CreditCardName__c": 68,
    "CreditCardNetwork__c": 67,
    "CreditCardNumber__c": 65,
    "CurrencyIsoCode": 4,
    "Current_Software_Provider__c": 202,
    "Custom_document_to_use__c": 96,
    "DBA_City_and_State__c": 97,
    "DBA_Name__c": 98,
    "DBA_Phone__c": 99,
    "DBA_Physical_Address__c": 100,
    "DBA_Zip_Code__c": 101,
    "Date_Signed__c": 203,
    "Date_start_software__c": 102,
    "Date_to_be_released__c": 204,
    "Day_Past_Due_FirstFee__c": 103,
    "Day_Past_Due_Notice__c": 104,
    "Days_Past_Due_Lien__c": 105,
    "Days_Past_Due_Locktenant__c": 106,
    "Days_Past_Due_Overlock__c": 107,
    "Days_prior_send_invoice__c": 108,
    "Days_until_second_late_fee__c": 244,
    "Desirable_New_City__c": 109,
    "Device_Quantity__c": 85,
    "Discuss_with_our_Product_Manager__c": 59,
    "Doc_electronic_sign__c": 110,
    "DocuSignStatus__c": 64,
    "Domain_Registration_Location__c": 111,
    "Emphasize_On_Website__c": 112,
    "Est_date_opening_facility__c": 113,
    "Existing_Corp_Code__c": 205,
    "Existing_SMS_account__c": 248,
    "Expected_FMS_start_date__c": 249,
    "Explain_Auction_process__c": 114,
    "FMS_converting_from__c": 115,
    "Faciilty_Legal_Entity_Name__c": 116,
    "Facility_Cancel_List__c": 29,
    "Facility_Email__c": 117,
    "Facility_ID__c": 86,
    "Facility_Legal_City_and_State__c": 118,
    "Facility_Legal_Mailing_Street_Address__c": 119,
    "Facility_Legal_Phone__c": 120,
    "Facility_Legal_Zip_Code__c": 121,
    "Facility_State__c": 122,
    "Facility_clone__c": 206,
    "Federal_Tax_ID__c": 123,
    "First_Late_Fee__c": 124,
    "FormURL__c": 83,
    "Form_Record_Type__c": 31,
    "Full_Address__c": 87,
    "GTM_ID__c": 258,
    "Gate_Software_Provider__c": 125,
    "Gatefacility_access_hours__c": 126,
    "Google_Analytics__c": 127,
    "Google_My_Business_Listing_Question__c": 128,
    "Google_My_Business_Listing__c": 129,
    "Have_Logo_Facility__c": 130,
    "Historical_Data_Selection__c": 207,
    "Holiday_Hours__c": 131,
    "How_much_Security_Deposit__c": 132,
    "How_payments_applied__c": 133,
    "Id": 0,
    "If_Other_what_is_name_of_Gate_Provider__c": 259,
    "Insurance_Product_to_Cancel__c": 32,
    "Insuranceprotection_plan__c": 134,
    "Interest_Digital_Marketing__c": 208,
    "Interest_Sparefoot_facility__c": 209,
    "Interest_in_Data_Archive__c": 60,
    "Invoice_Method__c": 246,
    "IsDeleted": 2,
    "JotForm_Enter_Case_Number__c": 135,
    "Jotform_Submission_ID__c": 63,
    "LastModifiedById": 9,
    "LastModifiedDate": 8,
    "License_Holder__c": 210,
    "Lien_Fee__c": 136,
    "Link_SLSE_Software__c": 137,
    "List_merch_items__c": 138,
    "Loc_Code_Preference__c": 211,
    "Location_Code__c": 212,
    "Lock_Cutting_Fee__c": 139,
    "Login_Credentials__c": 140,
    "Login_For_Domain__c": 141,
    "MS_Preapplication_JotForm__c": 142,
    "ManageCompany_Ownersame__c": 213,
    "Managesoftware_convert__c": 214,
    "Merch_Provider_Facility__c": 215,
    "MerchantId__c": 88,
    "Merchant_Timezone__c": 89,
    "NSF_Fee__c": 143,
    "Name": 3,
    "Name_Facility_Purchase__c": 216,
    "Name_POS_or_FMS_used__c": 144,
    "Nearby_Landmarks__c": 145,
    "Nearby_Neighborhoods__c": 146,
    "NewWebsite_ExistingDomain__c": 217,
    "New_Access_Provider__c": 240,
    "New_Insurance_Provider_moving_to__c": 33,
    "New_Software_Platform_moving_to__c": 34,
    "New_Software_Provider__c": 242,
    "New_Website_Platform_moving_to__c": 35,
    "New_Website_Provider__c": 241,
    "Offering_Tenant_Protection_Plans__c": 245,
    "Office_hours__c": 147,
    "Onethingwecouldhavedonedifferently__c": 36,
    "OpportunityId__c": 76,
    "Other_Cancel_Access_Control__c": 37,
    "Other_Cancel_Insurance__c": 38,
    "Other_Cancel_Payment_Other_Product__c": 39,
    "Other_Cancel_Software_Product__c": 40,
    "Other_Cancel_SpareFoot__c": 41,
    "Other_Cancel_Website_Product__c": 42,
    "Other_Merch_Provider__c": 218,
    "Other_Pastdue_Event__c": 148,
    "Other_Software_Provider__c": 219,
    "Other_Website_Provider__c": 220,
    "Overlock_Fee__c": 149,
    "Overlock_PastDue_Unit__c": 150,
    "OwnerId": 1,
    "Payment_or_Other_Product_to_Cancel__c": 43,
    "Place_Lien_Units__c": 151,
    "Please_Explain__c": 252,
    "Please_provide_the_name_of_the_purchaser__c": 44,
    "Preferred_Availability__c": 254,
    "Preferred_Contact_Method__c": 256,
    "Primary_User_Email__c": 152,
    "Primary_User__c": 153,
    "Promo_discount_offer__c": 154,
    "Prorate_Rent_moveout__c": 155,
    "Prorate_moveout_days__c": 156,
    "PurchFacility_SL_SE_ESS__c": 221,
    "Purchaser_Email__c": 188,
    "Purchaser_Phone__c": 187,
    "Reason_Cancel_Access_Control__c": 45,
    "Reason_Cancel_Insurance__c": 46,
    "Reason_Cancel_Payment_or_Other_Product__c": 47,
    "Reason_Cancel_Software_Product__c": 48,
    "Reason_Cancel_SpareFoot__c": 49,
    "Reason_Cancel_Website_Product__c": 50,
    "Reason_Opting_Out_of_Auto_Protect__c": 253,
    "Reasonforleaving__c": 51,
    "Recipient_Email__c": 222,
    "Recipient_Facility_Name__c": 223,
    "Recipient_Name__c": 224,
    "RecordTypeId": 5,
    "Recur_LateFee_OneTime__c": 157,
    "Related_Record_Created__c": 52,
    "Release_Date__c": 225,
    "Release_domain_name_website__c": 226,
    "Reservation_Fee__c": 158,
    "Retail_or_Merch_sale__c": 159,
    "SLCorpCode__c": 227,
    "SLLocationCode__c": 228,
    "SSO_Interest_Level__c": 255,
    "Second_Late_Fee__c": 160,
    "Selling_or_Transfer_of_Ownership__c": 61,
    "Send_monthly_rent_invoices__c": 161,
    "Share_login_info__c": 162,
    "Signer_Date_of_Birth__c": 163,
    "Signer_Email__c": 164,
    "Signer_Home_Address__c": 165,
    "Signer_Name__c": 166,
    "Signer_Percentage_Business_Owned__c": 167,
    "Signer_Phone__c": 168,
    "Signer_Title__c": 169,
    "Software_Products_to_Cancel__c": 54,
    "Software_forwardfacility__c": 229,
    "Source__c": 55,
    "SpareFoot_Product_to_Cancel__c": 56,
    "Start_or_acquire_date_of_business__c": 170,
    "Subject__c": 57,
    "Switching_Product__c": 16,
    "SystemModstamp": 10,
    "Tax_rate_on_rent__c": 171,
    "Temperature_Controlled_Units__c": 172,
    "Tenant_Insurance_Facility__c": 230,
    "Tenant_Insurance_Provider__c": 173,
    "Top_Amenity__c": 174,
    "Transferee_Company_Name__c": 231,
    "Transferee_Email__c": 232,
    "Transferee_Phone_Number__c": 233,
    "Transferee_Primary_Contact__c": 234,
    "Type_of_Business__c": 250,
    "UA_Code__c": 175,
    "UNPW_current_software__c": 176,
    "Units__c": 235,
    "Unmanned_Facility__c": 177,
    "Upload_Business_LicenseArticle_Incorp__c": 178,
    "Upload_Logo_Brand__c": 179,
    "Upload_Logo_Website__c": 180,
    "Upload_Signer_Driver_License__c": 181,
    "Upload_Void_Check_or_Bank_Detail__c": 182,
    "Upload_custom_document__c": 183,
    "Use_Gate_Software_Provider__c": 236,
    "Use_Sparefoot_facility__c": 237,
    "WebsiteProvider_Facility__c": 238,
    "Website_Photo_Facility__c": 184,
    "Website_Products_to_Cancel__c": 58,
    "Website_URL__c": 62,
    "What_is_your_domain__c": 260,
    "Which_PoS_or_FMS_will_you_be_using__c": 251,
    "Which_Storable_Software__c": 185,
    "Your_SL_CorpCode__c": 239,
    "storEDGE_integrate2__c": 189,
    "storEDGE_integrate__c": 186
}
    • schema_attributes: 
      {
    "ACHAccountNumber__c": "string",
    "ACHInstitutionCity__c": "string",
    "ACHInstitutionName__c": "string",
    "ACHInstitutionPostalCode__c": "string",
    "ACHInstitutionRegion__c": "string",
    "ACHRoutingNumber__c": "string",
    "ACS_quotehardware__c": "string",
    "Access_Control_Competitor_moving_to__c": "string",
    "Access_Control_Products_to_Cancel__c": "string",
    "Access_Hours__c": "string",
    "Access_after_Transfer__c": "string",
    "Access_point_restrict_keypad__c": "string",
    "Accesspointrestrict__c": "string",
    "Accounting_method_use__c": "string",
    "Add_info_facility__c": "string",
    "Additional_Comment__c": "string",
    "Addtl_info_or_Qs_on_MS_account__c": "string",
    "Administrative_Fee__c": "string",
    "Already_have_domain__c": "string",
    "Amenities_Offered__c": "string",
    "Amount": "string",
    "Anticipated_Monthly_Vol_per_month__c": "string",
    "Any_Portable_Units__c": "string",
    "Anything_else_we_should_know__c": "string",
    "Archive_Option_email_address__c": "string",
    "Assist_Google_My_Business__c": "string",
    "Auction_Fee_Amount__c": "string",
    "Auction_Units__c": "string",
    "BillingCity__c": "string",
    "BillingCountry__c": "string",
    "BillingName__c": "string",
    "BillingPaymentMethod__c": "string",
    "BillingPostalCode__c": "string",
    "BillingRegion__c": "string",
    "BillingStreet__c": "string",
    "Billing_Settings__c": "string",
    "Cancel_Single_Multiple_or_All_facility__c": "string",
    "Charge_Second_Late_Fee__c": "string",
    "Charge_Security_Deposit__c": "string",
    "Clone_softwaresetting__c": "string",
    "Clone_website_namefacility__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Construction_openbusiness__c": "string",
    "Contact_Email__c": "string",
    "Contact_Name__c": "string",
    "Contact_Person_Email__c": "string",
    "Contact_Person_Name__c": "string",
    "Contact_Person_Phone__c": "string",
    "Contact_Person_Title__c": "string",
    "Contact_Phone__c": "string",
    "Continue_software_service__c": "string",
    "Convertfromspreadsheet__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_Case__c": "string",
    "CreditCardCVV__c": "string",
    "CreditCardExpiration__c": "string",
    "CreditCardName__c": "string",
    "CreditCardNetwork__c": "string",
    "CreditCardNumber__c": "string",
    "CurrencyIsoCode": "string",
    "Current_Software_Provider__c": "string",
    "Custom_document_to_use__c": "string",
    "DBA_City_and_State__c": "string",
    "DBA_Name__c": "string",
    "DBA_Phone__c": "string",
    "DBA_Physical_Address__c": "string",
    "DBA_Zip_Code__c": "string",
    "Date_Signed__c": "string",
    "Date_start_software__c": "string",
    "Date_to_be_released__c": "string",
    "Day_Past_Due_FirstFee__c": "string",
    "Day_Past_Due_Notice__c": "string",
    "Days_Past_Due_Lien__c": "string",
    "Days_Past_Due_Locktenant__c": "string",
    "Days_Past_Due_Overlock__c": "string",
    "Days_prior_send_invoice__c": "string",
    "Days_until_second_late_fee__c": "string",
    "Desirable_New_City__c": "string",
    "Device_Quantity__c": "string",
    "Discuss_with_our_Product_Manager__c": "string",
    "Doc_electronic_sign__c": "string",
    "DocuSignStatus__c": "string",
    "Domain_Registration_Location__c": "string",
    "Emphasize_On_Website__c": "string",
    "Est_date_opening_facility__c": "string",
    "Existing_Corp_Code__c": "string",
    "Existing_SMS_account__c": "string",
    "ExpectedRevenue": "string",
    "Expected_FMS_start_date__c": "string",
    "Explain_Auction_process__c": "string",
    "FMS_converting_from__c": "string",
    "Faciilty_Legal_Entity_Name__c": "string",
    "Facility_Cancel_List__c": "string",
    "Facility_Email__c": "string",
    "Facility_ID__c": "string",
    "Facility_Legal_City_and_State__c": "string",
    "Facility_Legal_Mailing_Street_Address__c": "string",
    "Facility_Legal_Phone__c": "string",
    "Facility_Legal_Zip_Code__c": "string",
    "Facility_State__c": "string",
    "Facility_clone__c": "string",
    "Federal_Tax_ID__c": "string",
    "First_Late_Fee__c": "string",
    "ForecastCategory": "string",
    "FormURL__c": "string",
    "Form_Record_Type__c": "string",
    "Full_Address__c": "string",
    "GTM_ID__c": "string",
    "Gate_Software_Provider__c": "string",
    "Gatefacility_access_hours__c": "string",
    "Google_Analytics__c": "string",
    "Google_My_Business_Listing_Question__c": "string",
    "Google_My_Business_Listing__c": "string",
    "Have_Logo_Facility__c": "string",
    "Historical_Data_Selection__c": "string",
    "Holiday_Hours__c": "string",
    "How_much_Security_Deposit__c": "string",
    "How_payments_applied__c": "string",
    "Id": "string",
    "If_Other_what_is_name_of_Gate_Provider__c": "string",
    "Insurance_Product_to_Cancel__c": "string",
    "Insuranceprotection_plan__c": "string",
    "Interest_Digital_Marketing__c": "string",
    "Interest_Sparefoot_facility__c": "string",
    "Interest_in_Data_Archive__c": "string",
    "Invoice_Method__c": "string",
    "IsDeleted": "string",
    "JotForm_Enter_Case_Number__c": "string",
    "Jotform_Submission_ID__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "License_Holder__c": "string",
    "Lien_Fee__c": "string",
    "Link_SLSE_Software__c": "string",
    "List_merch_items__c": "string",
    "Loc_Code_Preference__c": "string",
    "Location_Code__c": "string",
    "Lock_Cutting_Fee__c": "string",
    "Login_Credentials__c": "string",
    "Login_For_Domain__c": "string",
    "MS_Preapplication_JotForm__c": "string",
    "ManageCompany_Ownersame__c": "string",
    "Managesoftware_convert__c": "string",
    "Merch_Provider_Facility__c": "string",
    "MerchantId__c": "string",
    "Merchant_Timezone__c": "string",
    "NSF_Fee__c": "string",
    "Name": "string",
    "Name_Facility_Purchase__c": "string",
    "Name_POS_or_FMS_used__c": "string",
    "Nearby_Landmarks__c": "string",
    "Nearby_Neighborhoods__c": "string",
    "NewWebsite_ExistingDomain__c": "string",
    "New_Access_Provider__c": "string",
    "New_Insurance_Provider_moving_to__c": "string",
    "New_Software_Platform_moving_to__c": "string",
    "New_Software_Provider__c": "string",
    "New_Website_Platform_moving_to__c": "string",
    "New_Website_Provider__c": "string",
    "Offering_Tenant_Protection_Plans__c": "string",
    "Office_hours__c": "string",
    "Onethingwecouldhavedonedifferently__c": "string",
    "OpportunityId": "string",
    "OpportunityId__c": "string",
    "Other_Cancel_Access_Control__c": "string",
    "Other_Cancel_Insurance__c": "string",
    "Other_Cancel_Payment_Other_Product__c": "string",
    "Other_Cancel_Software_Product__c": "string",
    "Other_Cancel_SpareFoot__c": "string",
    "Other_Cancel_Website_Product__c": "string",
    "Other_Merch_Provider__c": "string",
    "Other_Pastdue_Event__c": "string",
    "Other_Software_Provider__c": "string",
    "Other_Website_Provider__c": "string",
    "Overlock_Fee__c": "string",
    "Overlock_PastDue_Unit__c": "string",
    "OwnerId": "string",
    "Payment_or_Other_Product_to_Cancel__c": "string",
    "Place_Lien_Units__c": "string",
    "Please_Explain__c": "string",
    "Please_provide_the_name_of_the_purchaser__c": "string",
    "Preferred_Availability__c": "string",
    "Preferred_Contact_Method__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_User_Email__c": "string",
    "Primary_User__c": "string",
    "Probability": "string",
    "Promo_discount_offer__c": "string",
    "Prorate_Rent_moveout__c": "string",
    "Prorate_moveout_days__c": "string",
    "PurchFacility_SL_SE_ESS__c": "string",
    "Purchaser_Email__c": "string",
    "Purchaser_Phone__c": "string",
    "Reason_Cancel_Access_Control__c": "string",
    "Reason_Cancel_Insurance__c": "string",
    "Reason_Cancel_Payment_or_Other_Product__c": "string",
    "Reason_Cancel_Software_Product__c": "string",
    "Reason_Cancel_SpareFoot__c": "string",
    "Reason_Cancel_Website_Product__c": "string",
    "Reason_Opting_Out_of_Auto_Protect__c": "string",
    "Reasonforleaving__c": "string",
    "Recipient_Email__c": "string",
    "Recipient_Facility_Name__c": "string",
    "Recipient_Name__c": "string",
    "RecordTypeId": "string",
    "Recur_LateFee_OneTime__c": "string",
    "Related_Record_Created__c": "string",
    "Release_Date__c": "string",
    "Release_domain_name_website__c": "string",
    "Reservation_Fee__c": "string",
    "Retail_or_Merch_sale__c": "string",
    "SLCorpCode__c": "string",
    "SLLocationCode__c": "string",
    "SSO_Interest_Level__c": "string",
    "Second_Late_Fee__c": "string",
    "Selling_or_Transfer_of_Ownership__c": "string",
    "Send_monthly_rent_invoices__c": "string",
    "Share_login_info__c": "string",
    "Signer_Date_of_Birth__c": "string",
    "Signer_Email__c": "string",
    "Signer_Home_Address__c": "string",
    "Signer_Name__c": "string",
    "Signer_Percentage_Business_Owned__c": "string",
    "Signer_Phone__c": "string",
    "Signer_Title__c": "string",
    "Software_Products_to_Cancel__c": "string",
    "Software_forwardfacility__c": "string",
    "Source__c": "string",
    "SpareFoot_Product_to_Cancel__c": "string",
    "StageName": "string",
    "Start_or_acquire_date_of_business__c": "string",
    "Subject__c": "string",
    "Switching_Product__c": "string",
    "SystemModstamp": "string",
    "Tax_rate_on_rent__c": "string",
    "Temperature_Controlled_Units__c": "string",
    "Tenant_Insurance_Facility__c": "string",
    "Tenant_Insurance_Provider__c": "string",
    "Top_Amenity__c": "string",
    "Transferee_Company_Name__c": "string",
    "Transferee_Email__c": "string",
    "Transferee_Phone_Number__c": "string",
    "Transferee_Primary_Contact__c": "string",
    "Type_of_Business__c": "string",
    "UA_Code__c": "string",
    "UNPW_current_software__c": "string",
    "Units__c": "string",
    "Unmanned_Facility__c": "string",
    "Upload_Business_LicenseArticle_Incorp__c": "string",
    "Upload_Logo_Brand__c": "string",
    "Upload_Logo_Website__c": "string",
    "Upload_Signer_Driver_License__c": "string",
    "Upload_Void_Check_or_Bank_Detail__c": "string",
    "Upload_custom_document__c": "string",
    "Use_Gate_Software_Provider__c": "string",
    "Use_Sparefoot_facility__c": "string",
    "WebsiteProvider_Facility__c": "string",
    "Website_Photo_Facility__c": "string",
    "Website_Products_to_Cancel__c": "string",
    "Website_URL__c": "string",
    "What_is_your_domain__c": "string",
    "Which_PoS_or_FMS_will_you_be_using__c": "string",
    "Which_Storable_Software__c": "string",
    "Your_SL_CorpCode__c": "string",
    "storEDGE_integrate2__c": "string",
    "storEDGE_integrate__c": "string"
}
    • schema_name_id: 2060
    • schema_scan_id: 6251516
    • updated: 2023-08-16 11:16:48
    • created: 2023-08-16 10:27:30
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_form_response__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_form_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Access_Control_Competitor_moving_to__c`  string , `Access_Control_Products_to_Cancel__c`  string , `Anything_else_we_should_know__c`  string , `Switching_Product__c`  string , `Cancel_Single_Multiple_or_All_facility__c`  string , `Access_Hours__c`  string , `Accounting_method_use__c`  string , `Add_info_facility__c`  string , `Administrative_Fee__c`  string , `Already_have_domain__c`  string , `Amenities_Offered__c`  string , `Contact_Email__c`  string , `Contact_Name__c`  string , `Contact_Phone__c`  string , `Created_Case__c`  string , `Anticipated_Monthly_Vol_per_month__c`  string , `Facility_Cancel_List__c`  string , `Assist_Google_My_Business__c`  string , `Form_Record_Type__c`  string , `Insurance_Product_to_Cancel__c`  string , `New_Insurance_Provider_moving_to__c`  string , `New_Software_Platform_moving_to__c`  string , `New_Website_Platform_moving_to__c`  string , `Onethingwecouldhavedonedifferently__c`  string , `Other_Cancel_Access_Control__c`  string , `Other_Cancel_Insurance__c`  string , `Other_Cancel_Payment_Other_Product__c`  string , `Other_Cancel_Software_Product__c`  string , `Other_Cancel_SpareFoot__c`  string , `Other_Cancel_Website_Product__c`  string , `Payment_or_Other_Product_to_Cancel__c`  string , `Please_provide_the_name_of_the_purchaser__c`  string , `Reason_Cancel_Access_Control__c`  string , `Reason_Cancel_Insurance__c`  string , `Reason_Cancel_Payment_or_Other_Product__c`  string , `Reason_Cancel_Software_Product__c`  string , `Reason_Cancel_SpareFoot__c`  string , `Reason_Cancel_Website_Product__c`  string , `Reasonforleaving__c`  string , `Related_Record_Created__c`  string , `Auction_Units__c`  string , `Software_Products_to_Cancel__c`  string , `Source__c`  string , `SpareFoot_Product_to_Cancel__c`  string , `Subject__c`  string , `Website_Products_to_Cancel__c`  string , `Discuss_with_our_Product_Manager__c`  string , `Interest_in_Data_Archive__c`  string , `Selling_or_Transfer_of_Ownership__c`  string , `Website_URL__c`  string , `Jotform_Submission_ID__c`  string , `DocuSignStatus__c`  string , `CreditCardNumber__c`  string , `CreditCardExpiration__c`  string , `CreditCardNetwork__c`  string , `CreditCardName__c`  string , `BillingName__c`  string , `BillingCity__c`  string , `BillingCountry__c`  string , `BillingPostalCode__c`  string , `BillingRegion__c`  string , `BillingStreet__c`  string , `BillingPaymentMethod__c`  string , `OpportunityId__c`  string , `ACHAccountNumber__c`  string , `ACHRoutingNumber__c`  string , `ACHInstitutionCity__c`  string , `ACHInstitutionName__c`  string , `ACHInstitutionPostalCode__c`  string , `ACHInstitutionRegion__c`  string , `FormURL__c`  string , `Billing_Settings__c`  string , `Device_Quantity__c`  string , `Facility_ID__c`  string , `Full_Address__c`  string , `MerchantId__c`  string , `Merchant_Timezone__c`  string , `Charge_Second_Late_Fee__c`  string , `Charge_Security_Deposit__c`  string , `Contact_Person_Email__c`  string , `Contact_Person_Name__c`  string , `Contact_Person_Phone__c`  string , `Contact_Person_Title__c`  string , `Custom_document_to_use__c`  string , `DBA_City_and_State__c`  string , `DBA_Name__c`  string , `DBA_Phone__c`  string , `DBA_Physical_Address__c`  string , `DBA_Zip_Code__c`  string , `Date_start_software__c`  string , `Day_Past_Due_FirstFee__c`  string , `Day_Past_Due_Notice__c`  string , `Days_Past_Due_Lien__c`  string , `Days_Past_Due_Locktenant__c`  string , `Days_Past_Due_Overlock__c`  string , `Days_prior_send_invoice__c`  string , `Desirable_New_City__c`  string , `Doc_electronic_sign__c`  string , `Domain_Registration_Location__c`  string , `Emphasize_On_Website__c`  string , `Est_date_opening_facility__c`  string , `Explain_Auction_process__c`  string , `FMS_converting_from__c`  string , `Faciilty_Legal_Entity_Name__c`  string , `Facility_Email__c`  string , `Facility_Legal_City_and_State__c`  string , `Facility_Legal_Mailing_Street_Address__c`  string , `Facility_Legal_Phone__c`  string , `Facility_Legal_Zip_Code__c`  string , `Facility_State__c`  string , `Federal_Tax_ID__c`  string , `First_Late_Fee__c`  string , `Gate_Software_Provider__c`  string , `Gatefacility_access_hours__c`  string , `Google_Analytics__c`  string , `Google_My_Business_Listing_Question__c`  string , `Google_My_Business_Listing__c`  string , `Have_Logo_Facility__c`  string , `Holiday_Hours__c`  string , `How_much_Security_Deposit__c`  string , `How_payments_applied__c`  string , `Insuranceprotection_plan__c`  string , `JotForm_Enter_Case_Number__c`  string , `Lien_Fee__c`  string , `Link_SLSE_Software__c`  string , `List_merch_items__c`  string , `Lock_Cutting_Fee__c`  string , `Login_Credentials__c`  string , `Login_For_Domain__c`  string , `MS_Preapplication_JotForm__c`  string , `NSF_Fee__c`  string , `Name_POS_or_FMS_used__c`  string , `Nearby_Landmarks__c`  string , `Nearby_Neighborhoods__c`  string , `Office_hours__c`  string , `Other_Pastdue_Event__c`  string , `Overlock_Fee__c`  string , `Overlock_PastDue_Unit__c`  string , `Place_Lien_Units__c`  string , `Primary_User_Email__c`  string , `Primary_User__c`  string , `Promo_discount_offer__c`  string , `Prorate_Rent_moveout__c`  string , `Prorate_moveout_days__c`  string , `Recur_LateFee_OneTime__c`  string , `Reservation_Fee__c`  string , `Retail_or_Merch_sale__c`  string , `Second_Late_Fee__c`  string , `Send_monthly_rent_invoices__c`  string , `Share_login_info__c`  string , `Signer_Date_of_Birth__c`  string , `Signer_Email__c`  string , `Signer_Home_Address__c`  string , `Signer_Name__c`  string , `Signer_Percentage_Business_Owned__c`  string , `Signer_Phone__c`  string , `Signer_Title__c`  string , `Start_or_acquire_date_of_business__c`  string , `Tax_rate_on_rent__c`  string , `Temperature_Controlled_Units__c`  string , `Tenant_Insurance_Provider__c`  string , `Top_Amenity__c`  string , `UA_Code__c`  string , `UNPW_current_software__c`  string , `Unmanned_Facility__c`  string , `Upload_Business_LicenseArticle_Incorp__c`  string , `Upload_Logo_Brand__c`  string , `Upload_Logo_Website__c`  string , `Upload_Signer_Driver_License__c`  string , `Upload_Void_Check_or_Bank_Detail__c`  string , `Upload_custom_document__c`  string , `Website_Photo_Facility__c`  string , `Which_Storable_Software__c`  string , `storEDGE_integrate__c`  string , `Purchaser_Phone__c`  string , `Purchaser_Email__c`  string , `storEDGE_integrate2__c`  string , `ACS_quotehardware__c`  string , `Access_after_Transfer__c`  string , `Access_point_restrict_keypad__c`  string , `Accesspointrestrict__c`  string , `Additional_Comment__c`  string , `Any_Portable_Units__c`  string , `Archive_Option_email_address__c`  string , `Clone_softwaresetting__c`  string , `Clone_website_namefacility__c`  string , `Construction_openbusiness__c`  string , `Continue_software_service__c`  string , `Convertfromspreadsheet__c`  string , `Current_Software_Provider__c`  string , `Date_Signed__c`  string , `Date_to_be_released__c`  string , `Existing_Corp_Code__c`  string , `Facility_clone__c`  string , `Historical_Data_Selection__c`  string , `Interest_Digital_Marketing__c`  string , `Interest_Sparefoot_facility__c`  string , `License_Holder__c`  string , `Loc_Code_Preference__c`  string , `Location_Code__c`  string , `ManageCompany_Ownersame__c`  string , `Managesoftware_convert__c`  string , `Merch_Provider_Facility__c`  string , `Name_Facility_Purchase__c`  string , `NewWebsite_ExistingDomain__c`  string , `Other_Merch_Provider__c`  string , `Other_Software_Provider__c`  string , `Other_Website_Provider__c`  string , `PurchFacility_SL_SE_ESS__c`  string , `Recipient_Email__c`  string , `Recipient_Facility_Name__c`  string , `Recipient_Name__c`  string , `Release_Date__c`  string , `Release_domain_name_website__c`  string , `SLCorpCode__c`  string , `SLLocationCode__c`  string , `Software_forwardfacility__c`  string , `Tenant_Insurance_Facility__c`  string , `Transferee_Company_Name__c`  string , `Transferee_Email__c`  string , `Transferee_Phone_Number__c`  string , `Transferee_Primary_Contact__c`  string , `Units__c`  string , `Use_Gate_Software_Provider__c`  string , `Use_Sparefoot_facility__c`  string , `WebsiteProvider_Facility__c`  string , `Your_SL_CorpCode__c`  string , `New_Access_Provider__c`  string , `New_Website_Provider__c`  string , `New_Software_Provider__c`  string , `Auction_Fee_Amount__c`  string , `Days_until_second_late_fee__c`  string , `Offering_Tenant_Protection_Plans__c`  string , `Invoice_Method__c`  string , `Addtl_info_or_Qs_on_MS_account__c`  string , `Existing_SMS_account__c`  string , `Expected_FMS_start_date__c`  string , `Type_of_Business__c`  string , `Which_PoS_or_FMS_will_you_be_using__c`  string , `Please_Explain__c`  string , `Reason_Opting_Out_of_Auto_Protect__c`  string , `Preferred_Availability__c`  string , `SSO_Interest_Level__c`  string , `Preferred_Contact_Method__c`  string , `CreditCardCVV__c`  string , `GTM_ID__c`  string , `If_Other_what_is_name_of_Gate_Provider__c`  string , `What_is_your_domain__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-dev/raw/form_response__cs/2023-08-16/1692199578'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_form_response__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/form_response__cs/2023-08-16/1692199578
    • id: 4697427
    • processed: 1
    • raw_data: 
      {
    "ACHAccountNumber__c": 77,
    "ACHInstitutionCity__c": 79,
    "ACHInstitutionName__c": 80,
    "ACHInstitutionPostalCode__c": 81,
    "ACHInstitutionRegion__c": 82,
    "ACHRoutingNumber__c": 78,
    "ACS_quotehardware__c": 190,
    "Access_Control_Competitor_moving_to__c": 13,
    "Access_Control_Products_to_Cancel__c": 14,
    "Access_Hours__c": 18,
    "Access_after_Transfer__c": 191,
    "Access_point_restrict_keypad__c": 192,
    "Accesspointrestrict__c": 193,
    "Accounting_method_use__c": 19,
    "Add_info_facility__c": 20,
    "Additional_Comment__c": 194,
    "Addtl_info_or_Qs_on_MS_account__c": 247,
    "Administrative_Fee__c": 21,
    "Already_have_domain__c": 22,
    "Amenities_Offered__c": 23,
    "Anticipated_Monthly_Vol_per_month__c": 28,
    "Any_Portable_Units__c": 195,
    "Anything_else_we_should_know__c": 15,
    "Archive_Option_email_address__c": 196,
    "Assist_Google_My_Business__c": 30,
    "Auction_Fee_Amount__c": 243,
    "Auction_Units__c": 53,
    "BillingCity__c": 70,
    "BillingCountry__c": 71,
    "BillingName__c": 69,
    "BillingPaymentMethod__c": 75,
    "BillingPostalCode__c": 72,
    "BillingRegion__c": 73,
    "BillingStreet__c": 74,
    "Billing_Settings__c": 84,
    "Cancel_Single_Multiple_or_All_facility__c": 17,
    "Charge_Second_Late_Fee__c": 90,
    "Charge_Security_Deposit__c": 91,
    "Clone_softwaresetting__c": 197,
    "Clone_website_namefacility__c": 198,
    "ConnectionReceivedId": 11,
    "ConnectionSentId": 12,
    "Construction_openbusiness__c": 199,
    "Contact_Email__c": 24,
    "Contact_Name__c": 25,
    "Contact_Person_Email__c": 92,
    "Contact_Person_Name__c": 93,
    "Contact_Person_Phone__c": 94,
    "Contact_Person_Title__c": 95,
    "Contact_Phone__c": 26,
    "Continue_software_service__c": 200,
    "Convertfromspreadsheet__c": 201,
    "CreatedById": 7,
    "CreatedDate": 6,
    "Created_Case__c": 27,
    "CreditCardCVV__c": 257,
    "CreditCardExpiration__c": 66,
    "CreditCardName__c": 68,
    "CreditCardNetwork__c": 67,
    "CreditCardNumber__c": 65,
    "CurrencyIsoCode": 4,
    "Current_Software_Provider__c": 202,
    "Custom_document_to_use__c": 96,
    "DBA_City_and_State__c": 97,
    "DBA_Name__c": 98,
    "DBA_Phone__c": 99,
    "DBA_Physical_Address__c": 100,
    "DBA_Zip_Code__c": 101,
    "Date_Signed__c": 203,
    "Date_start_software__c": 102,
    "Date_to_be_released__c": 204,
    "Day_Past_Due_FirstFee__c": 103,
    "Day_Past_Due_Notice__c": 104,
    "Days_Past_Due_Lien__c": 105,
    "Days_Past_Due_Locktenant__c": 106,
    "Days_Past_Due_Overlock__c": 107,
    "Days_prior_send_invoice__c": 108,
    "Days_until_second_late_fee__c": 244,
    "Desirable_New_City__c": 109,
    "Device_Quantity__c": 85,
    "Discuss_with_our_Product_Manager__c": 59,
    "Doc_electronic_sign__c": 110,
    "DocuSignStatus__c": 64,
    "Domain_Registration_Location__c": 111,
    "Emphasize_On_Website__c": 112,
    "Est_date_opening_facility__c": 113,
    "Existing_Corp_Code__c": 205,
    "Existing_SMS_account__c": 248,
    "Expected_FMS_start_date__c": 249,
    "Explain_Auction_process__c": 114,
    "FMS_converting_from__c": 115,
    "Faciilty_Legal_Entity_Name__c": 116,
    "Facility_Cancel_List__c": 29,
    "Facility_Email__c": 117,
    "Facility_ID__c": 86,
    "Facility_Legal_City_and_State__c": 118,
    "Facility_Legal_Mailing_Street_Address__c": 119,
    "Facility_Legal_Phone__c": 120,
    "Facility_Legal_Zip_Code__c": 121,
    "Facility_State__c": 122,
    "Facility_clone__c": 206,
    "Federal_Tax_ID__c": 123,
    "First_Late_Fee__c": 124,
    "FormURL__c": 83,
    "Form_Record_Type__c": 31,
    "Full_Address__c": 87,
    "GTM_ID__c": 258,
    "Gate_Software_Provider__c": 125,
    "Gatefacility_access_hours__c": 126,
    "Google_Analytics__c": 127,
    "Google_My_Business_Listing_Question__c": 128,
    "Google_My_Business_Listing__c": 129,
    "Have_Logo_Facility__c": 130,
    "Historical_Data_Selection__c": 207,
    "Holiday_Hours__c": 131,
    "How_much_Security_Deposit__c": 132,
    "How_payments_applied__c": 133,
    "Id": 0,
    "If_Other_what_is_name_of_Gate_Provider__c": 259,
    "Insurance_Product_to_Cancel__c": 32,
    "Insuranceprotection_plan__c": 134,
    "Interest_Digital_Marketing__c": 208,
    "Interest_Sparefoot_facility__c": 209,
    "Interest_in_Data_Archive__c": 60,
    "Invoice_Method__c": 246,
    "IsDeleted": 2,
    "JotForm_Enter_Case_Number__c": 135,
    "Jotform_Submission_ID__c": 63,
    "LastModifiedById": 9,
    "LastModifiedDate": 8,
    "License_Holder__c": 210,
    "Lien_Fee__c": 136,
    "Link_SLSE_Software__c": 137,
    "List_merch_items__c": 138,
    "Loc_Code_Preference__c": 211,
    "Location_Code__c": 212,
    "Lock_Cutting_Fee__c": 139,
    "Login_Credentials__c": 140,
    "Login_For_Domain__c": 141,
    "MS_Preapplication_JotForm__c": 142,
    "ManageCompany_Ownersame__c": 213,
    "Managesoftware_convert__c": 214,
    "Merch_Provider_Facility__c": 215,
    "MerchantId__c": 88,
    "Merchant_Timezone__c": 89,
    "NSF_Fee__c": 143,
    "Name": 3,
    "Name_Facility_Purchase__c": 216,
    "Name_POS_or_FMS_used__c": 144,
    "Nearby_Landmarks__c": 145,
    "Nearby_Neighborhoods__c": 146,
    "NewWebsite_ExistingDomain__c": 217,
    "New_Access_Provider__c": 240,
    "New_Insurance_Provider_moving_to__c": 33,
    "New_Software_Platform_moving_to__c": 34,
    "New_Software_Provider__c": 242,
    "New_Website_Platform_moving_to__c": 35,
    "New_Website_Provider__c": 241,
    "Offering_Tenant_Protection_Plans__c": 245,
    "Office_hours__c": 147,
    "Onethingwecouldhavedonedifferently__c": 36,
    "OpportunityId__c": 76,
    "Other_Cancel_Access_Control__c": 37,
    "Other_Cancel_Insurance__c": 38,
    "Other_Cancel_Payment_Other_Product__c": 39,
    "Other_Cancel_Software_Product__c": 40,
    "Other_Cancel_SpareFoot__c": 41,
    "Other_Cancel_Website_Product__c": 42,
    "Other_Merch_Provider__c": 218,
    "Other_Pastdue_Event__c": 148,
    "Other_Software_Provider__c": 219,
    "Other_Website_Provider__c": 220,
    "Overlock_Fee__c": 149,
    "Overlock_PastDue_Unit__c": 150,
    "OwnerId": 1,
    "Payment_or_Other_Product_to_Cancel__c": 43,
    "Place_Lien_Units__c": 151,
    "Please_Explain__c": 252,
    "Please_provide_the_name_of_the_purchaser__c": 44,
    "Preferred_Availability__c": 254,
    "Preferred_Contact_Method__c": 256,
    "Primary_User_Email__c": 152,
    "Primary_User__c": 153,
    "Promo_discount_offer__c": 154,
    "Prorate_Rent_moveout__c": 155,
    "Prorate_moveout_days__c": 156,
    "PurchFacility_SL_SE_ESS__c": 221,
    "Purchaser_Email__c": 188,
    "Purchaser_Phone__c": 187,
    "Reason_Cancel_Access_Control__c": 45,
    "Reason_Cancel_Insurance__c": 46,
    "Reason_Cancel_Payment_or_Other_Product__c": 47,
    "Reason_Cancel_Software_Product__c": 48,
    "Reason_Cancel_SpareFoot__c": 49,
    "Reason_Cancel_Website_Product__c": 50,
    "Reason_Opting_Out_of_Auto_Protect__c": 253,
    "Reasonforleaving__c": 51,
    "Recipient_Email__c": 222,
    "Recipient_Facility_Name__c": 223,
    "Recipient_Name__c": 224,
    "RecordTypeId": 5,
    "Recur_LateFee_OneTime__c": 157,
    "Related_Record_Created__c": 52,
    "Release_Date__c": 225,
    "Release_domain_name_website__c": 226,
    "Reservation_Fee__c": 158,
    "Retail_or_Merch_sale__c": 159,
    "SLCorpCode__c": 227,
    "SLLocationCode__c": 228,
    "SSO_Interest_Level__c": 255,
    "Second_Late_Fee__c": 160,
    "Selling_or_Transfer_of_Ownership__c": 61,
    "Send_monthly_rent_invoices__c": 161,
    "Share_login_info__c": 162,
    "Signer_Date_of_Birth__c": 163,
    "Signer_Email__c": 164,
    "Signer_Home_Address__c": 165,
    "Signer_Name__c": 166,
    "Signer_Percentage_Business_Owned__c": 167,
    "Signer_Phone__c": 168,
    "Signer_Title__c": 169,
    "Software_Products_to_Cancel__c": 54,
    "Software_forwardfacility__c": 229,
    "Source__c": 55,
    "SpareFoot_Product_to_Cancel__c": 56,
    "Start_or_acquire_date_of_business__c": 170,
    "Subject__c": 57,
    "Switching_Product__c": 16,
    "SystemModstamp": 10,
    "Tax_rate_on_rent__c": 171,
    "Temperature_Controlled_Units__c": 172,
    "Tenant_Insurance_Facility__c": 230,
    "Tenant_Insurance_Provider__c": 173,
    "Top_Amenity__c": 174,
    "Transferee_Company_Name__c": 231,
    "Transferee_Email__c": 232,
    "Transferee_Phone_Number__c": 233,
    "Transferee_Primary_Contact__c": 234,
    "Type_of_Business__c": 250,
    "UA_Code__c": 175,
    "UNPW_current_software__c": 176,
    "Units__c": 235,
    "Unmanned_Facility__c": 177,
    "Upload_Business_LicenseArticle_Incorp__c": 178,
    "Upload_Logo_Brand__c": 179,
    "Upload_Logo_Website__c": 180,
    "Upload_Signer_Driver_License__c": 181,
    "Upload_Void_Check_or_Bank_Detail__c": 182,
    "Upload_custom_document__c": 183,
    "Use_Gate_Software_Provider__c": 236,
    "Use_Sparefoot_facility__c": 237,
    "WebsiteProvider_Facility__c": 238,
    "Website_Photo_Facility__c": 184,
    "Website_Products_to_Cancel__c": 58,
    "Website_URL__c": 62,
    "What_is_your_domain__c": 260,
    "Which_PoS_or_FMS_will_you_be_using__c": 251,
    "Which_Storable_Software__c": 185,
    "Your_SL_CorpCode__c": 239,
    "storEDGE_integrate2__c": 189,
    "storEDGE_integrate__c": 186
}
    • schema_attributes: 
      {
    "ACHAccountNumber__c": "string",
    "ACHInstitutionCity__c": "string",
    "ACHInstitutionName__c": "string",
    "ACHInstitutionPostalCode__c": "string",
    "ACHInstitutionRegion__c": "string",
    "ACHRoutingNumber__c": "string",
    "ACS_quotehardware__c": "string",
    "Access_Control_Competitor_moving_to__c": "string",
    "Access_Control_Products_to_Cancel__c": "string",
    "Access_Hours__c": "string",
    "Access_after_Transfer__c": "string",
    "Access_point_restrict_keypad__c": "string",
    "Accesspointrestrict__c": "string",
    "Accounting_method_use__c": "string",
    "Add_info_facility__c": "string",
    "Additional_Comment__c": "string",
    "Addtl_info_or_Qs_on_MS_account__c": "string",
    "Administrative_Fee__c": "string",
    "Already_have_domain__c": "string",
    "Amenities_Offered__c": "string",
    "Amount": "string",
    "Anticipated_Monthly_Vol_per_month__c": "string",
    "Any_Portable_Units__c": "string",
    "Anything_else_we_should_know__c": "string",
    "Archive_Option_email_address__c": "string",
    "Assist_Google_My_Business__c": "string",
    "Auction_Fee_Amount__c": "string",
    "Auction_Units__c": "string",
    "BillingCity__c": "string",
    "BillingCountry__c": "string",
    "BillingName__c": "string",
    "BillingPaymentMethod__c": "string",
    "BillingPostalCode__c": "string",
    "BillingRegion__c": "string",
    "BillingStreet__c": "string",
    "Billing_Settings__c": "string",
    "Cancel_Single_Multiple_or_All_facility__c": "string",
    "Charge_Second_Late_Fee__c": "string",
    "Charge_Security_Deposit__c": "string",
    "Clone_softwaresetting__c": "string",
    "Clone_website_namefacility__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Construction_openbusiness__c": "string",
    "Contact_Email__c": "string",
    "Contact_Name__c": "string",
    "Contact_Person_Email__c": "string",
    "Contact_Person_Name__c": "string",
    "Contact_Person_Phone__c": "string",
    "Contact_Person_Title__c": "string",
    "Contact_Phone__c": "string",
    "Continue_software_service__c": "string",
    "Convertfromspreadsheet__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_Case__c": "string",
    "CreditCardCVV__c": "string",
    "CreditCardExpiration__c": "string",
    "CreditCardName__c": "string",
    "CreditCardNetwork__c": "string",
    "CreditCardNumber__c": "string",
    "CurrencyIsoCode": "string",
    "Current_Software_Provider__c": "string",
    "Custom_document_to_use__c": "string",
    "DBA_City_and_State__c": "string",
    "DBA_Name__c": "string",
    "DBA_Phone__c": "string",
    "DBA_Physical_Address__c": "string",
    "DBA_Zip_Code__c": "string",
    "Date_Signed__c": "string",
    "Date_start_software__c": "string",
    "Date_to_be_released__c": "string",
    "Day_Past_Due_FirstFee__c": "string",
    "Day_Past_Due_Notice__c": "string",
    "Days_Past_Due_Lien__c": "string",
    "Days_Past_Due_Locktenant__c": "string",
    "Days_Past_Due_Overlock__c": "string",
    "Days_prior_send_invoice__c": "string",
    "Days_until_second_late_fee__c": "string",
    "Desirable_New_City__c": "string",
    "Device_Quantity__c": "string",
    "Discuss_with_our_Product_Manager__c": "string",
    "Doc_electronic_sign__c": "string",
    "DocuSignStatus__c": "string",
    "Domain_Registration_Location__c": "string",
    "Emphasize_On_Website__c": "string",
    "Est_date_opening_facility__c": "string",
    "Existing_Corp_Code__c": "string",
    "Existing_SMS_account__c": "string",
    "ExpectedRevenue": "string",
    "Expected_FMS_start_date__c": "string",
    "Explain_Auction_process__c": "string",
    "FMS_converting_from__c": "string",
    "Faciilty_Legal_Entity_Name__c": "string",
    "Facility_Cancel_List__c": "string",
    "Facility_Email__c": "string",
    "Facility_ID__c": "string",
    "Facility_Legal_City_and_State__c": "string",
    "Facility_Legal_Mailing_Street_Address__c": "string",
    "Facility_Legal_Phone__c": "string",
    "Facility_Legal_Zip_Code__c": "string",
    "Facility_State__c": "string",
    "Facility_clone__c": "string",
    "Federal_Tax_ID__c": "string",
    "First_Late_Fee__c": "string",
    "ForecastCategory": "string",
    "FormURL__c": "string",
    "Form_Record_Type__c": "string",
    "Full_Address__c": "string",
    "GTM_ID__c": "string",
    "Gate_Software_Provider__c": "string",
    "Gatefacility_access_hours__c": "string",
    "Google_Analytics__c": "string",
    "Google_My_Business_Listing_Question__c": "string",
    "Google_My_Business_Listing__c": "string",
    "Have_Logo_Facility__c": "string",
    "Historical_Data_Selection__c": "string",
    "Holiday_Hours__c": "string",
    "How_much_Security_Deposit__c": "string",
    "How_payments_applied__c": "string",
    "Id": "string",
    "If_Other_what_is_name_of_Gate_Provider__c": "string",
    "Insurance_Product_to_Cancel__c": "string",
    "Insuranceprotection_plan__c": "string",
    "Interest_Digital_Marketing__c": "string",
    "Interest_Sparefoot_facility__c": "string",
    "Interest_in_Data_Archive__c": "string",
    "Invoice_Method__c": "string",
    "IsDeleted": "string",
    "JotForm_Enter_Case_Number__c": "string",
    "Jotform_Submission_ID__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "License_Holder__c": "string",
    "Lien_Fee__c": "string",
    "Link_SLSE_Software__c": "string",
    "List_merch_items__c": "string",
    "Loc_Code_Preference__c": "string",
    "Location_Code__c": "string",
    "Lock_Cutting_Fee__c": "string",
    "Login_Credentials__c": "string",
    "Login_For_Domain__c": "string",
    "MS_Preapplication_JotForm__c": "string",
    "ManageCompany_Ownersame__c": "string",
    "Managesoftware_convert__c": "string",
    "Merch_Provider_Facility__c": "string",
    "MerchantId__c": "string",
    "Merchant_Timezone__c": "string",
    "NSF_Fee__c": "string",
    "Name": "string",
    "Name_Facility_Purchase__c": "string",
    "Name_POS_or_FMS_used__c": "string",
    "Nearby_Landmarks__c": "string",
    "Nearby_Neighborhoods__c": "string",
    "NewWebsite_ExistingDomain__c": "string",
    "New_Access_Provider__c": "string",
    "New_Insurance_Provider_moving_to__c": "string",
    "New_Software_Platform_moving_to__c": "string",
    "New_Software_Provider__c": "string",
    "New_Website_Platform_moving_to__c": "string",
    "New_Website_Provider__c": "string",
    "Offering_Tenant_Protection_Plans__c": "string",
    "Office_hours__c": "string",
    "Onethingwecouldhavedonedifferently__c": "string",
    "OpportunityId": "string",
    "OpportunityId__c": "string",
    "Other_Cancel_Access_Control__c": "string",
    "Other_Cancel_Insurance__c": "string",
    "Other_Cancel_Payment_Other_Product__c": "string",
    "Other_Cancel_Software_Product__c": "string",
    "Other_Cancel_SpareFoot__c": "string",
    "Other_Cancel_Website_Product__c": "string",
    "Other_Merch_Provider__c": "string",
    "Other_Pastdue_Event__c": "string",
    "Other_Software_Provider__c": "string",
    "Other_Website_Provider__c": "string",
    "Overlock_Fee__c": "string",
    "Overlock_PastDue_Unit__c": "string",
    "OwnerId": "string",
    "Payment_or_Other_Product_to_Cancel__c": "string",
    "Place_Lien_Units__c": "string",
    "Please_Explain__c": "string",
    "Please_provide_the_name_of_the_purchaser__c": "string",
    "Preferred_Availability__c": "string",
    "Preferred_Contact_Method__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_User_Email__c": "string",
    "Primary_User__c": "string",
    "Probability": "string",
    "Promo_discount_offer__c": "string",
    "Prorate_Rent_moveout__c": "string",
    "Prorate_moveout_days__c": "string",
    "PurchFacility_SL_SE_ESS__c": "string",
    "Purchaser_Email__c": "string",
    "Purchaser_Phone__c": "string",
    "Reason_Cancel_Access_Control__c": "string",
    "Reason_Cancel_Insurance__c": "string",
    "Reason_Cancel_Payment_or_Other_Product__c": "string",
    "Reason_Cancel_Software_Product__c": "string",
    "Reason_Cancel_SpareFoot__c": "string",
    "Reason_Cancel_Website_Product__c": "string",
    "Reason_Opting_Out_of_Auto_Protect__c": "string",
    "Reasonforleaving__c": "string",
    "Recipient_Email__c": "string",
    "Recipient_Facility_Name__c": "string",
    "Recipient_Name__c": "string",
    "RecordTypeId": "string",
    "Recur_LateFee_OneTime__c": "string",
    "Related_Record_Created__c": "string",
    "Release_Date__c": "string",
    "Release_domain_name_website__c": "string",
    "Reservation_Fee__c": "string",
    "Retail_or_Merch_sale__c": "string",
    "SLCorpCode__c": "string",
    "SLLocationCode__c": "string",
    "SSO_Interest_Level__c": "string",
    "Second_Late_Fee__c": "string",
    "Selling_or_Transfer_of_Ownership__c": "string",
    "Send_monthly_rent_invoices__c": "string",
    "Share_login_info__c": "string",
    "Signer_Date_of_Birth__c": "string",
    "Signer_Email__c": "string",
    "Signer_Home_Address__c": "string",
    "Signer_Name__c": "string",
    "Signer_Percentage_Business_Owned__c": "string",
    "Signer_Phone__c": "string",
    "Signer_Title__c": "string",
    "Software_Products_to_Cancel__c": "string",
    "Software_forwardfacility__c": "string",
    "Source__c": "string",
    "SpareFoot_Product_to_Cancel__c": "string",
    "StageName": "string",
    "Start_or_acquire_date_of_business__c": "string",
    "Subject__c": "string",
    "Switching_Product__c": "string",
    "SystemModstamp": "string",
    "Tax_rate_on_rent__c": "string",
    "Temperature_Controlled_Units__c": "string",
    "Tenant_Insurance_Facility__c": "string",
    "Tenant_Insurance_Provider__c": "string",
    "Top_Amenity__c": "string",
    "Transferee_Company_Name__c": "string",
    "Transferee_Email__c": "string",
    "Transferee_Phone_Number__c": "string",
    "Transferee_Primary_Contact__c": "string",
    "Type_of_Business__c": "string",
    "UA_Code__c": "string",
    "UNPW_current_software__c": "string",
    "Units__c": "string",
    "Unmanned_Facility__c": "string",
    "Upload_Business_LicenseArticle_Incorp__c": "string",
    "Upload_Logo_Brand__c": "string",
    "Upload_Logo_Website__c": "string",
    "Upload_Signer_Driver_License__c": "string",
    "Upload_Void_Check_or_Bank_Detail__c": "string",
    "Upload_custom_document__c": "string",
    "Use_Gate_Software_Provider__c": "string",
    "Use_Sparefoot_facility__c": "string",
    "WebsiteProvider_Facility__c": "string",
    "Website_Photo_Facility__c": "string",
    "Website_Products_to_Cancel__c": "string",
    "Website_URL__c": "string",
    "What_is_your_domain__c": "string",
    "Which_PoS_or_FMS_will_you_be_using__c": "string",
    "Which_Storable_Software__c": "string",
    "Your_SL_CorpCode__c": "string",
    "storEDGE_integrate2__c": "string",
    "storEDGE_integrate__c": "string"
}
    • schema_name_id: 2060
    • schema_scan_id: 6251353
    • updated: 2023-08-16 10:27:41
    • created: 2023-08-16 09:31:34
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_form_response__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_form_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Access_Control_Competitor_moving_to__c`  string , `Access_Control_Products_to_Cancel__c`  string , `Anything_else_we_should_know__c`  string , `Switching_Product__c`  string , `Cancel_Single_Multiple_or_All_facility__c`  string , `Access_Hours__c`  string , `Accounting_method_use__c`  string , `Add_info_facility__c`  string , `Administrative_Fee__c`  string , `Already_have_domain__c`  string , `Amenities_Offered__c`  string , `Contact_Email__c`  string , `Contact_Name__c`  string , `Contact_Phone__c`  string , `Created_Case__c`  string , `Anticipated_Monthly_Vol_per_month__c`  string , `Facility_Cancel_List__c`  string , `Assist_Google_My_Business__c`  string , `Form_Record_Type__c`  string , `Insurance_Product_to_Cancel__c`  string , `New_Insurance_Provider_moving_to__c`  string , `New_Software_Platform_moving_to__c`  string , `New_Website_Platform_moving_to__c`  string , `Onethingwecouldhavedonedifferently__c`  string , `Other_Cancel_Access_Control__c`  string , `Other_Cancel_Insurance__c`  string , `Other_Cancel_Payment_Other_Product__c`  string , `Other_Cancel_Software_Product__c`  string , `Other_Cancel_SpareFoot__c`  string , `Other_Cancel_Website_Product__c`  string , `Payment_or_Other_Product_to_Cancel__c`  string , `Please_provide_the_name_of_the_purchaser__c`  string , `Reason_Cancel_Access_Control__c`  string , `Reason_Cancel_Insurance__c`  string , `Reason_Cancel_Payment_or_Other_Product__c`  string , `Reason_Cancel_Software_Product__c`  string , `Reason_Cancel_SpareFoot__c`  string , `Reason_Cancel_Website_Product__c`  string , `Reasonforleaving__c`  string , `Related_Record_Created__c`  string , `Auction_Units__c`  string , `Software_Products_to_Cancel__c`  string , `Source__c`  string , `SpareFoot_Product_to_Cancel__c`  string , `Subject__c`  string , `Website_Products_to_Cancel__c`  string , `Discuss_with_our_Product_Manager__c`  string , `Interest_in_Data_Archive__c`  string , `Selling_or_Transfer_of_Ownership__c`  string , `Website_URL__c`  string , `Jotform_Submission_ID__c`  string , `DocuSignStatus__c`  string , `CreditCardNumber__c`  string , `CreditCardExpiration__c`  string , `CreditCardNetwork__c`  string , `CreditCardName__c`  string , `BillingName__c`  string , `BillingCity__c`  string , `BillingCountry__c`  string , `BillingPostalCode__c`  string , `BillingRegion__c`  string , `BillingStreet__c`  string , `BillingPaymentMethod__c`  string , `OpportunityId__c`  string , `ACHAccountNumber__c`  string , `ACHRoutingNumber__c`  string , `ACHInstitutionCity__c`  string , `ACHInstitutionName__c`  string , `ACHInstitutionPostalCode__c`  string , `ACHInstitutionRegion__c`  string , `FormURL__c`  string , `Billing_Settings__c`  string , `Device_Quantity__c`  string , `Facility_ID__c`  string , `Full_Address__c`  string , `MerchantId__c`  string , `Merchant_Timezone__c`  string , `Charge_Second_Late_Fee__c`  string , `Charge_Security_Deposit__c`  string , `Contact_Person_Email__c`  string , `Contact_Person_Name__c`  string , `Contact_Person_Phone__c`  string , `Contact_Person_Title__c`  string , `Custom_document_to_use__c`  string , `DBA_City_and_State__c`  string , `DBA_Name__c`  string , `DBA_Phone__c`  string , `DBA_Physical_Address__c`  string , `DBA_Zip_Code__c`  string , `Date_start_software__c`  string , `Day_Past_Due_FirstFee__c`  string , `Day_Past_Due_Notice__c`  string , `Days_Past_Due_Lien__c`  string , `Days_Past_Due_Locktenant__c`  string , `Days_Past_Due_Overlock__c`  string , `Days_prior_send_invoice__c`  string , `Desirable_New_City__c`  string , `Doc_electronic_sign__c`  string , `Domain_Registration_Location__c`  string , `Emphasize_On_Website__c`  string , `Est_date_opening_facility__c`  string , `Explain_Auction_process__c`  string , `FMS_converting_from__c`  string , `Faciilty_Legal_Entity_Name__c`  string , `Facility_Email__c`  string , `Facility_Legal_City_and_State__c`  string , `Facility_Legal_Mailing_Street_Address__c`  string , `Facility_Legal_Phone__c`  string , `Facility_Legal_Zip_Code__c`  string , `Facility_State__c`  string , `Federal_Tax_ID__c`  string , `First_Late_Fee__c`  string , `Gate_Software_Provider__c`  string , `Gatefacility_access_hours__c`  string , `Google_Analytics__c`  string , `Google_My_Business_Listing_Question__c`  string , `Google_My_Business_Listing__c`  string , `Have_Logo_Facility__c`  string , `Holiday_Hours__c`  string , `How_much_Security_Deposit__c`  string , `How_payments_applied__c`  string , `Insuranceprotection_plan__c`  string , `JotForm_Enter_Case_Number__c`  string , `Lien_Fee__c`  string , `Link_SLSE_Software__c`  string , `List_merch_items__c`  string , `Lock_Cutting_Fee__c`  string , `Login_Credentials__c`  string , `Login_For_Domain__c`  string , `MS_Preapplication_JotForm__c`  string , `NSF_Fee__c`  string , `Name_POS_or_FMS_used__c`  string , `Nearby_Landmarks__c`  string , `Nearby_Neighborhoods__c`  string , `Office_hours__c`  string , `Other_Pastdue_Event__c`  string , `Overlock_Fee__c`  string , `Overlock_PastDue_Unit__c`  string , `Place_Lien_Units__c`  string , `Primary_User_Email__c`  string , `Primary_User__c`  string , `Promo_discount_offer__c`  string , `Prorate_Rent_moveout__c`  string , `Prorate_moveout_days__c`  string , `Recur_LateFee_OneTime__c`  string , `Reservation_Fee__c`  string , `Retail_or_Merch_sale__c`  string , `Second_Late_Fee__c`  string , `Send_monthly_rent_invoices__c`  string , `Share_login_info__c`  string , `Signer_Date_of_Birth__c`  string , `Signer_Email__c`  string , `Signer_Home_Address__c`  string , `Signer_Name__c`  string , `Signer_Percentage_Business_Owned__c`  string , `Signer_Phone__c`  string , `Signer_Title__c`  string , `Start_or_acquire_date_of_business__c`  string , `Tax_rate_on_rent__c`  string , `Temperature_Controlled_Units__c`  string , `Tenant_Insurance_Provider__c`  string , `Top_Amenity__c`  string , `UA_Code__c`  string , `UNPW_current_software__c`  string , `Unmanned_Facility__c`  string , `Upload_Business_LicenseArticle_Incorp__c`  string , `Upload_Logo_Brand__c`  string , `Upload_Logo_Website__c`  string , `Upload_Signer_Driver_License__c`  string , `Upload_Void_Check_or_Bank_Detail__c`  string , `Upload_custom_document__c`  string , `Website_Photo_Facility__c`  string , `Which_Storable_Software__c`  string , `storEDGE_integrate__c`  string , `Purchaser_Phone__c`  string , `Purchaser_Email__c`  string , `storEDGE_integrate2__c`  string , `ACS_quotehardware__c`  string , `Access_after_Transfer__c`  string , `Access_point_restrict_keypad__c`  string , `Accesspointrestrict__c`  string , `Additional_Comment__c`  string , `Any_Portable_Units__c`  string , `Archive_Option_email_address__c`  string , `Clone_softwaresetting__c`  string , `Clone_website_namefacility__c`  string , `Construction_openbusiness__c`  string , `Continue_software_service__c`  string , `Convertfromspreadsheet__c`  string , `Current_Software_Provider__c`  string , `Date_Signed__c`  string , `Date_to_be_released__c`  string , `Existing_Corp_Code__c`  string , `Facility_clone__c`  string , `Historical_Data_Selection__c`  string , `Interest_Digital_Marketing__c`  string , `Interest_Sparefoot_facility__c`  string , `License_Holder__c`  string , `Loc_Code_Preference__c`  string , `Location_Code__c`  string , `ManageCompany_Ownersame__c`  string , `Managesoftware_convert__c`  string , `Merch_Provider_Facility__c`  string , `Name_Facility_Purchase__c`  string , `NewWebsite_ExistingDomain__c`  string , `Other_Merch_Provider__c`  string , `Other_Software_Provider__c`  string , `Other_Website_Provider__c`  string , `PurchFacility_SL_SE_ESS__c`  string , `Recipient_Email__c`  string , `Recipient_Facility_Name__c`  string , `Recipient_Name__c`  string , `Release_Date__c`  string , `Release_domain_name_website__c`  string , `SLCorpCode__c`  string , `SLLocationCode__c`  string , `Software_forwardfacility__c`  string , `Tenant_Insurance_Facility__c`  string , `Transferee_Company_Name__c`  string , `Transferee_Email__c`  string , `Transferee_Phone_Number__c`  string , `Transferee_Primary_Contact__c`  string , `Units__c`  string , `Use_Gate_Software_Provider__c`  string , `Use_Sparefoot_facility__c`  string , `WebsiteProvider_Facility__c`  string , `Your_SL_CorpCode__c`  string , `New_Access_Provider__c`  string , `New_Website_Provider__c`  string , `New_Software_Provider__c`  string , `Auction_Fee_Amount__c`  string , `Days_until_second_late_fee__c`  string , `Offering_Tenant_Protection_Plans__c`  string , `Invoice_Method__c`  string , `Addtl_info_or_Qs_on_MS_account__c`  string , `Existing_SMS_account__c`  string , `Expected_FMS_start_date__c`  string , `Type_of_Business__c`  string , `Which_PoS_or_FMS_will_you_be_using__c`  string , `Please_Explain__c`  string , `Reason_Opting_Out_of_Auto_Protect__c`  string , `Preferred_Availability__c`  string , `SSO_Interest_Level__c`  string , `Preferred_Contact_Method__c`  string , `CreditCardCVV__c`  string , `GTM_ID__c`  string , `If_Other_what_is_name_of_Gate_Provider__c`  string , `What_is_your_domain__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-dev/raw/form_response__cs/2023-08-16/1692195981'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_form_response__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/form_response__cs/2023-08-16/1692195981
    • id: 4697406
    • processed: 1
    • raw_data: 
      {
    "ACHAccountNumber__c": 77,
    "ACHInstitutionCity__c": 79,
    "ACHInstitutionName__c": 80,
    "ACHInstitutionPostalCode__c": 81,
    "ACHInstitutionRegion__c": 82,
    "ACHRoutingNumber__c": 78,
    "ACS_quotehardware__c": 190,
    "Access_Control_Competitor_moving_to__c": 13,
    "Access_Control_Products_to_Cancel__c": 14,
    "Access_Hours__c": 18,
    "Access_after_Transfer__c": 191,
    "Access_point_restrict_keypad__c": 192,
    "Accesspointrestrict__c": 193,
    "Accounting_method_use__c": 19,
    "Add_info_facility__c": 20,
    "Additional_Comment__c": 194,
    "Addtl_info_or_Qs_on_MS_account__c": 247,
    "Administrative_Fee__c": 21,
    "Already_have_domain__c": 22,
    "Amenities_Offered__c": 23,
    "Anticipated_Monthly_Vol_per_month__c": 28,
    "Any_Portable_Units__c": 195,
    "Anything_else_we_should_know__c": 15,
    "Archive_Option_email_address__c": 196,
    "Assist_Google_My_Business__c": 30,
    "Auction_Fee_Amount__c": 243,
    "Auction_Units__c": 53,
    "BillingCity__c": 70,
    "BillingCountry__c": 71,
    "BillingName__c": 69,
    "BillingPaymentMethod__c": 75,
    "BillingPostalCode__c": 72,
    "BillingRegion__c": 73,
    "BillingStreet__c": 74,
    "Billing_Settings__c": 84,
    "Cancel_Single_Multiple_or_All_facility__c": 17,
    "Charge_Second_Late_Fee__c": 90,
    "Charge_Security_Deposit__c": 91,
    "Clone_softwaresetting__c": 197,
    "Clone_website_namefacility__c": 198,
    "ConnectionReceivedId": 11,
    "ConnectionSentId": 12,
    "Construction_openbusiness__c": 199,
    "Contact_Email__c": 24,
    "Contact_Name__c": 25,
    "Contact_Person_Email__c": 92,
    "Contact_Person_Name__c": 93,
    "Contact_Person_Phone__c": 94,
    "Contact_Person_Title__c": 95,
    "Contact_Phone__c": 26,
    "Continue_software_service__c": 200,
    "Convertfromspreadsheet__c": 201,
    "CreatedById": 7,
    "CreatedDate": 6,
    "Created_Case__c": 27,
    "CreditCardCVV__c": 257,
    "CreditCardExpiration__c": 66,
    "CreditCardName__c": 68,
    "CreditCardNetwork__c": 67,
    "CreditCardNumber__c": 65,
    "CurrencyIsoCode": 4,
    "Current_Software_Provider__c": 202,
    "Custom_document_to_use__c": 96,
    "DBA_City_and_State__c": 97,
    "DBA_Name__c": 98,
    "DBA_Phone__c": 99,
    "DBA_Physical_Address__c": 100,
    "DBA_Zip_Code__c": 101,
    "Date_Signed__c": 203,
    "Date_start_software__c": 102,
    "Date_to_be_released__c": 204,
    "Day_Past_Due_FirstFee__c": 103,
    "Day_Past_Due_Notice__c": 104,
    "Days_Past_Due_Lien__c": 105,
    "Days_Past_Due_Locktenant__c": 106,
    "Days_Past_Due_Overlock__c": 107,
    "Days_prior_send_invoice__c": 108,
    "Days_until_second_late_fee__c": 244,
    "Desirable_New_City__c": 109,
    "Device_Quantity__c": 85,
    "Discuss_with_our_Product_Manager__c": 59,
    "Doc_electronic_sign__c": 110,
    "DocuSignStatus__c": 64,
    "Domain_Registration_Location__c": 111,
    "Emphasize_On_Website__c": 112,
    "Est_date_opening_facility__c": 113,
    "Existing_Corp_Code__c": 205,
    "Existing_SMS_account__c": 248,
    "Expected_FMS_start_date__c": 249,
    "Explain_Auction_process__c": 114,
    "FMS_converting_from__c": 115,
    "Faciilty_Legal_Entity_Name__c": 116,
    "Facility_Cancel_List__c": 29,
    "Facility_Email__c": 117,
    "Facility_ID__c": 86,
    "Facility_Legal_City_and_State__c": 118,
    "Facility_Legal_Mailing_Street_Address__c": 119,
    "Facility_Legal_Phone__c": 120,
    "Facility_Legal_Zip_Code__c": 121,
    "Facility_State__c": 122,
    "Facility_clone__c": 206,
    "Federal_Tax_ID__c": 123,
    "First_Late_Fee__c": 124,
    "FormURL__c": 83,
    "Form_Record_Type__c": 31,
    "Full_Address__c": 87,
    "GTM_ID__c": 258,
    "Gate_Software_Provider__c": 125,
    "Gatefacility_access_hours__c": 126,
    "Google_Analytics__c": 127,
    "Google_My_Business_Listing_Question__c": 128,
    "Google_My_Business_Listing__c": 129,
    "Have_Logo_Facility__c": 130,
    "Historical_Data_Selection__c": 207,
    "Holiday_Hours__c": 131,
    "How_much_Security_Deposit__c": 132,
    "How_payments_applied__c": 133,
    "Id": 0,
    "If_Other_what_is_name_of_Gate_Provider__c": 259,
    "Insurance_Product_to_Cancel__c": 32,
    "Insuranceprotection_plan__c": 134,
    "Interest_Digital_Marketing__c": 208,
    "Interest_Sparefoot_facility__c": 209,
    "Interest_in_Data_Archive__c": 60,
    "Invoice_Method__c": 246,
    "IsDeleted": 2,
    "JotForm_Enter_Case_Number__c": 135,
    "Jotform_Submission_ID__c": 63,
    "LastModifiedById": 9,
    "LastModifiedDate": 8,
    "License_Holder__c": 210,
    "Lien_Fee__c": 136,
    "Link_SLSE_Software__c": 137,
    "List_merch_items__c": 138,
    "Loc_Code_Preference__c": 211,
    "Location_Code__c": 212,
    "Lock_Cutting_Fee__c": 139,
    "Login_Credentials__c": 140,
    "Login_For_Domain__c": 141,
    "MS_Preapplication_JotForm__c": 142,
    "ManageCompany_Ownersame__c": 213,
    "Managesoftware_convert__c": 214,
    "Merch_Provider_Facility__c": 215,
    "MerchantId__c": 88,
    "Merchant_Timezone__c": 89,
    "NSF_Fee__c": 143,
    "Name": 3,
    "Name_Facility_Purchase__c": 216,
    "Name_POS_or_FMS_used__c": 144,
    "Nearby_Landmarks__c": 145,
    "Nearby_Neighborhoods__c": 146,
    "NewWebsite_ExistingDomain__c": 217,
    "New_Access_Provider__c": 240,
    "New_Insurance_Provider_moving_to__c": 33,
    "New_Software_Platform_moving_to__c": 34,
    "New_Software_Provider__c": 242,
    "New_Website_Platform_moving_to__c": 35,
    "New_Website_Provider__c": 241,
    "Offering_Tenant_Protection_Plans__c": 245,
    "Office_hours__c": 147,
    "Onethingwecouldhavedonedifferently__c": 36,
    "OpportunityId__c": 76,
    "Other_Cancel_Access_Control__c": 37,
    "Other_Cancel_Insurance__c": 38,
    "Other_Cancel_Payment_Other_Product__c": 39,
    "Other_Cancel_Software_Product__c": 40,
    "Other_Cancel_SpareFoot__c": 41,
    "Other_Cancel_Website_Product__c": 42,
    "Other_Merch_Provider__c": 218,
    "Other_Pastdue_Event__c": 148,
    "Other_Software_Provider__c": 219,
    "Other_Website_Provider__c": 220,
    "Overlock_Fee__c": 149,
    "Overlock_PastDue_Unit__c": 150,
    "OwnerId": 1,
    "Payment_or_Other_Product_to_Cancel__c": 43,
    "Place_Lien_Units__c": 151,
    "Please_Explain__c": 252,
    "Please_provide_the_name_of_the_purchaser__c": 44,
    "Preferred_Availability__c": 254,
    "Preferred_Contact_Method__c": 256,
    "Primary_User_Email__c": 152,
    "Primary_User__c": 153,
    "Promo_discount_offer__c": 154,
    "Prorate_Rent_moveout__c": 155,
    "Prorate_moveout_days__c": 156,
    "PurchFacility_SL_SE_ESS__c": 221,
    "Purchaser_Email__c": 188,
    "Purchaser_Phone__c": 187,
    "Reason_Cancel_Access_Control__c": 45,
    "Reason_Cancel_Insurance__c": 46,
    "Reason_Cancel_Payment_or_Other_Product__c": 47,
    "Reason_Cancel_Software_Product__c": 48,
    "Reason_Cancel_SpareFoot__c": 49,
    "Reason_Cancel_Website_Product__c": 50,
    "Reason_Opting_Out_of_Auto_Protect__c": 253,
    "Reasonforleaving__c": 51,
    "Recipient_Email__c": 222,
    "Recipient_Facility_Name__c": 223,
    "Recipient_Name__c": 224,
    "RecordTypeId": 5,
    "Recur_LateFee_OneTime__c": 157,
    "Related_Record_Created__c": 52,
    "Release_Date__c": 225,
    "Release_domain_name_website__c": 226,
    "Reservation_Fee__c": 158,
    "Retail_or_Merch_sale__c": 159,
    "SLCorpCode__c": 227,
    "SLLocationCode__c": 228,
    "SSO_Interest_Level__c": 255,
    "Second_Late_Fee__c": 160,
    "Selling_or_Transfer_of_Ownership__c": 61,
    "Send_monthly_rent_invoices__c": 161,
    "Share_login_info__c": 162,
    "Signer_Date_of_Birth__c": 163,
    "Signer_Email__c": 164,
    "Signer_Home_Address__c": 165,
    "Signer_Name__c": 166,
    "Signer_Percentage_Business_Owned__c": 167,
    "Signer_Phone__c": 168,
    "Signer_Title__c": 169,
    "Software_Products_to_Cancel__c": 54,
    "Software_forwardfacility__c": 229,
    "Source__c": 55,
    "SpareFoot_Product_to_Cancel__c": 56,
    "Start_or_acquire_date_of_business__c": 170,
    "Subject__c": 57,
    "Switching_Product__c": 16,
    "SystemModstamp": 10,
    "Tax_rate_on_rent__c": 171,
    "Temperature_Controlled_Units__c": 172,
    "Tenant_Insurance_Facility__c": 230,
    "Tenant_Insurance_Provider__c": 173,
    "Top_Amenity__c": 174,
    "Transferee_Company_Name__c": 231,
    "Transferee_Email__c": 232,
    "Transferee_Phone_Number__c": 233,
    "Transferee_Primary_Contact__c": 234,
    "Type_of_Business__c": 250,
    "UA_Code__c": 175,
    "UNPW_current_software__c": 176,
    "Units__c": 235,
    "Unmanned_Facility__c": 177,
    "Upload_Business_LicenseArticle_Incorp__c": 178,
    "Upload_Logo_Brand__c": 179,
    "Upload_Logo_Website__c": 180,
    "Upload_Signer_Driver_License__c": 181,
    "Upload_Void_Check_or_Bank_Detail__c": 182,
    "Upload_custom_document__c": 183,
    "Use_Gate_Software_Provider__c": 236,
    "Use_Sparefoot_facility__c": 237,
    "WebsiteProvider_Facility__c": 238,
    "Website_Photo_Facility__c": 184,
    "Website_Products_to_Cancel__c": 58,
    "Website_URL__c": 62,
    "What_is_your_domain__c": 260,
    "Which_PoS_or_FMS_will_you_be_using__c": 251,
    "Which_Storable_Software__c": 185,
    "Your_SL_CorpCode__c": 239,
    "storEDGE_integrate2__c": 189,
    "storEDGE_integrate__c": 186
}
    • schema_attributes: 
      {
    "ACHAccountNumber__c": "string",
    "ACHInstitutionCity__c": "string",
    "ACHInstitutionName__c": "string",
    "ACHInstitutionPostalCode__c": "string",
    "ACHInstitutionRegion__c": "string",
    "ACHRoutingNumber__c": "string",
    "ACS_quotehardware__c": "string",
    "Access_Control_Competitor_moving_to__c": "string",
    "Access_Control_Products_to_Cancel__c": "string",
    "Access_Hours__c": "string",
    "Access_after_Transfer__c": "string",
    "Access_point_restrict_keypad__c": "string",
    "Accesspointrestrict__c": "string",
    "Accounting_method_use__c": "string",
    "Add_info_facility__c": "string",
    "Additional_Comment__c": "string",
    "Addtl_info_or_Qs_on_MS_account__c": "string",
    "Administrative_Fee__c": "string",
    "Already_have_domain__c": "string",
    "Amenities_Offered__c": "string",
    "Amount": "string",
    "Anticipated_Monthly_Vol_per_month__c": "string",
    "Any_Portable_Units__c": "string",
    "Anything_else_we_should_know__c": "string",
    "Archive_Option_email_address__c": "string",
    "Assist_Google_My_Business__c": "string",
    "Auction_Fee_Amount__c": "string",
    "Auction_Units__c": "string",
    "BillingCity__c": "string",
    "BillingCountry__c": "string",
    "BillingName__c": "string",
    "BillingPaymentMethod__c": "string",
    "BillingPostalCode__c": "string",
    "BillingRegion__c": "string",
    "BillingStreet__c": "string",
    "Billing_Settings__c": "string",
    "Cancel_Single_Multiple_or_All_facility__c": "string",
    "Charge_Second_Late_Fee__c": "string",
    "Charge_Security_Deposit__c": "string",
    "Clone_softwaresetting__c": "string",
    "Clone_website_namefacility__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Construction_openbusiness__c": "string",
    "Contact_Email__c": "string",
    "Contact_Name__c": "string",
    "Contact_Person_Email__c": "string",
    "Contact_Person_Name__c": "string",
    "Contact_Person_Phone__c": "string",
    "Contact_Person_Title__c": "string",
    "Contact_Phone__c": "string",
    "Continue_software_service__c": "string",
    "Convertfromspreadsheet__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_Case__c": "string",
    "CreditCardCVV__c": "string",
    "CreditCardExpiration__c": "string",
    "CreditCardName__c": "string",
    "CreditCardNetwork__c": "string",
    "CreditCardNumber__c": "string",
    "CurrencyIsoCode": "string",
    "Current_Software_Provider__c": "string",
    "Custom_document_to_use__c": "string",
    "DBA_City_and_State__c": "string",
    "DBA_Name__c": "string",
    "DBA_Phone__c": "string",
    "DBA_Physical_Address__c": "string",
    "DBA_Zip_Code__c": "string",
    "Date_Signed__c": "string",
    "Date_start_software__c": "string",
    "Date_to_be_released__c": "string",
    "Day_Past_Due_FirstFee__c": "string",
    "Day_Past_Due_Notice__c": "string",
    "Days_Past_Due_Lien__c": "string",
    "Days_Past_Due_Locktenant__c": "string",
    "Days_Past_Due_Overlock__c": "string",
    "Days_prior_send_invoice__c": "string",
    "Days_until_second_late_fee__c": "string",
    "Desirable_New_City__c": "string",
    "Device_Quantity__c": "string",
    "Discuss_with_our_Product_Manager__c": "string",
    "Doc_electronic_sign__c": "string",
    "DocuSignStatus__c": "string",
    "Domain_Registration_Location__c": "string",
    "Emphasize_On_Website__c": "string",
    "Est_date_opening_facility__c": "string",
    "Existing_Corp_Code__c": "string",
    "Existing_SMS_account__c": "string",
    "ExpectedRevenue": "string",
    "Expected_FMS_start_date__c": "string",
    "Explain_Auction_process__c": "string",
    "FMS_converting_from__c": "string",
    "Faciilty_Legal_Entity_Name__c": "string",
    "Facility_Cancel_List__c": "string",
    "Facility_Email__c": "string",
    "Facility_ID__c": "string",
    "Facility_Legal_City_and_State__c": "string",
    "Facility_Legal_Mailing_Street_Address__c": "string",
    "Facility_Legal_Phone__c": "string",
    "Facility_Legal_Zip_Code__c": "string",
    "Facility_State__c": "string",
    "Facility_clone__c": "string",
    "Federal_Tax_ID__c": "string",
    "First_Late_Fee__c": "string",
    "ForecastCategory": "string",
    "FormURL__c": "string",
    "Form_Record_Type__c": "string",
    "Full_Address__c": "string",
    "GTM_ID__c": "string",
    "Gate_Software_Provider__c": "string",
    "Gatefacility_access_hours__c": "string",
    "Google_Analytics__c": "string",
    "Google_My_Business_Listing_Question__c": "string",
    "Google_My_Business_Listing__c": "string",
    "Have_Logo_Facility__c": "string",
    "Historical_Data_Selection__c": "string",
    "Holiday_Hours__c": "string",
    "How_much_Security_Deposit__c": "string",
    "How_payments_applied__c": "string",
    "Id": "string",
    "If_Other_what_is_name_of_Gate_Provider__c": "string",
    "Insurance_Product_to_Cancel__c": "string",
    "Insuranceprotection_plan__c": "string",
    "Interest_Digital_Marketing__c": "string",
    "Interest_Sparefoot_facility__c": "string",
    "Interest_in_Data_Archive__c": "string",
    "Invoice_Method__c": "string",
    "IsDeleted": "string",
    "JotForm_Enter_Case_Number__c": "string",
    "Jotform_Submission_ID__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "License_Holder__c": "string",
    "Lien_Fee__c": "string",
    "Link_SLSE_Software__c": "string",
    "List_merch_items__c": "string",
    "Loc_Code_Preference__c": "string",
    "Location_Code__c": "string",
    "Lock_Cutting_Fee__c": "string",
    "Login_Credentials__c": "string",
    "Login_For_Domain__c": "string",
    "MS_Preapplication_JotForm__c": "string",
    "ManageCompany_Ownersame__c": "string",
    "Managesoftware_convert__c": "string",
    "Merch_Provider_Facility__c": "string",
    "MerchantId__c": "string",
    "Merchant_Timezone__c": "string",
    "NSF_Fee__c": "string",
    "Name": "string",
    "Name_Facility_Purchase__c": "string",
    "Name_POS_or_FMS_used__c": "string",
    "Nearby_Landmarks__c": "string",
    "Nearby_Neighborhoods__c": "string",
    "NewWebsite_ExistingDomain__c": "string",
    "New_Access_Provider__c": "string",
    "New_Insurance_Provider_moving_to__c": "string",
    "New_Software_Platform_moving_to__c": "string",
    "New_Software_Provider__c": "string",
    "New_Website_Platform_moving_to__c": "string",
    "New_Website_Provider__c": "string",
    "Offering_Tenant_Protection_Plans__c": "string",
    "Office_hours__c": "string",
    "Onethingwecouldhavedonedifferently__c": "string",
    "OpportunityId": "string",
    "OpportunityId__c": "string",
    "Other_Cancel_Access_Control__c": "string",
    "Other_Cancel_Insurance__c": "string",
    "Other_Cancel_Payment_Other_Product__c": "string",
    "Other_Cancel_Software_Product__c": "string",
    "Other_Cancel_SpareFoot__c": "string",
    "Other_Cancel_Website_Product__c": "string",
    "Other_Merch_Provider__c": "string",
    "Other_Pastdue_Event__c": "string",
    "Other_Software_Provider__c": "string",
    "Other_Website_Provider__c": "string",
    "Overlock_Fee__c": "string",
    "Overlock_PastDue_Unit__c": "string",
    "OwnerId": "string",
    "Payment_or_Other_Product_to_Cancel__c": "string",
    "Place_Lien_Units__c": "string",
    "Please_Explain__c": "string",
    "Please_provide_the_name_of_the_purchaser__c": "string",
    "Preferred_Availability__c": "string",
    "Preferred_Contact_Method__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_User_Email__c": "string",
    "Primary_User__c": "string",
    "Probability": "string",
    "Promo_discount_offer__c": "string",
    "Prorate_Rent_moveout__c": "string",
    "Prorate_moveout_days__c": "string",
    "PurchFacility_SL_SE_ESS__c": "string",
    "Purchaser_Email__c": "string",
    "Purchaser_Phone__c": "string",
    "Reason_Cancel_Access_Control__c": "string",
    "Reason_Cancel_Insurance__c": "string",
    "Reason_Cancel_Payment_or_Other_Product__c": "string",
    "Reason_Cancel_Software_Product__c": "string",
    "Reason_Cancel_SpareFoot__c": "string",
    "Reason_Cancel_Website_Product__c": "string",
    "Reason_Opting_Out_of_Auto_Protect__c": "string",
    "Reasonforleaving__c": "string",
    "Recipient_Email__c": "string",
    "Recipient_Facility_Name__c": "string",
    "Recipient_Name__c": "string",
    "RecordTypeId": "string",
    "Recur_LateFee_OneTime__c": "string",
    "Related_Record_Created__c": "string",
    "Release_Date__c": "string",
    "Release_domain_name_website__c": "string",
    "Reservation_Fee__c": "string",
    "Retail_or_Merch_sale__c": "string",
    "SLCorpCode__c": "string",
    "SLLocationCode__c": "string",
    "SSO_Interest_Level__c": "string",
    "Second_Late_Fee__c": "string",
    "Selling_or_Transfer_of_Ownership__c": "string",
    "Send_monthly_rent_invoices__c": "string",
    "Share_login_info__c": "string",
    "Signer_Date_of_Birth__c": "string",
    "Signer_Email__c": "string",
    "Signer_Home_Address__c": "string",
    "Signer_Name__c": "string",
    "Signer_Percentage_Business_Owned__c": "string",
    "Signer_Phone__c": "string",
    "Signer_Title__c": "string",
    "Software_Products_to_Cancel__c": "string",
    "Software_forwardfacility__c": "string",
    "Source__c": "string",
    "SpareFoot_Product_to_Cancel__c": "string",
    "StageName": "string",
    "Start_or_acquire_date_of_business__c": "string",
    "Subject__c": "string",
    "Switching_Product__c": "string",
    "SystemModstamp": "string",
    "Tax_rate_on_rent__c": "string",
    "Temperature_Controlled_Units__c": "string",
    "Tenant_Insurance_Facility__c": "string",
    "Tenant_Insurance_Provider__c": "string",
    "Top_Amenity__c": "string",
    "Transferee_Company_Name__c": "string",
    "Transferee_Email__c": "string",
    "Transferee_Phone_Number__c": "string",
    "Transferee_Primary_Contact__c": "string",
    "Type_of_Business__c": "string",
    "UA_Code__c": "string",
    "UNPW_current_software__c": "string",
    "Units__c": "string",
    "Unmanned_Facility__c": "string",
    "Upload_Business_LicenseArticle_Incorp__c": "string",
    "Upload_Logo_Brand__c": "string",
    "Upload_Logo_Website__c": "string",
    "Upload_Signer_Driver_License__c": "string",
    "Upload_Void_Check_or_Bank_Detail__c": "string",
    "Upload_custom_document__c": "string",
    "Use_Gate_Software_Provider__c": "string",
    "Use_Sparefoot_facility__c": "string",
    "WebsiteProvider_Facility__c": "string",
    "Website_Photo_Facility__c": "string",
    "Website_Products_to_Cancel__c": "string",
    "Website_URL__c": "string",
    "What_is_your_domain__c": "string",
    "Which_PoS_or_FMS_will_you_be_using__c": "string",
    "Which_Storable_Software__c": "string",
    "Your_SL_CorpCode__c": "string",
    "storEDGE_integrate2__c": "string",
    "storEDGE_integrate__c": "string"
}
    • schema_name_id: 2060
    • schema_scan_id: 6251292
    • updated: 2023-08-16 09:31:45
Schema Scans: 5
Last at 2024-06-10 15:35:40
    • duration: 0:00:23.188327
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6510750
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-dev",
        "hive_path": "s3://sfdl-csv-salesforce-dev/raw/form_response__cs/2024-06-10/1718051367",
        "key": "raw/form_response__cs/2024-06-10/1718051367/form_response__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_form_response__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4767443459973667720,
        "service_name": "drive-thru",
        "span_id": 18169720349811158524,
        "trace_id": 5637525643771681616
    }
}
    • running: False
    • schema_name_id: 2060
    • start_time: 2024-06-10 15:35:40
    • success: True
    • trace_id: 5637525643771681616
    • duration: 0:00:22.440629
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6402602
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-dev",
        "hive_path": "s3://sfdl-csv-salesforce-dev/raw/form_response__cs/2024-01-11/1704985681",
        "key": "raw/form_response__cs/2024-01-11/1704985681/form_response__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_form_response__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6183200464714261958,
        "service_name": "drive-thru",
        "span_id": 15269261816570639049,
        "trace_id": 8847843676900768930
    }
}
    • running: False
    • schema_name_id: 2060
    • start_time: 2024-01-11 09:08:37
    • success: True
    • trace_id: 8847843676900768930
    • duration: 0:00:18.994143
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6251516
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-dev",
        "hive_path": "s3://sfdl-csv-salesforce-dev/raw/form_response__cs/2023-08-16/1692202316",
        "key": "raw/form_response__cs/2023-08-16/1692202316/form_response__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_form_response__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 475078375040436293,
        "service_name": "drive-thru",
        "span_id": 9536216581318662699,
        "trace_id": 3942633129936880882
    }
}
    • running: False
    • schema_name_id: 2060
    • start_time: 2023-08-16 11:16:29
    • success: True
    • trace_id: 3942633129936880882
    • duration: 0:00:18.755248
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6251353
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-dev",
        "hive_path": "s3://sfdl-csv-salesforce-dev/raw/form_response__cs/2023-08-16/1692199578",
        "key": "raw/form_response__cs/2023-08-16/1692199578/form_response__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_form_response__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8067563464301080211,
        "service_name": "drive-thru",
        "span_id": 13949300888118313596,
        "trace_id": 11451044869069217814
    }
}
    • running: False
    • schema_name_id: 2060
    • start_time: 2023-08-16 10:27:22
    • success: True
    • trace_id: 11451044869069217814
    • duration: 0:00:18.810239
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6251292
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-dev",
        "hive_path": "s3://sfdl-csv-salesforce-dev/raw/form_response__cs/2023-08-16/1692195981",
        "key": "raw/form_response__cs/2023-08-16/1692195981/form_response__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_form_response__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16034136658236143279,
        "service_name": "drive-thru",
        "span_id": 4102785281125507221,
        "trace_id": 1334535244353464852
    }
}
    • running: False
    • schema_name_id: 2060
    • start_time: 2023-08-16 09:31:26
    • success: True
    • trace_id: 1334535244353464852
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "ACHAccountNumber__c": "string",
    "ACHInstitutionCity__c": "string",
    "ACHInstitutionName__c": "string",
    "ACHInstitutionPostalCode__c": "string",
    "ACHInstitutionRegion__c": "string",
    "ACHRoutingNumber__c": "string",
    "ACS_quotehardware__c": "string",
    "Access_Control_Competitor_moving_to__c": "string",
    "Access_Control_Products_to_Cancel__c": "string",
    "Access_Hours__c": "string",
    "Access_after_Transfer__c": "string",
    "Access_point_restrict_keypad__c": "string",
    "Accesspointrestrict__c": "string",
    "Account_Record_Type__c": "string",
    "Account_Status__c": "string",
    "Account_Type__c": "string",
    "Account__c": "string",
    "Accounting_method_use__c": "string",
    "Add_info_facility__c": "string",
    "Additional_Comment__c": "string",
    "Addtl_info_or_Qs_on_MS_account__c": "string",
    "Administrative_Fee__c": "string",
    "Already_have_domain__c": "string",
    "Amenities_Offered__c": "string",
    "Amount": "string",
    "Anticipated_Monthly_Vol_per_month__c": "string",
    "Any_Portable_Units__c": "string",
    "Anything_else_we_should_know__c": "string",
    "Archive_Option_email_address__c": "string",
    "Assist_Google_My_Business__c": "string",
    "Auction_Fee_Amount__c": "string",
    "Auction_Units__c": "string",
    "BillingCity__c": "string",
    "BillingCountry__c": "string",
    "BillingName__c": "string",
    "BillingPaymentMethod__c": "string",
    "BillingPostalCode__c": "string",
    "BillingRegion__c": "string",
    "BillingStreet__c": "string",
    "Billing_Settings__c": "string",
    "Business_Country__c": "string",
    "Business_Registration_Number__c": "string",
    "CP_Company_ID__c": "string",
    "CP_Location_ID__c": "string",
    "CP_Products_Being_Purchased__c": "string",
    "CallPotential_Cancellation_Reason__c": "string",
    "CallPotential_Products_to_Cancel__c": "string",
    "CallPotential_going_forward_at_facility__c": "string",
    "CallPotential_interested_in_at_facility__c": "string",
    "Cancel_Single_Multiple_or_All_facility__c": "string",
    "Charge_Second_Late_Fee__c": "string",
    "Charge_Security_Deposit__c": "string",
    "Clone_softwaresetting__c": "string",
    "Clone_website_namefacility__c": "string",
    "CloseDate": "string",
    "Company_Status__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Construction_openbusiness__c": "string",
    "Contact_Email__c": "string",
    "Contact_Name__c": "string",
    "Contact_Person_Email__c": "string",
    "Contact_Person_Name__c": "string",
    "Contact_Person_Phone__c": "string",
    "Contact_Person_Title__c": "string",
    "Contact_Phone__c": "string",
    "Contact_Title__c": "string",
    "Continue_software_service__c": "string",
    "Convertfromspreadsheet__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_Case__c": "string",
    "CreditCardCVV__c": "string",
    "CreditCardExpiration__c": "string",
    "CreditCardName__c": "string",
    "CreditCardNetwork__c": "string",
    "CreditCardNumber__c": "string",
    "CurrencyIsoCode": "string",
    "Current_Software_Provider__c": "string",
    "Custom_document_to_use__c": "string",
    "DBA_City_and_State__c": "string",
    "DBA_Name__c": "string",
    "DBA_Phone__c": "string",
    "DBA_Physical_Address__c": "string",
    "DBA_Zip_Code__c": "string",
    "Date_Signed__c": "string",
    "Date_start_software__c": "string",
    "Date_to_be_released__c": "string",
    "Day_Past_Due_FirstFee__c": "string",
    "Day_Past_Due_Notice__c": "string",
    "Days_Past_Due_Lien__c": "string",
    "Days_Past_Due_Locktenant__c": "string",
    "Days_Past_Due_Overlock__c": "string",
    "Days_prior_send_invoice__c": "string",
    "Days_until_second_late_fee__c": "string",
    "Desirable_New_City__c": "string",
    "Device_Quantity__c": "string",
    "Discuss_with_our_Product_Manager__c": "string",
    "Doc_electronic_sign__c": "string",
    "DocuSignStatus__c": "string",
    "Domain_Registration_Location__c": "string",
    "Emphasize_On_Website__c": "string",
    "Est_date_opening_facility__c": "string",
    "Existing_Corp_Code__c": "string",
    "Existing_SMS_account__c": "string",
    "ExpectedRevenue": "string",
    "Expected_FMS_start_date__c": "string",
    "Explain_Auction_process__c": "string",
    "FMS_converting_from__c": "string",
    "Faciilty_Legal_Entity_Name__c": "string",
    "Facility_Cancel_List__c": "string",
    "Facility_Email__c": "string",
    "Facility_ID__c": "string",
    "Facility_Legal_City_and_State__c": "string",
    "Facility_Legal_Mailing_Street_Address__c": "string",
    "Facility_Legal_Phone__c": "string",
    "Facility_Legal_Zip_Code__c": "string",
    "Facility_Name__c": "string",
    "Facility_Phone_Number__c": "string",
    "Facility_State__c": "string",
    "Facility_clone__c": "string",
    "Federal_Tax_ID__c": "string",
    "First_Late_Fee__c": "string",
    "ForecastCategory": "string",
    "FormURL__c": "string",
    "Form_Record_Type__c": "string",
    "Full_Address__c": "string",
    "GTM_ID__c": "string",
    "Gate_Software_Provider__c": "string",
    "Gatefacility_access_hours__c": "string",
    "Gmail_for_GA__c": "string",
    "Google_Analytics__c": "string",
    "Google_My_Business_Listing_Question__c": "string",
    "Google_My_Business_Listing__c": "string",
    "Have_Logo_Facility__c": "string",
    "Historical_Data_Selection__c": "string",
    "Holiday_Hours__c": "string",
    "How_much_Security_Deposit__c": "string",
    "How_payments_applied__c": "string",
    "Id": "string",
    "If_Other_Amenities__c": "string",
    "If_Other_what_is_name_of_Gate_Provider__c": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "Insurance_Product_to_Cancel__c": "string",
    "Insuranceprotection_plan__c": "string",
    "Integration_Permission_True__c": "string",
    "Interest_Digital_Marketing__c": "string",
    "Interest_Sparefoot_facility__c": "string",
    "Interest_in_CallPotential__c": "string",
    "Interest_in_Data_Archive__c": "string",
    "Interest_in_Data_Decryption__c": "string",
    "Invoice_Method__c": "string",
    "IsDeleted": "string",
    "JotForm_Enter_Case_Number__c": "string",
    "Jotform_Submission_ID__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "License_Holder__c": "string",
    "Lien_Fee__c": "string",
    "Link_SLSE_Software__c": "string",
    "List_merch_items__c": "string",
    "Loc_Code_Preference__c": "string",
    "Location_Code__c": "string",
    "Location_Country__c": "string",
    "Lock_Cutting_Fee__c": "string",
    "Login_Credentials__c": "string",
    "Login_For_Domain__c": "string",
    "MS_Preapplication_JotForm__c": "string",
    "ManageCompany_Ownersame__c": "string",
    "Management_Software__c": "string",
    "Managesoftware_convert__c": "string",
    "Maximum_Usage__c": "string",
    "Merch_Provider_Facility__c": "string",
    "MerchantId__c": "string",
    "Merchant_Timezone__c": "string",
    "Modules_Launching__c": "string",
    "NSF_Fee__c": "string",
    "Name": "string",
    "Name_Facility_Purchase__c": "string",
    "Name_POS_or_FMS_used__c": "string",
    "Nearby_Landmarks__c": "string",
    "Nearby_Neighborhoods__c": "string",
    "NewWebsite_ExistingDomain__c": "string",
    "New_Access_Provider__c": "string",
    "New_Insurance_Provider_Other__c": "string",
    "New_Insurance_Provider__c": "string",
    "New_Insurance_Provider_moving_to__c": "string",
    "New_Software_Platform_moving_to__c": "string",
    "New_Software_Provider__c": "string",
    "New_Website_Platform_moving_to__c": "string",
    "New_Website_Provider__c": "string",
    "Offering_Tenant_Protection_Plans__c": "string",
    "Office_hours__c": "string",
    "Onethingwecouldhavedonedifferently__c": "string",
    "OpportunityId": "string",
    "OpportunityId__c": "string",
    "Opportunity_Type__c": "string",
    "Other_CallPotential_Cancellation_Details__c": "string",
    "Other_Cancel_Access_Control__c": "string",
    "Other_Cancel_Insurance__c": "string",
    "Other_Cancel_Payment_Other_Product__c": "string",
    "Other_Cancel_Software_Product__c": "string",
    "Other_Cancel_SpareFoot__c": "string",
    "Other_Cancel_Website_Product__c": "string",
    "Other_Domain_Registration__c": "string",
    "Other_Merch_Provider__c": "string",
    "Other_Pastdue_Event__c": "string",
    "Other_Software_Provider__c": "string",
    "Other_Website_Provider__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "Overlock_Fee__c": "string",
    "Overlock_PastDue_Unit__c": "string",
    "OwnerId": "string",
    "Parent_Corp_Account_Name__c": "string",
    "Payment_Cutoff_Days__c": "string",
    "Payment_or_Other_Product_to_Cancel__c": "string",
    "Per_Minute_Usage__c": "string",
    "Place_Lien_Units__c": "string",
    "Please_Explain__c": "string",
    "Please_provide_the_name_of_the_purchaser__c": "string",
    "Preferred_Availability__c": "string",
    "Preferred_Contact_Method__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_User_Email__c": "string",
    "Primary_User__c": "string",
    "Probability": "string",
    "Promo_discount_offer__c": "string",
    "Prorate_Rent_moveout__c": "string",
    "Prorate_moveout_days__c": "string",
    "PurchFacility_SL_SE_ESS__c": "string",
    "Purchaser_Email__c": "string",
    "Purchaser_Phone__c": "string",
    "Reason_Cancel_Access_Control__c": "string",
    "Reason_Cancel_Insurance__c": "string",
    "Reason_Cancel_Payment_or_Other_Product__c": "string",
    "Reason_Cancel_Software_Product__c": "string",
    "Reason_Cancel_SpareFoot__c": "string",
    "Reason_Cancel_Website_Product__c": "string",
    "Reason_Opting_Out_of_Auto_Protect__c": "string",
    "Reasonforleaving__c": "string",
    "Recipient_Email__c": "string",
    "Recipient_Facility_Name__c": "string",
    "Recipient_Name__c": "string",
    "RecordTypeId": "string",
    "Recur_LateFee_OneTime__c": "string",
    "Related_Record_Created__c": "string",
    "Release_Date__c": "string",
    "Release_domain_name_website__c": "string",
    "Reservation_Fee__c": "string",
    "Retail_or_Merch_sale__c": "string",
    "SE_Company_UUID__c": "string",
    "SE_Facility_UUID__c": "string",
    "SLCorpCode__c": "string",
    "SLLocationCode__c": "string",
    "SSO_Interest_Level__c": "string",
    "Sales_Team_Member__c": "string",
    "Second_Late_Fee__c": "string",
    "Selling_or_Transfer_of_Ownership__c": "string",
    "Send_monthly_rent_invoices__c": "string",
    "Share_login_info__c": "string",
    "Signer_Date_of_Birth__c": "string",
    "Signer_Email__c": "string",
    "Signer_Home_Address__c": "string",
    "Signer_Name__c": "string",
    "Signer_Percentage_Business_Owned__c": "string",
    "Signer_Phone__c": "string",
    "Signer_Title__c": "string",
    "Software_Products_to_Cancel__c": "string",
    "Software_forwardfacility__c": "string",
    "Source__c": "string",
    "SpareFoot_Product_to_Cancel__c": "string",
    "StageName": "string",
    "Start_or_acquire_date_of_business__c": "string",
    "Stock_Ticker_Exchange__c": "string",
    "Subject__c": "string",
    "Submission_Date__c": "string",
    "Switching_Product__c": "string",
    "SystemModstamp": "string",
    "Tax_rate_on_rent__c": "string",
    "Temperature_Controlled_Units__c": "string",
    "Tenant_Insurance_Facility__c": "string",
    "Tenant_Insurance_Provider__c": "string",
    "Top_Amenity__c": "string",
    "Total_of_Locations__c": "string",
    "Tracked_Recorded_Line__c": "string",
    "Transferee_Company_Name__c": "string",
    "Transferee_Email__c": "string",
    "Transferee_Phone_Number__c": "string",
    "Transferee_Primary_Contact__c": "string",
    "Type_of_Business__c": "string",
    "UA_Code__c": "string",
    "UNPW_current_software__c": "string",
    "Units__c": "string",
    "Unmanned_Facility__c": "string",
    "Upload_Business_LicenseArticle_Incorp__c": "string",
    "Upload_Logo_Brand__c": "string",
    "Upload_Logo_Website__c": "string",
    "Upload_Signer_Driver_License__c": "string",
    "Upload_Void_Check_or_Bank_Detail__c": "string",
    "Upload_custom_document__c": "string",
    "Use_Gate_Software_Provider__c": "string",
    "Use_Sparefoot_facility__c": "string",
    "WebsiteProvider_Facility__c": "string",
    "Website_Photo_Facility__c": "string",
    "Website_Products_to_Cancel__c": "string",
    "Website_URL__c": "string",
    "What_is_your_domain__c": "string",
    "Where_is_Domain_Registered__c": "string",
    "Which_PoS_or_FMS_will_you_be_using__c": "string",
    "Which_Storable_Software__c": "string",
    "Your_SL_CorpCode__c": "string",
    "of_Locations_Onboarding__c": "string",
    "storEDGE_integrate2__c": "string",
    "storEDGE_integrate__c": "string"
}
  • created: 2024-06-10 15:35:50
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_form_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Access_Control_Competitor_moving_to__c`  string , `Access_Control_Products_to_Cancel__c`  string , `Anything_else_we_should_know__c`  string , `Switching_Product__c`  string , `Cancel_Single_Multiple_or_All_facility__c`  string , `Access_Hours__c`  string , `Accounting_method_use__c`  string , `Add_info_facility__c`  string , `Administrative_Fee__c`  string , `Already_have_domain__c`  string , `Amenities_Offered__c`  string , `Contact_Email__c`  string , `Contact_Name__c`  string , `Contact_Phone__c`  string , `Created_Case__c`  string , `Anticipated_Monthly_Vol_per_month__c`  string , `Facility_Cancel_List__c`  string , `Assist_Google_My_Business__c`  string , `Form_Record_Type__c`  string , `Insurance_Product_to_Cancel__c`  string , `New_Insurance_Provider_moving_to__c`  string , `New_Software_Platform_moving_to__c`  string , `New_Website_Platform_moving_to__c`  string , `Onethingwecouldhavedonedifferently__c`  string , `Other_Cancel_Access_Control__c`  string , `Other_Cancel_Insurance__c`  string , `Other_Cancel_Payment_Other_Product__c`  string , `Other_Cancel_Software_Product__c`  string , `Other_Cancel_SpareFoot__c`  string , `Other_Cancel_Website_Product__c`  string , `Payment_or_Other_Product_to_Cancel__c`  string , `Please_provide_the_name_of_the_purchaser__c`  string , `Reason_Cancel_Access_Control__c`  string , `Reason_Cancel_Insurance__c`  string , `Reason_Cancel_Payment_or_Other_Product__c`  string , `Reason_Cancel_Software_Product__c`  string , `Reason_Cancel_SpareFoot__c`  string , `Reason_Cancel_Website_Product__c`  string , `Reasonforleaving__c`  string , `Related_Record_Created__c`  string , `Auction_Units__c`  string , `Software_Products_to_Cancel__c`  string , `Source__c`  string , `SpareFoot_Product_to_Cancel__c`  string , `Subject__c`  string , `Website_Products_to_Cancel__c`  string , `Discuss_with_our_Product_Manager__c`  string , `Interest_in_Data_Archive__c`  string , `Selling_or_Transfer_of_Ownership__c`  string , `Website_URL__c`  string , `Jotform_Submission_ID__c`  string , `DocuSignStatus__c`  string , `CreditCardNumber__c`  string , `CreditCardExpiration__c`  string , `CreditCardNetwork__c`  string , `CreditCardName__c`  string , `BillingName__c`  string , `BillingCity__c`  string , `BillingCountry__c`  string , `BillingPostalCode__c`  string , `BillingRegion__c`  string , `BillingStreet__c`  string , `BillingPaymentMethod__c`  string , `OpportunityId__c`  string , `ACHAccountNumber__c`  string , `ACHRoutingNumber__c`  string , `ACHInstitutionCity__c`  string , `ACHInstitutionName__c`  string , `ACHInstitutionPostalCode__c`  string , `ACHInstitutionRegion__c`  string , `FormURL__c`  string , `Billing_Settings__c`  string , `Device_Quantity__c`  string , `Facility_ID__c`  string , `Full_Address__c`  string , `MerchantId__c`  string , `Merchant_Timezone__c`  string , `Charge_Second_Late_Fee__c`  string , `Charge_Security_Deposit__c`  string , `Contact_Person_Email__c`  string , `Contact_Person_Name__c`  string , `Contact_Person_Phone__c`  string , `Contact_Person_Title__c`  string , `Custom_document_to_use__c`  string , `DBA_City_and_State__c`  string , `DBA_Name__c`  string , `DBA_Phone__c`  string , `DBA_Physical_Address__c`  string , `DBA_Zip_Code__c`  string , `Date_start_software__c`  string , `Day_Past_Due_FirstFee__c`  string , `Day_Past_Due_Notice__c`  string , `Days_Past_Due_Lien__c`  string , `Days_Past_Due_Locktenant__c`  string , `Days_Past_Due_Overlock__c`  string , `Days_prior_send_invoice__c`  string , `Desirable_New_City__c`  string , `Doc_electronic_sign__c`  string , `Domain_Registration_Location__c`  string , `Emphasize_On_Website__c`  string , `Est_date_opening_facility__c`  string , `Explain_Auction_process__c`  string , `FMS_converting_from__c`  string , `Faciilty_Legal_Entity_Name__c`  string , `Facility_Email__c`  string , `Facility_Legal_City_and_State__c`  string , `Facility_Legal_Mailing_Street_Address__c`  string , `Facility_Legal_Phone__c`  string , `Facility_Legal_Zip_Code__c`  string , `Facility_State__c`  string , `Federal_Tax_ID__c`  string , `First_Late_Fee__c`  string , `Gate_Software_Provider__c`  string , `Gatefacility_access_hours__c`  string , `Google_Analytics__c`  string , `Google_My_Business_Listing_Question__c`  string , `Google_My_Business_Listing__c`  string , `Have_Logo_Facility__c`  string , `Holiday_Hours__c`  string , `How_much_Security_Deposit__c`  string , `How_payments_applied__c`  string , `Insuranceprotection_plan__c`  string , `JotForm_Enter_Case_Number__c`  string , `Lien_Fee__c`  string , `Link_SLSE_Software__c`  string , `List_merch_items__c`  string , `Lock_Cutting_Fee__c`  string , `Login_Credentials__c`  string , `Login_For_Domain__c`  string , `MS_Preapplication_JotForm__c`  string , `NSF_Fee__c`  string , `Name_POS_or_FMS_used__c`  string , `Nearby_Landmarks__c`  string , `Nearby_Neighborhoods__c`  string , `Office_hours__c`  string , `Other_Pastdue_Event__c`  string , `Overlock_Fee__c`  string , `Overlock_PastDue_Unit__c`  string , `Place_Lien_Units__c`  string , `Primary_User_Email__c`  string , `Primary_User__c`  string , `Promo_discount_offer__c`  string , `Prorate_Rent_moveout__c`  string , `Prorate_moveout_days__c`  string , `Recur_LateFee_OneTime__c`  string , `Reservation_Fee__c`  string , `Retail_or_Merch_sale__c`  string , `Second_Late_Fee__c`  string , `Send_monthly_rent_invoices__c`  string , `Share_login_info__c`  string , `Signer_Date_of_Birth__c`  string , `Signer_Email__c`  string , `Signer_Home_Address__c`  string , `Signer_Name__c`  string , `Signer_Percentage_Business_Owned__c`  string , `Signer_Phone__c`  string , `Signer_Title__c`  string , `Start_or_acquire_date_of_business__c`  string , `Tax_rate_on_rent__c`  string , `Temperature_Controlled_Units__c`  string , `Tenant_Insurance_Provider__c`  string , `Top_Amenity__c`  string , `UA_Code__c`  string , `UNPW_current_software__c`  string , `Unmanned_Facility__c`  string , `Upload_Business_LicenseArticle_Incorp__c`  string , `Upload_Logo_Brand__c`  string , `Upload_Logo_Website__c`  string , `Upload_Signer_Driver_License__c`  string , `Upload_Void_Check_or_Bank_Detail__c`  string , `Upload_custom_document__c`  string , `Website_Photo_Facility__c`  string , `Which_Storable_Software__c`  string , `storEDGE_integrate__c`  string , `Purchaser_Phone__c`  string , `Purchaser_Email__c`  string , `storEDGE_integrate2__c`  string , `ACS_quotehardware__c`  string , `Access_after_Transfer__c`  string , `Access_point_restrict_keypad__c`  string , `Accesspointrestrict__c`  string , `Additional_Comment__c`  string , `Any_Portable_Units__c`  string , `Archive_Option_email_address__c`  string , `Clone_softwaresetting__c`  string , `Clone_website_namefacility__c`  string , `Construction_openbusiness__c`  string , `Continue_software_service__c`  string , `Convertfromspreadsheet__c`  string , `Current_Software_Provider__c`  string , `Date_Signed__c`  string , `Date_to_be_released__c`  string , `Existing_Corp_Code__c`  string , `Facility_clone__c`  string , `Historical_Data_Selection__c`  string , `Interest_Digital_Marketing__c`  string , `Interest_Sparefoot_facility__c`  string , `License_Holder__c`  string , `Loc_Code_Preference__c`  string , `Location_Code__c`  string , `ManageCompany_Ownersame__c`  string , `Managesoftware_convert__c`  string , `Merch_Provider_Facility__c`  string , `Name_Facility_Purchase__c`  string , `NewWebsite_ExistingDomain__c`  string , `Other_Merch_Provider__c`  string , `Other_Software_Provider__c`  string , `Other_Website_Provider__c`  string , `PurchFacility_SL_SE_ESS__c`  string , `Recipient_Email__c`  string , `Recipient_Facility_Name__c`  string , `Recipient_Name__c`  string , `Release_Date__c`  string , `Release_domain_name_website__c`  string , `SLCorpCode__c`  string , `SLLocationCode__c`  string , `Software_forwardfacility__c`  string , `Tenant_Insurance_Facility__c`  string , `Transferee_Company_Name__c`  string , `Transferee_Email__c`  string , `Transferee_Phone_Number__c`  string , `Transferee_Primary_Contact__c`  string , `Units__c`  string , `Use_Gate_Software_Provider__c`  string , `Use_Sparefoot_facility__c`  string , `WebsiteProvider_Facility__c`  string , `Your_SL_CorpCode__c`  string , `New_Access_Provider__c`  string , `New_Website_Provider__c`  string , `New_Software_Provider__c`  string , `Auction_Fee_Amount__c`  string , `Days_until_second_late_fee__c`  string , `Offering_Tenant_Protection_Plans__c`  string , `Invoice_Method__c`  string , `Addtl_info_or_Qs_on_MS_account__c`  string , `Existing_SMS_account__c`  string , `Expected_FMS_start_date__c`  string , `Type_of_Business__c`  string , `Which_PoS_or_FMS_will_you_be_using__c`  string , `Please_Explain__c`  string , `Reason_Opting_Out_of_Auto_Protect__c`  string , `Preferred_Availability__c`  string , `SSO_Interest_Level__c`  string , `Preferred_Contact_Method__c`  string , `CreditCardCVV__c`  string , `GTM_ID__c`  string , `If_Other_what_is_name_of_Gate_Provider__c`  string , `What_is_your_domain__c`  string , `Facility_Phone_Number__c`  string , `Gmail_for_GA__c`  string , `SE_Company_UUID__c`  string , `SE_Facility_UUID__c`  string , `Submission_Date__c`  string , `Sales_Team_Member__c`  string , `Company_Status__c`  string , `Stock_Ticker_Exchange__c`  string , `Contact_Title__c`  string , `Account__c`  string , `Interest_in_Data_Decryption__c`  string , `Payment_Cutoff_Days__c`  string , `CallPotential_Cancellation_Reason__c`  string , `Total_of_Locations__c`  string , `of_Locations_Onboarding__c`  string , `Modules_Launching__c`  string , `Management_Software__c`  string , `CallPotential_Products_to_Cancel__c`  string , `Other_CallPotential_Cancellation_Details__c`  string , `Business_Country__c`  string , `Location_Country__c`  string , `New_Insurance_Provider_Other__c`  string , `Business_Registration_Number__c`  string , `Tracked_Recorded_Line__c`  string , `Integration_Permission_True__c`  string , `New_Insurance_Provider__c`  string , `CallPotential_going_forward_at_facility__c`  string , `CallPotential_interested_in_at_facility__c`  string , `Interest_in_CallPotential__c`  string , `Account_Record_Type__c`  string , `Account_Status__c`  string , `Account_Type__c`  string , `CP_Company_ID__c`  string , `CP_Location_ID__c`  string , `CP_Products_Being_Purchased__c`  string , `Facility_Name__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Maximum_Usage__c`  string , `Opportunity_Type__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Parent_Corp_Account_Name__c`  string , `Per_Minute_Usage__c`  string , `If_Other_Amenities__c`  string , `Other_Domain_Registration__c`  string , `Where_is_Domain_Registered__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-dev/raw/form_response__cs/2024-06-10/1718051367'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_form_response__cs`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_form_response__cs"
}
Server:
  • hostname: schemamanager-5447774fc6-4w58v
  • name: schema_manager
  • process_start: 2026-04-02 21:43:44
  • sf_env: dev
  • version: 2427328685
Raw: 
{
    "name": {
        "created": "2022-10-24 14:52:26",
        "disabled": false,
        "format": "raw",
        "id": 2060,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "salesforce_form_response__cs"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "ACHAccountNumber__c": "string",
            "ACHInstitutionCity__c": "string",
            "ACHInstitutionName__c": "string",
            "ACHInstitutionPostalCode__c": "string",
            "ACHInstitutionRegion__c": "string",
            "ACHRoutingNumber__c": "string",
            "ACS_quotehardware__c": "string",
            "Access_Control_Competitor_moving_to__c": "string",
            "Access_Control_Products_to_Cancel__c": "string",
            "Access_Hours__c": "string",
            "Access_after_Transfer__c": "string",
            "Access_point_restrict_keypad__c": "string",
            "Accesspointrestrict__c": "string",
            "Account_Record_Type__c": "string",
            "Account_Status__c": "string",
            "Account_Type__c": "string",
            "Account__c": "string",
            "Accounting_method_use__c": "string",
            "Add_info_facility__c": "string",
            "Additional_Comment__c": "string",
            "Addtl_info_or_Qs_on_MS_account__c": "string",
            "Administrative_Fee__c": "string",
            "Already_have_domain__c": "string",
            "Amenities_Offered__c": "string",
            "Amount": "string",
            "Anticipated_Monthly_Vol_per_month__c": "string",
            "Any_Portable_Units__c": "string",
            "Anything_else_we_should_know__c": "string",
            "Archive_Option_email_address__c": "string",
            "Assist_Google_My_Business__c": "string",
            "Auction_Fee_Amount__c": "string",
            "Auction_Units__c": "string",
            "BillingCity__c": "string",
            "BillingCountry__c": "string",
            "BillingName__c": "string",
            "BillingPaymentMethod__c": "string",
            "BillingPostalCode__c": "string",
            "BillingRegion__c": "string",
            "BillingStreet__c": "string",
            "Billing_Settings__c": "string",
            "Business_Country__c": "string",
            "Business_Registration_Number__c": "string",
            "CP_Company_ID__c": "string",
            "CP_Location_ID__c": "string",
            "CP_Products_Being_Purchased__c": "string",
            "CallPotential_Cancellation_Reason__c": "string",
            "CallPotential_Products_to_Cancel__c": "string",
            "CallPotential_going_forward_at_facility__c": "string",
            "CallPotential_interested_in_at_facility__c": "string",
            "Cancel_Single_Multiple_or_All_facility__c": "string",
            "Charge_Second_Late_Fee__c": "string",
            "Charge_Security_Deposit__c": "string",
            "Clone_softwaresetting__c": "string",
            "Clone_website_namefacility__c": "string",
            "CloseDate": "string",
            "Company_Status__c": "string",
            "ConnectionReceivedId": "string",
            "ConnectionSentId": "string",
            "Construction_openbusiness__c": "string",
            "Contact_Email__c": "string",
            "Contact_Name__c": "string",
            "Contact_Person_Email__c": "string",
            "Contact_Person_Name__c": "string",
            "Contact_Person_Phone__c": "string",
            "Contact_Person_Title__c": "string",
            "Contact_Phone__c": "string",
            "Contact_Title__c": "string",
            "Continue_software_service__c": "string",
            "Convertfromspreadsheet__c": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "Created_Case__c": "string",
            "CreditCardCVV__c": "string",
            "CreditCardExpiration__c": "string",
            "CreditCardName__c": "string",
            "CreditCardNetwork__c": "string",
            "CreditCardNumber__c": "string",
            "CurrencyIsoCode": "string",
            "Current_Software_Provider__c": "string",
            "Custom_document_to_use__c": "string",
            "DBA_City_and_State__c": "string",
            "DBA_Name__c": "string",
            "DBA_Phone__c": "string",
            "DBA_Physical_Address__c": "string",
            "DBA_Zip_Code__c": "string",
            "Date_Signed__c": "string",
            "Date_start_software__c": "string",
            "Date_to_be_released__c": "string",
            "Day_Past_Due_FirstFee__c": "string",
            "Day_Past_Due_Notice__c": "string",
            "Days_Past_Due_Lien__c": "string",
            "Days_Past_Due_Locktenant__c": "string",
            "Days_Past_Due_Overlock__c": "string",
            "Days_prior_send_invoice__c": "string",
            "Days_until_second_late_fee__c": "string",
            "Desirable_New_City__c": "string",
            "Device_Quantity__c": "string",
            "Discuss_with_our_Product_Manager__c": "string",
            "Doc_electronic_sign__c": "string",
            "DocuSignStatus__c": "string",
            "Domain_Registration_Location__c": "string",
            "Emphasize_On_Website__c": "string",
            "Est_date_opening_facility__c": "string",
            "Existing_Corp_Code__c": "string",
            "Existing_SMS_account__c": "string",
            "ExpectedRevenue": "string",
            "Expected_FMS_start_date__c": "string",
            "Explain_Auction_process__c": "string",
            "FMS_converting_from__c": "string",
            "Faciilty_Legal_Entity_Name__c": "string",
            "Facility_Cancel_List__c": "string",
            "Facility_Email__c": "string",
            "Facility_ID__c": "string",
            "Facility_Legal_City_and_State__c": "string",
            "Facility_Legal_Mailing_Street_Address__c": "string",
            "Facility_Legal_Phone__c": "string",
            "Facility_Legal_Zip_Code__c": "string",
            "Facility_Name__c": "string",
            "Facility_Phone_Number__c": "string",
            "Facility_State__c": "string",
            "Facility_clone__c": "string",
            "Federal_Tax_ID__c": "string",
            "First_Late_Fee__c": "string",
            "ForecastCategory": "string",
            "FormURL__c": "string",
            "Form_Record_Type__c": "string",
            "Full_Address__c": "string",
            "GTM_ID__c": "string",
            "Gate_Software_Provider__c": "string",
            "Gatefacility_access_hours__c": "string",
            "Gmail_for_GA__c": "string",
            "Google_Analytics__c": "string",
            "Google_My_Business_Listing_Question__c": "string",
            "Google_My_Business_Listing__c": "string",
            "Have_Logo_Facility__c": "string",
            "Historical_Data_Selection__c": "string",
            "Holiday_Hours__c": "string",
            "How_much_Security_Deposit__c": "string",
            "How_payments_applied__c": "string",
            "Id": "string",
            "If_Other_Amenities__c": "string",
            "If_Other_what_is_name_of_Gate_Provider__c": "string",
            "Included_Minutes__c": "string",
            "Included_Tracking_Numbers__c": "string",
            "Insurance_Product_to_Cancel__c": "string",
            "Insuranceprotection_plan__c": "string",
            "Integration_Permission_True__c": "string",
            "Interest_Digital_Marketing__c": "string",
            "Interest_Sparefoot_facility__c": "string",
            "Interest_in_CallPotential__c": "string",
            "Interest_in_Data_Archive__c": "string",
            "Interest_in_Data_Decryption__c": "string",
            "Invoice_Method__c": "string",
            "IsDeleted": "string",
            "JotForm_Enter_Case_Number__c": "string",
            "Jotform_Submission_ID__c": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "License_Holder__c": "string",
            "Lien_Fee__c": "string",
            "Link_SLSE_Software__c": "string",
            "List_merch_items__c": "string",
            "Loc_Code_Preference__c": "string",
            "Location_Code__c": "string",
            "Location_Country__c": "string",
            "Lock_Cutting_Fee__c": "string",
            "Login_Credentials__c": "string",
            "Login_For_Domain__c": "string",
            "MS_Preapplication_JotForm__c": "string",
            "ManageCompany_Ownersame__c": "string",
            "Management_Software__c": "string",
            "Managesoftware_convert__c": "string",
            "Maximum_Usage__c": "string",
            "Merch_Provider_Facility__c": "string",
            "MerchantId__c": "string",
            "Merchant_Timezone__c": "string",
            "Modules_Launching__c": "string",
            "NSF_Fee__c": "string",
            "Name": "string",
            "Name_Facility_Purchase__c": "string",
            "Name_POS_or_FMS_used__c": "string",
            "Nearby_Landmarks__c": "string",
            "Nearby_Neighborhoods__c": "string",
            "NewWebsite_ExistingDomain__c": "string",
            "New_Access_Provider__c": "string",
            "New_Insurance_Provider_Other__c": "string",
            "New_Insurance_Provider__c": "string",
            "New_Insurance_Provider_moving_to__c": "string",
            "New_Software_Platform_moving_to__c": "string",
            "New_Software_Provider__c": "string",
            "New_Website_Platform_moving_to__c": "string",
            "New_Website_Provider__c": "string",
            "Offering_Tenant_Protection_Plans__c": "string",
            "Office_hours__c": "string",
            "Onethingwecouldhavedonedifferently__c": "string",
            "OpportunityId": "string",
            "OpportunityId__c": "string",
            "Opportunity_Type__c": "string",
            "Other_CallPotential_Cancellation_Details__c": "string",
            "Other_Cancel_Access_Control__c": "string",
            "Other_Cancel_Insurance__c": "string",
            "Other_Cancel_Payment_Other_Product__c": "string",
            "Other_Cancel_Software_Product__c": "string",
            "Other_Cancel_SpareFoot__c": "string",
            "Other_Cancel_Website_Product__c": "string",
            "Other_Domain_Registration__c": "string",
            "Other_Merch_Provider__c": "string",
            "Other_Pastdue_Event__c": "string",
            "Other_Software_Provider__c": "string",
            "Other_Website_Provider__c": "string",
            "Overage_Rate_for_Minutes__c": "string",
            "Overage_Rate_for_Tracking_Numbers__c": "string",
            "Overlock_Fee__c": "string",
            "Overlock_PastDue_Unit__c": "string",
            "OwnerId": "string",
            "Parent_Corp_Account_Name__c": "string",
            "Payment_Cutoff_Days__c": "string",
            "Payment_or_Other_Product_to_Cancel__c": "string",
            "Per_Minute_Usage__c": "string",
            "Place_Lien_Units__c": "string",
            "Please_Explain__c": "string",
            "Please_provide_the_name_of_the_purchaser__c": "string",
            "Preferred_Availability__c": "string",
            "Preferred_Contact_Method__c": "string",
            "PrevAmount": "string",
            "PrevCloseDate": "string",
            "Primary_User_Email__c": "string",
            "Primary_User__c": "string",
            "Probability": "string",
            "Promo_discount_offer__c": "string",
            "Prorate_Rent_moveout__c": "string",
            "Prorate_moveout_days__c": "string",
            "PurchFacility_SL_SE_ESS__c": "string",
            "Purchaser_Email__c": "string",
            "Purchaser_Phone__c": "string",
            "Reason_Cancel_Access_Control__c": "string",
            "Reason_Cancel_Insurance__c": "string",
            "Reason_Cancel_Payment_or_Other_Product__c": "string",
            "Reason_Cancel_Software_Product__c": "string",
            "Reason_Cancel_SpareFoot__c": "string",
            "Reason_Cancel_Website_Product__c": "string",
            "Reason_Opting_Out_of_Auto_Protect__c": "string",
            "Reasonforleaving__c": "string",
            "Recipient_Email__c": "string",
            "Recipient_Facility_Name__c": "string",
            "Recipient_Name__c": "string",
            "RecordTypeId": "string",
            "Recur_LateFee_OneTime__c": "string",
            "Related_Record_Created__c": "string",
            "Release_Date__c": "string",
            "Release_domain_name_website__c": "string",
            "Reservation_Fee__c": "string",
            "Retail_or_Merch_sale__c": "string",
            "SE_Company_UUID__c": "string",
            "SE_Facility_UUID__c": "string",
            "SLCorpCode__c": "string",
            "SLLocationCode__c": "string",
            "SSO_Interest_Level__c": "string",
            "Sales_Team_Member__c": "string",
            "Second_Late_Fee__c": "string",
            "Selling_or_Transfer_of_Ownership__c": "string",
            "Send_monthly_rent_invoices__c": "string",
            "Share_login_info__c": "string",
            "Signer_Date_of_Birth__c": "string",
            "Signer_Email__c": "string",
            "Signer_Home_Address__c": "string",
            "Signer_Name__c": "string",
            "Signer_Percentage_Business_Owned__c": "string",
            "Signer_Phone__c": "string",
            "Signer_Title__c": "string",
            "Software_Products_to_Cancel__c": "string",
            "Software_forwardfacility__c": "string",
            "Source__c": "string",
            "SpareFoot_Product_to_Cancel__c": "string",
            "StageName": "string",
            "Start_or_acquire_date_of_business__c": "string",
            "Stock_Ticker_Exchange__c": "string",
            "Subject__c": "string",
            "Submission_Date__c": "string",
            "Switching_Product__c": "string",
            "SystemModstamp": "string",
            "Tax_rate_on_rent__c": "string",
            "Temperature_Controlled_Units__c": "string",
            "Tenant_Insurance_Facility__c": "string",
            "Tenant_Insurance_Provider__c": "string",
            "Top_Amenity__c": "string",
            "Total_of_Locations__c": "string",
            "Tracked_Recorded_Line__c": "string",
            "Transferee_Company_Name__c": "string",
            "Transferee_Email__c": "string",
            "Transferee_Phone_Number__c": "string",
            "Transferee_Primary_Contact__c": "string",
            "Type_of_Business__c": "string",
            "UA_Code__c": "string",
            "UNPW_current_software__c": "string",
            "Units__c": "string",
            "Unmanned_Facility__c": "string",
            "Upload_Business_LicenseArticle_Incorp__c": "string",
            "Upload_Logo_Brand__c": "string",
            "Upload_Logo_Website__c": "string",
            "Upload_Signer_Driver_License__c": "string",
            "Upload_Void_Check_or_Bank_Detail__c": "string",
            "Upload_custom_document__c": "string",
            "Use_Gate_Software_Provider__c": "string",
            "Use_Sparefoot_facility__c": "string",
            "WebsiteProvider_Facility__c": "string",
            "Website_Photo_Facility__c": "string",
            "Website_Products_to_Cancel__c": "string",
            "Website_URL__c": "string",
            "What_is_your_domain__c": "string",
            "Where_is_Domain_Registered__c": "string",
            "Which_PoS_or_FMS_will_you_be_using__c": "string",
            "Which_Storable_Software__c": "string",
            "Your_SL_CorpCode__c": "string",
            "of_Locations_Onboarding__c": "string",
            "storEDGE_integrate2__c": "string",
            "storEDGE_integrate__c": "string"
        },
        "created": "2024-06-10 15:35:50",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_form_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Access_Control_Competitor_moving_to__c`  string , `Access_Control_Products_to_Cancel__c`  string , `Anything_else_we_should_know__c`  string , `Switching_Product__c`  string , `Cancel_Single_Multiple_or_All_facility__c`  string , `Access_Hours__c`  string , `Accounting_method_use__c`  string , `Add_info_facility__c`  string , `Administrative_Fee__c`  string , `Already_have_domain__c`  string , `Amenities_Offered__c`  string , `Contact_Email__c`  string , `Contact_Name__c`  string , `Contact_Phone__c`  string , `Created_Case__c`  string , `Anticipated_Monthly_Vol_per_month__c`  string , `Facility_Cancel_List__c`  string , `Assist_Google_My_Business__c`  string , `Form_Record_Type__c`  string , `Insurance_Product_to_Cancel__c`  string , `New_Insurance_Provider_moving_to__c`  string , `New_Software_Platform_moving_to__c`  string , `New_Website_Platform_moving_to__c`  string , `Onethingwecouldhavedonedifferently__c`  string , `Other_Cancel_Access_Control__c`  string , `Other_Cancel_Insurance__c`  string , `Other_Cancel_Payment_Other_Product__c`  string , `Other_Cancel_Software_Product__c`  string , `Other_Cancel_SpareFoot__c`  string , `Other_Cancel_Website_Product__c`  string , `Payment_or_Other_Product_to_Cancel__c`  string , `Please_provide_the_name_of_the_purchaser__c`  string , `Reason_Cancel_Access_Control__c`  string , `Reason_Cancel_Insurance__c`  string , `Reason_Cancel_Payment_or_Other_Product__c`  string , `Reason_Cancel_Software_Product__c`  string , `Reason_Cancel_SpareFoot__c`  string , `Reason_Cancel_Website_Product__c`  string , `Reasonforleaving__c`  string , `Related_Record_Created__c`  string , `Auction_Units__c`  string , `Software_Products_to_Cancel__c`  string , `Source__c`  string , `SpareFoot_Product_to_Cancel__c`  string , `Subject__c`  string , `Website_Products_to_Cancel__c`  string , `Discuss_with_our_Product_Manager__c`  string , `Interest_in_Data_Archive__c`  string , `Selling_or_Transfer_of_Ownership__c`  string , `Website_URL__c`  string , `Jotform_Submission_ID__c`  string , `DocuSignStatus__c`  string , `CreditCardNumber__c`  string , `CreditCardExpiration__c`  string , `CreditCardNetwork__c`  string , `CreditCardName__c`  string , `BillingName__c`  string , `BillingCity__c`  string , `BillingCountry__c`  string , `BillingPostalCode__c`  string , `BillingRegion__c`  string , `BillingStreet__c`  string , `BillingPaymentMethod__c`  string , `OpportunityId__c`  string , `ACHAccountNumber__c`  string , `ACHRoutingNumber__c`  string , `ACHInstitutionCity__c`  string , `ACHInstitutionName__c`  string , `ACHInstitutionPostalCode__c`  string , `ACHInstitutionRegion__c`  string , `FormURL__c`  string , `Billing_Settings__c`  string , `Device_Quantity__c`  string , `Facility_ID__c`  string , `Full_Address__c`  string , `MerchantId__c`  string , `Merchant_Timezone__c`  string , `Charge_Second_Late_Fee__c`  string , `Charge_Security_Deposit__c`  string , `Contact_Person_Email__c`  string , `Contact_Person_Name__c`  string , `Contact_Person_Phone__c`  string , `Contact_Person_Title__c`  string , `Custom_document_to_use__c`  string , `DBA_City_and_State__c`  string , `DBA_Name__c`  string , `DBA_Phone__c`  string , `DBA_Physical_Address__c`  string , `DBA_Zip_Code__c`  string , `Date_start_software__c`  string , `Day_Past_Due_FirstFee__c`  string , `Day_Past_Due_Notice__c`  string , `Days_Past_Due_Lien__c`  string , `Days_Past_Due_Locktenant__c`  string , `Days_Past_Due_Overlock__c`  string , `Days_prior_send_invoice__c`  string , `Desirable_New_City__c`  string , `Doc_electronic_sign__c`  string , `Domain_Registration_Location__c`  string , `Emphasize_On_Website__c`  string , `Est_date_opening_facility__c`  string , `Explain_Auction_process__c`  string , `FMS_converting_from__c`  string , `Faciilty_Legal_Entity_Name__c`  string , `Facility_Email__c`  string , `Facility_Legal_City_and_State__c`  string , `Facility_Legal_Mailing_Street_Address__c`  string , `Facility_Legal_Phone__c`  string , `Facility_Legal_Zip_Code__c`  string , `Facility_State__c`  string , `Federal_Tax_ID__c`  string , `First_Late_Fee__c`  string , `Gate_Software_Provider__c`  string , `Gatefacility_access_hours__c`  string , `Google_Analytics__c`  string , `Google_My_Business_Listing_Question__c`  string , `Google_My_Business_Listing__c`  string , `Have_Logo_Facility__c`  string , `Holiday_Hours__c`  string , `How_much_Security_Deposit__c`  string , `How_payments_applied__c`  string , `Insuranceprotection_plan__c`  string , `JotForm_Enter_Case_Number__c`  string , `Lien_Fee__c`  string , `Link_SLSE_Software__c`  string , `List_merch_items__c`  string , `Lock_Cutting_Fee__c`  string , `Login_Credentials__c`  string , `Login_For_Domain__c`  string , `MS_Preapplication_JotForm__c`  string , `NSF_Fee__c`  string , `Name_POS_or_FMS_used__c`  string , `Nearby_Landmarks__c`  string , `Nearby_Neighborhoods__c`  string , `Office_hours__c`  string , `Other_Pastdue_Event__c`  string , `Overlock_Fee__c`  string , `Overlock_PastDue_Unit__c`  string , `Place_Lien_Units__c`  string , `Primary_User_Email__c`  string , `Primary_User__c`  string , `Promo_discount_offer__c`  string , `Prorate_Rent_moveout__c`  string , `Prorate_moveout_days__c`  string , `Recur_LateFee_OneTime__c`  string , `Reservation_Fee__c`  string , `Retail_or_Merch_sale__c`  string , `Second_Late_Fee__c`  string , `Send_monthly_rent_invoices__c`  string , `Share_login_info__c`  string , `Signer_Date_of_Birth__c`  string , `Signer_Email__c`  string , `Signer_Home_Address__c`  string , `Signer_Name__c`  string , `Signer_Percentage_Business_Owned__c`  string , `Signer_Phone__c`  string , `Signer_Title__c`  string , `Start_or_acquire_date_of_business__c`  string , `Tax_rate_on_rent__c`  string , `Temperature_Controlled_Units__c`  string , `Tenant_Insurance_Provider__c`  string , `Top_Amenity__c`  string , `UA_Code__c`  string , `UNPW_current_software__c`  string , `Unmanned_Facility__c`  string , `Upload_Business_LicenseArticle_Incorp__c`  string , `Upload_Logo_Brand__c`  string , `Upload_Logo_Website__c`  string , `Upload_Signer_Driver_License__c`  string , `Upload_Void_Check_or_Bank_Detail__c`  string , `Upload_custom_document__c`  string , `Website_Photo_Facility__c`  string , `Which_Storable_Software__c`  string , `storEDGE_integrate__c`  string , `Purchaser_Phone__c`  string , `Purchaser_Email__c`  string , `storEDGE_integrate2__c`  string , `ACS_quotehardware__c`  string , `Access_after_Transfer__c`  string , `Access_point_restrict_keypad__c`  string , `Accesspointrestrict__c`  string , `Additional_Comment__c`  string , `Any_Portable_Units__c`  string , `Archive_Option_email_address__c`  string , `Clone_softwaresetting__c`  string , `Clone_website_namefacility__c`  string , `Construction_openbusiness__c`  string , `Continue_software_service__c`  string , `Convertfromspreadsheet__c`  string , `Current_Software_Provider__c`  string , `Date_Signed__c`  string , `Date_to_be_released__c`  string , `Existing_Corp_Code__c`  string , `Facility_clone__c`  string , `Historical_Data_Selection__c`  string , `Interest_Digital_Marketing__c`  string , `Interest_Sparefoot_facility__c`  string , `License_Holder__c`  string , `Loc_Code_Preference__c`  string , `Location_Code__c`  string , `ManageCompany_Ownersame__c`  string , `Managesoftware_convert__c`  string , `Merch_Provider_Facility__c`  string , `Name_Facility_Purchase__c`  string , `NewWebsite_ExistingDomain__c`  string , `Other_Merch_Provider__c`  string , `Other_Software_Provider__c`  string , `Other_Website_Provider__c`  string , `PurchFacility_SL_SE_ESS__c`  string , `Recipient_Email__c`  string , `Recipient_Facility_Name__c`  string , `Recipient_Name__c`  string , `Release_Date__c`  string , `Release_domain_name_website__c`  string , `SLCorpCode__c`  string , `SLLocationCode__c`  string , `Software_forwardfacility__c`  string , `Tenant_Insurance_Facility__c`  string , `Transferee_Company_Name__c`  string , `Transferee_Email__c`  string , `Transferee_Phone_Number__c`  string , `Transferee_Primary_Contact__c`  string , `Units__c`  string , `Use_Gate_Software_Provider__c`  string , `Use_Sparefoot_facility__c`  string , `WebsiteProvider_Facility__c`  string , `Your_SL_CorpCode__c`  string , `New_Access_Provider__c`  string , `New_Website_Provider__c`  string , `New_Software_Provider__c`  string , `Auction_Fee_Amount__c`  string , `Days_until_second_late_fee__c`  string , `Offering_Tenant_Protection_Plans__c`  string , `Invoice_Method__c`  string , `Addtl_info_or_Qs_on_MS_account__c`  string , `Existing_SMS_account__c`  string , `Expected_FMS_start_date__c`  string , `Type_of_Business__c`  string , `Which_PoS_or_FMS_will_you_be_using__c`  string , `Please_Explain__c`  string , `Reason_Opting_Out_of_Auto_Protect__c`  string , `Preferred_Availability__c`  string , `SSO_Interest_Level__c`  string , `Preferred_Contact_Method__c`  string , `CreditCardCVV__c`  string , `GTM_ID__c`  string , `If_Other_what_is_name_of_Gate_Provider__c`  string , `What_is_your_domain__c`  string , `Facility_Phone_Number__c`  string , `Gmail_for_GA__c`  string , `SE_Company_UUID__c`  string , `SE_Facility_UUID__c`  string , `Submission_Date__c`  string , `Sales_Team_Member__c`  string , `Company_Status__c`  string , `Stock_Ticker_Exchange__c`  string , `Contact_Title__c`  string , `Account__c`  string , `Interest_in_Data_Decryption__c`  string , `Payment_Cutoff_Days__c`  string , `CallPotential_Cancellation_Reason__c`  string , `Total_of_Locations__c`  string , `of_Locations_Onboarding__c`  string , `Modules_Launching__c`  string , `Management_Software__c`  string , `CallPotential_Products_to_Cancel__c`  string , `Other_CallPotential_Cancellation_Details__c`  string , `Business_Country__c`  string , `Location_Country__c`  string , `New_Insurance_Provider_Other__c`  string , `Business_Registration_Number__c`  string , `Tracked_Recorded_Line__c`  string , `Integration_Permission_True__c`  string , `New_Insurance_Provider__c`  string , `CallPotential_going_forward_at_facility__c`  string , `CallPotential_interested_in_at_facility__c`  string , `Interest_in_CallPotential__c`  string , `Account_Record_Type__c`  string , `Account_Status__c`  string , `Account_Type__c`  string , `CP_Company_ID__c`  string , `CP_Location_ID__c`  string , `CP_Products_Being_Purchased__c`  string , `Facility_Name__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Maximum_Usage__c`  string , `Opportunity_Type__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Parent_Corp_Account_Name__c`  string , `Per_Minute_Usage__c`  string , `If_Other_Amenities__c`  string , `Other_Domain_Registration__c`  string , `Where_is_Domain_Registered__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-dev/raw/form_response__cs/2024-06-10/1718051367'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_form_response__cs`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_form_response__cs"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}
©2019 SpareFoot Data Platform