• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
New Topic
Discussions Enhancement Requests Other Ideas
o

operations@pageantmedia.com

started a topic over 4 years ago

The ability to pass data pill variables into SQL Queries (specifically Redshift)

I have been told by the Workato team that it is not possible to pass a variable into a SQL query on Redshift like so:


image


Instead the query has to written statically like so:


image


I was told that there is no workaround for this and that it is intended.


Is it possible to change this because what can we do if we have a list of values to each make an SQL query to? It is not possible with the current implementation


As far as we know, other automation applications like Integromat and Zapier support this feature.


Is there a reason it does not exist in Workato?

Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2022   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count