Query Catalog¶
The Query Catalog is the organized collection of all the queries you previously built and saved, queries others shared with you, and pre-built query templates. It allows you to browse and search for the query you need.
This article explores how the Query Catalog is structured and what functionality is available within it to help you easily find the query you are looking for and organize new queries.
How to Use it¶
Browse existing queries by category from the Queries Menu. By default, queries are grouped using the following categories:
All Queries – selecting this will display all queries
My Queries – queries created by the logged in user
Shared Queries – queries created by another user that have been shared with you to run
Query Templates – pre-built Daybreak queries
Tags are key words added to a query to personalize the catalog organization. Tags will appear alphabetically below the default categories. The number next to each Tag denotes how many queries have that Tag. Learn more about Tags here.
Clicking one of the group or tag names will display all relevant query cards, which include the query name and description (if provided).
Search within the filtered context using the Search box in the upper right corner.
Once you’ve found the query you want, click the query cards to run the query and get Data Insights and Data Results. From this preview, if you are the owner of the query, you can add tags, share the query, or open in the Query Builder to edit. If you are not the query owner, you will only be able to open it in the Query Builder.
Easily navigate back to the Query Catalog using the Query Catalog link in the top left.
Not finding the query you want? Use the New Query button in the Query Catalog to launch the Query Builder to build the desired query.
Organizing Queries Using Tags¶
Organize your queries using Tags. This section explores how to add and manage Tags.
Tags can be added to queries you built in the Query Wizard or SQL Editor. Tags cannot and are not added to Aunalytics supplied query templates.
Before using tags, here are the Tag rules.
- Each query can have up to 5 Tags.
- Tag names can be up to 16 characters long and can have lowercase letters, numbers and spaces.
- The same Tag can be added on multiple queries.
- Tags will appear alphabetically under the query name.
There are several ways to add and manage tags for your queries.
Adding Tags from the Query Catalog Preview¶
Click the + Add Tag button when viewing a query to add Tags. The 5 most frequently used Tags are shown, and you can select one of them.
You can select + Create New Tag to add a new Tag or to add an existing Tag that is not one of the top 5 listed. Enter your tag name and click Submit. The new Tag will append to the existing list of Tags for that query.
Adding/Editing Tags in the Query Builder¶
When saving or editing a query, you may apply tags by typing the tag name in the Tag field. Hit tab or enter key on your keyboard and then click Save.
Note
When copying an existing query or shared query, the Tags from the original query will be on the copy but can be removed.
Removing Tags¶
Hover over a Tag you want to remove in the Query Catalog Preview and click the X next to the Tag name.
Click the edit icon (
) next to the query name in the Query Builder to open the Edit Details. Click the X on the Tag you want to remove. Click Save and the Tag will no longer be associated with the query.
Tags will continue to appear in the Query Menu as long as they are used on at least 1 query.
At any time you can exit the Insight creation process by clicking the "X" icon in the upper right of the Insight creation modal.
Tip
Shared Queries will display Tags the owner of the query added, but the recipient of the shared query can only see the Tags, and will not be able to add, edit, or delete the Tags on a shared query. Opening a shared query in the Query Wizard allows a user to Save As, creating a copy of the query where Tags can be edited on their own version of the query.