Hi,
I have a workflow that runs every Sunday and populates a table in Snowflake with the prior week's data. This workflow contains a stored procedure that pulls data from SQL Server. Recently, the stored procedure has been updated to populate existing fields in the Snowflake table that were previously NULL. Additionally, the Snowflake table has had new fields added to it, and the stored procedure has been altered to populate these fields as well. I have also altered the workflow to include these new fields.
However, after the execution of the workflow, while the existing fields that previously didn't have data are now populated, the new fields remain unpopulated, showing a value of NULL.
A few details that might help in troubleshooting:
Any suggestions or insights would be much appreciated. Thank you!