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!
Hi Chiranjeevi_N, thanks a lot for taking time to respond; As I mentioned in my question I am able to run the query with the below way
select * from <database Name>.<table Name>
but only when i try to use it for cross data source querying(Federation) i am getting the error. when the connector reads the secret manager using Athena Data Source and Database name; why it fails to read secrets manager while doing cross source querying. you can refer the below article. https://aws.amazon.com/blogs/big-data/query-snowflake-using-athena-federated-query-and-join-with-data-in-your-amazon-s3-data-lake/