Query Editor user guide
Query Editor is an interactive tool provided by Adobe Experience Platform Query Service, which allows you to write, validate, and run queries for customer experience data within the Experience Platform user interface. Query Editor supports developing queries for analysis and data exploration, and allows you to run interactive queries for development purposes as well as non-interactive queries to populate datasets in Experience Platform.
For more information about the concepts and features of Query Service, see the Query Service overview . To learn more about how to navigate the Query Service user interface on Platform, see the Query Service UI overview .
Query Editor provides flexible execution of queries by connecting to Query Service, and queries will only run while this connection is active.
Connecting to Query Service
Query Editor takes a few seconds to initialize and connect to Query Service when it is opened. Console tells you when it is connected, as shown below. If you attempt to run a query before the editor has connected, it delays execution until the connection is complete.
How queries are run from Query Editor
Queries executed from Query Editor run interactively. This means that if you close the browser or navigate away, the query is canceled. This is also true for queries made to generate datasets from query outputs.
Executing queries using Query Editor
To run a query in Query Editor, you can enter SQL in the editor or load a previous query from the Log or Browse tab, and click Play . The status of query execution is displayed in the Console tab below, and output data is shown in the Results tab.
The console provides information on the status and operation of Query Service. The console displays the connection status to Query Service, query operations being executed, and any error messages that result from those queries.
The console only shows errors that resulted from executing a query. It does not show query validation errors before a query is executed.
After a query has completed, the results are displayed in the Results tab, next to the Console tab. This view shows the tabular output of your query, displaying up to 100 rows. This view allows you to verify that your query produces the expected output. To generate a dataset with your query, remove limits on rows returned, and run the query with CREATE TABLE tablename AS SELECT to generate a dataset with the output. See the generating datasets tutorial for instructions on how to generate a dataset from query results in Query Editor.
Run queries with Query Service tutorial video
The following video shows how to run queries in the Adobe Experience Platform interface and in a PSQL client. Additionally, using individual properties in an XDM object, using Adobe-defined functions, and using CREATE TABLE AS SELECT (CTAS) are demonstrated.
Now that you know what features are available in Query Editor and how to navigate the application, you can start authoring your own queries directly in Platform. For more information about running SQL queries against datasets in Data Lake, see the guide on running queries . For sample SQL queries for working with Adobe Analytics and Adobe Target data, see the sample queries reference .