Athena - query using join between data sources

Hi

• Is there a way in Athena to join queries from 2 different data sources AWSDataCatelog & a postgres connector?
• I am experiencing following error when during "select COUNT(*) from <table>" but "select * from <table>" works fine. This is from DBeaver connecting to the S3 buckets where athena query results are stored

SQL Error [100071] [HY000]: [Simba]AthenaJDBC An error has been thrown from the AWS Athena client. Access Denied (Service: Amazon S3; Status Code: 403;