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 nameData typeDescription
EXTERNAL_VOLUME_IDNUMBERThe unique ID of the external volume associated with the error.
EXTERNAL_VOLUME_NAMEVARCHARThe name of the external volume associated with the error.
CREATED_ONTIMESTAMP_LTZDate and time when the error was raised.
EXTERNAL_VOLUME_PATHVARCHARFull path to the file on the external volume associated with the error.
MESSAGEVARCHARThe Snowflake error message.
STORAGE_METHOD_NAMEVARCHARThe method (action) tried against the storage location; for example, findRegionForLocation or deleteCurrentFiles.
STORAGE_PROVIDER_ERROR_MESSAGEVARCHARThe 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';

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());