Hi Alberto

I've found a solution using spark connector with the credentials

 

spark.read.format("bigquery")
This returns the correct data and format I expect.
I highly recommend a fix on federation engine to support bigquery as a foreign catalog
 
Best regards