Schema:: ACCOUNT_USAGE

SHARES view¶

This Account Usage view returns all the shares owned by the current account, including dropped shares. The information in this view has a latency of up to 3 hours.

Columns¶

The following table provides definitions for the SHARES view columns.

Column	Data type	Description
CREATED_ON	TIMESTAMP_LTZ	The timestamp when the share was created.
MODIFIED_ON	TIMESTAMP_LTZ	The timestamp when the share was last updated.
DELETED_ON	TIMESTAMP_LTZ	The timestamp when the share was deleted. This value is NULL if the share hasn’t been deleted.
NAME	VARCHAR	The name of the share.
OWNER	VARCHAR	The name of the role that owns the share.
COMMENT	VARCHAR	Comment associated with the share, if any.
DATABASE_NAME	VARCHAR	The name of the primary database associated with the share. This field is empty if no database has been granted to the share.
SECURE_OBJECTS_ONLY	BOOLEAN	Indicates whether the share can only have secure objects granted to it.
TARGET_ACCOUNTS	VARCHAR	A comma-separated list of target accounts the share is shared with (outbound). This field is empty if the share has no target accounts.
LISTING_GLOBAL_NAME	VARCHAR	Global unique name of the listing associated with the share, if any.