/export/records/totable

URL: http://GPUDB_IP_ADDRESS:GPUDB_PORT/export/records/totable

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

Input Parameter Description

Name Type Description
table_name string 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 string Parameterized insert query to export gpudb table data into remote database
options map of string to strings

Optional parameters. The default value is an empty map ( {} ).

Supported Parameters (keys) Parameter Description
batch_size Batch size, which determines how many rows to export per round trip.
datasink_name Name of an existing external data sink to which table name specified in input parameter table_name will be exported

Output Parameter Description

The GPUdb server embeds the endpoint response inside a standard response structure which contains status information and the actual response to the query. Here is a description of the various fields of the wrapper:

Name Type Description
status String 'OK' or 'ERROR'
message String Empty if success or an error message
data_type String 'export_records_to_table_response' or 'none' in case of an error
data String Empty string
data_str JSON or String

This embedded JSON represents the result of the /export/records/totable endpoint:

Name Type Description
table_name string 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 map of string to strings Additional information.

Empty string in case of an error.