The goal of this document is to teach you how to create SQL queries for either EventDB and/or AudienceDB using the program SQL Workbench/J.
You've created your connection profile for SQL Workbench/J and are ready to start querying data, but aren't really sure where to start, what your data columns are named, or what the Table and List schema represent. This document will help guide you in the right direction.
This tab is where you write SQL statements, view your results, or view any error messages.
The Database Explorer is an excellent tool to review for understanding what data is available.
First, the left panel states the Tables and Views accessible within your Redshift instance.
A table is a standard method of storing data in a Database. Any "NAME" not ending with "_view" is considered a table. The number of tables depends on the number of filtered streams that have been enabled for EventDB and if AudienceDB is enabled.
For each table there is a correspnding view. A view is provided for a more human-readable representation of the table's columns. Examples:
In regard to EventDB
In regard to AudienceDB:
Note, list and tally attributes are stored in their respective tables, whereas funnels and timelines are not yet supported.
Second, each table or view contains different pieces of data. In order to build your query in the Statement tab correctly, you need to know the data column names that are available to be queried, example udo_job_role. The right pane will help you navigate those data column names and build your queries.
Objects>Columns will provide the column names for each table or view.
By default, the COLUMN_NAME is not in alphapetical order. Click the header row to sort the names alphabetically.
Objects>Data will pull a random sample of data.
A data scientist or database administrator can help guide you in the right direction for querying this data. If there are any other questions please contact your Account Manager. However, please know that beyond connection and data schema support, there will be limited support that Tealium will provide. Anything regarding querying support, data export, integration into BI tools, and more will need to be handled by your internal team or an agency.