Connect BigQuery with region location with datasphere

[Alebas-Ribeiro]

Issue description

Hello Guys,

I had a issue in a customer environment using big query for replication flow.

In a documentation , we assume that location is optional. (Image 1)

This customer had a big query in region location.

when we tried to connect in replication flow, the dataset is not loaded. (Image 2)

If I fill the location (in my case us-east1), the dataset from Big query load normally. (Image 3)

If its possible, we need to add this in the help documentation :

"When Google Bigquery dataset was create using region mode it’s necessary fill the location."

Cheers
Alebas

Feedback Type (Optional)

None

Page Title on SAP Help Portal (prefilled)

Prepare Connectivity to Google BigQuery

Page URL on SAP Help Portal (prefilled)

https://help.sap.com/docs/SAP_DATASPHERE/9f804b8efa8043539289f42f372c4862/529cef1eee6a45a69ae4e51951718900.html?version=cloud

[co-sti]

Dear Alebas,
thanks a lot for your feedback. I'll follow up on updating the documentation to improve the misleading part and let you know once done.
Best Regards,
Cornelia from the SAP Datasphere User Assistance team

[sap-doc-bot]

Thank you for your valuable feedback contribution, @Alebas-Ribeiro! So that we can recognize your contribution in SAP Community, please tell us your SAP Community profile URL in a reply to this comment; don't include any other text, just the URL on its own, like this:

https://people.sap.com/your-user-name

Thanks!

[Alebas-Ribeiro]

https://people.sap.com/ale.ribeiro From: sap-doc-bot[bot] ***@***.***> Date: Tuesday, 12 December 2023 at 04:38 To: SAP-docs/sap-datasphere ***@***.***> Cc: Ribeiro, Alexandre ***@***.***>, Mention ***@***.***> Subject: Re: [SAP-docs/sap-datasphere] Connect BigQuery with region location with datasphere (Issue #25) You don't often get email from ***@***.*** Learn why this is important<https://aka.ms/LearnAboutSenderIdentification> Thank you for your valuable feedback contribution, @Alebas-Ribeiro<https://github.com/Alebas-Ribeiro>! So that we can recognize your contribution in SAP Community<https://github.com/SAP-docs/contribution-guidelines/blob/main/docs/recognition.md>, please tell us your SAP Community profile URL in a reply to this comment; don't include any other text, just the URL on its own, like this: https://people.sap.com/your-user-name Thanks! — Reply to this email directly, view it on GitHub<#25 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BETRAS33VORATOQXDPL3POLYJACVZAVCNFSM6AAAAABAQKHVCSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNJRGQ2DSNZSGU>. You are receiving this because you were mentioned.Message ID: ***@***.***>

[co-sti]

Hi Alebas,

with 2024.02, the documentation for the Google BigQuery property "Location" will change to the following to make clear that datasets from any other than the default location are only available if the location is added in the connection configuration:

"[optional] Enter an additional location. By default, SAP Datasphere connects to BigQuery datasets only from Google's default location - US. Datasets from any other location will only be available in the Data Builder if you enter the additional location here.
A location can be a region, for example us-west1or asia-east1, or a multi-region, for example EU.
Note: If you provide an invalid location, the connection validation still passes, but failures will happen when you're using the connection in the Data Builder."

Thanks a lot for contributing to this documentation improvement.

Best Regards,
Cornelia from the SAP Datasphere User Assistance team

[co-sti]

I'm closing this issue since the correction is available in the 2024.02 version of the documentation.