How to resolve Table Does Not Exist Errors

When viewing tables from the Manage Data page, you may encounter the following error:

The data source you are viewing is incompatible with its schema. This is likely because you have added a data source to a schema, but the data source does not contain all tables defined by the default data source of the schema.

This error typically occurs when you try to query a table using a data source that does not contain that table. Tables are generated for a schema when you select a default data source, and it is assumed that all data sources connected to the schema will include these tables.

Because all queries for a schema are expected to run against all data sources connected to that schema, Explo treats the default data source’s synced tables as the source of truth for that schema.

How do I resolve this?

Option 1: Remove Unneeded Tables

If you do not need the missing table synced to Explo, you can resolve this by simply resyncing tables for that schema and not including this table.
See Sync New Tables for more details.

Option 2: Add the Missing Table or Adjust Schemas

Otherwise, consider one of the following:

• Add the table to your data source so it matches the schema requirements.

• Move the data source to a different schema if it shouldn’t contain this table.

Note: All queries for a schema should be able to run against every data source in that schema. Any queries using the missing table will not work for customers associated with a data source that lacks that table.