Microsoft SQL Server connector pulls data from the remote database.

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.