Working with query history

Yandex WebSQL features query history. You can:

• View executed queries.
• Rerun a query.
• Publish a query.
• Configure access permissions for a published query.
• Delete a historical query.

Viewing an executed queryViewing an executed query

To view executed queries, go to Query history.

To view a specific query, select it from the history. The selected query will show up in the data panel.

Rerunning a queryRerunning a query

To rerun an executed query:

1. Go to the Query history section.

   Tip

   To find specific queries:

   • Use search by entering the database or table name in the search field.
   • Apply filters by clicking Filter and selecting a connection, query execution status, and time interval.

2. Select a query: it will show up in the data panel.

3. Click Open in editor.

4. (Optional) Update query parameters.

5. Click Execute.

You can also save your query as a template.

Publishing a queryPublishing a query

You can publish your query. Once published, the query will be available to all folder users. You cannot unpublish a query.

To publish a query:

1. Go to the Query history section.

2. Click to the right of the query you need and select Publish.

3. In the window that opens, click Publish.

You will see next to the information about the published query.

Configuring access permissions for a published queryConfiguring access permissions for a published query

To configure access permissions:

1. Go to the Query history section.

2. Click to the right of the query you need and select Access permissions.

3. In the window that opens, click Assign roles.

4. Assign the required roles and click Save.

Deleting a historical queryDeleting a historical query

1. Go to the Query history section.

2. Click to the right of the query you need and select Delete.

3. In the window that opens, click Apply.