Schema Info

Schema Name: sfdl_dev_csv.salesforce_cases
  • created: 2022-10-24 14:55:26
  • disabled: False
  • format: raw
  • id: 2082
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_dev_csv",
    "table": "salesforce_cases"
}
  • type: csv
Schema Versions: 5
    • created: 2024-06-10 15:37:04
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_cases`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_cases`\n(\n `Id`  string , `IsDeleted`  string , `MasterRecordId`  string , `CaseNumber`  string , `ContactId`  string , `AccountId`  string , `AssetId`  string , `ProductId`  string , `EntitlementId`  string , `SourceId`  string , `BusinessHoursId`  string , `ParentId`  string , `SuppliedName`  string , `SuppliedEmail`  string , `SuppliedPhone`  string , `SuppliedCompany`  string , `Type`  string , `RecordTypeId`  string , `Status`  string , `Reason`  string , `Origin`  string , `Language`  string , `IsVisibleInSelfService`  string , `Subject`  string , `Priority`  string , `Description`  string , `IsClosed`  string , `ClosedDate`  string , `IsEscalated`  string , `HasCommentsUnreadByOwner`  string , `HasSelfServiceComments`  string , `CurrencyIsoCode`  string , `OwnerId`  string , `IsClosedOnCreate`  string , `IsSelfServiceClosed`  string , `SlaStartDate`  string , `SlaExitDate`  string , `IsStopped`  string , `StopStartDate`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ContactPhone`  string , `ContactMobile`  string , `ContactEmail`  string , `ContactFax`  string , `Comments`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `ServiceContractId`  string , `MilestoneStatus`  string , `dCreated__c`  string , `ACH_Reject_Value__c`  string , `Actual_Hours__c`  string , `Due_Date__c`  string , `PreBoardingTaskscompleted__c`  string , `MS_Preapplication_JotForm__c`  string , `Original_Tech_Owner__c`  string , `Product__c`  string , `Type__c`  string , `SubType_1__c`  string , `SubType_2__c`  string , `Development_Priority__c`  string , `Outbound_Call_Count__c`  string , `Approved_for_Development__c`  string , `Department__c`  string , `Category__c`  string , `Assigned_Tech__c`  string , `Conversion_Complete_Date__c`  string , `Conversion_Scheduled_Date__c`  string , `Date_Assigned_to_Tech__c`  string , `Purchaser_Email__c`  string , `Requester_Email__c`  string , `Quoted_Price__c`  string , `Last_Call_ID__c`  string , `CreatePCIrequestforSLMS__c`  string , `Corp_Code_Search__c`  string , `Include_In_Immediate_Release__c`  string , `Actual_Hours_User__c`  string , `CSAT_Resend__c`  string , `Disposition_Estimate__c`  string , `Disposition_Estimate_Reason__c`  string , `Last_Email_Comment_SentBy__c`  string , `SubType_3_c__c`  string , `Last_Comment_Date__c`  string , `SuspendedDate__c`  string , `SuspendedBy__c`  string , `Purchaser_Phone__c`  string , `Google_My_Business_Listing__c`  string , `RateChange__c`  string , `IGD__Collection_Id__c`  string , `Reference_Opportunity__c`  string , `Opportunity__c`  string , `FirstClosedDate__c`  string , `Assignment_Health__c`  string , `Response_Health__c`  string , `Resolution_Health__c`  string , `Generate_ATB__c`  string , `EscalatedDate__c`  string , `EscalationReason__c`  string , `ACS_quotehardware__c`  string , `EscalationReasonDetails__c`  string , `EscalatedById__c`  string , `EscalatedByDepartment__c`  string , `Auto_Closed__c`  string , `Inbound_Call_Count__c`  string , `LastOutboundDate__c`  string , `Vanilla__ForumUrl__c`  string , `FirstAssignedDate__c`  string , `SF_Demand_in_scope_new_customer__c`  string , `EnableCustomInsurance__c`  string , `SFDemandinScopeExistingSFCustome__c`  string , `ExpectedBehavior__c`  string , `JIRAIssue__c`  string , `StepstoReproduce__c`  string , `Projected_Live_Date__c`  string , `Site_Status__c`  string , `Existing_Logo_Corp_Code__c`  string , `DisablePayeezydate__c`  string , `ProjectedGoLiveDateConfidence__c`  string , `LastInboundDate__c`  string , `Access_after_Transfer__c`  string , `Units__c`  string , `FMSLaunchDate__c`  string , `Category_new__c`  string , `CreateImplementationCase__c`  string , `Website__c`  string , `ImplementationNotes__c`  string , `Product_new__c`  string , `NewConstruction__c`  string , `Opportunity_Required_Approval__c`  string , `Current_FMS__c`  string , `SSL_Renewal_Date__c`  string , `Current_Website__c`  string , `Status_Reason__c`  string , `SE_Billing_Email__c`  string , `SF_Billing_Email__c`  string , `SE_Support_Email__c`  string , `Current_Gate__c`  string , `Current_Insurance__c`  string , `Current_Marketplace__c`  string , `Current_Payment__c`  string , `Net_MRR_Value__c`  string , `Case_Owner_at_Close__c`  string , `Discount_Amount__c`  string , `Settings_Form_Received_On__c`  string , `Discount_Period__c`  string , `Related_Opportunity_Amended__c`  string , `Assetrequired__c`  string , `Closed_Reason__c`  string , `MaxofUnits__c`  string , `Case_Survey_ID__c`  string , `Start_Case_Auto_Close_Process__c`  string , `Product_Family__c`  string , `Initial_Response_Milestone_Achieved__c`  string , `Most_Recent_Case_Comment__c`  string , `Brand__c`  string , `Resolution_Disposition__c`  string , `Access_point_restrict_keypad__c`  string , `RelatedOpptyClosedwonPortfolio__c`  string , `RelatedOpptyClosedwonStandard__c`  string , `Received_by__c`  string , `AdditionalNotes__c`  string , `List_Note__c`  string , `ContactsEmail__c`  string , `ContactsName__c`  string , `ContactsPhone__c`  string , `CorpCode__c`  string , `ExistingCaseurl__c`  string , `LocationCode__c`  string , `ProductsatRisk__c`  string , `ReasonforCancellationold__c`  string , `RequestedCancellationDate__c`  string , `BillableEntityID__c`  string , `CancelinBillingDate__c`  string , `ChargeOverId__c`  string , `CorpLocationID__c`  string , `NewProduct__c`  string , `OriginalLeaseDate__c`  string , `SFfacilitykeyChildfacility__c`  string , `SLMSAccount__c`  string , `BillingNotes__c`  string , `DiscontinueProductDate__c`  string , `ACHID__c`  string , `First_Response_Date__c`  string , `Suppress_Automated_Emails__c`  string , `Accesspointrestrict__c`  string , `SFClientKey__c`  string , `SEFMSID__c`  string , `SLCorpCode__c`  string , `SLLocationCode__c`  string , `MerchantID__c`  string , `Reopen_Count__c`  string , `DatawireID__c`  string , `Zendesk_Ticket_URL__c`  string , `Zendesk_Ticket_ID__c`  string , `ReasonforCancellation__c`  string , `HQMerchantID__c`  string , `MasterICowner__c`  string , `Enable_Storable_Payments__c`  string , `Activate_Storable_Payments__c`  string , `JotForm_URL__c`  string , `Setupcasecreated__c`  string , `Message_Sent_Count__c`  string , `Email_Received_Count__c`  string , `Public_Comment_Sent_Count__c`  string , `StatusReasonlastupdated__c`  string , `CSAT_Sent__c`  string , `CSAT_Combined_Score__c`  string , `Cancellationnoticesent__c`  string , `Onethingwecouldhavedonedifferently__c`  string , `ProductfeatureorImprovement__c`  string , `Reasonforleaving__c`  string , `ReasonDetailsifother__c`  string , `ReasonDetailsifCOVID19__c`  string , `DebookedReason__c`  string , `CSAT_Date_Time_Sent__c`  string , `CSAT_Support_Score__c`  string , `CSAT_Product_Score__c`  string , `CSAT_NPS__c`  string , `CSAT_Date_Time_Completed__c`  string , `CSAT_Comment__c`  string , `AuthGroup__c`  string , `monthlygroup__c`  string , `Discountgroup__c`  string , `Annualgroup__c`  string , `Date_Time_CSAT_Expiration__c`  string , `RelatedCase__c`  string , `Price__c`  string , `Additional_Comment__c`  string , `VoyagerMigrationEnabled__c`  string , `Any_Portable_Units__c`  string , `Archive_Option_email_address__c`  string , `ConsultationSize__c`  string , `ConsultationReason__c`  string , `ConsultationReasonDetails__c`  string , `Clone_softwaresetting__c`  string , `Sub_Category__c`  string , `Access_Control_Products_to_Cancel__c`  string , `Asset_Product_Cancel_List__c`  string , `Facility_Cancel_List__c`  string , `Form_Response_Record__c`  string , `Insurance_Product_to_Cancel__c`  string , `Payment_or_Other_Product_to_Cancel__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 , `Software_Products_to_Cancel__c`  string , `SpareFoot_Product_to_Cancel__c`  string , `Website_Products_to_Cancel__c`  string , `Website_Cancellation_URL__c`  string , `Hardware_Tracking__c`  string , `BillingPaymentMethod__c`  string , `BillingName__c`  string , `BillingCity__c`  string , `BillingPostalCode__c`  string , `BillingStreet__c`  string , `BillingRegion__c`  string , `BillingCountry__c`  string , `CreditCardNetwork__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 , `ACHInstitutionName__c`  string , `ACHInstitutionCity__c`  string , `ACHInstitutionRegion__c`  string , `ACHInstitutionPostalCode__c`  string , `CreditCardName__c`  string , `Fulfillment_Status__c`  string , `Shipping_Provider__c`  string , `Date_start_software__c`  string , `Auto_Reminder_Email_Sent__c`  string , `Interested_in_Data_Archive__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 , `Software_forwardfacility__c`  string , `Tax_rate_on_rent__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 , `Use_Gate_Software_Provider__c`  string , `Use_Sparefoot_facility__c`  string , `WebsiteProvider_Facility__c`  string , `Your_SL_CorpCode__c`  string , `Purchase_Order_ACH__c`  string , `SE_Facility_UUID__c`  string , `Refund_Method__c`  string , `PDK_RMA__c`  string , `EmailSubjectAddition__c`  string , `Synched_to_Netsuite__c`  string , `PDK_RMA_Complete__c`  string , `PDK_RMA_Email_Sent__c`  string , `Upsell_or_Transfer__c`  string , `Originating_Opportunity_Product__c`  string , `Revised_Quantity__c`  string , `Validation_Rule_Toggle__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_CSAT_Comment__c`  string , `Implementation_Product_Score__c`  string , `Exemption_Notes__c`  string , `Exempting_Manager__c`  string , `CSAT_Close_Email_Exempt__c`  string , `Auto_Reminder_Email_Sent_Date__c`  string , `Start_Case_Auto_Close_Process_Date__c`  string , `Other_Software_Cancellation_Details__c`  string , `Other_Website_Cancellation_Details__c`  string , `Other_Marketplace_Cancellation_Details__c`  string , `Other_Access_Cancellation_Details__c`  string , `Other_Payments_Cancellation_Details__c`  string , `AC_Hardware_Installment_Loan__c`  string , `AC_Hardware_Installment_Months__c`  string , `Implementation_Support_Score__c`  string , `Order_Product__c`  string , `Send_Secure_Emails__c`  string , `RocketLane_Product_List__c`  string , `RocketLane_Project_Notes__c`  string , `RocketLane_Project_URL__c`  string , `Original_Launch_Date__c`  string , `Launch_Time__c`  string , `Require_T1_Support__c`  string , `MRR_Total__c`  string , `Net_MRR_Total__c`  string , `Originating_CSF_Case__c`  string , `Reply_To_Email__c`  string , `CallPotential_Products_to_Cancel__c`  string , `Other_CallPotential_Cancellation_Details__c`  string , `Reason_Cancel_CallPotential__c`  string , `CP_Company_ID__c`  string , `CP_Location_ID__c`  string , `FMS_Status__c`  string , `Ultimate_Parent_Account_Name__c`  string , `Interested_in_Data_Decryption__c`  string , `CSR_Churn_Risk__c`  string , `Received_At__c`  string , `Statement_ID__c`  string , `Messaging_Session__c`  string , `RocketLane_Payments_URL__c`  string , `CallPotential_going_forward_at_facility__c`  string , `CallPotential_interest_at_facility__c`  string , `Interest_in_CallPotential__c`  string , `Facility_Phone_Number__c`  string , `PPS_Cleanup_Tool__c`  string , `PDK_RMA_Backbill_Complete__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/cases/2024-06-10/1718051798'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_cases"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/cases/2024-06-10/1718051798
    • id: 4706477
    • processed: 1
    • raw_data: 
      {
    "ACHID__c": 185,
    "ACHInstitutionCity__c": 272,
    "ACHInstitutionName__c": 271,
    "ACHInstitutionPostalCode__c": 274,
    "ACHInstitutionRegion__c": 273,
    "ACH_Reject_Value__c": 54,
    "ACS_quotehardware__c": 102,
    "AC_Hardware_Installment_Loan__c": 340,
    "AC_Hardware_Installment_Months__c": 341,
    "Access_Control_Products_to_Cancel__c": 240,
    "Access_after_Transfer__c": 123,
    "Access_point_restrict_keypad__c": 160,
    "Accesspointrestrict__c": 188,
    "AccountId": 5,
    "Activate_Storable_Payments__c": 202,
    "Actual_Hours_User__c": 80,
    "Actual_Hours__c": 55,
    "AdditionalNotes__c": 164,
    "Additional_Comment__c": 231,
    "Annualgroup__c": 227,
    "Any_Portable_Units__c": 233,
    "Approved_for_Development__c": 66,
    "Archive_Option_email_address__c": 234,
    "AssetId": 6,
    "Asset_Product_Cancel_List__c": 241,
    "Assetrequired__c": 150,
    "Assigned_Tech__c": 69,
    "Assignment_Health__c": 96,
    "AuthGroup__c": 224,
    "Auto_Closed__c": 106,
    "Auto_Reminder_Email_Sent_Date__c": 333,
    "Auto_Reminder_Email_Sent__c": 279,
    "BillableEntityID__c": 175,
    "BillingCity__c": 259,
    "BillingCountry__c": 263,
    "BillingName__c": 258,
    "BillingNotes__c": 183,
    "BillingPaymentMethod__c": 257,
    "BillingPostalCode__c": 260,
    "BillingRegion__c": 262,
    "BillingStreet__c": 261,
    "Brand__c": 158,
    "BusinessHoursId": 10,
    "CP_Company_ID__c": 358,
    "CP_Location_ID__c": 359,
    "CSAT_Close_Email_Exempt__c": 332,
    "CSAT_Combined_Score__c": 210,
    "CSAT_Comment__c": 223,
    "CSAT_Date_Time_Completed__c": 222,
    "CSAT_Date_Time_Sent__c": 218,
    "CSAT_NPS__c": 221,
    "CSAT_Product_Score__c": 220,
    "CSAT_Resend__c": 81,
    "CSAT_Sent__c": 209,
    "CSAT_Support_Score__c": 219,
    "CSR_Churn_Risk__c": 363,
    "CallPotential_Products_to_Cancel__c": 355,
    "CallPotential_going_forward_at_facility__c": 368,
    "CallPotential_interest_at_facility__c": 369,
    "CancelinBillingDate__c": 176,
    "Cancellationnoticesent__c": 211,
    "CaseNumber": 3,
    "Case_Owner_at_Close__c": 145,
    "Case_Survey_ID__c": 153,
    "Category__c": 68,
    "Category_new__c": 126,
    "ChargeOverId__c": 177,
    "Clone_softwaresetting__c": 238,
    "Clone_website_namefacility__c": 265,
    "ClosedDate": 27,
    "Closed_Reason__c": 151,
    "Comments": 48,
    "ConnectionReceivedId": 49,
    "ConnectionSentId": 50,
    "Construction_openbusiness__c": 266,
    "ConsultationReasonDetails__c": 237,
    "ConsultationReason__c": 236,
    "ConsultationSize__c": 235,
    "ContactEmail": 46,
    "ContactFax": 47,
    "ContactId": 4,
    "ContactMobile": 45,
    "ContactPhone": 44,
    "ContactsEmail__c": 166,
    "ContactsName__c": 167,
    "ContactsPhone__c": 168,
    "Continue_software_service__c": 267,
    "Conversion_Complete_Date__c": 70,
    "Conversion_Scheduled_Date__c": 71,
    "Convertfromspreadsheet__c": 268,
    "CorpCode__c": 169,
    "CorpLocationID__c": 178,
    "Corp_Code_Search__c": 78,
    "CreateImplementationCase__c": 127,
    "CreatePCIrequestforSLMS__c": 77,
    "CreatedById": 40,
    "CreatedDate": 39,
    "CreditCardName__c": 275,
    "CreditCardNetwork__c": 264,
    "CurrencyIsoCode": 31,
    "Current_FMS__c": 133,
    "Current_Gate__c": 140,
    "Current_Insurance__c": 141,
    "Current_Marketplace__c": 142,
    "Current_Payment__c": 143,
    "Current_Software_Provider__c": 269,
    "Current_Website__c": 135,
    "DatawireID__c": 195,
    "Date_Assigned_to_Tech__c": 72,
    "Date_Signed__c": 270,
    "Date_Time_CSAT_Expiration__c": 228,
    "Date_start_software__c": 278,
    "Date_to_be_released__c": 281,
    "DebookedReason__c": 217,
    "Department__c": 67,
    "Description": 25,
    "Development_Priority__c": 64,
    "DisablePayeezydate__c": 120,
    "DiscontinueProductDate__c": 184,
    "Discount_Amount__c": 146,
    "Discount_Period__c": 148,
    "Discountgroup__c": 226,
    "Disposition_Estimate_Reason__c": 83,
    "Disposition_Estimate__c": 82,
    "Due_Date__c": 56,
    "EmailSubjectAddition__c": 319,
    "Email_Received_Count__c": 206,
    "EnableCustomInsurance__c": 112,
    "Enable_Storable_Payments__c": 201,
    "EntitlementId": 8,
    "EscalatedByDepartment__c": 105,
    "EscalatedById__c": 104,
    "EscalatedDate__c": 100,
    "EscalationReasonDetails__c": 103,
    "EscalationReason__c": 101,
    "Exempting_Manager__c": 331,
    "Exemption_Notes__c": 330,
    "ExistingCaseurl__c": 170,
    "Existing_Corp_Code__c": 282,
    "Existing_Logo_Corp_Code__c": 119,
    "ExpectedBehavior__c": 114,
    "FMSLaunchDate__c": 125,
    "FMS_Status__c": 360,
    "Facility_Cancel_List__c": 242,
    "Facility_Phone_Number__c": 371,
    "Facility_clone__c": 283,
    "FirstAssignedDate__c": 110,
    "FirstClosedDate__c": 95,
    "First_Response_Date__c": 186,
    "Form_Response_Record__c": 243,
    "Fulfillment_Status__c": 276,
    "Generate_ATB__c": 99,
    "Google_My_Business_Listing__c": 90,
    "HQMerchantID__c": 199,
    "Hardware_Tracking__c": 256,
    "HasCommentsUnreadByOwner": 29,
    "HasSelfServiceComments": 30,
    "Historical_Data_Selection__c": 284,
    "IGD__Collection_Id__c": 92,
    "Id": 0,
    "ImplementationNotes__c": 129,
    "Implementation_CSAT_Comment__c": 328,
    "Implementation_Combined_Score__c": 327,
    "Implementation_Product_Score__c": 329,
    "Implementation_Support_Score__c": 342,
    "Inbound_Call_Count__c": 107,
    "Include_In_Immediate_Release__c": 79,
    "Initial_Response_Milestone_Achieved__c": 156,
    "Insurance_Product_to_Cancel__c": 244,
    "Interest_Digital_Marketing__c": 285,
    "Interest_Sparefoot_facility__c": 286,
    "Interest_in_CallPotential__c": 370,
    "Interested_in_Data_Archive__c": 280,
    "Interested_in_Data_Decryption__c": 362,
    "IsClosed": 26,
    "IsClosedOnCreate": 33,
    "IsDeleted": 1,
    "IsEscalated": 28,
    "IsSelfServiceClosed": 34,
    "IsStopped": 37,
    "IsVisibleInSelfService": 22,
    "JIRAIssue__c": 115,
    "JotForm_URL__c": 203,
    "Language": 21,
    "LastInboundDate__c": 122,
    "LastModifiedById": 42,
    "LastModifiedDate": 41,
    "LastOutboundDate__c": 108,
    "Last_Call_ID__c": 76,
    "Last_Comment_Date__c": 86,
    "Last_Email_Comment_SentBy__c": 84,
    "Launch_Time__c": 349,
    "License_Holder__c": 287,
    "List_Note__c": 165,
    "Loc_Code_Preference__c": 288,
    "LocationCode__c": 171,
    "Location_Code__c": 289,
    "MRR_Total__c": 351,
    "MS_Preapplication_JotForm__c": 58,
    "ManageCompany_Ownersame__c": 290,
    "Managesoftware_convert__c": 291,
    "MasterICowner__c": 200,
    "MasterRecordId": 2,
    "MaxofUnits__c": 152,
    "Merch_Provider_Facility__c": 292,
    "MerchantID__c": 193,
    "Message_Sent_Count__c": 205,
    "Messaging_Session__c": 366,
    "MilestoneStatus": 52,
    "Most_Recent_Case_Comment__c": 157,
    "Name_Facility_Purchase__c": 293,
    "Net_MRR_Total__c": 352,
    "Net_MRR_Value__c": 144,
    "NewConstruction__c": 131,
    "NewProduct__c": 179,
    "NewWebsite_ExistingDomain__c": 294,
    "Onethingwecouldhavedonedifferently__c": 212,
    "Opportunity_Required_Approval__c": 132,
    "Opportunity__c": 94,
    "Order_Product__c": 343,
    "Origin": 20,
    "OriginalLeaseDate__c": 180,
    "Original_Launch_Date__c": 348,
    "Original_Tech_Owner__c": 59,
    "Originating_CSF_Case__c": 353,
    "Originating_Opportunity_Product__c": 324,
    "Other_Access_Cancellation_Details__c": 338,
    "Other_CallPotential_Cancellation_Details__c": 356,
    "Other_Marketplace_Cancellation_Details__c": 337,
    "Other_Merch_Provider__c": 295,
    "Other_Payments_Cancellation_Details__c": 339,
    "Other_Software_Cancellation_Details__c": 335,
    "Other_Software_Provider__c": 296,
    "Other_Website_Cancellation_Details__c": 336,
    "Other_Website_Provider__c": 297,
    "Outbound_Call_Count__c": 65,
    "OwnerId": 32,
    "PDK_RMA_Backbill_Complete__c": 373,
    "PDK_RMA_Complete__c": 321,
    "PDK_RMA_Email_Sent__c": 322,
    "PDK_RMA__c": 318,
    "PPS_Cleanup_Tool__c": 372,
    "ParentId": 11,
    "Payment_or_Other_Product_to_Cancel__c": 245,
    "PreBoardingTaskscompleted__c": 57,
    "Price__c": 230,
    "Priority": 24,
    "ProductId": 7,
    "Product_Family__c": 155,
    "Product__c": 60,
    "Product_new__c": 130,
    "ProductfeatureorImprovement__c": 213,
    "ProductsatRisk__c": 172,
    "ProjectedGoLiveDateConfidence__c": 121,
    "Projected_Live_Date__c": 117,
    "Public_Comment_Sent_Count__c": 207,
    "PurchFacility_SL_SE_ESS__c": 298,
    "Purchase_Order_ACH__c": 315,
    "Purchaser_Email__c": 73,
    "Purchaser_Phone__c": 89,
    "Quoted_Price__c": 75,
    "RateChange__c": 91,
    "Reason": 19,
    "ReasonDetailsifCOVID19__c": 216,
    "ReasonDetailsifother__c": 215,
    "Reason_Cancel_Access_Control__c": 246,
    "Reason_Cancel_CallPotential__c": 357,
    "Reason_Cancel_Insurance__c": 247,
    "Reason_Cancel_Payment_or_Other_Product__c": 248,
    "Reason_Cancel_Software_Product__c": 249,
    "Reason_Cancel_SpareFoot__c": 250,
    "Reason_Cancel_Website_Product__c": 251,
    "ReasonforCancellation__c": 198,
    "ReasonforCancellationold__c": 173,
    "Reasonforleaving__c": 214,
    "Received_At__c": 364,
    "Received_by__c": 163,
    "Recipient_Email__c": 299,
    "Recipient_Facility_Name__c": 300,
    "Recipient_Name__c": 301,
    "RecordTypeId": 17,
    "Reference_Opportunity__c": 93,
    "Refund_Method__c": 317,
    "RelatedCase__c": 229,
    "RelatedOpptyClosedwonPortfolio__c": 161,
    "RelatedOpptyClosedwonStandard__c": 162,
    "Related_Opportunity_Amended__c": 149,
    "Release_Date__c": 302,
    "Release_domain_name_website__c": 303,
    "Reopen_Count__c": 194,
    "Reply_To_Email__c": 354,
    "RequestedCancellationDate__c": 174,
    "Requester_Email__c": 74,
    "Require_T1_Support__c": 350,
    "Resolution_Disposition__c": 159,
    "Resolution_Health__c": 98,
    "Response_Health__c": 97,
    "Revised_Quantity__c": 325,
    "RocketLane_Payments_URL__c": 367,
    "RocketLane_Product_List__c": 345,
    "RocketLane_Project_Notes__c": 346,
    "RocketLane_Project_URL__c": 347,
    "SEFMSID__c": 190,
    "SE_Billing_Email__c": 137,
    "SE_Facility_UUID__c": 316,
    "SE_Support_Email__c": 139,
    "SFClientKey__c": 189,
    "SFDemandinScopeExistingSFCustome__c": 113,
    "SF_Billing_Email__c": 138,
    "SF_Demand_in_scope_new_customer__c": 111,
    "SFfacilitykeyChildfacility__c": 181,
    "SLCorpCode__c": 191,
    "SLLocationCode__c": 192,
    "SLMSAccount__c": 182,
    "SSL_Renewal_Date__c": 134,
    "Send_Secure_Emails__c": 344,
    "ServiceContractId": 51,
    "Settings_Form_Received_On__c": 147,
    "Setupcasecreated__c": 204,
    "Shipping_Provider__c": 277,
    "Site_Status__c": 118,
    "SlaExitDate": 36,
    "SlaStartDate": 35,
    "Software_Products_to_Cancel__c": 252,
    "Software_forwardfacility__c": 304,
    "SourceId": 9,
    "SpareFoot_Product_to_Cancel__c": 253,
    "Start_Case_Auto_Close_Process_Date__c": 334,
    "Start_Case_Auto_Close_Process__c": 154,
    "Statement_ID__c": 365,
    "Status": 18,
    "StatusReasonlastupdated__c": 208,
    "Status_Reason__c": 136,
    "StepstoReproduce__c": 116,
    "StopStartDate": 38,
    "SubType_1__c": 62,
    "SubType_2__c": 63,
    "SubType_3_c__c": 85,
    "Sub_Category__c": 239,
    "Subject": 23,
    "SuppliedCompany": 15,
    "SuppliedEmail": 13,
    "SuppliedName": 12,
    "SuppliedPhone": 14,
    "Suppress_Automated_Emails__c": 187,
    "SuspendedBy__c": 88,
    "SuspendedDate__c": 87,
    "Synched_to_Netsuite__c": 320,
    "SystemModstamp": 43,
    "Tax_rate_on_rent__c": 305,
    "Tenant_Insurance_Facility__c": 306,
    "Transferee_Company_Name__c": 307,
    "Transferee_Email__c": 308,
    "Transferee_Phone_Number__c": 309,
    "Transferee_Primary_Contact__c": 310,
    "Type": 16,
    "Type__c": 61,
    "Ultimate_Parent_Account_Name__c": 361,
    "Units__c": 124,
    "Upsell_or_Transfer__c": 323,
    "Use_Gate_Software_Provider__c": 311,
    "Use_Sparefoot_facility__c": 312,
    "Validation_Rule_Toggle__c": 326,
    "Vanilla__ForumUrl__c": 109,
    "VoyagerMigrationEnabled__c": 232,
    "WebsiteProvider_Facility__c": 313,
    "Website_Cancellation_URL__c": 255,
    "Website_Products_to_Cancel__c": 254,
    "Website__c": 128,
    "Your_SL_CorpCode__c": 314,
    "Zendesk_Ticket_ID__c": 197,
    "Zendesk_Ticket_URL__c": 196,
    "dCreated__c": 53,
    "monthlygroup__c": 225
}
    • schema_attributes: 
      {
    "ACHAccountNumber__c": "string",
    "ACHID__c": "string",
    "ACHInstitutionCity__c": "string",
    "ACHInstitutionName__c": "string",
    "ACHInstitutionPostalCode__c": "string",
    "ACHInstitutionRegion__c": "string",
    "ACHRoutingNumber__c": "string",
    "ACH_Reject_Value__c": "string",
    "ACS_quotehardware__c": "string",
    "AC_Hardware_Installment_Loan__c": "string",
    "AC_Hardware_Installment_Months__c": "string",
    "Access_Control_Products_to_Cancel__c": "string",
    "Access_after_Transfer__c": "string",
    "Access_point_restrict_keypad__c": "string",
    "Accesspointrestrict__c": "string",
    "AccountId": "string",
    "Activate_Storable_Payments__c": "string",
    "Actual_Hours_User__c": "string",
    "Actual_Hours__c": "string",
    "AdditionalNotes__c": "string",
    "Additional_Comment__c": "string",
    "Amount": "string",
    "Annualgroup__c": "string",
    "Any_Portable_Units__c": "string",
    "Approved_for_Development__c": "string",
    "Archive_Option_email_address__c": "string",
    "AssetId": "string",
    "Asset_Product_Cancel_List__c": "string",
    "Assetrequired__c": "string",
    "Assigned_Tech__c": "string",
    "Assignment_Health__c": "string",
    "AuthGroup__c": "string",
    "Auto_Closed__c": "string",
    "Auto_Reminder_Email_Sent_Date__c": "string",
    "Auto_Reminder_Email_Sent__c": "string",
    "BillableEntityID__c": "string",
    "BillingCity__c": "string",
    "BillingCountry__c": "string",
    "BillingName__c": "string",
    "BillingNotes__c": "string",
    "BillingPaymentMethod__c": "string",
    "BillingPostalCode__c": "string",
    "BillingRegion__c": "string",
    "BillingStreet__c": "string",
    "Brand__c": "string",
    "BusinessHoursId": "string",
    "CP_Company_ID__c": "string",
    "CP_Location_ID__c": "string",
    "CSAT_Close_Email_Exempt__c": "string",
    "CSAT_Combined_Score__c": "string",
    "CSAT_Comment__c": "string",
    "CSAT_Date_Time_Completed__c": "string",
    "CSAT_Date_Time_Sent__c": "string",
    "CSAT_NPS__c": "string",
    "CSAT_Product_Score__c": "string",
    "CSAT_Resend__c": "string",
    "CSAT_Sent__c": "string",
    "CSAT_Support_Score__c": "string",
    "CSR_Churn_Risk__c": "string",
    "CallPotential_Products_to_Cancel__c": "string",
    "CallPotential_going_forward_at_facility__c": "string",
    "CallPotential_interest_at_facility__c": "string",
    "CancelinBillingDate__c": "string",
    "Cancellationnoticesent__c": "string",
    "CaseNumber": "string",
    "Case_Owner_at_Close__c": "string",
    "Case_Survey_ID__c": "string",
    "Category__c": "string",
    "Category_new__c": "string",
    "ChargeOverId__c": "string",
    "Clone_softwaresetting__c": "string",
    "Clone_website_namefacility__c": "string",
    "CloseDate": "string",
    "ClosedDate": "string",
    "Closed_Reason__c": "string",
    "Comments": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Construction_openbusiness__c": "string",
    "ConsultationReasonDetails__c": "string",
    "ConsultationReason__c": "string",
    "ConsultationSize__c": "string",
    "ContactEmail": "string",
    "ContactFax": "string",
    "ContactId": "string",
    "ContactMobile": "string",
    "ContactPhone": "string",
    "ContactsEmail__c": "string",
    "ContactsName__c": "string",
    "ContactsPhone__c": "string",
    "Continue_software_service__c": "string",
    "Conversion_Complete_Date__c": "string",
    "Conversion_Scheduled_Date__c": "string",
    "Convertfromspreadsheet__c": "string",
    "CorpCode__c": "string",
    "CorpLocationID__c": "string",
    "Corp_Code_Search__c": "string",
    "CreateImplementationCase__c": "string",
    "CreatePCIrequestforSLMS__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CreditCardCVV__c": "string",
    "CreditCardExpiration__c": "string",
    "CreditCardName__c": "string",
    "CreditCardNetwork__c": "string",
    "CreditCardNumber__c": "string",
    "CurrencyIsoCode": "string",
    "Current_FMS__c": "string",
    "Current_Gate__c": "string",
    "Current_Insurance__c": "string",
    "Current_Marketplace__c": "string",
    "Current_Payment__c": "string",
    "Current_Software_Provider__c": "string",
    "Current_Website__c": "string",
    "DatawireID__c": "string",
    "Date_Assigned_to_Tech__c": "string",
    "Date_Signed__c": "string",
    "Date_Time_CSAT_Expiration__c": "string",
    "Date_start_software__c": "string",
    "Date_to_be_released__c": "string",
    "DebookedReason__c": "string",
    "Department__c": "string",
    "Description": "string",
    "Development_Priority__c": "string",
    "DisablePayeezydate__c": "string",
    "DiscontinueProductDate__c": "string",
    "Discount_Amount__c": "string",
    "Discount_Period__c": "string",
    "Discountgroup__c": "string",
    "Disposition_Estimate_Reason__c": "string",
    "Disposition_Estimate__c": "string",
    "Due_Date__c": "string",
    "EmailSubjectAddition__c": "string",
    "Email_Received_Count__c": "string",
    "EnableCustomInsurance__c": "string",
    "Enable_Storable_Payments__c": "string",
    "EntitlementId": "string",
    "EscalatedByDepartment__c": "string",
    "EscalatedById__c": "string",
    "EscalatedDate__c": "string",
    "EscalationReasonDetails__c": "string",
    "EscalationReason__c": "string",
    "Exempting_Manager__c": "string",
    "Exemption_Notes__c": "string",
    "ExistingCaseurl__c": "string",
    "Existing_Corp_Code__c": "string",
    "Existing_Logo_Corp_Code__c": "string",
    "ExpectedBehavior__c": "string",
    "ExpectedRevenue": "string",
    "FMSLaunchDate__c": "string",
    "FMS_Status__c": "string",
    "Facility_Cancel_List__c": "string",
    "Facility_Phone_Number__c": "string",
    "Facility_clone__c": "string",
    "FirstAssignedDate__c": "string",
    "FirstClosedDate__c": "string",
    "First_Response_Date__c": "string",
    "ForecastCategory": "string",
    "Form_Response_Record__c": "string",
    "Fulfillment_Status__c": "string",
    "Generate_ATB__c": "string",
    "Google_My_Business_Listing__c": "string",
    "HQMerchantID__c": "string",
    "Hardware_Tracking__c": "string",
    "HasCommentsUnreadByOwner": "string",
    "HasSelfServiceComments": "string",
    "Historical_Data_Selection__c": "string",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "ImplementationNotes__c": "string",
    "Implementation_CSAT_Comment__c": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Support_Score__c": "string",
    "Inbound_Call_Count__c": "string",
    "Include_In_Immediate_Release__c": "string",
    "Initial_Response_Milestone_Achieved__c": "string",
    "Insurance_Product_to_Cancel__c": "string",
    "Interest_Digital_Marketing__c": "string",
    "Interest_Sparefoot_facility__c": "string",
    "Interest_in_CallPotential__c": "string",
    "Interested_in_Data_Archive__c": "string",
    "Interested_in_Data_Decryption__c": "string",
    "IsClosed": "string",
    "IsClosedOnCreate": "string",
    "IsDeleted": "string",
    "IsEscalated": "string",
    "IsSelfServiceClosed": "string",
    "IsStopped": "string",
    "IsVisibleInSelfService": "string",
    "JIRAIssue__c": "string",
    "JotForm_URL__c": "string",
    "Language": "string",
    "LastInboundDate__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LastOutboundDate__c": "string",
    "Last_Call_ID__c": "string",
    "Last_Comment_Date__c": "string",
    "Last_Email_Comment_SentBy__c": "string",
    "Launch_Time__c": "string",
    "License_Holder__c": "string",
    "List_Note__c": "string",
    "Loc_Code_Preference__c": "string",
    "LocationCode__c": "string",
    "Location_Code__c": "string",
    "MRR_Total__c": "string",
    "MS_Preapplication_JotForm__c": "string",
    "ManageCompany_Ownersame__c": "string",
    "Managesoftware_convert__c": "string",
    "MasterICowner__c": "string",
    "MasterRecordId": "string",
    "MaxofUnits__c": "string",
    "Merch_Provider_Facility__c": "string",
    "MerchantID__c": "string",
    "Message_Sent_Count__c": "string",
    "Messaging_Session__c": "string",
    "MilestoneStatus": "string",
    "Most_Recent_Case_Comment__c": "string",
    "Name_Facility_Purchase__c": "string",
    "Net_MRR_Total__c": "string",
    "Net_MRR_Value__c": "string",
    "NewConstruction__c": "string",
    "NewProduct__c": "string",
    "NewWebsite_ExistingDomain__c": "string",
    "Onethingwecouldhavedonedifferently__c": "string",
    "OpportunityId": "string",
    "Opportunity_Required_Approval__c": "string",
    "Opportunity__c": "string",
    "Order_Product__c": "string",
    "Origin": "string",
    "OriginalLeaseDate__c": "string",
    "Original_Launch_Date__c": "string",
    "Original_Tech_Owner__c": "string",
    "Originating_CSF_Case__c": "string",
    "Originating_Opportunity_Product__c": "string",
    "Other_Access_Cancellation_Details__c": "string",
    "Other_CallPotential_Cancellation_Details__c": "string",
    "Other_Marketplace_Cancellation_Details__c": "string",
    "Other_Merch_Provider__c": "string",
    "Other_Payments_Cancellation_Details__c": "string",
    "Other_Software_Cancellation_Details__c": "string",
    "Other_Software_Provider__c": "string",
    "Other_Website_Cancellation_Details__c": "string",
    "Other_Website_Provider__c": "string",
    "Outbound_Call_Count__c": "string",
    "OwnerId": "string",
    "PDK_RMA_Backbill_Complete__c": "string",
    "PDK_RMA_Complete__c": "string",
    "PDK_RMA_Email_Sent__c": "string",
    "PDK_RMA__c": "string",
    "PPS_Cleanup_Tool__c": "string",
    "ParentId": "string",
    "Payment_or_Other_Product_to_Cancel__c": "string",
    "PreBoardingTaskscompleted__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Price__c": "string",
    "Priority": "string",
    "Probability": "string",
    "ProductId": "string",
    "Product_Family__c": "string",
    "Product__c": "string",
    "Product_new__c": "string",
    "ProductfeatureorImprovement__c": "string",
    "ProductsatRisk__c": "string",
    "ProjectedGoLiveDateConfidence__c": "string",
    "Projected_Live_Date__c": "string",
    "Public_Comment_Sent_Count__c": "string",
    "PurchFacility_SL_SE_ESS__c": "string",
    "Purchase_Order_ACH__c": "string",
    "Purchaser_Email__c": "string",
    "Purchaser_Phone__c": "string",
    "Quoted_Price__c": "string",
    "RateChange__c": "string",
    "Reason": "string",
    "ReasonDetailsifCOVID19__c": "string",
    "ReasonDetailsifother__c": "string",
    "Reason_Cancel_Access_Control__c": "string",
    "Reason_Cancel_CallPotential__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",
    "ReasonforCancellation__c": "string",
    "ReasonforCancellationold__c": "string",
    "Reasonforleaving__c": "string",
    "Received_At__c": "string",
    "Received_by__c": "string",
    "Recipient_Email__c": "string",
    "Recipient_Facility_Name__c": "string",
    "Recipient_Name__c": "string",
    "RecordTypeId": "string",
    "Reference_Opportunity__c": "string",
    "Refund_Method__c": "string",
    "RelatedCase__c": "string",
    "RelatedOpptyClosedwonPortfolio__c": "string",
    "RelatedOpptyClosedwonStandard__c": "string",
    "Related_Opportunity_Amended__c": "string",
    "Release_Date__c": "string",
    "Release_domain_name_website__c": "string",
    "Reopen_Count__c": "string",
    "Reply_To_Email__c": "string",
    "RequestedCancellationDate__c": "string",
    "Requester_Email__c": "string",
    "Require_T1_Support__c": "string",
    "Resolution_Disposition__c": "string",
    "Resolution_Health__c": "string",
    "Response_Health__c": "string",
    "Revised_Quantity__c": "string",
    "RocketLane_Payments_URL__c": "string",
    "RocketLane_Product_List__c": "string",
    "RocketLane_Project_Notes__c": "string",
    "RocketLane_Project_URL__c": "string",
    "SEFMSID__c": "string",
    "SE_Billing_Email__c": "string",
    "SE_Facility_UUID__c": "string",
    "SE_Support_Email__c": "string",
    "SFClientKey__c": "string",
    "SFDemandinScopeExistingSFCustome__c": "string",
    "SF_Billing_Email__c": "string",
    "SF_Demand_in_scope_new_customer__c": "string",
    "SFfacilitykeyChildfacility__c": "string",
    "SLCorpCode__c": "string",
    "SLLocationCode__c": "string",
    "SLMSAccount__c": "string",
    "SSL_Renewal_Date__c": "string",
    "Send_Secure_Emails__c": "string",
    "ServiceContractId": "string",
    "Settings_Form_Received_On__c": "string",
    "Setupcasecreated__c": "string",
    "Shipping_Provider__c": "string",
    "Site_Status__c": "string",
    "SlaExitDate": "string",
    "SlaStartDate": "string",
    "Software_Products_to_Cancel__c": "string",
    "Software_forwardfacility__c": "string",
    "SourceId": "string",
    "SpareFoot_Product_to_Cancel__c": "string",
    "StageName": "string",
    "Start_Case_Auto_Close_Process_Date__c": "string",
    "Start_Case_Auto_Close_Process__c": "string",
    "Statement_ID__c": "string",
    "Status": "string",
    "StatusReasonlastupdated__c": "string",
    "Status_Reason__c": "string",
    "StepstoReproduce__c": "string",
    "StopStartDate": "string",
    "SubType_1__c": "string",
    "SubType_2__c": "string",
    "SubType_3_c__c": "string",
    "Sub_Category__c": "string",
    "Subject": "string",
    "SuppliedCompany": "string",
    "SuppliedEmail": "string",
    "SuppliedName": "string",
    "SuppliedPhone": "string",
    "Suppress_Automated_Emails__c": "string",
    "SuspendedBy__c": "string",
    "SuspendedDate__c": "string",
    "Synched_to_Netsuite__c": "string",
    "SystemModstamp": "string",
    "Tax_rate_on_rent__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",
    "Type": "string",
    "Type__c": "string",
    "Ultimate_Parent_Account_Name__c": "string",
    "Units__c": "string",
    "Upsell_or_Transfer__c": "string",
    "Use_Gate_Software_Provider__c": "string",
    "Use_Sparefoot_facility__c": "string",
    "Validation_Rule_Toggle__c": "string",
    "Vanilla__ForumUrl__c": "string",
    "VoyagerMigrationEnabled__c": "string",
    "WebsiteProvider_Facility__c": "string",
    "Website_Cancellation_URL__c": "string",
    "Website_Products_to_Cancel__c": "string",
    "Website__c": "string",
    "Your_SL_CorpCode__c": "string",
    "Zendesk_Ticket_ID__c": "string",
    "Zendesk_Ticket_URL__c": "string",
    "dCreated__c": "string",
    "monthlygroup__c": "string"
}
    • schema_name_id: 2082
    • schema_scan_id: 6510761
    • updated: 2024-06-10 15:37:17
    • created: 2024-01-11 09:15:22
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_cases`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_cases`\n(\n `Id`  string , `IsDeleted`  string , `MasterRecordId`  string , `CaseNumber`  string , `ContactId`  string , `AccountId`  string , `AssetId`  string , `ProductId`  string , `EntitlementId`  string , `SourceId`  string , `BusinessHoursId`  string , `ParentId`  string , `SuppliedName`  string , `SuppliedEmail`  string , `SuppliedPhone`  string , `SuppliedCompany`  string , `Type`  string , `RecordTypeId`  string , `Status`  string , `Reason`  string , `Origin`  string , `Language`  string , `IsVisibleInSelfService`  string , `Subject`  string , `Priority`  string , `Description`  string , `IsClosed`  string , `ClosedDate`  string , `IsEscalated`  string , `HasCommentsUnreadByOwner`  string , `HasSelfServiceComments`  string , `CurrencyIsoCode`  string , `OwnerId`  string , `IsClosedOnCreate`  string , `IsSelfServiceClosed`  string , `SlaStartDate`  string , `SlaExitDate`  string , `IsStopped`  string , `StopStartDate`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ContactPhone`  string , `ContactMobile`  string , `ContactEmail`  string , `ContactFax`  string , `Comments`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `ServiceContractId`  string , `MilestoneStatus`  string , `dCreated__c`  string , `ACH_Reject_Value__c`  string , `Actual_Hours__c`  string , `Due_Date__c`  string , `PreBoardingTaskscompleted__c`  string , `MS_Preapplication_JotForm__c`  string , `Original_Tech_Owner__c`  string , `Product__c`  string , `Type__c`  string , `SubType_1__c`  string , `SubType_2__c`  string , `Development_Priority__c`  string , `Outbound_Call_Count__c`  string , `Approved_for_Development__c`  string , `Department__c`  string , `Category__c`  string , `Assigned_Tech__c`  string , `Conversion_Complete_Date__c`  string , `Conversion_Scheduled_Date__c`  string , `Date_Assigned_to_Tech__c`  string , `Purchaser_Email__c`  string , `Requester_Email__c`  string , `Quoted_Price__c`  string , `Last_Call_ID__c`  string , `CreatePCIrequestforSLMS__c`  string , `Corp_Code_Search__c`  string , `Include_In_Immediate_Release__c`  string , `Actual_Hours_User__c`  string , `CSAT_Resend__c`  string , `Disposition_Estimate__c`  string , `Disposition_Estimate_Reason__c`  string , `Last_Email_Comment_SentBy__c`  string , `SubType_3_c__c`  string , `Last_Comment_Date__c`  string , `SuspendedDate__c`  string , `SuspendedBy__c`  string , `Purchaser_Phone__c`  string , `Google_My_Business_Listing__c`  string , `RateChange__c`  string , `IGD__Collection_Id__c`  string , `Reference_Opportunity__c`  string , `Opportunity__c`  string , `FirstClosedDate__c`  string , `Assignment_Health__c`  string , `Response_Health__c`  string , `Resolution_Health__c`  string , `Generate_ATB__c`  string , `EscalatedDate__c`  string , `EscalationReason__c`  string , `ACS_quotehardware__c`  string , `EscalationReasonDetails__c`  string , `EscalatedById__c`  string , `EscalatedByDepartment__c`  string , `Auto_Closed__c`  string , `Inbound_Call_Count__c`  string , `LastOutboundDate__c`  string , `Vanilla__ForumUrl__c`  string , `FirstAssignedDate__c`  string , `SF_Demand_in_scope_new_customer__c`  string , `EnableCustomInsurance__c`  string , `SFDemandinScopeExistingSFCustome__c`  string , `ExpectedBehavior__c`  string , `JIRAIssue__c`  string , `StepstoReproduce__c`  string , `Projected_Live_Date__c`  string , `Site_Status__c`  string , `Existing_Logo_Corp_Code__c`  string , `DisablePayeezydate__c`  string , `ProjectedGoLiveDateConfidence__c`  string , `LastInboundDate__c`  string , `Access_after_Transfer__c`  string , `Units__c`  string , `FMSLaunchDate__c`  string , `Category_new__c`  string , `CreateImplementationCase__c`  string , `Website__c`  string , `ImplementationNotes__c`  string , `Product_new__c`  string , `NewConstruction__c`  string , `Opportunity_Required_Approval__c`  string , `Current_FMS__c`  string , `SSL_Renewal_Date__c`  string , `Current_Website__c`  string , `Status_Reason__c`  string , `SE_Billing_Email__c`  string , `SF_Billing_Email__c`  string , `SE_Support_Email__c`  string , `Current_Gate__c`  string , `Current_Insurance__c`  string , `Current_Marketplace__c`  string , `Current_Payment__c`  string , `Net_MRR_Value__c`  string , `Case_Owner_at_Close__c`  string , `Discount_Amount__c`  string , `Settings_Form_Received_On__c`  string , `Discount_Period__c`  string , `Related_Opportunity_Amended__c`  string , `Assetrequired__c`  string , `Closed_Reason__c`  string , `MaxofUnits__c`  string , `Case_Survey_ID__c`  string , `Start_Case_Auto_Close_Process__c`  string , `Product_Family__c`  string , `Initial_Response_Milestone_Achieved__c`  string , `Most_Recent_Case_Comment__c`  string , `Brand__c`  string , `Resolution_Disposition__c`  string , `Access_point_restrict_keypad__c`  string , `RelatedOpptyClosedwonPortfolio__c`  string , `RelatedOpptyClosedwonStandard__c`  string , `Received_by__c`  string , `AdditionalNotes__c`  string , `List_Note__c`  string , `ContactsEmail__c`  string , `ContactsName__c`  string , `ContactsPhone__c`  string , `CorpCode__c`  string , `ExistingCaseurl__c`  string , `LocationCode__c`  string , `ProductsatRisk__c`  string , `ReasonforCancellationold__c`  string , `RequestedCancellationDate__c`  string , `BillableEntityID__c`  string , `CancelinBillingDate__c`  string , `ChargeOverId__c`  string , `CorpLocationID__c`  string , `NewProduct__c`  string , `OriginalLeaseDate__c`  string , `SFfacilitykeyChildfacility__c`  string , `SLMSAccount__c`  string , `BillingNotes__c`  string , `DiscontinueProductDate__c`  string , `ACHID__c`  string , `First_Response_Date__c`  string , `Suppress_Automated_Emails__c`  string , `Accesspointrestrict__c`  string , `SFClientKey__c`  string , `SEFMSID__c`  string , `SLCorpCode__c`  string , `SLLocationCode__c`  string , `MerchantID__c`  string , `Reopen_Count__c`  string , `DatawireID__c`  string , `Zendesk_Ticket_URL__c`  string , `Zendesk_Ticket_ID__c`  string , `ReasonforCancellation__c`  string , `HQMerchantID__c`  string , `MasterICowner__c`  string , `Enable_Storable_Payments__c`  string , `Activate_Storable_Payments__c`  string , `JotForm_URL__c`  string , `Setupcasecreated__c`  string , `Message_Sent_Count__c`  string , `Email_Received_Count__c`  string , `Public_Comment_Sent_Count__c`  string , `StatusReasonlastupdated__c`  string , `CSAT_Sent__c`  string , `CSAT_Combined_Score__c`  string , `Cancellationnoticesent__c`  string , `Onethingwecouldhavedonedifferently__c`  string , `ProductfeatureorImprovement__c`  string , `Reasonforleaving__c`  string , `ReasonDetailsifother__c`  string , `ReasonDetailsifCOVID19__c`  string , `DebookedReason__c`  string , `CSAT_Date_Time_Sent__c`  string , `CSAT_Support_Score__c`  string , `CSAT_Product_Score__c`  string , `CSAT_NPS__c`  string , `CSAT_Date_Time_Completed__c`  string , `CSAT_Comment__c`  string , `AuthGroup__c`  string , `monthlygroup__c`  string , `Discountgroup__c`  string , `Annualgroup__c`  string , `Date_Time_CSAT_Expiration__c`  string , `RelatedCase__c`  string , `Price__c`  string , `Additional_Comment__c`  string , `VoyagerMigrationEnabled__c`  string , `Any_Portable_Units__c`  string , `Archive_Option_email_address__c`  string , `ConsultationSize__c`  string , `ConsultationReason__c`  string , `ConsultationReasonDetails__c`  string , `Clone_softwaresetting__c`  string , `Sub_Category__c`  string , `Access_Control_Products_to_Cancel__c`  string , `Asset_Product_Cancel_List__c`  string , `Facility_Cancel_List__c`  string , `Form_Response_Record__c`  string , `Insurance_Product_to_Cancel__c`  string , `Payment_or_Other_Product_to_Cancel__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 , `Software_Products_to_Cancel__c`  string , `SpareFoot_Product_to_Cancel__c`  string , `Website_Products_to_Cancel__c`  string , `Website_Cancellation_URL__c`  string , `Hardware_Tracking__c`  string , `BillingPaymentMethod__c`  string , `BillingName__c`  string , `BillingCity__c`  string , `BillingPostalCode__c`  string , `BillingStreet__c`  string , `BillingRegion__c`  string , `BillingCountry__c`  string , `CreditCardNetwork__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 , `ACHInstitutionName__c`  string , `ACHInstitutionCity__c`  string , `ACHInstitutionRegion__c`  string , `ACHInstitutionPostalCode__c`  string , `CreditCardName__c`  string , `Fulfillment_Status__c`  string , `Shipping_Provider__c`  string , `Date_start_software__c`  string , `Auto_Reminder_Email_Sent__c`  string , `Interested_in_Data_Archive__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 , `Software_forwardfacility__c`  string , `Tax_rate_on_rent__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 , `Use_Gate_Software_Provider__c`  string , `Use_Sparefoot_facility__c`  string , `WebsiteProvider_Facility__c`  string , `Your_SL_CorpCode__c`  string , `Purchase_Order_ACH__c`  string , `SE_Facility_UUID__c`  string , `Refund_Method__c`  string , `PDK_RMA__c`  string , `EmailSubjectAddition__c`  string , `Synched_to_Netsuite__c`  string , `PDK_RMA_Complete__c`  string , `PDK_RMA_Email_Sent__c`  string , `Upsell_or_Transfer__c`  string , `Originating_Opportunity_Product__c`  string , `Revised_Quantity__c`  string , `Validation_Rule_Toggle__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_CSAT_Comment__c`  string , `Implementation_Product_Score__c`  string , `Exemption_Notes__c`  string , `Exempting_Manager__c`  string , `CSAT_Close_Email_Exempt__c`  string , `Auto_Reminder_Email_Sent_Date__c`  string , `Start_Case_Auto_Close_Process_Date__c`  string , `Other_Software_Cancellation_Details__c`  string , `Other_Website_Cancellation_Details__c`  string , `Other_Marketplace_Cancellation_Details__c`  string , `Other_Access_Cancellation_Details__c`  string , `Other_Payments_Cancellation_Details__c`  string , `AC_Hardware_Installment_Loan__c`  string , `AC_Hardware_Installment_Months__c`  string , `Implementation_Support_Score__c`  string , `Order_Product__c`  string , `Send_Secure_Emails__c`  string , `RocketLane_Product_List__c`  string , `RocketLane_Project_Notes__c`  string , `RocketLane_Project_URL__c`  string , `Original_Launch_Date__c`  string , `Launch_Time__c`  string , `Require_T1_Support__c`  string , `MRR_Total__c`  string , `Net_MRR_Total__c`  string , `Originating_CSF_Case__c`  string , `Reply_To_Email__c`  string , `CallPotential_Products_to_Cancel__c`  string , `Other_CallPotential_Cancellation_Details__c`  string , `Reason_Cancel_CallPotential__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/cases/2024-01-11/1704986067'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_cases"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/cases/2024-01-11/1704986067
    • id: 4700519
    • processed: 1
    • raw_data: 
      {
    "ACHID__c": 185,
    "ACHInstitutionCity__c": 272,
    "ACHInstitutionName__c": 271,
    "ACHInstitutionPostalCode__c": 274,
    "ACHInstitutionRegion__c": 273,
    "ACH_Reject_Value__c": 54,
    "ACS_quotehardware__c": 102,
    "AC_Hardware_Installment_Loan__c": 340,
    "AC_Hardware_Installment_Months__c": 341,
    "Access_Control_Products_to_Cancel__c": 240,
    "Access_after_Transfer__c": 123,
    "Access_point_restrict_keypad__c": 160,
    "Accesspointrestrict__c": 188,
    "AccountId": 5,
    "Activate_Storable_Payments__c": 202,
    "Actual_Hours_User__c": 80,
    "Actual_Hours__c": 55,
    "AdditionalNotes__c": 164,
    "Additional_Comment__c": 231,
    "Annualgroup__c": 227,
    "Any_Portable_Units__c": 233,
    "Approved_for_Development__c": 66,
    "Archive_Option_email_address__c": 234,
    "AssetId": 6,
    "Asset_Product_Cancel_List__c": 241,
    "Assetrequired__c": 150,
    "Assigned_Tech__c": 69,
    "Assignment_Health__c": 96,
    "AuthGroup__c": 224,
    "Auto_Closed__c": 106,
    "Auto_Reminder_Email_Sent_Date__c": 333,
    "Auto_Reminder_Email_Sent__c": 279,
    "BillableEntityID__c": 175,
    "BillingCity__c": 259,
    "BillingCountry__c": 263,
    "BillingName__c": 258,
    "BillingNotes__c": 183,
    "BillingPaymentMethod__c": 257,
    "BillingPostalCode__c": 260,
    "BillingRegion__c": 262,
    "BillingStreet__c": 261,
    "Brand__c": 158,
    "BusinessHoursId": 10,
    "CSAT_Close_Email_Exempt__c": 332,
    "CSAT_Combined_Score__c": 210,
    "CSAT_Comment__c": 223,
    "CSAT_Date_Time_Completed__c": 222,
    "CSAT_Date_Time_Sent__c": 218,
    "CSAT_NPS__c": 221,
    "CSAT_Product_Score__c": 220,
    "CSAT_Resend__c": 81,
    "CSAT_Sent__c": 209,
    "CSAT_Support_Score__c": 219,
    "CallPotential_Products_to_Cancel__c": 355,
    "CancelinBillingDate__c": 176,
    "Cancellationnoticesent__c": 211,
    "CaseNumber": 3,
    "Case_Owner_at_Close__c": 145,
    "Case_Survey_ID__c": 153,
    "Category__c": 68,
    "Category_new__c": 126,
    "ChargeOverId__c": 177,
    "Clone_softwaresetting__c": 238,
    "Clone_website_namefacility__c": 265,
    "ClosedDate": 27,
    "Closed_Reason__c": 151,
    "Comments": 48,
    "ConnectionReceivedId": 49,
    "ConnectionSentId": 50,
    "Construction_openbusiness__c": 266,
    "ConsultationReasonDetails__c": 237,
    "ConsultationReason__c": 236,
    "ConsultationSize__c": 235,
    "ContactEmail": 46,
    "ContactFax": 47,
    "ContactId": 4,
    "ContactMobile": 45,
    "ContactPhone": 44,
    "ContactsEmail__c": 166,
    "ContactsName__c": 167,
    "ContactsPhone__c": 168,
    "Continue_software_service__c": 267,
    "Conversion_Complete_Date__c": 70,
    "Conversion_Scheduled_Date__c": 71,
    "Convertfromspreadsheet__c": 268,
    "CorpCode__c": 169,
    "CorpLocationID__c": 178,
    "Corp_Code_Search__c": 78,
    "CreateImplementationCase__c": 127,
    "CreatePCIrequestforSLMS__c": 77,
    "CreatedById": 40,
    "CreatedDate": 39,
    "CreditCardName__c": 275,
    "CreditCardNetwork__c": 264,
    "CurrencyIsoCode": 31,
    "Current_FMS__c": 133,
    "Current_Gate__c": 140,
    "Current_Insurance__c": 141,
    "Current_Marketplace__c": 142,
    "Current_Payment__c": 143,
    "Current_Software_Provider__c": 269,
    "Current_Website__c": 135,
    "DatawireID__c": 195,
    "Date_Assigned_to_Tech__c": 72,
    "Date_Signed__c": 270,
    "Date_Time_CSAT_Expiration__c": 228,
    "Date_start_software__c": 278,
    "Date_to_be_released__c": 281,
    "DebookedReason__c": 217,
    "Department__c": 67,
    "Description": 25,
    "Development_Priority__c": 64,
    "DisablePayeezydate__c": 120,
    "DiscontinueProductDate__c": 184,
    "Discount_Amount__c": 146,
    "Discount_Period__c": 148,
    "Discountgroup__c": 226,
    "Disposition_Estimate_Reason__c": 83,
    "Disposition_Estimate__c": 82,
    "Due_Date__c": 56,
    "EmailSubjectAddition__c": 319,
    "Email_Received_Count__c": 206,
    "EnableCustomInsurance__c": 112,
    "Enable_Storable_Payments__c": 201,
    "EntitlementId": 8,
    "EscalatedByDepartment__c": 105,
    "EscalatedById__c": 104,
    "EscalatedDate__c": 100,
    "EscalationReasonDetails__c": 103,
    "EscalationReason__c": 101,
    "Exempting_Manager__c": 331,
    "Exemption_Notes__c": 330,
    "ExistingCaseurl__c": 170,
    "Existing_Corp_Code__c": 282,
    "Existing_Logo_Corp_Code__c": 119,
    "ExpectedBehavior__c": 114,
    "FMSLaunchDate__c": 125,
    "Facility_Cancel_List__c": 242,
    "Facility_clone__c": 283,
    "FirstAssignedDate__c": 110,
    "FirstClosedDate__c": 95,
    "First_Response_Date__c": 186,
    "Form_Response_Record__c": 243,
    "Fulfillment_Status__c": 276,
    "Generate_ATB__c": 99,
    "Google_My_Business_Listing__c": 90,
    "HQMerchantID__c": 199,
    "Hardware_Tracking__c": 256,
    "HasCommentsUnreadByOwner": 29,
    "HasSelfServiceComments": 30,
    "Historical_Data_Selection__c": 284,
    "IGD__Collection_Id__c": 92,
    "Id": 0,
    "ImplementationNotes__c": 129,
    "Implementation_CSAT_Comment__c": 328,
    "Implementation_Combined_Score__c": 327,
    "Implementation_Product_Score__c": 329,
    "Implementation_Support_Score__c": 342,
    "Inbound_Call_Count__c": 107,
    "Include_In_Immediate_Release__c": 79,
    "Initial_Response_Milestone_Achieved__c": 156,
    "Insurance_Product_to_Cancel__c": 244,
    "Interest_Digital_Marketing__c": 285,
    "Interest_Sparefoot_facility__c": 286,
    "Interested_in_Data_Archive__c": 280,
    "IsClosed": 26,
    "IsClosedOnCreate": 33,
    "IsDeleted": 1,
    "IsEscalated": 28,
    "IsSelfServiceClosed": 34,
    "IsStopped": 37,
    "IsVisibleInSelfService": 22,
    "JIRAIssue__c": 115,
    "JotForm_URL__c": 203,
    "Language": 21,
    "LastInboundDate__c": 122,
    "LastModifiedById": 42,
    "LastModifiedDate": 41,
    "LastOutboundDate__c": 108,
    "Last_Call_ID__c": 76,
    "Last_Comment_Date__c": 86,
    "Last_Email_Comment_SentBy__c": 84,
    "Launch_Time__c": 349,
    "License_Holder__c": 287,
    "List_Note__c": 165,
    "Loc_Code_Preference__c": 288,
    "LocationCode__c": 171,
    "Location_Code__c": 289,
    "MRR_Total__c": 351,
    "MS_Preapplication_JotForm__c": 58,
    "ManageCompany_Ownersame__c": 290,
    "Managesoftware_convert__c": 291,
    "MasterICowner__c": 200,
    "MasterRecordId": 2,
    "MaxofUnits__c": 152,
    "Merch_Provider_Facility__c": 292,
    "MerchantID__c": 193,
    "Message_Sent_Count__c": 205,
    "MilestoneStatus": 52,
    "Most_Recent_Case_Comment__c": 157,
    "Name_Facility_Purchase__c": 293,
    "Net_MRR_Total__c": 352,
    "Net_MRR_Value__c": 144,
    "NewConstruction__c": 131,
    "NewProduct__c": 179,
    "NewWebsite_ExistingDomain__c": 294,
    "Onethingwecouldhavedonedifferently__c": 212,
    "Opportunity_Required_Approval__c": 132,
    "Opportunity__c": 94,
    "Order_Product__c": 343,
    "Origin": 20,
    "OriginalLeaseDate__c": 180,
    "Original_Launch_Date__c": 348,
    "Original_Tech_Owner__c": 59,
    "Originating_CSF_Case__c": 353,
    "Originating_Opportunity_Product__c": 324,
    "Other_Access_Cancellation_Details__c": 338,
    "Other_CallPotential_Cancellation_Details__c": 356,
    "Other_Marketplace_Cancellation_Details__c": 337,
    "Other_Merch_Provider__c": 295,
    "Other_Payments_Cancellation_Details__c": 339,
    "Other_Software_Cancellation_Details__c": 335,
    "Other_Software_Provider__c": 296,
    "Other_Website_Cancellation_Details__c": 336,
    "Other_Website_Provider__c": 297,
    "Outbound_Call_Count__c": 65,
    "OwnerId": 32,
    "PDK_RMA_Complete__c": 321,
    "PDK_RMA_Email_Sent__c": 322,
    "PDK_RMA__c": 318,
    "ParentId": 11,
    "Payment_or_Other_Product_to_Cancel__c": 245,
    "PreBoardingTaskscompleted__c": 57,
    "Price__c": 230,
    "Priority": 24,
    "ProductId": 7,
    "Product_Family__c": 155,
    "Product__c": 60,
    "Product_new__c": 130,
    "ProductfeatureorImprovement__c": 213,
    "ProductsatRisk__c": 172,
    "ProjectedGoLiveDateConfidence__c": 121,
    "Projected_Live_Date__c": 117,
    "Public_Comment_Sent_Count__c": 207,
    "PurchFacility_SL_SE_ESS__c": 298,
    "Purchase_Order_ACH__c": 315,
    "Purchaser_Email__c": 73,
    "Purchaser_Phone__c": 89,
    "Quoted_Price__c": 75,
    "RateChange__c": 91,
    "Reason": 19,
    "ReasonDetailsifCOVID19__c": 216,
    "ReasonDetailsifother__c": 215,
    "Reason_Cancel_Access_Control__c": 246,
    "Reason_Cancel_CallPotential__c": 357,
    "Reason_Cancel_Insurance__c": 247,
    "Reason_Cancel_Payment_or_Other_Product__c": 248,
    "Reason_Cancel_Software_Product__c": 249,
    "Reason_Cancel_SpareFoot__c": 250,
    "Reason_Cancel_Website_Product__c": 251,
    "ReasonforCancellation__c": 198,
    "ReasonforCancellationold__c": 173,
    "Reasonforleaving__c": 214,
    "Received_by__c": 163,
    "Recipient_Email__c": 299,
    "Recipient_Facility_Name__c": 300,
    "Recipient_Name__c": 301,
    "RecordTypeId": 17,
    "Reference_Opportunity__c": 93,
    "Refund_Method__c": 317,
    "RelatedCase__c": 229,
    "RelatedOpptyClosedwonPortfolio__c": 161,
    "RelatedOpptyClosedwonStandard__c": 162,
    "Related_Opportunity_Amended__c": 149,
    "Release_Date__c": 302,
    "Release_domain_name_website__c": 303,
    "Reopen_Count__c": 194,
    "Reply_To_Email__c": 354,
    "RequestedCancellationDate__c": 174,
    "Requester_Email__c": 74,
    "Require_T1_Support__c": 350,
    "Resolution_Disposition__c": 159,
    "Resolution_Health__c": 98,
    "Response_Health__c": 97,
    "Revised_Quantity__c": 325,
    "RocketLane_Product_List__c": 345,
    "RocketLane_Project_Notes__c": 346,
    "RocketLane_Project_URL__c": 347,
    "SEFMSID__c": 190,
    "SE_Billing_Email__c": 137,
    "SE_Facility_UUID__c": 316,
    "SE_Support_Email__c": 139,
    "SFClientKey__c": 189,
    "SFDemandinScopeExistingSFCustome__c": 113,
    "SF_Billing_Email__c": 138,
    "SF_Demand_in_scope_new_customer__c": 111,
    "SFfacilitykeyChildfacility__c": 181,
    "SLCorpCode__c": 191,
    "SLLocationCode__c": 192,
    "SLMSAccount__c": 182,
    "SSL_Renewal_Date__c": 134,
    "Send_Secure_Emails__c": 344,
    "ServiceContractId": 51,
    "Settings_Form_Received_On__c": 147,
    "Setupcasecreated__c": 204,
    "Shipping_Provider__c": 277,
    "Site_Status__c": 118,
    "SlaExitDate": 36,
    "SlaStartDate": 35,
    "Software_Products_to_Cancel__c": 252,
    "Software_forwardfacility__c": 304,
    "SourceId": 9,
    "SpareFoot_Product_to_Cancel__c": 253,
    "Start_Case_Auto_Close_Process_Date__c": 334,
    "Start_Case_Auto_Close_Process__c": 154,
    "Status": 18,
    "StatusReasonlastupdated__c": 208,
    "Status_Reason__c": 136,
    "StepstoReproduce__c": 116,
    "StopStartDate": 38,
    "SubType_1__c": 62,
    "SubType_2__c": 63,
    "SubType_3_c__c": 85,
    "Sub_Category__c": 239,
    "Subject": 23,
    "SuppliedCompany": 15,
    "SuppliedEmail": 13,
    "SuppliedName": 12,
    "SuppliedPhone": 14,
    "Suppress_Automated_Emails__c": 187,
    "SuspendedBy__c": 88,
    "SuspendedDate__c": 87,
    "Synched_to_Netsuite__c": 320,
    "SystemModstamp": 43,
    "Tax_rate_on_rent__c": 305,
    "Tenant_Insurance_Facility__c": 306,
    "Transferee_Company_Name__c": 307,
    "Transferee_Email__c": 308,
    "Transferee_Phone_Number__c": 309,
    "Transferee_Primary_Contact__c": 310,
    "Type": 16,
    "Type__c": 61,
    "Units__c": 124,
    "Upsell_or_Transfer__c": 323,
    "Use_Gate_Software_Provider__c": 311,
    "Use_Sparefoot_facility__c": 312,
    "Validation_Rule_Toggle__c": 326,
    "Vanilla__ForumUrl__c": 109,
    "VoyagerMigrationEnabled__c": 232,
    "WebsiteProvider_Facility__c": 313,
    "Website_Cancellation_URL__c": 255,
    "Website_Products_to_Cancel__c": 254,
    "Website__c": 128,
    "Your_SL_CorpCode__c": 314,
    "Zendesk_Ticket_ID__c": 197,
    "Zendesk_Ticket_URL__c": 196,
    "dCreated__c": 53,
    "monthlygroup__c": 225
}
    • schema_attributes: 
      {
    "ACHAccountNumber__c": "string",
    "ACHID__c": "string",
    "ACHInstitutionCity__c": "string",
    "ACHInstitutionName__c": "string",
    "ACHInstitutionPostalCode__c": "string",
    "ACHInstitutionRegion__c": "string",
    "ACHRoutingNumber__c": "string",
    "ACH_Reject_Value__c": "string",
    "ACS_quotehardware__c": "string",
    "AC_Hardware_Installment_Loan__c": "string",
    "AC_Hardware_Installment_Months__c": "string",
    "Access_Control_Products_to_Cancel__c": "string",
    "Access_after_Transfer__c": "string",
    "Access_point_restrict_keypad__c": "string",
    "Accesspointrestrict__c": "string",
    "AccountId": "string",
    "Activate_Storable_Payments__c": "string",
    "Actual_Hours_User__c": "string",
    "Actual_Hours__c": "string",
    "AdditionalNotes__c": "string",
    "Additional_Comment__c": "string",
    "Amount": "string",
    "Annualgroup__c": "string",
    "Any_Portable_Units__c": "string",
    "Approved_for_Development__c": "string",
    "Archive_Option_email_address__c": "string",
    "AssetId": "string",
    "Asset_Product_Cancel_List__c": "string",
    "Assetrequired__c": "string",
    "Assigned_Tech__c": "string",
    "Assignment_Health__c": "string",
    "AuthGroup__c": "string",
    "Auto_Closed__c": "string",
    "Auto_Reminder_Email_Sent_Date__c": "string",
    "Auto_Reminder_Email_Sent__c": "string",
    "BillableEntityID__c": "string",
    "BillingCity__c": "string",
    "BillingCountry__c": "string",
    "BillingName__c": "string",
    "BillingNotes__c": "string",
    "BillingPaymentMethod__c": "string",
    "BillingPostalCode__c": "string",
    "BillingRegion__c": "string",
    "BillingStreet__c": "string",
    "Brand__c": "string",
    "BusinessHoursId": "string",
    "CSAT_Close_Email_Exempt__c": "string",
    "CSAT_Combined_Score__c": "string",
    "CSAT_Comment__c": "string",
    "CSAT_Date_Time_Completed__c": "string",
    "CSAT_Date_Time_Sent__c": "string",
    "CSAT_NPS__c": "string",
    "CSAT_Product_Score__c": "string",
    "CSAT_Resend__c": "string",
    "CSAT_Sent__c": "string",
    "CSAT_Support_Score__c": "string",
    "CallPotential_Products_to_Cancel__c": "string",
    "CancelinBillingDate__c": "string",
    "Cancellationnoticesent__c": "string",
    "CaseNumber": "string",
    "Case_Owner_at_Close__c": "string",
    "Case_Survey_ID__c": "string",
    "Category__c": "string",
    "Category_new__c": "string",
    "ChargeOverId__c": "string",
    "Clone_softwaresetting__c": "string",
    "Clone_website_namefacility__c": "string",
    "CloseDate": "string",
    "ClosedDate": "string",
    "Closed_Reason__c": "string",
    "Comments": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Construction_openbusiness__c": "string",
    "ConsultationReasonDetails__c": "string",
    "ConsultationReason__c": "string",
    "ConsultationSize__c": "string",
    "ContactEmail": "string",
    "ContactFax": "string",
    "ContactId": "string",
    "ContactMobile": "string",
    "ContactPhone": "string",
    "ContactsEmail__c": "string",
    "ContactsName__c": "string",
    "ContactsPhone__c": "string",
    "Continue_software_service__c": "string",
    "Conversion_Complete_Date__c": "string",
    "Conversion_Scheduled_Date__c": "string",
    "Convertfromspreadsheet__c": "string",
    "CorpCode__c": "string",
    "CorpLocationID__c": "string",
    "Corp_Code_Search__c": "string",
    "CreateImplementationCase__c": "string",
    "CreatePCIrequestforSLMS__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CreditCardCVV__c": "string",
    "CreditCardExpiration__c": "string",
    "CreditCardName__c": "string",
    "CreditCardNetwork__c": "string",
    "CreditCardNumber__c": "string",
    "CurrencyIsoCode": "string",
    "Current_FMS__c": "string",
    "Current_Gate__c": "string",
    "Current_Insurance__c": "string",
    "Current_Marketplace__c": "string",
    "Current_Payment__c": "string",
    "Current_Software_Provider__c": "string",
    "Current_Website__c": "string",
    "DatawireID__c": "string",
    "Date_Assigned_to_Tech__c": "string",
    "Date_Signed__c": "string",
    "Date_Time_CSAT_Expiration__c": "string",
    "Date_start_software__c": "string",
    "Date_to_be_released__c": "string",
    "DebookedReason__c": "string",
    "Department__c": "string",
    "Description": "string",
    "Development_Priority__c": "string",
    "DisablePayeezydate__c": "string",
    "DiscontinueProductDate__c": "string",
    "Discount_Amount__c": "string",
    "Discount_Period__c": "string",
    "Discountgroup__c": "string",
    "Disposition_Estimate_Reason__c": "string",
    "Disposition_Estimate__c": "string",
    "Due_Date__c": "string",
    "EmailSubjectAddition__c": "string",
    "Email_Received_Count__c": "string",
    "EnableCustomInsurance__c": "string",
    "Enable_Storable_Payments__c": "string",
    "EntitlementId": "string",
    "EscalatedByDepartment__c": "string",
    "EscalatedById__c": "string",
    "EscalatedDate__c": "string",
    "EscalationReasonDetails__c": "string",
    "EscalationReason__c": "string",
    "Exempting_Manager__c": "string",
    "Exemption_Notes__c": "string",
    "ExistingCaseurl__c": "string",
    "Existing_Corp_Code__c": "string",
    "Existing_Logo_Corp_Code__c": "string",
    "ExpectedBehavior__c": "string",
    "ExpectedRevenue": "string",
    "FMSLaunchDate__c": "string",
    "Facility_Cancel_List__c": "string",
    "Facility_clone__c": "string",
    "FirstAssignedDate__c": "string",
    "FirstClosedDate__c": "string",
    "First_Response_Date__c": "string",
    "ForecastCategory": "string",
    "Form_Response_Record__c": "string",
    "Fulfillment_Status__c": "string",
    "Generate_ATB__c": "string",
    "Google_My_Business_Listing__c": "string",
    "HQMerchantID__c": "string",
    "Hardware_Tracking__c": "string",
    "HasCommentsUnreadByOwner": "string",
    "HasSelfServiceComments": "string",
    "Historical_Data_Selection__c": "string",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "ImplementationNotes__c": "string",
    "Implementation_CSAT_Comment__c": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Support_Score__c": "string",
    "Inbound_Call_Count__c": "string",
    "Include_In_Immediate_Release__c": "string",
    "Initial_Response_Milestone_Achieved__c": "string",
    "Insurance_Product_to_Cancel__c": "string",
    "Interest_Digital_Marketing__c": "string",
    "Interest_Sparefoot_facility__c": "string",
    "Interested_in_Data_Archive__c": "string",
    "IsClosed": "string",
    "IsClosedOnCreate": "string",
    "IsDeleted": "string",
    "IsEscalated": "string",
    "IsSelfServiceClosed": "string",
    "IsStopped": "string",
    "IsVisibleInSelfService": "string",
    "JIRAIssue__c": "string",
    "JotForm_URL__c": "string",
    "Language": "string",
    "LastInboundDate__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LastOutboundDate__c": "string",
    "Last_Call_ID__c": "string",
    "Last_Comment_Date__c": "string",
    "Last_Email_Comment_SentBy__c": "string",
    "Launch_Time__c": "string",
    "License_Holder__c": "string",
    "List_Note__c": "string",
    "Loc_Code_Preference__c": "string",
    "LocationCode__c": "string",
    "Location_Code__c": "string",
    "MRR_Total__c": "string",
    "MS_Preapplication_JotForm__c": "string",
    "ManageCompany_Ownersame__c": "string",
    "Managesoftware_convert__c": "string",
    "MasterICowner__c": "string",
    "MasterRecordId": "string",
    "MaxofUnits__c": "string",
    "Merch_Provider_Facility__c": "string",
    "MerchantID__c": "string",
    "Message_Sent_Count__c": "string",
    "MilestoneStatus": "string",
    "Most_Recent_Case_Comment__c": "string",
    "Name_Facility_Purchase__c": "string",
    "Net_MRR_Total__c": "string",
    "Net_MRR_Value__c": "string",
    "NewConstruction__c": "string",
    "NewProduct__c": "string",
    "NewWebsite_ExistingDomain__c": "string",
    "Onethingwecouldhavedonedifferently__c": "string",
    "OpportunityId": "string",
    "Opportunity_Required_Approval__c": "string",
    "Opportunity__c": "string",
    "Order_Product__c": "string",
    "Origin": "string",
    "OriginalLeaseDate__c": "string",
    "Original_Launch_Date__c": "string",
    "Original_Tech_Owner__c": "string",
    "Originating_CSF_Case__c": "string",
    "Originating_Opportunity_Product__c": "string",
    "Other_Access_Cancellation_Details__c": "string",
    "Other_CallPotential_Cancellation_Details__c": "string",
    "Other_Marketplace_Cancellation_Details__c": "string",
    "Other_Merch_Provider__c": "string",
    "Other_Payments_Cancellation_Details__c": "string",
    "Other_Software_Cancellation_Details__c": "string",
    "Other_Software_Provider__c": "string",
    "Other_Website_Cancellation_Details__c": "string",
    "Other_Website_Provider__c": "string",
    "Outbound_Call_Count__c": "string",
    "OwnerId": "string",
    "PDK_RMA_Complete__c": "string",
    "PDK_RMA_Email_Sent__c": "string",
    "PDK_RMA__c": "string",
    "ParentId": "string",
    "Payment_or_Other_Product_to_Cancel__c": "string",
    "PreBoardingTaskscompleted__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Price__c": "string",
    "Priority": "string",
    "Probability": "string",
    "ProductId": "string",
    "Product_Family__c": "string",
    "Product__c": "string",
    "Product_new__c": "string",
    "ProductfeatureorImprovement__c": "string",
    "ProductsatRisk__c": "string",
    "ProjectedGoLiveDateConfidence__c": "string",
    "Projected_Live_Date__c": "string",
    "Public_Comment_Sent_Count__c": "string",
    "PurchFacility_SL_SE_ESS__c": "string",
    "Purchase_Order_ACH__c": "string",
    "Purchaser_Email__c": "string",
    "Purchaser_Phone__c": "string",
    "Quoted_Price__c": "string",
    "RateChange__c": "string",
    "Reason": "string",
    "ReasonDetailsifCOVID19__c": "string",
    "ReasonDetailsifother__c": "string",
    "Reason_Cancel_Access_Control__c": "string",
    "Reason_Cancel_CallPotential__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",
    "ReasonforCancellation__c": "string",
    "ReasonforCancellationold__c": "string",
    "Reasonforleaving__c": "string",
    "Received_by__c": "string",
    "Recipient_Email__c": "string",
    "Recipient_Facility_Name__c": "string",
    "Recipient_Name__c": "string",
    "RecordTypeId": "string",
    "Reference_Opportunity__c": "string",
    "Refund_Method__c": "string",
    "RelatedCase__c": "string",
    "RelatedOpptyClosedwonPortfolio__c": "string",
    "RelatedOpptyClosedwonStandard__c": "string",
    "Related_Opportunity_Amended__c": "string",
    "Release_Date__c": "string",
    "Release_domain_name_website__c": "string",
    "Reopen_Count__c": "string",
    "Reply_To_Email__c": "string",
    "RequestedCancellationDate__c": "string",
    "Requester_Email__c": "string",
    "Require_T1_Support__c": "string",
    "Resolution_Disposition__c": "string",
    "Resolution_Health__c": "string",
    "Response_Health__c": "string",
    "Revised_Quantity__c": "string",
    "RocketLane_Product_List__c": "string",
    "RocketLane_Project_Notes__c": "string",
    "RocketLane_Project_URL__c": "string",
    "SEFMSID__c": "string",
    "SE_Billing_Email__c": "string",
    "SE_Facility_UUID__c": "string",
    "SE_Support_Email__c": "string",
    "SFClientKey__c": "string",
    "SFDemandinScopeExistingSFCustome__c": "string",
    "SF_Billing_Email__c": "string",
    "SF_Demand_in_scope_new_customer__c": "string",
    "SFfacilitykeyChildfacility__c": "string",
    "SLCorpCode__c": "string",
    "SLLocationCode__c": "string",
    "SLMSAccount__c": "string",
    "SSL_Renewal_Date__c": "string",
    "Send_Secure_Emails__c": "string",
    "ServiceContractId": "string",
    "Settings_Form_Received_On__c": "string",
    "Setupcasecreated__c": "string",
    "Shipping_Provider__c": "string",
    "Site_Status__c": "string",
    "SlaExitDate": "string",
    "SlaStartDate": "string",
    "Software_Products_to_Cancel__c": "string",
    "Software_forwardfacility__c": "string",
    "SourceId": "string",
    "SpareFoot_Product_to_Cancel__c": "string",
    "StageName": "string",
    "Start_Case_Auto_Close_Process_Date__c": "string",
    "Start_Case_Auto_Close_Process__c": "string",
    "Status": "string",
    "StatusReasonlastupdated__c": "string",
    "Status_Reason__c": "string",
    "StepstoReproduce__c": "string",
    "StopStartDate": "string",
    "SubType_1__c": "string",
    "SubType_2__c": "string",
    "SubType_3_c__c": "string",
    "Sub_Category__c": "string",
    "Subject": "string",
    "SuppliedCompany": "string",
    "SuppliedEmail": "string",
    "SuppliedName": "string",
    "SuppliedPhone": "string",
    "Suppress_Automated_Emails__c": "string",
    "SuspendedBy__c": "string",
    "SuspendedDate__c": "string",
    "Synched_to_Netsuite__c": "string",
    "SystemModstamp": "string",
    "Tax_rate_on_rent__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",
    "Type": "string",
    "Type__c": "string",
    "Units__c": "string",
    "Upsell_or_Transfer__c": "string",
    "Use_Gate_Software_Provider__c": "string",
    "Use_Sparefoot_facility__c": "string",
    "Validation_Rule_Toggle__c": "string",
    "Vanilla__ForumUrl__c": "string",
    "VoyagerMigrationEnabled__c": "string",
    "WebsiteProvider_Facility__c": "string",
    "Website_Cancellation_URL__c": "string",
    "Website_Products_to_Cancel__c": "string",
    "Website__c": "string",
    "Your_SL_CorpCode__c": "string",
    "Zendesk_Ticket_ID__c": "string",
    "Zendesk_Ticket_URL__c": "string",
    "dCreated__c": "string",
    "monthlygroup__c": "string"
}
    • schema_name_id: 2082
    • schema_scan_id: 6402672
    • updated: 2024-01-11 09:15:34
    • created: 2023-08-16 11:17:26
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_cases`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_cases`\n(\n `Id`  string , `IsDeleted`  string , `MasterRecordId`  string , `CaseNumber`  string , `ContactId`  string , `AccountId`  string , `AssetId`  string , `ProductId`  string , `EntitlementId`  string , `SourceId`  string , `BusinessHoursId`  string , `ParentId`  string , `SuppliedName`  string , `SuppliedEmail`  string , `SuppliedPhone`  string , `SuppliedCompany`  string , `Type`  string , `RecordTypeId`  string , `Status`  string , `Reason`  string , `Origin`  string , `Language`  string , `IsVisibleInSelfService`  string , `Subject`  string , `Priority`  string , `Description`  string , `IsClosed`  string , `ClosedDate`  string , `IsEscalated`  string , `HasCommentsUnreadByOwner`  string , `HasSelfServiceComments`  string , `CurrencyIsoCode`  string , `OwnerId`  string , `IsClosedOnCreate`  string , `IsSelfServiceClosed`  string , `SlaStartDate`  string , `SlaExitDate`  string , `IsStopped`  string , `StopStartDate`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ContactPhone`  string , `ContactMobile`  string , `ContactEmail`  string , `ContactFax`  string , `Comments`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `ServiceContractId`  string , `MilestoneStatus`  string , `dCreated__c`  string , `ACH_Reject_Value__c`  string , `Actual_Hours__c`  string , `Due_Date__c`  string , `PreBoardingTaskscompleted__c`  string , `MS_Preapplication_JotForm__c`  string , `Original_Tech_Owner__c`  string , `Product__c`  string , `Type__c`  string , `SubType_1__c`  string , `SubType_2__c`  string , `Development_Priority__c`  string , `Outbound_Call_Count__c`  string , `Approved_for_Development__c`  string , `Department__c`  string , `Category__c`  string , `Assigned_Tech__c`  string , `Conversion_Complete_Date__c`  string , `Conversion_Scheduled_Date__c`  string , `Date_Assigned_to_Tech__c`  string , `Purchaser_Email__c`  string , `Requester_Email__c`  string , `Quoted_Price__c`  string , `Last_Call_ID__c`  string , `CreatePCIrequestforSLMS__c`  string , `Corp_Code_Search__c`  string , `Include_In_Immediate_Release__c`  string , `Actual_Hours_User__c`  string , `CSAT_Resend__c`  string , `Disposition_Estimate__c`  string , `Disposition_Estimate_Reason__c`  string , `Last_Email_Comment_SentBy__c`  string , `SubType_3_c__c`  string , `Last_Comment_Date__c`  string , `SuspendedDate__c`  string , `SuspendedBy__c`  string , `Purchaser_Phone__c`  string , `Google_My_Business_Listing__c`  string , `RateChange__c`  string , `IGD__Collection_Id__c`  string , `Reference_Opportunity__c`  string , `Opportunity__c`  string , `FirstClosedDate__c`  string , `Assignment_Health__c`  string , `Response_Health__c`  string , `Resolution_Health__c`  string , `Generate_ATB__c`  string , `EscalatedDate__c`  string , `EscalationReason__c`  string , `ACS_quotehardware__c`  string , `EscalationReasonDetails__c`  string , `EscalatedById__c`  string , `EscalatedByDepartment__c`  string , `Auto_Closed__c`  string , `Inbound_Call_Count__c`  string , `LastOutboundDate__c`  string , `Vanilla__ForumUrl__c`  string , `FirstAssignedDate__c`  string , `SF_Demand_in_scope_new_customer__c`  string , `EnableCustomInsurance__c`  string , `SFDemandinScopeExistingSFCustome__c`  string , `ExpectedBehavior__c`  string , `JIRAIssue__c`  string , `StepstoReproduce__c`  string , `Projected_Live_Date__c`  string , `Site_Status__c`  string , `Existing_Logo_Corp_Code__c`  string , `DisablePayeezydate__c`  string , `ProjectedGoLiveDateConfidence__c`  string , `LastInboundDate__c`  string , `Access_after_Transfer__c`  string , `Units__c`  string , `FMSLaunchDate__c`  string , `Category_new__c`  string , `CreateImplementationCase__c`  string , `Website__c`  string , `ImplementationNotes__c`  string , `Product_new__c`  string , `NewConstruction__c`  string , `Opportunity_Required_Approval__c`  string , `Current_FMS__c`  string , `SSL_Renewal_Date__c`  string , `Current_Website__c`  string , `Status_Reason__c`  string , `SE_Billing_Email__c`  string , `SF_Billing_Email__c`  string , `SE_Support_Email__c`  string , `Current_Gate__c`  string , `Current_Insurance__c`  string , `Current_Marketplace__c`  string , `Current_Payment__c`  string , `Net_MRR_Value__c`  string , `Case_Owner_at_Close__c`  string , `Discount_Amount__c`  string , `Settings_Form_Received_On__c`  string , `Discount_Period__c`  string , `Related_Opportunity_Amended__c`  string , `Assetrequired__c`  string , `Closed_Reason__c`  string , `MaxofUnits__c`  string , `Case_Survey_ID__c`  string , `Start_Case_Auto_Close_Process__c`  string , `Product_Family__c`  string , `Initial_Response_Milestone_Achieved__c`  string , `Most_Recent_Case_Comment__c`  string , `Brand__c`  string , `Resolution_Disposition__c`  string , `Access_point_restrict_keypad__c`  string , `RelatedOpptyClosedwonPortfolio__c`  string , `RelatedOpptyClosedwonStandard__c`  string , `Received_by__c`  string , `AdditionalNotes__c`  string , `List_Note__c`  string , `ContactsEmail__c`  string , `ContactsName__c`  string , `ContactsPhone__c`  string , `CorpCode__c`  string , `ExistingCaseurl__c`  string , `LocationCode__c`  string , `ProductsatRisk__c`  string , `ReasonforCancellationold__c`  string , `RequestedCancellationDate__c`  string , `BillableEntityID__c`  string , `CancelinBillingDate__c`  string , `ChargeOverId__c`  string , `CorpLocationID__c`  string , `NewProduct__c`  string , `OriginalLeaseDate__c`  string , `SFfacilitykeyChildfacility__c`  string , `SLMSAccount__c`  string , `BillingNotes__c`  string , `DiscontinueProductDate__c`  string , `ACHID__c`  string , `First_Response_Date__c`  string , `Suppress_Automated_Emails__c`  string , `Accesspointrestrict__c`  string , `SFClientKey__c`  string , `SEFMSID__c`  string , `SLCorpCode__c`  string , `SLLocationCode__c`  string , `MerchantID__c`  string , `Reopen_Count__c`  string , `DatawireID__c`  string , `Zendesk_Ticket_URL__c`  string , `Zendesk_Ticket_ID__c`  string , `ReasonforCancellation__c`  string , `HQMerchantID__c`  string , `MasterICowner__c`  string , `Enable_Storable_Payments__c`  string , `Activate_Storable_Payments__c`  string , `JotForm_URL__c`  string , `Setupcasecreated__c`  string , `Message_Sent_Count__c`  string , `Email_Received_Count__c`  string , `Public_Comment_Sent_Count__c`  string , `StatusReasonlastupdated__c`  string , `CSAT_Sent__c`  string , `CSAT_Combined_Score__c`  string , `Cancellationnoticesent__c`  string , `Onethingwecouldhavedonedifferently__c`  string , `ProductfeatureorImprovement__c`  string , `Reasonforleaving__c`  string , `ReasonDetailsifother__c`  string , `ReasonDetailsifCOVID19__c`  string , `DebookedReason__c`  string , `CSAT_Date_Time_Sent__c`  string , `CSAT_Support_Score__c`  string , `CSAT_Product_Score__c`  string , `CSAT_NPS__c`  string , `CSAT_Date_Time_Completed__c`  string , `CSAT_Comment__c`  string , `AuthGroup__c`  string , `monthlygroup__c`  string , `Discountgroup__c`  string , `Annualgroup__c`  string , `Date_Time_CSAT_Expiration__c`  string , `RelatedCase__c`  string , `Price__c`  string , `Additional_Comment__c`  string , `VoyagerMigrationEnabled__c`  string , `Any_Portable_Units__c`  string , `Archive_Option_email_address__c`  string , `ConsultationSize__c`  string , `ConsultationReason__c`  string , `ConsultationReasonDetails__c`  string , `Clone_softwaresetting__c`  string , `Sub_Category__c`  string , `Access_Control_Products_to_Cancel__c`  string , `Asset_Product_Cancel_List__c`  string , `Facility_Cancel_List__c`  string , `Form_Response_Record__c`  string , `Insurance_Product_to_Cancel__c`  string , `Payment_or_Other_Product_to_Cancel__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 , `Software_Products_to_Cancel__c`  string , `SpareFoot_Product_to_Cancel__c`  string , `Website_Products_to_Cancel__c`  string , `Website_Cancellation_URL__c`  string , `Hardware_Tracking__c`  string , `BillingPaymentMethod__c`  string , `BillingName__c`  string , `BillingCity__c`  string , `BillingPostalCode__c`  string , `BillingStreet__c`  string , `BillingRegion__c`  string , `BillingCountry__c`  string , `CreditCardNetwork__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 , `ACHInstitutionName__c`  string , `ACHInstitutionCity__c`  string , `ACHInstitutionRegion__c`  string , `ACHInstitutionPostalCode__c`  string , `CreditCardName__c`  string , `Fulfillment_Status__c`  string , `Shipping_Provider__c`  string , `Date_start_software__c`  string , `Auto_Reminder_Email_Sent__c`  string , `Interested_in_Data_Archive__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 , `Software_forwardfacility__c`  string , `Tax_rate_on_rent__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 , `Use_Gate_Software_Provider__c`  string , `Use_Sparefoot_facility__c`  string , `WebsiteProvider_Facility__c`  string , `Your_SL_CorpCode__c`  string , `Purchase_Order_ACH__c`  string , `SE_Facility_UUID__c`  string , `Refund_Method__c`  string , `PDK_RMA__c`  string , `EmailSubjectAddition__c`  string , `Synched_to_Netsuite__c`  string , `PDK_RMA_Complete__c`  string , `PDK_RMA_Email_Sent__c`  string , `Upsell_or_Transfer__c`  string , `Originating_Opportunity_Product__c`  string , `Revised_Quantity__c`  string , `Validation_Rule_Toggle__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_CSAT_Comment__c`  string , `Implementation_Product_Score__c`  string , `Exemption_Notes__c`  string , `Exempting_Manager__c`  string , `CSAT_Close_Email_Exempt__c`  string , `Auto_Reminder_Email_Sent_Date__c`  string , `Start_Case_Auto_Close_Process_Date__c`  string , `Other_Software_Cancellation_Details__c`  string , `Other_Website_Cancellation_Details__c`  string , `Other_Marketplace_Cancellation_Details__c`  string , `Other_Access_Cancellation_Details__c`  string , `Other_Payments_Cancellation_Details__c`  string , `AC_Hardware_Installment_Loan__c`  string , `AC_Hardware_Installment_Months__c`  string , `Implementation_Support_Score__c`  string , `Order_Product__c`  string , `Send_Secure_Emails__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/cases/2023-08-16/1692202620'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_cases"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/cases/2023-08-16/1692202620
    • id: 4697518
    • processed: 1
    • raw_data: 
      {
    "ACHID__c": 185,
    "ACHInstitutionCity__c": 272,
    "ACHInstitutionName__c": 271,
    "ACHInstitutionPostalCode__c": 274,
    "ACHInstitutionRegion__c": 273,
    "ACH_Reject_Value__c": 54,
    "ACS_quotehardware__c": 102,
    "AC_Hardware_Installment_Loan__c": 340,
    "AC_Hardware_Installment_Months__c": 341,
    "Access_Control_Products_to_Cancel__c": 240,
    "Access_after_Transfer__c": 123,
    "Access_point_restrict_keypad__c": 160,
    "Accesspointrestrict__c": 188,
    "AccountId": 5,
    "Activate_Storable_Payments__c": 202,
    "Actual_Hours_User__c": 80,
    "Actual_Hours__c": 55,
    "AdditionalNotes__c": 164,
    "Additional_Comment__c": 231,
    "Annualgroup__c": 227,
    "Any_Portable_Units__c": 233,
    "Approved_for_Development__c": 66,
    "Archive_Option_email_address__c": 234,
    "AssetId": 6,
    "Asset_Product_Cancel_List__c": 241,
    "Assetrequired__c": 150,
    "Assigned_Tech__c": 69,
    "Assignment_Health__c": 96,
    "AuthGroup__c": 224,
    "Auto_Closed__c": 106,
    "Auto_Reminder_Email_Sent_Date__c": 333,
    "Auto_Reminder_Email_Sent__c": 279,
    "BillableEntityID__c": 175,
    "BillingCity__c": 259,
    "BillingCountry__c": 263,
    "BillingName__c": 258,
    "BillingNotes__c": 183,
    "BillingPaymentMethod__c": 257,
    "BillingPostalCode__c": 260,
    "BillingRegion__c": 262,
    "BillingStreet__c": 261,
    "Brand__c": 158,
    "BusinessHoursId": 10,
    "CSAT_Close_Email_Exempt__c": 332,
    "CSAT_Combined_Score__c": 210,
    "CSAT_Comment__c": 223,
    "CSAT_Date_Time_Completed__c": 222,
    "CSAT_Date_Time_Sent__c": 218,
    "CSAT_NPS__c": 221,
    "CSAT_Product_Score__c": 220,
    "CSAT_Resend__c": 81,
    "CSAT_Sent__c": 209,
    "CSAT_Support_Score__c": 219,
    "CancelinBillingDate__c": 176,
    "Cancellationnoticesent__c": 211,
    "CaseNumber": 3,
    "Case_Owner_at_Close__c": 145,
    "Case_Survey_ID__c": 153,
    "Category__c": 68,
    "Category_new__c": 126,
    "ChargeOverId__c": 177,
    "Clone_softwaresetting__c": 238,
    "Clone_website_namefacility__c": 265,
    "ClosedDate": 27,
    "Closed_Reason__c": 151,
    "Comments": 48,
    "ConnectionReceivedId": 49,
    "ConnectionSentId": 50,
    "Construction_openbusiness__c": 266,
    "ConsultationReasonDetails__c": 237,
    "ConsultationReason__c": 236,
    "ConsultationSize__c": 235,
    "ContactEmail": 46,
    "ContactFax": 47,
    "ContactId": 4,
    "ContactMobile": 45,
    "ContactPhone": 44,
    "ContactsEmail__c": 166,
    "ContactsName__c": 167,
    "ContactsPhone__c": 168,
    "Continue_software_service__c": 267,
    "Conversion_Complete_Date__c": 70,
    "Conversion_Scheduled_Date__c": 71,
    "Convertfromspreadsheet__c": 268,
    "CorpCode__c": 169,
    "CorpLocationID__c": 178,
    "Corp_Code_Search__c": 78,
    "CreateImplementationCase__c": 127,
    "CreatePCIrequestforSLMS__c": 77,
    "CreatedById": 40,
    "CreatedDate": 39,
    "CreditCardName__c": 275,
    "CreditCardNetwork__c": 264,
    "CurrencyIsoCode": 31,
    "Current_FMS__c": 133,
    "Current_Gate__c": 140,
    "Current_Insurance__c": 141,
    "Current_Marketplace__c": 142,
    "Current_Payment__c": 143,
    "Current_Software_Provider__c": 269,
    "Current_Website__c": 135,
    "DatawireID__c": 195,
    "Date_Assigned_to_Tech__c": 72,
    "Date_Signed__c": 270,
    "Date_Time_CSAT_Expiration__c": 228,
    "Date_start_software__c": 278,
    "Date_to_be_released__c": 281,
    "DebookedReason__c": 217,
    "Department__c": 67,
    "Description": 25,
    "Development_Priority__c": 64,
    "DisablePayeezydate__c": 120,
    "DiscontinueProductDate__c": 184,
    "Discount_Amount__c": 146,
    "Discount_Period__c": 148,
    "Discountgroup__c": 226,
    "Disposition_Estimate_Reason__c": 83,
    "Disposition_Estimate__c": 82,
    "Due_Date__c": 56,
    "EmailSubjectAddition__c": 319,
    "Email_Received_Count__c": 206,
    "EnableCustomInsurance__c": 112,
    "Enable_Storable_Payments__c": 201,
    "EntitlementId": 8,
    "EscalatedByDepartment__c": 105,
    "EscalatedById__c": 104,
    "EscalatedDate__c": 100,
    "EscalationReasonDetails__c": 103,
    "EscalationReason__c": 101,
    "Exempting_Manager__c": 331,
    "Exemption_Notes__c": 330,
    "ExistingCaseurl__c": 170,
    "Existing_Corp_Code__c": 282,
    "Existing_Logo_Corp_Code__c": 119,
    "ExpectedBehavior__c": 114,
    "FMSLaunchDate__c": 125,
    "Facility_Cancel_List__c": 242,
    "Facility_clone__c": 283,
    "FirstAssignedDate__c": 110,
    "FirstClosedDate__c": 95,
    "First_Response_Date__c": 186,
    "Form_Response_Record__c": 243,
    "Fulfillment_Status__c": 276,
    "Generate_ATB__c": 99,
    "Google_My_Business_Listing__c": 90,
    "HQMerchantID__c": 199,
    "Hardware_Tracking__c": 256,
    "HasCommentsUnreadByOwner": 29,
    "HasSelfServiceComments": 30,
    "Historical_Data_Selection__c": 284,
    "IGD__Collection_Id__c": 92,
    "Id": 0,
    "ImplementationNotes__c": 129,
    "Implementation_CSAT_Comment__c": 328,
    "Implementation_Combined_Score__c": 327,
    "Implementation_Product_Score__c": 329,
    "Implementation_Support_Score__c": 342,
    "Inbound_Call_Count__c": 107,
    "Include_In_Immediate_Release__c": 79,
    "Initial_Response_Milestone_Achieved__c": 156,
    "Insurance_Product_to_Cancel__c": 244,
    "Interest_Digital_Marketing__c": 285,
    "Interest_Sparefoot_facility__c": 286,
    "Interested_in_Data_Archive__c": 280,
    "IsClosed": 26,
    "IsClosedOnCreate": 33,
    "IsDeleted": 1,
    "IsEscalated": 28,
    "IsSelfServiceClosed": 34,
    "IsStopped": 37,
    "IsVisibleInSelfService": 22,
    "JIRAIssue__c": 115,
    "JotForm_URL__c": 203,
    "Language": 21,
    "LastInboundDate__c": 122,
    "LastModifiedById": 42,
    "LastModifiedDate": 41,
    "LastOutboundDate__c": 108,
    "Last_Call_ID__c": 76,
    "Last_Comment_Date__c": 86,
    "Last_Email_Comment_SentBy__c": 84,
    "License_Holder__c": 287,
    "List_Note__c": 165,
    "Loc_Code_Preference__c": 288,
    "LocationCode__c": 171,
    "Location_Code__c": 289,
    "MS_Preapplication_JotForm__c": 58,
    "ManageCompany_Ownersame__c": 290,
    "Managesoftware_convert__c": 291,
    "MasterICowner__c": 200,
    "MasterRecordId": 2,
    "MaxofUnits__c": 152,
    "Merch_Provider_Facility__c": 292,
    "MerchantID__c": 193,
    "Message_Sent_Count__c": 205,
    "MilestoneStatus": 52,
    "Most_Recent_Case_Comment__c": 157,
    "Name_Facility_Purchase__c": 293,
    "Net_MRR_Value__c": 144,
    "NewConstruction__c": 131,
    "NewProduct__c": 179,
    "NewWebsite_ExistingDomain__c": 294,
    "Onethingwecouldhavedonedifferently__c": 212,
    "Opportunity_Required_Approval__c": 132,
    "Opportunity__c": 94,
    "Order_Product__c": 343,
    "Origin": 20,
    "OriginalLeaseDate__c": 180,
    "Original_Tech_Owner__c": 59,
    "Originating_Opportunity_Product__c": 324,
    "Other_Access_Cancellation_Details__c": 338,
    "Other_Marketplace_Cancellation_Details__c": 337,
    "Other_Merch_Provider__c": 295,
    "Other_Payments_Cancellation_Details__c": 339,
    "Other_Software_Cancellation_Details__c": 335,
    "Other_Software_Provider__c": 296,
    "Other_Website_Cancellation_Details__c": 336,
    "Other_Website_Provider__c": 297,
    "Outbound_Call_Count__c": 65,
    "OwnerId": 32,
    "PDK_RMA_Complete__c": 321,
    "PDK_RMA_Email_Sent__c": 322,
    "PDK_RMA__c": 318,
    "ParentId": 11,
    "Payment_or_Other_Product_to_Cancel__c": 245,
    "PreBoardingTaskscompleted__c": 57,
    "Price__c": 230,
    "Priority": 24,
    "ProductId": 7,
    "Product_Family__c": 155,
    "Product__c": 60,
    "Product_new__c": 130,
    "ProductfeatureorImprovement__c": 213,
    "ProductsatRisk__c": 172,
    "ProjectedGoLiveDateConfidence__c": 121,
    "Projected_Live_Date__c": 117,
    "Public_Comment_Sent_Count__c": 207,
    "PurchFacility_SL_SE_ESS__c": 298,
    "Purchase_Order_ACH__c": 315,
    "Purchaser_Email__c": 73,
    "Purchaser_Phone__c": 89,
    "Quoted_Price__c": 75,
    "RateChange__c": 91,
    "Reason": 19,
    "ReasonDetailsifCOVID19__c": 216,
    "ReasonDetailsifother__c": 215,
    "Reason_Cancel_Access_Control__c": 246,
    "Reason_Cancel_Insurance__c": 247,
    "Reason_Cancel_Payment_or_Other_Product__c": 248,
    "Reason_Cancel_Software_Product__c": 249,
    "Reason_Cancel_SpareFoot__c": 250,
    "Reason_Cancel_Website_Product__c": 251,
    "ReasonforCancellation__c": 198,
    "ReasonforCancellationold__c": 173,
    "Reasonforleaving__c": 214,
    "Received_by__c": 163,
    "Recipient_Email__c": 299,
    "Recipient_Facility_Name__c": 300,
    "Recipient_Name__c": 301,
    "RecordTypeId": 17,
    "Reference_Opportunity__c": 93,
    "Refund_Method__c": 317,
    "RelatedCase__c": 229,
    "RelatedOpptyClosedwonPortfolio__c": 161,
    "RelatedOpptyClosedwonStandard__c": 162,
    "Related_Opportunity_Amended__c": 149,
    "Release_Date__c": 302,
    "Release_domain_name_website__c": 303,
    "Reopen_Count__c": 194,
    "RequestedCancellationDate__c": 174,
    "Requester_Email__c": 74,
    "Resolution_Disposition__c": 159,
    "Resolution_Health__c": 98,
    "Response_Health__c": 97,
    "Revised_Quantity__c": 325,
    "SEFMSID__c": 190,
    "SE_Billing_Email__c": 137,
    "SE_Facility_UUID__c": 316,
    "SE_Support_Email__c": 139,
    "SFClientKey__c": 189,
    "SFDemandinScopeExistingSFCustome__c": 113,
    "SF_Billing_Email__c": 138,
    "SF_Demand_in_scope_new_customer__c": 111,
    "SFfacilitykeyChildfacility__c": 181,
    "SLCorpCode__c": 191,
    "SLLocationCode__c": 192,
    "SLMSAccount__c": 182,
    "SSL_Renewal_Date__c": 134,
    "Send_Secure_Emails__c": 344,
    "ServiceContractId": 51,
    "Settings_Form_Received_On__c": 147,
    "Setupcasecreated__c": 204,
    "Shipping_Provider__c": 277,
    "Site_Status__c": 118,
    "SlaExitDate": 36,
    "SlaStartDate": 35,
    "Software_Products_to_Cancel__c": 252,
    "Software_forwardfacility__c": 304,
    "SourceId": 9,
    "SpareFoot_Product_to_Cancel__c": 253,
    "Start_Case_Auto_Close_Process_Date__c": 334,
    "Start_Case_Auto_Close_Process__c": 154,
    "Status": 18,
    "StatusReasonlastupdated__c": 208,
    "Status_Reason__c": 136,
    "StepstoReproduce__c": 116,
    "StopStartDate": 38,
    "SubType_1__c": 62,
    "SubType_2__c": 63,
    "SubType_3_c__c": 85,
    "Sub_Category__c": 239,
    "Subject": 23,
    "SuppliedCompany": 15,
    "SuppliedEmail": 13,
    "SuppliedName": 12,
    "SuppliedPhone": 14,
    "Suppress_Automated_Emails__c": 187,
    "SuspendedBy__c": 88,
    "SuspendedDate__c": 87,
    "Synched_to_Netsuite__c": 320,
    "SystemModstamp": 43,
    "Tax_rate_on_rent__c": 305,
    "Tenant_Insurance_Facility__c": 306,
    "Transferee_Company_Name__c": 307,
    "Transferee_Email__c": 308,
    "Transferee_Phone_Number__c": 309,
    "Transferee_Primary_Contact__c": 310,
    "Type": 16,
    "Type__c": 61,
    "Units__c": 124,
    "Upsell_or_Transfer__c": 323,
    "Use_Gate_Software_Provider__c": 311,
    "Use_Sparefoot_facility__c": 312,
    "Validation_Rule_Toggle__c": 326,
    "Vanilla__ForumUrl__c": 109,
    "VoyagerMigrationEnabled__c": 232,
    "WebsiteProvider_Facility__c": 313,
    "Website_Cancellation_URL__c": 255,
    "Website_Products_to_Cancel__c": 254,
    "Website__c": 128,
    "Your_SL_CorpCode__c": 314,
    "Zendesk_Ticket_ID__c": 197,
    "Zendesk_Ticket_URL__c": 196,
    "dCreated__c": 53,
    "monthlygroup__c": 225
}
    • schema_attributes: 
      {
    "ACHAccountNumber__c": "string",
    "ACHID__c": "string",
    "ACHInstitutionCity__c": "string",
    "ACHInstitutionName__c": "string",
    "ACHInstitutionPostalCode__c": "string",
    "ACHInstitutionRegion__c": "string",
    "ACHRoutingNumber__c": "string",
    "ACH_Reject_Value__c": "string",
    "ACS_quotehardware__c": "string",
    "AC_Hardware_Installment_Loan__c": "string",
    "AC_Hardware_Installment_Months__c": "string",
    "Access_Control_Products_to_Cancel__c": "string",
    "Access_after_Transfer__c": "string",
    "Access_point_restrict_keypad__c": "string",
    "Accesspointrestrict__c": "string",
    "AccountId": "string",
    "Activate_Storable_Payments__c": "string",
    "Actual_Hours_User__c": "string",
    "Actual_Hours__c": "string",
    "AdditionalNotes__c": "string",
    "Additional_Comment__c": "string",
    "Amount": "string",
    "Annualgroup__c": "string",
    "Any_Portable_Units__c": "string",
    "Approved_for_Development__c": "string",
    "Archive_Option_email_address__c": "string",
    "AssetId": "string",
    "Asset_Product_Cancel_List__c": "string",
    "Assetrequired__c": "string",
    "Assigned_Tech__c": "string",
    "Assignment_Health__c": "string",
    "AuthGroup__c": "string",
    "Auto_Closed__c": "string",
    "Auto_Reminder_Email_Sent_Date__c": "string",
    "Auto_Reminder_Email_Sent__c": "string",
    "BillableEntityID__c": "string",
    "BillingCity__c": "string",
    "BillingCountry__c": "string",
    "BillingName__c": "string",
    "BillingNotes__c": "string",
    "BillingPaymentMethod__c": "string",
    "BillingPostalCode__c": "string",
    "BillingRegion__c": "string",
    "BillingStreet__c": "string",
    "Brand__c": "string",
    "BusinessHoursId": "string",
    "CSAT_Close_Email_Exempt__c": "string",
    "CSAT_Combined_Score__c": "string",
    "CSAT_Comment__c": "string",
    "CSAT_Date_Time_Completed__c": "string",
    "CSAT_Date_Time_Sent__c": "string",
    "CSAT_NPS__c": "string",
    "CSAT_Product_Score__c": "string",
    "CSAT_Resend__c": "string",
    "CSAT_Sent__c": "string",
    "CSAT_Support_Score__c": "string",
    "CancelinBillingDate__c": "string",
    "Cancellationnoticesent__c": "string",
    "CaseNumber": "string",
    "Case_Owner_at_Close__c": "string",
    "Case_Survey_ID__c": "string",
    "Category__c": "string",
    "Category_new__c": "string",
    "ChargeOverId__c": "string",
    "Clone_softwaresetting__c": "string",
    "Clone_website_namefacility__c": "string",
    "CloseDate": "string",
    "ClosedDate": "string",
    "Closed_Reason__c": "string",
    "Comments": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Construction_openbusiness__c": "string",
    "ConsultationReasonDetails__c": "string",
    "ConsultationReason__c": "string",
    "ConsultationSize__c": "string",
    "ContactEmail": "string",
    "ContactFax": "string",
    "ContactId": "string",
    "ContactMobile": "string",
    "ContactPhone": "string",
    "ContactsEmail__c": "string",
    "ContactsName__c": "string",
    "ContactsPhone__c": "string",
    "Continue_software_service__c": "string",
    "Conversion_Complete_Date__c": "string",
    "Conversion_Scheduled_Date__c": "string",
    "Convertfromspreadsheet__c": "string",
    "CorpCode__c": "string",
    "CorpLocationID__c": "string",
    "Corp_Code_Search__c": "string",
    "CreateImplementationCase__c": "string",
    "CreatePCIrequestforSLMS__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CreditCardCVV__c": "string",
    "CreditCardExpiration__c": "string",
    "CreditCardName__c": "string",
    "CreditCardNetwork__c": "string",
    "CreditCardNumber__c": "string",
    "CurrencyIsoCode": "string",
    "Current_FMS__c": "string",
    "Current_Gate__c": "string",
    "Current_Insurance__c": "string",
    "Current_Marketplace__c": "string",
    "Current_Payment__c": "string",
    "Current_Software_Provider__c": "string",
    "Current_Website__c": "string",
    "DatawireID__c": "string",
    "Date_Assigned_to_Tech__c": "string",
    "Date_Signed__c": "string",
    "Date_Time_CSAT_Expiration__c": "string",
    "Date_start_software__c": "string",
    "Date_to_be_released__c": "string",
    "DebookedReason__c": "string",
    "Department__c": "string",
    "Description": "string",
    "Development_Priority__c": "string",
    "DisablePayeezydate__c": "string",
    "DiscontinueProductDate__c": "string",
    "Discount_Amount__c": "string",
    "Discount_Period__c": "string",
    "Discountgroup__c": "string",
    "Disposition_Estimate_Reason__c": "string",
    "Disposition_Estimate__c": "string",
    "Due_Date__c": "string",
    "EmailSubjectAddition__c": "string",
    "Email_Received_Count__c": "string",
    "EnableCustomInsurance__c": "string",
    "Enable_Storable_Payments__c": "string",
    "EntitlementId": "string",
    "EscalatedByDepartment__c": "string",
    "EscalatedById__c": "string",
    "EscalatedDate__c": "string",
    "EscalationReasonDetails__c": "string",
    "EscalationReason__c": "string",
    "Exempting_Manager__c": "string",
    "Exemption_Notes__c": "string",
    "ExistingCaseurl__c": "string",
    "Existing_Corp_Code__c": "string",
    "Existing_Logo_Corp_Code__c": "string",
    "ExpectedBehavior__c": "string",
    "ExpectedRevenue": "string",
    "FMSLaunchDate__c": "string",
    "Facility_Cancel_List__c": "string",
    "Facility_clone__c": "string",
    "FirstAssignedDate__c": "string",
    "FirstClosedDate__c": "string",
    "First_Response_Date__c": "string",
    "ForecastCategory": "string",
    "Form_Response_Record__c": "string",
    "Fulfillment_Status__c": "string",
    "Generate_ATB__c": "string",
    "Google_My_Business_Listing__c": "string",
    "HQMerchantID__c": "string",
    "Hardware_Tracking__c": "string",
    "HasCommentsUnreadByOwner": "string",
    "HasSelfServiceComments": "string",
    "Historical_Data_Selection__c": "string",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "ImplementationNotes__c": "string",
    "Implementation_CSAT_Comment__c": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Support_Score__c": "string",
    "Inbound_Call_Count__c": "string",
    "Include_In_Immediate_Release__c": "string",
    "Initial_Response_Milestone_Achieved__c": "string",
    "Insurance_Product_to_Cancel__c": "string",
    "Interest_Digital_Marketing__c": "string",
    "Interest_Sparefoot_facility__c": "string",
    "Interested_in_Data_Archive__c": "string",
    "IsClosed": "string",
    "IsClosedOnCreate": "string",
    "IsDeleted": "string",
    "IsEscalated": "string",
    "IsSelfServiceClosed": "string",
    "IsStopped": "string",
    "IsVisibleInSelfService": "string",
    "JIRAIssue__c": "string",
    "JotForm_URL__c": "string",
    "Language": "string",
    "LastInboundDate__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LastOutboundDate__c": "string",
    "Last_Call_ID__c": "string",
    "Last_Comment_Date__c": "string",
    "Last_Email_Comment_SentBy__c": "string",
    "License_Holder__c": "string",
    "List_Note__c": "string",
    "Loc_Code_Preference__c": "string",
    "LocationCode__c": "string",
    "Location_Code__c": "string",
    "MS_Preapplication_JotForm__c": "string",
    "ManageCompany_Ownersame__c": "string",
    "Managesoftware_convert__c": "string",
    "MasterICowner__c": "string",
    "MasterRecordId": "string",
    "MaxofUnits__c": "string",
    "Merch_Provider_Facility__c": "string",
    "MerchantID__c": "string",
    "Message_Sent_Count__c": "string",
    "MilestoneStatus": "string",
    "Most_Recent_Case_Comment__c": "string",
    "Name_Facility_Purchase__c": "string",
    "Net_MRR_Value__c": "string",
    "NewConstruction__c": "string",
    "NewProduct__c": "string",
    "NewWebsite_ExistingDomain__c": "string",
    "Onethingwecouldhavedonedifferently__c": "string",
    "OpportunityId": "string",
    "Opportunity_Required_Approval__c": "string",
    "Opportunity__c": "string",
    "Order_Product__c": "string",
    "Origin": "string",
    "OriginalLeaseDate__c": "string",
    "Original_Tech_Owner__c": "string",
    "Originating_Opportunity_Product__c": "string",
    "Other_Access_Cancellation_Details__c": "string",
    "Other_Marketplace_Cancellation_Details__c": "string",
    "Other_Merch_Provider__c": "string",
    "Other_Payments_Cancellation_Details__c": "string",
    "Other_Software_Cancellation_Details__c": "string",
    "Other_Software_Provider__c": "string",
    "Other_Website_Cancellation_Details__c": "string",
    "Other_Website_Provider__c": "string",
    "Outbound_Call_Count__c": "string",
    "OwnerId": "string",
    "PDK_RMA_Complete__c": "string",
    "PDK_RMA_Email_Sent__c": "string",
    "PDK_RMA__c": "string",
    "ParentId": "string",
    "Payment_or_Other_Product_to_Cancel__c": "string",
    "PreBoardingTaskscompleted__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Price__c": "string",
    "Priority": "string",
    "Probability": "string",
    "ProductId": "string",
    "Product_Family__c": "string",
    "Product__c": "string",
    "Product_new__c": "string",
    "ProductfeatureorImprovement__c": "string",
    "ProductsatRisk__c": "string",
    "ProjectedGoLiveDateConfidence__c": "string",
    "Projected_Live_Date__c": "string",
    "Public_Comment_Sent_Count__c": "string",
    "PurchFacility_SL_SE_ESS__c": "string",
    "Purchase_Order_ACH__c": "string",
    "Purchaser_Email__c": "string",
    "Purchaser_Phone__c": "string",
    "Quoted_Price__c": "string",
    "RateChange__c": "string",
    "Reason": "string",
    "ReasonDetailsifCOVID19__c": "string",
    "ReasonDetailsifother__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",
    "ReasonforCancellation__c": "string",
    "ReasonforCancellationold__c": "string",
    "Reasonforleaving__c": "string",
    "Received_by__c": "string",
    "Recipient_Email__c": "string",
    "Recipient_Facility_Name__c": "string",
    "Recipient_Name__c": "string",
    "RecordTypeId": "string",
    "Reference_Opportunity__c": "string",
    "Refund_Method__c": "string",
    "RelatedCase__c": "string",
    "RelatedOpptyClosedwonPortfolio__c": "string",
    "RelatedOpptyClosedwonStandard__c": "string",
    "Related_Opportunity_Amended__c": "string",
    "Release_Date__c": "string",
    "Release_domain_name_website__c": "string",
    "Reopen_Count__c": "string",
    "RequestedCancellationDate__c": "string",
    "Requester_Email__c": "string",
    "Resolution_Disposition__c": "string",
    "Resolution_Health__c": "string",
    "Response_Health__c": "string",
    "Revised_Quantity__c": "string",
    "SEFMSID__c": "string",
    "SE_Billing_Email__c": "string",
    "SE_Facility_UUID__c": "string",
    "SE_Support_Email__c": "string",
    "SFClientKey__c": "string",
    "SFDemandinScopeExistingSFCustome__c": "string",
    "SF_Billing_Email__c": "string",
    "SF_Demand_in_scope_new_customer__c": "string",
    "SFfacilitykeyChildfacility__c": "string",
    "SLCorpCode__c": "string",
    "SLLocationCode__c": "string",
    "SLMSAccount__c": "string",
    "SSL_Renewal_Date__c": "string",
    "Send_Secure_Emails__c": "string",
    "ServiceContractId": "string",
    "Settings_Form_Received_On__c": "string",
    "Setupcasecreated__c": "string",
    "Shipping_Provider__c": "string",
    "Site_Status__c": "string",
    "SlaExitDate": "string",
    "SlaStartDate": "string",
    "Software_Products_to_Cancel__c": "string",
    "Software_forwardfacility__c": "string",
    "SourceId": "string",
    "SpareFoot_Product_to_Cancel__c": "string",
    "StageName": "string",
    "Start_Case_Auto_Close_Process_Date__c": "string",
    "Start_Case_Auto_Close_Process__c": "string",
    "Status": "string",
    "StatusReasonlastupdated__c": "string",
    "Status_Reason__c": "string",
    "StepstoReproduce__c": "string",
    "StopStartDate": "string",
    "SubType_1__c": "string",
    "SubType_2__c": "string",
    "SubType_3_c__c": "string",
    "Sub_Category__c": "string",
    "Subject": "string",
    "SuppliedCompany": "string",
    "SuppliedEmail": "string",
    "SuppliedName": "string",
    "SuppliedPhone": "string",
    "Suppress_Automated_Emails__c": "string",
    "SuspendedBy__c": "string",
    "SuspendedDate__c": "string",
    "Synched_to_Netsuite__c": "string",
    "SystemModstamp": "string",
    "Tax_rate_on_rent__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",
    "Type": "string",
    "Type__c": "string",
    "Units__c": "string",
    "Upsell_or_Transfer__c": "string",
    "Use_Gate_Software_Provider__c": "string",
    "Use_Sparefoot_facility__c": "string",
    "Validation_Rule_Toggle__c": "string",
    "Vanilla__ForumUrl__c": "string",
    "VoyagerMigrationEnabled__c": "string",
    "WebsiteProvider_Facility__c": "string",
    "Website_Cancellation_URL__c": "string",
    "Website_Products_to_Cancel__c": "string",
    "Website__c": "string",
    "Your_SL_CorpCode__c": "string",
    "Zendesk_Ticket_ID__c": "string",
    "Zendesk_Ticket_URL__c": "string",
    "dCreated__c": "string",
    "monthlygroup__c": "string"
}
    • schema_name_id: 2082
    • schema_scan_id: 6251523
    • updated: 2023-08-16 11:17:37
    • created: 2023-08-16 10:31:49
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_cases`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_cases`\n(\n `Id`  string , `IsDeleted`  string , `MasterRecordId`  string , `CaseNumber`  string , `ContactId`  string , `AccountId`  string , `AssetId`  string , `ProductId`  string , `EntitlementId`  string , `SourceId`  string , `BusinessHoursId`  string , `ParentId`  string , `SuppliedName`  string , `SuppliedEmail`  string , `SuppliedPhone`  string , `SuppliedCompany`  string , `Type`  string , `RecordTypeId`  string , `Status`  string , `Reason`  string , `Origin`  string , `Language`  string , `IsVisibleInSelfService`  string , `Subject`  string , `Priority`  string , `Description`  string , `IsClosed`  string , `ClosedDate`  string , `IsEscalated`  string , `HasCommentsUnreadByOwner`  string , `HasSelfServiceComments`  string , `CurrencyIsoCode`  string , `OwnerId`  string , `IsClosedOnCreate`  string , `IsSelfServiceClosed`  string , `SlaStartDate`  string , `SlaExitDate`  string , `IsStopped`  string , `StopStartDate`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ContactPhone`  string , `ContactMobile`  string , `ContactEmail`  string , `ContactFax`  string , `Comments`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `ServiceContractId`  string , `MilestoneStatus`  string , `dCreated__c`  string , `ACH_Reject_Value__c`  string , `Actual_Hours__c`  string , `Due_Date__c`  string , `PreBoardingTaskscompleted__c`  string , `MS_Preapplication_JotForm__c`  string , `Original_Tech_Owner__c`  string , `Product__c`  string , `Type__c`  string , `SubType_1__c`  string , `SubType_2__c`  string , `Development_Priority__c`  string , `Outbound_Call_Count__c`  string , `Approved_for_Development__c`  string , `Department__c`  string , `Category__c`  string , `Assigned_Tech__c`  string , `Conversion_Complete_Date__c`  string , `Conversion_Scheduled_Date__c`  string , `Date_Assigned_to_Tech__c`  string , `Purchaser_Email__c`  string , `Requester_Email__c`  string , `Quoted_Price__c`  string , `Last_Call_ID__c`  string , `CreatePCIrequestforSLMS__c`  string , `Corp_Code_Search__c`  string , `Include_In_Immediate_Release__c`  string , `Actual_Hours_User__c`  string , `CSAT_Resend__c`  string , `Disposition_Estimate__c`  string , `Disposition_Estimate_Reason__c`  string , `Last_Email_Comment_SentBy__c`  string , `SubType_3_c__c`  string , `Last_Comment_Date__c`  string , `SuspendedDate__c`  string , `SuspendedBy__c`  string , `Purchaser_Phone__c`  string , `Google_My_Business_Listing__c`  string , `RateChange__c`  string , `IGD__Collection_Id__c`  string , `Reference_Opportunity__c`  string , `Opportunity__c`  string , `FirstClosedDate__c`  string , `Assignment_Health__c`  string , `Response_Health__c`  string , `Resolution_Health__c`  string , `Generate_ATB__c`  string , `EscalatedDate__c`  string , `EscalationReason__c`  string , `ACS_quotehardware__c`  string , `EscalationReasonDetails__c`  string , `EscalatedById__c`  string , `EscalatedByDepartment__c`  string , `Auto_Closed__c`  string , `Inbound_Call_Count__c`  string , `LastOutboundDate__c`  string , `Vanilla__ForumUrl__c`  string , `FirstAssignedDate__c`  string , `SF_Demand_in_scope_new_customer__c`  string , `EnableCustomInsurance__c`  string , `SFDemandinScopeExistingSFCustome__c`  string , `ExpectedBehavior__c`  string , `JIRAIssue__c`  string , `StepstoReproduce__c`  string , `Projected_Live_Date__c`  string , `Site_Status__c`  string , `Existing_Logo_Corp_Code__c`  string , `DisablePayeezydate__c`  string , `ProjectedGoLiveDateConfidence__c`  string , `LastInboundDate__c`  string , `Access_after_Transfer__c`  string , `Units__c`  string , `FMSLaunchDate__c`  string , `Category_new__c`  string , `CreateImplementationCase__c`  string , `Website__c`  string , `ImplementationNotes__c`  string , `Product_new__c`  string , `NewConstruction__c`  string , `Opportunity_Required_Approval__c`  string , `Current_FMS__c`  string , `SSL_Renewal_Date__c`  string , `Current_Website__c`  string , `Status_Reason__c`  string , `SE_Billing_Email__c`  string , `SF_Billing_Email__c`  string , `SE_Support_Email__c`  string , `Current_Gate__c`  string , `Current_Insurance__c`  string , `Current_Marketplace__c`  string , `Current_Payment__c`  string , `Net_MRR_Value__c`  string , `Case_Owner_at_Close__c`  string , `Discount_Amount__c`  string , `Settings_Form_Received_On__c`  string , `Discount_Period__c`  string , `Related_Opportunity_Amended__c`  string , `Assetrequired__c`  string , `Closed_Reason__c`  string , `MaxofUnits__c`  string , `Case_Survey_ID__c`  string , `Start_Case_Auto_Close_Process__c`  string , `Product_Family__c`  string , `Initial_Response_Milestone_Achieved__c`  string , `Most_Recent_Case_Comment__c`  string , `Brand__c`  string , `Resolution_Disposition__c`  string , `Access_point_restrict_keypad__c`  string , `RelatedOpptyClosedwonPortfolio__c`  string , `RelatedOpptyClosedwonStandard__c`  string , `Received_by__c`  string , `AdditionalNotes__c`  string , `List_Note__c`  string , `ContactsEmail__c`  string , `ContactsName__c`  string , `ContactsPhone__c`  string , `CorpCode__c`  string , `ExistingCaseurl__c`  string , `LocationCode__c`  string , `ProductsatRisk__c`  string , `ReasonforCancellationold__c`  string , `RequestedCancellationDate__c`  string , `BillableEntityID__c`  string , `CancelinBillingDate__c`  string , `ChargeOverId__c`  string , `CorpLocationID__c`  string , `NewProduct__c`  string , `OriginalLeaseDate__c`  string , `SFfacilitykeyChildfacility__c`  string , `SLMSAccount__c`  string , `BillingNotes__c`  string , `DiscontinueProductDate__c`  string , `ACHID__c`  string , `First_Response_Date__c`  string , `Suppress_Automated_Emails__c`  string , `Accesspointrestrict__c`  string , `SFClientKey__c`  string , `SEFMSID__c`  string , `SLCorpCode__c`  string , `SLLocationCode__c`  string , `MerchantID__c`  string , `Reopen_Count__c`  string , `DatawireID__c`  string , `Zendesk_Ticket_URL__c`  string , `Zendesk_Ticket_ID__c`  string , `ReasonforCancellation__c`  string , `HQMerchantID__c`  string , `MasterICowner__c`  string , `Enable_Storable_Payments__c`  string , `Activate_Storable_Payments__c`  string , `JotForm_URL__c`  string , `Setupcasecreated__c`  string , `Message_Sent_Count__c`  string , `Email_Received_Count__c`  string , `Public_Comment_Sent_Count__c`  string , `StatusReasonlastupdated__c`  string , `CSAT_Sent__c`  string , `CSAT_Combined_Score__c`  string , `Cancellationnoticesent__c`  string , `Onethingwecouldhavedonedifferently__c`  string , `ProductfeatureorImprovement__c`  string , `Reasonforleaving__c`  string , `ReasonDetailsifother__c`  string , `ReasonDetailsifCOVID19__c`  string , `DebookedReason__c`  string , `CSAT_Date_Time_Sent__c`  string , `CSAT_Support_Score__c`  string , `CSAT_Product_Score__c`  string , `CSAT_NPS__c`  string , `CSAT_Date_Time_Completed__c`  string , `CSAT_Comment__c`  string , `AuthGroup__c`  string , `monthlygroup__c`  string , `Discountgroup__c`  string , `Annualgroup__c`  string , `Date_Time_CSAT_Expiration__c`  string , `RelatedCase__c`  string , `Price__c`  string , `Additional_Comment__c`  string , `VoyagerMigrationEnabled__c`  string , `Any_Portable_Units__c`  string , `Archive_Option_email_address__c`  string , `ConsultationSize__c`  string , `ConsultationReason__c`  string , `ConsultationReasonDetails__c`  string , `Clone_softwaresetting__c`  string , `Sub_Category__c`  string , `Access_Control_Products_to_Cancel__c`  string , `Asset_Product_Cancel_List__c`  string , `Facility_Cancel_List__c`  string , `Form_Response_Record__c`  string , `Insurance_Product_to_Cancel__c`  string , `Payment_or_Other_Product_to_Cancel__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 , `Software_Products_to_Cancel__c`  string , `SpareFoot_Product_to_Cancel__c`  string , `Website_Products_to_Cancel__c`  string , `Website_Cancellation_URL__c`  string , `Hardware_Tracking__c`  string , `BillingPaymentMethod__c`  string , `BillingName__c`  string , `BillingCity__c`  string , `BillingPostalCode__c`  string , `BillingStreet__c`  string , `BillingRegion__c`  string , `BillingCountry__c`  string , `CreditCardNetwork__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 , `ACHInstitutionName__c`  string , `ACHInstitutionCity__c`  string , `ACHInstitutionRegion__c`  string , `ACHInstitutionPostalCode__c`  string , `CreditCardName__c`  string , `Fulfillment_Status__c`  string , `Shipping_Provider__c`  string , `Date_start_software__c`  string , `Auto_Reminder_Email_Sent__c`  string , `Interested_in_Data_Archive__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 , `Software_forwardfacility__c`  string , `Tax_rate_on_rent__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 , `Use_Gate_Software_Provider__c`  string , `Use_Sparefoot_facility__c`  string , `WebsiteProvider_Facility__c`  string , `Your_SL_CorpCode__c`  string , `Purchase_Order_ACH__c`  string , `SE_Facility_UUID__c`  string , `Refund_Method__c`  string , `PDK_RMA__c`  string , `EmailSubjectAddition__c`  string , `Synched_to_Netsuite__c`  string , `PDK_RMA_Complete__c`  string , `PDK_RMA_Email_Sent__c`  string , `Upsell_or_Transfer__c`  string , `Originating_Opportunity_Product__c`  string , `Revised_Quantity__c`  string , `Validation_Rule_Toggle__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_CSAT_Comment__c`  string , `Implementation_Product_Score__c`  string , `Exemption_Notes__c`  string , `Exempting_Manager__c`  string , `CSAT_Close_Email_Exempt__c`  string , `Auto_Reminder_Email_Sent_Date__c`  string , `Start_Case_Auto_Close_Process_Date__c`  string , `Other_Software_Cancellation_Details__c`  string , `Other_Website_Cancellation_Details__c`  string , `Other_Marketplace_Cancellation_Details__c`  string , `Other_Access_Cancellation_Details__c`  string , `Other_Payments_Cancellation_Details__c`  string , `AC_Hardware_Installment_Loan__c`  string , `AC_Hardware_Installment_Months__c`  string , `Implementation_Support_Score__c`  string , `Order_Product__c`  string , `Send_Secure_Emails__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/cases/2023-08-16/1692199878'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_cases"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/cases/2023-08-16/1692199878
    • id: 4697463
    • processed: 1
    • raw_data: 
      {
    "ACHID__c": 185,
    "ACHInstitutionCity__c": 272,
    "ACHInstitutionName__c": 271,
    "ACHInstitutionPostalCode__c": 274,
    "ACHInstitutionRegion__c": 273,
    "ACH_Reject_Value__c": 54,
    "ACS_quotehardware__c": 102,
    "AC_Hardware_Installment_Loan__c": 340,
    "AC_Hardware_Installment_Months__c": 341,
    "Access_Control_Products_to_Cancel__c": 240,
    "Access_after_Transfer__c": 123,
    "Access_point_restrict_keypad__c": 160,
    "Accesspointrestrict__c": 188,
    "AccountId": 5,
    "Activate_Storable_Payments__c": 202,
    "Actual_Hours_User__c": 80,
    "Actual_Hours__c": 55,
    "AdditionalNotes__c": 164,
    "Additional_Comment__c": 231,
    "Annualgroup__c": 227,
    "Any_Portable_Units__c": 233,
    "Approved_for_Development__c": 66,
    "Archive_Option_email_address__c": 234,
    "AssetId": 6,
    "Asset_Product_Cancel_List__c": 241,
    "Assetrequired__c": 150,
    "Assigned_Tech__c": 69,
    "Assignment_Health__c": 96,
    "AuthGroup__c": 224,
    "Auto_Closed__c": 106,
    "Auto_Reminder_Email_Sent_Date__c": 333,
    "Auto_Reminder_Email_Sent__c": 279,
    "BillableEntityID__c": 175,
    "BillingCity__c": 259,
    "BillingCountry__c": 263,
    "BillingName__c": 258,
    "BillingNotes__c": 183,
    "BillingPaymentMethod__c": 257,
    "BillingPostalCode__c": 260,
    "BillingRegion__c": 262,
    "BillingStreet__c": 261,
    "Brand__c": 158,
    "BusinessHoursId": 10,
    "CSAT_Close_Email_Exempt__c": 332,
    "CSAT_Combined_Score__c": 210,
    "CSAT_Comment__c": 223,
    "CSAT_Date_Time_Completed__c": 222,
    "CSAT_Date_Time_Sent__c": 218,
    "CSAT_NPS__c": 221,
    "CSAT_Product_Score__c": 220,
    "CSAT_Resend__c": 81,
    "CSAT_Sent__c": 209,
    "CSAT_Support_Score__c": 219,
    "CancelinBillingDate__c": 176,
    "Cancellationnoticesent__c": 211,
    "CaseNumber": 3,
    "Case_Owner_at_Close__c": 145,
    "Case_Survey_ID__c": 153,
    "Category__c": 68,
    "Category_new__c": 126,
    "ChargeOverId__c": 177,
    "Clone_softwaresetting__c": 238,
    "Clone_website_namefacility__c": 265,
    "ClosedDate": 27,
    "Closed_Reason__c": 151,
    "Comments": 48,
    "ConnectionReceivedId": 49,
    "ConnectionSentId": 50,
    "Construction_openbusiness__c": 266,
    "ConsultationReasonDetails__c": 237,
    "ConsultationReason__c": 236,
    "ConsultationSize__c": 235,
    "ContactEmail": 46,
    "ContactFax": 47,
    "ContactId": 4,
    "ContactMobile": 45,
    "ContactPhone": 44,
    "ContactsEmail__c": 166,
    "ContactsName__c": 167,
    "ContactsPhone__c": 168,
    "Continue_software_service__c": 267,
    "Conversion_Complete_Date__c": 70,
    "Conversion_Scheduled_Date__c": 71,
    "Convertfromspreadsheet__c": 268,
    "CorpCode__c": 169,
    "CorpLocationID__c": 178,
    "Corp_Code_Search__c": 78,
    "CreateImplementationCase__c": 127,
    "CreatePCIrequestforSLMS__c": 77,
    "CreatedById": 40,
    "CreatedDate": 39,
    "CreditCardName__c": 275,
    "CreditCardNetwork__c": 264,
    "CurrencyIsoCode": 31,
    "Current_FMS__c": 133,
    "Current_Gate__c": 140,
    "Current_Insurance__c": 141,
    "Current_Marketplace__c": 142,
    "Current_Payment__c": 143,
    "Current_Software_Provider__c": 269,
    "Current_Website__c": 135,
    "DatawireID__c": 195,
    "Date_Assigned_to_Tech__c": 72,
    "Date_Signed__c": 270,
    "Date_Time_CSAT_Expiration__c": 228,
    "Date_start_software__c": 278,
    "Date_to_be_released__c": 281,
    "DebookedReason__c": 217,
    "Department__c": 67,
    "Description": 25,
    "Development_Priority__c": 64,
    "DisablePayeezydate__c": 120,
    "DiscontinueProductDate__c": 184,
    "Discount_Amount__c": 146,
    "Discount_Period__c": 148,
    "Discountgroup__c": 226,
    "Disposition_Estimate_Reason__c": 83,
    "Disposition_Estimate__c": 82,
    "Due_Date__c": 56,
    "EmailSubjectAddition__c": 319,
    "Email_Received_Count__c": 206,
    "EnableCustomInsurance__c": 112,
    "Enable_Storable_Payments__c": 201,
    "EntitlementId": 8,
    "EscalatedByDepartment__c": 105,
    "EscalatedById__c": 104,
    "EscalatedDate__c": 100,
    "EscalationReasonDetails__c": 103,
    "EscalationReason__c": 101,
    "Exempting_Manager__c": 331,
    "Exemption_Notes__c": 330,
    "ExistingCaseurl__c": 170,
    "Existing_Corp_Code__c": 282,
    "Existing_Logo_Corp_Code__c": 119,
    "ExpectedBehavior__c": 114,
    "FMSLaunchDate__c": 125,
    "Facility_Cancel_List__c": 242,
    "Facility_clone__c": 283,
    "FirstAssignedDate__c": 110,
    "FirstClosedDate__c": 95,
    "First_Response_Date__c": 186,
    "Form_Response_Record__c": 243,
    "Fulfillment_Status__c": 276,
    "Generate_ATB__c": 99,
    "Google_My_Business_Listing__c": 90,
    "HQMerchantID__c": 199,
    "Hardware_Tracking__c": 256,
    "HasCommentsUnreadByOwner": 29,
    "HasSelfServiceComments": 30,
    "Historical_Data_Selection__c": 284,
    "IGD__Collection_Id__c": 92,
    "Id": 0,
    "ImplementationNotes__c": 129,
    "Implementation_CSAT_Comment__c": 328,
    "Implementation_Combined_Score__c": 327,
    "Implementation_Product_Score__c": 329,
    "Implementation_Support_Score__c": 342,
    "Inbound_Call_Count__c": 107,
    "Include_In_Immediate_Release__c": 79,
    "Initial_Response_Milestone_Achieved__c": 156,
    "Insurance_Product_to_Cancel__c": 244,
    "Interest_Digital_Marketing__c": 285,
    "Interest_Sparefoot_facility__c": 286,
    "Interested_in_Data_Archive__c": 280,
    "IsClosed": 26,
    "IsClosedOnCreate": 33,
    "IsDeleted": 1,
    "IsEscalated": 28,
    "IsSelfServiceClosed": 34,
    "IsStopped": 37,
    "IsVisibleInSelfService": 22,
    "JIRAIssue__c": 115,
    "JotForm_URL__c": 203,
    "Language": 21,
    "LastInboundDate__c": 122,
    "LastModifiedById": 42,
    "LastModifiedDate": 41,
    "LastOutboundDate__c": 108,
    "Last_Call_ID__c": 76,
    "Last_Comment_Date__c": 86,
    "Last_Email_Comment_SentBy__c": 84,
    "License_Holder__c": 287,
    "List_Note__c": 165,
    "Loc_Code_Preference__c": 288,
    "LocationCode__c": 171,
    "Location_Code__c": 289,
    "MS_Preapplication_JotForm__c": 58,
    "ManageCompany_Ownersame__c": 290,
    "Managesoftware_convert__c": 291,
    "MasterICowner__c": 200,
    "MasterRecordId": 2,
    "MaxofUnits__c": 152,
    "Merch_Provider_Facility__c": 292,
    "MerchantID__c": 193,
    "Message_Sent_Count__c": 205,
    "MilestoneStatus": 52,
    "Most_Recent_Case_Comment__c": 157,
    "Name_Facility_Purchase__c": 293,
    "Net_MRR_Value__c": 144,
    "NewConstruction__c": 131,
    "NewProduct__c": 179,
    "NewWebsite_ExistingDomain__c": 294,
    "Onethingwecouldhavedonedifferently__c": 212,
    "Opportunity_Required_Approval__c": 132,
    "Opportunity__c": 94,
    "Order_Product__c": 343,
    "Origin": 20,
    "OriginalLeaseDate__c": 180,
    "Original_Tech_Owner__c": 59,
    "Originating_Opportunity_Product__c": 324,
    "Other_Access_Cancellation_Details__c": 338,
    "Other_Marketplace_Cancellation_Details__c": 337,
    "Other_Merch_Provider__c": 295,
    "Other_Payments_Cancellation_Details__c": 339,
    "Other_Software_Cancellation_Details__c": 335,
    "Other_Software_Provider__c": 296,
    "Other_Website_Cancellation_Details__c": 336,
    "Other_Website_Provider__c": 297,
    "Outbound_Call_Count__c": 65,
    "OwnerId": 32,
    "PDK_RMA_Complete__c": 321,
    "PDK_RMA_Email_Sent__c": 322,
    "PDK_RMA__c": 318,
    "ParentId": 11,
    "Payment_or_Other_Product_to_Cancel__c": 245,
    "PreBoardingTaskscompleted__c": 57,
    "Price__c": 230,
    "Priority": 24,
    "ProductId": 7,
    "Product_Family__c": 155,
    "Product__c": 60,
    "Product_new__c": 130,
    "ProductfeatureorImprovement__c": 213,
    "ProductsatRisk__c": 172,
    "ProjectedGoLiveDateConfidence__c": 121,
    "Projected_Live_Date__c": 117,
    "Public_Comment_Sent_Count__c": 207,
    "PurchFacility_SL_SE_ESS__c": 298,
    "Purchase_Order_ACH__c": 315,
    "Purchaser_Email__c": 73,
    "Purchaser_Phone__c": 89,
    "Quoted_Price__c": 75,
    "RateChange__c": 91,
    "Reason": 19,
    "ReasonDetailsifCOVID19__c": 216,
    "ReasonDetailsifother__c": 215,
    "Reason_Cancel_Access_Control__c": 246,
    "Reason_Cancel_Insurance__c": 247,
    "Reason_Cancel_Payment_or_Other_Product__c": 248,
    "Reason_Cancel_Software_Product__c": 249,
    "Reason_Cancel_SpareFoot__c": 250,
    "Reason_Cancel_Website_Product__c": 251,
    "ReasonforCancellation__c": 198,
    "ReasonforCancellationold__c": 173,
    "Reasonforleaving__c": 214,
    "Received_by__c": 163,
    "Recipient_Email__c": 299,
    "Recipient_Facility_Name__c": 300,
    "Recipient_Name__c": 301,
    "RecordTypeId": 17,
    "Reference_Opportunity__c": 93,
    "Refund_Method__c": 317,
    "RelatedCase__c": 229,
    "RelatedOpptyClosedwonPortfolio__c": 161,
    "RelatedOpptyClosedwonStandard__c": 162,
    "Related_Opportunity_Amended__c": 149,
    "Release_Date__c": 302,
    "Release_domain_name_website__c": 303,
    "Reopen_Count__c": 194,
    "RequestedCancellationDate__c": 174,
    "Requester_Email__c": 74,
    "Resolution_Disposition__c": 159,
    "Resolution_Health__c": 98,
    "Response_Health__c": 97,
    "Revised_Quantity__c": 325,
    "SEFMSID__c": 190,
    "SE_Billing_Email__c": 137,
    "SE_Facility_UUID__c": 316,
    "SE_Support_Email__c": 139,
    "SFClientKey__c": 189,
    "SFDemandinScopeExistingSFCustome__c": 113,
    "SF_Billing_Email__c": 138,
    "SF_Demand_in_scope_new_customer__c": 111,
    "SFfacilitykeyChildfacility__c": 181,
    "SLCorpCode__c": 191,
    "SLLocationCode__c": 192,
    "SLMSAccount__c": 182,
    "SSL_Renewal_Date__c": 134,
    "Send_Secure_Emails__c": 344,
    "ServiceContractId": 51,
    "Settings_Form_Received_On__c": 147,
    "Setupcasecreated__c": 204,
    "Shipping_Provider__c": 277,
    "Site_Status__c": 118,
    "SlaExitDate": 36,
    "SlaStartDate": 35,
    "Software_Products_to_Cancel__c": 252,
    "Software_forwardfacility__c": 304,
    "SourceId": 9,
    "SpareFoot_Product_to_Cancel__c": 253,
    "Start_Case_Auto_Close_Process_Date__c": 334,
    "Start_Case_Auto_Close_Process__c": 154,
    "Status": 18,
    "StatusReasonlastupdated__c": 208,
    "Status_Reason__c": 136,
    "StepstoReproduce__c": 116,
    "StopStartDate": 38,
    "SubType_1__c": 62,
    "SubType_2__c": 63,
    "SubType_3_c__c": 85,
    "Sub_Category__c": 239,
    "Subject": 23,
    "SuppliedCompany": 15,
    "SuppliedEmail": 13,
    "SuppliedName": 12,
    "SuppliedPhone": 14,
    "Suppress_Automated_Emails__c": 187,
    "SuspendedBy__c": 88,
    "SuspendedDate__c": 87,
    "Synched_to_Netsuite__c": 320,
    "SystemModstamp": 43,
    "Tax_rate_on_rent__c": 305,
    "Tenant_Insurance_Facility__c": 306,
    "Transferee_Company_Name__c": 307,
    "Transferee_Email__c": 308,
    "Transferee_Phone_Number__c": 309,
    "Transferee_Primary_Contact__c": 310,
    "Type": 16,
    "Type__c": 61,
    "Units__c": 124,
    "Upsell_or_Transfer__c": 323,
    "Use_Gate_Software_Provider__c": 311,
    "Use_Sparefoot_facility__c": 312,
    "Validation_Rule_Toggle__c": 326,
    "Vanilla__ForumUrl__c": 109,
    "VoyagerMigrationEnabled__c": 232,
    "WebsiteProvider_Facility__c": 313,
    "Website_Cancellation_URL__c": 255,
    "Website_Products_to_Cancel__c": 254,
    "Website__c": 128,
    "Your_SL_CorpCode__c": 314,
    "Zendesk_Ticket_ID__c": 197,
    "Zendesk_Ticket_URL__c": 196,
    "dCreated__c": 53,
    "monthlygroup__c": 225
}
    • schema_attributes: 
      {
    "ACHAccountNumber__c": "string",
    "ACHID__c": "string",
    "ACHInstitutionCity__c": "string",
    "ACHInstitutionName__c": "string",
    "ACHInstitutionPostalCode__c": "string",
    "ACHInstitutionRegion__c": "string",
    "ACHRoutingNumber__c": "string",
    "ACH_Reject_Value__c": "string",
    "ACS_quotehardware__c": "string",
    "AC_Hardware_Installment_Loan__c": "string",
    "AC_Hardware_Installment_Months__c": "string",
    "Access_Control_Products_to_Cancel__c": "string",
    "Access_after_Transfer__c": "string",
    "Access_point_restrict_keypad__c": "string",
    "Accesspointrestrict__c": "string",
    "AccountId": "string",
    "Activate_Storable_Payments__c": "string",
    "Actual_Hours_User__c": "string",
    "Actual_Hours__c": "string",
    "AdditionalNotes__c": "string",
    "Additional_Comment__c": "string",
    "Amount": "string",
    "Annualgroup__c": "string",
    "Any_Portable_Units__c": "string",
    "Approved_for_Development__c": "string",
    "Archive_Option_email_address__c": "string",
    "AssetId": "string",
    "Asset_Product_Cancel_List__c": "string",
    "Assetrequired__c": "string",
    "Assigned_Tech__c": "string",
    "Assignment_Health__c": "string",
    "AuthGroup__c": "string",
    "Auto_Closed__c": "string",
    "Auto_Reminder_Email_Sent_Date__c": "string",
    "Auto_Reminder_Email_Sent__c": "string",
    "BillableEntityID__c": "string",
    "BillingCity__c": "string",
    "BillingCountry__c": "string",
    "BillingName__c": "string",
    "BillingNotes__c": "string",
    "BillingPaymentMethod__c": "string",
    "BillingPostalCode__c": "string",
    "BillingRegion__c": "string",
    "BillingStreet__c": "string",
    "Brand__c": "string",
    "BusinessHoursId": "string",
    "CSAT_Close_Email_Exempt__c": "string",
    "CSAT_Combined_Score__c": "string",
    "CSAT_Comment__c": "string",
    "CSAT_Date_Time_Completed__c": "string",
    "CSAT_Date_Time_Sent__c": "string",
    "CSAT_NPS__c": "string",
    "CSAT_Product_Score__c": "string",
    "CSAT_Resend__c": "string",
    "CSAT_Sent__c": "string",
    "CSAT_Support_Score__c": "string",
    "CancelinBillingDate__c": "string",
    "Cancellationnoticesent__c": "string",
    "CaseNumber": "string",
    "Case_Owner_at_Close__c": "string",
    "Case_Survey_ID__c": "string",
    "Category__c": "string",
    "Category_new__c": "string",
    "ChargeOverId__c": "string",
    "Clone_softwaresetting__c": "string",
    "Clone_website_namefacility__c": "string",
    "CloseDate": "string",
    "ClosedDate": "string",
    "Closed_Reason__c": "string",
    "Comments": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Construction_openbusiness__c": "string",
    "ConsultationReasonDetails__c": "string",
    "ConsultationReason__c": "string",
    "ConsultationSize__c": "string",
    "ContactEmail": "string",
    "ContactFax": "string",
    "ContactId": "string",
    "ContactMobile": "string",
    "ContactPhone": "string",
    "ContactsEmail__c": "string",
    "ContactsName__c": "string",
    "ContactsPhone__c": "string",
    "Continue_software_service__c": "string",
    "Conversion_Complete_Date__c": "string",
    "Conversion_Scheduled_Date__c": "string",
    "Convertfromspreadsheet__c": "string",
    "CorpCode__c": "string",
    "CorpLocationID__c": "string",
    "Corp_Code_Search__c": "string",
    "CreateImplementationCase__c": "string",
    "CreatePCIrequestforSLMS__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CreditCardCVV__c": "string",
    "CreditCardExpiration__c": "string",
    "CreditCardName__c": "string",
    "CreditCardNetwork__c": "string",
    "CreditCardNumber__c": "string",
    "CurrencyIsoCode": "string",
    "Current_FMS__c": "string",
    "Current_Gate__c": "string",
    "Current_Insurance__c": "string",
    "Current_Marketplace__c": "string",
    "Current_Payment__c": "string",
    "Current_Software_Provider__c": "string",
    "Current_Website__c": "string",
    "DatawireID__c": "string",
    "Date_Assigned_to_Tech__c": "string",
    "Date_Signed__c": "string",
    "Date_Time_CSAT_Expiration__c": "string",
    "Date_start_software__c": "string",
    "Date_to_be_released__c": "string",
    "DebookedReason__c": "string",
    "Department__c": "string",
    "Description": "string",
    "Development_Priority__c": "string",
    "DisablePayeezydate__c": "string",
    "DiscontinueProductDate__c": "string",
    "Discount_Amount__c": "string",
    "Discount_Period__c": "string",
    "Discountgroup__c": "string",
    "Disposition_Estimate_Reason__c": "string",
    "Disposition_Estimate__c": "string",
    "Due_Date__c": "string",
    "EmailSubjectAddition__c": "string",
    "Email_Received_Count__c": "string",
    "EnableCustomInsurance__c": "string",
    "Enable_Storable_Payments__c": "string",
    "EntitlementId": "string",
    "EscalatedByDepartment__c": "string",
    "EscalatedById__c": "string",
    "EscalatedDate__c": "string",
    "EscalationReasonDetails__c": "string",
    "EscalationReason__c": "string",
    "Exempting_Manager__c": "string",
    "Exemption_Notes__c": "string",
    "ExistingCaseurl__c": "string",
    "Existing_Corp_Code__c": "string",
    "Existing_Logo_Corp_Code__c": "string",
    "ExpectedBehavior__c": "string",
    "ExpectedRevenue": "string",
    "FMSLaunchDate__c": "string",
    "Facility_Cancel_List__c": "string",
    "Facility_clone__c": "string",
    "FirstAssignedDate__c": "string",
    "FirstClosedDate__c": "string",
    "First_Response_Date__c": "string",
    "ForecastCategory": "string",
    "Form_Response_Record__c": "string",
    "Fulfillment_Status__c": "string",
    "Generate_ATB__c": "string",
    "Google_My_Business_Listing__c": "string",
    "HQMerchantID__c": "string",
    "Hardware_Tracking__c": "string",
    "HasCommentsUnreadByOwner": "string",
    "HasSelfServiceComments": "string",
    "Historical_Data_Selection__c": "string",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "ImplementationNotes__c": "string",
    "Implementation_CSAT_Comment__c": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Support_Score__c": "string",
    "Inbound_Call_Count__c": "string",
    "Include_In_Immediate_Release__c": "string",
    "Initial_Response_Milestone_Achieved__c": "string",
    "Insurance_Product_to_Cancel__c": "string",
    "Interest_Digital_Marketing__c": "string",
    "Interest_Sparefoot_facility__c": "string",
    "Interested_in_Data_Archive__c": "string",
    "IsClosed": "string",
    "IsClosedOnCreate": "string",
    "IsDeleted": "string",
    "IsEscalated": "string",
    "IsSelfServiceClosed": "string",
    "IsStopped": "string",
    "IsVisibleInSelfService": "string",
    "JIRAIssue__c": "string",
    "JotForm_URL__c": "string",
    "Language": "string",
    "LastInboundDate__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LastOutboundDate__c": "string",
    "Last_Call_ID__c": "string",
    "Last_Comment_Date__c": "string",
    "Last_Email_Comment_SentBy__c": "string",
    "License_Holder__c": "string",
    "List_Note__c": "string",
    "Loc_Code_Preference__c": "string",
    "LocationCode__c": "string",
    "Location_Code__c": "string",
    "MS_Preapplication_JotForm__c": "string",
    "ManageCompany_Ownersame__c": "string",
    "Managesoftware_convert__c": "string",
    "MasterICowner__c": "string",
    "MasterRecordId": "string",
    "MaxofUnits__c": "string",
    "Merch_Provider_Facility__c": "string",
    "MerchantID__c": "string",
    "Message_Sent_Count__c": "string",
    "MilestoneStatus": "string",
    "Most_Recent_Case_Comment__c": "string",
    "Name_Facility_Purchase__c": "string",
    "Net_MRR_Value__c": "string",
    "NewConstruction__c": "string",
    "NewProduct__c": "string",
    "NewWebsite_ExistingDomain__c": "string",
    "Onethingwecouldhavedonedifferently__c": "string",
    "OpportunityId": "string",
    "Opportunity_Required_Approval__c": "string",
    "Opportunity__c": "string",
    "Order_Product__c": "string",
    "Origin": "string",
    "OriginalLeaseDate__c": "string",
    "Original_Tech_Owner__c": "string",
    "Originating_Opportunity_Product__c": "string",
    "Other_Access_Cancellation_Details__c": "string",
    "Other_Marketplace_Cancellation_Details__c": "string",
    "Other_Merch_Provider__c": "string",
    "Other_Payments_Cancellation_Details__c": "string",
    "Other_Software_Cancellation_Details__c": "string",
    "Other_Software_Provider__c": "string",
    "Other_Website_Cancellation_Details__c": "string",
    "Other_Website_Provider__c": "string",
    "Outbound_Call_Count__c": "string",
    "OwnerId": "string",
    "PDK_RMA_Complete__c": "string",
    "PDK_RMA_Email_Sent__c": "string",
    "PDK_RMA__c": "string",
    "ParentId": "string",
    "Payment_or_Other_Product_to_Cancel__c": "string",
    "PreBoardingTaskscompleted__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Price__c": "string",
    "Priority": "string",
    "Probability": "string",
    "ProductId": "string",
    "Product_Family__c": "string",
    "Product__c": "string",
    "Product_new__c": "string",
    "ProductfeatureorImprovement__c": "string",
    "ProductsatRisk__c": "string",
    "ProjectedGoLiveDateConfidence__c": "string",
    "Projected_Live_Date__c": "string",
    "Public_Comment_Sent_Count__c": "string",
    "PurchFacility_SL_SE_ESS__c": "string",
    "Purchase_Order_ACH__c": "string",
    "Purchaser_Email__c": "string",
    "Purchaser_Phone__c": "string",
    "Quoted_Price__c": "string",
    "RateChange__c": "string",
    "Reason": "string",
    "ReasonDetailsifCOVID19__c": "string",
    "ReasonDetailsifother__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",
    "ReasonforCancellation__c": "string",
    "ReasonforCancellationold__c": "string",
    "Reasonforleaving__c": "string",
    "Received_by__c": "string",
    "Recipient_Email__c": "string",
    "Recipient_Facility_Name__c": "string",
    "Recipient_Name__c": "string",
    "RecordTypeId": "string",
    "Reference_Opportunity__c": "string",
    "Refund_Method__c": "string",
    "RelatedCase__c": "string",
    "RelatedOpptyClosedwonPortfolio__c": "string",
    "RelatedOpptyClosedwonStandard__c": "string",
    "Related_Opportunity_Amended__c": "string",
    "Release_Date__c": "string",
    "Release_domain_name_website__c": "string",
    "Reopen_Count__c": "string",
    "RequestedCancellationDate__c": "string",
    "Requester_Email__c": "string",
    "Resolution_Disposition__c": "string",
    "Resolution_Health__c": "string",
    "Response_Health__c": "string",
    "Revised_Quantity__c": "string",
    "SEFMSID__c": "string",
    "SE_Billing_Email__c": "string",
    "SE_Facility_UUID__c": "string",
    "SE_Support_Email__c": "string",
    "SFClientKey__c": "string",
    "SFDemandinScopeExistingSFCustome__c": "string",
    "SF_Billing_Email__c": "string",
    "SF_Demand_in_scope_new_customer__c": "string",
    "SFfacilitykeyChildfacility__c": "string",
    "SLCorpCode__c": "string",
    "SLLocationCode__c": "string",
    "SLMSAccount__c": "string",
    "SSL_Renewal_Date__c": "string",
    "Send_Secure_Emails__c": "string",
    "ServiceContractId": "string",
    "Settings_Form_Received_On__c": "string",
    "Setupcasecreated__c": "string",
    "Shipping_Provider__c": "string",
    "Site_Status__c": "string",
    "SlaExitDate": "string",
    "SlaStartDate": "string",
    "Software_Products_to_Cancel__c": "string",
    "Software_forwardfacility__c": "string",
    "SourceId": "string",
    "SpareFoot_Product_to_Cancel__c": "string",
    "StageName": "string",
    "Start_Case_Auto_Close_Process_Date__c": "string",
    "Start_Case_Auto_Close_Process__c": "string",
    "Status": "string",
    "StatusReasonlastupdated__c": "string",
    "Status_Reason__c": "string",
    "StepstoReproduce__c": "string",
    "StopStartDate": "string",
    "SubType_1__c": "string",
    "SubType_2__c": "string",
    "SubType_3_c__c": "string",
    "Sub_Category__c": "string",
    "Subject": "string",
    "SuppliedCompany": "string",
    "SuppliedEmail": "string",
    "SuppliedName": "string",
    "SuppliedPhone": "string",
    "Suppress_Automated_Emails__c": "string",
    "SuspendedBy__c": "string",
    "SuspendedDate__c": "string",
    "Synched_to_Netsuite__c": "string",
    "SystemModstamp": "string",
    "Tax_rate_on_rent__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",
    "Type": "string",
    "Type__c": "string",
    "Units__c": "string",
    "Upsell_or_Transfer__c": "string",
    "Use_Gate_Software_Provider__c": "string",
    "Use_Sparefoot_facility__c": "string",
    "Validation_Rule_Toggle__c": "string",
    "Vanilla__ForumUrl__c": "string",
    "VoyagerMigrationEnabled__c": "string",
    "WebsiteProvider_Facility__c": "string",
    "Website_Cancellation_URL__c": "string",
    "Website_Products_to_Cancel__c": "string",
    "Website__c": "string",
    "Your_SL_CorpCode__c": "string",
    "Zendesk_Ticket_ID__c": "string",
    "Zendesk_Ticket_URL__c": "string",
    "dCreated__c": "string",
    "monthlygroup__c": "string"
}
    • schema_name_id: 2082
    • schema_scan_id: 6251394
    • updated: 2023-08-16 10:32:00
    • created: 2023-08-16 09:31:55
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_cases`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_cases`\n(\n `Id`  string , `IsDeleted`  string , `MasterRecordId`  string , `CaseNumber`  string , `ContactId`  string , `AccountId`  string , `AssetId`  string , `ProductId`  string , `EntitlementId`  string , `SourceId`  string , `BusinessHoursId`  string , `ParentId`  string , `SuppliedName`  string , `SuppliedEmail`  string , `SuppliedPhone`  string , `SuppliedCompany`  string , `Type`  string , `RecordTypeId`  string , `Status`  string , `Reason`  string , `Origin`  string , `Language`  string , `IsVisibleInSelfService`  string , `Subject`  string , `Priority`  string , `Description`  string , `IsClosed`  string , `ClosedDate`  string , `IsEscalated`  string , `HasCommentsUnreadByOwner`  string , `HasSelfServiceComments`  string , `CurrencyIsoCode`  string , `OwnerId`  string , `IsClosedOnCreate`  string , `IsSelfServiceClosed`  string , `SlaStartDate`  string , `SlaExitDate`  string , `IsStopped`  string , `StopStartDate`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ContactPhone`  string , `ContactMobile`  string , `ContactEmail`  string , `ContactFax`  string , `Comments`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `ServiceContractId`  string , `MilestoneStatus`  string , `dCreated__c`  string , `ACH_Reject_Value__c`  string , `Actual_Hours__c`  string , `Due_Date__c`  string , `PreBoardingTaskscompleted__c`  string , `MS_Preapplication_JotForm__c`  string , `Original_Tech_Owner__c`  string , `Product__c`  string , `Type__c`  string , `SubType_1__c`  string , `SubType_2__c`  string , `Development_Priority__c`  string , `Outbound_Call_Count__c`  string , `Approved_for_Development__c`  string , `Department__c`  string , `Category__c`  string , `Assigned_Tech__c`  string , `Conversion_Complete_Date__c`  string , `Conversion_Scheduled_Date__c`  string , `Date_Assigned_to_Tech__c`  string , `Purchaser_Email__c`  string , `Requester_Email__c`  string , `Quoted_Price__c`  string , `Last_Call_ID__c`  string , `CreatePCIrequestforSLMS__c`  string , `Corp_Code_Search__c`  string , `Include_In_Immediate_Release__c`  string , `Actual_Hours_User__c`  string , `CSAT_Resend__c`  string , `Disposition_Estimate__c`  string , `Disposition_Estimate_Reason__c`  string , `Last_Email_Comment_SentBy__c`  string , `SubType_3_c__c`  string , `Last_Comment_Date__c`  string , `SuspendedDate__c`  string , `SuspendedBy__c`  string , `Purchaser_Phone__c`  string , `Google_My_Business_Listing__c`  string , `RateChange__c`  string , `IGD__Collection_Id__c`  string , `Reference_Opportunity__c`  string , `Opportunity__c`  string , `FirstClosedDate__c`  string , `Assignment_Health__c`  string , `Response_Health__c`  string , `Resolution_Health__c`  string , `Generate_ATB__c`  string , `EscalatedDate__c`  string , `EscalationReason__c`  string , `ACS_quotehardware__c`  string , `EscalationReasonDetails__c`  string , `EscalatedById__c`  string , `EscalatedByDepartment__c`  string , `Auto_Closed__c`  string , `Inbound_Call_Count__c`  string , `LastOutboundDate__c`  string , `Vanilla__ForumUrl__c`  string , `FirstAssignedDate__c`  string , `SF_Demand_in_scope_new_customer__c`  string , `EnableCustomInsurance__c`  string , `SFDemandinScopeExistingSFCustome__c`  string , `ExpectedBehavior__c`  string , `JIRAIssue__c`  string , `StepstoReproduce__c`  string , `Projected_Live_Date__c`  string , `Site_Status__c`  string , `Existing_Logo_Corp_Code__c`  string , `DisablePayeezydate__c`  string , `ProjectedGoLiveDateConfidence__c`  string , `LastInboundDate__c`  string , `Access_after_Transfer__c`  string , `Units__c`  string , `FMSLaunchDate__c`  string , `Category_new__c`  string , `CreateImplementationCase__c`  string , `Website__c`  string , `ImplementationNotes__c`  string , `Product_new__c`  string , `NewConstruction__c`  string , `Opportunity_Required_Approval__c`  string , `Current_FMS__c`  string , `SSL_Renewal_Date__c`  string , `Current_Website__c`  string , `Status_Reason__c`  string , `SE_Billing_Email__c`  string , `SF_Billing_Email__c`  string , `SE_Support_Email__c`  string , `Current_Gate__c`  string , `Current_Insurance__c`  string , `Current_Marketplace__c`  string , `Current_Payment__c`  string , `Net_MRR_Value__c`  string , `Case_Owner_at_Close__c`  string , `Discount_Amount__c`  string , `Settings_Form_Received_On__c`  string , `Discount_Period__c`  string , `Related_Opportunity_Amended__c`  string , `Assetrequired__c`  string , `Closed_Reason__c`  string , `MaxofUnits__c`  string , `Case_Survey_ID__c`  string , `Start_Case_Auto_Close_Process__c`  string , `Product_Family__c`  string , `Initial_Response_Milestone_Achieved__c`  string , `Most_Recent_Case_Comment__c`  string , `Brand__c`  string , `Resolution_Disposition__c`  string , `Access_point_restrict_keypad__c`  string , `RelatedOpptyClosedwonPortfolio__c`  string , `RelatedOpptyClosedwonStandard__c`  string , `Received_by__c`  string , `AdditionalNotes__c`  string , `List_Note__c`  string , `ContactsEmail__c`  string , `ContactsName__c`  string , `ContactsPhone__c`  string , `CorpCode__c`  string , `ExistingCaseurl__c`  string , `LocationCode__c`  string , `ProductsatRisk__c`  string , `ReasonforCancellationold__c`  string , `RequestedCancellationDate__c`  string , `BillableEntityID__c`  string , `CancelinBillingDate__c`  string , `ChargeOverId__c`  string , `CorpLocationID__c`  string , `NewProduct__c`  string , `OriginalLeaseDate__c`  string , `SFfacilitykeyChildfacility__c`  string , `SLMSAccount__c`  string , `BillingNotes__c`  string , `DiscontinueProductDate__c`  string , `ACHID__c`  string , `First_Response_Date__c`  string , `Suppress_Automated_Emails__c`  string , `Accesspointrestrict__c`  string , `SFClientKey__c`  string , `SEFMSID__c`  string , `SLCorpCode__c`  string , `SLLocationCode__c`  string , `MerchantID__c`  string , `Reopen_Count__c`  string , `DatawireID__c`  string , `Zendesk_Ticket_URL__c`  string , `Zendesk_Ticket_ID__c`  string , `ReasonforCancellation__c`  string , `HQMerchantID__c`  string , `MasterICowner__c`  string , `Enable_Storable_Payments__c`  string , `Activate_Storable_Payments__c`  string , `JotForm_URL__c`  string , `Setupcasecreated__c`  string , `Message_Sent_Count__c`  string , `Email_Received_Count__c`  string , `Public_Comment_Sent_Count__c`  string , `StatusReasonlastupdated__c`  string , `CSAT_Sent__c`  string , `CSAT_Combined_Score__c`  string , `Cancellationnoticesent__c`  string , `Onethingwecouldhavedonedifferently__c`  string , `ProductfeatureorImprovement__c`  string , `Reasonforleaving__c`  string , `ReasonDetailsifother__c`  string , `ReasonDetailsifCOVID19__c`  string , `DebookedReason__c`  string , `CSAT_Date_Time_Sent__c`  string , `CSAT_Support_Score__c`  string , `CSAT_Product_Score__c`  string , `CSAT_NPS__c`  string , `CSAT_Date_Time_Completed__c`  string , `CSAT_Comment__c`  string , `AuthGroup__c`  string , `monthlygroup__c`  string , `Discountgroup__c`  string , `Annualgroup__c`  string , `Date_Time_CSAT_Expiration__c`  string , `RelatedCase__c`  string , `Price__c`  string , `Additional_Comment__c`  string , `VoyagerMigrationEnabled__c`  string , `Any_Portable_Units__c`  string , `Archive_Option_email_address__c`  string , `ConsultationSize__c`  string , `ConsultationReason__c`  string , `ConsultationReasonDetails__c`  string , `Clone_softwaresetting__c`  string , `Sub_Category__c`  string , `Access_Control_Products_to_Cancel__c`  string , `Asset_Product_Cancel_List__c`  string , `Facility_Cancel_List__c`  string , `Form_Response_Record__c`  string , `Insurance_Product_to_Cancel__c`  string , `Payment_or_Other_Product_to_Cancel__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 , `Software_Products_to_Cancel__c`  string , `SpareFoot_Product_to_Cancel__c`  string , `Website_Products_to_Cancel__c`  string , `Website_Cancellation_URL__c`  string , `Hardware_Tracking__c`  string , `BillingPaymentMethod__c`  string , `BillingName__c`  string , `BillingCity__c`  string , `BillingPostalCode__c`  string , `BillingStreet__c`  string , `BillingRegion__c`  string , `BillingCountry__c`  string , `CreditCardNetwork__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 , `ACHInstitutionName__c`  string , `ACHInstitutionCity__c`  string , `ACHInstitutionRegion__c`  string , `ACHInstitutionPostalCode__c`  string , `CreditCardName__c`  string , `Fulfillment_Status__c`  string , `Shipping_Provider__c`  string , `Date_start_software__c`  string , `Auto_Reminder_Email_Sent__c`  string , `Interested_in_Data_Archive__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 , `Software_forwardfacility__c`  string , `Tax_rate_on_rent__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 , `Use_Gate_Software_Provider__c`  string , `Use_Sparefoot_facility__c`  string , `WebsiteProvider_Facility__c`  string , `Your_SL_CorpCode__c`  string , `Purchase_Order_ACH__c`  string , `SE_Facility_UUID__c`  string , `Refund_Method__c`  string , `PDK_RMA__c`  string , `EmailSubjectAddition__c`  string , `Synched_to_Netsuite__c`  string , `PDK_RMA_Complete__c`  string , `PDK_RMA_Email_Sent__c`  string , `Upsell_or_Transfer__c`  string , `Originating_Opportunity_Product__c`  string , `Revised_Quantity__c`  string , `Validation_Rule_Toggle__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_CSAT_Comment__c`  string , `Implementation_Product_Score__c`  string , `Exemption_Notes__c`  string , `Exempting_Manager__c`  string , `CSAT_Close_Email_Exempt__c`  string , `Auto_Reminder_Email_Sent_Date__c`  string , `Start_Case_Auto_Close_Process_Date__c`  string , `Other_Software_Cancellation_Details__c`  string , `Other_Website_Cancellation_Details__c`  string , `Other_Marketplace_Cancellation_Details__c`  string , `Other_Access_Cancellation_Details__c`  string , `Other_Payments_Cancellation_Details__c`  string , `AC_Hardware_Installment_Loan__c`  string , `AC_Hardware_Installment_Months__c`  string , `Implementation_Support_Score__c`  string , `Order_Product__c`  string , `Send_Secure_Emails__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/cases/2023-08-16/1692196280'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_cases"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/cases/2023-08-16/1692196280
    • id: 4697408
    • processed: 1
    • raw_data: 
      {
    "ACHID__c": 185,
    "ACHInstitutionCity__c": 272,
    "ACHInstitutionName__c": 271,
    "ACHInstitutionPostalCode__c": 274,
    "ACHInstitutionRegion__c": 273,
    "ACH_Reject_Value__c": 54,
    "ACS_quotehardware__c": 102,
    "AC_Hardware_Installment_Loan__c": 340,
    "AC_Hardware_Installment_Months__c": 341,
    "Access_Control_Products_to_Cancel__c": 240,
    "Access_after_Transfer__c": 123,
    "Access_point_restrict_keypad__c": 160,
    "Accesspointrestrict__c": 188,
    "AccountId": 5,
    "Activate_Storable_Payments__c": 202,
    "Actual_Hours_User__c": 80,
    "Actual_Hours__c": 55,
    "AdditionalNotes__c": 164,
    "Additional_Comment__c": 231,
    "Annualgroup__c": 227,
    "Any_Portable_Units__c": 233,
    "Approved_for_Development__c": 66,
    "Archive_Option_email_address__c": 234,
    "AssetId": 6,
    "Asset_Product_Cancel_List__c": 241,
    "Assetrequired__c": 150,
    "Assigned_Tech__c": 69,
    "Assignment_Health__c": 96,
    "AuthGroup__c": 224,
    "Auto_Closed__c": 106,
    "Auto_Reminder_Email_Sent_Date__c": 333,
    "Auto_Reminder_Email_Sent__c": 279,
    "BillableEntityID__c": 175,
    "BillingCity__c": 259,
    "BillingCountry__c": 263,
    "BillingName__c": 258,
    "BillingNotes__c": 183,
    "BillingPaymentMethod__c": 257,
    "BillingPostalCode__c": 260,
    "BillingRegion__c": 262,
    "BillingStreet__c": 261,
    "Brand__c": 158,
    "BusinessHoursId": 10,
    "CSAT_Close_Email_Exempt__c": 332,
    "CSAT_Combined_Score__c": 210,
    "CSAT_Comment__c": 223,
    "CSAT_Date_Time_Completed__c": 222,
    "CSAT_Date_Time_Sent__c": 218,
    "CSAT_NPS__c": 221,
    "CSAT_Product_Score__c": 220,
    "CSAT_Resend__c": 81,
    "CSAT_Sent__c": 209,
    "CSAT_Support_Score__c": 219,
    "CancelinBillingDate__c": 176,
    "Cancellationnoticesent__c": 211,
    "CaseNumber": 3,
    "Case_Owner_at_Close__c": 145,
    "Case_Survey_ID__c": 153,
    "Category__c": 68,
    "Category_new__c": 126,
    "ChargeOverId__c": 177,
    "Clone_softwaresetting__c": 238,
    "Clone_website_namefacility__c": 265,
    "ClosedDate": 27,
    "Closed_Reason__c": 151,
    "Comments": 48,
    "ConnectionReceivedId": 49,
    "ConnectionSentId": 50,
    "Construction_openbusiness__c": 266,
    "ConsultationReasonDetails__c": 237,
    "ConsultationReason__c": 236,
    "ConsultationSize__c": 235,
    "ContactEmail": 46,
    "ContactFax": 47,
    "ContactId": 4,
    "ContactMobile": 45,
    "ContactPhone": 44,
    "ContactsEmail__c": 166,
    "ContactsName__c": 167,
    "ContactsPhone__c": 168,
    "Continue_software_service__c": 267,
    "Conversion_Complete_Date__c": 70,
    "Conversion_Scheduled_Date__c": 71,
    "Convertfromspreadsheet__c": 268,
    "CorpCode__c": 169,
    "CorpLocationID__c": 178,
    "Corp_Code_Search__c": 78,
    "CreateImplementationCase__c": 127,
    "CreatePCIrequestforSLMS__c": 77,
    "CreatedById": 40,
    "CreatedDate": 39,
    "CreditCardName__c": 275,
    "CreditCardNetwork__c": 264,
    "CurrencyIsoCode": 31,
    "Current_FMS__c": 133,
    "Current_Gate__c": 140,
    "Current_Insurance__c": 141,
    "Current_Marketplace__c": 142,
    "Current_Payment__c": 143,
    "Current_Software_Provider__c": 269,
    "Current_Website__c": 135,
    "DatawireID__c": 195,
    "Date_Assigned_to_Tech__c": 72,
    "Date_Signed__c": 270,
    "Date_Time_CSAT_Expiration__c": 228,
    "Date_start_software__c": 278,
    "Date_to_be_released__c": 281,
    "DebookedReason__c": 217,
    "Department__c": 67,
    "Description": 25,
    "Development_Priority__c": 64,
    "DisablePayeezydate__c": 120,
    "DiscontinueProductDate__c": 184,
    "Discount_Amount__c": 146,
    "Discount_Period__c": 148,
    "Discountgroup__c": 226,
    "Disposition_Estimate_Reason__c": 83,
    "Disposition_Estimate__c": 82,
    "Due_Date__c": 56,
    "EmailSubjectAddition__c": 319,
    "Email_Received_Count__c": 206,
    "EnableCustomInsurance__c": 112,
    "Enable_Storable_Payments__c": 201,
    "EntitlementId": 8,
    "EscalatedByDepartment__c": 105,
    "EscalatedById__c": 104,
    "EscalatedDate__c": 100,
    "EscalationReasonDetails__c": 103,
    "EscalationReason__c": 101,
    "Exempting_Manager__c": 331,
    "Exemption_Notes__c": 330,
    "ExistingCaseurl__c": 170,
    "Existing_Corp_Code__c": 282,
    "Existing_Logo_Corp_Code__c": 119,
    "ExpectedBehavior__c": 114,
    "FMSLaunchDate__c": 125,
    "Facility_Cancel_List__c": 242,
    "Facility_clone__c": 283,
    "FirstAssignedDate__c": 110,
    "FirstClosedDate__c": 95,
    "First_Response_Date__c": 186,
    "Form_Response_Record__c": 243,
    "Fulfillment_Status__c": 276,
    "Generate_ATB__c": 99,
    "Google_My_Business_Listing__c": 90,
    "HQMerchantID__c": 199,
    "Hardware_Tracking__c": 256,
    "HasCommentsUnreadByOwner": 29,
    "HasSelfServiceComments": 30,
    "Historical_Data_Selection__c": 284,
    "IGD__Collection_Id__c": 92,
    "Id": 0,
    "ImplementationNotes__c": 129,
    "Implementation_CSAT_Comment__c": 328,
    "Implementation_Combined_Score__c": 327,
    "Implementation_Product_Score__c": 329,
    "Implementation_Support_Score__c": 342,
    "Inbound_Call_Count__c": 107,
    "Include_In_Immediate_Release__c": 79,
    "Initial_Response_Milestone_Achieved__c": 156,
    "Insurance_Product_to_Cancel__c": 244,
    "Interest_Digital_Marketing__c": 285,
    "Interest_Sparefoot_facility__c": 286,
    "Interested_in_Data_Archive__c": 280,
    "IsClosed": 26,
    "IsClosedOnCreate": 33,
    "IsDeleted": 1,
    "IsEscalated": 28,
    "IsSelfServiceClosed": 34,
    "IsStopped": 37,
    "IsVisibleInSelfService": 22,
    "JIRAIssue__c": 115,
    "JotForm_URL__c": 203,
    "Language": 21,
    "LastInboundDate__c": 122,
    "LastModifiedById": 42,
    "LastModifiedDate": 41,
    "LastOutboundDate__c": 108,
    "Last_Call_ID__c": 76,
    "Last_Comment_Date__c": 86,
    "Last_Email_Comment_SentBy__c": 84,
    "License_Holder__c": 287,
    "List_Note__c": 165,
    "Loc_Code_Preference__c": 288,
    "LocationCode__c": 171,
    "Location_Code__c": 289,
    "MS_Preapplication_JotForm__c": 58,
    "ManageCompany_Ownersame__c": 290,
    "Managesoftware_convert__c": 291,
    "MasterICowner__c": 200,
    "MasterRecordId": 2,
    "MaxofUnits__c": 152,
    "Merch_Provider_Facility__c": 292,
    "MerchantID__c": 193,
    "Message_Sent_Count__c": 205,
    "MilestoneStatus": 52,
    "Most_Recent_Case_Comment__c": 157,
    "Name_Facility_Purchase__c": 293,
    "Net_MRR_Value__c": 144,
    "NewConstruction__c": 131,
    "NewProduct__c": 179,
    "NewWebsite_ExistingDomain__c": 294,
    "Onethingwecouldhavedonedifferently__c": 212,
    "Opportunity_Required_Approval__c": 132,
    "Opportunity__c": 94,
    "Order_Product__c": 343,
    "Origin": 20,
    "OriginalLeaseDate__c": 180,
    "Original_Tech_Owner__c": 59,
    "Originating_Opportunity_Product__c": 324,
    "Other_Access_Cancellation_Details__c": 338,
    "Other_Marketplace_Cancellation_Details__c": 337,
    "Other_Merch_Provider__c": 295,
    "Other_Payments_Cancellation_Details__c": 339,
    "Other_Software_Cancellation_Details__c": 335,
    "Other_Software_Provider__c": 296,
    "Other_Website_Cancellation_Details__c": 336,
    "Other_Website_Provider__c": 297,
    "Outbound_Call_Count__c": 65,
    "OwnerId": 32,
    "PDK_RMA_Complete__c": 321,
    "PDK_RMA_Email_Sent__c": 322,
    "PDK_RMA__c": 318,
    "ParentId": 11,
    "Payment_or_Other_Product_to_Cancel__c": 245,
    "PreBoardingTaskscompleted__c": 57,
    "Price__c": 230,
    "Priority": 24,
    "ProductId": 7,
    "Product_Family__c": 155,
    "Product__c": 60,
    "Product_new__c": 130,
    "ProductfeatureorImprovement__c": 213,
    "ProductsatRisk__c": 172,
    "ProjectedGoLiveDateConfidence__c": 121,
    "Projected_Live_Date__c": 117,
    "Public_Comment_Sent_Count__c": 207,
    "PurchFacility_SL_SE_ESS__c": 298,
    "Purchase_Order_ACH__c": 315,
    "Purchaser_Email__c": 73,
    "Purchaser_Phone__c": 89,
    "Quoted_Price__c": 75,
    "RateChange__c": 91,
    "Reason": 19,
    "ReasonDetailsifCOVID19__c": 216,
    "ReasonDetailsifother__c": 215,
    "Reason_Cancel_Access_Control__c": 246,
    "Reason_Cancel_Insurance__c": 247,
    "Reason_Cancel_Payment_or_Other_Product__c": 248,
    "Reason_Cancel_Software_Product__c": 249,
    "Reason_Cancel_SpareFoot__c": 250,
    "Reason_Cancel_Website_Product__c": 251,
    "ReasonforCancellation__c": 198,
    "ReasonforCancellationold__c": 173,
    "Reasonforleaving__c": 214,
    "Received_by__c": 163,
    "Recipient_Email__c": 299,
    "Recipient_Facility_Name__c": 300,
    "Recipient_Name__c": 301,
    "RecordTypeId": 17,
    "Reference_Opportunity__c": 93,
    "Refund_Method__c": 317,
    "RelatedCase__c": 229,
    "RelatedOpptyClosedwonPortfolio__c": 161,
    "RelatedOpptyClosedwonStandard__c": 162,
    "Related_Opportunity_Amended__c": 149,
    "Release_Date__c": 302,
    "Release_domain_name_website__c": 303,
    "Reopen_Count__c": 194,
    "RequestedCancellationDate__c": 174,
    "Requester_Email__c": 74,
    "Resolution_Disposition__c": 159,
    "Resolution_Health__c": 98,
    "Response_Health__c": 97,
    "Revised_Quantity__c": 325,
    "SEFMSID__c": 190,
    "SE_Billing_Email__c": 137,
    "SE_Facility_UUID__c": 316,
    "SE_Support_Email__c": 139,
    "SFClientKey__c": 189,
    "SFDemandinScopeExistingSFCustome__c": 113,
    "SF_Billing_Email__c": 138,
    "SF_Demand_in_scope_new_customer__c": 111,
    "SFfacilitykeyChildfacility__c": 181,
    "SLCorpCode__c": 191,
    "SLLocationCode__c": 192,
    "SLMSAccount__c": 182,
    "SSL_Renewal_Date__c": 134,
    "Send_Secure_Emails__c": 344,
    "ServiceContractId": 51,
    "Settings_Form_Received_On__c": 147,
    "Setupcasecreated__c": 204,
    "Shipping_Provider__c": 277,
    "Site_Status__c": 118,
    "SlaExitDate": 36,
    "SlaStartDate": 35,
    "Software_Products_to_Cancel__c": 252,
    "Software_forwardfacility__c": 304,
    "SourceId": 9,
    "SpareFoot_Product_to_Cancel__c": 253,
    "Start_Case_Auto_Close_Process_Date__c": 334,
    "Start_Case_Auto_Close_Process__c": 154,
    "Status": 18,
    "StatusReasonlastupdated__c": 208,
    "Status_Reason__c": 136,
    "StepstoReproduce__c": 116,
    "StopStartDate": 38,
    "SubType_1__c": 62,
    "SubType_2__c": 63,
    "SubType_3_c__c": 85,
    "Sub_Category__c": 239,
    "Subject": 23,
    "SuppliedCompany": 15,
    "SuppliedEmail": 13,
    "SuppliedName": 12,
    "SuppliedPhone": 14,
    "Suppress_Automated_Emails__c": 187,
    "SuspendedBy__c": 88,
    "SuspendedDate__c": 87,
    "Synched_to_Netsuite__c": 320,
    "SystemModstamp": 43,
    "Tax_rate_on_rent__c": 305,
    "Tenant_Insurance_Facility__c": 306,
    "Transferee_Company_Name__c": 307,
    "Transferee_Email__c": 308,
    "Transferee_Phone_Number__c": 309,
    "Transferee_Primary_Contact__c": 310,
    "Type": 16,
    "Type__c": 61,
    "Units__c": 124,
    "Upsell_or_Transfer__c": 323,
    "Use_Gate_Software_Provider__c": 311,
    "Use_Sparefoot_facility__c": 312,
    "Validation_Rule_Toggle__c": 326,
    "Vanilla__ForumUrl__c": 109,
    "VoyagerMigrationEnabled__c": 232,
    "WebsiteProvider_Facility__c": 313,
    "Website_Cancellation_URL__c": 255,
    "Website_Products_to_Cancel__c": 254,
    "Website__c": 128,
    "Your_SL_CorpCode__c": 314,
    "Zendesk_Ticket_ID__c": 197,
    "Zendesk_Ticket_URL__c": 196,
    "dCreated__c": 53,
    "monthlygroup__c": 225
}
    • schema_attributes: 
      {
    "ACHAccountNumber__c": "string",
    "ACHID__c": "string",
    "ACHInstitutionCity__c": "string",
    "ACHInstitutionName__c": "string",
    "ACHInstitutionPostalCode__c": "string",
    "ACHInstitutionRegion__c": "string",
    "ACHRoutingNumber__c": "string",
    "ACH_Reject_Value__c": "string",
    "ACS_quotehardware__c": "string",
    "AC_Hardware_Installment_Loan__c": "string",
    "AC_Hardware_Installment_Months__c": "string",
    "Access_Control_Products_to_Cancel__c": "string",
    "Access_after_Transfer__c": "string",
    "Access_point_restrict_keypad__c": "string",
    "Accesspointrestrict__c": "string",
    "AccountId": "string",
    "Activate_Storable_Payments__c": "string",
    "Actual_Hours_User__c": "string",
    "Actual_Hours__c": "string",
    "AdditionalNotes__c": "string",
    "Additional_Comment__c": "string",
    "Amount": "string",
    "Annualgroup__c": "string",
    "Any_Portable_Units__c": "string",
    "Approved_for_Development__c": "string",
    "Archive_Option_email_address__c": "string",
    "AssetId": "string",
    "Asset_Product_Cancel_List__c": "string",
    "Assetrequired__c": "string",
    "Assigned_Tech__c": "string",
    "Assignment_Health__c": "string",
    "AuthGroup__c": "string",
    "Auto_Closed__c": "string",
    "Auto_Reminder_Email_Sent_Date__c": "string",
    "Auto_Reminder_Email_Sent__c": "string",
    "BillableEntityID__c": "string",
    "BillingCity__c": "string",
    "BillingCountry__c": "string",
    "BillingName__c": "string",
    "BillingNotes__c": "string",
    "BillingPaymentMethod__c": "string",
    "BillingPostalCode__c": "string",
    "BillingRegion__c": "string",
    "BillingStreet__c": "string",
    "Brand__c": "string",
    "BusinessHoursId": "string",
    "CSAT_Close_Email_Exempt__c": "string",
    "CSAT_Combined_Score__c": "string",
    "CSAT_Comment__c": "string",
    "CSAT_Date_Time_Completed__c": "string",
    "CSAT_Date_Time_Sent__c": "string",
    "CSAT_NPS__c": "string",
    "CSAT_Product_Score__c": "string",
    "CSAT_Resend__c": "string",
    "CSAT_Sent__c": "string",
    "CSAT_Support_Score__c": "string",
    "CancelinBillingDate__c": "string",
    "Cancellationnoticesent__c": "string",
    "CaseNumber": "string",
    "Case_Owner_at_Close__c": "string",
    "Case_Survey_ID__c": "string",
    "Category__c": "string",
    "Category_new__c": "string",
    "ChargeOverId__c": "string",
    "Clone_softwaresetting__c": "string",
    "Clone_website_namefacility__c": "string",
    "CloseDate": "string",
    "ClosedDate": "string",
    "Closed_Reason__c": "string",
    "Comments": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Construction_openbusiness__c": "string",
    "ConsultationReasonDetails__c": "string",
    "ConsultationReason__c": "string",
    "ConsultationSize__c": "string",
    "ContactEmail": "string",
    "ContactFax": "string",
    "ContactId": "string",
    "ContactMobile": "string",
    "ContactPhone": "string",
    "ContactsEmail__c": "string",
    "ContactsName__c": "string",
    "ContactsPhone__c": "string",
    "Continue_software_service__c": "string",
    "Conversion_Complete_Date__c": "string",
    "Conversion_Scheduled_Date__c": "string",
    "Convertfromspreadsheet__c": "string",
    "CorpCode__c": "string",
    "CorpLocationID__c": "string",
    "Corp_Code_Search__c": "string",
    "CreateImplementationCase__c": "string",
    "CreatePCIrequestforSLMS__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CreditCardCVV__c": "string",
    "CreditCardExpiration__c": "string",
    "CreditCardName__c": "string",
    "CreditCardNetwork__c": "string",
    "CreditCardNumber__c": "string",
    "CurrencyIsoCode": "string",
    "Current_FMS__c": "string",
    "Current_Gate__c": "string",
    "Current_Insurance__c": "string",
    "Current_Marketplace__c": "string",
    "Current_Payment__c": "string",
    "Current_Software_Provider__c": "string",
    "Current_Website__c": "string",
    "DatawireID__c": "string",
    "Date_Assigned_to_Tech__c": "string",
    "Date_Signed__c": "string",
    "Date_Time_CSAT_Expiration__c": "string",
    "Date_start_software__c": "string",
    "Date_to_be_released__c": "string",
    "DebookedReason__c": "string",
    "Department__c": "string",
    "Description": "string",
    "Development_Priority__c": "string",
    "DisablePayeezydate__c": "string",
    "DiscontinueProductDate__c": "string",
    "Discount_Amount__c": "string",
    "Discount_Period__c": "string",
    "Discountgroup__c": "string",
    "Disposition_Estimate_Reason__c": "string",
    "Disposition_Estimate__c": "string",
    "Due_Date__c": "string",
    "EmailSubjectAddition__c": "string",
    "Email_Received_Count__c": "string",
    "EnableCustomInsurance__c": "string",
    "Enable_Storable_Payments__c": "string",
    "EntitlementId": "string",
    "EscalatedByDepartment__c": "string",
    "EscalatedById__c": "string",
    "EscalatedDate__c": "string",
    "EscalationReasonDetails__c": "string",
    "EscalationReason__c": "string",
    "Exempting_Manager__c": "string",
    "Exemption_Notes__c": "string",
    "ExistingCaseurl__c": "string",
    "Existing_Corp_Code__c": "string",
    "Existing_Logo_Corp_Code__c": "string",
    "ExpectedBehavior__c": "string",
    "ExpectedRevenue": "string",
    "FMSLaunchDate__c": "string",
    "Facility_Cancel_List__c": "string",
    "Facility_clone__c": "string",
    "FirstAssignedDate__c": "string",
    "FirstClosedDate__c": "string",
    "First_Response_Date__c": "string",
    "ForecastCategory": "string",
    "Form_Response_Record__c": "string",
    "Fulfillment_Status__c": "string",
    "Generate_ATB__c": "string",
    "Google_My_Business_Listing__c": "string",
    "HQMerchantID__c": "string",
    "Hardware_Tracking__c": "string",
    "HasCommentsUnreadByOwner": "string",
    "HasSelfServiceComments": "string",
    "Historical_Data_Selection__c": "string",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "ImplementationNotes__c": "string",
    "Implementation_CSAT_Comment__c": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Support_Score__c": "string",
    "Inbound_Call_Count__c": "string",
    "Include_In_Immediate_Release__c": "string",
    "Initial_Response_Milestone_Achieved__c": "string",
    "Insurance_Product_to_Cancel__c": "string",
    "Interest_Digital_Marketing__c": "string",
    "Interest_Sparefoot_facility__c": "string",
    "Interested_in_Data_Archive__c": "string",
    "IsClosed": "string",
    "IsClosedOnCreate": "string",
    "IsDeleted": "string",
    "IsEscalated": "string",
    "IsSelfServiceClosed": "string",
    "IsStopped": "string",
    "IsVisibleInSelfService": "string",
    "JIRAIssue__c": "string",
    "JotForm_URL__c": "string",
    "Language": "string",
    "LastInboundDate__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LastOutboundDate__c": "string",
    "Last_Call_ID__c": "string",
    "Last_Comment_Date__c": "string",
    "Last_Email_Comment_SentBy__c": "string",
    "License_Holder__c": "string",
    "List_Note__c": "string",
    "Loc_Code_Preference__c": "string",
    "LocationCode__c": "string",
    "Location_Code__c": "string",
    "MS_Preapplication_JotForm__c": "string",
    "ManageCompany_Ownersame__c": "string",
    "Managesoftware_convert__c": "string",
    "MasterICowner__c": "string",
    "MasterRecordId": "string",
    "MaxofUnits__c": "string",
    "Merch_Provider_Facility__c": "string",
    "MerchantID__c": "string",
    "Message_Sent_Count__c": "string",
    "MilestoneStatus": "string",
    "Most_Recent_Case_Comment__c": "string",
    "Name_Facility_Purchase__c": "string",
    "Net_MRR_Value__c": "string",
    "NewConstruction__c": "string",
    "NewProduct__c": "string",
    "NewWebsite_ExistingDomain__c": "string",
    "Onethingwecouldhavedonedifferently__c": "string",
    "OpportunityId": "string",
    "Opportunity_Required_Approval__c": "string",
    "Opportunity__c": "string",
    "Order_Product__c": "string",
    "Origin": "string",
    "OriginalLeaseDate__c": "string",
    "Original_Tech_Owner__c": "string",
    "Originating_Opportunity_Product__c": "string",
    "Other_Access_Cancellation_Details__c": "string",
    "Other_Marketplace_Cancellation_Details__c": "string",
    "Other_Merch_Provider__c": "string",
    "Other_Payments_Cancellation_Details__c": "string",
    "Other_Software_Cancellation_Details__c": "string",
    "Other_Software_Provider__c": "string",
    "Other_Website_Cancellation_Details__c": "string",
    "Other_Website_Provider__c": "string",
    "Outbound_Call_Count__c": "string",
    "OwnerId": "string",
    "PDK_RMA_Complete__c": "string",
    "PDK_RMA_Email_Sent__c": "string",
    "PDK_RMA__c": "string",
    "ParentId": "string",
    "Payment_or_Other_Product_to_Cancel__c": "string",
    "PreBoardingTaskscompleted__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Price__c": "string",
    "Priority": "string",
    "Probability": "string",
    "ProductId": "string",
    "Product_Family__c": "string",
    "Product__c": "string",
    "Product_new__c": "string",
    "ProductfeatureorImprovement__c": "string",
    "ProductsatRisk__c": "string",
    "ProjectedGoLiveDateConfidence__c": "string",
    "Projected_Live_Date__c": "string",
    "Public_Comment_Sent_Count__c": "string",
    "PurchFacility_SL_SE_ESS__c": "string",
    "Purchase_Order_ACH__c": "string",
    "Purchaser_Email__c": "string",
    "Purchaser_Phone__c": "string",
    "Quoted_Price__c": "string",
    "RateChange__c": "string",
    "Reason": "string",
    "ReasonDetailsifCOVID19__c": "string",
    "ReasonDetailsifother__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",
    "ReasonforCancellation__c": "string",
    "ReasonforCancellationold__c": "string",
    "Reasonforleaving__c": "string",
    "Received_by__c": "string",
    "Recipient_Email__c": "string",
    "Recipient_Facility_Name__c": "string",
    "Recipient_Name__c": "string",
    "RecordTypeId": "string",
    "Reference_Opportunity__c": "string",
    "Refund_Method__c": "string",
    "RelatedCase__c": "string",
    "RelatedOpptyClosedwonPortfolio__c": "string",
    "RelatedOpptyClosedwonStandard__c": "string",
    "Related_Opportunity_Amended__c": "string",
    "Release_Date__c": "string",
    "Release_domain_name_website__c": "string",
    "Reopen_Count__c": "string",
    "RequestedCancellationDate__c": "string",
    "Requester_Email__c": "string",
    "Resolution_Disposition__c": "string",
    "Resolution_Health__c": "string",
    "Response_Health__c": "string",
    "Revised_Quantity__c": "string",
    "SEFMSID__c": "string",
    "SE_Billing_Email__c": "string",
    "SE_Facility_UUID__c": "string",
    "SE_Support_Email__c": "string",
    "SFClientKey__c": "string",
    "SFDemandinScopeExistingSFCustome__c": "string",
    "SF_Billing_Email__c": "string",
    "SF_Demand_in_scope_new_customer__c": "string",
    "SFfacilitykeyChildfacility__c": "string",
    "SLCorpCode__c": "string",
    "SLLocationCode__c": "string",
    "SLMSAccount__c": "string",
    "SSL_Renewal_Date__c": "string",
    "Send_Secure_Emails__c": "string",
    "ServiceContractId": "string",
    "Settings_Form_Received_On__c": "string",
    "Setupcasecreated__c": "string",
    "Shipping_Provider__c": "string",
    "Site_Status__c": "string",
    "SlaExitDate": "string",
    "SlaStartDate": "string",
    "Software_Products_to_Cancel__c": "string",
    "Software_forwardfacility__c": "string",
    "SourceId": "string",
    "SpareFoot_Product_to_Cancel__c": "string",
    "StageName": "string",
    "Start_Case_Auto_Close_Process_Date__c": "string",
    "Start_Case_Auto_Close_Process__c": "string",
    "Status": "string",
    "StatusReasonlastupdated__c": "string",
    "Status_Reason__c": "string",
    "StepstoReproduce__c": "string",
    "StopStartDate": "string",
    "SubType_1__c": "string",
    "SubType_2__c": "string",
    "SubType_3_c__c": "string",
    "Sub_Category__c": "string",
    "Subject": "string",
    "SuppliedCompany": "string",
    "SuppliedEmail": "string",
    "SuppliedName": "string",
    "SuppliedPhone": "string",
    "Suppress_Automated_Emails__c": "string",
    "SuspendedBy__c": "string",
    "SuspendedDate__c": "string",
    "Synched_to_Netsuite__c": "string",
    "SystemModstamp": "string",
    "Tax_rate_on_rent__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",
    "Type": "string",
    "Type__c": "string",
    "Units__c": "string",
    "Upsell_or_Transfer__c": "string",
    "Use_Gate_Software_Provider__c": "string",
    "Use_Sparefoot_facility__c": "string",
    "Validation_Rule_Toggle__c": "string",
    "Vanilla__ForumUrl__c": "string",
    "VoyagerMigrationEnabled__c": "string",
    "WebsiteProvider_Facility__c": "string",
    "Website_Cancellation_URL__c": "string",
    "Website_Products_to_Cancel__c": "string",
    "Website__c": "string",
    "Your_SL_CorpCode__c": "string",
    "Zendesk_Ticket_ID__c": "string",
    "Zendesk_Ticket_URL__c": "string",
    "dCreated__c": "string",
    "monthlygroup__c": "string"
}
    • schema_name_id: 2082
    • schema_scan_id: 6251294
    • updated: 2023-08-16 09:32:06
Schema Scans: 5
Last at 2024-06-10 15:36:52
    • duration: 0:00:25.335369
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6510761
    • 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/cases/2024-06-10/1718051798",
        "key": "raw/cases/2024-06-10/1718051798/cases.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_cases",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13073005879929943919,
        "service_name": "drive-thru",
        "span_id": 16160012327998186214,
        "trace_id": 5425276863239514092
    }
}
    • running: False
    • schema_name_id: 2082
    • start_time: 2024-06-10 15:36:52
    • success: True
    • trace_id: 5425276863239514092
    • duration: 0:00:21.654000
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6402672
    • 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/cases/2024-01-11/1704986067",
        "key": "raw/cases/2024-01-11/1704986067/cases.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_cases",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2364042668619483334,
        "service_name": "drive-thru",
        "span_id": 8729152415369398838,
        "trace_id": 15388460594348645193
    }
}
    • running: False
    • schema_name_id: 2082
    • start_time: 2024-01-11 09:15:12
    • success: True
    • trace_id: 15388460594348645193
    • duration: 0:00:21.053772
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6251523
    • 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/cases/2023-08-16/1692202620",
        "key": "raw/cases/2023-08-16/1692202620/cases.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_cases",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13780080992592140804,
        "service_name": "drive-thru",
        "span_id": 244439026669837125,
        "trace_id": 7981201559225925263
    }
}
    • running: False
    • schema_name_id: 2082
    • start_time: 2023-08-16 11:17:16
    • success: True
    • trace_id: 7981201559225925263
    • duration: 0:00:21.214625
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6251394
    • 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/cases/2023-08-16/1692199878",
        "key": "raw/cases/2023-08-16/1692199878/cases.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_cases",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11208142043588453428,
        "service_name": "drive-thru",
        "span_id": 15478717645381175855,
        "trace_id": 3817786477495923362
    }
}
    • running: False
    • schema_name_id: 2082
    • start_time: 2023-08-16 10:31:39
    • success: True
    • trace_id: 3817786477495923362
    • duration: 0:00:21.028344
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6251294
    • 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/cases/2023-08-16/1692196280",
        "key": "raw/cases/2023-08-16/1692196280/cases.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_cases",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8260248151476933885,
        "service_name": "drive-thru",
        "span_id": 16426251122549293917,
        "trace_id": 7700590618721404618
    }
}
    • running: False
    • schema_name_id: 2082
    • start_time: 2023-08-16 09:31:45
    • success: True
    • trace_id: 7700590618721404618
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "ACHAccountNumber__c": "string",
    "ACHID__c": "string",
    "ACHInstitutionCity__c": "string",
    "ACHInstitutionName__c": "string",
    "ACHInstitutionPostalCode__c": "string",
    "ACHInstitutionRegion__c": "string",
    "ACHRoutingNumber__c": "string",
    "ACH_Reject_Value__c": "string",
    "ACS_quotehardware__c": "string",
    "AC_Hardware_Installment_Loan__c": "string",
    "AC_Hardware_Installment_Months__c": "string",
    "Access_Control_Products_to_Cancel__c": "string",
    "Access_after_Transfer__c": "string",
    "Access_point_restrict_keypad__c": "string",
    "Accesspointrestrict__c": "string",
    "AccountId": "string",
    "Activate_Storable_Payments__c": "string",
    "Actual_Hours_User__c": "string",
    "Actual_Hours__c": "string",
    "AdditionalNotes__c": "string",
    "Additional_Comment__c": "string",
    "Amount": "string",
    "Annualgroup__c": "string",
    "Any_Portable_Units__c": "string",
    "Approved_for_Development__c": "string",
    "Archive_Option_email_address__c": "string",
    "AssetId": "string",
    "Asset_Product_Cancel_List__c": "string",
    "Assetrequired__c": "string",
    "Assigned_Tech__c": "string",
    "Assignment_Health__c": "string",
    "AuthGroup__c": "string",
    "Auto_Closed__c": "string",
    "Auto_Reminder_Email_Sent_Date__c": "string",
    "Auto_Reminder_Email_Sent__c": "string",
    "BillableEntityID__c": "string",
    "BillingCity__c": "string",
    "BillingCountry__c": "string",
    "BillingName__c": "string",
    "BillingNotes__c": "string",
    "BillingPaymentMethod__c": "string",
    "BillingPostalCode__c": "string",
    "BillingRegion__c": "string",
    "BillingStreet__c": "string",
    "Brand__c": "string",
    "BusinessHoursId": "string",
    "CP_Company_ID__c": "string",
    "CP_Location_ID__c": "string",
    "CSAT_Close_Email_Exempt__c": "string",
    "CSAT_Combined_Score__c": "string",
    "CSAT_Comment__c": "string",
    "CSAT_Date_Time_Completed__c": "string",
    "CSAT_Date_Time_Sent__c": "string",
    "CSAT_NPS__c": "string",
    "CSAT_Product_Score__c": "string",
    "CSAT_Resend__c": "string",
    "CSAT_Sent__c": "string",
    "CSAT_Support_Score__c": "string",
    "CSR_Churn_Risk__c": "string",
    "CallPotential_Products_to_Cancel__c": "string",
    "CallPotential_going_forward_at_facility__c": "string",
    "CallPotential_interest_at_facility__c": "string",
    "CancelinBillingDate__c": "string",
    "Cancellationnoticesent__c": "string",
    "CaseNumber": "string",
    "Case_Owner_at_Close__c": "string",
    "Case_Survey_ID__c": "string",
    "Category__c": "string",
    "Category_new__c": "string",
    "ChargeOverId__c": "string",
    "Clone_softwaresetting__c": "string",
    "Clone_website_namefacility__c": "string",
    "CloseDate": "string",
    "ClosedDate": "string",
    "Closed_Reason__c": "string",
    "Comments": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Construction_openbusiness__c": "string",
    "ConsultationReasonDetails__c": "string",
    "ConsultationReason__c": "string",
    "ConsultationSize__c": "string",
    "ContactEmail": "string",
    "ContactFax": "string",
    "ContactId": "string",
    "ContactMobile": "string",
    "ContactPhone": "string",
    "ContactsEmail__c": "string",
    "ContactsName__c": "string",
    "ContactsPhone__c": "string",
    "Continue_software_service__c": "string",
    "Conversion_Complete_Date__c": "string",
    "Conversion_Scheduled_Date__c": "string",
    "Convertfromspreadsheet__c": "string",
    "CorpCode__c": "string",
    "CorpLocationID__c": "string",
    "Corp_Code_Search__c": "string",
    "CreateImplementationCase__c": "string",
    "CreatePCIrequestforSLMS__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CreditCardCVV__c": "string",
    "CreditCardExpiration__c": "string",
    "CreditCardName__c": "string",
    "CreditCardNetwork__c": "string",
    "CreditCardNumber__c": "string",
    "CurrencyIsoCode": "string",
    "Current_FMS__c": "string",
    "Current_Gate__c": "string",
    "Current_Insurance__c": "string",
    "Current_Marketplace__c": "string",
    "Current_Payment__c": "string",
    "Current_Software_Provider__c": "string",
    "Current_Website__c": "string",
    "DatawireID__c": "string",
    "Date_Assigned_to_Tech__c": "string",
    "Date_Signed__c": "string",
    "Date_Time_CSAT_Expiration__c": "string",
    "Date_start_software__c": "string",
    "Date_to_be_released__c": "string",
    "DebookedReason__c": "string",
    "Department__c": "string",
    "Description": "string",
    "Development_Priority__c": "string",
    "DisablePayeezydate__c": "string",
    "DiscontinueProductDate__c": "string",
    "Discount_Amount__c": "string",
    "Discount_Period__c": "string",
    "Discountgroup__c": "string",
    "Disposition_Estimate_Reason__c": "string",
    "Disposition_Estimate__c": "string",
    "Due_Date__c": "string",
    "EmailSubjectAddition__c": "string",
    "Email_Received_Count__c": "string",
    "EnableCustomInsurance__c": "string",
    "Enable_Storable_Payments__c": "string",
    "EntitlementId": "string",
    "EscalatedByDepartment__c": "string",
    "EscalatedById__c": "string",
    "EscalatedDate__c": "string",
    "EscalationReasonDetails__c": "string",
    "EscalationReason__c": "string",
    "Exempting_Manager__c": "string",
    "Exemption_Notes__c": "string",
    "ExistingCaseurl__c": "string",
    "Existing_Corp_Code__c": "string",
    "Existing_Logo_Corp_Code__c": "string",
    "ExpectedBehavior__c": "string",
    "ExpectedRevenue": "string",
    "FMSLaunchDate__c": "string",
    "FMS_Status__c": "string",
    "Facility_Cancel_List__c": "string",
    "Facility_Phone_Number__c": "string",
    "Facility_clone__c": "string",
    "FirstAssignedDate__c": "string",
    "FirstClosedDate__c": "string",
    "First_Response_Date__c": "string",
    "ForecastCategory": "string",
    "Form_Response_Record__c": "string",
    "Fulfillment_Status__c": "string",
    "Generate_ATB__c": "string",
    "Google_My_Business_Listing__c": "string",
    "HQMerchantID__c": "string",
    "Hardware_Tracking__c": "string",
    "HasCommentsUnreadByOwner": "string",
    "HasSelfServiceComments": "string",
    "Historical_Data_Selection__c": "string",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "ImplementationNotes__c": "string",
    "Implementation_CSAT_Comment__c": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Support_Score__c": "string",
    "Inbound_Call_Count__c": "string",
    "Include_In_Immediate_Release__c": "string",
    "Initial_Response_Milestone_Achieved__c": "string",
    "Insurance_Product_to_Cancel__c": "string",
    "Interest_Digital_Marketing__c": "string",
    "Interest_Sparefoot_facility__c": "string",
    "Interest_in_CallPotential__c": "string",
    "Interested_in_Data_Archive__c": "string",
    "Interested_in_Data_Decryption__c": "string",
    "IsClosed": "string",
    "IsClosedOnCreate": "string",
    "IsDeleted": "string",
    "IsEscalated": "string",
    "IsSelfServiceClosed": "string",
    "IsStopped": "string",
    "IsVisibleInSelfService": "string",
    "JIRAIssue__c": "string",
    "JotForm_URL__c": "string",
    "Language": "string",
    "LastInboundDate__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LastOutboundDate__c": "string",
    "Last_Call_ID__c": "string",
    "Last_Comment_Date__c": "string",
    "Last_Email_Comment_SentBy__c": "string",
    "Launch_Time__c": "string",
    "License_Holder__c": "string",
    "List_Note__c": "string",
    "Loc_Code_Preference__c": "string",
    "LocationCode__c": "string",
    "Location_Code__c": "string",
    "MRR_Total__c": "string",
    "MS_Preapplication_JotForm__c": "string",
    "ManageCompany_Ownersame__c": "string",
    "Managesoftware_convert__c": "string",
    "MasterICowner__c": "string",
    "MasterRecordId": "string",
    "MaxofUnits__c": "string",
    "Merch_Provider_Facility__c": "string",
    "MerchantID__c": "string",
    "Message_Sent_Count__c": "string",
    "Messaging_Session__c": "string",
    "MilestoneStatus": "string",
    "Most_Recent_Case_Comment__c": "string",
    "Name_Facility_Purchase__c": "string",
    "Net_MRR_Total__c": "string",
    "Net_MRR_Value__c": "string",
    "NewConstruction__c": "string",
    "NewProduct__c": "string",
    "NewWebsite_ExistingDomain__c": "string",
    "Onethingwecouldhavedonedifferently__c": "string",
    "OpportunityId": "string",
    "Opportunity_Required_Approval__c": "string",
    "Opportunity__c": "string",
    "Order_Product__c": "string",
    "Origin": "string",
    "OriginalLeaseDate__c": "string",
    "Original_Launch_Date__c": "string",
    "Original_Tech_Owner__c": "string",
    "Originating_CSF_Case__c": "string",
    "Originating_Opportunity_Product__c": "string",
    "Other_Access_Cancellation_Details__c": "string",
    "Other_CallPotential_Cancellation_Details__c": "string",
    "Other_Marketplace_Cancellation_Details__c": "string",
    "Other_Merch_Provider__c": "string",
    "Other_Payments_Cancellation_Details__c": "string",
    "Other_Software_Cancellation_Details__c": "string",
    "Other_Software_Provider__c": "string",
    "Other_Website_Cancellation_Details__c": "string",
    "Other_Website_Provider__c": "string",
    "Outbound_Call_Count__c": "string",
    "OwnerId": "string",
    "PDK_RMA_Backbill_Complete__c": "string",
    "PDK_RMA_Complete__c": "string",
    "PDK_RMA_Email_Sent__c": "string",
    "PDK_RMA__c": "string",
    "PPS_Cleanup_Tool__c": "string",
    "ParentId": "string",
    "Payment_or_Other_Product_to_Cancel__c": "string",
    "PreBoardingTaskscompleted__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Price__c": "string",
    "Priority": "string",
    "Probability": "string",
    "ProductId": "string",
    "Product_Family__c": "string",
    "Product__c": "string",
    "Product_new__c": "string",
    "ProductfeatureorImprovement__c": "string",
    "ProductsatRisk__c": "string",
    "ProjectedGoLiveDateConfidence__c": "string",
    "Projected_Live_Date__c": "string",
    "Public_Comment_Sent_Count__c": "string",
    "PurchFacility_SL_SE_ESS__c": "string",
    "Purchase_Order_ACH__c": "string",
    "Purchaser_Email__c": "string",
    "Purchaser_Phone__c": "string",
    "Quoted_Price__c": "string",
    "RateChange__c": "string",
    "Reason": "string",
    "ReasonDetailsifCOVID19__c": "string",
    "ReasonDetailsifother__c": "string",
    "Reason_Cancel_Access_Control__c": "string",
    "Reason_Cancel_CallPotential__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",
    "ReasonforCancellation__c": "string",
    "ReasonforCancellationold__c": "string",
    "Reasonforleaving__c": "string",
    "Received_At__c": "string",
    "Received_by__c": "string",
    "Recipient_Email__c": "string",
    "Recipient_Facility_Name__c": "string",
    "Recipient_Name__c": "string",
    "RecordTypeId": "string",
    "Reference_Opportunity__c": "string",
    "Refund_Method__c": "string",
    "RelatedCase__c": "string",
    "RelatedOpptyClosedwonPortfolio__c": "string",
    "RelatedOpptyClosedwonStandard__c": "string",
    "Related_Opportunity_Amended__c": "string",
    "Release_Date__c": "string",
    "Release_domain_name_website__c": "string",
    "Reopen_Count__c": "string",
    "Reply_To_Email__c": "string",
    "RequestedCancellationDate__c": "string",
    "Requester_Email__c": "string",
    "Require_T1_Support__c": "string",
    "Resolution_Disposition__c": "string",
    "Resolution_Health__c": "string",
    "Response_Health__c": "string",
    "Revised_Quantity__c": "string",
    "RocketLane_Payments_URL__c": "string",
    "RocketLane_Product_List__c": "string",
    "RocketLane_Project_Notes__c": "string",
    "RocketLane_Project_URL__c": "string",
    "SEFMSID__c": "string",
    "SE_Billing_Email__c": "string",
    "SE_Facility_UUID__c": "string",
    "SE_Support_Email__c": "string",
    "SFClientKey__c": "string",
    "SFDemandinScopeExistingSFCustome__c": "string",
    "SF_Billing_Email__c": "string",
    "SF_Demand_in_scope_new_customer__c": "string",
    "SFfacilitykeyChildfacility__c": "string",
    "SLCorpCode__c": "string",
    "SLLocationCode__c": "string",
    "SLMSAccount__c": "string",
    "SSL_Renewal_Date__c": "string",
    "Send_Secure_Emails__c": "string",
    "ServiceContractId": "string",
    "Settings_Form_Received_On__c": "string",
    "Setupcasecreated__c": "string",
    "Shipping_Provider__c": "string",
    "Site_Status__c": "string",
    "SlaExitDate": "string",
    "SlaStartDate": "string",
    "Software_Products_to_Cancel__c": "string",
    "Software_forwardfacility__c": "string",
    "SourceId": "string",
    "SpareFoot_Product_to_Cancel__c": "string",
    "StageName": "string",
    "Start_Case_Auto_Close_Process_Date__c": "string",
    "Start_Case_Auto_Close_Process__c": "string",
    "Statement_ID__c": "string",
    "Status": "string",
    "StatusReasonlastupdated__c": "string",
    "Status_Reason__c": "string",
    "StepstoReproduce__c": "string",
    "StopStartDate": "string",
    "SubType_1__c": "string",
    "SubType_2__c": "string",
    "SubType_3_c__c": "string",
    "Sub_Category__c": "string",
    "Subject": "string",
    "SuppliedCompany": "string",
    "SuppliedEmail": "string",
    "SuppliedName": "string",
    "SuppliedPhone": "string",
    "Suppress_Automated_Emails__c": "string",
    "SuspendedBy__c": "string",
    "SuspendedDate__c": "string",
    "Synched_to_Netsuite__c": "string",
    "SystemModstamp": "string",
    "Tax_rate_on_rent__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",
    "Type": "string",
    "Type__c": "string",
    "Ultimate_Parent_Account_Name__c": "string",
    "Units__c": "string",
    "Upsell_or_Transfer__c": "string",
    "Use_Gate_Software_Provider__c": "string",
    "Use_Sparefoot_facility__c": "string",
    "Validation_Rule_Toggle__c": "string",
    "Vanilla__ForumUrl__c": "string",
    "VoyagerMigrationEnabled__c": "string",
    "WebsiteProvider_Facility__c": "string",
    "Website_Cancellation_URL__c": "string",
    "Website_Products_to_Cancel__c": "string",
    "Website__c": "string",
    "Your_SL_CorpCode__c": "string",
    "Zendesk_Ticket_ID__c": "string",
    "Zendesk_Ticket_URL__c": "string",
    "dCreated__c": "string",
    "monthlygroup__c": "string"
}
  • created: 2024-06-10 15:37:04
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_cases`\n(\n `Id`  string , `IsDeleted`  string , `MasterRecordId`  string , `CaseNumber`  string , `ContactId`  string , `AccountId`  string , `AssetId`  string , `ProductId`  string , `EntitlementId`  string , `SourceId`  string , `BusinessHoursId`  string , `ParentId`  string , `SuppliedName`  string , `SuppliedEmail`  string , `SuppliedPhone`  string , `SuppliedCompany`  string , `Type`  string , `RecordTypeId`  string , `Status`  string , `Reason`  string , `Origin`  string , `Language`  string , `IsVisibleInSelfService`  string , `Subject`  string , `Priority`  string , `Description`  string , `IsClosed`  string , `ClosedDate`  string , `IsEscalated`  string , `HasCommentsUnreadByOwner`  string , `HasSelfServiceComments`  string , `CurrencyIsoCode`  string , `OwnerId`  string , `IsClosedOnCreate`  string , `IsSelfServiceClosed`  string , `SlaStartDate`  string , `SlaExitDate`  string , `IsStopped`  string , `StopStartDate`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ContactPhone`  string , `ContactMobile`  string , `ContactEmail`  string , `ContactFax`  string , `Comments`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `ServiceContractId`  string , `MilestoneStatus`  string , `dCreated__c`  string , `ACH_Reject_Value__c`  string , `Actual_Hours__c`  string , `Due_Date__c`  string , `PreBoardingTaskscompleted__c`  string , `MS_Preapplication_JotForm__c`  string , `Original_Tech_Owner__c`  string , `Product__c`  string , `Type__c`  string , `SubType_1__c`  string , `SubType_2__c`  string , `Development_Priority__c`  string , `Outbound_Call_Count__c`  string , `Approved_for_Development__c`  string , `Department__c`  string , `Category__c`  string , `Assigned_Tech__c`  string , `Conversion_Complete_Date__c`  string , `Conversion_Scheduled_Date__c`  string , `Date_Assigned_to_Tech__c`  string , `Purchaser_Email__c`  string , `Requester_Email__c`  string , `Quoted_Price__c`  string , `Last_Call_ID__c`  string , `CreatePCIrequestforSLMS__c`  string , `Corp_Code_Search__c`  string , `Include_In_Immediate_Release__c`  string , `Actual_Hours_User__c`  string , `CSAT_Resend__c`  string , `Disposition_Estimate__c`  string , `Disposition_Estimate_Reason__c`  string , `Last_Email_Comment_SentBy__c`  string , `SubType_3_c__c`  string , `Last_Comment_Date__c`  string , `SuspendedDate__c`  string , `SuspendedBy__c`  string , `Purchaser_Phone__c`  string , `Google_My_Business_Listing__c`  string , `RateChange__c`  string , `IGD__Collection_Id__c`  string , `Reference_Opportunity__c`  string , `Opportunity__c`  string , `FirstClosedDate__c`  string , `Assignment_Health__c`  string , `Response_Health__c`  string , `Resolution_Health__c`  string , `Generate_ATB__c`  string , `EscalatedDate__c`  string , `EscalationReason__c`  string , `ACS_quotehardware__c`  string , `EscalationReasonDetails__c`  string , `EscalatedById__c`  string , `EscalatedByDepartment__c`  string , `Auto_Closed__c`  string , `Inbound_Call_Count__c`  string , `LastOutboundDate__c`  string , `Vanilla__ForumUrl__c`  string , `FirstAssignedDate__c`  string , `SF_Demand_in_scope_new_customer__c`  string , `EnableCustomInsurance__c`  string , `SFDemandinScopeExistingSFCustome__c`  string , `ExpectedBehavior__c`  string , `JIRAIssue__c`  string , `StepstoReproduce__c`  string , `Projected_Live_Date__c`  string , `Site_Status__c`  string , `Existing_Logo_Corp_Code__c`  string , `DisablePayeezydate__c`  string , `ProjectedGoLiveDateConfidence__c`  string , `LastInboundDate__c`  string , `Access_after_Transfer__c`  string , `Units__c`  string , `FMSLaunchDate__c`  string , `Category_new__c`  string , `CreateImplementationCase__c`  string , `Website__c`  string , `ImplementationNotes__c`  string , `Product_new__c`  string , `NewConstruction__c`  string , `Opportunity_Required_Approval__c`  string , `Current_FMS__c`  string , `SSL_Renewal_Date__c`  string , `Current_Website__c`  string , `Status_Reason__c`  string , `SE_Billing_Email__c`  string , `SF_Billing_Email__c`  string , `SE_Support_Email__c`  string , `Current_Gate__c`  string , `Current_Insurance__c`  string , `Current_Marketplace__c`  string , `Current_Payment__c`  string , `Net_MRR_Value__c`  string , `Case_Owner_at_Close__c`  string , `Discount_Amount__c`  string , `Settings_Form_Received_On__c`  string , `Discount_Period__c`  string , `Related_Opportunity_Amended__c`  string , `Assetrequired__c`  string , `Closed_Reason__c`  string , `MaxofUnits__c`  string , `Case_Survey_ID__c`  string , `Start_Case_Auto_Close_Process__c`  string , `Product_Family__c`  string , `Initial_Response_Milestone_Achieved__c`  string , `Most_Recent_Case_Comment__c`  string , `Brand__c`  string , `Resolution_Disposition__c`  string , `Access_point_restrict_keypad__c`  string , `RelatedOpptyClosedwonPortfolio__c`  string , `RelatedOpptyClosedwonStandard__c`  string , `Received_by__c`  string , `AdditionalNotes__c`  string , `List_Note__c`  string , `ContactsEmail__c`  string , `ContactsName__c`  string , `ContactsPhone__c`  string , `CorpCode__c`  string , `ExistingCaseurl__c`  string , `LocationCode__c`  string , `ProductsatRisk__c`  string , `ReasonforCancellationold__c`  string , `RequestedCancellationDate__c`  string , `BillableEntityID__c`  string , `CancelinBillingDate__c`  string , `ChargeOverId__c`  string , `CorpLocationID__c`  string , `NewProduct__c`  string , `OriginalLeaseDate__c`  string , `SFfacilitykeyChildfacility__c`  string , `SLMSAccount__c`  string , `BillingNotes__c`  string , `DiscontinueProductDate__c`  string , `ACHID__c`  string , `First_Response_Date__c`  string , `Suppress_Automated_Emails__c`  string , `Accesspointrestrict__c`  string , `SFClientKey__c`  string , `SEFMSID__c`  string , `SLCorpCode__c`  string , `SLLocationCode__c`  string , `MerchantID__c`  string , `Reopen_Count__c`  string , `DatawireID__c`  string , `Zendesk_Ticket_URL__c`  string , `Zendesk_Ticket_ID__c`  string , `ReasonforCancellation__c`  string , `HQMerchantID__c`  string , `MasterICowner__c`  string , `Enable_Storable_Payments__c`  string , `Activate_Storable_Payments__c`  string , `JotForm_URL__c`  string , `Setupcasecreated__c`  string , `Message_Sent_Count__c`  string , `Email_Received_Count__c`  string , `Public_Comment_Sent_Count__c`  string , `StatusReasonlastupdated__c`  string , `CSAT_Sent__c`  string , `CSAT_Combined_Score__c`  string , `Cancellationnoticesent__c`  string , `Onethingwecouldhavedonedifferently__c`  string , `ProductfeatureorImprovement__c`  string , `Reasonforleaving__c`  string , `ReasonDetailsifother__c`  string , `ReasonDetailsifCOVID19__c`  string , `DebookedReason__c`  string , `CSAT_Date_Time_Sent__c`  string , `CSAT_Support_Score__c`  string , `CSAT_Product_Score__c`  string , `CSAT_NPS__c`  string , `CSAT_Date_Time_Completed__c`  string , `CSAT_Comment__c`  string , `AuthGroup__c`  string , `monthlygroup__c`  string , `Discountgroup__c`  string , `Annualgroup__c`  string , `Date_Time_CSAT_Expiration__c`  string , `RelatedCase__c`  string , `Price__c`  string , `Additional_Comment__c`  string , `VoyagerMigrationEnabled__c`  string , `Any_Portable_Units__c`  string , `Archive_Option_email_address__c`  string , `ConsultationSize__c`  string , `ConsultationReason__c`  string , `ConsultationReasonDetails__c`  string , `Clone_softwaresetting__c`  string , `Sub_Category__c`  string , `Access_Control_Products_to_Cancel__c`  string , `Asset_Product_Cancel_List__c`  string , `Facility_Cancel_List__c`  string , `Form_Response_Record__c`  string , `Insurance_Product_to_Cancel__c`  string , `Payment_or_Other_Product_to_Cancel__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 , `Software_Products_to_Cancel__c`  string , `SpareFoot_Product_to_Cancel__c`  string , `Website_Products_to_Cancel__c`  string , `Website_Cancellation_URL__c`  string , `Hardware_Tracking__c`  string , `BillingPaymentMethod__c`  string , `BillingName__c`  string , `BillingCity__c`  string , `BillingPostalCode__c`  string , `BillingStreet__c`  string , `BillingRegion__c`  string , `BillingCountry__c`  string , `CreditCardNetwork__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 , `ACHInstitutionName__c`  string , `ACHInstitutionCity__c`  string , `ACHInstitutionRegion__c`  string , `ACHInstitutionPostalCode__c`  string , `CreditCardName__c`  string , `Fulfillment_Status__c`  string , `Shipping_Provider__c`  string , `Date_start_software__c`  string , `Auto_Reminder_Email_Sent__c`  string , `Interested_in_Data_Archive__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 , `Software_forwardfacility__c`  string , `Tax_rate_on_rent__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 , `Use_Gate_Software_Provider__c`  string , `Use_Sparefoot_facility__c`  string , `WebsiteProvider_Facility__c`  string , `Your_SL_CorpCode__c`  string , `Purchase_Order_ACH__c`  string , `SE_Facility_UUID__c`  string , `Refund_Method__c`  string , `PDK_RMA__c`  string , `EmailSubjectAddition__c`  string , `Synched_to_Netsuite__c`  string , `PDK_RMA_Complete__c`  string , `PDK_RMA_Email_Sent__c`  string , `Upsell_or_Transfer__c`  string , `Originating_Opportunity_Product__c`  string , `Revised_Quantity__c`  string , `Validation_Rule_Toggle__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_CSAT_Comment__c`  string , `Implementation_Product_Score__c`  string , `Exemption_Notes__c`  string , `Exempting_Manager__c`  string , `CSAT_Close_Email_Exempt__c`  string , `Auto_Reminder_Email_Sent_Date__c`  string , `Start_Case_Auto_Close_Process_Date__c`  string , `Other_Software_Cancellation_Details__c`  string , `Other_Website_Cancellation_Details__c`  string , `Other_Marketplace_Cancellation_Details__c`  string , `Other_Access_Cancellation_Details__c`  string , `Other_Payments_Cancellation_Details__c`  string , `AC_Hardware_Installment_Loan__c`  string , `AC_Hardware_Installment_Months__c`  string , `Implementation_Support_Score__c`  string , `Order_Product__c`  string , `Send_Secure_Emails__c`  string , `RocketLane_Product_List__c`  string , `RocketLane_Project_Notes__c`  string , `RocketLane_Project_URL__c`  string , `Original_Launch_Date__c`  string , `Launch_Time__c`  string , `Require_T1_Support__c`  string , `MRR_Total__c`  string , `Net_MRR_Total__c`  string , `Originating_CSF_Case__c`  string , `Reply_To_Email__c`  string , `CallPotential_Products_to_Cancel__c`  string , `Other_CallPotential_Cancellation_Details__c`  string , `Reason_Cancel_CallPotential__c`  string , `CP_Company_ID__c`  string , `CP_Location_ID__c`  string , `FMS_Status__c`  string , `Ultimate_Parent_Account_Name__c`  string , `Interested_in_Data_Decryption__c`  string , `CSR_Churn_Risk__c`  string , `Received_At__c`  string , `Statement_ID__c`  string , `Messaging_Session__c`  string , `RocketLane_Payments_URL__c`  string , `CallPotential_going_forward_at_facility__c`  string , `CallPotential_interest_at_facility__c`  string , `Interest_in_CallPotential__c`  string , `Facility_Phone_Number__c`  string , `PPS_Cleanup_Tool__c`  string , `PDK_RMA_Backbill_Complete__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/cases/2024-06-10/1718051798'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_cases`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_cases"
}
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:55:26",
        "disabled": false,
        "format": "raw",
        "id": 2082,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "salesforce_cases"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "ACHAccountNumber__c": "string",
            "ACHID__c": "string",
            "ACHInstitutionCity__c": "string",
            "ACHInstitutionName__c": "string",
            "ACHInstitutionPostalCode__c": "string",
            "ACHInstitutionRegion__c": "string",
            "ACHRoutingNumber__c": "string",
            "ACH_Reject_Value__c": "string",
            "ACS_quotehardware__c": "string",
            "AC_Hardware_Installment_Loan__c": "string",
            "AC_Hardware_Installment_Months__c": "string",
            "Access_Control_Products_to_Cancel__c": "string",
            "Access_after_Transfer__c": "string",
            "Access_point_restrict_keypad__c": "string",
            "Accesspointrestrict__c": "string",
            "AccountId": "string",
            "Activate_Storable_Payments__c": "string",
            "Actual_Hours_User__c": "string",
            "Actual_Hours__c": "string",
            "AdditionalNotes__c": "string",
            "Additional_Comment__c": "string",
            "Amount": "string",
            "Annualgroup__c": "string",
            "Any_Portable_Units__c": "string",
            "Approved_for_Development__c": "string",
            "Archive_Option_email_address__c": "string",
            "AssetId": "string",
            "Asset_Product_Cancel_List__c": "string",
            "Assetrequired__c": "string",
            "Assigned_Tech__c": "string",
            "Assignment_Health__c": "string",
            "AuthGroup__c": "string",
            "Auto_Closed__c": "string",
            "Auto_Reminder_Email_Sent_Date__c": "string",
            "Auto_Reminder_Email_Sent__c": "string",
            "BillableEntityID__c": "string",
            "BillingCity__c": "string",
            "BillingCountry__c": "string",
            "BillingName__c": "string",
            "BillingNotes__c": "string",
            "BillingPaymentMethod__c": "string",
            "BillingPostalCode__c": "string",
            "BillingRegion__c": "string",
            "BillingStreet__c": "string",
            "Brand__c": "string",
            "BusinessHoursId": "string",
            "CP_Company_ID__c": "string",
            "CP_Location_ID__c": "string",
            "CSAT_Close_Email_Exempt__c": "string",
            "CSAT_Combined_Score__c": "string",
            "CSAT_Comment__c": "string",
            "CSAT_Date_Time_Completed__c": "string",
            "CSAT_Date_Time_Sent__c": "string",
            "CSAT_NPS__c": "string",
            "CSAT_Product_Score__c": "string",
            "CSAT_Resend__c": "string",
            "CSAT_Sent__c": "string",
            "CSAT_Support_Score__c": "string",
            "CSR_Churn_Risk__c": "string",
            "CallPotential_Products_to_Cancel__c": "string",
            "CallPotential_going_forward_at_facility__c": "string",
            "CallPotential_interest_at_facility__c": "string",
            "CancelinBillingDate__c": "string",
            "Cancellationnoticesent__c": "string",
            "CaseNumber": "string",
            "Case_Owner_at_Close__c": "string",
            "Case_Survey_ID__c": "string",
            "Category__c": "string",
            "Category_new__c": "string",
            "ChargeOverId__c": "string",
            "Clone_softwaresetting__c": "string",
            "Clone_website_namefacility__c": "string",
            "CloseDate": "string",
            "ClosedDate": "string",
            "Closed_Reason__c": "string",
            "Comments": "string",
            "ConnectionReceivedId": "string",
            "ConnectionSentId": "string",
            "Construction_openbusiness__c": "string",
            "ConsultationReasonDetails__c": "string",
            "ConsultationReason__c": "string",
            "ConsultationSize__c": "string",
            "ContactEmail": "string",
            "ContactFax": "string",
            "ContactId": "string",
            "ContactMobile": "string",
            "ContactPhone": "string",
            "ContactsEmail__c": "string",
            "ContactsName__c": "string",
            "ContactsPhone__c": "string",
            "Continue_software_service__c": "string",
            "Conversion_Complete_Date__c": "string",
            "Conversion_Scheduled_Date__c": "string",
            "Convertfromspreadsheet__c": "string",
            "CorpCode__c": "string",
            "CorpLocationID__c": "string",
            "Corp_Code_Search__c": "string",
            "CreateImplementationCase__c": "string",
            "CreatePCIrequestforSLMS__c": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "CreditCardCVV__c": "string",
            "CreditCardExpiration__c": "string",
            "CreditCardName__c": "string",
            "CreditCardNetwork__c": "string",
            "CreditCardNumber__c": "string",
            "CurrencyIsoCode": "string",
            "Current_FMS__c": "string",
            "Current_Gate__c": "string",
            "Current_Insurance__c": "string",
            "Current_Marketplace__c": "string",
            "Current_Payment__c": "string",
            "Current_Software_Provider__c": "string",
            "Current_Website__c": "string",
            "DatawireID__c": "string",
            "Date_Assigned_to_Tech__c": "string",
            "Date_Signed__c": "string",
            "Date_Time_CSAT_Expiration__c": "string",
            "Date_start_software__c": "string",
            "Date_to_be_released__c": "string",
            "DebookedReason__c": "string",
            "Department__c": "string",
            "Description": "string",
            "Development_Priority__c": "string",
            "DisablePayeezydate__c": "string",
            "DiscontinueProductDate__c": "string",
            "Discount_Amount__c": "string",
            "Discount_Period__c": "string",
            "Discountgroup__c": "string",
            "Disposition_Estimate_Reason__c": "string",
            "Disposition_Estimate__c": "string",
            "Due_Date__c": "string",
            "EmailSubjectAddition__c": "string",
            "Email_Received_Count__c": "string",
            "EnableCustomInsurance__c": "string",
            "Enable_Storable_Payments__c": "string",
            "EntitlementId": "string",
            "EscalatedByDepartment__c": "string",
            "EscalatedById__c": "string",
            "EscalatedDate__c": "string",
            "EscalationReasonDetails__c": "string",
            "EscalationReason__c": "string",
            "Exempting_Manager__c": "string",
            "Exemption_Notes__c": "string",
            "ExistingCaseurl__c": "string",
            "Existing_Corp_Code__c": "string",
            "Existing_Logo_Corp_Code__c": "string",
            "ExpectedBehavior__c": "string",
            "ExpectedRevenue": "string",
            "FMSLaunchDate__c": "string",
            "FMS_Status__c": "string",
            "Facility_Cancel_List__c": "string",
            "Facility_Phone_Number__c": "string",
            "Facility_clone__c": "string",
            "FirstAssignedDate__c": "string",
            "FirstClosedDate__c": "string",
            "First_Response_Date__c": "string",
            "ForecastCategory": "string",
            "Form_Response_Record__c": "string",
            "Fulfillment_Status__c": "string",
            "Generate_ATB__c": "string",
            "Google_My_Business_Listing__c": "string",
            "HQMerchantID__c": "string",
            "Hardware_Tracking__c": "string",
            "HasCommentsUnreadByOwner": "string",
            "HasSelfServiceComments": "string",
            "Historical_Data_Selection__c": "string",
            "IGD__Collection_Id__c": "string",
            "Id": "string",
            "ImplementationNotes__c": "string",
            "Implementation_CSAT_Comment__c": "string",
            "Implementation_Combined_Score__c": "string",
            "Implementation_Product_Score__c": "string",
            "Implementation_Support_Score__c": "string",
            "Inbound_Call_Count__c": "string",
            "Include_In_Immediate_Release__c": "string",
            "Initial_Response_Milestone_Achieved__c": "string",
            "Insurance_Product_to_Cancel__c": "string",
            "Interest_Digital_Marketing__c": "string",
            "Interest_Sparefoot_facility__c": "string",
            "Interest_in_CallPotential__c": "string",
            "Interested_in_Data_Archive__c": "string",
            "Interested_in_Data_Decryption__c": "string",
            "IsClosed": "string",
            "IsClosedOnCreate": "string",
            "IsDeleted": "string",
            "IsEscalated": "string",
            "IsSelfServiceClosed": "string",
            "IsStopped": "string",
            "IsVisibleInSelfService": "string",
            "JIRAIssue__c": "string",
            "JotForm_URL__c": "string",
            "Language": "string",
            "LastInboundDate__c": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "LastOutboundDate__c": "string",
            "Last_Call_ID__c": "string",
            "Last_Comment_Date__c": "string",
            "Last_Email_Comment_SentBy__c": "string",
            "Launch_Time__c": "string",
            "License_Holder__c": "string",
            "List_Note__c": "string",
            "Loc_Code_Preference__c": "string",
            "LocationCode__c": "string",
            "Location_Code__c": "string",
            "MRR_Total__c": "string",
            "MS_Preapplication_JotForm__c": "string",
            "ManageCompany_Ownersame__c": "string",
            "Managesoftware_convert__c": "string",
            "MasterICowner__c": "string",
            "MasterRecordId": "string",
            "MaxofUnits__c": "string",
            "Merch_Provider_Facility__c": "string",
            "MerchantID__c": "string",
            "Message_Sent_Count__c": "string",
            "Messaging_Session__c": "string",
            "MilestoneStatus": "string",
            "Most_Recent_Case_Comment__c": "string",
            "Name_Facility_Purchase__c": "string",
            "Net_MRR_Total__c": "string",
            "Net_MRR_Value__c": "string",
            "NewConstruction__c": "string",
            "NewProduct__c": "string",
            "NewWebsite_ExistingDomain__c": "string",
            "Onethingwecouldhavedonedifferently__c": "string",
            "OpportunityId": "string",
            "Opportunity_Required_Approval__c": "string",
            "Opportunity__c": "string",
            "Order_Product__c": "string",
            "Origin": "string",
            "OriginalLeaseDate__c": "string",
            "Original_Launch_Date__c": "string",
            "Original_Tech_Owner__c": "string",
            "Originating_CSF_Case__c": "string",
            "Originating_Opportunity_Product__c": "string",
            "Other_Access_Cancellation_Details__c": "string",
            "Other_CallPotential_Cancellation_Details__c": "string",
            "Other_Marketplace_Cancellation_Details__c": "string",
            "Other_Merch_Provider__c": "string",
            "Other_Payments_Cancellation_Details__c": "string",
            "Other_Software_Cancellation_Details__c": "string",
            "Other_Software_Provider__c": "string",
            "Other_Website_Cancellation_Details__c": "string",
            "Other_Website_Provider__c": "string",
            "Outbound_Call_Count__c": "string",
            "OwnerId": "string",
            "PDK_RMA_Backbill_Complete__c": "string",
            "PDK_RMA_Complete__c": "string",
            "PDK_RMA_Email_Sent__c": "string",
            "PDK_RMA__c": "string",
            "PPS_Cleanup_Tool__c": "string",
            "ParentId": "string",
            "Payment_or_Other_Product_to_Cancel__c": "string",
            "PreBoardingTaskscompleted__c": "string",
            "PrevAmount": "string",
            "PrevCloseDate": "string",
            "Price__c": "string",
            "Priority": "string",
            "Probability": "string",
            "ProductId": "string",
            "Product_Family__c": "string",
            "Product__c": "string",
            "Product_new__c": "string",
            "ProductfeatureorImprovement__c": "string",
            "ProductsatRisk__c": "string",
            "ProjectedGoLiveDateConfidence__c": "string",
            "Projected_Live_Date__c": "string",
            "Public_Comment_Sent_Count__c": "string",
            "PurchFacility_SL_SE_ESS__c": "string",
            "Purchase_Order_ACH__c": "string",
            "Purchaser_Email__c": "string",
            "Purchaser_Phone__c": "string",
            "Quoted_Price__c": "string",
            "RateChange__c": "string",
            "Reason": "string",
            "ReasonDetailsifCOVID19__c": "string",
            "ReasonDetailsifother__c": "string",
            "Reason_Cancel_Access_Control__c": "string",
            "Reason_Cancel_CallPotential__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",
            "ReasonforCancellation__c": "string",
            "ReasonforCancellationold__c": "string",
            "Reasonforleaving__c": "string",
            "Received_At__c": "string",
            "Received_by__c": "string",
            "Recipient_Email__c": "string",
            "Recipient_Facility_Name__c": "string",
            "Recipient_Name__c": "string",
            "RecordTypeId": "string",
            "Reference_Opportunity__c": "string",
            "Refund_Method__c": "string",
            "RelatedCase__c": "string",
            "RelatedOpptyClosedwonPortfolio__c": "string",
            "RelatedOpptyClosedwonStandard__c": "string",
            "Related_Opportunity_Amended__c": "string",
            "Release_Date__c": "string",
            "Release_domain_name_website__c": "string",
            "Reopen_Count__c": "string",
            "Reply_To_Email__c": "string",
            "RequestedCancellationDate__c": "string",
            "Requester_Email__c": "string",
            "Require_T1_Support__c": "string",
            "Resolution_Disposition__c": "string",
            "Resolution_Health__c": "string",
            "Response_Health__c": "string",
            "Revised_Quantity__c": "string",
            "RocketLane_Payments_URL__c": "string",
            "RocketLane_Product_List__c": "string",
            "RocketLane_Project_Notes__c": "string",
            "RocketLane_Project_URL__c": "string",
            "SEFMSID__c": "string",
            "SE_Billing_Email__c": "string",
            "SE_Facility_UUID__c": "string",
            "SE_Support_Email__c": "string",
            "SFClientKey__c": "string",
            "SFDemandinScopeExistingSFCustome__c": "string",
            "SF_Billing_Email__c": "string",
            "SF_Demand_in_scope_new_customer__c": "string",
            "SFfacilitykeyChildfacility__c": "string",
            "SLCorpCode__c": "string",
            "SLLocationCode__c": "string",
            "SLMSAccount__c": "string",
            "SSL_Renewal_Date__c": "string",
            "Send_Secure_Emails__c": "string",
            "ServiceContractId": "string",
            "Settings_Form_Received_On__c": "string",
            "Setupcasecreated__c": "string",
            "Shipping_Provider__c": "string",
            "Site_Status__c": "string",
            "SlaExitDate": "string",
            "SlaStartDate": "string",
            "Software_Products_to_Cancel__c": "string",
            "Software_forwardfacility__c": "string",
            "SourceId": "string",
            "SpareFoot_Product_to_Cancel__c": "string",
            "StageName": "string",
            "Start_Case_Auto_Close_Process_Date__c": "string",
            "Start_Case_Auto_Close_Process__c": "string",
            "Statement_ID__c": "string",
            "Status": "string",
            "StatusReasonlastupdated__c": "string",
            "Status_Reason__c": "string",
            "StepstoReproduce__c": "string",
            "StopStartDate": "string",
            "SubType_1__c": "string",
            "SubType_2__c": "string",
            "SubType_3_c__c": "string",
            "Sub_Category__c": "string",
            "Subject": "string",
            "SuppliedCompany": "string",
            "SuppliedEmail": "string",
            "SuppliedName": "string",
            "SuppliedPhone": "string",
            "Suppress_Automated_Emails__c": "string",
            "SuspendedBy__c": "string",
            "SuspendedDate__c": "string",
            "Synched_to_Netsuite__c": "string",
            "SystemModstamp": "string",
            "Tax_rate_on_rent__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",
            "Type": "string",
            "Type__c": "string",
            "Ultimate_Parent_Account_Name__c": "string",
            "Units__c": "string",
            "Upsell_or_Transfer__c": "string",
            "Use_Gate_Software_Provider__c": "string",
            "Use_Sparefoot_facility__c": "string",
            "Validation_Rule_Toggle__c": "string",
            "Vanilla__ForumUrl__c": "string",
            "VoyagerMigrationEnabled__c": "string",
            "WebsiteProvider_Facility__c": "string",
            "Website_Cancellation_URL__c": "string",
            "Website_Products_to_Cancel__c": "string",
            "Website__c": "string",
            "Your_SL_CorpCode__c": "string",
            "Zendesk_Ticket_ID__c": "string",
            "Zendesk_Ticket_URL__c": "string",
            "dCreated__c": "string",
            "monthlygroup__c": "string"
        },
        "created": "2024-06-10 15:37:04",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_cases`\n(\n `Id`  string , `IsDeleted`  string , `MasterRecordId`  string , `CaseNumber`  string , `ContactId`  string , `AccountId`  string , `AssetId`  string , `ProductId`  string , `EntitlementId`  string , `SourceId`  string , `BusinessHoursId`  string , `ParentId`  string , `SuppliedName`  string , `SuppliedEmail`  string , `SuppliedPhone`  string , `SuppliedCompany`  string , `Type`  string , `RecordTypeId`  string , `Status`  string , `Reason`  string , `Origin`  string , `Language`  string , `IsVisibleInSelfService`  string , `Subject`  string , `Priority`  string , `Description`  string , `IsClosed`  string , `ClosedDate`  string , `IsEscalated`  string , `HasCommentsUnreadByOwner`  string , `HasSelfServiceComments`  string , `CurrencyIsoCode`  string , `OwnerId`  string , `IsClosedOnCreate`  string , `IsSelfServiceClosed`  string , `SlaStartDate`  string , `SlaExitDate`  string , `IsStopped`  string , `StopStartDate`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ContactPhone`  string , `ContactMobile`  string , `ContactEmail`  string , `ContactFax`  string , `Comments`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `ServiceContractId`  string , `MilestoneStatus`  string , `dCreated__c`  string , `ACH_Reject_Value__c`  string , `Actual_Hours__c`  string , `Due_Date__c`  string , `PreBoardingTaskscompleted__c`  string , `MS_Preapplication_JotForm__c`  string , `Original_Tech_Owner__c`  string , `Product__c`  string , `Type__c`  string , `SubType_1__c`  string , `SubType_2__c`  string , `Development_Priority__c`  string , `Outbound_Call_Count__c`  string , `Approved_for_Development__c`  string , `Department__c`  string , `Category__c`  string , `Assigned_Tech__c`  string , `Conversion_Complete_Date__c`  string , `Conversion_Scheduled_Date__c`  string , `Date_Assigned_to_Tech__c`  string , `Purchaser_Email__c`  string , `Requester_Email__c`  string , `Quoted_Price__c`  string , `Last_Call_ID__c`  string , `CreatePCIrequestforSLMS__c`  string , `Corp_Code_Search__c`  string , `Include_In_Immediate_Release__c`  string , `Actual_Hours_User__c`  string , `CSAT_Resend__c`  string , `Disposition_Estimate__c`  string , `Disposition_Estimate_Reason__c`  string , `Last_Email_Comment_SentBy__c`  string , `SubType_3_c__c`  string , `Last_Comment_Date__c`  string , `SuspendedDate__c`  string , `SuspendedBy__c`  string , `Purchaser_Phone__c`  string , `Google_My_Business_Listing__c`  string , `RateChange__c`  string , `IGD__Collection_Id__c`  string , `Reference_Opportunity__c`  string , `Opportunity__c`  string , `FirstClosedDate__c`  string , `Assignment_Health__c`  string , `Response_Health__c`  string , `Resolution_Health__c`  string , `Generate_ATB__c`  string , `EscalatedDate__c`  string , `EscalationReason__c`  string , `ACS_quotehardware__c`  string , `EscalationReasonDetails__c`  string , `EscalatedById__c`  string , `EscalatedByDepartment__c`  string , `Auto_Closed__c`  string , `Inbound_Call_Count__c`  string , `LastOutboundDate__c`  string , `Vanilla__ForumUrl__c`  string , `FirstAssignedDate__c`  string , `SF_Demand_in_scope_new_customer__c`  string , `EnableCustomInsurance__c`  string , `SFDemandinScopeExistingSFCustome__c`  string , `ExpectedBehavior__c`  string , `JIRAIssue__c`  string , `StepstoReproduce__c`  string , `Projected_Live_Date__c`  string , `Site_Status__c`  string , `Existing_Logo_Corp_Code__c`  string , `DisablePayeezydate__c`  string , `ProjectedGoLiveDateConfidence__c`  string , `LastInboundDate__c`  string , `Access_after_Transfer__c`  string , `Units__c`  string , `FMSLaunchDate__c`  string , `Category_new__c`  string , `CreateImplementationCase__c`  string , `Website__c`  string , `ImplementationNotes__c`  string , `Product_new__c`  string , `NewConstruction__c`  string , `Opportunity_Required_Approval__c`  string , `Current_FMS__c`  string , `SSL_Renewal_Date__c`  string , `Current_Website__c`  string , `Status_Reason__c`  string , `SE_Billing_Email__c`  string , `SF_Billing_Email__c`  string , `SE_Support_Email__c`  string , `Current_Gate__c`  string , `Current_Insurance__c`  string , `Current_Marketplace__c`  string , `Current_Payment__c`  string , `Net_MRR_Value__c`  string , `Case_Owner_at_Close__c`  string , `Discount_Amount__c`  string , `Settings_Form_Received_On__c`  string , `Discount_Period__c`  string , `Related_Opportunity_Amended__c`  string , `Assetrequired__c`  string , `Closed_Reason__c`  string , `MaxofUnits__c`  string , `Case_Survey_ID__c`  string , `Start_Case_Auto_Close_Process__c`  string , `Product_Family__c`  string , `Initial_Response_Milestone_Achieved__c`  string , `Most_Recent_Case_Comment__c`  string , `Brand__c`  string , `Resolution_Disposition__c`  string , `Access_point_restrict_keypad__c`  string , `RelatedOpptyClosedwonPortfolio__c`  string , `RelatedOpptyClosedwonStandard__c`  string , `Received_by__c`  string , `AdditionalNotes__c`  string , `List_Note__c`  string , `ContactsEmail__c`  string , `ContactsName__c`  string , `ContactsPhone__c`  string , `CorpCode__c`  string , `ExistingCaseurl__c`  string , `LocationCode__c`  string , `ProductsatRisk__c`  string , `ReasonforCancellationold__c`  string , `RequestedCancellationDate__c`  string , `BillableEntityID__c`  string , `CancelinBillingDate__c`  string , `ChargeOverId__c`  string , `CorpLocationID__c`  string , `NewProduct__c`  string , `OriginalLeaseDate__c`  string , `SFfacilitykeyChildfacility__c`  string , `SLMSAccount__c`  string , `BillingNotes__c`  string , `DiscontinueProductDate__c`  string , `ACHID__c`  string , `First_Response_Date__c`  string , `Suppress_Automated_Emails__c`  string , `Accesspointrestrict__c`  string , `SFClientKey__c`  string , `SEFMSID__c`  string , `SLCorpCode__c`  string , `SLLocationCode__c`  string , `MerchantID__c`  string , `Reopen_Count__c`  string , `DatawireID__c`  string , `Zendesk_Ticket_URL__c`  string , `Zendesk_Ticket_ID__c`  string , `ReasonforCancellation__c`  string , `HQMerchantID__c`  string , `MasterICowner__c`  string , `Enable_Storable_Payments__c`  string , `Activate_Storable_Payments__c`  string , `JotForm_URL__c`  string , `Setupcasecreated__c`  string , `Message_Sent_Count__c`  string , `Email_Received_Count__c`  string , `Public_Comment_Sent_Count__c`  string , `StatusReasonlastupdated__c`  string , `CSAT_Sent__c`  string , `CSAT_Combined_Score__c`  string , `Cancellationnoticesent__c`  string , `Onethingwecouldhavedonedifferently__c`  string , `ProductfeatureorImprovement__c`  string , `Reasonforleaving__c`  string , `ReasonDetailsifother__c`  string , `ReasonDetailsifCOVID19__c`  string , `DebookedReason__c`  string , `CSAT_Date_Time_Sent__c`  string , `CSAT_Support_Score__c`  string , `CSAT_Product_Score__c`  string , `CSAT_NPS__c`  string , `CSAT_Date_Time_Completed__c`  string , `CSAT_Comment__c`  string , `AuthGroup__c`  string , `monthlygroup__c`  string , `Discountgroup__c`  string , `Annualgroup__c`  string , `Date_Time_CSAT_Expiration__c`  string , `RelatedCase__c`  string , `Price__c`  string , `Additional_Comment__c`  string , `VoyagerMigrationEnabled__c`  string , `Any_Portable_Units__c`  string , `Archive_Option_email_address__c`  string , `ConsultationSize__c`  string , `ConsultationReason__c`  string , `ConsultationReasonDetails__c`  string , `Clone_softwaresetting__c`  string , `Sub_Category__c`  string , `Access_Control_Products_to_Cancel__c`  string , `Asset_Product_Cancel_List__c`  string , `Facility_Cancel_List__c`  string , `Form_Response_Record__c`  string , `Insurance_Product_to_Cancel__c`  string , `Payment_or_Other_Product_to_Cancel__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 , `Software_Products_to_Cancel__c`  string , `SpareFoot_Product_to_Cancel__c`  string , `Website_Products_to_Cancel__c`  string , `Website_Cancellation_URL__c`  string , `Hardware_Tracking__c`  string , `BillingPaymentMethod__c`  string , `BillingName__c`  string , `BillingCity__c`  string , `BillingPostalCode__c`  string , `BillingStreet__c`  string , `BillingRegion__c`  string , `BillingCountry__c`  string , `CreditCardNetwork__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 , `ACHInstitutionName__c`  string , `ACHInstitutionCity__c`  string , `ACHInstitutionRegion__c`  string , `ACHInstitutionPostalCode__c`  string , `CreditCardName__c`  string , `Fulfillment_Status__c`  string , `Shipping_Provider__c`  string , `Date_start_software__c`  string , `Auto_Reminder_Email_Sent__c`  string , `Interested_in_Data_Archive__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 , `Software_forwardfacility__c`  string , `Tax_rate_on_rent__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 , `Use_Gate_Software_Provider__c`  string , `Use_Sparefoot_facility__c`  string , `WebsiteProvider_Facility__c`  string , `Your_SL_CorpCode__c`  string , `Purchase_Order_ACH__c`  string , `SE_Facility_UUID__c`  string , `Refund_Method__c`  string , `PDK_RMA__c`  string , `EmailSubjectAddition__c`  string , `Synched_to_Netsuite__c`  string , `PDK_RMA_Complete__c`  string , `PDK_RMA_Email_Sent__c`  string , `Upsell_or_Transfer__c`  string , `Originating_Opportunity_Product__c`  string , `Revised_Quantity__c`  string , `Validation_Rule_Toggle__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_CSAT_Comment__c`  string , `Implementation_Product_Score__c`  string , `Exemption_Notes__c`  string , `Exempting_Manager__c`  string , `CSAT_Close_Email_Exempt__c`  string , `Auto_Reminder_Email_Sent_Date__c`  string , `Start_Case_Auto_Close_Process_Date__c`  string , `Other_Software_Cancellation_Details__c`  string , `Other_Website_Cancellation_Details__c`  string , `Other_Marketplace_Cancellation_Details__c`  string , `Other_Access_Cancellation_Details__c`  string , `Other_Payments_Cancellation_Details__c`  string , `AC_Hardware_Installment_Loan__c`  string , `AC_Hardware_Installment_Months__c`  string , `Implementation_Support_Score__c`  string , `Order_Product__c`  string , `Send_Secure_Emails__c`  string , `RocketLane_Product_List__c`  string , `RocketLane_Project_Notes__c`  string , `RocketLane_Project_URL__c`  string , `Original_Launch_Date__c`  string , `Launch_Time__c`  string , `Require_T1_Support__c`  string , `MRR_Total__c`  string , `Net_MRR_Total__c`  string , `Originating_CSF_Case__c`  string , `Reply_To_Email__c`  string , `CallPotential_Products_to_Cancel__c`  string , `Other_CallPotential_Cancellation_Details__c`  string , `Reason_Cancel_CallPotential__c`  string , `CP_Company_ID__c`  string , `CP_Location_ID__c`  string , `FMS_Status__c`  string , `Ultimate_Parent_Account_Name__c`  string , `Interested_in_Data_Decryption__c`  string , `CSR_Churn_Risk__c`  string , `Received_At__c`  string , `Statement_ID__c`  string , `Messaging_Session__c`  string , `RocketLane_Payments_URL__c`  string , `CallPotential_going_forward_at_facility__c`  string , `CallPotential_interest_at_facility__c`  string , `Interest_in_CallPotential__c`  string , `Facility_Phone_Number__c`  string , `PPS_Cleanup_Tool__c`  string , `PDK_RMA_Backbill_Complete__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/cases/2024-06-10/1718051798'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_cases`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_cases"
        }
    },
    "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