Failed (retcode -1) to execute statement 'use database"xxx"'

[nithin_seeni]

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"' "

[john_wang · Accepted solution]

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.

[sureshkumar · Accepted solution]

Hello @nithin_seeni 

Additional information on what John was added.

Required permissions

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

Tables created by Replicate

Permissions required if you want schemas that do not exist to be created automatically

• USAGE ON DATABASE
• CREATE SCHEMA ON DATABASE

Permissions required if the schema already exists

• USAGE ON DATABASE
• USAGE ON SCHEMA
• CREATE FILE FORMAT ON SCHEMA
• CREATE STAGE ON SCHEMA
• CREATE TABLE ON SCHEMA

Required permissions #Required permissions | Qlik Replicate Help

Regards,

Suresh

[nithin_seeni]

After adding the default role at the snowflake end to the account issue is fixed. 

[john_wang]

Thank you so much for the update @nithin_seeni .