dbt-labs / dbt-snowflake

dbt-snowflake contains all of the code enabling dbt to work with Snowflake
https://getdbt.com
Apache License 2.0
296 stars 176 forks source link

Update database role tests to avoid colliding with parallel test runs #1197

Closed mikealfare closed 1 month ago

mikealfare commented 1 month ago

Problem

The affected database role test uses a static name for the role name. It's possible for two parallel runs to collide and attempt to drop/create the same role at the same time, causing the test to fail.

The affected database role is granted future permissions on all tables in the database, which affects other grants tests.

Solution

Checklist