Reading data from Object Storage via Query data bindings

When you need to run the same queries repeatedly, you can use bindings to avoid specifying all query details each time.

Query example for reading data via a binding:

SELECT
    *
FROM
    `logs`
WHERE
    version>1

Setting up a data bindingSetting up a data binding

To create a binding to read data from Object Storage:

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, switch to the Bindings tab.

4. Click Create.

5. Under Connection parameters:

   1. In the Type field, select Object Storage.
   2. In the Connection field, select an existing connection or create a new one.

6. Under Binding parameters:

   1. In the Name field, specify the binding name.

   2. In the Path field, specify the path to bucket data. You can specify parts of file names using /*, e.g., yellow/*.csv.

   3. In the Compression field, specify the data compression method.

   4. In the Format field, specify the data storage format.

   5. Select a partitioning mode and specify the list of partition columns with their types.

      For the Extended mode, specify the partition projection columns.

   6. Specify the data columns and their types.

      To detect columns automatically, click Auto-detect columns.

7. To validate the data, click Preview.

8. Click Create.

Data modelData model

Object Storage stores data as binary files. To read data, use the following SQL statement:

SELECT
    <expression>
FROM
    `<binding>`
WHERE
    <filter>;

Where:

• <statement>: Statement that determines the result of the query.
• <binding>: Name of the data binding you created earlier.
• <filter>: Data filtering condition.

Example of reading data using bindingsExample of reading data using bindings

Query example for reading Object Storage data via bindings:

SELECT
    *
FROM
    `binding_name`

Where binding_name is the Object Storage data binding name.