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 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?
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