Athena Snowflake Federated Query Fails

0

Setup a serverlessrepo-AthenaSnowflakeConnector to enable query Federation; after the connector setup i am able to query the tables using data source name and table name but when i tried to use with "lambda:MyLambdaFunctionName" in my select statement got into the below error.

GENERIC_USER_ERROR: Encountered an exception[com.amazonaws.services.secretsmanager.model.ResourceNotFoundException] from your LambdaFunction[xxxlambdfnxxxx] executed in context[retrieving meta-data] with message[Secrets Manager can't find the specified secret. (Service: AWSSecretsManager; Status Code: 400; Error Code: ResourceNotFoundException; Request ID: ABCD8e00-9999-XXXX-863Y-XX36Y588XNNN; Proxy: null)]
This query ran against the "POCDB" database, unless qualified by the query. Please post the error message on our forum
or contact customer support
with Query Id:XXX7020Y-4Y41-4917-9520-NNN741X0NaNN

Altered the IAM inline policy to provide access to all secrets as well

{
            "Effect": "Allow",
            "Action": "secretsmanager:GetSecretValue",
            "Resource": "*"
        }

what is causing the issue any guidance will be greatly appreciated.

Thanks in Adavnce!

YogaK
asked 2 years ago387 views
1 Answer
0

Hello,

Looking at your error message Secrets Manager can't find the specified secret , it appears that the secret specified while creating your connector is either invalid or unavailable in your account.

Please ensure that you are providing a valid secret name which is present in the account where you are creating the connector. The connector retrieves the username and password from the specified secret.

You can find an example article here and here

AWS
SUPPORT ENGINEER
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions