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
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'
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.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!