Schema Info

Schema Name: sfdl_dev_salesforce.sitelink_contact

created: 2018-10-25 16:37:42
disabled: False
format: raw
id: 1069
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_dev_salesforce",
    "table": "sitelink_contact"
}

type: salesforce

Schema Versions: 2

Version 4662736

created: 2018-10-26 13:46:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_salesforce`",
    "DROP TABLE IF EXISTS `sfdl_dev_salesforce.sitelink_contact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_salesforce.sitelink_contact`\n(\n `MailingPostalCode`  string , `Title`  string , `pi__utm_medium__c`  string , `sales_contact__c`  boolean , `Department`  string , `MailingState`  string , `Fax`  string , `MailingLatitude`  double , `pi__utm_campaign__c`  string , `pi__first_search_term__c`  string , `OtherLongitude`  double , `Marketing__c`  string , `CurrencyIsoCode`  string , `rh2__Currency_Test__c`  decimal(16,2) , `IsDeleted`  boolean , `AccountId`  string , `Sent_to_SpareFoot__c`  boolean , `Email_3__c`  string , `LastReferencedDate`  timestamp , `Marketing_Contact_Method__c`  string , `Current_User_Email__c`  string , `MobilePhone`  string , `Email_1__c`  string , `Receives_Reporting_API__c`  boolean , `Sparefoot_Lead_Sent__c`  date , `OtherCity`  string , `pi__score__c`  double , `LastCUUpdateDate`  timestamp , `Account_Owner__c`  string , `Technical_Contact__c`  boolean , `Email_2__c`  string , `New_Email__c`  string , `pi__campaign__c`  string , `JigsawContactId`  string , `Jigsaw`  string , `LastModifiedById`  string , `EmailBouncedReason`  string , `OwnerId`  string , `utm_source__c`  string , `Email`  string , `Attended__c`  string , `pi__pardot_hard_bounced__c`  boolean , `pi__utm_content__c`  string , `Corp_Loc__c`  string , `pi__url__c`  string , `MailingLongitude`  double , `OtherPostalCode`  string , `pi__notes__c`  string , `TIMBASURVEYS__Survey__c`  string , `MailingCountry`  string , `No_Longer_with_Company__c`  boolean , `Authority__c`  string , `NDA_Signed__c`  boolean , `ContactId__c`  string , `Middle_Name__c`  string , `AccountId__c`  string , `Full_Name__c`  string , `Loc_Code__c`  string , `utm_campaign__c`  string , `utm_keyword__c`  string , `SystemModstamp`  timestamp , `CreatedDate`  timestamp , `Do_Not_Mail__c`  boolean , `attributes`  string , `DoNotCall`  boolean , `rh2__Formula_Test__c`  decimal(16,2) , `OtherStreet`  string , `MasterRecordId`  string , `FirstName`  string , `LastName`  string , `OtherLatitude`  double , `pi__last_activity__c`  timestamp , `MS_Contact__c`  boolean , `Receives_Call_Center_API__c`  boolean , `pi__conversion_date__c`  timestamp , `AssistantPhone`  string , `Corp_Code__c`  string , `pi__conversion_object_type__c`  string , `LastModifiedDate`  timestamp , `pi__first_search_type__c`  string , `AssistantName`  string , `Phone`  string , `HasOptedOutOfEmail`  boolean , `HasOptedOutOfFax`  boolean , `ConnectionSentId`  string , `LastCURequestDate`  timestamp , `Parent_Account_Owner_Alias__c`  string , `business_owner_checkbox__c`  boolean , `Account_Owner_Match__c`  string , `MailingStreet`  string , `OtherCountry`  string , `utm_ad__c`  string , `EmailBouncedDate`  timestamp , `pi__utm_term__c`  string , `Birthdate`  date , `pi__comments__c`  string , `OtherState`  string , `pi__utm_source__c`  string , `pi__first_touch_url__c`  string , `pi__Needs_Score_Synced__c`  boolean , `rh2__Integer_Test__c`  double , `Current_Feature_Interest__c`  string , `Home_Phone_1__c`  string , `OtherPhone`  string , `Contact_Outlook_Category__c`  string , `ReportsToId`  string , `Web_Comments__c`  string , `IsEmailBounced`  boolean , `pi__grade__c`  string , `Description`  string , `rh2__Describe__c`  string , `CreatedById`  string , `pi__conversion_object_name__c`  string , `LastViewedDate`  timestamp , `Address_Type__c`  string , `pi__created_date__c`  timestamp , `Name`  string , `MailingCity`  string , `pi__Pardot_Last_Scored_At__c`  timestamp , `IGD__Collection_Id__c`  string , `LeadSource`  string , `ConnectionReceivedId`  string , `pi__first_activity__c`  timestamp , `Receives_SOC_1_Type_2_Report__c`  boolean , `Needs__c`  string , `LastActivityDate`  date , `Salutation`  string , `Sent_to_SpareFoot_By__c`  string , `Id`  string , `HomePhone`  string \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-dev/raw/Contact/2018-10-26/1540579613'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_salesforce.sitelink_contact"
]

hive_path: s3://sfdl-salesforce-sitelink-dev/raw/Contact/2018-10-26/1540579613
id: 4662736
processed: 1

raw_data:

{
    "AccountId": 15,
    "AccountId__c": 55,
    "Account_Owner_Match__c": 88,
    "Account_Owner__c": 28,
    "Address_Type__c": 114,
    "AssistantName": 80,
    "AssistantPhone": 75,
    "Attended__c": 40,
    "Authority__c": 51,
    "Birthdate": 94,
    "ConnectionReceivedId": 121,
    "ConnectionSentId": 84,
    "ContactId__c": 53,
    "Contact_Outlook_Category__c": 104,
    "Corp_Code__c": 76,
    "Corp_Loc__c": 43,
    "CreatedById": 111,
    "CreatedDate": 61,
    "CurrencyIsoCode": 12,
    "Current_Feature_Interest__c": 101,
    "Current_User_Email__c": 20,
    "Department": 4,
    "Description": 109,
    "DoNotCall": 64,
    "Do_Not_Mail__c": 62,
    "Email": 39,
    "EmailBouncedDate": 92,
    "EmailBouncedReason": 36,
    "Email_1__c": 22,
    "Email_2__c": 30,
    "Email_3__c": 17,
    "Fax": 6,
    "FirstName": 68,
    "Full_Name__c": 56,
    "HasOptedOutOfEmail": 82,
    "HasOptedOutOfFax": 83,
    "HomePhone": 129,
    "Home_Phone_1__c": 102,
    "IGD__Collection_Id__c": 119,
    "Id": 128,
    "IsDeleted": 14,
    "IsEmailBounced": 107,
    "Jigsaw": 34,
    "JigsawContactId": 33,
    "LastActivityDate": 125,
    "LastCURequestDate": 85,
    "LastCUUpdateDate": 27,
    "LastModifiedById": 35,
    "LastModifiedDate": 78,
    "LastName": 69,
    "LastReferencedDate": 18,
    "LastViewedDate": 113,
    "LeadSource": 120,
    "Loc_Code__c": 57,
    "MS_Contact__c": 72,
    "MailingCity": 117,
    "MailingCountry": 49,
    "MailingLatitude": 7,
    "MailingLongitude": 45,
    "MailingPostalCode": 0,
    "MailingState": 5,
    "MailingStreet": 89,
    "Marketing_Contact_Method__c": 19,
    "Marketing__c": 11,
    "MasterRecordId": 67,
    "Middle_Name__c": 54,
    "MobilePhone": 21,
    "NDA_Signed__c": 52,
    "Name": 116,
    "Needs__c": 124,
    "New_Email__c": 31,
    "No_Longer_with_Company__c": 50,
    "OtherCity": 25,
    "OtherCountry": 90,
    "OtherLatitude": 70,
    "OtherLongitude": 10,
    "OtherPhone": 103,
    "OtherPostalCode": 46,
    "OtherState": 96,
    "OtherStreet": 66,
    "OwnerId": 37,
    "Parent_Account_Owner_Alias__c": 86,
    "Phone": 81,
    "Receives_Call_Center_API__c": 73,
    "Receives_Reporting_API__c": 23,
    "Receives_SOC_1_Type_2_Report__c": 123,
    "ReportsToId": 105,
    "Salutation": 126,
    "Sent_to_SpareFoot_By__c": 127,
    "Sent_to_SpareFoot__c": 16,
    "Sparefoot_Lead_Sent__c": 24,
    "SystemModstamp": 60,
    "TIMBASURVEYS__Survey__c": 48,
    "Technical_Contact__c": 29,
    "Title": 1,
    "Web_Comments__c": 106,
    "attributes": 63,
    "business_owner_checkbox__c": 87,
    "pi__Needs_Score_Synced__c": 99,
    "pi__Pardot_Last_Scored_At__c": 118,
    "pi__campaign__c": 32,
    "pi__comments__c": 95,
    "pi__conversion_date__c": 74,
    "pi__conversion_object_name__c": 112,
    "pi__conversion_object_type__c": 77,
    "pi__created_date__c": 115,
    "pi__first_activity__c": 122,
    "pi__first_search_term__c": 9,
    "pi__first_search_type__c": 79,
    "pi__first_touch_url__c": 98,
    "pi__grade__c": 108,
    "pi__last_activity__c": 71,
    "pi__notes__c": 47,
    "pi__pardot_hard_bounced__c": 41,
    "pi__score__c": 26,
    "pi__url__c": 44,
    "pi__utm_campaign__c": 8,
    "pi__utm_content__c": 42,
    "pi__utm_medium__c": 2,
    "pi__utm_source__c": 97,
    "pi__utm_term__c": 93,
    "rh2__Currency_Test__c": 13,
    "rh2__Describe__c": 110,
    "rh2__Formula_Test__c": 65,
    "rh2__Integer_Test__c": 100,
    "sales_contact__c": 3,
    "utm_ad__c": 91,
    "utm_campaign__c": 58,
    "utm_keyword__c": 59,
    "utm_source__c": 38
}

schema_attributes:

{
    "AccountId": "string",
    "AccountId__c": "string",
    "Account_Owner_Match__c": "string",
    "Account_Owner__c": "string",
    "Address_Type__c": "string",
    "AssistantName": "string",
    "AssistantPhone": "string",
    "Attended__c": "string",
    "Authority__c": "string",
    "Birthdate": "date",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactId__c": "string",
    "Contact_Outlook_Category__c": "string",
    "Corp_Code__c": "string",
    "Corp_Loc__c": "string",
    "CreatedById": "string",
    "CreatedDate": "timestamp",
    "CurrencyIsoCode": "string",
    "Current_Feature_Interest__c": "string",
    "Current_User_Email__c": "string",
    "Department": "string",
    "Description": "string",
    "DoNotCall": "boolean",
    "Do_Not_Mail__c": "boolean",
    "Email": "string",
    "EmailBouncedDate": "timestamp",
    "EmailBouncedReason": "string",
    "Email_1__c": "string",
    "Email_2__c": "string",
    "Email_3__c": "string",
    "Fax": "string",
    "FirstName": "string",
    "Full_Name__c": "string",
    "HasOptedOutOfEmail": "boolean",
    "HasOptedOutOfFax": "boolean",
    "HomePhone": "string",
    "Home_Phone_1__c": "string",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "IsDeleted": "boolean",
    "IsEmailBounced": "boolean",
    "Jigsaw": "string",
    "JigsawContactId": "string",
    "LastActivityDate": "date",
    "LastCURequestDate": "timestamp",
    "LastCUUpdateDate": "timestamp",
    "LastModifiedById": "string",
    "LastModifiedDate": "timestamp",
    "LastName": "string",
    "LastReferencedDate": "timestamp",
    "LastViewedDate": "timestamp",
    "LeadSource": "string",
    "Loc_Code__c": "string",
    "MS_Contact__c": "boolean",
    "MailingCity": "string",
    "MailingCountry": "string",
    "MailingLatitude": "double",
    "MailingLongitude": "double",
    "MailingPostalCode": "string",
    "MailingState": "string",
    "MailingStreet": "string",
    "Marketing_Contact_Method__c": "string",
    "Marketing__c": "string",
    "MasterRecordId": "string",
    "Middle_Name__c": "string",
    "MobilePhone": "string",
    "NDA_Signed__c": "boolean",
    "Name": "string",
    "Needs__c": "string",
    "New_Email__c": "string",
    "No_Longer_with_Company__c": "boolean",
    "OtherCity": "string",
    "OtherCountry": "string",
    "OtherLatitude": "double",
    "OtherLongitude": "double",
    "OtherPhone": "string",
    "OtherPostalCode": "string",
    "OtherState": "string",
    "OtherStreet": "string",
    "OwnerId": "string",
    "Parent_Account_Owner_Alias__c": "string",
    "Phone": "string",
    "Receives_Call_Center_API__c": "boolean",
    "Receives_Reporting_API__c": "boolean",
    "Receives_SOC_1_Type_2_Report__c": "boolean",
    "ReportsToId": "string",
    "Salutation": "string",
    "Sent_to_SpareFoot_By__c": "string",
    "Sent_to_SpareFoot__c": "boolean",
    "Sparefoot_Lead_Sent__c": "date",
    "SystemModstamp": "timestamp",
    "TIMBASURVEYS__Survey__c": "string",
    "Technical_Contact__c": "boolean",
    "Title": "string",
    "Web_Comments__c": "string",
    "attributes": "string",
    "business_owner_checkbox__c": "boolean",
    "pi__Needs_Score_Synced__c": "boolean",
    "pi__Pardot_Last_Scored_At__c": "timestamp",
    "pi__campaign__c": "string",
    "pi__comments__c": "string",
    "pi__conversion_date__c": "timestamp",
    "pi__conversion_object_name__c": "string",
    "pi__conversion_object_type__c": "string",
    "pi__created_date__c": "timestamp",
    "pi__first_activity__c": "timestamp",
    "pi__first_search_term__c": "string",
    "pi__first_search_type__c": "string",
    "pi__first_touch_url__c": "string",
    "pi__grade__c": "string",
    "pi__last_activity__c": "timestamp",
    "pi__notes__c": "string",
    "pi__pardot_hard_bounced__c": "boolean",
    "pi__score__c": "double",
    "pi__url__c": "string",
    "pi__utm_campaign__c": "string",
    "pi__utm_content__c": "string",
    "pi__utm_medium__c": "string",
    "pi__utm_source__c": "string",
    "pi__utm_term__c": "string",
    "rh2__Currency_Test__c": "decimal(16,2)",
    "rh2__Describe__c": "string",
    "rh2__Formula_Test__c": "decimal(16,2)",
    "rh2__Integer_Test__c": "double",
    "sales_contact__c": "boolean",
    "utm_ad__c": "string",
    "utm_campaign__c": "string",
    "utm_keyword__c": "string",
    "utm_source__c": "string"
}

schema_name_id: 1069
schema_scan_id: 4229339
updated: 2018-10-26 13:47:06

Version 4662722

created: 2018-10-25 16:37:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_salesforce`",
    "DROP TABLE IF EXISTS `sfdl_dev_salesforce.sitelink_contact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_salesforce.sitelink_contact`\n(\n `MailingPostalCode`  string , `Title`  string , `pi__utm_medium__c`  string , `sales_contact__c`  boolean , `Department`  string , `MailingState`  string , `Fax`  string , `MailingLatitude`  double , `pi__utm_campaign__c`  string , `pi__first_search_term__c`  string , `OtherLongitude`  double , `Marketing__c`  string , `CurrencyIsoCode`  string , `rh2__Currency_Test__c`  decimal(16,2) , `IsDeleted`  boolean , `AccountId`  string , `Sent_to_SpareFoot__c`  boolean , `Email_3__c`  string , `LastReferencedDate`  timestamp , `Marketing_Contact_Method__c`  string , `Current_User_Email__c`  string , `MobilePhone`  string , `Email_1__c`  string , `Receives_Reporting_API__c`  boolean , `Sparefoot_Lead_Sent__c`  date , `OtherCity`  string , `pi__score__c`  double , `LastCUUpdateDate`  timestamp , `Account_Owner__c`  string , `Technical_Contact__c`  boolean , `Email_2__c`  string , `New_Email__c`  string , `pi__campaign__c`  string , `JigsawContactId`  string , `Jigsaw`  string , `LastModifiedById`  string , `EmailBouncedReason`  string , `OwnerId`  string , `utm_source__c`  string , `Email`  string , `Attended__c`  string , `pi__pardot_hard_bounced__c`  boolean , `pi__utm_content__c`  string , `Corp_Loc__c`  string , `pi__url__c`  string , `MailingLongitude`  double , `OtherPostalCode`  string , `pi__notes__c`  string , `TIMBASURVEYS__Survey__c`  string , `MailingCountry`  string , `No_Longer_with_Company__c`  boolean , `Authority__c`  string , `NDA_Signed__c`  boolean , `ContactId__c`  string , `Middle_Name__c`  string , `AccountId__c`  string , `Full_Name__c`  string , `Loc_Code__c`  string , `utm_campaign__c`  string , `utm_keyword__c`  string , `SystemModstamp`  timestamp , `CreatedDate`  timestamp , `Do_Not_Mail__c`  boolean , `attributes`  string , `DoNotCall`  boolean , `rh2__Formula_Test__c`  decimal(16,2) , `OtherStreet`  string , `MasterRecordId`  string , `FirstName`  string , `LastName`  string , `OtherLatitude`  double , `pi__last_activity__c`  timestamp , `MS_Contact__c`  boolean , `Receives_Call_Center_API__c`  boolean , `pi__conversion_date__c`  timestamp , `AssistantPhone`  string , `Corp_Code__c`  string , `pi__conversion_object_type__c`  string , `LastModifiedDate`  timestamp , `pi__first_search_type__c`  string , `AssistantName`  string , `Phone`  string , `HasOptedOutOfEmail`  boolean , `HasOptedOutOfFax`  boolean , `ConnectionSentId`  string , `LastCURequestDate`  timestamp , `Parent_Account_Owner_Alias__c`  string , `business_owner_checkbox__c`  boolean , `Account_Owner_Match__c`  string , `MailingStreet`  string , `OtherCountry`  string , `utm_ad__c`  string , `EmailBouncedDate`  timestamp , `pi__utm_term__c`  string , `Birthdate`  date , `pi__comments__c`  string , `OtherState`  string , `pi__utm_source__c`  string , `pi__first_touch_url__c`  string , `pi__Needs_Score_Synced__c`  boolean , `rh2__Integer_Test__c`  double , `Current_Feature_Interest__c`  string , `Home_Phone_1__c`  string , `OtherPhone`  string , `Contact_Outlook_Category__c`  string , `ReportsToId`  string , `Web_Comments__c`  string , `IsEmailBounced`  boolean , `pi__grade__c`  string , `Description`  string , `rh2__Describe__c`  string , `CreatedById`  string , `pi__conversion_object_name__c`  string , `LastViewedDate`  timestamp , `Address_Type__c`  string , `pi__created_date__c`  timestamp , `Name`  string , `MailingCity`  string , `pi__Pardot_Last_Scored_At__c`  timestamp , `IGD__Collection_Id__c`  string , `LeadSource`  string , `ConnectionReceivedId`  string , `pi__first_activity__c`  timestamp , `Receives_SOC_1_Type_2_Report__c`  boolean , `Needs__c`  string , `LastActivityDate`  date , `Salutation`  string , `Sent_to_SpareFoot_By__c`  string , `Id`  string , `HomePhone`  string \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-dev/raw/Contact/2018-10-25/1540503459'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_salesforce.sitelink_contact"
]

