How to increase row select permission limit?

[danielhangan]

I am trying to fetch some data from a python server. And I cannot bypass the row select permission limit.

Things I did:

1. Set a new role for my table.
2. Increased 'Limit number of rows' from 1000 to 5000
3. Added x-hasura-role in headers
4. Checked if the table has more than 1000 rows (Yes)
5. added limit param to my query.

After all this I still get 1000 rows only.
It does work when I set row select permission lower than 1000. That works.
But when I try to increase to more than 1000 it never works.

The connection is a bigquery instance (idk if that helps).

What should I do? what am i missing?

Thanks!