I could not able to generate the edr report and it throws me Elementary Community #community-support

Join Slack

I could not able to generate the edr report and it...

# community-support

Sravan

10/24/2023, 5:51 AM

I could not able to generate the edr report and it throws me the below error. Any inputs on this please?

👀 1

Erik Zaadi

10/24/2023, 2:59 PM

Hey there @Sravan! This issue should be fixed in the upcoming release: https://github.com/elementary-data/elementary/issues/1157

Sravan

10/24/2023, 3:10 PM

@Erik Zaadi: Thanks Erik. Do you know when this will go live ? And also are you sure about the error that i am getting because it says elementary ERROR — Failed to parse Elementary's database and schema. Just want to make sure we both are on the same page

Erik Zaadi

10/29/2023, 8:00 AM

@Sravan The new version is live

Maayan Salom

10/30/2023, 8:27 PM

Hey @Sravan, I think it means that the Elementary schema is not found on the target that you are running

edr

against. Do you have an elementary schema? If so, is this the schema and database detailed in your profile named

elementary

Sravan

11/01/2023, 8:31 PM

Thanks @Erik Zaadi @Maayan Salom. Yes i have an elementary schema and i see the profile names elementary as well. But i am still not able to generate the edr report

Sravan

11/01/2023, 8:31 PM

(.dbt-venv-1_3) sravankumarkunadi@MAC-Y9JV49V dbt % edr report ________ __ / ____/ /__ __ _ _ __ / /_____ ________ __ / __/ / / _ \/ _ `_ \/ _ \/ __ \/ _/ _ `/ ___/ / / / / /___/ / __/ / / / / / __/ / / / /_/ /_/ / / / /_/ / /_____/_/\___/_/ /_/ /_/\___/_/ /_/\__/\__,_/_/ \__, / /____/ Any feedback and suggestions are welcomed! join our community here - https://bit.ly/slack-elementary 2023-11-01 132916 — INFO — Running with edr=0.12.0 2023-11-01 132917 — ERROR — Unable to get the latest invocation: Failed to run dbt command. 2023-11-01 132919 — ERROR — Failed to parse Elementary's database and schema. 2023-11-01 132919 — INFO — Running dbt --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_test_results", "macro_args": {"days_back": 7, "invocations_per_test": 720, "disable_passed_test_metrics": false}} --project-dir /Users/sravankumarkunadi/database-migrations/.dbt-venv-1_3/lib/python3.9/site-packages/elementary/monitor/dbt_project 2023-11-01 132920 — ERROR — Could not generate the report - Error: Failed to run dbt command. Please reach out to our community for help with this issue. NoneType: None

Sravan

11/01/2023, 8:31 PM

(.dbt-venv-1_3) sravankumarkunadi@MAC-Y9JV49V dbt % dbt debug 203144 Running with dbt=1.3.6 dbt version: 1.3.6 python version: 3.9.13 python path: /Users/sravankumarkunadi/database-migrations/.dbt-venv-1_3/bin/python os info: macOS-13.6-arm64-arm-64bit Using profiles.yml file at /Users/sravankumarkunadi/.dbt/profiles.yml Using dbt_project.yml file at /Users/sravankumarkunadi/procore-data-platform/dbt/dbt_project.yml Configuration: profiles.yml file [OK found and valid] dbt_project.yml file [OK found and valid] Required dependencies: - git [OK found] Connection: account: procoreit user: sravankumar.kunadi@procore.com database: PDP_MDM_DEV_SRAVAN schema: elementary warehouse: DDL_DEPLOYMENT_WH role: PDP_ENGINEER_ROLE client_session_keep_alive: False Connection test: [OK connection ok] All checks passed!

Sravan

11/01/2023, 8:33 PM

I have this in the profiles.yml

Sravan

11/01/2023, 8:33 PM

elementary: # Add your "unit_test" profile here type: snowflake account: procoreit user: "sravankumar.kunadi@procore.com" password: "xxxxxxxxxxx" role: "PDP_ENGINEER_ROLE" database: "PDP_MDM_DEV_SRAVAN" # Use a separate database for testing warehouse: DDL_DEPLOYMENT_WH schema: "elementary" # Use a separate schema for testing threads: 16 client_session_keep_alive: False target: elementary

Sravan

11/01/2023, 8:34 PM

I am able to run the edr --help

Sravan

11/01/2023, 8:34 PM

(.dbt-venv-1_3) sravankumarkunadi@MAC-Y9JV49V dbt % edr --help ________ __ / ____/ /__ __ _ _ __ / /_____ ________ __ / __/ / / _ \/ _ `_ \/ _ \/ __ \/ _/ _ `/ ___/ / / / / /___/ / __/ / / / / / __/ / / / /_/ /_/ / / / /_/ / /_____/_/\___/_/ /_/ /_/\___/_/ /_/\__/\__,_/_/ \__, / /____/ Loading dependencies (this might take a few seconds) Usage: edr [OPTIONS] COMMAND [ARGS]... Open source data reliability solution (https://docs.elementary-data.com/) Options: --version Show the version and exit. --help Show this message and exit. Commands: monitor Get alerts on failures in dbt jobs. report Generate a local observability report of your warehouse. send-report Generate and send the report to an external platform. run-operation Utilities for Elementary operations. (.dbt-venv-1_3) sravankumarkunadi@MAC-Y9JV49V dbt %

Sravan

11/02/2023, 11:55 AM

@Erik Zaadi: any update on this please?

Erik Zaadi

11/02/2023, 11:59 AM

Hey Sravan, just verifying, you update the

packages.yml

with the version

0.12.1

for the elementary package, then ran

dbt deps

? If you run

dbt run -s elementary

, does that finish successfully? Last question, what version of dbt are you using?

Sravan

11/02/2023, 12:03 PM

yes it finished successfully

Sravan

11/02/2023, 12:03 PM

(.dbt-venv-1_3) sravankumarkunadi@MAC-Y9JV49V dbt % dbt --version Core: - installed: 1.3.6 - latest: 1.6.7 - Update available! Your version of dbt-core is out of date! You can find instructions for upgrading here: https://docs.getdbt.com/docs/installation Plugins: - snowflake: 1.3.0 - Update available! At least one plugin is out of date or incompatible with dbt-core. You can find instructions for upgrading here: https://docs.getdbt.com/docs/installation

Noa Kurman

02/12/2024, 1:46 PM

Hey @Sravan! Sorry for the late response - seems like you’re using a pretty old dbt versions, do you mind trying to upgrade? Both the core and the snowflake plugin

31 Views

Open in Slack

Previous Next