Use the Openflow Connector for Google BigQuery

Note

This connector is subject to the Snowflake Connector Terms.

This topic describes tasks you may need to perform after installing and configuring the connector.

Remove and re-add a table for replication

To remove a table from replication:

  1. Verify the table’s state in the Table State Store.

  2. If the state is INCREMENTAL_IN_PROGRESS, stop the Trigger BigQuery Cdc On Incremental processor. Wait for the state to change to INCREMENTAL_REPLICATION.

  3. Remove the table from the Included Table Names or Included Table Names Regex parameters in the BigQuery Ingestion Parameters context.

To re-add a table for replication:

  1. Drop the destination table in Snowflake.

  2. Add the table back to the Included Table Names or Included Table Names Regex parameters.

This approach can also be used to recover from a failed table replication scenario.