Managing bindings

Bindings contain information about the connection, data format, and schema. You can use several different bindings in a single 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. Navigate to Yandex Query.
3. In the left-hand panel, select Bindings.
4. Click Create.
5. Under Connection parameters:
   1. Select the target connection type for the binding: Data Streams or Object Storage.
   2. Select an existing connection or create a new one.
6. Under Binding parameters:

   1. Specify the binding name and description. The naming requirements are as follows:

      • The name must consist of lowercase Latin letters.
      • It must be between 3 and 63 characters in length.
      • It may contain digits and hyphens.
      • It must start with a letter and cannot end with a hyphen.

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

   3. Optionally, select the compression algorithm.

   4. Select data binding format.

   5. Add columns:

      • Specify the column name.
      • Select the column type.
      • Enable Required, if required.
7. Click Create.

Getting binding detailsGetting binding details

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

2. Navigate to Yandex Query.

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

4. Find the binding you need in the list and click in its row.
   Binding details will appear under the list:
   General:

   • Data paths
   • Data format
   • Compression

   Columns: Data binding columns and their types.

   Connection parameters:

   • Type
   • Source details
   • Authentication

   Meta:

   • ID
   • Creation timestamp
   • Creator

Modifying a bindingModifying a binding

1. In the management console, select the folder with the binding you want to update.
2. Navigate to Yandex Query.
3. In the left-hand panel, select Bindings.
4. Locate the binding you need in the list, click in its row, and select Edit.
5. Update the binding settings. Note that the Connection parameters section settings are read-only.
6. Click Modify.

Deleting a bindingDeleting a binding

1. In the management console, select the folder containing the binding you want to delete.
2. Navigate to Yandex Query.
3. In the left-hand panel, select Bindings.
4. Locate the binding you need in the list, click in its row, and select Delete.
5. Confirm the deletion.