Ctrlk
Try Pentaho! - Start your 30 day evaluation today
For the complete documentation index, see llms.txt. This page is also available as Markdown.

Steps supporting metadata injection

The ETL Metadata Injection step inserts metadata into your template transformation through a step that supports metadata injection. See the ETL metadata injection article for details on how metadata is injected or if you are not familiar with the term "template transformation".

The following table specifies which steps contain fields supporting metadata injection:

Step
Version Introduced
Fields Supporting Metadata Injection

Add XML

7.0

All fields

Add a Checksum

8.2

All fields

Annotate Stream

7.0

All fields

AMQP Consumer

8.2

All fields

AMQP Producer

8.2

All fields

Append Streams

7.0

All fields

Avro Input

7.0

All fields

Avro Output

8.0

All fields

Cassandra Input

7.0

All fields

Cassandra Output

7.0

All fields

Combination Lookup / Update

7.0

All fields

Concat Fields

5.1

All fields

Copybook Input

9.0

All fields

CouchDB Input

7.0

All fields

CSV File Input

4.1

See CSV File Input for a list of supported fields

Data Grid

5.1

All fields

Data Validator

7.0

All fields

Delete

9.0

All fields

Dimension Lookup-Update

7.1

All fields

ETL metadata injection

7.0

All fields. See Injecting metadata into the ETL Metadata Injection step for exceptions.

Execute Row SQL Script

8.2

All fields

Execute SQL Script

8.2

All fields

Filter Rows

7.0

All fields

Fixed File Input

4.1

See Fixed File Input for a list of supported fields

Get Data from XML

5.0

See Get Data from XML for a list of supported fields

Get records from stream

8.0

All fields

Get rows from result

8.0

All fields

Get System Info

8.2

All fields

Get Table Names

7.0

All fields

Get Variable

7.0

All fields

Google Analytics

6.1

All fields

Greenplum Load

7.0

All fields

Group By

5.0

All fields

GZIP CSV Input

5.1

All fields

Hadoop File Input

7.0

All fields

Hadoop File Output

7.0

All fields

HBase Input

7.0

All fields

HBase Output

7.0

All fields

HBase Row Decoder

7.0

All fields

If Field Value is Null

7.0

All fields

Insert/Update

7.0

All fields

JMS Consumer

8.2

All fields

JMS Producer

8.2

All fields

Join Rows (Cartesian product)

7.0

All fields

JSON Input

7.0

All fields

JSON Output

5.2

All fields

Kafka consumer

8.0

All fields

Kafka Producer

8.0

All fields

Kinesis Consumer

8.3

All fields

Kinesis Producer

8.3

All fields

MapReduce Input

7.0

All fields

MapReduce Output

7.0

All fields

Memory Group By

7.0

All fields

Merge Join

7.0

All fields

Merge rows (diff)

7.0

All fields

Microsoft Access Input

5.0

See Microsoft Access Input for a list of supported fields

Microsoft Excel Input

4.1

See Microsoft Excel Input for a list of supported fields

Microsoft Excel Output

5.1

All fields (as of 6.1)

Microsoft Excel Writer

5.3

See Microsoft Excel Writer for a list of supported fields

MongoDB Input

7.0

All fields

MongoDB Output

7.0

All fields

MQTT Consumer

8.1

All fields

MQTT Producer

8.1

All fields

Multiway Merge Join

7.0

All fields

MySQL Bulk Loader

7.0

All fields

Null If

7.0

All fields

Oracle Bulk Loader

7.0

All fields

ORC Input

8.1

All fields

ORC Output

8.1

All fields

Parquet Input

8.0

All fields

Parquet Output

8.0

All fields

Pentaho Reporting Output

5.0

All fields

PostgreSQL Bulk Loader

5.1

All fields

Read metadata from Copybook

9.0

All fields

Replace in String

7.0

All fields

Row Denormaliser

4.2

All fields (as of 7.0)

Row Normaliser

4.2

See Row Normaliser for a list of supported fields

S3 CSV Input

6.1

All fields

S3 File Output

6.1

All fields

Salesforce Input

8.3

All fields

Select Values

4.1

All fields

Set Field Value

8.2

All fields

Set Field Value to a Constant

8.2

All fields

Shared Dimension

7.0

All fields

Sort rows

5.0

All fields

Sorted Merge

7.0

All fields

Split Fields

5.0

All fields (as of 6.1)

Splunk Input

7.0

All fields

Splunk Output

7.0

All fields

Stream Lookup

6.1

All fields

String Operations

9.0

All fields

Strings cut

8.3

All fields

Switch / Case

7.0

All fields

Synchronize After Merge

7.0

All fields

Table Input

5.2

See Table Input for a list of supported fields

Table Output

5.1

See Table Output for a list of supported fields

Text File Input

5.0

All fields

Text File Output

5.2

All fields

Update

7.0

All fields

User Defined Java Class

8.2

All fields

User Defined Java Expression

5.2

All fields

Value Mapper

6.1

All fields

Vertica Bulk Loader

7.0

All fields

XML Join

7.0

All fields

XML Output

6.1

All fields

PreviousVideoNextExecute Row SQL Script

Last updated

Was this helpful?