Quicksight - Visual Table with Image

Question & Answer
, , , , ,
1

Hello,

I am trying to add a table to the Analysis in Quicksight the table is reading from a dataset that contains images saved as BLOB file - and I am not able to find a way to do so. Below is what I have:

  • Dataset

    • car_details
    • Car Id - Number
    • Car Name - String
    • Car Pic - BLOB (Saved it as String Base64)

  • Adding Visual Table

    • What can be done to show the Car Name in column 1 and Car pic in column 2 ?

Regards,
Rami

2

Hi @rahmadieh and Welcome to the QuickSight community!
QuickSight is not directly compatible with BLOB files. You’ll have to upload the images to a public accessible location (like an S3 bucket). Then you can update your dataset with those image URL’s to work within QuickSight.

1 Like
3

Thank you Brett for your response two quick questions:
1- the urls can be added as String to the dataset and images will load accordingly or is there any management that should be done?
2- isnt there any other way than moving images to s3 since this will mean that we need to move all data in the table to an s3 location?

4

Hi @rahmadieh,

  1. Theoretically, there shouldn’t be a need for additional management.
  2. I believe S3 is the easiest route here and seems to work with the most success. You could try other publicly accessible image URL’s but may you may encounter errors.

Thank you!

1 Like
5

Hi @Brett ,

Thank you for your previous replies, I have been changing the structure to support the recommendation that you have provided however I am still stuck around this topic:

  • The Images are uploaded into the S3 bucket
  • I am able to access and see the image
  • I added into the Analysis a Table Visual
  • When loading the fields into the Table visual they are appearing as Text

What can be done to have the visual shows the values as images, I tried several formatting options but it seems there is no format of type image.

Regards,

6

Just to reference the question before I was able to handle this, it needs some practice on the analysis as a tool to get familiar with all options but to manage the above I was able to achieve this by using the following from the Properties

image

Thanks @Brett for you answers and help on this thread.

1 Like