Q&A from the Live session | Continuous Integration and Deployment in QuickSight

Answers generated from Webex transcript and chat interactions

Q: If I export a bundle (dashboard, analysis, datasets, and data sources) and import to my new account in multi-account. How do my data sources get created if I have a different Redshift instance in my other account? Won’t the data sources fail to create as it won’t find my original Redshift source? i have 2 quicksight subscription in 2 different accounts. I’m moving all my analyses and dashboards from the first account to the second one, because the first account was collecting data from legacy cur from other org accounts, while the second one was configured to collect cur 2.0 data. so, importing dashbords from the old account to the new one, does affect in any way datasets? for example, since account one uses legacy cur derived data, and new one cur 2.0 instead, importing an analyses or dashboard might change in some way my new account datasets?
A: If the target account has database instance of similar type, it tries to use same and establish connection. If not available, they can define the override parameters as part of import job. either to create new data source or use something with specific credential

Q: I would like to know how to combine two datasets for one dashboard as out put.
A: So the combining of data sets is not available, so the only option is you can use a programmatic approach to combine the data set like in the asset bundle export, the topic that we discussed today, it basically going to take a copy of whatever the setup you have here and you can export. Cal, when you say combining the asset, I assume two data set you want to make two into both or perform the join operation. So the join you can use a UI to perform that join or even in case of programmatic development if you’re familiar with that like there is a documentation available, you can also construct those join field and make it a one single data set and then use it as a source. So that should work.

Q: Is the Lambda code example used in the demo available for download?
A: Under the Amazon QuickSight user guide, you have a complete documentation about the dashboard, all the assets or the event patterns with the examples as well. And, our service team and one of our essays has published this blog to automate your Amazon Quickset asset deployment using Amazon event bridge integration. This is a step by step process. This is one of the early versions of the blogs which are the example available for dashboard. Amazon QuickSight events integration - Amazon QuickSight

Q: Are there are any similar reference implementations/artifacts with CodePipeline/CodeBuild instead of Lambda. Background: Few customers may prefer to deploy from a DevOps account and use standardized approach for other AWS Service component deployments.
A: we are working on some more examples for variety of assets with the cloud formation as a template and and even more examples with the quick Json as a template with a reusable workflows that is something work in progress. We don’t have the exact timeline, but we are working on and even there is a public workshop where you can see all from very basic to advanced topics. So we are planning to have that workshop added as one of the modules. So you can reference that, you can take the code and retry them for most of the assets we have that is supported for the eventbridge integration. Automate your Amazon QuickSight assets deployment using the new Amazon EventBridge integration | AWS Business Intelligence Blog

Q: Side question : are there any good blogs or docs talking about using Terraform to deploy QS and assets?
A: Nothing that I’m aware of. There is a basic documentation on terraform, but I don’t think we have a blog on it.

Q: How can a user have Multi-accounts on QuickSight?
A: Guidance for Multi-Account Environments on Amazon QuickSight

1 Like

Thank you for sharing the Q&A @madihs! I will archive this topic since we have not received any follow-up questions. Feel free to create a new topic in the community if you have further questions on the information covered during the live session.