Question: Could you please help me with this issue?

```
Encountered an error:
Compilation Error in model metrics_model (models\example\metrics_model.sql)
  Model 'model.test_project.metrics_model' (models\example\metrics_model.sql) depends on a source named 'automate.metrics' which was not found

```

I am having this monotonous error, which I have not been able to solve.

Many thanks beforehand!

Answer: 
This is due to the `automate.metrics` table missing from the database (either the dbt project’s target database or a different database on the same server). There should be a `source.yml` or `automate.yml` file somewhere in your project that defines the source. FYI `automate` is the schema name and `metrics` is the table name.

1. If the source yml file specifies a database for the `automate` schema, query that database to make sure that the `metrics` table exists in the `automate` schema.
2. If the source yml file doesn’t list a database, then that schema / table should exist in the dbt project’s target database. You can see what the target database is by looking at the profile for your project setup in `~/.dbt/profiles.yml`.
Are you seeing this in your dev environment? It's possible that you've not run `dbt run` after creating the `automate.metrics` which is preventing `metrics_model` from referencing it.