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.

Amine_Abedour
Community Advisor
Community Advisor
May 11, 2024

Hello @jieunki1 

 

Could you share your Google BigQuery external accout config?

 

Br,

Amine ABEDOUR