Schema Info

Schema Name: sfdl_prod_salesforce.sitelink_account
  • created: 2018-10-26 14:32:02
  • disabled: False
  • format: raw
  • id: 561
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_prod_salesforce",
    "table": "sitelink_account"
}
  • type: salesforce
Schema Versions: 1
    • created: 2018-10-26 14:32:03
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_salesforce`",
    "DROP TABLE IF EXISTS `sfdl_prod_salesforce.sitelink_account`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_salesforce.sitelink_account`\n(\n `ShippingState`  string , `AnnualRevenue`  decimal(16,2) , `of_SF_Open_Demand_Opportunities__c`  double , `Sales_Admin__c`  string , `Corp_Loc2__c`  string , `Case_Safe_Account_Id__c`  string , `Customer_Type__c`  string , `ShippingPostalCode`  string , `Sales_Activity_10_1_2013__c`  boolean , `New_Support_End__c`  date , `National_Check__c`  boolean , `Site_Contact__c`  string , `Billing_Entity__c`  string , `Holly_Call_Campaign_2017__c`  boolean , `Fax`  string , `SLPC_Last_Purchased_Feature__c`  string , `BM_Names__c`  boolean , `SLPC_Send_to_Corp_Office__c`  double , `LinkedIn_URL__c`  string , `New_Salesperson__c`  string , `Parent_Country__c`  string , `BillingState`  string , `Case_Safe_Parent_Account_Id__c`  string , `CurrencyIsoCode`  string , `Discontinued_Date__c`  date , `Parent_Zip__c`  string , `Parent_Account_Owner__c`  string , `IsDeleted`  boolean , `Owner_Territory__c`  string , `Last_Opportunity_Close__c`  date , `Discontinued_Reason__c`  string , `Facebook_URL__c`  string , `Ownership`  string , `Last_Upgrade__c`  date , `Industry`  string , `Configuration__c`  string , `Demo_End_2__c`  string , `Merchant_Services_Date_Opened__c`  date , `Sales_Contact__c`  string , `LastReferencedDate`  timestamp , `Hold_Out__c`  boolean , `Open_Demand_Opportunities_parent_SF__c`  double , `OA_Parent_State__c`  boolean , `Demo_End_1__c`  string , `ACH_Account_Status__c`  string , `Rating`  string , `Parent_Account_Owner_Match__c`  string , `CC_Processing__c`  string , `Territory_Matches_Txt__c`  string , `New_Software_Choice__c`  string , `Units_Rented__c`  double , `SicDesc`  string , `Occupancy__c`  string , `RedNova__c`  boolean , `Last_Rate_Change__c`  string , `SLWE_Paid_Thru_Date__c`  date , `Parent_State__c`  string , `Twitter_URL__c`  string , `Units__c`  double , `No_Longer_Customer__c`  boolean , `Parent_Account_Name__c`  string , `Comments__c`  string , `Other_Industry__c`  string , `Returned_SiteLink__c`  boolean , `Territory__c`  string , `Product__c`  string , `Jigsaw`  string , `Parent__c`  boolean , `LastModifiedById`  string , `JigsawCompanyId`  string , `Corp_Location__c`  string , `MerchantServicesNotes__c`  string , `OwnerId`  string , `Type`  string , `Parent_City__c`  string , `Merchant_Services_Date_Closed__c`  date , `AccountSource`  string , `Offsite_Reporting__c`  string , `Marketplace_Category__c`  string , `Tech_Support_Date__c`  date , `Gate_System__c`  string , `Bob_Myers__c`  boolean , `Fax_Test__c`  double , `Conversion__c`  boolean , `Insurance_Company__c`  string , `Owner_Department__c`  string , `BillingCountry`  string , `Previous_Software__c`  string , `Parent_Public_Folder__c`  string , `Territory_Txt__c`  string , `Outlook_Category__c`  string , `ShippingStreet`  string , `Has_Merchant_Opportunity__c`  boolean , `Previous_Sales_Owner__c`  string , `SLPC_Last_Payment_Check__c`  string , `NDA_Signed__c`  boolean , `Parent_Street__c`  string , `Reseller_Account__c`  string , `Satisfaction_Level__c`  string , `Territory_Match__c`  string , `Account_Roll_up_summary__c`  double , `ParentId`  string , `ShippingCity`  string , `YouTube_URL__c`  string , `Open_Oppty__c`  double , `Region__c`  string , `SLPC_Last_Payment_Auth__c`  string , `Billing_Address__c`  string , `Opportunities__c`  double , `CC_Provider__c`  string , `Online_Listing_Service__c`  string , `AccountNumber`  string , `Tag_Color__c`  string , `Marketplace_Approved__c`  boolean , `MS_User_is_Me__c`  boolean , `Demo_Date_2__c`  date , `HW_Parent_State__c`  boolean , `Insurance_Project_Number__c`  string , `CreatedDate`  timestamp , `attributes`  string , `BillingLongitude`  double , `Invoicing__c`  string , `MS_Discontinued_Reason__c`  string , `MasterRecordId`  string , `Operations_Contact__c`  string , `ShippingLatitude`  double , `New_Support_Start__c`  date , `Tech_Support_End_Date__c`  date , `ShippingCountry`  string , `Last_Date__c`  date , `Satisfaction_Indicator__c`  string , `Shipping_Address__c`  string , `Days_Since_Activity__c`  double , `Accounts_Have_SLMS__c`  boolean , `Storage_Type__c`  string , `Corp_Code__c`  string , `Website`  string , `OA_Names__c`  boolean , `SiteLink_eSign__c`  boolean , `Demo_Date_1__c`  date , `Billing_Currency__c`  string , `Parent_Account_checkbox__c`  boolean , `LastModifiedDate`  timestamp , `Google_URL__c`  string , `Merchant_Services_DBA_Name__c`  string , `Notes__c`  string , `Phone`  string , `Account_Classification__c`  string , `BillingLatitude`  double , `SS_Names__c`  boolean , `ConnectionSentId`  string , `Demo_Start_1__c`  string , `Out_of_Territory__c`  string , `Tech_Note__c`  string , `Locations__c`  double , `Parent_Locations__c`  double , `HW_Names__c`  boolean , `Merchant_Service_Rep__c`  string , `Merchandise_Tax__c`  double , `Demo_Start_2__c`  string , `Upgrade_Needed__c`  double , `Archive__c`  boolean , `Owner_Division__c`  string , `account_url_ms__c`  string , `ShippingLongitude`  double , `Current_Software__c`  string , `Timeframe__c`  string , `SMD_Account_ID__c`  string , `Trial_Expiration__c`  date , `Source_URL__c`  string , `RecordTypeId`  string , `BillingPostalCode`  string , `Converted_To_Customer_Onboarding_Date__c`  date , `Headquarter_Type__c`  string , `Current_Feature_Interest__c`  string , `Outlook_Create_Date__c`  date , `Open_Activities__c`  boolean , `Headquartered_Number__c`  string , `Last_Contact_Date__c`  date , `TickerSymbol`  string , `eCommerce_Audit_Completed__c`  string , `Moved_to_Lead__c`  boolean , `Child_Public_Folder__c`  string , `HW_State__c`  boolean , `MS_Contact__c`  string , `SLPC_Last_Payment_Date__c`  date , `Sic`  string , `SS_State__c`  boolean , `Cirrus_Files_Folder_Name__c`  string , `BM_State__c`  boolean , `Location_Code__c`  string , `Merchant_ID__c`  string , `Tradeshows__c`  string , `Accounting_Software__c`  string , `Account_Note__c`  string , `BillingCity`  string , `Description`  string , `NumberOfEmployees`  int , `Haynes_Willson__c`  boolean , `Unit_Rent_Tax_Rate__c`  double , `BM_Parent_State__c`  boolean , `Product_Interest__c`  string , `CreatedById`  string , `National__c`  boolean , `Previous_Sales_Rep__c`  string , `Google_Maps_Link__c`  string , `SystemModstamp`  timestamp , `LastViewedDate`  timestamp , `Tech_Support_Price__c`  decimal(16,2) , `PCI_Exceptions__c`  string , `Billing_Cycle__c`  string , `Name`  string , `Parent_National__c`  boolean , `Merchant_Services_Account_Status__c`  string , `SS_Parent_State__c`  boolean , `Sebastian_Sweeney__c`  boolean , `BillingStreet`  string , `IGD__Collection_Id__c`  string , `Record_Type_Check__c`  boolean , `Icons__c`  string , `Buyer_Account__c`  string , `ConnectionReceivedId`  string , `Access_Anywhere__c`  string , `Parent_Account_Note__c`  string , `Internet__c`  string , `Old_Salesperson__c`  string , `Lead_Source_Email__c`  string , `Management_Company_Account__c`  string , `Needs__c`  string , `LastActivityDate`  date , `Converted_To_Customer_Date__c`  date , `Site`  string , `Id`  string , `OA_State__c`  boolean , `Other_MS_Discontinued_Reason__c`  string , `Olivia_Austin__c`  boolean , `ACH_Provider__c`  string , `Insurance_Tax__c`  double , `Total_Won_Opportunities__c`  decimal(16,2) , `Gateway_ID__c`  string , `SLPC_Last_Payment_Amount__c`  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/Account/2018-10-26/1540582320'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_salesforce.sitelink_account"
]
    • hive_path: s3://sfdl-salesforce-sitelink-prod/raw/Account/2018-10-26/1540582320
    • id: 50075
    • processed: 1
    • raw_data: 
      {
    "ACH_Account_Status__c": 44,
    "ACH_Provider__c": 236,
    "Access_Anywhere__c": 222,
    "AccountNumber": 111,
    "AccountSource": 76,
    "Account_Classification__c": 147,
    "Account_Note__c": 194,
    "Account_Roll_up_summary__c": 100,
    "Accounting_Software__c": 193,
    "Accounts_Have_SLMS__c": 133,
    "AnnualRevenue": 1,
    "Archive__c": 161,
    "BM_Names__c": 16,
    "BM_Parent_State__c": 200,
    "BM_State__c": 189,
    "BillingCity": 195,
    "BillingCountry": 86,
    "BillingLatitude": 148,
    "BillingLongitude": 120,
    "BillingPostalCode": 171,
    "BillingState": 21,
    "BillingStreet": 216,
    "Billing_Address__c": 107,
    "Billing_Currency__c": 140,
    "Billing_Cycle__c": 210,
    "Billing_Entity__c": 12,
    "Bob_Myers__c": 81,
    "Buyer_Account__c": 220,
    "CC_Processing__c": 47,
    "CC_Provider__c": 109,
    "Case_Safe_Account_Id__c": 5,
    "Case_Safe_Parent_Account_Id__c": 22,
    "Child_Public_Folder__c": 182,
    "Cirrus_Files_Folder_Name__c": 188,
    "Comments__c": 61,
    "Configuration__c": 35,
    "ConnectionReceivedId": 221,
    "ConnectionSentId": 150,
    "Conversion__c": 83,
    "Converted_To_Customer_Date__c": 230,
    "Converted_To_Customer_Onboarding_Date__c": 172,
    "Corp_Code__c": 135,
    "Corp_Loc2__c": 4,
    "Corp_Location__c": 70,
    "CreatedById": 202,
    "CreatedDate": 118,
    "CurrencyIsoCode": 23,
    "Current_Feature_Interest__c": 174,
    "Current_Software__c": 165,
    "Customer_Type__c": 6,
    "Days_Since_Activity__c": 132,
    "Demo_Date_1__c": 139,
    "Demo_Date_2__c": 115,
    "Demo_End_1__c": 43,
    "Demo_End_2__c": 36,
    "Demo_Start_1__c": 151,
    "Demo_Start_2__c": 159,
    "Description": 196,
    "Discontinued_Date__c": 24,
    "Discontinued_Reason__c": 30,
    "Facebook_URL__c": 31,
    "Fax": 14,
    "Fax_Test__c": 82,
    "Gate_System__c": 80,
    "Gateway_ID__c": 239,
    "Google_Maps_Link__c": 205,
    "Google_URL__c": 143,
    "HW_Names__c": 156,
    "HW_Parent_State__c": 116,
    "HW_State__c": 183,
    "Has_Merchant_Opportunity__c": 92,
    "Haynes_Willson__c": 198,
    "Headquarter_Type__c": 173,
    "Headquartered_Number__c": 177,
    "Hold_Out__c": 40,
    "Holly_Call_Campaign_2017__c": 13,
    "IGD__Collection_Id__c": 217,
    "Icons__c": 219,
    "Id": 232,
    "Industry": 34,
    "Insurance_Company__c": 84,
    "Insurance_Project_Number__c": 117,
    "Insurance_Tax__c": 237,
    "Internet__c": 224,
    "Invoicing__c": 121,
    "IsDeleted": 27,
    "Jigsaw": 66,
    "JigsawCompanyId": 69,
    "LastActivityDate": 229,
    "LastModifiedById": 68,
    "LastModifiedDate": 142,
    "LastReferencedDate": 39,
    "LastViewedDate": 207,
    "Last_Contact_Date__c": 178,
    "Last_Date__c": 129,
    "Last_Opportunity_Close__c": 29,
    "Last_Rate_Change__c": 54,
    "Last_Upgrade__c": 33,
    "Lead_Source_Email__c": 226,
    "LinkedIn_URL__c": 18,
    "Location_Code__c": 190,
    "Locations__c": 154,
    "MS_Contact__c": 184,
    "MS_Discontinued_Reason__c": 122,
    "MS_User_is_Me__c": 114,
    "Management_Company_Account__c": 227,
    "Marketplace_Approved__c": 113,
    "Marketplace_Category__c": 78,
    "MasterRecordId": 123,
    "Merchandise_Tax__c": 158,
    "MerchantServicesNotes__c": 71,
    "Merchant_ID__c": 191,
    "Merchant_Service_Rep__c": 157,
    "Merchant_Services_Account_Status__c": 213,
    "Merchant_Services_DBA_Name__c": 144,
    "Merchant_Services_Date_Closed__c": 75,
    "Merchant_Services_Date_Opened__c": 37,
    "Moved_to_Lead__c": 181,
    "NDA_Signed__c": 95,
    "Name": 211,
    "National_Check__c": 10,
    "National__c": 203,
    "Needs__c": 228,
    "New_Salesperson__c": 19,
    "New_Software_Choice__c": 49,
    "New_Support_End__c": 9,
    "New_Support_Start__c": 126,
    "No_Longer_Customer__c": 59,
    "Notes__c": 145,
    "NumberOfEmployees": 197,
    "OA_Names__c": 137,
    "OA_Parent_State__c": 42,
    "OA_State__c": 233,
    "Occupancy__c": 52,
    "Offsite_Reporting__c": 77,
    "Old_Salesperson__c": 225,
    "Olivia_Austin__c": 235,
    "Online_Listing_Service__c": 110,
    "Open_Activities__c": 176,
    "Open_Demand_Opportunities_parent_SF__c": 41,
    "Open_Oppty__c": 104,
    "Operations_Contact__c": 124,
    "Opportunities__c": 108,
    "Other_Industry__c": 62,
    "Other_MS_Discontinued_Reason__c": 234,
    "Out_of_Territory__c": 152,
    "Outlook_Category__c": 90,
    "Outlook_Create_Date__c": 175,
    "OwnerId": 72,
    "Owner_Department__c": 85,
    "Owner_Division__c": 162,
    "Owner_Territory__c": 28,
    "Ownership": 32,
    "PCI_Exceptions__c": 209,
    "ParentId": 101,
    "Parent_Account_Name__c": 60,
    "Parent_Account_Note__c": 223,
    "Parent_Account_Owner_Match__c": 46,
    "Parent_Account_Owner__c": 26,
    "Parent_Account_checkbox__c": 141,
    "Parent_City__c": 74,
    "Parent_Country__c": 20,
    "Parent_Locations__c": 155,
    "Parent_National__c": 212,
    "Parent_Public_Folder__c": 88,
    "Parent_State__c": 56,
    "Parent_Street__c": 96,
    "Parent_Zip__c": 25,
    "Parent__c": 67,
    "Phone": 146,
    "Previous_Sales_Owner__c": 93,
    "Previous_Sales_Rep__c": 204,
    "Previous_Software__c": 87,
    "Product_Interest__c": 201,
    "Product__c": 65,
    "Rating": 45,
    "RecordTypeId": 170,
    "Record_Type_Check__c": 218,
    "RedNova__c": 53,
    "Region__c": 105,
    "Reseller_Account__c": 97,
    "Returned_SiteLink__c": 63,
    "SLPC_Last_Payment_Amount__c": 240,
    "SLPC_Last_Payment_Auth__c": 106,
    "SLPC_Last_Payment_Check__c": 94,
    "SLPC_Last_Payment_Date__c": 185,
    "SLPC_Last_Purchased_Feature__c": 15,
    "SLPC_Send_to_Corp_Office__c": 17,
    "SLWE_Paid_Thru_Date__c": 55,
    "SMD_Account_ID__c": 167,
    "SS_Names__c": 149,
    "SS_Parent_State__c": 214,
    "SS_State__c": 187,
    "Sales_Activity_10_1_2013__c": 8,
    "Sales_Admin__c": 3,
    "Sales_Contact__c": 38,
    "Satisfaction_Indicator__c": 130,
    "Satisfaction_Level__c": 98,
    "Sebastian_Sweeney__c": 215,
    "ShippingCity": 102,
    "ShippingCountry": 128,
    "ShippingLatitude": 125,
    "ShippingLongitude": 164,
    "ShippingPostalCode": 7,
    "ShippingState": 0,
    "ShippingStreet": 91,
    "Shipping_Address__c": 131,
    "Sic": 186,
    "SicDesc": 51,
    "Site": 231,
    "SiteLink_eSign__c": 138,
    "Site_Contact__c": 11,
    "Source_URL__c": 169,
    "Storage_Type__c": 134,
    "SystemModstamp": 206,
    "Tag_Color__c": 112,
    "Tech_Note__c": 153,
    "Tech_Support_Date__c": 79,
    "Tech_Support_End_Date__c": 127,
    "Tech_Support_Price__c": 208,
    "Territory_Match__c": 99,
    "Territory_Matches_Txt__c": 48,
    "Territory_Txt__c": 89,
    "Territory__c": 64,
    "TickerSymbol": 179,
    "Timeframe__c": 166,
    "Total_Won_Opportunities__c": 238,
    "Tradeshows__c": 192,
    "Trial_Expiration__c": 168,
    "Twitter_URL__c": 57,
    "Type": 73,
    "Unit_Rent_Tax_Rate__c": 199,
    "Units_Rented__c": 50,
    "Units__c": 58,
    "Upgrade_Needed__c": 160,
    "Website": 136,
    "YouTube_URL__c": 103,
    "account_url_ms__c": 163,
    "attributes": 119,
    "eCommerce_Audit_Completed__c": 180,
    "of_SF_Open_Demand_Opportunities__c": 2
}
    • schema_attributes: 
      {
    "ACH_Account_Status__c": "string",
    "ACH_Provider__c": "string",
    "Access_Anywhere__c": "string",
    "AccountNumber": "string",
    "AccountSource": "string",
    "Account_Classification__c": "string",
    "Account_Note__c": "string",
    "Account_Roll_up_summary__c": "double",
    "Accounting_Software__c": "string",
    "Accounts_Have_SLMS__c": "boolean",
    "AnnualRevenue": "decimal(16,2)",
    "Archive__c": "boolean",
    "BM_Names__c": "boolean",
    "BM_Parent_State__c": "boolean",
    "BM_State__c": "boolean",
    "BillingCity": "string",
    "BillingCountry": "string",
    "BillingLatitude": "double",
    "BillingLongitude": "double",
    "BillingPostalCode": "string",
    "BillingState": "string",
    "BillingStreet": "string",
    "Billing_Address__c": "string",
    "Billing_Currency__c": "string",
    "Billing_Cycle__c": "string",
    "Billing_Entity__c": "string",
    "Bob_Myers__c": "boolean",
    "Buyer_Account__c": "string",
    "CC_Processing__c": "string",
    "CC_Provider__c": "string",
    "Case_Safe_Account_Id__c": "string",
    "Case_Safe_Parent_Account_Id__c": "string",
    "Child_Public_Folder__c": "string",
    "Cirrus_Files_Folder_Name__c": "string",
    "Comments__c": "string",
    "Configuration__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Conversion__c": "boolean",
    "Converted_To_Customer_Date__c": "date",
    "Converted_To_Customer_Onboarding_Date__c": "date",
    "Corp_Code__c": "string",
    "Corp_Loc2__c": "string",
    "Corp_Location__c": "string",
    "CreatedById": "string",
    "CreatedDate": "timestamp",
    "CurrencyIsoCode": "string",
    "Current_Feature_Interest__c": "string",
    "Current_Software__c": "string",
    "Customer_Type__c": "string",
    "Days_Since_Activity__c": "double",
    "Demo_Date_1__c": "date",
    "Demo_Date_2__c": "date",
    "Demo_End_1__c": "string",
    "Demo_End_2__c": "string",
    "Demo_Start_1__c": "string",
    "Demo_Start_2__c": "string",
    "Description": "string",
    "Discontinued_Date__c": "date",
    "Discontinued_Reason__c": "string",
    "Facebook_URL__c": "string",
    "Fax": "string",
    "Fax_Test__c": "double",
    "Gate_System__c": "string",
    "Gateway_ID__c": "string",
    "Google_Maps_Link__c": "string",
    "Google_URL__c": "string",
    "HW_Names__c": "boolean",
    "HW_Parent_State__c": "boolean",
    "HW_State__c": "boolean",
    "Has_Merchant_Opportunity__c": "boolean",
    "Haynes_Willson__c": "boolean",
    "Headquarter_Type__c": "string",
    "Headquartered_Number__c": "string",
    "Hold_Out__c": "boolean",
    "Holly_Call_Campaign_2017__c": "boolean",
    "IGD__Collection_Id__c": "string",
    "Icons__c": "string",
    "Id": "string",
    "Industry": "string",
    "Insurance_Company__c": "string",
    "Insurance_Project_Number__c": "string",
    "Insurance_Tax__c": "double",
    "Internet__c": "string",
    "Invoicing__c": "string",
    "IsDeleted": "boolean",
    "Jigsaw": "string",
    "JigsawCompanyId": "string",
    "LastActivityDate": "date",
    "LastModifiedById": "string",
    "LastModifiedDate": "timestamp",
    "LastReferencedDate": "timestamp",
    "LastViewedDate": "timestamp",
    "Last_Contact_Date__c": "date",
    "Last_Date__c": "date",
    "Last_Opportunity_Close__c": "date",
    "Last_Rate_Change__c": "string",
    "Last_Upgrade__c": "date",
    "Lead_Source_Email__c": "string",
    "LinkedIn_URL__c": "string",
    "Location_Code__c": "string",
    "Locations__c": "double",
    "MS_Contact__c": "string",
    "MS_Discontinued_Reason__c": "string",
    "MS_User_is_Me__c": "boolean",
    "Management_Company_Account__c": "string",
    "Marketplace_Approved__c": "boolean",
    "Marketplace_Category__c": "string",
    "MasterRecordId": "string",
    "Merchandise_Tax__c": "double",
    "MerchantServicesNotes__c": "string",
    "Merchant_ID__c": "string",
    "Merchant_Service_Rep__c": "string",
    "Merchant_Services_Account_Status__c": "string",
    "Merchant_Services_DBA_Name__c": "string",
    "Merchant_Services_Date_Closed__c": "date",
    "Merchant_Services_Date_Opened__c": "date",
    "Moved_to_Lead__c": "boolean",
    "NDA_Signed__c": "boolean",
    "Name": "string",
    "National_Check__c": "boolean",
    "National__c": "boolean",
    "Needs__c": "string",
    "New_Salesperson__c": "string",
    "New_Software_Choice__c": "string",
    "New_Support_End__c": "date",
    "New_Support_Start__c": "date",
    "No_Longer_Customer__c": "boolean",
    "Notes__c": "string",
    "NumberOfEmployees": "int",
    "OA_Names__c": "boolean",
    "OA_Parent_State__c": "boolean",
    "OA_State__c": "boolean",
    "Occupancy__c": "string",
    "Offsite_Reporting__c": "string",
    "Old_Salesperson__c": "string",
    "Olivia_Austin__c": "boolean",
    "Online_Listing_Service__c": "string",
    "Open_Activities__c": "boolean",
    "Open_Demand_Opportunities_parent_SF__c": "double",
    "Open_Oppty__c": "double",
    "Operations_Contact__c": "string",
    "Opportunities__c": "double",
    "Other_Industry__c": "string",
    "Other_MS_Discontinued_Reason__c": "string",
    "Out_of_Territory__c": "string",
    "Outlook_Category__c": "string",
    "Outlook_Create_Date__c": "date",
    "OwnerId": "string",
    "Owner_Department__c": "string",
    "Owner_Division__c": "string",
    "Owner_Territory__c": "string",
    "Ownership": "string",
    "PCI_Exceptions__c": "string",
    "ParentId": "string",
    "Parent_Account_Name__c": "string",
    "Parent_Account_Note__c": "string",
    "Parent_Account_Owner_Match__c": "string",
    "Parent_Account_Owner__c": "string",
    "Parent_Account_checkbox__c": "boolean",
    "Parent_City__c": "string",
    "Parent_Country__c": "string",
    "Parent_Locations__c": "double",
    "Parent_National__c": "boolean",
    "Parent_Public_Folder__c": "string",
    "Parent_State__c": "string",
    "Parent_Street__c": "string",
    "Parent_Zip__c": "string",
    "Parent__c": "boolean",
    "Phone": "string",
    "Previous_Sales_Owner__c": "string",
    "Previous_Sales_Rep__c": "string",
    "Previous_Software__c": "string",
    "Product_Interest__c": "string",
    "Product__c": "string",
    "Rating": "string",
    "RecordTypeId": "string",
    "Record_Type_Check__c": "boolean",
    "RedNova__c": "boolean",
    "Region__c": "string",
    "Reseller_Account__c": "string",
    "Returned_SiteLink__c": "boolean",
    "SLPC_Last_Payment_Amount__c": "decimal(16,2)",
    "SLPC_Last_Payment_Auth__c": "string",
    "SLPC_Last_Payment_Check__c": "string",
    "SLPC_Last_Payment_Date__c": "date",
    "SLPC_Last_Purchased_Feature__c": "string",
    "SLPC_Send_to_Corp_Office__c": "double",
    "SLWE_Paid_Thru_Date__c": "date",
    "SMD_Account_ID__c": "string",
    "SS_Names__c": "boolean",
    "SS_Parent_State__c": "boolean",
    "SS_State__c": "boolean",
    "Sales_Activity_10_1_2013__c": "boolean",
    "Sales_Admin__c": "string",
    "Sales_Contact__c": "string",
    "Satisfaction_Indicator__c": "string",
    "Satisfaction_Level__c": "string",
    "Sebastian_Sweeney__c": "boolean",
    "ShippingCity": "string",
    "ShippingCountry": "string",
    "ShippingLatitude": "double",
    "ShippingLongitude": "double",
    "ShippingPostalCode": "string",
    "ShippingState": "string",
    "ShippingStreet": "string",
    "Shipping_Address__c": "string",
    "Sic": "string",
    "SicDesc": "string",
    "Site": "string",
    "SiteLink_eSign__c": "boolean",
    "Site_Contact__c": "string",
    "Source_URL__c": "string",
    "Storage_Type__c": "string",
    "SystemModstamp": "timestamp",
    "Tag_Color__c": "string",
    "Tech_Note__c": "string",
    "Tech_Support_Date__c": "date",
    "Tech_Support_End_Date__c": "date",
    "Tech_Support_Price__c": "decimal(16,2)",
    "Territory_Match__c": "string",
    "Territory_Matches_Txt__c": "string",
    "Territory_Txt__c": "string",
    "Territory__c": "string",
    "TickerSymbol": "string",
    "Timeframe__c": "string",
    "Total_Won_Opportunities__c": "decimal(16,2)",
    "Tradeshows__c": "string",
    "Trial_Expiration__c": "date",
    "Twitter_URL__c": "string",
    "Type": "string",
    "Unit_Rent_Tax_Rate__c": "double",
    "Units_Rented__c": "double",
    "Units__c": "double",
    "Upgrade_Needed__c": "double",
    "Website": "string",
    "YouTube_URL__c": "string",
    "account_url_ms__c": "string",
    "attributes": "string",
    "eCommerce_Audit_Completed__c": "string",
    "of_SF_Open_Demand_Opportunities__c": "double"
}
    • schema_name_id: 561
    • schema_scan_id: 19538441
    • updated: 2018-10-26 14:32:14
