summary
Help Page for ETL Configuration of Data Settings from Google Cloud Spanner.
constraints
- BYTES type is not supported.
Setting items
STEP1 Basic settings
| item name | indispensable | default value | Contents |
|---|---|---|---|
| Google Cloud Spanner Connection Configuration | Yes | - | Select the previously registered Connection Configuration that has the necessary permissions for this ETL Configuration. |
| instance ID | Yes | - | Specify the instance ID to be transferred. |
| Database ID | Yes | - | Specify the name of the database to be transferred. |
| 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 that the cursor reasoned at a time | Yes | 10000 | You can specify the number of rows to be retrieved at a time by the cursor. |
| Query execution timeout | Yes | 86400 | Query execution timeout can be specified in seconds. |