Periscope Data Documentation

Connecting to Periscope

First Time Connecting

Connection Definitions

Common Connection Errors

Private Network SSH Tunnels

Integrations

Overview

Getting Started

Keyboard Shortcuts

Charts & Dashboards

Chart Overview

Chart Options

Dashboard Overview

Refresh Mechanics

Organizing Charts

Organizing Dashboards

Table-like Charts

Table Overview

Cohort Grids

Pivot Tables

Graph-like Charts

Overview & General Settings

Chart Types and Settings

Mixing Chart Types

Map Charts

Map Chart Overview

Heatmaps

Clusters and Bubbles

Satellite Maps

GeoJSON

Other Charts & Customizations

Pie Charts

Image Charts

Chart Annotations

Site Administration

Adding Users

Removing Users

User Types

User Groups

Two-Factor Authentication

Managing User Permissions

Dashboard Permissions

Site Preferences

Query Management

Color Themes

Dashboard Refresh Management

Usage Data

Periscope Cache

Caching Strategies

Querying the Periscope Cache

Cross-Database Joins

CSV Upload

Materializing Views

SQL Formatters

Using SQL Formatters

Composing SQL Formatters

Dollars and Percentages

Time Zone Formatters

Date Aggregation

Date Parts

Basic Filters

Custom Filters

Date Range Filters

Aggregation Filter

Adding, Moving, and Hiding Filters

Advanced Filters

Default Filters

Drilldowns

Parent-Child Filters

Matching Filter Values

Time Zone Conversions

Direct Replacement

User Friendly Names

Views

SQL Views

Joining to Views

More SQL Tools

SQL Snippets

Parameterized SQL Snippets

SQL Alerts

Automatic Joins

Sharing and Embedding

Sharing Dashboards Externally

Email Reports

Easy Embedding

Embed API

Embed API Options

Public CSV URL

Slack API

Slack Linking Reports

Data Management

Adding and Deleting Datasource

Spaces: Data-Level Permissions

Improving Query Throughput

Revoking Table Permissions

Salesforce Datasource

Schema Browser

SSO Integrations

Overview

Okta

OneLogin

Google Apps

Query Management

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.

Overview

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.

Promoting and Cancelling Queries

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.

Action Type Definitions

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