Hi @RobsonNLPT,

This is a limitation, the data conversion issue you are facing is expected behavior due to the current data type mappings supported by the Lakehouse Federation platform. Unfortunately, this means that the JSON format you see in Google BigQuery results is not preserved when the data is accessed through the foreign catalog in Databricks. BigQuery types such as array, geography, interval, json, string, and struct are mapped to VarcharType in Spark. I will check if there is a feature request to adjust this.