Hello @achourey,
as of my knowledge there is currently no other way to include all fact and dimension tables into one source without creating a big table as QS does not provide anything else than Joins. However I found some interesting discussions and articles that could interest you depending on your specific analysis use cases and flexibility.
The first one is another Community entry on how to use a big table with two fact tables: 2 Fact tables in one dataset
The second one is a different reporting approach when using dimensional models:
Dimensional modeling in Amazon Redshift | AWS Big Data Blog
The idea here is that you can build you respective analyses using a fact table and only join the required dimension table. Maybe you can create multiple Datasets where your fact table is only joined to one dim table (which would be six in you case) and add them to your Analysis.
Maybe some of this can help you. I am curious to know!
Best
Nicolas