Variables can be used in Variables of a SQL job. Replace table variables allows replacing variables in both temporary tables and metadata tables of a SQL job with actual values.
Variable syntax: ${variable name}:default value
Note
_ is used as the separator in a variable name.
Creating a variable
On the Variables page, click Create > Create variable in the top right corner, enter the required information in the pop-up window, and click Confirm.
Referencing global variables in a table
On the Database/Table references page, click Create > Create table in the top right corner, select a catalog and database in the pop-up window, click Next, and select a method (three options: Template, Custom, and Cloud resource) to create the table. If you select Custom or Cloud resource, enter the required connection information. Set table variables in the WITH parameters and click Complete. For table variable naming rules, see Managing Tables. Referencing global variables in a SQL job
You can directly reference global variables in a SQL job as follows: Click Replace table variables, select Referenced global variable, and click Submit.