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

# gpudb::ExportRecordsToTableRequest

> gpudb::ExportRecordsToTableRequest — Kinetica C++ API

<div className="kinetica-doxygen">
  <div className="contents">
    <p>A set of parameters for <a className="el" href="/content/api/cpp/classgpudb_1_1GPUdb#a63a3d3e6b0df86ad1a7cab47c9223904">GPUdb::exportRecordsToTable</a>. <a href="#details">More...</a></p>
    <p><code>#include \<<a className="el" href="/content/api/cpp/export__records__to__table_8h_source">gpudb/protocol/export\_records\_to\_table.h</a>></code></p>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader"> Public Member Functions</h2>
        </td>
      </tr>

      <tr className="memitem:a478c9b68423654e705e60b0afb967558" id="r_a478c9b68423654e705e60b0afb967558">
        <td className="memItemLeft" align="right" valign="top"> </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a478c9b68423654e705e60b0afb967558">ExportRecordsToTableRequest</a> ()</td>
      </tr>

      <tr className="memdesc:a478c9b68423654e705e60b0afb967558">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Constructs an <a className="el" href="/content/api/cpp/structgpudb_1_1ExportRecordsToTableRequest" title="A set of parameters for GPUdb::exportRecordsToTable.">ExportRecordsToTableRequest</a> object with default parameters. <br /></td>
      </tr>

      <tr className="separator:a478c9b68423654e705e60b0afb967558">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ad076004591c72c0788e6fd0101861ecf" id="r_ad076004591c72c0788e6fd0101861ecf">
        <td className="memItemLeft" align="right" valign="top"> </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ad076004591c72c0788e6fd0101861ecf">ExportRecordsToTableRequest</a> (const std::string \&tableName\_, const std::string \&remoteQuery\_, const std::map\< std::string, std::string > \&options\_)</td>
      </tr>

      <tr className="memdesc:ad076004591c72c0788e6fd0101861ecf">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Constructs an <a className="el" href="/content/api/cpp/structgpudb_1_1ExportRecordsToTableRequest" title="A set of parameters for GPUdb::exportRecordsToTable.">ExportRecordsToTableRequest</a> object with the specified parameters. <br /></td>
      </tr>

      <tr className="separator:ad076004591c72c0788e6fd0101861ecf">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>
    </table>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader"> Public Attributes</h2>
        </td>
      </tr>

      <tr className="memitem:aa8156b0759344071207dd5a0027b92ba" id="r_aa8156b0759344071207dd5a0027b92ba">
        <td className="memItemLeft" align="right" valign="top">std::string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#aa8156b0759344071207dd5a0027b92ba">tableName</a></td>
      </tr>

      <tr className="memdesc:aa8156b0759344071207dd5a0027b92ba">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">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>. <br /></td>
      </tr>

      <tr className="separator:aa8156b0759344071207dd5a0027b92ba">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a04dff26c0ae574f8e6c56b5d3cfb0139" id="r_a04dff26c0ae574f8e6c56b5d3cfb0139">
        <td className="memItemLeft" align="right" valign="top">std::string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a04dff26c0ae574f8e6c56b5d3cfb0139">remoteQuery</a></td>
      </tr>

      <tr className="memdesc:a04dff26c0ae574f8e6c56b5d3cfb0139">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Parameterized insert query to export gpudb table data into remote database. <br /></td>
      </tr>

      <tr className="separator:a04dff26c0ae574f8e6c56b5d3cfb0139">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a152ea5ff166214eba1ce04224c88fa46" id="r_a152ea5ff166214eba1ce04224c88fa46">
        <td className="memItemLeft" align="right" valign="top">std::map\< std::string, std::string > </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a152ea5ff166214eba1ce04224c88fa46">options</a></td>
      </tr>

      <tr className="memdesc:a152ea5ff166214eba1ce04224c88fa46">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Optional parameters. <br /></td>
      </tr>

      <tr className="separator:a152ea5ff166214eba1ce04224c88fa46">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>
    </table>

    <h2 className="groupheader">Detailed Description</h2>

    <div className="textblock">
      <p>A set of parameters for <a className="el" href="/content/api/cpp/classgpudb_1_1GPUdb#a63a3d3e6b0df86ad1a7cab47c9223904">GPUdb::exportRecordsToTable</a>. </p>
      <p>Exports records from source table to the specified target table in an external database. </p>
      <p className="definition">Definition at line <a className="el" href="/content/api/cpp/export__records__to__table_8h_source#l00019">19</a> of file <a className="el" href="/content/api/cpp/export__records__to__table_8h_source">export\_records\_to\_table.h</a>.</p>
    </div>

    <h2 className="groupheader">Constructor & Destructor Documentation</h2>
    <h2 className="memtitle"><span className="permalink"><a href="#a478c9b68423654e705e60b0afb967558">◆ </a></span>ExportRecordsToTableRequest() <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">gpudb::ExportRecordsToTableRequest::ExportRecordsToTableRequest </td>
                  <td>(</td>

                  <td className="paramname">
                    <span className="paramname">
                      <span className="em" />
                    </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>Constructs an <a className="el" href="/content/api/cpp/structgpudb_1_1ExportRecordsToTableRequest" title="A set of parameters for GPUdb::exportRecordsToTable.">ExportRecordsToTableRequest</a> object with default parameters. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cpp/export__records__to__table_8h_source#l00025">25</a> of file <a className="el" href="/content/api/cpp/export__records__to__table_8h_source">export\_records\_to\_table.h</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ad076004591c72c0788e6fd0101861ecf">◆ </a></span>ExportRecordsToTableRequest() <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">gpudb::ExportRecordsToTableRequest::ExportRecordsToTableRequest </td>
                  <td>(</td>
                  <td className="paramtype">const std::string &</td>
                  <td className="paramname"><span className="paramname"><span className="em">tableName\_</span></span>, </td>
                </tr>

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

                  <td />

                  <td className="paramtype">const std::string &</td>
                  <td className="paramname"><span className="paramname"><span className="em">remoteQuery\_</span></span>, </td>
                </tr>

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

                  <td />

                  <td className="paramtype">const std::map\< std::string, std::string > &</td>
                  <td className="paramname"><span className="paramname"><span className="em">options\_</span></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>Constructs an <a className="el" href="/content/api/cpp/structgpudb_1_1ExportRecordsToTableRequest" title="A set of parameters for GPUdb::exportRecordsToTable.">ExportRecordsToTableRequest</a> object with the specified parameters. </p>

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

          <div className="dd">
            <table className="params">
              <tr>
                <td className="paramdir">\[in]</td>
                <td className="paramname">tableName\_</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="paramdir">\[in]</td>
                <td className="paramname">remoteQuery\_</td>
                <td>Parameterized insert query to export gpudb table data into remote database. The default value is ''. </td>
              </tr>

              <tr>
                <td className="paramdir">\[in]</td>
                <td className="paramname">options\_</td>

                <td>
                  Optional parameters.

                  <ul>
                    <li> <a className="el" href="/content/api/cpp/namespacegpudb#a85d205ffa986c9b4939c8cecccdefff9">export\_records\_to\_table\_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/cpp/namespacegpudb#aa89ddb9c3c00aef1fc8e62bca0abcc76">export\_records\_to\_table\_datasink\_name</a>: Name of an existing external data sink to which table name specified in <span className="em arg">tableName\_</span> will be exported. </li>
                    <li> <a className="el" href="/content/api/cpp/namespacegpudb#ab0e8c4fce245b0147639fdd00d70705a">export\_records\_to\_table\_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/cpp/namespacegpudb#a1328bcfcd1e57695d54d30b64a08bd77">export\_records\_to\_table\_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/cpp/namespacegpudb#adf44285a6525ba4dfe899eb422c124f3">export\_records\_to\_table\_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/cpp/namespacegpudb#aa370c090a9d6859b66aa280d1bdbe448">export\_records\_to\_table\_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/cpp/namespacegpudb#a2731835102f68fdecea5fc67c6ccb1db">export\_records\_to\_table\_true</a> </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#a9e45af6d64023a232bdb904e6b7f5aca">export\_records\_to\_table\_false</a> </li>
                      </ul>

                      The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a9e45af6d64023a232bdb904e6b7f5aca">export\_records\_to\_table\_false</a>.
                    </li>

                    <li>
                      <a className="el" href="/content/api/cpp/namespacegpudb#ab9b4df6482422f94af6f70ed35943100">export\_records\_to\_table\_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/cpp/namespacegpudb#a2731835102f68fdecea5fc67c6ccb1db">export\_records\_to\_table\_true</a> </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#a9e45af6d64023a232bdb904e6b7f5aca">export\_records\_to\_table\_false</a> </li>
                      </ul>

                      The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a9e45af6d64023a232bdb904e6b7f5aca">export\_records\_to\_table\_false</a>.
                    </li>
                  </ul>

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

        <p className="definition">Definition at line <a className="el" href="/content/api/cpp/export__records__to__table_8h_source#l00116">116</a> of file <a className="el" href="/content/api/cpp/export__records__to__table_8h_source">export\_records\_to\_table.h</a>.</p>
      </div>
    </div>

    <h2 className="groupheader">Member Data Documentation</h2>
    <h2 className="memtitle"><span className="permalink"><a href="#a152ea5ff166214eba1ce04224c88fa46">◆ </a></span>options</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="memname">
          <tr>
            <td className="memname">std::map\<std::string, std::string> gpudb::ExportRecordsToTableRequest::options</td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Optional parameters. </p>

        <ul>
          <li> <a className="el" href="/content/api/cpp/namespacegpudb#a85d205ffa986c9b4939c8cecccdefff9">export\_records\_to\_table\_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/cpp/namespacegpudb#aa89ddb9c3c00aef1fc8e62bca0abcc76">export\_records\_to\_table\_datasink\_name</a>: Name of an existing external data sink to which table name specified in <a className="el" href="#aa8156b0759344071207dd5a0027b92ba">tableName</a> will be exported. </li>
          <li> <a className="el" href="/content/api/cpp/namespacegpudb#ab0e8c4fce245b0147639fdd00d70705a">export\_records\_to\_table\_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/cpp/namespacegpudb#a1328bcfcd1e57695d54d30b64a08bd77">export\_records\_to\_table\_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/cpp/namespacegpudb#adf44285a6525ba4dfe899eb422c124f3">export\_records\_to\_table\_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/cpp/namespacegpudb#aa370c090a9d6859b66aa280d1bdbe448">export\_records\_to\_table\_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/cpp/namespacegpudb#a2731835102f68fdecea5fc67c6ccb1db">export\_records\_to\_table\_true</a> </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#a9e45af6d64023a232bdb904e6b7f5aca">export\_records\_to\_table\_false</a> </li>
            </ul>

            The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a9e45af6d64023a232bdb904e6b7f5aca">export\_records\_to\_table\_false</a>.
          </li>

          <li>
            <a className="el" href="/content/api/cpp/namespacegpudb#ab9b4df6482422f94af6f70ed35943100">export\_records\_to\_table\_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/cpp/namespacegpudb#a2731835102f68fdecea5fc67c6ccb1db">export\_records\_to\_table\_true</a> </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#a9e45af6d64023a232bdb904e6b7f5aca">export\_records\_to\_table\_false</a> </li>
            </ul>

            The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a9e45af6d64023a232bdb904e6b7f5aca">export\_records\_to\_table\_false</a>.
          </li>
        </ul>

        <p>The default value is an empty map. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cpp/export__records__to__table_8h_source#l00194">194</a> of file <a className="el" href="/content/api/cpp/export__records__to__table_8h_source">export\_records\_to\_table.h</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a04dff26c0ae574f8e6c56b5d3cfb0139">◆ </a></span>remoteQuery</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="memname">
          <tr>
            <td className="memname">std::string gpudb::ExportRecordsToTableRequest::remoteQuery</td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Parameterized insert query to export gpudb table data into remote database. </p>
        <p>The default value is ''. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cpp/export__records__to__table_8h_source#l00135">135</a> of file <a className="el" href="/content/api/cpp/export__records__to__table_8h_source">export\_records\_to\_table.h</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#aa8156b0759344071207dd5a0027b92ba">◆ </a></span>tableName</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="memname">
          <tr>
            <td className="memname">std::string gpudb::ExportRecordsToTableRequest::tableName</td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>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>. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cpp/export__records__to__table_8h_source#l00129">129</a> of file <a className="el" href="/content/api/cpp/export__records__to__table_8h_source">export\_records\_to\_table.h</a>.</p>
      </div>
    </div>

    <hr />

    The documentation for this struct was generated from the following file:

    <ul>
      <li>gpudb/protocol/<a className="el" href="/content/api/cpp/export__records__to__table_8h_source">export\_records\_to\_table.h</a></li>
    </ul>
  </div>
</div>