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:

IN -> Sybase_01.sql
CREATE TABLE remote_data(
    remote_id INT
) 
AT 'remote_server;remote_db;owner;remote_object';

Output Code:

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

Last updated