Snowflake schema per project

Level 1
Snowflake schema per project

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?

0 Kudos
1 Reply
Level 3


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!



0 Kudos