Connecting via SQL Clients

Once you've gotten a connection password through our website (see here for instructions on how to get a connection), you're ready to start connecting to bit.io through your preferred Postgres client. Below we've provided guides to for several of the clients we support.

psql

Once you get a connection password from our webpage, you can connect to bit.io through psql. You can either provide the url postgresql://your_connection_name:[email protected]:

or provide the host (db.bit.io), port (5432), and password (your connection password) to psql:

Tableau Desktop (see below for Tableau Online)

You can connect to Tableau via JDBC by selecting Other Databases (JDBC) and providing the url jdbc:postgresql://db.bit.io:5432/bitdotio as shown below:

DataGrip

To connect to DataGrip via JDBC, you just need to provide to provide the host (db.bit.io), port (5432), and password (your connection token), as shown below:

PopSQL

Create a new connection in PopSQL. Then, fill in the fields using the information provided by the "Connect" button on any https://bit.io repo page.

The only fields that are necessary to copy are hostname and password. "Port" can remain the default (5432). Both "database" and "username" can be anything, they're irrelevant.

Postico

Create a new connection in Postico. Then, fill in the fields using the information provided by the "Connect" button on any https://bit.io repo page.

Only "Host" and "Password" are required. The other fields can remain blank.

--

Tableau Online (for Desktop, see above)

On your Home page, click New on the far upper right and click on Published Data Source. Then, in Connect Data pick Connectors and choose PostgreSQL. You can get the server from the Connect button in on your repo page, or just use db.bit.io. Click Sign In and you're done!