SHOW COMPUTE PROFILE Usage - Teradata VantageCloud Lake

Lake - Working with SQL
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530
  • If the compute group name is not specified in an IN clause, a default compute group name is identified based on the following order:
    1. Compute group name from the session
    2. Compute group name from the user profile
    3. Compute group name from the user

    An error occurs if the compute group name is not found.

  • You do not require any privileges on the compute map or compute group to run this statement.
  • An error occurs in the following cases:
    • If the specified compute profile does not exist for the compute group.
    • If the specified or the default compute group does not exist.