[[["易于理解","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-18。"],[],[],null,["# Vertica\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\nDatabase configuration\n----------------------\n\nBefore you create a connection to Vertica, create a new database user and schema that is exclusive for your Looker applications. The Looker user needs read and write permissions into a separate schema to store PDTs and read-only privileges to other schemas in the Vertica database. This is optional but recommended.\n\nThe following is an example of creating a user and schema for Looker: \n\n CREATE USER looker Identified BY 'mypassword';\n CREATE SCHEMA looker_scratch;\n GRANT CREATE ON SCHEMA looker_scratch to looker;\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- **Name**: Give a name to the connection. This is how the LookML model will reference the connection.\n- **Dialect** : Select **Vertica** from the drop-down of dialects.\n- **Host**: Enter the Vertica server name or IP.\n- **Port**: The default is 5433.\n- **Database**: Enter Vertica's database name.\n- **Username and Password**: Enter the username and password of the user that will connect to Looker.\n- **Schema**: Enter the schema that contains the tables that you want to explore in Looker.\n- **Temp Database**: This is the scratch schema where you want Looker to create any temporal derived tables to improve performance. It is optional but recommended, and should be created beforehand.\n- **Max connections per node** : 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**: This is optional. Use the default value.\n- **Database Time Zone**: The time zone your Vertica database uses to store dates and times. For example, UTC. This is optional.\n- **Query Time Zone**: The time zone you want your queries to display. For example, US Eastern (America -- New York). This is optional.\n- **Additional JDBC parameters** : This is optional. Use this field to enable additional database settings. For example, to enable Vertica's native load balancing, use the JDBC connection parameter `ConnectionLoadBalance=1`. To assign a label to identify Looker's sessions, use the JDBC connection parameter `Label=\u003cmylabel\u003e`. You can pass several parameters one after the other using `&`, as shown on this page. For a complete list of available JDBC connection parameters, see [Vertica's documentation](https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/ConnectingToVertica/ClientJDBC/JDBCConnectionProperties.htm).\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\nVertica supports the following features as of Looker 25.14:\n\nNext steps\n----------\n\nAfter you have completed the database connection, [configure authentication options](/looker/docs/getting-started-with-users)."]]
