MSCEWI5022

WITH SELECT ANALYZED TABLE IS NOT SUPPORTED

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

High

Description

The use of With Select Analyzed Table is not supported in Snowflake

Example Code

Input Code:

WITH sas_score_in (c1,c2) AS
 (
  SELECT c1,c2 FROM t1
 )
 SELECT *
 FROM sas_score_in ANALYZE_TABLE(
 IMPLEMENTATION 'PROVIDER=SAS; ROUTINE_SOURCE_TABLE=ETLIN.SOURCE_TABLE; ROUTINE_SOURCE_NAME=SCORING_FUN3;'
 )

Output Code:

----** MSC-ERROR - MSCEWI5022 - WITH SELECT ANALYZED TABLE IS NOT SUPPORTED **
--   WITH sas_score_in (c1,c2) AS
-- (
--  SELECT c1,c2 FROM t1
-- )
-- SELECT *
-- FROM sas_score_in ANALYZE_TABLE(
-- IMPLEMENTATION 'PROVIDER=SAS; ROUTINE_SOURCE_TABLE=ETLIN.SOURCE_TABLE; ROUTINE_SOURCE_NAME=SCORING_FUN3;'
-- )

Recommendations

• If this error happens is because there is no Snowflake equivalent for the node that is being converted.

• If you need more support, you can email us at [email protected]