Connecting via Apache SuperSet

SuperSet provides a SQL editor, charting ability, and other data exploration tools. SuperSet works very well with bit.io!

First, add a database.

1930

Select PostgreSQL

1514

You'll need some information from bit.io for the next step. Go to your repo page and click the green Connect button on the upper right. Copy your password.

The other settings you need:

  • Host is db.bit.io
  • Port is 5432
  • Database is your Database name
  • Username is your bit.io username
  • Password is the password from the Connect tab, not your bit.io login password.
  • Enable SSL
1004

Click Connect, and you're ready to go!

1740

To start querying your data, navigate to "SQL Editor" under "SQL Lab" and select your database from the drop-down menu on the left.

2256

Congrats! Now you can start querying your data using SuperSet.