Adding a Lab Group - Teradata Data Lab

Teradata Data Lab User Guide

Product
Teradata Data Lab
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
hwi1478714153880.ditamap
dita:ditavalPath
2212_User_dl_1610.ditaval.ditaval
dita:id
B035-2212
lifecycle
previous
Product Category
Analytical Ecosystem
The Teradata Viewpoint Administrator must assign the Manage Lab Groups permission using Roles Manager for your Viewpoint role.
The Teradata Database user ID you use when you log in to the portlet must have the DROP USER Teradata Database privilege to update or delete a lab group and the following privileges to create a lab group:
  • CREATE USER
  • CREATE ROLE WITH GRANT OPTION
  • GRANT EXECUTE ON DBC.LogonRule
A wizard at the top of the screen guides you through the steps to create a new lab group. You can return to completed steps by clicking the numbered step.


After a lab group is created, most settings can be changed at a later time by the Viewpoint role with Manage Lab Groups permission.

Thresholds can be set and approvers selected for each request type. By default, all requests are sent to the lab group owner for approval. Approvals can be delegated to lab owners or set to automatically approve.

  1. From the Monitoring tab, click next to LAB GROUPS.
  2. In Lab Group (step 1), do the following to specify lab group details and the lab group owner email notification:
    1. Type a lab group name, up to 18 characters.
    2. [Optional] Type a lab group description up to 500 characters.
    3. Type or select a parent database from the list.
    4. Type the amount of space to allocate to the lab group. If the space is too low, lab users will be unable to request to add more labs in the lab group.
    5. [Optional] Select the Enable display of users and roles for the lab group and labs check box to enable lab users to see the Users tab when viewing lab group details and lab details.
    6. Type a percentage from 1% to 100%. When the allocated space is within the specified percentage of the lab group size, the lab group owner receives an email notification, depending on the email notification settings.
    7. Click Next.
  3. In Labs (step 2), specify the default lab settings, request limits, and lab owner email notifications, and click Next. The default lab settings appear when labs are created, but users can submit a request to overwrite the settings for their specific labs. Default lab settings can be changed by the Viewpoint role with Manage Lab Groups permission after the lab group is created except where noted.
    1. Type a size for the default lab. If the size is too low, users will be unable to load more data into the lab, requiring the lab user to send frequent requests to increase the lab size.
    2. [Optional] Select the Expire lab after check box and either select the number of days from the menu or type a number from 1 to 9999 and press Enter. If the check box is not selected, no lab expiration is set.
    3. [Optional] Select the Limit lab expiration requests check box and enter a number of days to enable users to request lab expirations up to that number of days. This option is only available if you selected and set the Expire lab after option.
      If you select the Limit lab expiration requests check box, the No expiration option will not be available to request submitters for labs within this lab group.
    4. [Optional] Select the Delete expired after check box and either select the number of days from the menu or type the number of days from 1 to 9999 and press Enter if you want an expired lab to delete automatically when the set value is reached.
    5. [Optional] Select the Grant lab users CREATE OBJECT privilege check box to allow lab users to create Teradata Database objects in the underlying Lab database using the CREATE OBJECT statement. This setting cannot be changed after the lab group is created.
    6. [Optional] Type a lab prefix. The lab prefix precedes all lab names in the lab group to help manage workloads. It may be up to 6 characters, or up to twelve characters if the Extended Object Names feature has been enabled on the selected Teradata system. The lab prefix cannot be changed after the lab group is created.
    7. [Optional] Type lab instructions, up to 500 characters. Lab instructions provide guidance and best practices to help lab users.
    8. [Optional] Under Request Limits, select the Limit the maximum lab size and specify a maximum size in MB, GB, or TB from 1 to 9999 for all labs in a lab group. Requests to increase a lab size that exceed the specified maximum lab size will be sent to the lab group owner for approval. For more information, see Request Limits.
    9. [Optional] Select the Automatically reject requests exceeding the limit check box to automatically reject requests from lab owners and users for sizes over that specified in the Limit the maximum lab size option.
    10. [Optional] Under Request Limits, select the check box, and then select the number of days from the menu or type the number of days from 1 to 9999 and press Enter to limit the maximum cumulative life for all labs in the lab group. Requests to extend a lab that exceed the specified number of days will be sent to the lab group owner for approval. For more information, see Request Limits.
    11. [Optional] Select the Automatically reject requests exceeding the limit check box to automatically reject requests from lab owners and users for time periods over that specified in the Limit the maximum cumulative life option.
    12. Under Lab Owner Email Notifications, select the number of days before a lab expires in which to trigger an email notification. An email notification is sent to the lab owner when the number of days is reached, depending on the email notification settings.
    13. Under Lab Owner Email Notifications, type a percentage from 1% to 99%. An email notification is sent to the lab owner when the available space for the lab falls below the percentage you set, depending on the email notification settings.
  4. In Permissions (step 3), select the appropriate check boxes to grant additional full access lab permissions. These are Teradata Database privileges granted to full access default users and lab users for labs that are added within this lab group.
  5. In Owners (step 4), select which Viewpoint users and roles own the lab group:
    1. Select a user from the Available users box and click to move that user (owner) to the Selected users box.

      If there are more than 500 users, use the User list filter.

    2. Select a role from the Available roles box and click to move that role to the Selected roles box.
    3. [Optional] In the User list filter box, type to filter the list of available users.
    4. Click Next.
  6. In Private (step 5), do one of the following to restrict access to the lab group:
    Option Description
    Not private Click Next if you do not want to place any restrictions on which Teradata Database users and roles can access labs in this lab group.
    Private
    1. Select the Restrict access to selected users and roles check box to restrict which Teradata Database users and roles can access the lab group.
    2. Select a user from the Available users box, and click to move that user to the Selected users box.

      If there are more than 500 users, use the User list filter.

    3. Select a role from the Available roles box, and click to move that role to the Selected roles box.
    4. [Optional] Select the Read-only check box if you want to give read-only access to labs in this lab group.

      Read-only users cannot send requests to remove a user, increase or decrease lab size, delete, extend, or reinstate a lab, drop an object, or edit lab details.

    5. Click Next.
  7. In Default Users (step 6), do one of the following to provide access to all labs in this lab group:
    Option Description
    Do not give access Click Next if you do not want to create any default users. A default user is a Teradata Database user or role that has either full control or is read-only for all labs in a lab group.
    Give access
    1. Select the Give access to selected users and roles check box to give lab access to selected Teradata Database users and roles in the lab group.
      When you give access to default users and roles, they will have either full control or are read-only for all labs in the lab group.
    2. Select a user from the Available users box, and click to move that user to the Selected users box.

      If there are more than 500 users, use the User list filter.

    3. Select a role from the Available roles box, and click to move that role to the Selected roles box.
    4. [Optional] Select the Read-only check box if you do not want the user or role to create, modify, or drop Teradata Database objects in the labs in the lab group.
    5. Click Next.
  8. In Approvers (step 7), do one of the following to set approvers for each request type: For more information, see approval controls.
    Option Description
    Default lab group owner approval Click Create if you do not want to set thresholds and want the lab group owner to approve all request types by default.
    Automatic approval
    1. In the top section, specify thresholds under Automatic approval so that requests that are less than or equal to the setting are approved automatically for increasing lab size, extending a lab, and adding a lab.
    2. In the bottom section, select Automatic approval for each request if no approval is required.
    3. Click Create.
    Lab owner
    1. In the top section, specify thresholds under Lab owner so that requests that are less than or equal to the settings for increasing lab size and extending a lab, and greater than Automatic approval, are approved by the lab owner or lab group owner.
    2. In the bottom section, select Lab owner for each request if approval is required from the lab owner or the lab group owner.
    3. Click Create.
    Lab group owner In the top section, requests for increasing lab size and extending a lab greater than the Automatic approval or Lab owner thresholds are approved automatically by the lab group owner.
    1. In the bottom section, select Lab group owner for each request if approval is required from the lab group owner.
    2. Click Create.
    A confirmation message appears.
  9. Click Done.