Database Drivers Support
No need to install additional software drivers on your machine. Login to your Superset web interface and craft a connection string. The RO Labs Superset image comes pre-bundled with drivers for the following database engines:
- MySQL / MariaDB
- Amazon Redshift
- Apache Druid
- Apache Hive
- Apache Spark
- Presto DB
- Apache Impala
- Azure MS SQL
- Microsoft SQL Server
- Amazon Athena
Adding Additional Database Drivers
Of course, if you need other database connection packages, you can easily install them on your instance.
Make sure you have SSH access to your machine, and
ssh into your box using your instance's public IP address or DNS host name.
Before installing the package, be sure to switch to the
sudo su - superset
From here you can install the package like normal using
The following example will install the Oracle database connector to the Superset instance.
pip install cx_Oracle
cx_Oraclewith the SQL Academy driver of your choice. Wait for the installation to complete, and the package can then be used. For a list of supported database drivers and their packages, please refer to the official Apache Superset documentation.