Foreign data wrappers

Foreign data wrappers make data that lives elsewhere look like tables in your Postgres database, so you can join it with your own rows in one query.

Coming soon: Foreign data wrappers is being built

Foreign data wrappers is not available on the platform yet. This page describes how it works at launch; prices and plan limits are already published in Platform pricing and limits and nothing is billed before it is live.

Status changes are announced in the changelog; the platform overview lists where every capability stands.

How it works (at launch)

• Pick a source in the portal (Stripe, S3, ClickHouse, BigQuery, Airtable, Firebase, or another Postgres server with postgres_fdw), enter its credentials and choose the tables to import. A preview shows rows before anything is created.
• Credentials are stored encrypted in your database, never in the control plane.
• The wrapper’s tables live in a schema you choose, governed by the same grants and policies as your own tables.

SQL

select c.email, sum(i.amount_paid) / 100.0 as paid
from stripe.invoices i join customers c on c.stripe_id = i.customer
group by c.email;