How to change the column headers in quicksight programatically?

I have multiple reports to publish in quicksight. Each report is getting generated from a different dataset that i have added to the dashboard. In total there are 10 datasets so there are going to be 10 reports. Most of these reports have a lot of repeated column headers. Is there a way to change the name of the column headers programmatically so that I can copy it for all the other reports ?

Below is an example of the columns in the datasets. The real dataset is pretty heavy so cannot share here.

Dataset 1 - 
      user_id, user_name, user_country, user_city, number_of_jobs_finished

Dataset 2 - 
      user_id, user_name, user_country, user_city, number_of_interactions
Dataset 10 - 
      user_id, user_name, user_country, user_city, number_of_movies_watched


  • List item

Hi @vinitkumar321 I will contact you directly. We have a solution on the way :slight_smile:

Hi, @vinitkumar321. Did @Jesse’s solution work for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. If Jesse’s solution resolved your issue, please provide the solution in a post in this thread to help other Community members that may run into the same issue.

Thanks for posting your questions on the QuickSight Community Q&A Forum!