This is a deprecated version of the SnowConvert documentation, please visit the official site .
When an External Table is transformed to a regular Table and there is no way to get the columns names, this EWI is added.
CREATE OR REPLACE EXTERNAL TABLE external_table_test
OPTIONS (
format = 'CSV',
field_delimiter = ',',
uris = ['gs://my_bucket/file.csv']
);
--** MSC-INFORMATION - MSCINF0058 - EXTERNAL TABLE TRANSLATED TO REGULAR TABLE **
--** MSC-ERROR - MSC-BQ0014 - THE RESULTING TABLE HAS NO COLUMNS **
CREATE OR REPLACE TABLE external_table_test (
)
--OPTIONS (
-- format = 'CSV',
-- field_delimiter = ',',
-- uris = ['gs://my_bucket/file.csv']
--)
;