MSC-BQ0015

The resulting table has no columns.

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

Severity

Medium

Description

When an External Table is transformed to a regular Table and there is no way to get the columns names, this EWI is added.

Code Example

BigQuery

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

Snowflake

--** 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']
--)
 ;

Recommendations

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