Using Salesforce, I want to only pull in part of a table to reduce Elasticube size using the manual query input in the table selection. Unfortunately, it appears that Sisense is automatically converting the table name to all capitals, causing it to not find the table in question.
Table name: Order
Auto Query Structure: SELECT * FROM [Order] (works with no issue)
Manual Query Input: SELECT * FROM [Order] (fails with error)
Error reading from table.
Unknown table '[ORDER]'
Is there any way I can pull only some of the table Order? I do not have authority to make changes to that data source.
Please sign in to leave a comment.