DataWorks:AnalyticDB for MySQL node

Step 1: Write the SQL code

Open the configuration tab of your AnalyticDB for MySQL node. In the code editor, write the SQL you want to execute.

To pass dynamic values at runtime, define variables in the ${variable} format directly in the SQL. Then, in the Properties tab, go to the Scheduling Parameters section and assign a scheduling expression to each variable. DataWorks substitutes the expression values into the SQL each time the node runs.

Example:

SHOW ${var};

In the sample code, you can set ${var} to the TABLES field.

For the full list of supported scheduling expressions, see Sources and expressions of scheduling parameters.

Step 2: Configure and run the node

1. Click the Run Configuration tab and set the following fields:

   Field	Description	Required
   Computing Resource	The AnalyticDB for MySQL V3.0 computing resource registered in DataWorks	Required
   Resource Group	A scheduling resource group connected to the computing resource. Network connectivity between the resource group and the computing resource must be in place.	Required

   For network connectivity requirements, see Network connectivity solutions.

2. In the upper part of the code editor, click the Select DataSource drop-down list and select the AnalyticDB for MySQL V3.0 computing resource.

3. Click Run in the top toolbar to execute the node immediately.

Step 3: Configure scheduling (optional)

To run the node automatically on a recurring basis, configure the schedule on the Properties tab based on your requirements. For details, see Node scheduling configuration.

Step 4: Deploy the node

After configuration is complete, deploy the node to make it available for scheduled runs. For details, see Deploy a node or a workflow.

Step 5: Monitor node runs

After deployment, go to Operation Center to view the running status of the node. For details, see Getting started with Operation Center.