Snowflake schema per project

[Talal]

Hi everyone,

Our team wants to create a new snowflake schema per project. We configured the connection to have ${projectKey} in the naming rules schema field. The issue occurs when running a dataset. When creating a new project and running a dataset, an error occurs that the schema doesn't exist.

Is there a way to force Dataiku to create the schema automatically if it doesn't exist?

[konathan]

Hi,

You can try creating the schema through a SQL recipe by running the line

create schema Database_Name.DSSProjectID;

Let me know if that helps!

-Konstantina