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.