Hello, team! I am new to elementary. When I run `e...
# community-support
s
Hello, team! I am new to elementary. When I run
edr report
I am getting the below error, and in my dbt project the path exist is
dbt_packages\\elementary\\integration_tests\\deprecated_tests\\data\\training\\any_type_column_anomalies_training.csv
Error is:
Copy code
elementary.exceptions.exceptions.DbtCommandError: Failed to run dbt command.
[Errno 2] No such file or directory: 'dbt_packages\\dbt-data-reliability-0.18.3\\integration_tests\\deprecated_tests\\data\\training\\any_type_column_anomalies_training.csv'
Could someone help me what am I missing here?
n
Hey @Sangeetha! Welcome to Elementary šŸŽ‰ Forwarding your question to #C08HW57FGN9, please let me know if it's helpful, and if you still need any further help.
s
As per the suggestion, tried all the below steps, but still getting the same error. • Deleted and re-created the new python virtual environment • Deleted and re-created the new dbt project • Tried installing the packages using
dbt deps
within the new venv and dbt project • requirements.txt
Copy code
dbt-core>=1.9.6
dbt-databricks>=1.1.1
elementary-data>=0.15.0
• packages.yml
Copy code
packages:
  - package: elementary-data/elementary
    version: 0.18.3
Attached the images of folder path inside the dbt project and inside the venv
Copy code
$ edr report -t dev

    ________                          __
   / ____/ /__  ____ ___  ___  ____  / /_____ ________  __
  / __/ / / _ \/ __ `__ \/ _ \/ __ \/ __/ __ `/ ___/ / / /
 / /___/ /  __/ / / / / /  __/ / / / /_/ /_/ / /  / /_/ /
/_____/_/\___/_/ /_/ /_/\___/_/ /_/\__/\__,_/_/   \__, /
                                                 /____/


Any feedback and suggestions are welcomed! join our community here - <https://bit.ly/slack-elementary>

2025-06-20 17:08:26 — INFO — Running with edr=0.18.3
INFO:elementary.cli.cli:Running with edr=0.18.3
2025-06-20 17:08:27 — INFO — Installing packages for edr internal dbt package...
INFO:elementary.clients.dbt.command_line_dbt_runner:Installing packages for edr internal dbt package...
2025-06-20 17:08:27 — INFO — Running dbt command --log-format json deps --project-dir C:\Users\username\Documents\D_17Mar2025_2\client\code_repos\dbt-prj\devenv\Lib\site-packages\elementary\monitor\dbt_project --target dev
INFO:elementary.clients.dbt.command_line_dbt_runner:Running dbt command --log-format json deps --project-dir C:\Users\username\Documents\D_17Mar2025_2\client\code_repos\dbt-prj\devenv\Lib\site-packages\elementary\monitor\dbt_project --target dev
{"data": {"exc": "[Errno 2] No such file or directory: 'dbt_packages\\\\dbt-data-reliability-0.18.3\\\\integration_tests\\\\deprecated_tests\\\\data\\\\training\\\\backfill_days_column_anomalies_training.csv'"}, "info": {"category": "", "code": "Z002", "extra": {}, "invocation_id": "6a3ed94b-a151-47d7-b2bf-0fc9f4e56299", "level": "error", "msg": "Encountered an error:\n[Errno 2] No such file or directory: 'dbt_packages\\\\dbt-data-reliability-0.18.3\\\\integration_tests\\\\deprecated_tests\\\\data\\\\training\\\\backfill_days_column_anomalies_training.csv'", "name": "MainEncounteredError", "pid": 31012, "thread": "MainThread", "ts": "2025-06-20T11:38:30.708267Z"}}
{"data": {"stack_trace": "Traceback (most recent call last):\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt\\cli\\requires.py\", line 161, in wrapper\n    result, success = func(*args, **kwargs)\n                      ^^^^^^^^^^^^^^^^^^^^^\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt\\cli\\requires.py\", line 111, in wrapper\n    return func(*args, **kwargs)\n           ^^^^^^^^^^^^^^^^^^^^^\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt\\cli\\requires.py\", line 237, in wrapper\n    return func(*args, **kwargs)\n           ^^^^^^^^^^^^^^^^^^^^^\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt\\cli\\requires.py\", line 285, in wrapper\n    return func(*args, **kwargs)\n           ^^^^^^^^^^^^^^^^^^^^^\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt\\cli\\main.py\", line 461, in deps\n    results = task.run()\n              ^^^^^^^^^^\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt\\task\\deps.py\", line 258, in run\n    package.install(self.project, renderer)\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt\\deps\\registry.py\", line 63, in install\n    self._install(project, renderer)\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt\\deps\\base.py\", line 121, in _install\n    connection_exception_retry(download_untar_fn, 5)\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt_common\\utils\\connection.py\", line 21, in connection_exception_retry\n    return fn()\n           ^^^^\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt\\deps\\base.py\", line 133, in download_and_untar\n    system.untar_package(tar_path, deps_path, package_name)\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt_common\\clients\\system.py\", line 641, in untar_package\n    safe_extract(tarball, dest_dir)\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt_common\\clients\\system.py\", line 634, in safe_extract\n    tarball.extractall(path, members=members)\n  File \"C:\\Program Files\\Python312\\Lib\\tarfile.py\", line 2269, in extractall\n    self._extract_one(tarinfo, path, set_attrs=not tarinfo.isdir(),\n  File \"C:\\Program Files\\Python312\\Lib\\tarfile.py\", line 2336, in _extract_one\n    self._handle_fatal_error(e)\n  File \"C:\\Program Files\\Python312\\Lib\\tarfile.py\", line 2332, in _extract_one\n    self._extract_member(tarinfo, os.path.join(path, tarinfo.name),\n  File \"C:\\Program Files\\Python312\\Lib\\tarfile.py\", line 2415, in _extract_member\n    self.makefile(tarinfo, targetpath)\n  File \"C:\\Program Files\\Python312\\Lib\\tarfile.py\", line 2461, in makefile\n    with bltn_open(targetpath, \"wb\") as target:\n         ^^^^^^^^^^^^^^^^^^^^^^^^^^^\nFileNotFoundError: [Errno 2] No such file or directory: 'dbt_packages\\\\dbt-data-reliability-0.18.3\\\\integration_tests\\\\deprecated_tests\\\\data\\\\training\\\\backfill_days_column_anomalies_training.csv'\n"}, "info": {"category": "", "code": "Z003", "extra": {}, "invocation_id": "6a3ed94b-a151-47d7-b2bf-0fc9f4e56299", "level": "error", "msg": "Traceback (most recent call last):\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt\\cli\\requires.py\", line 161, in wrapper\n    result, success = func(*args, **kwargs)\n                      ^^^^^^^^^^^^^^^^^^^^^\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt\\cli\\requires.py\", line 111, in wrapper\n    return func(*args, **kwargs)\n           ^^^^^^^^^^^^^^^^^^^^^\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt\\cli\\requires.py\", line 237, in wrapper\n    return func(*args, **kwargs)\n           ^^^^^^^^^^^^^^^^^^^^^\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt\\cli\\requires.py\", line 285, in wrapper\n    return func(*args, **kwargs)\n
^^^^^^^^^^^^^^^^^^^^^\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt\\cli\\main.py\", line 461, in deps\n    results = task.run()\n              ^^^^^^^^^^\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt\\task\\deps.py\", line 258, in run\n    package.install(self.project, renderer)\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt\\deps\\registry.py\", line 63, in install\n    self._install(project, renderer)\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt\\deps\\base.py\", line 121, in _install\n    connection_exception_retry(download_untar_fn, 5)\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt_common\\utils\\connection.py\", line 21, in connection_exception_retry\n    return fn()\n           ^^^^\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt\\deps\\base.py\", line 133, in download_and_untar\n    system.untar_package(tar_path, deps_path, package_name)\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt_common\\clients\\system.py\", line 641, in untar_package\n    safe_extract(tarball, dest_dir)\n  File \"C:\\Users\\username\\Documents\\D_17Mar2025_2\\client\\code_repos\\dbt-prj\\devenv\\Lib\\site-packages\\dbt_common\\clients\\system.py\", line 634, in safe_extract\n    tarball.extractall(path, members=members)\n  File \"C:\\Program Files\\Python312\\Lib\\tarfile.py\", line 2269, in extractall\n    self._extract_one(tarinfo, path, set_attrs=not tarinfo.isdir(),\n  File \"C:\\Program Files\\Python312\\Lib\\tarfile.py\", line 2336, in _extract_one\n    self._handle_fatal_error(e)\n  File \"C:\\Program Files\\Python312\\Lib\\tarfile.py\", line 2332, in _extract_one\n    self._extract_member(tarinfo, os.path.join(path, tarinfo.name),\n  File \"C:\\Program Files\\Python312\\Lib\\tarfile.py\", line 2415, in _extract_member\n    self.makefile(tarinfo, targetpath)\n  File \"C:\\Program Files\\Python312\\Lib\\tarfile.py\", line 2461, in makefile\n    with bltn_open(targetpath, \"wb\") as target:\n         ^^^^^^^^^^^^^^^^^^^^^^^^^^^\nFileNotFoundError: [Errno 2] No such file or directory: 'dbt_packages\\\\dbt-data-reliability-0.18.3\\\\integration_tests\\\\deprecated_tests\\\\data\\\\training\\\\backfill_days_column_anomalies_training.csv'\n", "name": "MainStackTrace", "pid": 31012, "thread": "MainThread", "ts": "2025-06-20T11:38:30.880769Z"}}
Copy code
Traceback (most recent call last):
  File "<frozen runpy>", line 198, in _run_module_as_main
  File "<frozen runpy>", line 88, in _run_code
  File "C:\Users\username\Documents\D_17Mar2025_2\client\code_repos\dbt-prj\devenv\Scripts\edr.exe\__main__.py", line 7, in <module>
  File "C:\Users\username\Documents\D_17Mar2025_2\client\code_repos\dbt-prj\devenv\Lib\site-packages\click\core.py", line 1442, in __call__
    return self.main(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\username\Documents\D_17Mar2025_2\client\code_repos\dbt-prj\devenv\Lib\site-packages\click\core.py", line 1363, in main
    rv = self.invoke(ctx)
         ^^^^^^^^^^^^^^^^
  File "C:\Users\username\Documents\D_17Mar2025_2\client\code_repos\dbt-prj\devenv\Lib\site-packages\elementary\cli\cli.py", line 66, in invoke
    return super().invoke(ctx)
           ^^^^^^^^^^^^^^^^^^^
  File "C:\Users\username\Documents\D_17Mar2025_2\client\code_repos\dbt-prj\devenv\Lib\site-packages\click\core.py", line 1830, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\username\Documents\D_17Mar2025_2\client\code_repos\dbt-prj\devenv\Lib\site-packages\click\core.py", line 1226, in invoke
    return ctx.invoke(self.callback, **ctx.params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\username\Documents\D_17Mar2025_2\client\code_repos\dbt-prj\devenv\Lib\site-packages\click\core.py", line 794, in invoke
    return callback(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\username\Documents\D_17Mar2025_2\client\code_repos\dbt-prj\devenv\Lib\site-packages\click\decorators.py", line 34, in new_func
    return f(get_current_context(), *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\username\Documents\D_17Mar2025_2\client\code_repos\dbt-prj\devenv\Lib\site-packages\elementary\monitor\cli.py", line 452, in report
    data_monitoring = DataMonitoringReport(
                      ^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\username\Documents\D_17Mar2025_2\client\code_repos\dbt-prj\devenv\Lib\site-packages\elementary\monitor\data_monitoring\report\data_monitoring_report.py", line 41, in __init__
    super().__init__(
  File "C:\Users\username\Documents\D_17Mar2025_2\client\code_repos\dbt-prj\devenv\Lib\site-packages\elementary\monitor\data_monitoring\data_monitoring.py", line 35, in __init__
    self.internal_dbt_runner = self._init_internal_dbt_runner()
                               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\username\Documents\D_17Mar2025_2\client\code_repos\dbt-prj\devenv\Lib\site-packages\elementary\monitor\data_monitoring\data_monitoring.py", line 61, in _init_internal_dbt_runner
    internal_dbt_runner = create_dbt_runner(
                          ^^^^^^^^^^^^^^^^^^
  File "C:\Users\username\Documents\D_17Mar2025_2\client\code_repos\dbt-prj\devenv\Lib\site-packages\elementary\clients\dbt\factory.py", line 37, in create_dbt_runner
    return RUNNER_CLASS(
           ^^^^^^^^^^^^^
  File "C:\Users\username\Documents\D_17Mar2025_2\client\code_repos\dbt-prj\devenv\Lib\site-packages\elementary\clients\dbt\command_line_dbt_runner.py", line 57, in __init__
    self._run_deps_if_needed()
  File "C:\Users\username\Documents\D_17Mar2025_2\client\code_repos\dbt-prj\devenv\Lib\site-packages\elementary\clients\dbt\command_line_dbt_runner.py", line 320, in _run_deps_if_needed
    self.deps()
  File "C:\Users\username\Documents\D_17Mar2025_2\client\code_repos\dbt-prj\devenv\Lib\site-packages\elementary\clients\dbt\command_line_dbt_runner.py", line 133, in deps
    result = self._run_command(
             ^^^^^^^^^^^^^^^^^^
  File "C:\Users\username\Documents\D_17Mar2025_2\client\code_repos\dbt-prj\devenv\Lib\site-packages\elementary\clients\dbt\command_line_dbt_runner.py", line 114, in _run_command
    result = self._inner_run_command(
             ^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\username\Documents\D_17Mar2025_2\client\code_repos\dbt-prj\devenv\Lib\site-packages\elementary\clients\dbt\api_dbt_runner.py", line 54, in _inner_run_command
    raise DbtCommandError(
elementary.exceptions.exceptions.DbtCommandError: Failed to run dbt command.
[Errno 2] No such file or directory: 'dbt_packages\\dbt-data-reliability-0.18.3\\integration_tests\\deprecated_tests\\data\\training\\backfill_days_column_anomalies_training.csv'
@Noya Offer @kapa.ai Please help me resolving this
šŸ‘€ 1