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 Interface
The Deploy Interface 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.
📄️ Environments
Learn how to configure Environments in Coalesce for deploying your data pipelines. This guide covers Environment setup, configuration options, and best practices for successful deployments.
🗃️ 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.