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:

PropertyControlDescription
NametextThe name of the global variable
DescriptiontextThe description of the global variable, if any
OwnertextThe display name of the user creator
LineagelinkAvailable 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 linkOpens the Edit Global Variable dialog
Delete (trash can)icon linkOpens 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:

Important

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 + NewGlobal 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.