We have a SQL Server backing store that we use to store our data.
A simple SQL recipe created a table that we now need to update the schema on - we're making 2 text fields longer.
I switched the schema to be Manually Define, updated the length of the two fields and ran the flow. The table was created and populated correctly.
When I switch the schema back to Automatically Generate, the flow now has the previous lengths so I assume they are cached somewhere. I see them being used in the logs to create the table.
How can I tell DataIKU to update those cached values based on the data in the current table?
Thanks, that worked - it does look like that doesn't propagate when we use "Propagate schemas across Flow from here". Is there a way to make that happen, or do we need to adjust the length in the schema for each table individually?