We are planning to use the BigQuery Data Transfer Service PostgreSQL connector with full ingestion from Cloud SQL PostgreSQL. During one transfer run, are all source tables read from a single PostgreSQL transaction or exported snapshot?
In general, what are the transactional or data consistency guarantees?