
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 29, 2021 01:03 PM
Hey Y’all,
Is anyone familiar with Google Data Studio?
Context:
-
I’m playing with an idea of archiving data from Airtable.
-
To do that, I’m routinely exporting the JSON output from the API, and appending a CSV in Google Cloud Storage.
-
I’m using that CSV to create a report in Google Data Studio.
Problem:
-
I’m at a loss of how to leverage Linked Records in visualizations, which output from the API as an array of Record IDs.
-
Currently, Data Studio only sees them as strings.
Questions:
- What are my options for replicating many-to-many linked record relationships in Google Data Studio? Will I need to load my data into Big Query first?
- If so, what are some best practices/suggestions for working with Big Query I can leverage? Links are much appreciated!
Thanks in advance!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 03, 2022 12:43 AM
All the linked records must be duplicated to separate column as formula (as easy as reference the column). By doing that, the data is stored as text.
