Hi all. I started seeing the error:

18:00:22   001759 (42601): SQL compilation error:
18:00:22  INSERT statement's target must be a table

after running

dbt test

. I was able to fix this by rebuilding the elementary tables:

dbt run --select elementary

but i’m still not sure what happened to cause this sudden error? any ideas? I’m running dbt 1.5.7, and elementary 0.12.0

Hey @Dardan Mu! Did you by any chance recently upgraded the elementary package version? If so (and even if not) the

dbt run --select elementary

command will recreate the elementary tables, my guess is for some reason the tables have been deleted or not all of them were created, and this is why running the command has solved it As I mentioned a possible explanation was a version upgrade

I didnt upgrade the dbt package, we hardcode this to 0.12. But it’s possible the python version was updated. could that change anything in the dbt tables?