Issues with SAS VIYA caslib to Amazon Redshift -

[smm662002]

Hello,

SAS VIYA: LTS 2025.03

System: Openshift

I am trying to create and use a caslib to Amazon Redshift.

The code used to create the caslib is below:

proc cas;
table.addCaslib / name='rslib9'
		description='Amazon Redshift CASLIB'
        session=FALSE
        datasource={
            srctype='redshift',
			server='server_name',
			database='ttt',
			uid='user'
			pwd='password'			
		};
quit;

NOTE: Active Session now CASAUTO.
NOTE: 'rslib9' is now the active caslib.
NOTE: Cloud Analytic Services added the caslib 'rslib9'.
NOTE: The PROCEDURE CAS printed page 1.
NOTE: PROCEDURE CAS used (Total process time):
      real time           0.13 seconds
      cpu time            0.06 seconds

NOTE: Active Session now CASAUTO.
NOTE: 'rslib9' is now the active caslib.
NOTE: Cloud Analytic Services added the caslib 'rslib9'.
NOTE: The PROCEDURE CAS printed page 1.
NOTE: PROCEDURE CAS used (Total process time):
      real time           0.13 seconds
      cpu time            0.06 seconds

NOTE: Active Session now CASAUTO.
NOTE: 'rslib9' is now the active caslib.
NOTE: Cloud Analytic Services added the caslib 'rslib9'.
NOTE: The PROCEDURE CAS printed page 1.
NOTE: PROCEDURE CAS used (Total process time):
real time 0.13 seconds
cpu time 0.06 seconds

When I try to use with the code below I have the following error:

proc fedsql sessref=casauto;
create table casuser.test as
   select * 
   from connection to rslib9
   (
      select * 
      from from schema.t1
      limit 5
   );
quit;

/* ERROR: The connection to the data source driver failed. */
/* ERROR: ERROR: [SAS][ODBC Redshift Wire Protocol driver][Redshift]FATAL: no pg_hba.conf entry for host "???", user "belgium_user", */
/* database "tpd", SSL off(File */
/* /opt/brazil-pkg-cache/packages/RedshiftPADB/RedshiftPADB-1.0.180974.0/AL2_aarch64/generic-flavor/src/src/pg/src/backend/libpq */
/* /auth.c; Line 694; Routine ClientAuthentication; ) */
/* ERROR: The action stopped due to errors. */
/* ERROR: The FedSQL action was not successful. */

Any thoughts why is not working?

Thank you,

smm662002

[SASKiwi]

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.