Activating a Secondary Role

Claro's lead data engineer holds ANALYST_ROLE as their primary role for all day-to-day work. This morning they need to run a one-off CREATE TABLE statement in the CORE schema — a privilege their ANALYST_ROLE does not hold. They have been granted a separate role that includes this privilege, but they want to keep ANALYST_ROLE active as their primary role rather than switching the session context entirely.

What is the correct approach?