# dbt Tests

dbt Tests are now going to be ingested into Select Star!

{% hint style="info" %}
To add dbt tests into your existing SelectStar organization, you will need to either update permissions (dbt Cloud) or add a `run_results.json` (dbt Core)
{% endhint %}

To see how to update your config:

{% content-ref url="dbt-cloud" %}
[dbt-cloud](https://docs.selectstar.com/integrations/dbt/dbt-cloud)
{% endcontent-ref %}

{% content-ref url="dbt-core-open-source" %}
[dbt-core-open-source](https://docs.selectstar.com/integrations/dbt/dbt-core-open-source)
{% endcontent-ref %}

Once updates, to find dbt tests, go to the dbt tests page from the hierarchy

<div align="left"><figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-9ec44210fbf540df1f4a830277738f7be984435c%2FScreenshot%202024-07-11%20at%2010.33.12%E2%80%AFAM.png?alt=media" alt="" width="292"><figcaption><p>dbt tests in hierarchy</p></figcaption></figure></div>

All tests that have run in the dbt data source should be available in the dbt tests page.

<figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-96809ed91b81e578fed209e977872dac4ef434fa%2FScreenshot%202022-12-15%20at%203.00.30%20AM.png?alt=media" alt=""><figcaption><p>Full dbt Tests Page</p></figcaption></figure>

To filter for failed tests, click on one of the tabs on top:

<figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-8ea0818b936869af205038a8dec44fa99316b403%2FScreenshot%202022-12-15%20at%203.03.20%20AM.png?alt=media" alt=""><figcaption><p>Failed dbt tests</p></figcaption></figure>

To view dbt tests that have run for a particular model or table, we can go to the newly added tests tab in each table/model page:

<figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-8b6a8360ed476f4970e008012f7b010a9f4b33ed%2FScreenshot%202022-12-15%20at%203.08.23%20AM.png?alt=media" alt=""><figcaption><p>Test that have run for view model.</p></figcaption></figure>

Click on any of the tests to drill down even further to see information such as all test runs and errors from the latest test run and the last run date.

<figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-f44907e41b250e1c3d2c3bef286b63ebad538d2f%2FScreenshot%202022-12-15%20at%203.11.38%20AM.png?alt=media" alt=""><figcaption><p>Failed test ingested from dbt</p></figcaption></figure>

You can each see the source of each test and copy this information really quickly:

<figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-37b213a1a10cc6e9710cd952c978e45a7c8d5add%2FScreenshot%202022-12-15%20at%203.14.18%20AM.png?alt=media" alt=""><figcaption><p>Source of test not_null</p></figcaption></figure>

dbt tests are also searchable like any other asset type in Select Star

<figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-1129652163527cd7612cd6a5a6ac4d4bb2fb055f%2FScreenshot%202022-12-16%20at%2010.30.54%20AM.png?alt=media" alt=""><figcaption><p>Search by the name of the dbt test</p></figcaption></figure>
