Query Admin

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

  1. From Admin, select Space Management.
  2. Select your space, and then click Query Admin.
  3. From the Queries tab, specify the logical query.


  4. Click Run Query to run the query.
  5. Click Navigate Query to run the internal query navigator and display an explanation of the navigation.
  6. Click 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, click Clear All Query Caches.
    • To clear dashboard cache, click Clear Dashboards Cache to clear cache.
    • Specify or paste a query in the text box, and then select Clear Cache for Query.
  8. Click Exact Match ❑ to clear the cache for this exact query only.
    For more details on how caching works in Birst, please refer to this Community post.