Google Big Query not working on self hosted integration runtime

Question

Google Big Query not working on self hosted integration runtime

Jonty 25

Google Big Query is not working on self hosted integration runtime v5.48.9106.2.

When I run a query it returns the following error:

Method not found: 'Microsoft.DI.MSDISDKConnectorInterfaces.DataObjects.Condition Microsoft.DI.Connector.USDK.IReader`1.get_Conditions()'.

It works fine if I use the default cloud runtime, I suspect there is a bug in this on prem version.

Smaran Thoomu 23,095 Reputation points Microsoft External Staff Moderator

2025-05-05T12:08:35.6666667+00:00
Hi @Jonty
Based on the error message you're encountering:

Method not found: 'Microsoft.DI.MSDISDKConnectorInterfaces.DataObjects.Condition Microsoft.DI.Connector.USDK.IReader`1.get_Conditions()'

This typically points to a mismatch or compatibility issue between the connector version and the Self-hosted Integration Runtime (SHIR).

Since your query works fine using the Azure-hosted IR, but fails on the SHIR (v5.48.9106.2), it's likely that the Google BigQuery connector or its dependencies are not properly updated or supported in your SHIR version.

Recommended Actions:

Update the Self-hosted IR to the latest version

Ensure your SHIR is fully updated. You can do this from the ADF portal or directly on the machine where SHIR is installed.

Go to Manage > Integration Runtimes > Your SHIR > Auto-update settings.

Or manually download the latest version from here: https://learn.microsoft.com/en-us/azure/data-factory/create-self-hosted-integration-runtime#download-and-install-the-integration-runtime

Note: As of now, the latest version may include bug fixes or updated connector interfaces not present in your current build.

Restart the IR after updating

After upgrading, restart the IR service to make sure changes take effect.

Recheck connector support on SHIR

Some connectors (like Google BigQuery) have limited or preview support on SHIR. If you're using a newly supported connector or feature, confirm that it’s officially supported on SHIR via the documentation:

https://learn.microsoft.com/en-us/azure/data-factory/connector-google-bigquery

Alternative Workaround:

If the feature isn’t supported yet or the latest SHIR still doesn't work:

Continue using the Azure-hosted IR for Google BigQuery activities as a temporary workaround until full support is stable in SHIR.

Let us know if updating the SHIR resolves your issue. If not, we can help you further investigate or raise this with the product team.

I hope this information helps. Please do let us know if you have any further queries.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.
Jonty 25 Reputation points

2025-05-05T13:41:42.51+00:00

Hi, I am already on the latest version of the Self-hosted IR so unfortunately not helpful.

Thanks
Jonty 25 Reputation points

2025-05-06T07:50:28.71+00:00

UPDATE:

So by uninstalling the runtime and re-installing version 5.46.9020.1 the Google Big Query data source is working again.

I have also set the auto update to false to ensure it does not break again.

Accepted answer

0 additional answers

Your answer

Jonty 25 Reputation points

2025-05-05T13:41:42.51+00:00

Hi, I am already on the latest version of the Self-hosted IR so unfortunately not helpful.

Thanks
Jonty 25 Reputation points

2025-05-06T07:50:28.71+00:00

UPDATE:

So by uninstalling the runtime and re-installing version 5.46.9020.1 the Google Big Query data source is working again.

I have also set the auto update to false to ensure it does not break again.

Answer 1

Hi @Jonty
I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others "I'll repost your solution in case you'd like to accept the answer.

Solution: The issue was resolved by uninstalling the existing runtime and reinstalling version 5.46.9020.1. After reinstalling, the Google BigQuery data source started working correctly.

It appears the latest runtime version may have introduced a regression, so using a stable earlier version like 5.46.9020.1 is a practical workaround until a fix is officially released.

Additionally, setting auto-update to false helped prevent the issue from recurring due to unexpected version changes.

Hope this helps others facing a similar issue!

If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.

If you have any other questions, please let me know. Thank you again for your time and patience throughout this issue.

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members

Share via

Google Big Query not working on self hosted integration runtime

0 additional answers

Your answer