SSC-EWI-TS0061

ALTER COLUMN not supported

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.

Severity

Medium

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

Description

This EWI is added whenever there is an unsupported ALTER COLUMN statement

Code Example

Input Code:

IN -> SqlServer_01.sql

ALTER TABLE SampleTable
ALTER COLUMN SampleColumn INT NULL SPARSE;

Output Code:

OUT -> SqlServer_01.sql

ALTER TABLE IF EXISTS SampleTable
ALTER COLUMN SampleColumn
                          !!!RESOLVE EWI!!! /*** SSC-EWI-TS0061 - ALTER COLUMN COMMENTED OUT BECAUSE SPARSE COLUMN IS NOT SUPPORTED IN SNOWFLAKE ***/!!!
                          INT NULL SPARSE;

Recommendations

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