When creating a new big query external table with parquet files on gcs. Showing error

Question

I was trying to create a big query external table with parquet files on gcs. It's showing a wrong format error.

But using the same files to create a native table works fine. why it must be a native table.

If use a native table, how can I import more data to this table? I don't want to delete and create the table that every time I got new data.

Any help will be appreciated.

Answer 1

Parquet is not currently a supported data format for federated tables. You can repeatedly load more data into the same table as long as you append (instead of overwriting) the current contents.