Superset docker image with Teradata database drivers. Uses the Teradata Dialect for SQL Alchemy. Currently only supports SQLite database backend for superset metadata.
- Clone or Download this repository.
- Download the Teradata ODBC Drivers for Linux (you will need to register and accept the licence terms). And place the tar.gz file in this directory.
- Optional: Edit the defaults for application configuration options or admin credentials. These files will be used to setup application and create the metadata backend if no persistent Superset config is found.
- Navigate to this directory and build the Docker image:
docker build -t superset-td .
By default, this image will setup a local Superset application and database backend at runtime, using its default application and admin settings. This of course implies that any changes made will be lost with the container, but this is good enough to test the image.
run -d --name superset-td -p 8088:8088 superset-td
To persist the backend and application configuration, mount a volume to the /superset point.
If not found, the default Superset application and database backend will be deployed to this volume.
docker run -it --name superset-td -v /tmp/superset:/superset:z -p 8088:8088 superset-td
- Open a web browser and point to the superset application at
<hostname>:<port>. E.g. http://localhost:8088 (Default on a local deployment) - Login with the admin user and password. See defaults in config file.
- Create the database connection:
- Go to Sources>Databases and click "Add a new record". E.g. http://localhost:8088/databaseview/add.
- Enter a name for the Database connection.
- Specify the SQLAlchemy URL, specifying 'teradata' for the dialect. E.g
teradata://user:password@192.168.123.123/dbc. - You may want to check "Expose in SQL Lab" to directly write queries in the SQL lab.
- Test/Save connection.
- Import tables/views:
- Go to Sources>Tables and click "Add a new record". E.g. http://localhost:8088/tablemodelview/add.
- Select the database connection, schema (e.g. 'dbc'), table (e.g. 'tables').
- Click save and click on the table name to start editing a slice!