Google Sheets connection reference

Learn about the fields used to create a Google Sheets connection with ThoughtSpot DataFlow.

Here is a list of the fields for a Google Sheets connection in ThoughtSpot DataFlow. You need specific information to establish a seamless and secure connection.

Connection properties

Connection name

Name your connection.

Mandatory field.

Example

GoogleSheetsConnection

Connection type

Choose the Google Sheets connection type.

Mandatory field.

Example

Google Sheets

Access token

Specify the access token to authenticate Google Sheets.

Mandatory field.

Refresh token

Specify the refresh token to authenticate Google Sheets.

Optional field.

Obtain access token

Select this option to use access key/token to connect to the Google Sheets web-service.

Optional field.

OAuth client ID

Specify the OAuth client ID.

Mandatory field.

Note

Only when you select the "obtain access token" option

OAuth client secret

Specify the OAuth client secret.

Mandatory field.

Note

Only when you select the "obtain access token" option

Callback URL

Secured domain URL of the repo used to register in Google Sheets.

Mandatory field.

Note

Only when you select the "obtain access token" option

Scope

Specify the number of users to access the account.

Mandatory field.

Note

Only when you select the "obtain access token" option

JDBC options

Specify the options associated with the JDBC URL.

Optional field.

Example
jdbc:sqlserver://[serverName[instanceName][:portNumber]]
Note

Advanced configuration

Sync properties

Column delimiter

Specify the column delimiter character.

Mandatory field.

Example

1

Valid values

Any printable ASCII character, or the decimal value for an ASCII character

Default

The delimiter specified in sync

Enclosing character

Specify if the text columns in the source data must be in quotes, and the quote types.

Optional field.

Example

DOUBLE

Valid values

Single, Double

Default

DOUBLE

Note

This is required if the text data has newline character or delimiter character.

Escape character

Specify the escape character if using a text qualifier in the source data.

Optional field.

Example

""

Valid values

Any ASCII character

Default

""

Fetch size

Specify the number of rows to fetch at one time, and process in memory.

If the value specified is 0, then DataFlow extracts all rows at the same time.

Optional field.

Example

1000

Valid values

Any numeric value

Default

1000

Max ignored rows

Abort the transaction after encountering 'n' ignored rows. Optional field.

Example:

0

Valid Values:

Any numeric value

Default:

0

TS load options

Specifies the parameters passed with the tsload command, in addition to the commands already included by the application.

The format for these parameters is:

--<param_1_name><optonal_param_1_value>
--<param_2_name><optonal_param_2_value>

Optional field.

Example
--max_ignored_rows 0
Valid values
--null_value """"
--escape_character """"
--max_ignored_rows 0
Default
--max_ignored_rows 0

Related information