The Lytho Data Warehouse exposes your data as views in the LYTHO_WAREHOUSE.CUSTOMER schema. Each view is flat and reads like a report, so you rarely need more than one. This page lists every view and how to connect them. Column-level detail for each view is in the Lytho Data Warehouse Guide.
Rules that apply to every view
- Views show the current state of each record, not history.
- Durations are in seconds. Date and time columns are
TIMESTAMP_NTZ. - You can only see your own organization's rows.
- Lytho Workflow views update in real time. Lytho DAM views refresh nightly.
Lytho Workflow views
|
View |
One row per |
Join on |
|---|---|---|
|
|
Campaign |
|
|
|
Project |
|
|
|
Project |
|
|
|
Work request |
|
|
|
Task |
|
|
|
Proof |
|
|
|
Reviewer decision |
|
|
|
Time entry |
|
|
|
Task or proof |
|
Lytho DAM views
|
View |
One row per |
Join on |
|---|---|---|
|
|
Asset |
|
|
|
File (version or rendition of an asset) |
|
|
|
Collection |
|
|
|
Publication |
|
|
|
Style guide |
|
|
|
Tag in the taxonomy |
|
|
|
Asset activity event |
|
|
|
Batch download |
|
|
|
User |
|
|
|
Storage summary |
|
|
|
Summary of asset activity |
|
|
|
Summary of asset growth |
|
|
|
Summary of batch downloads |
|
|
|
Summary of publication distribution |