# Table.to\_arrow\_batch\_iterator

### Table.<mark style="color:purple;">to\_arrow\_batch\_iterator</mark>(*max\_results=None, \*, variables=None, progress=True*) → [pyarrow.RecordBatch](https://arrow.apache.org/docs/python/generated/pyarrow.RecordBatch.html) iterator

Returns an iterator that can be used to consume a table in chunks of PyArrow RecordBatches. Allows for streaming workflows where only a small portion of the table is read into memory at a time.

{% hint style="info" %}
Also callable on [Queries](https://docs.redivis.com/api/client-libraries/redivis-python/reference/query) and [Uploads](https://docs.redivis.com/api/client-libraries/redivis-python/reference/upload) →  

`query.to_arrow_batch_iterator(...)` | `upload.to_arrow_batch_iterator(...)`
{% endhint %}

### **Parameters:**&#x20;

**`max_results` :&#x20;*****int, default None*** \
The maximum number of rows to return. If not specified, all rows in the table will be read.&#x20;

**`variables` :&#x20;*****list\<str>, default None***\
A list of variable names to read, improving performance when not all variables are needed. If unspecified, all variables will be represented in the returned rows. Variable names are case-insensitive, though the names in the results will reflect the variable's true casing. The order of the columns returned will correspond to the order of names in this list.

**`progress` :&#x20;*****bool, default True***\
Whether to show a progress ba&#x72;**.**&#x20;

### **Yields:**&#x20;

[**pyarrow.RecordBatch**](https://arrow.apache.org/docs/python/generated/pyarrow.RecordBatch.html)

{% hint style="success" %}
**See also**

* [Table.to\_arrow\_dataset()](https://docs.redivis.com/api/client-libraries/redivis-python/reference/table/table.to_arrow_dataset)
* [Table.to\_arrow\_table()](https://docs.redivis.com/api/client-libraries/redivis-python/reference/table/table.to_arrow_table)
* [Table.to\_geopandas\_dataframe()](https://docs.redivis.com/api/client-libraries/redivis-python/reference/table/table.to_geopandas_dataframe)
* [Table.to\_dask\_dataframe()](https://docs.redivis.com/api/client-libraries/redivis-python/reference/table/table.to_dask_dataframe)
* [Table.to\_pandas\_dataframe()](https://docs.redivis.com/api/client-libraries/redivis-python/reference/table/table.to_pandas_dataframe)
* [Table.to\_polars\_lazyframe()](https://docs.redivis.com/api/client-libraries/redivis-python/reference/table/table.to_polars_lazyframe)
  {% endhint %}