Snowflake schema per project
Talal
Registered Posts: 1 ✭
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?
Answers
-
Konstantina Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 25 ✭✭✭✭✭
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