...
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.
Click Next.
Edit the following parameters:
Parameters | Description |
Source | 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 |
Incremental | Imports only new data since the last import |
Data Settings
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.
...