Error on Full Refresh - Failure to match models

Tomme / dbt-athena

The athena adapter plugin for dbt (https://getdbt.com)

Apache License 2.0

142 stars 79 forks source link

Error on Full Refresh - Failure to match models #22

Closed konosp closed 3 years ago

konosp commented 3 years ago

When trying to run dbt with full refresh, i receive the below error. Have never seen this before so I am not sure this if is a setup issue on my side or something else.

dbt-error

Any thoughts?

sujeetpillai commented 3 years ago

I had the same issue and debugged it down to this line in dbt. https://github.com/dbt-labs/dbt/blob/e5c63884e201c16bf8c905ecf5672e176111d65d/core/dbt/adapters/base/relation.py#L35

In my profiles.yml I had set database: AwsDataCatalog

In the above mentioned line where it was comparing the database it was comparing a lowercase 'awsdatacatalog' with 'AwsDataCatalog'

Setting the database value in profiles.yml to lowercase awsdatacatalog solved it for me.

konosp commented 3 years ago

Hi @sujeetpillai,

Thanks for this! Seems to have solved my issue. dbt now works great. Closing the ticket.

Cheers