As Mentioned by the @guillaume blaquiere solution for this is BigLake. For more details refer to this documentation. And also you can load all the parquet files from cloud storage to BigQuery. Check in this link to load parquet files.

Posting the answer as community wiki for the benefit of the community that might encounter this use case in the future.

Feel free to edit this answer for additional information