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 Cloud Scale service section in the console and click Start Exploring.
   

2. Click Create a new Table.
   

3. Enter the table’s name as “Token” and click Create.
   

The table will be created.

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

4. Click New Column in the Schema View section.
   

5. Enter the column’s name as “refresh_token”. Select the data type as Encrypted Text.
   

6. Click Create.
   

7. Now click the New Column button again to create the second column. Name it “userId”, and select BigInt as its data type.
   

8. Click Create.
   

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 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.
   

2. Enable the Insert permission for the App User role under the Table Permissions section. Ensure you do not change any other permission setting.
   

The Data Store component is now configured for the application.