Superset

Available in VPC

Connect to external BI - Superset

To connect Data Query from Superset, follow these steps:

Sign in to the installed Superset and click Settings > Data - Database Connection menu at the top right of the screen.
Click the + Database button at the top right of the Databases menu.
Select trino from Supported databases below.
On the Basic tab of the Enter primary credentials step, enter the display name and the URI below in the SQLALCHEMY URI field.
After checking the connection status with Test connection, click the Finish button to complete the creation of the database to connect.
Click SQL > SQL Lab menu at the top of the Superset, and check if the schema and table lists of the created database are viewed normally.

Note

Data Query connection SQLALCHEMY URI

trino://{SubAccount ACCESS_KEY}:{SubAccount SECRET_KEY}@{Data Query DOMAIN}:443/{User's Data Source name}
- URI example
```
trino://A6____F8:1B____F3@kr.dataquery.naverncp.com:443/data_catalog
```

Connection screen

Caution

Depending on how the external BI tool manages the schema, this may result in periodic or frequent query calls.

Troubleshoot

Depending on the Superset build types(for example, build for production), the trino driver required for Data Query connection may not be included by default.
If Database Connection creation fails for this reason, add the driver based on your Superset installation type referring to the following methods:

1. PyPI installation environment

Superset > Installation (PyPI)
Install sqlalchemy-trino package in the environment where Superset is installed.
```
pip install sqlalchemy-trino
```

2. Docker Compose installation environment

Superset > Installation (Docker Compose)
While deploying Superset in the form of Docker Compose,
add sqlalchemy-trino in requirements-local.txt and run the Docker Compose Up command.
```
echo "sqlalchemy-trino" >> ./docker/requirements-local.txt
```

3. Kubernetes environment

Superset > Installation (Kubernetes)

Add sqlalchemy-trino in bootstrapScript in the helm value file.

bootstrapScript: |
  #!/bin/bash
  pip install sqlalchemy-trino