Skip to content

AWS infrastructure and custom config used to run CDS's instance of Superset.

License

Notifications You must be signed in to change notification settings

cds-snc/cds-superset

Repository files navigation

Superset

A modern, enterprise-ready business intelligence web application.

Setup

AWS

  1. Update the configuration in ./docker/superset_config.py.
  2. Build the Docker image with make build.
  3. Run Terraform apply with make apply.
  4. Create the database and admin user:
# Connect to the ECS task
aws ecs execute-command --cluster superset \
    --container superset \
    --task "$ECS_TASK_ID" \
    --region ca-central-1 \
    --interactive \
    --command "/bin/bash"

# Run database migrations
superset db upgrade

# Create admin user
superset fab create-admin \
    --username admin\
    --firstname Some \
    --lastname Body \
    --email [email protected] \
    --password "$ADMIN_PASSWORD"

# Setup roles/perms
superset init

Localhost

You will need Docker, and optionally VS Code devcontainers:

  1. Run make localhost.
  2. Username and password are admin at http://localhost:8088.

Databases

Use the database connection details in ./databases to connect to datasources.