QueryUserAssignmentLog

The QueryUserAssignmentLog table contains the history of user assignments for Persistent Query replicas in the controller.

When a client first authenticates to the controller, it is assigned a replica slot for each Persistent Query that uses replicas, which tells it which copy of the Persistent Query to connect to. These replica slot assignments can change depending on the status of the Persistent Queries. Each replica slot assignment event generates a row in this table.

Columns

Column NameColumn TypeDescription
DateStringThe date on which the information was generated. This is the partitioning column.
TimestampInstantThe timestamp of the event.
QuerySeriallongThe Persistent Query's serial number.
QueryOwnerStringThe Persistent Query's owner.
AdminGroupsStringAdditional administrators for the Persistent Query (i.e., users or groups that can edit, start, stop, or delete the query).
AssignedSlotintThe replica slot the user is assigned for this Persistent Query.
UserStringThe user being assigned the slot.
PolicyNameStringThe replica assignment policy such as RoundRobin.
DetailsStringThe reason for the assignment. Examples from the RoundRobin policy include First Assignment and Rebalancing due to reduced capacity.
IsResetBooleanWhether or not the query is reset (i.e. all replicas are removed).