# Jet Tables

With **Jet Tables**, you can build apps more efficiently using a PostgreSQL database hosted by Jet, which doesn't require any setup time.

Using Jet Database, you can:

* Interact with the data through a spreadsheet-style interface to easily edit, search, filter, and sort records
* Sync your 30+ data sources (Airtable, GoogleSheets, Firebase, ...) to Jet Tables
* Utilize a PostgreSQL database that is securely hosted
* Import or Export data in the different formats: CSV, XLS, XLSX, JSON
* Making SQL queries
* Multiple environments, including staging and production, can be used to manage the database

<figure><img src="https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LQ08RFAKZvFADEiXKFy%2Fuploads%2FAru0jqLY6ZhRvElKl85B%2Ftable%20view%202.png?alt=media&#x26;token=e10843ef-22f0-444e-92fe-66826e811c90" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
You can also use data from Jet Tables to [merge it](https://docs.jetadmin.io/user-guide/360-data-data-blending) with data from other data sources, write custom SQL on top of it, and access it through [the API](https://docs.jetadmin.io/user-guide/jet-admin-api#resources-api).
{% endhint %}

{% embed url="<https://www.youtube.com/watch?v=2rdWPCUiGd4&list=PLSkzi9eq0vBnUGMnwXrRRVo9TXUjZ7uSj&index=18&ab_channel=JetAdmin>" %}

### Creating a new resource

**To get started** with Jet tables, click "New Data" in the integrations list in the top left corner:

{% @arcade/embed flowId="FhhQdtmDCeG44iq8HxRl" url="<https://app.arcade.software/share/FhhQdtmDCeG44iq8HxRl>" %}

Then, you'll get to the page where you can set the initial configuration of your data source:

You can access the set-up menu by clicking the three dots next to the data source name **(1)**, where you can **change the name** or **delete** it.

You also get to choose how to **bring in your data**: you can either create a table by uploading the existing data in CSV, XLS, XLSX, or JSON **(2)** or create a new blank table to add fields and values manually **(3)**.

To create a new table, follow the steps:

1. Click on the `Add Icon`
2. Rename the Table
3. Click on the `Create` button
4. Click to **Import icon** to import the Data&#x20;

{% @arcade/embed flowId="ul6BhOueqoEHJjBbAXMf" url="<https://app.arcade.software/share/ul6BhOueqoEHJjBbAXMf>" %}

### Setting up the data

Then you'll be taken to the main data section. There are three main areas or parts:

* **(1)** In the left part, you can **manage collections** (tables) and the resource (Jet Tables) itself
* **(2)** In the top part, you scope in onto the individual table that's been selected on the left. You can switch between the tabs to **change the structure**, and the **field types,** and access the **API**
* **(3)** Here you can **manage the table's data**: add new records, change fields, and add new ones

<figure><img src="https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LQ08RFAKZvFADEiXKFy%2Fuploads%2FFLXX1vP6VIKPp78GmTVB%2Ftable%20view.png?alt=media&#x26;token=b4f5c966-b101-42ce-8c58-1eb2dcf39d32" alt=""><figcaption></figcaption></figure>

Now, we'll look at how to manage the data inside of a particular table.

{% hint style="info" %}
To learn about the **common** data section **functionality**, go to the [**data**](https://docs.jetadmin.io/user-guide/integrations/broken-reference) page
{% endhint %}

Now, to go from the dummy data to your own, there are two major paths:

* Import the data
* Edit the table directly

To **edit the data in the table** directly, you can edit the existing fields **(1)** and add new fields **(2)**

<figure><img src="https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LQ08RFAKZvFADEiXKFy%2Fuploads%2FClaNuX9LeHEWbTIECHo8%2Fedit%20or%20add%20field.png?alt=media&#x26;token=01be5b63-311c-4e88-8742-9850ad98fac2" alt=""><figcaption></figcaption></figure>

{% hint style="warning" %}
**Id** field (also referred to as "primary key"), can not be changed or deleted as it's used as a unique identifier of a record
{% endhint %}