I connected my Airtable base to Google Data Studio using the standard Postgres connector to run some analytics for a project. The arrays aren’t causing any issues. It’s working great.
I have a small base right now, so it seems to be syncing instantly...
I’ve been wanting to query Airtable with SQL. We would use JOIN and UNION all the time when we used Microsoft Access. So this looks helpful!
But I’m curious how lookups will work here?
For example, if I have a record that is linked to two or more rec...