Stream Compute Service
- Releases Notes and Announcements
- Getting Started
- Operation Guide
- Managing Jobs
- Developing Jobs
- Monitoring Jobs
- Events and Diagnosis
- Managing Metadata
- Tuning Jobs
- Managing Clusters
- Managing Permissions
- SQL Developer Guide
- DDL Statements
- Connectors
- SET Statement
- Operators and Built-in Functions
- Identifiers and Reserved Words
- ETL Developer Guide
Variables
Last updated: 2023-11-07 16:25:49
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 valueNote
_ is used as the separator in a variable name.Creating a variable
Log in to the Stream Compute Service console, create a SQL job in Jobs as instructed in Creating a SQL Job, go to the Development & Testing tab of the job, and click Variables on the left.
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.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No