# SnowflakeLoader

> **Class** in `langchain_community`

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

Load from `Snowflake` API.

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
SnowflakeLoader(
    self,
    query: str,
    user: str,
    password: str,
    account: str,
    warehouse: str,
    role: str,
    database: str,
    schema: str,
    parameters: Optional[Dict[str, Any]] = None,
    page_content_columns: Optional[List[str]] = None,
    metadata_columns: Optional[List[str]] = None,
)
```

## Parameters

| Name | Type | Required | Description |
|------|------|----------|-------------|
| `query` | `str` | Yes | The query to run in Snowflake. |
| `user` | `str` | Yes | Snowflake user. |
| `password` | `str` | Yes | Snowflake password. |
| `account` | `str` | Yes | Snowflake account. |
| `warehouse` | `str` | Yes | Snowflake warehouse. |
| `role` | `str` | Yes | Snowflake role. |
| `database` | `str` | Yes | Snowflake database |
| `schema` | `str` | Yes | Snowflake schema |
| `parameters` | `Optional[Dict[str, Any]]` | No | Optional. Parameters to pass to the query. (default: `None`) |
| `page_content_columns` | `Optional[List[str]]` | No | Optional. Columns written to Document `page_content`. (default: `None`) |
| `metadata_columns` | `Optional[List[str]]` | No | Optional. Columns written to Document `metadata`. (default: `None`) |

## Extends

- `BaseLoader`

## Constructors

```python
__init__(
    self,
    query: str,
    user: str,
    password: str,
    account: str,
    warehouse: str,
    role: str,
    database: str,
    schema: str,
    parameters: Optional[Dict[str, Any]] = None,
    page_content_columns: Optional[List[str]] = None,
    metadata_columns: Optional[List[str]] = None,
)
```

| Name | Type |
|------|------|
| `query` | `str` |
| `user` | `str` |
| `password` | `str` |
| `account` | `str` |
| `warehouse` | `str` |
| `role` | `str` |
| `database` | `str` |
| `schema` | `str` |
| `parameters` | `Optional[Dict[str, Any]]` |
| `page_content_columns` | `Optional[List[str]]` |
| `metadata_columns` | `Optional[List[str]]` |


## Properties

- `query`
- `user`
- `password`
- `account`
- `warehouse`
- `role`
- `database`
- `schema`
- `parameters`
- `page_content_columns`
- `metadata_columns`

## Methods

- [`lazy_load()`](https://reference.langchain.com/python/langchain-community/document_loaders/snowflake_loader/SnowflakeLoader/lazy_load)

---

[View source on GitHub](https://github.com/langchain-ai/langchain-community/blob/a6a6079511ac8a5c1293337f88096b8641562e77/libs/community/langchain_community/document_loaders/snowflake_loader.py#L10)