hive_path: s3://sfdl-salesforce-sitelink-dev/raw/Contact/2018-10-25/1540503459
id: 4662722
processed: 1

raw_data:

{
    "AccountId": 15,
    "AccountId__c": 55,
    "Account_Owner_Match__c": 88,
    "Account_Owner__c": 28,
    "Address_Type__c": 114,
    "AssistantName": 80,
    "AssistantPhone": 75,
    "Attended__c": 40,
    "Authority__c": 51,
    "Birthdate": 94,
    "ConnectionReceivedId": 121,
    "ConnectionSentId": 84,
    "ContactId__c": 53,
    "Contact_Outlook_Category__c": 104,
    "Corp_Code__c": 76,
    "Corp_Loc__c": 43,
    "CreatedById": 111,
    "CreatedDate": 61,
    "CurrencyIsoCode": 12,
    "Current_Feature_Interest__c": 101,
    "Current_User_Email__c": 20,
    "Department": 4,
    "Description": 109,
    "DoNotCall": 64,
    "Do_Not_Mail__c": 62,
    "Email": 39,
    "EmailBouncedDate": 92,
    "EmailBouncedReason": 36,
    "Email_1__c": 22,
    "Email_2__c": 30,
    "Email_3__c": 17,
    "Fax": 6,
    "FirstName": 68,
    "Full_Name__c": 56,
    "HasOptedOutOfEmail": 82,
    "HasOptedOutOfFax": 83,
    "HomePhone": 129,
    "Home_Phone_1__c": 102,
    "IGD__Collection_Id__c": 119,
    "Id": 128,
    "IsDeleted": 14,
    "IsEmailBounced": 107,
    "Jigsaw": 34,
    "JigsawContactId": 33,
    "LastActivityDate": 125,
    "LastCURequestDate": 85,
    "LastCUUpdateDate": 27,
    "LastModifiedById": 35,
    "LastModifiedDate": 78,
    "LastName": 69,
    "LastReferencedDate": 18,
    "LastViewedDate": 113,
    "LeadSource": 120,
    "Loc_Code__c": 57,
    "MS_Contact__c": 72,
    "MailingCity": 117,
    "MailingCountry": 49,
    "MailingLatitude": 7,
    "MailingLongitude": 45,
    "MailingPostalCode": 0,
    "MailingState": 5,
    "MailingStreet": 89,
    "Marketing_Contact_Method__c": 19,
    "Marketing__c": 11,
    "MasterRecordId": 67,
    "Middle_Name__c": 54,
    "MobilePhone": 21,
    "NDA_Signed__c": 52,
    "Name": 116,
    "Needs__c": 124,
    "New_Email__c": 31,
    "No_Longer_with_Company__c": 50,
    "OtherCity": 25,
    "OtherCountry": 90,
    "OtherLatitude": 70,
    "OtherLongitude": 10,
    "OtherPhone": 103,
    "OtherPostalCode": 46,
    "OtherState": 96,
    "OtherStreet": 66,
    "OwnerId": 37,
    "Parent_Account_Owner_Alias__c": 86,
    "Phone": 81,
    "Receives_Call_Center_API__c": 73,
    "Receives_Reporting_API__c": 23,
    "Receives_SOC_1_Type_2_Report__c": 123,
    "ReportsToId": 105,
    "Salutation": 126,
    "Sent_to_SpareFoot_By__c": 127,
    "Sent_to_SpareFoot__c": 16,
    "Sparefoot_Lead_Sent__c": 24,
    "SystemModstamp": 60,
    "TIMBASURVEYS__Survey__c": 48,
    "Technical_Contact__c": 29,
    "Title": 1,
    "Web_Comments__c": 106,
    "attributes": 63,
    "business_owner_checkbox__c": 87,
    "pi__Needs_Score_Synced__c": 99,
    "pi__Pardot_Last_Scored_At__c": 118,
    "pi__campaign__c": 32,
    "pi__comments__c": 95,
    "pi__conversion_date__c": 74,
    "pi__conversion_object_name__c": 112,
    "pi__conversion_object_type__c": 77,
    "pi__created_date__c": 115,
    "pi__first_activity__c": 122,
    "pi__first_search_term__c": 9,
    "pi__first_search_type__c": 79,
    "pi__first_touch_url__c": 98,
    "pi__grade__c": 108,
    "pi__last_activity__c": 71,
    "pi__notes__c": 47,
    "pi__pardot_hard_bounced__c": 41,
    "pi__score__c": 26,
    "pi__url__c": 44,
    "pi__utm_campaign__c": 8,
    "pi__utm_content__c": 42,
    "pi__utm_medium__c": 2,
    "pi__utm_source__c": 97,
    "pi__utm_term__c": 93,
    "rh2__Currency_Test__c": 13,
    "rh2__Describe__c": 110,
    "rh2__Formula_Test__c": 65,
    "rh2__Integer_Test__c": 100,
    "sales_contact__c": 3,
    "utm_ad__c": 91,
    "utm_campaign__c": 58,
    "utm_keyword__c": 59,
    "utm_source__c": 38
}

