# Configure and validate backups for Snowflake data

Create an AI application instance for your Snowflake account.

When the instance is created, Commvault automatically creates a default subclient that specifies the Snowflake data to protect. You can also configure default subclient to backup and protect specific data at a particular time or frequency.

## Before You Begin

If you are an MSP and you want your tenant administrators to configure backups for Snowflake data, see Managed Service Provider Configuration.

## Start the configuration

1. From the Command Center navigation pane, go to Protect > AI & Analytics.

2. Click Add AI application.

3. Select Snowflake, and then click Next.

## Specify credentials

Provide credentials for a Snowflake user that can connect to your account and access the data you want to protect.

If you already have a cloud app connection, you can use that instead of creating a new one.

To create a new cloud app connection, follow these steps:

1. Select New Cloud App Connection.

2. Enter a name for the Snowflake instance, and then enter the user account identifier.

   An account locator used as an identifier can include segments in different forms.

   For example, in the account identifier `swa53414.east-us-2.azure`:

   - `swa53414`: [account_locator]

   - `east-us-2`: [cloud_region_id]

   - `azure`: [cloud platform]

   For more information, see Account identifiers.

3. Upload the user's private key, and then enter the password for the private key.

4. Click Next.

## Specify data to back up with the default subclient

Specify the Snowflake data that you want the default subclient for the AI application instance to protect.

You can either use rules to automatically include content or you can select specific objects.

- Use rules (recommended): Define rules to automatically include databases, schemas, or tables based on naming patterns or other criteria. This approach is better for dynamic environments where new data is created regularly.

- Select specific data: Choose individual databases, schemas, or tables to include in backups. Use this approach for smaller or static environments where the data set does not change frequently.

- If you use rules, define criteria that match the databases, schemas, and tables you want to protect.

For example:

- Include all production data by matching names that contain `prod` or `production`

- Protect finance-related data by selecting objects with names that start with `fin_` or `acct_`

- Exclude temporary or staging data by filtering out names that contain `tmp`, `test`, or `staging`

- Target region-specific data by selecting objects with names that include `us`, `eu`, or other location identifiers

- Protect all tables except a known exception by excluding a specific name or pattern

- Save your configuration and continue.

## Create a backup plan

Create a backup plan for your Snowflake data.

Important

Use a backup plan that stores data without deduplication, because deduplication is not supported for Snowflake backups.

To optimize performance and avoid egress charges, use storage in the same cloud provider and region as your Snowflake account.

If you already have a backup plan for Snowflake, you can select it instead of creating a new backup plan.

1. Click the add button.

2. Enter a name for the backup plan, and then create or select Air Gap Protect storage.

   More information:

   - Backup plans

   - Air Gap Protect.

## Review summary

1. Review the summary.

2. Click Submit.

## Validation

### Verify the configuration

1. Confirm that the Snowflake instance appears in the list of configured AI applications.

2. Confirm that the default subclient is listed and associated with the backup plan.

### Run a backup

Run a backup for the Snowflake instance you created to confirm that backups work correctly.

You can also test backups for some individual subclients.

1. From the Command Center navigation pane, go to Protect > AI & Analytics.

2. For the application that you want to back up, click the action button , and then click Back up.

3. Select Incremental or Full.

   The default subclient is included in the backup operation.

4. Click Submit.

### Confirm that the backup completed successfully

1. From the Command Center navigation pane, go to Monitor > Jobs.

2. Locate the backup job for the Snowflake instance.

3. Confirm that the job status is Completed.

If the job fails, review the error details. Common causes include permission issues and network connectivity problems.

For more information, see Plan your Snowflake deployment.

### Test a restore

To confirm you can restore data, perform a simple table restore.

1. From the Command Center navigation pane, go to Protect > AI & Analytics.

2. Click the Snowflake instance.

3. On the Overview tab, in the Recovery points section, select the recovery point, and then click Restore.

4. Go to the database and select a small table to restore.

5. Click Restore.

6. Verify that the In place restore mode type is selected.

7. Verify that the restored data is accessible.

×

Loading...