Need help accessing multiple CSV

Question & Answer
, ,
1

Hello, I am a newbie to AWS Q and Quicksight. I wanted to create a dataset that pulls from four CSV files - customerdata, contactcenter, socialmedia and purchases. the four CSV files are tied by CustomerID. so i created an S3 bucket, created a JSON file with all four CSV files, and then successfully connected to it from Quicksight. However this is where I get stuck - it is not showing fields from all four CSV files. Do I need to create four datasets, one for each, and then join them from Quicksight. Any help would be great and I prefer to work with CSV file. Btw, the CSV are very small and this is more of a proof of concept to management. Would rather not deal with Athena or other db. Thanks.

2

Hello Vim,

Please refer - Joining across data sources on Amazon QuickSight | AWS Big Data Blog

Hope this helps.

Cheers,
Deep

3

Hi Deep, thanks for the note. However it doesn’t help me because the steps noted are different today than when this document was written in 2019. At least I was unable to follow step by step. It needs to be updated.

4

Hello Vim,

Could you share with possible screenshot what exactly you are doing ?
could you download the CSV locally and upload to Quicksight ?

Thanks for letting us know.

Cheers,
Deep

5

Hi Deep at this time, I think I am just going to push forward and go with a Glue/Athena solution to see how that works. I was under the mistaken assumption that QuickSight/SPICE had some Glue-functionality as far as understanding relationships, etc.

6

Hi @Vim - Since all the 4 files layout are different, better to create 4 data sets using S3 and import to QuickSight and then you can do the join as per the suggestion @Deep .

Loading the data in athena is another solution as well, however you need additional process to load the data from S3 to athena and that you have to manage out of QuickSight. I will suggest try to option -1 if it is solving your requirement.

Regards - Sanjeeb

7

thank you, that worked.