CDP displays a table view where you can review the overall status of the last Interactive Queries (IQ) execution, job status, start time, end time, and configuration setting for the workflow of your tenant. This table view, called A1_Status, is created and auto-populated as part of your IQ workflow.

The columns available in the A1_Status table view are:

IQ users, including Snowflake data sharing users, can query the A1_Status table periodically to learn when new data is available in IQ. This information can be leveraged to schedule any downstream processes. 

The following table lists the attributes in the Key column:

In the following example, the system uses the time in UTC rather than the value in the On time field. For more information, visit How to schedule a query.

For tenants using the BI workflow, which is upgraded to Snowflake architecture, in the A1_Status table:

• CDP does not display the configuration settings.
• The value in the Category field is pipeline.
• The value in the Source field is sf-bi.

Sample interactive query to retrieve the status of a tenant using Snowflake database:

select * from a1_status
where category='pipeline' and source='sf-bi'

A1 Status with Interactive Queries

CDP displays a table view where you can review the overall status of the last Interactive Queries (IQ) execution, job status, start time, end time, and configuration setting for the workflow of your tenant. This table view, called A1_Status, is created and auto-populated as part of your IQ workflow.

The columns available in the A1_Status table view are:

Column	Description	Data Type
Category	The source category of the workflow.	string
Source	The source of the workflow. For example, interactive-queries, sf-bi, or replication.	string
Type	The trigger source of the workflow. For example, Scheduled, Cohort.	string
Subtype	The campaign ID that triggered the workflow, when Type is Cohort.	string
Key	The key attribute to be tracked for the last run workflow.	string
Value	The value of the attribute for the last run workflow.	string
Data_Type	The datatype of the value.	string
Last_Modified	The time when the value was captured and saved.	timestamp

IQ users, including Snowflake data sharing users, can query the A1_Status table periodically to learn when new data is available in IQ. This information can be leveraged to schedule any downstream processes. 

The following table lists the attributes in the Key column:

Key	Description
status	The status of the most recent IQ workflow execution. For example, SUCCESS or FAILED.
start_time	The time in UTC when the workflow execution started.
end_time	The time in UTC when the workflow execution ended.
configuration	The workflow configuration settings in the JSON format. This is an internal setting used for the Extract, Transform, and Load (ETL) processes.

In the following example, the system uses the time in UTC rather than the value in the On time field. For more information, visit How to schedule a query.

For tenants using the BI workflow, which is upgraded to Snowflake architecture, in the A1_Status table:

• CDP does not display the configuration settings.
• The value in the Category field is pipeline.
• The value in the Source field is sf-bi.

Sample interactive query to retrieve the status of a tenant using Snowflake database:

copy

select * from a1_status
where category='pipeline' and source='sf-bi'