SPRKHVSQL1006

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 external table if not exists table12
(
product                 string,
date_ac                string,
asofdate                 int
)
partitioned by (asofdate int)
;

Output code:

--EWI: SPRKSPSQL1006 =>  The element SqlCreateExternalTable.SqlCreateExternalTableStart is not mapped yet.
--EWI: SPRKSPSQL1006 =>  The element SqlCreateExternalTable is not mapped yet.
create external table
                      --EWI: SPRKSPSQL1006 =>  The element SqlCreateExternalTable.SqlCreateExternalTableStart.SqlIfNotExists is not mapped yet.
                      if not exists
                                    --EWI: SPRKSPSQL1006 =>  The element SqlCreateExternalTable.SqlName is not mapped yet.
                                    table12
--EWI: SPRKSPSQL1006 =>  The element SqlCreateExternalTable.SqlTableElementList is not mapped yet.
(
   --EWI: SPRKSPSQL1006 =>  The element SqlCreateExternalTable.SqlTableElementList.SqlColumnDefinition.SqlName is not mapped yet.
   --EWI: SPRKSPSQL1006 =>  The element SqlCreateExternalTable.SqlTableElementList.SqlColumnDefinition is not mapped yet.
product                 string,
   --EWI: SPRKSPSQL1006 =>  The element SqlCreateExternalTable.SqlTableElementList.SqlColumnDefinition.SqlName is not mapped yet.
   --EWI: SPRKSPSQL1006 =>  The element SqlCreateExternalTable.SqlTableElementList.SqlColumnDefinition is not mapped yet.
date_ac                string,
   --EWI: SPRKSPSQL1006 =>  The element SqlCreateExternalTable.SqlTableElementList.SqlColumnDefinition.SqlName is not mapped yet.
   --EWI: SPRKSPSQL1006 =>  The element SqlCreateExternalTable.SqlTableElementList.SqlColumnDefinition is not mapped yet.
asofdate                 int
)
--partitioned by (asofdate int)
;

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.