Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
rolmontero
Partner - Contributor III
Partner - Contributor III

Qlik Application Automation Snowflake Connector

Hello everyone,

I'm trying to use Qlik Application Automation along with Snowflake, but I am facing some difficulties. I have created a database and table in Snowflake with some records. Additionally, I have also created a connection with Qlik which works fine; I can fetch the data without a problem. However, when I use the same parameters in Qlik Application Automation, it does not seem to work. For instance, I am using a block called Update Record by One Field, but it does not retrieve the table name.

rolmontero_0-1688668995228.png

 

My connection looks like this:

rolmontero_1-1688669142165.png

This instance of Snowflake is a trial one. Does it matter?

 

Thanks!

 

 

 

Labels (2)
1 Solution

Accepted Solutions
Shai_E
Support
Support

Hi @rolmontero ,

Open a case for support, with pictures of connection info from the automation side + analytics side, with the description from this post.

Best Regards

View solution in original post

9 Replies
Shai_E
Support
Support

Hi @rolmontero ,

Did you get this error by pressing search?

Thanks

rolmontero
Partner - Contributor III
Partner - Contributor III
Author

Hellon @Shai_E ,

Yes, I did get that error when I clicked on search so that I could fetch the table name. I have also tried writing the name manually, but it shows an SSL error even though the table, schema, and WH are correct.

 

Thanks for your help!

Shai_E
Support
Support

Hi @rolmontero ,

The only thing that i can suggest here is to open a case for support, why am i suggesting this?

From a test i did a few days ago i know that the connector itself works there shouldn't be a problem with it, as it works in my test environment.

This seems more like some kind of connectivity issue, in which product in Qlik does these credentials work?

In order to troubleshoot why you are not able to connect to your snowflake via the automation module i will need the connections guiid, this requires me to give guidance on how to do this through the developer tools in your web browser so a case is more suited, but even then i might not find the issue (it might be connectivity based).

Best Regards

 

rolmontero
Partner - Contributor III
Partner - Contributor III
Author

Hello again,

Yes, the connector from the analytics module of Qlik works fine, and thus I can connect and fetch data without any problems whatsoever. I believe the automation module has some issues regarding that connector. Thanks for your advice.

 

Have a nice day

rolmontero
Partner - Contributor III
Partner - Contributor III
Author

Hi,

When I don't use the search option from the block and I write the name manually, I get this error:

rolmontero_0-1690227927168.png

Whereas, on the analytics side, as mentioned before, I fetch the data with no problems:

rolmontero_1-1690228134388.png

 

 

Shai_E
Support
Support

Hi @rolmontero ,

Open a case for support, with pictures of connection info from the automation side + analytics side, with the description from this post.

Best Regards

Florentin74
Partner - Creator
Partner - Creator

Hi there,

I have the same issue. Did you get a solution for this issue @rolmontero ? 

rolmontero
Partner - Contributor III
Partner - Contributor III
Author

Hi @Florentin74 ,

 

Unfortunately, I haven't found any solution for this issue yet.

 

 

TTI-Richard
Contributor II
Contributor II

remove the .snowflakecomputing.com from the account_name settings