---
title: Adding a New Table
slug: kronpam-how-to-guides/adding-a-new-table
description: Learn how to add specific tables to Superset for querying in this comprehensive document. Follow the step-by-step instructions, including entering the Table Name and Database, optionally adding the database schema, and saving the configuration. Discover h
docTags: 
createdAt: 2022-08-18T14:06:16.000Z
---

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.&#x20;

**Step 1:** To add a new table:

1. Under the **Sources** menu, select the **Tables** option.

::Image[]{src="https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/huC3ulLQX1kdhdTsGdnLL_image.png" size="38" width="296" height="187" position="center" showCaption="false"}

- On the resulting page, click on the green plus + sign near the top left.


::Image[]{src="https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/cHALP2TVeq9IcM2_cRo_9_image.png" size="34" width="268" height="191" position="center" showCaption="false"}

- &#x20;3\. You only need a few pieces of information to add a new table to Superset:

Enter the **Table Name**.

::Image[]{src="https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/4yMze9X5yorTUKYO0FtD7_image.png" size="50" width="726" height="124" position="center" showCaption="false"}

Select the target database from the **Database** dropdown menu.

::Image[]{src="https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/QK74U2Qda3YrUA5ODhulQ_image.png" size="34" width="326" height="182" position="center" showCaption="false"}

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.

::Image[]{src="https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/DuO4gLtuCjCUWwiQxnF-z_image.png" size="38" width="186" height="96" position="center" showCaption="false"}

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

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/2AoHeGVXQKFpRFOW132jg_image.png)

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.

::Image[]{src="https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/W503PvNlCZ77npcdlyCUK_image.png" size="38" width="469" height="183" position="center" showCaption="false"}

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:

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/ZtyqXb-XhxVqkAWiKVQp1_image.png)

&#x20; 3\. As with the configurations above, click the **Save** button to save these settings.
