---
title: "Lookup Tables"
slug: "lookup-tables-1"
updated: 2025-12-23T11:54:24Z
published: 2025-12-23T11:58:53Z
canonical: "help.symphonysummitai.com/lookup-tables-1"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.symphonysummitai.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Lookup Tables

**Lookup tables** allow recipes to efficiently store, reference, and manage commonly used data in a tabular format with entry rows and value columns, similar to a cross-reference table. Lets you manually create, update, delete, and parse tables.

The **Lookup Tables** connector lets you build recipes that create, update, delete, and retrieve entry rows, or delete entire tables.

> [!NOTE]
> Note
> 
> Lookup tables have the following limitations:
> 
> - Maximum of 10 columns per table.
> - Up to 100,000 entries per table.
>   - The Get all entries action retrieves only the first 10,000 entries.
>   - Tables with more than 50,000 entries cannot be downloaded as a CSV file.
>   - When using Recipe Lifecycle Management, only 10,000 entries can be exported or imported.

To create a new Lookup Table, perform the following steps:

1. Log in to the Application.
2. Navigate to **Integration Hub** > **Tools** > **Lookup Tables**. ![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/lookup tables.png)

Figure: Navigation
3. Lookup Tables page is displayed. Click **+ New table** to create a new Lookup ![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/lt(1).png) Figure: Lookup Tables
4. Click on the ![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/pencil icon(1).png) edit icon, enter a name for the **Lookup Table.** ![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/edit pencil.png) Figure: Create Lookup Table
5. Click ![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/chek.png) **Save** icon to rename the Lookup Table. ![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/create lookup tab.png) Figure: Rename Lookup Table
6. You can add lookup tables using following methods:

![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/add(9).png)

Figure: Add Lookup Table
  - Import CSV
  - Add entries manually
  - Use a recipe action to programmatically insert or update data
7. To Import as CSV click **Import CSV** and upload the file. ![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/IMPORT CSV.png) Figure: Import CSV In the **Specify** action section, select one of the following options:

> [!NOTE]
> Note
> 
> Select the **Do not import the first row (header)** checkbox if the first row of the file should be excluded from the import.
  - Add row entries: Adds the CSV rows as new entries. Existing entries remain unchanged.
  - Replace existing data: Overwrites existing entries with the data from the uploaded CSV file.
8. To Add or Edit entries manually, perform the following:

![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/add manually.png)

Figure: Add entries manually
  - Click **Add entry**.
  - Enter values in each column of the new row.
  - Click **✓ Save** to save the entry.

## **Use Recipe Actions**

To automatically add and update entries, use the Add entry, Add entries, and Update entry recipe actions from the Lookup Tables.

The Lookup Tables connector lets you interact with Lookup tables through the following recipe actions:

- Add entry
- Add entries
- Lookup entry
- Search entries
- Get all entries
- Update entry
- Delete entry
- Delete multiple entries
- Truncate table