Unsupported SOQL (Salesforce Object Query Language) syntax. As a limitation, our data connector doesn’t support SOQL syntax such as count() FROM Object and select SELECT * from salesforceObject.
Bulk API limits. Bulk API offers faster ingestion but also has a limitation of 10,000 batch allocations within a 24-hour period. If your target is large, your entire available batch allocation might be consumed, causing your job to fail eventually. If you try to use the Bulk API, and the result is the ingestion of all records, consider enabling the synchronous transfer only option and using REST API. The use of REST API avoids the batch allocation limitation but might be slower.
Search for the connection you created.
Select New Source.
Type a name for your Source in the Data Transfer field.
Edit the following parameters:
Name of the object you want to import
Include deleted records
Enables including deleted records
Use synchronous transfer only
Enables synchronous transfer using REST API
Imports only new data since the last import
Select Next. The Data Settings page opens.
You can edit the SOQL query, WHERE conditions and Schema settings here.
Optionally, skip this page of the dialog.