Build a SQL exploration

  • Updated

To demonstrate the use of the SQL explorer for ad hoc analysis, consider a scenario in which 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. Go to + > SQL.
  2. Add the basic SQL commands in the query builder to initiate the query, and double-click the name, platform, and subscription_id columns to add them to the query.
  3. Double-click the Users dataset to add it to the query.
  4. Complete the query by double-clicking the platform column in the catalog and adding 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'
  5. Click Run.
  6. Name the exploration and click Save.

opti-sql-2.png