Database Argument Setter

The Database Argument Setter action plugin is available in the Hub.

Action that converts table column into pipeline arguments.

The action can be used whenever you want to pass data from database as arguments to a data pipeline. For example, you may want to read a particular table at runtime to set arguments for the pipeline.

Configuration

Property	Macro Enabled?	Description

Property	Macro Enabled?	Description
Plugin Name	No	Required. Name of the JDBC driver to use.
Connection String	Yes	Required. JDBC connection string including database name.
Username	Yes	Optional. User identity for connecting to the specified database.
Password	Yes	Optional. Password to use to connect to the specified database.
Database	Yes	Required. Database name.
Table	Yes	Required. Table name.
Argument Selection Conditions	Yes	Required. A set of conditions for identifying the arguments to run a pipeline. Multiple conditions can be specified in the format column1=<column1-value>;column2=<column2-value>.
Arguments Column	Yes	Required. Name of the column that contains the arguments.
Connection Arguments	Yes	Optional. A list of arbitrary string key/value pairs as connection arguments. These arguments will be passed to the JDBC driver as connection arguments for JDBC drivers that may need additional configurations.

Example

Suppose you have a configuration management database and you want to read a particular table at runtime to set arguments for the pipeline, including the source configuration, the transformations, the sink configuration, etc.

Property	Value

Property	Value
Driver Name	`"postgres"`
Connection String	`"jdbc:postgresql://localhost:5432/configuration"`
Database	`"configuration"`
Table	`"files"`
Argument Selection Conditions	`"file_id=1"`
Arguments Column	`"file_name"`