Unsupported Salesforce Objects and Fields in CRM Analytics

If an object requires query clauses that aren’t used in this example, it probably isn’t supported.

SELECT fields
      FROM object
      WHERE Id > '0xx00000000xxxx'
      AND Id <= '0xx00000000yyyy'
      ORDER BY Id
      ASC LIMIT 1
      OFFSET 249999;
     

SELECT and FROM define the fields and object to sync. The rest of the query controls batching. Bulk API processes batches of 10,000 records. The batch is determined by WHERE filtering and ORDER sorting of the record IDs. Clauses that limit the ability to use this query structure, such as constraints on ORDER or WHERE, prevent CRM Analytics from querying the object for data sync or dataflows. For more information, see the SELECT clause help page.