Hi all, I'm working on testing how Elementary will run with GitHub Actions in our dbt repo before implementing it in production. An issue I have run into is configuring Elementary to read our QC schema given the requirement that the

profile.yml

needs to be stored as a secret. We generate our QC schema names programmatically with the

${{ github.event.number }}

variable concatenating it with "dbt_qc". However, I haven't been able to encode the same method into the secret where the Elementary profile is stored. My attempts so far have looked like below: •

schema: "{{dbt_qc_+=env_var('BUILD_ID') }}"

•

schema: "dbt_qc_{{ env_var('BUILD_ID') }}"

Using dbt 1.4.5 and dbt-databricks 1.4.2

Hey @Will Seaton 👋🏼 Can you share the result of the schema value that you got? Did you get any errors?

Hi, Noy! The error was a "Failed to Elementary dbt package version" error. Unfortunately, I can't find the runs this occurred on as they got buried, I ultimately found a workaround. I copied the tables to my desired Elementary target schema. This wasn't my Plan A, since it involved some permissions difficulties, but it worked out in the end.