Managing tables and directories

1. In the management console, go to the folder page and select Managed Service for YDB.
2. Select the database to create a table in.
3. Go 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. Set up secondary indexes if needed.
   • 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. Set up 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: Lets you explicitly specify values for keys that will act as boundaries for the initial partitioning of the table. 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, applies the Bloom filter to search data by a 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 based on the YQL query language.

1. In the management console, go to the folder page 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: A simple primary key that consists of a single attribute. YDB uses the partition key value as an input for the internal hashing function. The result of calculating the hash function determines the partition where the item will be stored.
   • Sort key. A primary key can be composite and consist of a partition key and a sort key. All items with the same partition key will be stored together, in sorted order by the sort key value. If a partition key and a sort key are specified in a document table, two elements may contain the same value for the partition key, but must contain different values for the sort key.
6. Click Create table.

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, go to the folder page 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, applies the Bloom filter to search data by a key. In some cases, it can speed up key reads.
8. Click Alter table.

1. In the management console, go to the folder page 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, go to the folder page 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, go to the folder page 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, go to the folder page 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.