export\_records\_to\_table(table\_name=None, remote\_query='', options={"{"}{"}"})\[source]

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

Parameters

table\_name (str) –

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 (str) –

Parameterized insert query to export gpudb table data into remote database. The default value is ‘’.

options (dict of str to str) –

Optional parameters. Allowed keys are:

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 input parameter 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. Allowed values are:
- true
- false
The default value is ‘false’.
use\_indexed\_parameters – Uses \$n style syntax when generating insert query for remote\_table option. Allowed values are:
- true
- false
The default value is ‘false’.

The default value is an empty dict ( {"{"}{"}"} ).

Returns

A dict with the following entries–

table\_name (str) –

Value of input parameter table\_name.

count\_inserted (long) –

Number of records inserted into the target table.

count\_skipped (long) –

Number of records skipped.

count\_updated (long) –

\[Not yet implemented] Number of records updated within the target table.

info (dict of str to str) –

Additional information.