SHOW VERSIONS IN ORGANIZATION PROFILE¶

列出您有权访问的组织配置文件版本。

See also:: ALTER ORGANIZATION PROFILE, CREATE ORGANIZATION PROFILE, DESCRIBE AVAILABLE ORGANIZATION PROFILE, DESCRIBE ORGANIZATION PROFILE, DROP ORGANIZATION PROFILE, SHOW AVAILABLE ORGANIZATION PROFILES

语法

SHOW VERSIONS IN ORGANIZATION PROFILE <name>

参数

name

指定要列出其组织配置文件版本的组织配置文件的标识符。只能包含大写字符或数字。

If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case sensitive. See Identifier requirements.

输出

命令的输出包括以下列，它们描述了对象的属性和元数据：

Column	Description
`created_on`	The date and time when the organization profile was created.
`name`	The organization profile name.
`alias`	The user-defined alias for the organization profile version.
`location_uri`	The URI for the organization profile version.
`is_live`	The organization profile version is live. One of `TRUE` or `FALSE`.
`is_default`	The organization profile version is the default. One of `TRUE` or `FALSE`. Must be `FALSE` when `is_live` is `TRUE`.
`is_first`	The organization profile is the first version. One of `TRUE` or `FALSE`.
`is_last`	The organization profile is the last version. One of `TRUE` or `FALSE`.
`comment`	Comments added by users.
`source_location_uri`	The source location URI for the organization profile version.
`git_commit_hash`	The git commit hash for the organization profile version when it’s created from a git source. `NONE` when a git commit hash is unavailable.

访问控制要求

A role used to execute this operation must have the following privileges at a minimum:

Privilege	Object	Notes
MODIFY	Organization profile

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

示例

The following example lists the organization profile versions in the organization profile MYORGANIZATIONPROFILE that you have the privileges to access:

SHOW VERSIONS IN ORGANIZATION PROFILE myorganizationprofile;

+------------------------+---------------------+---------------------+-----------------------------------------------+---------------------+---------------------+-------------+-----------------+---------------------+---------------------+----------------+
|created_on              |name                 |alias                |location_uri                                   |is_live              |is_default           |is_first     |is_last          |comment              |source_location_uri  |git_commit_hash |
+------------------------+---------------------+---------------------+-----------------------------------------------+---------------------+---------------------+-------------+-----------------+---------------------+---------------------+----------------+
|2025-01-01 01:01:01.000 |VERSION$1            |V1                   |snow://notebook/mynotebook/versions/version$1  |TRUE                 |FALSE                |TRUE         |FALSE            |                     |@TESTDB.PUBLIC.STAGE |NONE            |
+------------------------+---------------------+---------------------+-----------------------------------------------+---------------------+---------------------+-------------+-----------------+---------------------+---------------------+----------------+