Purpose of System Accounting - Teradata VantageCloud Lake

Priority

VantageCloud Lake pre-defines a set of default workloads, each with its own priority level. In VantageCloud Lake, the system automatically assigns all active queries that do not have an explicit workload to a workload based on their query characteristics. You can override this automatic workload (and priority) assignment by specifying one of the default workloads in a user’s account string. Assign specific users to one of the five non-automatic priorities based on account strings to manage priorities effectively.

If an account string includes a valid workload classification representation (such as $L or $H), all queries submitted by that user will run under the priority associated with that account string.

See, Managing Your Workloads for more information on default workloads and how they are expressed within account strings.

User-defined Metadata

You can also use the account string to contain metadata associated with the user, in addition to overriding the automatically assigned workload. The account field is defined as 128 characters, and you can use any combination of text in this field. In this manner, the account string can be useful for reporting and analyzing users.