How to grant privilege to Groups using Grant (redshift)

Hi, I’m reading through this link: grants | dbt Developer Hub (getdbt.com)
And I cannot find a way to define if you’re granting privilege to a GROUP.

Would be cool if we don’t need to do macros for this and just use the new feature.

I already tried this:

models:
  my_schema:
    schema: my_schema
    description: "My schema"
    grant:
      select:
        - group: my_group

Didn’t get much luck.

Thanks!

Have you tried

models:
  my_schema:
    schema: my_schema
    description: "My schema"
    grant:
      select:
        - my_group

?

You should only need to provide the group/user name, as redshift doesn’t require you to know the type of entity (individual user vs group) that is being granted access, just its name.

I was able to have success on Redshift with 1.5.1 with the following:

models:
  +grants:
    select: ["group my_group_name"]

Not including the + will cause the word grants to look like a configuration path. And using +grant (singular) doesn’t seem to cause errors but it doesn’t actually do anything either (search for grant in the logs turned up nothing).

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.