MSCEWI5019

ANALYZE TABLE FACTOR IS NOT SUPPORTED

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

Severity

High

Description

The use of Analyze Table Factor is not supported in Snowflake

Example Code

Input Code:

SELECT
   *
FROM v1 ANALYZE_TABLE(
IMPLEMENTATION 'PROVIDER=SAS; ROUTINE_SOURCE_TABLE=ETLIN.SOURCE_TABLE; ROUTINE_SOURCE_NAME=SCORING_FUN3;')
ORDER BY 1;

Output Code:

SELECT
   *
FROM
--   --** MSC-ERROR - MSCEWI5019 - ANALYZE TABLE FACTOR IS NOT SUPPORTED **
--   v1 ANALYZE_TABLE(
--   IMPLEMENTATION 'PROVIDER=SAS; ROUTINE_SOURCE_TABLE=ETLIN.SOURCE_TABLE; ROUTINE_SOURCE_NAME=SCORING_FUN3;')
ORDER BY 1;

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]