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]​

MSCEWI3072

MSCEWI3074

Last modified 3mo ago