Hi <!channel>! announcement A new version of Elementary is out (CLI

0.7.10

, dbt package

0.7.8

)! elementary What's New? elementary • New artifacts model - dbt_columns table 🆕 ◦ Many users requested that we add this model with useful information about the columns in your project. ◦ We also plan to add features to the report and alerts based on this data. Stay tuned... coming soon ▪︎ (This is not yet supported for 🧱, working on it) • New lineage filters - Tags and owners filter🎉 ◦ You can now filter the lineage to see only the nodes that are relevant to a business department or a specific owner, and their upstream and downstream nodes. ◦ We also made some general improvements to the filters usability like adding search and clear all. • Test results sample size in the report can be changed fbwow ◦ The report is no longer limited to 5 results, you can change this by adding the var: ▪︎

test_sample_row_count: 10

• New flag -

edr --version

◦ Thank you @Manul Patel for contributing this thankyou elementary More changes elementary • Alerts suppression interval is no longer limited to 24 hours. • Added indicative exceptions to Elementary tests. •

time_bucket

can now be configured in model and var levels as well. • Created workarounds to solve breaking changes in dbt 1.5.0 adapters: ◦ Not rely on Databricks adapter to create temp tables - Thanks @Joseph Berni, @fitz and @Dharit Sura for reporting! ◦ Run queries from

run

instead of

run-operation

due to bug in Redshift adapter - Thank you @Eugene Sobolev for reporting and investigating with us! elementary Bug Fixes elementary • Support dbt run results compiled sql with % on Redshift new adapter - Thanks @Fabien Traventhal for reporting! • Fixed ignored backfill_days in no timestamp tests - Thanks @leila and @Roland Baranovic for reporting! • Fixed alerts

--group-by

empty value - Thank you @Dimosthenis Schizas for contributing 🤩 • Owners accept dict format - Thank you @Stephen Lloyd for reporting and @Manul Patel for contributing 🤩 • Paginate upload of source freshness data for large results - Thank you @Fred for reporting and fixing 🤩 • Thank you @winzee and @vinooganesh for helping keep our docs accurate and typos free 🎉 As always - We are looking forward to talk to you here on Slack (#C02CTC89LAX, #C03LPJ5EYU9 or DM to the elementary team), and happy to schedule calls!

Thanks for the update.. The lineage filter is a much needed feature.

Thanks for the feedback @Shantanu Panwar! cc: @Noy Arie @Adam Goddenyu 😊

Can you give example of how to use

test_sample_row_count

variable?

Hi @Thanat Varathon, of course! In your

dbt_project.yml

file add the var under the

vars

key like this:

vars:
  test_sample_row_count: 10

Next time you run

dbt test

and then

edr report

, the samples of failed tests would be 10 rows instead of the default which is 5 today.

• New artifacts model - dbt_columns table 🆕 ◦ Many users requested that we add this model with useful information about the columns in your project. Could you please post the link to documentation.. I am super thrilled to see this feature.. would love to get some meaningful lineage on the columns!

I would also like to see the docs for the “*New artifacts model - dbt_columns”* sounds interesting