'skip dbt model if source table not exist
I am trying to force dbt to skip a model if source table was not found, but I didn't found any resources that could help on such topic, for more detail on the context, I have a folder called sales on which let's suppose we have two model orders and customers, the sql code inside each model is simply looking this way :
select * from my_project.my_dataset.table
Now the thing to mention is that table is just a temporary table in BigQuery that gets expired and renewed with new data continuously, so sometimes it exists in the dataset, but sometimes not. With that said, dbt when trying to run the model will throw an error cause he didn't find the table in the source, and that's fine I just want dbt to skip it and don't throw an error of Table not Found
Any approaches how to deal with this ?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
