apache/beam

Python SDK BigQuery `schemaUpdateOptions`

Open

#21,141 opened on Jun 4, 2022

View on GitHub
 (2 comments) (0 reactions) (1 assignee)Java (4,097 forks)batch import
P3gcpgood first issueimprovementiopythonusability

Repository metrics

Stars
 (7,313 stars)
PR merge metrics
 (Avg merge 6d) (243 merged PRs in 30d)

Description

I noticed that in the Java SDK schemaUpdateOptions are exposed clearly to the user: https://beam.apache.org/releases/javadoc/2.32.0/org/apache/beam/sdk/io/gcp/bigquery/BigQueryIO.Write.html

 

Whereas, in the Python SDK this option seems to only be able to be passed through additional_bq_paramaters. 

 

Is this something which should be resolved? Perhaps add the schemaUpdateOptions to https://github.com/apache/beam/blob/b9457b711029051a837255e1bb516e55d32e56d5/sdks/python/apache_beam/io/gcp/bigquery.py#L437 and expose a kwarg to pass them in? 

Imported from Jira BEAM-12994. Original Jira may contain additional context. Reported by: judah.rand.

Contributor guide

Research direction
Study the Java SDK's BigQueryIO.Write class to understand how schemaUpdateOptions are exposed. Then examine the Python SDK's bigquery.py module, specifically the WriteToBigQuery transform and its parameters, to identify where to add schemaUpdateOptions as a named argument. Ensure backward compatibility and proper type hinting.
Tech stack
python
Domain
dataapi
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
Python SDKBigQuery
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
60