- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
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 ;)
Contenuto pertinente
- AWS UFFICIALEAggiornata 10 mesi fa
- AWS UFFICIALEAggiornata un anno fa
- AWS UFFICIALEAggiornata 2 anni fa
- AWS UFFICIALEAggiornata un anno fa