Setting up an RDS data source

Question & Answer
, ,
1

I am trying to set up a connection to an RDS Postgres DB that is in a VPC. I believe I have set everything up that I need. I am able to select the instance ID of the relevant DB from the select list. But when I try and select a connection type it says “chose a VPC connection” but I don’t get any options.

What have I done wrong?

2

Hello @gaynorg,

Welcome to QuickSight Community, it is great having you here.

To be able to connect to an RDS database via VPC you need to have QuickSight Enterprise Edition, if this is the case, then you might be missing the VPC connection from QuickSight.

Here is a post with a complete guide on how to setup an RDS to QuickSight using VPCs that might help.

Hope this helps!

Kind regards,
Andres.

1 Like
3

So I only have the standard edition does this mean I can’t access a DB in a VPC?

How am I supposed to access a DB then?

4

With standard edition you can only access to the DBs from the public network.

Other options could be to offload the data from your DB to an S3 bucket and access it using Athena o S3.

But if you need direct query or a simplified way of accessing the database on private networks you will have to upgrade to Enterprise Edition.

5

So I have created a Python script that writes the data to a local DB. My original idea was to port all of this to AWS and do the reports in Quicksite. I think it might make sense to put my data elsewhere. Is there a particular technology that you would recommend for that? Something that would be secure and scalable. Right now there isn’t that much data, maybe 10-20k rows and another table with maybe 1-200k rows.

6

Sorry I wasn’t fully clear. I was thinking I should stop writing to the Postgress DB and write to something else directly. Any recommendations for what I should use?

7

Hi,

Yes Indeed, I will recommend to write the data to an S3 bucket, and access it using Athena from QuickSight.

1 Like
8

@andres007 So what form in the bucket? S3 is just a filestore isn’t it ?

9

Yes, S3 is a file store, you can use Athena to query them. You can find more information in the documentation below.