Google Spanner Connections

Note

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 https://cloud.google.com/spanner.

Tip

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.

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	Description
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.
Database	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: Timeout=0; 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 Inference	Leave this value as `Enabled`.

For more information, see the driver documentation https://cdn.cdata.com/help/OGG/jdbc/default.htm.

Data Type Conversions