User Guide Getting Started Help Center Documentation Community Training
Connecting Looker to Your Database

To connect Looker to your database (which should have been secured and configured for Looker) select AdminConnectionsNew Connection to start the process:

Enter your database credentials on the connection form. If you need more specifics, you can read more about creating a Looker connection on the Connections page.

Once you’ve entered the credentials, click on Test These Settings to verify the information is correct and the database is able to connect.

Once you verify that the information is correct, click Add Connection. Your database connection is now added to the list on the Connections page.

You can click Test to show messages confirming the database connection as well as additional functionality supported by Looker for your database connection:

If your connection does not pass one or more tests, try some of the troubleshooting steps on the Testing Database Connectivity page.

If you are running Mongo version 3.6 or below on Atlas and you get a communications link failure, see this documentation page.

If you are still having trouble, contact Looker support for assistance.

In order to receive successful connection messages regarding the temp schema and persistent derived tables, you will have needed to allow that functionality when you set up your Looker database. Instructions for doing so are found here.

Next Step

After you have connected your database to Looker you’re ready to configure sign-in options for your users.