ACCESS_HISTORY view (Account Usage and Organization Usage): Simplified format for tag creation (Preview)¶

When you create a tag, you can specify a list of allowed values. The format of these allowed values in the object_modified_by_ddl column of the ACCOUNT_USAGE.ACCESS_HISTORY and ORGANIZATION_USAGE.ACCESS_HISTORY views behaves as follows:

Before the change:

Allowed values are formatted as keys of a JSON object. For example, when you create a tag with allowed values A, B, and C, the format in access history is shown in the following JSON object:

{
  "allowedValues": {
    "A": {
      "subOperationType": "ADD"
    },
    "B": {
      "subOperationType": "ADD"
    },
    "C": {
      "subOperationType": "ADD"
    }
  }
}

Copy

After the change:

Allowed values are formatted as an array of strings. This array is the value of the allowedValues key. For example:

{
  "allowedValues": [
    "A",
    "B",
    "C"
  ]
}

Copy

This change simplifies the record and more clearly reflects the command that was executed.

Ref: 2180