coursetags

Recipe Goal:

Replicate the deprecated coursetags data by joining courses, coursegrouptags, and tags. Since deprecation of the coursetags table on 3/19/2025, NRT BI users should now rely on a set of three joins to replicate the data formerly available in the coursetags table.

Sample SQL

select
    c.id as course_id,
    c.coursegroupid as course_group_id,
    c.companyid as company_id,
    t.label as tag_label,
    t.id as tag_id,
    cgt.updatedat as updated_at
from
    courses as c
join coursegrouptags as cgt on
    c.coursegroupid = cgt.coursegroupid
join tags as t on
    cgt.tagid = t.id
where
    ....