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 configure user-defined subclients to backup and protect specific data at a particular time or frequency.

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. Later, you can create additional subclients for data that has different backup or retention requirements.

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.

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 selected subclients are 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.

4. Select the subclients. By default, all subclients are included in the backup operation.

5. Click Submit.

Confirm that the backup completed successfully

1. From the Command Center navigation pane, go to 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 Subclients tab.

4. Click the subclient.

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

6. Click Restore.

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

8. Verify that the restored data is accessible.