Yes I did try that but still did not work. It turns out that my Networking Team have now fixed the issue . There was a firewall blocking access to the OKTA URL from SAS server and once that was opened my issue got resolved. @um3rella BTW Since you are of the SNOWFLAKE & SAS Users i found in this community, i wanted to check if you too faced this problem i reported here https://communities.sas.com/t5/SAS-Programming/Temporary-Table-support-in-Snowflake-from-SAS/m-p/735319#M229069 in your Testing of Snowflake from SAS .Basically if i want to join a SAS dataset with a SnowFlake Table I am unable to make use of the TEMPOARARY Table concept in SNOWFLAKE ( similar to VOLATILE TABLE in Teradata) to do the join in a more efficient manner. Looks like R&D is still looking into this.
... View more