SSC-EWI-SY0006

Open string is not supported in Snowflake.

Severity

High

Description

Snowflake does not support OPENSTRING functionality.

Code Examples

Input Code:

Sybase

IN -> Sybase_01.sql

SELECT * FROM 
OPENSTRING (FILE '/path/to/file.txt') 
WITH (Col1 INT, Col2 VARCHAR(20)) AS OS;

Output Code:

Snowflake

OUT -> Sybase_01.sql

SELECT
  *
FROM
  !!!RESOLVE EWI!!! /*** SSC-EWI-SY006 - OPEN STRING IS NOT SUPPORTED IN SNOWFLAKE ***/!!!
  OPENSTRING(FILE '/path/to/file.txt')
  WITH
  (
    Col1 INT,
    Col2 VARCHAR(20)
  ) AS OS;

Recommendations

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