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

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.