Adding a New Table
This is the second step of creating your own report with the Reporting module.
Now that youâve configured a database, youâll need to add specific tables to Superset that youâd like to query.
Step 1: To add a new table:
- Under the Sources menu, select the Tables option.
- On the resulting page, click on the green plus + sign near the top left.
- 3. You only need a few pieces of information to add a new table to Superset:
Enter the Table Name.
Select the target database from the Database dropdown menu.
Optionally, add the database schema. If the table exists in the âdefaultâ schema (e.g., the public schema in PostgreSQL or Redshift), you can leave the schema field blank.
- Click on the Save button to save the configuration.
When redirected back to the list of tables, you should see a message indicating that your table was created:
This message also directs you to edit the table configuration. Weâll edit a limited portion of the configuration now - just to get you started - and leave the rest for a more advanced tutorial.
Step 2: To edit the table:
- Click on the Edit button next to the table youâve created.
2. On the resulting page, click on the List Table Column tab. Here, youâll define how you can use specific columns of your table when exploring your data. Weâll run through these options to describe their purpose:
- If you want users to group metrics by a specific field, mark it as Groupable.
- If you need to filter on a specific field, mark it as Filterable.
- Is this field something youâd like to get a distinct count of? Check the Count Distinct box.
- Is this a metric you want to sum or get basic summary statistics for? The Sum, Min, and Max columns will help.
- The is temporal field should be checked for any date or time fields. Weâll cover how this manifests itself in analyses in a moment.
Hereâs how weâve configured fields for the weather data. Even for measures like the weather measurements (precipitation, snowfall, etc.), itâs ideal to group and filter by these values:
3. As with the configurations above, click the Save button to save these settings.