Excel: ----- CREATE FOREIGN TABLE Sheet1 ( ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'), FirstName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'), LastName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'), Age double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'), CONSTRAINT PK0 PRIMARY KEY(ROW_ID) ) OPTIONS ("teiid_excel:FILE" 'names.xlsx', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2'); Salesforce: ---------- CREATE FOREIGN TABLE AccountHistory ( Id string(18) NOT NULL AUTO_INCREMENT OPTIONS (NATIVE_TYPE 'id', calculated 'false', custom 'false', defaultedOnCreate 'true'), IsDeleted boolean OPTIONS (NATIVE_TYPE 'boolean', calculated 'false', custom 'false', defaultedOnCreate 'true'), AccountId string(18) OPTIONS (NATIVE_TYPE 'reference', calculated 'false', custom 'false', defaultedOnCreate 'false'), Field string(255) OPTIONS (NATIVE_TYPE 'restrictedpicklist', calculated 'false', custom 'false', defaultedOnCreate 'false', picklistValues 'accountMerged,AccountNumber,AccountSource,Active__c,AnnualRevenue,BillingAddress,BillingCity,BillingCountry,BillingLatitude,BillingLongitude,BillingPostalCode,BillingState,BillingStreet,created,accountCreatedFromLead,CustomerPriority__c,Description,Fax,feedEvent,Industry,Jigsaw,accountUpdatedByLead,personAccountUpdatedByLead,Name,NumberOfEmployees,NumberofLocations__c,Owner,ownerAccepted,ownerAssignment,Ownership,Parent,Phone,Rating,locked,unlocked,ShippingAddress,ShippingCity,ShippingCountry,ShippingLatitude,ShippingLongitude,ShippingPostalCode,ShippingState,ShippingStreet,Sic,SicDesc,Site,SLA__c,SLAExpirationDate__c,SLASerialNumber__c,TextName,TickerSymbol,Type,UpsellOpportunity__c,Website'), OldValue string(255) OPTIONS (NATIVE_TYPE 'anyType', calculated 'false', custom 'false', defaultedOnCreate 'false'), NewValue string(255) OPTIONS (NATIVE_TYPE 'anyType', calculated 'false', custom 'false', defaultedOnCreate 'false'), CONSTRAINT Id_PK PRIMARY KEY(Id), CONSTRAINT FK_Account_AccountId FOREIGN KEY(AccountId) REFERENCES Account (Id) ) OPTIONS (custom 'false', supportsCreate 'false', supportsDelete 'false', supportsMerge 'false', supportsQuery 'true', supportsReplicate 'true', supportsRetrieve 'true', supportsSearch 'false');