Can QuickSight parse and visualize nested JSON stored in a PostgreSQL column?

Q&A
, ,
1

Hi everyone,

I came across this AWS Prescriptive Guidance article that explains how to analyze and visualize nested JSON data using Amazon Athena and QuickSight. → Analyze and visualize nested JSON data with Amazon Athena and Amazon QuickSight - AWS Prescriptive Guidance

I’m wondering if a similar approach is possible when the JSON data is stored in a PostgreSQL database, specifically in a column of type json or jsonb. My goal is to connect QuickSight to the PostgreSQL source and be able to extract and visualize fields from the nested JSON structure directly.

Is there native support for parsing JSON fields from PostgreSQL in QuickSight?

Thanks in advance!

Teodora

2

Hi @Teodora,

Welcome to the Quick Suite Community! I’d definitely look into this article that goes over using Aurora PostgreSQL. Depending on what file type you use (JSON or JSONB), you might be able to achieve what you want with the nested JSON data. Let me know if this helps!

1 Like
3

Hi @Teodora

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

4

Thank you! I was looking for a more dynamic approach, but this one could work as well.