CODEWITHSUNDEEP
amazon-s3google-bigquery
idan
idan

Reputation: 2200

Big query external connection to AWS S3

I'm using Big query to query S3 storage. As you know I can add an external table from S3. So I clicked add table => selected S3 source => filled the right URL => filled the ARN role but I got an error so I looked at the helping icon and the requested format is fit to what I did. What is the problem? Does someone face the same issue?

enter image description here enter image description here

Upvotes: 0

Views: 705

Answers (1)

Vishal K
Vishal K

Reputation: 1464

As @Bruno said, you are using an IAM User instead of an IAM Role. So, change your AWS role id input from:

arn:aws:iam::account:user/user-name

To below ARN format to resolve your issue:

arn:aws:iam::account:role/my-role

Upvotes: 1

Related Questions