Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.

Prefect Community

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?

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

Thanks! Not sure how I missed `fetch_all`.