topic Re: Snowflake End point error in QLIK replicate in Qlik Replicate

Snowflake End point error in QLIK replicate

jyeragi — Fri, 06 Oct 2023 16:27:17 GMT

I have setup a target end point to snowflake and keep getting following error:

SYS-E-HTTPFAIL, Cannot connect to Cloud server.
SYS,GENERAL_EXCEPTION,Cannot connect to Cloud server,Failed use schema RetCode: SQL_ERROR SqlState: 02000 NativeError: 2043 Message: SQL compilation error: Object does not exist, or operation cannot be performed. Failed (retcode -1) to execute statement: 'use schema "PUBLIC";

Re: Snowflake End point error in QLIK replicate

Dana_Baldwin — Fri, 06 Oct 2023 17:20:40 GMT

Please ensure the user configured on the target endpoint has permissions assigned: Required permissions #Required permissions | Qlik Replicate Help

Also, please confirm you're using the correct driver version for the version of Qlik Replicate that you're using (you can change the version of the documentation at the top left of this screen): Prerequisites | Qlik Replicate Help

Hope this helps!

Dana

Re: Snowflake End point error in QLIK replicate

john_wang — Sat, 07 Oct 2023 09:59:02 GMT

Hello @jyeragi ,

Besides @Dana_Baldwin comment: by default, Replicate uses the schema "PUBLIC" in the connection. If you want to specify a different one, you may

Open Snowflake target endpoint
Go to the Advanced tab
Go to the Internal properties
Add below parameter in the input label
metadataschema
set the value to your schema eg "MYSCHEMA" in below sample. The default value is PUBLIC:

Hope this helps.

Regards,

John.

Re: Snowflake End point error in QLIK replicate

jyeragi — Tue, 24 Oct 2023 14:47:04 GMT

Thanks @Dana_Baldwin for your quick response.

All the permissions are set correctly and the drivers are also the latest ones.

Re: Snowflake End point error in QLIK replicate

jyeragi — Tue, 24 Oct 2023 14:48:39 GMT

@john_wang , Thanks for that parameter. I was able to get thru it once the parameter was added and updated with the schema name which i was using.

Re: Snowflake End point error in QLIK replicate

john_wang — Tue, 24 Oct 2023 15:44:30 GMT

Hello @jyeragi ,

Glad to hear that, thanks for your update!

Best Regards,

John.