> ## 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.

# exportRecordsToTable

<div className="kinetica-doxygen">
  <div id="a8902bf3719689976c728b4a2de2d7199" />

  <h2 className="memtitle"><span className="permalink"><a href="#a8902bf3719689976c728b4a2de2d7199">◆ </a></span>exportRecordsToTable() <span className="overload">\[1/2]</span></h2>

  <div className="memitem">
    <div className="memproto">
      <table className="mlabels">
        <tr>
          <td className="mlabels-left">
            <table className="memname">
              <tr>
                <td className="memname"><a className="el" href="/content/api/cs/classkinetica_1_1ExportRecordsToTableResponse">ExportRecordsToTableResponse</a> kinetica.Kinetica.exportRecordsToTable </td>
                <td>(</td>
                <td className="paramtype"><a className="el" href="/content/api/cs/classkinetica_1_1ExportRecordsToTableRequest">ExportRecordsToTableRequest</a></td>
                <td className="paramname"><span className="paramname"><span className="em">request\_</span></span></td>
                <td>)</td>

                <td />
              </tr>
            </table>
          </td>

          <td className="mlabels-right"> <span className="mlabels"><span className="mlabel inline">inline</span></span> </td>
        </tr>
      </table>
    </div>

    <div className="memdoc">
      <p>Exports records from source table to the specified target table in an external database. </p>

      <div className="dl params">
        <div className="dt">Parameters</div>

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramname">request\_</td>
              <td>Request object containing the parameters for the operation.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd">Response object containing the result of the operation. </div>
      </div>

      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs#L36000">36000</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs">KineticaFunctions.cs</a>.</p>
    </div>
  </div>

  <div id="adb2f09914b5a2e4fd90e09f1aa28b1b3" />

  <h2 className="memtitle"><span className="permalink"><a href="#adb2f09914b5a2e4fd90e09f1aa28b1b3">◆ </a></span>exportRecordsToTable() <span className="overload">\[2/2]</span></h2>

  <div className="memitem">
    <div className="memproto">
      <table className="mlabels">
        <tr>
          <td className="mlabels-left">
            <table className="memname">
              <tr>
                <td className="memname"><a className="el" href="/content/api/cs/classkinetica_1_1ExportRecordsToTableResponse">ExportRecordsToTableResponse</a> kinetica.Kinetica.exportRecordsToTable </td>
                <td>(</td>
                <td className="paramtype">string</td>
                <td className="paramname"><span className="paramname"><span className="em">table\_name</span></span>, </td>
              </tr>

              <tr>
                <td className="paramkey" />

                <td />

                <td className="paramtype">string</td>
                <td className="paramname"><span className="paramname"><span className="em">remote\_query</span></span><span className="paramdefsep"> = </span><span className="paramdefval">""</span>, </td>
              </tr>

              <tr>
                <td className="paramkey" />

                <td />

                <td className="paramtype">IDictionary\< string, string ></td>
                <td className="paramname"><span className="paramname"><span className="em">options</span></span><span className="paramdefsep"> = </span><span className="paramdefval">null</span> )</td>
              </tr>
            </table>
          </td>

          <td className="mlabels-right"> <span className="mlabels"><span className="mlabel inline">inline</span></span> </td>
        </tr>
      </table>
    </div>

    <div className="memdoc">
      <p>Exports records from source table to the specified target table in an external database. </p>

      <div className="dl params">
        <div className="dt">Parameters</div>

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramname">table\_name</td>
              <td>Name of the table from which the data will be exported to remote database, in \[schema\_name.]table\_name format, using standard <a href="/content/concepts/tables/#table-name-resolution" target="_top">name resolution rules</a>.</td>
            </tr>

            <tr>
              <td className="paramname">remote\_query</td>
              <td>Parameterized insert query to export gpudb table data into remote database. The default value is ''.</td>
            </tr>

            <tr>
              <td className="paramname">options</td>

              <td>
                Optional parameters.

                <ul>
                  <li> <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#a68f2173feb108034f17033850ba78c26">BATCH\_SIZE</a>: Batch size, which determines how many rows to export per round trip. The default value is '200000'. </li>
                  <li> <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#a6d73b8ca506ca025b2cc66b855ad8346">DATASINK\_NAME</a>: Name of an existing external data sink to which table name specified in <span className="em">table\_name</span> will be exported. </li>
                  <li> <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#ad492bdbb2f3b2e0f3717942658379ae1">JDBC\_SESSION\_INIT\_STATEMENT</a>: Executes the statement per each JDBC session before doing actual load. The default value is ''. </li>
                  <li> <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#a11ab4e51655d09453ed4d6d5b79d517a">JDBC\_CONNECTION\_INIT\_STATEMENT</a>: Executes the statement once before doing actual load. The default value is ''. </li>
                  <li> <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#a6262d57300e525d781b1a0887fbece95">REMOTE\_TABLE</a>: Name of the target table to which source table is exported. When this option is specified remote\_query cannot be specified. The default value is ''. </li>

                  <li>
                    <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#a267012cc13a395c0d917901363954279">USE\_ST\_GEOMFROM\_CASTS</a>: Wraps parameterized variables with st\_geomfromtext or st\_geomfromwkb based on source column type. Supported values:

                    <ul>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#a3ed4ecc36bee458eb855ba1d1c3c9572">TRUE</a> </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#ab8478437c6e5cd24b7ea41f95f1e57d3">FALSE</a> </li>
                    </ul>

                    The default value is <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#ab8478437c6e5cd24b7ea41f95f1e57d3">FALSE</a>.
                  </li>

                  <li>
                    <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#a6fc0a2f21153f30fd3ae026027d2cc97">USE\_INDEXED\_PARAMETERS</a>: Uses \$n style syntax when generating insert query for remote\_table option. Supported values:

                    <ul>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#a3ed4ecc36bee458eb855ba1d1c3c9572">TRUE</a> </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#ab8478437c6e5cd24b7ea41f95f1e57d3">FALSE</a> </li>
                    </ul>

                    The default value is <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#ab8478437c6e5cd24b7ea41f95f1e57d3">FALSE</a>.
                  </li>
                </ul>

                The default value is an empty Dictionary.
              </td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd">Response object containing the result of the operation. </div>
      </div>

      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs#L36124">36124</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs">KineticaFunctions.cs</a>.</p>
    </div>
  </div>

  <div id="a12d8722b1b003ae335421b12c5fd4236" />

  <h2 className="memtitle"><span className="permalink"><a href="#a12d8722b1b003ae335421b12c5fd4236">◆ </a></span>ExportRecordsToTableAsync() <span className="overload">\[1/2]</span></h2>

  <div className="memitem">
    <div className="memproto">
      <table className="mlabels">
        <tr>
          <td className="mlabels-left">
            <table className="memname">
              <tr>
                <td className="memname">async System.Threading.Tasks.Task\< <a className="el" href="/content/api/cs/classkinetica_1_1ExportRecordsToTableResponse">ExportRecordsToTableResponse</a> > kinetica.Kinetica.ExportRecordsToTableAsync </td>
                <td>(</td>
                <td className="paramtype"><a className="el" href="/content/api/cs/classkinetica_1_1ExportRecordsToTableRequest">ExportRecordsToTableRequest</a></td>
                <td className="paramname"><span className="paramname"><span className="em">request\_</span></span>, </td>
              </tr>

              <tr>
                <td className="paramkey" />

                <td />

                <td className="paramtype">System.Threading.CancellationToken</td>
                <td className="paramname"><span className="paramname"><span className="em">cancellationToken</span></span><span className="paramdefsep"> = </span><span className="paramdefval">default</span> )</td>
              </tr>
            </table>
          </td>

          <td className="mlabels-right"> <span className="mlabels"><span className="mlabel inline">inline</span></span> </td>
        </tr>
      </table>
    </div>

    <div className="memdoc">
      <p>Exports records from source table to the specified target table in an external database. </p>
      <p>(async)</p>

      <div className="dl params">
        <div className="dt">Parameters</div>

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramname">request\_</td>
              <td>Request object containing the parameters for the operation.</td>
            </tr>

            <tr>
              <td className="paramname">cancellationToken</td>
              <td>Cancellation token to cancel the operation.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd">Task that returns the response object containing the result of the operation.</div>
      </div>

      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs#L36016">36016</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs">KineticaFunctions.cs</a>.</p>
    </div>
  </div>

  <div id="a0b773583b22133fef77bf794b1cecb99" />

  <h2 className="memtitle"><span className="permalink"><a href="#a0b773583b22133fef77bf794b1cecb99">◆ </a></span>ExportRecordsToTableAsync() <span className="overload">\[2/2]</span></h2>

  <div className="memitem">
    <div className="memproto">
      <table className="mlabels">
        <tr>
          <td className="mlabels-left">
            <table className="memname">
              <tr>
                <td className="memname">async System.Threading.Tasks.Task\< <a className="el" href="/content/api/cs/classkinetica_1_1ExportRecordsToTableResponse">ExportRecordsToTableResponse</a> > kinetica.Kinetica.ExportRecordsToTableAsync </td>
                <td>(</td>
                <td className="paramtype">string</td>
                <td className="paramname"><span className="paramname"><span className="em">table\_name</span></span>, </td>
              </tr>

              <tr>
                <td className="paramkey" />

                <td />

                <td className="paramtype">string</td>
                <td className="paramname"><span className="paramname"><span className="em">remote\_query</span></span><span className="paramdefsep"> = </span><span className="paramdefval">""</span>, </td>
              </tr>

              <tr>
                <td className="paramkey" />

                <td />

                <td className="paramtype">IDictionary\< string, string ></td>
                <td className="paramname"><span className="paramname"><span className="em">options</span></span><span className="paramdefsep"> = </span><span className="paramdefval">null</span>, </td>
              </tr>

              <tr>
                <td className="paramkey" />

                <td />

                <td className="paramtype">System.Threading.CancellationToken</td>
                <td className="paramname"><span className="paramname"><span className="em">cancellationToken</span></span><span className="paramdefsep"> = </span><span className="paramdefval">default</span> )</td>
              </tr>
            </table>
          </td>

          <td className="mlabels-right"> <span className="mlabels"><span className="mlabel inline">inline</span></span> </td>
        </tr>
      </table>
    </div>

    <div className="memdoc">
      <p>Exports records from source table to the specified target table in an external database. </p>
      <p>(async)</p>

      <div className="dl params">
        <div className="dt">Parameters</div>

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramname">table\_name</td>
              <td>Name of the table from which the data will be exported to remote database, in \[schema\_name.]table\_name format, using standard <a href="/content/concepts/tables/#table-name-resolution" target="_top">name resolution rules</a>.</td>
            </tr>

            <tr>
              <td className="paramname">remote\_query</td>
              <td>Parameterized insert query to export gpudb table data into remote database. The default value is ''.</td>
            </tr>

            <tr>
              <td className="paramname">options</td>

              <td>
                Optional parameters.

                <ul>
                  <li> <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#a68f2173feb108034f17033850ba78c26">BATCH\_SIZE</a>: Batch size, which determines how many rows to export per round trip. The default value is '200000'. </li>
                  <li> <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#a6d73b8ca506ca025b2cc66b855ad8346">DATASINK\_NAME</a>: Name of an existing external data sink to which table name specified in <span className="em">table\_name</span> will be exported. </li>
                  <li> <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#ad492bdbb2f3b2e0f3717942658379ae1">JDBC\_SESSION\_INIT\_STATEMENT</a>: Executes the statement per each JDBC session before doing actual load. The default value is ''. </li>
                  <li> <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#a11ab4e51655d09453ed4d6d5b79d517a">JDBC\_CONNECTION\_INIT\_STATEMENT</a>: Executes the statement once before doing actual load. The default value is ''. </li>
                  <li> <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#a6262d57300e525d781b1a0887fbece95">REMOTE\_TABLE</a>: Name of the target table to which source table is exported. When this option is specified remote\_query cannot be specified. The default value is ''. </li>

                  <li>
                    <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#a267012cc13a395c0d917901363954279">USE\_ST\_GEOMFROM\_CASTS</a>: Wraps parameterized variables with st\_geomfromtext or st\_geomfromwkb based on source column type. Supported values:

                    <ul>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#a3ed4ecc36bee458eb855ba1d1c3c9572">TRUE</a> </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#ab8478437c6e5cd24b7ea41f95f1e57d3">FALSE</a> </li>
                    </ul>

                    The default value is <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#ab8478437c6e5cd24b7ea41f95f1e57d3">FALSE</a>.
                  </li>

                  <li>
                    <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#a6fc0a2f21153f30fd3ae026027d2cc97">USE\_INDEXED\_PARAMETERS</a>: Uses \$n style syntax when generating insert query for remote\_table option. Supported values:

                    <ul>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#a3ed4ecc36bee458eb855ba1d1c3c9572">TRUE</a> </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#ab8478437c6e5cd24b7ea41f95f1e57d3">FALSE</a> </li>
                    </ul>

                    The default value is <a className="el" href="/content/api/cs/structkinetica_1_1ExportRecordsToTableRequest_1_1Options#ab8478437c6e5cd24b7ea41f95f1e57d3">FALSE</a>.
                  </li>
                </ul>

                The default value is an empty Dictionary.
              </td>
            </tr>

            <tr>
              <td className="paramname">cancellationToken</td>
              <td>Cancellation token to cancel the operation.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd">Task that returns the response object containing the result of the operation.</div>
      </div>

      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs#L36235">36235</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs">KineticaFunctions.cs</a>.</p>
    </div>
  </div>
</div>