SSC-EWI-SY0002

Unsupported remote table syntax in Snowflake.

Severity

High

Description

Sybase IQ remote table syntax is not supported in Snowflake.

Code Examples

Input Code:

Sybase

IN -> Sybase_01.sql

CREATE TABLE remote_data(
    remote_id INT
) 
AT 'remote_server;remote_db;owner;remote_object';

Output Code:

Snowflake

OUT -> Sybase_01.sql

CREATE OR REPLACE TABLE remote_data (
    remote_id INT
)
    !!!RESOLVE EWI!!! /*** SSC-EWI-SY0002 - UNSUPPORTED REMOTE TABLE SYNTAX ***/!!!
AT 'remote_server;remote_db;owner;remote_object'
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "sybase",  "convertedOn": "07/02/2025",  "domain": "no-domain-provided" }}'
;

Recommendations

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