apache / apache/beam

[Feature Request]: Parameterized Query support in Go BigQuery IO connector

Open
#25,096 1 comment 0 reactions 1 assignee Claimed by @jvnuw View on GitHub
go io new feature P2
Dominant language
Java
Stars
8.7k
Forks
4.7k
Avg merge
1d 20h
Merged PRs (30d)
196

Description

### What would you like to happen?

The standard BigQuery library for Go supports [parameterized queries](https://cloud.google.com/bigquery/docs/parameterized-queries#go), and the BigQuery IO connector for Go should too.

I personally have a use case for this feature. A beam pipeline is sharing an SQL query with a user facing service. That service benefits from using query parameters as one layer of protection against SQL injection attacks. The beam pipeline needs the ability to set its own internal values for those parameters, if the query is to remain shared rather than duplicated.

Another likely use case is for beam pipelines which need to include externally-provided values in their SQL queries, and would directly benefit from the SQL injection protection of parameterized queries.

### Issue Priority

Priority: 2 (default / most feature requests should be filed as P2)

### Issue Components

- [ ] Component: Python SDK
- [ ] Component: Java SDK
- [X] Component: Go SDK
- [ ] Component: Typescript SDK
- [X] Component: IO connector
- [ ] Component: Beam examples
- [ ] Component: Beam playground
- [ ] Component: Beam katas
- [ ] Component: Website
- [ ] Component: Spark Runner
- [ ] Component: Flink Runner
- [ ] Component: Samza Runner
- [ ] Component: Twister2 Runner
- [ ] Component: Hazelcast Jet Runner
- [ ] Component: Google Cloud Dataflow Runner

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.