Managing tables and directories

1. In the management console, navigate to the folder page.
2. Go to Managed Service for YDB.
3. Select the database to create your table in.
4. Navigate to the Navigation tab.
5. Select Create → Table on the right side of the page.
6. Configure the table:
   • Table Name must be unique within the database.
   • Table type: Row table.
7. 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.
8. 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.
9. 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 partitions. When using this policy, set the number of partitions in the Count field.
   • Explicitly: Allows you to explicitly specify values for keys that will act as split points for initial table partitioning. To add another split point, click Add split point.
10. Configure automatic partitioning:
    • By size: If enabled, a partition is split into two when it reaches a certain data size.
    • By load: If enabled, a partition is split into two if it receives high throughput (uses a lot of CPU time) for a certain period of time.
11. Specify advanced table settings:
    • Auto-partitioning by size in MB: Data size threshold that triggers auto-partitioning by size.
    • Minimum number of partitions: Number of partitions in the table below which no partitions are merged by size or load.
    • Maximum number of partitions: Number of partitions in the table above which no partitions are split by size or load.
    • 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.
12. 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 page.
2. Go to Managed Service for YDB.
3. Select the database to create your table in.
4. Select Create → Table on the right side of the page.
5. Configure the table:
   • Table Name must be unique within the database.
   • Table type: Document 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.
   • Partition key: Simple primary key that consists of one attribute. YDB uses a partition key as an input for internal hashing. The hashing function result determines the partition the element will be stored in.
   • Sort key. A primary key can be composite and consist of a partition key and a sort key. All elements sharing the partition key will be stored together and sorted according to their sort key value. In a document table that has both a partition key and a sort key, any two elements may share the partition key value but must have different sort key values.
7. Click Create table.

1. In the management console, navigate to the folder page.
2. Go to Managed Service for YDB.
3. Select the database to create your table in.
4. Navigate to the Navigation tab.
5. Select Create → Table on the right side of the page.
6. Configure the table:
   • Table Name must be unique within the database.
   • Table type: Column table.
7. 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. Primary indexes are automatically created based on the primary key.

     Note

     The column order in the primary key depends on the column order in the table you are creating.

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

8. Configure the table TTL parameters:
   • Column. Select the column whose value will be used to calculate the lifetime of rows.
   • Lifetime. Specify the lifetime of table rows.
   • Unit. Select the measurement unit for the table row lifetime you specified.
9. Configure partitioning:
   • Partition key: Specify the column to split the table by.
   • Partition count: Specify the number of partitions for the table.
10. 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 page.
2. Go to Managed Service for YDB.
3. Select the database to update a table in.
4. Find the table in the list and select → Edit.
5. 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.
6. To delete non-key columns from the table, click in the relevant row. You cannot delete columns that make up a primary key.
7. Configure automatic partitioning:
   • By size: If enabled, a partition is split into two when it reaches a certain data size.
   • By load: If enabled, a partition is split into two if it receives high throughput (uses a lot of CPU time) for a certain period of time.
8. Specify advanced table settings:
   • Auto-partitioning by size in MB: Data size threshold that triggers auto-partitioning by size.
   • Minimum number of partitions: Number of partitions in the table below which no partitions are merged by size or load.
   • Maximum number of partitions: Number of partitions in the table above which no partitions are split by size or load.
   • 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.
9. Click Alter table.

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

1. In the management console, navigate to the folder page.

2. Go to Managed Service for YDB.

3. Select the database to update a table in.

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

   Update the table schema as needed. You can do the following:

   • 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 relevant 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 rows.
     • Lifetime. Specify the lifetime of table rows.
     • Unit. Select the measurement unit for the table row lifetime you specified.

5. 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 page.
2. Go to Managed Service for YDB.
3. Select the database to delete your table from.
4. Find the table in the list and select → Delete.
5. Confirm the deletion.

1. In the management console, navigate to the folder page.
2. Go to Managed Service for YDB.
3. Navigate to the database to delete your document table from.
4. Select the document table from the list, then click → Delete.
5. Confirm the deletion.

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

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