The EWI appears when the tool detects an element that is not yet in the mapping table.
Input code:
createexternaltableifnotexists 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.createexternaltable--EWI: SPRKSPSQL1006 => The element SqlCreateExternalTable.SqlCreateExternalTableStart.SqlIfNotExists is not mapped yet.ifnotexists--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 sma-support@snowflake.com. If you have a support contract with Snowflake, reach out to your sales engineer, who can direct your support needs.