I'm working on a JDBC connection to Redshift, which is a flavor of PSQL, and passing in 2 parameters. I know the way to reference the parameters in Redshift is to use the ":var_name" syntax (note the colon at the beginning).
Basically, if I have 2 dynamic parameters set in Boomi and pass it into the SQL, what are they called? I've tried referencing with ":1" and ":2" but that hasn't worked.
How do I even see the full text being submitted to the database? I'm getting pretty frustrated with the limitations in the logs, as I can't see the query that's being sent.