> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# gpudbsqliterator

> gpudbsqliterator — Kinetica Python API

<div className="kinetica-pydoc">
  <div itemprop="articleBody">
    <div id="class-gpudbsqliterator" className="section">
      <h1>Class GPUdbSqlIterator</h1>

      <div className="dl py class">
        <div className="dt sig sig-object py" id="gpudb.GPUdbSqlIterator"> <span className="em property"><span className="k"><span className="pre">class</span></span><span className="w"> </span></span><span className="sig-prename descclassname"><span className="pre">gpudb.</span></span><span className="sig-name descname"><span className="pre">GPUdbSqlIterator</span></span><span className="sig-paren">(</span><span className="em sig-param"><span className="n"><span className="pre">db</span></span><span className="p"><span className="pre">:</span></span><span className="w"> </span><span className="n"><a className="reference internal" href="/content/api/python/source/gpudb#gpudb.GPUdb" title="gpudb.GPUdb"><span className="pre">GPUdb</span></a></span></span>, <span className="em sig-param"><span className="n"><span className="pre">sql</span></span><span className="p"><span className="pre">:</span></span><span className="w"> </span><span className="n"><span className="pre">str</span></span></span>, <span className="em sig-param"><span className="n"><span className="pre">batch\_size</span></span><span className="p"><span className="pre">:</span></span><span className="w"> </span><span className="n"><span className="pre">int</span></span><span className="w"> </span><span className="o"><span className="pre">=</span></span><span className="w"> </span><span className="default_value"><span className="pre">5000</span></span></span>, <span className="em sig-param"><span className="n"><span className="pre">sql\_params</span></span><span className="o"><span className="pre">=</span></span><span className="default_value"><span className="pre">\[]</span></span></span>, <span className="em sig-param"><span className="n"><span className="pre">sql\_opts</span></span><span className="p"><span className="pre">:</span></span><span className="w"> </span><span className="n"><span className="pre">dict</span></span><span className="w"> </span><span className="o"><span className="pre">=</span></span><span className="w"> </span><span className="default_value"><span className="pre">{"{"}{"}"}</span></span></span><span className="sig-paren">)</span></div>

        <div className="dd">
          <p>Iterates over the records of a given query.</p>
          <p>Example</p>

          <div className="highlight-default notranslate">
            ```
            result_list = []
            with GPUdbSqlIterator(db, sql,
                                  batch_size=batch_size,
                                  sql_opts=sql_opts) as sql_iter:

                for rec in tqdm(iterable=sql_iter,
                                total=sql_iter.total_count,
                                desc='Fetching Records',
                                disable=(not show_progress),
                                ncols=cls.TQDM_NCOLS):
                    result_list.append(rec)
            ```
          </div>
        </div>
      </div>
    </div>
  </div>
</div>