schema_attributes:

{
    "AccountId": "string",
    "AccountId__c": "string",
    "Account_Owner_Match__c": "string",
    "Account_Owner__c": "string",
    "Address_Type__c": "string",
    "AssistantName": "string",
    "AssistantPhone": "string",
    "Attended__c": "string",
    "Authority__c": "string",
    "Birthdate": "date",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactId__c": "string",
    "Contact_Outlook_Category__c": "string",
    "Corp_Code__c": "string",
    "Corp_Loc__c": "string",
    "CreatedById": "string",
    "CreatedDate": "timestamp",
    "CurrencyIsoCode": "string",
    "Current_Feature_Interest__c": "string",
    "Current_User_Email__c": "string",
    "Department": "string",
    "Description": "string",
    "DoNotCall": "boolean",
    "Do_Not_Mail__c": "boolean",
    "Email": "string",
    "EmailBouncedDate": "timestamp",
    "EmailBouncedReason": "string",
    "Email_1__c": "string",
    "Email_2__c": "string",
    "Email_3__c": "string",
    "Fax": "string",
    "FirstName": "string",
    "Full_Name__c": "string",
    "HasOptedOutOfEmail": "boolean",
    "HasOptedOutOfFax": "boolean",
    "HomePhone": "string",
    "Home_Phone_1__c": "string",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "IsDeleted": "boolean",
    "IsEmailBounced": "boolean",
    "Jigsaw": "string",
    "JigsawContactId": "string",
    "LastActivityDate": "date",
    "LastCURequestDate": "timestamp",
    "LastCUUpdateDate": "timestamp",
    "LastModifiedById": "string",
    "LastModifiedDate": "timestamp",
    "LastName": "string",
    "LastReferencedDate": "timestamp",
    "LastViewedDate": "timestamp",
    "LeadSource": "string",
    "Loc_Code__c": "string",
    "MS_Contact__c": "boolean",
    "MailingCity": "string",
    "MailingCountry": "string",
    "MailingLatitude": "double",
    "MailingLongitude": "double",
    "MailingPostalCode": "string",
    "MailingState": "string",
    "MailingStreet": "string",
    "Marketing_Contact_Method__c": "string",
    "Marketing__c": "string",
    "MasterRecordId": "string",
    "Middle_Name__c": "string",
    "MobilePhone": "string",
    "NDA_Signed__c": "boolean",
    "Name": "string",
    "Needs__c": "string",
    "New_Email__c": "string",
    "No_Longer_with_Company__c": "boolean",
    "OtherCity": "string",
    "OtherCountry": "string",
    "OtherLatitude": "double",
    "OtherLongitude": "double",
    "OtherPhone": "string",
    "OtherPostalCode": "string",
    "OtherState": "string",
    "OtherStreet": "string",
    "OwnerId": "string",
    "Parent_Account_Owner_Alias__c": "string",
    "Phone": "string",
    "Receives_Call_Center_API__c": "boolean",
    "Receives_Reporting_API__c": "boolean",
    "Receives_SOC_1_Type_2_Report__c": "boolean",
    "ReportsToId": "string",
    "Salutation": "string",
    "Sent_to_SpareFoot_By__c": "string",
    "Sent_to_SpareFoot__c": "boolean",
    "Sparefoot_Lead_Sent__c": "date",
    "SystemModstamp": "timestamp",
    "TIMBASURVEYS__Survey__c": "string",
    "Technical_Contact__c": "boolean",
    "Title": "string",
    "Web_Comments__c": "string",
    "attributes": "string",
    "business_owner_checkbox__c": "boolean",
    "pi__Needs_Score_Synced__c": "boolean",
    "pi__Pardot_Last_Scored_At__c": "timestamp",
    "pi__campaign__c": "string",
    "pi__comments__c": "string",
    "pi__conversion_date__c": "timestamp",
    "pi__conversion_object_name__c": "string",
    "pi__conversion_object_type__c": "string",
    "pi__created_date__c": "timestamp",
    "pi__first_activity__c": "timestamp",
    "pi__first_search_term__c": "string",
    "pi__first_search_type__c": "string",
    "pi__first_touch_url__c": "string",
    "pi__grade__c": "string",
    "pi__last_activity__c": "timestamp",
    "pi__notes__c": "string",
    "pi__pardot_hard_bounced__c": "boolean",
    "pi__score__c": "double",
    "pi__url__c": "string",
    "pi__utm_campaign__c": "string",
    "pi__utm_content__c": "string",
    "pi__utm_medium__c": "string",
    "pi__utm_source__c": "string",
    "pi__utm_term__c": "string",
    "rh2__Currency_Test__c": "decimal(16,2)",
    "rh2__Describe__c": "string",
    "rh2__Formula_Test__c": "decimal(16,2)",
    "rh2__Integer_Test__c": "double",
    "sales_contact__c": "boolean",
    "utm_ad__c": "string",
    "utm_campaign__c": "string",
    "utm_keyword__c": "string",
    "utm_source__c": "string"
}

