Fix unique_devices canonical domain

When updating unique-devices to use a new access_method column, we introduced a bug in the domain, removing the leading www. from the canonical domains using it. This patch adds a new table to the loading job (HQL patch here: https://gerrit.wikimedia.org/r/c/analytics/refinery/+/1194885) to use the canonical domain when it exists in the canonical_data.wikis table.

Bug: T405533

Merge request reports

Loading