On setting up database properties, you can use global variables in the Server and Schema/Database fields. By default, the Server drop-down list contains the %METABASE_SERVER% variable, and the Schema/Database menu contains the %METABASE_DATABASE% variable. To select or edit another variable, click the Edit item in the drop-down list. Value editing dialog box opens:
The Value box is used to specify the expression based on which server/scheme/database name should be defined.
The Global Variables list contains all global variables of the repository.
To paste the selected list element into the Value box:
Click the Paste button.
Double-click.
Select the Paste context menu item.
See also: