- Releases Notes and Announcements
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- SQL Developer Guide
- Python Developer Guide
- ETL Developer Guide
- FAQ
- Contact Us
- Releases Notes and Announcements
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- SQL Developer Guide
- Python Developer Guide
- ETL Developer Guide
- FAQ
- Contact Us
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.
Yes
No
Was this page helpful?