Schema Info

Schema Name: sfdl_prod_salesforce.sitelink_opportunity

created: 2018-10-26 14:39:50
disabled: False
format: raw
id: 562
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_salesforce",
    "table": "sitelink_opportunity"
}

type: salesforce

Schema Versions: 1

Version 50077

created: 2018-10-26 14:39:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_salesforce`",
    "DROP TABLE IF EXISTS `sfdl_prod_salesforce.sitelink_opportunity`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_salesforce.sitelink_opportunity`\n(\n `SC_Last_Name__c`  string , `Routing__c`  string , `Billing_Contact_Phone__c`  string , `Credit_Card_Number__c`  string , `CampaignId`  string , `Temporary_Owner__c`  string , `SiteLinkCorporateCode_SF__c`  string , `We_Bundle_System_Sell__c`  decimal(16,2) , `Payment_Amount__c`  decimal(16,2) , `Record_Type_Name__c`  string , `Amount`  decimal(16,2) , `SC_Email__c`  string , `How_did_you_hear_about_us__c`  string , `SA_Line_Total_Discount__c`  decimal(16,2) , `WE_Bundle_Billing_Cycle_List__c`  decimal(16,2) , `Promotion__c`  string , `WE_Line_Subtotal_List__c`  decimal(16,2) , `Reason_for_contacting_u__c`  string , `TC_Phone__c`  string , `Account_Unit_Rent_Tax_Rate__c`  double , `Reason_Lost__c`  string , `Owner_Match__c`  boolean , `LastModifiedById`  string , `Pmt_Date__c`  date , `OwnerId`  string , `Merchant_Services_Date_Closed__c`  date , `WE_GBP_Subscription_Txt__c`  string , `BypassVR__c`  boolean , `Cancellation_Fee_Amount__c`  double , `UniqueOpptycount__c`  double , `Support_Total__c`  decimal(16,2) , `SA_Other_ShipTo_Country__c`  string , `Taxable_Total_Bundle__c`  decimal(16,2) , `SystemModstamp`  timestamp , `Expiration_Date__c`  date , `WonAmount__c`  decimal(16,2) , `Tax_Amount_MS__c`  decimal(16,2) , `MS_Total_Amount__c`  decimal(16,2) , `WE_GBP_Setup_Conversion_Text__c`  string , `Previous_CC_Provider__c`  string , `Tax_State_SA__c`  decimal(16,2) , `WE_Line_Subtotal_Sell__c`  decimal(16,2) , `LastModifiedDate`  timestamp , `ForecastCategoryName`  string , `MS_Line_Total_Sell__c`  decimal(16,2) , `WE_ZAR_Setup_Conversion_Text__c`  string , `WE_Discount_Txt__c`  string , `WE_Bundle_Setup_Conversion_List__c`  decimal(16,2) , `WE_Billing_Cycle__c`  string , `Billing_Contact_Email__c`  string , `Legacy_Owner__c`  string , `Lead_Development_Rep__c`  string , `Days_to_Expiration__c`  double , `WE_Subscription_Txt__c`  string , `SA_Other_ShipTo_Zip__c`  string , `WE_Monthly_Discount_Txt__c`  string , `Account_Insurance_Tax__c`  double , `NextStep`  string , `WE_Setup_Conversion_Calc__c`  decimal(16,2) , `SA_System_Text__c`  string , `Merchant_Services_Closed_Lost_Reason__c`  string , `Pmt_Txt__c`  string , `WE_Billing_Cycle_Calc__c`  double , `Account_Owner_Id__c`  string , `SC_Phone__c`  string , `Credit_Card_State__c`  string , `Tax_Local_TS__c`  decimal(16,2) , `CreatedById`  string , `Payment_Type_SF__c`  string , `Meet_or_Beat__c`  string , `SA_Other_ShipTo_State__c`  string , `Account_Current_Gate_System__c`  string , `Account_Number__c`  string , `IGD__Collection_Id__c`  string , `Best_day_time__c`  string , `SA_Line_Total_Sell__c`  decimal(16,2) , `Has_Discount__c`  boolean , `WE_Bundle_Setup_Conversion_Calc__c`  decimal(16,2) , `Expected_Profit_CC__c`  decimal(16,2) , `HasOpportunityLineItem`  boolean , `Users_created_SF__c`  string , `WE_Bundle_System_Discount__c`  decimal(16,2) , `Tax_Amount_Bundle__c`  decimal(16,2) , `Billing_State__c`  string , `Tax_State_MS__c`  decimal(16,2) , `WE_Bundle_Setup_Conversion_Sell__c`  decimal(16,2) , `WE_Quote__c`  string , `WE_EUR_Subscription_Discount_Txt__c`  string , `CurrencyIsoCode`  string , `We_Bundle_System_List__c`  decimal(16,2) , `IsDeleted`  boolean , `Quote__c`  string , `ExistingSpareFootcustomer__c`  boolean , `PushCount__c`  double , `Account_Merchandise_Tax__c`  double , `eSign_Closed_Lost_Reason__c`  string , `LastViewedDate`  timestamp , `SA_Payment_Type__c`  string , `SA_Notes_TF__c`  boolean , `Implementation_Type_SF__c`  string , `Support_Term_Calc__c`  double , `Account_Units_Rented__c`  double , `Account_Owner__c`  string , `MS_Quote__c`  string , `Merchant_Services_Date_Opened__c`  date , `TC_Last_Name__c`  string , `Support_Start__c`  date , `Merchant_Services_Status__c`  string , `Tax_Pct_Local__c`  string , `WE_Bundle_Setup_Conversion_Discount__c`  decimal(16,2) , `CC_Last_4__c`  string , `eSign_Status__c`  string , `Type`  string , `Unit_Rent_Tax_Rate__c`  double , `WE_Line_Total_List__c`  decimal(16,2) , `MS_Product_Type_Icon__c`  string , `Billing_Contact_Last_Name__c`  string , `WE_Bundle_Billing_Cycle_Sell__c`  decimal(16,2) , `Estimated_Savings_Field__c`  decimal(16,2) , `Opportunity_Notes_SF__c`  string , `Ready_To_Go__c`  string , `Opportunity_Amount_Calc__c`  decimal(16,2) , `Account_Tenant_Insurance_Co__c`  string , `AllWalkthroughsscheduled__c`  string , `WE_First_Year_Discount__c`  decimal(16,2) , `Contact_Email__c`  string , `SA_Quote__c`  string , `TC2_Phone__c`  string , `Total_Amount__c`  decimal(16,2) , `TC2_Email__c`  string , `WE_First_Year_List_Amount__c`  decimal(16,2) , `Support_Text__c`  string , `Taxable_Lines_SA__c`  decimal(16,2) , `MS_Total_Sell_Amount__c`  decimal(16,2) , `SA_Line_Total_List__c`  decimal(16,2) , `Please_provide_more_info__c`  string , `ContactPhone_SF__c`  string , `Support_List_Calc__c`  decimal(16,2) , `Credit_Card_Street__c`  string , `Support_Total_Discount__c`  decimal(16,2) , `Owner_Division__c`  string , `MS_Discount_Txt__c`  string , `WE_Notes__c`  string , `Docusign_Template_Id__c`  string , `Credit_Card_City__c`  string , `SF_Account_ID__c`  string , `We_Bundle_System_List_Calc__c`  decimal(16,2) , `WE_Total_List__c`  decimal(16,2) , `WE_Line_Total_Sell__c`  decimal(16,2) , `WE_System_List__c`  decimal(16,2) , `WE_System_Billing_Cycle_Net__c`  decimal(16,2) , `Authorization__c`  string , `New_Customer__c`  boolean , `SA_Total_List__c`  decimal(16,2) , `Channel__c`  string , `Name`  string , `WE_Notes_TF__c`  boolean , `SA_Other_ShipTo_Phone__c`  string , `LeadSource`  string , `IsPrivate`  boolean , `Total_Discount__c`  decimal(16,2) , `WE_GBP_Discount_Txt__c`  string , `First_Quote_Date__c`  date , `Account_Name_Text__c`  string , `WE_Setup_Conversion_List__c`  decimal(16,2) , `WE_Bundle_Line_Subtotal_Sell__c`  decimal(16,2) , `GPM_CC_Won_Ratio__c`  string , `SA_System_Sell__c`  decimal(16,2) , `WE_System_Discount__c`  decimal(16,2) , `Has_Taxes__c`  boolean , `Fiscal`  string , `Check__c`  string , `Support_Discount_Text__c`  string , `CC_Expiration__c`  string , `SA_System_Discount__c`  decimal(16,2) , `Suffix__c`  string , `Credit_Card_Country__c`  string , `TC_Email__c`  string , `WE_ZAR_Subscription_Txt__c`  string , `WE_Bundle_Total_List__c`  decimal(16,2) , `MS_Discount__c`  decimal(16,2) , `Total_of_Walkthroughs__c`  double , `SA_Total_Discount__c`  decimal(16,2) , `WE_Bundle_Total_Discount__c`  decimal(16,2) , `Tax_Amount_SA__c`  decimal(16,2) , `FiscalYear`  int , `Account_Current_Software__c`  string , `WE_Setup_Conversion_Sell__c`  decimal(16,2) , `Payment_Received_Associated__c`  boolean , `WE_Total_Amount__c`  decimal(16,2) , `User_access_setup_SF__c`  string , `WE_Line_Total_Discount__c`  decimal(16,2) , `CC_Name__c`  string , `Tax_State_TS__c`  decimal(16,2) , `Opportunity_Name_Calc__c`  string , `FiscalQuarter`  int , `WE_GBP_Subscription_Discount_Txt__c`  string , `SpareFoot_Status__c`  string , `WE_Bundle_Total_Amount__c`  decimal(16,2) , `Reason_for_leaving_previous_MS__c`  string , `WE_Bundle_Total_Sell__c`  decimal(16,2) , `MS_Installed_Date__c`  date , `Opportunity_MID__c`  string , `Probability`  string , `TS_Quote__c`  string , `Support_List__c`  decimal(16,2) , `Billing_Type__c`  string , `Tax_Local_MS__c`  decimal(16,2) , `WE_System_Sell__c`  decimal(16,2) , `attributes`  string , `Account_Billing_Type__c`  string , `Taxable_Lines_WE__c`  decimal(16,2) , `Taxable_Total_WE__c`  decimal(16,2) , `Account_Number_of_Units__c`  double , `WB_Quote__c`  string , `WE_Bundle_Setup_Conversion_Text__c`  string , `SyncedQuoteId`  string , `SA_Total_Amount__c`  decimal(16,2) , `Total_List__c`  decimal(16,2) , `Data_Wire__c`  string , `PrePayment__c`  decimal(16,2) , `ConnectionSentId`  string , `Merchant_ID__c`  string , `Winning_Competitor__c`  string , `All_Facilities_and_EmailPhoneIncluded_SF__c`  string , `Current_Software__c`  string , `SLMS_Approved__c`  string , `Billing_Contact_First_Name__c`  string , `RecordTypeId`  string , `Merchant_ID_Number__c`  string , `WE_First_Year_Sell_Amount__c`  decimal(16,2) , `WE_Total_Discount__c`  decimal(16,2) , `WE_System_Billing_Cycle_Sell__c`  decimal(16,2) , `WE_System_Billing_Cycle_List__c`  decimal(16,2) , `PrePayment_Discount__c`  decimal(16,2) , `MS_Cancellation_Fee__c`  string , `Account_Website_SF__c`  string , `Merchant_ID_Match__c`  boolean , `Created_By_Dept__c`  string , `SA_Other_ShipTo_Street__c`  string , `WE_System__c`  string , `Current_User_Email__c`  string , `SA_System_List__c`  decimal(16,2) , `Prior_System_Credit_Txt__c`  string , `WE_Bundle_Billing_Cycle_Calc__c`  double , `SA_Other_ShipTo_City__c`  string , `Schedule_Call_SF__c`  string , `Tax_Amount_TS__c`  decimal(16,2) , `Support_Discount__c`  decimal(16,2) , `SA_System_Amount_Calc__c`  decimal(16,2) , `Parent_Name__c`  string , `MS_Total_Volume__c`  decimal(16,2) , `Tax_Local_Bundle__c`  decimal(16,2) , `ConnectionReceivedId`  string , `Description`  string , `Total_of_Facilities_to_be_Implemented_SF__c`  double , `Taxable_Total_SA__c`  decimal(16,2) , `LastActivityDate`  date , `Created_By_Is_Me__c`  boolean , `AddingunitsornewDB__c`  boolean , `Id`  string , `Tax_Local_SA__c`  decimal(16,2) , `Tax_State_WE__c`  decimal(16,2) , `We_Bundle_System__c`  string , `Tax_Pct_State__c`  string , `Created_by_Division__c`  string , `StageName`  string , `WE_Bundle_Line_Subtotal_List__c`  decimal(16,2) , `Rich_Text__c`  string , `AddOn__c`  string , `Tenant_Insurance__c`  string , `AccountId`  string , `IsWon`  boolean , `SA_ShipTo__c`  string , `All_Facilities_and_Addresses_Included_SF__c`  string , `LastReferencedDate`  timestamp , `TC2_First_Name__c`  string , `Merchant_Services_Provider__c`  string , `TC2_Last_Name__c`  string , `Quote_Template_Id__c`  string , `ForecastCategory`  string , `Taxable_Lines_MS__c`  decimal(16,2) , `Comments__c`  string , `Total_Unit_Count__c`  double , `Contact__c`  string , `Site_City_c__c`  string , `WE_Discount_Total__c`  decimal(16,2) , `CloseDate`  date , `PrePayment_CB__c`  boolean , `SA_Other_ShipTo_Name__c`  string , `WE_ZAR_Discount_Txt__c`  string , `Current_Gate_System__c`  string , `WE_Bundle_Billing_Cycle__c`  string , `Units_Rented__c`  double , `Support_Term__c`  string , `WE_First_Year_Discount_Pct__c`  string , `WE_Discount_Qty__c`  double , `Bid_Rate_SF__c`  double , `WE_Setup_Conversion_Text__c`  string , `Date_First_Worked__c`  date , `Expected_Profit_ACH__c`  decimal(16,2) , `Tax_Local_WE__c`  decimal(16,2) , `Software_Interest__c`  string , `Support_End__c`  date , `CreatedDate`  timestamp , `WE_Discount__c`  decimal(16,2) , `Tax_Amount_WE__c`  decimal(16,2) , `SA_Notes__c`  string , `WE_Setup_Conversion_Discount__c`  decimal(16,2) , `SA_System__c`  string , `TC_First_Name__c`  string , `Contact_First_Name__c`  string , `Support_Sell__c`  decimal(16,2) , `Check_Number__c`  string , `Credit_Card__c`  string , `Credentials_Enabled__c`  boolean , `Pricebook2Id`  string , `MS_Product_Type__c`  string , `SiteLink_Store__c`  string , `Tentative_Conversion_Date__c`  date , `MS_Line_Total_List__c`  decimal(16,2) , `WE_Bundle_Subscription_Txt__c`  string , `Account_Owner_Match__c`  boolean , `Site_Fax__c`  string , `SetupNotes_SF__c`  string , `shipping_MS__c`  decimal(16,2) , `Merchandise_Tax__c`  double , `Account_Type_SF__c`  string , `Checking_Account__c`  string , `TotalOpportunityQuantity`  double , `SC_First_Name__c`  string , `IsClosed`  boolean , `SF_Opportunity_ID__c`  string , `WE_System_Amount_Calc__c`  decimal(16,2) , `Prior_System_Credit__c`  decimal(16,2) , `SpareFoot_Closed_Lost_Reason__c`  string , `WE_EUR_Discount_Txt__c`  string , `Payment_Method__c`  string , `WE_ZAR_Subscription_Discount_Txt__c`  string , `GPM_CC_Won__c`  decimal(16,2) , `Credit_Card_Zip__c`  string , `Reference_Opportunity__c`  string , `Tax_State_Bundle__c`  decimal(16,2) , `SA_Total_Sell__c`  decimal(16,2) , `WE_EUR_Subscription_Txt__c`  string , `WE_Subscription_Discount_Txt__c`  string , `New_Opportunity_Amount_Calc__c`  decimal(16,2) , `WE_Total_Net__c`  decimal(16,2) , `WE_Bundle_Notes__c`  string , `MS_Notes__c`  string , `WE_EUR_Setup_Conversion_Text__c`  string , `Tenant_Insurance_Co__c`  string , `Insurance_Tax__c`  double , `Expected_Profit_Total__c`  decimal(16,2) , `ExpectedRevenue`  decimal(16,2) \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '\u0001')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-salesforce-sitelink-prod/raw/Opportunity/2018-10-26/1540582787'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_salesforce.sitelink_opportunity"
]

hive_path: s3://sfdl-salesforce-sitelink-prod/raw/Opportunity/2018-10-26/1540582787
id: 50077
processed: 1

raw_data:

