- Newest
- Most votes
- Most comments
You can use Lambda UDFs to retrieve AWS Secret Manager secret's information using SQL statements in Redshift.
- Create a lambda function that takes secret ARN as input and returns the required information from secret as output
- Create a Lambda UDF in Redshift to invoke the lambda function using SQL statements
Example provided in this blog shows how to access Amazon DynamoDB using Lambda UDFs. You can access AWS Secret Manager in a similar way. You can follow this blog to understand how to retrieve secret information securely using AWS Lambda
Also, that there are many other alternative ways to retrieve secrets. You can retrieve from AWS console, the AWS CLI (get-secret-value) or using the GetSecretValue API .Please refer to retrieve secrets documentation to know more about these alternatives.
Hi,
One option is to use redshift data api (https://docs.aws.amazon.com/redshift/latest/mgmt/data-api.html), in combination with sdk libraries (https://docs.aws.amazon.com/AWSJavaScriptSDK/latest/AWS/SecretsManager.html) and combine/filter the results.
Hope it helps ;)
Relevant content
- asked 2 years ago
- asked 2 years ago
- Accepted Answerasked 10 months ago
- asked 8 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 4 months ago
- AWS OFFICIALUpdated 2 years ago