Expand my Community achievements bar.

SOLVED

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

Avatar

Level 1

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?  

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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,

 

View solution in original post

10 Replies

Avatar

Correct answer by
Community Advisor

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,

 

Avatar

Level 1

@Amine_Abedour 
Thanks, a lot.

 

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

 

Thanks.

Avatar

Administrator

Hi @Amine_Abedour,

Can you help @JieunKi1 further here?

Thanks!



Sukrity Wadhwa

Avatar

Community Advisor

Hello @JieunKi1 

 

Could you share your Google BigQuery external accout config?

 

Br,

Avatar

Community Advisor

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.


     Manoj
     Find me on LinkedIn

Avatar

Level 1

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

Avatar

Community Advisor

Hello @JieunKi1 

 

There is a dropdown in the highlighted section

Manoj_Kumar__0-1715559940576.png

 

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


     Manoj
     Find me on LinkedIn

Avatar

Level 1

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

Avatar

Level 1

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.