topic Re: Unable to connect to Snowflake in Qlik Replicate

Unable to connect to Snowflake

RajasGujarathi — Tue, 29 Aug 2023 08:43:33 GMT

We are trying to establish a Snowflake connection as a target. Currently following the https://help.qlik.com/en-US/replicate/May2023/Content/Replicate/Main/Snowflake%20Target/SNOW.htm article. However, we are still facing issues.

The "QLIK_DB" does exist on Snowflake.

Re: Unable to connect to Snowflake

Arun_Arasu — Tue, 29 Aug 2023 08:56:34 GMT

Hello @RajasGujarathi ,

Thank you for getting in touch with the Qlik Community.

Could you kindly verify the following points:

Do you possess the necessary privileges to access the QLIK_DB?

Please ensure that the drivers you are utilizing are compatible with the specifications outlined in the user guide.

Have you had the opportunity to review the logs? If so, could you please share the insights or findings from the logs?

Your cooperation and response are greatly appreciated.

Regards

Arun

Re: Unable to connect to Snowflake

RajasGujarathi — Tue, 29 Aug 2023 09:08:39 GMT

> Do you possess the necessary privileges to access the QLIK_DB?

Yes, we are running a PoC and have full access.

> Please ensure that the drivers you are utilizing are compatible with the specifications outlined in the user guide.

I have not installed anything specifically or manually, I am using the driver that comes packaged with the Qlik - https://aws.amazon.com/marketplace/pp/prodview-nvvkm6lsly6i4

> Have you had the opportunity to review the logs? If so, could you please share the insights or findings from the logs?

So far have viewed the logs that come as a part of Qlik Console it shows the same error as attached above, let me know if there is any other location where the logs are detailed.

Re: Unable to connect to Snowflake

SachinB — Tue, 29 Aug 2023 10:13:30 GMT

Hello @RajasGujarathi ,

Above issue could be due to following reasons:

1. Driver is not installed as per the pre-requisites on the replicate machine

2. You might have defined the incorrect Database which did not exist on target

3. Kindly check for the case sensitive character.

4. Try to test this using ODBC connection.

Please follow the below links for more clarity.

https://community.snowflake.com/s/article/SQL-compilation-error-Object-does-not-exist-or-not-authorized-when-setting-up-replication

https://community.snowflake.com/s/question/0D50Z00008Korq5SAB/sql-compilation-error-object-does-not-exist-or-operation-cannot-be-performed

We would request you open the support case by attaching the diagnostic package and set all server parameter to verbose and do the test connection. Send repsrv.log for further investigation.

Thanks for understanding!!

Re: Unable to connect to Snowflake

RajasGujarathi — Tue, 29 Aug 2023 11:03:00 GMT

> Driver is not installed as per the pre-requisites on the replicate machine

Does this mean, I need to perform some manual steps before making use if Qlik?

Re: Unable to connect to Snowflake

Arun_Arasu — Tue, 29 Aug 2023 11:11:19 GMT

Hello @RajasGujarathi ,

Please refer to the below userguide
https://help.qlik.com/en-US/replicate/May2023/Content/Replicate/Main/Snowflake%20Target/prereq_SNOW.htm

Client prerequisites

Qlik Replicate for Windows:

Download and install Snowflake ODBC driver 2.24.0 (64-bit) or later for Windows on the Qlik Replicate Server machine.

Qlik Replicate for Linux:

Download and install Snowflake ODBC driver 2.24.0 (64-bit) or later for Linux on the Qlik Replicate Server machine.

Regards,

Arun

Re: Unable to connect to Snowflake

RajasGujarathi — Tue, 29 Aug 2023 11:21:59 GMT

Thanks @SachinB & @Arun_Arasu I am now able to connect to Snowflake as a target.

Had to install the Snowflake ODBC driver - https://docs.snowflake.com/en/developer-guide/odbc/odbc after launching the instance.