Hi Everyone,
I am trying to use the SAS/Connect to snowflake for bulkload from SAS to snowflake db. i am on SAS 9.4 M7
My problem is i cant find how to define server side encryption on my bulkload options (SSE-S3) i.e. AES-256
If i was to directly copy a file to S3 using AWS CLI the command i run is
aws s3 cp /localpath/file s3://bucket/file --sse AES256
but when i try to use the bulkoad option i get access denied error ERROR: Message from TKS3: Access Denied
proc append base=snow.snowflake_table(bulkload=yes
bl_bucket="/mybucket"
) data=work.sasDataset force;
run;
I even tried using proc s3, i can list the objects in the bucket, but when i try to use PUT to transfer a file from local to S3 it fails again with access denied error. But listing the bucket contents using proc S3 works.
proc s3
;
put "/local/file.csv" "/bucket/file.csv";
list "/bucket";
run;
If anyone has any suggestions on how i can get the encryption to work or whether i need to change something in my approach please do guide me 🙂.
... View more
