ACCESS_HISTORY view (Account Usage and Organization Usage): Simpler format for values (Preview)¶

The format of values in the ACCOUNT_USAGE.ACCESS_HISTORY and ORGANIZATION_USAGE.ACCESS_HISTORY views behaves as follows:

Before the change:

A value is specified as a JSON object with a value key. For example:

{
  "columns": [
    {
      "objectName": "A",
      "objectId": {
        "value": 2
      },
      "subOperationType": "ADD"
    },
    {
      "objectName": "B",
      "objectId": {
        "value": 3
      },
      "subOperationType": "ADD"
    }
  ]
}

Copy

After the change:

A key-value pair shows the value as a string, number, or Boolean directly. The value key is no longer needed. For example:

{
  "columns": [
    {
      "objectName": "A",
      "objectId": 2,
      "subOperationType": "ADD"
    },
    {
      "objectName": "B",
      "objectId": 3,
      "subOperationType": "ADD"
    }
  ]
}

Copy

This change simplifies the record structure and improves readability.

Ref: 2179