> ## Documentation Index
> Fetch the complete documentation index at: https://algolia.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Google BigQuery

> Index your data from a Google BigQuery table.

export const Index = () => <Tooltip tip="An Algolia index is a searchable dataset that consists of records and configuration settings. These settings define how the records are searched and ranked.">
    index
  </Tooltip>;

The BigQuery connector lets you read data from a BigQuery table and store it in an Algolia <Index />.

## Authentication

To authenticate the connector,
you need a [Google service account](https://cloud.google.com/iam/docs/service-account-overview) with the following permissions:

```txt theme={"system"}
bigquery.datasets.get
bigquery.datasets.getIamPolicy
bigquery.jobs.create
bigquery.models.export
bigquery.models.getData
bigquery.models.getMetadata
bigquery.models.list
bigquery.routines.get
bigquery.routines.list
bigquery.tables.createSnapshot
bigquery.tables.export
bigquery.tables.get
bigquery.tables.getData
bigquery.tables.getIamPolicy
bigquery.tables.list
resourcemanager.projects.get
storage.folders.get
storage.objects.get
storage.objects.list
```

If your BigQuery table uses Google Cloud Storage (GCS) or BigLake formats like Apache Iceberg or Delta Lake,
you need to configure `storage` permissions to let the [BigQuery Storage API](https://cloud.google.com/bigquery/docs/reference/storage) speed up indexing.

## Custom SQL statement

The connector imports your selected table by default.
To use a custom SQL statement, replace your table name with `%s`:

```sql SQL icon="database" theme={"system"}
SELECT * FROM %s WHERE Status="Available"
```

Each row must have a unique identifier that Algolia uses as the [object ID](/doc/guides/sending-and-managing-data/send-and-update-your-data#unique-object-identifiers).

<Tip>
  To stay within your BigQuery quota,
  don't schedule tasks to run at most once per day.
</Tip>

## Limitations

This connector is subject to the following limitations:

* [Connectors limits](/doc/guides/scaling/algolia-service-limits/#connectors-limits)
* [Transformation limits](/doc/guides/scaling/algolia-service-limits/#data-transformation-and-fetch-limits)