Page tree




Feature Availability: This feature may not be available in all product editions. For more information on available features, see Compare Editions.

Google Spanner is a fully managed relational database service that offers transactional consistency at global scale, schemas, and synchronous replication for high availability. For more information, see

Early Preview connection: This connection is in early preview. It is read-only and available only in SaaS product editions. For more information on early previews, see Early Preview Connection Types.

Limitations and Requirements

NOTE: Creation of imported datasets with custom SQL is not supported.

NOTE: This connection type does not support connections to database instances that were built with PostgreSQL dialect.

  • OAuth 2.0 authentication is required. 

    • An OAuth 2.0 web client is created for you in the  Dataprep by Trifacta application .

    • You cannot create OAuth 2.0 connections via API.
  • You can view all tables under all the databases (irrespective of the database name you have provided) while creating the connection.

Create Connection

via  Dataprep by Trifacta application

When you create the connection, please review the following properties and specify them accordingly:

Connection PropertyDescription
Project ID

The ID of the project where your  Google Spanner instance resides.

Instance ID

The ID of the  Google Spanner instance to which you are connecting.


The name of the  Google Spanner database.

Connect String Options

The following default value sets the connection timeout in seconds:


Setting this value to 0 disables timeouts.

OAuth2 Client

The client is displayed.

NOTE: When you create the connection in this window, you must click Authenticate, which authenticates to the app. This step is required.

Default Column Data Type InferenceLeave this value as Enabled.

For more information, see the driver documentation

Data Type Conversions

For more information, see the driver documentation

See Also for Google Spanner Connections:

There is no content with the specified labels

This page has no comments.