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