PowerExchange for Google Cloud Spanner User Guide

Back Next

Advanced Properties

The Data Integration Service reads data from Google Cloud Spanner based on the data object read operation.

The Developer tool displays advanced properties for the Google Cloud Spanner data object operation in the Advanced view.

The following table describes the advanced properties for a Google Cloud Spanner data object read operation:

Property	Description
Index Directive	Specify the index directive in an SQL statement to indicate the index name to query a table. To specify a index directive, use the following syntax: FROM TableName@{FORCE_INDEX=TableIndex} For more information about index directive, click the following URL: https://cloud.google.com/spanner/docs/secondary-indexes
Batch Size	Minimum number of rows that PowerExchange for Google Cloud Spanner reads in a batch. Enter a number greater than 0. Default is 100.
Source Database	Optional. Overrides the Google Cloud Spanner database name specified in the Google Cloud Spanner data object read operation.
Source Table	Overrides the Google Cloud Spanner table name specified in the Google Cloud Spanner data object read operation.
EnableBulkRead	Reads data from large Google Cloud Spanner tables.