Welcome to Datalyst!

Connect Airtable

Datalyst.ai offers seamless integration with Airtable, allowing users to analyze and derive insights from their structured data stored in Airtable. Below is a detailed guide on connecting your Airtable data source to Datalyst.ai.

Step 1: Select Airtable as the Data Source

Description: Begin by selecting Airtable as the type of data source you want to connect.

How to Do It:

  1. Log in to Datalyst.ai and navigate to the "Data > Data Sources" section.
  2. Click on "Add Data Source".
  3. From the list of available data sources, select "Airtable".

Step 2: Configure Connection Information

Description: Provide the necessary connection details for Datalyst.ai to access your Airtable data. This typically includes:

  • Airtable API Key
  • Base ID

How to Do It:

  1. Obtain your Airtable API Key and Base ID from your Airtable account settings.
  2. Enter your Airtable API Key and Base ID in the designated fields.
  3. Click "Test Connection" to ensure the connection details are correct and the connection is successful.

Step 3: Choose Airtable Tables

Description: Select specific tables or views from your Airtable base that you want Datalyst.ai to connect to and analyze.

How to Do It:

  1. After successfully testing the connection, you'll see a list of tables/views from your Airtable base.
  2. Browse through the list and select the tables/views you wish to connect.
  3. Optionally, you can specify particular fields or criteria if you don't want to import the entire table/view.

Step 4: Configure Data Source Name and Update Schedule

Description: Name the data source and set up a schedule for Datalyst.ai to automatically collect and update the Airtable data.

How to Do It:

  1. Enter a descriptive name for the data source in the "Data Source Name" field.
  2. Optionally, provide a brief description.
  3. Choose the update frequency for data refreshes (e.g., daily at 2 AM) in the "Update Schedule" section.
  4. Click "Save" to finalize the setup.

Example Configuration

Example: Connecting to Airtable

  • Step 1: Select "Airtable" from the data source list.
  • Step 2:
    • Airtable API Key: your_airtable_api_key
    • Base ID: your_airtable_base_id
  • Step 3: Choose tables/views such as Customers, Orders, and Products.
  • Step 4:
    • Data Source Name: "Airtable Data"
    • Update Schedule: Daily at 2 AM

Benefits of Connecting Airtable to Datalyst.ai

  • Comprehensive Analysis: Utilize Datalyst.ai's analytical tools to gain insights from your Airtable structured data.
  • Automated Updates: Ensure your data is always current with automatic updates scheduled according to your preferences.
  • Seamless Integration: Easily manage and analyze Airtable data alongside other connected data sources.

Datalyst.ai's Connections feature simplifies the integration of your Airtable data source, empowering you to leverage your structured data for informed decision-making.