Changelog

In this section, we track updates and changes to the data model.

September 18, 2026

Data Connector 2.0 now includes CPE skill verifications in dim_certification and fact_certification_events. Continuing Professional Education (CPE) credits allow professionals (such as CPAs) to maintain their licenses and certifications through approved learning activities. You can explore available qualifying courses and programs on the DataCamp CPE page (requires login).

The dim_certification table includes two new fields:

• course_id — The course associated with the CPE skill verification.

• cpe_credits — The number of credits associated with the CPE skill verification.

The fact_certification_events table includes four new events and four new fields:

• Events: skill_verification_started, skill_verification_completed, skill_verification_granted, and skill_verification_failed.

• Fields: cpe_exam_reported_score, is_cpe_course_completed, cpe_course_completed_at, and cpe_credits_obtained.

These additions are separate from ordinary Certification reporting. Existing Certification metrics and the group_detail Certification fields are unchanged.

September 11, 2026

Added discloser_id to fact_ai_insights_disclosures, a masked version of user_id to provide a unique primary key in the table and enable aggregated user counting.

September 03, 2026

The user_id column has been removed from fact_ai_insights_disclosures.

This is a breaking schema change. Queries that select or join on user_id from this table will fail after the next export.

July 31, 2026

A new fact_ai_insights_disclosures fact table has been added to Data Connector 2.0. It contains non-sensitive topics and AI-tool mentions during AI Tutor conversations.

Use this table to analyze the topics and tools learners mention while using AI Tutor. Each row retains the first disclosure at the documented topic or tool grain while the learner was part of the group.

July 20, 2026

A new ai_tutor_credit_usage_detail metric table has been added to Data Connector 2.0. This table contains each learner's AI Tutor credit usage, remaining credits, effective user limit, limit source, and current reset window.

Use this table to monitor AI Tutor credit consumption per user and identify users who have exceeded their current AI Tutor credit limit.

July 09, 2026

A new nullable last_login_at timestamp has been added to the dim_user table. It contains the user's most recent DataCamp login time when available.

This field represents login recency and should not be used as a proxy for learning activity.

July 06, 2026

The dim_date table has been expanded with additional calendar fields, including week, month, quarter, half-year, and year attributes, period start and end dates, weekday and weekend flags, US holiday identifiers, and business-day indicators.

This is an additive schema change: existing dim_date fields remain available.

June 23, 2026

We've renamed the two course variants in the data model to match the rest of DataCamp: Classic is now Datacamp, and AI Native is now AI Tutor. This changes column names and the course_variant_name value, and is a breaking change for queries that reference the old names.

Renamed columns

• dim_content.has_variant_classic → has_variant_datacamp

• dim_content.has_variant_ai_native → has_variant_ai_tutor

• group_detail.ai_native_hours_on_learn → ai_tutor_hours_on_learn

• group_detail.ai_native_hours_on_courses → ai_tutor_hours_on_courses

• group_detail.ai_native_xp_earned → ai_tutor_xp_earned

• group_detail.ai_native_courses_started → ai_tutor_courses_started

• group_detail.ai_native_courses_completed → ai_tutor_courses_completed

Changed value

• dim_course_variant.course_variant_name now returns datacamp instead of classic, and ai-tutor instead of ai-native.

Action required

• Queries that select the renamed columns will error until they are updated to the new names.

• Queries that filter on course_variant_name (e.g. WHERE course_variant_name = 'ai-native') will return zero rows, with no error. Update the value, or filter on the numeric course_variant_id instead — it is unchanged (1 = datacamp, 2 = ai-tutor).

June 18, 2026

A new column, required_for_completion, has been added to the bridge_track_content table. It indicates whether a content item is required (true) or optional (false) for a learner to complete the track. Use this column to exclude optional content items and measure track progress more precisely.

May 21, 2026

A new column, track_description, has been added to the dim_track table. It surfaces the long-form description an admin enters when creating or editing a custom track, and the public-catalog description for non-custom tracks. The existing track_short_description column remains unchanged, populated only for DataCamp catalog tracks.

May 07, 2026

Four new event names have been added to the fact_certification_events table:

• certification_project_registered

• certification_project_failed,

• certification_project_expired,

• certification_skill_assessment_registered

and certification_case_study_registered coverage has been extended to every started case-study attempt.

Together these provide a complete registered → outcome funnel per attempt across all three component families (project, skill assessment, case study).

April 09, 2026

Five new columns have been added to the group_detail metric table to surface activity on AI-native course variants:

