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

# Big Tables

> Scale your app with up to 10 million rows of data.

#### Glide Big Tables

Built for the most demanding workflows, Big Tables are enterprise-grade databases hosted directly in Glide. While a normal [Glide Table](/docs/essentials/data-sources/glide-tables) has a limit of 25,000 rows, Big Tables can support up to 10 million rows. With Big Tables, your app can scale as your data grows.

Big Tables are a native Glide data source, and so they do not use updates when adding, editing, deleting, or syncing data. Data changes made with [Glide API](/docs/essentials/data-sources/getting-started-with-the-glide-api), however, still consume updates. Teams with an Enterprise plan will also use updates on Big Tables.

### Synchronous Saves

When a user saves data in a Glide app they will see an indicator on the bottom of the screen showing that the data is being saved. When the data has been safely saved to the Big Table, the indicator will disappear. If there are any errors during the save, the user will see an error message.

Changes to Big Tables made in the app will be updated on the Big Table. A refresh of the app or the data in the table is not necessary. Even if the data table shows "Query" in the cell, the data has been updated and refreshed data will appear live in the app if a component is connected to it.

## Creating a Big Table

You can only create Big Tables once you've created the app.

Select the [Data Editor](/docs/getting-started/introduction-to-the-data-editor) icon.

On the left side of the Data Editor, select the plus (+) icon.

Select **New big table**.

![Creating a Big Table in the Data Editor.](/docs/_fern-img/3cac10775ef9bb568991fb085c1d55088a05c6f8306de8d2f76c852f89c64f24.webp)

The Data Editor will create an empty table with a single cell. From here, you can add more rows and columns and configure them as you need.

## Import/Export Big Table data

### Import to a new Big Table

To import data into a new Big Table:

In the **Data Editor**, right-click the Big Table you'd like to import data into.

Select **Import**.

Choose which file to upload for import.

![Importing data into a Big Table.](/docs/_fern-img/0eadd7a26b41f28a1234e195db940b95feb94afa78d083a0660ba63e7a886253.webp)

Glide data imports support .xlsx, .csv, or .ods files.

### Import to an existing Big Table

To import data into an existing Big Table:

First, make sure the column names on the spreadsheet you want to import data from match the column names on the Big Table you want to import to. This helps Glide know where to put your imported data!

In the **Data Editor**, right-click the Big Table you'd like to import data into.

Select **Import**.

Choose which file to upload for import.

When you import data into an existing Big Table, Glide will add your rows to the existing table. It will not modify or delete the data that's already there.

### Exporting from a Big Table

To export data from a Big Table:

In the **Data Editor**, right-click the Big Table you'd like to export data from.

Select **Export**.

Choose which columns to export, or export all.

You will receive an email with your Big Table export as a .csv file.

![Exporting columns from a Big Table.](/docs/_fern-img/3a74cc35fe5f21905a79daa73c98f943af52cc261f8cd65d889bad2a75cdeb21.webp)

## Big Tables API

> **Glide API v2**
>
> Big Tables can be used with Glide APIv2, a RESTful API. [Read more at our advanced API documentation.](https://apidocs.glideapps.com/api-reference/v2/general/introduction)

You can also use an API to add rows, set columns, or delete rows from a Big Table. To use an API to add rows, set columns, get all rows, or delete rows from a Big Table:

* In the **Data Editor**, right-click on the Big Table you want to connect with.
* Select **Show API**.

![Show API options in the Data Editor.](/docs/_fern-img/a01b08153d4f46e102b50224f9787fe64446b1e2fac67c8c0db0a75a2046acc8.webp)

* The API usage provides examples for JavaScript, Python, and curl. Select one, then choose from either **Get rows, Add rows, Edit rows** or **Delete rows,** then click the Copy Code button to copy the API instructions to your clipboard.

![API code examples for JavaScript, Python, and curl.](/docs/_fern-img/62591505ddad997740906b557186b2722afda9c7ef374e55c6a23666bcd23f46.webp)

## Big Tables Audit Log

When you make changes to a Big Table via the API, an audit log is automatically generated to keep track of any new data that is written to your Big Table. This audit log will appear as a Big Table in the Data Editor called **GBT/SQL Table Audit Logs** and is read-only. The table cannot be deleted, but it can be renamed. The columns in the table also cannot be changed.

If you previously had a SQL source synced to your app, there will already be an audit log in the Data Editor called **SQL Table Audit Logs.** This same log will be used for your Big Tables audit information.

![An Existing SQL Table Audit Log](/docs/_fern-img/752e1c10e6cfb2eb19233c39ce4526091f86bd8d0d9fda5f9d2c3652dd50c020.webp)

## Limitations of Big Tables

There are some features in Glide that aren't compatible with a Big Table. These unavailable features are:

* **Single Value columns**: Cannot target a Big Table directly but work via [Multiple Relations](/docs/automation/computed-columns/relations#building-multiple-relations) or [Queries](/docs/automation/computed-columns/query-column). Only Single Value → First is supported.
* [Lookups](/docs/automation/computed-columns/lookup-column) into Big Tables (eg. Lookups via Multiple Relations or Lookups that target an entire Big Table column) are supported in Multiple Relations and Queries but limited to 100 matching rows.
* [Rollups](/docs/automation/computed-columns/rollup-column) and [Joined Lists](/docs/automation/computed-columns/joined-list): Work with most computed columns but are limited to 100 matching rows.
* **Delete Rows action:** Cannot be applied through a multi-relation in Big Tables.
* The [User Profile](/docs/essentials/security-and-user-data/user-profiles) data source cannot be a Big Table.
* Aggregations in general are limited to 100 matching rows.

## Frequently Asked Questions

#### Can I use Big Tables in my existing apps?

Yes!

#### Where is my data export?

When you export data, it will be emailed to the email address associated with your Glide account.

#### Why does my column show "Query" in every cell?

Some computed columns in Big Tables will show "Query" in the column rather than immediately displaying data. Because Big Tables save synchronously, this data is refreshed even without the "Query" text being clicked. Data from these columns can be used in the layout editor and will update synchronously, without a manual query.

> Scale your app with up to 10 million rows of data.

## Docs

- [Guide to Big Tables](https://www.glideapps.com/docs/essentials/data-sources/big-tables/guide-to-big-tables.md): Some ideas to help you get started with Big Tables