topic Re: Failed (retcode -1) to execute statement 'use database"xxx"' in Qlik Replicate

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

nithin_seeni — Tue, 30 Jul 2024 06:16:11 GMT

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

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

john_wang — Tue, 30 Jul 2024 06:27:29 GMT

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.

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

sureshkumar — Tue, 30 Jul 2024 11:12:19 GMT

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

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

nithin_seeni — Tue, 30 Jul 2024 11:14:29 GMT

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

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

john_wang — Tue, 30 Jul 2024 11:26:20 GMT

Thank you so much for the update @nithin_seeni .