Contact UsGet started
© 2024 Iron Hive LLC Belgrade

Working with saved queries

Written by
Updated at July 10, 2024

You can save any query to use it later and create a template out of it. The Saved queries section enables you to:

Saving a query as a template

To save a query:

  1. In the Connections section, connect to the database and go to the query editor.
  2. In the data panel, click next to the Execute button.
  3. In the Save query window:

    1. Select the database to query. By default, the current database is specified in this field.

    2. Specify a Name, i.e., any name under which the query will be displayed in the list of saved queries.

    3. For your saved query to be used as a template in the suggestions list, select Add tip and type the Tip text including userTemplate_.

      Tip

      If you add a suggestion and specify a template name, you can include in the query the arguments to be highlighted when this template is selected, such as SELECT $1 FROM employees LIMIT $2.

    4. Review or edit the query.

    5. Click Save.

  1. Open Yandex WebSQL.

  2. Go to the Saved queries section.

  3. In the top-right corner, click .

  4. In the window that opens:

    1. Select a connection to the queried database.

    2. Specify a Name, i.e., any name under which the query will be displayed in the list of saved queries.

    3. For your saved query to be used as a template in the suggestions list, select Add tip and type the Tip text including userTemplate_.

      Tip

      If you add a suggestion and specify a template name, you can include in the query the arguments to be highlighted when this template is selected, such as SELECT $1 FROM employees LIMIT $2.

    4. Enter the query text.

    5. Click Save.

After you save the query, it will appear in the Saved queries window. If you have added a suggestion, it will appear as a template along with the ready-made Yandex WebSQL templates.

Using a saved query

  1. Begin typing template in the query field.
    The suggestions list will show the saved userTemplate_* templates and ready-made templates:

    • template_CREATE
    • template_DELETE
    • template_DROP_TABLE
    • template_INSERT
    • template_SELECT
    • template_UPDATE

  2. Select the template you need from the suggestions list.

  3. Add relevant parameters to the template. Use the TAB key to switch between the parts of the template you are adding parameters to.

  4. Click Run.

  1. Go to the Saved queries section.
  2. Click to the right of the query you need and select Use query: it will show up in the data panel.
  3. Click Open in editor.
  4. (Optional) Update query parameters.
  5. Click Execute.

Editing a saved query

To edit a saved query:

  1. Go to the Saved queries section.

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

  3. In the window that opens:

    1. Select the database to query.

    2. Specify a Name, i.e., any name under which the query will be displayed in the list of saved queries.

    3. Add, edit, or delete a suggestion.

      Tip

      If you add a suggestion and specify a template name, you can include in the query the arguments to be highlighted when this template is selected, such as SELECT $1 FROM employees LIMIT $2.

    4. Review or edit the query.

  4. Click Save.

Publishing 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 Saved queries section.

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

  3. In the window that opens, click Publish.

You will see next to the name of the published query.

Configuring access permissions for a published query

To configure access permissions:

  1. Go to the Saved queries 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 saved query

To delete a saved query:

  1. Go to the Saved queries section.

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

  3. In the window that opens, click Apply.

Previous
Working with the query editor
Next
Working with query history