The Google Sheets connector pulls data from Google Sheets. Each sheet is treated as separate collection and being synced to separate table

Google BigQuery is a fast, scalable, and easy-to-use data warehouse. Main advantages of Google BiqQuery are:

• Serverless architecture.
• Pay-as-you go

Jitsu can stream and batch data to Google BigQuery. Streaming will get data to BQ immediately, however Google charges for each streamed record, while batching is free. Streaming is the fastest way to get started, but batching will be cheaper for large volumes.