home User Guide Getting Started Help Center Documentation Community Training Certification
Looker keyboard_arrow_down
language keyboard_arrow_down
Looker documentation will be moving to cloud.google.com in mid-2022!
All the information you rely on will be migrated and all docs.looker.com URLs will be redirected to the appropriate page.

Database configuration

Before 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.

The following is an example of creating a user and schema for Looker:

CREATE USER looker Identified BY 'mypassword'; CREATE SCHEMA looker_scratch; GRANT CREATE ON SCHEMA looker_scratch to looker;

Creating a connection to Vertica

In Looker, configure a database connection via the interface. From the Admin section, select Connections, and then select New Connection. See the Connecting Looker to your database documentation page for more information.

Enter the connection information in the required fields:

Click on Test These Settings to verify the connection to Vertica is successful. The Testing database connectivity documentation page has troubleshooting information.

Click Update Connection to save the connection.

Feature support

For Looker to support some features, your database dialect must also support them. In Looker 22.10, Vertica supports the following Looker features:

Next steps

After you have completed the database connection, configure authentication options.