search

mitodl / ol-data-platform

Pipeline definitions for managing data flows to power analytics at MIT Open Learning
BSD 3-Clause "New" or "Revised" License
36 stars 6 forks source link

fix dbt error on int__edxorg__mitx_courserun_certificates #1190

Closed rachellougee closed 2 months ago

rachellougee commented 2 months ago

What are the relevant tickets?

NA This is related to my previous PR https://github.com/mitodl/ol-data-platform/pull/1181, in which I forgot that the subqueries are used in ntedxorgmitx_courserun_certificates

Description (What does it do?)

This fixes the database error in today's run https://pipelines.odl.mit.edu/runs/4b3a8ca7-7961-4567-b2c6-645cbfe43d99

 Database Error in model int__edxorg__mitx_courserun_certificates (models/intermediate/edxorg/int__edxorg__mitx_courserun_certificates.sql)
  TrinoUserError(type=USER_ERROR, name=COLUMN_NOT_FOUND, message="line 98:25: Column 'dedp_edxorg_certificates_from_micromasters.user_edxorg_username' cannot be resolved", query_id=20240702_085829_07390_vvmzp)

The other database error on stgmicromastersapppostgresprofiles_employment is intermittent and nothing to fix

How can this be tested?

dbt build --select intedxorgmitx_courserun_certificates