Links

MSCEWI3073

Create Database Link Not Supported
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]