topic Re: Extracting token from AWS Secrets using Proc Http in Administration and Deployment

Extracting token from AWS Secrets using Proc Http

thesasuser — Wed, 26 Mar 2025 20:34:12 GMT

Hello
I am working on creating a SAS job using Proc HTTP (or any other SAS procedure) to extract token from the AWS Secret for accessing Databricks.
Wondering if somebody has worked hands on it and can help?
I am looking for something beyond these two references
Any experience accessing AWS Secret Manager from SAS Viya 4 on EKS? - SAS Support Communities and AWS Secrets Manager - API Reference

XavierBizoux — Thu, 27 Mar 2025 09:43:11 GMT

Hi,

I've seen your request. If you are using a SAS release where proc python is available, you can use it combined with the AWS SDK.

You can use the following article as reference to configure python on your Viya environment (if not yet done): Configuring SAS Viya for Python Integration

Please let me know if you need more information.

Regards,

Xavier

thesasuser — Thu, 27 Mar 2025 18:43:52 GMT

Thanks @XavierBizoux
I tried running the python code from the reference https://docs.aws.amazon.com/secretsmanager/latest/userguide/retrieving-secrets-python-sdk.html . I have installed boto3.
I am getting the following error

Any suggestions?

XavierBizoux — Fri, 28 Mar 2025 11:16:59 GMT

Hi,

I'm not an expert with AWS Python SDK.

The code for get_secret_value can be found here. You should most probably define the class in your code and then use that class.

Let me know if that helps. If not, you may ask for help on the AWS repository itself.

Regards,

Xavier