schema_name_id: 1069
schema_scan_id: 4225556
updated: 2018-10-25 16:37:53

Schema Scans: 2

Last at 2018-10-26 13:46:55

Scan 4229339

duration: 0:00:13.801686

exit_message:

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

id: 4229339

payload:

{
    "datatype_dict": {
        "AccountId": "string",
        "AccountId__c": "string",
        "Account_Owner_Match__c": "string",
        "Account_Owner__c": "string",
        "Address_Type__c": "string",
        "AssistantName": "string",
        "AssistantPhone": "string",
        "Attended__c": "string",
        "Authority__c": "string",
        "Birthdate": "date",
        "ConnectionReceivedId": "string",
        "ConnectionSentId": "string",
        "ContactId__c": "string",
        "Contact_Outlook_Category__c": "string",
        "Corp_Code__c": "string",
        "Corp_Loc__c": "string",
        "CreatedById": "string",
        "CreatedDate": "timestamp",
        "CurrencyIsoCode": "string",
        "Current_Feature_Interest__c": "string",
        "Current_User_Email__c": "string",
        "Department": "string",
        "Description": "string",
        "DoNotCall": "boolean",
        "Do_Not_Mail__c": "boolean",
        "Email": "string",
        "EmailBouncedDate": "timestamp",
        "EmailBouncedReason": "string",
        "Email_1__c": "string",
        "Email_2__c": "string",
        "Email_3__c": "string",
        "Fax": "string",
        "FirstName": "string",
        "Full_Name__c": "string",
        "HasOptedOutOfEmail": "boolean",
        "HasOptedOutOfFax": "boolean",
        "HomePhone": "string",
        "Home_Phone_1__c": "string",
        "IGD__Collection_Id__c": "string",
        "Id": "string",
        "IsDeleted": "boolean",
        "IsEmailBounced": "boolean",
        "Jigsaw": "string",
        "JigsawContactId": "string",
        "LastActivityDate": "date",
        "LastCURequestDate": "timestamp",
        "LastCUUpdateDate": "timestamp",
        "LastModifiedById": "string",
        "LastModifiedDate": "timestamp",
        "LastName": "string",
        "LastReferencedDate": "timestamp",
        "LastViewedDate": "timestamp",
        "LeadSource": "string",
        "Loc_Code__c": "string",
        "MS_Contact__c": "boolean",
        "MailingCity": "string",
        "MailingCountry": "string",
        "MailingLatitude": "double",
        "MailingLongitude": "double",
        "MailingPostalCode": "string",
        "MailingState": "string",
        "MailingStreet": "string",
        "Marketing_Contact_Method__c": "string",
        "Marketing__c": "string",
        "MasterRecordId": "string",
        "Middle_Name__c": "string",
        "MobilePhone": "string",
        "NDA_Signed__c": "boolean",
        "Name": "string",
        "Needs__c": "string",
        "New_Email__c": "string",
        "No_Longer_with_Company__c": "boolean",
        "OtherCity": "string",
        "OtherCountry": "string",
        "OtherLatitude": "double",
        "OtherLongitude": "double",
        "OtherPhone": "string",
        "OtherPostalCode": "string",
        "OtherState": "string",
        "OtherStreet": "string",
        "OwnerId": "string",
        "Parent_Account_Owner_Alias__c": "string",
        "Phone": "string",
        "Receives_Call_Center_API__c": "boolean",
        "Receives_Reporting_API__c": "boolean",
        "Receives_SOC_1_Type_2_Report__c": "boolean",
        "ReportsToId": "string",
        "Salutation": "string",
        "Sent_to_SpareFoot_By__c": "string",
        "Sent_to_SpareFoot__c": "boolean",
        "Sparefoot_Lead_Sent__c": "date",
        "SystemModstamp": "timestamp",
        "TIMBASURVEYS__Survey__c": "string",
        "Technical_Contact__c": "boolean",
        "Title": "string",
        "Web_Comments__c": "string",
        "business_owner_checkbox__c": "boolean",
        "pi__Needs_Score_Synced__c": "boolean",
        "pi__Pardot_Last_Scored_At__c": "timestamp",
        "pi__campaign__c": "string",
        "pi__comments__c": "string",
        "pi__conversion_date__c": "timestamp",
        "pi__conversion_object_name__c": "string",
        "pi__conversion_object_type__c": "string",
        "pi__created_date__c": "timestamp",
        "pi__first_activity__c": "timestamp",
        "pi__first_search_term__c": "string",
        "pi__first_search_type__c": "string",
        "pi__first_touch_url__c": "string",
        "pi__grade__c": "string",
        "pi__last_activity__c": "timestamp",
        "pi__notes__c": "string",
        "pi__pardot_hard_bounced__c": "boolean",
        "pi__score__c": "double",
        "pi__url__c": "string",
        "pi__utm_campaign__c": "string",
        "pi__utm_content__c": "string",
        "pi__utm_medium__c": "string",
        "pi__utm_source__c": "string",
        "pi__utm_term__c": "string",
        "rh2__Currency_Test__c": "decimal(16,2)",
        "rh2__Describe__c": "string",
        "rh2__Formula_Test__c": "decimal(16,2)",
        "rh2__Integer_Test__c": "double",
        "sales_contact__c": "boolean",
        "utm_ad__c": "string",
        "utm_campaign__c": "string",
        "utm_keyword__c": "string",
        "utm_source__c": "string"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-salesforce-sitelink-dev",
        "hive_path": "s3://sfdl-salesforce-sitelink-dev/raw/Contact/2018-10-26/1540579613",
        "key": "raw/Contact/2018-10-26/1540579613/file0.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_salesforce.sitelink_Contact",
        "type": "salesforce"
    }
}

