Exporting a Backup to Azure Blob

Before you can upload data to an Azure Blob, you must:

Create the blob container to store your data. For more information on how to create a blob container, click here.
Create a new Azure Blob Endpoint in the application.

NOTE: We are not responsible for data exported from the application to external storage. We cannot be held responsible for the security, privacy or protection of data in any external storage. You are responsible for your Snowflake Data Warehouse Account security and privacy. We are unable to check that it is secure.

Export a Full Backup Azure Blob

Set up an Azure Blob endpoint, according to the instructions in the User Guide.
Navigate to the specific service that you wish to export.
Navigate to the specific backup (date) that you wish to export.

In the summary page of the specific date's backup, click Export.

From the Export to menu that appears, select Azure Blob.

In the Select Endpoint drop-down list, select the Azure Endpoint option that you want for this export.

Select whether to export All or Specific objects.
If you selected Specific objects, select the objects you wish to export.
If you wish to include attachments, check the Include attachments checkbox.

NOTE: When exporting specific objects of a full backup, if you select to export attachments, only the attachments for those specific objects are exported.

Click Export.

If you selected an unsecured Azure Blob container, then a warning message displays.

If you wish to proceed with the export, click Yes, export. The export starts a new job.

When the export job is complete, the screen will display a confirmation that the Backup Export job has successfully completed, along with a summary of the backup (number of records, etc.)

Check your Azure Blob for the exported files.

The export creates a folder with the backup name under the path provided. The GZIP file created for each object is a zipped CSV file. The export uploads the files to this folder, if a file was previously uploaded (same backup, same object) the file is overwritten.

To keep all historic versions of the object, enable versioning on the bucket.

If you have not set up the Azure Blob with the necessary permissions, an error message is displayed when you click Export.

Click here to see a list of the objects that are excluded from the data export.