How do I read a yxdb from Google Drive

[davecodling]

Hi,  I know that Alteryx Designer can read many different data types from many sources.

So how do read from or write to a yxdb file on Google Drive?  This is the data infrastructure my organisation uses.

[JagdeeshN]

@davecodling 

Do you currently use Google Drive Sync?

With that you will see your files in a standard File Explorer box. You can then access the files from alteryx through a normal input tool.

[davecodling]

Hi, this is not used nor accessible in my organisation - but I will investigate it.

Why is there no Google Drive equivalent of the Amazon S3 tools?

[echuong1]

You can also use Drive File Stream to connect to your files just as you would from a network folder:

https://support.google.com/drive/answer/7329379?hl=en 

The most common data sources have connectors already built out by Alteryx (S3, Google Sheets, OneDrive, and Tableau to name a few). A majority of them are using APIs to pull/push the data from Designer. That being said, just because Alteryx has not released a connector doesn't mean a connector cannot be built. You're certainly able to leverage the Google Drive API and the Download tool to create a connector. Looking on the Gallery, it looks like someone has already created one!

https://gallery.alteryx.com/#!app/Google-Drive-Tools/5c65d93c0462d711bceaa0a5 

https://developers.google.com/drive