API / Programmatic Creation of Sheets and visuals

[sourabh_joshi]

I have visual data available to bind in the sheet for example (positions and types of visuals and controls with source data) and I want to update the analysis with my updated sheets programmatically.
Here are a few things I’d like to accomplish by programmatically creating analyses:

• Eliminate Manual Work: Creating Quicksight reports involves a lot of repetitive click-and-drag work. It would be more efficient to replace this with code.
• Improve Re-usability: Re-using content in Quicksight is a very click intensive manual process. Code is easier to reuse for similar work.
• Improve Precision: Click-intensive manual processes are naturally error prone. Giving users the ability to script out analysis creation reduces the potential for error.

Thanks in advance!

[Max]

This is currently not supported because quicksight is based on the idea of templates.

Template - Amazon QuickSight

However, in the future this might be possible with the introduction of “Assets of Code”

API / Programmatic Creation of Analyses and Sheets

Looking to find a way to manage Quicksight Dashboards across accounts. As I understand it, Dashboards contain Analyses, and Analyses contain sheets. Jumping from CLI / API version 1->2, the ability to add Analyses was added to the API. However it appears there is no obvious way to create the component sheets via the API. Is there any way to manage these programmatically as JSON, or is it only possible via the Quicksight Console?

[sourabh_joshi]

@max, I did not find any demo features like “Assets of code”, could you please help me?

[Max]

It looks like that url is no longer available.

However, they are in the process of developing it and to my understanding allows you to use JSON objects to describe visuals / analysis so that you can use it programatically.

[sourabh_joshi]

Hi @Max, Thanks for the reply,

Could you provide a tentative date for this feature release?
OR
Where should I get this feature update? Is there any Uri/Path to follow?

[Max]

I can’t provide a date for when this feature release is going to happen. Although it is a highly requested feature and I know they are working on it.

Once the update is available I’m sure there will be a press release / documentation and it will be natively in the Application / APIs.

I would suggest reaching out to your AWS / QuickSight Account Manager for more information.

[John_Russell]

The QuickSight API was fairly recently updated to add functions for assets-as-code: describe-analysis-definition, create-analysis, and update-analysis. In concept you can get the definition of one analysis and create a copy or update it to add columns etc. I think there should be a connector here because the import and export json is different shape but I’m excited to try it out. See this blog for introduction.