[Feature Request]: Support streaming inserts for bounded PCollections

[Bladieblah]

What would you like to happen?

Reading data from bigquery with a query string results in a bounded PCollection, which is fine. However, in order to handle row-level failures streaming loads are required, which are only supported on unbounded PColletions. Please add support for stream-inserts on bounded collections.

Issue Priority

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

Issue Components

• Component: Python SDK
• Component: Java SDK
• Component: Go SDK
• Component: Typescript SDK
• Component: IO connector
• Component: Beam YAML
• 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

[stankiewicz]

hi,
BigQueryIO has method
withMethod(Write.Method.STORAGE_WRITE_API_AT_LEAST_ONCE));
You can set it to streaming_insert if needed or use cheaper and better STORAGE_WRITE_API_AT_LEAST_ONCE