Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug] BigQuery parameterization cannot handle in %s syntax #1033

Open
austinweisgrau opened this issue Apr 9, 2024 · 0 comments
Open

[Bug] BigQuery parameterization cannot handle in %s syntax #1033

austinweisgrau opened this issue Apr 9, 2024 · 0 comments
Labels
bug Impact - something is currently broken in Parsons and needs to be fixed

Comments

@austinweisgrau
Copy link
Collaborator

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.

@austinweisgrau austinweisgrau added the bug Impact - something is currently broken in Parsons and needs to be fixed label Apr 9, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Impact - something is currently broken in Parsons and needs to be fixed
Projects
None yet
Development

No branches or pull requests

1 participant