OUTPUT_DEPLOYMENT_STATUS

Contains information about the deployment status of all the projections in your design.

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.