Create a Table

Now let’s create a table in the Data Store of the Alien City project. This table is used to store records of city names where aliens were seen.

To create a table:

  1. Navigate to the Cloud Scale section of the console, then click Start Exploring. catalyst_alien_city_cloud_scale_homepage

  2. Navigate to Data Store under Storage and click Create a New Table. catalyst_alien_city_create_table

  3. Enter the table’s name as “Alien City” and click Create. catalyst_alien_city_create_tablename

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

The table is now created.

Next, let’s create a column in the table to store the names of the cities.

  1. Click New Column in the Schema View section for the table. catalyst_alien_city_create_new_clm

  2. Enter the column’s name as “CityName.” Select the data type as Var Char and enter the max length as “100.” Click the Is Unique toggle switch to enable it. catalyst_alien_city_create_clm_dets

You can learn about the various data types supported by Catalyst, as well as the other properties of a column, from the Data Store help page.

  1. Click Create. catalyst_alien_city_create_clm_created

The column is now created and listed in the Schema View section.


Last Updated 2024-02-22 23:26:30 +0530 +0530

RELATED LINKS

Data Store