Acquia CDP
A1 Status with Interactive Queries
| 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:
Acquia CDPpipeline.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'
If this content did not answer your questions, try searching or contacting our support team for further assistance.
If this content did not answer your questions, try searching or contacting our support team for further assistance.