Error processing table structure
The table 'xxxx' could not be found, please check the table prefix defined for it.
STEPS TO REPRODUCE:1. Open the Warehouse Catalog
2. Right-click on a table of the project and select "Show Sample Data..."
CAUSE:One possible cause for this issue is that synonyms instead of tables are being retrieved from the Warehouse Catalog.
Synonyms are alternative names for objects such as tables or views and they are like public names to access objects. In general, a synonym can be used when a database administrator does not want to refer to an object using its schema name.
The issue appears if the SQL statements included in the Warehouse Read Settings, get the database namespace. When selecting "Show sample data...", that namespace will be appended to the name of the synonym and the following query will be executed against the Warehouse Database:
SELECT * FROM <namespace>.<synonym_name>
but
<namespace>.<synonym_name> doesn't exist. The query will return an error unless the synonym and its associated table are named in the same way.
The way to query the Warehouse Database in order to retrieve data from a synonym would be:
SELECT * FROM <synonym_name>
ACTION:Strategy will continue to investigate and post updates as soon as they are available.
WORKAROUND:Remove the references to the namespace from the Warehouse Catalog Read settings SQL statements. If you don't retrieve the namespace, the query generated when selecting "Show Sample Data..." will be the following:
SELECT * FROM <synonym_name>
.
