2010
08.27
08.27
When creating extracts in Tableau, make sure to verify the ROWSETLIMIT parameter for the user connecting to Netezza.
From the manual:
ROWSETLIMIT: Specifies the number of rows a query can return. You can specify
from 1 to 2,147,483,647 rows or zero for unlimited.
For some strange reason, this parameter doesn’t affect direct queries from Tableau Desktop or Server. However, when creating extracts, the number of rows returned will be limited (silently) by ROWSETLIMIT.
To change the value:
ALTER USER tableau WITH ROWSETLIMIT 10000;
No Comment.
Add Your Comment