Adobe Experience Platform provides improved visibility for the status of all query jobs through the UI. From Scheduled Queries tab you can now find important information about your query runs that includes the status, schedule details, and error messages/codes should they fail. You can also subscribe to alerts for queries based on their status through the UI for any of these queries through Scheduled Queries tab.
The Scheduled Queries tab provides an overview of all your scheduled CTAS and ITAS queries. Run details can be found for all scheduled queries as well as error codes and messages for any failed queries.
To navigate to the Scheduled Queries tab, select Queries from the left navigation bar followed by Scheduled Queries
The table below describes each available column.
The alert subscriptions icon is contained in each row in an untitled column. See the alert subscriptions section for more information.
Column | Description |
---|---|
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 its name becomes a snippet of the initial SQL used to create the query. Select any item from the Name column to see a list of all runs associated with the query. For more information see the query runs schedule details section. |
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 Run once and Scheduled . Queries can be filtered according to their run frequency. |
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 status values are: Success , Failed , In progress , and No runs . |
If you navigate to the Query Editor, you can select Queries to return to the Templates tab.
You can adjust the columns on the Scheduled Queries tab to your needs. Select the settings icon () to open the Customize table settings dialog and edit available columns.
Toggle the relevant checkboxes to remove or add a table column. Next, select Apply to confirm your choices.
Any query that was created through the UI becomes a named template as part of the creation process. The template name is seen in the template column. If the query was created through the API then the template column is blank.
You can subscribe to alerts from the Scheduled Queries tab. Select the alert notification icon () next to a query name to open the Alerts dialog. The Alerts dialog subscribes to both UI notifications and email alerts. Alerts are based on the status of the query. There are three options available:
start
, success
, and failure
. Check the appropriate box or boxes and select Save to subscribe.
See the alert subscriptions API documentation for more information.
You can filter queries based on run frequency. From the Scheduled Queries tab, select the filter icon () to open the filter sidebar.
Select either the Scheduled or Run once run frequency filter checkboxes to filter the list of queries.
Any query that has been executed but not scheduled qualifies as Run once.
Once you have enabled your filter criteria, select Hide Filters to close the filter panel.
Select a query name to navigate to the schedule details page. This view provides a list of all the runs executed as part of that scheduled query. The information provided includes the start and end time, status, and dataset used.
This information is provided in a five-column table. Each row denotes a query execution.
Column name | Description |
---|---|
Query run ID | The query run ID for the daily execution. Select the Query run ID to navigate to the Query run overview. |
Query run start | The timestamp when the query was executed. This is in UTC format. |
Query run complete | The timestamp when the query was completed. This is in UTC format. |
Status | The status of the most recent query execution. The three status values are: successful failed or in progress . |
Dataset | The dataset involved in the execution. |
Details of the query being scheduled can be seen in the Properties panel. This panel includes the initial query ID, client type, template name, query SQL, and cadence of the schedule.
Select a query run ID to navigate to the run details page and view query information.
The Query run overview provides information on individual runs for this scheduled query and a more detailed breakdown of the run status. This page also includes the client information and details of any errors that may have caused the query to fail.
The query status section provides the error code and error message should the query have failed.
You can copy the query SQL to your clipboard from this view. Select the copy icon in the top right of the SQL snippet to copy the query. A popup message confirms that the code has been copied.
Queries that use anonymous blocks to comprise their SQL statements are separated into their individual queries. This allows you to inspect the run details for each query block individually.
Anonymous blocks are denoted through the use of a $$
prefix before the query. See the anonymous block document to find out more about anonymous blocks in query service.
Anonymous block queries have tabs to the left of the run status. Select a tab to display the run details…
In the event an anonymous block query fails, you can find the error code for that particular block through this UI.
Select Query to return to the schedule details screen, or Scheduled Queries to return to the Scheduled Queries tab.