Skip to main content
  • EN

I am using Sampler to grab fisrt 1000 records but it reads all 2 million records that I am dealing with before grabbing first 1000 values. How do I avaoid it? Thanks.

Hi @anaresh299

You can specify the number to read in the Navigator window.

Hi @anaresh299

You can specify the number to read in the Navigator window.

@jeroenstiers It worked. Thanks.

Or if you use a SQLCreator/SQLExecutor you can simply put limit on the query (PostgreSQL).

capture.png

Reply


Community Stats

30,126
Posts
114,374
Replies
37,765
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.