Data Source - Snowflake
- 07 Dec 2022
- Print
- DarkLight
- PDF
Data Source - Snowflake
- Updated on 07 Dec 2022
- Print
- DarkLight
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
This is a machine-translated version of the original Japanese article.
Please understand that some of the information contained on this page may be inaccurate.
summary
This is the help page for configuring data transfer from Snowflake.
Supported Protocols
- Data Transfer (Embulk)
constraint
- BINARY type is not supported.
- We are confirming the transfer of CSV data for 10 GB.
Setting items
STEP1 Basic settings
| Item | namerequireddefault | valuecontent | |
|---|---|---|---|
| Snowflake connection information | Yes | - | From the connection information registered in advance, select the one that has the necessary permissions for this transfer setting. |
| Database name | Yes | - | Specify the database name of the data you want to transfer. |
| schema | Yes | public | Specify the schema of the data you want to transfer. |
| Warehouse name | Yes | - | Specify the warehouse name of the data you want to transfer. |
| query | Yes | - | Enter a query to retrieve the transferred data from Snowflake. Custom variables can also be used to dynamically determine the setting value during trocco data transfer. |
| The number of records that the cursor processes at one time | Yes | 10000 | You can specify the number of rows to retrieve at one time with the cursor. |
| Connection Timeout (seconds) | Yes | 300 | You can specify the amount of time, in seconds, before the connection timeout. |
| Socket Timeout (seconds) | Yes | 1800 | You can specify the socket timeout in seconds. |
Was this article helpful?