SQL
Outline
What is SQL Explorer?
SQL Explorer is an ad hoc analysis tool within Optimizely Analytics that allows you to run advanced queries using full SQLsyntax. It gives analysts and technical users the flexibility to dive deeper into data, customize their explorations, and deriveinsights beyond predefined templates.
With SQL Explorer, you can:
Run complex queries using standard SQL.
Visualize query results directly within the Analytics platform.
Use SQL-based explorations alongside other types (like segmentation or funnel reports) without switching tools.
Prerequisites
Before you begin creating explorations using SQL Explorer, make sure:
Your datasets are properly configured.
Your data sources are connected to Analytics.
Build a SQL Exploration
To get started with SQL Explorer, consider a use case where you want to identify users who are on the iOS platform and retrieve their name and subscription ID.
Learn how to build a SQL exploration using this scenario https://optimizely.navattic.com/icp0eu3.
Understand the SQL Explorer Interface
SQL Explorer consists of three core components:
Catalog – View datasets, tables, and field details.
Query Builder – Write and execute SQL queries.
Visualization Module – Preview and customize the results of your query visually.
To explore the interface in more detail, refer to this documentation: Learn more about SQL Explorer UI