The Compose CLI functionality can be incorporated into a script to easily update Custom ETLs.
The following custom ETL types are supported for the below syntax:
Data Warehouse and Data Mart tasks: Pre-Loading and Post-Loading
Data Warehouse tasks: Single Table and Multi Table
Syntax:
composecli update_custom_etls --project name --infolder path
Where:
project is the name of the project with the custom ETLs you want to update
infolder is the full path to the folder containing the custom ETL files
Example:
composecli update_custom_etls --project my-project --infolder c:\Compose\CustomETLs
Note:
- This option is available in versoin 2022.5-sp07(2022.5.523) and above
- The file names must be identical to the custom ETL names in the specified project. Otherwise, an error will occur. The file extension (e.g.. txt) is not important, but the file must be in SQL format.