Making Local Copies with a Subset of Columns


Making Local Copies with a Subset of Columns


To reduce the amount of data copied, you can choose a subset of table columns instead of the entire set. SF_BulkSOQL and SF_BulkSOQL_Refresh solve this need. SF_BulkSOQL uses the BulkAPI to create a local copy based on any SOQL query provided.

Once you have created an initial set of local, replicated tables with the subset of columns, you can keep those tables up-to-date by using SF_BulkSOQL_Refresh, which attempts to synchronize the local table created by the SOQL query, without having to re-download the entire result set.

NOTE: There are restrictions on which SOQL queries can be used with SF_BulkSOQL_Refresh.

For more information, see SF_BulkSOQL and SF_BulkSOQL_Refresh.