I have pipeline parameter name run_id = 123 in configuration and inside jdbc query i want to pass following query:
SELECT * FROM test WHERE id = ${run_id}
I have pipeline parameter name run_id = 123 in configuration and inside jdbc query i want to pass following query:
SELECT * FROM test WHERE id = ${run_id}
If run_id value is a number then we don’t need quote for numbers and if its a string value then we have to put into in single quote.
SELECT * FROM test WHERE id = ${run_id}. ( If the run_id is a number)
SELECT * FROM test WHERE id = ‘${run_id}’ (If run id is a string)
The issue was, beacues i have passed run_id in parametr in double quotes but only one quotes is allowed...
org.postgresql.util.PSQLException: ERROR: column "de89higjl-2fdf-4a9c-9447-01cacc661e0d" does not exist. Where "de89higjl-2fdf-4a9c-9447-01cacc661e0d" is a value of run_id parameter.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.