dbt_user_group.sql

-- create dbt user and group
create user dbt with password 'CHANGE_ME!'
    nocreatedb nocreateuser syslog access restricted
    connection limit 10;

-- create dbt group
create group dbt with user dbt;

-- grants on tickit_external schema
grant usage on schema tickit_external to group dbt;
grant create on schema tickit_external to group dbt;
grant all on all tables in schema tickit_external to group dbt;

-- grants on tickit_dbt schema
grant usage on schema tickit_dbt to group dbt;
grant create on schema tickit_dbt to group dbt;
grant all on all tables in schema tickit_dbt to group dbt;

-- reassign schema ownership to dbt
alter schema tickit_dbt owner to dbt;
alter schema tickit_external owner to dbt;