Unrecognized name: user_pseudo_id in model ga4.fct_ga4__sessions_daily and distinct_user_pseudo_ids in model ga4.fct_ga4__pages

Question

Unrecognized name: user_pseudo_id in model ga4.fct_ga4__sessions_daily and distinct_user_pseudo_ids in model ga4.fct_ga4__pages

Closed this issue a year ago · 1 comments

Hi,
I have upgraded to the latest version 5.0.0, but meet two unrecognized name issues:
one is : unrecognized 'user_pseudo_id' in model ga4.fct_ga4__sessions_daily
the other is: unrecognized 'distinct_user_pseudo_ids' in model ga4.fct_ga4__pages

pre-processes are successful: 'dbt deps' 'dbt seed', and other models except the two models run success.
I don't know how to fix it, could you help me identify the reasons and find a solution?

Answer 1 · 2023-08-08T14:14:57.000Z

I fix it now.
I have implement version 3.2.1 before, the two models run successfully after I delete the two models in bigquery which have the two columns. The updated models don't have these two columns any longer.