Hi all, I'm sure this has been asked several time,...
# ask-community-for-troubleshooting
p
Hi all, I'm sure this has been asked several time, but I'm new to BigQuery (as well as Airbyte). Do you recommend setting: • a) One datasource in BigQuery per source • b) A single datasource (and prefix the tables) ?
u
You don’t need to have one BQ connector per source, you can create one destination and use the Custom Namespace to send the data to the correct schema.
p
Got it, thanks! But generally do people tend to create one single BQ dataset or one dataset per source?
u
Depends on each project, probably one dataset to keep data in one place