Back to Presto

Apache Superset

presto-docs/src/main/sphinx/clients/superset.rst

0.2971.6 KB
Original Source

=============== Apache Superset

Apache Superset <https://superset.apache.org/>_ 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 <https://superset.apache.org/docs/intro>_.

  2. You may need pyhive to configure Superset to connect to Presto. See Connecting to Databases: Presto <https://superset.apache.org/docs/configuration/databases#presto>_ in the Superset documentation.

  3. Log into Superset as described in Log into Superset <https://superset.apache.org/docs/quickstart#3-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 <https://superset.apache.org/docs/configuration/databases#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.