Query parameters on Google BigQuery

Feature Requests (done)
1

The idea is:

The current version of Google Big Query node (2.1) does not support query parameters, like PostgreSQL or MySQL. This was already bad, but now with AI agents, where you can let the model choose the value for query parameters when they’re available, BigQuery becomes much less useful.

My use case:

The general use case for Query Parameters: avoid SQL injection. And now with AI agents, let the agent customize a query via Query Parameters.

I think it would be beneficial to add this because:

This makes data in Google Big Query much more useful!

Any resources to support this?

BigQuery Documentation

Are you willing to work on this?

Yes.

1 Like
2

Hi @miguel-mconf, this has been implemented in the meantime! Check out feat(Google BigQuery Node): Add parameterized query support by killthekitten · Pull Request #14302 · n8n-io/n8n · GitHub

2 Likes
3

Great! I’ve been using it for some time now, and even forgot I’ve made the Feature Request.
It seems it was merged on 1.106.0.
Thank you for you attention, and feel free to close this topic.

1 Like