Error: Database Error in Model, Must Be the Owner of View/Table

Issue

Transformations fail with one of the following errors:

Database error in model , must be the owner of view.

Database error in model , must be the owner of table.   

Environment

Transformations for dbt Core

Resolution

To resolve this issue, do the following:

1. Check the transformation run logs to identify views or tables affected by the error.
2. Provide the Fivetran user access to the transformation views or tables in the destination.

Cause

This issue occurs when the owner of a view or table created by the dbt transformation changes. This may happen if:

• you manually update the owner of a view or table after Fivetran triggers the transformation.
• dbt runs the transformation before Fivetran.