---
title: "Data Source - Snowflake"
slug: "data-source-snowflake"
updated: 2024-10-07T05:28:08Z
published: 2024-10-07T05:28:08Z
canonical: "documents.trocco.io/data-source-snowflake"
---

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

# Data Source - Snowflake

## summary

Help Page for ETL Configuration of Data Setting from Snowflake.

## constraints

- BINARY type is not supported.
- We have confirmed the transfer of 10 GB worth of CSV data.

## Setting items

### STEP1 Basic settings

| item name | indispensable | default value | Contents |
| --- | --- | --- | --- |
| Snowflake Connection Configuration | Yes | - | Select the preregistered [Snowflake Connection Configuration](/docs/connection-configuration-snowflake) that has the necessary permissions for this ETL Configuration. |
| Database Name | Yes | - | Specify the database name of the data you wish to transfer. |
| schema | Yes | public | Specify the schema of the data you wish to transfer. |
| Warehouse Name | Yes | - | Specify the warehouse name of the data you wish to transfer. |
| query | Yes | - | Enter a query to retrieve transfer data from Snowflake. [Custom Variables](/docs/custom-variables) can also be used to dynamically determine the value of a setting during ETL Configuration of TROCCO's data. |
| Number of records processed by the cursor at one time | Yes | 10000 | You can specify the number of rows to be retrieved at a time by the cursor. |
| Connection timeout (seconds) | Yes | 300 | You can specify the time in seconds until timeout on connection. |
| Socket timeout (seconds) | Yes | 1800 | Socket timeout can be specified in seconds. |