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 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 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. |