/alter/datasink

URL: http://GPUDB_IP_ADDRESS:GPUDB_PORT/alter/datasink

Alters the properties of an existing data sink

Input Parameter Description

Name Type Description
name string Name of the data sink to be altered. Must be an existing data sink.
datasink_updates_map map of string to strings

Map containing the properties of the data sink to be updated. Error if empty.

Supported Parameters (keys) Parameter Description
destination Destination for the output data in format 'destination_type://path[:port]'. Supported destination types are 'http', 'https' and 'kafka'.
connection_timeout Timeout in seconds for connecting to this sink
wait_timeout Timeout in seconds for waiting for a response from this sink
credential Name of the credential object to be used in this data sink
kafka_topic_name Name of the Kafka topic to use for this data sink, if it references a Kafka broker
max_batch_size Maximum number of records per notification message. The default value is '1'.
max_message_size Maximum size in bytes of each notification message. The default value is '1000000'.
json_format

The desired format of JSON encoded notifications message. If nested, records are returned as an array. Otherwise, only a single record per messages is returned. The default value is flat. The supported values are:

  • flat
  • nested
skip_validation

Bypass validation of connection to this data sink. The default value is false. The supported values are:

  • true
  • false
schema_name Updates the schema name. If schema_name doesn't exist, an error will be thrown. If schema_name is empty, then the user's default schema will be used.
options map of string to strings Optional parameters.

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 'alter_datasink_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 /alter/datasink endpoint:

Name Type Description
updated_properties_map map of string to strings Map of values updated
info map of string to strings Additional information.

Empty string in case of an error.