Error Using SQL to Prefilter Data from Hana / ODBC: ERROR [42S02]

[paulsnet1986]

One of my reports has a dataset that's taxing on our embedded instance, and so I'm trying to limit the records in the largest table before they're imported.

Advanced editor source

I have little experience with SQL but I figured such a simple action wouldn't be an issue. I'm attempting to limit the source table by adding the below statement:

However, when I attempt to connect to the data, I get the following error: [HDBODBC] Base table or view not found;259 invalid table name: Could not find table/view PROJECTDETAILLIST_PBI1 in schema WEBUSER: line 1 col 15 (at pos 14)"

[v-jingzhang · Accepted solution]

Hi @paulsnet1986 

This error message indicates that it couldn't find the table "PROJECTDETAILLIST_PBI1". Please check the name of the table. Does it have an additional "1" at the end? From the first picture, you are querying data from a table named "PROJECTDETAILLIST_PBI". 

If the table name is correct, please check the schema of the table. From the error message, it tried to find the table in schema WEBUSER by default. If this table is not in the schema, you should specifiy its schema in the SQL statement like 

select * from schemaname.tablename where SoldTo = '10015'

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.