Postgres Database

Integrate Untitled into your existing CDPs, workflows, and business intelligence platforms via our Postgres Database Connector.

This is a feature exclusively for enterprise accounts

Database Connection Overview

Untitled offers a premium feature that grants users access to a managed data warehouse, enabling integration at the data layer. All raw visitor data collected via the Untitled ID tag is exposed through a client-specific Postgres database connection, which can be accessed using the credential set available in your portal.

Follow the step-by-step guide below to test your connection to the Untitled Postgres database using a common method, and refer to the accompanying documentation for schema and table structure details.

SQL Client Connection Instructions

These instructions cover how to connect to the Untitled Postgres database using an open-source SQL client DBeaver. We selected DBeaver for this guide because it’s free and includes a pre-installed Postgres driver.

If you prefer to use a different SQL client, check whether it includes support for Postgres. If not, you may need to install an Postgres driver prior to testing your connection credentials as outlined in this guide.

Locate your Untitled Postgres Database Connection Credentials

1. Log in to your Untitled account.

2. Select "Custom Connections" on the left-side navigation menu.

   1. If you do not see this item on your navigation, please contact your customer success manager or [email protected] to enable it.

3. Your Postgres credentials will be located in the tile component titled "Postgres Warehouse" .

Download & Setup DBeaver (Example SQL Client)

1. DBeaver is a free and open source tool used to interact with various databases. To start, download the version of DBeaver corresponding to your operating system. Once downloaded, continue to the next step.

2. Create a new database connection by selecting the plug icon in the top left corner of your screen. Once clicked a new dialog box will appear. Select Postgres and then click Next.

1. Using the credentials found in the Custom Connections > Postgres Warehouse page of your Untitled account, enter the following information into the DBeaver Postgres Connection Settings.

   1. Host

   2. Port

   3. Database

   4. Username

   5. Password

1. You should now see your connection listed in the Database Navigator and can begin writing SQL to query your tables. To test your setup, enter the following in the SQL editor: SELECT * FROM resolutions.visitors LIMIT 10 Running this query should return the first 10 rows of data, confirming that your connection is working correctly.

Congratulations! You’ve successfully connected to your visitor database using DBeaver. If you have questions about building a replication pipeline from this database, feel free to reach out via the Support Desk—we’re happy to assist with your specific use case.

To review the Postgres Warehouse schema, please proceed to the following knowledge base article.

Manual Export (DBeaver Example)

Once you've successfully connected to the Postgres Database, test the following actions to save your query results locally.

Write and Execute Query

1. Write your SQL Query: Write the SQL query in DBeaver to select the data you want to export from the Untitled Postgres database.

2. Execute the Query: Execute the SQL query to retrieve the results from the Untitled Postgres database.

Export Query Results

1. Select Results to Export from the above query steps.

2. Export Results: Right-click and select the export option. Choose the appropriate format (e.g., CSV, Excel, etc.) and specify the export location.

3. Save Exported File: Save the exported file to the desired location on your local system.

Connecting the Postgres Database to the Looker Business Intelligence Platform

Google publishes a guide for connecting a Postgres database to Looker here: https://docs.cloud.google.com/looker/docs/db-config-postgresql.

Need Further Support or Have Additional Questions?

Check out our FAQs to get some answers, start a chat on our website, or get connected directly with our team here.