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.

19301930

Select PostgreSQL

15141514

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
10041004

Click Connect, and you're ready to go!

17401740

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

22562256

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