Cardinality In Quicksight dataset

Question & Answer
1

Hi Team,

How can we create cardinality in QuickSIght Dataset.

If it is not there by when it will coming as part of QuickSIght.
What is the alternate you propose?

Thanks & Regards
Shiv

2

Hi @vshivku1 - Welcome to AWS QuickSight community and thanks for posting the question. Can you please more details on the cardinality requirements. What exactly you are looking from QuickSight, if you can give some examples, that will be great as well.

Regards - Sanjeeb

3

Hi Sanjeeb,
I am working on a migration project where in source we have cardinality defined between tables as in : 1:1 , 1: n , n:1 like this , apart from joins . Can you please tell me how we can define the same in QuickSight.
If it is not there by when it will coming as part of QuickSIght.
What is the alternate you propose?
Thanks & Regards
Shiv

4

Hi @vshivku1 - The cardinality should be maintained at database level and model the data. In QuickSight you can bring the data sets and perform the joins ( inner, left, outer, full) and depending upon the cardinality and join, it will give you the desired result. You can do some POC on the data sets and joins in QuickSight. If you have some specific scenario and wants to replicate in QuickSight from BI prospective, please give details and we can see how you can achieve it from QS.

Tagging @Karthik_Tharmarajan @eperts @Naveed for their advise as well.

Regards - Sanjeeb

1 Like
5

Hi Sanjeeb,
Thanks for your reply!!
Is it possible to have 30 mins call show that I can show you the problem i am facing . If a cardinality is defined in my source BI i have to create the same in QuickSight . I have to modify the entire Database architecture for that for which my database team will not agree for it.
Thanks & Regards
Shiv

6

Hi @vshivku1 - I will message you offline to discuss on this.

Regards - Sanjeeb

7

Hi @vshivku1 - BI tools, at least the ones I’ve used so far (QuickSight,Qlik, Tableau, Looker) don’t care about cardinality so am not sure what you’re trying to achieve. All you have to do is set the joins in the data set and you are good to go.

2 Likes
8

Hi , Thank you for your response.

I can create a share a sample twbx file with data and also can share the data separately , the numbers are not matching due the cardinality .
Or If required I can we can have a call and showcase what i am trying to say.
Thanks & Regards
Shiv

9

Unless the data is anonymized I wouldn’t recommend sharing it. What you can do is share a csv representation of the tables with anonymized information. Then include a screenshot of the schema and settings in Tableau and one you currently use in QuickSight. That would allow us to better assist you.

10