Column exists transform Icon Column exists

Description

The Column Exists transforms allows you to verify the existence of a specific column in a database table.

Supported Engines

Hop Engine

Supported

Spark

Maybe Supported

Flink

Maybe Supported

Dataflow

Maybe Supported

Options

Option Description

Transform name

Name of the transform; This name has to be unique in a single pipeline

Connection

The database connection to use

Schema name

(optional) The schema name of the table of the column to check

Table name

The name of the table of the column to check

Tablename in field?

Enable to read the name of the table in an input field

Tablename field

Specify the fieldns containing parameters and the parameter type

Columnname field

The name of the column field in the input stream

Result fieldname

The name of the resulting boolean flag field