The Query Management feature allows visualizing and managing query queues for the site.
Note: Query Management is an add-on feature. Please contact your Sales Executive or the Periscope Data Support team for additional information.
Admins can start by navigating to the Query Management menu via the settings icon in the bottom left corner of the screen.
The query management screen displays the list of all user-initiated queries that are either running or pending for that space. This includes queries initiated through a manual refresh of a chart or dashboard, filter changes, or queries ran from the SQL editors for charts, SQL Views, or SQL Alerts. The dropdown menu at the top can be used to specify for which database to view the list.
In the Running and Promoted sections, queries are listed individually in the order they were queued.
In the Waiting section, queries are listed per user, listed from most to least queries initiated.
Queries in the Waiting section can be promoted to the Promoted section or cancelled in bulk by user by clicking on the gear icon to the left and choosing "Promote All" or "Cancel All".
Individual queries in the Waiting section can be bumped to the Promoted section or cancelled by drilling down on the user and clicking on the up arrow or 'X' icons, respectfully.
Individual queries in the Promoted section can be demoted back to the Waiting Section or cancelled by clicking the down arrow or 'X' icons, respectfully.
Queries that have been cancelled from the Query Management Page will show results from the last time the chart was run with an error icon indicating that the query was cancelled by an Administrator.
Chart Refresh: The user manually refreshed a chart
Dashboard Refresh: The user manually refreshed an entire dashboard
Chart Editor / SQL View Editor / SQL Alert Editor: The user ran a query within the editor
Pageload: The user loaded a dashboard with a chart that didn't have data yet
Filter Change: The user changed a filter
Shared Dashboard Chart Sync: The user edited a chart that is also on shared dashboards, and a chart update was scheduled for each share
Chart Definition Sync: The user updated the sql for a chart with filters. The user did not have the default filters selected, so a chart update for default filters was scheduled
Chart Auto Update: The chart definition changed in the background, either through a snippet change or some other user changing a chart