Pro Tips
Useful Variables
A lot of Hop’s default behavior can be customized through global variables. Check full list of variables to check them all. A couple of useful and often overlooked environment variables can be set (outside of Hop):
- 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
config
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.
- HOP_SHARED_JDBC_FOLDER
-
The variable which points to a shared folder with JDBC drivers in them.
Keyboard Shortcuts and Mouse actions
- CTRL-K
-
In any table view in a Hop dialog, select one or more lines and use
CTRL-K
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 theZ
key. - Copy as pipeline action
-
In any pipeline or workflow, click anywhere on the canvas and choose 'Copy as pipeline action' or 'Copy as workflow action'. The selected pipeline or workflow can now be pasted (CTRL-V) as a fully configured workflow or pipeline action in any workflow.
- Transform hover + SPACE
-
In a pipeline, hover over any transform and hit
SPACE
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 useCTRL-SHIFT-Click
key combination.
Projects and Environments
-
Projects can inherit metadata items (e.g. database connections) from parent projects. Use parent projects to reuse metadata items across multiple projects.
-
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.