SHOW DEPLOYMENTS IN DCM PROJECT¶

Shows all deployments for the specified DCM project.

该命令返回按创建日期排序的部署元数据和属性。

See also:: CREATE DCM PROJECT , ALTER DCM PROJECT, DESCRIBE DCM PROJECT , DROP DCM PROJECT, EXECUTE DCM PROJECT, SHOW DCM PROJECTS

语法

SHOW DEPLOYMENTS IN DCM PROJECT <name> [ LIMIT <rows> ]

必填参数

IN DCM PROJECT name: 指定包含要列出的部署的 DCM 项目的标识符。

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.

For more information, see Identifier requirements.

可选参数

LIMIT rows

Optionally limits the maximum number of rows returned. The actual number of rows returned might be less than the specified limit. For example, the number of existing objects is less than the specified limit.

Default: No value (no limit is applied to the output).

输出

命令输出在以下列中提供部署属性和元数据：

Column	Description
`created_on`	Date and time when the deployment was created.
`name`	Name of the deployment.
`alias`	User-specified deployment alias.
`deployment_file_path`	Full location URL for the deployment. Example: `snow://project/MY_DB.PUBLIC.P/deployment/deployment$2/`
`source_file_path`	Source location where this deployment is created from. This is the value provided with FROM `<source_location>`.
`git_commit_hash`	The Git commit hash that indicates the deployment of files in the Git repository from which the DCM project originates.

访问控制要求

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

权限	对象
MONITOR	DCM project

Operating on an object in a schema requires at least one privilege on the parent database and at least one privilege on the parent schema.

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.

示例

Show all deployments of the DCM project named my_project:

SHOW DEPLOYMENTS IN DCM PROJECT my_project;