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_semicolon (
  remote_id INT
)
!!!RESOLVE EWI!!! /*** SSC-EWI-SY0002 - UNSUPPORTED REMOTE TABLE SYNTAX ***/!!!
AT 'remote_server;remote_db;owner;remote_object'
;

Recommendations

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