> Software > Protect > AI & analytics

Protect Snowflake data

Commvault protects Snowflake data so you can restore from deletion, corruption, or ransomware events and retain data beyond native Snowflake features such as Time Travel and Fail-safe. You can protect databases, schemas, and tables and restore them within the same account or to another account.

What's supported

Snowflake cloud platforms

Commvault supports Snowflake environments hosted on the following cloud platforms:

  • Amazon Web Services (AWS)

  • Microsoft Azure

Snowflake data

Commvault protects and recovers the following Snowflake data:

  • Databases

  • Schemas

  • Snowflake Tables

  • Views

  • Functions

  • Procedures

Backup and restore capabilities

Commvault protects Snowflake data using full and incremental backups and supports standard restore operations.

Backups

  • Backups use Snowflake streams to capture changes after the initial full backup.

  • Incremental backups capture only new or changed data for tables that support change tracking.

  • Backup behavior depends on whether tables have primary keys.

Tables with primary keys:

  • After an initial full backup, incremental backups capture changes using Snowflake streams.

  • Newly discovered tables are backed up with a full backup.

Tables without primary keys:

  • Incremental backups don’t capture changes for these tables.

  • If a previous full backup exists, the table is skipped during incremental backups.

  • Newly discovered tables are backed up with a full backup.

Data flow and storage

  • Commvault orchestrates backups directly from Snowflake to Commvault Air Gap Protect storage, which uses cloud object storage in AWS or Azure.

  • Backup data is copied without deduplication due to how Snowflake data is captured and transferred.

  • Each Snowflake account is configured as an AI application in Commvault.

Restores

You can restore data in place, to the same Snowflake account, or out of place, to a different Snowflake account.

What isn't supported

Commvault doesn't support the following:

  • Deduplicated storage for Snowflake backups

  • Incremental change capture for tables without primary keys

  • Restoring full databases or schemas to a different Snowflake account

×

Loading...