Setting Up the Compute Cluster Administrative Users - Teradata VantageCloud Lake

A compute cluster is used to scale-up or scale-down compute without restarting the primary cluster.

Compute groups and compute profiles are created by administrators and a compute map is populated during initialization or during an upgrade of the VantageCloud Lake system (customers do not create compute maps). Administrators grant privileges to users who can run queries on instances in the compute cluster, by associating a user with a compute group either through a session, profile, or user setting. The related database objects are:

• Compute map: This is a template that defines a compute cluster instance type. For example, the instance sizes are TD_COMPUTE_XSMALL, TD_COMPUTE_SMALL, TD_COMPUTE_MEDIUM, TD_COMPUTE_LARGE, and so on. Maps are defined during system initialization or upgrades.
• Compute profile: Defines the resource policy to control the scaling of one or more compute cluster instances.
• Compute group: A logical group of compute profiles. Users associated with a compute group can access compute cluster instances in the group.

For VantageCloud Lake the following administrative users are created:

• Compute cluster profile administrator: A database user who has administrative rights on one or more compute profiles. This user may perform the following tasks, depending on the privileges granted to it:
  • Create a compute profile
  • Drop a compute profile
  • View the status of a compute profile
  • Suspend a compute profile
  • Resume a compute profile
  • Modify a compute profile by scaling the size of the compute cluster instances, scaling the number of compute cluster instances, hibernating or removing compute cluster instances
• Compute cluster group administrator: A database user who has administrative rights on one or more compute groups. This user may perform the following tasks depending on the privileges granted to it:
  • Create a compute group
  • Drop a compute group
  • Add and remove users from a compute group
  • Add and remove administrative users from a compute group

For more information about the administrative concepts and tasks associated with managing compute cluster resources, see Compute Cluster Statements.

• Creating Compute Cluster Administrative Users
• Granting CREATE COMPUTE GROUP Privileges to the Compute Cluster Administrator
• Granting CREATE COMPUTE PROFILE Privileges to the Vantage Cloud Administrator Profile
• Granting Compute Cluster Privileges to Roles
• Granting Users Access to Compute Clusters
• Setting Up Compute Cluster Administrative Users - SQL Examples