SEMANTIC_VIEWS view¶

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 displays a row for each semantic view in an account.

See also:: SEMANTIC_VIEWS view

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
SEMANTIC_VIEW_ID	NUMBER	Internal, Snowflake-generated identifier for the semantic view.
SEMANTIC_VIEW_NAME	VARCHAR	Name of the semantic view.
SEMANTIC_VIEW_SCHEMA_ID	NUMBER	Internal, Snowflake-generated identifier for the schema that the semantic view belongs to.
SEMANTIC_VIEW_SCHEMA_NAME	VARCHAR	Schema that the semantic view belongs to.
SEMANTIC_VIEW_DATABASE_ID	NUMBER	Internal, Snowflake-generated identifier for the database that the semantic view belongs to.
SEMANTIC_VIEW_DATABASE_NAME	VARCHAR	Database that the semantic view belongs to.
OWNER	VARCHAR	Name of the role that owns the semantic view.
CREATED	TIMESTAMP_LTZ	Creation time of the semantic view.
LAST_ALTERED	TIMESTAMP_LTZ	Date and time the object was last altered by a DDL or background metadata operation.
DELETED	TIMESTAMP_LTZ	Date and time when the semantic view was dropped.
COMMENT	VARCHAR	Comment for the semantic view.
MAX_STALESNESS_SEC	NUMBER	Maximum staleness in seconds allowed for the semantic view materialization. NULL if no materialization target lag is set.

Usage notes¶

Latency for the view may be up to 24 hours.