Error: Object Does Not Exist or Not Authorized

Issue

Transformations fail. The following error appears:

Object does not exist or not authorized.

Environment

• Transformations: Transformations for dbt Core
• Quickstart data models

Resolution

To resolve this issue, do the following:

1. Verify that the table is included in your connection schema.

   i. In Fivetran, go to your connection page.

   ii. Select the Schema tab.

   iii. Check that the table referenced in the error is included in your connection schema.

   iv. If the table isn't included, select the checkbox next to the table, then click Save changes.

2. Check that source data is available.

3. If no source data is available, check whether the connector supports syncing empty tables.

If source data is available or the connector supports syncing empty tables, contact our support team.

Cause

This issue occurs when one or more of the tables required to build the dbt model don't exist in your destination or we can't access them.

This may happen when:

• The table isn't included in your connection schema.
• The source contains no relevant data and the connector doesn't support syncing empty tables.