ACCESS_HISTORY view (Account Usage and Organization Usage): User-defined values in the objects_modified_by_ddl column (Pending)¶

通过此行为变更，ACCOUNT_USAGE.ACCESS_HISTORY 和 ORGANIZATION_USAGE.ACCESS_HISTORY 视图的 objects_modified_by_ddl 列从不使用用户定义的值作为 JSON 键值对的键。此变更的行为如下：

变更前:

用户指定的值（如列名和标签名）是 JSON 对象中的键。例如：

{
  "columns": {
    "A": {
      "objectId": {"value": 0},
      "subOperationType": "ADD",
      "tags": {
        "DB1.SCH.TAG1": {
          "objectId": {"value": 0},
          "subOperationType": "ADD",
          "tagValue": {"value": "v1"}
        }
      }
    }
  }
}

Copy

变更后:

用户指定的信息作为键值对的值获取。例如：

{
  "columns": [
    {
      "objectName": "A",
      "objectId": {"value": 0},
      "subOperationType": "ADD",
      "tags": [
        {
          "objectName": "DB1.SCH.TAG1",
          "objectId": {"value": 0},
          "subOperationType": "ADD",
          "tagValue": {"value": "v1"}
        }
      ]
    }
  ]
}

Copy

参考：2178