SQL Explorer

For Customer Admins and Analysts who need to validate their data using SQL queries.

Introduction

As an Admin or Analyst, you may need to perform deeper data validations or exploratory analysis that extend beyond the boundaries of existing dashboards or metrics.

The SQL Explorer Page allows users to write and run custom SQL statements directly in your One Model instance.  

This feature provides more autonomy and flexibility for data validation, while maintaining strict controls around access and data security.

Getting Started

SQL Explorer is available to all One Model customers where their Admins have full access to all data within their instance.

Permissions & Access Requirements

• To use the SQL Explorer Page, users need the new CanViewSQLExplorer permission. 
  • Note: This is an admin level data access tool and these users will be able to see all data using the SQL Explorer tool, so it should not be given to users who need their data restricted.  Data Access Role permission restrictions don't apply to SQL Explorer.
• For users with the permission, go to Data  → SQL Explorer to see the new page, and start querying!

How It Works

Write SQL statements into the input box, and select “Execute Query”, and the results will come back in tabular form.

Key Capabilities Include:

• Search & Navigate all Tables and Columns available in the instance using the Table and Column viewer on the left-hand side.

• Write and execute custom queries directly in the UI.

• Supports any SQL in a SELECT statement - for example Joins, Where clauses, Group By statements, Order By, etc.

• View results immediately within the same page.

• Full support for multiple queries - run all at once, or highlight a single query to run just that

• Run ad-hoc data checks to confirm the accuracy of dashboards, metrics, or uploaded data.

• Share and Reload queries by using the URL

Be sure to check out the SQL Explorer FAQs too!