MSC-PG0023

The argument mode (IN, OUT, INOUT, VARIADIC) are not supported by Snowflake. By default, all the arguments are in IN mode.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

In Snowflake, the argument modes (IN, OUT, INOUT, VARIADIC) do not exist for functions, procedures, etc. By default, all the arguments are in In mode.

Example Code

Input Code:

PostgreSQL

 COMMENT ON FUNCTION  function_name (out argname VARCHAR) IS 'this is a comment';

Output Code:

Snowflake

COMMENT ON FUNCTION (VARCHAR /*** MSC-WARNING - MSC-PG0023 - THE ARGUMENT MODE(IN, OUT, INOUT, VARIADIC) ARE NOT SUPPORTED BY SNOWFLAKE. BY DEFAULT, ALL THE ARGUMENTS ARE IN MODE ***/) function_name IS 'this is a comment';

Recommendations

• If you need more support, you can email us at [email protected]