3803010 - Data Flow - No datasets or tables visible when selecting Google BigQuery as the source - SAP Datasphere

No dataset or table can be shown after choosing the Google Big Query as the source even the Connection validation tells 'Data Flows are enabled'.

Even delete driver -> upload driver -> Sync cannot solve the issue:

As a comparing, if creating a Replication Flow and choose the same connection, there's dataset returned.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP Datasphere

1. Open Data Builder in the target space.
2. Create a new Data Flow.
3. In Sources, expand Connections.
4. Select the Google BigQuery connection and choose Import.
5. Observe that no datasets or tables appear on the right side although they exist in BigQuery.

By default, SAP Datasphere connects to BigQuery datasets only from Google's default location - US.

If the customer's datasets are located in a non-US region (e.g., EU), the Location parameter in the BigQuery connection must be configured to match the actual dataset region; otherwise, Data Builder will not list any datasets or tables.

With the below configuration - EMPTY location, no dataset will be returned:

Enter the relevant BigQuery region(s) or multi-region(s) as a comma-separated list (for example: EU, us-west1, asia-east1).

Note: By default or leaving it as EMPTY, only datasets in Google’s default location (US) are listed; additional locations must be specified here based on customer's actual region.

• SAP Datasphere - Prepare Connectivity to Google BigQuery
• Google BigQuery Connections
• SAP Note 3424000 - SAP Datasphere issue with BQ Google Connection

Datasphere, Data Builder, data flow, Google BigQuery, BigQuery connection, datasets not visible, tables not visible, empty source list, Import shows nothing, connection location, region, EU, US default, additional locations, discovery issue , KBA , DS-DI-DF , Data Flow Runtime , Problem