{
    "AccountId": 271,
    "Account_Billing_Type__c": 210,
    "Account_Current_Gate_System__c": 71,
    "Account_Current_Software__c": 186,
    "Account_Insurance_Tax__c": 56,
    "Account_Merchandise_Tax__c": 94,
    "Account_Name_Text__c": 163,
    "Account_Number__c": 72,
    "Account_Number_of_Units__c": 213,
    "Account_Owner_Id__c": 63,
    "Account_Owner_Match__c": 322,
    "Account_Owner__c": 102,
    "Account_Tenant_Insurance_Co__c": 122,
    "Account_Type_SF__c": 327,
    "Account_Unit_Rent_Tax_Rate__c": 19,
    "Account_Units_Rented__c": 101,
    "Account_Website_SF__c": 236,
    "AddOn__c": 269,
    "AddingunitsornewDB__c": 259,
    "AllWalkthroughsscheduled__c": 123,
    "All_Facilities_and_Addresses_Included_SF__c": 274,
    "All_Facilities_and_EmailPhoneIncluded_SF__c": 224,
    "Amount": 10,
    "Authorization__c": 151,
    "Best_day_time__c": 74,
    "Bid_Rate_SF__c": 297,
    "Billing_Contact_Email__c": 49,
    "Billing_Contact_First_Name__c": 227,
    "Billing_Contact_Last_Name__c": 116,
    "Billing_Contact_Phone__c": 2,
    "Billing_State__c": 83,
    "Billing_Type__c": 206,
    "BypassVR__c": 27,
    "CC_Expiration__c": 173,
    "CC_Last_4__c": 110,
    "CC_Name__c": 192,
    "CampaignId": 4,
    "Cancellation_Fee_Amount__c": 28,
    "Channel__c": 154,
    "Check_Number__c": 313,
    "Check__c": 171,
    "Checking_Account__c": 328,
    "CloseDate": 287,
    "Comments__c": 282,
    "ConnectionReceivedId": 253,
    "ConnectionSentId": 221,
    "ContactPhone_SF__c": 136,
    "Contact_Email__c": 125,
    "Contact_First_Name__c": 311,
    "Contact__c": 284,
    "CreatedById": 67,
    "CreatedDate": 304,
    "Created_By_Dept__c": 238,
    "Created_By_Is_Me__c": 258,
    "Created_by_Division__c": 265,
    "Credentials_Enabled__c": 315,
    "Credit_Card_City__c": 144,
    "Credit_Card_Country__c": 176,
    "Credit_Card_Number__c": 3,
    "Credit_Card_State__c": 65,
    "Credit_Card_Street__c": 138,
    "Credit_Card_Zip__c": 340,
    "Credit_Card__c": 314,
    "CurrencyIsoCode": 88,
    "Current_Gate_System__c": 291,
    "Current_Software__c": 225,
    "Current_User_Email__c": 241,
    "Data_Wire__c": 219,
    "Date_First_Worked__c": 299,
    "Days_to_Expiration__c": 52,
    "Description": 254,
    "Docusign_Template_Id__c": 143,
    "Estimated_Savings_Field__c": 118,
    "ExistingSpareFootcustomer__c": 92,
    "ExpectedRevenue": 354,
    "Expected_Profit_ACH__c": 300,
    "Expected_Profit_CC__c": 78,
    "Expected_Profit_Total__c": 353,
    "Expiration_Date__c": 34,
    "First_Quote_Date__c": 162,
    "Fiscal": 170,
    "FiscalQuarter": 195,
    "FiscalYear": 185,
    "ForecastCategory": 280,
    "ForecastCategoryName": 43,
    "GPM_CC_Won_Ratio__c": 166,
    "GPM_CC_Won__c": 339,
    "HasOpportunityLineItem": 79,
    "Has_Discount__c": 76,
    "Has_Taxes__c": 169,
    "How_did_you_hear_about_us__c": 12,
    "IGD__Collection_Id__c": 73,
    "Id": 260,
    "Implementation_Type_SF__c": 99,
    "Insurance_Tax__c": 352,
    "IsClosed": 331,
    "IsDeleted": 90,
    "IsPrivate": 159,
    "IsWon": 272,
    "LastActivityDate": 257,
    "LastModifiedById": 22,
    "LastModifiedDate": 42,
    "LastReferencedDate": 275,
    "LastViewedDate": 96,
    "LeadSource": 158,
    "Lead_Development_Rep__c": 51,
    "Legacy_Owner__c": 50,
    "MS_Cancellation_Fee__c": 235,
    "MS_Discount_Txt__c": 141,
    "MS_Discount__c": 180,
    "MS_Installed_Date__c": 201,
    "MS_Line_Total_List__c": 320,
    "MS_Line_Total_Sell__c": 44,
    "MS_Notes__c": 349,
    "MS_Product_Type_Icon__c": 115,
    "MS_Product_Type__c": 317,
    "MS_Quote__c": 103,
    "MS_Total_Amount__c": 37,
    "MS_Total_Sell_Amount__c": 133,
    "MS_Total_Volume__c": 251,
    "Meet_or_Beat__c": 69,
    "Merchandise_Tax__c": 326,
    "Merchant_ID_Match__c": 237,
    "Merchant_ID_Number__c": 229,
    "Merchant_ID__c": 222,
    "Merchant_Services_Closed_Lost_Reason__c": 60,
    "Merchant_Services_Date_Closed__c": 25,
    "Merchant_Services_Date_Opened__c": 104,
    "Merchant_Services_Provider__c": 277,
    "Merchant_Services_Status__c": 107,
    "Name": 155,
    "New_Customer__c": 152,
    "New_Opportunity_Amount_Calc__c": 346,
    "NextStep": 57,
    "Opportunity_Amount_Calc__c": 121,
    "Opportunity_MID__c": 202,
    "Opportunity_Name_Calc__c": 194,
    "Opportunity_Notes_SF__c": 119,
    "OwnerId": 24,
    "Owner_Division__c": 140,
    "Owner_Match__c": 21,
    "Parent_Name__c": 250,
    "Payment_Amount__c": 8,
    "Payment_Method__c": 337,
    "Payment_Received_Associated__c": 188,
    "Payment_Type_SF__c": 68,
    "Please_provide_more_info__c": 135,
    "Pmt_Date__c": 23,
    "Pmt_Txt__c": 61,
    "PrePayment_CB__c": 288,
    "PrePayment_Discount__c": 234,
    "PrePayment__c": 220,
    "Previous_CC_Provider__c": 39,
    "Pricebook2Id": 316,
    "Prior_System_Credit_Txt__c": 243,
    "Prior_System_Credit__c": 334,
    "Probability": 203,
    "Promotion__c": 15,
    "PushCount__c": 93,
    "Quote_Template_Id__c": 279,
    "Quote__c": 91,
    "Ready_To_Go__c": 120,
    "Reason_Lost__c": 20,
    "Reason_for_contacting_u__c": 17,
    "Reason_for_leaving_previous_MS__c": 199,
    "RecordTypeId": 228,
    "Record_Type_Name__c": 9,
    "Reference_Opportunity__c": 341,
    "Rich_Text__c": 268,
    "Routing__c": 1,
    "SA_Line_Total_Discount__c": 13,
    "SA_Line_Total_List__c": 134,
    "SA_Line_Total_Sell__c": 75,
    "SA_Notes_TF__c": 98,
    "SA_Notes__c": 307,
    "SA_Other_ShipTo_City__c": 245,
    "SA_Other_ShipTo_Country__c": 31,
    "SA_Other_ShipTo_Name__c": 289,
    "SA_Other_ShipTo_Phone__c": 157,
    "SA_Other_ShipTo_State__c": 70,
    "SA_Other_ShipTo_Street__c": 239,
    "SA_Other_ShipTo_Zip__c": 54,
    "SA_Payment_Type__c": 97,
    "SA_Quote__c": 126,
    "SA_ShipTo__c": 273,
    "SA_System_Amount_Calc__c": 249,
    "SA_System_Discount__c": 174,
    "SA_System_List__c": 242,
    "SA_System_Sell__c": 167,
    "SA_System_Text__c": 59,
    "SA_System__c": 309,
    "SA_Total_Amount__c": 217,
    "SA_Total_Discount__c": 182,
    "SA_Total_List__c": 153,
    "SA_Total_Sell__c": 343,
    "SC_Email__c": 11,
    "SC_First_Name__c": 330,
    "SC_Last_Name__c": 0,
    "SC_Phone__c": 64,
    "SF_Account_ID__c": 145,
    "SF_Opportunity_ID__c": 332,
    "SLMS_Approved__c": 226,
    "Schedule_Call_SF__c": 246,
    "SetupNotes_SF__c": 324,
    "SiteLinkCorporateCode_SF__c": 6,
    "SiteLink_Store__c": 318,
    "Site_City_c__c": 285,
    "Site_Fax__c": 323,
    "Software_Interest__c": 302,
    "SpareFoot_Closed_Lost_Reason__c": 335,
    "SpareFoot_Status__c": 197,
    "StageName": 266,
    "Suffix__c": 175,
    "Support_Discount_Text__c": 172,
    "Support_Discount__c": 248,
    "Support_End__c": 303,
    "Support_List_Calc__c": 137,
    "Support_List__c": 205,
    "Support_Sell__c": 312,
    "Support_Start__c": 106,
    "Support_Term_Calc__c": 100,
    "Support_Term__c": 294,
    "Support_Text__c": 131,
    "Support_Total_Discount__c": 139,
    "Support_Total__c": 30,
    "SyncedQuoteId": 216,
    "SystemModstamp": 33,
    "TC2_Email__c": 129,
    "TC2_First_Name__c": 276,
    "TC2_Last_Name__c": 278,
    "TC2_Phone__c": 127,
    "TC_Email__c": 177,
    "TC_First_Name__c": 310,
    "TC_Last_Name__c": 105,
    "TC_Phone__c": 18,
    "TS_Quote__c": 204,
    "Tax_Amount_Bundle__c": 82,
    "Tax_Amount_MS__c": 36,
    "Tax_Amount_SA__c": 184,
    "Tax_Amount_TS__c": 247,
    "Tax_Amount_WE__c": 306,
    "Tax_Local_Bundle__c": 252,
    "Tax_Local_MS__c": 207,
    "Tax_Local_SA__c": 261,
    "Tax_Local_TS__c": 66,
    "Tax_Local_WE__c": 301,
    "Tax_Pct_Local__c": 108,
    "Tax_Pct_State__c": 264,
    "Tax_State_Bundle__c": 342,
    "Tax_State_MS__c": 84,
    "Tax_State_SA__c": 40,
    "Tax_State_TS__c": 193,
    "Tax_State_WE__c": 262,
    "Taxable_Lines_MS__c": 281,
    "Taxable_Lines_SA__c": 132,
    "Taxable_Lines_WE__c": 211,
    "Taxable_Total_Bundle__c": 32,
    "Taxable_Total_SA__c": 256,
    "Taxable_Total_WE__c": 212,
    "Temporary_Owner__c": 5,
    "Tenant_Insurance_Co__c": 351,
    "Tenant_Insurance__c": 270,
    "Tentative_Conversion_Date__c": 319,
    "TotalOpportunityQuantity": 329,
    "Total_Amount__c": 128,
    "Total_Discount__c": 160,
    "Total_List__c": 218,
    "Total_Unit_Count__c": 283,
    "Total_of_Facilities_to_be_Implemented_SF__c": 255,
    "Total_of_Walkthroughs__c": 181,
    "Type": 112,
    "UniqueOpptycount__c": 29,
    "Unit_Rent_Tax_Rate__c": 113,
    "Units_Rented__c": 293,
    "User_access_setup_SF__c": 190,
    "Users_created_SF__c": 80,
    "WB_Quote__c": 214,
    "WE_Billing_Cycle_Calc__c": 62,
    "WE_Billing_Cycle__c": 48,
    "WE_Bundle_Billing_Cycle_Calc__c": 244,
    "WE_Bundle_Billing_Cycle_List__c": 14,
    "WE_Bundle_Billing_Cycle_Sell__c": 117,
    "WE_Bundle_Billing_Cycle__c": 292,
    "WE_Bundle_Line_Subtotal_List__c": 267,
    "WE_Bundle_Line_Subtotal_Sell__c": 165,
    "WE_Bundle_Notes__c": 348,
    "WE_Bundle_Setup_Conversion_Calc__c": 77,
    "WE_Bundle_Setup_Conversion_Discount__c": 109,
    "WE_Bundle_Setup_Conversion_List__c": 47,
    "WE_Bundle_Setup_Conversion_Sell__c": 85,
    "WE_Bundle_Setup_Conversion_Text__c": 215,
    "WE_Bundle_Subscription_Txt__c": 321,
    "WE_Bundle_System_Discount__c": 81,
    "WE_Bundle_Total_Amount__c": 198,
    "WE_Bundle_Total_Discount__c": 183,
    "WE_Bundle_Total_List__c": 179,
    "WE_Bundle_Total_Sell__c": 200,
    "WE_Discount_Qty__c": 296,
    "WE_Discount_Total__c": 286,
    "WE_Discount_Txt__c": 46,
    "WE_Discount__c": 305,
    "WE_EUR_Discount_Txt__c": 336,
    "WE_EUR_Setup_Conversion_Text__c": 350,
    "WE_EUR_Subscription_Discount_Txt__c": 87,
    "WE_EUR_Subscription_Txt__c": 344,
    "WE_First_Year_Discount_Pct__c": 295,
    "WE_First_Year_Discount__c": 124,
    "WE_First_Year_List_Amount__c": 130,
    "WE_First_Year_Sell_Amount__c": 230,
    "WE_GBP_Discount_Txt__c": 161,
    "WE_GBP_Setup_Conversion_Text__c": 38,
    "WE_GBP_Subscription_Discount_Txt__c": 196,
    "WE_GBP_Subscription_Txt__c": 26,
    "WE_Line_Subtotal_List__c": 16,
    "WE_Line_Subtotal_Sell__c": 41,
    "WE_Line_Total_Discount__c": 191,
    "WE_Line_Total_List__c": 114,
    "WE_Line_Total_Sell__c": 148,
    "WE_Monthly_Discount_Txt__c": 55,
    "WE_Notes_TF__c": 156,
    "WE_Notes__c": 142,
    "WE_Quote__c": 86,
    "WE_Setup_Conversion_Calc__c": 58,
    "WE_Setup_Conversion_Discount__c": 308,
    "WE_Setup_Conversion_List__c": 164,
    "WE_Setup_Conversion_Sell__c": 187,
    "WE_Setup_Conversion_Text__c": 298,
    "WE_Subscription_Discount_Txt__c": 345,
    "WE_Subscription_Txt__c": 53,
    "WE_System_Amount_Calc__c": 333,
    "WE_System_Billing_Cycle_List__c": 233,
    "WE_System_Billing_Cycle_Net__c": 150,
    "WE_System_Billing_Cycle_Sell__c": 232,
    "WE_System_Discount__c": 168,
    "WE_System_List__c": 149,
    "WE_System_Sell__c": 208,
    "WE_System__c": 240,
    "WE_Total_Amount__c": 189,
    "WE_Total_Discount__c": 231,
    "WE_Total_List__c": 147,
    "WE_Total_Net__c": 347,
    "WE_ZAR_Discount_Txt__c": 290,
    "WE_ZAR_Setup_Conversion_Text__c": 45,
    "WE_ZAR_Subscription_Discount_Txt__c": 338,
    "WE_ZAR_Subscription_Txt__c": 178,
    "We_Bundle_System_List_Calc__c": 146,
    "We_Bundle_System_List__c": 89,
    "We_Bundle_System_Sell__c": 7,
    "We_Bundle_System__c": 263,
    "Winning_Competitor__c": 223,
    "WonAmount__c": 35,
    "attributes": 209,
    "eSign_Closed_Lost_Reason__c": 95,
    "eSign_Status__c": 111,
    "shipping_MS__c": 325
}

schema_attributes:

