Support Questions
Find answers, ask questions, and share your expertise

Set Initial Max Value for QueryDatabaseTable using value from a Cassandra table

New Contributor

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?