Learn how to add Atlassian Analytics to a site and understand what you need to query data and create charts.
Learn how to connect and manage your connected Atlassian data and external data.
Create or build off of dashboard templates to start analyzing your Atlassian data.
Learn how to create insightful charts and dashboards with your organization’s data.
Learn how to use Visual SQL to create queries and transform data for making charts.
Need feedback on data? Learn how to share charts and dashboards with teammates so they can leave comments.
Learn how to grant resource access to the people who need it.
Learn how to manage your workspace and how to monitor your workspace activity.
Use the queries search to quickly find recently failed queries or search for the usage of tables, columns, or other SQL snippets in your Atlassian Analytics queries.
When you navigate to the Queries tab of a data source, Atlassian Analytics will show you any queries with errors before you run any searches. This quickly surfaces any queries that you need to fix.
To search for specific terms (for example, schema, table, or column names) used in your queries in your workspace:
You must have permission to manage the data source to search its queries.
Select Data in the global navigation.
Select the data source that you want to perform a query search for.
Go to the Queries tab.
Type your search term into the text field. Wrap your search term in double quotes to return queries with an exact match.
Keep in mind that non-letter characters like _, ', ", ., etc. are not considered in the search. So searching for created_date, for example, yields the same results as created date.
Note that search results only include queries from active dashboards. It does not include queries for archived and deleted dashboards.
Information returned in the query search results
Query search returns the following information:
Provides details about the resource that’s using the query:
The type of resource (for example, chart)
The link to the resource using the query
Last run status
When the query was last executed and its status
The raw SQL query containing your search term
To differentiate between visual mode and SQL mode queries:
Visual mode queries have a short summary above the query
SQL mode queries only show the SQL
Download query search results
To download your query search results as a CSV, select Download as CSV.
The CSV file contains the following information:
Dataset ID: The unique identifier of the query
Dataset name: The name of the query
Type: The type of resource using the query
Description: The title of the chart using the query
Link: The URL to the resource using the query
Query type: the mode used for creating the query—visual or SQL
SQL: The raw SQL query
Was this helpful?