{
    "AccountId": "string",
    "Account_Billing_Type__c": "string",
    "Account_Current_Gate_System__c": "string",
    "Account_Current_Software__c": "string",
    "Account_Insurance_Tax__c": "double",
    "Account_Merchandise_Tax__c": "double",
    "Account_Name_Text__c": "string",
    "Account_Number__c": "string",
    "Account_Number_of_Units__c": "double",
    "Account_Owner_Id__c": "string",
    "Account_Owner_Match__c": "boolean",
    "Account_Owner__c": "string",
    "Account_Tenant_Insurance_Co__c": "string",
    "Account_Type_SF__c": "string",
    "Account_Unit_Rent_Tax_Rate__c": "double",
    "Account_Units_Rented__c": "double",
    "Account_Website_SF__c": "string",
    "AddOn__c": "string",
    "AddingunitsornewDB__c": "boolean",
    "AllWalkthroughsscheduled__c": "string",
    "All_Facilities_and_Addresses_Included_SF__c": "string",
    "All_Facilities_and_EmailPhoneIncluded_SF__c": "string",
    "Amount": "decimal(16,2)",
    "Authorization__c": "string",
    "Best_day_time__c": "string",
    "Bid_Rate_SF__c": "double",
    "Billing_Contact_Email__c": "string",
    "Billing_Contact_First_Name__c": "string",
    "Billing_Contact_Last_Name__c": "string",
    "Billing_Contact_Phone__c": "string",
    "Billing_State__c": "string",
    "Billing_Type__c": "string",
    "BypassVR__c": "boolean",
    "CC_Expiration__c": "string",
    "CC_Last_4__c": "string",
    "CC_Name__c": "string",
    "CampaignId": "string",
    "Cancellation_Fee_Amount__c": "double",
    "Channel__c": "string",
    "Check_Number__c": "string",
    "Check__c": "string",
    "Checking_Account__c": "string",
    "CloseDate": "date",
    "Comments__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactPhone_SF__c": "string",
    "Contact_Email__c": "string",
    "Contact_First_Name__c": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "timestamp",
    "Created_By_Dept__c": "string",
    "Created_By_Is_Me__c": "boolean",
    "Created_by_Division__c": "string",
    "Credentials_Enabled__c": "boolean",
    "Credit_Card_City__c": "string",
    "Credit_Card_Country__c": "string",
    "Credit_Card_Number__c": "string",
    "Credit_Card_State__c": "string",
    "Credit_Card_Street__c": "string",
    "Credit_Card_Zip__c": "string",
    "Credit_Card__c": "string",
    "CurrencyIsoCode": "string",
    "Current_Gate_System__c": "string",
    "Current_Software__c": "string",
    "Current_User_Email__c": "string",
    "Data_Wire__c": "string",
    "Date_First_Worked__c": "date",
    "Days_to_Expiration__c": "double",
    "Description": "string",
    "Docusign_Template_Id__c": "string",
    "Estimated_Savings_Field__c": "decimal(16,2)",
    "ExistingSpareFootcustomer__c": "boolean",
    "ExpectedRevenue": "decimal(16,2)",
    "Expected_Profit_ACH__c": "decimal(16,2)",
    "Expected_Profit_CC__c": "decimal(16,2)",
    "Expected_Profit_Total__c": "decimal(16,2)",
    "Expiration_Date__c": "date",
    "First_Quote_Date__c": "date",
    "Fiscal": "string",
    "FiscalQuarter": "int",
    "FiscalYear": "int",
    "ForecastCategory": "string",
    "ForecastCategoryName": "string",
    "GPM_CC_Won_Ratio__c": "string",
    "GPM_CC_Won__c": "decimal(16,2)",
    "HasOpportunityLineItem": "boolean",
    "Has_Discount__c": "boolean",
    "Has_Taxes__c": "boolean",
    "How_did_you_hear_about_us__c": "string",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "Implementation_Type_SF__c": "string",
    "Insurance_Tax__c": "double",
    "IsClosed": "boolean",
    "IsDeleted": "boolean",
    "IsPrivate": "boolean",
    "IsWon": "boolean",
    "LastActivityDate": "date",
    "LastModifiedById": "string",
    "LastModifiedDate": "timestamp",
    "LastReferencedDate": "timestamp",
    "LastViewedDate": "timestamp",
    "LeadSource": "string",
    "Lead_Development_Rep__c": "string",
    "Legacy_Owner__c": "string",
    "MS_Cancellation_Fee__c": "string",
    "MS_Discount_Txt__c": "string",
    "MS_Discount__c": "decimal(16,2)",
    "MS_Installed_Date__c": "date",
    "MS_Line_Total_List__c": "decimal(16,2)",
    "MS_Line_Total_Sell__c": "decimal(16,2)",
    "MS_Notes__c": "string",
    "MS_Product_Type_Icon__c": "string",
    "MS_Product_Type__c": "string",
    "MS_Quote__c": "string",
    "MS_Total_Amount__c": "decimal(16,2)",
    "MS_Total_Sell_Amount__c": "decimal(16,2)",
    "MS_Total_Volume__c": "decimal(16,2)",
    "Meet_or_Beat__c": "string",
    "Merchandise_Tax__c": "double",
    "Merchant_ID_Match__c": "boolean",
    "Merchant_ID_Number__c": "string",
    "Merchant_ID__c": "string",
    "Merchant_Services_Closed_Lost_Reason__c": "string",
    "Merchant_Services_Date_Closed__c": "date",
    "Merchant_Services_Date_Opened__c": "date",
    "Merchant_Services_Provider__c": "string",
    "Merchant_Services_Status__c": "string",
    "Name": "string",
    "New_Customer__c": "boolean",
    "New_Opportunity_Amount_Calc__c": "decimal(16,2)",
    "NextStep": "string",
    "Opportunity_Amount_Calc__c": "decimal(16,2)",
    "Opportunity_MID__c": "string",
    "Opportunity_Name_Calc__c": "string",
    "Opportunity_Notes_SF__c": "string",
    "OwnerId": "string",
    "Owner_Division__c": "string",
    "Owner_Match__c": "boolean",
    "Parent_Name__c": "string",
    "Payment_Amount__c": "decimal(16,2)",
    "Payment_Method__c": "string",
    "Payment_Received_Associated__c": "boolean",
    "Payment_Type_SF__c": "string",
    "Please_provide_more_info__c": "string",
    "Pmt_Date__c": "date",
    "Pmt_Txt__c": "string",
    "PrePayment_CB__c": "boolean",
    "PrePayment_Discount__c": "decimal(16,2)",
    "PrePayment__c": "decimal(16,2)",
    "Previous_CC_Provider__c": "string",
    "Pricebook2Id": "string",
    "Prior_System_Credit_Txt__c": "string",
    "Prior_System_Credit__c": "decimal(16,2)",
    "Probability": "string",
    "Promotion__c": "string",
    "PushCount__c": "double",
    "Quote_Template_Id__c": "string",
    "Quote__c": "string",
    "Ready_To_Go__c": "string",
    "Reason_Lost__c": "string",
    "Reason_for_contacting_u__c": "string",
    "Reason_for_leaving_previous_MS__c": "string",
    "RecordTypeId": "string",
    "Record_Type_Name__c": "string",
    "Reference_Opportunity__c": "string",
    "Rich_Text__c": "string",
    "Routing__c": "string",
    "SA_Line_Total_Discount__c": "decimal(16,2)",
    "SA_Line_Total_List__c": "decimal(16,2)",
    "SA_Line_Total_Sell__c": "decimal(16,2)",
    "SA_Notes_TF__c": "boolean",
    "SA_Notes__c": "string",
    "SA_Other_ShipTo_City__c": "string",
    "SA_Other_ShipTo_Country__c": "string",
    "SA_Other_ShipTo_Name__c": "string",
    "SA_Other_ShipTo_Phone__c": "string",
    "SA_Other_ShipTo_State__c": "string",
    "SA_Other_ShipTo_Street__c": "string",
    "SA_Other_ShipTo_Zip__c": "string",
    "SA_Payment_Type__c": "string",
    "SA_Quote__c": "string",
    "SA_ShipTo__c": "string",
    "SA_System_Amount_Calc__c": "decimal(16,2)",
    "SA_System_Discount__c": "decimal(16,2)",
    "SA_System_List__c": "decimal(16,2)",
    "SA_System_Sell__c": "decimal(16,2)",
    "SA_System_Text__c": "string",
    "SA_System__c": "string",
    "SA_Total_Amount__c": "decimal(16,2)",
    "SA_Total_Discount__c": "decimal(16,2)",
    "SA_Total_List__c": "decimal(16,2)",
    "SA_Total_Sell__c": "decimal(16,2)",
    "SC_Email__c": "string",
    "SC_First_Name__c": "string",
    "SC_Last_Name__c": "string",
    "SC_Phone__c": "string",
    "SF_Account_ID__c": "string",
    "SF_Opportunity_ID__c": "string",
    "SLMS_Approved__c": "string",
    "Schedule_Call_SF__c": "string",
    "SetupNotes_SF__c": "string",
    "SiteLinkCorporateCode_SF__c": "string",
    "SiteLink_Store__c": "string",
    "Site_City_c__c": "string",
    "Site_Fax__c": "string",
    "Software_Interest__c": "string",
    "SpareFoot_Closed_Lost_Reason__c": "string",
    "SpareFoot_Status__c": "string",
    "StageName": "string",
    "Suffix__c": "string",
    "Support_Discount_Text__c": "string",
    "Support_Discount__c": "decimal(16,2)",
    "Support_End__c": "date",
    "Support_List_Calc__c": "decimal(16,2)",
    "Support_List__c": "decimal(16,2)",
    "Support_Sell__c": "decimal(16,2)",
    "Support_Start__c": "date",
    "Support_Term_Calc__c": "double",
    "Support_Term__c": "string",
    "Support_Text__c": "string",
    "Support_Total_Discount__c": "decimal(16,2)",
    "Support_Total__c": "decimal(16,2)",
    "SyncedQuoteId": "string",
    "SystemModstamp": "timestamp",
    "TC2_Email__c": "string",
    "TC2_First_Name__c": "string",
    "TC2_Last_Name__c": "string",
    "TC2_Phone__c": "string",
    "TC_Email__c": "string",
    "TC_First_Name__c": "string",
    "TC_Last_Name__c": "string",
    "TC_Phone__c": "string",
    "TS_Quote__c": "string",
    "Tax_Amount_Bundle__c": "decimal(16,2)",
    "Tax_Amount_MS__c": "decimal(16,2)",
    "Tax_Amount_SA__c": "decimal(16,2)",
    "Tax_Amount_TS__c": "decimal(16,2)",
    "Tax_Amount_WE__c": "decimal(16,2)",
    "Tax_Local_Bundle__c": "decimal(16,2)",
    "Tax_Local_MS__c": "decimal(16,2)",
    "Tax_Local_SA__c": "decimal(16,2)",
    "Tax_Local_TS__c": "decimal(16,2)",
    "Tax_Local_WE__c": "decimal(16,2)",
    "Tax_Pct_Local__c": "string",
    "Tax_Pct_State__c": "string",
    "Tax_State_Bundle__c": "decimal(16,2)",
    "Tax_State_MS__c": "decimal(16,2)",
    "Tax_State_SA__c": "decimal(16,2)",
    "Tax_State_TS__c": "decimal(16,2)",
    "Tax_State_WE__c": "decimal(16,2)",
    "Taxable_Lines_MS__c": "decimal(16,2)",
    "Taxable_Lines_SA__c": "decimal(16,2)",
    "Taxable_Lines_WE__c": "decimal(16,2)",
    "Taxable_Total_Bundle__c": "decimal(16,2)",
    "Taxable_Total_SA__c": "decimal(16,2)",
    "Taxable_Total_WE__c": "decimal(16,2)",
    "Temporary_Owner__c": "string",
    "Tenant_Insurance_Co__c": "string",
    "Tenant_Insurance__c": "string",
    "Tentative_Conversion_Date__c": "date",
    "TotalOpportunityQuantity": "double",
    "Total_Amount__c": "decimal(16,2)",
    "Total_Discount__c": "decimal(16,2)",
    "Total_List__c": "decimal(16,2)",
    "Total_Unit_Count__c": "double",
    "Total_of_Facilities_to_be_Implemented_SF__c": "double",
    "Total_of_Walkthroughs__c": "double",
    "Type": "string",
    "UniqueOpptycount__c": "double",
    "Unit_Rent_Tax_Rate__c": "double",
    "Units_Rented__c": "double",
    "User_access_setup_SF__c": "string",
    "Users_created_SF__c": "string",
    "WB_Quote__c": "string",
    "WE_Billing_Cycle_Calc__c": "double",
    "WE_Billing_Cycle__c": "string",
    "WE_Bundle_Billing_Cycle_Calc__c": "double",
    "WE_Bundle_Billing_Cycle_List__c": "decimal(16,2)",
    "WE_Bundle_Billing_Cycle_Sell__c": "decimal(16,2)",
    "WE_Bundle_Billing_Cycle__c": "string",
    "WE_Bundle_Line_Subtotal_List__c": "decimal(16,2)",
    "WE_Bundle_Line_Subtotal_Sell__c": "decimal(16,2)",
    "WE_Bundle_Notes__c": "string",
    "WE_Bundle_Setup_Conversion_Calc__c": "decimal(16,2)",
    "WE_Bundle_Setup_Conversion_Discount__c": "decimal(16,2)",
    "WE_Bundle_Setup_Conversion_List__c": "decimal(16,2)",
    "WE_Bundle_Setup_Conversion_Sell__c": "decimal(16,2)",
    "WE_Bundle_Setup_Conversion_Text__c": "string",
    "WE_Bundle_Subscription_Txt__c": "string",
    "WE_Bundle_System_Discount__c": "decimal(16,2)",
    "WE_Bundle_Total_Amount__c": "decimal(16,2)",
    "WE_Bundle_Total_Discount__c": "decimal(16,2)",
    "WE_Bundle_Total_List__c": "decimal(16,2)",
    "WE_Bundle_Total_Sell__c": "decimal(16,2)",
    "WE_Discount_Qty__c": "double",
    "WE_Discount_Total__c": "decimal(16,2)",
    "WE_Discount_Txt__c": "string",
    "WE_Discount__c": "decimal(16,2)",
    "WE_EUR_Discount_Txt__c": "string",
    "WE_EUR_Setup_Conversion_Text__c": "string",
    "WE_EUR_Subscription_Discount_Txt__c": "string",
    "WE_EUR_Subscription_Txt__c": "string",
    "WE_First_Year_Discount_Pct__c": "string",
    "WE_First_Year_Discount__c": "decimal(16,2)",
    "WE_First_Year_List_Amount__c": "decimal(16,2)",
    "WE_First_Year_Sell_Amount__c": "decimal(16,2)",
    "WE_GBP_Discount_Txt__c": "string",
    "WE_GBP_Setup_Conversion_Text__c": "string",
    "WE_GBP_Subscription_Discount_Txt__c": "string",
    "WE_GBP_Subscription_Txt__c": "string",
    "WE_Line_Subtotal_List__c": "decimal(16,2)",
    "WE_Line_Subtotal_Sell__c": "decimal(16,2)",
    "WE_Line_Total_Discount__c": "decimal(16,2)",
    "WE_Line_Total_List__c": "decimal(16,2)",
    "WE_Line_Total_Sell__c": "decimal(16,2)",
    "WE_Monthly_Discount_Txt__c": "string",
    "WE_Notes_TF__c": "boolean",
    "WE_Notes__c": "string",
    "WE_Quote__c": "string",
    "WE_Setup_Conversion_Calc__c": "decimal(16,2)",
    "WE_Setup_Conversion_Discount__c": "decimal(16,2)",
    "WE_Setup_Conversion_List__c": "decimal(16,2)",
    "WE_Setup_Conversion_Sell__c": "decimal(16,2)",
    "WE_Setup_Conversion_Text__c": "string",
    "WE_Subscription_Discount_Txt__c": "string",
    "WE_Subscription_Txt__c": "string",
    "WE_System_Amount_Calc__c": "decimal(16,2)",
    "WE_System_Billing_Cycle_List__c": "decimal(16,2)",
    "WE_System_Billing_Cycle_Net__c": "decimal(16,2)",
    "WE_System_Billing_Cycle_Sell__c": "decimal(16,2)",
    "WE_System_Discount__c": "decimal(16,2)",
    "WE_System_List__c": "decimal(16,2)",
    "WE_System_Sell__c": "decimal(16,2)",
    "WE_System__c": "string",
    "WE_Total_Amount__c": "decimal(16,2)",
    "WE_Total_Discount__c": "decimal(16,2)",
    "WE_Total_List__c": "decimal(16,2)",
    "WE_Total_Net__c": "decimal(16,2)",
    "WE_ZAR_Discount_Txt__c": "string",
    "WE_ZAR_Setup_Conversion_Text__c": "string",
    "WE_ZAR_Subscription_Discount_Txt__c": "string",
    "WE_ZAR_Subscription_Txt__c": "string",
    "We_Bundle_System_List_Calc__c": "decimal(16,2)",
    "We_Bundle_System_List__c": "decimal(16,2)",
    "We_Bundle_System_Sell__c": "decimal(16,2)",
    "We_Bundle_System__c": "string",
    "Winning_Competitor__c": "string",
    "WonAmount__c": "decimal(16,2)",
    "attributes": "string",
    "eSign_Closed_Lost_Reason__c": "string",
    "eSign_Status__c": "string",
    "shipping_MS__c": "decimal(16,2)"
}

schema_name_id: 562
schema_scan_id: 19539672
updated: 2018-10-26 14:40:01

Schema Scans: 1

Last at 2018-10-26 14:39:50

Scan 19539672

duration: 0:00:13.620530

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}

id: 19539672

payload:

