Hello #C02CTC89LAX, I want to leverage the elementary package, so I added the package and added it to my dbt_project.yml, but I am having issues with tables materializing incorrectly.
I have not changed any of the elementary config files from their default, and for some reason, models that are configured to be incremental (EX: DBT_INVOCATIONS) are running as ‘CREATE OR REPLACE TABLE’ as opposed to ‘MERGE’ which is what I would typically expect for an incremental model. As shown in the screenshot below, I would expect this model to materialize incrementally, but every time I run my project, it is wiping the previous run results and replacing them.
Not sure what I am missing here, but when I have others run dbt for the same exact project, it MERGES as expected. Any idea why this is happening and is unique to me? Ive tried updating the package, and am still facing the same issues. Thanks in advance!
Here is the config file for dbt_invocations.yml