I am using QueryDatabaseTable to fetch new values in a MS SQL table.Upon initial start up, I need to set the initial max value to a value that will be stored in a Cassandra table. The value in this table will be updated at the end of the flow. We chose this method as a measure to avoid data lose in the event of a DR failover or flow redeployment.
Here are my questions:
1.) How do I ensure that this value is called and set only once before the QueryDatabaseTable begins to query values.
2.) Is this even the right direction for this problem? Is there a better way of going about this?