running: False
schema_name_id: 1069
start_time: 2018-10-26 13:46:55
success: True
trace_id: 2414459594928375703

Scan 4225556

duration: 0:00:13.543393

exit_message:

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

id: 4225556

payload:

{
    "datatype_dict": {
        "AccountId": "string",
        "AccountId__c": "string",
        "Account_Owner_Match__c": "string",
        "Account_Owner__c": "string",
        "Address_Type__c": "string",
        "AssistantName": "string",
        "AssistantPhone": "string",
        "Attended__c": "string",
        "Authority__c": "string",
        "Birthdate": "date",
        "ConnectionReceivedId": "string",
        "ConnectionSentId": "string",
        "ContactId__c": "string",
        "Contact_Outlook_Category__c": "string",
        "Corp_Code__c": "string",
        "Corp_Loc__c": "string",
        "CreatedById": "string",
        "CreatedDate": "timestamp",
        "CurrencyIsoCode": "string",
        "Current_Feature_Interest__c": "string",
        "Current_User_Email__c": "string",
        "Department": "string",
        "Description": "string",
        "DoNotCall": "boolean",
        "Do_Not_Mail__c": "boolean",
        "Email": "string",
        "EmailBouncedDate": "timestamp",
        "EmailBouncedReason": "string",
        "Email_1__c": "string",
        "Email_2__c": "string",
        "Email_3__c": "string",
        "Fax": "string",
        "FirstName": "string",
        "Full_Name__c": "string",
        "HasOptedOutOfEmail": "boolean",
        "HasOptedOutOfFax": "boolean",
        "HomePhone": "string",
        "Home_Phone_1__c": "string",
        "IGD__Collection_Id__c": "string",
        "Id": "string",
        "IsDeleted": "boolean",
        "IsEmailBounced": "boolean",
        "Jigsaw": "string",
        "JigsawContactId": "string",
        "LastActivityDate": "date",
        "LastCURequestDate": "timestamp",
        "LastCUUpdateDate": "timestamp",
        "LastModifiedById": "string",
        "LastModifiedDate": "timestamp",
        "LastName": "string",
        "LastReferencedDate": "timestamp",
        "LastViewedDate": "timestamp",
        "LeadSource": "string",
        "Loc_Code__c": "string",
        "MS_Contact__c": "boolean",
        "MailingCity": "string",
        "MailingCountry": "string",
        "MailingLatitude": "double",
        "MailingLongitude": "double",
        "MailingPostalCode": "string",
        "MailingState": "string",
        "MailingStreet": "string",
        "Marketing_Contact_Method__c": "string",
        "Marketing__c": "string",
        "MasterRecordId": "string",
        "Middle_Name__c": "string",
        "MobilePhone": "string",
        "NDA_Signed__c": "boolean",
        "Name": "string",
        "Needs__c": "string",
        "New_Email__c": "string",
        "No_Longer_with_Company__c": "boolean",
        "OtherCity": "string",
        "OtherCountry": "string",
        "OtherLatitude": "double",
        "OtherLongitude": "double",
        "OtherPhone": "string",
        "OtherPostalCode": "string",
        "OtherState": "string",
        "OtherStreet": "string",
        "OwnerId": "string",
        "Parent_Account_Owner_Alias__c": "string",
        "Phone": "string",
        "Receives_Call_Center_API__c": "boolean",
        "Receives_Reporting_API__c": "boolean",
        "Receives_SOC_1_Type_2_Report__c": "boolean",
        "ReportsToId": "string",
        "Salutation": "string",
        "Sent_to_SpareFoot_By__c": "string",
        "Sent_to_SpareFoot__c": "boolean",
        "Sparefoot_Lead_Sent__c": "date",
        "SystemModstamp": "timestamp",
        "TIMBASURVEYS__Survey__c": "string",
        "Technical_Contact__c": "boolean",
        "Title": "string",
        "Web_Comments__c": "string",
        "business_owner_checkbox__c": "boolean",
        "pi__Needs_Score_Synced__c": "boolean",
        "pi__Pardot_Last_Scored_At__c": "timestamp",
        "pi__campaign__c": "string",
        "pi__comments__c": "string",
        "pi__conversion_date__c": "timestamp",
        "pi__conversion_object_name__c": "string",
        "pi__conversion_object_type__c": "string",
        "pi__created_date__c": "timestamp",
        "pi__first_activity__c": "timestamp",
        "pi__first_search_term__c": "string",
        "pi__first_search_type__c": "string",
        "pi__first_touch_url__c": "string",
        "pi__grade__c": "string",
        "pi__last_activity__c": "timestamp",
        "pi__notes__c": "string",
        "pi__pardot_hard_bounced__c": "boolean",
        "pi__score__c": "double",
        "pi__url__c": "string",
        "pi__utm_campaign__c": "string",
        "pi__utm_content__c": "string",
        "pi__utm_medium__c": "string",
        "pi__utm_source__c": "string",
        "pi__utm_term__c": "string",
        "rh2__Currency_Test__c": "decimal(16,2)",
        "rh2__Describe__c": "string",
        "rh2__Formula_Test__c": "decimal(16,2)",
        "rh2__Integer_Test__c": "double",
        "sales_contact__c": "boolean",
        "utm_ad__c": "string",
        "utm_campaign__c": "string",
        "utm_keyword__c": "string",
        "utm_source__c": "string"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-salesforce-sitelink-dev",
        "hive_path": "s3://sfdl-salesforce-sitelink-dev/raw/Contact/2018-10-25/1540503459",
        "key": "raw/Contact/2018-10-25/1540503459/file0.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_salesforce.sitelink_Contact",
        "type": "salesforce"
    }
}

