Tables

You can create tables in the Catalyst Data Store to store your application’s data. You can create columns for a table that categorize and group similar data together, and then create records.

In Catalyst terminology, the rows in the Data Store represent the individual records of the table, and the columns represent the fields that are created for a table.

Note: You can create upto 200 tables in each project in the development environment. You can request Catalyst for an increase in this limit by contacting our support at support@zohocatalyst.com. We will address each request on a case-by-case basis. There are no upper limits for table creation in the production environment.

Create a New Table

To create a new table in the Data Store:

  1. Navigate to Data Store under Storage in the Catalyst Cloud Scale console.

  2. In the Data Store page, click Create a new Table.
    Data Store- Create a Table

  3. Enter the Table Name in the text box and click Create.
    Data Store- Create a Table

Note: The table name can only contain alphanumeric characters and underscores. Do not include any whitespace or special characters. The table name should also not start with any numeric characters.

The table is now created and displayed in the Data Store page. All tables that you create will be listed on the left hand side of the page.

Data Store- Table Created

Once your table is created, a unique Table ID is created for it automatically. You can use it to refer to the table when working with the SDKs and APIs. You can find the Table ID under the table’s name when you click on a table from the list.

You can use the search box to search for a particular table by its name.

When you create a new table in the Data Store, a set of default columns for its characteristics are created automatically. You can learn more about these columns in the next section.


Update a Table Name

To update a table name in the Data Store:

  1. In the Data Store page, click the ellipsis icon for the table that needs to be renamed and click Edit.
    Data Store- Edit a Table
  2. Enter the new name for the table and click Update.
    Data Store- Edit a Table

Truncate a Table

The truncate operation deletes all the records in the table, while retaining its schema. The columns of the table and the table’s metadata will still be available, after the operation has ended.

You can truncate a table if you want to re-populate a table with a new set of data periodically and clear the old data. You can also perform this operation if you want to avoid creating a new table from scratch, and use an existing table with pre-defined schema instead.

To truncate a table in the Data Store:

  1. Click the ellipsis icon for the table that needs to be truncated, then click Truncate.

Data Store- Truncate a Table


  1. Enter “TRUNCATE” in the pop-up window to confirm the operation, then click Confirm.
    Data Store- Truncate a Table

The truncate process will be initiated. A Catalyst scheduler will run in the background and execute the operation. You will be able to perform other operations in the Data Store while the truncate operation is still in progress.

After the truncate is complete, you will receive a notification in the console about the status of the operation.

Data Store- Truncate a Table

Delete a Table

To delete a table from the Data Store:

  1. Click the ellipsis icon for the table that needs to be deleted, then click Delete.
    Data Store- Delete a Table
  2. Click Yes, Proceed in the confirmation pop-up.
    Data Store- Delete a Table

The table is now deleted from the Data Store.


Last Updated 2023-06-07 21:05:57 +0530 +0530