Tools → Schema Manager → Global Variables
Global Variables list view
A global variable is not limited to the user session. In addition, it is not subject to user access rights. Thus, it is available to all users in the tenant. By default, the Global Variable items appear in alphabetical, ascending order. The list shows 20 items at a time. When you select one or more items, the Search bar shows the Delete option (trash can icon). Use it to delete all selected items
For Global Variables, the list view shows the following properties:
Property | Control | Description |
---|---|---|
Name | text | The name of the global variable |
Description | text | The description of the global variable, if any |
Owner | text | The display name of the user creator |
Lineage | link | Available starting with 2023.7.0. Opens the Data Lineage Viewer that displays a diagram with the entities referenced in the variable (upstream lineage) and entities where the variable is referenced (downstream lineage). |
Edit (pen icon) | icon link | Opens the Edit Global Variable dialog |
Delete (trash can) | icon link | Opens the confirmation dialog for the global variable deletion |
Schema Manager actions for global variables
Using the Schema Manager, you can perform the following actions for global variables:
- Create a global variable
- View a list of global variables
- Search for a global variable
- View the data lineage of a global variable
- Edit a global variable
- Delete a global variable
- Delete one or more global variables
Validation Rules for a global variable name
A global variable name…
- Must be unique
- Must be between 1 and 250 characters in length
- Must begin with an alpha character, lower or upper case
- After the first alpha character, can contain zero or more alphanumeric characters in lower, upper, or mixed case
- After the first alpha character, can contain zero or more underscore
(_)
characters - Besides underscore
(_)
, cannot contain special characters, symbols, or spaces - Cannot share the same name with an internal or external session variable
- Is case-sensitive
Create a global variable
- In the Navigation bar, select Schema.
- In the Action bar, select + New → Global Variable.
- In the Create Global Variable dialog, in Name, enter the name of the global variable.
- In Description, optionally enter a description.
- Select Value to open the Formula Builder to construct the query expression of the global variable value.
- Optionally, select Test to test the global variable query expression.
- Select Create.
For examples of global variable query expressions, refer to Concepts → Global Variable.
View a list of global variables
- In the Navigation bar, select Schema.
- In the Context bar, select the Global Variables tab.
- On the Global Variables tab, review the list view of global variables.
Search for a global variable
- In the Navigation bar, select Schema.
- In the Context bar, select the Global Variables tab.
- On the Global Variables tab, in the Search bar, enter a search term.
- Review the list view of global variables.
To reset the search, in the Search bar, in the search box, select the remove button (x)
View the data lineage of a global variable
You can view the data lineage of any global variable in the tenant. This feature is available starting with 2023.7.0.
- In the Navigation bar, select Schema.
- In the Context bar, select the Global Variables tab.
- In the list view of global variables, for a given global variable, select Lineage.
- In the Data Lineage Viewer, review the upstream and downstream lineage of the global variable.
Edit a global variable
- In the Navigation bar, select Schema.
- In the Context bar, select the Global Variables tab.
- In the list view of global variables, for a given global variable, do one of
the following:
- select any part of the row
- select the edit icon (pen icon)
- In the dialog, make the necessary configuration updates.
- Select Ok.
Delete a global variable
- In the Navigation bar, select Schema.
- In the Context bar, select the Global Variables tab.
- In the list view of global variables, for a given row, select Delete (trash can icon).
- In the dialog, select Delete.
Delete one or more global variables
- In the Navigation bar, select Schema.
- In the Context bar, select the Global Variables tab.
- In the list view of global variables, for each global variable that you want to delete, select the checkbox.
- In the Search bar, next to Selected, select Delete (trash can icon).
- In the dialog, select Delete.