This document describes how to create SQL queries for EventDB and/or AudienceDB using the program SQL Workbench/J.
In this Article
After you create your connection profile for SQL Workbench/J, you are ready to start querying data. Follow this document to get started. First, learn your data column names and what your tables and list schema represent.
For additional questions regarding connection and data schema support, contact your Account Manager. If you need additional help regarding query support, data export, or integration into Business Intelligence (BI) tools, reach out to a member of your team, such as a data scientist or database administrator to guide you in the right direction.
The following sections provide general information about the most commonly used screens in the SQL Workbench/J interface.
From the SQL Workbench/J interface, click the Statements tab to write SQL statements and view results or error messages.
From the SQL Workbench/J interface, go to Database Explorer to review and understand the your available data.
The left panel displays the tables and views that are accessible within your Redshift instance. Each table or view contains different pieces of data. In order to build your query in the Statement tab correctly, you must know the data column names that are available to be queried, such as
udo_job_role. The right pane helps you navigate the data column names and build your queries.
_vieware considered tables. The number of tables depends on the number of filtered streams enabled for EventDB and AudienceDB (if enabled).
tags_main_1_executedwhereas a view displays
event - tags - tealium collect (main 1) - executed
udo_job_rolewhereas a view displays
event - udo - job_role
events__all_eventstable holds all events by default
visit_listscontains the current visit-scoped list attributes for querying
visit_talliescontains the current visit-scoped tally attributes for querying
visitor_listscontains the visitor-scoped list attributes for querying
visitor_talliescontains the visitor-scoped tally attributes for querying
visitor_replacescontains visitor profiles that have been stitched
visitorsis the most commonly-used table and contains the latest visitor-scoped data for each visitor and any audiences that they belong to
visitscontains the latest current visitor-scoped data for each visitor
Click the Objects tab to view the column names for each table or view. You can use the available filters in the interface to fine-tune your results. By default,
COLUMN_NAME is not in alphabetical order. Click the header row to sort the names alphabetically.
Click the Search table data tab to view random samples of data. You can use the available filters in the interface to fine-tune your results.
The following items are noted as common errors to avoid:
utag_datain your iQ Tag Management (TiQ) data layer. If the variables are not declared, they will not display in EventDB.