MSCEWI3073

Create Database Link Not Supported

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

Right now the severity of this issue is low because all the objects that are referenced by the database link created in Oracle should be created in the same Snowflake instance after the SnowConvert migration is completed.

Severity

Low

Description

This warning is used to indicate that database links are not supported in Snowflake and that all of the objects this database link uses should be created in the same Snowflake instance after the migration.

Example Code

Input Code:

CREATE DATABASE LINK mylink1
    CONNECT TO user1 IDENTIFIED BY password1
    USING 'my_connection_string1';

Output Code:

-- ** MSC-WARNING - MSCEWI3073 - CREATE DATABASE LINK NOT SUPPORTED [ DBLINK: mylink1 | USER: user1/password1 | CONNECTION: 'my_connection_string1' ] **
--CREATE DATABASE LINK mylink1
--    CONNECT TO user1 IDENTIFIED BY password1
--    USING 'my_connection_string1'

Recommendations

• Create all of the objects that are referenced by the database link to the same Snowflake database instance.

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