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?

CodePudding user response：

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