Reading data from Object Storage using Query bindings

There are cases when you need to run the same data queries on a regular basis. To avoid entering all the details of handling this data each time you make a query, you can use bindings.

Sample data read query using bindings:

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. In the list of services, select Yandex Query.

3. In the left-hand panel, go 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. Parts of file names can be specified using /*, such as yellow/*.csv.

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

   4. In the Format field, specify the format of stored data.

   5. Select a partitioning mode and list partitioning columns and their types.

      If you are using the Extended mode, specify the partition projection columns.

   6. List data columns and their types.

      Alternatively, you can click Detect columns to do this automatically.

7. To check 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:

• <binding>: Name of the previously created data binding.

Example of reading data using bindingsExample of reading data using bindings

Sample query to read data from Object Storage using bindings:

SELECT
    *
FROM
    `binding_name`

Where binding_name is the data binding name in Object Storage.