Snowflake End point error in QLIK replicate

[jyeragi]

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

[Dana_Baldwin]

Hi @jyeragi 

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

[john_wang · Accepted solution]

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

1. Open Snowflake target endpoint
2. Go to the Advanced tab
3. Go to the Internal properties
4. 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.

[jyeragi]

Thanks @Dana_Baldwin  for your quick response. 

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

[jyeragi]

@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.

[john_wang]

Hello @jyeragi ,

Glad to hear that, thanks for your update!

Best Regards,

John.