Presto

The pyhive library is the recommended way to connect to Presto through SQLAlchemy.

The expected connection string is formatted as follows:

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

You can pass in a username and password as well:

  1. presto://{username}:{password}@{hostname}:{port}/{database}

Here is an example connection string with values:

  1. presto://datascientist:securepassword@presto.example.com:8080/hive

By default Superset assumes the most recent version of Presto is being used when querying the datasource. If you’re using an older version of Presto, you can configure it in the extra parameter:

  1. {
  2. "version": "0.123"
  3. }