ACCESS_HISTORY view (Account Usage and Organization Usage): Simplified records for policy creation (Preview)¶

The object_modified_by_ddl column in the ACCOUNT_USAGE.ACCESS_HISTORY and ORGANIZATION_USAGE.ACCESS_HISTORY views contains records that correspond to creating a policy. This behavior change affects what is included in a record that corresponds to creating any of the following policies:

• Aggregation policies

• Join policies

• Masking policies

• Privacy policies

• Projection policies

• Row access policies

• Storage lifecycle policies

Before the change:

Records include system-generated fields that weren’t specified when creating the policy. For example, if someone created a row access policy, the record includes detailed type information with default values:

{
  "policyReturnType": {
    "value": {
      "byteLength": null,
      "collation": null,
      "fixed": null,
      "length": null,
      "nullable": true,
      "precision": null,
      "scale": null,
      "template": null,
      "type": "BOOLEAN"
    }
  },
  "policySignature": {
    "value": {
      "arguments": [
        {
          "datatype": {
            "byteLength": 134217728,
            "collation": null,
            "fixed": false,
            "isMaxLength": true,
            "length": 134217728,
            "nullable": true,
            "precision": null,
            "scale": null,
            "template": null,
            "type": "TEXT"
          },
          "defaultVal": null,
          "hasDefaultValue": false,
          "identifier": "EMAIL",
          "parameterType": "NONE"
        }
      ]
    }
  }
}

Copy

After the change:

Records include only information that was specified by the user when creating the policy. For example:

{
  "policyReturnType": {
    "value": {
      "type": "BOOLEAN"
    }
  },
  "policySignature": {
    "value": {
      "arguments": [
        {
          "datatype": {
            "type": "TEXT"
          },
          "identifier": "EMAIL"
        }
      ]
    }
  }
}

Copy

Ref: 2181