This EWI is added when referencing not supported or whithout equivalent in Snowflake SQL. to see the complete list of supported and not supported system tables.
Code Example
Input Code:
IN -> SqlServer_01.sql
SELECT *
FROM
sys.all_sql_modules
WHERE
[STATE] = 0; -- state must be ONLINE
Output Code:
OUT -> SqlServer_01.sql
SELECT
*
FROM
!!!RESOLVE EWI!!! /*** SSC-EWI-TS0046 - SYSTEM TABLE sys.all_sql_modules IS NOT SUPPORTED IN SNOWFLAKE ***/!!!
sys.all_sql_modules
WHERE
STATE = 0; -- state must be ONLINE
