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?


  • konathan
    konathan Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 25 ✭✭


    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!


Setup Info
      Help me…