...
For integrations that load from Google BigQuery to BigQuery, failures can occur if a source
BIGNUMERIC
column does not have precision and scale set and contains a value with precision larger than76
. This happens because when the precision and scale for aBIGNUMERIC
column is not set in the source, AutoSync sets it to (76,38
) when creating the target table. BigQuery can actually store aBIGNUMERIC
value with a precision and scale of (76.76,38
).
Workaround: Set the precision and scale for BIGNUMERIC columns in the source to (76,38
).For integrations with Google BigQuery as a source or destination, the Filter columns data preview might not contain data, so there is no way to select the columns that you do not want to synchronize.
Workaround: The issue is intermittent. Try re-creating the data pipeline.Clarification to documented behavior: When using the Append load type for CSV files, if you upload a file containing content that was previously uploaded, the content is duplicated in the destination. This is because CSV files do not have primary keys to distinguish the data.
For efficiency and performance, AutoSync uses bulk load for Salesforce objects. The Salesforce Bulk API does not support all object types, refer . Refer to the Salesforce discussion forum for more information.
...