> ## 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. # kinetica.ExportRecordsToTableRequest > kinetica.ExportRecordsToTableRequest — Kinetica C# API

A set of parameters for Kinetica.exportRecordsToTable. More...

Inheritance diagram for kinetica.ExportRecordsToTableRequest:
Collaboration diagram for kinetica.ExportRecordsToTableRequest:

Classes
struct   Options
  A set of string constants for the parameter ExportRecordsToTableRequest.options. More...
 

Public Member Functions
  ExportRecordsToTableRequest ()
  Constructs an ExportRecordsToTableRequest object with default parameters.
 
  ExportRecordsToTableRequest (string table\_name, string remote\_query=null, IDictionary\< string, string > options=null)
  Constructs an ExportRecordsToTableRequest object with the specified parameters.
 
  ExportRecordsToTableRequest ()
  Constructs an ExportRecordsToTableRequest object with default parameters.
 
  ExportRecordsToTableRequest (string table\_name, string remote\_query=null, IDictionary\< string, string > options=null)
  Constructs an ExportRecordsToTableRequest object with the specified parameters.
 
 Public Member Functions inherited from kinetica.KineticaData
  KineticaData (KineticaType type)
  Constructor from Kinetica Type.
 
  KineticaData (System.Type type=null)
  Default constructor, with optional System.Type.
 
object  Get (int fieldPos)
  Retrieve a specific property from this object.
 
void  Put (int fieldPos, object fieldValue)
  Write a specific property to this object.
 
  KineticaData (KineticaType type)
  Constructor from Kinetica Type.
 
  KineticaData (System.Type type=null)
  Default constructor, with optional System.Type.
 
object  Get (int fieldPos)
  Retrieve a specific property from this object.
 
void  Put (int fieldPos, object fieldValue)
  Write a specific property to this object.
 

Properties
string  table\_name \[get, set]
  Name of the table from which the data will be exported to remote database, in \[schema\_name.
 
string  remote\_query = "" \[get, set]
  Parameterized insert query to export gpudb table data into remote database.
 
IDictionary\< string, string >  options = new Dictionary\() \[get, set]
  Optional parameters.
 
 Properties inherited from kinetica.KineticaData
Schema  Schema \[get]
  Avro Schema for this class.
 

Additional Inherited Members
 Static Public Member Functions inherited from kinetica.KineticaData
static ? RecordSchema  SchemaFromType (System.Type t, KineticaType? ktype=null)
  Create an Avro Schema from a System.Type and a KineticaType.
 
static ? RecordSchema  SchemaFromType (System.Type t, KineticaType? ktype=null)
  Create an Avro Schema from a System.Type and a KineticaType.
 

Detailed Description

A set of parameters for Kinetica.exportRecordsToTable.

Exports records from source table to the specified target table in an external database.

Definition at line 16 of file ExportRecordsToTable.cs.

Constructor & Destructor Documentation

◆ ExportRecordsToTableRequest() \[1/4]

kinetica.ExportRecordsToTableRequest.ExportRecordsToTableRequest ( )
inline

Constructs an ExportRecordsToTableRequest object with default parameters.

Definition at line 203 of file ExportRecordsToTable.cs.

◆ ExportRecordsToTableRequest() \[2/4]

kinetica.ExportRecordsToTableRequest.ExportRecordsToTableRequest ( string table\_name,
string remote\_query = null,
IDictionary\< string, string > options = null )
inline

Constructs an ExportRecordsToTableRequest object with the specified parameters.

Parameters
table\_name Name of the table from which the data will be exported to remote database, in \[schema\_name.]table\_name format, using standard name resolution rules.
remote\_query Parameterized insert query to export gpudb table data into remote database. The default value is ''.
options Optional parameters.
  • BATCH\_SIZE: Batch size, which determines how many rows to export per round trip. The default value is '200000'.
  • DATASINK\_NAME: Name of an existing external data sink to which table name specified in table\_name will be exported.
  • JDBC\_SESSION\_INIT\_STATEMENT: Executes the statement per each JDBC session before doing actual load. The default value is ''.
  • JDBC\_CONNECTION\_INIT\_STATEMENT: Executes the statement once before doing actual load. The default value is ''.
  • REMOTE\_TABLE: 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 ''.
  • USE\_ST\_GEOMFROM\_CASTS: Wraps parameterized variables with st\_geomfromtext or st\_geomfromwkb based on source column type. Supported values: The default value is FALSE.
  • USE\_INDEXED\_PARAMETERS: Uses \$n style syntax when generating insert query for remote\_table option. Supported values: The default value is FALSE.
The default value is an empty Dictionary.

Definition at line 303 of file ExportRecordsToTable.cs.

◆ ExportRecordsToTableRequest() \[3/4]

kinetica.ExportRecordsToTableRequest.ExportRecordsToTableRequest ( )
inline

Constructs an ExportRecordsToTableRequest object with default parameters.

Definition at line 203 of file ExportRecordsToTable.cs.

◆ ExportRecordsToTableRequest() \[4/4]

kinetica.ExportRecordsToTableRequest.ExportRecordsToTableRequest ( string table\_name,
string remote\_query = null,
IDictionary\< string, string > options = null )
inline

Constructs an ExportRecordsToTableRequest object with the specified parameters.

Parameters
table\_name Name of the table from which the data will be exported to remote database, in \[schema\_name.]table\_name format, using standard name resolution rules.
remote\_query Parameterized insert query to export gpudb table data into remote database. The default value is ''.
options Optional parameters.
  • BATCH\_SIZE: Batch size, which determines how many rows to export per round trip. The default value is '200000'.
  • DATASINK\_NAME: Name of an existing external data sink to which table name specified in table\_name will be exported.
  • JDBC\_SESSION\_INIT\_STATEMENT: Executes the statement per each JDBC session before doing actual load. The default value is ''.
  • JDBC\_CONNECTION\_INIT\_STATEMENT: Executes the statement once before doing actual load. The default value is ''.
  • REMOTE\_TABLE: 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 ''.
  • USE\_ST\_GEOMFROM\_CASTS: Wraps parameterized variables with st\_geomfromtext or st\_geomfromwkb based on source column type. Supported values: The default value is FALSE.
  • USE\_INDEXED\_PARAMETERS: Uses \$n style syntax when generating insert query for remote\_table option. Supported values: The default value is FALSE.
The default value is an empty Dictionary.

Definition at line 303 of file ExportRecordsToTable.cs.

Property Documentation

◆ options

IDictionary\< string, string > kinetica.ExportRecordsToTableRequest.options = new Dictionary\()
getset

Optional parameters.

The default value is an empty Dictionary.

Definition at line 199 of file ExportRecordsToTable.cs.

◆ remote\_query

string kinetica.ExportRecordsToTableRequest.remote\_query = ""
getset

Parameterized insert query to export gpudb table data into remote database.

The default value is ''.

Definition at line 107 of file ExportRecordsToTable.cs.

◆ table\_name

string kinetica.ExportRecordsToTableRequest.table\_name
getset

Name of the table from which the data will be exported to remote database, in \[schema\_name.

]table\_name format, using standard name resolution rules.

Definition at line 102 of file ExportRecordsToTable.cs.

The documentation for this class was generated from the following files: