How to use ENC_keys in amazon redshift bulk loading in SAS 9.4 M6

ganesh56271 — Thu, 05 Mar 2020 16:17:02 GMT

HI Team,

we are trying to encrypt our amazon s3 bucket ACCESS ID & SECRET Keys. so i had followed below process but still getting no access key ID found error.

Steps followed:

1. created ENCKEY ADD statment (Xname)

2. Now trying to use the same name but its not recognizing ENCKEY name and giving ACCESS KEY ID not found error.

ERROR: Message from TKS3: No access key ID specified.

NOTE: The DATA step has been abnormally terminated.

topic How to use ENC_keys in amazon redshift bulk loading in SAS 9.4 M6 in SAS Data Management

How to use ENC_keys in amazon redshift bulk loading in SAS 9.4 M6