Skip to content

feat(bigquery-execute-sql): add dry run support #1057

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 10 commits into from
Aug 5, 2025

Conversation

Genesis929
Copy link
Contributor

@Genesis929 Genesis929 commented Aug 1, 2025

Add optional dry_run parameter to bigquery-execute-sql, which defaults to false.

When the dry_run parameter is set to true, the tool returns the metadata from the dry run instead of executing the query.

Fixes #703

@Genesis929 Genesis929 added the tests: run Label to trigger Github Action tests. label Aug 1, 2025
@github-actions github-actions bot removed the tests: run Label to trigger Github Action tests. label Aug 1, 2025
@Genesis929 Genesis929 marked this pull request as ready for review August 1, 2025 23:42
@Genesis929 Genesis929 requested a review from a team as a code owner August 1, 2025 23:42
@averikitsch
Copy link
Contributor

Hi @Genesis929 , can you update the documentation as well?

Copy link
Contributor

@Yuan325 Yuan325 left a comment

Choose a reason for hiding this comment

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

Thank you! :)

+1 @averikitsch comment on adding documentation

Genesis929 and others added 4 commits August 4, 2025 18:03
Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com>
Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com>
Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com>
@Genesis929 Genesis929 requested a review from Yuan325 August 5, 2025 01:15
@Genesis929
Copy link
Contributor Author

Hi @Genesis929 , can you update the documentation as well?

Thanks! Doc updated, forgot that.

@Yuan325
Copy link
Contributor

Yuan325 commented Aug 5, 2025

/gcbrun

@Yuan325 Yuan325 removed their assignment Aug 5, 2025
@Yuan325 Yuan325 added the tests: run Label to trigger Github Action tests. label Aug 5, 2025
@Yuan325 Yuan325 self-assigned this Aug 5, 2025
@github-actions github-actions bot removed the tests: run Label to trigger Github Action tests. label Aug 5, 2025
Copy link
Contributor

@Yuan325 Yuan325 left a comment

Choose a reason for hiding this comment

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

@Genesis929 Thank you!

@averikitsch averikitsch enabled auto-merge (squash) August 5, 2025 22:55
@averikitsch
Copy link
Contributor

/gcbrun

@averikitsch averikitsch added the tests: run Label to trigger Github Action tests. label Aug 5, 2025
@github-actions github-actions bot removed the tests: run Label to trigger Github Action tests. label Aug 5, 2025
@averikitsch averikitsch merged commit 1cac9b5 into googleapis:main Aug 5, 2025
12 checks passed
github-actions bot pushed a commit that referenced this pull request Aug 5, 2025
Add optional `dry_run` parameter to bigquery-execute-sql, which defaults
to `false`.

When the `dry_run` parameter is set to `true`, the tool returns the
metadata from the dry run instead of executing the query.

Fixes #703

---------

Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> 1cac9b5
github-actions bot pushed a commit to renovate-bot/googleapis-_-genai-toolbox that referenced this pull request Aug 5, 2025
)

Add optional `dry_run` parameter to bigquery-execute-sql, which defaults
to `false`.

When the `dry_run` parameter is set to `true`, the tool returns the
metadata from the dry run instead of executing the query.

Fixes googleapis#703

---------

Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> 1cac9b5
github-actions bot pushed a commit to bhardwajRahul/genai-toolbox that referenced this pull request Aug 6, 2025
)

Add optional `dry_run` parameter to bigquery-execute-sql, which defaults
to `false`.

When the `dry_run` parameter is set to `true`, the tool returns the
metadata from the dry run instead of executing the query.

Fixes googleapis#703

---------

Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> 1cac9b5
github-actions bot pushed a commit to Jaleel-zhu/genai-toolbox that referenced this pull request Aug 6, 2025
)

Add optional `dry_run` parameter to bigquery-execute-sql, which defaults
to `false`.

When the `dry_run` parameter is set to `true`, the tool returns the
metadata from the dry run instead of executing the query.

Fixes googleapis#703

---------

Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> 1cac9b5
github-actions bot pushed a commit to AnujJhunjhunwala/genai-toolbox that referenced this pull request Aug 6, 2025
)

Add optional `dry_run` parameter to bigquery-execute-sql, which defaults
to `false`.