running: False
schema_name_id: 1069
start_time: 2018-10-25 16:37:42
success: True
trace_id: 2514736894422011547

Partitions:

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

Schema:

attributes:

{
    "AccountId": "string",
    "AccountId__c": "string",
    "Account_Owner_Match__c": "string",
    "Account_Owner__c": "string",
    "Address_Type__c": "string",
    "AssistantName": "string",
    "AssistantPhone": "string",
    "Attended__c": "string",
    "Authority__c": "string",
    "Birthdate": "date",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactId__c": "string",
    "Contact_Outlook_Category__c": "string",
    "Corp_Code__c": "string",
    "Corp_Loc__c": "string",
    "CreatedById": "string",
    "CreatedDate": "timestamp",
    "CurrencyIsoCode": "string",
    "Current_Feature_Interest__c": "string",
    "Current_User_Email__c": "string",
    "Department": "string",
    "Description": "string",
    "DoNotCall": "boolean",
    "Do_Not_Mail__c": "boolean",
    "Email": "string",
    "EmailBouncedDate": "timestamp",
    "EmailBouncedReason": "string",
    "Email_1__c": "string",
    "Email_2__c": "string",
    "Email_3__c": "string",
    "Fax": "string",
    "FirstName": "string",
    "Full_Name__c": "string",
    "HasOptedOutOfEmail": "boolean",
    "HasOptedOutOfFax": "boolean",
    "HomePhone": "string",
    "Home_Phone_1__c": "string",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "IsDeleted": "boolean",
    "IsEmailBounced": "boolean",
    "Jigsaw": "string",
    "JigsawContactId": "string",
    "LastActivityDate": "date",
    "LastCURequestDate": "timestamp",
    "LastCUUpdateDate": "timestamp",
    "LastModifiedById": "string",
    "LastModifiedDate": "timestamp",
    "LastName": "string",
    "LastReferencedDate": "timestamp",
    "LastViewedDate": "timestamp",
    "LeadSource": "string",
    "Loc_Code__c": "string",
    "MS_Contact__c": "boolean",
    "MailingCity": "string",
    "MailingCountry": "string",
    "MailingLatitude": "double",
    "MailingLongitude": "double",
    "MailingPostalCode": "string",
    "MailingState": "string",
    "MailingStreet": "string",
    "Marketing_Contact_Method__c": "string",
    "Marketing__c": "string",
    "MasterRecordId": "string",
    "Middle_Name__c": "string",
    "MobilePhone": "string",
    "NDA_Signed__c": "boolean",
    "Name": "string",
    "Needs__c": "string",
    "New_Email__c": "string",
    "No_Longer_with_Company__c": "boolean",
    "OtherCity": "string",
    "OtherCountry": "string",
    "OtherLatitude": "double",
    "OtherLongitude": "double",
    "OtherPhone": "string",
    "OtherPostalCode": "string",
    "OtherState": "string",
    "OtherStreet": "string",
    "OwnerId": "string",
    "Parent_Account_Owner_Alias__c": "string",
    "Phone": "string",
    "Receives_Call_Center_API__c": "boolean",
    "Receives_Reporting_API__c": "boolean",
    "Receives_SOC_1_Type_2_Report__c": "boolean",
    "ReportsToId": "string",
    "Salutation": "string",
    "Sent_to_SpareFoot_By__c": "string",
    "Sent_to_SpareFoot__c": "boolean",
    "Sparefoot_Lead_Sent__c": "date",
    "SystemModstamp": "timestamp",
    "TIMBASURVEYS__Survey__c": "string",
    "Technical_Contact__c": "boolean",
    "Title": "string",
    "Web_Comments__c": "string",
    "attributes": "string",
    "business_owner_checkbox__c": "boolean",
    "pi__Needs_Score_Synced__c": "boolean",
    "pi__Pardot_Last_Scored_At__c": "timestamp",
    "pi__campaign__c": "string",
    "pi__comments__c": "string",
    "pi__conversion_date__c": "timestamp",
    "pi__conversion_object_name__c": "string",
    "pi__conversion_object_type__c": "string",
    "pi__created_date__c": "timestamp",
    "pi__first_activity__c": "timestamp",
    "pi__first_search_term__c": "string",
    "pi__first_search_type__c": "string",
    "pi__first_touch_url__c": "string",
    "pi__grade__c": "string",
    "pi__last_activity__c": "timestamp",
    "pi__notes__c": "string",
    "pi__pardot_hard_bounced__c": "boolean",
    "pi__score__c": "double",
    "pi__url__c": "string",
    "pi__utm_campaign__c": "string",
    "pi__utm_content__c": "string",
    "pi__utm_medium__c": "string",
    "pi__utm_source__c": "string",
    "pi__utm_term__c": "string",
    "rh2__Currency_Test__c": "decimal(16,2)",
    "rh2__Describe__c": "string",
    "rh2__Formula_Test__c": "decimal(16,2)",
    "rh2__Integer_Test__c": "double",
    "sales_contact__c": "boolean",
    "utm_ad__c": "string",
    "utm_campaign__c": "string",
    "utm_keyword__c": "string",
    "utm_source__c": "string"
}