• ai_native_hours_on_learn — Time spent on AI-native variant content

• ai_native_hours_on_courses — Time spent on AI-native course variant courses

• ai_native_xp_earned — XP earned from AI-native course variant content

• ai_native_courses_started — AI-native course variant courses initiated

• ai_native_courses_completed — AI-native course variant courses finished

These columns are subsets of the existing totals — they are already included in the corresponding total_* and nb_* columns. To isolate classic-only activity, subtract the AI-native value from the total.

March 30, 2026

Two new columns, Courses (Classic) and Courses (AI Native), have been added to the Time in Learn export. These columns represent the time a learner spent in each variant.

March 27, 2026

Two new columns, Courses (Classic) and Courses (AI Native), have been added to the Time in Learn report. These columns represent the time a learner spent in each variant.

March 25, 2026

We've introduced the concept of course variants to support our new AI-native course format. A course can now exist as a classic variant (the traditional DataCamp course experience) or an AI-native variant (a new interactive learning format powered by AI). Both variants share the same course identity (course_id / content_id) and all common metadata.

New table

• dim_course_variant — A new dimension table containing variant-specific information such as the variant name, description, and duration details. See Dimension tables for the full schema.

New columns

• course_variant_id added to dim_content — Identifies the course variant for course and chapter content rows. 1 = classic, 2 = AI-native.

• course_variant_id added to fact_learn_events — Identifies which course variant a learning event is associated with. Populated for course and chapter events.

Schema changes

• Breaking change: chapter_id in dim_content has changed from integer to string. If your queries cast chapter_id to an integer or use integer comparisons, they will need to be updated.

New content records

• AI-native courses introduce new chapter-level records in dim_content. These AI-native chapters have their own content_id and chapter_id values. If you aggregate at the chapter level, be aware that you will now see both classic and AI-native chapters unless you filter by course_variant_id.\

Impact on existing queries

• Course completion queries: A user can now complete both the classic and AI-native variant of the same course. If you count course completions, consider whether you want to count per variant or per course. Use course_variant_id to differentiate.

• Chapter-level queries: New AI-native chapters will appear alongside classic chapters. Filter by course_variant_id if you need to isolate one variant.

• Queries using chapter_id: Update any logic that treats chapter_id as an integer.

See Domain Gotchas for detailed guidance.

February 2, 2026

We've expanded the possible values of assessment_knowledge_level in fact_learn_events from 3 to 5 levels:

• Novice (0-69)

• Lower Intermediate (70-100)

• Upper Intermediate (101-130)

• Lower Advanced (131-160)

• Upper Advanced (161-200)

January 15, 2026

We've added a new assignment_unassigned event to fact_learn_events to better track the user–assignment lifecycle.

This event is triggered when an Admin deletes an assignment after creating it.

December 15, 2025

We've updated the Data Connector model to capture the new XP awarded for certification and skill assessment completions.

• Certifications (certification_granted event in fact_certification_events)

  • Career Certification pass: 10,000 XP

  • Fundamentals Certification pass: 2,000 XP

• Skill Assessments (assessment_engaged event in fact_learn_events)

  • Assessment completion: 100 XP

    • Note: this award is given for every completion (no per-user limit).

  • Score > 50th percentile: 500 XP

  • Score > 75th percentile: 1,000 XP

Each XP award can only be earned once per user per certification and assessment, unless otherwise noted.

• The group_detail metric table has been extended to include the new XP events and:

  • certification_started

  • certification_completed

• We have added URL fields to key dimension tables so you can link directly to content from your reports and dashboards:

  • dim_content – now includes a URL link to the content item

  • dim_track – now includes a URL link to the track

  • dim_certification – now includes a URL link to the certification

December 2, 2025

We've expanded the dim_content table to better represent non-course learning resources and competitions.

What's new

• New resource types added to dim_content: Free online resources are now included as content (code-alongs, cheat sheets, case studies, data sheets, ebooks, infographics, podcasts, tools, webinars, whitepapers)

• New is_resource flag: A new Boolean column is_resource has been added to dim_content to distinguish these resources from other content types (e.g., courses, tracks, assessments).

• Competitions in dim_content: Competitions are now also represented in the dim_content table as a dedicated content type, allowing you to report on and filter them alongside other learning assets.

October 2, 2025

We've released the DataCamp Data Connector 2.0 Power BI Template — a plug-and-play dashboard that lets you go from connection to insights in minutes.

• What's included: Pre-built pages for Snapshot, Engagement, Progress, and Leaderboard, wired to the Data Connector 2.0 model for consistent KPIs and analysis.

