Research: Support for CCX courses

[Ian2012]

This issue is intended to track what must be done to support CCX courses. Initial research on CCX courses must be done to determine how they differ from primary courses, their use cases, and the information needed.

Tasks

Preview Give feedback

1. ClickHouse functions changes.
2. Changes to the course_overviews sink.
3. Changes to transformers

[Ian2012]

The following PRs are in progress to support CCX courses:

• fix: dinamically get the block-id version event-routing-backends#392: Fixes to CCX related events transformations.
• feat: add support for CCX courses aspects-dbt#44 and feat: add get_org_from_ccx_course_url function #607: Fixes an issue extracting the organization from CCX course URLs and extracting the xblock_id.
• fix: sink ccx courses on original course published openedx-unsupported/openedx-event-sink-clickhouse#78: Fixes to the sinks.

Further research is required

[Ian2012]

All PRs merged, waiting for CI to pass here: #619.

@bmtcril Although the CCX courses are supported now, the experience of choosing CCX courses is not a good one. I was thinking of updating the course_run filter's dataset so that when courses are filtered by course_name, CCX child courses appear as a run of the master courses. Do you see this approach feasible?

[bmtcril]

I think that should be handled as part of the mock ups since we don't know how filtering is going to work yet. I think we can close this out since any remaining work is going to be done elsewhere?