Connect Postico to Query Service (Mac)
This document covers the steps for connecting Postico with Adobe Experience Platform Query Service.
To connect Postico to Query Service, open Postico and select New Favorite. The dialog for connection settings appears. From here, you can enter parameter values to connect with Adobe Experience Platform. Enter the connection settings listed below. Instructions on how to connect to a PostgreSQL server with Postico are also available from the official Postico website.
technicalAccountID
and the credential
downloaded in the configuration JSON file. The password value takes the form: {technicalAccountId}:{credential}. The configuration JSON file for non-expiring credentials is a one-time download during their initialization that Adobe does not keep a copy of.prod:all
.For more information on finding your database name, host, port, and login credentials, please read the credentials guide. To find your credentials, log in to Platform, then select Queries, followed by Credentials.
After inserting your credentials, select Connect to connect with Query Service.
After connecting to Platform, you’ll be able to see a list of all the relations previously made with Query Service.
Create SQL statements
To create a new SQL query, select SQL Query from the sidebar. Alternatively, use the keyboard shortcut (⇧⌘T) to navigate to the query view and enter the query you want to execute. When finished, select Execute Statement to run the query. A table appears with the results of your completed query run.
See the official Postico documentation for more information on using the query view.
Next steps
Now that you’ve connected with Query Service, you can use Postico to write queries. For more information on how to write and run queries, please read the running queries guide.