SSC-EWI-BQ0013
External table data format not supported in snowflake
This EWI is deprecated; please refer to SSC-EWI-0029 for the latest version of this EWI.
Severity
Medium
Description
Snowflake supports the following BigQuery formats:
BigQuery
Snowflake
AVRO
AVRO
CSV GOOGLE_SHEETS
CSV
NEWLINE_DELIMITED_JSON JSON
JSON
ORC
ORC
PARQUET
PARQUET
When a external table has other FORMAT not specified in the above table, this EWI will be generated to inform the user that the FORMAT is not supported.
Code Example
Input Code:
CREATE OR REPLACE EXTERNAL TABLE test.backup_restore_table
OPTIONS (
format = 'DATASTORE_BACKUP',
uris = ['gs://backup_bucket/backup_folder/*']
);
Output Code:
!!!RESOLVE EWI!!! /*** SSC-EWI-BQ0013 - EXTERNAL TABLE DATA FORMAT NOT SUPPORTED IN SNOWFLAKE ***/!!!
CREATE OR REPLACE EXTERNAL TABLE test.backup_restore_table
OPTIONS (
format = 'DATASTORE_BACKUP',
uris = ['gs://backup_bucket/backup_folder/*']
);
Recommendations
If you need more support, you can email us at [email protected]
Last updated