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

0

Want to create a quicksight dashboard which will allow user to upload a simple csv file to an existing dataset. Suppose, one dataset has one column customer_id. This has 10 entries. I want to enable users to upload a new csv file having new set of 50 customer_ids and append in that existing dataset. Could you please help/suggest how to achive that in quicksight.Thanks.

profile picture
Ani
asked a year ago1144 views
3 Answers
0

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.

profile picture
answered a year ago
  • Thank you @jayamaheizenberg for your response. But I am looking for this user upload option in quick sight itself so that user can get some nice interface to upload the file not aws s3 console by going to the bucket/folder and uploading the file there. Any suggestion on that please? Thanks again.

0

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 ?

profile picture
Ani
answered a year ago
0

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.

profile picture
EXPERT
iwasa
answered a year 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