By using AWS re:Post, you agree to the Terms of Use
/Define AWS database to use in Custom SQL?/

Define AWS database to use in Custom SQL?


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"
1 Answers

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 and Blog pages for any new feature announcements.

answered 3 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions