Illuminate May 2025 Release

Continuous Delivery | Release to Production 26 May 2025
CDM Changes, Data Dictionary

Our May 2025 release includes:

New canonical data model for Video Studio (CDM_MEDIA)

Video Studio is a Premium Blackboard capability that allows instructors to create accessible and engaging video content for their courses.

Now, Video Studio data is available in Illuminate. Developers can explore Video Studio data in Snowflake to analyze this tool's usage and adoption in their institutions.

We added a new canonical data model for Video Studio (CDM_MEDIA). The canonical data model contains 6 tables:

ACTIVITY: User interactions with videos such as load, playback, pause, and resume, as well as the duration of the action.
CONTAINER: Information about where videos are allocated.
INSTANCE: Video Studio instance, one per Blackboard tenant.
MEDIA: Video information such as duration, size, type, and creation date.
PERSON: User identifier for both owners and viewers of videos.
SESSION_ACTIVITY: Aggregation of all the actions from the ACTIVITY table per user session, giving an overview of the duration played back in each unique session.

Tables and data details are in the data dictionary. We published a Video Studio query in our queries repository in GitHub. You can use this query as a base to start exploring Video Studio data.

This change is retroactive. Historical data for Video Studio is available.

Image 1. A Video Studio query in Snowflake is searching the MEDIA table.