For this type of problem when there is no obvious evidence of the cause, then a good starting point for a Windows SAS installation would be to check if all SAS services are running on all servers in the installation. If any are not running, then trying a manual start would be the next step. If you are a SAS administrator then these steps should be familiar to you. If not then talk to your SAS administrator to find out what troubleshooting has been done.   I would also follow @JOL 's recommendation. ... View more

If you use a DATA step with Snowflake then the database, and schema must be defined in the LIBNAME statement. You can only use a LIBREF and a table name in the DATA statement like in the example I posted. ... View more

PERM is the only LIBREF you have defined for Snowflake. If you want to read a SAS table and write it to Snowflake in a DATA step the syntax should look like this: data perm.cars; set sashelp.cars; run; ... View more

Does the Redshift connection work OK in a DATA step or PROC SQL query? If not then I would suspect the problem is with the Redshift connection. If yes then I would suspect there is an issue on the CAS side. ... View more

@AndrewZ  - This is indeed the Snowflake driver used for the SAS/Access Interface to Snowflake. It should have posted this link: https://tshf.sas.com/techsup/download/hotfix/HF2/M3H.html#M3H004   ... View more

@AndrewZ - SAS have just released a new version of the SAS Snowflake ODBC driver for which there is a hot fix available. The previous SAS-supplied driver is no longer supported by Snowflake so it might be worthwhile testing this fix.  ... View more

You should also try setting the INSERTBUFF option as the default value is not optimal. Try INSERTBUFF = 10000 as a starting point but feel free to experiment with higher or lower values. ... View more

Please note that when using a remote SAS server it can be quite normal to have large variations in run time with the same program and data. This is because you are sharing the server with other users and if it is heavily loaded then program run times can take a lot longer than usual. The way you are monitoring the size of your lck SAS files is a good one. ... View more

A starting point to tracking user activity in SAS installations is to implement SAS's APM functionality. Here is a useful link for this: https://support.sas.com/kb/68/709.html   You should also search the SAS documentation for APM to learn more. ... View more

Does this help? - https://community.snowflake.com/s/article/ODBC-connectivity-to-snowflake-fails-with-error-Marshaling-private-key-failed-when-using-Key-Pair-Authentication ... View more

Is your SAS Viya environment already configured and working with Snowflake? If it is then tweaking it for a different database and/or authentication method shouldn't be too difficult. If it isn't then authentication is just one of many things that will need to be configured, including Viya.   What authentication method you use will most likely be dictated by what your Snowflake administrators have allowed. I suggest you consult with them if you haven't already.  ... View more

As @Kurt_Bremser has already stated, just a script wont work unless your administrators set up a network folder share that is accessible from your SAS server. Once that is done SAS code can be run on Viya 4 that will write to the share. PROC EXPORT would be one option to write SAS data to an Excel spreadsheet or a CSV file. ... View more

I suggest you explore creating a Viya Visual Analytics dashboard to track metrics from your monthly data feeds. Seeing your data graphically often shows up issues that otherwise would not be obvious. You can start to get ideas for a dashboard from the Viya Visual Analytics Gallery. It doesn't have to be as fancy as many of these. Start simple and go from there. ... View more

What SAS user interface is used here? If it is Enterprise Guide, then change your EG server connection to not use IWA (just Windows account and password) and test the same LIBNAME again. If this works then the problem is with IWA and SPNs for the storage being accessed. If it doesn't work then the problem is with the Windows account permissions on the folders in the LIBNAME and has nothing to do with IWA. ... View more

Looks like you are reading all columns from your Snowflake table CLD95_TRANSACTION_MM. How many columns are there? If suggest you try just extracting one column from the table as a test. Do you get the same error? If not try adding columns one at a time until you identify the column giving the error. ... View more