To connect Looker to a PostgreSQL database, you must configure your database. This document explains how to set up user accounts, grant required permissions, and define schema and connection parameters. For information about PostgreSQL on Heroku or Cloud SQL for PostgreSQL, see their documentation.
Dialects that use these instructions
The following dialects share database setup requirements as described on this page:
- PostgreSQL
- Microsoft Azure PostgreSQL
- Amazon Aurora PostgreSQL
- Amazon RDS for PostgreSQL
For Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL, Looker includes integration support.
For PostgreSQL on Heroku, see the Heroku documentation.
For Google Cloud SQL for PostgreSQL, see our dedicated Google Cloud SQL for PostgreSQL page.
Encrypting network traffic
It is a best practice to encrypt network traffic between the Looker application and your database. Consider one of the options that are described on the Enabling secure database access documentation page.
If you're interested in using SSL encryption, see the PostgreSQL documentation.
Users and security
To perform actions on your database, Looker needs to have a user account on your database.
To configure a database user for Looker to use, perform the following steps on your database:
Create a database user and password.
CREATE USER