[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["很难理解","hardToUnderstand","thumb-down"],["信息或示例代码不正确","incorrectInformationOrSampleCode","thumb-down"],["没有我需要的信息/示例","missingTheInformationSamplesINeed","thumb-down"],["翻译问题","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["最后更新时间 (UTC)：2025-08-25。"],[],[],null,["# Google Spanner\n\nThis page explains how to set up a connection in Looker to Google Spanner.\n\nEncrypting network traffic\n--------------------------\n\nIt is a best practice to encrypt network traffic between the Looker application and your database. Consider one of the options described on the [Enabling secure database access](/looker/docs/enabling-secure-db-access) documentation page.\n\nGetting the connection credentials\n----------------------------------\n\n1. Log in to the [Google Cloud console](https://console.cloud.google.com/).\n\n2. Select the appropriate project.\n\n3. From the menu, select **IAM \\& Admin** and then **Service accounts**.\n\n4. Select **Create service account** and fill in the dialog box as follows:\n\n - **Service account name** : Enter `looker-spanner-service` or something similar.\n - **Role** : Select **Cloud Spanner** and then **Cloud Spanner Database Reader**.\n - **Furnish a new private key** : Select the **Furnish a new private key** checkbox, and select **JSON** under **Key type**.\n\n5. Click **Create** and keep track of the following:\n\n - The email address associated with the service account\n - The name and location of the JSON credential file that was downloaded\n\nCreating the Looker connection to your database\n-----------------------------------------------\n\nIn the **Admin** section of Looker, select **Connections** , and then click **Add Connection**.\n\nFill out the connection details. The majority of the settings are common to most database dialects. See the [Connecting Looker to your database](/looker/docs/connecting-to-your-db) documentation page for information. Some of the settings are described next:\n\n- **Dialect** : **Google Spanner**.\n- **Name**: The name of the connection.\n- **Project Name**: The project ID for the Google project that contains the Spanner database.\n- **Instance Name**: The name of the instance that contains the Spanner database.\n- **Database**: The name of the Spanner database.\n- **Schema**: Leave this blank.\n- **Max connections per node** : The maximum number of total connections to the Spanner database across all users. The default is 30. This setting can be left at the default value initially. See the [Connecting Looker to your database](/looker/docs/connecting-to-your-db#max_connections) documentation page for more information.\n- **Connection Pool Timeout**: The number of seconds a query will wait before timing out because of a full connection pool.\n- **Additional JDBC parameters**: Any additional JDBC driver parameters.\n\nTo verify that the connection is successful, click **Test** . See the [Testing database connectivity](/looker/docs/testing-db-connectivity) documentation page for troubleshooting information.\n\nTo save these settings, click **Connect**.\n\nFeature support\n---------------\n\nFor Looker to support some features, your database dialect must also support them.\n\nGoogle Spanner supports the following features as of Looker 25.14:\n\nReferences\n----------\n\n- [Documented Spanner limits](/spanner/docs/limits)\n\n- [Google Spanner IAM documentation](/spanner/docs/iam)\n\nNext steps\n----------\n\nAfter you have connected your database to Looker, [configure sign-in options for your users](/looker/docs/getting-started-with-users)."]]
