BookmarkSubscribeRSS Feed
ql4
Calcite | Level 5 ql4
Calcite | Level 5

I got this error when I tried to connect my SAS to snowflake. I am using key pair to connect. Regenerated new key pair many times but still got this error.

3 REPLIES 3
gwootton
SAS Super FREQ
You could try running on Snowflake:
SYSTEM$GET_LOGIN_FAILURE_DETAILS('108dc7f8-afcc-4ed6-8b9b-9ff3')
to see if it gives any more information.

https://docs.snowflake.com/en/sql-reference/functions/system_get_login_failure_details

https://docs.snowflake.com/en/user-guide/key-pair-auth-troubleshooting#label-key-pair-troubleshootin...
--
Greg Wootton | Principal Systems Technical Support Engineer
ql4
Calcite | Level 5 ql4
Calcite | Level 5

when i ran this query "SYSTEM$GET_LOGIN_FAILURE_DETAILS('62d3c9ef-239a-4d33-83bf-a9e31b2ac4e6')" in snowflake SQL worksheet, I got this error: "Syntax error: unexpected 'SYSTEM$GET_LOGIN_FAILURE_DETAILS'. (line 1)". 

gwootton
SAS Super FREQ
The first link I provided is the documentation for that function if you are having issues using it.
--
Greg Wootton | Principal Systems Technical Support Engineer

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 339 views
  • 0 likes
  • 2 in conversation