Configuring Superset and Using SQL Lab

Superset has a flexible software architecture. This means that a Superset setup can be made for many different production environment needs. The production environment at Airbnb runs Superset inside Kubernetes and serves 600+ daily users, rendering over 100,000 charts every day.

At the same time, Superset can be set up with default settings for most users. When launching our first dashboard on a Google Compute Instance, we did not have to make any changes to the default parameters.

In this chapter, we will learn about the following:

• Setting the web server
• Metadata database
• Web server
• Setting up an NGINX reverse proxy
• Setting up HTTPS or SSL certification
• Flask-AppBuilder permissions
• Securing session data
• Caching queries
• Mapbox access token
• Long-running queries
• Upgrading Superset
• Main configuration file
• SQL Lab