LISTING_ACCESS_HISTORY view: New columns (Pending)

Attention

This behavior change is in the 2024_05 bundle.

For the current status of the bundle, refer to Bundle History.

When this behavior change bundle is enabled, the LISTING_ACCESS_HISTORY view includes the following new columns:

Column name

Data type

Description

STORAGE_INTEGRATION

TEXT

The name of the storage integration associated with the stage; NULL for internal stages or stages that do not use a storage integration.

IS_SHARE

BOOLEAN

TRUE if the access was on a share. When TRUE, the LISTING_OBJECTS_ACCESSED column provides details about the share objects accessed by the consumer query.

IS_APPLICATION

BOOLEAN

TRUE if the access was on an application. When TRUE, APPLICATION_OBJECTS_ACCESSED column provides details about the application objects accessed by the consumer query.

SHARE_OBJECTS_ACCESSED

ARRAY

See LISTING_OBJECTS_ACCESSED Array for formatting. Is null when IS_SHARE is FALSE.

Note: this column has the same data as the LISTING_OBJECTS_ACCESSED column.

It is recommended to use SHARE_OBJECTS_ACCESSED instead of LISTING_OBJECTS_ACCESSED to minimize future disruption.

APPLICATION_OBJECTS_ACCESSED

ARRAY

See APPLICATION_OBJECTS_ACCESSED Array for formatting.

Is NULL when IS_APPLICATION is FALSE.

APPLICATION_PACKAGE_NAME

VARCHAR

The current name of the application package from which the application was installed.

Is NULL when IS_APPLICATION is FALSE.

APPLICATION_VERSION

VARCHAR

The version of the application when this query occurred.

Is NULL when IS_APPLICATION is FALSE.

APPLICATION_PATCH_ID

INTEGER

The patch number of the application when this query occurred.

Is NULL when IS_APPLICATION is FALSE.

APPLICATION_OBJECTS_ACCESSED Array

The APPLICATION_OBJECTS_ACCESSED array provides details about the objects in an application accessed by a consumer query. The format of an item in the array depends on the type of object that was accessed.

Note

Object IDs are not available and database names are masked.

The following provides examples of the returned result when the underlying result is one of Functions, Stored procedures, or Tables, views, and columns.

Functions

{
  "argumentSignature": (function_signature varchar),
  "objectName": "23662386A408C571B77FDC53691793E4992D1C12.SCHEMA_NAME.FUNCTION_NAME",
  "objectDomain": "Function"
}
Copy

Stored procedures

{
  "argumentSignature": (function_signature varchar),
  "objectName": "23662386A408C571B77FDC53691793E4992D1C12.SCHEMA_NAME.PROCEDURE_NAME",
  "objectDomain":"Procedure"
}
Copy

Tables, views, and columns

[
  {
    "Columns": [
      {
        "columnName": "column1_name"
      },
      {
        "columnName": "column2_name"
      }
    ],
    "objectDomain":"VIEW",
    "objectName": "5F3297829072D2E23B852D7787825FF762E74EF3.PUBLIC.VIEW_1"
  },
  {
    "Columns": [
      {
        "columnName": "column3_name"
      },
      {
        "columnName": "column4_name"
      }
    ],
    "objectDomain":"TABLE",
    "objectName": "D85A2CE1531C6C1E077FA701713047305BDF5A83.PUBLIC.TABLE1"
  }
]
Copy

Ref: 1641