---
title: "Create a table"
url: https://docs.catalyst.zoho.com/en/tutorials/workdrivesync/java/create-table/
description: "Build a web application that synchronizes file uploads and deletions between two folders in the Catalyst Stratus and Zoho WorkDrive through APIs, using Catalyst functions and Event Listener"
last_updated: 2026-08-17T12:16:04Z
service: All Services
type: tutorial
related_links:
  - name: "Data Store"
    url: /en/cloud-scale/help/data-store/introduction
---

# Create a Table in the Data Store

Let's now create a table in the Data Store in the _WorkDriveSync_ project. This table stores the details of the files that are uploaded through the client application. This data is fetched to be displayed in the client, and is updated or deleted whenever the corresponding actions are performed.

To create a table:

1. Navigate to **Catalyst Cloud Scale** service in the console.
![cloudscale-service](https://catalyst-docs-development.zohostratus.in/images/tutorials/workdrivesync/cloud-scale-landing-page-work-drive-sync.webp) 

2. Navigate to the **Catalyst Cloud Scale DataStore** component and click **Create a new Table**. 
![create-new-table](https://catalyst-docs-development.zohostratus.in/images/tutorials/workdrivesync/cloud-scale-data-store-create-table.webp) 

3. Enter the table's name as "**FileVault**" and click **Create**.
 ![table-name](https://catalyst-docs-development.zohostratus.in/images/tutorials/workdrivesync/table-name-workdrive-sync-app.webp) 

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

<!-- The table is now created and displayed in the Catalyst Cloud Scale Data Store page.

![datastore-view](https://catalyst-docs-development.zohostratus.in/images/tutorials/workdrivesync/data-store-table-listed.webp) 
 -->

### Create Columns

Next, let's create columns in the table to store the metadata of the files.

1. Click **New Column** in the _Schema View_ section for the table.
 
<!-- ![new-column-button](https://catalyst-docs-development.zohostratus.in/images/tutorials/workdrivesync/new-column-button.webp) 
 -->

2. Enter the column's name as "**FileName**". Select the data type as **Var Char** with maximum size of **255**.![fileid-column](https://catalyst-docs-development.zohostratus.in/images/tutorials/workdrivesync/file-name-column-creation-work-drive-sync.webp)
 You can learn about the various data types supported by Catalyst and the other properties of a column from the [Data Store help page](https://docs.catalyst.zoho.com/en/cloud-scale/help/data-store/columns).

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

3. Click **Create**.

You must now **create 5 other columns** in the same way. The table must contain 6 columns in total with the following mandatory properties:

<table class="content-table">
<thead>
<tr>
<th><strong>Column Name</strong></th>
<th><strong>Data Type</strong></th>
<th><strong>Max Length</strong></th>
</tr>
</thead>
<tbody>
<tr>
<td>StratusUpload</td>
<td>Var Char</td>
<td>255</td>
</tr>
<tr>
<td>WorkDriveSync</td>
<td>Var Char</td>
<td>255</td>
</tr>
<tr>
<tr>
<td>UploadedTime</td>
<td>Var Char</td>
<td>255</td>
</tr>
<tr>
<td>FileSize</td>
<td>Int</td>
<td>-</td>
</tr>
<tr>
<td>WorkDriveFileID</td>
<td>Text</td>
<td>-</td>
</tr>
</tbody>
</table>

Create these columns and configure the specified values. You can ignore the other properties of the columns.

The columns will be created and listed in the Schema View section.

![all-columns](https://catalyst-docs-development.zohostratus.in/images/tutorials/workdrivesync/table-created-data-store-workdrive-sync.webp)

#### Configure Scopes and Permissions

Catalyst Data Store enables you to configure scopes and permissions for accessing each table by end users based on their [user roles](https://docs.catalyst.zoho.com/en/cloud-scale/help/authentication/user-management/users/introduction/).

Because this application involves viewing, inserting, updating, and deleting rows from this table, we must enable all these permissions for the role _App User_. This will enable all authenticated users to perform these actions through the client application. They will be enabled for the role _App Administrator_ by default.

Click the **Scopes & Permissions** tab, then **enable all permissions** for _App User_.

![scopes](https://catalyst-docs-development.zohostratus.in/images/tutorials/workdrivesync/table-permissions-workdrive-sync-app.webp)