{
    "datatype_dict": {
        "AccountId": "string",
        "Account_Billing_Type__c": "string",
        "Account_Current_Gate_System__c": "string",
        "Account_Current_Software__c": "string",
        "Account_Insurance_Tax__c": "double",
        "Account_Merchandise_Tax__c": "double",
        "Account_Name_Text__c": "string",
        "Account_Number__c": "string",
        "Account_Number_of_Units__c": "double",
        "Account_Owner_Id__c": "string",
        "Account_Owner_Match__c": "boolean",
        "Account_Owner__c": "string",
        "Account_Tenant_Insurance_Co__c": "string",
        "Account_Type_SF__c": "string",
        "Account_Unit_Rent_Tax_Rate__c": "double",
        "Account_Units_Rented__c": "double",
        "Account_Website_SF__c": "string",
        "AddOn__c": "string",
        "AddingunitsornewDB__c": "boolean",
        "AllWalkthroughsscheduled__c": "string",
        "All_Facilities_and_Addresses_Included_SF__c": "string",
        "All_Facilities_and_EmailPhoneIncluded_SF__c": "string",
        "Amount": "decimal(16,2)",
        "Authorization__c": "string",
        "Best_day_time__c": "string",
        "Bid_Rate_SF__c": "double",
        "Billing_Contact_Email__c": "string",
        "Billing_Contact_First_Name__c": "string",
        "Billing_Contact_Last_Name__c": "string",
        "Billing_Contact_Phone__c": "string",
        "Billing_State__c": "string",
        "Billing_Type__c": "string",
        "BypassVR__c": "boolean",
        "CC_Expiration__c": "string",
        "CC_Last_4__c": "string",
        "CC_Name__c": "string",
        "CampaignId": "string",
        "Cancellation_Fee_Amount__c": "double",
        "Channel__c": "string",
        "Check_Number__c": "string",
        "Check__c": "string",
        "Checking_Account__c": "string",
        "CloseDate": "date",
        "Comments__c": "string",
        "ConnectionReceivedId": "string",
        "ConnectionSentId": "string",
        "ContactPhone_SF__c": "string",
        "Contact_Email__c": "string",
        "Contact_First_Name__c": "string",
        "Contact__c": "string",
        "CreatedById": "string",
        "CreatedDate": "timestamp",
        "Created_By_Dept__c": "string",
        "Created_By_Is_Me__c": "boolean",
        "Created_by_Division__c": "string",
        "Credentials_Enabled__c": "boolean",
        "Credit_Card_City__c": "string",
        "Credit_Card_Country__c": "string",
        "Credit_Card_Number__c": "string",
        "Credit_Card_State__c": "string",
        "Credit_Card_Street__c": "string",
        "Credit_Card_Zip__c": "string",
        "Credit_Card__c": "string",
        "CurrencyIsoCode": "string",
        "Current_Gate_System__c": "string",
        "Current_Software__c": "string",
        "Current_User_Email__c": "string",
        "Data_Wire__c": "string",
        "Date_First_Worked__c": "date",
        "Days_to_Expiration__c": "double",
        "Description": "string",
        "Docusign_Template_Id__c": "string",
        "Estimated_Savings_Field__c": "decimal(16,2)",
        "ExistingSpareFootcustomer__c": "boolean",
        "ExpectedRevenue": "decimal(16,2)",
        "Expected_Profit_ACH__c": "decimal(16,2)",
        "Expected_Profit_CC__c": "decimal(16,2)",
        "Expected_Profit_Total__c": "decimal(16,2)",
        "Expiration_Date__c": "date",
        "First_Quote_Date__c": "date",
        "Fiscal": "string",
        "FiscalQuarter": "int",
        "FiscalYear": "int",
        "ForecastCategory": "string",
        "ForecastCategoryName": "string",
        "GPM_CC_Won_Ratio__c": "string",
        "GPM_CC_Won__c": "decimal(16,2)",
        "HasOpportunityLineItem": "boolean",
        "Has_Discount__c": "boolean",
        "Has_Taxes__c": "boolean",
        "How_did_you_hear_about_us__c": "string",
        "IGD__Collection_Id__c": "string",
        "Id": "string",
        "Implementation_Type_SF__c": "string",
        "Insurance_Tax__c": "double",
        "IsClosed": "boolean",
        "IsDeleted": "boolean",
        "IsPrivate": "boolean",
        "IsWon": "boolean",
        "LastActivityDate": "date",
        "LastModifiedById": "string",
        "LastModifiedDate": "timestamp",
        "LastReferencedDate": "timestamp",
        "LastViewedDate": "timestamp",
        "LeadSource": "string",
        "Lead_Development_Rep__c": "string",
        "Legacy_Owner__c": "string",
        "MS_Cancellation_Fee__c": "string",
        "MS_Discount_Txt__c": "string",
        "MS_Discount__c": "decimal(16,2)",
        "MS_Installed_Date__c": "date",
        "MS_Line_Total_List__c": "decimal(16,2)",
        "MS_Line_Total_Sell__c": "decimal(16,2)",
        "MS_Notes__c": "string",
        "MS_Product_Type_Icon__c": "string",
        "MS_Product_Type__c": "string",
        "MS_Quote__c": "string",
        "MS_Total_Amount__c": "decimal(16,2)",
        "MS_Total_Sell_Amount__c": "decimal(16,2)",
        "MS_Total_Volume__c": "decimal(16,2)",
        "Meet_or_Beat__c": "string",
        "Merchandise_Tax__c": "double",
        "Merchant_ID_Match__c": "boolean",
        "Merchant_ID_Number__c": "string",
        "Merchant_ID__c": "string",
        "Merchant_Services_Closed_Lost_Reason__c": "string",
        "Merchant_Services_Date_Closed__c": "date",
        "Merchant_Services_Date_Opened__c": "date",
        "Merchant_Services_Provider__c": "string",
        "Merchant_Services_Status__c": "string",
        "Name": "string",
        "New_Customer__c": "boolean",
        "New_Opportunity_Amount_Calc__c": "decimal(16,2)",
        "NextStep": "string",
        "Opportunity_Amount_Calc__c": "decimal(16,2)",
        "Opportunity_MID__c": "string",
        "Opportunity_Name_Calc__c": "string",
        "Opportunity_Notes_SF__c": "string",
        "OwnerId": "string",
        "Owner_Division__c": "string",
        "Owner_Match__c": "boolean",
        "Parent_Name__c": "string",
        "Payment_Amount__c": "decimal(16,2)",
        "Payment_Method__c": "string",
        "Payment_Received_Associated__c": "boolean",
        "Payment_Type_SF__c": "string",
        "Please_provide_more_info__c": "string",
        "Pmt_Date__c": "date",
        "Pmt_Txt__c": "string",
        "PrePayment_CB__c": "boolean",
        "PrePayment_Discount__c": "decimal(16,2)",
        "PrePayment__c": "decimal(16,2)",
        "Previous_CC_Provider__c": "string",
        "Pricebook2Id": "string",
        "Prior_System_Credit_Txt__c": "string",
        "Prior_System_Credit__c": "decimal(16,2)",
        "Probability": "string",
        "Promotion__c": "string",
        "PushCount__c": "double",
        "Quote_Template_Id__c": "string",
        "Quote__c": "string",
        "Ready_To_Go__c": "string",
        "Reason_Lost__c": "string",
        "Reason_for_contacting_u__c": "string",
        "Reason_for_leaving_previous_MS__c": "string",
        "RecordTypeId": "string",
        "Record_Type_Name__c": "string",
        "Reference_Opportunity__c": "string",
        "Rich_Text__c": "string",
        "Routing__c": "string",
        "SA_Line_Total_Discount__c": "decimal(16,2)",
        "SA_Line_Total_List__c": "decimal(16,2)",
        "SA_Line_Total_Sell__c": "decimal(16,2)",
        "SA_Notes_TF__c": "boolean",
        "SA_Notes__c": "string",
        "SA_Other_ShipTo_City__c": "string",
        "SA_Other_ShipTo_Country__c": "string",
        "SA_Other_ShipTo_Name__c": "string",
        "SA_Other_ShipTo_Phone__c": "string",
        "SA_Other_ShipTo_State__c": "string",
        "SA_Other_ShipTo_Street__c": "string",
        "SA_Other_ShipTo_Zip__c": "string",
        "SA_Payment_Type__c": "string",
        "SA_Quote__c": "string",
        "SA_ShipTo__c": "string",
        "SA_System_Amount_Calc__c": "decimal(16,2)",
        "SA_System_Discount__c": "decimal(16,2)",
        "SA_System_List__c": "decimal(16,2)",
        "SA_System_Sell__c": "decimal(16,2)",
        "SA_System_Text__c": "string",
        "SA_System__c": "string",
        "SA_Total_Amount__c": "decimal(16,2)",
        "SA_Total_Discount__c": "decimal(16,2)",
        "SA_Total_List__c": "decimal(16,2)",
        "SA_Total_Sell__c": "decimal(16,2)",
        "SC_Email__c": "string",
        "SC_First_Name__c": "string",
        "SC_Last_Name__c": "string",
        "SC_Phone__c": "string",
        "SF_Account_ID__c": "string",
        "SF_Opportunity_ID__c": "string",
        "SLMS_Approved__c": "string",
        "Schedule_Call_SF__c": "string",
        "SetupNotes_SF__c": "string",
        "SiteLinkCorporateCode_SF__c": "string",
        "SiteLink_Store__c": "string",
        "Site_City_c__c": "string",
        "Site_Fax__c": "string",
        "Software_Interest__c": "string",
        "SpareFoot_Closed_Lost_Reason__c": "string",
        "SpareFoot_Status__c": "string",
        "StageName": "string",
        "Suffix__c": "string",
        "Support_Discount_Text__c": "string",
        "Support_Discount__c": "decimal(16,2)",
        "Support_End__c": "date",
        "Support_List_Calc__c": "decimal(16,2)",
        "Support_List__c": "decimal(16,2)",
        "Support_Sell__c": "decimal(16,2)",
        "Support_Start__c": "date",
        "Support_Term_Calc__c": "double",
        "Support_Term__c": "string",
        "Support_Text__c": "string",
        "Support_Total_Discount__c": "decimal(16,2)",
        "Support_Total__c": "decimal(16,2)",
        "SyncedQuoteId": "string",
        "SystemModstamp": "timestamp",
        "TC2_Email__c": "string",
        "TC2_First_Name__c": "string",
        "TC2_Last_Name__c": "string",
        "TC2_Phone__c": "string",
        "TC_Email__c": "string",
        "TC_First_Name__c": "string",
        "TC_Last_Name__c": "string",
        "TC_Phone__c": "string",
        "TS_Quote__c": "string",
        "Tax_Amount_Bundle__c": "decimal(16,2)",
        "Tax_Amount_MS__c": "decimal(16,2)",
        "Tax_Amount_SA__c": "decimal(16,2)",
        "Tax_Amount_TS__c": "decimal(16,2)",
        "Tax_Amount_WE__c": "decimal(16,2)",
        "Tax_Local_Bundle__c": "decimal(16,2)",
        "Tax_Local_MS__c": "decimal(16,2)",
        "Tax_Local_SA__c": "decimal(16,2)",
        "Tax_Local_TS__c": "decimal(16,2)",
        "Tax_Local_WE__c": "decimal(16,2)",
        "Tax_Pct_Local__c": "string",
        "Tax_Pct_State__c": "string",
        "Tax_State_Bundle__c": "decimal(16,2)",
        "Tax_State_MS__c": "decimal(16,2)",
        "Tax_State_SA__c": "decimal(16,2)",
        "Tax_State_TS__c": "decimal(16,2)",
        "Tax_State_WE__c": "decimal(16,2)",
        "Taxable_Lines_MS__c": "decimal(16,2)",
        "Taxable_Lines_SA__c": "decimal(16,2)",
        "Taxable_Lines_WE__c": "decimal(16,2)",
        "Taxable_Total_Bundle__c": "decimal(16,2)",
        "Taxable_Total_SA__c": "decimal(16,2)",
        "Taxable_Total_WE__c": "decimal(16,2)",
        "Temporary_Owner__c": "string",
        "Tenant_Insurance_Co__c": "string",
        "Tenant_Insurance__c": "string",
        "Tentative_Conversion_Date__c": "date",
        "TotalOpportunityQuantity": "double",
        "Total_Amount__c": "decimal(16,2)",
        "Total_Discount__c": "decimal(16,2)",
        "Total_List__c": "decimal(16,2)",
        "Total_Unit_Count__c": "double",
        "Total_of_Facilities_to_be_Implemented_SF__c": "double",
        "Total_of_Walkthroughs__c": "double",
        "Type": "string",
        "UniqueOpptycount__c": "double",
        "Unit_Rent_Tax_Rate__c": "double",
        "Units_Rented__c": "double",
        "User_access_setup_SF__c": "string",
        "Users_created_SF__c": "string",
        "WB_Quote__c": "string",
        "WE_Billing_Cycle_Calc__c": "double",
        "WE_Billing_Cycle__c": "string",
        "WE_Bundle_Billing_Cycle_Calc__c": "double",
        "WE_Bundle_Billing_Cycle_List__c": "decimal(16,2)",
        "WE_Bundle_Billing_Cycle_Sell__c": "decimal(16,2)",
        "WE_Bundle_Billing_Cycle__c": "string",
        "WE_Bundle_Line_Subtotal_List__c": "decimal(16,2)",
        "WE_Bundle_Line_Subtotal_Sell__c": "decimal(16,2)",
        "WE_Bundle_Notes__c": "string",
        "WE_Bundle_Setup_Conversion_Calc__c": "decimal(16,2)",
        "WE_Bundle_Setup_Conversion_Discount__c": "decimal(16,2)",
        "WE_Bundle_Setup_Conversion_List__c": "decimal(16,2)",
        "WE_Bundle_Setup_Conversion_Sell__c": "decimal(16,2)",
        "WE_Bundle_Setup_Conversion_Text__c": "string",
        "WE_Bundle_Subscription_Txt__c": "string",
        "WE_Bundle_System_Discount__c": "decimal(16,2)",
        "WE_Bundle_Total_Amount__c": "decimal(16,2)",
        "WE_Bundle_Total_Discount__c": "decimal(16,2)",
        "WE_Bundle_Total_List__c": "decimal(16,2)",
        "WE_Bundle_Total_Sell__c": "decimal(16,2)",
        "WE_Discount_Qty__c": "double",
        "WE_Discount_Total__c": "decimal(16,2)",
        "WE_Discount_Txt__c": "string",
        "WE_Discount__c": "decimal(16,2)",
        "WE_EUR_Discount_Txt__c": "string",
        "WE_EUR_Setup_Conversion_Text__c": "string",
        "WE_EUR_Subscription_Discount_Txt__c": "string",
        "WE_EUR_Subscription_Txt__c": "string",
        "WE_First_Year_Discount_Pct__c": "string",
        "WE_First_Year_Discount__c": "decimal(16,2)",
        "WE_First_Year_List_Amount__c": "decimal(16,2)",
        "WE_First_Year_Sell_Amount__c": "decimal(16,2)",
        "WE_GBP_Discount_Txt__c": "string",
        "WE_GBP_Setup_Conversion_Text__c": "string",
        "WE_GBP_Subscription_Discount_Txt__c": "string",
        "WE_GBP_Subscription_Txt__c": "string",
        "WE_Line_Subtotal_List__c": "decimal(16,2)",
        "WE_Line_Subtotal_Sell__c": "decimal(16,2)",
        "WE_Line_Total_Discount__c": "decimal(16,2)",
        "WE_Line_Total_List__c": "decimal(16,2)",
        "WE_Line_Total_Sell__c": "decimal(16,2)",
        "WE_Monthly_Discount_Txt__c": "string",
        "WE_Notes_TF__c": "boolean",
        "WE_Notes__c": "string",
        "WE_Quote__c": "string",
        "WE_Setup_Conversion_Calc__c": "decimal(16,2)",
        "WE_Setup_Conversion_Discount__c": "decimal(16,2)",
        "WE_Setup_Conversion_List__c": "decimal(16,2)",
        "WE_Setup_Conversion_Sell__c": "decimal(16,2)",
        "WE_Setup_Conversion_Text__c": "string",
        "WE_Subscription_Discount_Txt__c": "string",
        "WE_Subscription_Txt__c": "string",
        "WE_System_Amount_Calc__c": "decimal(16,2)",
        "WE_System_Billing_Cycle_List__c": "decimal(16,2)",
        "WE_System_Billing_Cycle_Net__c": "decimal(16,2)",
        "WE_System_Billing_Cycle_Sell__c": "decimal(16,2)",
        "WE_System_Discount__c": "decimal(16,2)",
        "WE_System_List__c": "decimal(16,2)",
        "WE_System_Sell__c": "decimal(16,2)",
        "WE_System__c": "string",
        "WE_Total_Amount__c": "decimal(16,2)",
        "WE_Total_Discount__c": "decimal(16,2)",
        "WE_Total_List__c": "decimal(16,2)",
        "WE_Total_Net__c": "decimal(16,2)",
        "WE_ZAR_Discount_Txt__c": "string",
        "WE_ZAR_Setup_Conversion_Text__c": "string",
        "WE_ZAR_Subscription_Discount_Txt__c": "string",
        "WE_ZAR_Subscription_Txt__c": "string",
        "We_Bundle_System_List_Calc__c": "decimal(16,2)",
        "We_Bundle_System_List__c": "decimal(16,2)",
        "We_Bundle_System_Sell__c": "decimal(16,2)",
        "We_Bundle_System__c": "string",
        "Winning_Competitor__c": "string",
        "WonAmount__c": "decimal(16,2)",
        "eSign_Closed_Lost_Reason__c": "string",
        "eSign_Status__c": "string",
        "shipping_MS__c": "decimal(16,2)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-salesforce-sitelink-prod",
        "hive_path": "s3://sfdl-salesforce-sitelink-prod/raw/Opportunity/2018-10-26/1540582787",
        "key": "raw/Opportunity/2018-10-26/1540582787/file0.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_salesforce.sitelink_Opportunity",
        "type": "salesforce"
    }
}

