When I type edr report in dbt it is trying to crea...
# ask-elementary-ai
v
When I type edr report in dbt it is trying to create edr internal dbt package and ending up with external connection exception. I want to generate dbt test dashboard
k
A message from kapa.ai
When you run
edr report
, Elementary's CLI uses an internal dbt project and attempts to install the required dbt packages (like
elementary
and
dbt_utils
) by running
dbt deps
in the background. This process requires internet connectivity to download the packages from the dbt package hub. If your environment does not have internet access, you will encounter external connection exceptions, such as HTTPS connection errors or "Connection reset by peer" errors, because the CLI cannot reach the package repository to fetch dependencies. How to resolve this in an offline/no-internet environment: - You need to pre-populate the internal dbt project's
dbt_packages
directory with the required packages before running
edr report
. This can be done during your image build or setup process, so that when
edr
runs, it finds the necessary packages already present and skips the download step. - Specifically, copy the
elementary
and
dbt_utils
packages into the internal dbt project's
dbt_packages
directory, which is typically located at:
Copy code
<python-site-packages>/elementary/monitor/dbt_project/dbt_packages/
- You can do this by running:
Copy code
dbt deps --project-dir <python-site-packages>/elementary/monitor/dbt_project --profiles-dir <your_profiles_dir>
during your Docker image build or environment setup, after installing the Elementary CLI. This ensures the dependencies are available at runtime, even without internet access. This approach has been confirmed to work by other users and is the recommended workaround for air-gapped or offline environments. If the required packages are present,
edr
will not attempt to download them and will proceed to generate the report as expected. For more details, see the discussion and solution here: [Slack thread on offline environments](https://slack.com/archives/C02CTC89LAX/p1679910207387459) and [another relevant thread](https://slack.com/archives/C02CTC89LAX/p1665377430565369). Summary: To generate the dbt test dashboard with
edr report
in an offline environment, pre-install the required dbt packages in the internal dbt project directory before running the command. This will prevent the CLI from attempting to access the internet and avoid the external connection exception.
v
What should I mention in <your_profiles_dir>. To generate edr report what packages should be installed. I have downloaded elementary and dbt_utils. What else is needed