Bigquery - External Table

[Preeti123]

Hi Team,

I need to create one external table and I want to take .parquet and .parq type source format at once. I can create for parquet and parq format separately but my requirement to create external table for both at once. Kindly help me with this 

Like this:

[Aris_O]

You can create a external table with multiple source file but it should have the same type source format.

This article might help you:
https://cloud.google.com/bigquery/docs/external-tables#external_table_limitations

[kolban]

I'm wondering if the data files represent disjoint sets of data ... if they are of the same schema but different physical encodings, I'm wondering (out loud) if we can create TWO external tables ... one using one physical encoding for one set of data files and the other using a different physical encoding for the other set of data files and then create a "view" that joins both tables together.  Would that work?

[Preeti123]

I will try this. Thankyou

[Preeti123]

Thankyou. But it will not help for required result.