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:
I would like to have the table dynamically set Dataiku based on the current code recipe.
Operating system used: Windows 10