Capabilities for BigQuery

This section lists the of Fivetran Local Data Processing when using 'BigQuery'. For more information about the pre-requisites, access privileges, and other configuration requirements, see .

Capture

Local Data Processing does not support changes from location on BigQuery.

Repository Database

Local Data Processing does not support Repository database on BigQuery.

Integrate

Local Data Processing supports the following capabilities on BigQuery:

changes into location (BigQuery version 2).
Burst integration ( with parameter Method=BURST) (BigQuery version 2).
with parameter BurstCommitFrequency (BigQuery version 2).
Continuous integration ( with parameter Method=CONTINUOUS) (BigQuery version 2).
with parameter SoftDelete (BigQuery version 2).
Bulk load requires a staging area (location property Staging_Directory) (BigQuery version 2).
Creation and update of Local Data Processing state tables (BigQuery version 2).

Local Data Processing does not support the following capabilities on BigQuery:

Tables without a key and without with NoDuplicateRows for continuous integration.
Continuous with parameter OnErrorSaveFailed.
Disable/enable database triggers during (with parameter NoTriggerFiring).
with parameter DbProc.

Bi-directional Replication

Local Data Processing does not support Bi-directional Replication on BigQuery.

Refresh and Compare

Local Data Processing supports the following capabilities on BigQuery:

or from source location (BigQuery version 2).
into target location (BigQuery version 2).
Row-wise into target location (option -g) (BigQuery version 2).

Local Data Processing does not support the following capabilities on BigQuery:

Bulk load of multiple slices of same table can be done in parallel.

Other Capabilities

Local Data Processing supports the following capabilities on BigQuery:

International table and column names where DBMS is not configured with UTF-8 encoding (BigQuery version 2).
Always treat DBMS table names and column names as case sensitive, even if not configured (equivalent to location property Case_Sensitive_Names always set to TRUE) (BigQuery version 2).
Always treat DBMS schema names case sensitive (BigQuery version 2).

Local Data Processing does not support the following capabilities on BigQuery:

Use distribution key for parallelizing changes within a table ( with parameter DistributionKey).
Lossless binary float datatypes. No data loss when transporting float values (because base 2 fractions are never converted to base 10). The values for these datatypes, when selected back from the database, might be slightly different from the ones that were inserted. This leads to Compare differences.