How to Override Snowflake staging location

Internally, CopyStorm replicates data to Snowflake by creating a CSV file of the records being backed up and uploading the CSV file to Snowflake. It may be required to change this staging location to meet business requirements. CopyStorm allows customers to specify a different Snowflake stage by following this process:

Create a xml file named “SnowflakeDatabaseBuilder.xml”

Then place the contents below into the xml file.

<SnowflakeDatabaseBuilder>
    <SnowflakeStage value="@clientProvidedStagePath"/>
</SnowflakeDatabaseBuilder>

You will need to replace “clientProvidedStagePath” with the Snowflake stage’s path, then place this file into CopyStorm/config directory and relaunch CopyStorm.

Note: This feature is available in CopyStorm versions 10.56.5 and above.