Pro Tips

    HOP_AUDIT_FOLDER

    Set this variable to a valid path on your machine to store Hop’s audit information. This information includes last opened files per project, zoom size and lots more.

    HOP_CONFIG_FOLDER

    Hop stores your configuration in the folder by default. Set this environment variable to point to a folder outside of your Hop installation to keep your configuration, projects and environment list etc, no matter which Hop version or installation you use.

    HOP_PLUGIN_BASE_FOLDERS

    Set this variable to point Hop to a comma separated list of folders where you want Hop to look for additional plugins.

    The variable which points to a shared folder with JDBC drivers in them.

    CTRL-K

    In any table view in a Hop dialog, select one or more lines and use to remove all lines but your selection

    CTRL-SHIFT-Click

    Hover your mouse pointer over any pipeline action in a workflow, pipeline or workflow executor transform etc and use CTRL-SHIFT-Click to open that item in a new tab. The same behavior can be triggered by hovering over an item and hitting the Z key.

    Copy as pipeline action

    Transform hover + SPACE

    In a pipeline, hover over any transform and hit to show the list of output fields for the selected transform.

    Action or transform hover + Z

    Hover your mouse pointer over any pipeline action in a workflow, pipeline or workflow executor transform etc and hit the Z key to open that item in a new tab. The same behavior can be triggered by hovering over an item and hitting the use key combination.

    • a best practice rather than a pro tip: use project variables only for variables that are valid across all environments. Variable that have different values in different environments should be created on the environment level.