How to choose tables

To choose which tables or objects to load from a source, consider the following:

  • Size: The number of table rows or objects and their size determines how long it will take to load and synchronize. It also impacts costs associated with storage in staging and in the target. Some targets limit table or record size. Load only the data you need to get the best performance and reduce costs. When creating a data pipeline, you can filter out any non-required columns that you do not want to synchronize.
  • Synchronization: Choose a sychronization schedule and load type that meets your requirements for data freshness with the least amount of data transfer.
  • Related information: If a table or object references other tables or objects, you must select the related entities to have AutoSync load them.

To load all information related to an object or table, identify dependencies in the source data. For example, in Salesforce the Contact object is a child of the Account object. Contact has an AccountId field that references the parent Account. To load both contact and account information in the target, select both the Contact and Account objects. The following image shows the results:

Load related information