Limitations

The CDC Replication Engine for BigQuery does not support the following features.

• Derived expression:
  • %GETCOL() is not supported.
  • %CURR() is not supported.
  • %ORDERTAB() is not supported.
  • %USERFUNC is not supported.
• Conflict detection and resolution are not supported.
• User exits are not supported.
• JDBC refresh: CDC Replication Engine for BigQuery supports only fast load refresh. JDBC refresh or JDBC parameters are not supported as the CDC Replication Engine for BigQuery uses the BigQuery REST API to connect to the data warehouse.
• Referential integrity or primary key constraints are not supported.
• LOBs mapped to any BigQuery data types are not supported.
• Filtering where clause during refresh is not supported.