All Products
Search

This Product

    DataWorks:Hologres SQL node

    Document Center

    DataWorks:Hologres SQL node

    Last Updated:Jul 17, 2026

    A Hologres SQL node lets you query and analyze large-scale data in MaxCompute using standard PostgreSQL statements, delivering fast results without data migration.

    Prerequisites

    Add a Hologres compute engine instance on the Workspace Settings page. For details, see Configure a workspace.

    Procedure

    1. On the Hologres SQL node editor page, follow these steps:

      Develop SQL code

      Develop the task code in the SQL editor. You can define variables using the ${variable_name} format and assign values in the Scheduling Parameters section of the Scheduling Settings panel on the right to dynamically pass parameters for scheduled runs. For more information, see Scheduling parameter sources and their expressions. For example:

      SELECT col_1,col_2 FROM your_table_name WHERE pt>${pt_num} limit 500;
      Note

      By default, a query returns a maximum of 200 results. To retrieve more results, add a limit clause to your SELECT statement. The maximum number of results is 10000.

      Run the SQL task

      1. In the Run Configuration panel, configure the Compute Resource and Resource Group.

        Note

        To access a data source over the public network or in a VPC environment, you must use a scheduling resource group that can connect to the data source. For more information, see Network connectivity solutions.

      2. From the Select a data source drop-down list in the toolbar, select your Hologres data source, and then click Run.

      3. Click Save.

    2. To run the node periodically, configure its scheduling properties. For details, see Node scheduling configuration.

    3. After configuring the node, you must deploy it. For details, see Node and workflow deployment.

    4. After the node is deployed, you can view the run status of periodic tasks in Operation Center. For details, see Getting started with Operation Center.