running: False
schema_name_id: 562
start_time: 2018-10-26 14:39:50
success: True
trace_id: 12720227479852629953

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "AccountId": "string",
    "Account_Billing_Type__c": "string",
    "Account_Current_Gate_System__c": "string",
    "Account_Current_Software__c": "string",
    "Account_Insurance_Tax__c": "double",
    "Account_Merchandise_Tax__c": "double",
    "Account_Name_Text__c": "string",
    "Account_Number__c": "string",
    "Account_Number_of_Units__c": "double",
    "Account_Owner_Id__c": "string",
    "Account_Owner_Match__c": "boolean",
    "Account_Owner__c": "string",
    "Account_Tenant_Insurance_Co__c": "string",
    "Account_Type_SF__c": "string",
    "Account_Unit_Rent_Tax_Rate__c": "double",
    "Account_Units_Rented__c": "double",
    "Account_Website_SF__c": "string",
    "AddOn__c": "string",
    "AddingunitsornewDB__c": "boolean",
    "AllWalkthroughsscheduled__c": "string",
    "All_Facilities_and_Addresses_Included_SF__c": "string",
    "All_Facilities_and_EmailPhoneIncluded_SF__c": "string",
    "Amount": "decimal(16,2)",
    "Authorization__c": "string",
    "Best_day_time__c": "string",
    "Bid_Rate_SF__c": "double",
    "Billing_Contact_Email__c": "string",
    "Billing_Contact_First_Name__c": "string",
    "Billing_Contact_Last_Name__c": "string",
    "Billing_Contact_Phone__c": "string",
    "Billing_State__c": "string",
    "Billing_Type__c": "string",
    "BypassVR__c": "boolean",
    "CC_Expiration__c": "string",
    "CC_Last_4__c": "string",
    "CC_Name__c": "string",
    "CampaignId": "string",
    "Cancellation_Fee_Amount__c": "double",
    "Channel__c": "string",
    "Check_Number__c": "string",
    "Check__c": "string",
    "Checking_Account__c": "string",
    "CloseDate": "date",
    "Comments__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactPhone_SF__c": "string",
    "Contact_Email__c": "string",
    "Contact_First_Name__c": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "timestamp",
    "Created_By_Dept__c": "string",
    "Created_By_Is_Me__c": "boolean",
    "Created_by_Division__c": "string",
    "Credentials_Enabled__c": "boolean",
    "Credit_Card_City__c": "string",
    "Credit_Card_Country__c": "string",
    "Credit_Card_Number__c": "string",
    "Credit_Card_State__c": "string",
    "Credit_Card_Street__c": "string",
    "Credit_Card_Zip__c": "string",
    "Credit_Card__c": "string",
    "CurrencyIsoCode": "string",
    "Current_Gate_System__c": "string",
    "Current_Software__c": "string",
    "Current_User_Email__c": "string",
    "Data_Wire__c": "string",
    "Date_First_Worked__c": "date",
    "Days_to_Expiration__c": "double",
    "Description": "string",
    "Docusign_Template_Id__c": "string",
    "Estimated_Savings_Field__c": "decimal(16,2)",
    "ExistingSpareFootcustomer__c": "boolean",
    "ExpectedRevenue": "decimal(16,2)",
    "Expected_Profit_ACH__c": "decimal(16,2)",
    "Expected_Profit_CC__c": "decimal(16,2)",
    "Expected_Profit_Total__c": "decimal(16,2)",
    "Expiration_Date__c": "date",
    "First_Quote_Date__c": "date",
    "Fiscal": "string",
    "FiscalQuarter": "int",
    "FiscalYear": "int",
    "ForecastCategory": "string",
    "ForecastCategoryName": "string",
    "GPM_CC_Won_Ratio__c": "string",
    "GPM_CC_Won__c": "decimal(16,2)",
    "HasOpportunityLineItem": "boolean",
    "Has_Discount__c": "boolean",
    "Has_Taxes__c": "boolean",
    "How_did_you_hear_about_us__c": "string",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "Implementation_Type_SF__c": "string",
    "Insurance_Tax__c": "double",
    "IsClosed": "boolean",
    "IsDeleted": "boolean",
    "IsPrivate": "boolean",
    "IsWon": "boolean",
    "LastActivityDate": "date",
    "LastModifiedById": "string",
    "LastModifiedDate": "timestamp",
    "LastReferencedDate": "timestamp",
    "LastViewedDate": "timestamp",
    "LeadSource": "string",
    "Lead_Development_Rep__c": "string",
    "Legacy_Owner__c": "string",
    "MS_Cancellation_Fee__c": "string",
    "MS_Discount_Txt__c": "string",
    "MS_Discount__c": "decimal(16,2)",
    "MS_Installed_Date__c": "date",
    "MS_Line_Total_List__c": "decimal(16,2)",
    "MS_Line_Total_Sell__c": "decimal(16,2)",
    "MS_Notes__c": "string",
    "MS_Product_Type_Icon__c": "string",
    "MS_Product_Type__c": "string",
    "MS_Quote__c": "string",
    "MS_Total_Amount__c": "decimal(16,2)",
    "MS_Total_Sell_Amount__c": "decimal(16,2)",
    "MS_Total_Volume__c": "decimal(16,2)",
    "Meet_or_Beat__c": "string",
    "Merchandise_Tax__c": "double",
    "Merchant_ID_Match__c": "boolean",
    "Merchant_ID_Number__c": "string",
    "Merchant_ID__c": "string",
    "Merchant_Services_Closed_Lost_Reason__c": "string",
    "Merchant_Services_Date_Closed__c": "date",
    "Merchant_Services_Date_Opened__c": "date",
    "Merchant_Services_Provider__c": "string",
    "Merchant_Services_Status__c": "string",
    "Name": "string",
    "New_Customer__c": "boolean",
    "New_Opportunity_Amount_Calc__c": "decimal(16,2)",
    "NextStep": "string",
    "Opportunity_Amount_Calc__c": "decimal(16,2)",
    "Opportunity_MID__c": "string",
    "Opportunity_Name_Calc__c": "string",
    "Opportunity_Notes_SF__c": "string",
    "OwnerId": "string",
    "Owner_Division__c": "string",
    "Owner_Match__c": "boolean",
    "Parent_Name__c": "string",
    "Payment_Amount__c": "decimal(16,2)",
    "Payment_Method__c": "string",
    "Payment_Received_Associated__c": "boolean",
    "Payment_Type_SF__c": "string",
    "Please_provide_more_info__c": "string",
    "Pmt_Date__c": "date",
    "Pmt_Txt__c": "string",
    "PrePayment_CB__c": "boolean",
    "PrePayment_Discount__c": "decimal(16,2)",
    "PrePayment__c": "decimal(16,2)",
    "Previous_CC_Provider__c": "string",
    "Pricebook2Id": "string",
    "Prior_System_Credit_Txt__c": "string",
    "Prior_System_Credit__c": "decimal(16,2)",
    "Probability": "string",
    "Promotion__c": "string",
    "PushCount__c": "double",
    "Quote_Template_Id__c": "string",
    "Quote__c": "string",
    "Ready_To_Go__c": "string",
    "Reason_Lost__c": "string",
    "Reason_for_contacting_u__c": "string",
    "Reason_for_leaving_previous_MS__c": "string",
    "RecordTypeId": "string",
    "Record_Type_Name__c": "string",
    "Reference_Opportunity__c": "string",
    "Rich_Text__c": "string",
    "Routing__c": "string",
    "SA_Line_Total_Discount__c": "decimal(16,2)",
    "SA_Line_Total_List__c": "decimal(16,2)",
    "SA_Line_Total_Sell__c": "decimal(16,2)",
    "SA_Notes_TF__c": "boolean",
    "SA_Notes__c": "string",
    "SA_Other_ShipTo_City__c": "string",
    "SA_Other_ShipTo_Country__c": "string",
    "SA_Other_ShipTo_Name__c": "string",
    "SA_Other_ShipTo_Phone__c": "string",
    "SA_Other_ShipTo_State__c": "string",
    "SA_Other_ShipTo_Street__c": "string",
    "SA_Other_ShipTo_Zip__c": "string",
    "SA_Payment_Type__c": "string",
    "SA_Quote__c": "string",
    "SA_ShipTo__c": "string",
    "SA_System_Amount_Calc__c": "decimal(16,2)",
    "SA_System_Discount__c": "decimal(16,2)",
    "SA_System_List__c": "decimal(16,2)",
    "SA_System_Sell__c": "decimal(16,2)",
    "SA_System_Text__c": "string",
    "SA_System__c": "string",
    "SA_Total_Amount__c": "decimal(16,2)",
    "SA_Total_Discount__c": "decimal(16,2)",
    "SA_Total_List__c": "decimal(16,2)",
    "SA_Total_Sell__c": "decimal(16,2)",
    "SC_Email__c": "string",
    "SC_First_Name__c": "string",
    "SC_Last_Name__c": "string",
    "SC_Phone__c": "string",
    "SF_Account_ID__c": "string",
    "SF_Opportunity_ID__c": "string",
    "SLMS_Approved__c": "string",
    "Schedule_Call_SF__c": "string",
    "SetupNotes_SF__c": "string",
    "SiteLinkCorporateCode_SF__c": "string",
    "SiteLink_Store__c": "string",
    "Site_City_c__c": "string",
    "Site_Fax__c": "string",
    "Software_Interest__c": "string",
    "SpareFoot_Closed_Lost_Reason__c": "string",
    "SpareFoot_Status__c": "string",
    "StageName": "string",
    "Suffix__c": "string",
    "Support_Discount_Text__c": "string",
    "Support_Discount__c": "decimal(16,2)",
    "Support_End__c": "date",
    "Support_List_Calc__c": "decimal(16,2)",
    "Support_List__c": "decimal(16,2)",
    "Support_Sell__c": "decimal(16,2)",
    "Support_Start__c": "date",
    "Support_Term_Calc__c": "double",
    "Support_Term__c": "string",
    "Support_Text__c": "string",
    "Support_Total_Discount__c": "decimal(16,2)",
    "Support_Total__c": "decimal(16,2)",
    "SyncedQuoteId": "string",
    "SystemModstamp": "timestamp",
    "TC2_Email__c": "string",
    "TC2_First_Name__c": "string",
    "TC2_Last_Name__c": "string",
    "TC2_Phone__c": "string",
    "TC_Email__c": "string",
    "TC_First_Name__c": "string",
    "TC_Last_Name__c": "string",
    "TC_Phone__c": "string",
    "TS_Quote__c": "string",
    "Tax_Amount_Bundle__c": "decimal(16,2)",
    "Tax_Amount_MS__c": "decimal(16,2)",
    "Tax_Amount_SA__c": "decimal(16,2)",
    "Tax_Amount_TS__c": "decimal(16,2)",
    "Tax_Amount_WE__c": "decimal(16,2)",
    "Tax_Local_Bundle__c": "decimal(16,2)",
    "Tax_Local_MS__c": "decimal(16,2)",
    "Tax_Local_SA__c": "decimal(16,2)",
    "Tax_Local_TS__c": "decimal(16,2)",
    "Tax_Local_WE__c": "decimal(16,2)",
    "Tax_Pct_Local__c": "string",
    "Tax_Pct_State__c": "string",
    "Tax_State_Bundle__c": "decimal(16,2)",
    "Tax_State_MS__c": "decimal(16,2)",
    "Tax_State_SA__c": "decimal(16,2)",
    "Tax_State_TS__c": "decimal(16,2)",
    "Tax_State_WE__c": "decimal(16,2)",
    "Taxable_Lines_MS__c": "decimal(16,2)",
    "Taxable_Lines_SA__c": "decimal(16,2)",
    "Taxable_Lines_WE__c": "decimal(16,2)",
    "Taxable_Total_Bundle__c": "decimal(16,2)",
    "Taxable_Total_SA__c": "decimal(16,2)",
    "Taxable_Total_WE__c": "decimal(16,2)",
    "Temporary_Owner__c": "string",
    "Tenant_Insurance_Co__c": "string",
    "Tenant_Insurance__c": "string",
    "Tentative_Conversion_Date__c": "date",
    "TotalOpportunityQuantity": "double",
    "Total_Amount__c": "decimal(16,2)",
    "Total_Discount__c": "decimal(16,2)",
    "Total_List__c": "decimal(16,2)",
    "Total_Unit_Count__c": "double",
    "Total_of_Facilities_to_be_Implemented_SF__c": "double",
    "Total_of_Walkthroughs__c": "double",
    "Type": "string",
    "UniqueOpptycount__c": "double",
    "Unit_Rent_Tax_Rate__c": "double",
    "Units_Rented__c": "double",
    "User_access_setup_SF__c": "string",
    "Users_created_SF__c": "string",
    "WB_Quote__c": "string",
    "WE_Billing_Cycle_Calc__c": "double",
    "WE_Billing_Cycle__c": "string",
    "WE_Bundle_Billing_Cycle_Calc__c": "double",
    "WE_Bundle_Billing_Cycle_List__c": "decimal(16,2)",
    "WE_Bundle_Billing_Cycle_Sell__c": "decimal(16,2)",
    "WE_Bundle_Billing_Cycle__c": "string",
    "WE_Bundle_Line_Subtotal_List__c": "decimal(16,2)",
    "WE_Bundle_Line_Subtotal_Sell__c": "decimal(16,2)",
    "WE_Bundle_Notes__c": "string",
    "WE_Bundle_Setup_Conversion_Calc__c": "decimal(16,2)",
    "WE_Bundle_Setup_Conversion_Discount__c": "decimal(16,2)",
    "WE_Bundle_Setup_Conversion_List__c": "decimal(16,2)",
    "WE_Bundle_Setup_Conversion_Sell__c": "decimal(16,2)",
    "WE_Bundle_Setup_Conversion_Text__c": "string",
    "WE_Bundle_Subscription_Txt__c": "string",
    "WE_Bundle_System_Discount__c": "decimal(16,2)",
    "WE_Bundle_Total_Amount__c": "decimal(16,2)",
    "WE_Bundle_Total_Discount__c": "decimal(16,2)",
    "WE_Bundle_Total_List__c": "decimal(16,2)",
    "WE_Bundle_Total_Sell__c": "decimal(16,2)",
    "WE_Discount_Qty__c": "double",
    "WE_Discount_Total__c": "decimal(16,2)",
    "WE_Discount_Txt__c": "string",
    "WE_Discount__c": "decimal(16,2)",
    "WE_EUR_Discount_Txt__c": "string",
    "WE_EUR_Setup_Conversion_Text__c": "string",
    "WE_EUR_Subscription_Discount_Txt__c": "string",
    "WE_EUR_Subscription_Txt__c": "string",
    "WE_First_Year_Discount_Pct__c": "string",
    "WE_First_Year_Discount__c": "decimal(16,2)",
    "WE_First_Year_List_Amount__c": "decimal(16,2)",
    "WE_First_Year_Sell_Amount__c": "decimal(16,2)",
    "WE_GBP_Discount_Txt__c": "string",
    "WE_GBP_Setup_Conversion_Text__c": "string",
    "WE_GBP_Subscription_Discount_Txt__c": "string",
    "WE_GBP_Subscription_Txt__c": "string",
    "WE_Line_Subtotal_List__c": "decimal(16,2)",
    "WE_Line_Subtotal_Sell__c": "decimal(16,2)",
    "WE_Line_Total_Discount__c": "decimal(16,2)",
    "WE_Line_Total_List__c": "decimal(16,2)",
    "WE_Line_Total_Sell__c": "decimal(16,2)",
    "WE_Monthly_Discount_Txt__c": "string",
    "WE_Notes_TF__c": "boolean",
    "WE_Notes__c": "string",
    "WE_Quote__c": "string",
    "WE_Setup_Conversion_Calc__c": "decimal(16,2)",
    "WE_Setup_Conversion_Discount__c": "decimal(16,2)",
    "WE_Setup_Conversion_List__c": "decimal(16,2)",
    "WE_Setup_Conversion_Sell__c": "decimal(16,2)",
    "WE_Setup_Conversion_Text__c": "string",
    "WE_Subscription_Discount_Txt__c": "string",
    "WE_Subscription_Txt__c": "string",
    "WE_System_Amount_Calc__c": "decimal(16,2)",
    "WE_System_Billing_Cycle_List__c": "decimal(16,2)",
    "WE_System_Billing_Cycle_Net__c": "decimal(16,2)",
    "WE_System_Billing_Cycle_Sell__c": "decimal(16,2)",
    "WE_System_Discount__c": "decimal(16,2)",
    "WE_System_List__c": "decimal(16,2)",
    "WE_System_Sell__c": "decimal(16,2)",
    "WE_System__c": "string",
    "WE_Total_Amount__c": "decimal(16,2)",
    "WE_Total_Discount__c": "decimal(16,2)",
    "WE_Total_List__c": "decimal(16,2)",
    "WE_Total_Net__c": "decimal(16,2)",
    "WE_ZAR_Discount_Txt__c": "string",
    "WE_ZAR_Setup_Conversion_Text__c": "string",
    "WE_ZAR_Subscription_Discount_Txt__c": "string",
    "WE_ZAR_Subscription_Txt__c": "string",
    "We_Bundle_System_List_Calc__c": "decimal(16,2)",
    "We_Bundle_System_List__c": "decimal(16,2)",
    "We_Bundle_System_Sell__c": "decimal(16,2)",
    "We_Bundle_System__c": "string",
    "Winning_Competitor__c": "string",
    "WonAmount__c": "decimal(16,2)",
    "attributes": "string",
    "eSign_Closed_Lost_Reason__c": "string",
    "eSign_Status__c": "string",
    "shipping_MS__c": "decimal(16,2)"
}

