How-To Guides
...
Reporting Guides
Create Your Own Report with Re...

Adding a New Table

6min

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:

  1. Under the Sources menu, select the Tables option.
Document image
ï»ż
  • On the resulting page, click on the green plus + sign near the top left.
Document image
ï»ż
  • 3. You only need a few pieces of information to add a new table to Superset:

Enter the Table Name.

Document image
ï»ż

Select the target database from the Database dropdown menu.

Document image
ï»ż

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.
Document image
ï»ż

When redirected back to the list of tables, you should see a message indicating that your table was created:

Document image
ï»ż

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:

  1. Click on the Edit button next to the table you’ve created.
Document image
ï»ż

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:

Document image
ï»ż

3. As with the configurations above, click the Save button to save these settings.