Foreign data wrappers

You use PostgreSQL foreign data wrappers (FDWs) to query external data sources from a Timescale Cloud service. These external data sources can be one of the following:

• Other Timescale Cloud services
• PostgreSQL databases outside of Timescale Cloud

If you are using VPC peering, you can create FDWs in your Customer VPC to query a service in your Timescale Cloud project. However, you can't create FDWs in your Timescale Cloud services to query a data source in your Customer VPC. This is because Timescale Cloud VPC peering uses AWS PrivateLink for increased security. See VPC peering documentation for additional details.

PostgreSQL FDWs are particularly useful if you manage multiple Timescale Cloud services with different capabilities, and need to seamlessly access and merge regular and time-series data.

To follow the steps on this page:

• Create a target Timescale Cloud service with time-series and analytics enabled.

  You need your connection details. This procedure also works for self-hosted TimescaleDB.

To query another data source: