https://community.databricks.com/t5/data-engineering/bigquery-as-foreign-catalog-full-object-structs/m-p/81349#M36279 <P>Hi -</P><P>We have mounted BigQuery, hosting Google Analytics data, as a foreign catalog.</P><P>When querying the tables, objects are returned as strings, with all keys obfuscated by "f" or "v", likely to avoid replicating object keys across all records and hence minimizing transfer of data.</P><P>How can these be mapped back to full object structure? Is there any off-the-shelf util / config?</P><P>Thanks,</P><P>Max</P> Wed, 31 Jul 2024 15:49:30 GMT mdelvaux 2024-07-31T15:49:30Z https://community.databricks.com/t5/data-engineering/bigquery-as-foreign-catalog-full-object-structs/m-p/81349#M36279 <P>Hi -</P><P>We have mounted BigQuery, hosting Google Analytics data, as a foreign catalog.</P><P>When querying the tables, objects are returned as strings, with all keys obfuscated by "f" or "v", likely to avoid replicating object keys across all records and hence minimizing transfer of data.</P><P>How can these be mapped back to full object structure? Is there any off-the-shelf util / config?</P><P>Thanks,</P><P>Max</P> Wed, 31 Jul 2024 15:49:30 GMT https://community.databricks.com/t5/data-engineering/bigquery-as-foreign-catalog-full-object-structs/m-p/81349#M36279 mdelvaux 2024-07-31T15:49:30Z