And the only concern is that the query runs for a really long time (never stopped on its own still) with the below statements in the log

Implement Salesforce Bulk API for SELECTS to Salesforce Connector ----------------------------------------------------------------- Key: TEIID-4284 URL: https://issues.jboss.org/browse/TEIID-4284 Project: Teiid Issue Type: Feature Request Components: Salesforce Connector Affects Versions: 8.13.5 Environment: With Salesforce datasource Reporter: sameer P Assignee: Steven Hawkins Fix For: 9.1 There is some huge data (many GBs) in the Salesforce which has around 1.5 million rows and doing some simple select * on it fails with QUERY_TIMEOUT. The salesforce guys suggested to try Bulk API for select with PK chunking as stated in https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asy... .