postgres_fdw
FOREIGN SERVER.
You can utilize postgres_fdw’s advance push-down capabilities to maximize the performance of your queries involving BigQuery and Snowflake tables. For queries where push-down is important, you can expect 100x performance gains compared to other foreign data wrappers.Let’s go through steps to query BigQuery and Snowflake using PeerDB.
(…)
with the appropriate connection details for both the Postgres and Snowflake instances. More details on adding PEERs are available here.
postgres_fdw
postgres_fdw
. As PeerDB is Postgres wire-compatible, you can connect to PeerDB as a postgres_fdw FOREIGN SERVER from your Postgres database and start querying tables in Peers that have been created on PeerDB.
Let’s walk through the steps to query tables in BigQuery from your existing Postgres database using PeerDB.