Apache Superset

Apache Superset is an open source data exploration tool. Follow these steps to configure Superset to query Presto.

  1. Install or deploy Superset following the Superset documentation.
  2. You may need pyhive to configure Superset to connect to Presto. See Connecting to Databases: Presto in the Superset documentation.
  3. Log into Superset as described in Log into Superset.
  4. In the Superset UI, select + in the upper right to display the drop-down menu, then select Data, then Connect database.
  5. In the Connect a database window, select Presto.
  6. In SQLAlchemy URI, enter a connection string using the following format:

presto://{hostname}:{port}/{database}

For example, presto://<Presto-IP-address>:8080/system

For more information, see the Superset documentation for connecting to Presto. 7. Select Test Connection. If the message Connection looks good! is displayed, continue.

Note: If your Presto server is running locally, localhost may not resolve DNS successfully from the Superset docker compose launched instance to the local Presto server. Replace <Presto-IP-address> with your system’s actual IP address. 8. Select Connect.