What causes ICEBERG_EXTERNAL_VOLUME_ERROR?

The external volume's IAM role or storage integration lost permission to the S3 bucket or ADLS container. The external volume was dropped or its storage location was changed after the Iceberg table was created. The S3 bucket or ADLS container referenced by the external volume was deleted or renamed. The Iceberg table's metadata path within the external volume is incorrect

How do I fix ICEBERG_EXTERNAL_VOLUME_ERROR?

Step 1: Run DESCRIBE EXTERNAL VOLUME volume_name to verify the volume configuration and active storage location.. Step 2: Test access by running SYSTEM$VALIDATE_STORAGE_INTEGRATION for the underlying storage integration.. Step 3: Verify the IAM role or service principal has s3:GetObject, s3:PutObject, and s3:ListBucket permissions on the bucket.. Step 4: If the bucket was renamed or deleted, update the external volume with ALTER EXTERNAL VOLUME.. Step 5: Re-create the Iceberg table if the volume configuration was fundamentally changed.

High severityconfiguration

Power BI Refresh Error:
ICEBERG_EXTERNAL_VOLUME_ERROR

What does this error mean?

A Snowflake Iceberg table operation failed because the external volume pointing to the cloud storage location is misconfigured or inaccessible.

Common causes

1The external volume's IAM role or storage integration lost permission to the S3 bucket or ADLS container
2The external volume was dropped or its storage location was changed after the Iceberg table was created
3The S3 bucket or ADLS container referenced by the external volume was deleted or renamed
4The Iceberg table's metadata path within the external volume is incorrect

How to fix it

1Step 1: Run DESCRIBE EXTERNAL VOLUME volume_name to verify the volume configuration and active storage location.
2Step 2: Test access by running SYSTEM$VALIDATE_STORAGE_INTEGRATION for the underlying storage integration.
3Step 3: Verify the IAM role or service principal has s3:GetObject, s3:PutObject, and s3:ListBucket permissions on the bucket.
4Step 4: If the bucket was renamed or deleted, update the external volume with ALTER EXTERNAL VOLUME.
5Step 5: Re-create the Iceberg table if the volume configuration was fundamentally changed.

Frequently asked questions

What is the difference between a Snowflake external volume and a storage integration?

A storage integration is a Snowflake-managed IAM trust relationship with cloud storage. An external volume uses a storage integration to define a specific storage location for Iceberg or external table data.

Can I use Snowflake Iceberg tables with both AWS and Azure storage?

Yes — Iceberg tables support AWS S3, Azure Data Lake Storage Gen2, and Google Cloud Storage as external volumes, depending on the Snowflake account's cloud provider.