- Schema:
For guidance on query performance when using organization-wide usage views, see Performance (Organization Usage).
CONTACT_
Important
This view is only available in the organization account. For more information, see Premium views in the organization account.
Organization Usage performance
When you query a specific view in the SNOWFLAKE.ORGANIZATION_USAGE schema, follow the organization-wide guidance in
Performance (Organization Usage): bound every scan on history views, list
columns explicitly, and use the time filter column table plus worked SQL and anti-patterns there.
This Organization 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¶
Organization-level columns
| Column Name | Data Type | Description |
|---|---|---|
| ORGANIZATION_NAME | VARCHAR | Name of the organization. |
| ACCOUNT_LOCATOR | VARCHAR | System-generated identifier for the account. |
| ACCOUNT_NAME | VARCHAR | User-defined identifier for the account. |
Additional 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 may be up to 240 minutes (4 hours).