DataWorks:Create a Hologres SQL node

Step 1: Go to DataStudio

Log on to the DataWorks console. In the top navigation bar, select a region. In the left-side navigation pane, choose Data Development and O&M > Data Development. Select your workspace from the drop-down list and click Go to Data Development.

Step 2: Create a workflow

Skip this step if you already have a workflow.

1. Move the pointer over the icon and select Workflow.

2. In the Create Workflow dialog box, enter a Workflow Name.

3. Click Create.

Step 3: Create a Hologres SQL node

1. Move the pointer over the icon and choose Create Node > Hologres > Hologres SQL. Alternatively, right-click Hologres in the target workflow and choose Create > Hologres SQL.

2. In the Create Node dialog box, enter a Node Name. Node names can be up to 128 characters and may contain letters, digits, underscores (_), and periods (.).

3. Click Commit.

Step 4: Write and run SQL

In the code editor on the Hologres SQL node tab, write your query using Hologres SQL syntax. For the full syntax reference, see SELECT.

To verify that your node is connected and your table is accessible, start with a simple query:

SELECT * FROM <your_table_name> LIMIT 10;

SELECT col_1, col_2 FROM <your_table_name> WHERE pt > 0 LIMIT 500;

Step 5: Configure scheduling properties

On the node tab, click Properties in the right-side navigation pane and configure the scheduling options. For details, see Configure basic properties.

Step 6: Save and commit

1. Click the icon in the top toolbar to save the node.

2. Click the icon to open the commit dialog.

3. In the Commit Node dialog box, enter a Change description.

4. Click OK.

Step 7: Deploy (standard mode only)

If your workspace is in standard mode, click Deploy in the upper-right corner after committing. Nodes that are not deployed will not run on schedule. For details, see Deploy nodes.