I just need to edit few of the datasets which does not use custom sql and instead do table loading.
I want to convert them into custom sql and second usecase is convert from rds to athena using QuickSight API.
Hi @mufidepalaoglu I’m marking Naveed’s answer as solution. QuickSight API is not the right tool for manipulating datasets. For that, as Naveed said, you can use AWS Glue ETL or AWS Glue DataBrew to output your data to S3 and consume from there. You can also use Amazon Athena to connect to your S3 bucket, or to RDS directly using Athena Federated Query. You might find this blog helpful as an example.