Coalesce - Trigger Job

info

This Blueprint is classified as "Free" and does not incur billable runtime. Learn more.

Overview

Trigger the execution of a Coalesce job.

Recommended Setup It is recommended to set the Wait For Completion input to TRUE so that the blueprint completes once the Coalesce job has finished.

Parameters Parameters can be used within the blueprint by passing in the JSON format of the parameters like so:

{ "foo": "bar1" }

If you provide a value for a parameter that is different than the default value (defined in the Coalesce UI), the value provided will be used for the refresh.

Variables

Name	Reference	Type	Required	Default	Options	Description
Access Token	COALESCE_ACCESS_TOKEN	Password	✅	-	-	The API token generated in Coalesce
Environment ID	COALESCE_ENVIRONMENT_ID	Alphanumeric	✅	-	-	The environment to be refreshed
Job ID	COALESCE_JOB_ID	Alphanumeric	➖	-	-	The ID of the job being run
Snowflake Username	COALESCE_SNOWFLAKE_USERNAME	Alphanumeric	✅	-	-	Snowflake account username
Snowflake Password	COALESCE_SNOWFLAKE_PASSWORD	Password	✅	-	-	Snowflake account password
Snowflake Role	COALESCE_SNOWFLAKE_ROLE	Alphanumeric	➖	-	-	Snowflake user role
Snowflake Warehouse	COALESCE_SNOWFLAKE_WAREHOUSE	Alphanumeric	➖	-	-	Snowflake compute warehouse
Include Nodes Selector	COALESCE_INCLUDE_NODES_SELECTOR	Alphanumeric	➖	-	-	The nodes to be included on a ad-hoc job run
Exclude Nodes Selector	COALESCE_EXCLUDE_NODES_SELECTOR	Alphanumeric	➖	-	-	The nodes to be excluded for an ad-hoc job run
Parallelism	COALESCE_PARALLELISM	Integer	➖	16	-	The maximum number of parallel nodes to run
Wait For Completion	COALESCE_WAIT	Boolean	➖	TRUE	-	Enable if you want the vessel to wait until the sync job is successfully completed. Otherwise, the vessel will only initiate the sync job without waiting
Parameters	COALESCE_PARAMETERS	Alphanumeric	➖	-	-	The optional parameters to use which are defined in the Coalesce UI. Format should be JSON where the Key is the name of the parameter and the Value is what the parameter should be.

YAML

Below is the YAML template for this Blueprint and can be used in the Fleet YAML Editor.

source:
  blueprint: Coalesce - Trigger Job
  inputs:
    COALESCE_ACCESS_TOKEN: null  ## REQUIRED
    COALESCE_ENVIRONMENT_ID: null ## REQUIRED
    COALESCE_JOB_ID: null
    COALESCE_SNOWFLAKE_USERNAME: null ## REQUIRED
    COALESCE_SNOWFLAKE_PASSWORD: null ## REQUIRED
    COALESCE_SNOWFLAKE_ROLE: null
    COALESCE_SNOWFLAKE_WAREHOUSE: null
    COALESCE_INCLUDE_NODES_SELECTOR: null
    COALESCE_EXCLUDE_NODES_SELECTOR: null
    COALESCE_PARALLELISM: 16
    COALESCE_WAIT: 'TRUE'
    COALESCE_PARAMETERS: null
  type: BLUEPRINT
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - '0'