Superset

Available in VPC

Superset is a data visualization BI tool based on the Apache open source web. You can use data stored in an uploaded Excel file or PostgreSQL DB that has been installed together to create a visualization dashboard.

Creating and accessing server

The method for creating and accessing the server is the same as creating a regular server on NAVER Cloud Platform. The following are detailed procedures and reference guides:

Using Superset

When the server is created, you can access and use the service through the web browser.

Access PostgreSQL DB

If preparations are required in the DB, you can access PostgreSQL DB in the docker to run the required tasks.

1. While connected to the server, enter the docker ps command.
   • The container information of the docker is displayed.
2. Check the container name of the docker where PostgreSQL is installed.
3. Utilize the container name you checked, and then enter the docker exec -it (Container name) /bin/bash command.
   • <example> When the container name is superset_postgres_1, docker exec -it superset_postgres_1 /bin/bash
   • Enter the PostgreSQL docker.
4. Enter the psql -U superset -d superset command to access the DB.
5. Run the required DB tasks.
6. If you've completed DB tasks, enter the \q command to end DB access.
7. Enter the exit command to end docker access.

Getting started with Superset

The following describes how to get started with Superset on the web browser.

1. Enter the URL on the web browser.

   • VPC environment: access an externally accessible VPC server, and then enter http://(public ip address):18088

2. When the login page appears, enter the admin account to log in.

   • Username: admin
   • Password: server name set on the NAVER Cloud Platform console
   Note

   Change your password to protect your security. Click the Security > List Users menus on the Superset page, in that order, and then click > Reset Password of the admin account to change the password.

Superset functions

You can use the various functions of Superset by clicking the upper menu of the Superset page.

• When you click the Dashboards menu, the same dashboard is displayed. To create and use more dashboards, see Superset webpage.
• After you add DB settings information in the Sources menu, you can use PostgreSQL DB.
  • The initial password of the Superset account is ncloud123!@#!, and you can access it only on the server where Superset and PostgreSQL are installed.
  • Set SQLAlchemy URI: postgresql://superset:ncloud123!@#!@postgres:5432/Database name