Create a Table

Let’s now create a table in the Data Store of the AlienCity project. This table is used to store records of city names where aliens were sighted.

To create a table:

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

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

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

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_datastore_table_created

  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_column_datastore

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.

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

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


Last Updated 2024-03-25 14:47:40 +0530 +0530

RELATED LINKS

Data Store