You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@beam.apache.org by GitBox <gi...@apache.org> on 2020/09/23 16:52:52 UTC
[GitHub] [beam] rincon-santi opened a new pull request #12916: Added explanation and examples for dynamic destination data writing to big query (python)
rincon-santi opened a new pull request #12916:
URL: https://github.com/apache/beam/pull/12916
I have found that now it's possible to apply dynamic destination with python when saving in big query tables through IO, and updated the documentation accordingly.
Source: https://beam.apache.org/releases/pydoc/2.19.0/apache_beam.io.gcp.bigquery.html#writing-data-to-bigquery
------------------------
Thank you for your contribution! Follow this checklist to help us incorporate your contribution quickly and easily:
- [ ] [**Choose reviewer(s)**](https://beam.apache.org/contribute/#make-your-change) and mention them in a comment (`R: @username`).
- [ ] Format the pull request title like `[BEAM-XXX] Fixes bug in ApproximateQuantiles`, where you replace `BEAM-XXX` with the appropriate JIRA issue, if applicable. This will automatically link the pull request to the issue.
- [ ] Update `CHANGES.md` with noteworthy changes.
- [ ] If this contribution is large, please file an Apache [Individual Contributor License Agreement](https://www.apache.org/licenses/icla.pdf).
See the [Contributor Guide](https://beam.apache.org/contribute) for more tips on [how to make review process smoother](https://beam.apache.org/contribute/#make-reviewers-job-easier).
Post-Commit Tests Status (on master branch)
------------------------------------------------------------------------------------------------
Lang | SDK | Dataflow | Flink | Samza | Spark | Twister2
--- | --- | --- | --- | --- | --- | ---
Go | [](https://ci-beam.apache.org/job/beam_PostCommit_Go/lastCompletedBuild/) | --- | [](https://ci-beam.apache.org/job/beam_PostCommit_Go_VR_Flink/lastCompletedBuild/) | --- | [](https://ci-beam.apache.org/job/beam_PostCommit_Go_VR_Spark/lastCompletedBuild/) | ---
Java | [](https://ci-beam.apache.org/job/beam_PostCommit_Java/lastCompletedBuild/) | [](https://ci-beam.apache.org/job/beam_PostCommit_Java_ValidatesRunner_Dataflow/lastCompletedBuild/)<br>[](https://ci-beam.apache.org/job/beam_PostCommit_Java_ValidatesRunner_Dataflow_Java11/lastCompletedBuild/) | [](https://ci-beam.apache.org/job/beam_PostCommit_Java_ValidatesRunner_Flink/lastCompletedBuild/)<br>[](https://ci-beam.apache.org/job/beam_PostCommit_Java_ValidatesRunner_Flink_Java11/lastCompletedBuild/)<br>[](https://ci-beam.apache.org/job/beam_PostCommit_Java_PVR_Flink_Batch/lastCompletedBuild/)<br>[](https://ci-beam.apache.org/job/beam_PostCommit_Java_PVR_Flink_Streaming/lastCompletedBuild/) | [](https://ci-beam.apache.org/job/beam_PostCommit_Java_ValidatesRunner_Samza/lastCompletedBuild/) | [](https://ci-beam.apache.org/job/beam_PostCommit_Java_ValidatesRunner_Spark/lastCompletedBuild/)<br>[](https://ci-beam.apache.org/job/beam_PostCommit_Java_PVR_Spark_Batch/lastCompletedBuild/)<br>[](https://ci-beam.apache.org/job/beam_PostCommit_Java_ValidatesRunner_SparkStructuredStreaming/lastCompletedBuild/) | [](https://ci-beam.apache.org/job/beam_PostCommit_Java_ValidatesRunner_Twister2/lastCompletedBuild/)
Python | ](https://ci-beam.apache.org/job/beam_PostCommit_Python36/lastCompletedBuild/)<br>[](https://ci-beam.apache.org/job/beam_PostCommit_Python37/lastCompletedBuild/)<br>[](https://ci-beam.apache.org/job/beam_PostCommit_Python38/lastCompletedBuild/) | [](https://ci-beam.apache.org/job/beam_PostCommit_Py_VR_Dataflow/lastCompletedBuild/)<br>[](https://ci-beam.apache.org/job/beam_PostCommit_Py_VR_Dataflow_V2/lastCompletedBuild/)<br>[](https://ci-beam.apache.org/job/beam_PostCommit_Py_ValCont/lastCompletedBuild/) | [](https://ci-beam.apache.org/job/beam_PreCommit_Python_PVR_Flink_Cron/lastCompletedBuild/)<br>[](https://ci-beam.apache.org/job/beam_PostCommit_Python_VR_Flink/lastCompletedBuild/) | --- | [](https://ci-beam.apache.org/job/beam_PostCommit_Python_VR_Spark/lastCompletedBuild/) | ---
XLang | [](https://ci-beam.apache.org/job/beam_PostCommit_XVR_Direct/lastCompletedBuild/) | --- | [](https://ci-beam.apache.org/job/beam_PostCommit_XVR_Flink/lastCompletedBuild/) | --- | [](https://ci-beam.apache.org/job/beam_PostCommit_XVR_Spark/lastCompletedBuild/) | ---
Pre-Commit Tests Status (on master branch)
------------------------------------------------------------------------------------------------
--- |Java | Python | Go | Website | Whitespace | Typescript
--- | --- | --- | --- | --- | --- | ---
Non-portable | [](https://ci-beam.apache.org/job/beam_PreCommit_Java_Cron/lastCompletedBuild/) | [](https://ci-beam.apache.org/job/beam_PreCommit_Python_Cron/lastCompletedBuild/)<br>[](https://ci-beam.apache.org/job/beam_PreCommit_PythonLint_Cron/lastCompletedBuild/)<br>[](https://ci-beam.apache.org/job/beam_PreCommit_PythonDocker_Cron/lastCompletedBuild/) <br>[](https://ci-beam.apache.org/job/beam_PreCommit_PythonDocs_Cron/lastCompletedBuild/) | [](https://ci-beam.apache.org/job/beam_PreCommit_Go_Cron/lastCompletedBuild/) | [](https://ci-beam.apache.org/job/beam_PreCommit_Website_Cron/lastCompletedBuild/) | [](https://ci-beam.apache.org/job/beam_PreCommit_Whitespace_Cron/lastCompletedBuild/) | [](https://ci-beam.apache.org/job/beam_PreCommit_Typescript_Cron/lastCompletedBuild/)
Portable | --- | [](https://ci-beam.apache.org/job/beam_PreCommit_Portable_Python_Cron/lastCompletedBuild/) | --- | --- | --- | ---
See [.test-infra/jenkins/README](https://github.com/apache/beam/blob/master/.test-infra/jenkins/README.md) for trigger phrase, status and link of all Jenkins jobs.
GitHub Actions Tests Status (on master branch)
------------------------------------------------------------------------------------------------
[](https://github.com/apache/beam/actions?query=workflow%3A%22Build+python+source+distribution+and+wheels%22+branch%3Amaster+event%3Aschedule)
[](https://github.com/apache/beam/actions?query=workflow%3A%22Python+Tests%22+branch%3Amaster+event%3Aschedule)
[](https://github.com/apache/beam/actions?query=workflow%3A%22Java+Tests%22+branch%3Amaster+event%3Aschedule)
See [CI.md](https://github.com/apache/beam/blob/master/CI.md) for more information about GitHub Actions CI.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [beam] pabloem commented on a change in pull request #12916: Added explanation and examples for dynamic destination data writing to big query (python)
Posted by GitBox <gi...@apache.org>.
pabloem commented on a change in pull request #12916:
URL: https://github.com/apache/beam/pull/12916#discussion_r499021934
##########
File path: sdks/python/apache_beam/examples/snippets/snippets.py
##########
@@ -1179,6 +1179,19 @@ def model_bigqueryio(p, write_project='', write_dataset='', write_table=''):
write_disposition=beam.io.BigQueryDisposition.WRITE_TRUNCATE,
create_disposition=beam.io.BigQueryDisposition.CREATE_IF_NEEDED)
# [END model_bigqueryio_write]
+
+ # [START model_bigqueryio_write_dynamic_input]
+ table_names = (p | beam.Create([
+ ('error', 'my_project.dataset1.error_table_for_today'),
+ ('user_log', 'my_project.dataset1.query_table_for_today'),
+ ])
Review comment:
also, if you feel up to it, the same document users table partitioning : ) - do you think you could add a snippet for that?
It would look something like this:
```
bq_output = input
| beam.io.WriteToBigQuery(
(TABLE something something),
additional_bq_parameters={'timePartitioning': {'type': 'HOUR'}})
```
That's not a must. Only if you feel up to it : )
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [beam] github-actions[bot] commented on pull request #12916: Added explanation and examples for dynamic destination data writing to big query (python)
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on pull request #12916:
URL: https://github.com/apache/beam/pull/12916#issuecomment-1041455002
This pull request has been closed due to lack of activity. If you think that is incorrect, or the pull request requires review, you can revive the PR at any time.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@beam.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [beam] aaltay commented on pull request #12916: Added explanation and examples for dynamic destination data writing to big query (python)
Posted by GitBox <gi...@apache.org>.
aaltay commented on pull request #12916:
URL: https://github.com/apache/beam/pull/12916#issuecomment-709564035
> Hi, I'm really busy because of personal life, in two weeks or so I will be able to continue working on it El jue., 15 oct. 2020 a las 20:30, Ahmet Altay (<no...@github.com>) escribió:
> […](#)
> @rincon-santi <https://github.com/rincon-santi> - Are you still working on this PR? Do you need help? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <[#12916 (comment)](https://github.com/apache/beam/pull/12916#issuecomment-709512471)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AH2UKF5OFBG5LQSC7VJJORDSK45UNANCNFSM4RXIXXYA> .
Take care. Thank you for the reply.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [beam] pabloem commented on pull request #12916: Added explanation and examples for dynamic destination data writing to big query (python)
Posted by GitBox <gi...@apache.org>.
pabloem commented on pull request #12916:
URL: https://github.com/apache/beam/pull/12916#issuecomment-916546115
sorry - any updaTES? : ) : /
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@beam.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [beam] aaltay commented on pull request #12916: Added explanation and examples for dynamic destination data writing to big query (python)
Posted by GitBox <gi...@apache.org>.
aaltay commented on pull request #12916:
URL: https://github.com/apache/beam/pull/12916#issuecomment-709512471
@rincon-santi - Are you still working on this PR? Do you need help?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [beam] github-actions[bot] closed pull request #12916: Added explanation and examples for dynamic destination data writing to big query (python)
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed pull request #12916:
URL: https://github.com/apache/beam/pull/12916
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@beam.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [beam] rincon-santi commented on pull request #12916: Added explanation and examples for dynamic destination data writing to big query (python)
Posted by GitBox <gi...@apache.org>.
rincon-santi commented on pull request #12916:
URL: https://github.com/apache/beam/pull/12916#issuecomment-709538424
Hi, I'm really busy because of personal life, in two weeks or so I will be
able to continue working on it
El jue., 15 oct. 2020 a las 20:30, Ahmet Altay (<no...@github.com>)
escribió:
> @rincon-santi <https://github.com/rincon-santi> - Are you still working
> on this PR? Do you need help?
>
> —
> You are receiving this because you were mentioned.
> Reply to this email directly, view it on GitHub
> <https://github.com/apache/beam/pull/12916#issuecomment-709512471>, or
> unsubscribe
> <https://github.com/notifications/unsubscribe-auth/AH2UKF5OFBG5LQSC7VJJORDSK45UNANCNFSM4RXIXXYA>
> .
>
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [beam] pabloem commented on a change in pull request #12916: Added explanation and examples for dynamic destination data writing to big query (python)
Posted by GitBox <gi...@apache.org>.
pabloem commented on a change in pull request #12916:
URL: https://github.com/apache/beam/pull/12916#discussion_r499020846
##########
File path: sdks/python/apache_beam/examples/snippets/snippets.py
##########
@@ -1179,6 +1179,19 @@ def model_bigqueryio(p, write_project='', write_dataset='', write_table=''):
write_disposition=beam.io.BigQueryDisposition.WRITE_TRUNCATE,
create_disposition=beam.io.BigQueryDisposition.CREATE_IF_NEEDED)
# [END model_bigqueryio_write]
+
+ # [START model_bigqueryio_write_dynamic_input]
+ table_names = (p | beam.Create([
+ ('error', 'my_project.dataset1.error_table_for_today'),
+ ('user_log', 'my_project.dataset1.query_table_for_today'),
+ ])
Review comment:
it seems that you're missing an extra parenthesis here @rincon-santi . Could you add it please?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [beam] stale[bot] commented on pull request #12916: Added explanation and examples for dynamic destination data writing to big query (python)
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on pull request #12916:
URL: https://github.com/apache/beam/pull/12916#issuecomment-748441223
This pull request has been marked as stale due to 60 days of inactivity. It will be closed in 1 week if no further activity occurs. If you think that’s incorrect or this pull request requires a review, please simply write any comment. If closed, you can revive the PR at any time and @mention a reviewer or discuss it on the dev@beam.apache.org list. Thank you for your contributions.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [beam] github-actions[bot] commented on pull request #12916: Added explanation and examples for dynamic destination data writing to big query (python)
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on pull request #12916:
URL: https://github.com/apache/beam/pull/12916#issuecomment-1032573370
This pull request has been marked as stale due to 60 days of inactivity. It will be closed in 1 week if no further activity occurs. If you think that’s incorrect or this pull request requires a review, please simply write any comment. If closed, you can revive the PR at any time and @mention a reviewer or discuss it on the dev@beam.apache.org list. Thank you for your contributions.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@beam.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org