How to create External table with avro formate in Big Query

Since Avro is a data serialisation system, a schema specification is necessary. JSON can be used to define Avro schemas.
The structure of your data is specified by this schema. For creating table in Big Query , Apache Hive,Spark , you may make a table in the Avro format like this one:

Create External table 
with Parttion columns
Options{
enum_as_string=false,
enable_list_inference=false,
formate="avro",
hive_partitionon_uri_prifix="path upto folder only ",
uris=["path till partition"]
}

Conclusion

Here we learn about creation of external table in big query. In your big data environment, create the table: You will build a table and indicate that it should utilise the Avro format, depending on your particular big data platform (Big Query, Hadoop, Spark, Hive, etc.). For instance, with Apache Hive, you may make a table in the Avro format.