# Airtable (Beta)

*Airtable support is currently **in beta**. Please raise any issues you encounter via the chat bubble in the bottom-right of the site, and we'll be happy to help.*

***

### Overview

Our Airtable integration allows you to:

* Import your data, allowing you to clean and transform your data as well as ask it questions via Chat Explore.

{% hint style="danger" %}
You must allow network traffic from the public IP address `54.197.189.139` in order to allow Akkio to access your data.
{% endhint %}

### Importing Data

To import data, first create a new project.

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FyAvYjZJdVfNys2RGIRzF%2Fimage%20(40).webp?alt=media&#x26;token=f7e1a7cc-798f-4f9c-b8b4-980698287332" alt=""><figcaption><p>Create a new flow from the homepage.</p></figcaption></figure>

Select the Airtable button.

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FWzgb0NlLCikUl9ZxrUJV%2Fimage%20(41).webp?alt=media&#x26;token=d454e06c-c5db-4850-8768-c25f0eff8c19" alt=""><figcaption></figcaption></figure>

Click "Connect Dataset" to add a new dataset.

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FaMoKobilXXn5zX9xTdeK%2Fimage.png?alt=media&#x26;token=6acc6e13-a3cd-4503-8033-9fb3092a2de9" alt=""><figcaption></figcaption></figure>

Enter connection details for your database.

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2F64zOBIq5ISmtL6o5xELP%2Fimage%20(42).webp?alt=media&#x26;token=c606cc5c-16ba-4e8c-a34a-ed52cd67e30a" alt=""><figcaption></figcaption></figure>

We need these fields to pull your data in:

* **Personal Access Token:** You can generate one here: <https://airtable.com/create/tokens>. This token *must* have scopes `data.records:read` and `schema:bases:read` as well as Access settings that permit access to whichever table you are trying to import.

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FKWiOAENioLDkVrerr4Vn%2Fimage.png?alt=media&#x26;token=f73fdee1-7bae-4bdd-8c78-50b6088f62f9" alt=""><figcaption><p>What your personal access token permissions should look like.</p></figcaption></figure>

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FhJz2mn0ZtBcTKJgmhH9g%2Fimage%20(43).webp?alt=media&#x26;token=b95207d6-d089-492f-bb9b-c6cced15d7d0" alt=""><figcaption></figcaption></figure>

Fill this information out then hit the "Continue" button. Next you will be prompted to enter the Base and Table names.

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2Fbw24Yi9ARyjhYIKrukr6%2Fimage%20(27).webp?alt=media&#x26;token=5012f397-c116-4092-8fd0-ae454e95230e" alt="" width="563"><figcaption></figcaption></figure>

Fill this information in and hit "Continue." We will then validate the connection.

If we're successful, you'll move forward to the data loading screen, where your data is syncing behind the scenes.

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FqH9fkPU3TonkjoUKOyt0%2Fimage.png?alt=media&#x26;token=75013bf2-6393-4f61-a165-5136a8803c27" alt=""><figcaption></figcaption></figure>

You may need to wait for a little bit for the data to import. Rest assured that we're importing data behind the scenes. Small datasets should only take a few minutes; large datasets may take longer.

Once your data is done importing, you'll see it populate onto the screen.

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FT2QiQwdkQMllWZVvNLqc%2Fimage.png?alt=media&#x26;token=dc40fca7-9290-44df-b271-5a7e7bd2543a" alt=""><figcaption></figcaption></figure>

From here, you can do anything you like to the data - clean and transform it on the Prepare tab, ask Chat Explore questions on the Explore tab, you name it!
