OUTPUT_DEPLOYMENT_STATUS

Contains information about the deployment status of all the projections in your design. Each row contains information about a different projection. Vertica populates this table when you deploy the database design by running the function DESIGNER_RUN_POPULATE_DESIGN_AND_DEPLOY.

Column Name Column Type Description
deployment_id INTEGER

Unique ID that Database Designer assigned to the deployment.
design_name VARCHAR

Unique name that the user assigned to the design.
deployment_projection_id INTEGER

Unique ID that Database Designer assigned to the output projection.
deployment_projection_name VARCHAR

Name that Database Designer assigned to the output projection or the name of the projection to be dropped.
deployment_status VARCHAR

Status of the deployment:

  • pending
  • complete
  • needs_refresh
  • in_progress
  • error
error_message VARCHAR

Text of any error that occurred when creating or refreshing the specified projection.