Snowflake supports the following BigQuery formats:
BigQuery
Snowflake
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:
Output Code:
Recommendations
If you need more support, you can email us at
AVRO
AVRO
CSV
GOOGLE_SHEETS
CSV
NEWLINE_DELIMITED_JSON
JSON
JSON
ORC
ORC
PARQUET
PARQUET
IN -> BigQuery_01.sql
CREATE OR REPLACE EXTERNAL TABLE test.backup_restore_table
OPTIONS (
format = 'DATASTORE_BACKUP',
uris = ['gs://backup_bucket/backup_folder/*']
);
OUT -> BigQuery_01.sql
!!!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/*']
);
SSC-EWI-BQ0013
External table data format not supported in snowflake