Hi all We are facing two issues related to elementary 1. The ELEMENTARY_TEST_RESULTS table is not updated with the results randomly on some days, this is very recent behaviour after our upgrade. The logs give this error

ERROR 2023-12-04T15:38:10.251009+00:00 on-run-end failed, error: 003001 (42501): SQL access control error: Insufficient privileges to operate on table 'test_0d342ea346_elementary_column_anomalies_slvr__auth_usage_master_missing_count__account_id__metrics__tmp_20231204144822915382'|

It seems like there is some random permissions issue in a temp table which elementary is trying to create , but why would it randomly occur? 2. If we want to disable elementary tests based on tags meta data , can we achieve that at folder level from dbt_project.yml ? If yes, can you please share an example, right now we define the tags at test level in test doc.ym

Hey @Annu Joshi Thanks for reaching out! 1. Did it just started happening when you upgraded? What version did you upgrade to? Mind sharing you

dbt.log

? 2. Not sure I 100% understand the question, you want to disable specific alerts in the

dbt_project.yml

? you can diable models if you’d like like so which would affect the edr -

models:
  elementary:
    edr:
      dbt_artifacts:
        dbt_columns:
          +enabled: false

If you’d like you can share as an example what you’re doing in

docs.yml

as you mentioned

@Noa Kurman Yes it started happening when we upgraded to 0.12.1

Can you maybe find the query that gets this error? I guess this is a user with insufficient permissions, but I wonder why it’s only happens randomly. If you find the query can you confirm this is the right user and the same one that is querying other tables successfully (even so other temp tables)

so this is happening in our production runs which is essentially a machine user and permissions remain the same for that role.

Hi @Annu Joshi, care to share your

dbt.log

? in DM is ok too