Schema:: ACCOUNT_USAGE

APPLICATION_REMOTE_OPERATION_HISTORY view¶

Use the APPLICATION_REMOTE_OPERATION_HISTORY view to query the history of remote app operation invocations for Snowflake Native Apps in your Snowflake account.

The latency for this view is up to 1 hour, and the retention time is 365 days (1 year).

For more information about remote app operations, see Use remote app operations and Manage remote app operations.

Columns¶

The following table provides definitions for the APPLICATION_REMOTE_OPERATION_HISTORY view columns.

Column	Data type	Description
APPLICATION_NAME	VARCHAR	The name of the application on which the remote app operation was performed.
APPLICATION_ID	NUMBER	The internal, system-generated identifier for the application.
APPLICATION_HASH	VARCHAR	The provider-facing identifier for the application.
REQUEST_ID	VARCHAR	The unique identifier for the remote app operation invocation.
OPERATION_TYPE	VARCHAR	The type of remote operation. Possible values are: `run_sql`, `disable`, `enable`, `retry_upgrade`.
COMPLETED_ON	TIMESTAMP_LTZ	The timestamp when the operation was completed.
REQUEST_STATUS	VARCHAR	The status of the remote app operation invocation.
REQUEST_CONFIG	VARIANT	The configuration provided for the remote app operation invocation, such as `{"sql": "SELECT 1"}` for the `run_sql` operation.

Examples¶

Retrieve the remote app operation history for all applications in the current account:

SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.APPLICATION_REMOTE_OPERATION_HISTORY;

Retrieve the remote operation history for a specific application and specific operation type:

SELECT
    *
FROM
    SNOWFLAKE.ACCOUNT_USAGE.APPLICATION_REMOTE_OPERATION_HISTORY
WHERE
    APPLICATION_NAME = 'my_app'
    AND OPERATION_TYPE = 'run_sql'
ORDER BY
    COMPLETED_ON DESC;