Can we create custom data set using quicksight API?

Question & Answer
, ,
1

Hey Community,

I want to create a custom dataset in quicksight using the data that is returning from connect queue and other connect APIs. Can we create dataset using some custom data?
I just want to know if there is a way to create that dataset using quicksight createdataset api or any other way?

Kind regards

2

Hi @musama,

Thanks for posting your question, when you refer to “connect” are you referring to Amazon Connect?
If so, one option is to query data from Amazon Connect by landing the data in S3 and then querying the files using an Athena datasource connection. One such blog where this is discussed can be found here.

There is also this AWS Workshop “Visualize Amazon Connect Contact Trace Records Using Amazon QuickSight” that may be helpful.

Many Thanks,
Andrew

1 Like
3

Hey @abacon

Thanks for the reply and I understand this solution. I think I just wanted to add queues names by using amazon connect api using lambda. I don’t wanna store it in some storage. Is there a way to do that ?

Regards

1 Like
4

Hello @musama, from my understanding of QuickSight datasets, I don’t believe there is a way to accomplish that task without utilizing S3 and Athena. There isn’t a way currently to use an API call to populate data directly into a dataset like you are wanting. The route suggested by @abacon will be your best course of action to accomplish this task.

Since this feature is currently not available though, I will go ahead and tag it as a feature request. Your feedback helps us build a better service. Let me know if you have any further questions on this, otherwise I will archive the question for our support team. Thank you!

1 Like
5

Hey @DylanM Thanks for responding.

1 Like