Accelerating Data Science with Snowflake and Dataiku
Job failed: SQL compilation error: Stage 'PC_DATAIKU_DB.PUBLIC.DATAIKU_DEFAULT_STAGE' does not exist or not authorized.
Answers
-
Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,225 Dataiker
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, -
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 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.