---
title: "Create a Table"
url: https://docs.catalyst.zoho.com/en/tutorials/leadmanager-appsail/springboot/create-table/
description: "Build a Lead Manager application hosted on AppSail that connects to Zoho CRM using Catalyst connectors to view, create, update, or delete leads."
last_updated: 2026-11-04T10:10:44Z
service: All Services
type: tutorial
related_links:
  - name: "Data Store"
    url: /en/cloud-scale/help/data-store/introduction/
  - name: "ZCQL"
    url: /en/cloud-scale/help/zcql/introduction
---

# Create a Table

Next, let’s create a table in the **Data Store**. This table is used to store the *Refresh Token* and `userID` values, which are retrieved whenever an *Access Token* needs to be generated.

To create a table:

1. Navigate to the [Catalyst CloudScale](https://docs.catalyst.zoho.com/en/cloud-scale/) service section in the console and click **Start Exploring**.
    ![catalyst_tutorials_leadmanager_appsail_start_explore_cloud_scale](https://catalyst-docs-development.zohostratus.in/images/tutorials/leadmanager-appsail/catalyst_tutorials_leadmanager_appsail_start_explore_cloud_scale.webp)

2. Click **Create a new Table**.
    ![catalyst_tutorials_lkeadmanager_appsail_create_table](https://catalyst-docs-development.zohostratus.in/images/tutorials/leadmanager-appsail/data-store-create-new-table.webp)

3. Enter the table’s name as "`Token`" and click **Create**.
    ![catalyst_tutorials_leadmanager_appsail_table_nme](https://catalyst-docs-development.zohostratus.in/images/tutorials/leadmanager-appsail/catalyst_tutorials_leadmanager_appsail_table_nme.webp)

> **Note:** Ensure that you enter the name exactly as instructed because the application's code contains the same name.

The table will be created.

![catalyst_tutorials_leadmnager_appsail_table_created](https://catalyst-docs-development.zohostratus.in/images/tutorials/leadmanager-appsail/catalyst_tutorials_leadmnager_appsail_table_created.webp)

Now, let’s create two columns in the table to store the `userID` and the `refresh token` respectively.

> **Info:** You can learn about the various data types supported by Catalyst and the other properties of a column from the [Data Store help documentation](https://docs.catalyst.zoho.com/en/cloud-scale/help/data-store/introduction/).

4. Click **New Column** in the *Schema View* section.
    ![catalyst_tutorials_leadmanager_appsail_new_clm](https://catalyst-docs-development.zohostratus.in/images/tutorials/leadmanager-appsail/catalyst_tutorials_leadmanager_appsail_new_clm.webp)

5. Enter the column’s name as "refresh_token". Select the data type as Encrypted Text.
    ![catalyst_tutorials_leadmanager_appsail_clm_name](https://catalyst-docs-development.zohostratus.in/images/tutorials/leadmanager-appsail/catalyst_tutorials_leadmanager_appsail_clm_name.webp)

6. Click **Create**.
    ![catalyst_tutorials_leadmanager_appsail_clm_1_created](https://catalyst-docs-development.zohostratus.in/images/tutorials/leadmanager-appsail/catalyst_tutorials_leadmanager_appsail_clm_1_created.webp)

7. Now click the **New Column** button again to create the second column. Name it "`userId`", and select **BigInt** as its data type.
    ![catalyst_tutorials_leadmanager_appsail_clm_2](https://catalyst-docs-development.zohostratus.in/images/tutorials/leadmanager-appsail/catalyst_tutorials_leadmanager_appsail_clm_2.webp)

8. Click **Create**.
    ![catalyst_tutorials_leadmanager_appsail_clms_created](https://catalyst-docs-development.zohostratus.in/images/tutorials/leadmanager-appsail/catalyst_tutorials_leadmanager_appsail_clms_created.webp)

The required columns have been created.

### Configure Scopes and Permissions

To allow any user of the Lead Manager application to view or manage leads from the client application, you must enable an additional [table permission](https://docs.catalyst.zoho.com/en/cloud-scale/help/data-store/scopes-and-permissions) that will allow the user to fetch and store new *Refresh Tokens*, if needed.

To enable the required permissions:

1. Click the **Scopes and Permissions** tab.
    ![catalyst_tutorials_leadmanager_appsail_tables_permissions](https://catalyst-docs-development.zohostratus.in/images/tutorials/leadmanager-appsail/catalyst_tutorials_leadmanager_appsail_tables_permissions.webp)

2. Enable the **Insert** permission for the **App User** role under the *Table Permissions* section. Ensure you do not change any other permission setting.
    ![catalyst_tutorials_leadmanager_appsail_permission_aet](https://catalyst-docs-development.zohostratus.in/images/tutorials/leadmanager-appsail/catalyst_tutorials_leadmanager_appsail_permission_aet.webp)

The Data Store component is now configured for the application.