Managing queries

Queries contain a set of YQL statements for handling data and connection parameters.

Creating a queryCreating a query

1. In the management console, select the folder where you want to create a query.
2. In the list of services, select Yandex Query.
3. In the left-hand panel, select Queries.
4. In the top panel, click New analytics query or New streaming query.
5. Enter the query text in the input field.

Checking a queryChecking a query

To check the text of your query without executing it, click Validate.

Running a queryRunning a query

Stopping a queryStopping a query

To stop a query:

Viewing query execution informationViewing query execution information

You can view the query progress in the following tabs:

• Result: Query results as a table or schema. You can only view the results of the last query execution within 24 hours.
• Issues: Information about query execution errors.
• Plan: Information about query execution stages.
• Statistics: Query metrics with the following data:
  • Input data streams.
  • Capacity used for running the query.
  • Amount of RAM used.
  • Amount of output data.
• Meta: Query metadata:
  • Query ID.
  • Query execution status.
  • Date when the query was created, modified, and last executed.

Viewing the history of query runsViewing the history of query runs

Yandex Query logs each query's run history.

1. In the management console, select the folder where you want to view the query execution history.
2. In the list of services, select Yandex Query.
3. In the left-hand panel, select Queries.
4. In the top panel, select a query and click Show launches.

Renaming a queryRenaming a query

1. In the management console, select the folder where you want to rename a query.
2. In the list of services, select Yandex Query.
3. In the left-hand panel, select Queries.
4. Select the query and click next to the query name on the panel.
5. Enter a new name for the query and click .

Editing a queryEditing a query

To edit a query, enter a new query text and click Run. If the query is running, stop it to edit the query text.

Cloning a queryCloning a query

For convenience, you can clone a query with the original query text:

1. In the management console, select the folder where you want to clone a query.
2. In the list of services, select Yandex Query.
3. In the left-hand panel, select Queries.
4. Select the query and click Clone. To clone it to a query of a different type, click Clone as….

Deleting a queryDeleting a query

1. In the management console, select the folder to delete the query from.
2. In the list of services, select Yandex Query.
3. In the left-hand panel, select Queries.
4. Click next to the name of the query to delete.
5. Confirm query deletion.