How does CopyStorm/Restore Work with Snowflake?
CopyStorm/Restore supports the ability to restore Salesforce data directly from a Snowflake database. This allows organizations that use CopyStorm to archive Salesforce data into Snowflake (for analytics or storage) to also leverage that same data for recovery purposes.
When configured with a Snowflake connection, CopyStorm/Restore behaves similarly to how it would with a traditional relational database. All standard restore operations are supported as long as the data exists in Snowflake.
When to Use CopyStorm/Restore with Snowflake
- You’re already archiving Salesforce data to Snowflake with CopyStorm.
- You need a simple recovery option without setting up a second relational database.
- You don’t need metadata restore, snapshot-based restores, or file attachment support.
Unsupported Features
- Metadata Restore – Metadata cannot be restored from Snowflake.
- Point-in-Time Restore / Snapshots – Snapshot data is not supported in Snowflake.
- CS:Govern Restore – CS:Govern is not available for Snowflake.
- Base64 / Binary Content – Snowflake does not support native CLOB or binary types in the required format. As a result, objects like Attachment & ContentVersion cannot be restored from Snowflake.