---
title: "A1 Status with Interactive Queries"
date: "2024-02-14T06:18:38+00:00"
summary: "Monitor your Interactive Queries workflow with A1 Status table. Track execution status, job details, and configuration settings for efficient data management and downstream process scheduling."
image:
type: "page"
url: "/customer-data-platform/a1-status-interactive-queries"
id: "90d96ed4-337b-49ec-af31-614414a506ef"
---

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.

![AI status table](https://acquia.widen.net/content/ooaiyjxgqr/jpeg/cdp_ai-status-table.jpeg?position=c&color=ffffffff&quality=80&u=lcfvma)

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](https://redash.io/help/user-guide/querying/scheduling-a-query/#:~:text=When%20you%20schedule%20queries%20to,scheduling%20system%20like%20CRON%20instead.).

![cdp_iq-timeutc.png](https://acquia.widen.net/content/4b2de052-0f15-49ca-b29e-e33e69f0905c/web/cdp_iq-timeutc.png)

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'