• Where to get it: Group Hub → Reporting → Data Connector. Download the .pbit file and open it in Power BI Desktop.

• Setup highlights: Create an Athena ODBC DSN on Windows and connect via the built-in Amazon Athena connector in Power BI. See our Microsoft Power BI guide for step-by-step DSN fields and connection prompts. enterprise-docs.datacamp.com

Download the template now to turn your Data Connector 2.0 data into insights in minutes, unlock richer analyses and faster decisions with zero modeling needed.

September 17, 2025

We've updated the data model to capture license and invite interactions. The fact_permission_event table now records these events (e.g., user_license_allocated, user_license_revoked, invite_sent, invite_claimed, invite_withdrawn). This enables company-level analysis of DataCamp adoption.

August 21, 2025

We've fixed an issue in the data model by removing course_engagement events with content_id = ex0. These events did not represent exercise-level engagement and are no longer included, ensuring that engagement metrics remain consistent and exercise-granular.

August 20, 2025

We've enhanced the data model to include course difficulty levels. A new field, course_difficulty_level, has been added to the dim_content table.

August 19, 2025

We've updated the data model to support the source of the DataLab workbook. The fact_datalab_events table now includes the workbook_source and workbook_class fields.

The workbook_source field contains the source of the workbook, with the following possible values: project, certification, competition, course, or other.

When a workbook source includes one of the following values — project, certification, competition, or course, it is marked as embedded.

July 10, 2025

A new dim_assignment table has been added to the data model to support assignment-level analysis and reporting. Additionally, four assignment-related events—assignment_assigned, assignment_completed, assignment_completed_late, and assignment_missed—have been integrated into the fact_learn_events table.

July 2, 2025

Courses in dim_content can now contain decimal values for time_duration_in_hours. This change is meant to support upcoming courses that are expected to take less than one hour to complete.

June 5, 2025

We've updated the data model to support custom assessments. The dim_content table now includes a new boolean field: assessment_is_custom. This field indicates whether an assessment is custom (true) or standard (false).

If your group uses custom assessments, you'll now see corresponding rows reflected in this table.

We have also added a last_sso_nameid column to the bridge_user_group table. This field contains the last SSO NameID of the user in the group. Some groups that authenticate with SSO use this field to include custom identification data for their users.

May 28, 2025

We've updated the underlying data in the data model (note: this is not a schema change) to improve the accuracy of engagement metrics:

• Filtered course activity: We now exclude course_engagement events associated with courses that are not in one of the three expected states: Live, Soft Launched, or Archived. Previously, some engagement data from courses in other states may have been included. This change may slightly reduce reported course durations. This does not affect XP calculations.

• Filtered assessment activity: We now exclude assessment_engaged events for assessments that are not in the public state. Previously, engagement data for non-public assessments was included. This change may slightly reduce assessment duration metrics. This does not affect XP calculations.

May 22, 2025

We've enhanced the data model to include the description and short description for courses and chapters. New fields, description and short_description has been added to the dim_content table.

April 22, 2025

We've enhanced the data model to include the estimated time required to complete courses and projects. A new field time_needed_in_hours has been added to the dim_content table. This field represents the expected duration (in hours) to complete a given piece of content and is currently populated only for courses and projects.

April 17, 2025

We've added a course_is_skipped column to fact_learn_events . This column will contain a boolean (true/false) for course_completed events, indicating whether the course was skipped. A skipped course is still treated as a completed course. For cases when the course was skipped, the occurred_at timestamp for the course completion event will reflect the time at which the course was skipped.

April 16, 2025

We've updated the data model to support custom certifications. The dim_certification table now includes a new boolean field: certification_is_custom. This field indicates whether a certification is custom (true) or standard (false).

If your group uses custom certifications, you'll now see corresponding rows reflected in this table.

March 31, 2025

Launched Data Connector 2.0!!

• With Data Connector 2.0, we've significantly improved the data model, making it simpler, more efficient, and aligned with the rest of our reporting.

  • Simplified data model – Fewer tables (29 → 13) for easier querying

  • Data alignment with Groups tab reporting - Data Connector 2.0 now uses the same source as the rest of our reporting, ensuring consistency across all analytics and no discrepancies.

  • Includes mobile data - Now includes learner data done via the mobile app

  • Pre-aggregated metrics – New pre-aggregated metric tables to speed up reporting

  • Easier querying – Significantly fewer complex joins for common reports

  For more info on the differences, check out Migrating from Data Connector (1.0)