# Google Spanner

<!-- BEGIN GENERATED:intro -->

The Google Spanner connector is a [Palantir-provided driver](../../data-integration/foundry-provided-drivers/index.md) for Google Spanner.

To create a new Google Spanner source, follow the [standard setup flow for Palantir-provided drivers](../../data-integration/foundry-provided-drivers/index.md#setup), then use the sections below for Google Spanner-specific configuration and networking. For the complete property reference, see the [official Google Spanner driver documentation ↗](https://cdn.cdata.com/help/OGK/jdbc/pg_connectionj.htm).

<!-- END GENERATED:intro -->

<!-- BEGIN GENERATED:capabilities -->

:::callout{theme="neutral" title="Beta"}
The Google Spanner connector is in the [beta](../../platform-overview/development-life-cycle/index.md) phase of development and may not be available on your enrollment. Functionality may change during active development.
:::

## Supported capabilities

| Capability | Status |
|---|---|
| Exploration | 🟡 Beta |
| Batch syncs | 🟡 Beta |
| Incremental | 🟡 Beta |
| [OAuth 2.0 authentication](#oauth-20-authentication) | 🟡 Beta |
| [Table exports](#table-exports) | 🟡 Beta |

<!-- END GENERATED:capabilities -->

<!-- BEGIN GENERATED:configuration -->

## Configuration

The properties below are mandatory or recommended.

| Property | Required? | Description | Default |
|---|---|---|---|
| [`DatabaseDialect` ↗](https://cdn.cdata.com/help/OGK/jdbc/RSBGoogleSpanner_p_DatabaseDialect.htm) | Mandatory | The dialect type of the connected database. | `GoogleStandardSQL` |
| [`AuthScheme` ↗](https://cdn.cdata.com/help/OGK/jdbc/RSBGoogleSpanner_p_AuthScheme.htm) | Recommended | The type of authentication to use when connecting to Google Spanner. | `OAuthJWT` |
| [`Database` ↗](https://cdn.cdata.com/help/OGK/jdbc/RSBGoogleSpanner_p_Database.htm) | Recommended | The name of the Google Spanner database to connect to. | — |
| [`InitiateOAuth` ↗](https://cdn.cdata.com/help/OGK/jdbc/RSBGoogleSpanner_p_InitiateOAuth.htm) | Recommended | Specifies the process for obtaining or refreshing the OAuth access token, which maintains user access while an authenticated, authorized user is working. | `GETANDREFRESH` |
| [`InstanceId` ↗](https://cdn.cdata.com/help/OGK/jdbc/RSBGoogleSpanner_p_InstanceId.htm) | Recommended | The id of the Google Spanner instance to which you are connecting. | — |
| [`OAuthClientId` ↗](https://cdn.cdata.com/help/OGK/jdbc/RSBGoogleSpanner_p_OAuthClientId.htm) | Recommended | Specifies the client Id that was assigned when the custom OAuth application was created. (Also known as the consumer key.) This ID registers the custom application with the OAuth authorization server. | — |
| [`OAuthClientSecret` ↗](https://cdn.cdata.com/help/OGK/jdbc/RSBGoogleSpanner_p_OAuthClientSecret.htm) | Recommended | Specifies the client secret that was assigned when the custom OAuth application was created. (Also known as the consumer secret). This secret registers the custom application with the OAuth authorization server. | — |
| [`OAuthJWTCert` ↗](https://cdn.cdata.com/help/OGK/jdbc/RSBGoogleSpanner_p_OAuthJWTCert.htm) | Recommended | The JWT Certificate store. | — |
| [`OAuthJWTCertType` ↗](https://cdn.cdata.com/help/OGK/jdbc/RSBGoogleSpanner_p_OAuthJWTCertType.htm) | Recommended | The type of key store containing the JWT Certificate. | `GOOGLEJSONBLOB` |
| [`OAuthJWTSubject` ↗](https://cdn.cdata.com/help/OGK/jdbc/RSBGoogleSpanner_p_OAuthJWTSubject.htm) | Recommended | The user subject for which the application is requesting delegated access. | — |
| [`ProjectId` ↗](https://cdn.cdata.com/help/OGK/jdbc/RSBGoogleSpanner_p_ProjectId.htm) | Recommended | The id of the project where your Google Spanner instance resides. | — |

<!-- END GENERATED:configuration -->

<!-- BEGIN GENERATED:networking -->

## Networking

The table below lists the domains that the source must be able to access to run.

For each domain, add a corresponding [egress policy](../../administration/configure-egress/index.md). If the source is hosted on-premises and not directly reachable from Foundry, use an [agent proxy egress policy](../../administration/configure-egress/index.md#agent-proxy-egress-policies) instead. The agent host itself must also be able to reach the listed domains. See [using an agent as a proxy](../../data-connection/agent-proxy/index.md) for details.

| Domain  | Required |
|--- |--- |
| accounts.google.com | Always. Required for OAuth |
| spanner.googleapis.com | Always. There is a hidden property Server that can override this with a different URL. |
| googleapis.com | Always |

<!-- END GENERATED:networking -->

<!-- BEGIN GENERATED:oauth -->

## OAuth 2.0 authentication

This connector supports OAuth 2.0 authentication. Follow the [OAuth 2.0 guidance for Palantir-provided drivers](../../data-integration/foundry-provided-drivers/index.md#oauth-20-authentication) to configure and authorize the connection.

<!-- END GENERATED:oauth -->

<!-- BEGIN GENERATED:table-exports -->

## Table exports

This connector supports table exports. Learn how to [set up a table export](../../data-connection/export-overview/index.md#table-exports).

<!-- END GENERATED:table-exports -->