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:
- Go to + > SQL.
- 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.
- Double-click the Users dataset to add it to the query.
- 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' - Click Run.
- Name the exploration and click Save.
Please sign in to leave a comment.