- Schema:
CONTACT_
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 | VARCHAR | Name of the database in which the contact exists. |
| CONTACT_SCHEMA | VARCHAR | Name of schema in which the contact exists. |
| CONTACT_ID | NUMBER | Internal/system-generated identifier for the contact. |
| CONTACT_NAME | VARCHAR | Name of a contact. |
| CONTACT_PURPOSE | VARCHAR | Purpose that was specified when the contact was associated with the object. |
| OBJECT_DATABASE | VARCHAR | 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 | VARCHAR | 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 | VARCHAR | 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 | VARCHAR | Type of the referenced object. |
Usage notes¶
- Latency for the view is 2 hours.