# BigQuery

## Introduction

Google BigQuery is a cloud-based data warehousing and analytics platform that enables users to analyze and process large datasets using SQL-like queries. It is highly scalable and allows users to store and query massive amounts of data in real time.

Check out our [BigQuery guides](/two-way-sync/guides/modify-salesforce-data-in-postgres.md) to get started and sync data to your other systems and databases!

## Things to keep in mind

#### Quotas and Limits

There is a limit of 1,500 table modifications that can be made to a BigQuery table in a day. Table modifications include `DELETE`, `INSERT`, `MERGE`, `TRUNCATE TABLE`, or `UPDATE` statements. If a table reaches this limit, any new modifications made through independent load jobs might fail. However, Stacksync operations are designed to avoid quota limitations so your syncs won't fail.

This is a restriction set by Google, for more details:

{% embed url="<https://cloud.google.com/bigquery/quotas>" %}

#### Views are not supported

As of now, only **tables** can be synced with Stacksync. Views and materialized views cannot be synced, but we are working on it! Stay tuned!


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.stacksync.com/two-way-sync/connectors/bigquery.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
