I have a feeling this is operator error, but I want to extract data from Redshift tables using custom date ranges in SQL.
I’ve added a Date&Time Configuration node to the workflow, and connected the port to the DB Table Selector coming out of the Amazon Redshift Connector node. When I run the workflow with hard coded dates, it works just fine.
I’ve tried this with sql_statement populated and not populated.
What I was expecting to happen was that the query would read the varStartDate and pulling everything starting at that point, but it would seem that it’s assuming the varStartDate is coming directly from the table as it returns errors that the particular date column is not in the table.
Also, when I convert the node to a component so that I can change the date - the varStartDate no longer exports:
This returns last 40 months. The problem is that I need to pull out 5 or so tables and want the flexibility to select various date parameters, but don’t want to open up 5 different nodes to manually change each time and I’m not sure what the issue is wiht the flow variable - is it because this is being inserted into a larger SQL code vs. one simple field?
fantastic - thank you. I tried with single quotes, and just about every different way, but apparently didn’t check single quotes AND no flow variable populated. So I had success. The second part of my issue is that I understand I should create a component so that it’s just a double click to set the date. But, you’ll note that the varStartDate is not in the output when I convert to component: