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