Hi @tomm, we don't set a limit for how many rows you can get from Airtable. The query size limit on Retool is 100MB, which can be well over a million rows depending on datatypes.
if the following is true:
This would be a limitation on Airtable's end, not on Retool. The workarounds you've found, including @jg80's approach, are using the power of Retool to go around it. But perhaps Airtable offers a different paid plan where such limitation is not present.