Contents:
Contents:
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 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. |
| Connect String Options | The following default value sets the connection timeout in seconds: Timeout=0; Setting this value to |
| 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
For more information, see the driver documentation https://cdn.cdata.com/help/OGG/jdbc/default.htm.
This page has no comments.