Unable to Run DBT Glue Job in eu-west-2 in DEV Account

0

Dear all,

We are looking to implement Glue ETL jobs into our Data Pipeline processing.

To achieve this we are using the DBT Glue Adaptor https://github.com/aws-samples/dbt-glue

and following this AWS tutorial demo to get started - https://aws.amazon.com/blogs/big-data/build-your-data-pipeline-in-your-aws-modern-data-platform-using-aws-lake-formation-aws-glue-and-dbt-core/

We're able to successfully deploy and run this tutorial in regions - us-west-1, us-east-1, eu-west-1, eu-central-1. We are also able to deploy this in eu-west-2 in our STAGING account.

However, we are NOT able to run it in eu-west-2 (London) in our DEV Account.

Please note we use eu-west-2 as our primary region and have previously used Lake Formation for proof of concept projects. So I'm not sure if this has something to do with it.

We've tried everything including deleting all stacks and IAM Permissions/Roles/Policies related to Glue, Lake Formation in eu-west-2 and it doesn't seem to work.

We don't think its a problem with the dbt glue connector as this works correctly across other regions including eu-west-2 in our STAGING account.

Can anyone kindly advise how to debug or resolve this?

Thanks in advance,

Eric Sales De Andrade

質問済み 2年前218ビュー
1回答
0

Resolved - Turns out the glue service role didn’t have access to the default glue db in Lake Formation

回答済み 2年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン