Custom Connections

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 Athena 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 Athena database using a common method, and refer to the accompanying documentation for schema and table structure details.

SQL Client Connection Instructions

Locate your Untitled Athena Database Connection Credentials

1. Log in to your Untitled account.

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

3. Your Athena credentials will be located in the tile component titled "Tag Data Warehouse"

Authentication Credentials

In order to authenticate any SQL client, you'll need the following 5 details located within the Custom Connections > Tag Data Warehouse module in your Untitled Account:

• Region: Enter the AWS region provided by Untitled (e.g., us-east-1).

• S3 Staging Directory: Enter the S3 bucket path provided by Untitled (e.g., s3://your-bucket-name/).

• Workgroup: Enter the workgroup name DistilledResolutions

• aws_access_key_id: Your AWS Access Key ID.

• aws_secret_access_key: Your AWS Secret Access Key.

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 Athena and then click Next.

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

1. You must edit the workgroup in order to complete the connection process. To do that, Navigate to Driver properties and scroll to the bottom.

2. Next to Workgroup enter DistilledResolutions and then click Finish

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 Tag Data Warehouse schema, please proceed to the following knowledge base article.

Manual Export (DBeaver Example)

Once you've successfully connected to the Athena 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 Athena database.

2. Execute the Query: Execute the SQL query to retrieve the results from the Untitled Athena 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 Athena Database to the Looker BI Platform

Set Up Looker Connection

1. Log in to your Looker instance.

2. In Looker's main menu, navigate to the Admin section.

3. Click on Connections and then Database to create a new database connection.

4. Choose Amazon Athena as the database dialect.

Configure Looker Connection Settings

1. Provide a Connection Name that identifies the connection (e.g., "Untitled Visitor Database").

2. In Looker’s Host field, copy and paste the following: athena.us-east-1.amazonaws.com

3. Set Looker’s Database field to Athena.

4. Navigate to back to Untitled.

   1. Copy the Access Key ID provided under the Tag Data Warehouse and paste in the Looker Username field.

   2. Copy the Secret Key provided under Tag Data Warehouse and paste in the Looker Password field.

   3. Copy the S3 Location URL provided under Tag Data Warehouse and paste in the Looker Connection String Extras field.

Test the Connection

1. Click the Test button to ensure that Looker can successfully connect to the database.

2. If the test is successful, save the connection settings.

Congratulations! You have successfully connected your Tag Data Warehouse from Untitled to Looker, allowing you to explore and visualize your data through Looker's intuitive interface. Remember to follow best practices for data security and access control when configuring IAM roles and permissions.

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.