dbt-labs / dbt-athena

The athena adapter plugin for dbt (https://getdbt.com)
https://dbt-athena.github.io
Apache License 2.0
228 stars 100 forks source link

[Feature] Glue database creation should be optional #716

Open moltar opened 2 months ago

moltar commented 2 months ago

Is this your first time submitting a feature request?

Describe the feature

Currently, a run will create a schema if it does not exist.

This is done via the athena__create_schema macro.

However, we pre-created the schema, and it will be always available, thus we never need to create one.

However, this requirement requires us to open up IAM permissions to create schemas, because even running such query, even nothing is created, will fail unless permission is given.

Describe alternatives you've considered

To give permission glue:CreateDatabase.

Who will this benefit?

Everyone who is mindful of security.

Are you interested in contributing this feature?

No

Anything else?

N/A