This guide shows how to download and install SQL Workbench/J, then connect to the database associated with your DataAccess account. This is a quick and easy way to connect to your database, see the schema, and analyze your data.
SQL Workbench/J is a simple and free SQL query tool that can also connect to many database management systems (DBMS) such as PostgreSQL (what Redshift is based on) or MySQL.
This article covers the following topics:
Alternate guide for connecting using SQL Workbench for Windows.
The driver for Amazon Redshift JDBC must be installed in SQL Workbench before you can connect to the database.
To install the Amazon Redshift JDBC driver:
Now it's time to create a connection profile. This is where you provide SQL Workbench with the connection credentials to your Tealium database.
If successful, you will be taken to the Statement page where you can begin writing scripts to query the data. If you have recently enabled EventDB or AudienceDB, it may take up to an hour for data to become available.
Upon closing SQL Workbench for the first time after successfully creating a new conncetion profile, you will be prompted to save your new connection profile. Be sure to accept.