Managing bindings

Bindings contain information about a connection, data format, and data schema. You can use different bindings in the same query.

Creating a bindingCreating a binding

To create a binding:

1. In the management console, select the folder where you want to create a binding.

2. In the list of services, select Yandex Query.

3. In the left-hand panel, select Bindings.

4. Click Create.

5. Under Connection parameters:

   1. Select the type of connection to create a binding for: Data Streams or Object Storage.
   2. Select a connection or create a new one.

6. Under Binding parameters:

   1. Enter a name and description for the binding. The naming requirements are as follows:

      • The name must be in lowercase Latin letters.
      • Length: between 3 and 63 characters.
      • It may contain digits and hyphens.
      • The first character must be a letter, the last one cannot be a hyphen.

   2. For the Data Streams connection type, select a data stream or create a new one.
      For the Object Storage connection type, specify the bucket path.

   3. (Optional) Select the compression algorithm.

   4. Select data binding format.

   5. Add columns:

      • Enter a name for the column.
      • Select the column type.
      • Enable the Required option if needed.

7. Click Create.

Getting information about a bindingGetting information about a binding

1. In the management console , select the folder where you created the binding.

2. In the list of services, select Yandex Query.

3. In the left-hand panel, select Bindings.

4. In the line with the binding name, click .
   Under the list of bindings, you will see the following binding information:
   General:

   • Data paths.
   • Data format.
   • Compression.

   Columns: List of data binding columns and their types.

   Connection parameters:

   • Type.
   • Information about the source.
   • Authentication.

   Meta:

   • ID.
   • Creation timestamp.
   • Author.

Changing a bindingChanging a binding

1. In the management console, select the folder where you want to change the binding.
2. In the list of services, select Yandex Query.
3. In the left-hand panel, select Bindings.
4. In the line with the binding name, click and select Edit.
5. Specify new parameters for the data binding. You cannot edit information in the Connection parameters section.
6. Click Modify.

Deleting a bindingDeleting a binding

1. In the management console, select the folder to delete the binding from.
2. In the list of services, select Yandex Query.
3. In the left-hand panel, select Bindings.
4. In the line with the binding name, click and select Delete.
5. Confirm the deletion.