Skip to main content Skip to complementary content

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.

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!