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:
COMMENT ON FUNCTION function_name (out argname VARCHAR) IS 'this is a comment';
Output Code:
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 snowconvert-support@snowflake.com
Last updated