Error: Execution Failure. Failed to Access dbt_project.yml

Issue

While compiling a project, the following error appears:

Execution failure. Failed to access dbt_project.yml

Environment

Transformations for dbt Core

Resolution

To resolve this issue, ensure the dbt_project.yml file is at the root of your repository rather than in a folder. If that's not possible, you can specify the file path to the dbt_project.yml file in your project by doing the following:

1. In Fivetran, click Transformations.
2. Click Manage projects in the top-right corner.
3. Click the project.
4. On the dbt Transformations page, set the Show advanced options toggle to ON.
5. In the Project path (optional) field, enter the path to the dbt_project.yml file.
6. Click Save & Test.
7. After the tests have passed, click Done.

Cause

This error occurs when Transformations for dbt Core either can't access the dbt_project.yml file in the dbt project folder or the file is missing. By default, Transformations for dbt Core attempts to locate the dbt_project.yml file at the root of the project directory or repository.