Using the Redshift connector, you can parameterize an in statement like so:
Redshift().query("select * from table where value in %s", parameters=[tuple(values)])
However, with the BigQuery connector, this kind of syntax results in a syntax error.
Detailed Description
To Reproduce
Your Environment
Version of Parsons used (if you know):
Environment name and version (e.g. Chrome 39, node.js 5.4):
Operating System and version (desktop or mobile):
Additional Context
Add any other context about the problem here.
Priority
Please indicate whether fixing this bug is high, medium, or low priority for you. If the issue is time-sensitive for you, please let us know when you need it addressed by.
Using the Redshift connector, you can parameterize an
instatement like so:Redshift().query("select * from table where value in %s", parameters=[tuple(values)])However, with the BigQuery connector, this kind of syntax results in a syntax error.
Detailed Description
To Reproduce
Your Environment
Additional Context
Add any other context about the problem here.
Priority
Please indicate whether fixing this bug is high, medium, or low priority for you. If the issue is time-sensitive for you, please let us know when you need it addressed by.