Slackbot
10/13/2023, 1:26 PMAnge Melhuish
10/13/2023, 1:28 PMalerts_source_freshness and alerts_dbt_source_freshness table/view, but the error has returned again today after more alerts have been generated (we run all our models just once per day).Ange Melhuish
10/13/2023, 1:33 PMAnge Melhuish
10/13/2023, 1:43 PMmerge into `production`.`elementary`.`alerts_source_freshness` as DBT_INTERNAL_DEST
using `alerts_source_freshness__dbt_tmp` as DBT_INTERNAL_SOURCE ...
and alerts_source_freshness__dbt_tmp is created with
create temporary view `alerts_source_freshness__dbt_tmp` as
select
*,
false as alert_sent,
'pending' as suppression_status,
cast(NULL as string) as sent_at
from `production`.`elementary`.`alerts_dbt_source_freshness`
there seems to be a mismatch - the two datasets have different schemas
Is this expected?Ange Melhuish
10/17/2023, 3:29 PMalerts_source_freshness only this time and everything seems to work repeatedly now. ✅