Define AWS database to use in Custom SQL?

Question

I am creating a dataset in AWS Quicksight using custom SQL which I prepare/test in Athena. However, unless I define each join/table "databasename".table, the QS custom SQL fails. I have tried the below but it has failed. Is it possible to instruct the query to fun against a specific DB at the beginning of the query?

```
USING AwsDataCatalog."databasename"
```

Answer

Thank you for posting the question and the detailed explanation on what you are expecting. 
At present, it is not possible to instruct a query to run against a specific database at the beginning of the query. I have raised a feature request with the service team on your behalf. While I am unable to comment on if/when this feature may get released, I request you to keep an eye on our [What's New](https://aws.amazon.com/new/?whats-new-content-all.sort-by=item.additionalFields.postDateTime&whats-new-content-all.sort-order=desc&awsf.whats-new-analytics=*all&awsf.whats-new-app-integration=*all&awsf.whats-new-arvr=*all&awsf.whats-new-blockchain=*all&awsf.whats-new-business-applications=*all&awsf.whats-new-cloud-financial-management=*all&awsf.whats-new-compute=*all&awsf.whats-new-containers=*all&awsf.whats-new-customer-enablement=*all&awsf.whats-new-customer%20engagement=*all&awsf.whats-new-database=*all&awsf.whats-new-developer-tools=*all&awsf.whats-new-end-user-computing=*all&awsf.whats-new-mobile=*all&awsf.whats-new-gametech=*all&awsf.whats-new-iot=*all&awsf.whats-new-machine-learning=*all&awsf.whats-new-management-governance=*all&awsf.whats-new-media-services=*all&awsf.whats-new-migration-transfer=*all&awsf.whats-new-networking-content-delivery=*all&awsf.whats-new-quantum-tech=*all&awsf.whats-new-robotics=*all&awsf.whats-new-satellite=*all&awsf.whats-new-security-id-compliance=*all&awsf.whats-new-serverless=*all&awsf.whats-new-storage=*all) and [Blog](https://aws.amazon.com/blogs/aws/) pages for any new feature announcements.

Define AWS database to use in Custom SQL?

Relevant questions

Unable to refresh QuickSight Dataset

Can QuickSight connect to Azure SQL Database?

Define AWS database to use in Custom SQL?

Glue Studio Designer: use pyspark functions

How do I define a SQLite expression in DynamoDB 'object-mapping' DMS migration task?

can NOT see Athena "data source connector" db in QuickSight

How to resolve the issues in viewing the dataset and creating the calculated fields when using edit dataset option in quicksight?

Can we add column to an existing table in AWS Athena using SQL query?

Q Topics option not visible in the leftside embedSession

Wordpress Multisite - ERROR: Cookies are blocked