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?