Administration and Deployment

Installing and maintaining your SAS environment
BookmarkSubscribeRSS Feed
thesasuser
Lapis Lazuli | Level 10

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

3 REPLIES 3
XavierBizoux
SAS Super FREQ

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 would write your python code as in the example on Get a Secrets Manager secret value using the Python AWS SDK - AWS Secrets Manager.

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 

Xavier BIZOUX
Advisory Technical Architect ● Global Enablement and Learning
Technology Transfer and Governance, R&D
thesasuser
Lapis Lazuli | Level 10

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 

thesasuser_0-1743100942643.png

Any suggestions?

XavierBizoux
SAS Super FREQ

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

Xavier BIZOUX
Advisory Technical Architect ● Global Enablement and Learning
Technology Transfer and Governance, R&D

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 211 views
  • 1 like
  • 2 in conversation