SHOW DEPLOYMENTS IN DCM PROJECT¶

Shows all deployments for the specified DCM project.

The command returns deployment metadata and properties, ordered by creation date.

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

Syntax¶

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

Required parameters¶

IN DCM PROJECT name

Specifies the identifier of the DCM project that contains the deployments to list.

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.

Optional parameters¶

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).

Output¶

The command output provides deployment properties and metadata in the following columns:


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.

Access control requirements¶

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


Privilege	Object
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.

Examples¶

Show all deployments of the DCM project named my_project:

SHOW DEPLOYMENTS IN DCM PROJECT my_project;