Connect Looker to Query Service
This document covers the steps for connecting Looker with Adobe Experience Platform Query Service.
Create a new database connection create-connection
After logging into Looker, select Admin, followed by Connections. The Connections page opens. On the Connections page, select Add Connection.
From here, enter the details for the connection settings listed below. See the official Looker documentation for instructions to create a new database connection and descriptions of the available properties.
- 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. - SSL: Enable SSL to ensure a secure connection across the network.
To find the credentials necessary to connect Looker with Query Service, log in to the Platform UI and select Queries from the left navigation, followed by Credentials. For more information on finding your host, port, database, username, and password credentials, please read the credentials guide.
credential and technicalAccountId values acquired comprise the value for the Looker password parameter.To learn about SSL support for third-party connections in Adobe Experience Platform, see the Query Service SSL documentation. This document provides instructions on how to connect using verify-full SSL mode.
After you have entered your connection details, select Test These Settings to ensure your credentials work properly. More information on testing your connection settings are provided in the official Looker documentation. Upon a successful connection, a message appears on screen to indicate that you can connect. Once your connection is 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.