> This page is for Glide Classic.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://www.glideapps.com/docs/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://www.glideapps.com/docs/_mcp/server.

# BigQuery

> Bring your BigQuery data into Glide.

#### BigQuery Video

[BigQuery](https://cloud.google.com/bigquery) is Google Cloud's data warehouse tool that allows businesses to run analytics across a tremendous amount of data using SQL (Structured Query Language).

> **Note**
>
> BigQuery integration is only available on Enterprise plans. Need to upgrade? Read more about our plans and pricing [here](https://www.glideapps.com/pricing).

## Getting Set up with BigQuery

Before using BigQuery with Glide, [you'll need to set up a BigQuery account.](https://cloud.google.com/bigquery)

Make sure your first column in your data set is a unique string or number column named 'id' so Glide can identify the rows.

New to SQL queries? [Check out Google's documentation to get started](https://cloud.google.com/bigquery/docs/reference/standard-sql/introduction).

Make sure cookies are left on in your personal Glide settings.

## Syncing Data from BigQuery

> **Warning**
>
> Before adding your BigQuery data source, decide who in your Glide team will control the integration. This Glide user account needs to be part of the team as long as you are using BigQuery and cannot be changed or removed. Any updates to the BigQuery connection must be performed by this same team member.

#### BigQuery Sync Arcade

From the [Data Editor](/docs/getting-started/introduction-to-the-data-editor), navigate to the Tables menu in the left sidebar and select plus (+) to add a new [Data Source](/docs/essentials/data-sources).

Select **BigQuery** and sign in to the relevant Google account.

**Search or browse your datasets** and select the one you want to sync with Glide.

In the query screen, run whatever queries you like to create the dataset you want to pull into Glide.

When you're ready, you can name the query and save it as a table.

You can now work with this data for your Glide app.

## Editing Your Synced Table

> **Note**
>
> Unlike our other data integrations, changes you make to BigQuery data in Glide do not write back to your BigQuery data warehouse. Glide uses BigQuery as a read-only data source.

To change your table:

Select **edit query** in the upper right corner of your query table.

Make any changes to the query you'd like.

Preview your data, then save it to update your table.

## Limitations of BigQuery

There are some features in Glide that aren't compatible with a table generated from BigQuery. Those features are:

* [Row owners](/docs/essentials/security-and-user-data/row-owners)
* [Protected columns](/docs/essentials/security-and-user-data/protected-columns)
* [Rollups](/docs/automation/computed-columns/rollup-column) and [lookups](/docs/automation/computed-columns/lookup-column) into relations
* [Grouping](/docs/reference/user-experience/group)

In [computed columns](/docs/automation/computed-columns), filtering, sorted, and search is not supported.

The following components will load at most 5000 rows:

* Chart
* Radial Chart
* Choice
* Kanban
* Calendar

## Frequently Asked Questions

#### I don't see the option to add BigQuery in tables.

You might need an Enterprise plan! [You can read more about our plans and pricing here.](https://www.glideapps.com/pricing)

#### I don't see BigQuery on the 'select a source' page for my new app.

To sync your BigQuery data for an app, first create an empty app with Glide tables. Then you can sync the data source using the steps above.

#### My sign-in screen for BigQuery won't load.

Please make sure you have cookies turned on in your Glide settings, and that you aren't using a web browser or tool that blocks third party cookies.

#### I'm getting a 'There was an issue running your query' error.

Your table will need to have a first column with a unique string or column number labeled 'id.'

#### I need help learning BigQuery.

BigQuery has an extensive [documentation library](https://cloud.google.com/bigquery/docs) that can help.