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 required to complete this lesson.
Simple Queries
Let’s start with some simple queries:
-
In the Platform user interface, go to Queries in the left navigation
-
Select the Create Query button on the top right to open a text box to run and execute queries
-
Enter the following query in the editor and press Shift+Enter or Shift+Return to execute the query.
code language-none SHOW TABLES
-
This shows the list of available tables
-
Now try this query, replacing
_techmarketingdemos
with your own tenant namespace, which, if you recall, is visible in your schemas.code language-none SELECT person.name.lastName,loyalty.tier FROM luma_loyalty_dataset WHERE loyalty.tier ='gold'
-
If there is any error, detailed messages will appear in the Console tab, as pictured below
-
With your successful query, Name it
Luma Gold Level Customers
-
Select the Save button
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!