Migrate Superset to Elestio

This migration document focuses on the migration of the applications supported by Elestio. Find the software list here

This document provides a step-by-step guide for migrating your existing Superset pipelines to Elestio. Elestio is designed to enhance performance, scalability, and overall system efficiency. Before you begin the migration process, make sure to check the pre-requisites

1️⃣ Pre-requisites

  1. Create an account on Elestio

  2. Log in to your Superset admin dashboard account on the server where your current Superset is deployed

  3. Make sure the UI for the application is working fine and there are no critical errors detected in the application logs. If found otherwise please feel free to create a support ticket

  4. When deploying the service on Elestio, use the same software version as your present service, or your data migration will fail.

2️⃣ Exporting the Dashboards and Data

  1. Head over to your original (source) dashboard of superset

  2. Select all the dashboards you are planning on migrating and click on Export

Migrate Superset to Elestio

  1. Similarly, head over to the charts section, select all the required charts, and click on Export

Migrate Superset to Elestio

  1. These exported files will be stored in your local machine in .zip format

  2. You will have to reconfigure your connected database with Superset after the migration so you should make sure you have all the information required for configuration

  3. If you have a database connected with the Superset then head over to Elestio's Migration Docs similar to this for migration instructions for the specific database

If you want to migrate the database to seamless integration with the Superset then head over to Elestio's Migration Docs similar to this for migration instructions for the specific databases.

3️⃣ Importing the Dashboards and Data

  1. Login to your Elestio account

  2. Go to Create Services and select "Superset"

  3. Select service provider, region, and service information

Migrate Superset to Elestio

  1. Name your service, configurations, and support layer, and hit "Create Service"

Migrate Superset to Elestio

  1. Once deployed, head over to the service details and use the credentials provided under "Admin UI" to access the Superset dashboard.

Migrate Superset to Elestio

  1. Once logged in, head over to the dashboard tab and click on the import button as shown in the image

Migrate Superset to Elestio

  1. Click on "Select File" select the export (.zip) you exported from the previous step and click on "Import"

Migrate Superset to Elestio

  1. Additionally, you can add and configure your databases from the settings shown in the image below

Migrate Superset to Elestio

Woohoo 🎉 you have successfully imported all your dashboards and repeat the same to import the charts.

4️⃣ Testing the Migration

  1. You have successfully migrated to Elestio, now it's time for testing if your application is running as you intended

  2. Head over to the Dashboard and check if you can still see the dashboards like your previous instance

  3. Here as you can see, my new dashboards have successfully been imported as I showed during the import

Migrate Superset to Elestio

5️⃣ Need additional help?

Stuck somewhere? We are here to help you, go ahead and create a support ticket and we will get back to you in no time.

Originally published at https://docs.elest.io on November 22, 2023.

0
Subscribe to my newsletter

Read articles from Kaiwalya Koparkar directly inside your inbox. Subscribe to the newsletter, and don't miss out.

Written by

Kaiwalya Koparkar
Kaiwalya Koparkar

I am Kaiwalya Koparkar, founder of Geek Around Community, a GitHub Campus Expert, MLH Coach, Open-Source Advocate & DevRel. I work as a Program Manager/ Community Manager in several communities. I love to speak at sessions, workshops, meetups, and conferences. In the past year, I have won over 10+ hackathons and mentored/judged/participated in over 35+ global hackathons.