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

Velir / dbt-ga4

dbt Package for modeling raw data exported by Google Analytics 4. BigQuery support, only.

MIT License

289 stars 128 forks source link

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

Closed QingFyndiq closed 10 months ago

QingFyndiq commented 10 months ago

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?

QingFyndiq commented 10 months ago

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.