When the `dry_run` parameter is set to `true`, the tool returns the
metadata from the dry run instead of executing the query.

Fixes googleapis#703

---------

Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> 1cac9b5
github-actions bot pushed a commit to bpranava/genai-toolbox that referenced this pull request Aug 6, 2025
)

Add optional `dry_run` parameter to bigquery-execute-sql, which defaults
to `false`.

When the `dry_run` parameter is set to `true`, the tool returns the
metadata from the dry run instead of executing the query.

Fixes googleapis#703

---------

Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> 1cac9b5
SaxenaAnushka102 pushed a commit to SaxenaAnushka102/genai-toolbox that referenced this pull request Aug 14, 2025
Add optional `dry_run` parameter to bigquery-execute-sql, which defaults
to `false`.

When the `dry_run` parameter is set to `true`, the tool returns the
metadata from the dry run instead of executing the query.

Fixes googleapis#703

---------

Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com>
Yuan325 added a commit that referenced this pull request Aug 14, 2025
🤖 I have created a release *beep* *boop*
---


##
[0.12.0](v0.11.0...v0.12.0)
(2025-08-14)


### Features

* **prebuiltconfig:** Introduce additional parameter to limit context in
list_tables
([#1151](#1151))
([497d3b1](497d3b1))
* **prebuiltconfig/alloydb-admin:** Add list cluster, instance and users
([#1126](#1126))
([b42c139](b42c139))
* **prebuiltconfig/alloydb-postgres:** Add tool to create user via Built
in user type or IAM
([#1130](#1130))
([f5bcb9c](f5bcb9c))
* **source/http:** Add User Agent to `http` invocations
([#1102](#1102))
([6f55b78](6f55b78))
* **sources/postgres:** Add support for `queryParams`
([#1047](#1047))
([7b57251](7b57251)),
closes [#963](#963)
* **tools/bigquery-execute-sql:** Add dry run support
([#1057](#1057))
([1cac9b5](1cac9b5))
* **tools/dataplex-search-aspect-types:** Add support for
`dataplex-search-aspect-types` tool
([#1061](#1061))
([d940187](d940187))
* **tools/looker:** Add `looker-make-look` tool to create Looks
([#1099](#1099))
([61d9489](61d9489))
* **tools/looker:** Add visualizations to `query-url` tool
([#1090](#1090))
([5bf2758](5bf2758))
* **tools/looker:** New Looker tools for dashboards
([#1118](#1118))
([42be3f5](42be3f5))
* **ui:** Add login with google button for automatic id token retrieval
([#1044](#1044))
([d91bdfc](d91bdfc))


### Bug Fixes

* Correct the capitalization of `map` manifests
([#1139](#1139))
([0b0457c](0b0457c))
* Remove unnecessary fields from `map` parameter manifests
([#1138](#1138))
([fbe8c1a](fbe8c1a))
* **tools/looker:** Add authorized invocation feature to all Looker
tools ([#1091](#1091))
([3b1cce7](3b1cce7))
* Update ui info log to reflect port
([#1125](#1125))
([6d691d5](6d691d5))

---
This PR was generated with [Release
Please](https://github.com/googleapis/release-please). See
[documentation](https://github.com/googleapis/release-please#release-please).

---------

Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>
Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com>
github-actions bot pushed a commit that referenced this pull request Aug 14, 2025
🤖 I have created a release *beep* *boop*
---

##
[0.12.0](v0.11.0...v0.12.0)
(2025-08-14)

### Features

* **prebuiltconfig:** Introduce additional parameter to limit context in
list_tables
([#1151](#1151))
([497d3b1](497d3b1))
* **prebuiltconfig/alloydb-admin:** Add list cluster, instance and users
([#1126](#1126))
([b42c139](b42c139))
* **prebuiltconfig/alloydb-postgres:** Add tool to create user via Built
in user type or IAM
([#1130](#1130))
([f5bcb9c](f5bcb9c))
* **source/http:** Add User Agent to `http` invocations
([#1102](#1102))
([6f55b78](6f55b78))
* **sources/postgres:** Add support for `queryParams`
([#1047](#1047))
([7b57251](7b57251)),
closes [#963](#963)
* **tools/bigquery-execute-sql:** Add dry run support
([#1057](#1057))
([1cac9b5](1cac9b5))
* **tools/dataplex-search-aspect-types:** Add support for
`dataplex-search-aspect-types` tool
([#1061](#1061))
([d940187](d940187))
* **tools/looker:** Add `looker-make-look` tool to create Looks
([#1099](#1099))
([61d9489](61d9489))
* **tools/looker:** Add visualizations to `query-url` tool
([#1090](#1090))
([5bf2758](5bf2758))
* **tools/looker:** New Looker tools for dashboards
([#1118](#1118))
([42be3f5](42be3f5))
* **ui:** Add login with google button for automatic id token retrieval
([#1044](#1044))
([d91bdfc](d91bdfc))

### Bug Fixes

* Correct the capitalization of `map` manifests
([#1139](#1139))
([0b0457c](0b0457c))
* Remove unnecessary fields from `map` parameter manifests
([#1138](#1138))
([fbe8c1a](fbe8c1a))
* **tools/looker:** Add authorized invocation feature to all Looker
tools ([#1091](#1091))
([3b1cce7](3b1cce7))
* Update ui info log to reflect port
([#1125](#1125))
([6d691d5](6d691d5))

---
This PR was generated with [Release
Please](https://github.com/googleapis/release-please). See
[documentation](https://github.com/googleapis/release-please#release-please).

---------

Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>
Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> d19cfc1
github-actions bot pushed a commit to renovate-bot/googleapis-_-genai-toolbox that referenced this pull request Aug 14, 2025
🤖 I have created a release *beep* *boop*
---

##
[0.12.0](googleapis/genai-toolbox@v0.11.0...v0.12.0)
(2025-08-14)

### Features

* **prebuiltconfig:** Introduce additional parameter to limit context in
list_tables
([googleapis#1151](googleapis#1151))
([497d3b1](googleapis@497d3b1))
* **prebuiltconfig/alloydb-admin:** Add list cluster, instance and users
([googleapis#1126](googleapis#1126))
([b42c139](googleapis@b42c139))
* **prebuiltconfig/alloydb-postgres:** Add tool to create user via Built
in user type or IAM
([googleapis#1130](googleapis#1130))
([f5bcb9c](googleapis@f5bcb9c))
* **source/http:** Add User Agent to `http` invocations
([googleapis#1102](googleapis#1102))
([6f55b78](googleapis@6f55b78))
* **sources/postgres:** Add support for `queryParams`
([googleapis#1047](googleapis#1047))
([7b57251](googleapis@7b57251)),
closes [googleapis#963](googleapis#963)
* **tools/bigquery-execute-sql:** Add dry run support
([googleapis#1057](googleapis#1057))
([1cac9b5](googleapis@1cac9b5))
* **tools/dataplex-search-aspect-types:** Add support for
`dataplex-search-aspect-types` tool
([googleapis#1061](googleapis#1061))
([d940187](googleapis@d940187))
* **tools/looker:** Add `looker-make-look` tool to create Looks
([googleapis#1099](googleapis#1099))
([61d9489](googleapis@61d9489))
* **tools/looker:** Add visualizations to `query-url` tool
([googleapis#1090](googleapis#1090))
([5bf2758](googleapis@5bf2758))
* **tools/looker:** New Looker tools for dashboards
([googleapis#1118](googleapis#1118))
([42be3f5](googleapis@42be3f5))
* **ui:** Add login with google button for automatic id token retrieval
([googleapis#1044](googleapis#1044))
([d91bdfc](googleapis@d91bdfc))

### Bug Fixes

* Correct the capitalization of `map` manifests
([googleapis#1139](googleapis#1139))
([0b0457c](googleapis@0b0457c))
* Remove unnecessary fields from `map` parameter manifests
([googleapis#1138](googleapis#1138))
([fbe8c1a](googleapis@fbe8c1a))
* **tools/looker:** Add authorized invocation feature to all Looker
tools ([googleapis#1091](googleapis#1091))
([3b1cce7](googleapis@3b1cce7))
* Update ui info log to reflect port
([googleapis#1125](googleapis#1125))
([6d691d5](googleapis@6d691d5))

---
This PR was generated with [Release
Please](https://github.com/googleapis/release-please). See
[documentation](https://github.com/googleapis/release-please#release-please).

---------

Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>
Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> d19cfc1
github-actions bot pushed a commit to Jaleel-zhu/genai-toolbox that referenced this pull request Aug 15, 2025
🤖 I have created a release *beep* *boop*
---

##
[0.12.0](googleapis/genai-toolbox@v0.11.0...v0.12.0)
(2025-08-14)

### Features

* **prebuiltconfig:** Introduce additional parameter to limit context in
list_tables
([googleapis#1151](googleapis#1151))
([497d3b1](googleapis@497d3b1))
* **prebuiltconfig/alloydb-admin:** Add list cluster, instance and users
([googleapis#1126](googleapis#1126))
([b42c139](googleapis@b42c139))
* **prebuiltconfig/alloydb-postgres:** Add tool to create user via Built
in user type or IAM
([googleapis#1130](googleapis#1130))
([f5bcb9c](googleapis@f5bcb9c))
* **source/http:** Add User Agent to `http` invocations
([googleapis#1102](googleapis#1102))
([6f55b78](googleapis@6f55b78))
* **sources/postgres:** Add support for `queryParams`
([googleapis#1047](googleapis#1047))
([7b57251](googleapis@7b57251)),
closes [googleapis#963](googleapis#963)
* **tools/bigquery-execute-sql:** Add dry run support
([googleapis#1057](googleapis#1057))
([1cac9b5](googleapis@1cac9b5))
* **tools/dataplex-search-aspect-types:** Add support for
`dataplex-search-aspect-types` tool
([googleapis#1061](googleapis#1061))
([d940187](googleapis@d940187))
* **tools/looker:** Add `looker-make-look` tool to create Looks
([googleapis#1099](googleapis#1099))
([61d9489](googleapis@61d9489))
* **tools/looker:** Add visualizations to `query-url` tool
([googleapis#1090](googleapis#1090))
([5bf2758](googleapis@5bf2758))
* **tools/looker:** New Looker tools for dashboards
([googleapis#1118](googleapis#1118))
([42be3f5](googleapis@42be3f5))
* **ui:** Add login with google button for automatic id token retrieval
([googleapis#1044](googleapis#1044))
([d91bdfc](googleapis@d91bdfc))

### Bug Fixes

* Correct the capitalization of `map` manifests
([googleapis#1139](googleapis#1139))
([0b0457c](googleapis@0b0457c))
* Remove unnecessary fields from `map` parameter manifests
([googleapis#1138](googleapis#1138))
([fbe8c1a](googleapis@fbe8c1a))
* **tools/looker:** Add authorized invocation feature to all Looker
tools ([googleapis#1091](googleapis#1091))
([3b1cce7](googleapis@3b1cce7))
* Update ui info log to reflect port
([googleapis#1125](googleapis#1125))
([6d691d5](googleapis@6d691d5))

---
This PR was generated with [Release
Please](https://github.com/googleapis/release-please). See
[documentation](https://github.com/googleapis/release-please#release-please).

---------

Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>
Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> d19cfc1
github-actions bot pushed a commit to bhardwajRahul/genai-toolbox that referenced this pull request Aug 15, 2025
🤖 I have created a release *beep* *boop*
---

##
[0.12.0](googleapis/genai-toolbox@v0.11.0...v0.12.0)
(2025-08-14)

### Features

* **prebuiltconfig:** Introduce additional parameter to limit context in
list_tables
([googleapis#1151](googleapis#1151))
([497d3b1](googleapis@497d3b1))
* **prebuiltconfig/alloydb-admin:** Add list cluster, instance and users
([googleapis#1126](googleapis#1126))
([b42c139](googleapis@b42c139))
* **prebuiltconfig/alloydb-postgres:** Add tool to create user via Built
in user type or IAM
([googleapis#1130](googleapis#1130))
([f5bcb9c](googleapis@f5bcb9c))
* **source/http:** Add User Agent to `http` invocations
([googleapis#1102](googleapis#1102))
([6f55b78](googleapis@6f55b78))
* **sources/postgres:** Add support for `queryParams`
([googleapis#1047](googleapis#1047))
([7b57251](googleapis@7b57251)),
closes [googleapis#963](googleapis#963)
* **tools/bigquery-execute-sql:** Add dry run support
([googleapis#1057](googleapis#1057))
([1cac9b5](googleapis@1cac9b5))
* **tools/dataplex-search-aspect-types:** Add support for
`dataplex-search-aspect-types` tool
([googleapis#1061](googleapis#1061))
([d940187](googleapis@d940187))
* **tools/looker:** Add `looker-make-look` tool to create Looks
([googleapis#1099](googleapis#1099))
([61d9489](googleapis@61d9489))
* **tools/looker:** Add visualizations to `query-url` tool
([googleapis#1090](googleapis#1090))
([5bf2758](googleapis@5bf2758))
* **tools/looker:** New Looker tools for dashboards
([googleapis#1118](googleapis#1118))
([42be3f5](googleapis@42be3f5))
* **ui:** Add login with google button for automatic id token retrieval
([googleapis#1044](googleapis#1044))
([d91bdfc](googleapis@d91bdfc))

### Bug Fixes

* Correct the capitalization of `map` manifests
([googleapis#1139](googleapis#1139))
([0b0457c](googleapis@0b0457c))
* Remove unnecessary fields from `map` parameter manifests
([googleapis#1138](googleapis#1138))
([fbe8c1a](googleapis@fbe8c1a))
* **tools/looker:** Add authorized invocation feature to all Looker
tools ([googleapis#1091](googleapis#1091))
([3b1cce7](googleapis@3b1cce7))
* Update ui info log to reflect port
([googleapis#1125](googleapis#1125))
([6d691d5](googleapis@6d691d5))

---
This PR was generated with [Release
Please](https://github.com/googleapis/release-please). See
[documentation](https://github.com/googleapis/release-please#release-please).

---------

Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>
Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> d19cfc1
trehanshakuntG pushed a commit that referenced this pull request Aug 20, 2025
🤖 I have created a release *beep* *boop*
---


##
[0.12.0](v0.11.0...v0.12.0)
(2025-08-14)


### Features

* **prebuiltconfig:** Introduce additional parameter to limit context in
list_tables
([#1151](#1151))
([497d3b1](497d3b1))
* **prebuiltconfig/alloydb-admin:** Add list cluster, instance and users
([#1126](#1126))
([b42c139](b42c139))
* **prebuiltconfig/alloydb-postgres:** Add tool to create user via Built
in user type or IAM
([#1130](#1130))
([f5bcb9c](f5bcb9c))
* **source/http:** Add User Agent to `http` invocations
([#1102](#1102))
([6f55b78](6f55b78))
* **sources/postgres:** Add support for `queryParams`
([#1047](#1047))
([7b57251](7b57251)),
closes [#963](#963)
* **tools/bigquery-execute-sql:** Add dry run support
([#1057](#1057))
([1cac9b5](1cac9b5))
* **tools/dataplex-search-aspect-types:** Add support for
`dataplex-search-aspect-types` tool
([#1061](#1061))
([d940187](d940187))
* **tools/looker:** Add `looker-make-look` tool to create Looks
([#1099](#1099))
([61d9489](61d9489))
* **tools/looker:** Add visualizations to `query-url` tool
([#1090](#1090))
([5bf2758](5bf2758))
* **tools/looker:** New Looker tools for dashboards
([#1118](#1118))
([42be3f5](42be3f5))
* **ui:** Add login with google button for automatic id token retrieval
([#1044](#1044))
([d91bdfc](d91bdfc))


### Bug Fixes

* Correct the capitalization of `map` manifests
([#1139](#1139))
([0b0457c](0b0457c))
* Remove unnecessary fields from `map` parameter manifests
([#1138](#1138))
([fbe8c1a](fbe8c1a))
* **tools/looker:** Add authorized invocation feature to all Looker
tools ([#1091](#1091))
([3b1cce7](3b1cce7))
* Update ui info log to reflect port
([#1125](#1125))
([6d691d5](6d691d5))

---
This PR was generated with [Release
Please](https://github.com/googleapis/release-please). See
[documentation](https://github.com/googleapis/release-please#release-please).

---------

Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>
Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

Support "dry run" bigquery-execute-sql
3 participants