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?
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.
Unable to refresh QuickSight Datasetasked 3 months ago
Can QuickSight connect to Azure SQL Database?EXPERTasked 5 months ago
Define AWS database to use in Custom SQL?asked 3 months ago
Glue Studio Designer: use pyspark functionsAccepted Answerasked 2 months ago
How do I define a SQLite expression in DynamoDB 'object-mapping' DMS migration task?asked 22 days ago
can NOT see Athena "data source connector" db in QuickSightasked 25 days ago
How to resolve the issues in viewing the dataset and creating the calculated fields when using edit dataset option in quicksight?asked 5 months ago
Can we add column to an existing table in AWS Athena using SQL query?Accepted Answerasked 3 years ago
Q Topics option not visible in the leftside embedSessionasked 3 months ago
Wordpress Multisite - ERROR: Cookies are blockedasked 2 years ago