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

4

Hi @MamunHossain,
I believe what Ramon was suggesting was to move the file to S3 and manage from there directly as opposed to trying to sync up to your Google Drive as that is not currently supported through QuickSight.

Let us know if you have any additional questions, if we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

5

Hi @MamunHossain,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!