Skip to content

Creating an Apache Superset data service using Ametnes Cloud#

Prerequisites#

Firstly, you need to have an Ametnes Data Service location. Follow this link to set up one.

Ensure you are running the latest version of the Ametnes Cloud Agent.

helm repo add ametnes https://ametnes.github.io/helm && helm repo update

Apache Superset depends on various components including;

  1. A postgres database to store the data service's state.
  2. A Redis for caching queries to various configured databases.

To deploy Apache Superset, you need to ensure you have at least 3Gb memory, 2 vCPUs and 10Gb storage space.

Deployment constraints#

If you have deployment constraints that you must follow, these include;

  1. Storage by way of kubernetes storage class.
  2. On specific compute nodes by way of kubernetes taints and tolerations.

Follow this guide on how to set up your dataservice for these constraints.

Create the service#

Sign into your Ametnes Cloud console#

Follow this link.

With an internal postgres database.#

  1. Using the Services left menu, navigate to the service management dashboard.
  2. Click New Service.
  3. Enter the Superset to filter from the list and select Create
  4. In the displayed form, enter the following info.
    1. Enter the Name: Superset-Service-DSL1 and Description: Superset-Service-DSL1.
    2. Select a Version from the list.
    3. Select the Location: Demo/DSL1.
    4. Enter an Admin User and Admin Password that will be used to authenticate into the Superset service.
    5. Click Create.
    6. Wait a short while and your data service will be ready.

With an external postgres database.#

  1. Using the Services left menu, navigate to the service management dashboard.
  2. Click New Service.
  3. Enter the Superset to filter from the list and select Create
  4. In the displayed form, enter the following info.
    1. Enter the Name: Superset-Service-DSL1 and Description: Superset-Service-DSL1.
    2. Select a Version from the list.
    3. Select the Location: Demo/DSL1.
    4. Enter an Admin User and Admin Password that will be used to authenticate into the Superset service.
    5. Enter the Database Host, Database Port, Database User (the user must have full write permissions to the database), Database Password and Database Name (The database should be a blank database)
    6. Click Create.
    7. Wait a short while and your data service will be ready.

Test connectivity#

  1. In your browser, paste the URL https://<your.instance.host.name>/.
  2. You should get a prompt to login.