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

Options
info-rchitect
info-rchitect Registered Posts: 169 ✭✭✭✭✭✭
edited July 16 in Using Dataiku

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

Tagged:
Setup Info
    Tags
      Help me…