Skip to content

feat(tool/bigquery-execute-sql)!: add allowed datasets support#1443

Merged
Genesis929 merged 13 commits into
googleapis:mainfrom
Genesis929:ds_ex_api
Sep 25, 2025
Merged

feat(tool/bigquery-execute-sql)!: add allowed datasets support#1443
Genesis929 merged 13 commits into
googleapis:mainfrom
Genesis929:ds_ex_api

Conversation

@Genesis929

@Genesis929 Genesis929 commented Sep 12, 2025

Copy link
Copy Markdown
Contributor

Description

This introduces a breaking change. The bigquery-execute-sql tool will now enforce the allowed datasets setting from its BigQuery source configuration. Previously, this setting had no effect on the tool.


Should include a concise description of the changes (bug or feature), it's
impact, along with a summary of the solution

PR Checklist


Thank you for opening a Pull Request! Before submitting your PR, there are a
few things you can do to make sure it goes smoothly:

  • Make sure you reviewed
    CONTRIBUTING.md
  • Make sure to open an issue as a
    bug/issue
    before writing your code! That way we can discuss the change, evaluate
    designs, and agree on the general idea
  • Ensure the tests and linter pass
  • Code coverage does not decrease (if any source code was changed)
  • Appropriate docs were updated (if necessary)
  • Make sure to add ! if this involve a breaking change

🛠️ Part of #873

@Genesis929 Genesis929 requested a review from a team September 12, 2025 23:48
@Genesis929 Genesis929 marked this pull request as draft September 12, 2025 23:48
@Genesis929 Genesis929 marked this pull request as ready for review September 13, 2025 00:13
@Genesis929 Genesis929 added the tests: run Label to trigger Github Action tests. label Sep 13, 2025
@github-actions github-actions Bot removed the tests: run Label to trigger Github Action tests. label Sep 13, 2025
@Yuan325 Yuan325 assigned Yuan325 and unassigned duwenxin99 Sep 24, 2025
Comment thread internal/tools/bigquery/bigqueryexecutesql/bigqueryexecutesql.go Outdated
Comment thread internal/tools/bigquery/bigqueryexecutesql/bigqueryexecutesql.go Outdated
Comment thread internal/tools/bigquery/bigqueryexecutesql/bigqueryexecutesql.go
Comment thread internal/tools/bigquery/bigqueryexecutesql/bigqueryexecutesql.go
Comment thread tests/bigquery/bigquery_integration_test.go
Genesis929 and others added 4 commits September 24, 2025 14:31
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 September 24, 2025 22:44
@Yuan325 Yuan325 added the tests: run Label to trigger Github Action tests. label Sep 25, 2025
@github-actions github-actions Bot removed the tests: run Label to trigger Github Action tests. label Sep 25, 2025
@Genesis929 Genesis929 enabled auto-merge (squash) September 25, 2025 18:12
@Genesis929 Genesis929 added the tests: run Label to trigger Github Action tests. label Sep 25, 2025
@github-actions github-actions Bot removed the tests: run Label to trigger Github Action tests. label Sep 25, 2025
@Genesis929 Genesis929 added the tests: run Label to trigger Github Action tests. label Sep 25, 2025
@github-actions github-actions Bot removed the tests: run Label to trigger Github Action tests. label Sep 25, 2025
@Genesis929 Genesis929 added the tests: run Label to trigger Github Action tests. label Sep 25, 2025
@github-actions github-actions Bot removed the tests: run Label to trigger Github Action tests. label Sep 25, 2025
@Genesis929 Genesis929 merged commit 9501ebb into googleapis:main Sep 25, 2025
15 checks passed
github-actions Bot pushed a commit that referenced this pull request Sep 25, 2025
#1443)

## Description
This introduces a breaking change. The bigquery-execute-sql tool will
now enforce the allowed datasets setting from its BigQuery source
configuration. Previously, this setting had no effect on the tool.

---
> Should include a concise description of the changes (bug or feature),
it's
> impact, along with a summary of the solution

## PR Checklist

