_Journey
Journey Builder journey versions, status, and dates. BU-scoped to where the journey was created.
Schema last reviewed 2026-06-17
Opens _Journey in the interactive canvas with SQL Sandbox.
Journey Builder journey versions, status, and dates. BU-scoped to where the journey was created.
Schema last reviewed 2026-06-17
Opens _Journey in the interactive canvas with SQL Sandbox.
| Field | Type | Flags | Relations | Description |
|---|---|---|---|---|
VersionID |
Text(36) | PK | — | Journey version GUID. |
JourneyID |
Text(36) | — | — | Root journey GUID across versions. |
JourneyName |
Text(200) | — | — | Journey name. |
VersionNumber |
Number | — | — | Version number. |
CreatedDate |
Date | — | — | Version creation date. |
LastPublishedDate |
Date | NULL | — | Last published date. |
ModifiedDate |
Date | — | — | Last modified date. |
JourneyStatus |
Text(100) | — | — | Running mode: Draft, Running, Finishing, Stopped. |
SELECT TOP 100
VersionID, JourneyID, JourneyName, VersionNumber, CreatedDate, LastPublishedDate
FROM _Journey
WHERE CreatedDate >= DATEADD(day, -30, GETDATE())
ORDER BY CreatedDate DESCValid in Query Studio and Automation Studio Query Activities. GROUP BY is only needed for aggregates; ORDER BY is optional but recommended with TOP so rows are meaningful. Narrow date ranges on large tracking views to avoid timeouts.