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:
- PostgreSQL
- MySQL / MariaDB
- Amazon Redshift
- Apache Druid
- Apache Hive
- Apache Spark
- Presto DB
- Apache Impala
- Azure MS SQL
- Microsoft SQL Server
- Teradata
- 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.
ssh ec2-user@<INSTANCE-IP>
Before installing the package, be sure to switch to the superset
user.
sudo su - superset
From here you can install the package like normal using pip
.
The following example will install the Oracle database connector to the Superset instance.
pip install cx_Oracle
cx_Oracle
with 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.