SAP Knowledge Base Article - Preview

3432433 - Error when validating Google Big Query Connection in Datasphere

Symptom

The following error is generated when validating Google BigQuery connection in Datasphere : 

  • Connection "XXX" is valid, but not all features are available.
    - Data flows can’t be used because of errors in the connection.
    - Replication flows can’t be used because of errors in the connection.
    - Remote tables are enabled.
    Data Flows: Cause: Open request could not be performed due to error: ODBC call <SQLDriverConnect> for data source <> failed: <SQL submitted to database <> resulted in error <[Simba][BigQuery] (100) Error interacting with REST API: >. The SQL submitted is <SELECT 1>.>.
    Replication Flows: Cause: Open request could not be performed due to error: ODBC call <SQLDriverConnect> for data source <> failed: <SQL submitted to database <> resulted in error <[Simba][BigQuery] (100) Error interacting with REST API: >. The SQL submitted is <SELECT 1>.>.


Read more...

Environment

  • SAP Datasphere

Product

SAP Datasphere all versions

Keywords

GCP, Simba, BigQuery, Datasphere, Connection, SQLDriverConnect, Google , KBA , DS-DI-RF , Replication Flow Runtime , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.