Coalesce provides several mechanisms for viewing the results of a deployment that can be leveraged for troubleshooting.
Viewing the Results of a Deploy
The results of a deploy are available via the Activity Feed in the UI or the Command Line Interface (CLI) log, and/or the REST API via the results endpoint.
The Activity Feed in the Coalesce app (UI) provides details of both deploys and refreshes within your organization and is available via the right panel of the Deploy Interface.
You are able to apply filters to the results to limit by Project, Environment, type (deploy and/or refresh), and status.
The Activity Feed provides full details for each Deploy in a visual interface. These details include:
- Connection details
- Parameters used
- Details for each Node + steps for a Node
- Snowflake query ID
- Error message(s), if any
Command Line Interface (CLI)
The same details available in the Activity Feed about a deploy are logged by the CLI when the CLI is leveraged for deploy and can be actioned upon depending upon your requirements and orchestration method. See the CLI Deploy section of the Coalesce documentation for more information.
The same details available in the Activity Feed about a deploy are available via the API using the results endpoint. See the List Run Results section of the Coalesce documentation for more information.
In the case of any errors, Coalesce surfaces detailed error messages at the level of the step for the Node that failed; the developer can then use these error messages and the other associated information, such as the Snowflake query ID and SQL, to identify and resolve the source of the error.
Rolling Back a Deployment
In the case of failed deployment or just a general need to return to a previously deployed state, a deployment can be rolled back via the process described in the How-To: Rollback a Deployment article.