Skip to content

Change Write Disposition from WRITE_TRUNCATE to WRITE_APPEND#96

Merged
ryanmcdowell merged 1 commit intoGoogleCloudPlatform:masterfrom
ramenno:patch-1
Apr 13, 2020
Merged

Change Write Disposition from WRITE_TRUNCATE to WRITE_APPEND#96
ryanmcdowell merged 1 commit intoGoogleCloudPlatform:masterfrom
ramenno:patch-1

Conversation

@ramenno
Copy link
Copy Markdown
Contributor

@ramenno ramenno commented Apr 13, 2020

Setting a default template to delete all existing data in a BQ table not only limits its use, but is also a bit dangerous (as I just found out, all my existing data was gone when I started using Dataflow). Setting it to Append instead makes the template more useful. Most people who end up using this template probably want to schedule Dataflow to incrementally new data as it arrives. The trucation at the moment is a dangerous side effect, as someone running this template would have no clue they are going to lose all existing data by using this template.

Setting a default template to delete all existing data in a BQ table not only limits its use, but is also a bit dangerous (as I just found out, all my existing data was gone when I started using Dataflow). Setting it to Append instead makes the template more useful. Most people who end up using this template probably want to schedule Dataflow to incrementally new data as it arrives. The trucation at the moment is a dangerous side effect, as someone running this template would have no clue they are going to lose all existing data by using this template.
@googlebot
Copy link
Copy Markdown

Thanks for your pull request. It looks like this may be your first contribution to a Google open source project (if not, look below for help). Before we can look at your pull request, you'll need to sign a Contributor License Agreement (CLA).

📝 Please visit https://cla.developers.google.com/ to sign.

Once you've signed (or fixed any issues), please reply here with @googlebot I signed it! and we'll verify it.


What to do if you already signed the CLA

Individual signers
Corporate signers

ℹ️ Googlers: Go here for more info.

@googlebot googlebot added the cla: no The PR submitter does not have a CLA label Apr 13, 2020
@ramenno
Copy link
Copy Markdown
Contributor Author

ramenno commented Apr 13, 2020

@googlebot I signed it!

@googlebot
Copy link
Copy Markdown

CLAs look good, thanks!

ℹ️ Googlers: Go here for more info.

@googlebot googlebot added cla: yes The PR submitter has a CLA and removed cla: no The PR submitter does not have a CLA labels Apr 13, 2020
Copy link
Copy Markdown
Member

@sabhyankar sabhyankar left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Thanks @ramnathnayakpr

LGTM

@sabhyankar sabhyankar added the Google LGTM Approval of a pull request to be merged into the repository label Apr 13, 2020
@ryanmcdowell ryanmcdowell merged commit df38854 into GoogleCloudPlatform:master Apr 13, 2020
@iconde
Copy link
Copy Markdown

iconde commented Jun 19, 2020

By changing the WRITE_DISPOSITION option, this code is not coherent with what is explained in the Google documentation:
https://cloud.google.com/dataflow/docs/guides/templates/provided-batch#gcstexttobigquery
image

It could be a nice feature to add WRITE_DISPOSITION as a template parameter.

shreyakhajanchi pushed a commit that referenced this pull request Feb 11, 2025
* Add IT for Cassandra (#86)

* Add IT for Cassandra Reverse Replication

* Added IT Fixes

* Added IT fixes

* removed logger

* removed unwanted system log

* Handle Catch

* Handle with safehandler

* Running load test

* revert unwanted commit

* Added IT FIXES

* Added UT and removed unwanted SOUT

* Added One to Many Datatype Transformation for IT (#90)

Added One to Many Datatype Transformation for IT
Fix PR review comments

* Handle IT for MYSQL

* Added ByteBuffer TO BigInteger

* Cassandra rr custom transfornation it test (#96)

* PR Review Comments (#97)

* Splotless fixes

* Handle Retry Missing Exception Category

* Rebase Issue fixes

---------

Co-authored-by: pawankashyapollion <v-pawan.kumar@ollion.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

cla: yes The PR submitter has a CLA Google LGTM Approval of a pull request to be merged into the repository

Projects

None yet

Development

Successfully merging this pull request may close these issues.

5 participants