# BigQueryLoader

> **Class** in `langchain_community`

📖 [View in docs](https://reference.langchain.com/python/langchain-community/document_loaders/bigquery/BigQueryLoader)

Load from the Google Cloud Platform `BigQuery`.

Each document represents one row of the result. The `page_content_columns`
are written into the `page_content` of the document. The `metadata_columns`
are written into the `metadata` of the document. By default, all columns
are written into the `page_content` and none into the `metadata`.

## Signature

```python
BigQueryLoader(
    self,
    query: str,
    project: Optional[str] = None,
    page_content_columns: Optional[List[str]] = None,
    metadata_columns: Optional[List[str]] = None,
    credentials: Optional[Credentials] = None,
)
```

## Parameters

| Name | Type | Required | Description |
|------|------|----------|-------------|
| `query` | `str` | Yes | The query to run in BigQuery. |
| `project` | `Optional[str]` | No | Optional. The project to run the query in. (default: `None`) |
| `page_content_columns` | `Optional[List[str]]` | No | Optional. The columns to write into the `page_content` of the document. (default: `None`) |
| `metadata_columns` | `Optional[List[str]]` | No | Optional. The columns to write into the `metadata` of the document. (default: `None`) |
| `credentials ` | `unknown` | Yes | google.auth.credentials.Credentials, optional Credentials for accessing Google APIs. Use this parameter to override default credentials, such as to use Compute Engine (`google.auth.compute_engine.Credentials`) or Service Account (`google.oauth2.service_account.Credentials`) credentials directly. |

## Extends

- `BaseLoader`

## Constructors

```python
__init__(
    self,
    query: str,
    project: Optional[str] = None,
    page_content_columns: Optional[List[str]] = None,
    metadata_columns: Optional[List[str]] = None,
    credentials: Optional[Credentials] = None,
)
```

| Name | Type |
|------|------|
| `query` | `str` |
| `project` | `Optional[str]` |
| `page_content_columns` | `Optional[List[str]]` |
| `metadata_columns` | `Optional[List[str]]` |
| `credentials` | `Optional[Credentials]` |


## Properties

- `query`
- `project`
- `page_content_columns`
- `metadata_columns`
- `credentials`

## Methods

- [`load()`](https://reference.langchain.com/python/langchain-community/document_loaders/bigquery/BigQueryLoader/load)

## ⚠️ Deprecated

Deprecated since version 0.0.32.

---

[View source on GitHub](https://github.com/langchain-ai/langchain-community/blob/4b280287bd55b99b44db2dd849f02d66c89534d5/libs/community/langchain_community/document_loaders/bigquery.py#L15)