Add Superset to the cluster

You can configure Superset to use the SQLite database in the Python library. Alternatively, you can configure Superset to use the existing MySQL or Postgres database that you installed. MySQL or Postgres are suitable for production work. SQLite is suitable for development work only.

1. In Ambari, click Service > Add Service and select Superset. Accept the default node assignment, or select another node for the service. Click Next.
2. In Customize Services - Superset Metadata Storage, accept the default Superset Database Name, superset.
3. Select a database type.
   • SQLite and skip the next step. A superset user and database are already set up.
   • MySQL or Postgres
4. If you chose MySql or Postgres in the last step, open a terminal window, log into your database, create a superset user, and grant the superset user all privileges with the GRANT option. Create a superset database using the UTF8 character set.
   For example, in MySQL:

   CREATE USER 'superset'@'%' IDENTIFIED BY '<password>';
   GRANT ALL PRIVILEGES ON *.* TO 'superset'@'%';
   GRANT ALL PRIVILEGES ON *.* TO 'superset'@'%' WITH GRANT OPTION;
   FLUSH PRIVILEGES;
   
   CREATE DATABASE superset DEFAULT CHARACTER SET utf8;         

5. In Customize Services - Superset Metadata Storage continue configuring the Superset service: In Superset Database Password, enter the password.
6. In Database Host Name:
   • SQLite: Accept the default value localhost.
   • MySQL or Postgres: Change the value to the FQDN of the node where you installed the database.
7. In Superset Database port:
   • SQLite: 8088
   • MySQL: 3306
   • Postgres: 5432
8. In SECRET_KEY, enter a random number, (recommended 20-digits long) preceded by at least one alphabetic character.
   For example: ab19336102290664791884
9. In Advanced, in Advanced superset-env, enter a Superset Admin password.
   Do not change the Superset Admin Password. This password is encrypted and embedded in Ambari.
10. Accept the Superset Admin user name admin and other defaults. Click Next, click Deploy, and Complete. Restart services as required, starting from the top of the Ambari Services list.