The Adobe Experience Platform Query Service provides a user interface that can be used to write and execute queries, view previously executed queries, and access queries saved by users within your IMS Organization. To access the UI within Adobe Experience Platform, select Queries in the left navigation.
The Query Editor enables you to write and execute queries without using an external client. Select Create Query to open the Query Editor and create a new query. You can also access the Query Editor by selecting a query from the Log or Templates tabs. Selecting a previously executed or saved query will open the Query Editor and display the SQL for the selected query.
Query Editor provides editing space where you can begin typing a query. As you type, the editor automatically completes SQL reserved words, tables, and field names within tables. When finished writing your query, select the Play button to run the query. The Console tab below the editor shows what Query Service is currently doing, indicating when a query has been returned. The Result tab, next to the Console, displays query results. See the Query Editor guide for more information on using the Query Editor.
Queries that have already been saved as a template can be scheduled to run on a regular cadence. When scheduling a query, you can choose the frequency of runs, the start and end date, the day of the week the scheduled query runs, as well as the dataset to export the query to. Query schedules are set using Query Editor.
Once a query has been scheduled it appears in the list of scheduled queries on the Scheduled Queries tab. Full details regarding the query, runs, creator, and timings can be found by selecting a scheduled query from the list.
|Name||The name field is either the template name or the first few characters of your SQL query. Any query created through the UI with the Query Editor is named at inception. If the query was created through the API then the name of the query is a snippet of the initial SQL used to create the query.|
|Template||The template name of the query. Select a template name to navigate to the Query Editor. The query template is displayed in the Query Editor for convenience. If there is no template name, the row is marked with a hyphen and there is no ability to redirect to the Query Editor to view the query.|
|SQL||A snippet of the SQL query.|
|Run frequency||This is the cadence at which your query is set to run. The available values are
|Created by||The name of the user who created the query.|
|Created||The timestamp when the query was created, in UTC format.|
|Last run timestamp||The most recent timestamp when the query was run. This column highlights whether a query has been executed according to its current schedule.|
|Last run status||The status of the most recent query execution. The three status values are:
See the documentation for more information on how to monitor queries through the Query Service UI.
The Templates tab shows queries saved by users in your organization. It is useful to think of these as query projects, as queries saved here may still be under construction. Queries displayed on the Templates tab also display as run queries in the Log tab if they have been previously executed by Query Service.
|Name||The name field is either the query name created by the user or the first few characters of your SQL query. Any query created through the UI with the Query Editor is named at inception. If the query was created through the API then the name of the query is a snippet of the initial SQL used to create the query. You can select the query name to open the query in the Query Editor. You can also use the search bar to search for the Name of a query. Searches are case sensitive.|
|SQL||The first few characters of the SQL query. Hovering over the code displays the full query.|
|Modified by||The last user who modified the query. Any user in your organization with access to Query Service can modify queries.|
|Last modified||The date and time of the last modification to the query, in the browser’s time zone.|
See the query templates documentation for more information on templates in the Platform UI.
The Log tab provides a list of queries that have previously been executed. By default, the log lists the queries in reverse chronology.
|Name||The query name, consisting of the first several characters of the SQL query. Select the template name to open the Query log details view for that run. You can use the search bar to search on the name of a query. Searches are case sensitive.|
|Start time||The time that the query was executed.|
|Complete time||The time that the query run completed.|
|Status||The current status of the query.|
|Dataset||The input dataset used by the query. Select the dataset to go to the input dataset details screen.|
|Client||The client used for the query.|
|Created by||The name of the person who created the query.|
Select the pencil icon () from any row of the query log to navigate to the Query Editor. The query is pre-populated for convenient editing.
See the query logs documentation for more information on the log files automatically generated by a query event.
The Credentials tab displays both your expiring and non-expiring credentials. For more information on how to use these credentials to connect with external clients, please read the credentials guide.
Now that you are familiar with Query Service user interface on Platform, you can access Query Editor to start creating your own query projects to share with other users in your organization. For more information on authoring and running queries in Query Editor, see the Query Editor user guide.