[jira] [Resolved] (BEAM-6611) A Python Sink for BigQuery with File Loads in Streaming

["Pablo Estrada (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/BEAM-6611?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pablo Estrada resolved BEAM-6611.
---------------------------------
    Resolution: Fixed

> A Python Sink for BigQuery with File Loads in Streaming
> -------------------------------------------------------
>
>                 Key: BEAM-6611
>                 URL: https://issues.apache.org/jira/browse/BEAM-6611
>             Project: Beam
>          Issue Type: Improvement
>          Components: sdk-py-core
>            Reporter: Pablo Estrada
>            Assignee: Tanay Tummalapalli
>            Priority: Major
>              Labels: gsoc, gsoc2019, mentor
>             Fix For: 2.16.0
>
>          Time Spent: 10h 50m
>  Remaining Estimate: 0h
>
> The Java SDK supports a bunch of methods for writing data into BigQuery, while the Python SDK supports the following:
> - Streaming inserts for streaming pipelines [As seen in [bigquery.py and BigQueryWriteFn|https://github.com/apache/beam/blob/master/sdks/python/apache_beam/io/gcp/bigquery.py#L649-L813]]
> - File loads for batch pipelines [As implemented in [PR 7655|https://github.com/apache/beam/pull/7655]]
> Qucik and dirty early design doc: https://s.apache.org/beam-bqfl-py-streaming
> The Java SDK also supports File Loads for Streaming pipelines [see BatchLoads application|https://github.com/apache/beam/blob/master/sdks/java/io/google-cloud-platform/src/main/java/org/apache/beam/sdk/io/gcp/bigquery/BigQueryIO.java#L1709-L1776].
> File loads have the advantage of being much cheaper than streaming inserts (although they also are slower for the records to show up in the table).



--
This message was sent by Atlassian Jira
(v8.3.2#803003)