Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
nirutaware
Contributor
Contributor

Can't connect to Snowflake

Hello,

I have multiple snowflake connections created in Qlik SAAS

All were working fine until today.

Now all snowflake connections are failing due to below error

Error
ERROR [42000] SQL compilation error: syntax error line 1 at position 4 unexpected '-'.
 
Kindly help.
Labels (1)
  • SaaS

1 Solution

Accepted Solutions
Akshesh_Patel
Support
Support

@nirutaware  Would you mind trying now and seeing if the error still persists? there is some improvement has been made recently, that might resolve your issue.

Thanks

View solution in original post

4 Replies
Akshesh_Patel
Support
Support

Hi @nirutaware   Do you know which region your tenant belong to?

Akshesh_Patel
Support
Support

Hi,

I see the error : message='Error message: Please check the values for Username‚ Password‚ Host and other properties. Description: Syntax error or access violation', detailMessage='ERROR [42000] SQL compilation error: syntax error line 1 at position 4 unexpected '-'.'.

Please check your connection details again, edit the credential and Test the connection before reloading any apps.

 

Thank you

Akshesh_Patel
Support
Support

@nirutaware  Would you mind trying now and seeing if the error still persists? there is some improvement has been made recently, that might resolve your issue.

Thanks

nirutaware
Contributor
Contributor
Author

Hello,

This issue got resolved automatically,
not sure how but, our apps were failing for almost two days, and from 3rd day it succeeded.

Did not change anything in connection though.