Big Query External Account - Data Loading Error in Non Admin User | Community
Skip to main content
April 18, 2024
Solved

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

  • April 18, 2024
  • 1 reply
  • 1680 views

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?  

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Amine_Abedour

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,

 

1 reply

Amine_Abedour
Community Advisor
Amine_AbedourCommunity AdvisorAccepted solution
Community Advisor
April 18, 2024

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,

 

Amine ABEDOUR
JieunKi1Author
April 18, 2024

@amine_abedour 
Thanks, a lot.

 

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

 

Thanks.

Sukrity_Wadhwa
Community Manager
Community Manager
May 2, 2024

Hi @amine_abedour,

Can you help @jieunki1 further here?

Thanks!

Sukrity Wadhwa