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.