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. Type the destination name in the Search by name field to find the destination, or select the destination from the list.
3. Go to Settings > dbt Core > Edit connection details.
4. Set the Show advanced options toggle to ON.
5. In the Project path (optional) field, enter the path to the dbt_project.yml file.

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.