Presto

0: Prerequisites

Run through the Quick Start guide and shut down the frontend server process.

1: Update the data sources configuration

Add your MySQL database URL and credentials in thirdeye-pinot/config/datasources/data-sources-config.yml. You will be able to add multiple databases with multiple credentials, as follows:

dataSourceConfigs:
  - className: org.apache.pinot.thirdeye.datasource.sql.SqlThirdEyeDataSource
    properties:
      Presto:
        - db:
            <dbname1>: jdbc:presto://<db url1>
            <dbname2>: jdbc:presto://<db url2>
          user: <username>
          password: <password>
         - db:
            <dbname3>: jdbc:presto://<db url3>
            <dbname4>: jdbc:presto://<db url4>
          user: <username2>
          password: <password2>

Note: the dbname here is an arbitrary name that you want to name it. In dburl, you still need to include the specific database you are using.

2: Run ThirdEye frontend

./run-frontend.sh

3: Import metric from Presto

See Import metric from Presto/MySQL.

4: Start an analysis

Point your favorite browser to

http://localhost:1426/app/#/rootcause

and type any data set or metric name (fragment) in the search box. Auto-complete will now list the names of matching metrics. Select any metric to start an investigation.