MSC-PG0005

Set search path with multiple schemas.

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

Severity

Medium

Description

Set search path with multiple schemas is not supported in Snowflake, you can consult here.

Code Example

Input Code:

PostgreSQL

SET SEARCH_PATH TO schema1, schema2, schema3;

Output Code:

Snowflake

--** MSC-ERROR - MSC-PG0005 - SET SEARCH PATH WITH MULTIPLE SCHEMAS IS NOT SUPPORTED IN SNOWFLAKE **
USE SCHEMA schema1 /*, schema2, schema3*/;

Recommendations

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