Replication of PostgreSQL to Google BiqQuery is taking long to load to destination regardless of the dataset size.
Connector - PostgreSQL on Google Cloud
Destination - Google BigQuery
Google Cloud PostgreSQL does not support the logical replication of the WAL. Fivetran, therefore, uses the XMIN sync strategy. This results in Fivetran performing full table scans each sync to identify new or updated records.