We're happy to announce the beta release of our new Postgres Proxy support. Our goal is to allow any BI and data science tools which support PostgreSQL, to connect to directly with data.world. No 3rd party integration support required!
data.world provides a federated engine to query data from multiple data systems simultaneously, at the source. By using Postgres Proxy, it’s now easier than ever to extend these capabilities to your favorite analysis tools for quickly accessing and creating value from data.
To connect to data.world using the proxy, simply create a new PostgreSQL connection, configured as follows:
host: postgres.data.world
port: 5432
user: {your data.world user id}
pass: {read/write token}
db: agentid/datasetid
You can find your read/write token in the user settings. If you have any issues or questions, don't hesitate to reach out.
Note: for single tenant customers, set host to postgres.{site}.data.world
.