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