Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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