Answer The Toughest Questions

Get the most out of your analytics with with Periscope Data's SQL, Python, and R editors, plus advanced functionality and manageability.

Our SQL Editor Was Built By Experts, For Experts

Powerful functionalities, like query revision history, autocomplete, formatting, and universal syntax helpers will enable you to go from query to answer in seconds.

Improve your workflow and team collaboration with SQL Snippets and Views. Store frequently used code to a common library with Snippets or reuse entire queries with Views.

The Periscope Data editor for SQL and Python analysts
slq iconpython iconr icon

SQL, Python, and R — Together, For The First Time

Seamlessly and efficiently analyze in SQL, Python or R — all on the same development environment. Then easily visualize, collaborate, and share with others.

With Periscope Data, all of your data and analyses are now in one place and up-to-date, ensuring a single source of truth within and across teams.

Do More With Your Data

Easily visualize insights using Python libraries or R packages that you’re familiar with,  or by leveraging Periscope’s preset charting options.

*Don't see your go-to library or package? Let us know.

Robust Data And User Management

Data Permissions

Control user access to data tables by creating isolated environments within your company.

User Permissions

Customize user permissions to fit your company's needs - who has access to what, who can read and write queries.

Query Management

View, promote or cancel queued queries to improve system efficiency.


Adjust visibility of certain dashboards and datasets for different audiences.

Dashboard Refresh Management

Schedule data refreshes to ensure most up-to-date data is available to users.

Usage Data

Know who is accessing data and how they are using it to optimize dashboard performance.

Create Interactive And Dynamic Dashboards

From bar charts to maps, our many customization options let you express your ideas and answer meaningful questions with actionable insights.

The Periscope Data editor for SQL and Python analysts

Go From Code To Charts, Instantly

Periscope Infrastructure utilizes a distributed architecture with columnar storage for rapid data retrieval. Our data scientists and engineers are Amazon Redshift specialists with years of experience pushing the limits.

Cross Database Joins

Connect all of your databases, tie your data together, and spend less time establishing connections.

Near Real-Time Data Syncing

Never make decisions using outdated metrics again. Periscope Data stays in sync with your internal servers by default so charts and dashboards are automatically refreshed and updated.

Highly Available Clusters

Worry less about database maintenance and more time focusing on bringing value to your business.

Easily Explore Data Even Without Code

With our interface and exploration features such as filters, drill downs, and pivot tables, you can easily refine a new dashboard or dig deeper to analyze charts without ever touching the code.

Use excel style pivot tables for easy data exploration

Deliver And Share Insights

No more version control issues. Periscope Data makes it easy to share insights live or printed with your teams and customers.

Link Sharing

Create and send links direct to reports and dashboards.

Customizable Email Alerts

Schedule reports and dashboards to be sent directly to your inbox.

PDF & Printable Dashboard

Easily deliver polished reports to share with business executives or customers.

Slack Integration

Share live dashboards with your coworkers.


Collaborate by adding comments or questions directly onto charts.

Full-Screen TV Mode

Show critical metrics in meetings or with your entire organization.

Supercharge With Periscope Platform

Connect to Your Data

Securely push or pull data from any source using our native connectors or ETL partners into a single, governed data platform.

Accelerate Queries

Run queries up to 150x faster while reducing dependency on your existing databases

Materialize New Views

Create and store new data tables by joining and blending data from multiple sources

Map Dependencies

Ensure accuracy of your dashboards with visibility into dependencies on data sources

Manage Cluster Performance

Full control and visibility into cluster CPU’s and memory performance

Embedding and Reporting

Easily deliver live dashboards or polished reports to share with other teams, partners, or customers

Iron-Clad Security

Nothing is more important than the security of your data. That's why we've built a cloud security infrastructure that follows industry-wide best practices and standards while being trusted by some of the largest companies in the world.

User Security

Two-Factor Authentication and Single Sign‑On


End-to-end (AES-256 Bit) Encryption


SOC 2 and HIPAA compliance