We are evaluating options for moving data from a PostgreSQL database into a Google BigQuery datamart and would appreciate guidance on the recommended architecture, tooling, and implementation approach.

Specifically, we are looking to understand:

• Recommended methods for extracting data from PostgreSQL and loading it into BigQuery.
• Options for both full-load and incremental/CDC (Change Data Capture) replication.
• Best practices for designing and maintaining a BigQuery datamart sourced from PostgreSQL.
• Recommended orchestration, scheduling, and monitoring solutions for this data movement process.
• Security, connectivity, and performance considerations.
• Available native or enterprise-approved tools (e.g., Fivetran, Dataflow, Airflow, Google-native services, or other supported ETL/ELT platforms).
• High-level implementation steps and operational considerations for a team that is new to this technology stack.

Our goal is to establish a reliable, scalable, and supportable data pipeline that keeps BigQuery synchronized with PostgreSQL while following organizational standards and best practices.

Any reference architectures, documentation, examples, or recommended learning resources would be greatly appreciated.

Louis