How to fetch more than 50000 records from Adobe postgres DB through java application (jdbc)
Solved! Go to Solution.
Views
Replies
Total Likes
@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
If you need to fetch more rows you may want to consider other approaches:
If you have a use case we might be able to guide you better.
What is your use case?
Danny
@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
If you need to fetch more rows you may want to consider other approaches:
If you have a use case we might be able to guide you better.
What is your use case?
Danny
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
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 !!!
Thank you. This simplified my work to pull 55 K rows.
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Like
Replies
Views
Likes
Replies