created: 2018-10-26 14:39:50

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_salesforce`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_salesforce.sitelink_opportunity`\n(\n `SC_Last_Name__c`  string , `Routing__c`  string , `Billing_Contact_Phone__c`  string , `Credit_Card_Number__c`  string , `CampaignId`  string , `Temporary_Owner__c`  string , `SiteLinkCorporateCode_SF__c`  string , `We_Bundle_System_Sell__c`  decimal(16,2) , `Payment_Amount__c`  decimal(16,2) , `Record_Type_Name__c`  string , `Amount`  decimal(16,2) , `SC_Email__c`  string , `How_did_you_hear_about_us__c`  string , `SA_Line_Total_Discount__c`  decimal(16,2) , `WE_Bundle_Billing_Cycle_List__c`  decimal(16,2) , `Promotion__c`  string , `WE_Line_Subtotal_List__c`  decimal(16,2) , `Reason_for_contacting_u__c`  string , `TC_Phone__c`  string , `Account_Unit_Rent_Tax_Rate__c`  double , `Reason_Lost__c`  string , `Owner_Match__c`  boolean , `LastModifiedById`  string , `Pmt_Date__c`  date , `OwnerId`  string , `Merchant_Services_Date_Closed__c`  date , `WE_GBP_Subscription_Txt__c`  string , `BypassVR__c`  boolean , `Cancellation_Fee_Amount__c`  double , `UniqueOpptycount__c`  double , `Support_Total__c`  decimal(16,2) , `SA_Other_ShipTo_Country__c`  string , `Taxable_Total_Bundle__c`  decimal(16,2) , `SystemModstamp`  timestamp , `Expiration_Date__c`  date , `WonAmount__c`  decimal(16,2) , `Tax_Amount_MS__c`  decimal(16,2) , `MS_Total_Amount__c`  decimal(16,2) , `WE_GBP_Setup_Conversion_Text__c`  string , `Previous_CC_Provider__c`  string , `Tax_State_SA__c`  decimal(16,2) , `WE_Line_Subtotal_Sell__c`  decimal(16,2) , `LastModifiedDate`  timestamp , `ForecastCategoryName`  string , `MS_Line_Total_Sell__c`  decimal(16,2) , `WE_ZAR_Setup_Conversion_Text__c`  string , `WE_Discount_Txt__c`  string , `WE_Bundle_Setup_Conversion_List__c`  decimal(16,2) , `WE_Billing_Cycle__c`  string , `Billing_Contact_Email__c`  string , `Legacy_Owner__c`  string , `Lead_Development_Rep__c`  string , `Days_to_Expiration__c`  double , `WE_Subscription_Txt__c`  string , `SA_Other_ShipTo_Zip__c`  string , `WE_Monthly_Discount_Txt__c`  string , `Account_Insurance_Tax__c`  double , `NextStep`  string , `WE_Setup_Conversion_Calc__c`  decimal(16,2) , `SA_System_Text__c`  string , `Merchant_Services_Closed_Lost_Reason__c`  string , `Pmt_Txt__c`  string , `WE_Billing_Cycle_Calc__c`  double , `Account_Owner_Id__c`  string , `SC_Phone__c`  string , `Credit_Card_State__c`  string , `Tax_Local_TS__c`  decimal(16,2) , `CreatedById`  string , `Payment_Type_SF__c`  string , `Meet_or_Beat__c`  string , `SA_Other_ShipTo_State__c`  string , `Account_Current_Gate_System__c`  string , `Account_Number__c`  string , `IGD__Collection_Id__c`  string , `Best_day_time__c`  string , `SA_Line_Total_Sell__c`  decimal(16,2) , `Has_Discount__c`  boolean , `WE_Bundle_Setup_Conversion_Calc__c`  decimal(16,2) , `Expected_Profit_CC__c`  decimal(16,2) , `HasOpportunityLineItem`  boolean , `Users_created_SF__c`  string , `WE_Bundle_System_Discount__c`  decimal(16,2) , `Tax_Amount_Bundle__c`  decimal(16,2) , `Billing_State__c`  string , `Tax_State_MS__c`  decimal(16,2) , `WE_Bundle_Setup_Conversion_Sell__c`  decimal(16,2) , `WE_Quote__c`  string , `WE_EUR_Subscription_Discount_Txt__c`  string , `CurrencyIsoCode`  string , `We_Bundle_System_List__c`  decimal(16,2) , `IsDeleted`  boolean , `Quote__c`  string , `ExistingSpareFootcustomer__c`  boolean , `PushCount__c`  double , `Account_Merchandise_Tax__c`  double , `eSign_Closed_Lost_Reason__c`  string , `LastViewedDate`  timestamp , `SA_Payment_Type__c`  string , `SA_Notes_TF__c`  boolean , `Implementation_Type_SF__c`  string , `Support_Term_Calc__c`  double , `Account_Units_Rented__c`  double , `Account_Owner__c`  string , `MS_Quote__c`  string , `Merchant_Services_Date_Opened__c`  date , `TC_Last_Name__c`  string , `Support_Start__c`  date , `Merchant_Services_Status__c`  string , `Tax_Pct_Local__c`  string , `WE_Bundle_Setup_Conversion_Discount__c`  decimal(16,2) , `CC_Last_4__c`  string , `eSign_Status__c`  string , `Type`  string , `Unit_Rent_Tax_Rate__c`  double , `WE_Line_Total_List__c`  decimal(16,2) , `MS_Product_Type_Icon__c`  string , `Billing_Contact_Last_Name__c`  string , `WE_Bundle_Billing_Cycle_Sell__c`  decimal(16,2) , `Estimated_Savings_Field__c`  decimal(16,2) , `Opportunity_Notes_SF__c`  string , `Ready_To_Go__c`  string , `Opportunity_Amount_Calc__c`  decimal(16,2) , `Account_Tenant_Insurance_Co__c`  string , `AllWalkthroughsscheduled__c`  string , `WE_First_Year_Discount__c`  decimal(16,2) , `Contact_Email__c`  string , `SA_Quote__c`  string , `TC2_Phone__c`  string , `Total_Amount__c`  decimal(16,2) , `TC2_Email__c`  string , `WE_First_Year_List_Amount__c`  decimal(16,2) , `Support_Text__c`  string , `Taxable_Lines_SA__c`  decimal(16,2) , `MS_Total_Sell_Amount__c`  decimal(16,2) , `SA_Line_Total_List__c`  decimal(16,2) , `Please_provide_more_info__c`  string , `ContactPhone_SF__c`  string , `Support_List_Calc__c`  decimal(16,2) , `Credit_Card_Street__c`  string , `Support_Total_Discount__c`  decimal(16,2) , `Owner_Division__c`  string , `MS_Discount_Txt__c`  string , `WE_Notes__c`  string , `Docusign_Template_Id__c`  string , `Credit_Card_City__c`  string , `SF_Account_ID__c`  string , `We_Bundle_System_List_Calc__c`  decimal(16,2) , `WE_Total_List__c`  decimal(16,2) , `WE_Line_Total_Sell__c`  decimal(16,2) , `WE_System_List__c`  decimal(16,2) , `WE_System_Billing_Cycle_Net__c`  decimal(16,2) , `Authorization__c`  string , `New_Customer__c`  boolean , `SA_Total_List__c`  decimal(16,2) , `Channel__c`  string , `Name`  string , `WE_Notes_TF__c`  boolean , `SA_Other_ShipTo_Phone__c`  string , `LeadSource`  string , `IsPrivate`  boolean , `Total_Discount__c`  decimal(16,2) , `WE_GBP_Discount_Txt__c`  string , `First_Quote_Date__c`  date , `Account_Name_Text__c`  string , `WE_Setup_Conversion_List__c`  decimal(16,2) , `WE_Bundle_Line_Subtotal_Sell__c`  decimal(16,2) , `GPM_CC_Won_Ratio__c`  string , `SA_System_Sell__c`  decimal(16,2) , `WE_System_Discount__c`  decimal(16,2) , `Has_Taxes__c`  boolean , `Fiscal`  string , `Check__c`  string , `Support_Discount_Text__c`  string , `CC_Expiration__c`  string , `SA_System_Discount__c`  decimal(16,2) , `Suffix__c`  string , `Credit_Card_Country__c`  string , `TC_Email__c`  string , `WE_ZAR_Subscription_Txt__c`  string , `WE_Bundle_Total_List__c`  decimal(16,2) , `MS_Discount__c`  decimal(16,2) , `Total_of_Walkthroughs__c`  double , `SA_Total_Discount__c`  decimal(16,2) , `WE_Bundle_Total_Discount__c`  decimal(16,2) , `Tax_Amount_SA__c`  decimal(16,2) , `FiscalYear`  int , `Account_Current_Software__c`  string , `WE_Setup_Conversion_Sell__c`  decimal(16,2) , `Payment_Received_Associated__c`  boolean , `WE_Total_Amount__c`  decimal(16,2) , `User_access_setup_SF__c`  string , `WE_Line_Total_Discount__c`  decimal(16,2) , `CC_Name__c`  string , `Tax_State_TS__c`  decimal(16,2) , `Opportunity_Name_Calc__c`  string , `FiscalQuarter`  int , `WE_GBP_Subscription_Discount_Txt__c`  string , `SpareFoot_Status__c`  string , `WE_Bundle_Total_Amount__c`  decimal(16,2) , `Reason_for_leaving_previous_MS__c`  string , `WE_Bundle_Total_Sell__c`  decimal(16,2) , `MS_Installed_Date__c`  date , `Opportunity_MID__c`  string , `Probability`  string , `TS_Quote__c`  string , `Support_List__c`  decimal(16,2) , `Billing_Type__c`  string , `Tax_Local_MS__c`  decimal(16,2) , `WE_System_Sell__c`  decimal(16,2) , `attributes`  string , `Account_Billing_Type__c`  string , `Taxable_Lines_WE__c`  decimal(16,2) , `Taxable_Total_WE__c`  decimal(16,2) , `Account_Number_of_Units__c`  double , `WB_Quote__c`  string , `WE_Bundle_Setup_Conversion_Text__c`  string , `SyncedQuoteId`  string , `SA_Total_Amount__c`  decimal(16,2) , `Total_List__c`  decimal(16,2) , `Data_Wire__c`  string , `PrePayment__c`  decimal(16,2) , `ConnectionSentId`  string , `Merchant_ID__c`  string , `Winning_Competitor__c`  string , `All_Facilities_and_EmailPhoneIncluded_SF__c`  string , `Current_Software__c`  string , `SLMS_Approved__c`  string , `Billing_Contact_First_Name__c`  string , `RecordTypeId`  string , `Merchant_ID_Number__c`  string , `WE_First_Year_Sell_Amount__c`  decimal(16,2) , `WE_Total_Discount__c`  decimal(16,2) , `WE_System_Billing_Cycle_Sell__c`  decimal(16,2) , `WE_System_Billing_Cycle_List__c`  decimal(16,2) , `PrePayment_Discount__c`  decimal(16,2) , `MS_Cancellation_Fee__c`  string , `Account_Website_SF__c`  string , `Merchant_ID_Match__c`  boolean , `Created_By_Dept__c`  string , `SA_Other_ShipTo_Street__c`  string , `WE_System__c`  string , `Current_User_Email__c`  string , `SA_System_List__c`  decimal(16,2) , `Prior_System_Credit_Txt__c`  string , `WE_Bundle_Billing_Cycle_Calc__c`  double , `SA_Other_ShipTo_City__c`  string , `Schedule_Call_SF__c`  string , `Tax_Amount_TS__c`  decimal(16,2) , `Support_Discount__c`  decimal(16,2) , `SA_System_Amount_Calc__c`  decimal(16,2) , `Parent_Name__c`  string , `MS_Total_Volume__c`  decimal(16,2) , `Tax_Local_Bundle__c`  decimal(16,2) , `ConnectionReceivedId`  string , `Description`  string , `Total_of_Facilities_to_be_Implemented_SF__c`  double , `Taxable_Total_SA__c`  decimal(16,2) , `LastActivityDate`  date , `Created_By_Is_Me__c`  boolean , `AddingunitsornewDB__c`  boolean , `Id`  string , `Tax_Local_SA__c`  decimal(16,2) , `Tax_State_WE__c`  decimal(16,2) , `We_Bundle_System__c`  string , `Tax_Pct_State__c`  string , `Created_by_Division__c`  string , `StageName`  string , `WE_Bundle_Line_Subtotal_List__c`  decimal(16,2) , `Rich_Text__c`  string , `AddOn__c`  string , `Tenant_Insurance__c`  string , `AccountId`  string , `IsWon`  boolean , `SA_ShipTo__c`  string , `All_Facilities_and_Addresses_Included_SF__c`  string , `LastReferencedDate`  timestamp , `TC2_First_Name__c`  string , `Merchant_Services_Provider__c`  string , `TC2_Last_Name__c`  string , `Quote_Template_Id__c`  string , `ForecastCategory`  string , `Taxable_Lines_MS__c`  decimal(16,2) , `Comments__c`  string , `Total_Unit_Count__c`  double , `Contact__c`  string , `Site_City_c__c`  string , `WE_Discount_Total__c`  decimal(16,2) , `CloseDate`  date , `PrePayment_CB__c`  boolean , `SA_Other_ShipTo_Name__c`  string , `WE_ZAR_Discount_Txt__c`  string , `Current_Gate_System__c`  string , `WE_Bundle_Billing_Cycle__c`  string , `Units_Rented__c`  double , `Support_Term__c`  string , `WE_First_Year_Discount_Pct__c`  string , `WE_Discount_Qty__c`  double , `Bid_Rate_SF__c`  double , `WE_Setup_Conversion_Text__c`  string , `Date_First_Worked__c`  date , `Expected_Profit_ACH__c`  decimal(16,2) , `Tax_Local_WE__c`  decimal(16,2) , `Software_Interest__c`  string , `Support_End__c`  date , `CreatedDate`  timestamp , `WE_Discount__c`  decimal(16,2) , `Tax_Amount_WE__c`  decimal(16,2) , `SA_Notes__c`  string , `WE_Setup_Conversion_Discount__c`  decimal(16,2) , `SA_System__c`  string , `TC_First_Name__c`  string , `Contact_First_Name__c`  string , `Support_Sell__c`  decimal(16,2) , `Check_Number__c`  string , `Credit_Card__c`  string , `Credentials_Enabled__c`  boolean , `Pricebook2Id`  string , `MS_Product_Type__c`  string , `SiteLink_Store__c`  string , `Tentative_Conversion_Date__c`  date , `MS_Line_Total_List__c`  decimal(16,2) , `WE_Bundle_Subscription_Txt__c`  string , `Account_Owner_Match__c`  boolean , `Site_Fax__c`  string , `SetupNotes_SF__c`  string , `shipping_MS__c`  decimal(16,2) , `Merchandise_Tax__c`  double , `Account_Type_SF__c`  string , `Checking_Account__c`  string , `TotalOpportunityQuantity`  double , `SC_First_Name__c`  string , `IsClosed`  boolean , `SF_Opportunity_ID__c`  string , `WE_System_Amount_Calc__c`  decimal(16,2) , `Prior_System_Credit__c`  decimal(16,2) , `SpareFoot_Closed_Lost_Reason__c`  string , `WE_EUR_Discount_Txt__c`  string , `Payment_Method__c`  string , `WE_ZAR_Subscription_Discount_Txt__c`  string , `GPM_CC_Won__c`  decimal(16,2) , `Credit_Card_Zip__c`  string , `Reference_Opportunity__c`  string , `Tax_State_Bundle__c`  decimal(16,2) , `SA_Total_Sell__c`  decimal(16,2) , `WE_EUR_Subscription_Txt__c`  string , `WE_Subscription_Discount_Txt__c`  string , `New_Opportunity_Amount_Calc__c`  decimal(16,2) , `WE_Total_Net__c`  decimal(16,2) , `WE_Bundle_Notes__c`  string , `MS_Notes__c`  string , `WE_EUR_Setup_Conversion_Text__c`  string , `Tenant_Insurance_Co__c`  string , `Insurance_Tax__c`  double , `Expected_Profit_Total__c`  decimal(16,2) , `ExpectedRevenue`  decimal(16,2) \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '\u0001')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-salesforce-sitelink-prod/raw/Opportunity/2018-10-26/1540582787'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_salesforce.sitelink_opportunity`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_salesforce.sitelink_opportunity"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2018-10-26 14:39:50",
        "disabled": false,
        "format": "raw",
        "id": 562,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_salesforce",
            "table": "sitelink_opportunity"
        },
        "type": "salesforce"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AccountId": "string",
            "Account_Billing_Type__c": "string",
            "Account_Current_Gate_System__c": "string",
            "Account_Current_Software__c": "string",
            "Account_Insurance_Tax__c": "double",
            "Account_Merchandise_Tax__c": "double",
            "Account_Name_Text__c": "string",
            "Account_Number__c": "string",
            "Account_Number_of_Units__c": "double",
            "Account_Owner_Id__c": "string",
            "Account_Owner_Match__c": "boolean",
            "Account_Owner__c": "string",
            "Account_Tenant_Insurance_Co__c": "string",
            "Account_Type_SF__c": "string",
            "Account_Unit_Rent_Tax_Rate__c": "double",
            "Account_Units_Rented__c": "double",
            "Account_Website_SF__c": "string",
            "AddOn__c": "string",
            "AddingunitsornewDB__c": "boolean",
            "AllWalkthroughsscheduled__c": "string",
            "All_Facilities_and_Addresses_Included_SF__c": "string",
            "All_Facilities_and_EmailPhoneIncluded_SF__c": "string",
            "Amount": "decimal(16,2)",
            "Authorization__c": "string",
            "Best_day_time__c": "string",
            "Bid_Rate_SF__c": "double",
            "Billing_Contact_Email__c": "string",
            "Billing_Contact_First_Name__c": "string",
            "Billing_Contact_Last_Name__c": "string",
            "Billing_Contact_Phone__c": "string",
            "Billing_State__c": "string",
            "Billing_Type__c": "string",
            "BypassVR__c": "boolean",
            "CC_Expiration__c": "string",
            "CC_Last_4__c": "string",
            "CC_Name__c": "string",
            "CampaignId": "string",
            "Cancellation_Fee_Amount__c": "double",
            "Channel__c": "string",
            "Check_Number__c": "string",
            "Check__c": "string",
            "Checking_Account__c": "string",
            "CloseDate": "date",
            "Comments__c": "string",
            "ConnectionReceivedId": "string",
            "ConnectionSentId": "string",
            "ContactPhone_SF__c": "string",
            "Contact_Email__c": "string",
            "Contact_First_Name__c": "string",
            "Contact__c": "string",
            "CreatedById": "string",
            "CreatedDate": "timestamp",
            "Created_By_Dept__c": "string",
            "Created_By_Is_Me__c": "boolean",
            "Created_by_Division__c": "string",
            "Credentials_Enabled__c": "boolean",
            "Credit_Card_City__c": "string",
            "Credit_Card_Country__c": "string",
            "Credit_Card_Number__c": "string",
            "Credit_Card_State__c": "string",
            "Credit_Card_Street__c": "string",
            "Credit_Card_Zip__c": "string",
            "Credit_Card__c": "string",
            "CurrencyIsoCode": "string",
            "Current_Gate_System__c": "string",
            "Current_Software__c": "string",
            "Current_User_Email__c": "string",
            "Data_Wire__c": "string",
            "Date_First_Worked__c": "date",
            "Days_to_Expiration__c": "double",
            "Description": "string",
            "Docusign_Template_Id__c": "string",
            "Estimated_Savings_Field__c": "decimal(16,2)",
            "ExistingSpareFootcustomer__c": "boolean",
            "ExpectedRevenue": "decimal(16,2)",
            "Expected_Profit_ACH__c": "decimal(16,2)",
            "Expected_Profit_CC__c": "decimal(16,2)",
            "Expected_Profit_Total__c": "decimal(16,2)",
            "Expiration_Date__c": "date",
            "First_Quote_Date__c": "date",
            "Fiscal": "string",
            "FiscalQuarter": "int",
            "FiscalYear": "int",
            "ForecastCategory": "string",
            "ForecastCategoryName": "string",
            "GPM_CC_Won_Ratio__c": "string",
            "GPM_CC_Won__c": "decimal(16,2)",
            "HasOpportunityLineItem": "boolean",
            "Has_Discount__c": "boolean",
            "Has_Taxes__c": "boolean",
            "How_did_you_hear_about_us__c": "string",
            "IGD__Collection_Id__c": "string",
            "Id": "string",
            "Implementation_Type_SF__c": "string",
            "Insurance_Tax__c": "double",
            "IsClosed": "boolean",
            "IsDeleted": "boolean",
            "IsPrivate": "boolean",
            "IsWon": "boolean",
            "LastActivityDate": "date",
            "LastModifiedById": "string",
            "LastModifiedDate": "timestamp",
            "LastReferencedDate": "timestamp",
            "LastViewedDate": "timestamp",
            "LeadSource": "string",
            "Lead_Development_Rep__c": "string",
            "Legacy_Owner__c": "string",
            "MS_Cancellation_Fee__c": "string",
            "MS_Discount_Txt__c": "string",
            "MS_Discount__c": "decimal(16,2)",
            "MS_Installed_Date__c": "date",
            "MS_Line_Total_List__c": "decimal(16,2)",
            "MS_Line_Total_Sell__c": "decimal(16,2)",
            "MS_Notes__c": "string",
            "MS_Product_Type_Icon__c": "string",
            "MS_Product_Type__c": "string",
            "MS_Quote__c": "string",
            "MS_Total_Amount__c": "decimal(16,2)",
            "MS_Total_Sell_Amount__c": "decimal(16,2)",
            "MS_Total_Volume__c": "decimal(16,2)",
            "Meet_or_Beat__c": "string",
            "Merchandise_Tax__c": "double",
            "Merchant_ID_Match__c": "boolean",
            "Merchant_ID_Number__c": "string",
            "Merchant_ID__c": "string",
            "Merchant_Services_Closed_Lost_Reason__c": "string",
            "Merchant_Services_Date_Closed__c": "date",
            "Merchant_Services_Date_Opened__c": "date",
            "Merchant_Services_Provider__c": "string",
            "Merchant_Services_Status__c": "string",
            "Name": "string",
            "New_Customer__c": "boolean",
            "New_Opportunity_Amount_Calc__c": "decimal(16,2)",
            "NextStep": "string",
            "Opportunity_Amount_Calc__c": "decimal(16,2)",
            "Opportunity_MID__c": "string",
            "Opportunity_Name_Calc__c": "string",
            "Opportunity_Notes_SF__c": "string",
            "OwnerId": "string",
            "Owner_Division__c": "string",
            "Owner_Match__c": "boolean",
            "Parent_Name__c": "string",
            "Payment_Amount__c": "decimal(16,2)",
            "Payment_Method__c": "string",
            "Payment_Received_Associated__c": "boolean",
            "Payment_Type_SF__c": "string",
            "Please_provide_more_info__c": "string",
            "Pmt_Date__c": "date",
            "Pmt_Txt__c": "string",
            "PrePayment_CB__c": "boolean",
            "PrePayment_Discount__c": "decimal(16,2)",
            "PrePayment__c": "decimal(16,2)",
            "Previous_CC_Provider__c": "string",
            "Pricebook2Id": "string",
            "Prior_System_Credit_Txt__c": "string",
            "Prior_System_Credit__c": "decimal(16,2)",
            "Probability": "string",
            "Promotion__c": "string",
            "PushCount__c": "double",
            "Quote_Template_Id__c": "string",
            "Quote__c": "string",
            "Ready_To_Go__c": "string",
            "Reason_Lost__c": "string",
            "Reason_for_contacting_u__c": "string",
            "Reason_for_leaving_previous_MS__c": "string",
            "RecordTypeId": "string",
            "Record_Type_Name__c": "string",
            "Reference_Opportunity__c": "string",
            "Rich_Text__c": "string",
            "Routing__c": "string",
            "SA_Line_Total_Discount__c": "decimal(16,2)",
            "SA_Line_Total_List__c": "decimal(16,2)",
            "SA_Line_Total_Sell__c": "decimal(16,2)",
            "SA_Notes_TF__c": "boolean",
            "SA_Notes__c": "string",
            "SA_Other_ShipTo_City__c": "string",
            "SA_Other_ShipTo_Country__c": "string",
            "SA_Other_ShipTo_Name__c": "string",
            "SA_Other_ShipTo_Phone__c": "string",
            "SA_Other_ShipTo_State__c": "string",
            "SA_Other_ShipTo_Street__c": "string",
            "SA_Other_ShipTo_Zip__c": "string",
            "SA_Payment_Type__c": "string",
            "SA_Quote__c": "string",
            "SA_ShipTo__c": "string",
            "SA_System_Amount_Calc__c": "decimal(16,2)",
            "SA_System_Discount__c": "decimal(16,2)",
            "SA_System_List__c": "decimal(16,2)",
            "SA_System_Sell__c": "decimal(16,2)",
            "SA_System_Text__c": "string",
            "SA_System__c": "string",
            "SA_Total_Amount__c": "decimal(16,2)",
            "SA_Total_Discount__c": "decimal(16,2)",
            "SA_Total_List__c": "decimal(16,2)",
            "SA_Total_Sell__c": "decimal(16,2)",
            "SC_Email__c": "string",
            "SC_First_Name__c": "string",
            "SC_Last_Name__c": "string",
            "SC_Phone__c": "string",
            "SF_Account_ID__c": "string",
            "SF_Opportunity_ID__c": "string",
            "SLMS_Approved__c": "string",
            "Schedule_Call_SF__c": "string",
            "SetupNotes_SF__c": "string",
            "SiteLinkCorporateCode_SF__c": "string",
            "SiteLink_Store__c": "string",
            "Site_City_c__c": "string",
            "Site_Fax__c": "string",
            "Software_Interest__c": "string",
            "SpareFoot_Closed_Lost_Reason__c": "string",
            "SpareFoot_Status__c": "string",
            "StageName": "string",
            "Suffix__c": "string",
            "Support_Discount_Text__c": "string",
            "Support_Discount__c": "decimal(16,2)",
            "Support_End__c": "date",
            "Support_List_Calc__c": "decimal(16,2)",
            "Support_List__c": "decimal(16,2)",
            "Support_Sell__c": "decimal(16,2)",
            "Support_Start__c": "date",
            "Support_Term_Calc__c": "double",
            "Support_Term__c": "string",
            "Support_Text__c": "string",
            "Support_Total_Discount__c": "decimal(16,2)",
            "Support_Total__c": "decimal(16,2)",
            "SyncedQuoteId": "string",
            "SystemModstamp": "timestamp",
            "TC2_Email__c": "string",
            "TC2_First_Name__c": "string",
            "TC2_Last_Name__c": "string",
            "TC2_Phone__c": "string",
            "TC_Email__c": "string",
            "TC_First_Name__c": "string",
            "TC_Last_Name__c": "string",
            "TC_Phone__c": "string",
            "TS_Quote__c": "string",
            "Tax_Amount_Bundle__c": "decimal(16,2)",
            "Tax_Amount_MS__c": "decimal(16,2)",
            "Tax_Amount_SA__c": "decimal(16,2)",
            "Tax_Amount_TS__c": "decimal(16,2)",
            "Tax_Amount_WE__c": "decimal(16,2)",
            "Tax_Local_Bundle__c": "decimal(16,2)",
            "Tax_Local_MS__c": "decimal(16,2)",
            "Tax_Local_SA__c": "decimal(16,2)",
            "Tax_Local_TS__c": "decimal(16,2)",
            "Tax_Local_WE__c": "decimal(16,2)",
            "Tax_Pct_Local__c": "string",
            "Tax_Pct_State__c": "string",
            "Tax_State_Bundle__c": "decimal(16,2)",
            "Tax_State_MS__c": "decimal(16,2)",
            "Tax_State_SA__c": "decimal(16,2)",
            "Tax_State_TS__c": "decimal(16,2)",
            "Tax_State_WE__c": "decimal(16,2)",
            "Taxable_Lines_MS__c": "decimal(16,2)",
            "Taxable_Lines_SA__c": "decimal(16,2)",
            "Taxable_Lines_WE__c": "decimal(16,2)",
            "Taxable_Total_Bundle__c": "decimal(16,2)",
            "Taxable_Total_SA__c": "decimal(16,2)",
            "Taxable_Total_WE__c": "decimal(16,2)",
            "Temporary_Owner__c": "string",
            "Tenant_Insurance_Co__c": "string",
            "Tenant_Insurance__c": "string",
            "Tentative_Conversion_Date__c": "date",
            "TotalOpportunityQuantity": "double",
            "Total_Amount__c": "decimal(16,2)",
            "Total_Discount__c": "decimal(16,2)",
            "Total_List__c": "decimal(16,2)",
            "Total_Unit_Count__c": "double",
            "Total_of_Facilities_to_be_Implemented_SF__c": "double",
            "Total_of_Walkthroughs__c": "double",
            "Type": "string",
            "UniqueOpptycount__c": "double",
            "Unit_Rent_Tax_Rate__c": "double",
            "Units_Rented__c": "double",
            "User_access_setup_SF__c": "string",
            "Users_created_SF__c": "string",
            "WB_Quote__c": "string",
            "WE_Billing_Cycle_Calc__c": "double",
            "WE_Billing_Cycle__c": "string",
            "WE_Bundle_Billing_Cycle_Calc__c": "double",
            "WE_Bundle_Billing_Cycle_List__c": "decimal(16,2)",
            "WE_Bundle_Billing_Cycle_Sell__c": "decimal(16,2)",
            "WE_Bundle_Billing_Cycle__c": "string",
            "WE_Bundle_Line_Subtotal_List__c": "decimal(16,2)",
            "WE_Bundle_Line_Subtotal_Sell__c": "decimal(16,2)",
            "WE_Bundle_Notes__c": "string",
            "WE_Bundle_Setup_Conversion_Calc__c": "decimal(16,2)",
            "WE_Bundle_Setup_Conversion_Discount__c": "decimal(16,2)",
            "WE_Bundle_Setup_Conversion_List__c": "decimal(16,2)",
            "WE_Bundle_Setup_Conversion_Sell__c": "decimal(16,2)",
            "WE_Bundle_Setup_Conversion_Text__c": "string",
            "WE_Bundle_Subscription_Txt__c": "string",
            "WE_Bundle_System_Discount__c": "decimal(16,2)",
            "WE_Bundle_Total_Amount__c": "decimal(16,2)",
            "WE_Bundle_Total_Discount__c": "decimal(16,2)",
            "WE_Bundle_Total_List__c": "decimal(16,2)",
            "WE_Bundle_Total_Sell__c": "decimal(16,2)",
            "WE_Discount_Qty__c": "double",
            "WE_Discount_Total__c": "decimal(16,2)",
            "WE_Discount_Txt__c": "string",
            "WE_Discount__c": "decimal(16,2)",
            "WE_EUR_Discount_Txt__c": "string",
            "WE_EUR_Setup_Conversion_Text__c": "string",
            "WE_EUR_Subscription_Discount_Txt__c": "string",
            "WE_EUR_Subscription_Txt__c": "string",
            "WE_First_Year_Discount_Pct__c": "string",
            "WE_First_Year_Discount__c": "decimal(16,2)",
            "WE_First_Year_List_Amount__c": "decimal(16,2)",
            "WE_First_Year_Sell_Amount__c": "decimal(16,2)",
            "WE_GBP_Discount_Txt__c": "string",
            "WE_GBP_Setup_Conversion_Text__c": "string",
            "WE_GBP_Subscription_Discount_Txt__c": "string",
            "WE_GBP_Subscription_Txt__c": "string",
            "WE_Line_Subtotal_List__c": "decimal(16,2)",
            "WE_Line_Subtotal_Sell__c": "decimal(16,2)",
            "WE_Line_Total_Discount__c": "decimal(16,2)",
            "WE_Line_Total_List__c": "decimal(16,2)",
            "WE_Line_Total_Sell__c": "decimal(16,2)",
            "WE_Monthly_Discount_Txt__c": "string",
            "WE_Notes_TF__c": "boolean",
            "WE_Notes__c": "string",
            "WE_Quote__c": "string",
            "WE_Setup_Conversion_Calc__c": "decimal(16,2)",
            "WE_Setup_Conversion_Discount__c": "decimal(16,2)",
            "WE_Setup_Conversion_List__c": "decimal(16,2)",
            "WE_Setup_Conversion_Sell__c": "decimal(16,2)",
            "WE_Setup_Conversion_Text__c": "string",
            "WE_Subscription_Discount_Txt__c": "string",
            "WE_Subscription_Txt__c": "string",
            "WE_System_Amount_Calc__c": "decimal(16,2)",
            "WE_System_Billing_Cycle_List__c": "decimal(16,2)",
            "WE_System_Billing_Cycle_Net__c": "decimal(16,2)",
            "WE_System_Billing_Cycle_Sell__c": "decimal(16,2)",
            "WE_System_Discount__c": "decimal(16,2)",
            "WE_System_List__c": "decimal(16,2)",
            "WE_System_Sell__c": "decimal(16,2)",
            "WE_System__c": "string",
            "WE_Total_Amount__c": "decimal(16,2)",
            "WE_Total_Discount__c": "decimal(16,2)",
            "WE_Total_List__c": "decimal(16,2)",
            "WE_Total_Net__c": "decimal(16,2)",
            "WE_ZAR_Discount_Txt__c": "string",
            "WE_ZAR_Setup_Conversion_Text__c": "string",
            "WE_ZAR_Subscription_Discount_Txt__c": "string",
            "WE_ZAR_Subscription_Txt__c": "string",
            "We_Bundle_System_List_Calc__c": "decimal(16,2)",
            "We_Bundle_System_List__c": "decimal(16,2)",
            "We_Bundle_System_Sell__c": "decimal(16,2)",
            "We_Bundle_System__c": "string",
            "Winning_Competitor__c": "string",
            "WonAmount__c": "decimal(16,2)",
            "attributes": "string",
            "eSign_Closed_Lost_Reason__c": "string",
            "eSign_Status__c": "string",
            "shipping_MS__c": "decimal(16,2)"
        },
        "created": "2018-10-26 14:39:50",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_salesforce`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_salesforce.sitelink_opportunity`\n(\n `SC_Last_Name__c`  string , `Routing__c`  string , `Billing_Contact_Phone__c`  string , `Credit_Card_Number__c`  string , `CampaignId`  string , `Temporary_Owner__c`  string , `SiteLinkCorporateCode_SF__c`  string , `We_Bundle_System_Sell__c`  decimal(16,2) , `Payment_Amount__c`  decimal(16,2) , `Record_Type_Name__c`  string , `Amount`  decimal(16,2) , `SC_Email__c`  string , `How_did_you_hear_about_us__c`  string , `SA_Line_Total_Discount__c`  decimal(16,2) , `WE_Bundle_Billing_Cycle_List__c`  decimal(16,2) , `Promotion__c`  string , `WE_Line_Subtotal_List__c`  decimal(16,2) , `Reason_for_contacting_u__c`  string , `TC_Phone__c`  string , `Account_Unit_Rent_Tax_Rate__c`  double , `Reason_Lost__c`  string , `Owner_Match__c`  boolean , `LastModifiedById`  string , `Pmt_Date__c`  date , `OwnerId`  string , `Merchant_Services_Date_Closed__c`  date , `WE_GBP_Subscription_Txt__c`  string , `BypassVR__c`  boolean , `Cancellation_Fee_Amount__c`  double , `UniqueOpptycount__c`  double , `Support_Total__c`  decimal(16,2) , `SA_Other_ShipTo_Country__c`  string , `Taxable_Total_Bundle__c`  decimal(16,2) , `SystemModstamp`  timestamp , `Expiration_Date__c`  date , `WonAmount__c`  decimal(16,2) , `Tax_Amount_MS__c`  decimal(16,2) , `MS_Total_Amount__c`  decimal(16,2) , `WE_GBP_Setup_Conversion_Text__c`  string , `Previous_CC_Provider__c`  string , `Tax_State_SA__c`  decimal(16,2) , `WE_Line_Subtotal_Sell__c`  decimal(16,2) , `LastModifiedDate`  timestamp , `ForecastCategoryName`  string , `MS_Line_Total_Sell__c`  decimal(16,2) , `WE_ZAR_Setup_Conversion_Text__c`  string , `WE_Discount_Txt__c`  string , `WE_Bundle_Setup_Conversion_List__c`  decimal(16,2) , `WE_Billing_Cycle__c`  string , `Billing_Contact_Email__c`  string , `Legacy_Owner__c`  string , `Lead_Development_Rep__c`  string , `Days_to_Expiration__c`  double , `WE_Subscription_Txt__c`  string , `SA_Other_ShipTo_Zip__c`  string , `WE_Monthly_Discount_Txt__c`  string , `Account_Insurance_Tax__c`  double , `NextStep`  string , `WE_Setup_Conversion_Calc__c`  decimal(16,2) , `SA_System_Text__c`  string , `Merchant_Services_Closed_Lost_Reason__c`  string , `Pmt_Txt__c`  string , `WE_Billing_Cycle_Calc__c`  double , `Account_Owner_Id__c`  string , `SC_Phone__c`  string , `Credit_Card_State__c`  string , `Tax_Local_TS__c`  decimal(16,2) , `CreatedById`  string , `Payment_Type_SF__c`  string , `Meet_or_Beat__c`  string , `SA_Other_ShipTo_State__c`  string , `Account_Current_Gate_System__c`  string , `Account_Number__c`  string , `IGD__Collection_Id__c`  string , `Best_day_time__c`  string , `SA_Line_Total_Sell__c`  decimal(16,2) , `Has_Discount__c`  boolean , `WE_Bundle_Setup_Conversion_Calc__c`  decimal(16,2) , `Expected_Profit_CC__c`  decimal(16,2) , `HasOpportunityLineItem`  boolean , `Users_created_SF__c`  string , `WE_Bundle_System_Discount__c`  decimal(16,2) , `Tax_Amount_Bundle__c`  decimal(16,2) , `Billing_State__c`  string , `Tax_State_MS__c`  decimal(16,2) , `WE_Bundle_Setup_Conversion_Sell__c`  decimal(16,2) , `WE_Quote__c`  string , `WE_EUR_Subscription_Discount_Txt__c`  string , `CurrencyIsoCode`  string , `We_Bundle_System_List__c`  decimal(16,2) , `IsDeleted`  boolean , `Quote__c`  string , `ExistingSpareFootcustomer__c`  boolean , `PushCount__c`  double , `Account_Merchandise_Tax__c`  double , `eSign_Closed_Lost_Reason__c`  string , `LastViewedDate`  timestamp , `SA_Payment_Type__c`  string , `SA_Notes_TF__c`  boolean , `Implementation_Type_SF__c`  string , `Support_Term_Calc__c`  double , `Account_Units_Rented__c`  double , `Account_Owner__c`  string , `MS_Quote__c`  string , `Merchant_Services_Date_Opened__c`  date , `TC_Last_Name__c`  string , `Support_Start__c`  date , `Merchant_Services_Status__c`  string , `Tax_Pct_Local__c`  string , `WE_Bundle_Setup_Conversion_Discount__c`  decimal(16,2) , `CC_Last_4__c`  string , `eSign_Status__c`  string , `Type`  string , `Unit_Rent_Tax_Rate__c`  double , `WE_Line_Total_List__c`  decimal(16,2) , `MS_Product_Type_Icon__c`  string , `Billing_Contact_Last_Name__c`  string , `WE_Bundle_Billing_Cycle_Sell__c`  decimal(16,2) , `Estimated_Savings_Field__c`  decimal(16,2) , `Opportunity_Notes_SF__c`  string , `Ready_To_Go__c`  string , `Opportunity_Amount_Calc__c`  decimal(16,2) , `Account_Tenant_Insurance_Co__c`  string , `AllWalkthroughsscheduled__c`  string , `WE_First_Year_Discount__c`  decimal(16,2) , `Contact_Email__c`  string , `SA_Quote__c`  string , `TC2_Phone__c`  string , `Total_Amount__c`  decimal(16,2) , `TC2_Email__c`  string , `WE_First_Year_List_Amount__c`  decimal(16,2) , `Support_Text__c`  string , `Taxable_Lines_SA__c`  decimal(16,2) , `MS_Total_Sell_Amount__c`  decimal(16,2) , `SA_Line_Total_List__c`  decimal(16,2) , `Please_provide_more_info__c`  string , `ContactPhone_SF__c`  string , `Support_List_Calc__c`  decimal(16,2) , `Credit_Card_Street__c`  string , `Support_Total_Discount__c`  decimal(16,2) , `Owner_Division__c`  string , `MS_Discount_Txt__c`  string , `WE_Notes__c`  string , `Docusign_Template_Id__c`  string , `Credit_Card_City__c`  string , `SF_Account_ID__c`  string , `We_Bundle_System_List_Calc__c`  decimal(16,2) , `WE_Total_List__c`  decimal(16,2) , `WE_Line_Total_Sell__c`  decimal(16,2) , `WE_System_List__c`  decimal(16,2) , `WE_System_Billing_Cycle_Net__c`  decimal(16,2) , `Authorization__c`  string , `New_Customer__c`  boolean , `SA_Total_List__c`  decimal(16,2) , `Channel__c`  string , `Name`  string , `WE_Notes_TF__c`  boolean , `SA_Other_ShipTo_Phone__c`  string , `LeadSource`  string , `IsPrivate`  boolean , `Total_Discount__c`  decimal(16,2) , `WE_GBP_Discount_Txt__c`  string , `First_Quote_Date__c`  date , `Account_Name_Text__c`  string , `WE_Setup_Conversion_List__c`  decimal(16,2) , `WE_Bundle_Line_Subtotal_Sell__c`  decimal(16,2) , `GPM_CC_Won_Ratio__c`  string , `SA_System_Sell__c`  decimal(16,2) , `WE_System_Discount__c`  decimal(16,2) , `Has_Taxes__c`  boolean , `Fiscal`  string , `Check__c`  string , `Support_Discount_Text__c`  string , `CC_Expiration__c`  string , `SA_System_Discount__c`  decimal(16,2) , `Suffix__c`  string , `Credit_Card_Country__c`  string , `TC_Email__c`  string , `WE_ZAR_Subscription_Txt__c`  string , `WE_Bundle_Total_List__c`  decimal(16,2) , `MS_Discount__c`  decimal(16,2) , `Total_of_Walkthroughs__c`  double , `SA_Total_Discount__c`  decimal(16,2) , `WE_Bundle_Total_Discount__c`  decimal(16,2) , `Tax_Amount_SA__c`  decimal(16,2) , `FiscalYear`  int , `Account_Current_Software__c`  string , `WE_Setup_Conversion_Sell__c`  decimal(16,2) , `Payment_Received_Associated__c`  boolean , `WE_Total_Amount__c`  decimal(16,2) , `User_access_setup_SF__c`  string , `WE_Line_Total_Discount__c`  decimal(16,2) , `CC_Name__c`  string , `Tax_State_TS__c`  decimal(16,2) , `Opportunity_Name_Calc__c`  string , `FiscalQuarter`  int , `WE_GBP_Subscription_Discount_Txt__c`  string , `SpareFoot_Status__c`  string , `WE_Bundle_Total_Amount__c`  decimal(16,2) , `Reason_for_leaving_previous_MS__c`  string , `WE_Bundle_Total_Sell__c`  decimal(16,2) , `MS_Installed_Date__c`  date , `Opportunity_MID__c`  string , `Probability`  string , `TS_Quote__c`  string , `Support_List__c`  decimal(16,2) , `Billing_Type__c`  string , `Tax_Local_MS__c`  decimal(16,2) , `WE_System_Sell__c`  decimal(16,2) , `attributes`  string , `Account_Billing_Type__c`  string , `Taxable_Lines_WE__c`  decimal(16,2) , `Taxable_Total_WE__c`  decimal(16,2) , `Account_Number_of_Units__c`  double , `WB_Quote__c`  string , `WE_Bundle_Setup_Conversion_Text__c`  string , `SyncedQuoteId`  string , `SA_Total_Amount__c`  decimal(16,2) , `Total_List__c`  decimal(16,2) , `Data_Wire__c`  string , `PrePayment__c`  decimal(16,2) , `ConnectionSentId`  string , `Merchant_ID__c`  string , `Winning_Competitor__c`  string , `All_Facilities_and_EmailPhoneIncluded_SF__c`  string , `Current_Software__c`  string , `SLMS_Approved__c`  string , `Billing_Contact_First_Name__c`  string , `RecordTypeId`  string , `Merchant_ID_Number__c`  string , `WE_First_Year_Sell_Amount__c`  decimal(16,2) , `WE_Total_Discount__c`  decimal(16,2) , `WE_System_Billing_Cycle_Sell__c`  decimal(16,2) , `WE_System_Billing_Cycle_List__c`  decimal(16,2) , `PrePayment_Discount__c`  decimal(16,2) , `MS_Cancellation_Fee__c`  string , `Account_Website_SF__c`  string , `Merchant_ID_Match__c`  boolean , `Created_By_Dept__c`  string , `SA_Other_ShipTo_Street__c`  string , `WE_System__c`  string , `Current_User_Email__c`  string , `SA_System_List__c`  decimal(16,2) , `Prior_System_Credit_Txt__c`  string , `WE_Bundle_Billing_Cycle_Calc__c`  double , `SA_Other_ShipTo_City__c`  string , `Schedule_Call_SF__c`  string , `Tax_Amount_TS__c`  decimal(16,2) , `Support_Discount__c`  decimal(16,2) , `SA_System_Amount_Calc__c`  decimal(16,2) , `Parent_Name__c`  string , `MS_Total_Volume__c`  decimal(16,2) , `Tax_Local_Bundle__c`  decimal(16,2) , `ConnectionReceivedId`  string , `Description`  string , `Total_of_Facilities_to_be_Implemented_SF__c`  double , `Taxable_Total_SA__c`  decimal(16,2) , `LastActivityDate`  date , `Created_By_Is_Me__c`  boolean , `AddingunitsornewDB__c`  boolean , `Id`  string , `Tax_Local_SA__c`  decimal(16,2) , `Tax_State_WE__c`  decimal(16,2) , `We_Bundle_System__c`  string , `Tax_Pct_State__c`  string , `Created_by_Division__c`  string , `StageName`  string , `WE_Bundle_Line_Subtotal_List__c`  decimal(16,2) , `Rich_Text__c`  string , `AddOn__c`  string , `Tenant_Insurance__c`  string , `AccountId`  string , `IsWon`  boolean , `SA_ShipTo__c`  string , `All_Facilities_and_Addresses_Included_SF__c`  string , `LastReferencedDate`  timestamp , `TC2_First_Name__c`  string , `Merchant_Services_Provider__c`  string , `TC2_Last_Name__c`  string , `Quote_Template_Id__c`  string , `ForecastCategory`  string , `Taxable_Lines_MS__c`  decimal(16,2) , `Comments__c`  string , `Total_Unit_Count__c`  double , `Contact__c`  string , `Site_City_c__c`  string , `WE_Discount_Total__c`  decimal(16,2) , `CloseDate`  date , `PrePayment_CB__c`  boolean , `SA_Other_ShipTo_Name__c`  string , `WE_ZAR_Discount_Txt__c`  string , `Current_Gate_System__c`  string , `WE_Bundle_Billing_Cycle__c`  string , `Units_Rented__c`  double , `Support_Term__c`  string , `WE_First_Year_Discount_Pct__c`  string , `WE_Discount_Qty__c`  double , `Bid_Rate_SF__c`  double , `WE_Setup_Conversion_Text__c`  string , `Date_First_Worked__c`  date , `Expected_Profit_ACH__c`  decimal(16,2) , `Tax_Local_WE__c`  decimal(16,2) , `Software_Interest__c`  string , `Support_End__c`  date , `CreatedDate`  timestamp , `WE_Discount__c`  decimal(16,2) , `Tax_Amount_WE__c`  decimal(16,2) , `SA_Notes__c`  string , `WE_Setup_Conversion_Discount__c`  decimal(16,2) , `SA_System__c`  string , `TC_First_Name__c`  string , `Contact_First_Name__c`  string , `Support_Sell__c`  decimal(16,2) , `Check_Number__c`  string , `Credit_Card__c`  string , `Credentials_Enabled__c`  boolean , `Pricebook2Id`  string , `MS_Product_Type__c`  string , `SiteLink_Store__c`  string , `Tentative_Conversion_Date__c`  date , `MS_Line_Total_List__c`  decimal(16,2) , `WE_Bundle_Subscription_Txt__c`  string , `Account_Owner_Match__c`  boolean , `Site_Fax__c`  string , `SetupNotes_SF__c`  string , `shipping_MS__c`  decimal(16,2) , `Merchandise_Tax__c`  double , `Account_Type_SF__c`  string , `Checking_Account__c`  string , `TotalOpportunityQuantity`  double , `SC_First_Name__c`  string , `IsClosed`  boolean , `SF_Opportunity_ID__c`  string , `WE_System_Amount_Calc__c`  decimal(16,2) , `Prior_System_Credit__c`  decimal(16,2) , `SpareFoot_Closed_Lost_Reason__c`  string , `WE_EUR_Discount_Txt__c`  string , `Payment_Method__c`  string , `WE_ZAR_Subscription_Discount_Txt__c`  string , `GPM_CC_Won__c`  decimal(16,2) , `Credit_Card_Zip__c`  string , `Reference_Opportunity__c`  string , `Tax_State_Bundle__c`  decimal(16,2) , `SA_Total_Sell__c`  decimal(16,2) , `WE_EUR_Subscription_Txt__c`  string , `WE_Subscription_Discount_Txt__c`  string , `New_Opportunity_Amount_Calc__c`  decimal(16,2) , `WE_Total_Net__c`  decimal(16,2) , `WE_Bundle_Notes__c`  string , `MS_Notes__c`  string , `WE_EUR_Setup_Conversion_Text__c`  string , `Tenant_Insurance_Co__c`  string , `Insurance_Tax__c`  double , `Expected_Profit_Total__c`  decimal(16,2) , `ExpectedRevenue`  decimal(16,2) \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '\u0001')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-salesforce-sitelink-prod/raw/Opportunity/2018-10-26/1540582787'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_salesforce.sitelink_opportunity`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_salesforce.sitelink_opportunity"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}