Hi there I am using `prefect sqlalchemy` and have set up a `

Question

Hi there I am using `prefect sqlalchemy` and have set up a `SqlAlchemyConnector` block However I notice that there is an Optional fetch size that defaults to 1 and impacts my queries eg `fetch many` Is there a way to prevent this fetch size from being enforced especially if I don t know how many rows I am retrieving beforehand

Andrew Huang · Answer

Maybe you can try using fetch all

Andrew Huang · Answer

Or you can use a while loop to keep fetching the rows in batches like in the examples

Dylan Lim · Answer

Thanks Not sure how I missed `fetch all`