SSC-EWI-TS0046

System table is not supported in Snowflake.

Severity

Medium

Description

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

Recommendations

• If you need more support, you can email us at [e-mail]