NodeAmazon Redshift Connector

Source

This node creates a connection to Amazon Redshift using the native Amazon Redshift JDBC driver. You need to provide the server's hostname (or IP address), the port, and a database name. Login credentials can either be provided directly in the configuration or via credentials set on the workflow.

For more information visit Amazon Redshift and also the AWS Forums.

Driver URL template:

This node uses the selected driver's URL template for creating the concrete database URL. For additional drivers, which are not provided by the KNIME database modules, the URL template is to be specified on the driver preferences page under KNIME/Databases. E.g.

jdbc:redshift://<host>:<port>/[database]

is a possible Redshift driver URL template.

Tokens:

  • Mandatory value (e.g. <database>):
    The referenced variable must have a non-blank value. The name between the brackets must be a valid variable name. Please refer to the variable descriptions below.
  • Optional value (e.g. [database]):
    The referenced variable may have a blank value. The name between the brackets must be a valid variable name. Please refer to the variable descriptions below.

Variables:

  • host:
    The value of the Hostname field on the Connection Settings tab.
  • port:
    The value of the Port field on the Connection Settings tab.
  • database:
    The value of the Database name field on the Connection Settings tab.

Field validation in the dialog depends on whether the (included) tokens referencing them are mandatory or optional.

Output Ports

  1. Port Type: DB Session
    Amazon Redshift connection