Hi I have noticed that the failed test rows for Elementary a Elementary Community #community-support

Hi. I have noticed that the failed test rows for E...

Clement NN

01/03/2024, 10:23 AM

Hi. I have noticed that the failed test rows for Elementary are available in the table

test_result_rows

. However for non-Elementary tests, the table

test_result_rows

only contains 5 of the failed rows. How can I increase the number of failed rows stored for non-Elementary tests? I am using Elementary version 0.12.1. Thank you.

Ofek Weiss

01/08/2024, 2:20 PM

Hi @Clement NN, you can use the

test_sample_row_count

var in your

dbt_project.yml

file

Clement NN

01/08/2024, 2:20 PM

Thanks Ofek. I'll try that.

Clement NN

01/09/2024, 1:29 PM

Hi @Ofek Weiss. So I tried it. And it didn't work. Specifically I have this line in my dbt_project.yml

Copy code

models:
  elementary:
    +schema: "my_elementary_schema"
    test_sample_row_count: 10

Could you tell me what I am doing wrong? On a related note, I tried to find where the variable

test_sample_row_count

is used in the elementary code [1] but the only mention of

test_sample_row_count

I could find was in the documentation [2]. Do you know where in the code the variable is used? [1] https://github.com/elementary-data/elementary/tree/master [2] https://github.com/elementary-data/elementary/blob/997c3006edb89e2b66771c573f9174e89de144af/docs/cloud/general/security-and-privacy.mdx#L55

Ofek Weiss

01/09/2024, 1:55 PM

Hi @Clement NN, this is currently undocumented, currently working on adding it to the docs. in the meantime, you need to add it directly under

vars

, not

models.elementary

, like so:

Copy code

vars:
  test_sample_row_count: 10

Clement NN

01/09/2024, 3:38 PM

Great. Thanks a lot Ofek. That worked.

Ofek Weiss

01/09/2024, 3:43 PM

Amazing! glad i could help drop joy

36 Views

Open in Slack

Previous Next