SSC-FDM-0032

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

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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 [email protected]