# Improving performances with a Snowflake target

In case of large file, using the SnowFlakeTarget.Put and SnowFlakeTarget.Remove parameters in the DD\_USRDATA.DD\_PARAM table enables to modify auto-compress mode.

## Procedure

1. Activate the compress mode with the following query:

   UPDATE DD\_USRDATA.DD\_PARAM SET PARVAL = 'put file://&snowfile @~ auto\_compress=true;' WHERE PARNAME='SnowFlakeTarget.Put'
2. Update removed compressed files with the following query:

   UPDATE DD\_USRDATA.DD\_PARAM SET PARVAL = 'rm @~ pattern=''&snowfile.\*'';' WHERE PARNAME='SnowFlakeTarget.Remove'

   Information noteWarning: If other parameters have been added to SnowFlakeTarget.Put and SnowFlakeTarget.Remove, make sure to update the queries with those parameters.