How to grant privilege to Groups using Grant (redshift)

Help
,
1

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!

2

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.