Big Query External Account - Data Loading Error in Non Admin User

[JieunKi1]

Hello, Everyone.

In our project, We use an external accout for Google BigQuery Data Connection.
There's no problem to use this one by administrator right.
But,  There's data access error if no admi operators try to use it.
 

Error message is like following :

You do not have access to data in the data source 'ncdm-p-pii-reader@kone-platform.iam.gserviceaccount.com:kone-platform@C:\Users\acadmin\Desktop\ncdm-p-pii-reader_20231219.json'.

We try to change key file directory or directory access permission,
created a user was created with all named right except administrator and the user was added to the external account folder.

Campaign Operators does not have to have Admin right but need to use bigquery data access.

It's critical for us.

Is there anyone who have similar problem?

Could anyone share any clue in this kind of problem?  

[Amine_Abedour · Accepted solution]

Hello @JieunKi1

You have to create a custom named right and give to non-amin users who need access to remote database.

Please follow this instructions to do so.

Br,

[JieunKi1]

@Amine_Abedour 
Thanks, a lot.

Could you share the custom named right example for the Google Big Query?

Thanks.

[Sukrity_Wadhwa]

Hi @Amine_Abedour,

Can you help @JieunKi1 further here?

Thanks!

[Amine_Abedour]

Hello @JieunKi1 

Could you share your Google BigQuery external accout config?

Br,

[JieunKi1]

[_Manoj_Kumar_]

Hello @JieunKi1 

Select the Upload Key file to server option and it should work.

Also, Please don't post the username and service account without masking.

[JieunKi1]

Hello, @_Manoj_Kumar_ 

Thanks for the reply for my case.
Could you explain for your comment ' Upload Key file to server option '?
I want to know where and how to do for ' Upload Key file to server option '.

Thanks

[_Manoj_Kumar_]

Hello @JieunKi1 

There is a dropdown in the highlighted section

Select the Upload Key to server and then upload the json key to server.

[JieunKi1]

Hello, Amine ABEDOUR

Thanks for consider this case.
I attached the external account setting for BigQuery connection.
If you have any question, Please leave a comment here.

Thanks

[emilrowlandSvsp]

Hi,

How should we name the nameright for a BigQuery FDA, so non Admins can access the DB?

We have uploaded the key to the server but we still get that the non Admins has no access to the remote database.