This document covers the steps for connecting Looker with Adobe Experience Platform Query Service.
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. 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.
ORG_ID@AdobeOrg
.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.
Query Service also offers non-expiring credentials to allow for a one-time setup with third-party clients. See the documentation for full instructions on how to generate and use non-expiring credentials. It is necessary to complete this process if you wish to connect Looker as a one-time setup. The 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.
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.