SPRKSPSQL1006

The element is not mapped yet

Category

Conversion error.

Description

The EWI appears when the tool detects an element that is not yet in the mapping table.

Input code:

CREATE FUNCTION blue() 
RETURNS STRING 
COMMENT 'Blue color code' 
LANGUAGE SQL 
RETURN '0000FF';

Output code:

CREATE FUNCTION blue()
RETURNS STRING
COMMENT =
          --EWI: SPRKSPSQL1006 =>  The element SqlCreateFunction.SqlCommentClause.SqlLiteralExpr is not mapped yet.
          'Blue color code'
--EWI: SPRKSPSQL1006 =>  The element SqlCreateFunction.SqlLanguageClause is not mapped yet.
LANGUAGE
         --EWI: SPRKSPSQL1006 =>  The element SqlCreateFunction.SqlLanguageClause.SqlSpecificLanguage is not mapped yet.
         SQL
RETURN
       --EWI: SPRKSPSQL1006 =>  The element SqlReturnStatement.SqlLiteralExpr is not mapped yet.
       '0000FF';

Recommendation

• For more support, email us at [e-mail]. If you have a support contract with Snowflake, reach out to your sales engineer, who can direct your support needs.