Configuring Postgres Proxy on data.world
To use Postgres Proxy on data.world, you first need to create a PostgreSQL connection in your BI Tool for the dataset or project you want to analyse. Open your BI tool and create the connection with the following parameter values:
host: postgres.data.world
port: 5432
db: agentid/datasetid
user: {your data.world user id}
pass: {read/write token}
Note
For single tenant customers, set host to postgres.{site}.data.world
You can find the agentid/datasetid in the URL for the resource:
The read/write token is located in the Advanced settings in your profile. More information about your API tokens can be found here.