Summary
How to include a column in BigQuery to identify the Stripe account of each item when dumping multiple Stripe accounts into BigQuery using Airbyte
Question
hi! i want to use Airbyte to dump multiple Stripe accounts into BigQuery: i.e., one Source (Stripe), one destination (BigQuery), and multiple connections (hundreds)
how can i include a column in BigQuery to identify the Stripe account of each item? ideally, i’d want a connection_id or connection_name column to identify the connection… is it possible to somehow include some connection ID into the _airtable_meta column?
the docs offer ways to specify the dataset and the table prefix, but i’d end up with a lot of datasets or tables, all of them with the same schema, which doesn’t look like a clean solution
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.