1 Answer
- Newest
- Most votes
- Most comments
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.
Relevant content
- asked 2 years ago
- asked 3 months ago
- AWS OFFICIALUpdated a month ago
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 2 years ago
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/