Building a SQL Exploration

To demonstrate how to use the SQL Explorer for ad hoc analysis, let's consider a scenario where you need to locate users who use the iOS platform along with their Name and Subscription ID.

To build such an exploration, follow these steps:

1. Access the SQL Explorer.
2. Use the Catalog and the Query Builder to create the query.
   1. Add the basic SQL commands to initiate the query.
   2. From the Catalog, double-click the name, platform, and subscription_id columns to add them into the Query Builder.
   3. Double-click the Users dataset to add it to the Query Builder.
   4. Complete the query by double-clicking on the "platform" column in the Catalog and add a condition to filter out users who use the iOS platform. Your query will look like this:
      select "name", "platform", "subscription_id" from "Data.Users" where "platform"= 'iOS'
3. Click Run Exploration.
4. Give a name to the exploration and save it.