Query logs
Adobe Experience Platform maintains a log of all query events that occur through both the API and the UI. This information is available in the Query Service UI from the Logs tab.
The log files are generated automatically by any query event and contain information including the SQL used, the status of the query, how long it took, and last run time. You can use query log data as a powerful tool for troubleshooting inefficient or problem queries. More comprehensive log information is kept as part of the audit log feature and can be found in the audit log documentation.
Check query logs
To check the query logs, select Queries to navigate to the Query Service workspace and select Log from the available options.
Customize and search customize-and-search
Query Service logs are presented in a customizable table format. To customize the table columns, select the settings icon ( ) to the right of the screen. A Customize Table dialog appears where each column can be deselected.
You can also search for logs relating to specific query templates by typing the template name into the search field.
A description for each of the log table columns can be found in the Log section of the Query Service overview.
Discover log data
Each row represents log data for a query run associated with a query template. Select any row from the table to populate the right sidebar with log data for that run.
In the log details panel, you can perform a variety of actions. You can run the query as CTAS, which creates a new output dataset, see or copy the complete SQL query that was used in the run, or delete the query.
You can also select a query template name from the Name column to navigate directly to the Query log details view.
Edit logs edit-logs
Next to each row’s template name or SQL snippet is a pencil icon ( ) that you can use to navigate to the Query Editor. The query is then pre-populated in the editor for editing.
Filter logs filter-logs
You can filter the list of query logs based on a variety of settings. Select the filter icon ( ) at the top left of the workspace to open a set of filter options in the left rail.
The list of available filters is displayed.
The following table proved a description of each filter.
API
, Adobe Query Service UI
, or QsAccel
.Any applied filters are displayed above the filtered log results.
Next steps
By reading this document, you now have a better understanding of how query logs are accessed and used in the Query Service UI.
See the UI overview, or the Query Service API guide to learn more about Query Service capabilities.
See the monitor queries document to learn how Query Service improves the visibility of scheduled query runs.