Schema:: MONITORING

ICEBERG_ACCESS_ERRORS view¶

This MONITORING schema view displays external volume access errors for the account.

Use the information in this view to search for and troubleshoot access errors, which can result from situations like the following:

Snowflake loses privileges to access the external volume storage location.
Snowflake tries to access files that have been deleted or overwritten.
Snowflake encounters other storage access issues.

See also:: Apache Iceberg™ tables

Columns¶

Column name	Data type	Description
EXTERNAL_VOLUME_ID	NUMBER	The unique ID of the external volume associated with the error.
EXTERNAL_VOLUME_NAME	TEXT	The name of the external volume associated with the error.
CREATED_ON	TIMESTAMP_LTZ	Date and time when the error was raised.
EXTERNAL_VOLUME_PATH	TEXT	Full path to the file on the external volume associated with the error.
MESSAGE	TEXT	The Snowflake error message.
STORAGE_METHOD_NAME	TEXT	The method (action) tried against the storage location; for example, `findRegionForLocation` or `deleteCurrentFiles`.
STORAGE_PROVIDER_ERROR_MESSAGE	TEXT	The error message received from your cloud service provider.

Examples¶

Retrieve all storage access errors for the external volume named my_s3_external_volume:

SELECT * FROM snowflake.monitoring.iceberg_access_errors
  WHERE EXTERNAL_VOLUME_NAME ILIKE 'my_s3_external_volume';

Copy

Retrieve storage access errors that started within the last hour for the external volume named my_external_volume:

SELECT * FROM snowflake.monitoring.iceberg_access_errors
  WHERE EXTERNAL_VOLUME_NAME ILIKE 'my_external_volume'
  AND CREATED_ON > DATEADD(HOUR, -1, CURRENT_TIMESTAMP());

Copy