SSC-FDM-0032

Parameter is not a literal value, transformation could not be fully applied

Description

For multiple transformations, SnowConvert sometimes requires to validate the contents of a parameter, which is only possible if the parameter is a literal value.

This message is generated to warn the user that SnowConvert could not retrieve the value of the parameter because it was passed by reference, causing the transformation of the function or statement to not be completed.

Example Code

Input Code (Redshift):

IN -> Redshift_01.sql

SELECT TO_CHAR(DATE '2001-01-01', 'YYY/MM/DD'),
TO_CHAR(DATE '2001-01-01', f)
FROM (SELECT 'YYY/MM/DD' as f);

Output Code:

OUT -> Redshift_01.sql

SELECT
PUBLIC.YEAR_PART_UDF(DATE '2001-01-01', 3) || TO_CHAR(DATE '2001-01-01', '/MM/DD'),
--** SSC-FDM-0032 - PARAMETER 'format_string' IS NOT A LITERAL VALUE, TRANSFORMATION COULD NOT BE FULLY APPLIED **
TO_CHAR(DATE '2001-01-01', f)
FROM (SELECT 'YYY/MM/DD' as f);

Recommendations

• Try to provide the specified parameter as a literal value.

• If you need more support, you can email us at [e-mail]