Airtable ➡️ Google Cloud Storage (.csv) ➡️ Google Data Studio [Help!]

[VictoriaPlummer]

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!

[Hendrik_Yang]

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.