MSCINF0006

External table translated to regular table

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

None

Description

Since Snowflake supports a more limited set of features for external tables, these will be transformed into regular tables.

Code Example

Input Code:

Oracle

CREATE OR REPLACE EXTERNAL TABLE external_table_test
(
  col1 INTEGER,
  col2 STRING,
  col3 STRING
)
OPTIONS (
  format = 'CSV',
  field_delimiter = ',',
  uris = ['gs://my_bucket/file.csv']
);

Output Code:

Snowflake

--** MSC-INFORMATION - MSCINF0058 - EXTERNAL TABLE TRANSLATED TO REGULAR TABLE **
CREATE OR REPLACE TABLE external_table_test (
  col1 INTEGER,
  col2 STRING,
  col3 STRING
)
--OPTIONS(
--  format = 'CSV',
--  field_delimiter = ',',
--  uris = ['gs://my_bucket/file.csv']
--)
 ;

Recommendations

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