Setting up Snowflake — the exact grant statements we run

Archive
21

Hey @claire! I just wanted to double-check the grants in section 7 for an existing analytics database. Should the last 2 lines grant to the role ‘reporter’ rather than ‘transformer’, in line with the rest of the section?

grant usage on all schemas in database analytics to role reporter;
grant select on all tables in database analytics to role reporter;
grant select on all views in database analytics to role reporter;

Thanks!

1 Like
22

Thanks Eugene!! I don’t have time to dig into this right now, but I’ll return to your comment next time I’m setting up Snowflake. Much appreciated.

23

Eeguh bo myun jeon hwa jo… nae ga jeong mal jeong mal mee an hae