Superset hands-on examples

​

Run a query

1. Select a catalog, schema, and table.
2. Enter a query and run it. Superset displays all available tables.

• Selects unique employee IDs and first names
• Orders the results by employee ID in ascending order
• Limits the results to 50 rows

SELECT DISTINCT employee_id, first_name
FROM employees1
ORDER BY employee_id ASC
LIMIT 50

• On Superset, this query would generate a table preview.
  

  SQL Lab query example
• If you’d rather create a table or view, you can click the dropdown menu beside Run. It provides an option to create a table or view.
  

  Create a table or view
• After running the query, the results appear in a table format.
  

  Query result
• You can also view a history of when you ran these queries.
  

  Query history

​

Create a dashboard

1. From the Superset navigation bar, click Charts and select + Chart to create a new chart.
2. Choose the dataset you want to visualize.
3. Choose a chart type, for example, Line Chart, and click Create New Chart.
4. Configure the chart:
   • Set the X-axis.
   • Set the Metrics.
   • Optional: Add filters or groupings as needed.
5. Click Create Chart to preview the chart.
6. Click Save, enter a chart name, select or create a dashboard, and click Save & Go to Dashboard.

Creating a chart in Superset

Dashboard created from the chart

​

Additional resources

• To get an overview of Superset, refer to the Superset in NexusOne page.
• For more details about Superset, refer to the Superset official documentation.
• To learn more about how NexusOne uses KeyCloak and Trino, refer to the NexusOne KeyCloak and Trino documentation.