Connect Looker to Query Service

This document covers the steps for connecting Looker with Adobe Experience Platform Query Service.

NOTE

This guide assumes you already have access to Looker and are familiar with how to navigate its interface. More information about Looker can be found in the official Looker documentation.

After logging into Looker, select Admin, followed by Connections.

On this page, select New Connection.

From here, you can fill out the details for the connection settings.

  • Name: The name of your connection.
  • Dialect: The dialect used for the SQL database. Query Service uses PostgreSQL.
  • Host and Port: The host endpoint and its port for Query Service.
  • Database: The database that will be used.
  • Username and Password: The login credentials that will be used. The username will be in the form of ORG_ID@AdobeOrg.
NOTE

For more information on finding your host and port, database name, and login credentials, visit the credentials page on Platform. To find your credentials, log in to Platform, then select Queries, followed by Credentials.

After inputting your connection details, select Test These Settings to ensure your credentials work properly. If they do, a message indicating that you can connect will appear below. If your connection is indeed successful, select Add Connection to create your connection.

Next steps

Now that you’ve connected with Query Service, you can use Looker to write queries. For more information on how to write and run queries, please read the running queries guide.

On this page