BigQuery as foreign catalog - full object structs
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-31-2024 08:49 AM
Hi -
We have mounted BigQuery, hosting Google Analytics data, as a foreign catalog.
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.
How can these be mapped back to full object structure? Is there any off-the-shelf util / config?
Thanks,
Max