Skip to main content

Snippets

Snippets are reusable pieces of SQL saved at the group level. Anyone in the group can insert a snippet while writing a query in the editor, so common patterns — a standard join, a set of filters, a boilerplate WITH clause — only have to be written once.

Creating a snippet​

From the group's snippet settings, create a snippet with:

  • A name so you can find it later.
  • The SQL body that will be inserted.

The snippet is stored on the group and becomes available to every member.

Using a snippet​

While writing SQL in the editor, insert a snippet to drop its body into your query at the cursor. This is the fastest way to reuse a tested fragment without copy-pasting from another query.

See Autocomplete and snippets for how snippets appear alongside the editor's other suggestions.

Editing and deleting snippets​

Snippets are fully managed: you can edit a snippet's name or body, or delete it when it is no longer needed. Changes apply for everyone in the group the next time they insert the snippet.

When to use snippets​

  • Standard column lists or joins you repeat across many queries.
  • Boilerplate for Kvery directives (such as error handling or webhooks).
  • Common filter blocks that use form variables.