I am trying to connect to Google BigQuery in KNIME using the Simba JDBC driver, but I’m facing issues with the browser-based OAuth authentication. When attempting to connect, I receive the error: “Unable to obtain application default credentials” after setting the OAuthType=0 in the JDBC connection string,However, when I use DBeaver, the browser window automatically opens, allowing me to log in and authenticate successfully with Google Cloud, and I can connect to BigQuery without issues. In KNIME, I don’t see this browser-based authentication prompt and instead get the credential error mentioned above.
Has anyone encountered this issue or found a way to trigger the browser-based authentication flow in KNIME for connecting to BigQuery? Any suggestions for how to resolve this would be greatly appreciated.