Huawei Cloud Data Warehouse Service DWS

Collect Huawei Cloud DWS monitoring metrics

Configuration¶

Install Func¶

It is recommended to activate Guance Integration - Extensions - DataFlux Func (Automata): All prerequisites are automatically installed, please proceed with the script installation.

If you need to deploy Func manually, refer to Manual Deployment of Func

Install Script¶

Note: Please prepare the Huawei Cloud AK in advance (for simplicity, you can grant the global read-only permission Tenant Guest)

Automata Version Activation Script¶

1. Log in to the Guance console
2. Click the 【Integration】 menu, select 【Cloud Account Management】
3. Click 【Add Cloud Account】, select 【Huawei Cloud】, and fill in the required information on the interface. If the cloud account information has been configured before, ignore this step
4. Click 【Test】, if the test is successful, click 【Save】. If the test fails, please check if the relevant configuration information is correct and test again
5. Click 【Cloud Account Management】 list, you can see the added cloud account, click the corresponding cloud account to enter the details page
6. Click the 【Integration】 button on the cloud account details page, find Huawei Cloud Data Warehouse Service DWS under the Not Installed list, click the 【Install】 button, and the installation interface will pop up for installation.

Manual Activation Script¶

1. Log in to the Func console, click 【Script Market】, enter the Guance script market, search for integration_huaweicloud_dws

2. Click 【Install】, then enter the corresponding parameters: Huawei Cloud AK, SK, and account name

3. Click 【Deploy Startup Script】, the system will automatically create the Startup script set and configure the corresponding startup script

4. After activation, you can see the corresponding automatic trigger configuration in 「Management / Automatic Trigger Configuration」. Click 【Execute】 to immediately execute it once without waiting for the scheduled time. After a while, you can view the execution task records and corresponding logs

Verification¶

1. In 「Management / Automatic Trigger Configuration」, confirm whether the corresponding task has the automatic trigger configuration, and you can also check the corresponding task records and logs for any anomalies
2. In Guance, check if there is asset information in 「Infrastructure - Resource Catalog」
3. In Guance, check if there is corresponding monitoring data in 「Metrics」

Metrics¶

Collect Huawei Cloud Data Warehouse Service DWS metrics, more metrics can be collected through configuration Huawei Cloud DWS Metrics Details

Huawei Cloud DWS metrics are under the huaweicloud_SYS.DWS set, below are the DWS related metrics descriptions

Object¶

After the data is synchronized normally, you can view the data in Guance's 「Infrastructure - Resource Catalog」.

{
  "measurement": "huaweicloud_dws",
  "tags": {
    "RegionId"                : "cn-south-4",
    "project_id"              : "756ada1aa17e4049b2a16ea41912e52d",
    "enterprise_project_id"   : "0824ss-xxxx-xxxx-xxxx-12334fedffg",
    "datastore_id"            : "xxxxxx",
    "datastore_name"          : "test"
  },
  "fields": {
    "status"                        : "AVAILABLE",
    "version"                       : "8.0.x",
    "port"                          : "8000",
    "user_name"                     : "xxxxx",
    "availability_zone"             : "cn-south-4a",
    "node_type"                     : "dwsk2-xxx-xxx",
    "sub_status"                    : "xxxxxxxxx",
    "create_time"                   : "2024-11-11T08:15:58Z",
    "update_time"                   : "2024-11-11T08:15:58Z",
    "endpoints"                     : "xxxxx",
    "nodes"                         : "[]",
    "number_of_node"                : "3",
    "recent_event"                  : "2",
    "public_endpoints"              : "[]",
    "action_progress"               : "{}",
    "public_ip"                     : "xxxxxxxx"
  }
}

Note: The fields in tags and fields may change with subsequent updates