DB Table Selector with Flow Variables
I have a small workflow trying to build. Pulling data from an Amazon Redshift Connector. I want the option for variable dates based on inputs.
I created a component that gives a start and end date (named varStartDate and varEndDate). Passed through to Table Row to Variable.
The Amazon Redshift Connector was successful, and passes through to the DB Table Selector and passes through successfully, as does the DB Reader.
(the FROM is not actual, changed for privacy issues). I have a simple query where I want to bring back all data starting on varStartDate and if possible, end varEndDate.
I’ve put varStart Date in sqlstatement (and customquery), but my output contains ALL dates
For this example, here is the start/end date:
All dates are being returned:
I’m sure this is operator error, what am I missing?