Run queries

In this lesson, you will learn how to setup, write and execute queries to validate the data you have ingested.

Adobe Experience Platform Query Service helps you make sense of your data by allowing you to use standard SQL to query data in Platform. Using Query Service, you can join any dataset in the Data Lake and capture the query results as a new dataset for use in reporting, machine learning, or for ingestion into Real-time Customer Profile.

Data Architects and Data Engineers will need to use query service outside of this tutorial.

Before you begin the exercises, watch this short video to learn more about Query Service:

Permissions required

In the Configure Permissions lesson, you set up all the access controls you need to complete this lesson, specifically:

  • Settings > Services > Query Service
  • Permission items Data Management > View Datasets and Manage Datasets
  • Permission item Sandboxes > Luma Tutorial
  • User-role access to the Luma Tutorial Platform product profile

Simple Queries

Let’s start with some simple queries:

  1. In the Platform UI, click Queries in the left navigation

  2. Click the Create Query button on the top right

  3. This will open a text box to run and execute queries

  4. Enter the following query in the editor and press Shift+Enter or Shift+Return to execute the query.

    SHOW TABLES
    
  5. This will show list of available tables

    SHOW TABLE query

  6. Now try this query, replacing _techmarketingdemos with your own tenant namespace, which, if you recall, is visible in your schemas.

    SELECT person.name.lastName,_techmarketingdemos.loyalty.level
    FROM luma_loyalty_dataset
    WHERE _techmarketingdemos.loyalty.level ='gold'
    

    SELECT data from the loyalty dataset

  7. If there is any error you detailed messages will appear in the Console tab, as pictured below
    Error in the query

  8. With your successful query, Name it Luma Gold Level Customers

  9. Click the Save button
    Saving the query

Additional Exercises

Additional Query Service exercises will be added to the tutorial at a later date.

Additional Resources

And now for the final hands-on lesson, creating segments!

On this page