ERR_SQL_TABLE_NOT_FOUND: SQL Table not found

DSS tried to access a table in a SQL database, but the SQL database does not contain the table.

This error can happen:

  • When trying to view a SQL dataset

Remediation

  • If this error occurs on a “source” dataset (i.e. a dataset that is at the beginning of the flow), you need to check the settings of the dataset. The table name might be incorrect

  • If this error occurs on a “managed” dataset (i.e. a dataset that is built as part of the Flow), you might need to rebuild this dataset, as it may have been previously cleared.

  • Check that, in addition to the table name, the schema name is also correct

  • Pay attention to case: most SQL databases are case-sensitive, “MYTABLE” is not the same as “mytable”

  • This error can also be caused by permission issues. On some databases, if you don’t have permission to read or write a table, you will get a “table not found” error