Trying to connect QuickSight to Google Drive and have it automate

Question & Answer
, , , , ,
1

I’m trying to connect to a Google Drive link that I dump CSVs in to display on my dashboard. Right now I have a very manual process but I was wondering if this is possible to automate?

2

Hi @MamunHossain

QuickSight currently is not able to natively connect to files sitting in google drive. In order to automate i recommend you leverage S3. Move the csvs to s3 and connect directly from quicksight.

Regards
Ramon

3

Hi @Ramon_Lopez

So just to clarify, would it be best to leverage S3 and also have a GCP account connect with OAuth, and have a script to take from this? Or am I overthinking this.

Regards,

Mamun