I have a SQL query that is very large. It conditionally loads new items from database using an IN() statement that is long (10k items per chunk). The query is appended to the metadata and makes the flow file enormous and unresponsive.
Is there a way I can 'fool' the flow into forgetting the source metadata, or edit the metadata to remove it?
Possibly something like this: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Execute-all-SQL-files-in-a-folder-and-...
Maybe managing the SQL files externally and then executing them via a macro