Create Row Acces Policy

create_row_access_policy.sql

CREATE OR REPLACE ROW ACCESS POLICY  customer_loyalty_city_row_policy 
as (city VARCHAR) RETURNS BOOLEAN ->
       CURRENT_ROLE() IN (<ROLE_NAME1>,<ROLE_NAME2>) -- e.g. 'TASTY_ADMIN','TASTY_DEV' 
        OR EXISTS 
            ( SELECT rp.role_name 
              FROM   frostbyte_tasty_bytes.data_governance.customer_loyalty_city_policy_mapping rp
              WHERE  rp.role_name = CURRENT_ROLE()
                AND  rp.city_value = city
            );