Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
While creating a target endpoint for Snowflake and connecting to the database in Snowflake facing the error "Failed (retcode -1) to execute statement 'use database"xxx"' "
Hello @nithin_seeni ,
Welcome to Qlik Community forum and thanks for reaching out here!
Looks to me this is a permission issue, or if the database/schema is accessible. Would you please connect to Snowflake by the same account and execute below SQL:
use database "XXX";
To see if you get the same error.
BTW, there is another discussion: Snowflake End point error in QLIK replicate.
Hope this helps.
John.
Hello @nithin_seeni
Additional information on what John was added.
The required permissions differ according to whether or not the schema and/or the target tables already existed before the Replicate task started.
Please check permissions as mentioned in the user guide
Permissions required if you want schemas that do not exist to be created automatically
Permissions required if the schema already exists
Required permissions #Required permissions | Qlik Replicate Help
Regards,
Suresh
Hello @nithin_seeni ,
Welcome to Qlik Community forum and thanks for reaching out here!
Looks to me this is a permission issue, or if the database/schema is accessible. Would you please connect to Snowflake by the same account and execute below SQL:
use database "XXX";
To see if you get the same error.
BTW, there is another discussion: Snowflake End point error in QLIK replicate.
Hope this helps.
John.
Hello @nithin_seeni
Additional information on what John was added.
The required permissions differ according to whether or not the schema and/or the target tables already existed before the Replicate task started.
Please check permissions as mentioned in the user guide
Permissions required if you want schemas that do not exist to be created automatically
Permissions required if the schema already exists
Required permissions #Required permissions | Qlik Replicate Help
Regards,
Suresh
After adding the default role at the snowflake end to the account issue is fixed.
Thank you so much for the update @nithin_seeni .