Hi , Im trying to create a dataset with Athena …since AwsDataCatalog has a lot of DB’s it times out
So im trying to use custom sql
It gives me the intended results , But i want to pass the DB name dynamically because we have >30 db’s and each time i want to pass the DB name as parameter and the dashboard get populated with that DB data .
To do that i created DB name as a parameter in Dataset but it is giving me SQL error .
Select * from <<$DatabaseName>>.<<$TableName>>
Our Architecture in brief is something like this … we have multiple solutions and in S3 we store the parquet files of each solution in a different folder and use athena to query the same . example this is a pflzvc9xm8 solution /folder in which my parquet files reside is specific to one particular customer .
I don’t think it is possible to change the database name and table name dynamically from QuickSight.
Based on your description if you could get data from the multiple DBs into a common table outside of QuickSight but as you merge the datasets include an additional column for the client then you can use that client column to filter dynamically using a parameter.
Hi @Abhishek_B_A,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
