Accelerating Data Science with Snowflake and Dataiku

vnay17
vnay17 Registered Posts: 2

Job failed: SQL compilation error: Stage 'PC_DATAIKU_DB.PUBLIC.DATAIKU_DEFAULT_STAGE' does not exist or not authorized.

View job details


Operating system used: Windows

Answers

  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,225 Dataiker
    edited July 17

    Hi @vnay17
    ,

    Are you using Dataiku Cloud instance? Since Snowflake UDF is enabled by default you will need to have a stage created on your Snowflake connection to recipe to be able to use UDF.

    When setting up the connection, you should have been suggested a script to run in the Snowflake console that would create this stage. Can you please try to create the stage in Snowflake using :

    The steps to create / grant permission to this role would be :
    -- Use database
    
    USE DATABASE PC_DATAIKU_DB;
    
    -- Create stage if not exists
    
    CREATE STAGE IF NOT EXISTS "DATAIKU_DEFAULT_STAGE";
    
    -- Grant ownership on stage to role. replace role_name with actual role name you have set in your connection
    
    GRANT OWNERSHIP ON STAGE "DATAIKU_DEFAULT_STAGE" TO ROLE role_name;
    ​

    If you have any further issues please reach out to Support via Chat widget in your Dataiku Cloud Launchpad.


    Kind Regards,

  • vnay17
    vnay17 Registered Posts: 2

    I have already created stage using the same steps. But still the same issue like SQL compilation error: Stage 'PC_DATAIKU_DB.PUBLIC.DATAIKU_DEFAULT_STAGE' does not exist or not authorized

  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,225 Dataiker

    That's unexpected when you ran the script in Snowflake, did you make sure to select the whole script and "run all"? Did you receive any error in Snowflake console?

    Please reach out to support https://knowledge.dataiku.com/latest/dataiku-cloud/support/index.html so we can assist further.

Setup Info
    Tags
      Help me…