Expand my Community achievements bar.

Help shape the future of AI assistance by participating in this quick card sorting activity. Your input will help create a more effective system that better serves your needs and those of your colleagues.
SOLVED

Jdbc result set returns only 50000 records If there is no any limit

Avatar

Level 2

How to fetch more than 50000 records from Adobe postgres DB through java application (jdbc)

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

@Arulprakash07 There are some guardrails put in place, see here: https://experienceleague.adobe.com/docs/experience-platform/query/guardrails.html?lang=en#primary-en...

 

Client Connector

  • Query UI (100 rows)
  • Third-party client (50,000)
  • PostgresSQL client (50,000)

If you need to fetch more rows you may want to consider other approaches:

  1. Writing to a dataset and using Data Access API
  2. Event Forwarding
  3. Destinations

If you have a use case we might be able to guide you better.

What is your use case?

Danny

View solution in original post

4 Replies

Avatar

Correct answer by
Employee Advisor

@Arulprakash07 There are some guardrails put in place, see here: https://experienceleague.adobe.com/docs/experience-platform/query/guardrails.html?lang=en#primary-en...

 

Client Connector

  • Query UI (100 rows)
  • Third-party client (50,000)
  • PostgresSQL client (50,000)

If you need to fetch more rows you may want to consider other approaches:

  1. Writing to a dataset and using Data Access API
  2. Event Forwarding
  3. Destinations

If you have a use case we might be able to guide you better.

What is your use case?

Danny

Avatar

Level 2

Thanks Danny for your response !

 

When use limit in my query, I'm able to get more than 50,000 records.
For example, If I use limit as '80000' in my query then I'm able to get 80,000 records.
If there is NO any limit in my query, then getting only max 50,000 records. that's the concern here

Avatar

Level 2

When using limit as ZERO, I'm able to get more than 50,000 records. 

 

Hope it works for my use case since able to get 5 million records

 

Thanks @Danny-Miller !!!

Avatar

Level 1

Thank you. This simplified my work to pull 55 K rows.