Programmatically create table visual from dataset and get embed dashboard url

[zhan2819]

Hi guys,
For our use case, we are ingesting datasets from s3. For every dataset created, we are wondering if there’s a way to programmatically create the paginated table dashboard and generate embedding link to use in our portal so that no manual intervention is required?

Thank you!

[duncan]

Hello @zhan2819 !

To do this effectively and automatically you will need to create permissions and most likely a lambda function but the general outline is that you will need to create a version of the analysis that you want to publish as your dashboard and use that as a template. From there you can use APIs to make updates. I would recommend checking out the following:

CreateDataSet - Amazon QuickSight
UpdateAnalysis - Amazon QuickSight
GetDashboardEmbedUrl - Amazon QuickSight

I would also check out this topic:

How to edit published dashboard created from a template and make change available with boto3?

You can save a new analysis from the dashboard, make changes to it and then publish a new dashboard. When you publish, you won’t see the option to replace the original. [image] If you really need to replace the original dashboard instead of creating a new one, I think there may be a way with the API but I haven’t tried it myself. After you save the new analysis from the original dashboard, use it to create a template by specifying it as the source analysis in the request body. [image] T…

[zhan2819]

Thanks @duncan ! From my understanding, we basically manually make one visual analysis for one dataset, then call APIs to recreate dashboard for all other datasets through the saved analysis template. is that correct?

[duncan]

Hey @zhan2819 !

Essentially yes, you will want to create the template and then be able to plug in the new datasets. That being said, the datasets will need to be consistent. At least from my experience, it is a lot easier when the datasets share the same fields.