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"

Created in 2020 by Google Inc.