Deploy and Refresh
Coalesce Scheduler
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
The Deploy Page is where you can deploy your project's metadata from the desired state in your git repository, and see a history of your pipeline's Deploys and Refreshes.
🗃️ 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. Learn how to analyze job results, understand error messages, debug failed jobs, and implement solutions for common pipeline issues to ensure reliable data transformations.