CONNECTION

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Applies to

• SQL Server

Description

Some parts in the output code are omitted for clarity reasons.

When CONNECTION clause is in the ALTER statement, Snowconvert will comment out the entire statement, since it is not supported.

Sample Source Patterns

SQL Server

IN -> SqlServer_01.sql

ALTER TABLE bought 
ADD COL2 VARCHAR(32), CONSTRAINT EC_BOUGHT1 CONNECTION (Customer TO Product, Supplier TO Product) 
ON DELETE NO ACTION;

Snowflake

OUT -> SqlServer_01.sql

ALTER TABLE bought
ADD COL2 VARCHAR(32);

!!!RESOLVE EWI!!! /*** SSC-EWI-0109 - ALTER TABLE SYNTAX NOT APPLICABLE IN SNOWFLAKE ***/!!!
ALTER TABLE bought
ADD
CONSTRAINT EC_BOUGHT1 CONNECTION (Customer TO Product, Supplier TO Product)
ON DELETE NO ACTION;

Known Issues

1. ALTER TABLE CONNECTION clause is not supported in Snowflake.

The entire ALTER TABLE CONNECTION clause is commented out, since it is not supported in Snowflake.

Related EWIs

• SSC-EWI-0109: Alter Table syntax is not applicable in Snowflake.