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
