Connecting via SQL Clients
Once you've gotten a connection password through our website, 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.
Once you get a connection password from our webpage, you can connect to bit.io through psql. You can connect easily using the Connection String from the Connect tab of your database page. Connect with
Alternately, you can provide the hostname, port, username, database name, and password to connect with psql. All of these details are available from the Connect tab.
Create a new PostgreSQL connection in PopSQL. Then, fill in the fields using the information provided by the "Connect" button on any https://bit.io repo page.
Select "Postgres" from "Select a connection type..." in the new connection menu. Copy the connection details from the "Connect" menu
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.
Tableau Desktop (see below for Tableau Online)
You can connect to Tableau via JDBC by selecting PostgreSQL in the "Connect to a Server" menu and filling in the details from your database page's Connect menu.
Updated 9 months ago