CONTACTS view¶

This Account Usage view displays a row for each contact in the account.

Columns¶

Column name	Data type	Description
CONTACT_ID	NUMBER	Internal/system-generated identifier of the contact.
CONTACT_NAME	TEXT	Name of the contact.
CONTACT_SCHEMA_ID	NUMBER	Internal/system-generated identifier of the schema in which the contact exists.
CONTACT_SCHEMA	TEXT	Name of the schema in which the contact exists.
CONTACT_DATABASE_ID	NUMBER	Internal/system-generated identifier of the database in which the contact exists.
CONTACT_DATABASE	TEXT	Name of the database in which the contact exists.
CONTACT_OWNER	TEXT	Name of the role that owns the contact.
CONTACT_OWNER_ROLE_TYPE	TEXT	Type of role that owns the object. Either ROLE, DATABASE_ROLE, or APPLICATION (if a Snowflake Native App owns the object). Deleted contacts have a NULL value.
CONTACT_USERS	ARRAY	Array of Snowflake users to contact.
CONTACT_EMAIL_DISTRIBUTION_LIST	TEXT	Email address used to communicate with the contact.
CONTACT_URL	TEXT	URL used to communicate with the contact.
COMMENT	TEXT	Comments for the contact, if any.
CREATED	TIMESTAMP_LTZ	Date and time when the contact was created.
LAST_ALTERED	TIMESTAMP_LTZ	Date and time the object was last altered.
DELETED	TIMESTAMP_LTZ	Date and time when the contact was dropped or the date and time when its parent was dropped.