Generic user error when running athena queries

Question

Hi, when running a query with Athena I'm getting this error. I'm thinking it might be the DefaultConnectionString, any advice will help.

DefaultConnectionString:
postgres://jdbc:postgresql://xxxxx-dbstack-xxxxxx-mydb-xxxxxxxx.xxxxxxxx.us-west-2.rds.amazonaws.com:5432/salesdb?user=xxxxxx&password=xxxxxxxxx

GENERIC_USER_ERROR: Encountered an exception[java.lang.RuntimeException] from your LambdaFunction[arn:aws:lambda:us-west-2:xxxxxxxxxxx:function:postgresqlconnector] executed in context[retrieving meta-data] with message[Could not find table in dms_sample]
This query ran against the "pg_catalog" database, unless qualified by the query. Please post the error message on our forum

Answer

Hi, 
Not sure if this is the correct answer to your error. Can you check the cloudwatch logs for the Lambda function, it should have a more detailed error with stack trace. I suspect that your Lambda is unable to connect. Later we can dig deeper and try to resolve this.

Thanks

Generic user error when running athena queries

Relevanter Inhalt