This topic describes how to use Superset to connect to DLA for data analytics.

Background information

DLA connects to other external systems over the MySQL protocol. Most BI tools can use a MySQL connector to connect to DLA. However, Superset cannot directly connect to DLA because Superset follows a strict rule to check the statements defined for tables. In addition, the table creation statements of DLA are different from those of MySQL. In this situation, you can modify the username to connect Superset to DLA.

Procedure

Append %lst=true to the username.

Example: If the original username is user and the password is pass, change the username to user%lst=true before you connect Superset to DLA.