Database Impact Input Database Impact Input

Description

The Database Impact Input transform allows gives you the impact of a pipeline on a database. It explains which transforms read, write, update or delete information, in which table, the SQL used, and so on.

This transform supports error handling. You can add an error handling hop to a transform to be informed of the pipelines that throw an error when calculating the database impact. See also: Pipeline error handling.

Supported Engines

Hop Engine

Supported

Spark

Supported

Flink

Supported

Dataflow

Supported

Options

Option

Description

Transform name

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

File name field

The name of the field in the transform input which will contain the filenames to analyze the database impact for.

You can use a Get File Names transform as input. To search for your project pipelines specify folder ${PROJECT_HOME} with wildcard .*\.hpl$.

Output fields

Fieldname

Type

Type

String

PipelineName

String

PipelineFileName

String

TransformName

String

DatabaseName

String

DatabaseTable

String

TableField

String

FieldName

String

FieldOrigin

String

SQL

String

Remark

String