Managing tables and directories

1. In the management console, navigate to the folder dashboard and select Managed Service for YDB.
2. Select the database to create a table in.
3. Navigate to the Navigation tab.
4. Choose Create → Table on the right side of the page.
5. Configure the table settings:
   • Table Name. Must be unique within the database.
   • Table type: Row table.
6. Add columns:
   • Column Name. Must be unique within the table.
   • Column data Type. Regardless of the data type, each column may contain a NULL value.
   • Primary key. Specify whether the column is part of the primary key. Primary indexes are automatically created based on the primary key.
7. If necessary, set up secondary indexes:
   • Secondary index Name. Must be unique within the table.
   • Key: One or more columns that make up a key for creating a secondary index.
8. Configure the partitioning policy:
   • None: The table is not partitioned.
   • Evenly: The entire range of values of Uint32 or Uint64 key columns (from 0 to the maximum value) is split into same-length intervals. When using this policy, set the number of intervals in the Count field.
   • Explicitly: Allows you to explicitly specify values for keys that will act as boundaries for initial table partitioning. To add another boundary value, click Add split point.
9. Configure automatic partitioning:
   • By size: If enabled, a partition is split into two when a certain data size is reached.
   • By load: If enabled, a partition is split into two if it is under high loads for a certain period of time (uses a lot of CPU time).
10. Configure advanced table settings:
    • Auto-partitioning by size in MB: Threshold data size at which auto partitioning by size is triggered.
    • Minimum number of partitions: Number of partitions in the table below which no partition merge by size or load is performed.
    • Maximum number of partitions: Number of partitions in the table above which no splitting by size or load is performed.
    • Bloom filter for primary key: If enabled, YDB uses a Bloom filter to search data by key. In some cases, it can speed up key reads.
11. Click Create table.

To create row-oriented tables, you can also use the CREATE TABLE command.

1. In the management console, navigate to the folder dashboard and select Managed Service for YDB.
2. Select the database to create a table in.
3. Choose Create → Table on the right side of the page.
4. Configure the table settings:
   • Table Name. Must be unique within the database.
   • Table type: Document table.
5. Add columns:
   • Column Name. Must be unique within the table.
   • Column data Type. Regardless of the data type, each column may contain a NULL value.
   • Partition key: Simple primary key that consists of one attribute. YDB uses the partitioning key value as an input for the internal hashing function. The result of the hash function calculation decides the partition the element will be stored in.
   • Sort key. The primary key can be composite and consist of a partitioning key and a sorting key. All elements with the same partitioning key will be stored together, sorted based on the sorting key. If a document table features a partitioning key and a sorting key, any two elements may contain the same partitioning key value but must contain different sorting key values.
6. Click Create table.

1. In the management console, navigate to the folder dashboard and select Managed Service for YDB.
2. Select the database to create a table in.
3. Navigate to the Navigation tab.
4. Choose Create → Table on the right side of the page.
5. Configure the table settings:
   • Table Name. Must be unique within the database.
   • Table type: Column table.
6. Add columns:

   • Column Name. Must be unique within the table.

   • Column data Type.

   • Primary key. Specify whether the column is part of the primary key. A primary index is automatically created based on the primary key.

     Note

     The order of columns in the primary key depends on the order of columns in the table being created.

   • NOT NULL constraint. Specify whether the column may contain the NULL value.

7. Configure the table TTL parameters:
   • Column. Select the column whose value will be used to calculate the lifetime of the rows.
   • Lifetime. Specify the lifetime of the table rows.
   • Unit. Select a unit of measurement for the table row lifetime you specified.
8. Configure partitioning:
   • Partition key: Specify a column to partition the table by.
   • Partition count: Specify the number of partitions for the table.
9. Click Create table.

To create column-oriented tables, you can also use the CREATE TABLE command.

In the YDB cloud console, you can add non-key columns to a table and change its automatic partitioning settings.

1. In the management console, navigate to the folder dashboard and select Managed Service for YDB.
2. Select the database to update a table in.
3. Find the table in the list and select → Edit.
4. Add new columns to the table and specify their parameters:
   • Column Name. Must be unique within the table.
   • Column data Type. Regardless of the data type, each column may contain a NULL value.
5. To delete non-key columns from the table, click in the appropriate line. You cannot delete columns that make up a primary key.
6. Configure automatic partitioning:
   • By size: If enabled, a partition is split into two when a certain data size is reached.
   • By load: If enabled, a partition is split into two if it is under high loads for a certain period of time (uses a lot of CPU time).
7. Configure advanced table settings:
   • Auto-partitioning by size in MB: Threshold data size at which auto partitioning by size is triggered.
   • Minimum number of partitions: Number of partitions in the table below which no partition merge by size or load is performed.
   • Maximum number of partitions: Number of partitions in the table above which no splitting by size or load is performed.
   • Bloom filter for primary key: If enabled, YDB uses a Bloom filter to search data by key. In some cases, it can speed up key reads.
8. Click Alter table.

1. In the management console, navigate to the folder dashboard and select Managed Service for YDB.
2. Select the database to update a table in.
3. Find the table in the list and click it.
4. Click Add row.
5. Enter the values for the columns listed in the form, then click Add.

1. In the management console, navigate to the folder dashboard and select Managed Service for YDB.

2. Select the database to update a table in.

3. Find the table in the list and select → Edit.

   Make the required updates in the table structure. Available actions:

   • Add new columns to the table and specify their parameters:
     • Column Name. Must be unique within the table.
     • Column data Type. Regardless of the data type, each column may contain a NULL value.
   • To delete non-key columns from the table, click in the appropriate row. You cannot delete columns that make up a primary key.
   • Configure the table TTL parameters:
     • Column. Select the column whose value will be used to calculate the lifetime of the rows.
     • Lifetime. Specify the lifetime of the table rows.
     • Unit. Select a unit of measurement for the table row lifetime you specified.

4. Click Alter table.

To update column-oriented tables, you can also use the ALTER TABLE command.

1. In the management console, navigate to the folder dashboard and select Managed Service for YDB.
2. Select the database to delete a table from.
3. Find the table in the list and select → Delete.
4. Confirm the deletion.

1. In the management console, navigate to the folder dashboard and select Managed Service for YDB.
2. Go to the database to delete a document table from.
3. Select a document table from the list of tables, then click → Delete.
4. Confirm the deletion.

1. In the management console, navigate to the folder dashboard and select Managed Service for YDB.
2. Select the database to delete a table from.
3. Find the table in the list and select → Delete.
4. Confirm the deletion.

1. In the management console, navigate to the folder dashboard and select Managed Service for YDB.
2. Select the database to create a directory in.
3. Choose Create → Directory on the right side of the page.
4. Enter the directory name and click Create directory.