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 troubleshoot this issue, do the following:

1. In Fivetran, go to your connector page.
2. Select the Schema tab.
3. Check that the table referenced in the error is included in your connector schema.

If the table is not included in your connector schema, check the checkbox next to the table, then click Save changes.

If the table is included in your schema, check that relevant data is available in your source. If no data is available, check whether we sync empty tables for your connector. See our syncing empty tables documentation for more information. If either we sync empty tables for your connector or data is available, contact our support team.

Cause

This issue may occur if any of the tables required to build the applicable dbt model don't exist in your destination or can't be accessed. We don't create empty tables for some connectors. Therefore, this may happen if we haven't yet synced applicable data for a required table.