I've tested a foreign catalog connected to a google bigquery project.

The connection was ok and I was able to see my datasets and tables

The problem: for columns with regular data types the data format is perfect but the columns with type record and repeated(arrays) I was expecting the see the json format like I see in google big query results.

The data is a json but with a completely different schema and it doesn't make any sense. The foreign catalog maps the record and repeated data types to varchar(65535). 

Federation is a great feature but those incorrect data conversions are a disaster. 

Any helps?