created: 2018-10-26 13:46:55

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_salesforce`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_salesforce.sitelink_contact`\n(\n `MailingPostalCode`  string , `Title`  string , `pi__utm_medium__c`  string , `sales_contact__c`  boolean , `Department`  string , `MailingState`  string , `Fax`  string , `MailingLatitude`  double , `pi__utm_campaign__c`  string , `pi__first_search_term__c`  string , `OtherLongitude`  double , `Marketing__c`  string , `CurrencyIsoCode`  string , `rh2__Currency_Test__c`  decimal(16,2) , `IsDeleted`  boolean , `AccountId`  string , `Sent_to_SpareFoot__c`  boolean , `Email_3__c`  string , `LastReferencedDate`  timestamp , `Marketing_Contact_Method__c`  string , `Current_User_Email__c`  string , `MobilePhone`  string , `Email_1__c`  string , `Receives_Reporting_API__c`  boolean , `Sparefoot_Lead_Sent__c`  date , `OtherCity`  string , `pi__score__c`  double , `LastCUUpdateDate`  timestamp , `Account_Owner__c`  string , `Technical_Contact__c`  boolean , `Email_2__c`  string , `New_Email__c`  string , `pi__campaign__c`  string , `JigsawContactId`  string , `Jigsaw`  string , `LastModifiedById`  string , `EmailBouncedReason`  string , `OwnerId`  string , `utm_source__c`  string , `Email`  string , `Attended__c`  string , `pi__pardot_hard_bounced__c`  boolean , `pi__utm_content__c`  string , `Corp_Loc__c`  string , `pi__url__c`  string , `MailingLongitude`  double , `OtherPostalCode`  string , `pi__notes__c`  string , `TIMBASURVEYS__Survey__c`  string , `MailingCountry`  string , `No_Longer_with_Company__c`  boolean , `Authority__c`  string , `NDA_Signed__c`  boolean , `ContactId__c`  string , `Middle_Name__c`  string , `AccountId__c`  string , `Full_Name__c`  string , `Loc_Code__c`  string , `utm_campaign__c`  string , `utm_keyword__c`  string , `SystemModstamp`  timestamp , `CreatedDate`  timestamp , `Do_Not_Mail__c`  boolean , `attributes`  string , `DoNotCall`  boolean , `rh2__Formula_Test__c`  decimal(16,2) , `OtherStreet`  string , `MasterRecordId`  string , `FirstName`  string , `LastName`  string , `OtherLatitude`  double , `pi__last_activity__c`  timestamp , `MS_Contact__c`  boolean , `Receives_Call_Center_API__c`  boolean , `pi__conversion_date__c`  timestamp , `AssistantPhone`  string , `Corp_Code__c`  string , `pi__conversion_object_type__c`  string , `LastModifiedDate`  timestamp , `pi__first_search_type__c`  string , `AssistantName`  string , `Phone`  string , `HasOptedOutOfEmail`  boolean , `HasOptedOutOfFax`  boolean , `ConnectionSentId`  string , `LastCURequestDate`  timestamp , `Parent_Account_Owner_Alias__c`  string , `business_owner_checkbox__c`  boolean , `Account_Owner_Match__c`  string , `MailingStreet`  string , `OtherCountry`  string , `utm_ad__c`  string , `EmailBouncedDate`  timestamp , `pi__utm_term__c`  string , `Birthdate`  date , `pi__comments__c`  string , `OtherState`  string , `pi__utm_source__c`  string , `pi__first_touch_url__c`  string , `pi__Needs_Score_Synced__c`  boolean , `rh2__Integer_Test__c`  double , `Current_Feature_Interest__c`  string , `Home_Phone_1__c`  string , `OtherPhone`  string , `Contact_Outlook_Category__c`  string , `ReportsToId`  string , `Web_Comments__c`  string , `IsEmailBounced`  boolean , `pi__grade__c`  string , `Description`  string , `rh2__Describe__c`  string , `CreatedById`  string , `pi__conversion_object_name__c`  string , `LastViewedDate`  timestamp , `Address_Type__c`  string , `pi__created_date__c`  timestamp , `Name`  string , `MailingCity`  string , `pi__Pardot_Last_Scored_At__c`  timestamp , `IGD__Collection_Id__c`  string , `LeadSource`  string , `ConnectionReceivedId`  string , `pi__first_activity__c`  timestamp , `Receives_SOC_1_Type_2_Report__c`  boolean , `Needs__c`  string , `LastActivityDate`  date , `Salutation`  string , `Sent_to_SpareFoot_By__c`  string , `Id`  string , `HomePhone`  string \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-dev/raw/Contact/2018-10-26/1540579613'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_salesforce.sitelink_contact`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_salesforce.sitelink_contact"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2018-10-25 16:37:42",
        "disabled": false,
        "format": "raw",
        "id": 1069,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_salesforce",
            "table": "sitelink_contact"
        },
        "type": "salesforce"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AccountId": "string",
            "AccountId__c": "string",
            "Account_Owner_Match__c": "string",
            "Account_Owner__c": "string",
            "Address_Type__c": "string",
            "AssistantName": "string",
            "AssistantPhone": "string",
            "Attended__c": "string",
            "Authority__c": "string",
            "Birthdate": "date",
            "ConnectionReceivedId": "string",
            "ConnectionSentId": "string",
            "ContactId__c": "string",
            "Contact_Outlook_Category__c": "string",
            "Corp_Code__c": "string",
            "Corp_Loc__c": "string",
            "CreatedById": "string",
            "CreatedDate": "timestamp",
            "CurrencyIsoCode": "string",
            "Current_Feature_Interest__c": "string",
            "Current_User_Email__c": "string",
            "Department": "string",
            "Description": "string",
            "DoNotCall": "boolean",
            "Do_Not_Mail__c": "boolean",
            "Email": "string",
            "EmailBouncedDate": "timestamp",
            "EmailBouncedReason": "string",
            "Email_1__c": "string",
            "Email_2__c": "string",
            "Email_3__c": "string",
            "Fax": "string",
            "FirstName": "string",
            "Full_Name__c": "string",
            "HasOptedOutOfEmail": "boolean",
            "HasOptedOutOfFax": "boolean",
            "HomePhone": "string",
            "Home_Phone_1__c": "string",
            "IGD__Collection_Id__c": "string",
            "Id": "string",
            "IsDeleted": "boolean",
            "IsEmailBounced": "boolean",
            "Jigsaw": "string",
            "JigsawContactId": "string",
            "LastActivityDate": "date",
            "LastCURequestDate": "timestamp",
            "LastCUUpdateDate": "timestamp",
            "LastModifiedById": "string",
            "LastModifiedDate": "timestamp",
            "LastName": "string",
            "LastReferencedDate": "timestamp",
            "LastViewedDate": "timestamp",
            "LeadSource": "string",
            "Loc_Code__c": "string",
            "MS_Contact__c": "boolean",
            "MailingCity": "string",
            "MailingCountry": "string",
            "MailingLatitude": "double",
            "MailingLongitude": "double",
            "MailingPostalCode": "string",
            "MailingState": "string",
            "MailingStreet": "string",
            "Marketing_Contact_Method__c": "string",
            "Marketing__c": "string",
            "MasterRecordId": "string",
            "Middle_Name__c": "string",
            "MobilePhone": "string",
            "NDA_Signed__c": "boolean",
            "Name": "string",
            "Needs__c": "string",
            "New_Email__c": "string",
            "No_Longer_with_Company__c": "boolean",
            "OtherCity": "string",
            "OtherCountry": "string",
            "OtherLatitude": "double",
            "OtherLongitude": "double",
            "OtherPhone": "string",
            "OtherPostalCode": "string",
            "OtherState": "string",
            "OtherStreet": "string",
            "OwnerId": "string",
            "Parent_Account_Owner_Alias__c": "string",
            "Phone": "string",
            "Receives_Call_Center_API__c": "boolean",
            "Receives_Reporting_API__c": "boolean",
            "Receives_SOC_1_Type_2_Report__c": "boolean",
            "ReportsToId": "string",
            "Salutation": "string",
            "Sent_to_SpareFoot_By__c": "string",
            "Sent_to_SpareFoot__c": "boolean",
            "Sparefoot_Lead_Sent__c": "date",
            "SystemModstamp": "timestamp",
            "TIMBASURVEYS__Survey__c": "string",
            "Technical_Contact__c": "boolean",
            "Title": "string",
            "Web_Comments__c": "string",
            "attributes": "string",
            "business_owner_checkbox__c": "boolean",
            "pi__Needs_Score_Synced__c": "boolean",
            "pi__Pardot_Last_Scored_At__c": "timestamp",
            "pi__campaign__c": "string",
            "pi__comments__c": "string",
            "pi__conversion_date__c": "timestamp",
            "pi__conversion_object_name__c": "string",
            "pi__conversion_object_type__c": "string",
            "pi__created_date__c": "timestamp",
            "pi__first_activity__c": "timestamp",
            "pi__first_search_term__c": "string",
            "pi__first_search_type__c": "string",
            "pi__first_touch_url__c": "string",
            "pi__grade__c": "string",
            "pi__last_activity__c": "timestamp",
            "pi__notes__c": "string",
            "pi__pardot_hard_bounced__c": "boolean",
            "pi__score__c": "double",
            "pi__url__c": "string",
            "pi__utm_campaign__c": "string",
            "pi__utm_content__c": "string",
            "pi__utm_medium__c": "string",
            "pi__utm_source__c": "string",
            "pi__utm_term__c": "string",
            "rh2__Currency_Test__c": "decimal(16,2)",
            "rh2__Describe__c": "string",
            "rh2__Formula_Test__c": "decimal(16,2)",
            "rh2__Integer_Test__c": "double",
            "sales_contact__c": "boolean",
            "utm_ad__c": "string",
            "utm_campaign__c": "string",
            "utm_keyword__c": "string",
            "utm_source__c": "string"
        },
        "created": "2018-10-26 13:46:55",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_salesforce`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_salesforce.sitelink_contact`\n(\n `MailingPostalCode`  string , `Title`  string , `pi__utm_medium__c`  string , `sales_contact__c`  boolean , `Department`  string , `MailingState`  string , `Fax`  string , `MailingLatitude`  double , `pi__utm_campaign__c`  string , `pi__first_search_term__c`  string , `OtherLongitude`  double , `Marketing__c`  string , `CurrencyIsoCode`  string , `rh2__Currency_Test__c`  decimal(16,2) , `IsDeleted`  boolean , `AccountId`  string , `Sent_to_SpareFoot__c`  boolean , `Email_3__c`  string , `LastReferencedDate`  timestamp , `Marketing_Contact_Method__c`  string , `Current_User_Email__c`  string , `MobilePhone`  string , `Email_1__c`  string , `Receives_Reporting_API__c`  boolean , `Sparefoot_Lead_Sent__c`  date , `OtherCity`  string , `pi__score__c`  double , `LastCUUpdateDate`  timestamp , `Account_Owner__c`  string , `Technical_Contact__c`  boolean , `Email_2__c`  string , `New_Email__c`  string , `pi__campaign__c`  string , `JigsawContactId`  string , `Jigsaw`  string , `LastModifiedById`  string , `EmailBouncedReason`  string , `OwnerId`  string , `utm_source__c`  string , `Email`  string , `Attended__c`  string , `pi__pardot_hard_bounced__c`  boolean , `pi__utm_content__c`  string , `Corp_Loc__c`  string , `pi__url__c`  string , `MailingLongitude`  double , `OtherPostalCode`  string , `pi__notes__c`  string , `TIMBASURVEYS__Survey__c`  string , `MailingCountry`  string , `No_Longer_with_Company__c`  boolean , `Authority__c`  string , `NDA_Signed__c`  boolean , `ContactId__c`  string , `Middle_Name__c`  string , `AccountId__c`  string , `Full_Name__c`  string , `Loc_Code__c`  string , `utm_campaign__c`  string , `utm_keyword__c`  string , `SystemModstamp`  timestamp , `CreatedDate`  timestamp , `Do_Not_Mail__c`  boolean , `attributes`  string , `DoNotCall`  boolean , `rh2__Formula_Test__c`  decimal(16,2) , `OtherStreet`  string , `MasterRecordId`  string , `FirstName`  string , `LastName`  string , `OtherLatitude`  double , `pi__last_activity__c`  timestamp , `MS_Contact__c`  boolean , `Receives_Call_Center_API__c`  boolean , `pi__conversion_date__c`  timestamp , `AssistantPhone`  string , `Corp_Code__c`  string , `pi__conversion_object_type__c`  string , `LastModifiedDate`  timestamp , `pi__first_search_type__c`  string , `AssistantName`  string , `Phone`  string , `HasOptedOutOfEmail`  boolean , `HasOptedOutOfFax`  boolean , `ConnectionSentId`  string , `LastCURequestDate`  timestamp , `Parent_Account_Owner_Alias__c`  string , `business_owner_checkbox__c`  boolean , `Account_Owner_Match__c`  string , `MailingStreet`  string , `OtherCountry`  string , `utm_ad__c`  string , `EmailBouncedDate`  timestamp , `pi__utm_term__c`  string , `Birthdate`  date , `pi__comments__c`  string , `OtherState`  string , `pi__utm_source__c`  string , `pi__first_touch_url__c`  string , `pi__Needs_Score_Synced__c`  boolean , `rh2__Integer_Test__c`  double , `Current_Feature_Interest__c`  string , `Home_Phone_1__c`  string , `OtherPhone`  string , `Contact_Outlook_Category__c`  string , `ReportsToId`  string , `Web_Comments__c`  string , `IsEmailBounced`  boolean , `pi__grade__c`  string , `Description`  string , `rh2__Describe__c`  string , `CreatedById`  string , `pi__conversion_object_name__c`  string , `LastViewedDate`  timestamp , `Address_Type__c`  string , `pi__created_date__c`  timestamp , `Name`  string , `MailingCity`  string , `pi__Pardot_Last_Scored_At__c`  timestamp , `IGD__Collection_Id__c`  string , `LeadSource`  string , `ConnectionReceivedId`  string , `pi__first_activity__c`  timestamp , `Receives_SOC_1_Type_2_Report__c`  boolean , `Needs__c`  string , `LastActivityDate`  date , `Salutation`  string , `Sent_to_SpareFoot_By__c`  string , `Id`  string , `HomePhone`  string \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-dev/raw/Contact/2018-10-26/1540579613'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_salesforce.sitelink_contact`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_salesforce.sitelink_contact"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}