I have 100 tables in my redshift. i have created 100 datasets for them. Now i want to link one topic to all these datasets. After adding 20 datasets in the topic. i get the error Something went wrong. What can be the issue ? Is there a limit to how many datasets i can add in a single topic, and do i have to create mulitple topics for all these datasets ?
Thankyou but No, Nothing in this article is related to number of datasets in a topic or any kind of restrction for topics
Hello Abd,
I do not know the limitation about the the number of data set to be added in single topic. I feel your approach may not be appropriate and scalable. Instead of joining all those data set in topics i would rather join and create a table in the backend and finally create a topic on final data set.
else you may ended up Q not generating the expected answers as there many be lot of fields etc and the joining situations. Its my personal opinion 
Hope this gives some directions.
Cheers,
Deep
1 Like
@Deep … Hi, Thankyou for the suggestion. I actually have around 100+ tables. connected with each other. I want to connect my database with quicksight so it can read each table and answer appropriately. Just to give you an idea. Lets say i have a table for Sales . it will have foreign keys like customer, country, currency, Sector, etc … which are linked to their own tables.
Like this sales table i have around 20 tables that contain data linked with the remaining tables in my database.
What kind of approach would you advise here. Because im fairly new on quicksight and i thought. Each table will be a dataset . And i will connect all datasets to one topic .
But im facing the 20 limit issue now.
I do not want to merge or join tables to form a single table because that would require kind of merging all tables into one which i dont think is the right approach. So what do you suggest in this scenario ?
Hello Abd,
I am afraid to say that creating 100 data set from 100 tables from the same database may not be appropriate or sustainable. Even if you dislike it you may need to join the tables to get a data set where you could create topic for Q&A.
Some reference link -Joining data - Amazon QuickSight
Modeling - Two fact tables and different level
https://aws.amazon.com/blogs/big-data/dimensional-modeling-in-amazon-redshift/https://community.amazonquicksight.com/t/2-fact-tables-in-one-dataset/17545
Hope this helps.
Cheers,
Deep
1 Like