Want to create a quicksight dashboard which will allow user to upload a simple csv file to an existing dataset

Yes, it is possible to allow users to upload a CSV file and append it to an existing dataset in Amazon QuickSight. Here are the general steps to achieve this:

Create a new dataset in QuickSight by connecting to the data source where you want to store the uploaded CSV file.

Next, create a new data source that allows file uploads. Amazon S3 is a popular option for this, as it can be easily configured to allow file uploads.

Create an Amazon Lambda function that will be triggered when a file is uploaded to the S3 bucket. This function should be able to process the CSV file and append the data to the existing dataset in QuickSight.

Create an Amazon API Gateway to expose the Lambda function as an API endpoint. This will allow users to call the API and upload the CSV file to the S3 bucket.

Finally, in QuickSight, create a new dashboard and add the dataset to it. Create a new data set with the same name as the existing data set and map the columns of the uploaded CSV file to the existing dataset columns.

Create a button on the dashboard that allows users to upload a CSV file and call the API Gateway endpoint to trigger the Lambda function.

This process is a high-level overview and you would need to do more research on how to set up and configure each of these services. But this should give you a good starting point.

Also, "Create a button on the dashboard that allows users to upload a CSV file and call the API Gateway endpoint to trigger the Lambda function." for this step, how to create the button in dashboard ?

Hi, @Ani.

You can embed external web pages into your dashboards and analyses, using custom visual content.

https://docs.aws.amazon.com/quicksight/latest/user/custom-visual-content.html

You can use this to display a user interface for uploading.