Getting statistics on queries to Object Storage objects using Yandex Query

1. In the management console, select the folder where you want to create a bucket.
2. From the list of services, select Object Storage.
3. At the top right, click Create bucket.
4. In the ** Name** field, enter the bucket name: object-bucket.
5. Click Create bucket.

Similarly, create a bucket named logs-bucket.

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

2. From the list of services, select Object Storage.

3. Select object-bucket.

4. Enable logging:

   1. In the left-hand panel, select Settings.
   2. Navigate to the Logging tab.
   3. Enable Write logs.
   4. In the Bucket for log storage field, select logs-bucket.
   5. Click Save.

5. In the left-hand panel, select Objects and upload your objects. For example, you can upload a couple of simple text files.

1. Go to Query.

2. In the left-hand panel, select Connections.

3. Click Create new.

4. Enter a name for the connection, e.g., bucket-logs-connection.

5. Select the Object Storage connection type and specify the Connection type parameters.

6. In the Bucket auth field, select Private and set these properties:

   • Cloud and Folder: Select the cloud and folder where you created your buckets.
   • Bucket: logs-bucket.
   • Service account: yq-sa.

7. Click Check. After a successful test, click Create.

8. Click Automatically fill settings for and select Object Storage Access Logs from the drop-down list.

   1. Enter a name for the binding, e.g., bucket-logs-binding.
   2. In the Path field, specify the path to the statistics within the bucket. If the statistics are stored in the bucket root directory, specify /.
   3. Click Preview to verify the settings are correct.
   4. Click Create to complete creating the binding.

1. Go to Query.

2. In the left-hand panel, select Connections.

3. Select bucket-logs-connection.

4. In the editor on the right, enter this query:

   SELECT `timestamp`, request_id, handler, object_key, status, request_time
   FROM `bucket-logs-binding`
   LIMIT 100;
   

   This query will return 100 records of statistics on queries to Object Storage objects. You can remove the record limit and filter results using WHERE.

5. Click Run and check the results.