Deploy and Refresh
The Coalesce Scheduler is now available. Schedule refreshes directly in the app. Read more in Scheduling Jobs in Coalesce.
Understanding Deploy and Refresh
Here's how Deploy and Refresh are different.
Deploy and Create
Deploy handles structural changes to your data warehouse by:
- Creating or modifying columns and tables
- Executing DDL (Data Definition Language) statements
- Performing ALTER, CREATE, and DELETE operations
Refresh and Run
Refresh handles data transformations by:
- Running defined transformations
- Executing DML (Data Manipulation Language) statements
- Performing MERGE, INSERT, UPDATE, and TRUNCATE operations
Getting Started
Here are the recommended steps for getting started:
- Configure your Environment settings.
- Deploy your pipeline.
- Create and schedule refresh Jobs using the Coalesce Scheduler.
- Monitor deployment and refresh status.
Deploy and Refresh Methods
| Location | Deploy | Refresh and Jobs |
|---|---|---|
| Coalesce App | ✔️ | ✔️ |
| CLI | ✔️ | ✔️ |
| REST API | ✔️ | |
| DevOps Platform | ✔️ | ✔️ |
📄️ The Deploy Page
Navigate the Coalesce Deploy Page interface for managing data transformation deployments and pipeline history. Master the deployment dashboard, activity feeds, individual run monitoring, and deployment status tracking to efficiently manage enterprise data warehouse projects and maintain deployment visibility.
🗃️ Parameters
3 items
🗃️ Deploy
4 items
🗃️ Refresh
3 items
🗃️ Third Party DevOps Tools
2 items
📄️ Troubleshooting Deploys and Refreshes
Master job monitoring and troubleshooting in Coalesce data transformation platform. Learn to analyze deployment results, understand error messages, debug failed pipeline jobs, and implement solutions for common data warehouse deployment issues to ensure reliable transformations and continuous delivery workflows.