Possible to create dynamic variables for Python post-write SQL statements?

info-rchitect

Hi,

I am continually having to add the following post-write SQL statements to my Python recipes.

grant select on table MYDB.MYSCHEMA.MYTABLE to role ROLE1;
grant select on table MYDB.MYSCHEMA.MYTABLE to role ROLE2;

I already have some variables that define the database and schema:

{
  "snowflake_db": "MYDB",
  "snowflake_schema": "MYSCHEMA"
}

I would like to have the table dynamically set Dataiku based on the current code recipe.

thx

---

Operating system used: Windows 10