This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

Dataform - Bigquery Omni AWS problem

Posted on 03-04-2025 11:55 AM
jaime_parra
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

Hi, I'm currently working on the multi-cloud integration in my company.

To achieve this, we started to connect data from AWS into GCP through Bigquery Omni. For Data governance reasons and to get the best control in the process we started to use Dataform.

I'm trying configuring an external table using the operators but when we try to execute, I get the following error.

jaime_parra_0-1741117832500.png

We did enough roles to the Service agent but it continues failing.

jaime_parra_1-1741117948906.png

The AWS region we are configuring is "aws-east-1". Also when we copy and execute the query generated by Dataform in the bigquery console it works well.

Best regards,

 

2 4 299
Topic Labels
4 REPLIES 4