Skip to main content

Google Spanner Connections


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

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


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


Creation of imported datasets with custom SQL is not supported.

  • OAuth 2.0 authentication is required.

    • An OAuth 2.0 web client is created for you in the 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 Property


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.

Database Dialect

Select the required dialect to connect to the database instance:

  • GoogleStandardSQL

  • PostgresSQL

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.


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 Inference

Leave this value as Enabled.

For more information, see the driver documentation

Data Type Conversions

For more information, see the driver documentation