This topic describes how to configure the resource groups that are used by SQL query tasks and data upload tasks on the System Management page of DataAnalysis.
Limits
You can go to the System Management page only by using your Alibaba Cloud account or as a RAM user that is assigned the tenant administrator role.
The settings that you configure on the System Management page take effect only for the current tenant in the current region. You must ensure that network connections are established between the data sources and resource groups that are used by SQL query tasks and data upload tasks. For more information, see Network connectivity solutions.
Take note of the following limits when you upload data:
Compute engines: You can upload data only to MaxCompute, E-MapReduce (EMR) Hive, or Hologres compute engines.
Resource groups: To use the data upload feature, you must take note of the following items to specify a resource group:
Upload data to MaxCompute:
Serverless resource groups and old-version resource groups are supported. Old-version resource groups consist of exclusive resource groups for scheduling and exclusive resource groups for Data Integration. We recommend that you use serverless resource groups. Make sure that the data source used by data upload tasks is connected to the selected resource groups.
The selected exclusive resource groups and serverless resource groups must be associated with the DataWorks workspace where the table that is used to receive data resides.
Upload data to EMR Hive or Hologres:
Only serverless resource groups and exclusive resource groups are supported. Exclusive resource groups consist of exclusive resource groups for scheduling and exclusive resource groups for Data Integration. You must select an exclusive resource group or a serverless resource group for the compute engine type on the System Management page of DataAnalysis.
The selected resource groups must be associated with the DataWorks workspace where the table that is used to receive data resides. Make sure that the data source used by data upload tasks is connected to the selected resource groups.
Go to the System Management page
In the left-side navigation pane, click the
icon and select System Management.
Configure the resource groups used by tasks of different compute engine types
On the System Management page, you can specify the resource groups that you want to use to run SQL query tasks and data upload tasks of different compute engine types.
You can select a resource group for scheduling and a resource group for Data Integration from the drop-down lists to the right of a compute engine type. The resource groups that you select must be connected to the desired data source. This ensures that tasks can be run as expected.
You can test the network connectivity between a data source and a resource group when you add the data source. For more information, see Add an AnalyticDB for MySQL 2.0 data source.
The selected resource groups must be associated with the DataWorks workspace where the table that is used to receive data resides. For more information, see Create and use a serverless resource group and Use old-version resource groups.