Snowflake DBA

Iceberg Tables & External Storage

Question

A lake must remain in customer-managed object storage while Snowflake queries its Iceberg tables. What design fits?

Answer

Use an external volume. Configure its storage identity and location, grant required access, verify connectivity, and create Iceberg tables against that volume. Plan data protection and recovery outside Snowflake because Fail-safe is not provided for externally stored tables.

This is 16 of 21 free samples for Snowflake DBA.

More Snowflake DBA topic samples