GET_CONTACTS¶

Returns the contacts associated with an object.

Syntax¶

SNOWFLAKE.CORE.GET_CONTACTS (
  '<object_name>',
  '<object_type>'
  [ , '<contact_name>' ]
)

Copy

'object_name'

Name of an object that can have contacts associated with it.

'object_type'

Type of the specified object. Possible values are DATABASE, SCHEMA, and TABLE (for all table-like objects contained in a database and schema).

For a list of supported object types, see Supported objects.

'contact_name': Name of a contact. If a contact is specified, the function doesn’t return information about other contacts that are associated with the specified object.

Returns a table, where each row has the following columns:

Title¶
Column	Data type	Description
`purpose`	VARCHAR	Describes the relationship between the contact and the specified object. The purpose helps you distinguish between contacts associated with the object so you know who to communicate with for assistance. For example, an ACCESS_APPROVAL purpose indicates that the contact can help you get access to the object.
`email_distribution_list`	VARCHAR	Email addresses that can be used to contact someone about the object.
`url`	VARCHAR	A URL that can be used to contact someone about the object.
`user`	VARCHAR	User who can be contacted about the object.
`level`	VARCHAR	Type of object with which the contact was associated. You can use the level to determine where within the object hierarchy the contact was associated. Possible values include DATABASE, SCHEMA, and TABLE (for all table-like objects contained in a database and schema).

Note

The name of the contact object is intentionally omitted from the output of this function.

You must have the CORE_VIEWER database role to call this function.

If a contact object includes a list of users, this function returns a separate row for each user in the list.

Return a row for each contact associated with the table t1.

SELECT * FROM TABLE(SNOWFLAKE.CORE.GET_CONTACTS('t1', 'TABLE'));

Copy