- Schema:
For guidance on query performance when using organization-wide usage views, see Performance (Organization Usage).
SEMANTIC_
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 dimension defined in a semantic view.
- See also:
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_DIMENSION_ID | NUMBER | ID of the dimension in the semantic view. |
| SEMANTIC_DIMENSION_NAME | VARCHAR | Name of the dimension in the semantic view. |
| SEMANTIC_TABLE_ID | NUMBER | ID of the semantic table the dimension belongs to. |
| SEMANTIC_TABLE_NAME | VARCHAR | Name of the semantic table the dimension belongs to. |
| SEMANTIC_VIEW_ID | NUMBER | ID of the semantic view. |
| SEMANTIC_VIEW_NAME | VARCHAR | Name of the semantic view. |
| SEMANTIC_VIEW_SCHEMA_ID | NUMBER | ID of the schema to which the semantic view belongs. |
| SEMANTIC_VIEW_SCHEMA_NAME | VARCHAR | Schema to which the semantic view belongs. |
| SEMANTIC_VIEW_DATABASE_ID | NUMBER | ID of the database to which the semantic view belongs. |
| SEMANTIC_VIEW_DATABASE_NAME | VARCHAR | Database to which the semantic view belongs. |
| DATA_TYPE | VARCHAR | Data type of the dimension expression. |
| EXPRESSION | VARCHAR | The SQL expression used to calculate the dimension. |
| SYNONYMS | ARRAY | List of the synonyms for the dimension. |
| CREATED | TIMESTAMP_LTZ | Creation time of the dimension. |
| 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 dimension was dropped. |
| COMMENT | VARCHAR | Description of the dimension. |
| CORTEX_SEARCH_SERVICE_DATABASE | VARCHAR | Name of the database containing the Cortex Search Service that the dimension uses. |
| CORTEX_SEARCH_SERVICE_SCHEMA | VARCHAR | Name of the schema containing the Cortex Search Service that the dimension uses. |
| CORTEX_SEARCH_SERVICE | VARCHAR | Name of the Cortex Search Service that the dimension uses. |
| CORTEX_SEARCH_SERVICE_COLUMN | VARCHAR | Name of the column that the Cortex Search Service allows you to search on. |
| LABELS | ARRAY | List of labels associated with the dimension. |
| LOD_DIMENSIONS | ARRAY | List of dimensions that define the level of detail for the dimension. |
| LOD_DIMENSION_TYPE | VARCHAR | Type of level-of-detail dimension applied to the dimension. |
Usage notes¶
- Latency for the view may be up to 24 hours.