Hi, I have 2 questions, hope you can help me: 1. I want to run

edr monitor --select path/to/dir,tag:my_tag

, but i'm not sure is this is supported. basically, I want to run the monitor on a specific directory of models, and within this directory, i want to run the monitor only on models with certain tags, is this possible? 2. when the on-run-end hooks running, I'm facing the following error:

09:52:37  on-run-end failed, error:
09:52:37   001759 (42601): SQL compilation error:
09:52:37  INSERT statement's target must be a table

any idea what this error is related? Thanks a lot 🙏

Hey @Itay Dar! 1. You can try and pass

--project-dir

with the path to your dbt project. That way elementary could try and use the dbt selector over your project to filter the relevant nodes 🙂 2. Can you share with me your dbt.log? It hard for me to tell what might cause the problem

@Idan Shavit I also encounter the same error even just running dbt commands. Error being encountered during the post hook where elementary packages inserting artifacts. The elementary is inserting to temp table. how to debug?

Hey @Jay Leon, The temp tables is part of the regular flow of Elementary. Can you please share a

dbt.log

that includes the error you get?

nope, see here

Maybe you shared a log file of a different run?

ooj wait

Also of you can detect the failure in the DB it would help

yes

I understand.. the thing is v11 didn't have dbt_columns, so no attempt to insert to it. However your failure is on this query:

insert into "NABUMINDS_DBTCORE_DB"."ELEMENTARY"."DBT_COLUMNS" select * from "NABUMINDS_DBTCORE_DB"."ELEMENTARY"."DBT_COLUMNS__tmp_20231205131513572878"

The syntax is ok, other inserts with the same syntax work fine. That's why I asked if "NABUMINDS_DBTCORE_DB"."ELEMENTARY"."DBT_COLUMNS" exists.. also maybe it wasn't created as a table? When upgrading to v12 did you run

dbt run --select elementary

?

Ahh I see. I'll check