Appendix C. Built-in Variables and Properties Reference

This appendix starts with a description of all the internal variables that are set automatically by Kettle. That is followed by a list of all the variables that you can set to influence the way that Kettle operates at run-time. Next, we discuss how you can define variables to help secure FTP authentication using VFS. Finally, we mention a few noteworthy variables from the Java Runtime Environment.

For more information on how to use variables, see Chapter 2.

Internal Variables

Table C-1 shows all the variables that are defined at run-time by the Kettle transformation or job engine.

Table C.1. Internal Variables




This contains the version string of Kettle, for example, 4.0.0.


This contains the subversion revision of the Kettle source of the build you're using.


The build date.


If you are running a job from a file (.kjb), this variable will contain the folder in which that file is located. This variable allows you to specify other jobs, transformations, and files in a relative fashion.


If you are running a job from a file (.kjb), this variable will contain the name of that file.


The name of the currently executing parent job.


If you are running a job from a repository, this variable will contain the path to the repository directory from which ...

Get Pentaho® Kettle Solutions: Building Open Source ETL Solutions with Pentaho Data Integration now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.