Snowflake schema per project

Options
Talal
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

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

    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

Setup Info
    Tags
      Help me…