External table translated to regular table
Last updated 1 year ago
This is a deprecated version of the SnowConvert documentation, please visit the official site .
None
Since Snowflake supports a more limited set of features for external tables, these will be transformed into regular tables.
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'] );
--** 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'] --) ;
If you need more support, you can email us at