Schema Scans: 1
Last at 2018-10-26 14:32:02
    • duration: 0:00:13.901441
    • exit_message: 
      {
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}
    • id: 19538441
    • payload: 
      {
    "datatype_dict": {
        "ACH_Account_Status__c": "string",
        "ACH_Provider__c": "string",
        "Access_Anywhere__c": "string",
        "AccountNumber": "string",
        "AccountSource": "string",
        "Account_Classification__c": "string",
        "Account_Note__c": "string",
        "Account_Roll_up_summary__c": "double",
        "Accounting_Software__c": "string",
        "Accounts_Have_SLMS__c": "boolean",
        "AnnualRevenue": "decimal(16,2)",
        "Archive__c": "boolean",
        "BM_Names__c": "boolean",
        "BM_Parent_State__c": "boolean",
        "BM_State__c": "boolean",
        "BillingCity": "string",
        "BillingCountry": "string",
        "BillingLatitude": "double",
        "BillingLongitude": "double",
        "BillingPostalCode": "string",
        "BillingState": "string",
        "BillingStreet": "string",
        "Billing_Address__c": "string",
        "Billing_Currency__c": "string",
        "Billing_Cycle__c": "string",
        "Billing_Entity__c": "string",
        "Bob_Myers__c": "boolean",
        "Buyer_Account__c": "string",
        "CC_Processing__c": "string",
        "CC_Provider__c": "string",
        "Case_Safe_Account_Id__c": "string",
        "Case_Safe_Parent_Account_Id__c": "string",
        "Child_Public_Folder__c": "string",
        "Cirrus_Files_Folder_Name__c": "string",
        "Comments__c": "string",
        "Configuration__c": "string",
        "ConnectionReceivedId": "string",
        "ConnectionSentId": "string",
        "Conversion__c": "boolean",
        "Converted_To_Customer_Date__c": "date",
        "Converted_To_Customer_Onboarding_Date__c": "date",
        "Corp_Code__c": "string",
        "Corp_Loc2__c": "string",
        "Corp_Location__c": "string",
        "CreatedById": "string",
        "CreatedDate": "timestamp",
        "CurrencyIsoCode": "string",
        "Current_Feature_Interest__c": "string",
        "Current_Software__c": "string",
        "Customer_Type__c": "string",
        "Days_Since_Activity__c": "double",
        "Demo_Date_1__c": "date",
        "Demo_Date_2__c": "date",
        "Demo_End_1__c": "string",
        "Demo_End_2__c": "string",
        "Demo_Start_1__c": "string",
        "Demo_Start_2__c": "string",
        "Description": "string",
        "Discontinued_Date__c": "date",
        "Discontinued_Reason__c": "string",
        "Facebook_URL__c": "string",
        "Fax": "string",
        "Fax_Test__c": "double",
        "Gate_System__c": "string",
        "Gateway_ID__c": "string",
        "Google_Maps_Link__c": "string",
        "Google_URL__c": "string",
        "HW_Names__c": "boolean",
        "HW_Parent_State__c": "boolean",
        "HW_State__c": "boolean",
        "Has_Merchant_Opportunity__c": "boolean",
        "Haynes_Willson__c": "boolean",
        "Headquarter_Type__c": "string",
        "Headquartered_Number__c": "string",
        "Hold_Out__c": "boolean",
        "Holly_Call_Campaign_2017__c": "boolean",
        "IGD__Collection_Id__c": "string",
        "Icons__c": "string",
        "Id": "string",
        "Industry": "string",
        "Insurance_Company__c": "string",
        "Insurance_Project_Number__c": "string",
        "Insurance_Tax__c": "double",
        "Internet__c": "string",
        "Invoicing__c": "string",
        "IsDeleted": "boolean",
        "Jigsaw": "string",
        "JigsawCompanyId": "string",
        "LastActivityDate": "date",
        "LastModifiedById": "string",
        "LastModifiedDate": "timestamp",
        "LastReferencedDate": "timestamp",
        "LastViewedDate": "timestamp",
        "Last_Contact_Date__c": "date",
        "Last_Date__c": "date",
        "Last_Opportunity_Close__c": "date",
        "Last_Rate_Change__c": "string",
        "Last_Upgrade__c": "date",
        "Lead_Source_Email__c": "string",
        "LinkedIn_URL__c": "string",
        "Location_Code__c": "string",
        "Locations__c": "double",
        "MS_Contact__c": "string",
        "MS_Discontinued_Reason__c": "string",
        "MS_User_is_Me__c": "boolean",
        "Management_Company_Account__c": "string",
        "Marketplace_Approved__c": "boolean",
        "Marketplace_Category__c": "string",
        "MasterRecordId": "string",
        "Merchandise_Tax__c": "double",
        "MerchantServicesNotes__c": "string",
        "Merchant_ID__c": "string",
        "Merchant_Service_Rep__c": "string",
        "Merchant_Services_Account_Status__c": "string",
        "Merchant_Services_DBA_Name__c": "string",
        "Merchant_Services_Date_Closed__c": "date",
        "Merchant_Services_Date_Opened__c": "date",
        "Moved_to_Lead__c": "boolean",
        "NDA_Signed__c": "boolean",
        "Name": "string",
        "National_Check__c": "boolean",
        "National__c": "boolean",
        "Needs__c": "string",
        "New_Salesperson__c": "string",
        "New_Software_Choice__c": "string",
        "New_Support_End__c": "date",
        "New_Support_Start__c": "date",
        "No_Longer_Customer__c": "boolean",
        "Notes__c": "string",
        "NumberOfEmployees": "int",
        "OA_Names__c": "boolean",
        "OA_Parent_State__c": "boolean",
        "OA_State__c": "boolean",
        "Occupancy__c": "string",
        "Offsite_Reporting__c": "string",
        "Old_Salesperson__c": "string",
        "Olivia_Austin__c": "boolean",
        "Online_Listing_Service__c": "string",
        "Open_Activities__c": "boolean",
        "Open_Demand_Opportunities_parent_SF__c": "double",
        "Open_Oppty__c": "double",
        "Operations_Contact__c": "string",
        "Opportunities__c": "double",
        "Other_Industry__c": "string",
        "Other_MS_Discontinued_Reason__c": "string",
        "Out_of_Territory__c": "string",
        "Outlook_Category__c": "string",
        "Outlook_Create_Date__c": "date",
        "OwnerId": "string",
        "Owner_Department__c": "string",
        "Owner_Division__c": "string",
        "Owner_Territory__c": "string",
        "Ownership": "string",
        "PCI_Exceptions__c": "string",
        "ParentId": "string",
        "Parent_Account_Name__c": "string",
        "Parent_Account_Note__c": "string",
        "Parent_Account_Owner_Match__c": "string",
        "Parent_Account_Owner__c": "string",
        "Parent_Account_checkbox__c": "boolean",
        "Parent_City__c": "string",
        "Parent_Country__c": "string",
        "Parent_Locations__c": "double",
        "Parent_National__c": "boolean",
        "Parent_Public_Folder__c": "string",
        "Parent_State__c": "string",
        "Parent_Street__c": "string",
        "Parent_Zip__c": "string",
        "Parent__c": "boolean",
        "Phone": "string",
        "Previous_Sales_Owner__c": "string",
        "Previous_Sales_Rep__c": "string",
        "Previous_Software__c": "string",
        "Product_Interest__c": "string",
        "Product__c": "string",
        "Rating": "string",
        "RecordTypeId": "string",
        "Record_Type_Check__c": "boolean",
        "RedNova__c": "boolean",
        "Region__c": "string",
        "Reseller_Account__c": "string",
        "Returned_SiteLink__c": "boolean",
        "SLPC_Last_Payment_Amount__c": "decimal(16,2)",
        "SLPC_Last_Payment_Auth__c": "string",
        "SLPC_Last_Payment_Check__c": "string",
        "SLPC_Last_Payment_Date__c": "date",
        "SLPC_Last_Purchased_Feature__c": "string",
        "SLPC_Send_to_Corp_Office__c": "double",
        "SLWE_Paid_Thru_Date__c": "date",
        "SMD_Account_ID__c": "string",
        "SS_Names__c": "boolean",
        "SS_Parent_State__c": "boolean",
        "SS_State__c": "boolean",
        "Sales_Activity_10_1_2013__c": "boolean",
        "Sales_Admin__c": "string",
        "Sales_Contact__c": "string",
        "Satisfaction_Indicator__c": "string",
        "Satisfaction_Level__c": "string",
        "Sebastian_Sweeney__c": "boolean",
        "ShippingCity": "string",
        "ShippingCountry": "string",
        "ShippingLatitude": "double",
        "ShippingLongitude": "double",
        "ShippingPostalCode": "string",
        "ShippingState": "string",
        "ShippingStreet": "string",
        "Shipping_Address__c": "string",
        "Sic": "string",
        "SicDesc": "string",
        "Site": "string",
        "SiteLink_eSign__c": "boolean",
        "Site_Contact__c": "string",
        "Source_URL__c": "string",
        "Storage_Type__c": "string",
        "SystemModstamp": "timestamp",
        "Tag_Color__c": "string",
        "Tech_Note__c": "string",
        "Tech_Support_Date__c": "date",
        "Tech_Support_End_Date__c": "date",
        "Tech_Support_Price__c": "decimal(16,2)",
        "Territory_Match__c": "string",
        "Territory_Matches_Txt__c": "string",
        "Territory_Txt__c": "string",
        "Territory__c": "string",
        "TickerSymbol": "string",
        "Timeframe__c": "string",
        "Total_Won_Opportunities__c": "decimal(16,2)",
        "Tradeshows__c": "string",
        "Trial_Expiration__c": "date",
        "Twitter_URL__c": "string",
        "Type": "string",
        "Unit_Rent_Tax_Rate__c": "double",
        "Units_Rented__c": "double",
        "Units__c": "double",
        "Upgrade_Needed__c": "double",
        "Website": "string",
        "YouTube_URL__c": "string",
        "account_url_ms__c": "string",
        "eCommerce_Audit_Completed__c": "string",
        "of_SF_Open_Demand_Opportunities__c": "double"
    },
    "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/Account/2018-10-26/1540582320",
        "key": "raw/Account/2018-10-26/1540582320/file0.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_salesforce.sitelink_Account",
        "type": "salesforce"
    }
}
    • running: False
    • schema_name_id: 561
    • start_time: 2018-10-26 14:32:02
    • success: True
    • trace_id: 4996392427688761962
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "ACH_Account_Status__c": "string",
    "ACH_Provider__c": "string",
    "Access_Anywhere__c": "string",
    "AccountNumber": "string",
    "AccountSource": "string",
    "Account_Classification__c": "string",
    "Account_Note__c": "string",
    "Account_Roll_up_summary__c": "double",
    "Accounting_Software__c": "string",
    "Accounts_Have_SLMS__c": "boolean",
    "AnnualRevenue": "decimal(16,2)",
    "Archive__c": "boolean",
    "BM_Names__c": "boolean",
    "BM_Parent_State__c": "boolean",
    "BM_State__c": "boolean",
    "BillingCity": "string",
    "BillingCountry": "string",
    "BillingLatitude": "double",
    "BillingLongitude": "double",
    "BillingPostalCode": "string",
    "BillingState": "string",
    "BillingStreet": "string",
    "Billing_Address__c": "string",
    "Billing_Currency__c": "string",
    "Billing_Cycle__c": "string",
    "Billing_Entity__c": "string",
    "Bob_Myers__c": "boolean",
    "Buyer_Account__c": "string",
    "CC_Processing__c": "string",
    "CC_Provider__c": "string",
    "Case_Safe_Account_Id__c": "string",
    "Case_Safe_Parent_Account_Id__c": "string",
    "Child_Public_Folder__c": "string",
    "Cirrus_Files_Folder_Name__c": "string",
    "Comments__c": "string",
    "Configuration__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Conversion__c": "boolean",
    "Converted_To_Customer_Date__c": "date",
    "Converted_To_Customer_Onboarding_Date__c": "date",
    "Corp_Code__c": "string",
    "Corp_Loc2__c": "string",
    "Corp_Location__c": "string",
    "CreatedById": "string",
    "CreatedDate": "timestamp",
    "CurrencyIsoCode": "string",
    "Current_Feature_Interest__c": "string",
    "Current_Software__c": "string",
    "Customer_Type__c": "string",
    "Days_Since_Activity__c": "double",
    "Demo_Date_1__c": "date",
    "Demo_Date_2__c": "date",
    "Demo_End_1__c": "string",
    "Demo_End_2__c": "string",
    "Demo_Start_1__c": "string",
    "Demo_Start_2__c": "string",
    "Description": "string",
    "Discontinued_Date__c": "date",
    "Discontinued_Reason__c": "string",
    "Facebook_URL__c": "string",
    "Fax": "string",
    "Fax_Test__c": "double",
    "Gate_System__c": "string",
    "Gateway_ID__c": "string",
    "Google_Maps_Link__c": "string",
    "Google_URL__c": "string",
    "HW_Names__c": "boolean",
    "HW_Parent_State__c": "boolean",
    "HW_State__c": "boolean",
    "Has_Merchant_Opportunity__c": "boolean",
    "Haynes_Willson__c": "boolean",
    "Headquarter_Type__c": "string",
    "Headquartered_Number__c": "string",
    "Hold_Out__c": "boolean",
    "Holly_Call_Campaign_2017__c": "boolean",
    "IGD__Collection_Id__c": "string",
    "Icons__c": "string",
    "Id": "string",
    "Industry": "string",
    "Insurance_Company__c": "string",
    "Insurance_Project_Number__c": "string",
    "Insurance_Tax__c": "double",
    "Internet__c": "string",
    "Invoicing__c": "string",
    "IsDeleted": "boolean",
    "Jigsaw": "string",
    "JigsawCompanyId": "string",
    "LastActivityDate": "date",
    "LastModifiedById": "string",
    "LastModifiedDate": "timestamp",
    "LastReferencedDate": "timestamp",
    "LastViewedDate": "timestamp",
    "Last_Contact_Date__c": "date",
    "Last_Date__c": "date",
    "Last_Opportunity_Close__c": "date",
    "Last_Rate_Change__c": "string",
    "Last_Upgrade__c": "date",
    "Lead_Source_Email__c": "string",
    "LinkedIn_URL__c": "string",
    "Location_Code__c": "string",
    "Locations__c": "double",
    "MS_Contact__c": "string",
    "MS_Discontinued_Reason__c": "string",
    "MS_User_is_Me__c": "boolean",
    "Management_Company_Account__c": "string",
    "Marketplace_Approved__c": "boolean",
    "Marketplace_Category__c": "string",
    "MasterRecordId": "string",
    "Merchandise_Tax__c": "double",
    "MerchantServicesNotes__c": "string",
    "Merchant_ID__c": "string",
    "Merchant_Service_Rep__c": "string",
    "Merchant_Services_Account_Status__c": "string",
    "Merchant_Services_DBA_Name__c": "string",
    "Merchant_Services_Date_Closed__c": "date",
    "Merchant_Services_Date_Opened__c": "date",
    "Moved_to_Lead__c": "boolean",
    "NDA_Signed__c": "boolean",
    "Name": "string",
    "National_Check__c": "boolean",
    "National__c": "boolean",
    "Needs__c": "string",
    "New_Salesperson__c": "string",
    "New_Software_Choice__c": "string",
    "New_Support_End__c": "date",
    "New_Support_Start__c": "date",
    "No_Longer_Customer__c": "boolean",
    "Notes__c": "string",
    "NumberOfEmployees": "int",
    "OA_Names__c": "boolean",
    "OA_Parent_State__c": "boolean",
    "OA_State__c": "boolean",
    "Occupancy__c": "string",
    "Offsite_Reporting__c": "string",
    "Old_Salesperson__c": "string",
    "Olivia_Austin__c": "boolean",
    "Online_Listing_Service__c": "string",
    "Open_Activities__c": "boolean",
    "Open_Demand_Opportunities_parent_SF__c": "double",
    "Open_Oppty__c": "double",
    "Operations_Contact__c": "string",
    "Opportunities__c": "double",
    "Other_Industry__c": "string",
    "Other_MS_Discontinued_Reason__c": "string",
    "Out_of_Territory__c": "string",
    "Outlook_Category__c": "string",
    "Outlook_Create_Date__c": "date",
    "OwnerId": "string",
    "Owner_Department__c": "string",
    "Owner_Division__c": "string",
    "Owner_Territory__c": "string",
    "Ownership": "string",
    "PCI_Exceptions__c": "string",
    "ParentId": "string",
    "Parent_Account_Name__c": "string",
    "Parent_Account_Note__c": "string",
    "Parent_Account_Owner_Match__c": "string",
    "Parent_Account_Owner__c": "string",
    "Parent_Account_checkbox__c": "boolean",
    "Parent_City__c": "string",
    "Parent_Country__c": "string",
    "Parent_Locations__c": "double",
    "Parent_National__c": "boolean",
    "Parent_Public_Folder__c": "string",
    "Parent_State__c": "string",
    "Parent_Street__c": "string",
    "Parent_Zip__c": "string",
    "Parent__c": "boolean",
    "Phone": "string",
    "Previous_Sales_Owner__c": "string",
    "Previous_Sales_Rep__c": "string",
    "Previous_Software__c": "string",
    "Product_Interest__c": "string",
    "Product__c": "string",
    "Rating": "string",
    "RecordTypeId": "string",
    "Record_Type_Check__c": "boolean",
    "RedNova__c": "boolean",
    "Region__c": "string",
    "Reseller_Account__c": "string",
    "Returned_SiteLink__c": "boolean",
    "SLPC_Last_Payment_Amount__c": "decimal(16,2)",
    "SLPC_Last_Payment_Auth__c": "string",
    "SLPC_Last_Payment_Check__c": "string",
    "SLPC_Last_Payment_Date__c": "date",
    "SLPC_Last_Purchased_Feature__c": "string",
    "SLPC_Send_to_Corp_Office__c": "double",
    "SLWE_Paid_Thru_Date__c": "date",
    "SMD_Account_ID__c": "string",
    "SS_Names__c": "boolean",
    "SS_Parent_State__c": "boolean",
    "SS_State__c": "boolean",
    "Sales_Activity_10_1_2013__c": "boolean",
    "Sales_Admin__c": "string",
    "Sales_Contact__c": "string",
    "Satisfaction_Indicator__c": "string",
    "Satisfaction_Level__c": "string",
    "Sebastian_Sweeney__c": "boolean",
    "ShippingCity": "string",
    "ShippingCountry": "string",
    "ShippingLatitude": "double",
    "ShippingLongitude": "double",
    "ShippingPostalCode": "string",
    "ShippingState": "string",
    "ShippingStreet": "string",
    "Shipping_Address__c": "string",
    "Sic": "string",
    "SicDesc": "string",
    "Site": "string",
    "SiteLink_eSign__c": "boolean",
    "Site_Contact__c": "string",
    "Source_URL__c": "string",
    "Storage_Type__c": "string",
    "SystemModstamp": "timestamp",
    "Tag_Color__c": "string",
    "Tech_Note__c": "string",
    "Tech_Support_Date__c": "date",
    "Tech_Support_End_Date__c": "date",
    "Tech_Support_Price__c": "decimal(16,2)",
    "Territory_Match__c": "string",
    "Territory_Matches_Txt__c": "string",
    "Territory_Txt__c": "string",
    "Territory__c": "string",
    "TickerSymbol": "string",
    "Timeframe__c": "string",
    "Total_Won_Opportunities__c": "decimal(16,2)",
    "Tradeshows__c": "string",
    "Trial_Expiration__c": "date",
    "Twitter_URL__c": "string",
    "Type": "string",
    "Unit_Rent_Tax_Rate__c": "double",
    "Units_Rented__c": "double",
    "Units__c": "double",
    "Upgrade_Needed__c": "double",
    "Website": "string",
    "YouTube_URL__c": "string",
    "account_url_ms__c": "string",
    "attributes": "string",
    "eCommerce_Audit_Completed__c": "string",
    "of_SF_Open_Demand_Opportunities__c": "double"
}
  • created: 2018-10-26 14:32:03
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_salesforce`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_salesforce.sitelink_account`\n(\n `ShippingState`  string , `AnnualRevenue`  decimal(16,2) , `of_SF_Open_Demand_Opportunities__c`  double , `Sales_Admin__c`  string , `Corp_Loc2__c`  string , `Case_Safe_Account_Id__c`  string , `Customer_Type__c`  string , `ShippingPostalCode`  string , `Sales_Activity_10_1_2013__c`  boolean , `New_Support_End__c`  date , `National_Check__c`  boolean , `Site_Contact__c`  string , `Billing_Entity__c`  string , `Holly_Call_Campaign_2017__c`  boolean , `Fax`  string , `SLPC_Last_Purchased_Feature__c`  string , `BM_Names__c`  boolean , `SLPC_Send_to_Corp_Office__c`  double , `LinkedIn_URL__c`  string , `New_Salesperson__c`  string , `Parent_Country__c`  string , `BillingState`  string , `Case_Safe_Parent_Account_Id__c`  string , `CurrencyIsoCode`  string , `Discontinued_Date__c`  date , `Parent_Zip__c`  string , `Parent_Account_Owner__c`  string , `IsDeleted`  boolean , `Owner_Territory__c`  string , `Last_Opportunity_Close__c`  date , `Discontinued_Reason__c`  string , `Facebook_URL__c`  string , `Ownership`  string , `Last_Upgrade__c`  date , `Industry`  string , `Configuration__c`  string , `Demo_End_2__c`  string , `Merchant_Services_Date_Opened__c`  date , `Sales_Contact__c`  string , `LastReferencedDate`  timestamp , `Hold_Out__c`  boolean , `Open_Demand_Opportunities_parent_SF__c`  double , `OA_Parent_State__c`  boolean , `Demo_End_1__c`  string , `ACH_Account_Status__c`  string , `Rating`  string , `Parent_Account_Owner_Match__c`  string , `CC_Processing__c`  string , `Territory_Matches_Txt__c`  string , `New_Software_Choice__c`  string , `Units_Rented__c`  double , `SicDesc`  string , `Occupancy__c`  string , `RedNova__c`  boolean , `Last_Rate_Change__c`  string , `SLWE_Paid_Thru_Date__c`  date , `Parent_State__c`  string , `Twitter_URL__c`  string , `Units__c`  double , `No_Longer_Customer__c`  boolean , `Parent_Account_Name__c`  string , `Comments__c`  string , `Other_Industry__c`  string , `Returned_SiteLink__c`  boolean , `Territory__c`  string , `Product__c`  string , `Jigsaw`  string , `Parent__c`  boolean , `LastModifiedById`  string , `JigsawCompanyId`  string , `Corp_Location__c`  string , `MerchantServicesNotes__c`  string , `OwnerId`  string , `Type`  string , `Parent_City__c`  string , `Merchant_Services_Date_Closed__c`  date , `AccountSource`  string , `Offsite_Reporting__c`  string , `Marketplace_Category__c`  string , `Tech_Support_Date__c`  date , `Gate_System__c`  string , `Bob_Myers__c`  boolean , `Fax_Test__c`  double , `Conversion__c`  boolean , `Insurance_Company__c`  string , `Owner_Department__c`  string , `BillingCountry`  string , `Previous_Software__c`  string , `Parent_Public_Folder__c`  string , `Territory_Txt__c`  string , `Outlook_Category__c`  string , `ShippingStreet`  string , `Has_Merchant_Opportunity__c`  boolean , `Previous_Sales_Owner__c`  string , `SLPC_Last_Payment_Check__c`  string , `NDA_Signed__c`  boolean , `Parent_Street__c`  string , `Reseller_Account__c`  string , `Satisfaction_Level__c`  string , `Territory_Match__c`  string , `Account_Roll_up_summary__c`  double , `ParentId`  string , `ShippingCity`  string , `YouTube_URL__c`  string , `Open_Oppty__c`  double , `Region__c`  string , `SLPC_Last_Payment_Auth__c`  string , `Billing_Address__c`  string , `Opportunities__c`  double , `CC_Provider__c`  string , `Online_Listing_Service__c`  string , `AccountNumber`  string , `Tag_Color__c`  string , `Marketplace_Approved__c`  boolean , `MS_User_is_Me__c`  boolean , `Demo_Date_2__c`  date , `HW_Parent_State__c`  boolean , `Insurance_Project_Number__c`  string , `CreatedDate`  timestamp , `attributes`  string , `BillingLongitude`  double , `Invoicing__c`  string , `MS_Discontinued_Reason__c`  string , `MasterRecordId`  string , `Operations_Contact__c`  string , `ShippingLatitude`  double , `New_Support_Start__c`  date , `Tech_Support_End_Date__c`  date , `ShippingCountry`  string , `Last_Date__c`  date , `Satisfaction_Indicator__c`  string , `Shipping_Address__c`  string , `Days_Since_Activity__c`  double , `Accounts_Have_SLMS__c`  boolean , `Storage_Type__c`  string , `Corp_Code__c`  string , `Website`  string , `OA_Names__c`  boolean , `SiteLink_eSign__c`  boolean , `Demo_Date_1__c`  date , `Billing_Currency__c`  string , `Parent_Account_checkbox__c`  boolean , `LastModifiedDate`  timestamp , `Google_URL__c`  string , `Merchant_Services_DBA_Name__c`  string , `Notes__c`  string , `Phone`  string , `Account_Classification__c`  string , `BillingLatitude`  double , `SS_Names__c`  boolean , `ConnectionSentId`  string , `Demo_Start_1__c`  string , `Out_of_Territory__c`  string , `Tech_Note__c`  string , `Locations__c`  double , `Parent_Locations__c`  double , `HW_Names__c`  boolean , `Merchant_Service_Rep__c`  string , `Merchandise_Tax__c`  double , `Demo_Start_2__c`  string , `Upgrade_Needed__c`  double , `Archive__c`  boolean , `Owner_Division__c`  string , `account_url_ms__c`  string , `ShippingLongitude`  double , `Current_Software__c`  string , `Timeframe__c`  string , `SMD_Account_ID__c`  string , `Trial_Expiration__c`  date , `Source_URL__c`  string , `RecordTypeId`  string , `BillingPostalCode`  string , `Converted_To_Customer_Onboarding_Date__c`  date , `Headquarter_Type__c`  string , `Current_Feature_Interest__c`  string , `Outlook_Create_Date__c`  date , `Open_Activities__c`  boolean , `Headquartered_Number__c`  string , `Last_Contact_Date__c`  date , `TickerSymbol`  string , `eCommerce_Audit_Completed__c`  string , `Moved_to_Lead__c`  boolean , `Child_Public_Folder__c`  string , `HW_State__c`  boolean , `MS_Contact__c`  string , `SLPC_Last_Payment_Date__c`  date , `Sic`  string , `SS_State__c`  boolean , `Cirrus_Files_Folder_Name__c`  string , `BM_State__c`  boolean , `Location_Code__c`  string , `Merchant_ID__c`  string , `Tradeshows__c`  string , `Accounting_Software__c`  string , `Account_Note__c`  string , `BillingCity`  string , `Description`  string , `NumberOfEmployees`  int , `Haynes_Willson__c`  boolean , `Unit_Rent_Tax_Rate__c`  double , `BM_Parent_State__c`  boolean , `Product_Interest__c`  string , `CreatedById`  string , `National__c`  boolean , `Previous_Sales_Rep__c`  string , `Google_Maps_Link__c`  string , `SystemModstamp`  timestamp , `LastViewedDate`  timestamp , `Tech_Support_Price__c`  decimal(16,2) , `PCI_Exceptions__c`  string , `Billing_Cycle__c`  string , `Name`  string , `Parent_National__c`  boolean , `Merchant_Services_Account_Status__c`  string , `SS_Parent_State__c`  boolean , `Sebastian_Sweeney__c`  boolean , `BillingStreet`  string , `IGD__Collection_Id__c`  string , `Record_Type_Check__c`  boolean , `Icons__c`  string , `Buyer_Account__c`  string , `ConnectionReceivedId`  string , `Access_Anywhere__c`  string , `Parent_Account_Note__c`  string , `Internet__c`  string , `Old_Salesperson__c`  string , `Lead_Source_Email__c`  string , `Management_Company_Account__c`  string , `Needs__c`  string , `LastActivityDate`  date , `Converted_To_Customer_Date__c`  date , `Site`  string , `Id`  string , `OA_State__c`  boolean , `Other_MS_Discontinued_Reason__c`  string , `Olivia_Austin__c`  boolean , `ACH_Provider__c`  string , `Insurance_Tax__c`  double , `Total_Won_Opportunities__c`  decimal(16,2) , `Gateway_ID__c`  string , `SLPC_Last_Payment_Amount__c`  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/Account/2018-10-26/1540582320'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_salesforce.sitelink_account`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_salesforce.sitelink_account"
}
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:32:02",
        "disabled": false,
        "format": "raw",
        "id": 561,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_salesforce",
            "table": "sitelink_account"
        },
        "type": "salesforce"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "ACH_Account_Status__c": "string",
            "ACH_Provider__c": "string",
            "Access_Anywhere__c": "string",
            "AccountNumber": "string",
            "AccountSource": "string",
            "Account_Classification__c": "string",
            "Account_Note__c": "string",
            "Account_Roll_up_summary__c": "double",
            "Accounting_Software__c": "string",
            "Accounts_Have_SLMS__c": "boolean",
            "AnnualRevenue": "decimal(16,2)",
            "Archive__c": "boolean",
            "BM_Names__c": "boolean",
            "BM_Parent_State__c": "boolean",
            "BM_State__c": "boolean",
            "BillingCity": "string",
            "BillingCountry": "string",
            "BillingLatitude": "double",
            "BillingLongitude": "double",
            "BillingPostalCode": "string",
            "BillingState": "string",
            "BillingStreet": "string",
            "Billing_Address__c": "string",
            "Billing_Currency__c": "string",
            "Billing_Cycle__c": "string",
            "Billing_Entity__c": "string",
            "Bob_Myers__c": "boolean",
            "Buyer_Account__c": "string",
            "CC_Processing__c": "string",
            "CC_Provider__c": "string",
            "Case_Safe_Account_Id__c": "string",
            "Case_Safe_Parent_Account_Id__c": "string",
            "Child_Public_Folder__c": "string",
            "Cirrus_Files_Folder_Name__c": "string",
            "Comments__c": "string",
            "Configuration__c": "string",
            "ConnectionReceivedId": "string",
            "ConnectionSentId": "string",
            "Conversion__c": "boolean",
            "Converted_To_Customer_Date__c": "date",
            "Converted_To_Customer_Onboarding_Date__c": "date",
            "Corp_Code__c": "string",
            "Corp_Loc2__c": "string",
            "Corp_Location__c": "string",
            "CreatedById": "string",
            "CreatedDate": "timestamp",
            "CurrencyIsoCode": "string",
            "Current_Feature_Interest__c": "string",
            "Current_Software__c": "string",
            "Customer_Type__c": "string",
            "Days_Since_Activity__c": "double",
            "Demo_Date_1__c": "date",
            "Demo_Date_2__c": "date",
            "Demo_End_1__c": "string",
            "Demo_End_2__c": "string",
            "Demo_Start_1__c": "string",
            "Demo_Start_2__c": "string",
            "Description": "string",
            "Discontinued_Date__c": "date",
            "Discontinued_Reason__c": "string",
            "Facebook_URL__c": "string",
            "Fax": "string",
            "Fax_Test__c": "double",
            "Gate_System__c": "string",
            "Gateway_ID__c": "string",
            "Google_Maps_Link__c": "string",
            "Google_URL__c": "string",
            "HW_Names__c": "boolean",
            "HW_Parent_State__c": "boolean",
            "HW_State__c": "boolean",
            "Has_Merchant_Opportunity__c": "boolean",
            "Haynes_Willson__c": "boolean",
            "Headquarter_Type__c": "string",
            "Headquartered_Number__c": "string",
            "Hold_Out__c": "boolean",
            "Holly_Call_Campaign_2017__c": "boolean",
            "IGD__Collection_Id__c": "string",
            "Icons__c": "string",
            "Id": "string",
            "Industry": "string",
            "Insurance_Company__c": "string",
            "Insurance_Project_Number__c": "string",
            "Insurance_Tax__c": "double",
            "Internet__c": "string",
            "Invoicing__c": "string",
            "IsDeleted": "boolean",
            "Jigsaw": "string",
            "JigsawCompanyId": "string",
            "LastActivityDate": "date",
            "LastModifiedById": "string",
            "LastModifiedDate": "timestamp",
            "LastReferencedDate": "timestamp",
            "LastViewedDate": "timestamp",
            "Last_Contact_Date__c": "date",
            "Last_Date__c": "date",
            "Last_Opportunity_Close__c": "date",
            "Last_Rate_Change__c": "string",
            "Last_Upgrade__c": "date",
            "Lead_Source_Email__c": "string",
            "LinkedIn_URL__c": "string",
            "Location_Code__c": "string",
            "Locations__c": "double",
            "MS_Contact__c": "string",
            "MS_Discontinued_Reason__c": "string",
            "MS_User_is_Me__c": "boolean",
            "Management_Company_Account__c": "string",
            "Marketplace_Approved__c": "boolean",
            "Marketplace_Category__c": "string",
            "MasterRecordId": "string",
            "Merchandise_Tax__c": "double",
            "MerchantServicesNotes__c": "string",
            "Merchant_ID__c": "string",
            "Merchant_Service_Rep__c": "string",
            "Merchant_Services_Account_Status__c": "string",
            "Merchant_Services_DBA_Name__c": "string",
            "Merchant_Services_Date_Closed__c": "date",
            "Merchant_Services_Date_Opened__c": "date",
            "Moved_to_Lead__c": "boolean",
            "NDA_Signed__c": "boolean",
            "Name": "string",
            "National_Check__c": "boolean",
            "National__c": "boolean",
            "Needs__c": "string",
            "New_Salesperson__c": "string",
            "New_Software_Choice__c": "string",
            "New_Support_End__c": "date",
            "New_Support_Start__c": "date",
            "No_Longer_Customer__c": "boolean",
            "Notes__c": "string",
            "NumberOfEmployees": "int",
            "OA_Names__c": "boolean",
            "OA_Parent_State__c": "boolean",
            "OA_State__c": "boolean",
            "Occupancy__c": "string",
            "Offsite_Reporting__c": "string",
            "Old_Salesperson__c": "string",
            "Olivia_Austin__c": "boolean",
            "Online_Listing_Service__c": "string",
            "Open_Activities__c": "boolean",
            "Open_Demand_Opportunities_parent_SF__c": "double",
            "Open_Oppty__c": "double",
            "Operations_Contact__c": "string",
            "Opportunities__c": "double",
            "Other_Industry__c": "string",
            "Other_MS_Discontinued_Reason__c": "string",
            "Out_of_Territory__c": "string",
            "Outlook_Category__c": "string",
            "Outlook_Create_Date__c": "date",
            "OwnerId": "string",
            "Owner_Department__c": "string",
            "Owner_Division__c": "string",
            "Owner_Territory__c": "string",
            "Ownership": "string",
            "PCI_Exceptions__c": "string",
            "ParentId": "string",
            "Parent_Account_Name__c": "string",
            "Parent_Account_Note__c": "string",
            "Parent_Account_Owner_Match__c": "string",
            "Parent_Account_Owner__c": "string",
            "Parent_Account_checkbox__c": "boolean",
            "Parent_City__c": "string",
            "Parent_Country__c": "string",
            "Parent_Locations__c": "double",
            "Parent_National__c": "boolean",
            "Parent_Public_Folder__c": "string",
            "Parent_State__c": "string",
            "Parent_Street__c": "string",
            "Parent_Zip__c": "string",
            "Parent__c": "boolean",
            "Phone": "string",
            "Previous_Sales_Owner__c": "string",
            "Previous_Sales_Rep__c": "string",
            "Previous_Software__c": "string",
            "Product_Interest__c": "string",
            "Product__c": "string",
            "Rating": "string",
            "RecordTypeId": "string",
            "Record_Type_Check__c": "boolean",
            "RedNova__c": "boolean",
            "Region__c": "string",
            "Reseller_Account__c": "string",
            "Returned_SiteLink__c": "boolean",
            "SLPC_Last_Payment_Amount__c": "decimal(16,2)",
            "SLPC_Last_Payment_Auth__c": "string",
            "SLPC_Last_Payment_Check__c": "string",
            "SLPC_Last_Payment_Date__c": "date",
            "SLPC_Last_Purchased_Feature__c": "string",
            "SLPC_Send_to_Corp_Office__c": "double",
            "SLWE_Paid_Thru_Date__c": "date",
            "SMD_Account_ID__c": "string",
            "SS_Names__c": "boolean",
            "SS_Parent_State__c": "boolean",
            "SS_State__c": "boolean",
            "Sales_Activity_10_1_2013__c": "boolean",
            "Sales_Admin__c": "string",
            "Sales_Contact__c": "string",
            "Satisfaction_Indicator__c": "string",
            "Satisfaction_Level__c": "string",
            "Sebastian_Sweeney__c": "boolean",
            "ShippingCity": "string",
            "ShippingCountry": "string",
            "ShippingLatitude": "double",
            "ShippingLongitude": "double",
            "ShippingPostalCode": "string",
            "ShippingState": "string",
            "ShippingStreet": "string",
            "Shipping_Address__c": "string",
            "Sic": "string",
            "SicDesc": "string",
            "Site": "string",
            "SiteLink_eSign__c": "boolean",
            "Site_Contact__c": "string",
            "Source_URL__c": "string",
            "Storage_Type__c": "string",
            "SystemModstamp": "timestamp",
            "Tag_Color__c": "string",
            "Tech_Note__c": "string",
            "Tech_Support_Date__c": "date",
            "Tech_Support_End_Date__c": "date",
            "Tech_Support_Price__c": "decimal(16,2)",
            "Territory_Match__c": "string",
            "Territory_Matches_Txt__c": "string",
            "Territory_Txt__c": "string",
            "Territory__c": "string",
            "TickerSymbol": "string",
            "Timeframe__c": "string",
            "Total_Won_Opportunities__c": "decimal(16,2)",
            "Tradeshows__c": "string",
            "Trial_Expiration__c": "date",
            "Twitter_URL__c": "string",
            "Type": "string",
            "Unit_Rent_Tax_Rate__c": "double",
            "Units_Rented__c": "double",
            "Units__c": "double",
            "Upgrade_Needed__c": "double",
            "Website": "string",
            "YouTube_URL__c": "string",
            "account_url_ms__c": "string",
            "attributes": "string",
            "eCommerce_Audit_Completed__c": "string",
            "of_SF_Open_Demand_Opportunities__c": "double"
        },
        "created": "2018-10-26 14:32:03",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_salesforce`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_salesforce.sitelink_account`\n(\n `ShippingState`  string , `AnnualRevenue`  decimal(16,2) , `of_SF_Open_Demand_Opportunities__c`  double , `Sales_Admin__c`  string , `Corp_Loc2__c`  string , `Case_Safe_Account_Id__c`  string , `Customer_Type__c`  string , `ShippingPostalCode`  string , `Sales_Activity_10_1_2013__c`  boolean , `New_Support_End__c`  date , `National_Check__c`  boolean , `Site_Contact__c`  string , `Billing_Entity__c`  string , `Holly_Call_Campaign_2017__c`  boolean , `Fax`  string , `SLPC_Last_Purchased_Feature__c`  string , `BM_Names__c`  boolean , `SLPC_Send_to_Corp_Office__c`  double , `LinkedIn_URL__c`  string , `New_Salesperson__c`  string , `Parent_Country__c`  string , `BillingState`  string , `Case_Safe_Parent_Account_Id__c`  string , `CurrencyIsoCode`  string , `Discontinued_Date__c`  date , `Parent_Zip__c`  string , `Parent_Account_Owner__c`  string , `IsDeleted`  boolean , `Owner_Territory__c`  string , `Last_Opportunity_Close__c`  date , `Discontinued_Reason__c`  string , `Facebook_URL__c`  string , `Ownership`  string , `Last_Upgrade__c`  date , `Industry`  string , `Configuration__c`  string , `Demo_End_2__c`  string , `Merchant_Services_Date_Opened__c`  date , `Sales_Contact__c`  string , `LastReferencedDate`  timestamp , `Hold_Out__c`  boolean , `Open_Demand_Opportunities_parent_SF__c`  double , `OA_Parent_State__c`  boolean , `Demo_End_1__c`  string , `ACH_Account_Status__c`  string , `Rating`  string , `Parent_Account_Owner_Match__c`  string , `CC_Processing__c`  string , `Territory_Matches_Txt__c`  string , `New_Software_Choice__c`  string , `Units_Rented__c`  double , `SicDesc`  string , `Occupancy__c`  string , `RedNova__c`  boolean , `Last_Rate_Change__c`  string , `SLWE_Paid_Thru_Date__c`  date , `Parent_State__c`  string , `Twitter_URL__c`  string , `Units__c`  double , `No_Longer_Customer__c`  boolean , `Parent_Account_Name__c`  string , `Comments__c`  string , `Other_Industry__c`  string , `Returned_SiteLink__c`  boolean , `Territory__c`  string , `Product__c`  string , `Jigsaw`  string , `Parent__c`  boolean , `LastModifiedById`  string , `JigsawCompanyId`  string , `Corp_Location__c`  string , `MerchantServicesNotes__c`  string , `OwnerId`  string , `Type`  string , `Parent_City__c`  string , `Merchant_Services_Date_Closed__c`  date , `AccountSource`  string , `Offsite_Reporting__c`  string , `Marketplace_Category__c`  string , `Tech_Support_Date__c`  date , `Gate_System__c`  string , `Bob_Myers__c`  boolean , `Fax_Test__c`  double , `Conversion__c`  boolean , `Insurance_Company__c`  string , `Owner_Department__c`  string , `BillingCountry`  string , `Previous_Software__c`  string , `Parent_Public_Folder__c`  string , `Territory_Txt__c`  string , `Outlook_Category__c`  string , `ShippingStreet`  string , `Has_Merchant_Opportunity__c`  boolean , `Previous_Sales_Owner__c`  string , `SLPC_Last_Payment_Check__c`  string , `NDA_Signed__c`  boolean , `Parent_Street__c`  string , `Reseller_Account__c`  string , `Satisfaction_Level__c`  string , `Territory_Match__c`  string , `Account_Roll_up_summary__c`  double , `ParentId`  string , `ShippingCity`  string , `YouTube_URL__c`  string , `Open_Oppty__c`  double , `Region__c`  string , `SLPC_Last_Payment_Auth__c`  string , `Billing_Address__c`  string , `Opportunities__c`  double , `CC_Provider__c`  string , `Online_Listing_Service__c`  string , `AccountNumber`  string , `Tag_Color__c`  string , `Marketplace_Approved__c`  boolean , `MS_User_is_Me__c`  boolean , `Demo_Date_2__c`  date , `HW_Parent_State__c`  boolean , `Insurance_Project_Number__c`  string , `CreatedDate`  timestamp , `attributes`  string , `BillingLongitude`  double , `Invoicing__c`  string , `MS_Discontinued_Reason__c`  string , `MasterRecordId`  string , `Operations_Contact__c`  string , `ShippingLatitude`  double , `New_Support_Start__c`  date , `Tech_Support_End_Date__c`  date , `ShippingCountry`  string , `Last_Date__c`  date , `Satisfaction_Indicator__c`  string , `Shipping_Address__c`  string , `Days_Since_Activity__c`  double , `Accounts_Have_SLMS__c`  boolean , `Storage_Type__c`  string , `Corp_Code__c`  string , `Website`  string , `OA_Names__c`  boolean , `SiteLink_eSign__c`  boolean , `Demo_Date_1__c`  date , `Billing_Currency__c`  string , `Parent_Account_checkbox__c`  boolean , `LastModifiedDate`  timestamp , `Google_URL__c`  string , `Merchant_Services_DBA_Name__c`  string , `Notes__c`  string , `Phone`  string , `Account_Classification__c`  string , `BillingLatitude`  double , `SS_Names__c`  boolean , `ConnectionSentId`  string , `Demo_Start_1__c`  string , `Out_of_Territory__c`  string , `Tech_Note__c`  string , `Locations__c`  double , `Parent_Locations__c`  double , `HW_Names__c`  boolean , `Merchant_Service_Rep__c`  string , `Merchandise_Tax__c`  double , `Demo_Start_2__c`  string , `Upgrade_Needed__c`  double , `Archive__c`  boolean , `Owner_Division__c`  string , `account_url_ms__c`  string , `ShippingLongitude`  double , `Current_Software__c`  string , `Timeframe__c`  string , `SMD_Account_ID__c`  string , `Trial_Expiration__c`  date , `Source_URL__c`  string , `RecordTypeId`  string , `BillingPostalCode`  string , `Converted_To_Customer_Onboarding_Date__c`  date , `Headquarter_Type__c`  string , `Current_Feature_Interest__c`  string , `Outlook_Create_Date__c`  date , `Open_Activities__c`  boolean , `Headquartered_Number__c`  string , `Last_Contact_Date__c`  date , `TickerSymbol`  string , `eCommerce_Audit_Completed__c`  string , `Moved_to_Lead__c`  boolean , `Child_Public_Folder__c`  string , `HW_State__c`  boolean , `MS_Contact__c`  string , `SLPC_Last_Payment_Date__c`  date , `Sic`  string , `SS_State__c`  boolean , `Cirrus_Files_Folder_Name__c`  string , `BM_State__c`  boolean , `Location_Code__c`  string , `Merchant_ID__c`  string , `Tradeshows__c`  string , `Accounting_Software__c`  string , `Account_Note__c`  string , `BillingCity`  string , `Description`  string , `NumberOfEmployees`  int , `Haynes_Willson__c`  boolean , `Unit_Rent_Tax_Rate__c`  double , `BM_Parent_State__c`  boolean , `Product_Interest__c`  string , `CreatedById`  string , `National__c`  boolean , `Previous_Sales_Rep__c`  string , `Google_Maps_Link__c`  string , `SystemModstamp`  timestamp , `LastViewedDate`  timestamp , `Tech_Support_Price__c`  decimal(16,2) , `PCI_Exceptions__c`  string , `Billing_Cycle__c`  string , `Name`  string , `Parent_National__c`  boolean , `Merchant_Services_Account_Status__c`  string , `SS_Parent_State__c`  boolean , `Sebastian_Sweeney__c`  boolean , `BillingStreet`  string , `IGD__Collection_Id__c`  string , `Record_Type_Check__c`  boolean , `Icons__c`  string , `Buyer_Account__c`  string , `ConnectionReceivedId`  string , `Access_Anywhere__c`  string , `Parent_Account_Note__c`  string , `Internet__c`  string , `Old_Salesperson__c`  string , `Lead_Source_Email__c`  string , `Management_Company_Account__c`  string , `Needs__c`  string , `LastActivityDate`  date , `Converted_To_Customer_Date__c`  date , `Site`  string , `Id`  string , `OA_State__c`  boolean , `Other_MS_Discontinued_Reason__c`  string , `Olivia_Austin__c`  boolean , `ACH_Provider__c`  string , `Insurance_Tax__c`  double , `Total_Won_Opportunities__c`  decimal(16,2) , `Gateway_ID__c`  string , `SLPC_Last_Payment_Amount__c`  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/Account/2018-10-26/1540582320'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_salesforce.sitelink_account`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_salesforce.sitelink_account"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform