Query Admin

Space Administrators can test the SQL generation, query navigation plan, and query results of BQL queries from Query Admin.

1. From Admin 2.0, select Space Management.
   
   

   

   
   
2. Select your space and then select Query Admin.
   
3. From the Queries tab, enter the logical query.
   
4. Select Run Query to run the query.
   
5. Select Navigate Query to run the internal query navigator and display an explanation of the navigation.
6. Download Query Log to download a log of queries run in the space.
7. From the Cache tab, you can clear caches. Birst has two caches, query and dashboards. The query cache, also called the results cache, caches the results of database queries. It contains the results of queries keyed by the logical query with which it is associated. The dashboards cache contains information about what users have access to what dashboards.
   
   
   • To clear all query caches, select Clear All Query Caches.
   • To clear dashboard cache, select Clear Dashboards Cache to clear cache.
   • Type or paste a query in the text box and select Clear Cache for Query.
8. Select Exact Match to clear the cache for this exact query only - you may still be hitting the cache if there is a fuzzy match for this query.