Schema:: ACCOUNT_USAGE

CONTACT_REFERENCES view¶

This Account Usage view can be used to identify the associations between contacts and the objects to which they have been added.

Contact lineage is not included in this view. For example, if a contact is associated with a schema, the view does not have records for associations between the contact and all the tables in the schema even though the tables inherit the association from the schema.

Columns¶

Column name	Data type	Description
CONTACT_DATABASE	TEXT	Name of the database in which the contact exists.
CONTACT_SCHEMA	TEXT	Name of schema in which the contact exists.
CONTACT_ID	NUMBER	Internal/system-generated identifier for the contact.
CONTACT_NAME	TEXT	Name of a contact.
CONTACT_PURPOSE	TEXT	Purpose that was specified when the contact was associated with the object.
OBJECT_DATABASE	TEXT	Name of the database that contains the referenced object. If the object is not a database or schema object, the value is empty.
OBJECT_SCHEMA	TEXT	Name of the schema that contains the referenced object. If the referenced object is not a schema object (for example, a warehouse), the value is empty.
OBJECT_ID	NUMBER	Internal/system-generated identifier of the referenced object.
OBJECT_NAME	TEXT	Name of the referenced object.
OBJECT_DELETED	TIMESTAMP_LTZ	Date and time when the referenced object was dropped or when its parent object was dropped.
OBJECT_DOMAIN	TEXT	Type of the referenced object.

Usage notes¶

Latency for the view is 2 hours.