Qlik Compose Deployment

[mopidesp]

Hello,

We are trying to deploy  a project with some changes from Dev to STG environment. This project  is already present in STG environment. We have added some new tables in Dev and deploying to STG. During STG migration, when we try to validate under Data Warehouse section -- instead of auto adjusting , its asking to generate the script. And auto adjust script is disabled. Some times , it gives the option to auto adjust.

May I know in which scenarios auto adjust is enabled and in which scenarios its disabled.

Thanks for your time

[TimGarrod]

Please review the documentation on validating the data warehouse - https://help.qlik.com/en-US/compose/May2021/Content/ComposeDWDL/Main/DW/Data%20Warehouse/validate_da...

Note that Compose will always try to auto-adjust if possible.  However, we want to be sure you are aware if the change could cause data loss / integrity issues in the data warehouse. 

For example if you reduce the length of a data type - that would likely mean some data loss. 

If you add a column to an existing KEY for an entity - you must adjust the script to populate the new column as a key value cannot be null.     So any time you cannot adjust automatically - its actually for your own data safety / integrity.   The script will then have sections commented as TODO - and you should validate those sections of the scripts. 

Hope that helps.