How to solve error in Redshift query: Result exceeded maximum size (105.961MB > 100MB)

Hello,
I am trying to run a query on Redshift to display a table on my Retool App, but I get this error message:
Result exceeded maximum size (105.961MB > 100MB)
Does anyone know how can I solve this?
Thanks in advance

Hey @annafonte and welcome to the forum! It looks like your query returned too much data, and rendering it would overload the frontend. Is there a filter you can apply, or use server side pagination?

1 Like

Hey @justin :slight_smile: Thanks for you welcome and answer.
It worked with server side pagination!

1 Like