Accelerating Data Science with Snowflake and Dataiku

[vnay17]

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

[AlexT]

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]

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

 

[AlexT]

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.