5.11. Using Apache Superset

Basic Usage for Presto on AWS

Login to Superset

1. CloudFormation Console
Navigate to the CloudFormation Console under “Management Tools” within the Services menu.
2. Outputs

Select your “Stack Name” and click the associated tab labeled “Outputs”.

../_images/presto_cft_outputs.png
3. Retrieve Superset Password
Find and copy the “Superset Admin Password”.
4. Superset URL
Locate and click the “Public Superset URL”.
5. Complete Login
Once at the sign in page, enter “admin” within the username field and your copied Superset password into the password field. You will then be redirected to the Superset dashboards page.

Query Demonstration - SQL Editor

1. SQL Editor
Navigate to the “SQL Lab” drop-down menu at the top of the page. Click “SQL Editor”.
2. Specify Database and Schema
Select the database drop-down menu, and click the “tpch” database. Move down to the schema drop-down menu and choose “sf1”.
3. Add Table

Under the add a table drop-down menu select “customer” to get a sense for the data you will be working on. Immediately, you should be presented with a preview of the customer table.

../_images/superset_add_table.png
4. Write the Query
Type the SQL code, from the screenshot below, into the window.
5. Run the Query

When finished typing and reviewing the SQL code, press “Run Query”.

../_images/superset_run_query.png
6. View Results

When done processing, Superset will display the results of your query under the “Results” tab below the query window, as shown in the screenshot below.

../_images/superset_view_results.png

Visualization and Dashboard Demonstration

1. Results → Visualization
From the Results tab navigate to the “Visualize” button located just above your results.
2. Specify Visualization

You will be presented with a visualization specification window.

  • Under the chart type drop-down menu select “Pie Chart”.
  • Under the agg_func drop-down menu select “AVG(x)” for the column Avg_Price.
  • Click “Visualize”.
../_images/superset_visualize.png
3. Finalize Visualization

You will be directed to a new page containing your preliminary visualization.

Data:

  • Navigate to the “Data” tab in the upper left-hand corner of the page to further tailor your graph.
  • Under the Group by drop-down menu deselect “Avg_Acct_Bal” and select “mktsegment”.
  • Double click on the “undefined - untitled” title on the visualization and type a new title.
  • A popup will appear prompting you to implement these changes. Click “Run Query”.

Style:

  • Select the “Style” tab directly next to the current “Data” tab to customize the aesthetics of your visualization.
  • Under the Label Type drop-down menu select “value”.
  • If you desire, further specify the colors of the wedges and location of the labels.
4. Save to Dashboard

When content, navigate to the “save” button at the top, left-hand corner of the page. You will be presented with a popup “ Save A Chart” window. From here, name the chart and specify a dashboard to save it to. If you don’t have an existing dashboard or wish to save it to a new one, name and add a new dashboard.

../_images/superset_save_chart.png ../_images/superset_market_analysis.png

Superset Documentation Reference

To learn more about Apache Superset and additional functions refer to their documentation.