Daniel Wiszowaty
05/15/2025, 9:22 AMkapa.ai
05/15/2025, 9:22 AMkapa.ai
05/15/2025, 9:22 AMedr report using GitHub Actions when your dbt project is orchestrated by dbt Cloud, you need to: 1. Ensure the Elementary dbt package is installed in your dbt project and that your dbt Cloud jobs are writing the necessary artifacts to your data warehouse (DWH). The Elementary dbt package will handle this automatically as part of your dbt runs in dbt Cloud, writing outputs to the elementary schema in your DWH [see here](https://slack.com/archives/C02CTC89LAX/p1686334697024729). 2. Set up a GitHub Action that runs the Elementary CLI (edr report) after your dbt Cloud job completes. Since dbt Cloud cannot run non-dbt commands, you must orchestrate edr report separately—GitHub Actions is a common choice for this [see here](https://slack.com/archives/C02CTC89LAX/p1678312037552069). 3. In your GitHub Action, provide a profiles.yml (as a secret or file) that allows the Elementary CLI to connect to the same data warehouse and schema used by your dbt Cloud job. Here’s a sample GitHub Actions workflow for running edr report (for example, with Snowflake): yaml name: Run Elementary on: workflow_dispatch: jobs: elementary: runs-on: ubuntu-latest steps: - name: Checkout dbt project uses: actions/checkout@v3 - name: Run Elementary uses: elementary-data/run-elementary-action@v1.11 with: warehouse-type: snowflake adapter-version: 1.5.0 profiles-yml: ${{ secrets.ELEMENTARY_PROFILES_YML }} edr-command: | edr report --file-path "report.html" - name: Upload report uses: actions/upload-artifact@v3 with: name: report.html path: report.html - name: Upload log if: always() uses: actions/upload-artifact@v3 with: name: edr.log path: edr.log Key points: - The profiles.yml must point to the same warehouse/schema as your dbt Cloud job. - You can schedule this workflow or trigger it after your dbt Cloud job (using webhooks if available, or on a schedule). - The report will be generated based on the artifacts written by dbt Cloud to your DWH [see here](https://slack.com/archives/C02CTC89LAX/p1686334697024729). You cannot run edr report directly inside dbt Cloud, but this approach allows you to generate and share reports using GitHub Actions after your dbt Cloud jobs complete [see here](https://slack.com/archives/C02CTC89LAX/p1678312037552069).Daniel Wiszowaty
05/15/2025, 11:38 AMkapa.ai
05/15/2025, 11:38 AMkapa.ai
05/15/2025, 11:38 AMedr report command and then published it to platforms like GitHub Pages by copying the generated HTML file(s) to the appropriate directory (often as index.html) for static site hosting. This approach is similar to how users deploy dbt docs or other static reports. For example, one user described generating the report and copying it to a public directory for deployment, which is compatible with GitHub Pages workflows [see example](https://slack.com/archives/C02CTC89LAX/p1695986985130289). To summarize: - Run edr report to generate the HTML report. - Copy the resulting HTML file (e.g., elementary_report.html or rename it to index.html) to the directory used by GitHub Pages (commonly public or docs). - Push this directory to the branch configured for GitHub Pages. This will make your Elementary report accessible via GitHub Pages.Daniel Wiszowaty
05/15/2025, 11:39 AMkapa.ai
05/15/2025, 11:39 AMkapa.ai
05/15/2025, 11:39 AM