---
title: "Data Source - Google Cloud Spanner"
slug: "data-source-google-cloud-spanner"
updated: 2024-10-07T05:27:48Z
published: 2024-10-07T05:27:48Z
canonical: "documents.trocco.io/data-source-google-cloud-spanner"
---

> ## 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 - Google Cloud Spanner

## 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](/docs/connection-configuration-google-cloud-spanner) 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](/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 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. |