##dbt-glue connection_IAM-permission
Hi Community,
I am new to dbt and currently encountering two errors:
1.Git related error
2.IAM policy error
I believe that even without Git installed, we should be able to access the dbt-Glue connection. However, I’m receiving the following error:
Error
Glue adapter: Error during connect for session dbt-glue__AllowPassRoleToGlue
Connection test: [ERROR]
2 checks failed:
-
Error from git --help: Could not find command, ensure it is in the user’s PATH and that the user has permissions to run it: “git”
-
dbt was unable to connect to the specified database.
The database returned the following error:
>Database Error
An error occurred (AccessDeniedException) when calling the CreateSession operation: User:
Below is the profiles.yml configuration:
default:
outputs:
dev:
type: glue
role_arn: arn:aws:iam::ACCESS_ID:role/AllowPassRoleToGlue
region: region
workers: 5
worker_type: G.1X
schema: "test_schema"
session_provisioning_timeout_in_seconds: 20
prod:
type: glue
role_arn: arn:aws:iam::ACCESS_ID:role/AllowPassRoleToGlue
region: eu-west-1
workers: 5
worker_type: G.1X
schema: "dbt_test_{{ var('_dbt_random_suffix') }}"
session_provisioning_timeout_in_seconds: 20
target: dev
I have tried multiple inline IAM policies, including the following AllowPassRoleToGlue policy:
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": "glue:*",
"Resource": "*"
}
]
}
pip show dbt-glue
Name: dbt-glue
Version: 1.8.6
I would appreciate any guidance or suggestions to resolve these issues. If you need any further clarification, please let me know.
Thank you