---
> Thank you for opening a Pull Request! Before submitting your PR, there
are a
> few things you can do to make sure it goes smoothly:

- [ ] Make sure you reviewed

[CONTRIBUTING.md](https://github.com/googleapis/genai-toolbox/blob/main/CONTRIBUTING.md)
- [ ] Make sure to open an issue as a

[bug/issue](https://github.com/googleapis/genai-toolbox/issues/new/choose)
before writing your code! That way we can discuss the change, evaluate
  designs, and agree on the general idea
- [ ] Ensure the tests and linter pass
- [ ] Code coverage does not decrease (if any source code was changed)
- [ ] Appropriate docs were updated (if necessary)
- [ ] Make sure to add `!` if this involve a breaking change

🛠️ Fixes #873

---------

Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> 9501ebb
github-actions Bot pushed a commit to renovate-bot/googleapis-_-genai-toolbox that referenced this pull request Sep 25, 2025
googleapis#1443)

## Description
This introduces a breaking change. The bigquery-execute-sql tool will
now enforce the allowed datasets setting from its BigQuery source
configuration. Previously, this setting had no effect on the tool.

---
> Should include a concise description of the changes (bug or feature),
it's
> impact, along with a summary of the solution

## PR Checklist

---
> Thank you for opening a Pull Request! Before submitting your PR, there
are a
> few things you can do to make sure it goes smoothly:

- [ ] Make sure you reviewed

[CONTRIBUTING.md](https://github.com/googleapis/genai-toolbox/blob/main/CONTRIBUTING.md)
- [ ] Make sure to open an issue as a

[bug/issue](https://github.com/googleapis/genai-toolbox/issues/new/choose)
before writing your code! That way we can discuss the change, evaluate
  designs, and agree on the general idea
- [ ] Ensure the tests and linter pass
- [ ] Code coverage does not decrease (if any source code was changed)
- [ ] Appropriate docs were updated (if necessary)
- [ ] Make sure to add `!` if this involve a breaking change

🛠️ Fixes googleapis#873

---------

Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> 9501ebb
github-actions Bot pushed a commit to Genesis929/genai-toolbox that referenced this pull request Sep 25, 2025
googleapis#1443)

## Description
This introduces a breaking change. The bigquery-execute-sql tool will
now enforce the allowed datasets setting from its BigQuery source
configuration. Previously, this setting had no effect on the tool.

---
> Should include a concise description of the changes (bug or feature),
it's
> impact, along with a summary of the solution

## PR Checklist

---
> Thank you for opening a Pull Request! Before submitting your PR, there
are a
> few things you can do to make sure it goes smoothly:

- [ ] Make sure you reviewed

[CONTRIBUTING.md](https://github.com/googleapis/genai-toolbox/blob/main/CONTRIBUTING.md)
- [ ] Make sure to open an issue as a

[bug/issue](https://github.com/googleapis/genai-toolbox/issues/new/choose)
before writing your code! That way we can discuss the change, evaluate
  designs, and agree on the general idea
- [ ] Ensure the tests and linter pass
- [ ] Code coverage does not decrease (if any source code was changed)
- [ ] Appropriate docs were updated (if necessary)
- [ ] Make sure to add `!` if this involve a breaking change

🛠️ Fixes googleapis#873

---------

Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> 9501ebb
github-actions Bot pushed a commit to bhardwajRahul/genai-toolbox that referenced this pull request Sep 25, 2025
googleapis#1443)

## Description
This introduces a breaking change. The bigquery-execute-sql tool will
now enforce the allowed datasets setting from its BigQuery source
configuration. Previously, this setting had no effect on the tool.

---
> Should include a concise description of the changes (bug or feature),
it's
> impact, along with a summary of the solution

## PR Checklist

---
> Thank you for opening a Pull Request! Before submitting your PR, there
are a
> few things you can do to make sure it goes smoothly:

- [ ] Make sure you reviewed

[CONTRIBUTING.md](https://github.com/googleapis/genai-toolbox/blob/main/CONTRIBUTING.md)
- [ ] Make sure to open an issue as a

[bug/issue](https://github.com/googleapis/genai-toolbox/issues/new/choose)
before writing your code! That way we can discuss the change, evaluate
  designs, and agree on the general idea
- [ ] Ensure the tests and linter pass
- [ ] Code coverage does not decrease (if any source code was changed)
- [ ] Appropriate docs were updated (if necessary)
- [ ] Make sure to add `!` if this involve a breaking change

🛠️ Fixes googleapis#873

---------

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


##
[0.16.0](v0.15.0...v0.16.0)
(2025-09-25)


### ⚠ BREAKING CHANGES

* **tool/bigquery-execute-sql:** add allowed datasets support
([#1443](#1443))
* **tool/bigquery-forecast:** add allowed datasets support
([#1412](#1412))

### Features

* **cassandra:** Add Cassandra Source and Tool
([#1012](#1012))
([6e42053](6e42053))
* **sources/postgres:** Add application_name
([#1504](#1504))
([72a2366](72a2366))
* **tool/bigquery-execute-sql:** Add allowed datasets support
([#1443](#1443))
([9501ebb](9501ebb))
* **tool/bigquery-forecast:** Add allowed datasets support
([#1412](#1412))
([88bac7e](88bac7e))
* **tools/clickhouse-list-tables:** Add list-tables tool
([#1446](#1446))
([69a3caf](69a3caf))


### Bug Fixes

* **tool/mongodb-find:** Fix find tool `limit` field
([#1570](#1570))
([4166bf7](4166bf7))
* **tools/mongodb:** Concat filter params only once in mongodb update
tools ([#1545](#1545))
([295f9dc](295f9dc))

---
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 Sep 26, 2025
🤖 I have created a release *beep* *boop*
---

##
[0.16.0](v0.15.0...v0.16.0)
(2025-09-25)

### ⚠ BREAKING CHANGES

* **tool/bigquery-execute-sql:** add allowed datasets support
([#1443](#1443))
* **tool/bigquery-forecast:** add allowed datasets support
([#1412](#1412))

### Features

* **cassandra:** Add Cassandra Source and Tool
([#1012](#1012))
([6e42053](6e42053))
* **sources/postgres:** Add application_name
([#1504](#1504))
([72a2366](72a2366))
* **tool/bigquery-execute-sql:** Add allowed datasets support
([#1443](#1443))
([9501ebb](9501ebb))
* **tool/bigquery-forecast:** Add allowed datasets support
([#1412](#1412))
([88bac7e](88bac7e))
* **tools/clickhouse-list-tables:** Add list-tables tool
([#1446](#1446))
([69a3caf](69a3caf))

### Bug Fixes

* **tool/mongodb-find:** Fix find tool `limit` field
([#1570](#1570))
([4166bf7](4166bf7))
* **tools/mongodb:** Concat filter params only once in mongodb update
tools ([#1545](#1545))
([295f9dc](295f9dc))

---
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> 964a82e
github-actions Bot pushed a commit to renovate-bot/googleapis-_-genai-toolbox that referenced this pull request Sep 26, 2025
🤖 I have created a release *beep* *boop*
---

##
[0.16.0](googleapis/mcp-toolbox@v0.15.0...v0.16.0)
(2025-09-25)

### ⚠ BREAKING CHANGES

* **tool/bigquery-execute-sql:** add allowed datasets support
([googleapis#1443](googleapis#1443))
* **tool/bigquery-forecast:** add allowed datasets support
([googleapis#1412](googleapis#1412))

### Features

* **cassandra:** Add Cassandra Source and Tool
([googleapis#1012](googleapis#1012))
([6e42053](googleapis@6e42053))
* **sources/postgres:** Add application_name
([googleapis#1504](googleapis#1504))
([72a2366](googleapis@72a2366))
* **tool/bigquery-execute-sql:** Add allowed datasets support
([googleapis#1443](googleapis#1443))
([9501ebb](googleapis@9501ebb))
* **tool/bigquery-forecast:** Add allowed datasets support
([googleapis#1412](googleapis#1412))
([88bac7e](googleapis@88bac7e))
* **tools/clickhouse-list-tables:** Add list-tables tool
([googleapis#1446](googleapis#1446))
([69a3caf](googleapis@69a3caf))

### Bug Fixes

* **tool/mongodb-find:** Fix find tool `limit` field
([googleapis#1570](googleapis#1570))
([4166bf7](googleapis@4166bf7))
* **tools/mongodb:** Concat filter params only once in mongodb update
tools ([googleapis#1545](googleapis#1545))
([295f9dc](googleapis@295f9dc))

---
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> 964a82e
github-actions Bot pushed a commit to Jaleel-zhu/genai-toolbox that referenced this pull request Sep 26, 2025
🤖 I have created a release *beep* *boop*
---

##
[0.16.0](googleapis/mcp-toolbox@v0.15.0...v0.16.0)
(2025-09-25)

### ⚠ BREAKING CHANGES

* **tool/bigquery-execute-sql:** add allowed datasets support
([googleapis#1443](googleapis#1443))
* **tool/bigquery-forecast:** add allowed datasets support
([googleapis#1412](googleapis#1412))

### Features

* **cassandra:** Add Cassandra Source and Tool
([googleapis#1012](googleapis#1012))
([6e42053](googleapis@6e42053))
* **sources/postgres:** Add application_name
([googleapis#1504](googleapis#1504))
([72a2366](googleapis@72a2366))
* **tool/bigquery-execute-sql:** Add allowed datasets support
([googleapis#1443](googleapis#1443))
([9501ebb](googleapis@9501ebb))
* **tool/bigquery-forecast:** Add allowed datasets support
([googleapis#1412](googleapis#1412))
([88bac7e](googleapis@88bac7e))
* **tools/clickhouse-list-tables:** Add list-tables tool
([googleapis#1446](googleapis#1446))
([69a3caf](googleapis@69a3caf))

### Bug Fixes

* **tool/mongodb-find:** Fix find tool `limit` field
([googleapis#1570](googleapis#1570))
([4166bf7](googleapis@4166bf7))
* **tools/mongodb:** Concat filter params only once in mongodb update
tools ([googleapis#1545](googleapis#1545))
([295f9dc](googleapis@295f9dc))

---
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> 964a82e
github-actions Bot pushed a commit to bhardwajRahul/genai-toolbox that referenced this pull request Sep 26, 2025
🤖 I have created a release *beep* *boop*
---

##
[0.16.0](googleapis/mcp-toolbox@v0.15.0...v0.16.0)
(2025-09-25)

### ⚠ BREAKING CHANGES

* **tool/bigquery-execute-sql:** add allowed datasets support
([googleapis#1443](googleapis#1443))
* **tool/bigquery-forecast:** add allowed datasets support
([googleapis#1412](googleapis#1412))

### Features

* **cassandra:** Add Cassandra Source and Tool
([googleapis#1012](googleapis#1012))
([6e42053](googleapis@6e42053))
* **sources/postgres:** Add application_name
([googleapis#1504](googleapis#1504))
([72a2366](googleapis@72a2366))
* **tool/bigquery-execute-sql:** Add allowed datasets support
([googleapis#1443](googleapis#1443))
([9501ebb](googleapis@9501ebb))
* **tool/bigquery-forecast:** Add allowed datasets support
([googleapis#1412](googleapis#1412))
([88bac7e](googleapis@88bac7e))
* **tools/clickhouse-list-tables:** Add list-tables tool
([googleapis#1446](googleapis#1446))
([69a3caf](googleapis@69a3caf))

### Bug Fixes

* **tool/mongodb-find:** Fix find tool `limit` field
([googleapis#1570](googleapis#1570))
([4166bf7](googleapis@4166bf7))
* **tools/mongodb:** Concat filter params only once in mongodb update
tools ([googleapis#1545](googleapis#1545))
([295f9dc](googleapis@295f9dc))

---
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> 964a82e
rahulpinto19 pushed a commit that referenced this pull request Sep 30, 2025
## Description
This introduces a breaking change. The bigquery-execute-sql tool will
now enforce the allowed datasets setting from its BigQuery source
configuration. Previously, this setting had no effect on the tool.

---
> Should include a concise description of the changes (bug or feature),
it's
> impact, along with a summary of the solution

## PR Checklist

---
> Thank you for opening a Pull Request! Before submitting your PR, there
are a
> few things you can do to make sure it goes smoothly:

- [ ] Make sure you reviewed

[CONTRIBUTING.md](https://github.com/googleapis/genai-toolbox/blob/main/CONTRIBUTING.md)
- [ ] Make sure to open an issue as a

[bug/issue](https://github.com/googleapis/genai-toolbox/issues/new/choose)
before writing your code! That way we can discuss the change, evaluate
  designs, and agree on the general idea
- [ ] Ensure the tests and linter pass
- [ ] Code coverage does not decrease (if any source code was changed)
- [ ] Appropriate docs were updated (if necessary)
- [ ] Make sure to add `!` if this involve a breaking change

🛠️ Fixes #873

---------

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


##
[0.16.0](v0.15.0...v0.16.0)
(2025-09-25)


### ⚠ BREAKING CHANGES

* **tool/bigquery-execute-sql:** add allowed datasets support
([#1443](#1443))
* **tool/bigquery-forecast:** add allowed datasets support
([#1412](#1412))

### Features

* **cassandra:** Add Cassandra Source and Tool
([#1012](#1012))
([6e42053](6e42053))
* **sources/postgres:** Add application_name
([#1504](#1504))
([72a2366](72a2366))
* **tool/bigquery-execute-sql:** Add allowed datasets support
([#1443](#1443))
([9501ebb](9501ebb))
* **tool/bigquery-forecast:** Add allowed datasets support
([#1412](#1412))
([88bac7e](88bac7e))
* **tools/clickhouse-list-tables:** Add list-tables tool
([#1446](#1446))
([69a3caf](69a3caf))


### Bug Fixes

* **tool/mongodb-find:** Fix find tool `limit` field
([#1570](#1570))
([4166bf7](4166bf7))
* **tools/mongodb:** Concat filter params only once in mongodb update
tools ([#1545](#1545))
([295f9dc](295f9dc))

---
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>
NightStack15 added a commit to NightStack15/googleapis-_-genai-toolbox that referenced this pull request Mar 20, 2026
🤖 I have created a release *beep* *boop*
---


##
[0.16.0](googleapis/mcp-toolbox@v0.15.0...v0.16.0)
(2025-09-25)


### ⚠ BREAKING CHANGES

* **tool/bigquery-execute-sql:** add allowed datasets support
([#1443](googleapis/mcp-toolbox#1443))
* **tool/bigquery-forecast:** add allowed datasets support
([#1412](googleapis/mcp-toolbox#1412))

### Features

* **cassandra:** Add Cassandra Source and Tool
([#1012](googleapis/mcp-toolbox#1012))
([6e42053](googleapis/mcp-toolbox@6e42053))
* **sources/postgres:** Add application_name
([#1504](googleapis/mcp-toolbox#1504))
([72a2366](googleapis/mcp-toolbox@72a2366))
* **tool/bigquery-execute-sql:** Add allowed datasets support
([#1443](googleapis/mcp-toolbox#1443))
([9501ebb](googleapis/mcp-toolbox@9501ebb))
* **tool/bigquery-forecast:** Add allowed datasets support
([#1412](googleapis/mcp-toolbox#1412))
([88bac7e](googleapis/mcp-toolbox@88bac7e))
* **tools/clickhouse-list-tables:** Add list-tables tool
([#1446](googleapis/mcp-toolbox#1446))
([69a3caf](googleapis/mcp-toolbox@69a3caf))


### Bug Fixes

* **tool/mongodb-find:** Fix find tool `limit` field
([#1570](googleapis/mcp-toolbox#1570))
([4166bf7](googleapis/mcp-toolbox@4166bf7))
* **tools/mongodb:** Concat filter params only once in mongodb update
tools ([#1545](googleapis/mcp-toolbox#1545))
([295f9dc](googleapis/mcp-toolbox@295f9dc))

---
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.

3 participants