Running Elementary Tests and Generate Reports

​

Elementary CLI Setup

The CLI tool allows users to generate reports and visuallize results based on the tests we just configured. While we have already added the Elementary packages to our dbt project, the Elementary CLI requires a separate installation, as it is a Python tool.

pip install elementary-data

pip install 'elementary-data[snowflake]'
pip install 'elementary-data[bigquery]'
pip install 'elementary-data[redshift]'
pip install 'elementary-data[databricks]'
## Postgres doesn't require this step

dbt run-operation elementary.generate_elementary_cli_profile

## SNOWFLAKE ##
## By default, edr expects the profile name 'elementary'.      ##
## Configure the database and schema of elementary models.     ##
## Check where 'elementary_test_results' is to find it.        ##

elementary:
  outputs:
    default:
      type: snowflake
      account: [account id]

      ## User/password auth ##
      user: [username]
      password: [password]

      role: [user role]
      database: [database name]
      warehouse: [warehouse name]
      schema: [schema name]_elementary
      threads: 4

​

Running Elementary

Now that we have added Elementary tests to our schemas.yml file, it’s time to run our first tests. We begin by running on a subset of our data that is all valid:

dbt run --vars "{'anomalies': False}"

​

Your First Test

Now that we have populated our data warehouse with valid data, we will run our tests and ensure that everything passes:

dbt test

All of our tests (except the dbt project’s example tests) should pass. Now, let’s visualize our results:

edr report

You’ve just run your first Elementary report!

​

Let’s get real though…

Data is rarely perfect. Let’s get real and add some more data to our project:

dbt run --vars "{'anomalies': True}"

Now let’s run our tests again:

dbt test

Now we should see our Elementary tests fail! Now let’s visualize this failure:

edr report

​

Congratulations!

Congratulations, you successfully configured Elementary’s tests and ran the report!

For additional information and help, you can use one of these channels:

• Slack (live chat with the team, community support, discussions, etc.)

• GitHub (bug reports, feature requests, contributions)

• 📧 Contact us directly at team@elementary-data.com

Any feedback would be highly appreciated 🤗